TABLE  target

This list was formed by merging all the survey input tables/catalogues. TARGET is the hub of the database. The record with targetid=0 and targetname='blank____record' is there for objects that appear in other tables that for some reason are no longer in the master TARGET configuration file. eg there are some 70 objects in SPECTRA that are not in TARGET, they have been assigned a targetid=0 in the SPECTRA table. Required constraints: Primary key is (targetid)

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
TARGETID	bigint	8		unique ID no., used to link tables
TARGETNAME	varchar	15		name in config file, used to name FITS file and generate thumbnail images
HTMID	bigint	8		Hierarchical Triangular Mesh (20-deep) number, mainly useful internally for indexing on position
RA	float	8	degrees	master RA J2000 (decimal degrees)
DEC	float	8	degrees	master Dec J2000 (decimal degrees)
CX	float	8		Cartesian x of unit (ra,dec) vector on celestial sphere
CY	float	8		Cartesian y of unit (ra,dec) vector on celestial sphere
CZ	float	8		Cartesian z of unit (ra,dec) vector on celestial sphere
GL	float	8	degrees	galactic longitude
GB	float	8	degrees	galactic latitude
A_V	real	4		Schlegel V extinction
PROGID	smallint	2		highest priority programme ID
BMAG	real	4	mag	Bj galaxy magnitude from recalibrated SuperCOSMOS data (0.00 is null)
RMAG	real	4	mag	Rf galaxy magnitude from recalibrated SuperCOSMOS data (0.00 is null)
SG	smallint	2		SSS star/galaxy flag 1=galaxy 2=star 3=unclass 4=noise
ZCATVEL	int	4	km/s	velocity in ZCAT
ZCATERR	int	4	km/s	error on velocity in ZCAT
ZCATREF	smallint	2		ZCAT reference
BMAGSEL	real	4	mag	Bj magnitude from online SuperCOSMOS Sky Surveys (99.99 and 23.0 are nulls), appeared as BMAG in the EDR and DR1
RMAGSEL	real	4	mag	Rf magnitude from online SuperCOSMOS Sky Surveys (99.99 and 22.0 are nulls), appeared as BMAG in the EDR and DR1
Total length		121