Consolidated Database for LATISS

The Consolidated Database Schema for LATISS describes the tables and views available as fixed metadata to describe LATISS exposures, visits, and parts thereof.

exposure

Column Name Data Type Unit Description [UCD]
exposure_id long Unique identifier.
exposure_name string Official name of the exposure.
controller string The abbreviation of the controller used for the observation (O, C).
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
physical_filter string ID of physical filter, the filter associated with a particular instrument.
band string Name of the band used to take the exposure. Abstract filter that is not associated with a particular instrument.
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]
shut_time float s Spatially-averaged shutter-open duration, accurate to 10ms. [time.interval]
dark_time float s Duration from last clear to readout, accurate to 10ms. [time.interval]
group_id string Identifier for the group that this exposure is part of.
cur_index int Number (1-based) of the observation within its group.
max_index int Expected number of observations within the group.
img_type string Type of exposure taken.
emulated boolean True if the exposure was taken in emulation mode.
science_program string Science program.
observation_reason string Reason for the observation.
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).
shut_lower float Dome dropout door opening percentage.
shut_upper float Dome main door opening percentage.
focus_z float Focus Z position.
dome_azimuth float Dome azimuth.
simulated boolean Were any control system components simulated?
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.
s_region string Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html). [pos.outline;obs.field]
mount_motion_image_degradation float arcsec Image degradation due to mount motion.
mount_motion_image_degradation_az float arcsec Image degradation due to mount motion in azimuth.
mount_motion_image_degradation_el float arcsec Image degradation due to mount motion in elevation.
mount_jitter_rms float arcsec RMS mount jitter.
mount_jitter_rms_az float arcsec Azimuth RMS mount jitter.
mount_jitter_rms_el float arcsec Elevation RMS mount jitter.
mount_jitter_rms_rot float arcsec Rotator RMS mount jitter.

exposure_flexdata

Column Name Data Type Unit Description [UCD]
obs_id long Unique identifier.
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
key string Name of key.
value text Content of value as a string.

exposure_flexdata_schema

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

ccdexposure

Column Name Data Type Unit Description [UCD]
ccdexposure_id long Unique identifier. [meta.id]
exposure_id long Identifier of the exposure.
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
detector int Number of the detector in the focal plane. [meta.id.part;instr.det]
s_region string Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html). [pos.outline;obs.field]

ccdexposure_camera

Column Name Data Type Unit Description [UCD]
ccdexposure_id long Unique identifier.
temp_set float Temperature setpoint of CCD in degC.
ccd_temp float Temperature of CCD in degC. [phys.temperature]

ccdexposure_flexdata

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

ccdexposure_flexdata_schema

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

visit1

Column Name Data Type Unit Description [UCD]
visit_id long Unique identifier.
exposure_name string Official name of the exposure mapped to this visit by the 1-to-1 visit system.
controller string The abbreviation of the controller used for the observation (O, C).
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
physical_filter string ID of physical filter, the filter associated with a particular instrument.
band string Name of the band used to take the visit. Abstract filter that is not associated with a particular instrument.
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 visit. [pos.az.azi]
azimuth_end float deg Azimuth of focal plane center at the end of the visit. [pos.az.azi]
azimuth float deg Azimuth of focal plane center at the middle of the visit. [pos.az.azi]
altitude_start float deg Altitude of focal plane center at the start of the visit. [pos.az.alt]
altitude_end float deg Altitude of focal plane center at the end of the visit. [pos.az.alt]
altitude float deg Altitude of focal plane center at the middle of the visit. [pos.az.alt]
zenith_distance_start float deg Zenith distance at the start of the visit. [pos.az.zd]
zenith_distance_end float deg Zenith distance at the end of the visit. [pos.az.zd]
zenith_distance float deg Zenith distance at the middle of the visit. [pos.az.zd]
airmass float Airmass of the observed line of sight at the middle of the visit. [obs.airMass]
exp_midpt timestamp Midpoint time for visit at the fiducial center of the focal plane. array. TAI, accurate to 10ms. [time.epoch]
exp_midpt_mjd double d Midpoint time for visit at the fiducial center of the focal plane. array in MJD. TAI, accurate to 10ms. [time.epoch]
obs_start timestamp Start time of the visit at the fiducial center of the focal plane. array, TAI, accurate to 10ms. [time.start]
obs_start_mjd double d Start of the visit in MJD, TAI, accurate to 10ms. [time.start]
obs_end timestamp End time of the visit at the fiducial center of the focal plane. array, TAI, accurate to 10ms. [time.end]
obs_end_mjd double d End of the visit in MJD, TAI, accurate to 10ms. [time.end]
exp_time float s Spatially-averaged duration of visit, accurate to 10ms. [time.interval]
shut_time float s Spatially-averaged shutter-open duration, accurate to 10ms. [time.interval]
dark_time float s Duration from last clear to readout, accurate to 10ms. [time.interval]
group_id string Identifier for the group that this visit is part of.
cur_index int Number (1-based) of the observation within its group.
max_index int Expected number of observations within the group.
img_type string Type of visit taken.
emulated boolean True if the visit was taken in emulation mode.
science_program string Science program.
observation_reason string Reason for the observation.
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).
shut_lower float Dome dropout door opening percentage.
shut_upper float Dome main door opening percentage.
focus_z float Focus Z position.
simulated boolean Were any control system components simulated?
vignette string Instrument blocked from the sky: UNKNOWN, NO, PARTIALLY, FULLY.
vignette_min string Lowest amount of instrument vignetting detected during the visit: UNKNOWN, NO, PARTIALLY, FULLY.
s_region string Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html). [pos.outline;obs.field]

visit1_quicklook

Column Name Data Type Unit Description [UCD]
visit_id long Unique identifier.
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
n_inputs int Number of CCDs used to compute the visit aggregates.
astrom_offset_mean float arcsec Mean offset of astrometric calibration matches.
astrom_offset_std float arcsec Standard deviation of offsets of astrometric calibration matches.
eff_time float s Effective exposure time calculated from PSF sigma, sky background, and zero point.
eff_time_psf_sigma_scale float Scale factor for effective exposure time based on PSF sigma.
eff_time_sky_bg_scale float Scale factor for effective exposure time based on sky background.
eff_time_zero_point_scale float Scale factor for effective exposure time based on zero point.
max_dist_to_nearest_psf float Maximum distance of an unmasked pixel to its nearest model PSF star.
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.
seeing_zenith_500nm double Measured PSF sigma, corrected to 500nm and an airmass of 1.
zero_point float Photometric zero point.
low_snr_source_count int count Count of low signal-to-noise-ratio sources.
high_snr_source_count int count Count of high signal-to-noise-ratio sources.

exposure_quicklook

Column Name Data Type Unit Description [UCD]
exposure_id long Unique identifier.
day_obs int Day of observation. [meta.id.part]
seq_num int Sequence number. [meta.id.part]
postisr_pixel_median float electron Median postISR pixel value.

ccdvisit1

Column Name Data Type Unit Description [UCD]
ccdvisit_id long Unique identifier. [meta.id]
visit_id long Identifier of the visit. [meta.id.part]
detector int Number of the detector in the focal plane. [meta.id.part;instr.det]
s_region string Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html). [pos.outline;obs.field]

ccdvisit1_quicklook

Column Name Data Type Unit Description [UCD]
ccdvisit_id long Unique identifier.
s_ra double deg Central Spatial Position in ICRS; Computed right ascension of CCD center. [pos.eq.ra]
s_dec double deg Central Spatial Position in ICRS; Computed declination of CCD center. [pos.eq.dec]
zenith_distance float Zenith distance at observation mid-point.
photometric_calib float nJy/count Conversion from DN to nanojansky.
psf_sigma float PSF model second-moments determinant radius (center of chip).
sky_bg float Average sky background.
sky_noise float RMS noise of the sky background.
zero_point float Photometric zero point.
seeing_zenith_500nm double Measured PSF sigma, corrected to 500nm and an airmass of 1.
astrom_offset_mean float arcsec Mean offset of astrometric calibration matches.
astrom_offset_std float arcsec Standard deviation of offsets of astrometric calibration matches.
eff_time float s Effective exposure time.
eff_time_psf_sigma_scale float Scale factor for effective exposure time based on PSF sigma.
eff_time_sky_bg_scale float Scale factor for effective exposure time based on sky background.
eff_time_zero_point_scale float Scale factor for effective exposure time based on zero point.
mean_var float Mean of the variance plane.
n_psf_star int count 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_star_delta_e1_median float Median E1 residual (starE1 - psfE1) for PSF stars.
psf_star_delta_e2_median float Median E2 residual (starE2 - psfE2) for PSF stars.
psf_star_delta_e1_scatter float Scatter (via MAD) of E1 residual (starE1 - psfE1) 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 pixel Median size residual (starSize - psfSize) for PSF stars.
psf_star_delta_size_scatter float pixel 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 pixel Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels.
max_dist_to_nearest_psf float pixel Maximum distance of an unmasked pixel to its nearest model PSF star.

SDM Schemas is maintained by Rubin Observatory.