TAP mwa.observation Schema and Examples
- Greg Sleap
- Dev Null
- Harrison Barlow (Unlicensed)
Owned by Greg Sleap
Examples
Find CenA observations, show most recent first
select * from mwa.observation where obsname like '%CenA%' order by obs_id desc
Definition
Describes details of a single MWA observation.
| Column Name | Data Type | Description |
|---|---|---|
| obs_id | BIGINT | Observation ID- unique identifier of an MWA observation |
| starttime | BIGINT | GPS Start time of observation |
| stoptime | BIGINT | GPS Stop time of observation |
| duration | INTEGER | Length of observation in seconds |
| starttime_mjd | REAL | MJD Start time of observation |
| stoptime_mjd | REAL | MJD Stop time of observation |
| starttime_utc | TIMESTAMP | UTC Start time of observation |
| stoptime_utc | TIMESTAMP | UTC Stop time of observation |
| starttime_mro | TIMESTAMP | Start time of observation (local MRO time) |
| stoptime_mro | TIMESTAMP | Stop time of observation (local MRO time) |
| obsname | VARCHAR(255) | Name of observation |
| creator | VARCHAR(255) | Name of the creator of the observation |
| modtime | TIMESTAMP | Last modification date time of the observation (AWST) |
| mode | VARCHAR(50) | Observing mode (HW_LFILES/MWAX_CORRELATOR are correlator observations; VOLTAGE_START/VOLTAGE_BUFFER/MWAX_VCS are voltage capture system VCS observations) |
| projectid | VARCHAR(50) | Proposal / project identifier |
| projectshortname | VARCHAR(255) | Short name of proposal / project identifier |
| projectdescription | VARCHAR(255) | Description of proposal / project Identifier |
| dataquality | INTEGER | Data quality code |
| dataqualityname | VARCHAR(255) | Data quality description |
| dataqualitycomment | VARCHAR(2048) | Data quality comment - extra hand written comments on this observations data quality |
| deleted_flag | BOOLEAN | Has this observations files been deleted? |
| deletedtime_mro | TIMESTAMP | Date time of observation deletion (local MRO time) |
| vcs_recombined_flag | BOOLEAN | For voltage capture system (VCS) observations- has this observation been recombined? |
| int_time | REAL | Correlator mode integration time (seconds) |
| freq_res | REAL | Correlator mode frequency averaging / fine channel width (kHz) |
| ra | REAL | Right ascension (ICRS, J2000.0) (Uses ra_phase if exists, otherwise ra_pointing) |
| dec | REAL | Declination (ICRS, J2000.0) (Uses dec_phase if exists, otherwise dec_pointing) |
| ra_pointing | REAL | Right ascension (ICRS, J2000.0) of pointing centre at mid-time of the observation (Pointing centre is aligned to the beamformer grid name and grid number) |
| dec_pointing | REAL | Declination (ICRS, J2000.0) of pointing centre at mid-time of the observation (Pointing centre is aligned to the beamformer grid name and grid number) |
| ra_phase_center | REAL | Right ascension (ICRS, J2000.0) of phase centre at mid-time of the observation |
| dec_phase_center | REAL | Declination (ICRS, J2000.0) of phase centre at mid-time of the observation |
| azimuth_pointing | REAL | Azimuth of target at mid-time of the observation (decimal degrees) |
| elevation_pointing | REAL | Elevation of target at mid-time of the observation (decimal degrees) |
| azimuth | REAL | Azimuth, in decimal degrees, of pointing aligned to the beamformer grid name and grid number |
| elevation | REAL | Elevation, in decimal degrees, of pointing aligned to the beamformer grid name and grid number |
| gal_lat | REAL | Galactic latitude, in decimal degrees, of the phase center (or pointing aligned to the beamformer grid name and grid number if no phase centre) |
| gal_long | REAL | Galactic longitude, in decimal degrees, of the phase centre (or pointing aligned to the beamformer grid name and grid number if no phase centre) |
| sky_temp | REAL | Sky temperature (K) |
| calibration | BOOLEAN | Is this an observations used for calibration? |
| calibrators | VARCHAR(255) | If calibration is true what are the calibrator(s) used |
| gridpoint_name | VARCHAR(50) | Name of the pointing grid used by this observation |
| gridpoint_number | INTEGER | Gridpoint number for this Observation |
| local_sidereal_time_deg | REAL | Local sidereal time (decimal degrees) of observation |
| sun_elevation | REAL | Elevation of the Sun at the mid-time of the observation (decimal degrees) |
| sun_pointing_distance | REAL | Distance of the Sun from pointing center at mid-time of the observation (decimal degrees) |
| jupiter_pointing_distance | REAL | Distance of Jupiter from pointing center at mid-time of the observation (decimal degrees) |
| moon_pointing_distance | REAL | Distance of the Moon from pointing center at mid-time of the observation (decimal degrees) |
| channel_numbers_csv | VARCHAR | Receiver coarse channel numbers represented as comma separated values |
| channel_center_frequencies_mhz_csv | VARCHAR | Receiver coarse channel frequencies, in MHz, represented as comma separated values |
| first_channel_number | INTEGER | First frequency channel number |
| center_channel_number | INTEGER | Center frequency channel number |
| last_channel_number | INTEGER | Last frequency channel number |
| first_channel_lowest_frequency_mhz | REAL | Lower bound frequency of first channel in MHz |
| center_frequency_mhz | REAL | Center frequency in MHz |
| last_channel_highest_frequency_mhz | REAL | Upper bound frequency of last channel in MHz |
| channels_are_contiguous | BOOLEAN | Are the coarse channels contiguous? |
| channel_count | INTEGER | Count of channel_width_mhz coarse channels |
| channel_width_mhz | REAL | Width of each coarse channel in MHz |
| mwa_array_configuration | VARCHAR | The configuration of MWA telescope at the time of this observation |
| groupid | BIGINT | All observations with this groupid are part of the same observing session |
| collection_id | BIGINT | This observation is part of a collection with this identifier |
| collection_name | VARCHAR | This observation is part of a collection with this name |
| collection_url | VARCHAR | This observation is part of a collection with this URL |
| iono_qa | REAL | An ionospheric quality metric used by the EoR science working group. |
| tiles_with_bad_states | INTEGER | Number of tiles with bad states |
| tiles_with_bad_pointings | INTEGER | Number of tiles with bad pointings |
| tiles_with_bad_freqs | INTEGER | Number of tiles with bad frequencies |
| tiles_with_bad_gains | INTEGER | Number of tiles with bad gains |
| tiles_with_bad_beamshape | INTEGER | Number of tiles with bad beamshape (where more than 1 dipole is bad) |
| tiles_flagged | INTEGER | Number of tiles flagged |
| bad_tiles | INTEGER | Total tiles minus good tiles (tiles in bad or unknown state) |
| good_tiles | INTEGER | Number of good tiles |
| total_tiles | INTEGER | Total number of tiles in this observation |
| vcs_files_raw_total | BIGINT | Total number of VCS raw files for this observation |
| vcs_files_raw_archived | BIGINT | Total number of VCS raw files archived for this observation |
| vcs_files_ics_archived | BIGINT | Total number of VCS incoherent sum (ICS) files archived for this observation |
| vcs_files_tar_archived | BIGINT | Total number of VCS recombined (tar) files (or MWAX subfiles) archived for this observation |
| gpubox_files_total | BIGINT | Total number of gpubox (visibility) files produced in this observation |
| gpubox_files_archived | BIGINT | Total number of gpubox (visibility) files archived for this observation |
| flag_files_exist | BOOLEAN | Do precomputed RFI flag files exist for this observation (compatible with aoflagger) |
| total_archived_data_files | BIGINT | Total files archived for this observation (excluding deleted files, metafits_ppds and flags) |
| total_archived_data_bytes | BIGINT | Total bytes archived for this observation (excluding deleted files, metafits_ppds and flags) |
| total_archived_files | BIGINT | Total files archived for this observation (excluding deleted files) |
| total_archived_bytes | BIGINT | Total bytes archived for this observation (excluding deleted files) |
| files_deleted | BIGINT | Total number of files deleted for this observation |
| files_deleted_bytes | BIGINT | Total bytes deleted for this observation |
| data_files_summary | VARCHAR(255) | Summary of data files. For correlator: gpubox files archived. For VCS: archived raw seconds/archived recombined seconds |
| downloads | INTEGER | Total number of downloads of this observation |
| first_download_datetime_mro | TIMESTAMP | Date time the observation was first downloaded (local MRO time) |
| last_download_datetime_mro | TIMESTAMP | Date time of most recent download of this observation (local MRO time) |
| days_since_last_download | INTEGER | Days since last download of this observation |
| days_from_obs_to_first_download | INTEGER | Days elapsed between the observation and first download |
| downloaded_bytes | BIGINT | Total bytes downloaded for this observation |
| delaymode_name | VARCHAR(255) | Delay mode name (see delaymode_description for info) |
| delaymode_description | VARCHAR(255) | Description of the delay mode used in this observation (see cable_delays, geometric_dlays and calibration_delays fields for more info) |
| cable_delays | INTEGER | Cable delay mode applied (see cable_delays_description for info) |
| cable_delays_description | VARCHAR(255) | Descripition of cable delay mode applied to this observation |
| geometric_delays | INTEGER | Geometric delay mode applied (see geometric_delays_description for info) |
| geometric_delays_description | VARCHAR(255) | Descripition of geometric delay mode applied to this observation |
| calibration_delays | BOOLEAN | Have real-time calibration delays been applied in this observation? |
| oversampled_flag | BOOLEAN | Does this observation have oversampled coarse channels? |
| deripple_flag | BOOLEAN | Has a de-ripple been applied to the coarse channels of this observation? |
| deripple_params | VARCHAR(255) | If de-ripple has been applied, which de-ripple was applied? |
| deletion_pending_flag | BOOLEAN | Has this observation been marked for future deletion? |