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) |