ESO Logo

Science Archive
Programmatic and Tools Access
Demo page

The purpose of this page is to help you to learn:
  1. how to compose URLs to interact with the different ESO science archive services, either programmatically or via tools;
  2. how to construct queries to interrogate the various database tables of the ESO science archive, using ADQL and TAP;
  3. how to put it all together and script your access to the ESO science archive, using the pyvo python module.
If some terms in this page are not familiar to you, please read the overview page first.

In this page: [open] click here to read the page description...

This page is organised in 7 tabs. You'll have to click on a tab to see its content.

In the Query a TAP service tab you can learn how to write and execute a query to the ESO databases. Queries must be written in the Astronomical Query Data Language (ADQL). To learn the ADQL syntax, a pulldown menu (Choose a query [...]) provides you some precooked query examples: you can modify them at will, validate them, and/or execute them. Queries can be issued either synchronously, or, for more complex and slower queries, they can be issued asynchronously. The link to the ESO TAP Query Manager is provided, to allow you to (learn how to) control the ESO asynchronous jobs.
Passband characteristics are provided to help formulating wavelength constraints to the ivoa.ObsCore table. Though, please note that the ESO ivoa.ObsCore table exposes some extra, non-standard, columns, as shown in the following table.

ESO extends the ivoa.ObsCore table with 11 extra columns
column namedescription
abmaglimlimiting magnitude, available only for images, source tables, and cubes
dp_idESO internal unique identifier of a dataset, useful to join with other tables
filtername of the filter
gal_latgalactic latitude
gal_longalactic longitude
n_obsnumber of scientific frames used to generate the given product (NCOMBINE)
snrsignal-to-noise ratio available only for 1d spectra
multi_obeither M or S.
M for products result of combination of exposures from multiple telescope visits;
S for a product result of combination of exposures taken during the same visit
obstechtechnique of observation
p3origEither EDP or IDP, EDPs are products certified by the user community, IDPs by ESO
publication_datetime when the product has been made available (though it could still be under proprietary period)

It is also possible to query some other TAP servers (provided in the TAP Service pulldown menu), in which case the query validator and the provided query examples are not guaranteed to work.

In the async Query Manager tab, you can (learn how to) control the asynchronous queries. From there you can change the execution duration of a job, set its destruction time, run it, abort it, and of course you can check at any time the status of the job; when the job is successfully completed, you can fetch the results.

The Script your access to the archive tab provides a python script to illustrate how to query the SSAP service and download high signal-to-noise spectra in a given region, using the pyvo module.

In the Configure VO tools tab, you can learn how to configure some VO-aware tools like TOPCAT and ALADIN to make use of the new ESO services. In a second stage, when the ESO VO interfaces will have been registered in the EUROVO registry, the tools will be already aware of the ESO interaces; at that point this section will be removed.

In the Learn dataset actions tab you can learn how to interact with the ESO Science Archive at the level of an individual dataset, recognised by its unique identifier (ID). Once you provide an ID, by clicking on the provided buttons you can get to its preview, metadata (obscore), or download its main science file and/or its associated files (datalink), etc. With the checkbox Show URL only activated, the action's URL is only displayed, and not actually retrieved, so to allow you to learn how you can construct the various service URLs for consumption via scripts or via tools.

The IVOA standards and software tab lists the standards and the software suites onto which the ESO programmatic and tool access is based. Links to the standards are provided. Links to the software libraries available on github are provided.

The Change Log tab lists all the changes to the programmatic and tool interfaces that could affect your scripts or anyway your way of accessing the ESO science archive via TAP, SSAP, or via one of the URLs specified in the Learn dataset actions. Keep an eye on it, to make sure to be up-to-date with this newly born and still evolving functionality of the ESO Science Archive.






Click on a tab to see its contents here.