TABLE TiledTargetAll

Keep track of why a Target was assigned to a Tile

This table is designed to be searched both ways - one can find the Targets assigned to a Tile or one can find all the Tiles a Target has been assigned to (objects can be assigned to more than one tile if they are QA objects). Information comes from plPlugMapP files, but only OBJECT hole info is stored. HoleObj can be used to find other holetypes that made it to a Plate.

name type length unit ucd description

tile smallint 2 ID_PLATE tile number

targetID bigint 8 ID_CATALOG ID of Target

ra float 8 deg POS_EQ_RA right ascension

dec float 8 deg POS_EQ_DEC declination

htmID bigint 8 CODE_HTM htm tree info

cx float 8 POS_EQ_CART_X x projection of vector on unit sphere

cy float 8 POS_EQ_CART_Y y projection of vector on unit sphere

cz float 8 POS_EQ_CART_Z z projection of vector on unit sphere

objType int 4 CLASS_OBJECT plPlugMap style objType (only OBJECT holes)

duplicate tinyint 1 CODE_MISC duplicate spectrum by mistake

untiled tinyint 1 CODE_MISC 1: this tile later untiled, 0: otherwise

loadVersion int 4 ID_VERSION Load Version

name	type	length	unit	ucd	description
tile	smallint	2		ID_PLATE	tile number
targetID	bigint	8		ID_CATALOG	ID of Target
ra	float	8	deg	POS_EQ_RA	right ascension
dec	float	8	deg	POS_EQ_DEC	declination
htmID	bigint	8		CODE_HTM	htm tree info
cx	float	8		POS_EQ_CART_X	x projection of vector on unit sphere
cy	float	8		POS_EQ_CART_Y	y projection of vector on unit sphere
cz	float	8		POS_EQ_CART_Z	z projection of vector on unit sphere
objType	int	4		CLASS_OBJECT	plPlugMap style objType (only OBJECT holes)
duplicate	tinyint	1		CODE_MISC	duplicate spectrum by mistake
untiled	tinyint	1		CODE_MISC	1: this tile later untiled, 0: otherwise
loadVersion	int	4		ID_VERSION	Load Version