TABLE  PlateX

Each plate has 640 observed spectra. WE NEED TO SPECIFY WHERE INFORMATION COMES FROM

name	type	length	unit	ucd	description
plateID	bigint	8		ID_PLATE	Unique ID, composite of plate number and MJD
firstRelease	varchar	32			Name of release that this plate/mjd/rerun was first distributed in
run2d	varchar	32			2d Reduction rerun of plate
run1d	varchar	32			1d Reduction rerun of plate
runsspp	varchar	32			SSPP Reduction rerun of plate ("none" if not run)
plate	smallint	2			plate number
tile	smallint	2			Tile number for SDSS-I, -II plates (-1 for SDSS-III) [from platelist product]
designID	int	4			Design number number for SDSS-III plates (-1 for SDSS-I, -II) [from platelist product]
locationID	int	4			Location number number for SDSS-III plates (-1 for SDSS-I, -II) [from platelist product]
mjd	int	4	days		MJD of observation (last)
mjdList	varchar	512			List of contributing MJDs [from spPlate header]
ra	float	8	deg		RA, J2000 [from spPlate header]
dec	float	8	deg		Dec, J2000 [from spPlate header]
iopVersion	varchar	64			IOP Version [from spPlate header]
camVersion	varchar	64			Camera code version [from spPlate header]
taiHMS	varchar	64			Time in string format [from spPlate header]
dateObs	varchar	12			Date of 1st row [from spPlate header]
timeSys	varchar	8			Time System [from spPlate header]
cx	float	8			x of Normal unit vector in J2000
cy	float	8			y of Normal unit vector in J2000
cz	float	8			z of Normal unit vector in J2000
cartridgeID	smallint	2			ID of cartridge used for the observation [from spPlate header]
tai	float	8	sec		Mean time (TAI) [from spPlate header]
taiBegin	float	8	sec		Beginning time (TAI) [from spPlate header]
taiEnd	float	8	sec		Ending time (TAI) [from spPlate header]
airmass	real	4			Airmass at central TAI time [from spPlate header]
mapMjd	int	4	days		Map MJD [from spPlate header]
mapName	varchar	32			ID of mapping file [from spPlate header]
plugFile	varchar	32			Full name of mapping file [from spPlate header]
expTime	real	4	sec		Total Exposure time [from spPlate header]
expTimeB1	real	4	sec		exposure time in B1 spectrograph [from spPlate header]
expTimeB2	real	4	sec		exposure time in B2 spectrograph [from spPlate header]
expTimeR1	real	4	sec		exposure time in R1 spectrograph [from spPlate header]
expTimeR2	real	4	sec		exposure time in R2 spectrograph [from spPlate header]
vers2d	varchar	32			idlspec2d version used during 2d reduction [from spPlate header]
verscomb	varchar	32			idlspec2d version used during combination of multiple exposures [from spPlate header]
vers1d	varchar	32			idlspec2d version used during redshift fitting [from spPlate header]
survey	varchar	32			Name of survey [from platelist product]
programName	varchar	32			Name of program [from platelist product]
chunk	varchar	32			Name of tiling chunk [from platelist product]
plateRun	varchar	32			Drilling run for plate [from platelist product]
designComments	varchar	128			Comments on the plate design from plate plans [from platelist product]
plateQuality	varchar	32			Characterization of plate quality
qualityComments	varchar	100			Comments on reason for plate quality
platesn2	real	4			Overall signal to noise measure for plate
snturnoff	real	4			Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate)
nturnoff	real	4			Number of MS turnoff stars on plate
nExp	smallint	2			Number of exposures total [from spPlate header]
nExpB1	smallint	2			Number of exposures in B1 spectrograph [from spPlate header]
nExpB2	smallint	2			Number of exposures in B2 spectrograph [from spPlate header]
nExpR1	smallint	2			Number of exposures in R1 spectrograph [from spPlate header]
nExpR2	smallint	2			Number of exposures in R2 spectrograph [from spPlate header]
sn1_g	real	4			(S/N)^2 at g=20.20 for spectrograph #1 [from spPlate header]
sn1_r	real	4			(S/N)^2 at r=20.25 for spectrograph #1 [from spPlate header]
sn1_i	real	4			(S/N)^2 at i=19.90 for spectrograph #1 [from spPlate header]
sn2_g	real	4			(S/N)^2 at g=20.20 for spectrograph #2 [from spPlate header]
sn2_r	real	4			(S/N)^2 at r=20.25 for spectrograph #2 [from spPlate header]
sn2_i	real	4			(S/N)^2 at i=19.90 for spectrograph #2 [from spPlate header]
helioRV	real	4	km/s		Heliocentric velocity correction [from spPlate header]
gOffStd	real	4	mag		Mean g-band mag difference (spectro - photo) for standards [from spPlate header]
gRMSStd	real	4	mag		Stddev of g-band mag difference (spectro - photo) for standards [from spPlate header]
rOffStd	real	4	mag		Mean r-band mag difference (spectro - photo) for standards [from spPlate header]
rRMSStd	real	4	mag		Stddev of r-band mag difference (spectro - photo) for standards [from spPlate header]
iOffStd	real	4	mag		Mean i-band mag difference (spectro - photo) for standards [from spPlate header]
iRMSStd	real	4	mag		Stddev of i-band mag difference (spectro - photo) for standards [from spPlate header]
grOffStd	real	4	mag		Mean g-band mag difference (spectro - photo) for standards [from spPlate header]
grRMSStd	real	4	mag		Stddev of g-band mag difference (spectro - photo) for standards [from spPlate header]
riOffStd	real	4	mag		Mean r-band mag difference (spectro - photo) for standards [from spPlate header]
riRMSStd	real	4	mag		Stddev of r-band mag difference (spectro - photo) for standards [from spPlate header]
gOffGal	real	4	mag		Mean g-band mag difference (spectro - photo) for galaxies [from spPlate header]
gRMSGal	real	4	mag		Stddev of g-band mag difference (spectro - photo) for galaxies [from spPlate header]
rOffGal	real	4	mag		Mean r-band mag difference (spectro - photo) for galaxies [from spPlate header]
rRMSGal	real	4	mag		Stddev of r-band mag difference (spectro - photo) for galaxies [from spPlate header]
iOffGal	real	4	mag		Mean i-band mag difference (spectro - photo) for galaxies [from spPlate header]
iRMSGal	real	4	mag		Stddev of i-band mag difference (spectro - photo) for galaxies [from spPlate header]
grOffGal	real	4	mag		Mean g-band mag difference (spectro - photo) for galaxies [from spPlate header]
grRMSGal	real	4	mag		Stddev of g-band mag difference (spectro - photo) for galaxies [from spPlate header]
riOffGal	real	4	mag		Mean r-band mag difference (spectro - photo) for galaxies [from spPlate header]
riRMSGal	real	4	mag		Stddev of r-band mag difference (spectro - photo) for galaxies [from spPlate header]
nGuide	int	4			Number of guider camera frames taken during the exposure [from spPlate header]
seeing20	real	4			20th-percentile of seeing during exposure (arcsec) [from spPlate header]
seeing50	real	4			50th-percentile of seeing during exposure (arcsec) [from spPlate header]
seeing80	real	4			80th-percentile of seeing during exposure (arcsec) [from spPlate header]
rmsoff20	real	4			20th-percentile of RMS offset of guide fibers (arcsec) [from spPlate header]
rmsoff50	real	4			50th-percentile of RMS offset of guide fibers (arcsec) [from spPlate header]
rmsoff80	real	4			80th-percentile of RMS offset of guide fibers (arcsec) [from spPlate header]
airtemp	real	4	deg Celsius		Air temperature in the dome [from spPlate header]
sfd_used	tinyint	1			Were the SFD dust maps applied to the output spectrum? (0 = no, 1 = yes)
xSigma	real	4			sigma of gaussian fit to spatial profile[from spPlate header]
xSigMin	real	4			minimum of xSigma for all exposures [from spPlate header]
xSigMax	real	4			maximum of xSigma for all exposures [from spPlate header]
wSigma	real	4			sigma of gaussian fit to arc-line profiles in wavelength direction [from spPlate header]
wSigMin	real	4			minimum of wSigma for all exposures [from spPlate header]
wSigMax	real	4			maximum of wSigma for all exposures [from spPlate header]
xChi2	real	4			[from spPlate header]
xChi2Min	real	4			[from spPlate header]
xChi2Max	real	4			[from spPlate header]
skyChi2	real	4			average chi-squared from sky subtraction from all exposures [from spPlate header]
skyChi2Min	real	4			minimum skyChi2 over all exposures [from spPlate header]
skyChi2Max	real	4			maximum skyChi2 over all exposures [from spPlate header]
fBadPix	real	4			Fraction of pixels that are bad (total) [from spPlate header]
fBadPix1	real	4			Fraction of pixels that are bad (spectrograph #1) [from spPlate header]
fBadPix2	real	4			Fraction of pixels that are bad (spectrograph #2) [from spPlate header]
status2d	varchar	32			Status of 2D extraction
statuscombine	varchar	32			Status of combination of multiple MJDs
status1d	varchar	32			Status of 1D reductions
nGalaxy	real	4			Number of objects classified as galaxy [calculated from spZbest file]
nQSO	real	4			Number of objects classified as QSO [calculated from spZbest file]
nStar	real	4			Number of objects classified as Star [calculated from spZbest file]
nSky	real	4			Number of sky objects [calculated from spZbest file]
nUnknown	real	4			Number of objects with zWarning set non-zero (such objects still classified as star, galaxy or QSO) [calculated from spZbest file]
isBest	tinyint	1			is this plateX entry the best observation of the plate
isPrimary	tinyint	1			is this plateX entry both good and the best observation of the plate
isTile	tinyint	1			is this plate the best representative of its tile (only set for "legacy" program plates)
ha	real	4	deg	POS_EQ_RA	hour angle of design [from plPlugMapM file]
mjdDesign	int	4		MJD	MJD designed for [from plPlugMapM file]
theta	real	4		POS_POS-ANG	cartridge position angle [from plPlugMapM file]
fscanVersion	varchar	32			version of fiber scanning software [from plPlugMapM file]
fmapVersion	varchar	32			version of fiber mapping software [from plPlugMapM file]
fscanMode	varchar	32			'slow', 'fast', or 'extreme' [from plPlugMapM file]
fscanSpeed	int	4			speed of scan [from plPlugMapM file]
htmID	bigint	8			20 deep Hierarchical Triangular Mesh ID
loadVersion	int	4			Load Version