https://jwst.esac.esa.int/server/tap ObsCore-1.1 ADQL 2.0 2.1 ADQL 2.1

esdc_array_dims(n VARCHAR) -> VARCHAR

esdc_array_element(n VARCHAR, position INTEGER) -> VARCHAR

esdc_array_length(n VARCHAR, dim INTEGER) -> INTEGER

esdc_array_ndims(n VARCHAR) -> INTEGER

esdc_astrometric_parameter_error(e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, parallax DOUBLE, radial_velocity DOUBLE, e_rv DOUBLE) -> DOUBLE[21]

esdc_astrometric_parameters(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE) -> DOUBLE[6]

esdc_cardinality(n VARCHAR) -> INTEGER

esdc_case_condition(default_value VARCHAR, conditions VARCHAR, results VARCHAR) -> VARCHAR

esdc_case_expression(input_value VARCHAR, default_value VARCHAR, condition_values VARCHAR, results VARCHAR) -> VARCHAR

esdc_coalesce(n VARCHAR) -> VARCHAR

esdc_crossmatch_positional(table_schema_a VARCHAR, table_name_a VARCHAR, table_schema_b VARCHAR, table_name_b VARCHAR, radius DOUBLE, output_table_name VARCHAR) -> BIGINT

esdc_current_date() -> TIMESTAMP

esdc_epoch_prop(astrometric_parameters DOUBLE[6], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6]

esdc_epoch_prop(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6]

esdc_epoch_prop_covariance(ra DOUBLE, dec DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, plx_de DOUBLE, pm_ra_ra DOUBLE, pm_ra_de DOUBLE, pm_ra_plx DOUBLE, pm_de_ra DOUBLE, pm_de_de DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6][6]

esdc_epoch_prop_error(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[21]

esdc_epoch_prop_error(astrometric_parameters DOUBLE[6], astrometric_parameter_error DOUBLE[21], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[21]

esdc_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> VARCHAR

esdc_greatest(v1 DOUBLE, v2 DOUBLE) -> DOUBLE

esdc_if_then_else(condition VARCHAR, ouput_value VARCHAR, default_value VARCHAR) -> VARCHAR

esdc_least(v1 DOUBLE, v2 DOUBLE) -> DOUBLE

esdc_left(string VARCHAR, n INTEGER) -> VARCHAR

esdc_length(string VARCHAR) -> INTEGER

esdc_nullif(value1 VARCHAR, value2 VARCHAR) -> VARCHAR

esdc_position(substring VARCHAR, string VARCHAR) -> INTEGER

esdc_radial_velocity(pm_rv DOUBLE, parallax DOUBLE) -> DOUBLE

esdc_right(string VARCHAR, n INTEGER) -> VARCHAR

esdc_stddev(n DOUBLE) -> DOUBLE

esdc_substring(string VARCHAR, start_position INTEGER, length INTEGER) -> VARCHAR

esdc_to_bigint(n DOUBLE) -> BIGINT

esdc_to_boolean(n INTEGER) -> BOOLEAN

esdc_to_char(n DOUBLE) -> VARCHAR

esdc_to_double(n DOUBLE) -> DOUBLE

esdc_to_integer(n DOUBLE) -> INTEGER

esdc_to_real(n DOUBLE) -> REAL

esdc_to_smallint(n DOUBLE) -> SMALLINT

esdc_translate(string VARCHAR, from VARCHAR, to VARCHAR) -> VARCHAR

esdc_trim(characters VARCHAR, string VARCHAR) -> VARCHAR

gavo_ipix(long REAL, lat REAL) -> BIGINT

ivo_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> POINT

ivo_geom_transform(from_sys VARCHAR, to_sys VARCHAR, geo VARCHAR) -> VARCHAR

ivo_hashlist_has(hashlist VARCHAR, item VARCHAR) -> INTEGER

ivo_hasword(needle VARCHAR, haystack VARCHAR) -> INTEGER

ivo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[*]

ivo_interval_overlaps(a1 DOUBLE, b1 DOUBLE, a2 DOUBLE, b2 DOUBLE) -> INTEGER

ivo_nocasematch(value VARCHAR, pattern VARCHAR) -> INTEGER

ivo_normal_random(mu REAL, sigma REAL) -> REAL

ivo_simbadpoint(identifier VARCHAR) -> POINT

ivo_string_agg(expression VARCHAR, delimiter VARCHAR) -> VARCHAR

ivo_to_jd(d TIMESTAMP) -> REAL

ivo_to_mjd(d TIMESTAMP) -> REAL

AREA

BOX

CENTROID

CIRCLE

CONTAINS

COORD1

COORD2

COORDSYS

DISTANCE

INTERSECTS

POINT

POLYGON

REGION

WITH

LOWER

UPPER

ILIKE

UNION

EXCEPT

INTERSECT

OFFSET

CAST

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