Consolidated Database for LSSTComCamSim

The Consolidated Database Schema for LSSTComCamSim describes the tables and views available as fixed metadata to describe LSSTComCamSim 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.
seq_num	int		Sequence number.
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).
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 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]

exposure_flexdata

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

exposure_flexdata_schema

Column Name	Data Type	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	Description [UCD]
ccdexposure_id	long	Unique identifier. [meta.id]
exposure_id	long	Identifier of the exposure. [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	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	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	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.
seq_num	int		Sequence number.
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).
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.
n_inputs	int		Number of CCDs used to compute the visit aggregates.
astrom_offset_mean_min	float	arcsec	Mean offset of astrometric calibration matches (minimum across all detectors).
astrom_offset_mean_max	float	arcsec	Mean offset of astrometric calibration matches (maximum across all detectors).
astrom_offset_mean_median	float	arcsec	Mean offset of astrometric calibration matches (median across all detectors).
astrom_offset_std_min	float	arcsec	Standard deviation of offsets of astrometric calibration matches (minimum across all detectors).
astrom_offset_std_max	float	arcsec	Standard deviation of offsets of astrometric calibration matches (maximum across all detectors).
astrom_offset_std_median	float	arcsec	Standard deviation of offsets of astrometric calibration matches (median across all detectors).
eff_time_min	float	s	Effective exposure time (minimum across all detectors).
eff_time_max	float	s	Effective exposure time (maximum across all detectors).
eff_time_median	float	s	Effective exposure time (median across all detectors).
eff_time_psf_sigma_scale_min	float		Scale factor for effective exposure time based on PSF sigma (minimum across all detectors).
eff_time_psf_sigma_scale_max	float		Scale factor for effective exposure time based on PSF sigma (maximum across all detectors).
eff_time_psf_sigma_scale_median	float		Scale factor for effective exposure time based on PSF sigma (median across all detectors).
eff_time_sky_bg_scale_min	float		Scale factor for effective exposure time based on sky background (minimum across all detectors).
eff_time_sky_bg_scale_max	float		Scale factor for effective exposure time based on sky background (maximum across all detectors).
eff_time_sky_bg_scale_median	float		Scale factor for effective exposure time based on sky background (median across all detectors).
eff_time_zero_point_scale_min	float		Scale factor for effective exposure time based on zero point (minimum across all detectors).
eff_time_zero_point_scale_max	float		Scale factor for effective exposure time based on zero point (maximum across all detectors).
eff_time_zero_point_scale_median	float		Scale factor for effective exposure time based on zero point (median across all detectors).
max_dist_to_nearest_psf_min	float		Maximum distance of an unmasked pixel to its nearest model PSF star (minimum across all detectors).
max_dist_to_nearest_psf_max	float		Maximum distance of an unmasked pixel to its nearest model PSF star (maximum across all detectors).
max_dist_to_nearest_psf_median	float		Maximum distance of an unmasked pixel to its nearest model PSF star (median across all detectors).
mean_var_min	float		Mean of the variance plane (minimum across all detectors).
mean_var_max	float		Mean of the variance plane (maximum across all detectors).
mean_var_median	float		Mean of the variance plane (median across all detectors).
n_psf_star_min	int		Number of stars used for PSF model (minimum across all detectors).
n_psf_star_max	int		Number of stars used for PSF model (maximum across all detectors).
n_psf_star_median	int		Number of stars used for PSF model (median across all detectors).
n_psf_star_total	int		Number of stars used for PSF model (total across all detectors).
psf_area_min	float		PSF area (minimum across all detectors).
psf_area_max	float		PSF area (maximum across all detectors).
psf_area_median	float		PSF area (median across all detectors).
psf_ixx_min	float		PSF Ixx moment (minimum across all detectors).
psf_ixx_max	float		PSF Ixx moment (maximum across all detectors).
psf_ixx_median	float		PSF Ixx moment (median across all detectors).
psf_ixy_min	float		PSF Ixy moment (minimum across all detectors).
psf_ixy_max	float		PSF Ixy moment (maximum across all detectors).
psf_ixy_median	float		PSF Ixy moment (median across all detectors).
psf_iyy_min	float		PSF Iyy moment (minimum across all detectors).
psf_iyy_max	float		PSF Iyy moment (maximum across all detectors).
psf_iyy_median	float		PSF Iyy moment (median across all detectors).
psf_sigma_min	float		PSF sigma (minimum across all detectors).
psf_sigma_max	float		PSF sigma (maximum across all detectors).
psf_sigma_median	float		PSF sigma (median across all detectors).
psf_star_delta_e1_median_min	float		Median E1 residual (starE1 - psfE1) for PSF stars (minimum across all detectors).
psf_star_delta_e1_median_max	float		Median E1 residual (starE1 - psfE1) for PSF stars (maximum across all detectors).
psf_star_delta_e1_median_median	float		Median E1 residual (starE1 - psfE1) for PSF stars (median across all detectors).
psf_star_delta_e1_scatter_min	float		Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (minimum across all detectors).
psf_star_delta_e1_scatter_max	float		Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (maximum across all detectors).
psf_star_delta_e1_scatter_median	float		Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (median across all detectors).
psf_star_delta_e2_median_min	float		Median E2 residual (starE2 - psfE2) for PSF stars (minimum across all detectors).
psf_star_delta_e2_median_max	float		Median E2 residual (starE2 - psfE2) for PSF stars (maximum across all detectors).
psf_star_delta_e2_median_median	float		Median E2 residual (starE2 - psfE2) for PSF stars (median across all detectors).
psf_star_delta_e2_scatter_min	float		Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (minimum across all detectors).
psf_star_delta_e2_scatter_max	float		Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (maximum across all detectors).
psf_star_delta_e2_scatter_median	float		Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (median across all detectors).
psf_star_delta_size_median_min	float		Median size residual (starSize - psfSize) for PSF stars (minimum across all detectors).
psf_star_delta_size_median_max	float		Median size residual (starSize - psfSize) for PSF stars (maximum across all detectors).
psf_star_delta_size_median_median	float		Median size residual (starSize - psfSize) for PSF stars (median across all detectors).
psf_star_delta_size_scatter_min	float		Scatter (via MAD) of size residual (starSize - psfSize) for stars (minimum across all detectors).
psf_star_delta_size_scatter_max	float		Scatter (via MAD) of size residual (starSize - psfSize) for stars (maximum across all detectors).
psf_star_delta_size_scatter_median	float		Scatter (via MAD) of size residual (starSize - psfSize) for stars (median across all detectors).
psf_star_scaled_delta_size_scatter_min	float		Scatter (via MAD) of size residual scaled by median size squared (minimum across all detectors).
psf_star_scaled_delta_size_scatter_max	float		Scatter (via MAD) of size residual scaled by median size squared (maximum across all detectors).
psf_star_scaled_delta_size_scatter_median	float		Scatter (via MAD) of size residual scaled by median size squared (median across all detectors).
psf_trace_radius_delta_min	float		Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels (minimum across all detectors).
psf_trace_radius_delta_max	float		Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels (maximum across all detectors).
psf_trace_radius_delta_median	float		Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels (median across all detectors).
sky_bg_min	float		Average sky background (minimum across all detectors).
sky_bg_max	float		Average sky background (maximum across all detectors).
sky_bg_median	float		Average sky background (median across all detectors).
sky_noise_min	float		RMS noise of the sky background (minimum across all detectors).
sky_noise_max	float		RMS noise of the sky background (maximum across all detectors).
sky_noise_median	float		RMS noise of the sky background (median across all detectors).
seeing_zenith_500nm_min	double		Measured PSF sigma, corrected to 500nm and an airmass of 1 (minimum across all detectors).
seeing_zenith_500nm_max	double		Measured PSF sigma, corrected to 500nm and an airmass of 1 (maximum across all detectors).
seeing_zenith_500nm_median	double		Measured PSF sigma, corrected to 500nm and an airmass of 1 (median across all detectors).
zero_point_min	float		Photometric zero point (minimum across all detectors).
zero_point_max	float		Photometric zero point (maximum across all detectors).
zero_point_median	float		Photometric zero point (median across all detectors).
low_snr_source_count_min	int	count	Count of low signal-to-noise-ratio sources (minimum across all detectors).
low_snr_source_count_max	int	count	Count of low signal-to-noise-ratio sources (maximum across all detectors).
low_snr_source_count_median	int	count	Count of low signal-to-noise-ratio sources (median across all detectors).
low_snr_source_count_total	int	count	Count of low signal-to-noise-ratio sources (total across all detectors).
high_snr_source_count_min	int	count	Count of high signal-to-noise-ratio sources (minimum across all detectors).
high_snr_source_count_max	int	count	Count of high signal-to-noise-ratio sources (maximum across all detectors).
high_snr_source_count_median	int	count	Count of high signal-to-noise-ratio sources (median across all detectors).
high_snr_source_count_total	int	count	Count of high signal-to-noise-ratio sources (total across all detectors).

ccdvisit1

Column Name	Data Type	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 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.
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.