2.1   Observing summary data

RHESSI observing summary files provide count-rates pre-binned to coarse energy and time resolution, and observing flags. A database of observing summary information was created by the solar group at Glasgow University by importing data from the RHESSI observing summary files (e.g. hsi_obssumm_20030224_040.fits), to allow immediate visualisation of the summary data. For a detailed description of observing summary data follow this link.

2.2   Example queries

Here are examples of ADQL queries to the observing summaries database:

Select * from rhessi as a where a.time_start > '2004-10-13T00:00:00' and a.time_start < '2004-10-13T12:00:00'

The query above is the basic time range query.

2.3   How to send a query to the observing summary database

1. Follow this link for help in downloading and launching the AstroGrid Workbench.
2. Once Workbench is running click on the Task Launcher icon.
3. Search for 'rhessi' . Select 'Glasgow RHESSI DSA Service' by clicking on the box to the left of the name. Select 'adql' as the interface. This will take you to the Query Builder.
4. Once the Query Builder appears, click on the Adql/s tab. Now you can type in your query as a string. If you click on the name of one of the tables on the rhs, you can see a list of the keywords you can query on
5. To submit the query click on the green icon. This will open a Lookout window.

NOTE: to be able to get back a very large result (eg when you want to look at a long time range), you need to save the output to a file in MySpace: In Task Luncher click on 'Parameter', then under 'outputs' click on the Box under Ref?. Type in a name of a file where the output should go -eg: output.vot click ok and re-submit job.

To view the results launch Topcat . Then in the Lookout window put your mouse over 'Result' in the bottom right corner and choose 'To Topcat' 'as Votable'.

The image below is a plot made with Topcat showing the results of an observing summary query.