TABLE  SpecPhotoAll

The combined spectro and photo parameters of an object in SpecObjAll

This is a precomputed join between the PhotoObjAll and SpecObjAll tables. The photo attibutes included cover about the same as PhotoTag. The table also includes certain attributes from Tiles.

nametypelengthunitucddescription
specObjIDbigint8 ID_CATALOGUnique ID
mjdint4MJDTIME_DATEMJD of observation
platesmallint2 ID_PLATEPlate ID
tilesmallint2 ID_PLATETile ID
fiberIDsmallint2 ID_FIBERFiber ID
zreal4 REDSHIFTFinal Redshift
zErrreal4 REDSHIFT ERRORRedshift error
zConfreal4 REDSHIFT STAT_PROBABILITYRedshift confidence
zStatusLink to SpecZStatussmallint2 CODE_QUALITYRedshift status
specClassLink to SpecClasssmallint2 CLASS_OBJECTSpectral Classification
zWarningLink to SpeczWarningint4 CODE_QUALITYWarning Flags
rafloat8degPOS_EQ_RA_MAINra in J2000 from SpecObj
decfloat8degPOS_EQ_DEC_MAINdec in J2000 from SpecObj
cxfloat8 POS_EQ_CART_X?x of Normal unit vector in J2000
cyfloat8 POS_EQ_CART_Y?y of Normal unit vector in J2000
czfloat8 POS_EQ_CART_Z?z of Normal unit vector in J2000
htmIDbigint8 CODE_HTM20 deep Hierarchical Triangular Mesh ID
primTargetLink to PrimTargetint4 CODE_MISCSpecifies which primary target catagories the object was selected in.
secTargetLink to SecTargetint4 CODE_MISCSpecifies which secondary target catagories the object was selected in.
sciencePrimarysmallint2 CODE_MISCDeemed to be science-worthy (defines default view SpecObj)
plateIDbigint8 ID_PLATELink to plate on which the spectrum was taken
objTypeLink to ObjTypeint4 CLASS_OBJECTobject type (plPlugMap style)
targetIDbigint8 ID_CATALOGID of Target
targetObjIDbigint8 ID_CATALOGID of target PhotoObj
targetModetinyint1 CLASS_OBJECT1: primary, 2: secondary, 3: family object.
objIDbigint8 ID_CATALOGUnique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
skyVersionint4 CODE_MISC0 = OPDB target, 1 = OPDB best
runint4 OBS_RUNRun number
rerunint4 CODE_MISCRerun number
camcolint4 INST_IDCamera column
fieldint4 ID_FIELDField number
objint4 ID_NUMBERThe object id within a field. Usually changes between reruns of the same field.
modeint4 CLASS_OBJECT1: primary, 2: secondary, 3: family object.
nChildint4 NUMBERNumber of children if this is a deblened composite object. BRIGHT (in a flags sense) objects also have nchild==1, the non-BRIGHT sibling.
typeLink to PhotoTypeint4 CLASS_OBJECTMorphological type classification of the object.
flagsLink to PhotoFlagsbigint8 CODE_MISCPhoto Object Attribute Flags
psfMag_ureal4magPHOT_SDSS_UPSF flux
psfMag_greal4magPHOT_SDSS_GPSF flux
psfMag_rreal4magPHOT_SDSS_RPSF flux
psfMag_ireal4magPHOT_SDSS_IPSF flux
psfMag_zreal4magPHOT_SDSS_ZPSF flux
psfMagErr_ureal4magPHOT_SDSS_U ERRORPSF flux error
psfMagErr_greal4magPHOT_SDSS_G ERRORPSF flux error
psfMagErr_rreal4magPHOT_SDSS_R ERRORPSF flux error
psfMagErr_ireal4magPHOT_SDSS_I ERRORPSF flux error
psfMagErr_zreal4magPHOT_SDSS_Z ERRORPSF flux error
fiberMag_ureal4magPHOT_SDSS_UFlux in 3 arcsec diameter fiber radius
fiberMag_greal4magPHOT_SDSS_GFlux in 3 arcsec diameter fiber radius
fiberMag_rreal4magPHOT_SDSS_RFlux in 3 arcsec diameter fiber radius
fiberMag_ireal4magPHOT_SDSS_IFlux in 3 arcsec diameter fiber radius
fiberMag_zreal4magPHOT_SDSS_ZFlux in 3 arcsec diameter fiber radius
fiberMagErr_ureal4magPHOT_SDSS_U ERRORFlux in 3 arcsec diameter fiber radius error
fiberMagErr_greal4magPHOT_SDSS_G ERRORFlux in 3 arcsec diameter fiber radius error
fiberMagErr_rreal4magPHOT_SDSS_R ERRORFlux in 3 arcsec diameter fiber radius error
fiberMagErr_ireal4magPHOT_SDSS_I ERRORFlux in 3 arcsec diameter fiber radius error
fiberMagErr_zreal4magPHOT_SDSS_Z ERRORFlux in 3 arcsec diameter fiber radius error
petroMag_ureal4magPHOT_SDSS_UPetrosian flux
petroMag_greal4magPHOT_SDSS_GPetrosian flux
petroMag_rreal4magPHOT_SDSS_RPetrosian flux
petroMag_ireal4magPHOT_SDSS_IPetrosian flux
petroMag_zreal4magPHOT_SDSS_ZPetrosian flux
petroMagErr_ureal4magPHOT_SDSS_U ERRORPetrosian flux error
petroMagErr_greal4magPHOT_SDSS_G ERRORPetrosian flux error
petroMagErr_rreal4magPHOT_SDSS_R ERRORPetrosian flux error
petroMagErr_ireal4magPHOT_SDSS_I ERRORPetrosian flux error
petroMagErr_zreal4magPHOT_SDSS_Z ERRORPetrosian flux error
modelMag_ureal4magPHOT_SDSS_U FIT_PARAMbetter of DeV/Exp magnitude fit
modelMag_greal4magPHOT_SDSS_G FIT_PARAMbetter of DeV/Exp magnitude fit
modelMag_rreal4magPHOT_SDSS_R FIT_PARAMbetter of DeV/Exp magnitude fit
modelMag_ireal4magPHOT_SDSS_I FIT_PARAMbetter of DeV/Exp magnitude fit
modelMag_zreal4magPHOT_SDSS_Z FIT_PARAMbetter of DeV/Exp magnitude fit
modelMagErr_ureal4magPHOT_SDSS_U ERRORbetter of DeV/Exp magnitude fit error
modelMagErr_greal4magPHOT_SDSS_G ERRORbetter of DeV/Exp magnitude fit error
modelMagErr_rreal4magPHOT_SDSS_R ERRORbetter of DeV/Exp magnitude fit error
modelMagErr_ireal4magPHOT_SDSS_I ERRORbetter of DeV/Exp magnitude fit error
modelMagErr_zreal4magPHOT_SDSS_Z ERRORbetter of DeV/Exp magnitude fit error
mRrCc_rreal4 FIT_PARAMAdaptive ( + )
mRrCcErr_rreal4 FIT_PARAM ERRORError in adaptive ( + )
statusLink to PhotoStatusint4 CODE_MISCStatus of the object in the survey
photoRafloat8degPOS_EQ_RA_MAINJ2000 right ascension (r') from Best
photoDecfloat8degPOS_EQ_DEC_MAINJ2000 declination (r') from Best
extinction_ureal4magPHOT_EXTINCTION_GALReddening in each filter
extinction_greal4magPHOT_EXTINCTION_GALReddening in each filter
extinction_rreal4magPHOT_EXTINCTION_GALReddening in each filter
extinction_ireal4magPHOT_EXTINCTION_GALReddening in each filter
extinction_zreal4magPHOT_EXTINCTION_GALReddening in each filter
bestPrimTargetLink to PrimTargetint4 CODE_MISCSpecifies which primary target catagories the object was selected in.
bestSecTargetLink to SecTargetint4 CODE_MISCSpecifies which secondary target catagories the object was selected in.
priorityint4 CODE_MISCPriority bits
fieldIDbigint8 ID_FIELDLink to the field this object is in
dered_ureal4magPHOT_SDSS_USimplified mag, corrected for reddening: modelMag-reddening
dered_greal4magPHOT_SDSS_GSimplified mag, corrected for reddening: modelMag-reddening
dered_rreal4magPHOT_SDSS_RSimplified mag, corrected for reddening: modelMag-reddening
dered_ireal4magPHOT_SDSS_ISimplified mag, corrected for reddening: modelMag-reddening
dered_zreal4magPHOT_SDSS_ZSimplified mag, corrected for reddening: modelMag-reddening
sizereal4  computed: =SQRT(mRrCc_r/2.0)
tileRunsmallint2 ID_VERSIONrun of tiling software
tiPriorityLink to ???int4 CODE_MISCcollision priority given during tiling
tiMaskLink to TiMaskint4 CODE_MISCmask bits to determine what happened during tiling
collisionGroupIDint4 ID_CATALOGunique ID of collisionGroup in this tiling run