Table of Contents ECSS Model Page
Background Information Data bases
Data base query forms

Database queries

This package provides access to a number of mission databases and indices (geomagnetic and solar wind parameters). The original data sets have been downloaded and stored into the Open Data Interface (ODI), a MySQL database developed under ESA Contract No 21964/08/NL/AT. More information on ODI can be found here. Magnetic coordinates have in most cases been (re)-calculated using the UNILIB library.

The following mission datasets are or will be included:

Mission Instrument Orbit PI Start Stop
Goes 12 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Apr 2003 Present
Goes 11 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Jul 2000 Present
Goes 10 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Jul 1998 Present
Goes 9 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Dec 1995 31 Jul 1998
Goes 8 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Mar 1995 08 Apr 2003
Goes 7 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Mar 1987 31 Aug 1996
Goes 6 SEM GEO Terry Onsager (NOAA)
Dan Wilkinson (NGDC)		 01 Jan 1986 30 Nov 1994
Goes 5 SEM GEO Harold Leinbach
Howard A. Garcia		 01 Jan 1986 31 Mar 1987
Meteosat 3 SEM-2 GEO Andrew J. Coates 01 Nov 1988 23 Nov 1995
ISEE 1 WIM highly elliptical Donald J. Williams 09 Nov 1977 07 Sep 1979
ISEE 2 KED highly elliptical Erhard Keppler 03 Nov 1977 02 Mar 1987
STRV 1b REM GTO A. Zehnder 30 Jun 1994 31 Dec 1997
MIR REM LEO A. Zehnder 01 Nov 1994 29 Nov 1996
CRRES MEA GTO Alfred L. Vampola 15 Aug 1990 12 Oct 1991
AZUR EI-88 near POLAR Dieter K. Hovestadt08 Nov 1969 05 Mar 1970
SAMPEX PET   Glenn M. Mason 06 Jul 1992 Present
UARS PEM/HEPS LEO J. David Winningham 07 Oct 1991 01 Sep 1992
Indices 01 Jan 1949 Present

The sections below describe the inputs that are to be provided on the forms by the user in order to perform a data set query.

Dataset selection

The first form presents an overview of the available datasets with start and end times, separated into index and spacecraft datasets. After selecting a dataset by ticking the respective radio button, pressing the button brings up the page with the available variables for the selected dataset.

Variable selection

The user has to specify the start and end dates and times for searching the database. The dates and times preset on the form are the start and stop epochs for data in the dataset. The maximum number of records that can be retrieved is restricted to 2500, i.e. only the first 2500 points matching the selection query will be returned.

The variables to be included in the query are selected by ticking the respective check boxes from the list of variables (for multi-dimensional variables, both the variable name and the sub channel need to be checked!). The list of available variables depends on the selected mission.

Results

The database query produces the files listed in the table below. A description of the format of the files can be brought up by clicking on their description in the table.

List of output files generated by the database query
File name Description
spenvis_dbo.txt Query results

To generate plots, select the plot options and graphics format, and click the button. The current page will be updated with the newly generated plot files.

Last update: Mon, 12 Mar 2018