name | type | length | unit | ucd | description |
specObjID | bigint | 8 | | ID_CATALOG | Unique ID |
mjd | int | 4 | MJD | TIME_DATE | MJD of observation |
plate | smallint | 2 | | ID_PLATE | Plate ID |
tile | smallint | 2 | | ID_PLATE | Tile ID |
xFocal | float | 8 | | POS_CCD_X | X Focal |
yFocal | float | 8 | | POS_CCD_Y | Y Focal |
fiberID | smallint | 2 | | ID_FIBER | Fiber ID |
z | real | 4 | | REDSHIFT | Final Redshift |
zErr | real | 4 | | REDSHIFT ERROR | Redshift error |
zConf | real | 4 | | REDSHIFT STAT_PROBABILITY | Redshift confidence |
zStatus | smallint | 2 | | CODE_QUALITY | Redshift status |
specClass | smallint | 2 | | CLASS_OBJECT | Spectral Classification |
zWarning | int | 4 | | CODE_QUALITY | Warning Flags |
velDisp | real | 4 | ??? | VELOC_DISP | Velocity Dispersion |
velDispErr | real | 4 | | VELOC_DISP ERROR | Velocity Dispersion error |
eCoeff_0 | real | 4 | | FIT_PARAM | Expansion Coeff for Galaxies |
eCoeff_1 | real | 4 | | FIT_PARAM | Expansion Coeff for Galaxies |
eCoeff_2 | real | 4 | | FIT_PARAM | Expansion Coeff for Galaxies |
eCoeff_3 | real | 4 | | FIT_PARAM | Expansion Coeff for Galaxies |
eCoeff_4 | real | 4 | | FIT_PARAM | Expansion Coeff for Galaxies |
eClass | real | 4 | | CLASS_OBJECT | Classification |
nGood | int | 4 | pix | NUMBER | Good Pixels |
sn_0 | real | 4 | | INST_S/N | Median S/N in g' |
sn_1 | real | 4 | | INST_S/N | Median S/N in r' |
sn_2 | real | 4 | | INST_S/N | Median S/N in i' |
mag_0 | real | 4 | mag | PHOT_SDSS_G | Synthetic Magnitude in g' |
mag_1 | real | 4 | mag | PHOT_SDSS_R | Synthetic Magnitude in r' |
mag_2 | real | 4 | mag | PHOT_SDSS_I | Synthetic Magnitude in i' |
ra | float | 8 | deg | POS_EQ_RA_MAIN | ra in J2000 |
dec | float | 8 | deg | POS_EQ_DEC_MAIN | dec in 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 |
htmID | bigint | 8 | | CODE_HTM | 20 deep Hierarchical Triangular Mesh ID |
fiberMag_u | real | 4 | luptitudes | PHOT_SDSS_U | Fiber Magnitudes |
fiberMag_g | real | 4 | luptitudes | PHOT_SDSS_G | Fiber Magnitudes |
fiberMag_r | real | 4 | luptitudes | PHOT_SDSS_R | Fiber Magnitudes |
fiberMag_i | real | 4 | luptitudes | PHOT_SDSS_I | Fiber Magnitudes |
fiberMag_z | real | 4 | luptitudes | PHOT_SDSS_Z | Fiber Magnitudes |
primTarget | int | 4 | | CODE_MISC | Specifies which primary target catagories the object was selected in. |
secTarget | int | 4 | | CODE_MISC | Specifies which secondary target catagories the object was selected in. |
seguePrimTarget | int | 4 | | CODE_MISC | Specifies which SEGUE primary target catagories the object was selected in. |
segueSecTarget | int | 4 | | CODE_MISC | Specifies which SEGUE secondary target catagories the object was selected in. |
otherPrimTarget | int | 4 | | CODE_MISC | Specifies which other program primary target catagories the object was selected in. |
otherSecTarget | int | 4 | | CODE_MISC | Specifies which other program secondary target catagories the object was selected in. |
pixMin | smallint | 2 | pix | INST_DET_LIMIT | Pixmin |
pixMax | smallint | 2 | pix | INST_DET_LIMIT | Pixmax |
sci_sn | real | 4 | | CODE_MISC | Science signal to noise ratio |
smear_sn | real | 4 | | CODE_MISC | Smear signal to noise ratio |
sm_leg_0 | real | 4 | | CODE_MISC | 1st legendre coeff. for smear correct |
sm_leg_1 | real | 4 | | CODE_MISC | 2nd legendre coeff. for smear correct |
sm_leg_2 | real | 4 | | CODE_MISC | 3rd legendre coeff. for smear correct |
sciencePrimary | smallint | 2 | | CODE_MISC | Deemed to be science-worthy (defines default view SpecObj) |
loadVersion | int | 4 | | ID_TRACER | Load Version |
plateID | bigint | 8 | | ID_PLATE | Link to plate on which the spectrum was taken |
spectrographID | smallint | 2 | | INST_ID | which spectrograph (1,2) |
throughput | int | 4 | ??? | NUMBER | fiber throughput as measured by mapper |
objType | int | 4 | | CLASS_OBJECT | object type (plPlugMap style) |
objTypeName | varchar | 32 | | CLASS_OBJECT | Object Type as string |
targetID | bigint | 8 | | ID_CATALOG | ID of Target |
targetObjID | bigint | 8 | | ID_CATALOG | ID of target PhotoObj |
bestObjID | bigint | 8 | | ID_MAIN | ID of best PhotoObj |
img | image | 16 | | SPECT | GIF image of the spectrum |