ConsDB - StarTrackerNarrow

The Consolidated Database for StarTrackerNarrow schema contains information for each exposure taken by the instrument, a narrow-field star tracker mounted on the Simonyi Survey Telescope. This includes observatory data from the FITS image header metadata and measurements and metrics from Rapid Analysis and other data processing.

exposure

Information from observatory systems about each raw image taken

Column Name Data Type Unit Description UCD Index Principal
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_flexdata

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

Column Name Data Type Unit Description UCD Index Principal
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 Unit Description UCD Index Principal
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+/).

exposure_quicklook

Information from Summit Rapid Analysis about each raw image taken

Column Name Data Type Unit Description UCD Index Principal
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.

SDM Schemas is maintained by Rubin Observatory.