TABLE  spectra

Parameters are recorded for both the V and R frames (with a lot of the values being the same for both frames), redshift information is derived from a combined VR frame. Objects can be observed more than once. Required constraints: Primary key is (specid)

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
SPECID	bigint	8		unique ID no., used to generate GIF image of spectrum
TARGETID	bigint	8		ID no. in Target table
TARGETNAME	varchar	32		matching name in target table, used to name FITS files and generate thumbnail images
OBSRA	float	8	degrees	observed ra (J2000 degrees)
OBSDEC	float	8	degrees	observed dec (J2000 degrees)
MATCH_DR	float	8	arcsec	position match error (arcsec)
HTMID	bigint	8		Hierarchical Triangular Mesh (20-deep), mainly useful internally for indexing on position
CX	float	8		Cartesian x of unit vector on celestial sphere
CY	float	8		Cartesian y of unit vector on celestial sphere
CZ	float	8		Cartesian z of unit vector on celestial sphere
Z_ORIGIN	char	1		redshift from C=combined V or R frame
Z	real	4		raw measured redshift
Z_HELIO	real	4		heliocentric redshift
QUALITY	int	4		redshift measurement quality: 4=good 1=bad (6=star)
ABEMMA	int	4		redshift type: abs=1,emi=2,man=3
NMBEST	int	4		emission lines for emission z
NGOOD	int	4		number of good emission lines
Z_EMI	real	4		emission redshift
Q_Z_EMI	int	4		emission redshift quality
KBESTR	int	4		cross-correlation template
R_CRCOR	real	4		cross-correlation peak
Z_ABS	real	4		cross-correlation redshift
Q_Z_ABS	int	4		cross-correlation quality
Q_FINAL	int	4		suggested quality for redshift
IALTER	int	4		IALTER=1 if automatic z altered
Z_COMM	varchar	29		observer's comment
ZEMIBESTERR	real	4		error on the selected emission line redshift, 0.0 if not measured
ZABSBESTERR	real	4		error on the selected absorption line redshift, 0.0 if not measured
ZFINALERR	real	4		error on final quoted redshift, 0.0 if not measured
TITLE_V	varchar	32		eg 1325m243p2.sds observation title
CENRA_V	float	8	radians	RA of field centre
CENDEC_V	float	8	radians	DEC of field centre
APPRA_V	float	8	radians	apparent RA of field centre
APPDEC_V	float	8	radians	apparent DEC of field centre
ACTMJD_V	float	8	Julian days	the time the field was actually configured
CONMJD_V	float	8	Julian days	time which was specified when configure was run
PROGID_V	varchar	32		programme ID in V frame
LABEL_V	varchar	32		label in V frame
OBSID_V	varchar	32		obsid in V frame
RUN_V	int	4		V run number
EXP_V	real	4	seconds	V reference frame exposure time seconds
NCOMB_V	smallint	2		number of V frames combined
GRATID_V	varchar	14		grating ID in V frame
GRATSET_V	real	4		V grating micrometer setting
GRATSLOT_V	char	1		V grating slot ID
GRATBLAZ_V	varchar	10		V blaze direction
SOURCE_V	varchar	10		V source plate
FOCUS_V	real	4		V frame spectrograph focus value
TFOCUS_V	real	4		V frame telescope focus value
GAIN_V	real	4		V gain
NOISE_v	real	4		V readout noise
CCD_V	varchar	12		V CCD name
UTDATE_V	datetime	8	MM-DD-YYYY	UT date in V frame
UTSTRT_V	varchar	15	HH-MM-SS	UT start time of V reference frame
MJDOBS_V	float	8	Julian days	MJD of observation
NAME_V	varchar	32		name of object in V frame
THPUT_V	real	4		V thruput of fibre
RA_V	float	8	degrees	observed ra (J2000 degrees)
DEC_V	float	8	degrees	observed dec (J2000 degrees)
X_V	int	4		x position of object from V frame
Y_V	int	4		y position of object from V frame
XERR_V	int	4		error on X_V position
YERR_V	int	4		error on Y_V position
THETA_V	float	8	degrees	fibre angle V frame
FIBRE_V	smallint	2		fibre number (row on CCD)
PIVOT_V	smallint	2		V pivot number
RECMAG_V	real	4	mag	magnitude read from V frame
PID_V	int	4		PID number read from V frame
TITLE_R	varchar	32		eg 1325m243p2.sds observation title
CENRA_R	float	8	radians	RA of field centre
CENDEC_R	float	8	radians	DEC of field centre
APPRA_R	float	8	radians	apparent RA of field centre
APPDEC_R	float	8	radians	apparent DEC of field centre
ACTMJD_R	float	8	Julian days	the time the field was actually configured
CONMJD_R	float	8	Julian days	time which was specified when configure was run
PROGID_R	varchar	32		programme ID in R frame
LABEL_R	varchar	32		label in R frame
OBSID_R	varchar	32		obsid in R frame
RUN_R	int	4		R run number
EXP_R	real	4	seconds	R reference frame exposure time seconds
NCOMB_R	smallint	2		number of R frames combined
GRATID_R	varchar	14		grating ID in R frame
GRATSET_R	real	4		R grating micrometer setting
GRATSLOT_R	char	1		R grating slot ID
GRATBLAZ_R	varchar	10		R blaze direction
SOURCE_R	varchar	10		R source plate
FOCUS_R	real	4		R frame spectrograph focus value
GAIN_R	real	4		R gain
NOISE_R	real	4		R readout noise
CCD_R	varchar	12		R CCD name
UTDATE_R	datetime	8	MM-DD-YYYY	UT date in R frame
UTSTRT_R	varchar	15	HH-MM-SS	UT start time of R reference frame
MJDOBS_R	float	8	Julian days	MJD of observation
NAME_R	varchar	32		name of object in R frame
THPUT_R	real	4		R thruput of fibre
RA_R	float	8	degrees	observed ra (J2000 degrees)
DEC_R	float	8	degrees	observed dec (J2000 degrees)
X_R	int	4		x position of object from R frame
Y_R	int	4		y position of object from R frame
XERR_R	int	4		error on X_R position
YERR_R	int	4		error on Y_R position
THETA_R	float	8	degrees	fibre angle R frame
FIBRE_R	smallint	2		fibre number (row on CCD)
PIVOT_R	smallint	2		R pivot number
RECMAG_R	real	4	mag	magnitude read from R frame
PID_R	int	4		PID number read from R frame
Total length		942