VIEW  Tile

DERIVED FROM  TileAll

A view of TileAll that have untiled=0

The view excludes those Tiles that have been untiled.

nametypelengthunitucddescription
tilesmallint2 ID_PLATE(unique) tile number
tileRunsmallint2 ID_VERSIONrun of the tiling software
raCenfloat8degPOS_EQ_RAright ascension of tile center
decCenfloat8degPOS_EQ_DECdeclination of the tile center
htmIDbigint8 CODE_HTMhtm tree info
cxfloat8 POS_EQ_CART_Xx projection of vector on unit sphere
cyfloat8 POS_EQ_CART_Yy projection of vector on unit sphere
czfloat8 POS_EQ_CART_Zz projection of vector on unit sphere
untiledtinyint1 CODE_MISC1: this tile later untiled, 0: otherwise
nTargetsint4 NUMBERnumber of targets assigned to this tile
programTypeLink to ProgramTypeint4 OBS_TYPEspectroscopic program type
programNamevarchar32 OBJ_IDcharacter string of program (from plate inventory db)
extinction_ureal4magPHOT_EXTINCTION_GALaverage extinction (u) across the Tile
extinction_greal4magPHOT_EXTINCTION_GALaverage extinction (g) across the Tile
extinction_rreal4magPHOT_EXTINCTION_GALaverage extinction (r) across the Tile
extinction_ireal4magPHOT_EXTINCTION_GALaverage extinction (i) across the Tile
extinction_zreal4magPHOT_EXTINCTION_GALaverage extinction (z) across the Tile
completeTileVersionvarchar32 ID_VERSIONversion of completeTile software
loadVersionint4 ID_VERSIONLoad Version