Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
(Must be present, possibly empty)

 

 

 

 

Current value
current but dubious or undefined
possible alternative but undefined

— ? : closest sense

_ : N/A in ObsCore

from epntap v2 mixin (aug 2017)
equivalent/close in ObsCore doc 1.1

 

granule_uid

Y

Text

 

Internal table row index
Unique ID in data service. Can be alphanum.

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.idobscore: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;srcEpn.TargetName 

target_class

Y

Text

 

Type of target, from enumerated list

src.class

src.classEpn.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.exposureEpn.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_minAlways as freq

spectral_range_max

 

Double

Hz

Max spectral range (frequency)

em.freq;stat.max

em.wl;stat.maxEpn.Spectral.Spectral_range_max 

spectral_sampling_step_min

 

Double

Hz

Min spectral sampling step

em.freq.step;stat.min

meta.numberEpn.Spectral.Spectral_sampling_step_min 

spectral_sampling_step_max

 

Double

Hz

Max spectral sampling step

em.freq.step;stat.max

meta.numberEpn.Spectral.Spectral_sampling_step_max 

spectral_resolution_min

 

Double

Hz

Min spectral resolution

spect.resolution;stat.min

spect.resolutionEpn.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)
or pos.radius;stat.min (does not exist)
  for spherical & cylindrical

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.raEpn.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.zd;stat.min (for zenithal distance) for spherical 

or pos.az.azi;stat.min (for azimuth)
  for cylindrical

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.decEpn.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
or pos.az.azi;stat.min (for azimuth)
  for spherical

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)
or
pos.distance;pos.bodyrc;stat.min for body (from center)?

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.fieldobscore: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
if angular

pos.angResolution;stat.minEpn.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.maxEpn.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
 pos.angResolution;stat.min
if angular

 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
 pos.angResolution;stat.min
if angular
(spherical only)

 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
 pos.incidenceAng;stat.min
posAng

_Epn.View_angle.Incidence_angle_min 

incidence_max

 

Double

deg

Max incidence angle (solar zenithal angle)

pos.posAng;stat.max
 pos.incidenceAng;stat.max

_Epn.View_angle.Incidence_angle_max 

emergence_min

 

Double

deg

Min emergence angle

pos.posAng;stat.min
 pos.emergenceAng;stat.min

_Epn.View_angle.Emergence_angle_min 

emergence_max

 

Double

deg

Max emergence angle

pos.posAng;stat.max
 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.telProvenance.ObsConfig.Facility.name 

instrument_name

 

Text

 

Standard name of instrument

meta.id;instr

meta.id;instrProvenance.ObsConfig.Instrument.name 

measurement_type

 

Text

 

UCD(s) defining the data

meta.ucd

meta.ucdEpn.Measurement_type 

processing_level

 

Integer

 

Use dataset-related value. If none defined, use CODMAC calibration level in v1

meta.calibLevel

meta.code;obs.calib

~ obscore:ObsDataset.calibLevelTo be replaced by PDS4 values in v2?

creation_date

YTimestamp

(ISO-8601 String)

Date of first entry of this granule

time.creation

time;meta.dataset
 

modification_date

YTimestamp(ISO-8601 String)

Date of last modification (used to handle mirroring)

time.update
    time.processing? (not quite this)

 
 

release_date

YTimestamp

(ISO-8601 String)

Start of public access period (set to creation_date if no proprietary period)

time.release

time.releaseobscore:Curation.releaseDate 

service_title

Y

Text

 

Title of resource (an acronym really, will be used to handle multiservice results)

meta.title

 
 

Optional parameters

 

 

 

 

 

 
 

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.urlObs.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.mimeObs.Access.Format 

access_estsize

 

Integer

kbyte

Estimate file size in kbyte (with this spelling)

phys.size;meta.file

phys.size;meta.fileObs.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 servermeta.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 Textcan be a listProvides 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
(can be the standard name of a region of interest)

obs.field 

 
Anchor
featurename
featurename

publisher

 

Text

 

Resource publisher

meta.name
  meta.curation?

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 servicemeta.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
(~COOSYS)

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
or
pos;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 DoubledegMin sub-solar pointpos.bodyrc.lon;stat.min 
Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body'
subsolar_longitude_max DoubledegMax sub-solar pointpos.bodyrc.lon;stat.max 
Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body'
subsolar_latitude_min DoubledegMin sub-solar pointpos.bodyrc.lat;stat.min 
_
subsolar_latitude_max DoubledegMax sub-solar pointpos.bodyrc.lat;stat.max 
_
subobserver_longitude_min DoubledegMin sub-observer point (sub-Earth for ground based observations)pos.bodyrc.lon;stat.min 
_
subobserver_longitude_max DoubledegMax sub-observer point (sub-Earth for ground based observations)pos.bodyrc.lon;stat.max 
_
subobserver_latitude_min DoubledegMin sub-observer point (sub-Earth for ground based observations) pos.bodyrc.lat;stat.min 
_
subobserver_latitude_max DoubledegMax 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 DoublekmMin distance from center (in body-fixed frame)pos.distance;pos.bodyrc;stat.min 
 
radial_distance_max DoublekmMax distance from center (in body-fixed frame)pos.distance;pos.bodyrc;stat.max 
 
altitude_fromshape_min DoublekmMin altitude above shape model / DTM (in body-fixed frame)pos.bodyrc.alt;stat.min 
 
altitude_fromshape_max DoublekmMax 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
pos.bodyrc.lon;pos.heliocentric;stat.max

(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

kmObserver-target distancepos.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 DoubleauEarth-target distancepos.distance;stat.min 
 
earth_distance_max Doubleau 

pos.distance;stat.max

 
 
sun_distance_min DoubleauSun-target distancepos.distance;stat.min 
 
sun_distance_max Doubleau pos.distance;stat.max 
 

Parameters from extensions









mass Doublekg phys.mass 
Solar System Objects extension (generic values in catalogues, not observations)
sideral_rotation_period Doubleh time.period.rotation 
 
mean_radius Doublekm phys.size.radius 
 
equatorial_radius Doublekm phys.size.radius 
 
polar_radius Doublekm phys.size.radius 
 

semi_major_axis


Doubleau




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
Use phys.particle?

 
 

particle_spectral_resolution_max

 

Double

 

 

spect.resolution;stat.max
Use phys.particle?

 
 

...