GES SCIENCE ARCHIVE

Login

Freeform SQL

Example Queries

Q&A

Glossary

Gallery

Publications

Downtime

Links

IFA ROE

Status: Not logged in.
Please reload this page if you have logged in and are not seeing the correct login status.

Freeform SQL Query

This form allows you to submit an SQL query to the GES database (notes and tips).

An enhanced version of this form allows the upload of a file to a temporary database table. This table (#userTable) can then form part of the query being executed.
Download iDR5 RecommendedAstroAnalysis (FITS file of select * from RecommendedAstroAnalysis)

First select the programme/survey you wish to use:

Database release to use:

Upload SQL query from file into this form:

or enter
SQL statement:

ensure one of the file formats is selected below if you want to save your results.

Email Address: the results of long running queries will be sent by email.
Data Format:

HTML table summary (results are NOT saved to file)

ASCII FILE (downloadable with HTML table summary on-screen)
FITS FILE (downloadable with HTML table summary on-screen)
VOTable FILE (downloadable with HTML table summary on-screen)

( The number of rows written to the downloadable files is subject to an upper limit see data access )
File Compression:

(none) GZIP

HTML rows:

Number of rows written to HTML table summary (maximum 100)

Timeout (seconds):

your query will be halted after this time (max 10800)

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK
Tel +44 131 668 8356 (office)
or +44 131 668 8100 (switchboard)

ges-support@roe.ac.uk