...
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) | Utype | Comments / UCD | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EPNCore mandatory parameters |
|
|
|
| Current value | — ? : closest sense _ : N/A in ObsCore | from epntap v2 mixin (aug 2017) | ||||||||
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 | obscore:DataID.observationID | ||||||||
_ | 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 | Epn.dataProductType obscore:ObsDataset.dataProductType | |||||||
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 | Epn.TargetName | |||||||
target_class | Y | target_class | Text |
| Type of target, from enumerated list | meta.code.class;src src.class | src.class | Epn.TargetClass | |||||||
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 | Char.TimeAxis.Coverage.Bounds.Limits.Interval.StartTime TBD (from ObsCore) | ||||||||
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 | Char.TimeAxis.Coverage.Bounds.Limits.Interval.StopTime TBD (from ObsCore) | ||||||||
time_sampling_step_min | time_sampling_step_min | Double | s | Min time sampling step | time.interval;stat.min | time.resolution — ? | Epn.Time.Time_sampling_step_min | ||||||||
time_sampling_step_max | time_sampling_step_max | Double | s | Max time sampling step | time.interval;stat.max | Epn.Time.Time_sampling_step_max | |||||||||
time_exp_min | time_exp_min | Double | s | Min integration time | time.duration;obs.exposure;stat.min | time.duration;obs.exposure | Epn.Time.Time_exp_min | ||||||||
time_exp_max | time_exp_max | Double | s | Max integration time | time.duration;obs.exposure;stat.max | Epn.Time.Time_exp_max | |||||||||
spectral_range_min | spectral_range_min | Double | Hz | Min spectral range (frequency) | em.freq;stat.min | em.wl;stat.min (always as wl) | Epn.Spectral.Spectral_range_min | Always as freq | |||||||
spectral_range_max | spectral_range_max | Double | Hz | Max spectral range (frequency) | em.freq;stat.max | em.wl;stat.max | Epn.Spectral.Spectral_range_max | ||||||||
spectral_sampling_step_min | spectral_sampling_step_min | Double | Hz | Min spectral sampling step | em.freq.step;stat.min | meta.number | Epn.Spectral.Spectral_sampling_step_min | ||||||||
spectral_sampling_step_max | spectral_sampling_step_max | Double | Hz | Max spectral sampling step | em.freq.step;stat.max | meta.number | Epn.Spectral.Spectral_sampling_step_max | ||||||||
spectral_resolution_min | spectral_resolution_min | Double | Hz | Min spectral resolution | spect.resolution;stat.min | spect.resolution | Epn.Spectral.Spectral_resolution_min | ||||||||
spectral_resolution_max | spectral_resolution_max | Double | Hz | Max spectral resolution | spect.resolution;stat.max | Epn.Spectral.Spectral_resolution_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 (bof) 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) - TBC empty ("") for none (and no unit) | pos.eq.ra | Epn.Spatial.Spatial_range.c1min | ||||||||
c1max | c1max | Double | (1)
| Max of first coordinate | pos;stat.max, etc | Epn.Spatial.Spatial_range.c1max | |||||||||
c2min | c2min | Double | (1) Latitude from -89.9999 to +89.9999 | Min of second coordinate | pos;stat.min pos.angDistance;stat.min or pos.az.azi;stat.min (for azimuth) pos.eq.dec;stat.min for celestial pos.bodyrc.lat;stat.min for body pos.cartesian.y;stat.min for Cartesian empty ("") for none (and no unit) | pos.eq.dec | Epn.Spatial.Spatial_range.c2min | ||||||||
c2max | c2max | Double | (1) | Max of second coordinate | pos;stat.max, etc | Epn.Spatial.Spatial_range.c2max | |||||||||
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 empty ("") for none (and no unit) | Epn.Spatial.Spatial_range.c3min | |||||||||
c3max | c3max | Double | (1) | Max of third coordinate | pos;stat.max, etc | Epn.Spatial.Spatial_range.c3max | |||||||||
s_region |
| spoly | PgSphere spoly | ObsCore-like footprint,valid for celestial, spherical, or body-fixed frames. | phys.outline;obs.field (was initially instr.fov, to be corrected) | phys.outline;obs.field | obscore:Char.SpatialAxis.Coverage.Support.Area | 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 | Epn.Spatial.Spatial_resolution.c1_resol_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 | Epn.Spatial.Spatial_resolution.c1_resol_max | (UCD is deprecated, but needed!) | |||||||
c2_resol_min | c2_resol_min | Double | (1) | Min resolution in second coordinate | pos.resolution;stat.min | Epn.Spatial.Spatial_resolution.c2_resol_min | (UCD is deprecated, but needed!) | ||||||||
c2_resol_max | c2_resol_max | Double | (1) | Max resolution in second coordinate | pos.resolution;stat.max | Epn.Spatial.Spatial_resolution.c2_resol_max | (UCD is deprecated, but needed!) | ||||||||
c3_resol_min | c3_resol_min | Double | (1) | Min resolution in third coordinate | pos.resolution;stat.min | Epn.Spatial.Spatial_resolution.c3_resol_min | (UCD is deprecated, but needed!) | ||||||||
c3_resol_max | c3_resol_max | Double | (1) | Max resolution in third coordinate | pos.resolution;stat.max | Epn.Spatial.Spatial_resolution.c3_resol_max | (UCD is deprecated, but needed!) | ||||||||
spatial_frame_type | Y | spatial_frame_type | Text | (1) Use "none" if undefined | Flavor of coordinate system, defines the nature of coordinates. From enumerated list | meta.code.class;pos.frame | _ | A value is required by DaCHS (query will return errors if empty) | |||||||
incidence_min | incidence_min | Double | deg | Min incidence angle (solar zenithal angle) | pos.posAng;stat.min | _ | Epn.View_angle.Incidence_angle_min | ||||||||
incidence_max | incidence_max | Double | deg | Max incidence angle (solar zenithal angle) | pos.posAng;stat.max | _ | Epn.View_angle.Incidence_angle_max | ||||||||
emergence_min | emergence_min | Double | deg | Min emergence angle | pos.posAng;stat.min | _ | Epn.View_angle.Emergence_angle_min | ||||||||
emergence_max | emergence_max | Double | deg | Max emergence angle | pos.posAng;stat.max | _ | Epn.View_angle.Emergence_angle_max | ||||||||
phase_min | phase_min | Double | deg | Min phase angle | pos.phaseAng;stat.min | Epn.View_angle.Phase_angle_min | |||||||||
phase_max | phase_max | Double | deg | Max phase angle | pos.phaseAng;stat.max | Epn.View_angle.Phase_angle_max | |||||||||
instrument_host_name | instrument_host_name | Text |
| Standard name of the observatory or spacecraft | meta.id;instr.obsty | meta.id;instr.tel | Provenance.ObsConfig.Facility.name | ||||||||
instrument_name | instrument_name | Text |
| Standard name of instrument | meta.id;instr | meta.id;instr | Provenance.ObsConfig.Instrument.name | ||||||||
measurement_type | measurement_type | Text |
| UCD(s) defining the data | meta.ucd | meta.ucd | Epn.Measurement_type | ||||||||
processing_level | processing_level | Integer |
| CODMAC calibration level in v1 | meta.code;obs.calib | meta.code;obs.calib | ~ obscore:ObsDataset.calibLevel | To be replaced by PDS4 values in v2? | |||||||
creation_date | Y | Timestamp | (ISO-8601 String) | Date of first entry of this granule | time.creation | time;meta.dataset | |||||||||
modification_date | Y | Timestamp | (ISO-8601 String) | Date of last modification (used to handle mirroring) | time.update | ||||||||||
release_date | Y | Timestamp | (ISO-8601 String) | Start of public access period (set to creation_date if no proprietary period) | time.release | time.release | obscore:Curation.releaseDate | ||||||||
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 | Obs.Access.Reference | Use this to link data! Can accommodate a datalink if access_format = 'application/x-votable+xml;content=datalink' (UCD from ObsCore) | |||||||
access_format | access_format | Text | (mime type in lowercase) | File format type | meta.code.mime | meta.code.mime | Obs.Access.Format | ||||||||
access_estsize | access_estsize | Integer | kbyte | Estimate file size in kbyte (with this spelling) | phys.size;meta.file | phys.size;meta.file | Obs.Access.Size | ||||||||
data_access_url (best avoided and replaced by datalink in access_url; TBC but this is what ObsCore does) | 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 | ||||||||||||
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 | ||||||||||
filter | Text | Identifies a filter in use (e.g. imaging) | meta.id;instr.filter | Informative only, free format (no list). Search can only rely on spectral range, as ObsCore does. | |||||||||||
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) | obscore:Curation.reference | ||||||||
internal_reference | Text | List of granule_uid(s) in the current service | meta.id.cross | Use to link one granule to a set of other granules. Only to solve situations that would otherwise require several tables | |||||||||||
external_link | Text | (url) | Link to a web page providing more details on the granule. | meta.ref.url | Link to an individual page in a web site associated to the database, e.g., a planet page in Exoplanets service. This is a way to provide extra granule information which cannot be accommodated in the table. | ||||||||||
subsolar_longitude | Double | deg | Sub-solar point | pos.bodyrc.lon | Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body' | ||||||||||
subsolar_latitude | Double | deg | Sub-solar point | pos.bodyrc.lat | _ | ||||||||||
subobserver_longitude | Double | deg | Sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lon | _ | ||||||||||
subobserver_latitude | Double | deg | Sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lat | _ | ||||||||||
ra | ra | Double | deg only (like ObsCore) | Right ascension (not hour angle!) | pos.eq.ra;meta.main | ||||||||||
dec | dec | Double | deg | Declination | pos.eq.dec;meta.main | ||||||||||
radial_distance | Double | km | Distance from center (in body-fixed frame) | pos.distance;pos.bodyrc | |||||||||||
altitude_fromshape | Double | km | Altitude above shape model / DTM (in body-fixed frame) | pos.bodyrc.alt | |||||||||||
solar_longitude_min | solar_longitude | Double | deg | Min Solar longitude Ls (location on orbit / season) | pos.posangle pos.posAng;pos.heliocentric;stat.min or pos.angDistance;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 or pos.angDistance;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 (no min/max) | Double | km | Observer-target distance | pos.distance;stat.min | ||||||||||
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 | Earth-target distance | pos.distance;stat.min | |||||||||||
earth_distance_max | Double | au | pos.distance;stat.max | ||||||||||||
sun_distance_min | Double | au | Sun-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 | ||||||||||||
Other optional parameters | These parameters were "Relative to service" (i.e., included in Table header) in v1; they are now regular optional parameters located in the table. |
|
|
|
| ||||||||||
publisher | publisher | Text |
| Resource publisher | meta.name | meta.ref.url;meta.curation — ? | ~ obscore:Curation.publisherID | ||||||||
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 |
...