TABLE QsoSpec

Contains a record describing the attributes of each QSO Spec object and also Spectroscopic Surrogates to fill in the QsoConcordanceAll view.

This table is copied from the 'base' Best..SpecObj Table. It has a row for each spectroscopic QSO candidate and if no candidate exists nearby a Target or Best candidate then a 'surrogate' Spectroscopic object is added the closest specobj within 1.5 arcseconds of the QsoBunch head. If no such surrogate Spec object can be found, we use the ZERO surrogate (literally, all fields are zero). The test for a Spec object being a QSO candidate is: primary target flags set to one of TARGET_QSO_HIZ |TARGET_QSO_CAP | TARGET_QSO_SKIRT |TARGET_QSO_FIRST_CAP | TARGET_QSO_FIRST_SKIRT The table also includes the id and summary statistics for matching FIRST and ROSAT objects if they exist, and zero otherwise Also includes absolute magnitude estimated using Pei(1999) if a reliable reshift is available from a corresponding bunch specobj

name type length unit ucd description

SpecObjID bigint 8 Unique ID of the Spectro obs

HeadObjID bigint 8 ID_CATALOG Unique ID of Qso Bunch Head

SpecRa float 8 deg POS_EQ_RA_MAIN ra in J2000

SpecDec float 8 deg POS_EQ_DEC_MAIN dec in J2000

SpecCx float 8 POS_EQ_CART_X unit vector for ra+dec

SpecCy float 8 POS_EQ_CART_Y unit vector for ra+dec

SpecCz float 8 POS_EQ_CART_Z unit vector for ra+dec

SpecZ float 8 REDSHIFT Final Redshift

SpecZerr real 4 REDSHIFT ERROR Redshift error

SpecZConf real 4 REDSHIFT STAT_PROBABILITY Redshift confidence

SpecZStatus smallint 2 CODE_QUALITY Redshift status

SpecZWarning int 4 Spectral Classification

SpecClass smallint 2 Spectral Classification

SpecPlate smallint 2 ID_PLATE Plate ID

SpecFiberID smallint 2 ID_FIBER Fiber ID

SpecMjd int 4 MJD TIME_DATE MJD of observation

SpecSciencePrimary smallint 2 CODE_MISC Deemed to be science-worthy (defines default view SpecObj)

SpecPrimTarget int 4 Bit mask of target categories

SpecLineID bigint 8 Unique identifier of the line

SpecMaxVelocity real 4 MAX_VELOCITY Velocity estimate based on FWHM velocity of broadest good line -- /U km/s

SpecQsoConfirmed tinyint 1 CODE_MISC 1: was confirmed QSO

SpecBestObjID bigint 8 Unique ID of the Best observation

SpecTargetObjID bigint 8 Unique ID of the Target observation

SpecTargetID bigint 8 object ID in target table

SpecPlateSn1_i float 8 PLATE Spectogram 1(S/N)^2 i band

SpecPlateSn2_i float 8 PLATE Spectogram 2 (S/N)^2 i band

name	type	length	unit	ucd	description
SpecObjID	bigint	8			Unique ID of the Spectro obs
HeadObjID	bigint	8		ID_CATALOG	Unique ID of Qso Bunch Head
SpecRa	float	8	deg	POS_EQ_RA_MAIN	ra in J2000
SpecDec	float	8	deg	POS_EQ_DEC_MAIN	dec in J2000
SpecCx	float	8		POS_EQ_CART_X	unit vector for ra+dec
SpecCy	float	8		POS_EQ_CART_Y	unit vector for ra+dec
SpecCz	float	8		POS_EQ_CART_Z	unit vector for ra+dec
SpecZ	float	8		REDSHIFT	Final Redshift
SpecZerr	real	4		REDSHIFT ERROR	Redshift error
SpecZConf	real	4		REDSHIFT STAT_PROBABILITY	Redshift confidence
SpecZStatus	smallint	2		CODE_QUALITY	Redshift status
SpecZWarning	int	4			Spectral Classification
SpecClass	smallint	2			Spectral Classification
SpecPlate	smallint	2		ID_PLATE	Plate ID
SpecFiberID	smallint	2		ID_FIBER	Fiber ID
SpecMjd	int	4	MJD	TIME_DATE	MJD of observation
SpecSciencePrimary	smallint	2		CODE_MISC	Deemed to be science-worthy (defines default view SpecObj)
SpecPrimTarget	int	4			Bit mask of target categories
SpecLineID	bigint	8			Unique identifier of the line
SpecMaxVelocity	real	4		MAX_VELOCITY	Velocity estimate based on FWHM velocity of broadest good line -- /U km/s
SpecQsoConfirmed	tinyint	1		CODE_MISC	1: was confirmed QSO
SpecBestObjID	bigint	8			Unique ID of the Best observation
SpecTargetObjID	bigint	8			Unique ID of the Target observation
SpecTargetID	bigint	8			object ID in target table
SpecPlateSn1_i	float	8			PLATE Spectogram 1(S/N)^2 i band
SpecPlateSn2_i	float	8			PLATE Spectogram 2 (S/N)^2 i band