TAP ivoa.obscore Schema and Examples
- Greg Sleap
Owned by Greg Sleap
Examples
select * from ivoa.obscore where target_name like '%CenA%' order by obs_id desc
Definition
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 |