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
fehspectype	varchar	32			SEGUE or SDSS target type abbrev.
hammersptype	varchar	32			Stellar Type Classification -- UW
sptypea	varchar	32			Stellar Type Classification -- SSPP
flag	varchar	32			SSPP flags dDEhHlnNSV, x -- not a star
feha	real	4	dex		adopted [Fe/H] value
fehan	int	4			number of estimators combined into feha
fehaerr	real	4			error/sigma on the [Fe/H] value, or -9.999
fehw	real	4			bi-weight [Fe/H] from all avail. estimators
fehwn	int	4			number of estimators for fehw
fehwerr	real	4			error/sigma on the [Fe/H] value
fehr	real	4			refined [Fe/H] from est. of [Fe/H] --U/ dex
fehrn	int	4			number of estimators for calculating fehr
fehrerr	real	4			error/sigma on the [Fe/H] value
feh1	real	4			YoungSun's Kurucz grid 2 (NGS2 grid)
feh1n	int	4			indicator variable, =1 ok, =0 not used
feh1err	real	4			error/sigma on the [Fe/H] value
feh2	real	4			YoungSun's Kurucz grid 1 (NGS1 grid)
feh2n	int	4			indicator variable, =1 ok, =0 not used
feh2err	real	4			error/sigma on the [Fe/H] value
feh3	real	4			[Fe/H] from neural network method
feh3n	int	4			indicator variable, =1 ok, =0 not used
feh3err	real	4			error/sigma on the [Fe/H] value
feh4	real	4			[Fe/H] from Ca II K method
feh4n	int	4			indicator variable, =1 ok, =0 not used
feh4err	real	4			error/sigma on the [Fe/H] value
feh5	real	4			[Fe/H] from auto-correlation method.
feh5n	int	4			indicator variable, =1 ok, =0 not used
feh5err	real	4			error/sigma on the [Fe/H] value
feh6	real	4			[Fe/H] from Ca II triplet method
feh6n	int	4			indicator variable, =1 ok, =0 not used
feh6err	real	4			error/sigma on the [Fe/H] value
feh7	real	4			[Fe/H] from Wilhelm, Beers, and Gray (1999)
feh7n	int	4			indicator variable, =1 ok, =0 not used
feh7err	real	4			error/sigma on the [Fe/H] value
feh8	real	4			[Fe/H] from Carlos k24 grid
feh8n	int	4			indicator variable, =1 ok, =0 not used
feh8err	real	4			error/sigma on the [Fe/H] value
feh9	real	4			[Fe/H] from Carlos ki13 grid
feh9n	int	4			indicator variable, =1 ok, =0 not used
feh9err	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
teff1n	int	4			indicator variable, =1 ok, =0 not used
teff1err	real	4			erorr/sigma on the Teff
teff2	real	4			Teff from H delta line
teff2n	int	4			indicator variable, =1 ok, =0 not used
teff2err	real	4			error/sigma on the Teff
teff3	real	4			Teff from Kurucz models, based on colors
teff3n	int	4			indicator variable, =1 ok, =0 not used
teff3err	real	4			error/sigma on the Teff
teff4	real	4			Teff from Girardi isochrones (2004)
teff4n	int	4			indicator variable, =1 ok, =0 not used
teff4err	real	4			error/sigma on the Teff
teff5	real	4			Teff from Ivezic et al. (2007) (colors)
teff5n	int	4			indicator variable, =1 ok, =0 not used
teff5err	real	4			error/sigma on the Teff
teff6	real	4			Teff from YoungSun's Kurucz grid 1
teff6n	int	4			indicator variable, =1 ok, =0 not used
teff6err	real	4			error/sigma on the Teff
teff7	real	4			Teff from neural network method
teff7n	int	4			indicator variable, =1 ok, =0 not used
teff7err	real	4			error/sigma on the Teff
teff8	real	4			Teff from Wilhelm, Beers, and Gray (1999)
teff8n	int	4			indicator variable, =1 ok, =0 not used
teff8err	real	4			error/sigma on the Teff
teff9	real	4			Teff from Carlos k24 grid
teff9n	int	4			indicator variable, =1 ok, =0 not used
teff9err	real	4			error/sigma on the Teff
teff10	real	4			Teff from Carlos ki13 grid
teff10n	int	4			indicator variable, =1 ok, =0 not used
teff10err	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 YoungSun's Kurucz grid 2 (NGS2)
logg1n	int	4			indicator variable, =1 ok, =0 not used
logg1err	real	4			error/sigma on log g
logg2	real	4			log g from YoungSun's Kurucz grid 1 (NGS1)
logg2n	int	4			indicator variable, =1 ok, =0 not used
logg2err	real	4			error/sigma on log g
logg3	real	4			log g from neural netork method
logg3n	int	4			indicator variable, =1 ok, =0 not used
logg3err	real	4			error/sigma on log g
logg4	real	4			log g from from Ca I (4227 A) line index
logg4n	int	4			indicator variable, =1 ok, =0 not used
logg4err	real	4			error/sigma on log g
logg5	real	4			log g from MgH features (around 5170 A)
logg5n	int	4			indicator variable, =1 ok, =0 not used
logg5err	real	4			error/sigma on log g
logg6	real	4			log g from Wilhelm, Beers, and Gray (1999)
logg6n	int	4			indicator variable, =1 ok, =0 not used
logg6err	real	4			error/sigma on log g
logg7	real	4			log g from Carlos k24 grid
logg7n	int	4			indicator variable, =1 ok, =0 not used
logg7err	real	4			error/sigma on log g
logg8	real	4			log g from Carlos ki13 grid
logg8n	int	4			indicator variable, =1 ok, =0 not used
logg8err	real	4			error/sigma on log g
alphafe	real	4			[alpha/Fe] from YoungSun's Kurucz grid 2
alphafen	int	4			indicator variable, =1 ok, =0 not used
alphafeerr	real	4			error/sigam in [alpha/Fe]
distV	real	4	kpc		distance to star if star is dwarf
distTO	real	4			distance to star if star is turnoff star
distIII	real	4			distance to star if star is giant
distAGB	real	4			distance to star if star is on AGB
distHB	real	4			distance to star if star is on HB
distCAP	real	4			distance to star from Carlos model fits
unused1	real	4			unused
distZ	real	4			dist. to star in Z above Galactic plane
KPindex	real	4	Angstroms		Ca II K line index
GPindex	real	4			G band line index
unused2	real	4			unused
RVflag	varchar	32			RV flag, if ok, it says OK
rva	real	4	km/s		Adopted RV (usu. Elodie +7.3m km/s)
rvaerr	real	4			error in RV
calcrv	real	4			sspp calc. RV c=3.0e5 km/s used throughout
calcrverr	real	4			error in calcrv
bsrv	real	4	km/s		SpecBS RV
bsrverr	real	4			SpecBS RV error
elodierv	real	4	km/s		ELODIE template match RV (offset)
elodierverr	real	4			ELODIE RV error
unused3	real	4			unused
unused4	real	4			unused
velgal	real	4	km/s		v_GalStdRest v_sun= (10.1,224,6.7)
g0	real	4			Dereddened target psf magnitude in the g band
V0	real	4	mag		Derived V magnitude dereddened
gmr0	real	4			Dereddened target psf color (g-r)_0
grhbaa	real	4			Adopted predicted (g-r)_0 from Balmer lines
grbha	real	4			predicted (g-r)_0 from H alpha
grbhd	real	4			predicted (g-r)_0 from H delta
grhp	real	4			predicted (g-r)_0 from half power point
BmV0	real	4			(B-V)_0 derived from 0.916(g-r)+0.187
BmVBalmer0	real	4			(B-V)_0 derived from H balmer lines
umg0	real	4	mag		Dereddened target psf color (u-g)_0
rmi0	real	4			Dereddened target psf color (r-i)_0
imz0	real	4			Dereddened target psf color (i-z)_0
uerr	real	4			Error in psf magnitude u band
gerr	real	4	mag		error in g
rerr	real	4			error in r
ierr	real	4			error in i
zerr	real	4			error in z
ebv	real	4			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
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
chiMg	real	4			chi-square/dof region of Mg triplet
pmepoch	float	8	years		Proper motion epoch
pmmatch	real	4			Proper motion match to USNO-B catalog 1=match
pmdelta	real	4	arcsec		distance the star has moved
pml	real	4	mas/yr		propermotion in the Gal. l
pmb	real	4	mas/yr		proper motion in the Gal. b
pmra	real	4	mas/yr		proper motion in ra
pmdec	real	4	mas/yr		proper motion in dec
pmraerr	real	4	mas/yr		error in pmra
pmdecerr	real	4	mas/yr		error in pmdec
pmsigra	real	4			sigma in ra ppm
pmsigdec	real	4			sigma in dec ppm
pmnfit	int	4			number of fits to the ppm
usnomag_u	real	4			USNO-B mag of the star in derived u band
usnomag_g	real	4			USNO-B mag of the star in derived g band
usnomag_r	real	4			USNO-B mag of the star in derived r band
usnomag_i	real	4			USNO-B mag of the star in derived i band
usnomag_z	real	4			USNO-B mag of the star in derived z band
pmdist20	real	4	arcs		dist to nearest star g less than 20
pmdist22	real	4	arcs		dist to nearest star g less than 22
brun	int	4			SDSS Run number (target version of sky)
brerun	int	4			SDSS Rerun number (target version of sky)
bcamcol	int	4			SDSS Camcol number (target version of sky)
bfield	int	4			SDSS Field number (target version of sky)
bobj	int	4			SDSS object number (target version of sky)
zbsubclass	varchar	32			specBS subclass
zbelodiesptype	varchar	32			specBS ELODIE best match template
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
zbclass	varchar	32			SpecBS class
zbrchi2	real	4			SpecBS rchi2 reduced chi-square per dof
zbdof	real	4			SpecBS dof measure for best fit template
zbvdisp	real	4			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, 6= redstar
sprv	real	4	km/s		Spectro1d(Chicago) rv
sprverr	real	4			Spectro1d(Chicago) RV err
vel_dis	real	4			Spectro1d(Chicago) Vel disp (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 Prin. comp. 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)
inspect	int	4			Inspection flag (0 = not inspected yet)