AstroGrid

This website (www2.astrogrid.org) is now deprecated - please go to www.astrogrid.org for up to date information.

Document Actions

Solar Event Catalogue

This page describes how to access the Solar Event Catalogue via AstroGrid

The Solar Event Catalogue developed by EGSO, can be queried from the AstroGrid Workbench. Below are two examples of how to do this, and explore the results of the query using Topcat.

1. Obtaining a list of solar x-ray flares with magnitude M1.0 or above, for times after January 1, 2003.

In the Workbench click on Task Launcher and search for 'solar and event'. Choose the Solar Event Catalogue App by clicking on the box next to its name. This will take you to the Query Builder: on the rhs you can see the event catalogues that are available - click on 'goes_xray_flare' and you will see a description of the columns in this catalogue: you cna query on any of these. Now click on the Adql/s tab and replace the text with the following query:

Select * From goes_xray_flare as t1 where t1.time_start > '2003-01-01T00:00:00' and t1.xray_class >= 'M1.0'

After typing in the query hit return.

Click on the green 'Execute this application' icon to launch the application. This will automatically open a Lookout window, that allows you to monitor progress of your query and display the results. Under Queries, you will see the task you just submitted. Once the text turns to black the query has completed.

At this point Launch Topcat - (See the Topcat Homepage for documentation). Then go back to Lookout, click on Result, then on the glasses icon, and choose 'To topcat' and 'As Votable'. The table of flares will be sent to Topcat available for analysis.

2. Retrieving a list of TRACE observations at wavelength 1600 Angstrom for 2 days in 2003.

To retrieve TRACE data information, click on Task Launcher and search for 'trace'. TRACE data available to AstroGrid are held at the UKSSDC, hence click on the box next to UKSSDC. You will be taken to the Query Builder, where on the rhs you will see a list of TRACE catalogues available. The catalogue called 'trace_header' holds the most detailed information: you can query on any of the parameters listed here.

Now click on the Adql/s tab and replace the text with the following query:

Select * From trace_fits_catalogue as t1 where t1.datetime > '2003-03-01T00:00:00' and t1.datetime < '2003-03-05T00:00:00' and t1.wave_len = '1600'

After typing in the query hit return and follow the same steps as in 1. above to send the query and visualise the results. Note that for this particular dataset the wavelength is a string, to allow for a value WL=white light.