TAP mwa.observation Schema and Examples
Examples
Find CenA observations, show most recent first
select *
from mwa.observation
where obsname like '%CenA%'
order by obs_id descDefinition
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 Legacy VCS raw files for this observation |
vcs_files_raw_archived | BIGINT | Total number of Legacy VCS raw files archived for this observation |
vcs_files_ics_archived | BIGINT | Total number of Legacy VCS incoherent sum (ICS) files archived for this observation |
vcs_files_tar_archived | BIGINT | Total number of Legacy VCS recombined (tar) files (or MWAX subfiles) archived for this observation |
vcs_files_sub_archived | BIGINT | Total number of MWAX VCS subfiles archived for this observation |
filterbank_files_archived | BIGINT | Total number of incoherent beamformer filterbank files archived for this observation |
vdif_files_archived | BIGINT | Total number of vdif (coherent beamformed files) 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) |