name | type | length | unit | ucd | description |
tile | smallint | 2 | | ID_PLATE | (unique) tile number |
tileRun | smallint | 2 | | ID_VERSION | run of the tiling software |
raCen | float | 8 | deg | POS_EQ_RA | right ascension of tile center |
decCen | float | 8 | deg | POS_EQ_DEC | declination of the tile center |
htmID | bigint | 8 | | CODE_HTM | htm tree info |
cx | float | 8 | | POS_EQ_CART_X | x projection of vector on unit sphere |
cy | float | 8 | | POS_EQ_CART_Y | y projection of vector on unit sphere |
cz | float | 8 | | POS_EQ_CART_Z | z projection of vector on unit sphere |
untiled | tinyint | 1 | | CODE_MISC | 1: this tile later untiled, 0: otherwise |
nTargets | int | 4 | | NUMBER | number of targets assigned to this tile |
programType | int | 4 | | OBS_TYPE | spectroscopic program type |
programName | varchar | 32 | | OBJ_ID | character string of program (from plate inventory db) |
extinction_u | real | 4 | mag | PHOT_EXTINCTION_GAL | average extinction (u) across the Tile |
extinction_g | real | 4 | mag | PHOT_EXTINCTION_GAL | average extinction (g) across the Tile |
extinction_r | real | 4 | mag | PHOT_EXTINCTION_GAL | average extinction (r) across the Tile |
extinction_i | real | 4 | mag | PHOT_EXTINCTION_GAL | average extinction (i) across the Tile |
extinction_z | real | 4 | mag | PHOT_EXTINCTION_GAL | average extinction (z) across the Tile |
completeTileVersion | varchar | 32 | | ID_VERSION | version of completeTile software |
loadVersion | int | 4 | | ID_VERSION | Load Version |