VIEW SpecPhoto

DERIVED FROM SpecPhotoAll

A view of joined Spectro and Photo objects that have the clean spectra.

The view includes only those pairs where the SpecObj is a sciencePrimary, and the BEST PhotoObj is a PRIMARY (mode=1).

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