ConsDB - 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

Search:

Column Name	Data Type	Unit	Description	UCD
air_temp	float		Outside air temperature in degC.	phys.temperature
airmass	float		Airmass of the observed line of sight at the middle of the exposure.	obs.airMass
altitude	float	deg	Altitude of focal plane center at the middle 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_start	float	deg	Altitude of focal plane center at the start of the exposure.	pos.az.alt
azimuth	float	deg	Azimuth of focal plane center at the middle 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_start	float	deg	Azimuth of focal plane center at the start of the exposure.	pos.az.azi
band	string		Name of the band used to take the exposure. Abstract filter that is not associated with a particular instrument.
controller	string		The abbreviation of the controller used for the observation (O, C).
cur_index	int		Number (1-based) of the observation within its group.
dark_time	float	s	Duration from last clear to readout, accurate to 10ms.	time.interval
day_obs	int		Day of observation.	meta.id.part
dimm_seeing	float	arcsec	Seeing as measured by external DIMM (FWHM).
dome_azimuth	float		Dome azimuth.
emulated	boolean		True if the exposure was taken in emulation mode.
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
exp_time	float	s	Spatially-averaged duration of exposure, accurate to 10ms.	time.interval
exposure_id	long		Unique identifier.
exposure_name	string		Official name of the exposure.
focus_z	float		Focus Z position.
group_id	string		Identifier for the group that this exposure is part of.
humidity	float		Outside relative humidity.
img_type	string		Type of exposure taken.
max_index	int		Expected number of observations within the group.
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
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
observation_reason	string		Reason for the observation.
physical_filter	string		ID of physical filter, the filter associated with a particular instrument.
pressure	float	Pa	Outside air pressure.
s_dec	double	deg	Central Spatial Position in ICRS; Declination of targeted focal plane center.	pos.eq.dec
s_ra	double	deg	Central Spatial Position in ICRS; Right ascension of targeted focal plane center.	pos.eq.ra
s_region	string		Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html).	pos.outline;obs.field
science_program	string		Science program.
seq_num	int		Sequence number.	meta.id.part
shut_lower	float		Dome dropout door opening percentage.
shut_time	float	s	Spatially-averaged shutter-open duration, accurate to 10ms.	time.interval
shut_upper	float		Dome main door opening percentage.
simulated	boolean		Were any control system components simulated?
sky_rotation	double	deg	Targeted sky rotation angle.	pos.posAng
target_name	string		Target of the observation.
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.
wind_dir	float	deg	Wind direction.
wind_speed	float	m/s	Outside wind speed.
zenith_distance	float	deg	Zenith distance at the middle of the exposure.	pos.az.zd
zenith_distance_end	float	deg	Zenith distance at the end of the exposure.	pos.az.zd
zenith_distance_start	float	deg	Zenith distance at the start of the exposure.	pos.az.zd

Showing 1 to 51 of 51 entries

exposure_flexdata

Search:

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

Showing 1 to 5 of 5 entries

exposure_flexdata_schema

Search:

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

Showing 1 to 5 of 5 entries

ccdexposure

Search:

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

Showing 1 to 6 of 6 entries

ccdexposure_camera

Search:

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

Showing 1 to 3 of 3 entries

ccdexposure_flexdata

Search:

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

Showing 1 to 3 of 3 entries

ccdexposure_flexdata_schema

Search:

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

Showing 1 to 5 of 5 entries

visit1

Search:

Column Name	Data Type	Unit	Description	UCD
air_temp	float		Outside air temperature in degC.	phys.temperature
airmass	float		Airmass of the observed line of sight at the middle of the visit.	obs.airMass
altitude	float	deg	Altitude of focal plane center at the middle 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_start	float	deg	Altitude of focal plane center at the start of the visit.	pos.az.alt
azimuth	float	deg	Azimuth of focal plane center at the middle 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_start	float	deg	Azimuth of focal plane center at the start of the visit.	pos.az.azi
band	string		Name of the band used to take the visit. Abstract filter that is not associated with a particular instrument.
controller	string		The abbreviation of the controller used for the observation (O, C).
cur_index	int		Number (1-based) of the observation within its group.
dark_time	float	s	Duration from last clear to readout, accurate to 10ms.	time.interval
day_obs	int		Day of observation.	meta.id.part
dimm_seeing	float	arcsec	Seeing as measured by external DIMM (FWHM).
emulated	boolean		True if the visit was taken in emulation mode.
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
exp_time	float	s	Spatially-averaged duration of visit, accurate to 10ms.	time.interval
exposure_name	string		Official name of the exposure mapped to this visit by the 1-to-1 visit system.
focus_z	float		Focus Z position.
group_id	string		Identifier for the group that this visit is part of.
humidity	float		Outside relative humidity.
img_type	string		Type of visit taken.
max_index	int		Expected number of observations within the group.
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
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
observation_reason	string		Reason for the observation.
physical_filter	string		ID of physical filter, the filter associated with a particular instrument.
pressure	float	Pa	Outside air pressure.
s_dec	double	deg	Central Spatial Position in ICRS; Declination of targeted focal plane center.	pos.eq.dec
s_ra	double	deg	Central Spatial Position in ICRS; Right ascension of targeted focal plane center.	pos.eq.ra
s_region	string		Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html).	pos.outline;obs.field
science_program	string		Science program.
seq_num	int		Sequence number.	meta.id.part
shut_lower	float		Dome dropout door opening percentage.
shut_time	float	s	Spatially-averaged shutter-open duration, accurate to 10ms.	time.interval
shut_upper	float		Dome main door opening percentage.
simulated	boolean		Were any control system components simulated?
sky_rotation	double	deg	Targeted sky rotation angle.	pos.posAng
target_name	string		Target of the observation.
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.
visit_id	long		Unique identifier.
wind_dir	float	deg	Wind direction.
wind_speed	float	m/s	Outside wind speed.
zenith_distance	float	deg	Zenith distance at the middle of the visit.	pos.az.zd
zenith_distance_end	float	deg	Zenith distance at the end of the visit.	pos.az.zd
zenith_distance_start	float	deg	Zenith distance at the start of the visit.	pos.az.zd

Showing 1 to 50 of 50 entries

visit1_quicklook

Search:

Column Name	Data Type	Unit	Description	UCD
astrom_offset_mean	float	arcsec	Mean offset of astrometric calibration matches.
astrom_offset_std	float	arcsec	Standard deviation of offsets of astrometric calibration matches.
day_obs	int		Day of observation.	meta.id.part
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.
high_snr_source_count	int	count	Count of high signal-to-noise-ratio sources.
low_snr_source_count	int	count	Count of low signal-to-noise-ratio sources.
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_inputs	int		Number of CCDs used to compute the visit aggregates.
n_psf_star	int		Number of stars used for PSF model.
pixel_scale	float	arcsec/pixel	Measured detector pixel scale.
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.
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_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.
seeing_zenith_500nm	double		Measured PSF sigma, corrected to 500nm and an airmass of 1.
seq_num	int		Sequence number.	meta.id.part
sky_bg	float		Average sky background.
sky_noise	float		RMS noise of the sky background.
stats_mag_lim	float	mag	Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats.
visit_id	long		Unique identifier.
zero_point	float		Photometric zero point.

Showing 1 to 36 of 36 entries

exposure_quicklook

Search:

Column Name	Data Type	Unit	Description	UCD
day_obs	int		Day of observation.	meta.id.part
exposure_id	long		Unique identifier.
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.
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.
postisr_pixel_median	float	electron	Median postISR pixel value.
seq_num	int		Sequence number.	meta.id.part

Showing 1 to 11 of 11 entries

ccdvisit1

Search:

Column Name	Data Type	Description	UCD
ccdvisit_id	long	Unique identifier.	meta.id
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
visit_id	long	Identifier of the visit.	meta.id.part

Showing 1 to 4 of 4 entries

ccdvisit1_quicklook

Search:

Column Name	Data Type	Unit	Description	UCD
astrom_offset_mean	float	arcsec	Mean offset of astrometric calibration matches.
astrom_offset_std	float	arcsec	Standard deviation of offsets of astrometric calibration matches.
ccdvisit_id	long		Unique identifier.
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.
max_dist_to_nearest_psf	float	pixel	Maximum distance of an unmasked pixel to its nearest model PSF star.
mean_var	float		Mean of the variance plane.
n_psf_star	int	count	Number of stars used for PSF model.
photometric_calib	float	nJy/count	Conversion from DN to nanojansky.
pixel_scale	float	arcsec/pixel	Measured detector pixel scale.
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.
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_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 model second-moments determinant radius (center of chip).
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	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.
s_dec	double	deg	Central Spatial Position in ICRS; Computed declination of CCD center.	pos.eq.dec
s_ra	double	deg	Central Spatial Position in ICRS; Computed right ascension of CCD center.	pos.eq.ra
seeing_zenith_500nm	double		Measured PSF sigma, corrected to 500nm and an airmass of 1.
sky_bg	float		Average sky background.
sky_noise	float		RMS noise of the sky background.
zenith_distance	float		Zenith distance at observation mid-point.
zero_point	float		Photometric zero point.

Showing 1 to 34 of 34 entries

SDM Schemas is maintained by Rubin Observatory.