Page tree

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. Can accommodate FWHM for filters.

spect.resolution;stat.min

spect.resolutionEpn.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)
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.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.angResolution;stat.max
if angular

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

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

 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.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.
Add ;meta.modelled if simlulation or model

meta.ucd

meta.ucdEpn.Measurement_type 

processing_level

 

Integer

 

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

meta.calibLevel

meta.code;obs.calib

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

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 = schema name (an acronym really)

meta.title

 
May be used to handle multiservice results

Common 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.urlObs.Access.Reference

Use this to link data!

Could accommodate a datalink with access_format = 'application/x-votable+xml;content=datalink'
(UCD from ObsCore)

- this  but this is a funny idea though…idea…

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

  
This is the only case sensitive parameter
filter Text Identifies a filter in use, typically for images.meta.id;instr.filter 
Informative only, free format (no list, but see http://svo2.cab.inta-csic.es/svo/theory/fps3/). Search can only rely on spectral range, as ObsCore does.
waveband
Text

Electro-magnetic band, from enumerated list

instr.bandpass


alt_target_name Textcan be a hash listProvides 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
(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 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
(~COOSYS, but includes planetary ones)

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

Min local time at observed region

time.period.rotation;time.phase;stat.min

 
 

local_time_max

 

Double

h

Max local time at observed region

time.period.rotation;time.phase;stat.max

 
 

target_distance_min

 

Double

km

Min observer-target distance

pos.distance;stat.min

 

target_distance_max 

Double

kmMax observer-target distancepos.distance;stat.max 
 

target_time_min

 

Double

d

Min observing time in target frame

time.start

 
(simplest way to look for coordinated observations)

target_time_max

 

Double

d

Max observing time in target frame

time.end

 
 
earth_distance_min DoubleauMin Earth-target distancepos.distance;stat.min 
 
earth_distance_max DoubleauMax Earth-target distance

pos.distance;stat.max

 
 
sun_distance_min DoubleauMin Sun-target distancepos.distance;stat.min 
 
sun_distance_max DoubleauMax Sun-target distancepos.distance;stat.max 
 

Parameters from extensions









obs_mode
text
Observing modemeta.code;instr.setup


detector_name
text
Detector namemeta.id;instr.det

From APIS / + observation extensionextensions
opt_elem
text
Optical element namemeta.id;instr.param


instrument_type
text
type of instrumentmeta.id;instr

To be used with caution: free format, no reference list intended.
acquisition_id
text
ID of the data file/acquisition in the original archivemeta.id


proposal_id
Integer
Proposal identifiermeta.id;meta.code


proposal_pi
text
Proposal principal investigatormeta.bib.author


proposal_title
text
Proposal titlemeta.title


campaign
text
Name of the observational campaignmeta.id;meta.code


target_description
text
Original target keywordsmeta.note


proposal_target_name
text
target name as in proposal titlemeta.note;meta.main


target_apparent_radius
double
Apparent radius of the targetpos.angDistance


north_pole_position
double
North pole position angle with respect to celestial north polepos.angDistance


target_primary_hemisphere
text
Primary observed hemispheremeta.id;obs.field


target_secondary_hemisphere
text
Secondary observed hemispheremeta.id;obs.field


platesc
double
spatial resolution per pixel or platescale (on sky only)pos.angResolution


orientation
double
Position angle of image y axis (on sky only)pos.posAng


observer_name
text
Observer namemeta.note;meta.main


observer_institute
text
Observer institutemeta.note;meta.main


observer_idintInteger
Image observer's PVOL numeric identifiermeta.pubid

those are from PVOL, UCDs are wrong
observer_code
text
Image observer's PVOL usernamemeta.pubcode


observer_country
text
Image observer's country of residencemeta.pubcountry


observer_lon
Double
Observer's approximate longitudemeta.publon


observer_lat
Double
Observer's approximate latitudemeta.publat


mass Doublekg Mass of objectphys.mass 
Solar System Objects extension (generic values in catalogues, not observations)
sideral_rotation_period Doubleh Object rotation ratetime.period.rotation 
 
mean_radius Doublekm phys.size.radius 
 
equatorial_radius Doublekm phys.size.radius 
 
polar_radius Doublekm phys.size.radius 
 
diameter
doublekmTarget diameter. Or equivalent diameter for binary objectsphys.size.diameter

In Used in tnosarecool, not very consistent (use radius?)

semi_major_axis


Doubleau

phys.size.smajAxis




inclination
Double
Orbit inclination

src.orbital.inclination




eccentricity
Double
Orbit eccentricity

src.orbital.eccentricity




long_asc
DoubledegLongitude of ascending node, J2000.0src.orbital.node


arg_perihel
DoubledegArgument of Perihelion, J2000.0src.orbital.periastron


mean_anomaly
DoubledegMean anomaly at the epochsrc.orbital.meanAnomaly


dynamical_class


text
Class of small body, from enumerated listmeta.code.class


dynamical_type
text
Subdivision of the class, from enumerated listmeta.code.class


taxonomy_code
text
Code for target taxonomysrc.class.color

Values depend on target type and possibly service
magnitude
DoublemagAbsolute magnitude. For small bodies, from HG magnitude systemphys.magAbs

Actually depends on service (eg, spctro_planets vs DynAstVO vs tnosarecool)
flux
doublemJyTarget fluxphot.flux.density


albedo
double
Target albedophys.albedo


map_projection


text
ID from enumerated list


Map extension

map_height


DoublepixelMap size in px

phys.size




map_width
DoublepixelMap size in px

phys.size




map_scale
text
Format TBD

pos.wcs.scale?




pixelscale_min
Doublekm/pixelMin pixel size on a surfacepos.bodyrc;phys.size;stat.min


pixelscale_max
Doublekm/pixelMax pixel size on a surfacepos.bodyrc;phys.size;stat.max


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?

 
 

original_publisher



text
Refers to the source of the data, especially in compilations of experimental data


Experiment spectroscopy + contributive work extensions

producer_name


text
Data producer name, especially in compilations of experimental datameta.note;meta.main


producer_institute


text
Data producer institute, especially in compilations of experimental datameta.note;meta.main


sample_classification


texthash listInformation related to class, sub-class, species… (using standard names)meta.note;phys.composition


sample_desc
textcan be a hash listDescribes the sample, its origin, and possible preparationmeta.note


data_calibration_desc


textcan be a hash listProvides information on post-processing meta.note

(preferably to a "comment" parameter)meta.note
setup_desc
textcan be a hash listDescribes the experimental setup if needed - may include Aperture (size of sample measured), etcmeta.note


geometry_type


text
Type of observation (such as bidirectional, biconical, directional-hemispherical, etc)meta.note


grain_size_min


DoubleµmMin particle size in µm

phys.size;stat.min




grain_size_max
Double
Max particle size in µm

phys.size;stat.max




azimuth_min
DoubledegMin azimuth angle for illumination (check for <0 values?)pos.azimuthAng;stat.min


azimuth_max
DoubledegMax azimuth angle for illuminationpos.azimuthAng;stat.max


pressure


Double? TBC (bar is not welcome)Ambient pressure

phys.pressure




measurement_atmosphere


text
Describes experimental conditions. "vacuum" for measurements under vacuum.

meta.note;phys.pressure




temperature
DoubleKAmbient temperature

phys.temperature




event_type


text

Type of event from enumerated list (e. g., meteor_shower, fireball, lunar_flash, comet_tail_crossing…).

If dataproduct_type = ev.




Events extension
event_status
text

From enumerated list.

If dataproduct_type = ev.





event_cite
text

From enumerated list.

If dataproduct_type = ev.





...