Quick Guide to get public information and data via direct HTTP access

In this section there are several examples and explanation about how to query and download the public data from the different investigations.

As aforementioned, note that within the HTTP QUERY parameter a ADQL language is used (similar to SQL), and is using URL enconding.
Remember that you will need to log in before download the data (see Authentication section).

Which are the available 'Platforms' at the archive?

Search for platform_name within the table hreda.platform. The results will come in JSON format:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=json&QUERY=SELECT+platform_name+from+hreda.platform

Lists all 'Missions' at the archive

Search for hre_mission_name, start_date, end_date within the table hre_mission. The results will come in JSON format:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=json&QUERY=SELECT+DISTINCT+hre_mission_name,start_date,end_date+from+hreda.hre_mission

Which 'Categories' can be used for filtering?

Search for hre_category_name within the table hreda.hre_category. The results will come in JSON format:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=json&QUERY=SELECT+DISTINCT+hre_category_name+from+hreda.hre_category

Information about all the 'Investigations'

Using the metadata of the 'Investigation', retrieve information about all investigations available at the archive.
The results will come in CSV format (note FORMAT parameter):

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=csv&QUERY=SELECT+investigation_name,short_description,platform_name,start_date,end_date+from+hreda.v_investigation

Search for available investigations at a certain category field and platform. In this example, platform='ISS' and hre_category_name='Biology'.
Search for investigation_name within the view hreda.v_investigation. The results will come in JSON format:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=json&QUERY=SELECT+DISTINCT+investigation_name+from+hreda.v_investigation+where+platform_name='ISS'+and+hre_category_name='Biology'

Research keywords

» Show all the keywords available in the archive
Using this other query we can get a list of all the keywords defined up to now in the archive for the ingested investigations. The results will come again in CSV format:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=csv&QUERY=SELECT+DISTINCT+keyword_name+from+hreda.v_keyword_investigation+order+by+keyword_name

» Show the keywords associated to a given investigation
We can also list all the keywords associated to a given investigation. In this example we retrieve the keywords for 'Tropi 2':

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=csv&QUERY=SELECT+DISTINCT+keyword_name+from+hreda.v_keyword_investigation+where+investigation_name='Tropi-2'+order+by+keyword_name

» Show all the investigations with a given keyword
In a similar way, we can find all the investigations 'tagged' with the same keyword or list of keywords:

https://hreda.esac.esa.int/hreda-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=csv&QUERY=SELECT+DISTINCT+investigation_name+from+hreda.v_keyword_investigation+where+keyword_name+like+'%25Biology%25'+order+by+investigation_name