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.

name type length unit ucd description

specObjID bigint 8 ID_CATALOG Unique ID

mjd int 4 MJD TIME_DATE MJD of observation

plate smallint 2 ID_PLATE Plate ID

tile smallint 2 ID_PLATE Tile ID

fiberID smallint 2 ID_FIBER Fiber ID

z real 4 REDSHIFT Final Redshift

zErr real 4 REDSHIFT ERROR Redshift error

zConf real 4 REDSHIFT STAT_PROBABILITY Redshift confidence

zStatus smallint 2 CODE_QUALITY Redshift status

specClass smallint 2 CLASS_OBJECT Spectral Classification

zWarning int 4 CODE_QUALITY Warning Flags

ra float 8 deg POS_EQ_RA_MAIN ra in J2000 from SpecObj

dec float 8 deg POS_EQ_DEC_MAIN dec in J2000 from SpecObj

cx float 8 POS_EQ_CART_X? x of Normal unit vector in J2000

cy float 8 POS_EQ_CART_Y? y of Normal unit vector in J2000

cz float 8 POS_EQ_CART_Z? z of Normal unit vector in J2000

htmID bigint 8 CODE_HTM 20 deep Hierarchical Triangular Mesh ID

primTarget int 4 CODE_MISC Specifies which primary target catagories the object was selected in.

secTarget int 4 CODE_MISC Specifies which secondary target catagories the object was selected in.

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

plateID bigint 8 ID_PLATE Link to plate on which the spectrum was taken

objType int 4 CLASS_OBJECT object type (plPlugMap style)

targetID bigint 8 ID_CATALOG ID of Target

targetObjID bigint 8 ID_CATALOG ID of target PhotoObj

targetMode tinyint 1 CLASS_OBJECT 1: primary, 2: secondary, 3: family object.

objID bigint 8 ID_CATALOG Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].

skyVersion int 4 CODE_MISC 0 = OPDB target, 1 = OPDB best

run int 4 OBS_RUN Run number

rerun int 4 CODE_MISC Rerun number

camcol int 4 INST_ID Camera column

field int 4 ID_FIELD Field number

obj int 4 ID_NUMBER The object id within a field. Usually changes between reruns of the same field.

mode int 4 CLASS_OBJECT 1: primary, 2: secondary, 3: family object.

nChild int 4 NUMBER Number of children if this is a deblened composite object. BRIGHT (in a flags sense) objects also have nchild==1, the non-BRIGHT sibling.

type int 4 CLASS_OBJECT Morphological type classification of the object.

flags bigint 8 CODE_MISC Photo Object Attribute Flags

psfMag_u real 4 mag PHOT_SDSS_U PSF flux

psfMag_g real 4 mag PHOT_SDSS_G PSF flux

psfMag_r real 4 mag PHOT_SDSS_R PSF flux

psfMag_i real 4 mag PHOT_SDSS_I PSF flux

psfMag_z real 4 mag PHOT_SDSS_Z PSF flux

psfMagErr_u real 4 mag PHOT_SDSS_U ERROR PSF flux error

psfMagErr_g real 4 mag PHOT_SDSS_G ERROR PSF flux error

psfMagErr_r real 4 mag PHOT_SDSS_R ERROR PSF flux error

psfMagErr_i real 4 mag PHOT_SDSS_I ERROR PSF flux error

psfMagErr_z real 4 mag PHOT_SDSS_Z ERROR PSF flux error

fiberMag_u real 4 mag PHOT_SDSS_U Flux in 3 arcsec diameter fiber radius

fiberMag_g real 4 mag PHOT_SDSS_G Flux in 3 arcsec diameter fiber radius

fiberMag_r real 4 mag PHOT_SDSS_R Flux in 3 arcsec diameter fiber radius

fiberMag_i real 4 mag PHOT_SDSS_I Flux in 3 arcsec diameter fiber radius

fiberMag_z real 4 mag PHOT_SDSS_Z Flux in 3 arcsec diameter fiber radius

fiberMagErr_u real 4 mag PHOT_SDSS_U ERROR Flux in 3 arcsec diameter fiber radius error

fiberMagErr_g real 4 mag PHOT_SDSS_G ERROR Flux in 3 arcsec diameter fiber radius error

fiberMagErr_r real 4 mag PHOT_SDSS_R ERROR Flux in 3 arcsec diameter fiber radius error

fiberMagErr_i real 4 mag PHOT_SDSS_I ERROR Flux in 3 arcsec diameter fiber radius error

fiberMagErr_z real 4 mag PHOT_SDSS_Z ERROR Flux in 3 arcsec diameter fiber radius error

petroMag_u real 4 mag PHOT_SDSS_U Petrosian flux

petroMag_g real 4 mag PHOT_SDSS_G Petrosian flux

petroMag_r real 4 mag PHOT_SDSS_R Petrosian flux

petroMag_i real 4 mag PHOT_SDSS_I Petrosian flux

petroMag_z real 4 mag PHOT_SDSS_Z Petrosian flux

petroMagErr_u real 4 mag PHOT_SDSS_U ERROR Petrosian flux error

petroMagErr_g real 4 mag PHOT_SDSS_G ERROR Petrosian flux error

petroMagErr_r real 4 mag PHOT_SDSS_R ERROR Petrosian flux error

petroMagErr_i real 4 mag PHOT_SDSS_I ERROR Petrosian flux error

petroMagErr_z real 4 mag PHOT_SDSS_Z ERROR Petrosian flux error

modelMag_u real 4 mag PHOT_SDSS_U FIT_PARAM better of DeV/Exp magnitude fit

modelMag_g real 4 mag PHOT_SDSS_G FIT_PARAM better of DeV/Exp magnitude fit

modelMag_r real 4 mag PHOT_SDSS_R FIT_PARAM better of DeV/Exp magnitude fit

modelMag_i real 4 mag PHOT_SDSS_I FIT_PARAM better of DeV/Exp magnitude fit

modelMag_z real 4 mag PHOT_SDSS_Z FIT_PARAM better of DeV/Exp magnitude fit

modelMagErr_u real 4 mag PHOT_SDSS_U ERROR better of DeV/Exp magnitude fit error

modelMagErr_g real 4 mag PHOT_SDSS_G ERROR better of DeV/Exp magnitude fit error

modelMagErr_r real 4 mag PHOT_SDSS_R ERROR better of DeV/Exp magnitude fit error

modelMagErr_i real 4 mag PHOT_SDSS_I ERROR better of DeV/Exp magnitude fit error

modelMagErr_z real 4 mag PHOT_SDSS_Z ERROR better of DeV/Exp magnitude fit error

mRrCc_r real 4 FIT_PARAM Adaptive ( + )

mRrCcErr_r real 4 FIT_PARAM ERROR Error in adaptive ( + )

status int 4 CODE_MISC Status of the object in the survey

photoRa float 8 deg POS_EQ_RA_MAIN J2000 right ascension (r') from Best

photoDec float 8 deg POS_EQ_DEC_MAIN J2000 declination (r') from Best

extinction_u real 4 mag PHOT_EXTINCTION_GAL Reddening in each filter

extinction_g real 4 mag PHOT_EXTINCTION_GAL Reddening in each filter

extinction_r real 4 mag PHOT_EXTINCTION_GAL Reddening in each filter

extinction_i real 4 mag PHOT_EXTINCTION_GAL Reddening in each filter

extinction_z real 4 mag PHOT_EXTINCTION_GAL Reddening in each filter

bestPrimTarget int 4 CODE_MISC Specifies which primary target catagories the object was selected in.

bestSecTarget int 4 CODE_MISC Specifies which secondary target catagories the object was selected in.

priority int 4 CODE_MISC Priority bits

fieldID bigint 8 ID_FIELD Link to the field this object is in

dered_u real 4 mag PHOT_SDSS_U Simplified mag, corrected for reddening: modelMag-reddening

dered_g real 4 mag PHOT_SDSS_G Simplified mag, corrected for reddening: modelMag-reddening

dered_r real 4 mag PHOT_SDSS_R Simplified mag, corrected for reddening: modelMag-reddening

dered_i real 4 mag PHOT_SDSS_I Simplified mag, corrected for reddening: modelMag-reddening

dered_z real 4 mag PHOT_SDSS_Z Simplified mag, corrected for reddening: modelMag-reddening

size real 4 computed: =SQRT(mRrCc_r/2.0)

tileRun smallint 2 ID_VERSION run of tiling software

tiPriority int 4 CODE_MISC collision priority given during tiling

tiMask int 4 CODE_MISC mask bits to determine what happened during tiling

collisionGroupID int 4 ID_CATALOG unique ID of collisionGroup in this tiling run

name	type	length	unit	ucd	description
specObjID	bigint	8		ID_CATALOG	Unique ID
mjd	int	4	MJD	TIME_DATE	MJD of observation
plate	smallint	2		ID_PLATE	Plate ID
tile	smallint	2		ID_PLATE	Tile ID
fiberID	smallint	2		ID_FIBER	Fiber ID
z	real	4		REDSHIFT	Final Redshift
zErr	real	4		REDSHIFT ERROR	Redshift error
zConf	real	4		REDSHIFT STAT_PROBABILITY	Redshift confidence
zStatus	smallint	2		CODE_QUALITY	Redshift status
specClass	smallint	2		CLASS_OBJECT	Spectral Classification
zWarning	int	4		CODE_QUALITY	Warning Flags
ra	float	8	deg	POS_EQ_RA_MAIN	ra in J2000 from SpecObj
dec	float	8	deg	POS_EQ_DEC_MAIN	dec in J2000 from SpecObj
cx	float	8		POS_EQ_CART_X?	x of Normal unit vector in J2000
cy	float	8		POS_EQ_CART_Y?	y of Normal unit vector in J2000
cz	float	8		POS_EQ_CART_Z?	z of Normal unit vector in J2000
htmID	bigint	8		CODE_HTM	20 deep Hierarchical Triangular Mesh ID
primTarget	int	4		CODE_MISC	Specifies which primary target catagories the object was selected in.
secTarget	int	4		CODE_MISC	Specifies which secondary target catagories the object was selected in.
sciencePrimary	smallint	2		CODE_MISC	Deemed to be science-worthy (defines default view SpecObj)
plateID	bigint	8		ID_PLATE	Link to plate on which the spectrum was taken
objType	int	4		CLASS_OBJECT	object type (plPlugMap style)
targetID	bigint	8		ID_CATALOG	ID of Target
targetObjID	bigint	8		ID_CATALOG	ID of target PhotoObj
targetMode	tinyint	1		CLASS_OBJECT	1: primary, 2: secondary, 3: family object.
objID	bigint	8		ID_CATALOG	Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
skyVersion	int	4		CODE_MISC	0 = OPDB target, 1 = OPDB best
run	int	4		OBS_RUN	Run number
rerun	int	4		CODE_MISC	Rerun number
camcol	int	4		INST_ID	Camera column
field	int	4		ID_FIELD	Field number
obj	int	4		ID_NUMBER	The object id within a field. Usually changes between reruns of the same field.
mode	int	4		CLASS_OBJECT	1: primary, 2: secondary, 3: family object.
nChild	int	4		NUMBER	Number of children if this is a deblened composite object. BRIGHT (in a flags sense) objects also have nchild==1, the non-BRIGHT sibling.
type	int	4		CLASS_OBJECT	Morphological type classification of the object.
flags	bigint	8		CODE_MISC	Photo Object Attribute Flags
psfMag_u	real	4	mag	PHOT_SDSS_U	PSF flux
psfMag_g	real	4	mag	PHOT_SDSS_G	PSF flux
psfMag_r	real	4	mag	PHOT_SDSS_R	PSF flux
psfMag_i	real	4	mag	PHOT_SDSS_I	PSF flux
psfMag_z	real	4	mag	PHOT_SDSS_Z	PSF flux
psfMagErr_u	real	4	mag	PHOT_SDSS_U ERROR	PSF flux error
psfMagErr_g	real	4	mag	PHOT_SDSS_G ERROR	PSF flux error
psfMagErr_r	real	4	mag	PHOT_SDSS_R ERROR	PSF flux error
psfMagErr_i	real	4	mag	PHOT_SDSS_I ERROR	PSF flux error
psfMagErr_z	real	4	mag	PHOT_SDSS_Z ERROR	PSF flux error
fiberMag_u	real	4	mag	PHOT_SDSS_U	Flux in 3 arcsec diameter fiber radius
fiberMag_g	real	4	mag	PHOT_SDSS_G	Flux in 3 arcsec diameter fiber radius
fiberMag_r	real	4	mag	PHOT_SDSS_R	Flux in 3 arcsec diameter fiber radius
fiberMag_i	real	4	mag	PHOT_SDSS_I	Flux in 3 arcsec diameter fiber radius
fiberMag_z	real	4	mag	PHOT_SDSS_Z	Flux in 3 arcsec diameter fiber radius
fiberMagErr_u	real	4	mag	PHOT_SDSS_U ERROR	Flux in 3 arcsec diameter fiber radius error
fiberMagErr_g	real	4	mag	PHOT_SDSS_G ERROR	Flux in 3 arcsec diameter fiber radius error
fiberMagErr_r	real	4	mag	PHOT_SDSS_R ERROR	Flux in 3 arcsec diameter fiber radius error
fiberMagErr_i	real	4	mag	PHOT_SDSS_I ERROR	Flux in 3 arcsec diameter fiber radius error
fiberMagErr_z	real	4	mag	PHOT_SDSS_Z ERROR	Flux in 3 arcsec diameter fiber radius error
petroMag_u	real	4	mag	PHOT_SDSS_U	Petrosian flux
petroMag_g	real	4	mag	PHOT_SDSS_G	Petrosian flux
petroMag_r	real	4	mag	PHOT_SDSS_R	Petrosian flux
petroMag_i	real	4	mag	PHOT_SDSS_I	Petrosian flux
petroMag_z	real	4	mag	PHOT_SDSS_Z	Petrosian flux
petroMagErr_u	real	4	mag	PHOT_SDSS_U ERROR	Petrosian flux error
petroMagErr_g	real	4	mag	PHOT_SDSS_G ERROR	Petrosian flux error
petroMagErr_r	real	4	mag	PHOT_SDSS_R ERROR	Petrosian flux error
petroMagErr_i	real	4	mag	PHOT_SDSS_I ERROR	Petrosian flux error
petroMagErr_z	real	4	mag	PHOT_SDSS_Z ERROR	Petrosian flux error
modelMag_u	real	4	mag	PHOT_SDSS_U FIT_PARAM	better of DeV/Exp magnitude fit
modelMag_g	real	4	mag	PHOT_SDSS_G FIT_PARAM	better of DeV/Exp magnitude fit
modelMag_r	real	4	mag	PHOT_SDSS_R FIT_PARAM	better of DeV/Exp magnitude fit
modelMag_i	real	4	mag	PHOT_SDSS_I FIT_PARAM	better of DeV/Exp magnitude fit
modelMag_z	real	4	mag	PHOT_SDSS_Z FIT_PARAM	better of DeV/Exp magnitude fit
modelMagErr_u	real	4	mag	PHOT_SDSS_U ERROR	better of DeV/Exp magnitude fit error
modelMagErr_g	real	4	mag	PHOT_SDSS_G ERROR	better of DeV/Exp magnitude fit error
modelMagErr_r	real	4	mag	PHOT_SDSS_R ERROR	better of DeV/Exp magnitude fit error
modelMagErr_i	real	4	mag	PHOT_SDSS_I ERROR	better of DeV/Exp magnitude fit error
modelMagErr_z	real	4	mag	PHOT_SDSS_Z ERROR	better of DeV/Exp magnitude fit error
mRrCc_r	real	4		FIT_PARAM	Adaptive ( + )
mRrCcErr_r	real	4		FIT_PARAM ERROR	Error in adaptive ( + )
status	int	4		CODE_MISC	Status of the object in the survey
photoRa	float	8	deg	POS_EQ_RA_MAIN	J2000 right ascension (r') from Best
photoDec	float	8	deg	POS_EQ_DEC_MAIN	J2000 declination (r') from Best
extinction_u	real	4	mag	PHOT_EXTINCTION_GAL	Reddening in each filter
extinction_g	real	4	mag	PHOT_EXTINCTION_GAL	Reddening in each filter
extinction_r	real	4	mag	PHOT_EXTINCTION_GAL	Reddening in each filter
extinction_i	real	4	mag	PHOT_EXTINCTION_GAL	Reddening in each filter
extinction_z	real	4	mag	PHOT_EXTINCTION_GAL	Reddening in each filter
bestPrimTarget	int	4		CODE_MISC	Specifies which primary target catagories the object was selected in.
bestSecTarget	int	4		CODE_MISC	Specifies which secondary target catagories the object was selected in.
priority	int	4		CODE_MISC	Priority bits
fieldID	bigint	8		ID_FIELD	Link to the field this object is in
dered_u	real	4	mag	PHOT_SDSS_U	Simplified mag, corrected for reddening: modelMag-reddening
dered_g	real	4	mag	PHOT_SDSS_G	Simplified mag, corrected for reddening: modelMag-reddening
dered_r	real	4	mag	PHOT_SDSS_R	Simplified mag, corrected for reddening: modelMag-reddening
dered_i	real	4	mag	PHOT_SDSS_I	Simplified mag, corrected for reddening: modelMag-reddening
dered_z	real	4	mag	PHOT_SDSS_Z	Simplified mag, corrected for reddening: modelMag-reddening
size	real	4			computed: =SQRT(mRrCc_r/2.0)
tileRun	smallint	2		ID_VERSION	run of tiling software
tiPriority	int	4		CODE_MISC	collision priority given during tiling
tiMask	int	4		CODE_MISC	mask bits to determine what happened during tiling
collisionGroupID	int	4		ID_CATALOG	unique ID of collisionGroup in this tiling run