TABLE  SpecObjAll

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. These tables contain both the BOSS and SDSS spectrograph data. NOTE: The RA and Dec in this table refer to the DR8 coordinates, which have errors in the region north of 41 deg in Dec. This change does not affect the matching to the photometric catalog.

name	type	length	unit	ucd	description
specObjID	bigint	8		ID_CATALOG	Unique database ID based on PLATE, MJD, FIBERID, RUN2D
bestObjID	bigint	8		ID_MAIN	Object ID of photoObj match (position-based)
fluxObjID	bigint	8		ID_MAIN	Object ID of photoObj match (flux-based)
targetObjID	bigint	8		ID_CATALOG	Object ID of original target
plateID	bigint	8			Database ID of Plate
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
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
bossSpecObjID	int	4			Index of BOSS observation in spAll flat file
firstRelease	varchar	32			Name of first release this object was associated with
survey	varchar	32			Survey name
instrument	varchar	32			Instrument used (SDSS or BOSS spectrograph)
programname	varchar	32			Program name
chunk	varchar	32			Chunk name
platerun	varchar	32			Plate drill run name
mjd	int	4	days		MJD of observation
plate	smallint	2			Plate number
fiberID	smallint	2			Fiber ID
run1d	varchar	32			1D Reduction version of spectrum
run2d	varchar	32			2D Reduction version of spectrum
tile	int	4			Tile number
designID	int	4			Design ID number
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
primTarget	bigint	8			target selection information at plate design, primary science selection (for backwards compatibility)
secTarget	bigint	8			target selection information at plate design, secondary/qa/calib selection (for backwards compatibility)
spectrographID	smallint	2			which spectrograph (1,2)
sourceType	varchar	128			For Legacy, SEGUE-2 and BOSS science targets, type of object targeted as (target bits contain full information and are recommended)
targetType	varchar	128			Nature of target: SCIENCE, STANDARD, or SKY
ra	float	8	deg		DR8 Right ascension of fiber, J2000
dec	float	8	deg		DR8 Declination of fiber, 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
xFocal	real	4	mm		X focal plane position (+RA direction)
yFocal	real	4	mm		Y focal plane position (+Dec direction)
lambdaEff	real	4	Angstroms		Effective wavelength that hole was drilled for (accounting for atmopheric refraction)
blueFiber	int	4			Set to 1 if this hole was designated a "blue fiber", 0 if designated a "red fiber" (high redshift LRGs are preferentially in "red fibers")
zOffset	real	4	microns		Washer thickness used (for backstopping BOSS quasar targets, so they are closer to 4000 Angstrom focal plan)
z	real	4			Final Redshift
zErr	real	4			Redshift error
zWarning	int	4			Bitmask of warning values; 0 means all is well
class	varchar	32			Spectroscopic class (GALAXY, QSO, or STAR)
subClass	varchar	32			Spectroscopic subclass
rChi2	real	4			Reduced chi-squared of best fit
DOF	real	4			Degrees of freedom in best fit
rChi2Diff	real	4			Difference in reduced chi-squared between best and second best fit
z_noqso	real	4			Best redshift when excluding QSO fit (right redshift to use for galaxy targets)
zErr_noqso	real	4			Error in "z_noqso" redshift
zWarning_noqso	real	4			Warnings in "z_noqso" redshift
class_noqso	varchar	32			Classification in "z_noqso" redshift
subClass_noqso	varchar	32			Sub-classification in "z_noqso" redshift
rChi2Diff_noqso	real	4			Reduced chi-squared difference from next best redshift, for "z_noqso" redshift
z_person	real	4			Person-assigned redshift, if this object has been inspected
class_person	varchar	32			Person-assigned classification, if this object has been inspected
comments_person	varchar	200			Comments from person for inspected objects
tFile	varchar	32			File name of best fit template source
tColumn_0	smallint	2			Which column of the template file corresponds to template #0
tColumn_1	smallint	2			Which column of the template file corresponds to template #1
tColumn_2	smallint	2			Which column of the template file corresponds to template #2
tColumn_3	smallint	2			Which column of the template file corresponds to template #3
tColumn_4	smallint	2			Which column of the template file corresponds to template #4
tColumn_5	smallint	2			Which column of the template file corresponds to template #5
tColumn_6	smallint	2			Which column of the template file corresponds to template #6
tColumn_7	smallint	2			Which column of the template file corresponds to template #7
tColumn_8	smallint	2			Which column of the template file corresponds to template #8
tColumn_9	smallint	2			Which column of the template file corresponds to template #9
nPoly	real	4			Number of polynomial terms used in the fit
theta_0	real	4			Coefficient for template #0 of fit
theta_1	real	4			Coefficient for template #1 of fit
theta_2	real	4			Coefficient for template #2 of fit
theta_3	real	4			Coefficient for template #3 of fit
theta_4	real	4			Coefficient for template #4 of fit
theta_5	real	4			Coefficient for template #5 of fit
theta_6	real	4			Coefficient for template #6 of fit
theta_7	real	4			Coefficient for template #7 of fit
theta_8	real	4			Coefficient for template #8 of fit
theta_9	real	4			Coefficient for template #9 of fit
velDisp	real	4	km/s		Velocity dispersion
velDispErr	real	4	km/s		Error in velocity dispersion
velDispZ	real	4			Redshift associated with best fit velocity dispersion
velDispZErr	real	4			Error in redshift associated with best fit velocity dispersion
velDispChi2	real	4			Chi-squared associated with velocity dispersion fit
velDispNPix	int	4			Number of pixels overlapping best template in velocity dispersion fit
velDispDOF	int	4			Number of degrees of freedom in velocity dispersion fit
waveMin	real	4	Angstroms		Minimum observed (vacuum) wavelength
waveMax	real	4	Angstroms		Maximum observed (vacuum) wavelength
wCoverage	real	4			Coverage in wavelength, in units of log10 wavelength
snMedian_u	real	4			Median signal-to-noise over all good pixels in u-band
snMedian_g	real	4			Median signal-to-noise over all good pixels in g-band
snMedian_r	real	4			Median signal-to-noise over all good pixels in r-band
snMedian_i	real	4			Median signal-to-noise over all good pixels in i-band
snMedian_z	real	4			Median signal-to-noise over all good pixels in z-band
snMedian	real	4			Median signal-to-noise over all good pixels
chi68p	real	4			68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit)
fracNSigma_1	real	4			Fraction of pixels deviant by more than 1 sigma relative to best-fit
fracNSigma_2	real	4			Fraction of pixels deviant by more than 2 sigma relative to best-fit
fracNSigma_3	real	4			Fraction of pixels deviant by more than 3 sigma relative to best-fit
fracNSigma_4	real	4			Fraction of pixels deviant by more than 4 sigma relative to best-fit
fracNSigma_5	real	4			Fraction of pixels deviant by more than 5 sigma relative to best-fit
fracNSigma_6	real	4			Fraction of pixels deviant by more than 6 sigma relative to best-fit
fracNSigma_7	real	4			Fraction of pixels deviant by more than 7 sigma relative to best-fit
fracNSigma_8	real	4			Fraction of pixels deviant by more than 8 sigma relative to best-fit
fracNSigma_9	real	4			Fraction of pixels deviant by more than 9 sigma relative to best-fit
fracNSigma_10	real	4			Fraction of pixels deviant by more than 10 sigma relative to best-fit
fracNSigHi_1	real	4			Fraction of pixels high by more than 1 sigma relative to best-fit
fracNSigHi_2	real	4			Fraction of pixels high by more than 2 sigma relative to best-fit
fracNSigHi_3	real	4			Fraction of pixels high by more than 3 sigma relative to best-fit
fracNSigHi_4	real	4			Fraction of pixels high by more than 4 sigma relative to best-fit
fracNSigHi_5	real	4			Fraction of pixels high by more than 5 sigma relative to best-fit
fracNSigHi_6	real	4			Fraction of pixels high by more than 6 sigma relative to best-fit
fracNSigHi_7	real	4			Fraction of pixels high by more than 7 sigma relative to best-fit
fracNSigHi_8	real	4			Fraction of pixels high by more than 8 sigma relative to best-fit
fracNSigHi_9	real	4			Fraction of pixels high by more than 9 sigma relative to best-fit
fracNSigHi_10	real	4			Fraction of pixels high by more than 10 sigma relative to best-fit
fracNSigLo_1	real	4			Fraction of pixels low by more than 1 sigma relative to best-fit
fracNSigLo_2	real	4			Fraction of pixels low by more than 2 sigma relative to best-fit
fracNSigLo_3	real	4			Fraction of pixels low by more than 3 sigma relative to best-fit
fracNSigLo_4	real	4			Fraction of pixels low by more than 4 sigma relative to best-fit
fracNSigLo_5	real	4			Fraction of pixels low by more than 5 sigma relative to best-fit
fracNSigLo_6	real	4			Fraction of pixels low by more than 6 sigma relative to best-fit
fracNSigLo_7	real	4			Fraction of pixels low by more than 7 sigma relative to best-fit
fracNSigLo_8	real	4			Fraction of pixels low by more than 8 sigma relative to best-fit
fracNSigLo_9	real	4			Fraction of pixels low by more than 9 sigma relative to best-fit
fracNSigLo_10	real	4			Fraction of pixels low by more than 10 sigma relative to best-fit
spectroFlux_u	real	4	nanomaggies		Spectrum projected onto u filter
spectroFlux_g	real	4	nanomaggies		Spectrum projected onto g filter
spectroFlux_r	real	4	nanomaggies		Spectrum projected onto r filter
spectroFlux_i	real	4	nanomaggies		Spectrum projected onto i filter
spectroFlux_z	real	4	nanomaggies		Spectrum projected onto z filter
spectroSynFlux_u	real	4	nanomaggies		Best-fit template spectrum projected onto u filter
spectroSynFlux_g	real	4	nanomaggies		Best-fit template spectrum projected onto g filter
spectroSynFlux_r	real	4	nanomaggies		Best-fit template spectrum projected onto r filter
spectroSynFlux_i	real	4	nanomaggies		Best-fit template spectrum projected onto i filter
spectroSynFlux_z	real	4	nanomaggies		Best-fit template spectrum projected onto z filter
spectroFluxIvar_u	real	4	1/nanomaggies^2		Inverse variance of spectrum projected onto u filter
spectroFluxIvar_g	real	4	1/nanomaggies^2		Inverse variance of spectrum projected onto g filter
spectroFluxIvar_r	real	4	1/nanomaggies^2		Inverse variance of spectrum projected onto r filter
spectroFluxIvar_i	real	4	1/nanomaggies^2		Inverse variance of spectrum projected onto i filter
spectroFluxIvar_z	real	4	1/nanomaggies^2		Inverse variance of spectrum projected onto z filter
spectroSynFluxIvar_u	real	4	1/nanomaggies^2		Inverse variance of best-fit template spectrum projected onto u filter
spectroSynFluxIvar_g	real	4	1/nanomaggies^2		Inverse variance of best-fit template spectrum projected onto g filter
spectroSynFluxIvar_r	real	4	1/nanomaggies^2		Inverse variance of best-fit template spectrum projected onto r filter
spectroSynFluxIvar_i	real	4	1/nanomaggies^2		Inverse variance of best-fit template spectrum projected onto i filter
spectroSynFluxIvar_z	real	4	1/nanomaggies^2		Inverse variance of best-fit template spectrum projected onto z filter
spectroSkyFlux_u	real	4	nanomaggies		Sky spectrum projected onto u filter
spectroSkyFlux_g	real	4	nanomaggies		Sky spectrum projected onto g filter
spectroSkyFlux_r	real	4	nanomaggies		Sky spectrum projected onto r filter
spectroSkyFlux_i	real	4	nanomaggies		Sky spectrum projected onto i filter
spectroSkyFlux_z	real	4	nanomaggies		Sky spectrum projected onto z filter
anyAndMask	int	4			For each bit, records whether any pixel in the spectrum has that bit set in its ANDMASK
anyOrMask	int	4			For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK
plateSN2	real	4			Overall signal-to-noise-squared measure for plate (only set for SDSS spectrograph)
deredSN2	real	4			Dereddened signal-to-noise-squared measure for plate (only set for BOSS spectrograph)
snTurnoff	real	4			Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate)
sn1_g	real	4			(S/N)^2 at g=20.20 for spectrograph #1
sn1_r	real	4			(S/N)^2 at r=20.25 for spectrograph #1
sn1_i	real	4			(S/N)^2 at i=19.90 for spectrograph #1
sn2_g	real	4			(S/N)^2 at g=20.20 for spectrograph #2
sn2_r	real	4			(S/N)^2 at r=20.25 for spectrograph #2
sn2_i	real	4			(S/N)^2 at i=19.90 for spectrograph #2
elodieFileName	varchar	32			File name for best-fit Elodie star
elodieObject	varchar	32			Star name (mostly Henry Draper names)
elodieSpType	varchar	32			Spectral type
elodieBV	real	4	mag		(B-V) color
elodieTEff	real	4	Kelvin		Effective temperature
elodieLogG	real	4			log10(gravity)
elodieFeH	real	4			Metallicity ([Fe/H])
elodieZ	real	4			Redshift
elodieZErr	real	4			Redshift error (negative for invalid fit)
elodieZModelErr	real	4			Standard deviation in redshift among the 12 best-fit stars
elodieRChi2	real	4			Reduced chi^2
elodieDOF	real	4			Degrees of freedom for fit
htmID	bigint	8		CODE_HTM	20 deep Hierarchical Triangular Mesh ID
loadVersion	int	4		ID_TRACER	Load Version
img	varbinary	-1		IMAGE?	Spectrum Image
sdssPrimary	smallint	2			Best version of spectrum at this location among SDSS plates