TABLE QsoConcordanceAll

A concordance of all the objects from Spectro, Best, or Target that 'smell' like a QSO

QsoConcordanceAll is built from QSOCatalogAll. For each entry in QSOCatalogAll, QsoConcordance collects popular fields from the three different databases involved (Spectro, Best, Target). Its fields are itemized and documented below. See also the QsoCatalogAll table description.

name type length unit ucd description

HeadObjID bigint 8 ID of first object in bunch (points to QsoBunch)

tripleID int 4 Unique ID of this triple in the bunch

QsoPrimary bit 1 1; this is best triple of bunch

TargetObjID bigint 8 target QSO or surrogate target object or zero

SpecObjID bigint 8 spec QSO or surrogate specobj or 0

BestObjID bigint 8 best QSO or surrogate best or

TargetQsoTargeted bit 1 1: Target was flagged QSO

SpecQsoConfirmed bit 1 1; Spec was confirmed QSO

SpecQsoUnknown bit 1 1; Spec was class unkonwn

SpecQsoLargeZ bit 1 1; SpecObj has Z > 0.6

SpecQsoTargeted bit 1 1; Spec was targeted as QSO

BestQsoTargeted bit 1 1: Best was flagged QSO

dist_Target_Best float 8 arcmins POS_ANG_DIST_GENERAL distance arcMin between Target and Best

dist_Target_Spec float 8 arcmins POS_ANG_DIST_GENERAL distance arcMin betweenTarget and Spec

dist_Best_Spec float 8 arcmins POS_ANG_DIST_GENERAL distance arcMin between Best and Spec

psfmag_i_diff float 8 mag PHOT_COLOR -- (target.psfmag_i - best.psfmag_i)

psfmag_g_i_diff float 8 mag PHOT_COLOR (target.psfmag_g-target.psfmag_i) - (best.psfmag_g-best.psfmag_i)

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

SpecTargetID bigint 8 object ID in target table

SpecTargetObjID bigint 8 Unique ID of the Target observation

SpecBestObjID bigint 8 Unique ID of the Best observation

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

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

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

targetRa float 8 deg J2000 right ascension (r')

targetDec float 8 deg J2000 declination (r')

targetCx float 8 POS_EQ_CART_X unit vector for ra+dec

targetCy float 8 POS_EQ_CART_Y unit vector for ra+dec

targetCz float 8 POS_EQ_CART_Z unit vector for ra+dec

targetPsfMag_u real 4 mag PHOT_SDSS_U PSF flux

targetPsfMag_g real 4 mag PHOT_SDSS_G PSF flux

targetPsfMag_r real 4 mag PHOT_SDSS_R PSF flux

targetPsfMag_i real 4 mag PHOT_SDSS_I PSF flux

targetPsfMag_z real 4 mag PHOT_SDSS_Z PSF flux

targetPsfMagErr_u real 4 mag PSF flux error

targetPsfMagErr_g real 4 mag PSF flux error

targetPsfMagErr_r real 4 mag PSF flux error

targetPsfMagErr_i real 4 mag PSF flux error

targetPsfMagErr_z real 4 mag PSF flux error

targetExtinction_u real 4 mag Extinction in each filter

targetExtinction_g real 4 mag Extinction in each filter

targetExtinction_r real 4 mag Extinction in each filter

targetExtinction_i real 4 mag Extinction in each filter

targetExtinction_z real 4 mag Extinction in each filter

targetType int 4 Morphological type classification of object.

targetMode int 4 1:primary, 2:secondary,4:outside survey.

targetStatus int 4 Photo status flags of this object

targetFlags bigint 8 Photo Object Attribute

targetFlags_u bigint 8 Object detection flags per band

targetFlags_g bigint 8 Object detection flags per band

targetFlags_r bigint 8 Object detection flags per band

targetFlags_i bigint 8 Object detection flags per band

targetFlags_z bigint 8 Object detection flags per band

targetRowC_i real 4 Row center position (r' coordinates)

targetColC_i real 4 Column center position (r' coordinates)

targetInsideMask int 4 Flag tells if object inside a mask & why

targetPrimTarget int 4 Bit mask of primary target categories

targetPriTargHiZ int 4 1: object flagged as HiZ QSO

targetPriTargLowZ int 4 1: object flagged as cap|skirt QSO

targetPriTargFirst int 4 1: object flagged as first cap|skirt QSO

targetFieldID bigint 8 Field this object is in

targetFieldMjd float 8 MJD(TAI) Julian Date row 0 was read

targetFieldQuality int 4 Quality of field

targetFieldCulled int 4 Targets culled from the field

targetSectorID bigint 8 The sector covering this object or 0

targetFirstID int 4 matching FIRST catalog id or 0

targetFirstPeak float 8 Peak first radio flux

targetRosatID int 4 matching ROSAT source (0 = no match)

targetRosatCps float 8 ct/s -- integrated ROSAT counts

targetMi float 8 estimated absolute magnitude based on Pen (1999) (or 0)

targetUniform bit 1 boolean: part of the uniform QSO sample

bestRa float 8 deg J2000 right ascension (r')

bestDec float 8 deg J2000 declination (r')

bestCx float 8 POS_EQ_CART_X unit vector for ra+dec

bestCy float 8 POS_EQ_CART_Y unit vector for ra+dec

bestCz float 8 POS_EQ_CART_Z unit vector for ra+dec

bestPsfMag_u real 4 mag PHOT_SDSS_U PSF flux

bestPsfMag_g real 4 mag PHOT_SDSS_G PSF flux

bestPsfMag_r real 4 mag PHOT_SDSS_R PSF flux

bestPsfMag_i real 4 mag PHOT_SDSS_I PSF flux

bestPsfMag_z real 4 mag PHOT_SDSS_Z PSF flux

bestPsfMagErr_u real 4 mag PSF flux error

bestPsfMagErr_g real 4 mag PSF flux error

bestPsfMagErr_r real 4 mag PSF flux error

bestPsfMagErr_i real 4 mag PSF flux error

bestPsfMagErr_z real 4 mag PSF flux error

bestExtinction_u real 4 mag Extinction in each filter

bestExtinction_g real 4 mag Extinction in each filter

bestExtinction_r real 4 mag Extinction in each filter

bestExtinction_i real 4 mag Extinction in each filter

bestExtinction_z real 4 mag Extinction in each filter

bestType int 4 Morphological type classification

bestMode int 4 1:primary, 2:secondary, 4:outside survey

bestFlags bigint 8 Photo Object Attribute Flags

bestFlags_u bigint 8 Object detection flags per band

bestFlags_g bigint 8 Object detection flags per band

bestFlags_r bigint 8 Object detection flags per band

bestFlags_i bigint 8 Object detection flags per band

bestFlags_z bigint 8 Object detection flags per band

bestRowC_i real 4 Row center position (r' coordinates)

bestColC_i real 4 Column center position (r' coordinates)

bestInsideMask int 4 Flag indicates if object is inside a mask

bestPrimTarget int 4 Bit mask of primary target categories

bestPriTargHiZ int 4 1: object flagged as HiZ QSO

bestPriTargLowZ int 4 1: object flagged as cap|skirt

bestPriTargFirst int 4 1: object flagged as first cap|skirt QSO

bestFieldID bigint 8 Link to the field this object is in

bestFieldMjd float 8 MJD(TAI) Julian Date when row 0 was read

bestFieldQuality int 4 Quality of field in terms of acceptance

bestFieldCulled int 4 Targets culled from the field

bestFirstID int 4 FIRST catalog id of one matching source

bestFirstPeak float 8 mJy Peak first radio flux

bestRosatID int 4 ID of matching ROSAT source (0 =no match)

bestRosatCps float 8 ct/s integrated ROSAT counts

bestMi float 8 estimated absolute magnitude based on Pen (1999) and Pei (1999) (or 0)

name	type	length	unit	ucd	description
HeadObjID	bigint	8			ID of first object in bunch (points to QsoBunch)
tripleID	int	4			Unique ID of this triple in the bunch
QsoPrimary	bit	1			1; this is best triple of bunch
TargetObjID	bigint	8			target QSO or surrogate target object or zero
SpecObjID	bigint	8			spec QSO or surrogate specobj or 0
BestObjID	bigint	8			best QSO or surrogate best or
TargetQsoTargeted	bit	1			1: Target was flagged QSO
SpecQsoConfirmed	bit	1			1; Spec was confirmed QSO
SpecQsoUnknown	bit	1			1; Spec was class unkonwn
SpecQsoLargeZ	bit	1			1; SpecObj has Z > 0.6
SpecQsoTargeted	bit	1			1; Spec was targeted as QSO
BestQsoTargeted	bit	1			1: Best was flagged QSO
dist_Target_Best	float	8	arcmins	POS_ANG_DIST_GENERAL	distance arcMin between Target and Best
dist_Target_Spec	float	8	arcmins	POS_ANG_DIST_GENERAL	distance arcMin betweenTarget and Spec
dist_Best_Spec	float	8	arcmins	POS_ANG_DIST_GENERAL	distance arcMin between Best and Spec
psfmag_i_diff	float	8	mag	PHOT_COLOR	-- (target.psfmag_i - best.psfmag_i)
psfmag_g_i_diff	float	8	mag	PHOT_COLOR	(target.psfmag_g-target.psfmag_i) - (best.psfmag_g-best.psfmag_i)
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
SpecTargetID	bigint	8			object ID in target table
SpecTargetObjID	bigint	8			Unique ID of the Target observation
SpecBestObjID	bigint	8			Unique ID of the Best observation
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
SpecPlateSn1_i	float	8			PLATE Spectogram 1(S/N)^2 i band
SpecPlateSn2_i	float	8			PLATE Spectogram 2 (S/N)^2 i band
targetRa	float	8	deg		J2000 right ascension (r')
targetDec	float	8	deg		J2000 declination (r')
targetCx	float	8		POS_EQ_CART_X	unit vector for ra+dec
targetCy	float	8		POS_EQ_CART_Y	unit vector for ra+dec
targetCz	float	8		POS_EQ_CART_Z	unit vector for ra+dec
targetPsfMag_u	real	4	mag	PHOT_SDSS_U	PSF flux
targetPsfMag_g	real	4	mag	PHOT_SDSS_G	PSF flux
targetPsfMag_r	real	4	mag	PHOT_SDSS_R	PSF flux
targetPsfMag_i	real	4	mag	PHOT_SDSS_I	PSF flux
targetPsfMag_z	real	4	mag	PHOT_SDSS_Z	PSF flux
targetPsfMagErr_u	real	4	mag		PSF flux error
targetPsfMagErr_g	real	4	mag		PSF flux error
targetPsfMagErr_r	real	4	mag		PSF flux error
targetPsfMagErr_i	real	4	mag		PSF flux error
targetPsfMagErr_z	real	4	mag		PSF flux error
targetExtinction_u	real	4	mag		Extinction in each filter
targetExtinction_g	real	4	mag		Extinction in each filter
targetExtinction_r	real	4	mag		Extinction in each filter
targetExtinction_i	real	4	mag		Extinction in each filter
targetExtinction_z	real	4	mag		Extinction in each filter
targetType	int	4			Morphological type classification of object.
targetMode	int	4			1:primary, 2:secondary,4:outside survey.
targetStatus	int	4			Photo status flags of this object
targetFlags	bigint	8			Photo Object Attribute
targetFlags_u	bigint	8			Object detection flags per band
targetFlags_g	bigint	8			Object detection flags per band
targetFlags_r	bigint	8			Object detection flags per band
targetFlags_i	bigint	8			Object detection flags per band
targetFlags_z	bigint	8			Object detection flags per band
targetRowC_i	real	4			Row center position (r' coordinates)
targetColC_i	real	4			Column center position (r' coordinates)
targetInsideMask	int	4			Flag tells if object inside a mask & why
targetPrimTarget	int	4			Bit mask of primary target categories
targetPriTargHiZ	int	4			1: object flagged as HiZ QSO
targetPriTargLowZ	int	4			1: object flagged as cap\|skirt QSO
targetPriTargFirst	int	4			1: object flagged as first cap\|skirt QSO
targetFieldID	bigint	8			Field this object is in
targetFieldMjd	float	8			MJD(TAI) Julian Date row 0 was read
targetFieldQuality	int	4			Quality of field
targetFieldCulled	int	4			Targets culled from the field
targetSectorID	bigint	8			The sector covering this object or 0
targetFirstID	int	4			matching FIRST catalog id or 0
targetFirstPeak	float	8			Peak first radio flux
targetRosatID	int	4			matching ROSAT source (0 = no match)
targetRosatCps	float	8	ct/s --		integrated ROSAT counts
targetMi	float	8			estimated absolute magnitude based on Pen (1999) (or 0)
targetUniform	bit	1			boolean: part of the uniform QSO sample
bestRa	float	8	deg		J2000 right ascension (r')
bestDec	float	8	deg		J2000 declination (r')
bestCx	float	8		POS_EQ_CART_X	unit vector for ra+dec
bestCy	float	8		POS_EQ_CART_Y	unit vector for ra+dec
bestCz	float	8		POS_EQ_CART_Z	unit vector for ra+dec
bestPsfMag_u	real	4	mag	PHOT_SDSS_U	PSF flux
bestPsfMag_g	real	4	mag	PHOT_SDSS_G	PSF flux
bestPsfMag_r	real	4	mag	PHOT_SDSS_R	PSF flux
bestPsfMag_i	real	4	mag	PHOT_SDSS_I	PSF flux
bestPsfMag_z	real	4	mag	PHOT_SDSS_Z	PSF flux
bestPsfMagErr_u	real	4	mag		PSF flux error
bestPsfMagErr_g	real	4	mag		PSF flux error
bestPsfMagErr_r	real	4	mag		PSF flux error
bestPsfMagErr_i	real	4	mag		PSF flux error
bestPsfMagErr_z	real	4	mag		PSF flux error
bestExtinction_u	real	4	mag		Extinction in each filter
bestExtinction_g	real	4	mag		Extinction in each filter
bestExtinction_r	real	4	mag		Extinction in each filter
bestExtinction_i	real	4	mag		Extinction in each filter
bestExtinction_z	real	4	mag		Extinction in each filter
bestType	int	4			Morphological type classification
bestMode	int	4			1:primary, 2:secondary, 4:outside survey
bestFlags	bigint	8			Photo Object Attribute Flags
bestFlags_u	bigint	8			Object detection flags per band
bestFlags_g	bigint	8			Object detection flags per band
bestFlags_r	bigint	8			Object detection flags per band
bestFlags_i	bigint	8			Object detection flags per band
bestFlags_z	bigint	8			Object detection flags per band
bestRowC_i	real	4			Row center position (r' coordinates)
bestColC_i	real	4			Column center position (r' coordinates)
bestInsideMask	int	4			Flag indicates if object is inside a mask
bestPrimTarget	int	4			Bit mask of primary target categories
bestPriTargHiZ	int	4			1: object flagged as HiZ QSO
bestPriTargLowZ	int	4			1: object flagged as cap\|skirt
bestPriTargFirst	int	4			1: object flagged as first cap\|skirt QSO
bestFieldID	bigint	8			Link to the field this object is in
bestFieldMjd	float	8			MJD(TAI) Julian Date when row 0 was read
bestFieldQuality	int	4			Quality of field in terms of acceptance
bestFieldCulled	int	4			Targets culled from the field
bestFirstID	int	4			FIRST catalog id of one matching source
bestFirstPeak	float	8	mJy		Peak first radio flux
bestRosatID	int	4			ID of matching ROSAT source (0 =no match)
bestRosatCps	float	8	ct/s		integrated ROSAT counts
bestMi	float	8			estimated absolute magnitude based on Pen (1999) and Pei (1999) (or 0)