name | type | length | unit | ucd | description |
specObjID | bigint | 8 | | | id number, match in specObjAll |
bestObjID | bigint | 8 | | ID_MAIN | Object ID of best PhotoObj match (flux-based) |
origObjID | bigint | 8 | | ID_MAIN | Object ID of best PhotoObj match (position-based) |
targetObjID | bigint | 8 | | | Object ID of original target |
plateID | bigint | 8 | | | Database ID of Plate (match in plateX) |
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 (defines default view SpecObj) |
firstRelease | varchar | 32 | | | Name of first release this object was associated with |
SURVEY | varchar | 32 | | | Survey name |
PROGRAMNAME | varchar | 32 | | | Program name |
CHUNK | varchar | 32 | | | Chunk name |
PLATERUN | varchar | 32 | | | Plate drill run name |
MJD | bigint | 8 | | | Modified Julian Date of observation |
PLATE | bigint | 8 | | | Plate number |
FIBERID | bigint | 8 | | | Fiber number (1-640) |
RUN2D | varchar | 32 | | | Name of 2D rerun |
RUN1D | varchar | 32 | | | Name of 1D rerun |
RUNSSPP | varchar | 32 | | | Name of SSPP rerun |
TARGETSTRING | varchar | 32 | | | ASCII translation of target selection information as determined at the time the plate was designed |
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) |
LEGACY_TARGET1 | bigint | 8 | | | Legacy target selection information at plate design, primary science selection |
LEGACY_TARGET2 | bigint | 8 | | | Legacy target selection information at plate design, secondary/qa/calib selection |
SPECIAL_TARGET1 | bigint | 8 | | | Special program target selection information at plate design, primary science selection |
SPECIAL_TARGET2 | bigint | 8 | | | Special program target selection information at plate design, secondary/qa/calib selection |
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 |
SPECTYPEHAMMER | varchar | 32 | | | Spectral Type from HAMMER |
SPECTYPEELODIE | varchar | 32 | | | Spectral Type from ELODIE templates |
FLAG | varchar | 32 | | | Flag with combination of four letters among BCdDEgGhHlnNSV, n=normal |
TEFFADOP | real | 4 | Kelvin | | Adopted Teff, bi-weigth average of estimators with indicator variable of 1 |
TEFFADOPN | tinyint | 1 | Kelvin | | Number of estimators used in bi-weight average |
TEFFADOPUNC | real | 4 | Kelvin | | Error in the adopted temperature |
TEFFHA24 | real | 4 | Kelvin | | Teff estimate from HA24 |
TEFFHD24 | real | 4 | Kelvin | | Teff estimate from HD24 |
TEFFTK | real | 4 | Kelvin | | Teff estimate from TKurucz |
TEFFTG | real | 4 | Kelvin | | Teff estimate from TGirardi |
TEFFTI | real | 4 | Kelvin | | Teff estimate from TIveciz |
TEFFNGS1 | real | 4 | Kelvin | | Teff estimate from NGS1 |
TEFFANNSR | real | 4 | Kelvin | | Teff estimate from ANNSR |
TEFFANNRR | real | 4 | Kelvin | | Teff estimate from ANNRR |
TEFFWBG | real | 4 | Kelvin | | Teff estimate from WBG |
TEFFK24 | real | 4 | Kelvin | | Teff estimate from k24 |
TEFFKI13 | real | 4 | Kelvin | | Teff estimate from ki13 |
TEFFHA24IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFHD24IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFTKIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFTGIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFTIIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFNGS1IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFANNSRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFANNRRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFWBGIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFK24IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFKI13IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
TEFFHA24UNC | real | 4 | Kelvin | | Error in Teff estimate from HA24 |
TEFFHD24UNC | real | 4 | Kelvin | | Error in Teff estimate from HD24 |
TEFFTKUNC | real | 4 | Kelvin | | Error in Teff estimate from TKurucz |
TEFFTGUNC | real | 4 | Kelvin | | Error in Teff estimate from TGirardi |
TEFFTIUNC | real | 4 | Kelvin | | Error in Teff estimate from TIveciz |
TEFFNGS1UNC | real | 4 | Kelvin | | Error in Teff estimate from NGS1 |
TEFFANNSRUNC | real | 4 | Kelvin | | Error in Teff estimate from ANNSR |
TEFFANNRRUNC | real | 4 | Kelvin | | Error in Teff estimate from ANNRR |
TEFFWBGUNC | real | 4 | Kelvin | | Error in Teff estimate from WBG |
TEFFK24UNC | real | 4 | Kelvin | | Error in Teff estimate from k24 |
TEFFKI13UNC | real | 4 | Kelvin | | Error in Teff estimate from ki13 |
LOGGADOP | real | 4 | dex | | Adopted log g, bi-weigth average of estimators with indicator variable of 2 |
LOGGADOPN | tinyint | 1 | | | Number of log g estimators in used bi-weight average |
LOGGADOPUNC | real | 4 | dex | | Error in the adopted log g |
LOGGNGS2 | real | 4 | dex | | log g estimate from NGS2 |
LOGGNGS1 | real | 4 | dex | | log g estimate from NGS1 |
LOGGANNSR | real | 4 | dex | | log g estimate from ANNSR |
LOGGANNRR | real | 4 | dex | | log g estimate from ANNRR |
LOGGCAI1 | real | 4 | dex | | log g estimate from CaI1 |
LOGGCAI2 | real | 4 | dex | | log g estimate from CaI2 |
LOGGMGH | real | 4 | dex | | log g estimate from MgH |
LOGGWBG | real | 4 | dex | | log g estimate from WBG |
LOGGK24 | real | 4 | dex | | log g estimate from k24 |
LOGGKI13 | real | 4 | dex | | log g estimate from ki13 |
LOGGNGS2IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGNGS1IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGANNSRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGANNRRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGCAI1IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGCAI2IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGMGHIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGWBGIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGK24IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGKI13IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 good |
LOGGNGS2UNC | real | 4 | dex | | Error in log g estimate from NGS2 |
LOGGNGS1UNC | real | 4 | dex | | Error in log g estimate from NGS1 |
LOGGANNSRUNC | real | 4 | dex | | Error in log g estimate from ANNSR |
LOGGANNRRUNC | real | 4 | dex | | Error in log g estimate from ANNRR |
LOGGCAI1UNC | real | 4 | dex | | Error in log g estimate from CaI1 |
LOGGCAI2UNC | real | 4 | dex | | Error in log g estimate from CaI2 |
LOGGMGHUNC | real | 4 | dex | | Error in log g estimate from MgH |
LOGGWBGUNC | real | 4 | dex | | Error in log g estimate from WBG |
LOGGK24UNC | real | 4 | dex | | Error in log g estimate from k24 |
LOGGKI13UNC | real | 4 | dex | | Error in log g estimate from ki13 |
FEHADOP | real | 4 | dex | | Adopted [Fe/H], bi-weigth average of estimators with indicator variable of 2 |
FEHADOPN | tinyint | 1 | | | Number of estimators used in bi-weight average |
FEHADOPUNC | real | 4 | dex | | Error in the adopted [Fe/H] |
FEHNGS2 | real | 4 | dex | | [Fe/H] estimate from NGS2 |
FEHNGS1 | real | 4 | dex | | [Fe/H] estimate from NGS1 |
FEHANNSR | real | 4 | dex | | [Fe/H] estimate from ANNSR |
FEHANNRR | real | 4 | dex | | [Fe/H] estimate from ANNRR |
FEHCAIIK1 | real | 4 | dex | | [Fe/H] estimate from CaIIK1 |
FEHCAIIK2 | real | 4 | dex | | [Fe/H] estimate from CaIIK2 |
FEHCAIIK3 | real | 4 | dex | | [Fe/H] estimate from CaIIK3 |
FEHACF | real | 4 | dex | | [Fe/H] estimate from ACF |
FEHCAIIT | real | 4 | dex | | [Fe/H] estimate from CaIIT |
FEHWBG | real | 4 | dex | | [Fe/H] estimate from WBG |
FEHK24 | real | 4 | dex | | [Fe/H] estimate from k24 |
FEHKI13 | real | 4 | dex | | [Fe/H] estimate from ki13 |
FEHNGS2IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHNGS1IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHANNSRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHANNRRIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHCAIIK1IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHCAIIK2IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHCAIIK3IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHACFIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHCAIITIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHWBGIND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHK24IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHKI13IND | tinyint | 1 | | | Indicator variable, = 0 bad, = 1 low S/N or out of g-r color range, = 2 good |
FEHNGS2UNC | real | 4 | dex | | Error in [Fe/H] estimate from NGS2 |
FEHNGS1UNC | real | 4 | dex | | Error in [Fe/H] estimate from NGS1 |
FEHANNSRUNC | real | 4 | dex | | Error in [Fe/H] estimate from ANNSR |
FEHANNRRUNC | real | 4 | dex | | Error in [Fe/H] estimate from ANNRR |
FEHCAIIK1UNC | real | 4 | dex | | Error in [Fe/H] estiimate from CaIIK1 |
FEHCAIIK2UNC | real | 4 | dex | | Error in [Fe/H] estimate from CaIIK2 |
FEHCAIIK3UNC | real | 4 | dex | | Error in [Fe/H] estimate from CaIIK3 |
FEHACFUNC | real | 4 | dex | | Error in [Fe/H] estimate from ACF |
FEHCAIITUNC | real | 4 | dex | | Error in [Fe/H] estimate from CaIIT |
FEHWBGUNC | real | 4 | dex | | Error in [Fe/H] estimate from WBG |
FEHK24UNC | real | 4 | dex | | Error in [Fe/H] estimate from k24 |
FEHKI13UNC | real | 4 | dex | | Error in [Fe/H] estimate from ki13 |
SNR | real | 4 | | | Average S/N per pixel over 4000 - 8000 A |
QA | tinyint | 1 | | | Quality check on spectrum, depending on S/N |
CCCAHK | real | 4 | | | Correlation coefficient over 3850-4250 A |
CCMGH | real | 4 | | | Correlation coefficient over 4500-5500 A |
TEFFSPEC | real | 4 | Kelvin | | Spectroscopically determined Teff, color independent |
TEFFSPECN | tinyint | 1 | | | Number of estimators used in average |
TEFFSPECUNC | real | 4 | Kelvin | | Error in the spectroscopically determined Teff |
LOGGSPEC | real | 4 | dex | | Spectroscopically determined log g, color independent |
LOGGSPECN | tinyint | 1 | | | Number of estimators used in average |
LOGGSPECUNC | real | 4 | dex | | Error in the spectroscopically determined log g |
FEHSPEC | real | 4 | dex | | Spectroscopically determined [Fe/H], color independent |
FEHSPECN | tinyint | 1 | | | Number of estimators used in average |
FEHSPECUNC | real | 4 | dex | | Error in the spectroscopically determined [Fe/H] |
TEFFCOL | real | 4 | Kelvin | | Teff from g-z color-Teff relation |
TEFFCOLUNC | real | 4 | Kelvin | | Error in Teff from g-z color-Teff relation |
FEHTFIXNGS2 | real | 4 | dex | | [Fe/H] estimate from NGS2 with fixed Teff from g-z color-Teff relation |
FEHTFIXNGS1 | real | 4 | dex | | [Fe/H] estimate from NGS1 with fixed Teff from g-z color-Teff relation |
LOGGTFIXNGS2 | real | 4 | dex | | log g estimate from NGS2 with fixed Teff from g-z color-Teff relation |
LOGGTFIXNGS1 | real | 4 | dex | | log g estimate from NGS1 with fixed Teff from g-z color-Teff relation |
FEHTFIXNGS2UNC | real | 4 | dex | | Error in [Fe/H] from NGS2 with fixed Teff from g-z color-Teff relation |
FEHTFIXNGS1UNC | real | 4 | dex | | Error in [Fe/H] from NGS1 with fixed Teff from g-z color-Teff relation |
LOGGTFIXNGS2UNC | real | 4 | dex | | Error in log g from NGS2 with fixed Teff from g-z color-Teff relation |
LOGGTFIXNGS1UNC | real | 4 | dex | | Error in log g from NGS1 with fixed Teff from g-z color-Teff relation |
FEHTFIXCAIIK1 | real | 4 | dex | | [Fe/H] from CaIIK1 with fixed Teff from g-z color-Teff relation |
FEHTFIXCAIIK1UNC | real | 4 | dex | | Error in [Fe/H] from CaIIK1 with fixed Teff from g-z color-Teff relation |
ACF1 | real | 4 | | | Auto-Correlation Function over 4000-4086/4116-4325/4355-4500 |
ACF1SNR | real | 4 | | | Average signal-to-noise ratio in Auto-Correlation Function 1 (ACF1) |
ACF2 | real | 4 | | | Auto-Correlation Functioin over 4000-4086/4116-4280/4280-4500 |
ACF2SNR | real | 4 | | | Average signal-to-noise ratio in Auto-Correlation Function 2 (ACF2) |
INSPECT | varchar | 32 | | | Flag with combination of six letters among FTtMmCn, for inspecting spectra |
ELODIERVFINAL | real | 4 | km/s | | Velocity as measured by Elodie library templates, converted to km/s and with the empirical 7.3 km/s offset applied (see Yanny et al. 2009, AJ, 137, 4377) |
ELODIERVFINALERR | real | 4 | km/s | | Uncertainty in the measured Elodie RV, as determined from the chisq template-fitting routine. See the discussion of empirically-determined velocity errors in Yanny et al. 2009, AJ, 137, 4377 |
ZWARNING | bigint | 8 | | | Warning flags about velocity/redshift determinations |