...
s_region is a parameter in the ObsCore standard of IVOA, and ADQL allows for powerful query functions such as intersections. s_region introduces a pgSphere variable of type spoly providing description of the observed area on a sphere, which allows for accurate searches.
This can be used to provide footprint of spatially extended data either on the sky or on a planetary surface (as long as it is reasonably ellipsoidal). Use with 3D shape models needs study (should fail with concave 3D shapes such as 67P). Also study how concave footprints/polygons are handled, TBC.
The use in the context of GIS also has to be studied.
...
6) Support of coordinated observations
The target_time parameter now provides _min/max parameters now provide observation time in the reference frame of the target. This is intended to facilitate the cross-correlation of observations from different locations, e.g., telescopic observations in support of space missions, or multi-spacecraft campaigns.
...
Name, v2 | Must be filled? | Name, v1 | SQL type | Unit / Format / Range | Description | UCD Please comment! | UCD in Obscore 1.1 (30/3/2016 version) | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EPNCore mandatory parameters |
|
|
|
| Current value | — ? : closest sense _ : N/A in ObsCore | ||||||||
granule_uid | Y | index | Text |
| Internal table row index | meta.id meta.id;meta.dataset | meta.id | |||||||
granule_gid | Y | Text |
| Common to granules of same type (e.g. same map projection, or geometry data products). Can be alphanum. | meta.id | meta.id | ||||||||
obs_id | Y | Text |
| Associates granules derived from the same data (e.g. various representations / processing levels). Can be alphanum., may be the ID of original observation. | meta.id meta.id;obs | meta.id | ||||||||
_ | resource_type | Text |
| Can be dataset or granule | (meta.code.class) | _ | ||||||||
_ | dataset_id | Text |
| Dataset identification & granule reference | (meta.id) | _ | ||||||||
dataproduct_type | Y | dataproduct_type | Text |
| Organization of the data product, from enumerated list | meta.code.class | meta.id | |||||||
target_name | Y (TBC) | target_name | Text |
| Standard IAU name of target (from a list related to target class), case sensitive | meta.id;src | meta.id;src | |||||||
target_class | Y | target_class | Text |
| Type of target, from enumerated list | meta.code.class;src src.class | src.class | |||||||
time_min | time_min | Double | d (date as JD) | Acquisition start time (in JD). UTC measured at time_origin location (default is observer's frame) | time.start time.start;obs | time.start;obs.exposure | ||||||||
time_max | time_max | Double | d (date as JD) | Acquisition stop time (in JD). UTC measured at time_origin location (default is observer's frame) | time.end time.end;obs | time.end;obs.exposure | ||||||||
time_sampling_step_min | time_sampling_step_min | Double | s | Min time sampling step | time.interval;stat.min | time.resolution — ? | ||||||||
time_sampling_step_max | time_sampling_step_max | Double | s | Max time sampling step | time.interval;stat.max | |||||||||
time_exp_min | time_exp_min | Double | s | Min integration time | time.duration;obs.exposure;stat.min | time.duration;obs.exposure | ||||||||
time_exp_max | time_exp_max | Double | s | Max integration time | time.duration;obs.exposure;stat.max | |||||||||
spectral_range_min | spectral_range_min | Double | Hz | Min spectral range (frequency) | em.freq;stat.min | em.wl;stat.min (always as wl) | Always as freq | |||||||
spectral_range_max | spectral_range_max | Double | Hz | Max spectral range (frequency) | em.freq;stat.max | em.wl;stat.max | ||||||||
spectral_sampling_step_min | spectral_sampling_step_min | Double | Hz | Min spectral sampling step | em.freq.step;stat.min | meta.number | ||||||||
spectral_sampling_step_max | spectral_sampling_step_max | Double | Hz | Max spectral sampling step | em.freq.step;stat.max | meta.number | ||||||||
spectral_resolution_min | spectral_resolution_min | Double | Hz | Min spectral resolution | spect.resolution;stat.min | spect.resolution | ||||||||
spectral_resolution_max | spectral_resolution_max | Double | Hz | Max spectral resolution | spect.resolution;stat.max | |||||||||
c1min | c1min | Double | (1) Longitude from 0. to 359.9999 RA from 0. to 23.9999 | Min of first coordinate | pos;stat.min pos.distance;stat.min pos.eq.ra;stat.min for celestial pos.bodyrc.lon;stat.min for body pos.cartesian.x;stat.min for Cartesian pos.healpix for healpix (with 2 parameters? - weird) | pos.eq.ra | RA-DEC only | |||||||
c1max | c1max | Double | (1) Latitude from -89.9999 to +89.9999 | Max of first coordinate | pos;stat.max | |||||||||
c2min | c2min | Double | (1) | Min of second coordinate | pos;stat.min pos.angDistance;stat.min pos.eq.dec;stat.min for celestial pos.bodyrc.lat;stat.min for body pos.cartesian.y;stat.min for Cartesian | pos.eq.dec | ||||||||
c2max | c2max | Double | (1) | Max of second coordinate | pos;stat.max | |||||||||
c3min | c3min | Double | (1) | Min of third coordinate | pos;stat.min pos.AngDistance;stat.min pos.distance;stat.min for cylindrical? pos.distance;stat.min for celestial pos.bodyrc.alt;stat.min for body? (from surface only, implicitly from reference level) pos.cartesian.z;stat.min for Cartesian | |||||||||
c3max | c3max | Double | (1) | Max of third coordinate | pos;stat.max | |||||||||
s_region |
| spoly | PgSphere spoly | ObsCore-like footprint,valid for celestial, spherical, or body-fixed frames. | instr.fov phys.outline;obs.field | phys.outline;obs.field | ObsCore value recently updated (was phys.angArea;obs) Frame may be identified in q.rd (UNKNOWNFrame) Do we need another param for GIS interface? | |||||||
c1_resol_min | c1_resol_min | Double | (1) | Min resolution in first coordinate | pos.resolution;stat.min | pos.angResolution;stat.min | (UCD is deprecated, but needed!) | |||||||
c1_resol_max | c1_resol_max | Double | (1) | Max resolution in first coordinate | pos.resolution;stat.max | pos.angResolution;stat.max | (UCD is deprecated, but needed!) | |||||||
c2_resol_min | c2_resol_min | Double | (1) | Min resolution in second coordinate | pos.resolution;stat.min | (UCD is deprecated, but needed!) | ||||||||
c2_resol_max | c2_resol_max | Double | (1) | Max resolution in second coordinate | pos.resolution;stat.max | (UCD is deprecated, but needed!) | ||||||||
c3_resol_min | c3_resol_min | Double | (1) | Min resolution in third coordinate | pos.resolution;stat.min | (UCD is deprecated, but needed!) | ||||||||
c3_resol_max | c3_resol_max | Double | (1) | Max resolution in third coordinate | pos.resolution;stat.max | (UCD is deprecated, but needed!) | ||||||||
spatial_frame_type | spatial_frame_type | Text | (1) | Flavor of coordinate system, defines the nature of coordinates. From enumerated list | meta.code.class;pos.frame | _ | ||||||||
incidence_min | incidence_min | Double | deg | Min incidence angle (solar zenithal angle) | pos.posAng;stat.min | _ | ||||||||
incidence_max | incidence_max | Double | deg | Max incidence angle (solar zenithal angle) | pos.posAng;stat.max | _ | ||||||||
emergence_min | emergence_min | Double | deg | Min emergence angle | pos.posAng;stat.min | _ | ||||||||
emergence_max | emergence_max | Double | deg | Max emergence angle | pos.posAng;stat.max | _ | ||||||||
phase_min | phase_min | Double | deg | Min phase angle | pos.phaseAng;stat.min | |||||||||
phase_max | phase_max | Double | deg | Max phase angle | pos.phaseAng;stat.max | |||||||||
instrument_host_name | instrument_host_name | Text |
| Standard name of the observatory or spacecraft | meta.id;instr.obsty | meta.id;instr.tel | ||||||||
instrument_name | instrument_name | Text |
| Standard name of instrument | meta.id;instr | meta.id;instr | ||||||||
measurement_type | measurement_type | Text |
| UCD(s) defining the data | meta.ucd | meta.ucd | ||||||||
processing_level | processing_level | Integer |
| CODMAC calibration level in v1 | meta.code;obs.calib | meta.code;obs.calib | To be replaced by PDS4 values in v2? | |||||||
creation_date | Y | Date | (ISO-8601 String) | Date of first entry of this granule | time.creation | time;meta.dataset | ||||||||
modification_date | Y | Date | (ISO-8601 String) | Date of last modification (used to handle mirroring) | time.update | |||||||||
release_date | Y | Date | (ISO-8601 String) | Start of public access period (set to creation_date if no proprietary period) | time.release | time.release | ||||||||
service_title | Y | service_title | Text |
| Title of resource (an acronym really, will be used to handle multiservice results) | meta.title | ||||||||
Optional parameters |
|
|
|
|
| |||||||||
access_url | access_url | Text |
| URL of the data file, case sensitive. Can point to a script. If present, next 2 parameters must also be present. | meta.ref.url;meta.file | meta.ref.url | Use this to link data! | |||||||
access_format | access_format | Text | (mime type in lowercase) | File format type | meta.code.mime | meta.code.mime | ||||||||
access_estsize | access_estsize | Integer | kbyte | Estimate file size in kbyte (with this spelling) | phys.size;meta.file | phys.size;meta.file | ||||||||
data_access_url (best avoided and replaced by datalink in access_url, TBC) | Text | If access_format indicates a detached label, this parameter is mandatory and points to the corresponding data file - both will be handled by the client before samping it to tools or downloading- TBC | meta.ref.url;meta.file | Must be filled? being questioned! | ||||||||||
| access_md5 | Text | MD5 Hash for the file when available (real file, not script) | meta.checksum;meta.file | |||||||||||
_ | preview_url | Integer |
| URL of a preview image (std format with adequate resolution for user's purpose) | (meta.ref.url;meta.file) | replaced by another granule group | ||||||||
_ | native_access_url | Text |
| URL of the data file in native form, case sensitive | (meta.ref.url;meta.file) | replaced by another granule group | ||||||||
_ | native_access_format | Text |
| File format type in native form | (meta.id;class) | replaced by another granule group | ||||||||
thumbnail_url | Text |
| URL of a thumbnail image with predefined size (png ~200 pix, for use in a client only) | meta.ref.url;meta.file meta.ref.url;meta.preview | ||||||||||
file_name | file_name | Text |
| Name of the data file only, case sensitive | meta.id;meta.file | meta.title;obs — ? | ObsCore obs_title is for a short free text string describing the granule. Do we want this? | |||||||
species | species | Text |
| Identifies a chemical species, case sensitive | meta.id;phys.atmol | |||||||||
| alt_target_name | Text | Provides alternative target name if more common (e.g. comets) | meta.id;src | |||||||||||
target_region | target_region | Text |
| Type of region of interest | meta.id;class obs.field | |||||||||
feature_name | element_name | Text |
| Secondary name | meta.id;pos obs.field |
| ||||||||
bib_reference | reference | Text |
| Bibcode preferred if available (does that include link?), doi, or other biblio id, URL… | meta.bib meta.bib.bibcode (if bibcode) | meta.bib.bibcode (always as bibcode) | ||||||||
ra | ra | Double | deg or h:m:s? | Right ascension (not hour angle…) | pos.eq.ra;meta.main | |||||||||
dec | dec | Double | deg | Declination | pos.eq.dec;meta.main | |||||||||
solar_longitude_min | solar_longitude | Double | deg | Min Solar longitude Ls (location on orbit / season) | pos.posangle pos.posAng;pos.heliocentric;stat.min | |||||||||
solar_longitude_max | solar_longitude | Double | deg | Max Solar longitude Ls (location on orbit / season) | pos.posangle pos.posAng;pos.heliocentric;stat.max | |||||||||
local_time_min | local_time_min | Double | h | Local time at observed region | time.phase;stat.min time.period.rotation;time.phase;stat.min | |||||||||
local_time_max | local_time_max | Double | h | Local time at observed region | time.phase;stat.max time.period.rotation;time.phase;stat.max | |||||||||
target_distance_min | target_distance | Double | km | Observer-target distance | pos.distance;stat.min | was target_distance without min/max in v1 | ||||||||
| target_distance_max | Double | km | Observer-target distance | pos.distance;stat.max | ||||||||||
target_time_min | Double | d | Observing time in target frame | time.start | (simplest way to look for coordinated observations) | |||||||||
target_time_max | Double | d | time.end | |||||||||||
| earth_distance_min | Double | au | EarthEarth-target distance | pos.distance;stat.min | ||||||||||
| earth_distance_max | Double | au | pos.distance;stat.max | |||||||||||
| sun_distance_min | Double | au | SunSun-target distance | pos.distance;stat.min | ||||||||||
| sun_distance_max | Double | au | pos.distance;stat.max | |||||||||||
particle_spectral_type | particle_spectral_type | Text |
|
| Use phys.particle? | Particle spectroscopy extension | ||||||||
particle_spectral_range_min | particle_spectral_range_min | Double |
|
| Use phys.particle? | |||||||||
particle_spectral_range_max | particle_spectral_range_max | Double |
|
| Use phys.particle? | |||||||||
particle_spectral_sampling_step_min | particle_spectral_sampling_step_min | Double |
|
| Use phys.particle? | |||||||||
particle_spectral_sampling_step_max | particle_spectral_sampling_step_max | Double |
|
| Use phys.particle? | |||||||||
particle_spectral_resolution_min | particle_spectral_resolution_min | Double |
|
| spect.resolution;stat.min Use phys.particle? | |||||||||
particle_spectral_resolution_max | particle_spectral_resolution_max | Double |
|
| spect.resolution;stat.max Use phys.particle? | |||||||||
| mass | Double | kg | phys.mass | Solar System Objects extension (generic values in catalogues, not observations) | ||||||||||
| sideral_rotation_period | Double | h | time.period.rotation | |||||||||||
| mean_radius | Double | km | phys.size.radius | |||||||||||
| equatorial_radius | Double | km | phys.size.radius | |||||||||||
| polar_radius | Double | km | phys.size.radius | |||||||||||
More optional parameters (TBC) | were "Relative to service" (in Table header) |
|
|
|
| |||||||||
publisher | publisher | Text |
| Resource publisher | meta.name | meta.ref.url;meta.curation — ? | ||||||||
spatial_coordinate_description | spatial_coordinate_description | Text |
| ID of specific coordinate system and version | meta.code.class;pos.frame | still TBD. Discussion in progress here: EPN-TAP v2: Current discussion topic | ||||||||
spatial_origin | spatial_origin | Text |
| Defines the frame origin | meta.ref;pos.frame | |||||||||
time_origin | time_origin | Text |
| Defines where the time is measured (e. g., ground vs spacecraft) [target_time is of course always on target]. | meta.ref;time.scale | TBC | ||||||||
time_scale |
| Text |
| Always UTC in data services (may be relaxed in computational services such as ephemeris) - from enumerated list | time.scale |
...
File name-type | granule_uid | granule_gid | obs_id |
A-Raw | 1 | native | A |
A-Calib | 2 | calibrated | A |
A-geom | 3 | geometry | A |
A-proj | 4 | projected | A |
B-Raw | 5 | native | B |
B-Calib | 6 | calibrated | B |
B-geom | 7 | geometry | B |
B-proj | 8 | projected | B |
Other modifications
...
• mutlivalued lists = first entry#second entry#…#last entry, or scalar (with no #)
string delimiter Values separator = #
Tests show that this No quotes around the list
This can be parsed by ADQL/RegTAP function ivo_hashlist_has , looks like the most flexible solutionlike this:
select * from vvex.epn_core where 1 = ivo_hashlist_has(lower(target_name),'Venus')
Where the lower function is mandatory to handle values possibly containing upper cases (this is implicit on the 2nd argument)
Beware that only complete elements between separators will be found. The provider has to split the string according to expected searches, e.g.:
Composite Infrared Spectrometer#CIRS
not Composite Infrared Spectrometer (CIRS)
• Defaut values (to be reviewed):
NULL/void: will never return an answer to a query using this parameter (TBC, seems ADQL-related. To be corrected if it is a limitation of the client)
For float / double : -inf for *_min +inf for *_max – still TBC (NaN won't do). To be tested on a real case.
Not needed for strings? (i.e. NULL/void is OK?)
Default behavior looks OK in fact. If we need to preserve the NULL values on queried parameters (ie, when NULL is considered as "I don't know"), this can be done with a OR param = NULL (on option in the client? This is feasible manually on TapHandle)
...
• UCDs: to be reviewed against PDS4 and IPDA, and completed (ObsCore OKchecked)
• Processing levels: to be reviewed against PDS4 (again- mostly related to geometry, considered as derived in PDS4)
...