ConsDB LSSTCam

---

exposure

Information from observatory systems about each raw image taken

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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 focal plane center derived from encoder readings and correcting for annual abberation, precession-nutation, earth orientation, atmospheric refraction, and mount/flexure model, determined without reference to a plate solution.	pos.eq.ra
s_dec	double	deg	Central Spatial Position in ICRS; declination of focal plane center derived from encoder readings and correcting for annual abberation, precession-nutation, earth orientation, atmospheric refraction, and mount/flexure model, determined without reference to a plate solution.	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.
scheduler_note	string		A note indicating how or why the observation was chosen by the Feature Based Scheduler.
s_region	string		Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html).	pos.outline;obs.field
can_see_sky	boolean		Whether the observation can see sky or not.

---

exposure_quicklook

Information from Summit Rapid Analysis about each raw image taken

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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_median	float	count	Median postISR pixel value (median across all detectors).	phot;phys.electron
postisr_pixel_median_mean	float	count	Median postISR pixel value (mean across all detectors).	phot;phys.electron
postisr_pixel_median_max	float	count	Median postISR pixel value (max across all detectors).	phot;phys.electron
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_motion_image_degradation_rot	float	arcsec	Image degradation due to rotator jitter.
mount_jitter_rms_cam_hexapod	float	arcsec	The RMS image motion due to movement of the camera hexapod.
mount_jitter_rms_m2_hexapod	float	arcsec	The RMS image motion due to movement of the M2 hexapod.
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.
ra_package_versions	text		Packages such as ts_wep, donut_viz, tarts, danish versions used for processing.
mtaos_package_versions	text		mtaos package versions used.

---

visit1

Information from observatory systems about each visit in visit system 1 (visit per exposure); describes processed visit images (or calibrated exposures)

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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 focal plane center derived from encoder readings and correcting for annual abberation, precession-nutation, earth orientation, atmospheric refraction, and mount/flexure model, determined without reference to a plate solution.	pos.eq.ra
s_dec	double	deg	Central Spatial Position in ICRS; declination of focal plane center derived from encoder readings and correcting for annual abberation, precession-nutation, earth orientation, atmospheric refraction, and mount/flexure model, determined without reference to a plate solution.	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.
scheduler_note	string		A note indicating how or why the observation was chosen by the Feature Based Scheduler.
s_region	string		Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html).	pos.outline;obs.field
can_see_sky	boolean		Whether the observation can see sky or not.

---

visit1_quicklook

Information from Summit Rapid Analysis about each visit in visit system 1 (visit per exposure); describes processed visit images (or calibrated exposures)

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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	count	Number of CCDs used to compute the visit aggregates.
pixel_scale_min	float	arcsec/pixel	Measured detector pixel scale (minimum across all detectors).
pixel_scale_max	float	arcsec/pixel	Measured detector pixel scale (maximum across all detectors).
pixel_scale_median	float	arcsec/pixel	Measured detector pixel scale (median across all detectors).
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).
astrom_ra	double	deg	Central Spatial Position in ICRS; Right ascension of the center position of the central CCD (R22_S11). In contrast with #exposure.s_ra, which is the targeted sky position, this is the position fitted after plate solving the image.	pos.eq.ra
astrom_dec	double	deg	Central Spatial Position in ICRS; Declination of the center position of the central CCD (R22_S11). In contrast with #exposure.s_dec, which is the targeted sky position, this is the position fitted after plate solving the image.	pos.eq.dec
astrom_sky_rotation	double	deg	Fitted sky rotation angle based on plate solving. This quantity can be compared to #exposure.sky_rotation, the targeted sky rotation angle.	pos.posAng
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).
stats_mag_lim_min	float	mag	Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (minimum across all detectors).
stats_mag_lim_max	float	mag	Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (maximum across all detectors).
stats_mag_lim_median	float	mag	Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (median across all detectors).
psf_ap_flux_delta_min	float		Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels (minimum across all detectors).
psf_ap_flux_delta_max	float		Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels (maximum across all detectors).
psf_ap_flux_delta_median	float		Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels (median across all detectors).
psf_ap_corr_sigma_scaled_delta_min	float		Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma evaluated on a grid of unmasked pixels (minimum across all detectors).
psf_ap_corr_sigma_scaled_delta_max	float		Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma evaluated on a grid of unmasked pixels (maximum across all detectors).
psf_ap_corr_sigma_scaled_delta_median	float		Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma evaluated on a grid of unmasked pixels (median across all detectors).
max_dist_to_nearest_psf_min	float	pixel	Maximum distance of an unmasked pixel to its nearest model PSF star (minimum across all detectors).
max_dist_to_nearest_psf_max	float	pixel	Maximum distance of an unmasked pixel to its nearest model PSF star (maximum across all detectors).
max_dist_to_nearest_psf_median	float	pixel	Maximum distance of an unmasked pixel to its nearest model PSF star (median across all detectors).
mean_var_min	float	count**2	Mean of the variance plane (minimum across all detectors).	phot;phys.electron
mean_var_max	float	count**2	Mean of the variance plane (maximum across all detectors).	phot;phys.electron
mean_var_median	float	count**2	Mean of the variance plane (median across all detectors).	phot;phys.electron
n_psf_star_min	int	count	Number of stars used for PSF model (minimum across all detectors).
n_psf_star_max	int	count	Number of stars used for PSF model (maximum across all detectors).
n_psf_star_median	int	count	Number of stars used for PSF model (median across all detectors).
n_psf_star_total	int	count	Number of stars used for PSF model (total across all detectors).
psf_area_min	float	pixel**2	PSF area (minimum across all detectors).
psf_area_max	float	pixel**2	PSF area (maximum across all detectors).
psf_area_median	float	pixel**2	PSF area (median across all detectors).
psf_ixx_min	float	pixel**2	PSF Ixx moment (minimum across all detectors).
psf_ixx_max	float	pixel**2	PSF Ixx moment (maximum across all detectors).
psf_ixx_median	float	pixel**2	PSF Ixx moment (median across all detectors).
psf_ixy_min	float	pixel**2	PSF Ixy moment (minimum across all detectors).
psf_ixy_max	float	pixel**2	PSF Ixy moment (maximum across all detectors).
psf_ixy_median	float	pixel**2	PSF Ixy moment (median across all detectors).
psf_iyy_min	float	pixel**2	PSF Iyy moment (minimum across all detectors).
psf_iyy_max	float	pixel**2	PSF Iyy moment (maximum across all detectors).
psf_iyy_median	float	pixel**2	PSF Iyy moment (median across all detectors).
psf_sigma_min	float	pixel	PSF sigma (minimum across all detectors).
psf_sigma_max	float	pixel	PSF sigma (maximum across all detectors).
psf_sigma_median	float	pixel	PSF sigma (median across all detectors).
psf_sigma_95	float	pixel	PSF sigma (95% across all detectors).
psf_sigma_05	float	pixel	PSF sigma (5% across all detectors).
psf_fwhm_x_gradient	float	arcsec/deg	PSF FWHM X Gradient calculated as Z2,fwhm in OCS in arcsec/deg.
psf_fwhm_y_gradient	float	arcsec/deg	PSF FWHM Y Gradient calculated as Z3,fwhm in OCS in arcsec/deg.
psf_fwhm_radial_gradient	float	arcsec/deg**2	PSF FWHM radial gradient, calculated as Z4,fwhm in arcsec/deg2.
psf_ellipticity_median	float		Ellipticity median across all detectors.
psf_ellipticity_95	float		Ellipticity 95% across all detectors.
psf_ellipticity_05	float		Ellipticity 5% across all detectors.
psf_e1_x_gradient	float	1/deg	PSF e1 X Gradient calculated as Z2,e1 in OCS in 1/deg.
psf_e1_y_gradient	float	1/deg	PSF e1 Y Gradient calculated as Z3,e1 in OCS in 1/deg.
psf_e1_radial_gradient	float	1/deg**2	PSF e1 radial gradient, calculated as Z4,e1 in 1/deg2.
psf_e2_x_gradient	float	1/deg	PSF e2 X Gradient calculated as Z2,e2 in OCS in 1/deg.
psf_e2_y_gradient	float	1/deg	PSF e2 Y Gradient calculated as Z3,e2 in OCS in 1/deg.
psf_e2_radial_gradient	float	1/deg**2	PSF e2 radial gradient, calculated as Z4,e2 in 1/deg2.
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	pixel	Median size residual (starSize - psfSize) for PSF stars (minimum across all detectors).
psf_star_delta_size_median_max	float	pixel	Median size residual (starSize - psfSize) for PSF stars (maximum across all detectors).
psf_star_delta_size_median_median	float	pixel	Median size residual (starSize - psfSize) for PSF stars (median across all detectors).
psf_star_delta_size_scatter_min	float	pixel	Scatter (via MAD) of size residual (starSize - psfSize) for stars (minimum across all detectors).
psf_star_delta_size_scatter_max	float	pixel	Scatter (via MAD) of size residual (starSize - psfSize) for stars (maximum across all detectors).
psf_star_delta_size_scatter_median	float	pixel	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	pixel	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	pixel	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	pixel	Delta (max - min) of model PSF trace radius values evaluated on a grid of unmasked pixels (median across all detectors).
sky_bg_min	float	count	Average sky background (minimum across all detectors).	phot;phys.electron
sky_bg_max	float	count	Average sky background (maximum across all detectors).	phot;phys.electron
sky_bg_median	float	count	Average sky background (median across all detectors).	phot;phys.electron
sky_noise_min	float	count	RMS noise of the sky background (minimum across all detectors).	phot;phys.electron
sky_noise_max	float	count	RMS noise of the sky background (maximum across all detectors).	phot;phys.electron
sky_noise_median	float	count	RMS noise of the sky background (median across all detectors).	phot;phys.electron
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	mag	Photometric zero point (minimum across all detectors).
zero_point_max	float	mag	Photometric zero point (maximum across all detectors).
zero_point_median	float	mag	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).
z4	float	um	Estimated total defocus (Z4) in OCS, mean estimated across four corners in microns.
z5	float	um	Estimated total oblique primary astigmatism (Z5) in OCS, mean estimated across four corners in microns.
z6	float	um	Estimated total vertical primary astigmatism (Z6) in OCS, mean estimated across four corners in microns.
z7	float	um	Estimated total vertical primary coma (Z7) in OCS, mean estimated across four corners in microns.
z8	float	um	Estimated total horizontal primary coma (Z8) in OCS, mean estimated across four corners in microns.
z9	float	um	Estimated total vertical trefoil (Z9) in OCS, mean estimated across four corners in microns.
z10	float	um	Estimated total oblique trefoil (Z10) in OCS, mean estimated across four corners in microns.
z11	float	um	Estimated total primary spherical (Z11) in OCS, mean estimated across four corners in microns.
z12	float	um	Estimated total vertical secondary astigmatism (Z12) in OCS, mean estimated across four corners in microns.
z13	float	um	Estimated total oblique secondary astigmatism (Z13) in OCS, mean estimated across four corners in microns.
z14	float	um	Estimated total vertical quadrafoil (Z14) in OCS, mean estimated across four corners in microns.
z15	float	um	Estimated total oblique quadrafoil (Z15) in OCS, mean estimated across four corners in microns.
z16	float	um	Estimated total horizontal secondary coma (Z16) in OCS, mean estimated across four corners in microns.
z17	float	um	Estimated total vertical secondary coma (Z17) in OCS, mean estimated across four corners in microns.
z18	float	um	Estimated total oblique secondary trefoil (Z18) in OCS, mean estimated across four corners in microns.
z19	float	um	Estimated total vertical secondary trefoil (Z19) in OCS, mean estimated across four corners in microns.
z20	float	um	Estimated total oblique pentafoil (Z20) in OCS, mean estimated across four corners in microns.
z21	float	um	Estimated total vertical pentafoil (Z21) in OCS, mean estimated across four corners in microns.
z22	float	um	Estimated total secondary spherical (Z22) in OCS, mean estimated across four corners in microns.
z23	float	um	Estimated total tertiary astigmatism (Z23) in OCS, mean estimated across four corners in microns.
z24	float	um	Estimated total tertiary astigmatism (Z24) in OCS, mean estimated across four corners in microns.
z25	float	um	Estimated total oblique secondary quadrafoil (Z25) in OCS, mean estimated across four corners in microns.
z26	float	um	Estimated total vertical secondary quadrafoil (Z26) in OCS, mean estimated across four corners in microns.
z27	float	um	Estimated total hexafoil (Z27) in OCS, mean estimated across four corners in microns.
z28	float	um	Estimated total hexafoil (Z28) in OCS, mean estimated across four corners in microns.
z4_intrinsic	float	um	Intrinsic defocus (Z4) in OCS, mean across four corners in microns.
z11_intrinsic	float	um	Intrinsic primary spherical (Z11) in OCS, mean across four corners in microns.
z22_intrinsic	float	um	Intrinsic secondary spherical (Z22) in OCS, mean across four corners in microns.
z2_8_intrinsic	float	um	Intrinsic double zernike k=2, j=8 in OCS.
z3_7_intrinsic	float	um	Intrinsic double zernike k=3, j=7 in OCS.
z2_4	float	um	Double zernike k=2, j=4 in OCS in microns for field radius 1.75 deg.
z2_5	float	um	Double zernike k=2, j=5 in OCS in microns for field radius 1.75 deg.
z2_6	float	um	Double zernike k=2, j=6 in OCS in microns for field radius 1.75 deg.
z2_7	float	um	Double zernike k=2, j=7 in OCS in microns for field radius 1.75 deg.
z2_8	float	um	Double zernike k=2, j=8 in OCS in microns for field radius 1.75 deg.
z2_9	float	um	Double zernike k=2, j=9 in OCS in microns for field radius 1.75 deg.
z2_10	float	um	Double zernike k=2, j=10 in OCS in microns for field radius 1.75 deg.
z2_11	float	um	Double zernike k=2, j=11 in OCS in microns for field radius 1.75 deg.
z2_12	float	um	Double zernike k=2, j=12 in OCS in microns for field radius 1.75 deg.
z2_13	float	um	Double zernike k=2, j=13 in OCS in microns for field radius 1.75 deg.
z2_14	float	um	Double zernike k=2, j=14 in OCS in microns for field radius 1.75 deg.
z2_15	float	um	Double zernike k=2, j=15 in OCS in microns for field radius 1.75 deg.
z2_16	float	um	Double zernike k=2, j=16 in OCS in microns for field radius 1.75 deg.
z2_17	float	um	Double zernike k=2, j=17 in OCS in microns for field radius 1.75 deg.
z2_18	float	um	Double zernike k=2, j=18 in OCS in microns for field radius 1.75 deg.
z2_19	float	um	Double zernike k=2, j=19 in OCS in microns for field radius 1.75 deg.
z2_20	float	um	Double zernike k=2, j=20 in OCS in microns for field radius 1.75 deg.
z2_21	float	um	Double zernike k=2, j=21 in OCS in microns for field radius 1.75 deg.
z2_22	float	um	Double zernike k=2, j=22 in OCS in microns for field radius 1.75 deg.
z2_23	float	um	Double zernike k=2, j=23 in OCS in microns for field radius 1.75 deg.
z2_24	float	um	Double zernike k=2, j=24 in OCS in microns for field radius 1.75 deg.
z2_25	float	um	Double zernike k=2, j=25 in OCS in microns for field radius 1.75 deg.
z2_26	float	um	Double zernike k=2, j=26 in OCS in microns for field radius 1.75 deg.
z2_27	float	um	Double zernike k=2, j=27 in OCS in microns for field radius 1.75 deg.
z2_28	float	um	Double zernike k=2, j=28 in OCS in microns for field radius 1.75 deg.
z3_4	float	um	Double zernike k=3, j=4 in OCS in microns for field radius 1.75 deg.
z3_5	float	um	Double zernike k=3, j=5 in OCS in microns for field radius 1.75 deg.
z3_6	float	um	Double zernike k=3, j=6 in OCS in microns for field radius 1.75 deg.
z3_7	float	um	Double zernike k=3, j=7 in OCS in microns for field radius 1.75 deg.
z3_8	float	um	Double zernike k=3, j=8 in OCS in microns for field radius 1.75 deg.
z3_9	float	um	Double zernike k=3, j=9 in OCS in microns for field radius 1.75 deg.
z3_10	float	um	Double zernike k=3, j=10 in OCS in microns for field radius 1.75 deg.
z3_11	float	um	Double zernike k=3, j=11 in OCS in microns for field radius 1.75 deg.
z3_12	float	um	Double zernike k=3, j=12 in OCS in microns for field radius 1.75 deg.
z3_13	float	um	Double zernike k=3, j=13 in OCS in microns for field radius 1.75 deg.
z3_14	float	um	Double zernike k=3, j=14 in OCS in microns for field radius 1.75 deg.
z3_15	float	um	Double zernike k=3, j=15 in OCS in microns for field radius 1.75 deg.
z3_16	float	um	Double zernike k=3, j=16 in OCS in microns for field radius 1.75 deg.
z3_17	float	um	Double zernike k=3, j=17 in OCS in microns for field radius 1.75 deg.
z3_18	float	um	Double zernike k=3, j=18 in OCS in microns for field radius 1.75 deg.
z3_19	float	um	Double zernike k=3, j=19 in OCS in microns for field radius 1.75 deg.
z3_20	float	um	Double zernike k=3, j=20 in OCS in microns for field radius 1.75 deg.
z3_21	float	um	Double zernike k=3, j=21 in OCS in microns for field radius 1.75 deg.
z3_22	float	um	Double zernike k=3, j=22 in OCS in microns for field radius 1.75 deg.
z3_23	float	um	Double zernike k=3, j=23 in OCS in microns for field radius 1.75 deg.
z3_24	float	um	Double zernike k=3, j=24 in OCS in microns for field radius 1.75 deg.
z3_25	float	um	Double zernike k=3, j=25 in OCS in microns for field radius 1.75 deg.
z3_26	float	um	Double zernike k=3, j=26 in OCS in microns for field radius 1.75 deg.
z3_27	float	um	Double zernike k=3, j=27 in OCS in microns for field radius 1.75 deg.
z3_28	float	um	Double zernike k=3, j=28 in OCS in microns for field radius 1.75 deg.
ringss_seeing	float	arcsec	Atmospheric seeing as measured by external SOAR/Gemini RINGSS (FWHM)
aos_fwhm	float	arcsec	Estimated contribution of the optical system to the overall seeing (FWHM) using the measured zernike coefficients.
donut_blur_fwhm	float	arcsec	Estimated contribution of the atmosphere to the overall seeing (FWHM) derived from danish donut forward modeling.
physical_rotator_angle	double	deg	Physical rotator angle in degrees.	pos.posAng
guider_exp_time	float	s	Total guider exposure time across all stamps.	time.interval
guider_stamp_exp_time	float	s	The delivered guider exposure time for a single stamp.	time.interval
guider_n_stamps_expected	int	count	Number of expected guider stamps.
guider_n_stamps_delivered	int	count	Number of delivered guider stamps.
guider_roi_cols	float	pixel	Number of columns in the guider ROI, in pixels.
guider_roi_rows	float	pixel	Number of rows in the guider ROI, in pixels.
guider_n_tracked_stars	int	count	Number of tracked stars.
guider_n_measurements	int	count	Number of tracked star measurements.
guider_altitude_drift	float	arcsec	Altitude drift over exposure in arcsec.
guider_altitude_standard_deviation	float	arcsec	Standard deviation of altitude over exposure.
guider_altitude_rms_detrended	float	arcsec	RMS of altitude after trendline is subtracted.
guider_azimuth_drift	float	arcsec	Azimuth drift over exposure in arcsec.
guider_azimuth_standard_deviation	float	arcsec	Standard deviation of azimuth over exposure.
guider_azimuth_rms_detrended	float	arcsec	RMS of azimuth after trendline is subtracted.
guider_focalplane_theta_drift	float	arcsec	Focal plane theta drift over exposure in arcsec.
guider_focalplane_theta_standard_deviation	float	arcsec	Standard deviation of focal plane theta over exposure.
guider_focalplane_theta_rms_detrended	float	arcsec	RMS of focal plane theta after trendline is subtracted.
guider_magnitude_drift	float	mag	Magnitude drift over exposure in magnitudes.
guider_magnitude_standard_deviation	float	mag	Standard deviation of magnitude over exposure.
guider_magnitude_rms_detrended	float	mag	RMS of magnitude after trendline is subtracted.
guider_psf_fwhm_start	float	arcsec	PSF FWHM of the guider star at the start of the exposure.
guider_psf_fwhm_drift	float	arcsec	PSF FWHM drift over exposure in arcsec.
guider_psf_fwhm_standard_deviation	float	arcsec	Standard deviation of PSF FWHM over exposure.
guider_psf_fwhm_rms_detrended	float	arcsec	RMS of PSF FWHM after trendline is subtracted.
guider_psf_fwhm	float	arcsec	Mean PSF FWHM for all measurements over the exposure.
guider_e1_mean	float		Mean second moment e1 for all measurements over the exposure.
guider_e2_mean	float		Mean second moment e2 for all measurements over the exposure.
guider_ground_layer_seeing	float	arcsec	Ground layer seeing calculated with guider exposure.
guider_mid_layer_seeing	float	arcsec	Mid layer seeing calculated with guider exposure.
guider_free_seeing	float	arcsec	Free atmosphere seeing calculated with guider exposure.
guider_total_seeing	float	arcsec	Total seeing calculated with guider exposure.
guider_l0	float	m	Outer scale L0 in meters calculated by the guider.
shapelet_score_median	float		Median shapelet score across the FOV.
shapelet_score_max	float		Maximum shapelet score across the FOV.
shapelet_score_min	float		Minimum shapelet score across the FOV.
last_correction_visit_id	int		Visit ID from which the last applied AOS corrections were calculated.

---

ccdexposure

Information from observatory systems about each detector (CCD) within each raw image taken

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

Information from Summit Rapid Analysis about each detector (CCD) within each raw image taken

Indexes

Columns	Description	Reference Name
ccdexposure_id	Explicit index for single-column ID.	idx_ccdexposure_quicklook_ccdexposure_id

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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
ccdexposure_id	long		Unique identifier.
postisr_pixel_median	float	count	Median postISR pixel value.	phot;phys.electron

---

ccdexposure_camera

Information from the Camera Control System about each detector (CCD) within each raw image taken

Indexes

Columns	Description	Reference Name
ccdexposure_id	Explicit index for single-column ID.	idx_ccdexposure_camera_ccdexposure_id

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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
ccdexposure_id	long		Unique identifier.
temp_set	float		Temperature setpoint of CCD in degC.
ccd_temp	float		Temperature of CCD in degC.	phys.temperature

---

ccdvisit1

Information from observatory systems about each detector (CCD) within each visit in visit system 1 (visit per exposure); describes detectors in processed visit images (or calibrated exposures)

Column Name	Data Type	Unit	Description	UCD	Order	Principal
day_obs	int		Day of observation.	meta.id.part
seq_num	int		Sequence number.	meta.id.part
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

Information from Summit Rapid Analysis about each detector (CCD) within each visit in visit system 1 (visit per exposure); describes detectors in processed visit images (or calibrated exposures)

Indexes

Columns	Description	Reference Name
ccdvisit_id	Explicit index for single-column ID.	idx_ccdvisit1_quicklook_ccdvisit_id

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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
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	pixel	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.
pixel_scale	float	arcsec/pixel	Measured detector pixel scale.
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.
stats_mag_lim	float	mag	Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats.
mean_var	float		Mean of the variance plane.
n_psf_star	int	count	Number of stars used for PSF model.
psf_area	float	pixel**2	PSF area.
psf_ixx	float		PSF Ixx moment.
psf_ixy	float		PSF Ixy moment.
psf_iyy	float		PSF Iyy moment.
coma_1	float		Coma-like higher-order moment combination, M30 + M12.
coma_2	float		Coma-like higher-order moment combination, M21 + M03.
trefoil_1	float		Trefoil-like higher-order moment combination, M30 - 3*M12.
trefoil_2	float		Trefoil-like higher-order moment combination, 3*M21 - M03.
kurtosis	float		Kurtosis-like higher-order moment combination, M40 + 2*M22 + M04.
e4_1	float		Fourth-order ellipticity-like higher-order moment combination, M40 - M04.
e4_2	float		Fourth-order ellipticity-like higher-order moment combination, 2*(M31 + M13).
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.
psf_ap_flux_delta	float		Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels.
psf_ap_corr_sigma_scaled_delta	float		Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma 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.
z4	float	um	Estimated total defocus (Z4) in OCS, in microns.
z5	float	um	Estimated total oblique primary astigmatism (Z5) in OCS, in microns.
z6	float	um	Estimated total vertical primary astigmatism (Z6) in OCS, in microns.
z7	float	um	Estimated total vertical primary coma (Z7) in OCS, in microns.
z8	float	um	Estimated total horizontal primary coma (Z8) in OCS, in microns.
z9	float	um	Estimated total vertical trefoil (Z9) in OCS, in microns.
z10	float	um	Estimated total oblique trefoil (Z10) in OCS, in microns.
z11	float	um	Estimated total primary spherical (Z11) in OCS, in microns.
z12	float	um	Estimated total vertical secondary astigmatism (Z12) in OCS, in microns.
z13	float	um	Estimated total oblique secondary astigmatism (Z13) in OCS, in microns.
z14	float	um	Estimated total vertical quadrafoil (Z14) in OCS, in microns.
z15	float	um	Estimated total oblique quadrafoil (Z15) in OCS, in microns.
z16	float	um	Estimated total horizontal secondary coma (Z16) in OCS, in microns.
z17	float	um	Estimated total vertical secondary coma (Z17) in OCS, in microns.
z18	float	um	Estimated total oblique secondary trefoil (Z18) in OCS, in microns.
z19	float	um	Estimated total vertical secondary trefoil (Z19) in OCS, in microns.
z20	float	um	Estimated total oblique pentafoil (Z20) in OCS, in microns.
z21	float	um	Estimated total vertical pentafoil (Z21) in OCS, in microns.
z22	float	um	Estimated total secondary spherical (Z22) in OCS, in microns.
z23	float	um	Estimated total tertiary astigmatism (Z23) in OCS, in microns.
z24	float	um	Estimated total tertiary astigmatism (Z24) in OCS, in microns.
z25	float	um	Estimated total oblique secondary quadrafoil (Z25) in OCS, in microns.
z26	float	um	Estimated total vertical secondary quadrafoil (Z26) in OCS, in microns.
z27	float	um	Estimated total hexafoil (Z27) in OCS, in microns.
z28	float	um	Estimated total hexafoil (Z28) in OCS, in microns.
z4_intrinsic	float	um	Intrinsic defocus (Z4) in OCS in microns.
z11_intrinsic	float	um	Intrinsic primary spherical (Z11) in OCS in microns.
z22_intrinsic	float	um	Intrinsic secondary spherical (Z22) in OCS in microns.

---

exposure_flexdata

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

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

Key names and value types used in the exposure_flexdata table

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

---

ccdexposure_flexdata

Flexible key/value metadata about each detector (CCD) within each raw image taken; used for development and engineering purposes

Indexes

Columns	Description	Reference Name
obs_id, key	Explicit index for single-column ID.	idx_ccdexposure_flexdata_obs_id_key

Column Name	Data Type	Unit	Description	UCD	Order	Principal
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
obs_id	long		Unique identifier.
key	string		Name of key.
value	text		Content of value as a string.

---

ccdexposure_flexdata_schema

Key names and value types used in the ccdexposure_flexdata table

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

---

SDM Schemas is maintained by Rubin Observatory.