VIEW SpecObj

DERIVED FROM specObjAll

A view of Spectro objects that just has the clean spectra.

The view excludes QA and Sky and duplicates. Use this as the main way to access the spectro objects.

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