The freeform SQL gives you a flexible way of querying the GES Science Archive. You can query any table or combination of tables and have control over the columns returned.
The following documentation is available to assist querying the GES Science Archive. However, the GES data model (that is, the tables and views comprising the database and the columns that they contain) has changed significantly between releases. Thus, the details of querying the GES Science Archive also vary between releases. Below different sets of examples are given for the different releases and you should choose the ones appropriate to the release that you are using (which will usually be the most recent).
Release iDR5 (November 2017; most recent)
Release iDR4 (February 2016
Release iDR2iDR3 (February 2015)
The startHere page gives additional details of the GES archive. The archive database structure (tables and columns etc), is documented in the schema browser.
Release iDR2 (July 2014)
Release iDR1 (August 2013)
Release iDR1Prelim (May 2013)
Use the examples for the iDR1 release (above), but proceed with caution as some details are different.
Home | Overview | Browser | Access | Login | Examples
Links | Credits
WFAU, Institute for Astronomy,