visit1_quicklook

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

Columns

name datatype description unit nullable ivoa:ucd tap:std votable:utype
visit_id foreign key long Unique identifier. false 0
day_obs primary key foreign key int Day of observation. false meta.id.part 0
seq_num primary key foreign key int Sequence number. false meta.id.part 0
n_inputs int Number of CCDs used to compute the visit aggregates. count true 0
pixel_scale_min float Measured detector pixel scale (minimum across all detectors). arcsec/pixel true 0
pixel_scale_max float Measured detector pixel scale (maximum across all detectors). arcsec/pixel true 0
pixel_scale_median float Measured detector pixel scale (median across all detectors). arcsec/pixel true 0
astrom_offset_mean_min float Mean offset of astrometric calibration matches (minimum across all detectors). arcsec true 0
astrom_offset_mean_max float Mean offset of astrometric calibration matches (maximum across all detectors). arcsec true 0
astrom_offset_mean_median float Mean offset of astrometric calibration matches (median across all detectors). arcsec true 0
astrom_offset_std_min float Standard deviation of offsets of astrometric calibration matches (minimum across all detectors). arcsec true 0
astrom_offset_std_max float Standard deviation of offsets of astrometric calibration matches (maximum across all detectors). arcsec true 0
astrom_offset_std_median float Standard deviation of offsets of astrometric calibration matches (median across all detectors). arcsec true 0
astrom_ra double 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. deg true pos.eq.ra 1 Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1
astrom_dec double 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. deg true pos.eq.dec 1 Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2
astrom_sky_rotation double Fitted sky rotation angle based on plate solving. This quantity can be compared to #exposure.sky_rotation, the targeted sky rotation angle. deg true pos.posAng 0
eff_time_min float Effective exposure time (minimum across all detectors). s true 0
eff_time_max float Effective exposure time (maximum across all detectors). s true 0
eff_time_median float Effective exposure time (median across all detectors). s true 0
eff_time_psf_sigma_scale_min float Scale factor for effective exposure time based on PSF sigma (minimum across all detectors). true 0
eff_time_psf_sigma_scale_max float Scale factor for effective exposure time based on PSF sigma (maximum across all detectors). true 0
eff_time_psf_sigma_scale_median float Scale factor for effective exposure time based on PSF sigma (median across all detectors). true 0
eff_time_sky_bg_scale_min float Scale factor for effective exposure time based on sky background (minimum across all detectors). true 0
eff_time_sky_bg_scale_max float Scale factor for effective exposure time based on sky background (maximum across all detectors). true 0
eff_time_sky_bg_scale_median float Scale factor for effective exposure time based on sky background (median across all detectors). true 0
eff_time_zero_point_scale_min float Scale factor for effective exposure time based on zero point (minimum across all detectors). true 0
eff_time_zero_point_scale_max float Scale factor for effective exposure time based on zero point (maximum across all detectors). true 0
eff_time_zero_point_scale_median float Scale factor for effective exposure time based on zero point (median across all detectors). true 0
stats_mag_lim_min float Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (minimum across all detectors). mag true 0
stats_mag_lim_max float Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (maximum across all detectors). mag true 0
stats_mag_lim_median float Magnitude limit at fixed SNR (default SNR=5) calculated from exposure summary stats (median across all detectors). mag true 0
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). true 0
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). true 0
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). true 0
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). true 0
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). true 0
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). true 0
max_dist_to_nearest_psf_min float Maximum distance of an unmasked pixel to its nearest model PSF star (minimum across all detectors). pixel true 0
max_dist_to_nearest_psf_max float Maximum distance of an unmasked pixel to its nearest model PSF star (maximum across all detectors). pixel true 0
max_dist_to_nearest_psf_median float Maximum distance of an unmasked pixel to its nearest model PSF star (median across all detectors). pixel true 0
mean_var_min float Mean of the variance plane (minimum across all detectors). count**2 true phot;phys.electron 0
mean_var_max float Mean of the variance plane (maximum across all detectors). count**2 true phot;phys.electron 0
mean_var_median float Mean of the variance plane (median across all detectors). count**2 true phot;phys.electron 0
n_psf_star_min int Number of stars used for PSF model (minimum across all detectors). count true 0
n_psf_star_max int Number of stars used for PSF model (maximum across all detectors). count true 0
n_psf_star_median int Number of stars used for PSF model (median across all detectors). count true 0
n_psf_star_total int Number of stars used for PSF model (total across all detectors). count true 0
psf_area_min float PSF area (minimum across all detectors). pixel**2 true 0
psf_area_max float PSF area (maximum across all detectors). pixel**2 true 0
psf_area_median float PSF area (median across all detectors). pixel**2 true 0
psf_ixx_min float PSF Ixx moment (minimum across all detectors). pixel**2 true 0
psf_ixx_max float PSF Ixx moment (maximum across all detectors). pixel**2 true 0
psf_ixx_median float PSF Ixx moment (median across all detectors). pixel**2 true 0
psf_ixy_min float PSF Ixy moment (minimum across all detectors). pixel**2 true 0
psf_ixy_max float PSF Ixy moment (maximum across all detectors). pixel**2 true 0
psf_ixy_median float PSF Ixy moment (median across all detectors). pixel**2 true 0
psf_iyy_min float PSF Iyy moment (minimum across all detectors). pixel**2 true 0
psf_iyy_max float PSF Iyy moment (maximum across all detectors). pixel**2 true 0
psf_iyy_median float PSF Iyy moment (median across all detectors). pixel**2 true 0
psf_sigma_min float PSF sigma (minimum across all detectors). pixel true 0
psf_sigma_max float PSF sigma (maximum across all detectors). pixel true 0
psf_sigma_median float PSF sigma (median across all detectors). pixel true 0
psf_star_delta_e1_median_min float Median E1 residual (starE1 - psfE1) for PSF stars (minimum across all detectors). true 0
psf_star_delta_e1_median_max float Median E1 residual (starE1 - psfE1) for PSF stars (maximum across all detectors). true 0
psf_star_delta_e1_median_median float Median E1 residual (starE1 - psfE1) for PSF stars (median across all detectors). true 0
psf_star_delta_e1_scatter_min float Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (minimum across all detectors). true 0
psf_star_delta_e1_scatter_max float Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (maximum across all detectors). true 0
psf_star_delta_e1_scatter_median float Scatter (via MAD) of E1 residual (starE1 - psfE1) for PSF stars (median across all detectors). true 0
psf_star_delta_e2_median_min float Median E2 residual (starE2 - psfE2) for PSF stars (minimum across all detectors). true 0
psf_star_delta_e2_median_max float Median E2 residual (starE2 - psfE2) for PSF stars (maximum across all detectors). true 0
psf_star_delta_e2_median_median float Median E2 residual (starE2 - psfE2) for PSF stars (median across all detectors). true 0
psf_star_delta_e2_scatter_min float Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (minimum across all detectors). true 0
psf_star_delta_e2_scatter_max float Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (maximum across all detectors). true 0
psf_star_delta_e2_scatter_median float Scatter (via MAD) of E2 residual (starE2 - psfE2) for PSF stars (median across all detectors). true 0
psf_star_delta_size_median_min float Median size residual (starSize - psfSize) for PSF stars (minimum across all detectors). pixel true 0
psf_star_delta_size_median_max float Median size residual (starSize - psfSize) for PSF stars (maximum across all detectors). pixel true 0
psf_star_delta_size_median_median float Median size residual (starSize - psfSize) for PSF stars (median across all detectors). pixel true 0
psf_star_delta_size_scatter_min float Scatter (via MAD) of size residual (starSize - psfSize) for stars (minimum across all detectors). pixel true 0
psf_star_delta_size_scatter_max float Scatter (via MAD) of size residual (starSize - psfSize) for stars (maximum across all detectors). pixel true 0
psf_star_delta_size_scatter_median float Scatter (via MAD) of size residual (starSize - psfSize) for stars (median across all detectors). pixel true 0
psf_star_scaled_delta_size_scatter_min float Scatter (via MAD) of size residual scaled by median size squared (minimum across all detectors). true 0
psf_star_scaled_delta_size_scatter_max float Scatter (via MAD) of size residual scaled by median size squared (maximum across all detectors). true 0
psf_star_scaled_delta_size_scatter_median float Scatter (via MAD) of size residual scaled by median size squared (median across all detectors). true 0
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). pixel true 0
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). pixel true 0
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). pixel true 0
sky_bg_min float Average sky background (minimum across all detectors). count true phot;phys.electron 0
sky_bg_max float Average sky background (maximum across all detectors). count true phot;phys.electron 0
sky_bg_median float Average sky background (median across all detectors). count true phot;phys.electron 0
sky_noise_min float RMS noise of the sky background (minimum across all detectors). count true phot;phys.electron 0
sky_noise_max float RMS noise of the sky background (maximum across all detectors). count true phot;phys.electron 0
sky_noise_median float RMS noise of the sky background (median across all detectors). count true phot;phys.electron 0
seeing_zenith_500nm_min double Measured PSF sigma, corrected to 500nm and an airmass of 1 (minimum across all detectors). true 0
seeing_zenith_500nm_max double Measured PSF sigma, corrected to 500nm and an airmass of 1 (maximum across all detectors). true 0
seeing_zenith_500nm_median double Measured PSF sigma, corrected to 500nm and an airmass of 1 (median across all detectors). true 0
zero_point_min float Photometric zero point (minimum across all detectors). mag true 0
zero_point_max float Photometric zero point (maximum across all detectors). mag true 0
zero_point_median float Photometric zero point (median across all detectors). mag true 0
low_snr_source_count_min int Count of low signal-to-noise-ratio sources (minimum across all detectors). count true 0
low_snr_source_count_max int Count of low signal-to-noise-ratio sources (maximum across all detectors). count true 0
low_snr_source_count_median int Count of low signal-to-noise-ratio sources (median across all detectors). count true 0
low_snr_source_count_total int Count of low signal-to-noise-ratio sources (total across all detectors). count true 0
high_snr_source_count_min int Count of high signal-to-noise-ratio sources (minimum across all detectors). count true 0
high_snr_source_count_max int Count of high signal-to-noise-ratio sources (maximum across all detectors). count true 0
high_snr_source_count_median int Count of high signal-to-noise-ratio sources (median across all detectors). count true 0
high_snr_source_count_total int Count of high signal-to-noise-ratio sources (total across all detectors). count true 0
z4 float Estimated defocus (Z4), mean estimated across four corners in microns. um true 0
z5 float Estimated oblique primary astigmatism (Z5), mean estimated across four corners in microns. um true 0
z6 float Estimated vertical primary astigmatism (Z6), mean estimated across four corners in microns. um true 0
z7 float Estimated vertical primary coma (Z7), mean estimated across four corners in microns. um true 0
z8 float Estimated horizontal primary coma (Z8), mean estimated across four corners in microns. um true 0
z9 float Estimated vertical trefoil (Z9), mean estimated across four corners in microns. um true 0
z10 float Estimated horizontal trefoil (Z10), mean estimated across four corners in microns. um true 0
z11 float Estimated primary spherical (Z11), mean estimated across four corners in microns. um true 0
z12 float Estimated vertical secondary astigmatism (Z12), mean estimated across four corners in microns. um true 0
z13 float Estimated oblique secondary astigmatism (Z13), mean estimated across four corners in microns. um true 0
z14 float Estimated vertical quadrafoil (Z14), mean estimated across four corners in microns. um true 0
z15 float Estimated horizontal quadrafoil (Z15), mean estimated across four corners in microns. um true 0
z16 float Estimated horizontal secondary coma (Z16), mean estimated across four corners in microns. um true 0
z17 float Estimated vertical secondary coma (Z17), mean estimated across four corners in microns. um true 0
z18 float Estimated oblique secondary trefoil (Z18), mean estimated across four corners in microns. um true 0
z19 float Estimated vertical secondary trefoil (Z19), mean estimated across four corners in microns. um true 0
z20 float Estimated oblique pentafoil (Z20), mean estimated across four corners in microns. um true 0
z21 float Estimated vertical pentafoil (Z21), mean estimated across four corners in microns. um true 0
z22 float Estimated secondary spherical (Z22), mean estimated across four corners in microns. um true 0
z23 float Estimated tertiary astimgatism (Z23), mean estimated across four corners in microns. um true 0
z24 float Estimated tertiary astimgatism (Z24), mean estimated across four corners in microns. um true 0
z25 float Estimated oblique secondary quadrafoil (Z25), mean estimated across four corners in microns. um true 0
z26 float Estimated vertical secondary quadrafoil (Z26), mean estimated across four corners in microns. um true 0
z27 float Estimated hexafoil (Z27), mean estimated across four corners in microns. um true 0
z28 float Estimated hexafoil (Z28), mean estimated across four corners in microns. um true 0
ringss_seeing float Atmospheric seeing as measured by external SOAR/Gemini RINGSS (FWHM) arcsec true 0
aos_fwhm float Estimated contribution of the optical system to the overall seeing (FWHM) using the measured zernike coefficients. arcsec true 0
donut_blur_fwhm float Estimated contribution of the atmosphere to the overall seeing (FWHM) derived from danish donut forward modeling. arcsec true 0
physical_rotator_angle double Physical rotator angle in degrees. deg true pos.posAng 0
guider_exp_time float Total guider exposure time across all stamps. s true time.interval 0
guider_stamp_exp_time float The delivered guider exposure time for a single stamp. s true time.interval 0
guider_n_stamps_expected int Number of expected guider stamps. count true 0
guider_n_stamps_delivered int Number of delivered guider stamps. count true 0
guider_roi_cols float Number of columns in the guider ROI, in pixels. pixel true 0
guider_roi_rows float Number of rows in the guider ROI, in pixels. pixel true 0
guider_n_tracked_stars int Number of tracked stars. count true 0
guider_n_measurements int Number of tracked star measurements. count true 0
guider_altitude_drift float Altitude drift over exposure in arcsec. arcsec true 0
guider_altitude_standard_deviation float Standard deviation of altitude over exposure. arcsec true 0
guider_altitude_rms_detrended float RMS of altitude after trendline is subtracted. arcsec true 0
guider_azimuth_drift float Azimuth drift over exposure in arcsec. arcsec true 0
guider_azimuth_standard_deviation float Standard deviation of azimuth over exposure. arcsec true 0
guider_azimuth_rms_detrended float RMS of azimuth after trendline is subtracted. arcsec true 0
guider_focalplane_theta_drift float Focal plane theta drift over exposure in arcsec. arcsec true 0
guider_focalplane_theta_standard_deviation float Standard deviation of focal plane theta over exposure. arcsec true 0
guider_focalplane_theta_rms_detrended float RMS of focal plane theta after trendline is subtracted. arcsec true 0
guider_magnitude_drift float Magnitude drift over exposure in magnitudes. mag true 0
guider_magnitude_standard_deviation float Standard deviation of magnitude over exposure. mag true 0
guider_magnitude_rms_detrended float RMS of magnitude after trendline is subtracted. mag true 0
guider_psf_fwhm_start float PSF FWHM of the guider star at the start of the exposure. arcsec true 0
guider_psf_fwhm_drift float PSF FWHM drift over exposure in arcsec. arcsec true 0
guider_psf_fwhm_standard_deviation float Standard deviation of PSF FWHM over exposure. arcsec true 0
guider_psf_fwhm_rms_detrended float RMS of PSF FWHM after trendline is subtracted. arcsec true 0
guider_psf_fwhm float Mean PSF FWHM for all measurements over the exposure. arcsec true 0
guider_e1_mean float Mean second moment e1 for all measurements over the exposure. true 0
guider_e2_mean float Mean second moment e2 for all measurements over the exposure. true 0
guider_ground_layer_seeing float Ground layer seeing calculated with guider exposure. arcsec true 0
guider_mid_layer_seeing float Mid layer seeing calculated with guider exposure. arcsec true 0
guider_free_seeing float Free atmosphere seeing calculated with guider exposure. arcsec true 0
guider_total_seeing float Total seeing calculated with guider exposure. arcsec true 0

Constraints

Constraint Type Definition Description
fk_visit1_quicklook_obs_id ForeignKey
Columns: visit_id
References: exposure.exposure_id
 Quicklook visit_id must be an Exposure exposure_id.
fk_visit1_quicklook_ds ForeignKey
Columns: day_obs, seq_num
 Quicklook day_obs must be an Exposure day_obs.
fk_visit1_quicklook_visit_id_ds ForeignKey Quicklook visit_id/day_obs/seq_num must match an Exposure.