CINXE.COM

<!DOCTYPE html> <head> <meta charset='utf-8'> <title>SkyMapper Southern Sky Survey</title>  <link rel="stylesheet" type="text/css" href='/static/sm_asvo/fonts.css' /> <link rel='stylesheet' type='text/css' href='/static/sm_asvo/master.css' /> <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>  <script type='text/javascript' src='/static/sm_asvo/master.js'></script> <script type='text/javascript' src="https://cdn.rawgit.com/leafo/sticky-kit/v1.1.2/jquery.sticky-kit.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" /> <link rel="icon" type="image/ico" href='/static/sm_asvo/img/favicon.ico' />  <meta property="og:title" content="SkyMapper Southern Sky Survey" /> <meta property="og:type" content="website" /> <meta property="og:url" content="https://skymapper.anu.edu.au/tap/" /> <meta property="og:image" content="https://skymapper.anu.edu.au/static/sm_asvo/img/skymapper_logo1-200x198_3.jpg" /> <meta property="og:description" content="Access to and information about the SkyMapper Southern Sky Survey" /> <meta property="fb:app_id" content="968590116638493" /> <script src='/static/sm_tap/js/forms.js'></script> <script src='/static/sm_tap/js/codemirror.js'></script>  <script> function openMetadata() { window.open("/table-browser-standalone/", "_blank", "toolbar=no, scrollbars=yes, location=no, resizable=no, top=100, left=100, width=1000, height=500"); } </script>  <script src='/static/sm_tap/js/adql.js'></script> <script type='text/javascript'> $( document ).ready(function () { var editor = null; // alert('In document ready!'); $('.push-to.get-all-columns-from-table').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D This query will select all columns from the image table\u000D\u000A\u002D\u002D\u000D\u000ASELECT * FROM dr1.images\u000D\u000A") }); $('.push-to.get-specific-columns-and-rows').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D Select five columns from the master photometry table\u000D\u000A\u002D\u002D You can use WHERE to limit the rows returned\u000D\u000A\u002D\u002D\u000D\u000ASELECT object_id, raj2000, dej2000, r_psf, e_r_psf\u000D\u000A FROM dr1.master\u000D\u000A WHERE r_psf\u003C16") }); $('.push-to.multiple-row-constraints').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D Select all columns from fs_photometry, but only detections\u000D\u000A\u002D\u002D in the g band with good flags, PSF mags and circular elongations.\u000D\u000A\u002D\u002D\u000D\u000ASELECT *\u000D\u000A FROM dr1.fs_photometry\u000D\u000A WHERE \u000D\u000A filter \u003D \u0027g\u0027 \u000D\u000A AND flags \u003D 0 \u000D\u000A AND nimaflags \u003D 0\u000D\u000A AND elong \u003C 1.2\u000D\u000A AND mag_psf IS NOT NULL\u000D\u000A") }); $('.push-to.cone-search-geometric-query').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D Select star\u002Dlike objects with g\u002Dr \u003E 0.8 in a 0.5 deg cone \u000D\u000A\u002D\u002D around RA\u003D160 and Dec\u003D\u002D35 deg using the CONTAINS spatial\u000D\u000A\u002D\u002D operator. The results are ordered by their distance from the \u000D\u000A\u002D\u002D centre of the cone using the DISTANCE operator.\u000D\u000A\u002D\u002D\u000D\u000ASELECT \u000D\u000A DISTANCE(POINT(\u0027ICRS\u0027, raj2000, dej2000),\u000D\u000A POINT(\u0027ICRS\u0027, 160.0, \u002D35.0)) AS dist, m.*\u000D\u000A FROM dr1.master AS m\u000D\u000A WHERE \u000D\u000A 1\u003DCONTAINS(POINT(\u0027ICRS\u0027, raj2000, dej2000),\u000D\u000A CIRCLE(\u0027ICRS\u0027, 160.0, \u002D35.0, 0.5 ))\u000D\u000A AND g_psf\u002Dr_psf \u003E 0.8 \u000D\u000A AND class_star\u003E0.9\u000D\u000A ORDER BY dist") }); $('.push-to.aggregating-rows').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D Compute the mean elongation, minimum epoch, maximum epoch and \u000D\u000A\u002D\u002D number of stars in the master photometry table. Note the use \u000D\u000A\u002D\u002D of AS to rename columns into something more readable.\u000D\u000A\u002D\u002D\u000D\u000ASELECT \u000D\u000A AVG(a/b) as mean_elong,\u000D\u000A MIN(mean_epoch) AS min_epoch, \u000D\u000A MAX(mean_epoch) AS max_epoch,\u000D\u000A COUNT(*) AS num_stars \u000D\u000A FROM\u000D\u000A dr1.master\u000D\u000A WHERE\u000D\u000A 1\u003DCONTAINS(POINT(\u0027ICRS\u0027, raj2000, dej2000),\u000D\u000A CIRCLE(\u0027ICRS\u0027, 160.0, \u002D35.0, 0.5 ))\u000D\u000A AND b\u003E0\u000D\u000A") }); $('.push-to.grouping-rows').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D ADQL allows you to run aggregate functions on *groups* of rows.\u000D\u000A\u002D\u002D In this case we are calculating the mean elongation\u000D\u000A\u002D\u002D as a function of g, r, i and z filters for star\u002Dlike objects.\u000D\u000A\u002D\u002D Note the use of IN to select from values in a set.\u000D\u000A\u002D\u002D\u000D\u000ASELECT\u000D\u000A filter, AVG(elong) AS avg_elong, COUNT(*) AS num\u000D\u000A FROM\u000D\u000A dr1.fs_photometry\u000D\u000A WHERE \u000D\u000A 1\u003DCONTAINS(POINT(\u0027ICRS\u0027, ra_img, decl_img),\u000D\u000A CIRCLE(\u0027ICRS\u0027, 160.0, \u002D35.0, 0.5 ))\u000D\u000A AND mag_psf\u003C17\u000D\u000A AND class_star\u003E0.9 \u000D\u000A AND filter IN (\u0027g\u0027,\u0027r\u0027,\u0027i\u0027,\u0027z\u0027)\u000D\u000A GROUP BY filter\u000D\u000A ORDER BY avg_elong ASC\u000D\u000A") }); $('.push-to.joining-tables').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D You can join tables together if they have a column(s) in common.\u000D\u000A\u002D\u002D Here we are joining the fs_photometry table to the images table \u000D\u000A\u002D\u002D to examine the date and airmass of each measurement of a \u000D\u000A\u002D\u002D particular object.\u000D\u000A\u002D\u002D\u000D\u000ASELECT\u000D\u000A date,airmass,image_id,ccd,ra_img,decl_img,f.filter,mag_psf,e_mag_psf\u000D\u000A FROM\u000D\u000A dr1.fs_photometry f\u000D\u000A JOIN \u000D\u000A dr1.images USING (image_id)\u000D\u000A WHERE \u000D\u000A object_id\u003D19372658\u000D\u000A ORDER BY date") }); $('.push-to.joining-skymapper-to-other-tables').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D The DR1 master table has been pre\u002Dmatched to the EDR, \u000D\u000A\u002D\u002D AllWISE, 2MASS, UCAC4 and APASS, Gaia DR1 and GALEX.\u000D\u000A\u002D\u002D We can use the matched object IDs to easily grab the \u000D\u000A\u002D\u002D columns we need from the external tables. \u000D\u000A\u002D\u002D Here we join master to 2MASS PSC and UCAC4 within 2\u0022:\u000D\u000A\u002D\u002D\u000D\u000ASELECT \u000D\u000A smss_j, m.raj2000, m.dej2000, m.r_psf, m.i_psf, t.j_m, t.k_m, u.pmra, u.pmde\u000D\u000A FROM \u000D\u000A dr1.master m \u000D\u000A JOIN \u000D\u000A ext.twomass_psc t ON m.twomass_key1\u003Dt.pts_key \u000D\u000A JOIN \u000D\u000A ext.ucac4 u ON m.ucac4_mpos\u003Du.mpos\u000D\u000A WHERE \u000D\u000A m.twomass_dist1\u003C2 \u000D\u000A AND m.twomass_cat1\u003D\u0027psc\u0027 \u000D\u000A AND m.ucac4_dist\u003C2\u000D\u000A AND 1\u003DCONTAINS(POINT(\u0027ICRS\u0027,m.raj2000,m.dej2000),CIRCLE(\u0027ICRS\u0027,100,\u002D30,0.5)) \u000D\u000A AND r_psf\u003C15 \u000D\u000A AND SQRT(POWER(u.pmra,2)+POWER(u.pmde,2)) \u003E 50") }); $('.push-to.using-cross-matches').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D A cross\u002Dmatch is a spatial join of two tables.\u000D\u000A\u002D\u002D We have cross\u002Dmatched several spectroscopic\u000D\u000A\u002D\u002D catalogues with the master table.\u000D\u000A\u002D\u002D Here we select objects from the HES QSO table\u000D\u000A\u002D\u002D and join it with their nearest SkyMapper source,\u000D\u000A\u002D\u002D using only counterparts within 2 arcsec.\u000D\u000A\u002D\u002D\u000D\u000ASELECT hename,z,smss_j,u_psf,v_psf,g_psf,r_psf,i_psf,z_psf\u000D\u000A FROM\u000D\u000A ext.spec_hesqso h\u000D\u000A JOIN\u000D\u000A dr1.master m\u000D\u000A ON h.dr1_id \u003D m.object_id AND h.dr1_dist \u003C 2\u000D\u000A") }); $('.push-to.returning-radec-in-hmsdms').click(function () { editor.setValue("\u002D\u002D\u000D\u000A\u002D\u002D You can return RA and Dec formatted as HH:MM:SS.SS and sDD:MM:SS.S with the\u000D\u000A\u002D\u002D complicated parsing here (also returning all other columns, in addition):\u000D\u000A\u002D\u002D\u000D\u000ASELECT\u000D\u000A lpad(text(trunc(raj2000/15.)),2,\u00270\u0027)||\u0027:\u0027||lpad(text(trunc((raj2000/15.\u002Dtrunc(raj2000/15.))*60)),2,\u00270\u0027)||\u0027:\u0027||lpad(text(trunc((((raj2000/15.\u002Dtrunc(raj2000/15.))*60\u002Dtrunc((raj2000/15.\u002Dtrunc(raj2000/15.))*60.))*60.))),2,\u00270\u0027)||\u0027.\u0027||\u000D\u000Alpad(text(trunc(100.*\u000D\u000A((((raj2000/15.\u002Dtrunc(raj2000/15.))*60\u002Dtrunc((raj2000/15.\u002Dtrunc(raj2000/15.))*60.))*60.)\u002Dtrunc((((raj2000/15.\u002Dtrunc(raj2000/15.))*60\u002Dtrunc((raj2000/15.\u002Dtrunc(raj2000/15.))*60.))*60.)))\u000D\u000A)),2,\u00270\u0027) AS ra_hms, \u000D\u000A text(trunc(dej2000))||\u0027:\u0027||lpad(text(trunc((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60.)),2,\u00270\u0027)||\u0027:\u0027||lpad(text(trunc((((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60.)\u002Dtrunc(((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60.)))*60.)),2,\u00270\u0027)||\u0027.\u0027||lpad(text(trunc(10.*\u000D\u000A((((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60\u002Dtrunc((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60.))*60.)\u002Dtrunc((((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60\u002Dtrunc((abs(dej2000)\u002Dtrunc(abs(dej2000)))*60.))*60.)))\u000D\u000A)),1,\u00270\u0027) AS dec_dms, \u000D\u000A * \u000D\u000AFROM \u000D\u000A dr1.master") }); // Activate the lined text area editor = CodeMirror.fromTextArea(document.getElementById("id_adql"), { mode: "text/x-adql", tabMode: "indent", matchBrackets: true, lineNumbers: true, viewportMargin: Infinity, lineWrapping: true }); // editor.refresh(); }); </script> <link rel='stylesheet' href='/static/sm_tap/css/forms.css' /> <link rel='stylesheet' href='/static/sm_tap/css/codemirror.css' /> <style> .CodeMirror-scroll { min-height: 250px; } </style>     <script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','https://www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-100583569-1', 'auto'); ga('send', 'pageview'); $( document ).ready(function () { $('#linkbar').stick_in_parent(); }) </script> </head> <body> <div id='wrapper'> <div id="userwarn"><a href="/accounts/login/?next=/tap/">Log-in</a> to SkyMapper</div> <div id='banner'>  <h1><a href='/'><strong>SkyMapper</strong> | Southern Sky Survey</a></h1> <span class='vahelper'></span><a href='https://www.anu.edu.au/'><img src='/static/sm_asvo/img/2x_anu_logo_small_over.png' id='anu' /></a>  </div>  <ul id='linkbar'> <li class='menuitem mi-icon'><a href='/'><i class="material-icons md-light"> </i>Home</a></li> <li class='menuitem mi-icon'><a href='/about-skymapper/'><i class="material-icons md-light"> </i>About SkyMapper</a></li> <li class='menuitem mi-icon'><a href='/purchase-time/' style="background-color: darkred;"><i class="material-icons md-light">shopping_cart </i>Purchase Time</a></li> <li class='menuitem mi-icon'><a href='/how-to-cite/'><i class="material-icons md-light">book </i>Cite & Acknowledge</a></li> <li class='menuitem mi-icon'><a href='/news/'><i class="material-icons md-light">keyboard </i>Latest News</a></li> <li class='menuitem mi-icon-inactive'><a><i class="material-icons md-light"> </i>Survey Information<span style='float:right;padding-right:5px;'>————</span></a></li> <li class='menuitem'><a href="/data-release/">Data Releases</a></li> <li class='menuitem'><a href='/surveys/'>Survey Progress</a></li> <li class='menuitem'><a href='/publications/'>View Publications</a></li> <li class='menuitem'><a href='/publications/statistics/'>Publication Statistics</a></li> <li class='menuitem mi-icon-inactive'><a><i class="material-icons md-light"> </i>Data Access<span style='float:right;padding-right:5px;'>————</span></a></li> <li class='menuitem'><a href='/how-to-access/'>How To Access</a></li> <li class='menuitem'><a href='/object-viewer/'>Object Viewer</a></li> <li class='menuitem'><a href='/cone-search/'>Cone Search</a></li> <li class='menuitem'><a href='/image-cutout/'>Image Cutouts</a></li> <li class='menuitem'><a href='/tap/'>Full Catalogue Search</a></li> <li class='menuitem'><a href='/table-browser/'>Table Metadata</a></li> <li class='menuitem mi-icon'><a href='/sky-viewer/'><i class="material-icons md-light"></i> Sky Viewer</span></a></li>   <li class='menuitem mi-icon'><a href='/skymapper-board/'><i class="material-icons md-light">work </i>SkyMapper Board</a></li> <li class='menuitem mi-icon'><a href='/media-gallery/'><i class="material-icons md-light"> </i>Media Gallery</a></li> <li class='menuitem mi-icon'><a href='/forum/'><i class="material-icons md-light"> </i>User Forum</a></li> </ul> <ul id='linkmenu'> <li id='menubutton'><a href='#'>⇶ Menu</a></li> <li class='menuitem'><i class="material-icons"></i><a href='/'>Home</a></li> <li class='menuitem'><i class="material-icons"></i><a href='/about-skymapper/'>About SkyMapper</a></li> <li class='menuitem'><i class="material-icons"></i><a href='/purchase-time/' style="background-color: darkred;">Purchase Time</a></li> <li class='menuitem'><a href='/how-to-cite/'>Cite & Acknowledge</a></li> <li class='menuitem'><a href='/news/'>Latest News</a></li> <li class='menuitem'><a href='/data-release/'>Data Releases</a></li> <li class='menuitem'><a href='/surveys/'>Survey Progress</a></li> <li class='menuitem'><a href='/publications/'>View Publications</a></li> <li class='menuitem'><a href='/publications/statistics/'>Publication Statistics</a></li> <li class='menuitem'><a href='/how-to-access/'>How to Access</a></li> <li class='menuitem'><a href='/object-viewer/'>Object Viewer</a></li> <li class='menuitem'><a href='/cone-search/'>Cone Search</a></li> <li class='menuitem'><a href='/image-cutout/'>Image Cutouts</a></li> <li class='menuitem'><a href='/tap/'>Full Catalogue Search</a></li> <li class='menuitem'><a href='/table-browser/'>Table Metadata</a></li> <li class='menuitem'><a href='/sky-viewer/'>Sky Viewer</a></li>  <li class='menuitem'><a href='/skymapper-board/'>SkyMapper Board</a></li> <li class='menuitem'><a href='/media-gallery/'>Media Gallery</a></li> <li class='menuitem'><a href='/forum/'>User Forum</a></li> </ul>  <div id='content'> <p></p> <h1>Full Catalogue Search (ADQL)</h1> <p>This page allows arbitrary queries and joins against all SkyMapper and selected external catalogues using the Virtual Observatory Table Access Protocol (TAP), and is only suitable for relatively simple, fast (synchronous) requests that will not time out in the browser. For more complex work requiring asynchronous access and stored results, please use a tool such as <a href="http://www.star.bris.ac.uk/~mbt/topcat/sun253/TapTableLoadDialog.html" target="_blank">TOPCAT</a> with the <em>asynchronous</em> TAP service, as described on the <a href='/how-to-access/#tap'>How To Access</a> page.</p> <p>Queries are made to this service using the <a href="https://www.ivoa.net/documents/latest/ADQL.html" target="_blank">Astronomical Data Query Language</a> (ADQL), similar to SQL used by relational databases such as MySQL and PostgreSQL. If you are unfamiliar with ADQL, you can use the examples below and find further information and tutorials <a href="https://is.gd/ADQLTutorial" target="_blank">here</a>, <a href="http://docs.g-vo.org/adql/html/twoup.pdf" target="_blank">here</a> and <a href="http://tapvizier.u-strasbg.fr/adql/help.html" target="_blank">here</a>.</p> <p>TAP queries are data-release agnostic – all tables from all releases are available via our TAP server.</p> <p class='pwarning'>Note: By using SkyMapper data, you agree to observe the <a href='/policies/'>SkyMapper policies</a> published on this website.</p> <div class='multiaccord'> <h3 class='multiaccord-head'><span class='multiaccord-head-arr'>▶ </span> Example ADQL Queries</h3> <div class='multiaccord-box'><p>Click on an example to show it in the ADQL Query box.</p> <p> <a class='push-to get-all-columns-from-table'>Get all columns from table</a> | <a class='push-to get-specific-columns-and-rows'>Get specific columns and rows</a> | <a class='push-to multiple-row-constraints'>Multiple row constraints</a> | <a class='push-to cone-search-geometric-query'>Cone search (geometric query)</a> | <a class='push-to aggregating-rows'>Aggregating rows</a> | <a class='push-to grouping-rows'>Grouping rows</a> | <a class='push-to joining-tables'>Joining tables</a> | <a class='push-to joining-skymapper-to-other-tables'>Joining SkyMapper to other tables</a> | <a class='push-to using-cross-matches'>Using Cross-matches</a> | <a class='push-to returning-radec-in-hmsdms'>Returning RA/Dec in HMS/DMS</a> </p> </p></div> </div> <form data-parsley-validate action='/tap/' method='post'> <input type='hidden' name='csrfmiddlewaretoken' value='NTPLBZsRfyAwZyJC83pds7o6qAxlRQRIx8hRFRU5vwvJ7EQUGq6Zv0ivq3HcKvLq' /> <input type="hidden" name="data_release" value="DR4" id="id_data_release" /><input type="hidden" name="initial-data_release" value="DR4" id="initial-id_data_release" /> <h3 class='multiaccord-head'><span class='multiaccord-head-arr'>▶ </span> ADQL Query</h3> <div class='multiaccord-box'> <p>To aid in constructing queries, <a style="cursor:pointer;" onclick="openMetadata()">click here</a> to browse the table and column metadata in a new window. The syntax of your query will be checked prior to being run on the server. <small><font color="#808080">(Add "@NOVALID" to your query to bypass the CDS ADQL-validator.)</font></small></p> <p><div class="CodeMirror"><textarea name="adql" id="id_adql" style="width: 60%; min-width: 250px; padding: auto 10px auto 10px" rows="10" cols="40" required> -- Type your query here </textarea></div><br /><span class='hint'>Refresh page if query editor does not load</span><br /></p> <p><label for="id_return_no">Maximum number of rows to return:</label> <select name="return_no" id="id_return_no"> <option value="100" selected>100</option> <option value="1000">1000</option> <option value="2000">2000</option> </select><br /> <span class='hint'>Override by specifying your own 'TOP nnn' value in your ADQL query. There is a return limit of 2000 objects for queries made from this page.</span></p> <p></p> </div> <input type='submit' class='btn-submit-highlight' value='Run Query'/> </form> <p></p> </div> <div class="clearboth"></div> <div id='footer'><p> The use of all SkyMapper data is governed by the <a href='/policies/'>policies</a> outlined on this website. Please review them prior to downloading or publishing data.<br/> Copyright © 2025 <a href='https://rsaa.anu.edu.au/'>Research School of Astronomy and Astrophysics</a>, <a href='https://www.anu.edu.au/'>The Australian National University</a>. Development funded by <a href='http://astronomyaustralia.org.au/'>Astronomy Australia Ltd.</a> as part of the <a href='http://www.asvo.org.au/'>All-Sky Virtual Observatory</a> and <a href='https://odc.org.au/'>Optical Data Centre</a>. Hosted by <a href='http://nci.org.au/'>National Computational Infrastructure</a>.<br /> Powered by <a href='https://www.djangoproject.com' target='_blank'>Django</a> and <a href="https://www.cherrypy.org" target="_blank">CherryPy</a>.</p></div> </div> </body> </html>