ConsDB StarTrackerWide

exposure

Information from observatory systems about each raw image taken

Column Name	Data Type	Unit	Description	UCD
exposure_id	long		Unique identifier.
day_obs	int		Day of observation.
seq_num	int		Sequence number.
s_ra	double	deg	Central Spatial Position in ICRS; Right ascension of targeted focal plane center.	pos.eq.ra
s_dec	double	deg	Central Spatial Position in ICRS; Declination of targeted focal plane center.	pos.eq.dec
sky_rotation	double	deg	Targeted sky rotation angle.	pos.posAng
azimuth_start	float	deg	Azimuth of focal plane center at the start of the exposure.	pos.az.azi
azimuth_end	float	deg	Azimuth of focal plane center at the end of the exposure.	pos.az.azi
azimuth	float	deg	Azimuth of focal plane center at the middle of the exposure.	pos.az.azi
altitude_start	float	deg	Altitude of focal plane center at the start of the exposure.	pos.az.alt
altitude_end	float	deg	Altitude of focal plane center at the end of the exposure.	pos.az.alt
altitude	float	deg	Altitude of focal plane center at the middle of the exposure.	pos.az.alt
zenith_distance_start	float	deg	Zenith distance at the start of the exposure.	pos.az.zd
zenith_distance_end	float	deg	Zenith distance at the end of the exposure.	pos.az.zd
zenith_distance	float	deg	Zenith distance at the middle of the exposure.	pos.az.zd
airmass	float		Airmass of the observed line of sight at the middle of the exposure.	obs.airMass
exp_midpt	timestamp		Midpoint time for exposure at the fiducial center of the focal plane. array. TAI, accurate to 10ms.	time.epoch
exp_midpt_mjd	double	d	Midpoint time for exposure at the fiducial center of the focal plane. array in MJD. TAI, accurate to 10ms.	time.epoch
obs_start	timestamp		Start time of the exposure at the fiducial center of the focal plane. array, TAI, accurate to 10ms.	time.start
obs_start_mjd	double	d	Start of the exposure in MJD, TAI, accurate to 10ms.	time.start
obs_end	timestamp		End time of the exposure at the fiducial center of the focal plane. array, TAI, accurate to 10ms.	time.end
obs_end_mjd	double	d	End of the exposure in MJD, TAI, accurate to 10ms.	time.end
exp_time	float	s	Spatially-averaged duration of exposure, accurate to 10ms.	time.interval
img_type	string		Type of exposure taken.
target_name	string		Target of the observation.
air_temp	float		Outside air temperature in degC.	phys.temperature
pressure	float	Pa	Outside air pressure.
humidity	float		Outside relative humidity.
wind_speed	float	m/s	Outside wind speed.
wind_dir	float	deg	Wind direction.
dimm_seeing	float	arcsec	Seeing as measured by external DIMM (FWHM).
dome_azimuth	float		Dome azimuth.
vignette	string		Instrument blocked from the sky: UNKNOWN, NO, PARTIALLY, FULLY.
vignette_min	string		Lowest amount of instrument vignetting detected during the exposure: UNKNOWN, NO, PARTIALLY, FULLY.

exposure_quicklook

Information from Summit Rapid Analysis about each raw image taken

Column Name	Data Type	Unit	Description	UCD
exposure_id	long		Unique identifier.
ra	double	deg	Central Spatial Position in ICRS; Right ascension of fitted WCS.	pos.eq.ra
dec	double	deg	Central Spatial Position in ICRS; Declination of fitted WCS.	pos.eq.dec
astrom_offset_mean	float	arcsec	Mean offset of astrometric calibration matches.
astrom_offset_std	float	arcsec	Standard deviation of offsets of astrometric calibration matches.
mean_var	float		Mean of the variance plane.
n_psf_star	int		Number of stars used for PSF model.
psf_area	float		PSF area.
psf_ixx	float		PSF Ixx moment.
psf_ixy	float		PSF Ixy moment.
psf_iyy	float		PSF Iyy moment
psf_sigma	float		PSF sigma.
psf_star_delta_e1_median	float		Median E1 residual (starE1 - psfE1) for PSF stars.
psf_star_delta_e1_scatter	float		Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars.
psf_star_delta_e2_median	float		Median E2 residual (starE2 - psfE2) for PSF stars.
psf_star_delta_e2_scatter	float		Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars.
psf_star_delta_size_median	float		Median size residual (starSize - psfSize) for PSF stars.
psf_star_delta_size_scatter	float		Scatter (via MAD) of size residual (starSize - psfSize) for stars.
psf_star_scaled_delta_size_scatter	float		Scatter (via MAD) of size residual scaled by median size squared.
psf_trace_radius_delta	float		Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels.
sky_bg	float		Average sky background.
sky_noise	float		RMS noise of the sky background.
source_count	int	count	Count of sources.

exposure_flexdata

Flexible key/value metadata about each raw image taken; used for development and engineering purposes

Column Name	Data Type	Description
obs_id	long	Unique identifier.
key	string	Name of key.
value	text	Content of value as a string.

exposure_flexdata_schema

Key names and value types used in the exposure_flexdata table

Column Name	Data Type	Description
key	string	Name of key.
dtype	string	Name of the data type of the value, one of bool, int, float, str.
doc	text	Documentation string.
unit	string	Unit for the value. Should be from the IVOA (https://www.ivoa.net/documents/VOUnits/) or astropy.
ucd	string	IVOA Unified Content Descriptor (https://www.ivoa.net/documents/UCD1+/).

SDM Schemas is maintained by Rubin Observatory.