2dFgg Search Index
Database Overview
See also
mSQL Keywords
Updated 21 April 2001
2dFgg mSQL Server
Look at table names and column headings, or submit an mSQL query
on all 2dFgg data. Obtain database files.
Display the Sky Map and Spectrum.
Now gives multiple rows for each object. Use extnum = 0 in your WHERE
clause to obtain a single row.
Updated 9 June 2000
2dFgg Catalogue Matching
Match objects in your catalogue with those in the 2dFgg survey,
and obtain the 2dFgg names of the matched objects. Use the
returned file of 2dFgg names as input to the
Find By Name mSQL Server
to obtain more information on the matched objects.
Find By Name mSQL Server
Provide a file of 2dFgg names, and
submit a mSQL query
on 2dFgg objects named in your file.
Display the Sky Map and Spectrum.
2dFgg Search Field
Find all objects within a given search radius, and
submit an mSQL query on the objects found in the search.
Display the Sky Map and Spectrum.
2dFgg-NVSS mSQL Server
This data base contains some 5700 objects in common to the NVSS and
2dFgg surveys. The matching criteria is that a NVSS radio source is
matched to a 2dFgg object within a radius of 15 arc-sec of the NVSS
position. The 2dFgg objects with serial numbers
29032, 73670, 95594, 188581, and 326253
are matched with two NVSS sources.
SQL tutorial.
A tutorial on SQL (structured query language) Note: not all commands are
implemented in miniSQL (mSQL) and altering the data is not allowed
access.
Page Author: Bruce Peterson
peterson@mso.anu.edu.au,
Mt. Stromlo Observatory, The Australian National University
Page last modified Thursday, 21-Jun-2001 18:31:02 EST