VIEW  Tile

DERIVED FROM  TileAll

The view excludes those Tiles that have been untiled.

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