...
Name, v2 | Must be filled? | SQL type | Unit / Format / Range | Description | UCD Please comment! | UCD in Obscore 1.1 (30/3/2016 version) | Utype (tentative) | Comments / UCD | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EPNCore mandatory parameters |
|
|
| Current value | — ? : closest sense _ : N/A in ObsCore | from epntap v2 mixin (aug 2017) | ||||||||
granule_uid | Y | 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. Keep it simple in intricate situations. | meta.id;obs | meta.id | obscore:DataID.observationID | |||||||
dataproduct_type | Y | Text |
| Organization of the data product, from enumerated list | meta.code.class | meta.id | Epn.dataProductType obscore:ObsDataset.dataProductType | |||||||
target_name | (services with no target_name do exist) | 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 | Text |
| Type of target, from enumerated list | src.class | src.class | Epn.TargetClass | |||||||
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;obs time.start;obs.exposure (if exposed?) | time.start;obs.exposure | Char.TimeAxis.Coverage.Bounds.Limits.Interval.StartTime TBD (from ObsCore) | ||||||||
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;obs time.end;obs.exposure (if exposed?) | time.end;obs.exposure | Char.TimeAxis.Coverage.Bounds.Limits.Interval.StopTime TBD (from ObsCore) | ||||||||
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 | Double | s | Max time sampling step | time.interval;stat.max | Epn.Time.Time_sampling_step_max | |||||||||
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 | Double | s | Max integration time | time.duration;obs.exposure;stat.max | Epn.Time.Time_exp_max | |||||||||
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 | Double | Hz | Max spectral range (frequency) | em.freq;stat.max | em.wl;stat.max | Epn.Spectral.Spectral_range_max | ||||||||
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 | Double | Hz | Max spectral sampling step | em.freq.step;stat.max | meta.number | Epn.Spectral.Spectral_sampling_step_max | ||||||||
spectral_resolution_min | Double | Hz | Min spectral resolution | spect.resolution;stat.min | spect.resolution | Epn.Spectral.Spectral_resolution_min | ||||||||
spectral_resolution_max | Double | Hz | Max spectral resolution | spect.resolution;stat.max | Epn.Spectral.Spectral_resolution_max | |||||||||
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 | Double | (1)
| Max of first coordinate | pos;stat.max, etc | Epn.Spatial.Spatial_range.c1max | |||||||||
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 | Double | (1) | Max of second coordinate | pos;stat.max, etc | Epn.Spatial.Spatial_range.c2max | |||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Double | deg | Min incidence angle (solar zenithal angle) | pos.;stat.min | _ | Epn.View_angle.Incidence_angle_min | ||||||||
incidence_max | Double | deg | Max incidence angle (solar zenithal angle) | pos.posAng;stat.max | _ | Epn.View_angle.Incidence_angle_max | ||||||||
emergence_min | Double | deg | Min emergence angle | pos.posAng;stat.min | _ | Epn.View_angle.Emergence_angle_min | ||||||||
emergence_max | Double | deg | Max emergence angle | pos.posAng;stat.max | _ | Epn.View_angle.Emergence_angle_max | ||||||||
phase_min | Double | deg | Min phase angle | pos.phaseAng;stat.min | Epn.View_angle.Phase_angle_min | |||||||||
phase_max | Double | deg | Max phase angle | pos.phaseAng;stat.max | Epn.View_angle.Phase_angle_max | |||||||||
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 | Text |
| Standard name of instrument | meta.id;instr | meta.id;instr | Provenance.ObsConfig.Instrument.name | ||||||||
measurement_type | Text |
| UCD(s) defining the data | meta.ucd | meta.ucd | Epn.Measurement_type | ||||||||
processing_level | Integer |
| Use dataset-related value. If none defined, use CODMAC calibration level | meta.calibLevel | 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 | Text |
| Title of resource = schema name (an acronym really, will be used to handle multiservice results) | meta.title | |||||||||
Optional parameters |
|
|
|
| ||||||||||
access_url | Text |
| URL of the data file, case sensitive (additional files may be linked through datalink_url). 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 | Text | (mime type in lowercase) | File format type | meta.code.mime | meta.code.mime | Obs.Access.Format | ||||||||
access_estsize | Integer | kbyte | Estimate file size in kbyte (with this spelling) | phys.size;meta.file | phys.size;meta.file | Obs.Access.Size | ||||||||
access_md5 | Text | MD5 Hash for the file when available (real file, not script) | meta.checksum;meta.file | |||||||||||
thumbnail_url | Text |
| URL of a thumbnail image with predefined size (png ~200 pix, for use in a client only) | meta.ref.url;meta.preview | ||||||||||
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? | ||||||||
datalink_url | Text | (url) | Provides links to files or services on the server | meta.ref.url;meta.datalink | ||||||||||
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 | can be a list | Provides alternative target name if more common (e.g. comets) | meta.id;src | ||||||||||
target_region | Text |
| Type of region of interest | obs.field | ||||||||||
feature_name | Text |
| Secondary name | obs.field |
| |||||||||
publisher | Text |
| Resource publisher | meta.name | meta.ref.url;meta.curation — ? | ~ obscore:Curation.publisherID | ||||||||
bib_reference | Text |
| Bibcode preferred if available, 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. | |||||||||
spatial_coordinate_description | Text |
| ID of specific coordinate system and version / properties | meta.code.class;pos.frame | still TBD. Discussion in progress here: EPN-TAP v2: Current discussion topic | |||||||||
spatial_origin | Text |
| Defines the frame origin | meta.ref;pos.frame | ||||||||||
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 | ||||||||||
subsolar_longitude_min | Double | deg | Min sub-solar point | pos.bodyrc.lon;stat.min | Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body' | |||||||||
subsolar_longitude_max | Double | deg | Max sub-solar point | pos.bodyrc.lon;stat.max | Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body' | |||||||||
subsolar_latitude_min | Double | deg | Min sub-solar point | pos.bodyrc.lat;stat.min | _ | |||||||||
subsolar_latitude_max | Double | deg | Max sub-solar point | pos.bodyrc.lat;stat.max | _ | |||||||||
subobserver_longitude_min | Double | deg | Min sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lon;stat.min | _ | |||||||||
subobserver_longitude_max | Double | deg | Max sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lon;stat.max | _ | |||||||||
subobserver_latitude_min | Double | deg | Min sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lat;stat.min | _ | |||||||||
subobserver_latitude_max | Double | deg | Max sub-observer point (sub-Earth for ground based observations) | pos.bodyrc.lat;stat.max | _ | |||||||||
ra | Double | deg only (like ObsCore) | Right ascension (not hour angle!) | pos.eq.ra;meta.main | ||||||||||
dec | Double | deg | Declination | pos.eq.dec;meta.main | ||||||||||
radial_distance_min | Double | km | Min distance from center (in body-fixed frame) | pos.distance;pos.bodyrc;stat.min | ||||||||||
radial_distance_max | Double | km | Max distance from center (in body-fixed frame) | pos.distance;pos.bodyrc;stat.max | ||||||||||
altitude_fromshape_min | Double | km | Min altitude above shape model / DTM (in body-fixed frame) | pos.bodyrc.alt;stat.min | ||||||||||
altitude_fromshape_max | Double | km | Max altitude above shape model / DTM (in body-fixed frame) | pos.bodyrc.alt;stat.max | ||||||||||
solar_longitude_min | Double | deg | Min Solar longitude Ls (location on orbit / season) | pos.posang pos.bodyrc.lon;pos.heliocentric;stat.min (posang means something else) | ||||||||||
solar_longitude_max | Double | deg | Max Solar longitude Ls (location on orbit / season) | pos.posang (posang means something else) | ||||||||||
local_time_min | Double | h | Local time at observed region | time.period.rotation;time.phase;stat.min | ||||||||||
local_time_max | Double | h | Local time at observed region | time.period.rotation;time.phase;stat.max | ||||||||||
target_distance_min | 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 | |||||||||||
Parameters from extensions | ||||||||||||||
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 | |||||||||||
semi_major_axis | Double | au | ||||||||||||
dynamical_class | text | |||||||||||||
dynamical_type | text | |||||||||||||
particle_spectral_type | Text |
|
| Use phys.particle? | Particle spectroscopy extension | |||||||||
particle_spectral_range_min | Double |
|
| Use phys.particle? | ||||||||||
particle_spectral_range_max | Double |
|
| Use phys.particle? | ||||||||||
particle_spectral_sampling_step_min | Double |
|
| Use phys.particle? | ||||||||||
particle_spectral_sampling_step_max | Double |
|
| Use phys.particle? | ||||||||||
particle_spectral_resolution_min | Double |
|
| spect.resolution;stat.min | ||||||||||
particle_spectral_resolution_max | Double |
|
| spect.resolution;stat.max |
...