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

class varchar 32 Spectroscopic class (GALAXY, QSO, or STAR)

subClass varchar 32 Spectroscopic subclass

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

sciencePrimary smallint 2 Best version of spectrum at this location (defines default view SpecObj)

legacyPrimary smallint 2 Best version of spectrum at this location, among Legacy plates

seguePrimary smallint 2 Best version of spectrum at this location, among SEGUE plates (defines default view SpecObj)

segue1Primary smallint 2 Best version of spectrum at this location, among SEGUE-1 plates

segue2Primary smallint 2 Best version of spectrum at this location, among SEGUE-1 plates

bossPrimary smallint 2 Best version of spectrum at this location, among BOSS plates

sdssPrimary smallint 2 Best version of spectrum at this location among SDSS plates

survey varchar 32 Survey name

programname varchar 32 Program name

legacy_target1 bigint 8 for Legacy program, target selection information at plate design

legacy_target2 bigint 8 for Legacy program target selection information at plate design, secondary/qa/calibration

special_target1 bigint 8 for Special program target selection information at plate design

special_target2 bigint 8 for Special program target selection information at plate design, secondary/qa/calibration

segue1_target1 bigint 8 SEGUE-1 target selection information at plate design, primary science selection

segue1_target2 bigint 8 SEGUE-1 target selection information at plate design, secondary/qa/calib selection

segue2_target1 bigint 8 SEGUE-2 target selection information at plate design, primary science selection

segue2_target2 bigint 8 SEGUE-2 target selection information at plate design, secondary/qa/calib selection

boss_target1 bigint 8 BOSS target selection information at plate

ancillary_target1 bigint 8 BOSS ancillary science target selection information at plate design

ancillary_target2 bigint 8 BOSS ancillary target selection information at plate design

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

sourceType varchar 32 CLASS_OBJECT type of object targeted as

targetObjID bigint 8 ID_CATALOG ID of target PhotoObj

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

cModelMag_u real 4 mag DeV+Exp magnitude

cModelMag_g real 4 mag DeV+Exp magnitude

cModelMag_r real 4 mag DeV+Exp magnitude

cModelMag_i real 4 mag DeV+Exp magnitude

cModelMag_z real 4 mag DeV+Exp magnitude

cModelMagErr_u real 4 mag DeV+Exp magnitude error

cModelMagErr_g real 4 mag DeV+Exp magnitude error

cModelMagErr_r real 4 mag DeV+Exp magnitude error

cModelMagErr_i real 4 mag DeV+Exp magnitude error

cModelMagErr_z real 4 mag DeV+Exp magnitude error

mRrCc_r real 4 FIT_PARAM Adaptive ( + )

mRrCcErr_r real 4 FIT_PARAM ERROR Error in adaptive ( + )

score real 4 Quality of field (0-1)

resolveStatus int 4 Resolve status of object

calibStatus_u int 4 Calibration status in u-band

calibStatus_g int 4 Calibration status in g-band

calibStatus_r int 4 Calibration status in r-band

calibStatus_i int 4 Calibration status in i-band

calibStatus_z int 4 Calibration status in z-band

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

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

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
class	varchar	32			Spectroscopic class (GALAXY, QSO, or STAR)
subClass	varchar	32			Spectroscopic subclass
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
sciencePrimary	smallint	2			Best version of spectrum at this location (defines default view SpecObj)
legacyPrimary	smallint	2			Best version of spectrum at this location, among Legacy plates
seguePrimary	smallint	2			Best version of spectrum at this location, among SEGUE plates (defines default view SpecObj)
segue1Primary	smallint	2			Best version of spectrum at this location, among SEGUE-1 plates
segue2Primary	smallint	2			Best version of spectrum at this location, among SEGUE-1 plates
bossPrimary	smallint	2			Best version of spectrum at this location, among BOSS plates
sdssPrimary	smallint	2			Best version of spectrum at this location among SDSS plates
survey	varchar	32			Survey name
programname	varchar	32			Program name
legacy_target1	bigint	8			for Legacy program, target selection information at plate design
legacy_target2	bigint	8			for Legacy program target selection information at plate design, secondary/qa/calibration
special_target1	bigint	8			for Special program target selection information at plate design
special_target2	bigint	8			for Special program target selection information at plate design, secondary/qa/calibration
segue1_target1	bigint	8			SEGUE-1 target selection information at plate design, primary science selection
segue1_target2	bigint	8			SEGUE-1 target selection information at plate design, secondary/qa/calib selection
segue2_target1	bigint	8			SEGUE-2 target selection information at plate design, primary science selection
segue2_target2	bigint	8			SEGUE-2 target selection information at plate design, secondary/qa/calib selection
boss_target1	bigint	8			BOSS target selection information at plate
ancillary_target1	bigint	8			BOSS ancillary science target selection information at plate design
ancillary_target2	bigint	8			BOSS ancillary target selection information at plate design
plateID	bigint	8		ID_PLATE	Link to plate on which the spectrum was taken
sourceType	varchar	32		CLASS_OBJECT	type of object targeted as
targetObjID	bigint	8		ID_CATALOG	ID of target PhotoObj
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
cModelMag_u	real	4	mag		DeV+Exp magnitude
cModelMag_g	real	4	mag		DeV+Exp magnitude
cModelMag_r	real	4	mag		DeV+Exp magnitude
cModelMag_i	real	4	mag		DeV+Exp magnitude
cModelMag_z	real	4	mag		DeV+Exp magnitude
cModelMagErr_u	real	4	mag		DeV+Exp magnitude error
cModelMagErr_g	real	4	mag		DeV+Exp magnitude error
cModelMagErr_r	real	4	mag		DeV+Exp magnitude error
cModelMagErr_i	real	4	mag		DeV+Exp magnitude error
cModelMagErr_z	real	4	mag		DeV+Exp magnitude error
mRrCc_r	real	4		FIT_PARAM	Adaptive ( + )
mRrCcErr_r	real	4		FIT_PARAM ERROR	Error in adaptive ( + )
score	real	4			Quality of field (0-1)
resolveStatus	int	4			Resolve status of object
calibStatus_u	int	4			Calibration status in u-band
calibStatus_g	int	4			Calibration status in g-band
calibStatus_r	int	4			Calibration status in r-band
calibStatus_i	int	4			Calibration status in i-band
calibStatus_z	int	4			Calibration status in z-band
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
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