2dFGRS Database - Make Query Powered_by_mSQL

1. Options: Choose whether to make a query or list the database tables and headings. If making a query, choose: (i) whether to return the results as an HTML table or via an email giving the URL of the results file; and (ii) in the latter case, whether to return a compressed text (gzipped ASCII) file with the chosen parameters for the objects selected by the mSQL query, or a compressed archive (gzipped tarfile) of the FITS files for the objects selected by the query.

2. Query: After SELECT, list the parameters you wish returned; after WHERE give the set of conditions that the parameters must satisfy (see the SQL tutorial and the database introduction for examples). Then hit SUBMIT to submit the query.

SELECT
FROM TDFgg
 WHERE 

NOTES

  • Serial numbers: SGP 1-193550 + 416694-467214; NGP 193551-332694 + 389714-416693; RAN 332695-389713.
  • Only the 102426 objects observed between 1 October 1997 and 31 January 2000 are included in this release.
  • The HTML table option should only be used for relatively small numbers of objects.
  • Large queries should use the option of returning an email giving the URL of the results file.
  • Use of ORDER BY to sort queries takes a very long time; don't use it on large queries (better to sort off-line).
Bruce A. Peterson, peterson@mso.anu.edu.au, Wed 8 Apr 2015, [Error Creating Counter File -- Click for more info] access