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 |