Versions Compared

Key

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

...

+ See notes below the table.


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
(Must be present, possibly empty)
New or modified
relative to v1

 

 

 

 

 

Current value
current but dubious or undefined
possible alternative (but undefined)

— ? : closest sense

_ : N/A in ObsCore

 

granule_uid

Y

index

Text

 

Internal table row index
Unique ID in data service, also in v2. 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.

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
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)

pos.eq.raRA-DEC only

c1max

 

c1max

Double

(1)

 

Max of first coordinate

pos;stat.max

  

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;stat.min (for azimuth)
  for spherical & cylindrical?

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
or pos.az.zd;stat.min (for zenithal distance)
  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

  

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.

phys.outline;obs.field

(was initially instr.fov, to be corrected)

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
if angular

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

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

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

_ 

incidence_max

 

incidence_max

Double

deg

Max incidence angle (solar zenithal angle)

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

_ 

emergence_min

 

emergence_min

Double

deg

Min emergence angle

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

_ 

emergence_max

 

emergence_max

Double

deg

Max emergence angle

pos.posAng;stat.max
 pos.emergenceAng;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.calibLevel

meta.code;obs.calib

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
    time.process

  

release_date

Y Timestamp

(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
(still "title" in many v1 services)

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!

Can accommodate a datalink if access_format = 'application/x-votable+xml;content=datalink'

(this is from ObsCore)

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 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
 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)
(or meta.code.mime if we use MIME type)

 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)inst.filter.id 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
(can be standard name of region of interest)

meta.id;pos

  obs.field 

 
Anchor
featurename
featurename

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)

 
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.

subsolar_longitude  DoubledegSub-solar pointpos.bodyrc.lon Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body'
subsolar_latitude  DoubledegSub-solar pointpos.bodyrc.lat _
subobserver_longitude  DoubledegSub-observer point (sub-Earth for ground based observations)pos.bodyrc.lon _
subobserver_latitude  DoubledegSub-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  DoublekmDistance from center (in body-fixed frame)pos.distance;pos.bodyrc   
altitude_fromshape  DoublekmAltitude 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

Double

km

Observer-target distance

pos.distance;stat.min

 was target_distance without min/max in v1
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  

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  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  

More optional parameters (TBC)

 

were "Relative to service" (in Table header)

 

 

 

 

  

publisher

 

publisher

Text

 

Resource publisher

meta.name
  meta.curation

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
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

  

 

(1): depending on context (as given by spatial_frame_type). Please comment here: EPN-TAP v2: Current discussion topic

Beware that datatypes apply to the epn_core view, not to the q.rd file where they can be different




Example table:

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 


multivalued lists = first entry#second entry#…#last entry, or scalar (with no #)
Values separator = #
No quotes around the list

...

(was not really compliant…)

indexresource_typedataset_idaccess_urlaccess_formatpreview_urlnative_access_urlnative_access_format
23801granuleoriginal_datao5g202x4q_x2d.jpgjpgo5g202x4q_x2d_small.jpg

o5g202x4q_x2d.fits

fits
23802granuleprocessed_datao5g202x4q_proc.jpgjpgo5g202x4q_proc_small.jpgo5g202x4q_proc.fitsfits
23803granulecylindric_projo5g202x4q_cyl.jpgjpgo5g202x4q_cyl_small.jpg  
23804granulepolar_proj_northo5g202x4q_pol_n.jpgjpgo5g202x4q_pol_n_small.jpg  
23805granulepolar_proj_southo5g202x4q_pol_s.jpgjpgo5g202x4q_pol_s_small.jpg  

EPNcore Table v2

granule_uidgranule_gidobs_idaccess_urlaccess_formatthumbnail_url
o5g202x4q_x2doriginal_datao5g202x4qo5g202x4q_x2d.fitsimage/fitso5g202x4q_x2d_small.jpg
o5g202x4q_x2d_prevoriginal_data_previewo5g202x4qo5g202x4q_x2d.jpgimage/jpgo5g202x4q_x2d_small.jpg
o5g202x4q_procprocessed_datao5g202x4qo5g202x4q_proc.fitsimage/fitso5g202x4q_proc_small.jpg
o5g202x4q_proc_prevprocessed_data_previewo5g202x4qo5g202x4q_proc.jpgimage/jpgo5g202x4q_proc_small.jpg
o5g202x4q_cylcylindrical_projectiono5g202x4q o5g202x4q_cyl.jpgimage/jpgo5g202x4q_cyl_small.jpg
o5g202x4q_pol_npolar_projection_northo5g202x4q o5g202x4q_pol_n.jpgimage/jpgo5g202x4q_pol_n_small.jpg
o5g202x4q_pol_spolar_projection_southo5g202x4q o5g202x4q_pol_s.jpgimage/jpgo5g202x4q_pol_s_small.jpg