TABLE  PlateX

Each plate has 640 observed spectra.

name	type	length	unit	ucd	description
plateID	bigint	8		ID_PLATE	Unique ID, composite of plate number and MJD
spRerun	int	4		CODE_MISC	Spectro rerun
mjd	int	4	MJD	TIME_DATE	MJD of observation
plate	smallint	2		ID_PLATE	Plate ID
tile	smallint	2		ID_PLATE	Tile ID
mapMjd	int	4	MJD	TIME_DATE	Map MJD
nExp	smallint	2		NUMBER	Number of exposures
tai	real	4	sec	TIME_DATE	TAI
raBoresight	float	8	deg	POS_EQ_RA	RA of telescope boresight
decBoresight	float	8	deg	POS_EQ_DEC	DEC of telescope boresight
taiHMS	varchar	64		TIME_DATE	HMS
expTime	real	4	sec	TIME_EXPTIME	Total Exposure time
expTimeB1	real	4	sec	TIME_EXPTIME	exposure time in B1 spectrograph
expTimeB2	real	4	sec	TIME_EXPTIME	exposure time in B2 spectrograph
expTimeR1	real	4	sec	TIME_EXPTIME	exposure time in R1 spectrograph
expTimeR2	real	4	sec	TIME_EXPTIME	exposure time in R2 spectrograph
helioRV	real	4	km/s	VELOC_CORR VELOC_HC	Heliocentric velocity correction
ra	real	4	deg	POS_EQ_RA	ra
dec	real	4	deg	POS_EQ_DEC	dec
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
sn1_0	real	4		INST_S/N	(S/N)^2 1st Spectrograph, g band
sn1_1	real	4		INST_S/N	(S/N)^2 1st Spectrograph, r band
sn1_2	real	4		INST_S/N	(S/N)^2 1st Spectrograph, i band
sn2_0	real	4		INST_S/N	(S/N)^2 2nd Spectrograph, g band
sn2_1	real	4		INST_S/N	(S/N)^2 2nd Spectrograph, r band
sn2_2	real	4		INST_S/N	(S/N)^2 2nd Spectrograph, i band
dateObs	varchar	12		TIME_DATE	Date of 1st row
timeSys	varchar	8		TIME	Time System
quality	varchar	12		CODE_QUALITY	Quality of night/image
name	varchar	32		ID_CATALOG	Name of target; PlateId-MJD-Mapper ReRun
program	varchar	16		ID_VOLUME	ID of CCD Program
version	varchar	64		ID_VERSION	IOP Version
observer	varchar	64		ID_HUMAN	Observer name
camVer	varchar	64		ID_VERSION	Camera code version
spec2DVer	varchar	64		ID_VERSION	IDL Spec2D version
utilsVer	varchar	64		ID_VERSION	IDL Utils version
spec1DVer	varchar	64		ID_VERSION	Spec1D version
readVer	varchar	64		ID_VERSION	???
combVer	varchar	64		ID_VERSION	???
extinction_u	real	4	mag	PHOT_EXTINCTION	average extinction (u) across the Tile
extinction_g	real	4	luptitudes	PHOT_EXTINCTION	average extinction (g) across the Tile
extinction_r	real	4	luptitudes	PHOT_EXTINCTION	average extinction (r) across the Tile
extinction_i	real	4	luptitudes	PHOT_EXTINCTION	average extinction (i) across the Tile
extinction_z	real	4	luptitudes	PHOT_EXTINCTION	average extinction (z) across the Tile
rOffset1	real	4		CODE_MISC	Mean r-band mag difference (spectro - photo)
rSigma1	real	4		CODE_MISC	Stddev of r-band mag difference (spectro - photo)
grOff1	real	4		CODE_MISC	Mean (g-r) color difference (spectro - photo)
grSigma1	real	4		CODE_MISC	Stddev of (g-r) color difference (spectro - photo)
rOffset2	real	4		CODE_MISC	Mean r-band mag difference (spectro - photo)
rSigma2	real	4		CODE_MISC	Stddev of r-band mag difference (spectro - photo)
grOff2	real	4		CODE_MISC	Mean (g-r) color difference (spectro - photo)
grSigma2	real	4		CODE_MISC	Stddev of (g-r) color difference (spectro - photo)
sfd_used	tinyint	1		CODE_MISC	SFD dust maps used?
xygrSig1	real	4		CODE_MISC	Sigma of (g-r) offsets as a fcn of plate x/y
xygrSig2	real	4		CODE_MISC	Sigma of (g-r) offsets as a fcn of plate x/y
mpgrSig1	real	4		CODE_MISC	Sigma of (g-r)_model - (g-r)_photo Spec 1
mpgrSig2	real	4		CODE_MISC	Sigma of (g-r)_model - (g-r)_photo Spec 2
mpgrOff1	real	4		CODE_MISC	Mean of (g-r)_model - (g-r)_photo of Spec 1
mpgrOff2	real	4		CODE_MISC	Mean of (g-r)_model - (g-r)_photo of Spec 2
isPrimary	tinyint	1		CODE_MISC	is this PlateX a primary observation of the plate
cartridgeID	smallint	2		INST_ID	ID of cartridge used for the observation
plateVersion	varchar	32		ID_VERSION	version of plate software
haMin	real	4	deg	POS_EQ_RA	min hour angle design
haMax	real	4	deg	POS_EQ_DEC	max hour angle design
mjdDesign	int	4		MJD	MJD designed for
theta	real	4		POS_POS-ANG	cartridge position angle
fscanVersion	varchar	32		ID_VERSION	version of fiber scanning software
fmapVersion	varchar	32		ID_VERSION	version of fiber mapping software
fscanMode	varchar	32		CODE_MISC	'slow', 'fast', or 'extreme'
fscanSpeed	int	4		NUMBER	speed of scan
programType	int	4		OBS__TYPE	spectroscopic program type
programName	varchar	32		OBS_ID	character string of program (from plate inventory db)
loadVersion	int	4		ID_VERSION	Load Version
expID	varbinary	1000		ID_VERSION	Exposure ID array