Versions Compared

Key

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

...

Name

SQL type

Unit

Description

UCD

UCD in Obscore 1.1

(9/5/2017 REC version)

Utype

(tentative) 

Comments

EPNCore mandatory parameters
 (Must be present, possibly empty)
 (bold face: a value is required)




Current value
current but dubious or undefined

— ? : closest sense

_ : N/A in ObsCore

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

 

granule_uid

Text


Unique ID in data service.

meta.id

meta.id
 Can be alphanum.

granule_gid

Text


Common to granules of same type

meta.id

meta.id
E.g. same map projection, or geometry data products. Can be alphanum.

obs_id

Text


Associates granules derived from the same data

meta.id;obs

meta.idobscore:DataID.observationID E.g. various representations / processing levels. Can be alphanum., may be the ID of original observation.
Keep it simple in intricate situations.

dataproduct_type

Text


Organization of the data product, from enumerated list

meta.code.class

meta.id

Epn.dataProductType

obscore:ObsDataset.dataProductType


target_name

Text


Standard IAU name of target (must match target_class), case sensitive.

meta.id;src

meta.id;srcEpn.TargetNameCase sensitive
Services with no target_name do exist

target_class

Text


Type of target, from enumerated list

src.class

src.classEpn.TargetClass

time_min

Double

d

Start time (in JD). UTC measured at time_origin location (default is observer's frame)

time.start;obs

time.start;obs.exposure

Char.TimeAxis.Coverage.Bounds.Limits.Interval.StartTime



time_max

Double

d

Stop time (in JD). UTC measured at time_origin location (default is observer's frame)

time.end;obs

time.end;obs.exposure

Char.TimeAxis.Coverage.Bounds.Limits.Interval.StopTime



time_sampling_step_min

Double

s

Min time sampling step

time.resolution;stat.min

time.resolution Epn.Time.Time_sampling_step_min

time_sampling_step_max

Double

s

Max time sampling step

time.resolution;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 (as frequency)

em.freq;stat.min

em.wl;stat.min (always as wl)

Epn.Spectral.Spectral_range_minAlways as frequency

spectral_range_max

Double

Hz

Max spectral range (as 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;stat.interval;stat.min

meta.numberEpn.Spectral.Spectral_sampling_step_min

spectral_sampling_step_max

Double

Hz

Max spectral sampling step

em.freq;stat.interval;stat.max

meta.numberEpn.Spectral.Spectral_sampling_step_max

spectral_resolution_min

Double


Min spectral resolution (resolving power)

spect.resolution;stat.min

spect.resolution (relates to resolving power)

Epn.Spectral.Spectral_resolution_min

Now (2019) provides resolving power |(lambda / delta(lambda)| = |f /Df|
How do we accommodate FWHM for filters?

spectral_resolution_max

Double


Max spectral resolution (resolving power)

spect.resolution;stat.max


Epn.Spectral.Spectral_resolution_max

Now (2019) provides resolving power |(lambda / delta(lambda)| = |f /Df|
How do we accommodate FWHM for filters?

c1min

Double

(1)


Min of first coordinate, depends on the frame. 

see table below

pos.eq.raEpn.Spatial.Spatial_range.c1min

Typo in current mixin (.lonG => .lon

UCDs for cyl and sph coord are from PEN-UCDlist-20210430

c1max

Double

(1)

Max of first coordinate, depends on the frame



Epn.Spatial.Spatial_range.c1max

c2min

Double

(1)


Min of second coordinate, depends on the frame. 


pos.eq.decEpn.Spatial.Spatial_range.c2min

c2max

Double

(1)

Max of second coordinate, depends on the frame



Epn.Spatial.Spatial_range.c2max

c3min

Double

(1)

Min of third coordinate



Epn.Spatial.Spatial_range.c3min

c3max

Double

(1)

Max of third coordinate



Epn.Spatial.Spatial_range.c3max

s_region

spoly

(3)

ObsCore-like footprint in 2D (celestial or body-related frames)

pos.outline;obs.field

pos.outline;obs.fieldobscore:Char.SpatialAxis.Coverage.Support.Area

(was initially instr.fov, to be corrected)
ObsCore value updated (was phys.angArea;obs) to phys.outline, 
then corrected to pos.outline

Must have xtype= adql:REGION to work with TAP
Frame may be identified in q.rd (UNKNOWNFrame).
Use value given in spatial_frame_type - very unclear…
Do we need another param for GIS interface?

c1_resol_min

Double

(2)

Min resolution in first coordinate

(2)

pos.angResolution;stat.minEpn.Spatial.Spatial_resolution.c1_resol_minpos.resolution restored in 2018
In body fixed frame, use pixelscale_min/max for resolution at the surface 

c1_resol_max

Double

(2)

Max resolution in first coordinate

(2)

pos.angResolution;stat.maxEpn.Spatial.Spatial_resolution.c1_resol_max_

c2_resol_min

Double

(2)

Min resolution in second coordinate

(2)


Epn.Spatial.Spatial_resolution.c2_resol_min_

c2_resol_max

Double

(2)

Max resolution in second coordinate

(2)


Epn.Spatial.Spatial_resolution.c2_resol_max_

c3_resol_min

Double

(2)

Min resolution in third coordinate

(2)


Epn.Spatial.Spatial_resolution.c3_resol_minpos.resolution restored in 2018

c3_resol_max

Double

(2)

Max resolution in third coordinate

(2)


Epn.Spatial.Spatial_resolution.c3_resol_maxpos.resolution restored in 2018

spatial_frame_type

Text

(1)


Flavor of coordinate system, defines the nature of coordinates. From enumerated list. Use "none" if undefined.

meta.code.class;pos.frame

_

A value is required by DaCHS (query will return errors if empty)
Default value = none

incidence_min

Double

deg

Min incidence angle (solar zenithal angle)

 pos.incidenceAng;stat.min

_Epn.View_angle.Incidence_angle_minUCD for angles included in 2018 

incidence_max

Double

deg

Max incidence angle (solar zenithal angle)

 pos.incidenceAng;stat.max

_Epn.View_angle.Incidence_angle_maxUCD for angles included in 2018

emergence_min

Double

deg

Min emergence angle

 pos.emergenceAng;stat.min

_Epn.View_angle.Emergence_angle_minUCD for angles included in 2018

emergence_max

Double

deg

Max emergence angle

 pos.emergenceAng;stat.max

_Epn.View_angle.Emergence_angle_maxUCD for angles included in 2018

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_typeAdd ;meta.modelled if simulation or model
Add ;stat.uncalib if uncalibrated data - in which case processing_level must be 0 or 1

processing_level

Integer


Dataset-related encoding, or simplified CODMAC calibration level

meta.calibLevel

meta.code;obs.calib

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

creation_date

Timestamp


Date of first entry of this granule

time.creation

time;meta.dataset

modification_date

Timestamp

Date of last modification

time.processing



Used to handle mirroring
UCD value being discussed in 2018

release_date

Timestamp


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

time.release

time.releaseobscore:Curation.releaseDate

The value is in ISO 8601 format reusing this pattern: (“YYYY-MM-DDThh:mm:ss”) If release_date is in the future, the data is proprietary.

service_title

Text


Title of resource = schema name

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'
(from ObsCore)
- but this is a funny idea…

access_format

Text


RFC 2045 media type (mime), required to be all-lower case 

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_md5Text
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_urlText
Provides links to files or services on the servermeta.ref.url

Associated mime-type is 'application/x-votable+xml;content=datalink'
(from ObsCore)

species

Text


Identifies a chemical species, case sensitive

meta.id;phys.atmol



This is the only case sensitive parameter (with target_name)
wavebandText

Electro-magnetic band, from enumerated list

instr.bandpass


alt_target_nameText
Provides alternative target name(s). Can be a hash listmeta.id;src


target_region

Text


Type of region or feature of interest

meta.id;src;obs.field




feature_name

Text


Secondary name (e.g. standard name of a region of interest)

meta.id;src;obs.field 



Anchor
featurename
featurename

publisher

Text


Resource publisher

meta.curation

meta.ref.uri;meta.curation~ obscore:Curation.publisherID

bib_reference

Text


Bibcode or doi preferred; can be a URL or anything else. Refers to the granule

meta.bib

meta.bib

obscore:Curation.referenceBibcode & doi can be completed in TOPCAT
internal_referenceText
Related granule_uid(s) in the current servicemeta.id.cross

Use to link one granule to a set of other granules. To be used only if required - e.g. to solve situations that would otherwise require several tables
external_linkText
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.

shapeText

introduces an ascii (ST)MOC, v2 (2D footprint on celestial or body-related frames, possibly including time)

pos.outline;obs.field

Must have xtype="MOC" (follow DALI recommendation)

outline doesn't fit definition (refers to a contour)

spatial_coordinate_description

Text


ID of specific coordinate system and version / properties

meta.code.class;pos.frame



~COOSYS, but includes planetary ones
Still TBD, needs to be OGC compliant. 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). Default is observer's frame.

meta.ref;time.scale



target_time is of course always on target.

time_scale

Text


Always UTC in data services - from enumerated list

time.scale




subsolar_longitude_minDoubledegMinimum sub-solar point longitudepos.bodyrc.lon;stat.min

Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body'
subsolar_longitude_maxDoubledegMaximum sub-solar point longitudepos.bodyrc.lon;stat.max

Provided in the most natural body-related coordinate frame, E-handed - seems to require 'body'
subsolar_latitude_minDoubledegMinimum sub-solar point latitudepos.bodyrc.lat;stat.min

_
subsolar_latitude_maxDoubledegMaximum sub-solar point latitudepos.bodyrc.lat;stat.max

_
subobserver_longitude_minDoubledegMinimum sub-observer point longitude (sub-Earth for ground based observations)pos.bodyrc.lon;stat.min

_
subobserver_longitude_maxDoubledegMaximum sub-observer point longitude (sub-Earth for ground based observations)pos.bodyrc.lon;stat.max

_
subobserver_latitude_minDoubledegMinimum sub-observer point latitude (sub-Earth for ground based observations) pos.bodyrc.lat;stat.min

_
subobserver_latitude_maxDoubledegMaximum sub-observer point latitude (sub-Earth for ground based observations) pos.bodyrc.lat;stat.max

_

ra

Double

deg

Right ascension

pos.eq.ra;meta.main



deg only (like ObsCore)

dec

Double

deg

Declination

pos.eq.dec;meta.main




radial_distance_minDoublekmMin distance from observed area to body center pos.distance;pos.bodyrc;stat.min


radial_distance_maxDoublekmMax distance from observed area to body center pos.distance;pos.bodyrc;stat.max


altitude_fromshape_minDoublekmMin altitude of observed area above shape model / DTMpos.bodyrc.alt;stat.min


altitude_fromshape_maxDoublekmMax altitude of observed area above shape model / DTMpos.bodyrc.alt;stat.max


solar_longitude_min

Double

deg

Min Solar longitude Ls (location on orbit / season)

pos.ecliptic.lon;pos.heliocentric;stat.min 




solar_longitude_max

Double

deg

Max Solar longitude Ls (location on orbit / season)

pos.ecliptic.lon;pos.heliocentric;stat.max




local_time_min

Double

h

Min local time at observed region

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




local_time_max

Double

h

Max local time at observed region

time.phase;time.period.rotation;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

Timestamp


Min observing time in target frame

time.start;src



(simplest way to look for coordinated observations)

target_time_max

Timestamp


Max observing time in target frame

time.end;src




earth_distance_minDoubleAUMin Earth-target distancepos.distance;stat.min


earth_distance_maxDoubleAUMax Earth-target distance

pos.distance;stat.max




sun_distance_minDoubleAUMin Sun-target distancepos.distance;stat.min


sun_distance_maxDoubleAUMax Sun-target distancepos.distance;stat.max


Parameters from extensions








obs_modeText
Observing modemeta.code;instr.setup

From APIS + observation extensions (with adapted UCDs)
detector_nameText
Detector namemeta.id;instr.det


opt_elemText
Optical element namemeta.id;instr.param


filterText Identifies filter in use, typically for imagesmeta.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.
instrument_typeText
type of instrumentmeta.id;instr

Informative only (not a reliable search parameter): free format, no reference list intended.
acquisition_idText
ID of the data file/acquisition in the original archivemeta.id


proposal_idText
Proposal identifiermeta.id;obs.proposal


proposal_piText
Proposal principal investigator

meta.id.PI;obs.proposal




proposal_titleText
Proposal titlemeta.title;obs.proposal


campaignText
Name of the observational campaignmeta.id;obs.proposal


target_descriptionText
Original target keywordsmeta.note;src


proposal_target_nameText
target name as in proposal titlemeta.note;obs.proposal


target_apparent_radiusDouble
Apparent radius of the target

phys.angSize;src




north_pole_positionDoubledegNorth pole position angle with respect to celestial north pole

pos.posAng



Group of 5 parameters very specific to APIS.
Name is ~ OK, but actually provides the position angle of the planet axis. Use "orientation" for the image.
target_primary_hemisphereText
Primary observed hemispheremeta.id;obs.field


target_secondary_hemisphereText
Secondary observed hemispheremeta.id;obs.field


platescDoublearcsec/pixpixel angular size or platescale (on sky only)instr.scale


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

Provides the direction of the polar axis in the image, counted clockwise from north.
observer_nameText
Observer name

obs.observer;meta.main




observer_instituteText
Observer institutemeta.note;meta.main


observer_idInteger
Image observer's numeric identifier

meta.id.PI




Group of 5 from PVOL, OK for general use but UCDs have to be changed in PVOL.
meta.pubid in PVOL

observer_codeText
Image observer's PVOL usernamemeta.id.PI

meta.pubcode in PVOL
observer_countryText
Image observer's country of residencemeta.note;obs.observer

meta.pubcountry in PVOL
observer_lonDouble
Observer's approximate longitudeobs.observer;pos.earth.lon


meta.publon in PVOL
observer_latDouble
Observer's approximate latitudeobs.observer;pos.earth.lat

meta.publat in PVOL
massDoublekgMass of objectphys.mass

Solar System Objects extension (generic values in catalogues, not observations)
sidereal_rotation_periodDoublehObject rotation ratetime.period.rotation


mean_radiusDoublekm
phys.size.radius


equatorial_radiusDoublekm
phys.size.radius


polar_radiusDoublekm
phys.size.radius


diameterDoublekmTarget diameter, or equivalent diameter for binary objectsphys.size.diameter

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

semi_major_axis

DoubleAU

phys.size.smajAxis




inclinationDouble
Orbit inclination

src.orbital.inclination




eccentricityDouble
Orbit eccentricity

src.orbital.eccentricity




long_ascDoubledegLongitude of ascending node, J2000.0src.orbital.node


arg_perihelDoubledegArgument of Perihelion, J2000.0src.orbital.periastron


mean_anomalyDoubledegMean anomaly at the epochsrc.orbital.meanAnomaly


dynamical_class

Text
Class of small body, from enumerated listmeta.code.class;src


dynamical_typeText
Subdivision of the class, from enumerated listmeta.code.class;src


taxonomy_codeText
Code for target taxonomysrc.class.color

Possible values depend on target type and possibly on service
magnitudeDoublemagAbsolute magnitude. For small bodies, from HG magnitude systemphys.magAbs

Actually depends on service (eg, spectro_planets vs DynAstVO vs tnosarecool).
UCD may include mention of the photometric band.
fluxDoublemJyTarget fluxphot.flux.density


albedoDouble
Target albedophys.albedo


map_projection

Text
ID from enumerated list, or string with parameters (referring to a standard)pos.projection

Map extension

map_height

DoublepixMap size in px

phys.size




map_widthDoublepixMap size in px

phys.size




map_scaleText
Format TBD

pos.wcs.scale




pixelscale_minDoublekm/pixMin pixel size on a surface

instr.scale;stat.min




pixelscale_maxDoublekm/pixMax pixel size on a surface

instr.scale;stat.max




particle_spectral_type

Text


From enumerated list

meta.id;phys.particle




particle_spectral_range_min

Double



phys.energy;phys.particle;stat.min

phys.mass;phys.particle;stat.min




particle_spectral_range_max

Double



phys.energy;phys.particle;stat.max

phys.mass;phys.particle;stat.max




particle_spectral_sampling_step_min

Double



spect.resolution;phys.particle;stat.min




particle_spectral_sampling_step_max

Double



spect.resolution;phys.particle;stat.max




particle_spectral_resolution_min

Double



spect.resolution;phys.particle;stat.min




particle_spectral_resolution_max

Double



spect.resolution;phys.particle;stat.max




original_publisher


Text
Refers to the source of the data, e. g.,  in compilations of experimental datameta.note;meta.main

Experimental 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, e. g., in compilations of experimental datameta.note;meta.main


sample_idText
Provides a local ID in an existing catalogue meta.id;src

In addition to target_name

sample_classification

Text
Information related to class, sub-class, species… as hash listmeta.note;phys.composition

This uses standard names for classes… 
sample_descText
Describes the sample, its origin, and possible preparation. Can be a hash listmeta.note


data_calibration_desc

Text
Provides information on post-processing. Can be a hash listmeta.note

(preferably to a "comment" parameter)
setup_descText
Describes the experimental setup. Can be a hash listmeta.note

May include Aperture (size of sample measured), etc

geometry_type

Text
Type of observation, from enumerated list. Can be a hash listmeta.note;instr.setup


spectrum_type

Text
Type of spectral observation, from enumerated list TBD. Can be a hash listmeta.note;instr.setup

Alternative to UCD, very detailed

grain_size_min

DoubleumMin sample particle size 

phys.size;stat.min




grain_size_maxDoubleumMax sample particle size 

phys.size;stat.max




azimuth_minDoubledegMin azimuth angle for illuminationpos.azimuth;stat.min

Check meaning/requirements for <0 values?
UCD added in 2018 (instead of pos.azimuthAng requested - OK)

azimuth_maxDoubledegMax azimuth angle for illuminationpos.azimuth;stat.max

UCD added in 2018

pressure

DoublebarAmbient pressure

phys.pressure



VOunits says: Pascal.

measurement_atmosphere

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

meta.note;phys.pressure




temperatureDoubleKAmbient temperature

phys.temperature




event_type

Text

Type of event from enumerated list

meta.code.class



Events extension
If dataproduct_type = ev
UCDs should be provided with the standard

event_statusText

From enumerated list

meta.code.status




event_citeText

From enumerated list

meta.code.status




...