HREDA TAP

HREDA TAP HREDA ivo://esavo/hreda/tap European Space Agency Jacqueline Myrrhe Jacqueline.Myrrhe@ext.esa.int -- ESA, HREDA, Archive, ESAC This service provides access to investigation for the HREDA archive hosted at the ESAC Science Data Centre https://hreda.esac.esa.int/hreda https://hreda.esac.esa.int/hreda-sl-tap/tap 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,de,parallax,pm_ra,pm_de,radial_velocity) propagated from the reference epoch to an arbitrary epoch. 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,de,parallax,pm_ra,pm_de,radial_velocity) propagated from the reference epoch to an arbitrary 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 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: 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 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 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 259200 259200 10800 10800 100000000 100000000 https://hreda.esac.esa.int/hreda-sl-tap/tap/availability https://hreda.esac.esa.int/hreda-sl-tap/tap/tables https://hreda.esac.esa.int/hreda-sl-tap/tap/examples/ https://hreda.esac.esa.int/hreda-sl-tap/tap/capabilities hreda hreda.affiliation active boolean address char affiliation_id char affiliation_name char affiliation_oid int country char

hreda.experiment active boolean end_date char experiment_id char experiment_name char experiment_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char involved_crew char last_update_date char operations_entity char start_date char

hreda.experiment_mission experiment_id char experiment_mission_oid int experiment_name char experiment_oid int hre_mission_oid int

hreda.hre_category active boolean category_icon_path char display_order int hre_category_id char hre_category_name char hre_category_oid int is_displayed boolean

hreda.hre_mission active boolean end_date char hre_mission_id char hre_mission_name char hre_mission_oid int platform_id char platform_name char platform_oid int start_date char

hreda.industrial_partner affiliation_id char affiliation_name char affiliation_oid int industrial_partner_name char industrial_partner_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char

hreda.investigation_attachment active boolean description char file_name char file_path char file_size long ingestion_date char investigation_attachment_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char

hreda.investigation_keyword investigation_keyword_oid int investigation_oid int keyword_oid int

hreda.investigation_publication investigation_id char investigation_name char investigation_oid int investigation_publication_oid int investigation_unique_acronym char publication char

hreda.investigation_reference investigation_id char investigation_name char investigation_oid int investigation_reference_oid int investigation_unique_acronym char reference char

hreda.key_question active boolean hre_category_id char hre_category_name char hre_category_oid int key_question_id char key_question_name char key_question_oid int

hreda.keyword active boolean keyword_id char keyword_name char keyword_oid int

hreda.platform active boolean display_order int is_operative boolean platform_group_id char platform_group_name char platform_group_oid int platform_id char platform_name char platform_oid int

hreda.platform_group active boolean display_order int is_displayed boolean platform_group_icon_path char platform_group_id char platform_group_name char platform_group_oid int

hreda.sponsor affiliation_id char affiliation_name char affiliation_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char sponsor_name char sponsor_oid int

hreda.team_coordinator affiliation_id char affiliation_name char affiliation_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char team_coordinator_name char team_coordinator_oid int

hreda.team_member_list team_member_list_oid int team_member_name char

hreda.v_dataset data_available boolean dataset_description char dataset_doi char dataset_name char dataset_oid int dataset_unique_acronym char end_date char investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char is_forbidden boolean last_update_date char prior_access_days int prior_access_end_date char prior_access_initial_date char start_date char subjects char

hreda.v_doi_investigation active boolean ancillary_data_available boolean data_available boolean earth_benefits char end_date char facilities char hre_category_id char hre_category_name char hre_category_oid int investigation_doi char investigation_id char investigation_name char investigation_oid int investigation_op_nom char investigation_short_title char investigation_title char investigation_unique_acronym char ipr_data boolean is_published boolean key_question_id char key_question_name char key_question_oid int keywords char last_update_date char medical_sensitive boolean mission_name char objectives char payload char platform_id char platform_name char platform_oid int "procedure" char publications_list char references_list char results char short_description char space_benefits char start_date char team_coordinator_name char team_member_name char

hreda.v_experiment end_date char experiment_id char experiment_name char investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char involved_crew char last_update_date char missions char operations_entity char start_date char

hreda.v_experiment_mission experiment_id char experiment_name char experiment_oid int hre_mission_id char hre_mission_name char hre_mission_oid int

hreda.v_file_ancillary access_granted boolean active boolean file_ancillary_oid long file_name char file_path char file_size long ingestion_date char integrity_method char integrity_value char investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char metadata_ingestion_date char path_stage char relative_path char security_level int subjects char

hreda.v_file_metadata access_granted boolean acquisition_end_time char acquisition_time char active boolean creation_time char data_authors char data_owners char data_source char dataset_name char dataset_unique_acronym char extra_information char file_format char file_metadata_oid long file_name char file_path char file_size long ingestion_date char integrity_method char integrity_value char investigation_id char investigation_name char investigation_unique_acronym char metadata_ingestion_date char model char prior_access_end_date char prior_access_initial_date char processing_level char product_type char relative_path char security_level int specific_metadata char subjects char

hreda.v_industrial_partners industrial_partner_affiliation_address char industrial_partner_affiliation_country char industrial_partner_affiliation_id char industrial_partner_affiliation_name char investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char partner_name char

hreda.v_investigation active boolean ancillary_data_available boolean data_available boolean earth_benefits char end_date char facilities char hre_category_id char hre_category_name char hre_category_oid int investigation_doi char investigation_id char investigation_name char investigation_oid int investigation_op_nom char investigation_short_title char investigation_title char investigation_unique_acronym char ipr_data boolean is_published boolean key_question_id char key_question_name char key_question_oid int last_update_date char medical_sensitive boolean mission_name char objectives char payload char platform_id char platform_name char platform_oid int "procedure" char results char short_description char space_benefits char start_date char team_coordinator_name char team_member_name char

hreda.v_investigation_attachment access_granted boolean active boolean attachment_order int description char file_name char file_path char file_size long ingestion_date char investigation_attachment_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char

hreda.v_investigation_filter column_file_metadata char display_order int filter_description char filter_name char filter_type char first_date char investigation_filter_oid int investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char last_date char max_number char metadata_field char min_number char specific_filter boolean values_enumeration char

hreda.v_keyword_investigation investigation_id char investigation_name char investigation_unique_acronym char keyword_id char keyword_name char

hreda.v_sponsors investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char sponsor_affiliation_address char sponsor_affiliation_country char sponsor_affiliation_id char sponsor_affiliation_name char sponsor_name char

hreda.v_team_coordinators investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char team_coordinator_affiliation_address char team_coordinator_affiliation_country char team_coordinator_affiliation_id char team_coordinator_affiliation_name char team_coordinator_name char

hreda.v_team_members investigation_id char investigation_name char investigation_oid int investigation_unique_acronym char team_member_affiliation_address char team_member_affiliation_country char team_member_affiliation_id char team_member_affiliation_name char team_member_name char

job_upload public public.dualauxiliary 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.columnsTAP 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_columnsTAP 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.keysTAP 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.schemasTAP SCHEMA schemas db_schema_name char description char schema_index int schema_name char utype char

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