TABLE  sppParams

Spectra for over 250,000 Galactic stars of all common spectral types are available with DR6. These Spectra were processed with a pipeline called the 'Spectro Parameter Pipeline' (spp) that computes standard stellar atmospheric parameters such as [Fe/H], log g and Teff for each star by a variety of methods. These outputs are stored in this table, and indexed on the 'specObjID' key index parameter for queries joining to other tables such as specobjall and photoobjall. See the Sample Queries in SkyServer for examples of such queries.

name	type	length	unit	ucd	description
specobjid	bigint	8			64 bit unique spectrum id f(p,mjd,fiber)
plate	int	4			plate number
mjd	int	4			Modified Julian Date of (last) observation
fiberid	int	4			Fiber number (1-640) 1-320 on spec#1
seguetargetclass	varchar	64			SEGUE or SDSS target type abbrev. (see targettype below)
hammersptype	varchar	64			Stellar Type Classification -- UW
sptypea	varchar	64			Stellar Type Classification -- SSPP
flag	varchar	64			SSPP flags BCdDEgGhHlnNSV, n=normal
feha	real	4	dex		adopted [Fe/H] value, combination of good estimates
fehan	int	4			number of estimators combined into feha
fehaerr	real	4			error/sigma on the [Fe/H] value, or -9.999
feh1	real	4			YSL1 Kurucz NGS grid [Fe/H]
feh1n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh1err	real	4			error/sigma on the [Fe/H] value
feh2	real	4			YSL2 Kurucz NGS grid [Fe/H] --U/ dex
feh2n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh2err	real	4			error/sigma on the [Fe/H] value
feh3	real	4			ANNSR [Fe/H] neural network SR method
feh3n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh3err	real	4			error/sigma on the [Fe/H] value
feh4	real	4			ANNRR [Fe/H] neural network RR method
feh4n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh4err	real	4			error/sigma on the [Fe/H] value
feh5	real	4			CaK_Y [Fe/H] from neural network method
feh5n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh5err	real	4			error/sigma on the [Fe/H] value
feh6	real	4			CaK_T1 [Fe/H] from neural network method
feh6n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh6err	real	4			error/sigma on the [Fe/H] value
feh7	real	4			CaK_T2 [Fe/H] from neural network method
feh7n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh7err	real	4			error/sigma on the [Fe/H] value
feh8	real	4			AUTOcorrelation [Fe/H] method
feh8n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh8err	real	4			error/sigma on the [Fe/H] value
feh9	real	4			Ca triplet method [Fe/H]
feh9n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh9err	real	4			error/sigma on the [Fe/H] value
feh10	real	4			Wilhelm, Beers and Gray method (1999) [Fe/H]
feh10n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh10err	real	4			error/sigma on the [Fe/H] value
feh11	real	4			[Fe/H] from Carlos K24 grid method
feh11n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh11err	real	4			error/sigma on the [Fe/H] value
feh12	real	4			[Fe/H] from Carlos K13 grid method
feh12n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
feh12err	real	4			error/sigma on the [Fe/H] value
teffa	real	4	Kelvins		Adopted Teff -- weighted mean
teffan	int	4			number of methods averaged
teffaerr	real	4			error/sigma on the Teff
teff1	real	4			Teff from H alpha line (24A EW)
teff1n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff1err	real	4			erorr/sigma on the Teff
teff2	real	4			Teff from H delta line (24A EW)
teff2n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff2err	real	4			error/sigma on the Teff
teff3	real	4			Teff from Kurucz models, based on colors
teff3n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff3err	real	4			error/sigma on the Teff
teff4	real	4			Teff from Girardi isochrones (2004)
teff4n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff4err	real	4			error/sigma on the Teff
teff5	real	4			Teff from Ivezic et al. (2007) (colors)
teff5n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff5err	real	4			error/sigma on the Teff
teff6	real	4			Teff from YSL method
teff6n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff6err	real	4			error/sigma on the Teff
teff7	real	4			Teff from neural network method ANNSR
teff7n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff7err	real	4			error/sigma on the Teff
teff8	real	4			Teff from neural network method ANNRR
teff8n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff8err	real	4			error/sigma on the Teff
teff9	real	4			Teff from Wilhelm, Beers, and Gray (1999)
teff9n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff9err	real	4			error/sigma on the Teff
teff10	real	4			Teff from Carlos k24 grid
teff10n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff10err	real	4			error/sigma on the Teff
teff11	real	4			Teff from Carlos ki13 grid
teff11n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
teff11err	real	4			error/sigma on the Teff
logga	real	4	cgs		Adopted log g -- weighted mean
loggan	int	4			number of methods used
loggaerr	real	4			error/sigma on log g
logg1	real	4			log g from YSL1 Kurucz grid
logg1n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg1err	real	4			error/sigma on log g
logg2	real	4			log g from YSL2 Kurucz grid
logg2n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg2err	real	4			error/sigma on log g
logg3	real	4			log g from neural netork method ANNSR
logg3n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg3err	real	4			error/sigma on log g
logg4	real	4			log g from neural network method ANNRR
logg4n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg4err	real	4			error/sigma on log g
logg5	real	4			log g from CaK_Y method
logg5n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg5err	real	4			error/sigma on log g
logg6	real	4			log g from from Ca I (4226 A) line index
logg6n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg6err	real	4			error/sigma on log g
logg7	real	4			log g from MgH features (around 5170 A)
logg7n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg7err	real	4			error/sigma on log g
logg8	real	4			log g from Wilhelm, Beers, and Gray (1999)
logg8n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg8err	real	4			error/sigma on log g
logg9	real	4			log g from Carlos k24 grid
logg9n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg9err	real	4			error/sigma on log g
logg10	real	4			log g from Carlos ki13 grid
logg10n	int	4			0 = no value, 1 = low S/N value, 2 = good, included in feha average
logg10err	real	4			error/sigma on log g
alphafe	real	4	dex		[alpha/Fe] from YoungSun's Kurucz grid 2
alphafen	int	4			0 =no value, 1 = ok
alphafeerr	real	4	dex		error on [alpha/Fe]
elodierv	real	4	km/s		ELODIE template match RV (offset)
elodierverr	real	4	km/s		ELODIE RV error
g0	real	4	mag		Dereddened psf magnitude in the g band (before ubercal corr)
gmr0	real	4	mag		Dereddened target psf color (g-r)_0 (before ubercal corr)
grhbaa	real	4	mag		Adopted predicted (g-r)_0 from Balmer lines
grbha	real	4	mag		predicted (g-r)_0 from H alpha
grbhd	real	4	mag		predicted (g-r)_0 from H delta
grhp	real	4	mag		predicted (g-r)_0 from half power point
umg0	real	4	mag		Dereddened target psf color (u-g)_0 (before ubercal corr)
rmi0	real	4	mag		Dereddened target psf color (r-i)_0 (before ubercal corr)
imz0	real	4	mag		Dereddened target psf color (i-z)_0 (before ubercal corr)
uerr	real	4	mag		Error in psf magnitude u band
gerr	real	4	mag		Error in psf magnitude g band
rerr	real	4	mag		Error in psf magnitude r band
ierr	real	4	mag		Error in psf magnitude i band
zerr	real	4	mag		Error in psf magnitude z band
ebv	real	4	mag		E(B-V) at this (l,b) from SFD98
sna	real	4			Avg S/N per pixel over 3950-6000 A
qualitycheck	int	4			Quality check (=0)
ra	float	8	degrees		RA (J2000)
dec	float	8	degrees		DEC (J2000)
l	float	8	degrees		Galactic Longitude
b	float	8	degrees		Galactic Latitude
chiHK	real	4			chi-square/dof region of Ca H+K
chiGband	real	4			chi-square/dof region of the G band
targ_pmepoch	float	8	years		PM epoch (targ version, use propermotions table join)
targ_pmmatch	real	4			Proper motion match to USNO-B catalog 1=match
targ_pmdelta	real	4	arcsec		distance the star has moved
targ_pml	real	4	mas/yr		propermotion in the Gal. l
targ_pmb	real	4	mas/yr		proper motion in the Gal. b
targ_pmra	real	4	mas/yr		proper motion in ra
targ_pmdec	real	4	mas/yr		proper motion in dec
targ_pmraerr	real	4	mas/yr		error in pmra
targ_pmdecerr	real	4	mas/yr		error in pmdec
targ_pmsigra	real	4			sigma in ra ppm
targ_pmsigdec	real	4			sigma in dec ppm
targ_pmnfit	int	4			number of fits to the ppm
targ_usnomag_u	real	4			USNO-B mag of the star in derived u band
targ_usnomag_g	real	4			USNO-B mag of the star in derived g band
targ_usnomag_r	real	4			USNO-B mag of the star in derived r band
targ_usnomag_i	real	4			USNO-B mag of the star in derived i band
targ_usnomag_z	real	4			USNO-B mag of the star in derived z band
targ_pmdist20	real	4	arcs		dist to nearest star g less than 20
targ_pmdist22	real	4	arcs		dist to nearest star g less than 22
targ_raErr	real	4	mas		error in ra
targ_decErr	real	4	mas		error in dec
targ_raDecErr	real	4			ra dec cross correlation term
brun	int	4			SDSS Run number (best version of sky)
brerun	int	4			SDSS Rerun number (best version of sky)
bcamcol	int	4			SDSS Camcol number (best version of sky)
bfield	int	4			SDSS Field number (best version of sky)
bobj	int	4			SDSS object number (best version of sky)
lpar	real	4	mag		Newberg-Lenz "l" color, perp. locus
spar	real	4	mag		Ivezic (modified) s color, prn. cmp.
wpar	real	4	mag		Ivezic (modified) w color, prn. cmp.
p1spar	real	4	mag		Ivezic color, perp to s color
bsz	real	4			SpecBS pipeline redshift
bszerr	real	4			SpecBS pipeline redshift error
targettype	varchar	64			SEGUE or Legacy Target type string, see primtarget in specobjall table
zbclass	varchar	64			SpecBS class (STAR, GALAXY, QSO)
zbsubclass	varchar	64			SpecBS subclass (type of star)
zbelodiesptype	varchar	64			SpecBS ELODIE spectral type (type of best match template star)
zbrchi2	real	4			SpecBS rchi2 reduced chi-square per dof
zbdof	real	4			SpecBS degrees of freedom measure for best fit template
zbvdisp	real	4	km/s		SpecBS Velocity dispersion (for galaxies)
zbvdisperr	real	4	km/s		SpecBS error in Velocity disp
zbzwarning	real	4			SpecBS warning flag
spec_cln	int	4			Spectro1d(Chicago) class 1= star, 2 = Galaxy, 3,4 = QSO, 6= redstar
spz	real	4			Spectro1d(Chicago) redshift (Legacy primary objects hand inspected)
spzerr	real	4			Spectro1d(Chicago) redhisft error
vel_dis	real	4	km/s		Spectro1d(Chicago) Velocity dispersion (for galaxies)
vel_disperr	real	4	km/s		Spectro1d(Chicago) Vel disp error
spz_conf	real	4			Spectro1d(Chicago) redshift confidence
spz_status	int	4			Spectro1d(Chicago) redshift status
spz_warning	int	4			Spectro1d(Chicago) redshift warning
eclass	real	4			Spectro1d(Chicago) galaxy Principal component class
ecoeff1	real	4			Galaxy Prin. comp. 1 (for galaxies)
ecoeff2	real	4			Galaxy Prin. comp. 2 (for galaxies)
ecoeff3	real	4			Galaxy Prin. comp. 3 (for galaxies)
ecoeff4	real	4			Galaxy Prin. comp. 4 (for galaxies)
ecoeff5	real	4			Galaxy Prin. comp. 5 (for galaxies)
tsver	varchar	64			Version of SEGUE target selection version used (or Legacy)
amnhtype	varchar	64			AMNH Red Star Spectral Type (sdM, esdM, usdM)
amnhsubtype	real	4			AMNH Red Star Spectral Sub-type classification (0-9)
amnhmindex	real	4			AMNH Red Star pixels shifted for best fit parameter
amnhmvalue	real	4			AMNH Red Star least squares chi-sq estimate parameter
inspect	int	4			Identically 0