Virtual Observatory Software for Astronomers

UKIDSS Sample SQL Queries

This page provides examples of queries against the UKIDSS catalogue using AstroGrid. You can type (or copy'n'paste) the query in the Query Builder window as shown in the image below.

Example queries

Search for all objects in dxs brighter than K=19

This is a basic query returning all objects in brighter than K=19 mags (kAperMag3): 

SELECT a.ra, a.dec, a.kAperMag3, a.jAperMag3, a.jAperMag3Err, a.kAperMag3Err FROM
  dxsSource as a 
WHERE 
  a.kAperMag3 < 19 AND a.kAperMag3 > 0.0 
  AND 
  a.jAperMag3>0.0

The output is saved to a VOspace file in this case dxs-k-lt19.vot. The query returned some 35,000 objects and the query took < one minute to complete.

Attachments

Acknowledging AstroGrid. If you make use of the AstroGrid system or tools, we would be grateful if you could acknowledge this use in any resulting publications. You could use these words: 'This research has made use of data obtained using, or software provided by, the UK's AstroGrid Virtual Observatory Project, which is funded by the Science and Technology Facilities Council and through the EU's Framework 6 programme.' Use of any data discovered or accessed through AstroGrid should of course be mentioned as noted by the data providers.

Licensing and Copyright. AstroGrid software is released under the Academic Free License.. The copyright on the text used in these web pages is owned by the contributing authors. Copyright on images used are assumed to be with the indicated or implied source as appropriate.