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?

MWA Telescope

TAP mwa.observation Schema and Examples

Analytics

Examples

Definition

Related content