TABLE SpecObjAll

Contains the measured parameters for a spectrum.

This is a base table containing ALL the spectroscopic information, including a lot of duplicate and bad data. Use the SpecObj view instead, which has the data properly filtered for cleanliness.

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

xFocal float 8 POS_CCD_X X Focal

yFocal float 8 POS_CCD_Y Y Focal

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

velDisp real 4 ??? VELOC_DISP Velocity Dispersion

velDispErr real 4 VELOC_DISP ERROR Velocity Dispersion error

eCoeff_0 real 4 FIT_PARAM Expansion Coeff for Galaxies

eCoeff_1 real 4 FIT_PARAM Expansion Coeff for Galaxies

eCoeff_2 real 4 FIT_PARAM Expansion Coeff for Galaxies

eCoeff_3 real 4 FIT_PARAM Expansion Coeff for Galaxies

eCoeff_4 real 4 FIT_PARAM Expansion Coeff for Galaxies

eClass real 4 CLASS_OBJECT Classification

nGood int 4 pix NUMBER Good Pixels

sn_0 real 4 INST_S/N Median S/N in g'

sn_1 real 4 INST_S/N Median S/N in r'

sn_2 real 4 INST_S/N Median S/N in i'

mag_0 real 4 mag PHOT_SDSS_G Synthetic Magnitude in g'

mag_1 real 4 mag PHOT_SDSS_R Synthetic Magnitude in r'

mag_2 real 4 mag PHOT_SDSS_I Synthetic Magnitude in i'

ra float 8 deg POS_EQ_RA_MAIN ra in J2000

dec float 8 deg POS_EQ_DEC_MAIN dec in J2000

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

fiberMag_u real 4 luptitudes PHOT_SDSS_U Fiber Magnitudes

fiberMag_g real 4 luptitudes PHOT_SDSS_G Fiber Magnitudes

fiberMag_r real 4 luptitudes PHOT_SDSS_R Fiber Magnitudes

fiberMag_i real 4 luptitudes PHOT_SDSS_I Fiber Magnitudes

fiberMag_z real 4 luptitudes PHOT_SDSS_Z Fiber Magnitudes

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.

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

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

otherPrimTarget int 4 CODE_MISC Specifies which other program primary target catagories the object was selected in.

otherSecTarget int 4 CODE_MISC Specifies which other program secondary target catagories the object was selected in.

pixMin smallint 2 pix INST_DET_LIMIT Pixmin

pixMax smallint 2 pix INST_DET_LIMIT Pixmax

sci_sn real 4 CODE_MISC Science signal to noise ratio

smear_sn real 4 CODE_MISC Smear signal to noise ratio

sm_leg_0 real 4 CODE_MISC 1st legendre coeff. for smear correct

sm_leg_1 real 4 CODE_MISC 2nd legendre coeff. for smear correct

sm_leg_2 real 4 CODE_MISC 3rd legendre coeff. for smear correct

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

loadVersion int 4 ID_TRACER Load Version

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

spectrographID smallint 2 INST_ID which spectrograph (1,2)

throughput int 4 ??? NUMBER fiber throughput as measured by mapper

objType int 4 CLASS_OBJECT object type (plPlugMap style)

objTypeName varchar 32 CLASS_OBJECT Object Type as string

targetID bigint 8 ID_CATALOG ID of Target

targetObjID bigint 8 ID_CATALOG ID of target PhotoObj

bestObjID bigint 8 ID_MAIN ID of best PhotoObj

img image 16 SPECT GIF image of the spectrum

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
xFocal	float	8		POS_CCD_X	X Focal
yFocal	float	8		POS_CCD_Y	Y Focal
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
velDisp	real	4	???	VELOC_DISP	Velocity Dispersion
velDispErr	real	4		VELOC_DISP ERROR	Velocity Dispersion error
eCoeff_0	real	4		FIT_PARAM	Expansion Coeff for Galaxies
eCoeff_1	real	4		FIT_PARAM	Expansion Coeff for Galaxies
eCoeff_2	real	4		FIT_PARAM	Expansion Coeff for Galaxies
eCoeff_3	real	4		FIT_PARAM	Expansion Coeff for Galaxies
eCoeff_4	real	4		FIT_PARAM	Expansion Coeff for Galaxies
eClass	real	4		CLASS_OBJECT	Classification
nGood	int	4	pix	NUMBER	Good Pixels
sn_0	real	4		INST_S/N	Median S/N in g'
sn_1	real	4		INST_S/N	Median S/N in r'
sn_2	real	4		INST_S/N	Median S/N in i'
mag_0	real	4	mag	PHOT_SDSS_G	Synthetic Magnitude in g'
mag_1	real	4	mag	PHOT_SDSS_R	Synthetic Magnitude in r'
mag_2	real	4	mag	PHOT_SDSS_I	Synthetic Magnitude in i'
ra	float	8	deg	POS_EQ_RA_MAIN	ra in J2000
dec	float	8	deg	POS_EQ_DEC_MAIN	dec in J2000
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
fiberMag_u	real	4	luptitudes	PHOT_SDSS_U	Fiber Magnitudes
fiberMag_g	real	4	luptitudes	PHOT_SDSS_G	Fiber Magnitudes
fiberMag_r	real	4	luptitudes	PHOT_SDSS_R	Fiber Magnitudes
fiberMag_i	real	4	luptitudes	PHOT_SDSS_I	Fiber Magnitudes
fiberMag_z	real	4	luptitudes	PHOT_SDSS_Z	Fiber Magnitudes
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.
seguePrimTarget	int	4		CODE_MISC	Specifies which SEGUE primary target catagories the object was selected in.
segueSecTarget	int	4		CODE_MISC	Specifies which SEGUE secondary target catagories the object was selected in.
otherPrimTarget	int	4		CODE_MISC	Specifies which other program primary target catagories the object was selected in.
otherSecTarget	int	4		CODE_MISC	Specifies which other program secondary target catagories the object was selected in.
pixMin	smallint	2	pix	INST_DET_LIMIT	Pixmin
pixMax	smallint	2	pix	INST_DET_LIMIT	Pixmax
sci_sn	real	4		CODE_MISC	Science signal to noise ratio
smear_sn	real	4		CODE_MISC	Smear signal to noise ratio
sm_leg_0	real	4		CODE_MISC	1st legendre coeff. for smear correct
sm_leg_1	real	4		CODE_MISC	2nd legendre coeff. for smear correct
sm_leg_2	real	4		CODE_MISC	3rd legendre coeff. for smear correct
sciencePrimary	smallint	2		CODE_MISC	Deemed to be science-worthy (defines default view SpecObj)
loadVersion	int	4		ID_TRACER	Load Version
plateID	bigint	8		ID_PLATE	Link to plate on which the spectrum was taken
spectrographID	smallint	2		INST_ID	which spectrograph (1,2)
throughput	int	4	???	NUMBER	fiber throughput as measured by mapper
objType	int	4		CLASS_OBJECT	object type (plPlugMap style)
objTypeName	varchar	32		CLASS_OBJECT	Object Type as string
targetID	bigint	8		ID_CATALOG	ID of Target
targetObjID	bigint	8		ID_CATALOG	ID of target PhotoObj
bestObjID	bigint	8		ID_MAIN	ID of best PhotoObj
img	image	16		SPECT	GIF image of the spectrum