Heliophysics Event Catalogue

Free SQL Query



Examples of SQL Queries to the UOC

Unified Observing Catalogue

The Unified Observing Catalogue (UOC) is used in two different ways and the types of information associated with these are quite different:
  1. Where there are problems accessing the observations from some instruments – either because not all of them are on-line or because of complexities in the archive interface – the UOC contains the details of what is available and the URLs that should be used to access the data.
  2. For (remote-sensing) instruments that observe the Sun with restricted fields-of-view the UOC contains details of the instrument pointing as well as other information about the observing mode.

Entries in the first category are used by the DPAS to support access to certain instruments; that the DPAS should use the UOC is specified in the Provider Access Table (PAT). Data in this catagory includes planetary particle interaction (PPI) data held in NASA's Planetary Data System (PDS) amd ESA's Planetary Science Archive (PSA) – the URLs that should be used to access the files are mined by HELIO software and stored in the UOC.

Entries in the second category are used as part of the search process; the information they contain make it possible to filter data requests based on whether the instrument was observing the required target.

To access the UOC select the type of data using the window tabs. Next define the time range of interest and the required instrument and then press "Send Request". The results can be viewed as a Web page or downloaded as a VOTable or text file.

A Free-SQL window is provided to allow the user to experiment with SQL queries.

Interface created and maintained by UCL–MSSL; database originally developed by INAF–OATs