...
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. Can accommodate FWHM for filters. | spect.resolution;stat.min | spect.resolution | Epn.Spectral.Spectral_resolution_min | ||||||||
spectral_resolution_max | Double | Hz | Max spectral resolution. Can accommodate FWHM for filters. | 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.angResolution;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.angResolution;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.angResolution;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.angResolution;stat.min | 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.incidenceAng;stat.min | _ | Epn.View_angle.Incidence_angle_min | ||||||||
incidence_max | Double | deg | Max incidence angle (solar zenithal angle) | pos.incidenceAng;stat.max | _ | Epn.View_angle.Incidence_angle_max | ||||||||
emergence_min | Double | deg | Min emergence angle | pos.emergenceAng;stat.min | _ | Epn.View_angle.Emergence_angle_min | ||||||||
emergence_max | Double | deg | Max emergence angle | pos.emergenceAng;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, typically for images. | 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 hash list | Provides alternative target name if more common (e.g. comets) | meta.id;src | ||||||||||
target_region | Text |
| Type of region or feature 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 (to be used only if required). | 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 - 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.bodyrc.lon;pos.heliocentric;stat.min | ||||||||||
solar_longitude_max | Double | deg | Max Solar longitude Ls (location on orbit / season) | pos.bodyrc.lon;pos.heliocentric;stat.max | ||||||||||
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 | phys.size.smajAxis | |||||||||||
| inclination | Double | Body inclination | Orbit inclination | src.orbital.inclination | ||||||||||
| eccentricity | Double | Orbit eccentricity | src.orbital.eccentricity | |||||||||||
dynamical_class | text | Class of small body, from enumerated list | ||||||||||||
| dynamical_type | text | Subdivision of the class, from enumerated list | ||||||||||||
map_projection | text | ID from enumerated list | ||||||||||||
map_height | Double | pixel | Map size in px | phys.size | ||||||||||
| map_width | Double | pixel | Map size in px | phys.size | ||||||||||
| map_scale | text | Format TBD | pos.wcs.scale? | |||||||||||
| pixelscale_min | Double | km/pixel | Min pixel size on a surface | |||||||||||
| pixelscale_max | Double | km/pixel | Max pixel size on a surface | |||||||||||
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 | ||||||||||
original_publisher | text | Refers to the source of the data, especially in compilations | ||||||||||||
producer_name | text | Data producer name, especially in compilations of experimental data | ||||||||||||
producer_institute | text | Data producer institute, especially in compilations of experimental data | ||||||||||||
sample_classification | text | hash list | Information related to class, sub-class, species… (using standard names) | |||||||||||
| sample_desc | text | can be a hash list | Describes the sample, its origin, and possible preparation | |||||||||||
data_calibration_desc | text | can be a hash list | Provides information on post-processing (preferably to a "comment" parameter) | |||||||||||
| setup_desc | text | can be a hash list | Describes the experimental setup if needed - may include Aperture (size of sample measured), etc | |||||||||||
geometry_type | text | Type of observation (such as bidirectional, biconical, directional-hemispherical, etc) | ||||||||||||
grain_size_min | Double | µm | Min particle size in µm | phys.size | ||||||||||
| grain_size_max | Double | Max particle size in µm | phys.size | |||||||||||
| azimuth_min | Double | deg | Min azimuth angle for illumination (check for <0 values?) | |||||||||||
| azimuth_max | Double | deg | Max azimuth angle for illumination | |||||||||||
pressure | Double | ? TBC (bar not welcome) | Ambient pressure | |||||||||||
measurement_atmosphere | text | Describes experimental conditions. "vacuum" for measurements under vacuum. | ||||||||||||
| temperature | Double | K | Ambient temperature | |||||||||||
event_type | text | Type of event from enumerated list (e. g., meteor_shower, fireball, lunar_flash, comet_tail_crossing…). If dataproduct_type = ev. | ||||||||||||
| event_status | text | From enumerated list. If dataproduct_type = ev. | ||||||||||||
| event_cite | text | From enumerated list. If dataproduct_type = ev. |
...