TAP ivoa.obscore Schema and Examples
Examples
select *
from ivoa.obscore
where target_name like '%CenA%'
order by obs_id descDefinition
Standard ivoa obscore table. One row per MWA observation.
Column Name | Data Type | Description |
|---|---|---|
obs_id | VARCHAR(8) | Observation ID |
dataproduct_type | VARCHAR(50) | Logical data product type |
dataproduct_subtype | VARCHAR(20) | Logical data product subtype |
calib_level | SMALLINT | Calibration level (0, 1, 2, 3, 4) |
target_name | VARCHAR(255) | Astronomical object observed if any |
obs_title | VARCHAR(255) | Title of the data observation |
obs_collection | VARCHAR(255) | Name of the data collection |
obs_creator_name | VARCHAR(255) | Name of the creator of the observation |
obs_publisher_did | VARCHAR(255) | Dataset identifier given by the publisher |
access_url | VARCHAR(255) | URL used to access (download) dataset |
access_format | VARCHAR(50) | File content format |
access_estsize | BIGINT | Estimated size of dataset in kilobytes |
s_ra | DOUBLE | Central right ascension, ICRS |
s_dec | DOUBLE | Central declination, ICRS |
s_fov | DOUBLE | Diameter (bounds) of the covered region |
s_region | REGION | Sky region covered by the data product (expressed in ICRS frame) |
s_resolution | DOUBLE | Spatial resolution of data as FWHM |
s_xel1 | INTEGER | Number of elements along the first spatial axis |
s_xel2 | INTEGER | Number of elements along the second spatial axis |
t_xel | INTEGER | Number of elements along the time axis |
t_min | DOUBLE | Start time in MJD |
t_max | DOUBLE | Stop time in MJD |
t_exptime | DOUBLE | Total exposure time |
t_resolution | DOUBLE | Temporal resolution FWHM |
em_xel | INTEGER | Number of elements along the spectral axis |
em_min | DOUBLE | Start in spectral coordinates |
em_max | DOUBLE | Stop in spectral coordinates |
em_res_power | DOUBLE | Spectral resolving power |
o_ucd | VARCHAR(50) | UCD of observable |
pol_xel | INTEGER | Number of polarization samples |
pol_states | VARCHAR(11) | List of polarization states or NULL if not applicable |
facility_name | VARCHAR(50) | The observatory or facility used to collect the data |
instrument_name | VARCHAR(50) | The name of the instrument used for the acquisition of the observation |
obs_release_date | TIMESTAMP | Date the embargo lifted for this observation |