European JWST Archive TAP
JWST
ivo://esavo/jwst/tap
European Space Agency
Bruno Merin
esdc_leads@cosmos.esa.int
+34918131456
ESA, JWST, James Webb, Archive, ESAC
This service provides access to observations from the European JWST Science Archive hosted at the ESAC Science Data Centre.
https://jwst.esac.esa.int/archive
https://jwst.esac.esa.int/server/tap
ObsCore-1.1
ADQL
2.0
2.1
ADQL 2.1
Returns a text representation of array dimensions
Parameters:
n: Input array.
Returns the requested element (second argument) of the provided array as first argument in the input
Parameters:
n: Input array.
position: array position of the element to be retrieved where position = 1 refers to the first array element
Returns the length of the requested array dimension
Parameters:
n: Input array.
dim: Input dimension.
Returns the number of dimensions of the array.
Parameters:
n: Input array.
Returns the astrometric parameter errors double array to be used as input for epoch_prop() function
Parameters:
e_ra_deg: Standard Error in Right Ascension (mas)
e_de_deg: Standard Error in Declination (mas)
e_plx: Standard Error in Parallax (mas)
e_pm_ra: Standard Error in Proper Motion in RA (mas/yr)
e_pm_de: Standard Error in Proper Motion in Dec (mas/yr)
de_ra: Correlation Coefficient RA/Dec
plx_ra: Correlation Coefficient Parallax/RA
pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA
pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA
plx_de: Correlation Coefficient Parallax/Dec
pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec
pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec
pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax
pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax
pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec
parallax: Parallax (mas)
radial_velocity: Radial Velocity (km/s)
e_rv: Standard Error in Radial Velocity (km/s)
Returns the astrometric parameters double array to be used as input for epoch_prop() function
Parameters:
ra: Right Ascension (deg)
de: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
Returns the total number of elements in the array, or 0 if the array is empty.
Parameters:
n: Input array.
For an array of input conditions and results, return the first one found true.
Parameters:
default_value: Value to return if all conditions are false.
conditions: Input conditions array.
results: Input results array.
For an array of input conditions and results, return the first one found equal to input value.
Parameters:
input_value: Value to compare condition values with.
default_value: Value to return if none of condition_values equal input_value.
condition_values: Input results array.
results: Input results array.
Returns the first of its arguments that is not null
Parameters:
n: Nth input element.
For input tables, create a positional crossmatch for input radius and store it in a separate table.
Parameters:
table_schema_a: First table schema.
table_name_a: First table name.
table_schema_b: Second table schema.
table_name_b: Second table name.
radius: Crossmatch radius.
output_table_name: Output table name.
Returns a DATE value that represents the current date
Parameters:
Returns all six input parameters (ra,dec,parallax,pm_ra,pm_dec,radial_velocity) propagated at the new arbitrary input epoch. Please note that the input argument radial_velocity denotes radial velocity in km/s while the corresponding output quantity is the radial proper motion in mas/yr computed as radial_velocity * parallax / 4.740,470,464
Parameters:
astrometric_parameters: Array with the full six input parameters needed (ra[deg],dec[deg],plx[mas],pm_ra[mas/yr],pm_dec[mas/yr],pm_rv[mas/yr])
ref_epoch: Reference Julian Epoch
out_epoch: Final Julian Epoch
Returns all six input parameters (ra,dec,parallax,pm_ra,pm_dec,radial_velocity) propagated at the new arbitrary input epoch. Please note that the input argument radial_velocity denotes radial velocity in km/s while the corresponding output quantity is the radial proper motion in mas/yr computed as radial_velocity * parallax / 4.740,470,464
Parameters:
ra: Right Ascension (deg)
de: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
ref_epoch: Reference Julian Epoch
out_epoch: Final Julian Epoch
Returns the propagated covariance matrix from the epoch_prop function
Parameters:
ra: Right Ascension (deg)
dec: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
e_ra_deg: Standard Error in Right Ascension (mas)
e_de_deg: Standard Error in Declination (mas)
e_plx: Standard Error in Parallax (mas)
e_pm_ra: Standard Error in Proper Motion in RA (mas/yr)
e_pm_de: Standard Error in Proper Motion in Dec (mas/yr)
e_rv: Standard Error in Radial Velocity (km/s)
de_ra: Correlation Coefficient RA/Dec
plx_ra: Correlation Coefficient Parallax/RA
plx_de: Correlation Coefficient Parallax/Dec
pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA
pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec
pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax
pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA
pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec
pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax
pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec
ref_epoch: Reference Julian Epoch (yr)
out_epoch: Final Julian Epoch (yr)
Returns the error vector with the uncertainties associated to the propagated astrometric parameters plus the set of propagated correlation parameters
Parameters:
ra: Right Ascension (deg)
de: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
e_ra_deg: Standard Error in Right Ascension (mas)
e_de_deg: Standard Error in Declination (mas)
e_plx: Standard Error in Parallax (mas)
e_pm_ra: Standard Error in Proper Motion in RA (mas/yr)
e_pm_de: Standard Error in Proper Motion in Dec (mas/yr)
e_rv: Standard Error in Radial Velocity (km/s)
de_ra: Correlation Coefficient RA/Dec
plx_ra: Correlation Coefficient Parallax/RA
pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA
pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA
plx_de: Correlation Coefficient Parallax/Dec
pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec
pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec
pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax
pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax
pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec
ref_epoch: Reference Julian Epoch (yr)
out_epoch: Final Julian Epoch (yr)
Returns the error vector with the uncertainties associated to the propagated astrometric parameters plus the set of propagated correlation parameters
Parameters:
astrometric_parameters: Array with the full six input parameters needed (ra[deg],dec[deg],plx[mas],pm_ra[mas/yr],pm_dec[mas/yr],pm_rv[mas/yr])
astrometric_parameter_error: Array with the 21 covariance matrix elements (output from astrometric_parameter_error ADQL function)
ref_epoch: Reference Julian Epoch
out_epoch: Final Julian Epoch
Returns the new position (ra,dec) of the source at the new arbitrary input epoch
Parameters:
ra: Right Ascension (deg)
de: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
ref_epoch: Reference Julian Epoch
out_epoch: Final Julian Epoch
Select the largest value among given arguments.
Parameters:
v1: First argument.
v2: Second argument.
If input condition is true, return output value. Otherwise return default value.
Parameters:
condition: Value to compare to true.
ouput_value: Value to return if condition is true.
default_value: Value to return if condition is false.
Select the smallest value among given arguments.
Parameters:
v1: First argument.
v2: Second argument.
The function returns the first n characters in the string.
Parameters:
string: a string from which a number of the leftmost characters is returned.
n: an integer that specifies the number of left-most characters in the string should be returned. If n is negative, the function returns the leftmost characters in the string but last |n| (absolute) characters.
The function returns the number of characters in the string.
Parameters:
string: the string that you want to calculate its length.
Returns a null value if value1 equals value2; otherwise it returns value1.
Parameters:
value1: Input value 1.
value2: Input value 2.
The function returns the location of a substring in a string.
Parameters:
substring: the string that you want to locate.
string: the string for which the substring is searched.
Returns the radial velocity in units of mas/yr
Parameters:
pm_rv: Radial proper motion (mas/yr)
parallax: Parallax (mas)
The function returns the last n characters in a string.
Parameters:
string: a string from which a number of the rightmost characters is returned.
n: an integer that specifies the number of right-most characters in the string should be returned. If n is negative, the function returns all characters in the string but first |n| (absolute) characters.
Standard deviation.
Parameters:
n: Input value.
The function returns a part of string.
Parameters:
string: the string that you want to get a part extracted.
start_position: an integer that specifies where you want to extract the substring. If start_position equals zero, the substring starts at the first character of the string. The start_position can be only positive
length: a positive integer that determines the number of characters that you want to extract from the string beginning at start_position. If the sum of start_position and length is greater than the number of characters in the string, the substring function returns the whole string beginning at start_position. The length parameter is optional. If you omit the length parameter, the substring function returns the whole string started at start_position.
Converts input value to BIGINT type.
Parameters:
n: Input value.
Converts input value to BOOLEAN type.
Parameters:
n: Input value.
Converts input value to VARCHAR type.
Parameters:
n: Input value.
Converts input value to DOUBLE type.
Parameters:
n: Input value.
Converts input value to INTEGER type.
Parameters:
n: Input value.
Converts input value to REAL type.
Parameters:
n: Input value.
Converts input value to SMALLINT type.
Parameters:
n: Input value.
The function performs several single-character, one-to-one translation in one operation.
Parameters:
string: the string subjected to translation.
from: a set of characters in the first argument (_string_) that should be replaced.
to: a set of characters that replaces the _from_ in the _string_.
removes the longest string that contains a specific character from a string. By default, the function removes spaces if you don’t specify explicitly which character you want to remove.
Parameters:
characters: optional parameter that defines a literal specifying explicitly which characters you want to remove in the string. Accepted literals are: LEADING, TRAILING and BOTH. Example of use: TRIM(BOTH, string)
string: the string for which the removal is requested. Mandatory parameter: example of use: TRIM(string)
Returns the q3c ipix (Koposov and Bartunov, 2006) for a long/lat pair (it simply wraps the q3c_angpix function).
Parameters:
long: The longitude to compute the ipix for.
lat: The latitude to compute the ipix for.
Returns the new position (ra,dec) of the source at the new arbitrary input epoch
Parameters:
ra: Right Ascension (deg)
de: Declination (deg)
parallax: Parallax (mas)
pm_ra: Proper Motion in Right Ascension (mas/yr)
pm_de: Proper Motion in Declination (mas/yr)
radial_velocity: Radial Velocity (km/s)
ref_epoch: Reference Julian Epoch
out_epoch: Final Julian Epoch
The function transforms ADQL geometries between various reference systems.
Parameters:
from_sys: name of the source reference system.
to_sys: name of the target reference system.
geo: an ADQL geometry (POINT, CIRCLE, POLYGON).
The function returns 1 if, compared case-insensitively, the second argument is in the list of words encoded in the first argument, 0 otherwise.
Parameters:
hashlist: A string containing hash-separated terms.
item: A string containing a single term not containing a hash.
Returns 1 if all tokens from the string needle are contained (in some sense) in the string haystack, 0 otherwise.
Parameters:
needle: A string to locate in haystack.
haystack: A text to match needle in.
This aggregate function returns a histogram of val with nbins+2 elements. Assuming 0-based arrays, results[0] contains the number of underflows (i.e., val < lower), result[nbins+1] the number of overflows. Elements 1…nbins are the counts in nbins bins of width (upper−lower)/nbins. Clients will have to convert back to physical units using some external communication, as there currently is no (meta-) data as lower and upper in the TAP response.
Parameters:
val: the value to bin.
lower: the lower limit of the histogram
upper: the upper limit of the histogram
nbins: the number of "natural" bins in the histogram.
Function returns 1 if the interval [a1…b1] overlaps with the interval [a2…b2].
Parameters:
a1: The lower bound of the first interval.
b1: The upper bound of the first interval.
a2: The lower bound of the second interval.
b2: The upper bound of the second interval.
Evaluates value ILIKE pattern, i.e., pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively.
Parameters:
value: A string-valued SQL expression.
pattern: A SQL pattern for LIKE evaluation.
Returns a random number drawn from a normal distribution.
Parameters:
mu: The mean of the normal distribution.
sigma: The width of the normal distribution..
Queries Simbad for an identifier and returns the corresponding point.
Parameters:
identifier: A string containing an identifier Simbad can resolve.
An aggregate function returning all values of expression concatenated with delimiter.
Parameters:
expression: A SQL expression giving the strings to concatenate.
delimiter: A string used to concatenate the values of expression in each group.
Converts a timestamp to a Julian date.
Parameters:
d: The SQL timestamp to convert.
Converts a timestamp to modified Julian date.
Parameters:
d: The SQL timestamp to convert.
application/x-votable+xml
votable_gzip
application/x-votable+xml
votable
application/x-votable+xml
votable_plain
text/csv
csv
text/ecsv
ecsv
text/tab-separated-values
tsv
application/json
json
application/fits
fits
text/xml
votable_plain_conesearch
604800
604800
3600
3600
3000000
3000000
100000000
100000000
https://jwst.esac.esa.int/server/tap/availability
https://jwst.esac.esa.int/server/tap/tables
https://jwst.esac.esa.int/server/tap/examples/
https://jwst.esac.esa.int/server/tap/capabilities
ivoa
ivoa.ObsCore
access_estsize
Estimated size of dataset in kilo bytes
kbyte
phys.size;meta.file
obscore:Access.size
long
primary
access_format
File content format
meta.code.mime
obscore:Access.format
char
primary
access_url
URL used to access (download) dataset
meta.ref.url
obscore:Access.reference
char
primary
calib_level
Calibration level {0, 1, 2, 3, 4}
meta.code;obs.calib
obscore:ObsDataset.calibLevel
int
primary
core_id
char
dataproduct_type
Data product type
meta.code.class
obscore:ObsDataset.dataProductType
char
primary
datarelease
char
em_max
Stop in spectral coordinates
m
em.wl;stat.max
obscore:Char.SpectralAxis.Coverage.Bounds.Limits.HiLimit
double
primary
em_min
Start in spectral coordinates
m
em.wl;stat.min
obscore:Char.SpectralAxis.Coverage.Bounds.Limits.LoLimit
double
primary
em_res_power
Spectral resolving power
spect.resolution
obscore:Char.SpectralAxis.Resolution.ResolPower.refVal
double
primary
em_ucd
Nature of the spectral axis
meta.ucd
obscore:Char.SpectralAxis.ucd
char
primary
em_xel
Number of elements along the spectral axis
meta.number
obscore:Char.SpectralAxis.numBins
long
primary
facility_name
Name of the facility used for this observation
meta.id;instr.tel
obscore:Provenance.ObsConfig.Facility.name
char
primary
hipsname
char
instrument_name
Name of the instrument used for this observation
meta.id;instr
obscore:Provenance.ObsConfig.Instrument.name
char
primary
lastmodified
char
metarelease
char
o_ucd
unitless String UCD of observable
meta.ucd
obscore:Char.ObservableAxis.ucd
char
primary
obs_collection
Name of the data collection
meta.id
obscore:DataID.collection
char
primary
obs_id
Observation ID
meta.id
obscore:DataID.observationID
char
primary
obs_publisher_did
Dataset identifier given by the publisher
meta.ref.ivoid
obscore:Curation.publisherDID
char
primary
obs_release_date
Observation release date (ISO 8601)
time.release
obscore:Curation.releaseDate
char
primary
observing_mode
char
planeid
char
pol_states
List of polarization states or NULL if not applicable
meta.code;phys.polarization
obscore:Char.PolarizationAxis.stateList
char
primary
pol_xel
Number of polarization samples
meta.number
obscore:Char.PolarizationAxis.numBins
long
primary
position_bounds_area
double
position_bounds_center
char
position_bounds_spoly
char
s_dec
Central declination, ICRS
deg
pos.eq.dec
obscore:Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2
double
primary
s_fov
Diameter (bounds) of the covered region
deg
phys.angSize;instr.fov
obscore:Char.SpatialAxis.Coverage.Bounds.Extent.diameter
double
primary
s_ra
Central right ascension, ICRS
deg
pos.eq.ra
obscore:Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1
double
primary
s_region
Sky region covered by the data product(expressed in ICRS frame)
pos.outline;obs.field
obscore:Char.SpatialAxis.Coverage.Support.Area
char
primary
s_resolution
Spatial resolution of data as FWHM
arcsec
pos.angResolution
obscore:Char.SpatialAxis.Resolution.Refval.value
double
primary
s_xel1
Number of elements along the first spatial axis
meta.number
obscore:Char.SpatialAxis.numBins1
long
primary
s_xel2
Number of elements along the second spatial axis
meta.number
obscore:Char.SpatialAxis.numBins2
long
primary
t_exptime
Total exposure time
s
time.duration;obs.exposure
obscore:Char.TimeAxis.Coverage.Support.Extent
double
primary
t_max
Stop time in MJD
d
time.end;obs.exposure
obscore:Char.TimeAxis.Coverage.Bounds.Limits.StopTime
double
primary
t_min
Start time in MJD
d
time.start;obs.exposure
obscore:Char.TimeAxis.Coverage.Bounds.Limits.StartTime
double
primary
t_resolution
Temporal resolution FWHM
s
time.resolution
obscore:Char.TimeAxis.Resolution.Refval.value
double
primary
t_xel
Number of elements along the time axis
meta.number
obscore:Char.TimeAxis.numBins
long
primary
target_name
Astronomical object observed, if any
meta.id;src
obscore:Target.name
char
primary
template
char
job_upload
jwst
JWST CAOM-based schema
jwst
jwst.archive
calibrationlevel
Calibration level {0, 1, 2, 3, 4}
int
collection
Name of the data collection
meta.id
char
dataproducttype
Data product type
char
detector
Name of the detector defined in instrument_keywords
char
energy_bandpassname
Collection-specific name for energy band (e.g. filter name)
char
energy_bounds_lower
Start in spectral coordinates
m
em.wl;stat.min
Char.SpectralAxis.Coverage.Bounds.Limits.LoLimit
double
energy_bounds_upper
Stop in spectral coordinates
m
em.wl;stat.max
Char.SpectralAxis.Coverage.Bounds.Limits.HiLimit
double
energy_bounds_width
Width of the energy bounds
m
double
instrument_name
Name of the instrument used for this observation
meta.id;instr
Provenance.ObsConfig.Instrument.name
char
intent
Intended purpose of data (one of: science, calibration)
char
members
Members of a composite observation (space-separated list of Observation URIs)
char
members_number
Number of observations used to generate this on
int
observationid
Observation ID
meta.id
DataID.observationID
char
observing_mode
Observing Mode extracted from EXP_KEY keyword
char
obsid
Foreign key
char
plane_datarelease
Date the data for a plane is public (UTC)
char
planeid
Foreign key
char
position_bounds_size
Diameter (bounds) of the covered region
deg
phys.angSize;instr.fov
Char.SpatialAxis.Coverage.Bounds.Extent.diameter
double
position_bounds_spoly
Sky region covered by the data product(expressed in ICRS frame)
pos.outline;obs.field
Char.SpatialAxis.Coverage.Support.Area
char
product_url
URL used to access (download) dataset
meta.ref.url
char
proposal_id
Collection-specific unique proposal identifier
char
proposal_keywords
Proposal keywords (separated by |)
char
proposal_pi
Proposal Principal Investigator
char
provenance_reference
char
"public"
Checks if observation is public or not
boolean
subarray
SUBARRAY field extracted from instrument_keywords
char
target_category
TARGETCATEGORY parameter extracted from target_keywords
char
target_keywords
Target keywords (separated by |)
char
target_moving
Flag for moving target
int
target_name
Astronomical object observed, if any
meta.id;src
Target.name
char
targetposition_coordinates_cval1
Central right ascension, ICRS
deg
pos.eq.ra;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1
double
targetposition_coordinates_cval2
Central declination, ICRS
deg
pos.eq.dec;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2
double
template
TEMPLATE parameter extracted from instrument_keywords
char
time_bounds_lower
Start time in MJD
d
time.start;obs.exposure
Char.TimeAxis.Coverage.Bounds.Limits.StartTime
double
time_bounds_upper
Stop time in MJD
d
time.end;obs.exposure
Char.TimeAxis.Coverage.Bounds.Limits.StopTime
double
time_exposure
Total exposure time
s
time.duration;obs.exposure
Char.TimeAxis.Coverage.Support.Extent
double
vis_cube
Flag to determine if cubes are available for this observation
boolean
vis_image
Central wavelength in spectral coordinates
boolean
wave_central
Central wavelength in spectral coordinates
µm
double
jwst.artifact
Physical data artifacts (e.g. files)
accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Artifact.accMetaChecksum
char
artifactid
Unique artifact identifier
caom2:Artifact.id
char
contentchecksum
Checksum of the content (URI of the form {algorithm}:{hex value})
caom2:Artifact.contentChecksum
char
contentlength
Size of the representation at uri
byte
caom2:Artifact.contentLength
long
contenttype
Content-type of the representation at uri
caom2:Artifact.contentType
char
filename
File Name of the product
char
lastmodified
Timestamp of last modification of this row
caom2:Artifact.lastModified
char
maxlastmodified
Timestamp of last modification of this entity+children
caom2:Artifact.maxLastModified
char
metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Artifact.metaChecksum
char
metarelease
Date the metadata for an observation is public (UTC)
caom2:Observation.metaRelease
char
obsid
Foreign key
char
planeid
Foreign key
char
producttype
Product type (science, calibration, auxiliary, preview)
caom2:Artifact.productType
char
releasetype
Release type (data, meta)
caom2:Artifact.releaseType
char
uri
External URI for the physical artifact
caom2:Artifact.uri
char
vis_cube
Flag SET to true if it is a cube
boolean
vis_image
Flag SET to true if it contains a 2D image
boolean
jwst.chunk
Description of the data array in a part
accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Chunk.accMetaChecksum
char
artifactid
Foreign key
char
chunkid
Unique chunk identifier
caom2:Chunk.id
char
energy_axis_axis_ctype
Coordinate type for energy axis
caom2:Chunk.energy.axis.axis.ctype
char
energy_axis_axis_cunit
Coordinate unit for energy axis
caom2:Chunk.energy.axis.axis.cunit
char
energy_axis_bounds
Coordinate bounds for energy axis (string-encoded)
caom2:Chunk.energy.axis.bounds
char
energy_axis_error_rnder
Random coordinate error for energy axis
caom2:Chunk.energy.axis.error.rnder
double
energy_axis_error_syser
Systematic coordinate error for energy axis
caom2:Chunk.energy.axis.error.syser
double
energy_axis_function_delta
Coordinate function for energy axis
caom2:Chunk.energy.axis.function.delta
double
energy_axis_function_naxis
Coordinate function for energy axis
caom2:Chunk.energy.axis.function.naxis
long
energy_axis_function_refcoord_pix
Coordinate function for energy axis
caom2:Chunk.energy.axis.function.refCoord.pix
double
energy_axis_function_refcoord_val
Coordinate function for energy axis
caom2:Chunk.energy.axis.function.refCoord.val
double
energy_axis_range_end_pix
Coordinate range for energy axis
caom2:Chunk.energy.axis.range.end.pix
double
energy_axis_range_end_val
Coordinate range for energy axis
caom2:Chunk.energy.axis.range.end.val
double
energy_axis_range_start_pix
Coordinate range for energy axis
caom2:Chunk.energy.axis.range.start.pix
double
energy_axis_range_start_val
Coordinate range for energy axis
caom2:Chunk.energy.axis.range.start.val
double
energy_bandpassname
Observatory name for the band (e.g. filter name)
caom2:Chunk.energy.bandpassName
char
energy_resolvingpower
Resolving power R
caom2:Chunk.energy.resolvingPower
double
energy_restfrq
RESTFRQ
caom2:Chunk.energy.restfrq
double
energy_restwav
RESTWAV
caom2:Chunk.energy.restwav
double
energy_specsys
SPECSYS
caom2:Chunk.energy.specsys
char
energy_ssysobs
SSYSOBS
caom2:Chunk.energy.ssysobs
char
energy_ssyssrc
SSYSSRC
caom2:Chunk.energy.ssyssrc
char
energy_transition_species
Target element/molecule species
caom2:Chunk.energy.transition.species
char
energy_transition_transition
Target energy transition
caom2:Chunk.energy.transition.transition
char
energy_velang
VELANG
caom2:Chunk.energy.velang
double
energy_velosys
VELOSYS
caom2:Chunk.energy.velosys
double
energy_zsource
ZSOURCE
caom2:Chunk.energy.zsource
double
energyaxis
Axis for the energy coordinate
caom2:Chunk.energyAxis
int
lastmodified
Timestamp of last modification of this row
caom2:Chunk.lastModified
char
maxlastmodified
Timestamp of last modification of this entity+children
caom2:Chunk.maxLastModified
char
metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Chunk.metaChecksum
char
metarelease
Date the metadata for a plane is public (UTC)
caom2:Chunk.metaRelease
char
naxis
Number of data axes
caom2:Chunk.naxis
int
observable_dependent_axis_ctype
Dependent observable axis coordinate type
caom2:Chunk.observable.dependent.axis.ctype
char
observable_dependent_axis_cunit
Dependent observable axis coordinate unit
caom2:Chunk.observable.dependent.axis.cunit
char
observable_dependent_bin
Dependent observable pixel value
caom2:Chunk.observable.dependent.bin
long
observable_independent_axis_ctype
Independent observable axis coordinate type
caom2:Chunk.observable.independent.axis.ctype
char
observable_independent_axis_cunit
Independent observable axis coordinate unit
caom2:Chunk.observable.independent.axis.cunit
char
observable_independent_bin
Independent observable pixel value
caom2:Chunk.observable.independent.bin
long
observableaxis
Axis for the observable quantity
caom2:Chunk.observableAxis
int
obsid
Foreign key
char
partid
Parent identifier
char
planeid
Foreign key
char
polarization_axis_axis_ctype
Coordinate type for polarization axis
caom2:Chunk.polarization.axis.axis.ctype
char
polarization_axis_axis_cunit
Coordinate unit for polarization axis
caom2:Chunk.polarization.axis.axis.cunit
char
polarization_axis_bounds
Coordinate bounds for polarization axis (string-encoded)
caom2:Chunk.polarization.axis.bounds
char
polarization_axis_error_rnder
Random coordinate error for polarization axis
caom2:Chunk.polarization.axis.error.rnder
double
polarization_axis_error_syser
Systematic coordinate error for polarization axis
caom2:Chunk.polarization.axis.error.syser
double
polarization_axis_function_delta
Coordinate function for polarization axis
caom2:Chunk.polarization.axis.function.delta
double
polarization_axis_function_naxis
Coordinate function for polarization axis
caom2:Chunk.polarization.axis.function.naxis
long
polarization_axis_function_refcoord_pix
Coordinate function for polarization axis
caom2:Chunk.polarization.axis.function.refCoord.pix
double
polarization_axis_function_refcoord_val
Coordinate function for polarization axis
caom2:Chunk.polarization.axis.function.refCoord.val
double
polarization_axis_range_end_pix
Coordinate range for time axis
caom2:Chunk.polarization.axis.range.end.pix
double
polarization_axis_range_end_val
Coordinate range for time axis
caom2:Chunk.polarization.axis.range.end.val
double
polarization_axis_range_start_pix
Coordinate range for time axis
caom2:Chunk.polarization.axis.range.start.pix
double
polarization_axis_range_start_val
Coordinate range for time axis
caom2:Chunk.polarization.axis.range.start.val
double
polarizationaxis
Axis for the polarization coordinate
caom2:Chunk.polarizationAxis
int
position_axis_axis1_ctype
Coordinate type for first position axis
caom2:Chunk.position.axis.axis1.ctype
char
position_axis_axis1_cunit
Coordinate unit for first position axis
caom2:Chunk.position.axis.axis1.cunit
char
position_axis_axis2_ctype
Coordinate type for second position axis
caom2:Chunk.position.axis.axis2.ctype
char
position_axis_axis2_cunit
Coordinate unit for second position axis
caom2:Chunk.position.axis.axis2.cunit
char
position_axis_bounds
Coordinate bounds for position axis (string-encoded)
caom2:Chunk.position.axis.bounds
char
position_axis_error1_rnder
Random coordinate error for first position axis
caom2:Chunk.position.axis.error1.rnder
double
position_axis_error1_syser
Systematic coordinate error for first position axis
caom2:Chunk.position.axis.error1.syser
double
position_axis_error2_rnder
Random coordinate error for second position axis
caom2:Chunk.position.axis.error2.rnder
double
position_axis_error2_syser
Systematic coordinate error for second position axis
caom2:Chunk.position.axis.error2.syser
double
position_axis_function_cd11
Coordinate function for position axis
caom2:Chunk.position.axis.function.cd11
double
position_axis_function_cd12
Coordinate function for position axis
caom2:Chunk.position.axis.function.cd12
double
position_axis_function_cd21
Coordinate function for position axis
caom2:Chunk.position.axis.function.cd21
double
position_axis_function_cd22
Coordinate function for position axis
caom2:Chunk.position.axis.function.cd22
double
position_axis_function_dimension_naxis1
Coordinate function for position axis
caom2:Chunk.position.axis.function.dimension.naxis1
long
position_axis_function_dimension_naxis2
Coordinate function for position axis
caom2:Chunk.position.axis.function.dimension.naxis2
long
position_axis_function_refcoord_coord1_pix
Coordinate function for position axis
caom2:Chunk.position.axis.function.refCoord.coord1.pix
double
position_axis_function_refcoord_coord1_val
Coordinate function for position axis
caom2:Chunk.position.axis.function.refCoord.coord1.val
double
position_axis_function_refcoord_coord2_pix
Coordinate function for position axis
caom2:Chunk.position.axis.function.refCoord.coord2.pix
double
position_axis_function_refcoord_coord2_val
Coordinate function for position axis
caom2:Chunk.position.axis.function.refCoord.coord2.val
double
position_axis_range_end_coord1_pix
Coordinate range for position axis
caom2:Chunk.position.axis.range.end.coord1.pix
double
position_axis_range_end_coord1_val
Coordinate range for position axis
caom2:Chunk.position.axis.range.end.coord1.val
double
position_axis_range_end_coord2_pix
Coordinate range for position axis
caom2:Chunk.position.axis.range.end.coord2.pix
double
position_axis_range_end_coord2_val
Coordinate range for position axis
caom2:Chunk.position.axis.range.end.coord2.val
double
position_axis_range_start_coord1_pix
Coordinate range for position axis
caom2:Chunk.position.axis.range.start.coord1.pix
double
position_axis_range_start_coord1_val
Coordinate range for position axis
caom2:Chunk.position.axis.range.start.coord1.val
double
position_axis_range_start_coord2_pix
Coordinate range for position axis
caom2:Chunk.position.axis.range.start.coord2.pix
double
position_axis_range_start_coord2_val
Coordinate range for position axis
caom2:Chunk.position.axis.range.start.coord2.val
double
position_coordsys
Coordinate system name
caom2:Chunk.position.coordsys
char
position_equinox
Coordinate equinox
a
caom2:Chunk.position.equinox
double
position_resolution
Median spatial resolution (FWHM)
arcsec
caom2:Chunk.position.resolution
double
positionaxis1
Axis for the first position coordinate
caom2:Chunk.positionAxis1
int
positionaxis2
Axis for the second position coordinate
caom2:Chunk.positionAxis2
int
producttype
Deprecated
caom2:Chunk.productType
char
time_axis_axis_ctype
Coordinate type for time axis
caom2:Chunk.time.axis.axis.ctype
char
time_axis_axis_cunit
Coordinate unit for time axis
caom2:Chunk.time.axis.axis.cunit
char
time_axis_bounds
Coordinate bounds for time axis (string-encoded)
caom2:Chunk.time.axis.bounds
char
time_axis_error_rnder
Random coordinate error for time axis
caom2:Chunk.time.axis.error.rnder
double
time_axis_error_syser
Systematic coordinate error for time axis
caom2:Chunk.time.axis.error.syser
double
time_axis_function_delta
Coordinate function for time axis
caom2:Chunk.time.axis.function.delta
double
time_axis_function_naxis
Coordinate function for time axis
caom2:Chunk.time.axis.function.naxis
long
time_axis_function_refcoord_pix
Coordinate function for time axis
caom2:Chunk.time.axis.function.refCoord.pix
double
time_axis_function_refcoord_val
Coordinate function for time axis
caom2:Chunk.time.axis.function.refCoord.val
double
time_axis_range_end_pix
Coordinate range for time axis
caom2:Chunk.time.axis.range.end.pix
double
time_axis_range_end_val
Coordinate range for time axis
caom2:Chunk.time.axis.range.end.val
double
time_axis_range_start_pix
Coordinate range for time axis
caom2:Chunk.time.axis.range.start.pix
double
time_axis_range_start_val
Coordinate range for time axis
caom2:Chunk.time.axis.range.start.val
double
time_exposure
Median exposure time per pixel
s
caom2:Chunk.time.exposure
double
time_mjdref
Reference MJD value
d
caom2:Chunk.time.mjdref
double
time_resolution
Resolution on time axis
s
caom2:Chunk.time.resolution
double
time_timesys
Time system
caom2:Chunk.time.timesys
char
time_trefpos
Time reference position
caom2:Chunk.time.trefpos
char
timeaxis
Axis for the time coordinate
caom2:Chunk.timeAxis
int
jwst.harvestskipuri
Table with CAOM synchronization issues
cname
char
errormessage
char
id
char
lastmodified
char
skipid
char
source
char
tryafter
char
jwst.main
Table with joins for observation, artifact and plane tables
algorithm_name
Algorithm that defines the observation( exposure for simple, grouping algorithm for composites)
caom2:Observation.algorithm.name
char
calibrationlevel
IVOA ObsCore calibration level + extensions (-1,0,1,2,3,4)
caom2:Plane.calibrationLevel
int
collection
Data collection this observation belongs to
caom2:Observation.collection
char
creatorid
Unique creator identifier for this product
caom2:Plane.creatorID
char
dataproducttype
IVOA ObsCore data product type + extensions
caom2:Plane.dataProductType
char
energy_bandpassname
Collection-specific name for energy band (e.g. filter name)
caom2:Plane.energy.bandpassName
char
energy_bounds
Energy coverage (barycentric wavelength)
m
caom2:Plane.energy.bounds
char
energy_bounds_lower
Lower bound on energy axis (barycentric wavelength)
m
caom2:Plane.energy.bounds.lower
double
energy_bounds_upper
Upper bound on energy axis (barycentric wavelength)
m
caom2:Plane.energy.bounds.upper
double
energy_bounds_width
Width of the energy bounds
m
caom2:Plane.energy.bounds.width
double
energy_dimension
Dimension (number of pixels) along energy axis
caom2:Plane.energy.dimension
long
energy_energybands
Energy band names (Radio,Millimeter,Infrared,Optical,UV,EUV,X-ray,Gamma-ray separated by | [new in 2.4]
caom2:Plane.energy.energyBands
char
energy_freqsamplesize
Median sample (pixel) size on energy axis (convenience: in frequency)
Hz
caom2:Plane.energy.freqSampleSize
double
energy_freqwidth
Width of the energy bounds (convenience: in frequency)
Hz
caom2:Plane.energy.freqWidth
double
energy_resolvingpower
Median spectral resolving power (R)
caom2:Plane.energy.resolvingPower
double
energy_restwav
Rest wavelength of target spectral feature (barycentric)
m
caom2:Plane.energy.restwav
double
energy_samplesize
Median sample (pixel) size on energy axis
m
caom2:Plane.energy.sampleSize
double
energy_transition_species
Atom or molecule
caom2:Plane.energy.transition.species
char
energy_transition_transition
Specific energy transition of species
caom2:Plane.energy.transition.transition
char
environment_ambienttemp
Ambient temperature telescope during observation
C
caom2:Observation.environment.ambientTemp
double
environment_elevation
Elevation above horizon (0 to 90)
deg
caom2:Observation.environment.elevation
double
environment_humidity
Humidity at telescope during observation
caom2:Observation.environment.humidity
double
environment_photometric
Conditions were photometric (0=false, 1=true)
caom2:Observation.environment.photometric
int
environment_seeing
Atmospheric seeing (FWHM)
arcsec
caom2:Observation.environment.seeing
double
environment_tau
Zenith optical depth
caom2:Observation.environment.tau
double
environment_wavelengthtau
Wavelength at which Tau has been measured
m
caom2:Observation.environment.wavelengthTau
double
instrument_keywords
Instrument keywords (separated by |)
caom2:Observation.instrument.keywords
char
instrument_name
Name of instrument used to acquire observation
caom2:Observation.instrument.name
char
intent
Intended purpose of data (one of: science, calibration)
caom2:Observation.intent
char
max_cal_level
Maximum cal. level available for this observation
int
members
Members of a composite observation (space-separated list of Observation URIs)
caom2:Observation.members
char
metrics_background
Background intensity
Jy/pix
caom2:Plane.metrics.background
double
metrics_backgroundstddev
Standard deviation in background
Jy/pix
caom2:Plane.metrics.backgroundStddev
double
metrics_fluxdensitylimit
Flux density limit where S:N=5 for point source
Jy
caom2:Plane.metrics.fluxDensityLimit
double
metrics_maglimit
AB magnitude limit where S:N=5 for point source
caom2:Plane.metrics.magLimit
double
metrics_sourcenumberdensity
Number density of sources
deg-2
caom2:Plane.metrics.sourceNumberDensity
double
obs_accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Observation.accMetaChecksum
char
obs_lastmodified
Timestamp of last modification of this row
caom2:Observation.lastModified
char
obs_maxlastmodified
Timestamp of last modification of this entity+children
caom2:Observation.maxLastModified
char
obs_metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Observation.metaChecksum
char
obs_metarelease
Date the metadata for a plane is public (UTC)
caom2:Observation.metaRelease
char
observationid
Collection-specific unique observation identifier
caom2:Observation.observationID
char
observationuri
char
obsid
Unique observation identifier
caom2:Observation.id
char
parenturi
char
plane_accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Plane.accMetaChecksum
char
plane_datarelease
Date the data for a plane is public (UTC)
caom2:Plane.dataRelease
char
plane_lastmodified
Timestamp of last modification of this row
caom2:Plane.lastModified
char
plane_maxlastmodified
Timestamp of last modification of this entity+children
caom2:Plane.maxLastModified
char
plane_metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Plane.metaChecksum
char
plane_metarelease
Date the metadata for a plane is public (UTC)
caom2:Observation.metaRelease
char
planeid
Unique plane identifier
caom2:Plane.id
char
planeuri
Unique internal URI for this product
caom2:Plane.uri
char
polarization_dimension
Number of samples (pixels) along polarization axis
caom2:Plane.polarization.dimension
int
polarization_states
Polarization letter codes in canonical order, separated by /
caom2:Plane.polarization.states
char
position_bounds_area
double
position_bounds_center
char
position_bounds_size
Size of the polygon bounds (diameter of minimum spanning circle)
deg
caom2:Plane.position.bounds.size
double
position_bounds_spoly
char
position_dimension_naxis1
Dimensions (number of pixels) along one spatial axis
caom2:Plane.position.dimension.naxis1
long
position_dimension_naxis2
Dimensions (number of pixels) along other spatial axis
caom2:Plane.position.dimension.naxis2
long
position_resolution
Median spatial resolution (FWHM)
arcsec
caom2:Plane.position.resolution
double
position_samplesize
Median sample (pixel) size on spatial axes
arcsec
caom2:Plane.position.sampleSize
double
position_timedependent
Flag indicating that the position is time-dependent (0=false, 1=true)
caom2:Plane.position.timeDependent
int
productid
Name of this product
caom2:Plane.productID
char
proposal_id
Collection-specific unique proposal identifier
caom2:Observation.proposal.id
char
proposal_keywords
Proposal keywords (separated by |)
caom2:Observation.proposal.keywords
char
proposal_pi
Proposal principal investigator
caom2:Observation.proposal.pi
char
proposal_project
Project that created/acquired the observation
caom2:Observation.proposal.project
char
proposal_title
Proposal title
caom2:Observation.proposal.title
char
provenance_inputs
Inputs of the process that created this plane (space-separated list of Plane URIs)
caom2:Plane.provenance.inputs
char
provenance_keywords
Provenance keywords (separated by |)
caom2:Plane.provenance.keywords
char
provenance_lastexecuted
Date this process was last executed
caom2:Plane.provenance.lastExecuted
char
provenance_name
Name of the process that created this plane
caom2:Plane.provenance.name
char
provenance_producer
Responsible entity (e.g. person)
caom2:Plane.provenance.producer
char
provenance_project
Responsible entity (e.g. person)
caom2:Plane.provenance.project
char
provenance_reference
External reference (URL)
caom2:Plane.provenance.reference
char
provenance_runid
Responsible entity (e.g. person)
caom2:Plane.provenance.runID
char
provenance_version
Version of the process/software
caom2:Plane.provenance.version
char
"public"
True if datarelease<= now
boolean
publisherid
Unique publisher identifier for this product
caom2:Plane.publisherID
char
quality_flag
Flag describing the data quality (possible values: junk)
caom2:Plane.quality.flag
char
requirements_flag
Flag describing satisfied proposal requirements (possible values: fail)
caom2:Observation.requirements.flag
char
sequencenumber
Sequence number assigned by the observatory
caom2:Observation.sequenceNumber
int
target_dec
Central declination, ICRS
deg
pos.eq.dec;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2
double
target_keywords
Target keywords (separated by |)
caom2:Observation.target.keywords
char
target_moving
Flag for moving target
caom2:Observation.target.moving
int
target_name
Name of intended target
caom2:Observation.target.name
char
target_ra
Central right ascension, ICRS
deg
pos.eq.ra;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1
double
target_redshift
Redshift of intended target
caom2:Observation.target.redshift
double
target_standard
Intended target is a standard (0=false, 1=true)
caom2:Observation.target.standard
int
target_type
Classification of intended target
caom2:Observation.target.type
char
targetposition_coordsys
Coordinate system for target position
caom2:Observation.targetPosition.coordsys
char
targetposition_equinox
Equinox of target position coordinate system
caom2:Observation.targetPosition.equinox
double
telescope_geolocationx
X component of geocentric location of telescope
caom2:Observation.telescope.geoLocationX
double
telescope_geolocationy
Y component of geocentric location of telescope
caom2:Observation.telescope.geoLocationY
double
telescope_geolocationz
Z component of geocentric location of telescope
caom2:Observation.telescope.geoLocationZ
double
telescope_keywords
Telescope keywords (separated by |)
caom2:Observation.telescope.keywords
char
telescope_name
Telescope keywords (separated by |)
caom2:Observation.telescope.name
char
time_bounds
Time coverage (Modified Julian Day)
d
caom2:Plane.time.bounds
char
time_bounds_lower
Lower bound on time axis (Modified Julian Day)
d
caom2:Plane.time.bounds.lower
double
time_bounds_upper
Upper bound on time axis (Modified Julian Day)
d
caom2:Plane.time.bounds.upper
double
time_bounds_width
Width of the time bounds
d
caom2:Plane.time.bounds.width
double
time_dimension
Dimension (number of pixels) along time axis
caom2:Plane.time.dimension
long
time_exposure
Median exposure time per pixel
s
caom2:Plane.time.exposure
double
time_resolution
Median resolution on the time axis
d
caom2:Plane.time.resolution
double
time_samplesize
Median sample (pixel) size on time axis
d
caom2:Plane.time.sampleSize
double
type
Type of data collected (e.g. FITS OBSTYPE header)
caom2:Observation.type
char
typecode
Single character code to denote type: S(impleObservation) or C(ompositeOvservation)
caom2:Observation.typeCode
char
jwst.moc
nside
long
observationid
char
pixelno
int
"public"
boolean
stcs
char
type
char
jwst.mv_archive_angular
calibrationlevel
Calibration level {0, 1, 2, 3, 4}
int
collection
Name of the data collection
meta.id
char
dataproducttype
Data product type
char
dec
double
detector
Name of the detector defined in instrument_keywords
char
energy_bandpassname
Collection-specific name for energy band (e.g. filter name)
char
energy_bounds_lower
Start in spectral coordinates
m
em.wl;stat.min
Char.SpectralAxis.Coverage.Bounds.Limits.LoLimit
double
energy_bounds_upper
Stop in spectral coordinates
m
em.wl;stat.max
Char.SpectralAxis.Coverage.Bounds.Limits.HiLimit
double
energy_bounds_width
Width of the energy bounds
m
double
instrument_name
Name of the instrument used for this observation
meta.id;instr
Provenance.ObsConfig.Instrument.name
char
intent
Intended purpose of data (one of: science, calibration)
char
members
Members of a composite observation (space-separated list of Observation URIs)
char
members_number
Number of observations used to generate this on
int
observationid
Observation ID
meta.id
DataID.observationID
char
observing_mode
Observing Mode extracted from EXP_KEY keyword
char
obsid
Foreign key
char
plane_datarelease
Date the data for a plane is public (UTC)
char
planeid
Foreign key
char
position_bounds_size
Diameter (bounds) of the covered region
deg
phys.angSize;instr.fov
Char.SpatialAxis.Coverage.Bounds.Extent.diameter
double
position_bounds_spoly
Sky region covered by the data product(expressed in ICRS frame)
pos.outline;obs.field
Char.SpatialAxis.Coverage.Support.Area
double
product_url
URL used to access (download) dataset
meta.ref.url
char
proposal_id
Collection-specific unique proposal identifier
char
proposal_keywords
Proposal keywords (separated by |)
char
proposal_pi
Proposal Principal Investigator
char
provenance_reference
char
"public"
Checks if observation is public or not
boolean
ra
double
ra_h
double
subarray
SUBARRAY field extracted from instrument_keywords
char
target_category
TARGETCATEGORY parameter extracted from target_keywords
char
target_description
char
target_keywords
Target keywords (separated by |)
char
target_moving
Flag for moving target
int
target_name
Astronomical object observed, if any
meta.id;src
Target.name
char
template
TEMPLATE parameter extracted from instrument_keywords
char
time_bounds_lower
Start time in MJD
d
time.start;obs.exposure
Char.TimeAxis.Coverage.Bounds.Limits.StartTime
char
time_bounds_upper
Stop time in MJD
d
time.end;obs.exposure
Char.TimeAxis.Coverage.Bounds.Limits.StopTime
char
time_exposure
Total exposure time
s
time.duration;obs.exposure
Char.TimeAxis.Coverage.Support.Extent
double
vis_cube
Flag to determine if cubes are available for this observation
boolean
vis_image
Central wavelength in spectral coordinates
boolean
wave_central
Central wavelength in spectral coordinates
µm
double
jwst.observation
The main CAOM Observation table
accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Observation.accMetaChecksum
char
algorithm_name
Algorithm that defines the observation( exposure for simple, grouping algorithm for composites)
caom2:Observation.algorithm.name
char
collection
Data collection this observation belongs to
caom2:Observation.collection
char
environment_ambienttemp
Ambient temperature telescope during observation
C
caom2:Observation.environment.ambientTemp
double
environment_elevation
Elevation above horizon (0 to 90)
deg
caom2:Observation.environment.elevation
double
environment_humidity
Humidity at telescope during observation
caom2:Observation.environment.humidity
double
environment_photometric
Conditions were photometric (0=false, 1=true)
caom2:Observation.environment.photometric
int
environment_seeing
Atmospheric seeing (FWHM)
arcsec
caom2:Observation.environment.seeing
double
environment_tau
Zenith optical depth
caom2:Observation.environment.tau
double
environment_wavelengthtau
Wavelength at which Tau has been measured
m
caom2:Observation.environment.wavelengthTau
double
instrument_keywords
Instrument keywords (separated by |)
caom2:Observation.instrument.keywords
char
instrument_name
Name of instrument used to acquire observation
caom2:Observation.instrument.name
char
intent
Intended purpose of data (one of: science, calibration)
caom2:Observation.intent
char
lastmodified
Timestamp of last modification of this row
caom2:Observation.lastModified
char
maxlastmodified
Timestamp of last modification of this entity+children
caom2:Observation.maxLastModified
char
members
Members of a composite observation (space-separated list of Observation URIs)
caom2:Observation.members
char
metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Observation.metaChecksum
char
metarelease
Date the metadata for an observation is public (UTC)
caom2:Observation.metaRelease
char
observationid
Collection-specific unique observation identifier
caom2:Observation.observationID
char
observationuri
char
obsid
Unique observation identifier
caom2:Observation.id
char
proposal_id
Collection-specific unique proposal identifier
caom2:Observation.proposal.id
char
proposal_keywords
Proposal keywords (separated by |)
caom2:Observation.proposal.keywords
char
proposal_pi
Proposal principal investigator
caom2:Observation.proposal.pi
char
proposal_project
Project that created/acquired the observation
caom2:Observation.proposal.project
char
proposal_title
Proposal title
caom2:Observation.proposal.title
char
requirements_flag
Flag describing satisfied proposal requirements (possible values: fail)
caom2:Observation.requirements.flag
char
sequencenumber
Sequence number assigned by the observatory
caom2:Observation.sequenceNumber
int
target_keywords
Target keywords (separated by |)
caom2:Observation.target.keywords
char
target_moving
Flag for moving target
caom2:Observation.target.moving
int
target_name
Name of intended target
caom2:Observation.target.name
char
target_redshift
Redshift of intended target
caom2:Observation.target.redshift
double
target_standard
Intended target is a standard (0=false, 1=true)
caom2:Observation.target.standard
int
target_type
Classification of intended target
caom2:Observation.target.type
char
targetposition_coordinates_cval1
Central right ascension, ICRS
deg
pos.eq.ra;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1
double
targetposition_coordinates_cval2
Central declination, ICRS
deg
pos.eq.dec;meta.main
Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2
double
targetposition_coordsys
Coordinate system for target position
caom2:Observation.targetPosition.coordsys
char
targetposition_equinox
Equinox of target position coordinate system
caom2:Observation.targetPosition.equinox
double
telescope_geolocationx
X component of geocentric location of telescope
caom2:Observation.telescope.geoLocationX
double
telescope_geolocationy
Y component of geocentric location of telescope
caom2:Observation.telescope.geoLocationY
double
telescope_geolocationz
Z component of geocentric location of telescope
caom2:Observation.telescope.geoLocationZ
double
telescope_keywords
Telescope keywords (separated by |)
caom2:Observation.telescope.keywords
char
telescope_name
Name of telescope used to acquire observation
caom2:Observation.telescope.name
char
type
Type of data collected (e.g. FITS OBSTYPE header)
caom2:Observation.type
char
typecode
Single character code to denote type: S(impleObservation) or C(ompositeOvservation)
caom2:Observation.typeCode
char
jwst.observationmember
Composite to simple observation join table
memberid
Member observation identifier [changed in 2.4]
char
parentid
Parent observation identifier [changed in 2.4]
char
jwst.part
Parts of artifacts (e.g. FITS extensions)
accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Part.accMetaChecksum
char
artifactid
Foreign key
char
lastmodified
Timestamp of last modification of this row
caom2:Part.lastModified
char
maxlastmodified
Timestamp of last modification of this entity+children
caom2:Part.maxLastModified
char
metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Part.metaChecksum
char
metarelease
Date the metadata for a plane is public (UTC)
caom2:Part.metaRelease
char
name
Name of this part
caom2:Part.name
char
obsid
Foreign key
char
partid
Unique part identifier
caom2:Part.id
char
planeid
Foreign key
char
producttype
Product type (science, calibration, auxiliary, preview, info)
caom2:Part.productType
char
jwst.plane
The products of the observation
accmetachecksum
Checksum of the metadata in this entity+children (URI of the form {algorithm}:{hex value})
caom2:Plane.accMetaChecksum
char
calibrationlevel
IVOA ObsCore calibration level + extensions (-1,0,1,2,3,4)
caom2:Plane.calibrationLevel
int
creatorid
Unique creator identifier for this product
caom2:Plane.creatorID
char
dataproducttype
IVOA ObsCore data product type + extensions
caom2:Plane.dataProductType
char
datarelease
Date the data for a plane is public (UTC)
caom2:Plane.dataRelease
char
energy_bandpassname
Collection-specific name for energy band (e.g. filter name)
caom2:Plane.energy.bandpassName
char
energy_bounds
Energy coverage (barycentric wavelength)
m
caom2:Plane.energy.bounds
char
energy_bounds_lower
Lower bound on energy axis (barycentric wavelength)
m
caom2:Plane.energy.bounds.lower
double
energy_bounds_upper
Upper bound on energy axis (barycentric wavelength)
m
caom2:Plane.energy.bounds.upper
double
energy_bounds_width
Width of the energy bounds
m
caom2:Plane.energy.bounds.width
double
energy_dimension
Dimension (number of pixels) along energy axis
caom2:Plane.energy.dimension
long
energy_energybands
Energy band names (Radio,Millimeter,Infrared,Optical,UV,EUV,X-ray,Gamma-ray separated by | [new in 2.4]
caom2:Plane.energy.energyBands
char
energy_freqsamplesize
Median sample (pixel) size on energy axis (convenience: in frequency)
Hz
caom2:Plane.energy.freqSampleSize
double
energy_freqwidth
Width of the energy bounds (convenience: in frequency)
Hz
caom2:Plane.energy.freqWidth
double
energy_resolvingpower
Median spectral resolving power (R)
caom2:Plane.energy.resolvingPower
double
energy_restwav
Rest wavelength of target spectral feature (barycentric)
m
caom2:Plane.energy.restwav
double
energy_samplesize
Median sample (pixel) size on energy axis
m
caom2:Plane.energy.sampleSize
double
energy_transition_species
Atom or molecule
caom2:Plane.energy.transition.species
char
energy_transition_transition
Specific energy transition of species
caom2:Plane.energy.transition.transition
char
lastmodified
Timestamp of last modification of this row
caom2:Plane.lastModified
char
maxlastmodified
Timestamp of last modification of this entity+children
caom2:Plane.maxLastModified
char
metachecksum
Checksum of the metadata in this entity (URI of the form {algorithm}:{hex value})
caom2:Plane.metaChecksum
char
metarelease
Date the metadata for a plane is public (UTC)
caom2:Plane.metaRelease
char
metrics_background
Background intensity
Jy/pix
caom2:Plane.metrics.background
double
metrics_backgroundstddev
Standard deviation in background
Jy/pix
caom2:Plane.metrics.backgroundStddev
double
metrics_fluxdensitylimit
Flux density limit where S:N=5 for point source
Jy
caom2:Plane.metrics.fluxDensityLimit
double
metrics_maglimit
AB magnitude limit where S:N=5 for point source
caom2:Plane.metrics.magLimit
double
metrics_sourcenumberdensity
Number density of sources
deg-2
caom2:Plane.metrics.sourceNumberDensity
double
obsid
Foreign key
char
planeid
Unique plane identifier
caom2:Plane.id
char
planeuri
Unique internal URI for this product
caom2:Plane.uri
char
polarization_dimension
Number of samples (pixels) along polarization axis
caom2:Plane.polarization.dimension
int
polarization_states
Polarization letter codes in canonical order, separated by /
caom2:Plane.polarization.states
char
position_bounds_area
double
position_bounds_center
char
position_bounds_size
Size of the polygon bounds (diameter of minimum spanning circle)
deg
caom2:Plane.position.bounds.size
double
position_bounds_spoly
char
position_bounds_stcs
String polygon of the footprint
char
position_dimension_naxis1
Dimensions (number of pixels) along one spatial axis
caom2:Plane.position.dimension.naxis1
long
position_dimension_naxis2
Dimensions (number of pixels) along other spatial axis
caom2:Plane.position.dimension.naxis2
long
position_resolution
Median spatial resolution (FWHM)
arcsec
caom2:Plane.position.resolution
double
position_samplesize
Median sample (pixel) size on spatial axes
arcsec
caom2:Plane.position.sampleSize
double
position_timedependent
Flag indicating that the position is time-dependent (0=false, 1=true)
caom2:Plane.position.timeDependent
int
productid
Name of this product
caom2:Plane.productID
char
provenance_inputs
Inputs of the process that created this plane (space-separated list of Plane URIs)
caom2:Plane.provenance.inputs
char
provenance_keywords
Provenance keywords (separated by |)
caom2:Plane.provenance.keywords
char
provenance_lastexecuted
Date this process was last executed
caom2:Plane.provenance.lastExecuted
char
provenance_name
Name of the process that created this plane
caom2:Plane.provenance.name
char
provenance_producer
Responsible entity (e.g. person)
caom2:Plane.provenance.producer
char
provenance_project
Responsible entity (e.g. person)
caom2:Plane.provenance.project
char
provenance_reference
External reference (URL)
caom2:Plane.provenance.reference
char
provenance_runid
Responsible entity (e.g. person)
caom2:Plane.provenance.runID
char
provenance_version
Version of the process/software
caom2:Plane.provenance.version
char
"public"
True if datarelease<= now
boolean
publisherid
Unique publisher identifier for this product
caom2:Plane.publisherID
char
quality_flag
Flag describing the data quality (possible values: junk)
caom2:Plane.quality.flag
char
time_bounds
Time coverage (Modified Julian Day)
d
caom2:Plane.time.bounds
char
time_bounds_lower
Lower bound on time axis (Modified Julian Day)
d
caom2:Plane.time.bounds.lower
double
time_bounds_upper
Upper bound on time axis (Modified Julian Day)
d
caom2:Plane.time.bounds.upper
double
time_bounds_width
Width of the time bounds
d
caom2:Plane.time.bounds.width
double
time_dimension
Dimension (number of pixels) along time axis
caom2:Plane.time.dimension
long
time_exposure
Median exposure time per pixel
s
caom2:Plane.time.exposure
double
time_resolution
Median resolution on the time axis
d
caom2:Plane.time.resolution
double
time_samplesize
Median sample (pixel) size on time axis
d
caom2:Plane.time.sampleSize
double
jwst.plane_vis
planeid
char
vis_cube
boolean
vis_image
boolean
public
public.dual
auxiliary table to be used as dummy "from"
dummy
int
tap_config
tap_config.coord_sys
epoch
char
equinox
char
id
char
system
char
xml_output
char
tap_config.properties
"key"
char
"value"
char
tap_schema
tap_schema.columns
TAP SCHEMA columns
arraysize
char
column_index
int
column_name
char
datatype
char
db_column_name
char
description
char
indexed
int
principal
int
schema_name
char
"size"
int
std
int
table_name
char
ucd
char
unit
char
utype
char
xtype
char
tap_schema.tables
table_name
table_name
TAP schema table name
tap_schema.key_columns
TAP SCHEMA key columns
from_column
char
key_id
char
target_column
char
tap_schema.keys
key_id
key_id
TAP schema key columns key id
tap_schema.keys
TAP SCHEMA keys
description
char
from_table
char
key_id
char
target_table
char
utype
char
tap_schema.tables
from_table
table_name
TAP schema keys from table
tap_schema.tables
target_table
table_name
TAP schema keys target table
tap_schema.schemas
TAP SCHEMA schemas
db_schema_name
char
description
char
schema_index
int
schema_name
char
utype
char
tap_schema.tables
TAP SCHEMA tables
db_table_name
char
description
char
schema_name
char
"size"
long
size_bytes
long
table_index
int
table_name
char
table_type
char
utype
char
tap_schema.schemas
schema_name
schema_name
TAP schema schema name
tap_upload