CINXE.COM
How To Access SkyMapper Data
<!DOCTYPE html> <head> <meta charset='utf-8'> <title>How To Access SkyMapper Data</title> <!-- Stylesheets --> <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> <!-- Custom page scripts --> <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' /> <!-- Add OG properties (required for FB login) --> <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/how-to-access/" /> <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" /> <!-- include Aladin Lite CSS file in the head section of your page --> <link rel="stylesheet" href="https://aladin.u-strasbg.fr/AladinLite/api/v2/latest/aladin.min.css" /> <!-- GOOGLE FONTS --> <!--<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">--> <!--<link href='https://fonts.googleapis.com/css?family=Open+Sans:400,700,400italic,700italic' rel='stylesheet' type='text/css' />--> <!--<link href='https://fonts.googleapis.com/css?family=Carrois+Gothic' rel='stylesheet' type='text/css'>--> <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=/how-to-access/">Log-in</a> to SkyMapper</div> <div id='banner'> <!--<div class="trans-black">--> <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>--> </div> <!-- <div class='bg-college' style='width: 100%; height: 7px; border: 0; margin: 0; padding: 0;'></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-inactive'><a><i class="material-icons md-light"> </i>Publications</a></li>--> <!-- <li class='menuitem mi-icon'><a href='/science-projects/'><i class="material-icons md-light">error_outline </i>Protected Science</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='/science-projects/'>Protected Science</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> --> <div id='content'> <p></p> <h1>How to Access SkyMapper Data Products</h1> <p><span style="color:#c0392b"><strong>The SkyMapper website and services have been migrated to HTTPS. If you encounter errors, try updating any http:// URLs to https://</strong></span></p> <p><strong>Location-based access controls have been removed for Data Release 4.</strong></p> <hr /> <hr /> <h2><a name="AU"></a><u><span style="color:#c0392b"><strong>All Users</strong></span></u><a class="back-to-top" href="#">^ Back to top</a></h2> <p>We currently provide three ways of accessing <em>SkyMapper Southern Survey</em> data — a simple cone search of the catalogues around a given sky position, arbitrary queries of the full database and external tables using ADQL, and reduced image cutouts with WCS around a given sky position. All three methods can also be accessed through Virtual Observatory-compatible tools such as <a href="http://www.star.bris.ac.uk/~mbt/topcat/">TOPCAT</a>, <a href="http://aladin.u-strasbg.fr/">Aladin</a> and custom scripts.</p> <ul> <li><a href="#aus_cone" style="font-size: 12pt;">Cone Search</a> (including <a href="#aus_scs">SCS</a> and <a href="#aus_multicone">Multi-object</a>)</li> <li><a href="#aus_cutout" style="font-size: 12pt;">Image Cutouts</a><span style="font-size:12pt"> (including </span><a href="#aus_siap" style="font-size: 12pt;">SIAP</a><span style="font-size:12pt">)</span></li> <li><a href="#aus_adql" style="font-size: 12pt;">Full Catalogue Search</a><span style="font-size:12pt"> (including </span><a href="#aus_tap" style="font-size: 12pt;">TAP access</a><span style="font-size:12pt">)</span><br /> </li> </ul> <h3><a name="aus_cone"></a>Cone Search<a class="back-to-top" href="#">^ Back to top</a></h3> <p>Performing a <a href="/cone-search/">Cone Search</a> is the simplest way to query the SkyMapper distilled photometry table (<code>dr4.master</code>) and requires only a sky position and a search radius. You may optionally specify how many columns are returned by the service using the metadata verbosity parameter. No other search criteria are allowed. The website currently supports three coordinate options:</p> <ul> <li>ICRS coordinates (RA & Dec, in a variety of formats);</li> <li>Galactic coordinates (l, b);</li> <li>A valid SIMBAD object name</li> </ul> <p>Cone Searches from the website are currently limited to a search radius of 1 degree (3,600 arcseconds) and/or 2,000 rows, though larger queries (up to 1,000,000 rows) are possible from other clients. For more complex queries (including cross-matching), we suggest using the SkyMapper TAP service <a href="#aus_adql">described below</a>. </p> <p><span style="font-size:12pt">The query page will validate your inputs before performing the search to avoid any errors. </span>By default, Cone Search results are sorted by the angular distance from the query centre. You may re-sort the columns by clicking on the headers, or filter the rows using a variety of operators (including <code><</code> and <code>></code>) to select only those objects meeting your criteria. The table can then be saved as a VOTable (XML), CSV or tab separated file, or the entire table sent to TOPCAT <span style="font-size:12pt">(if it is running) </span><span style="font-size:12pt">or another Virtual Observatory client for further processing.</span></p> <h4><a name="aus_scs"></a>Virtual Observatory Access (Simple Cone Search)<a class="back-to-top" href="#">^ Back to top</a></h4> <p>You may also directly submit requests to this Cone Search service via TOPCAT, your web browser or other favourite tool (e.g. wget, Python) using the Virtual Observatory <em>Simple Cone Search</em> standard. This is especially useful if you would like to call a Cone Search from within a script. Instructions for using TOPCAT to load the results of a Cone Search can be <a href="http://www.star.bris.ac.uk/~mbt/topcat/sun253/ConeSearchDialog.html" target="_blank">found here</a>. </p> <p>For manual queries, the URL to submit your request to is:</p> <p><code>https://skymapper.anu.edu.au/sm-cone/public/query?</code></p> <p><span style="font-size:12pt">If constructing the URL yourself, use the required parameters </span><code>RA</code><span style="font-size:12pt">, </span><code>DEC</code><span style="font-size:12pt"> (both ICRS decimal degrees) and </span><code>SR</code><span style="font-size:12pt"> (search radius in degrees), and the optional parameter </span><code>VERB</code><span style="font-size:12pt"> (1=minimum to 3=maximum), for example:</span></p> <p><code>https://skymapper.anu.edu.au/sm-cone/public/query?RA=100&DEC=-30&SR=0.1&VERB=3</code></p> <p>By default, queries are made on the <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">dr4.master</span><span style="font-size:12pt"> catalog. You may search the object detection catalog by setting </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">CATALOG=dr4.photometry</span><span style="font-size:12pt"> (or similarly </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">dr2.[master|fs_photometry]</span><span style="font-size:12pt"> for the DR2 tables).</span></p> <p>You can also change the table format returned by the service using the optional <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">RESPONSEFORMAT</span><span style="font-size:12pt"> parameter and choosing either </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">VOTABLE</span><span style="font-size:12pt"> (VOTable XML file with full metadata), </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">CSV</span><span style="font-size:12pt"> (comma separated file with header row), </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">TSV</span><span style="font-size:12pt"> (tab separated file with header row) or their associated MIME-types (e.g. </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">application/xml</span><span style="font-size:12pt"> or </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">text/tab-separated-values</span><span style="font-size:12pt">). </span></p> <p><span style="font-size:12pt">For example:</span></p> <p><code>https://skymapper.anu.edu.au/sm-cone/public/query?RA=100&DEC=-30&SR=0.1&RESPONSEFORMAT=CSV</code></p> <p>will download a comma separated file (called result.csv) of default verbosity.</p> <p><span style="font-size:12pt">Some basic error checking will be performed by the server. More details on the </span><em>Simple Cone Search</em><span style="font-size:12pt"> standard and interpreting the VOTable results can be found in the </span><a href="http://www.ivoa.net/documents/REC/DAL/ConeSearch-20080222.html" style="font-size: 12pt;" target="_blank">IVOA documentation</a><span style="font-size:12pt">.</span></p> <h4><a name="aus_multicone"></a>Virtual Observatory Access (Multi-object Cone Searches)<a class="back-to-top" href="#">^ Back to top</a></h4> <p>For TOPCAT users who want to match multiple objects against SkyMapper Data Releases, you can use the Joins->Multicone or VO->Multicone functions. Use this Cone Search URL:</p> <p><code>https://skymapper.anu.edu.au/sm-cone/public/query?</code></p> <p>and select your local table, along with its RA and Dec columns, and a search radius.</p> <p>Similar functionality is available through STILTS using <a href="http://www.star.bris.ac.uk/~mbt/stilts/sun256/coneskymatch.html"><em>coneskymatch</em></a> and the Cone Search URL shown above.</p> <p>Both versions of multi-object cone searches allow the queried table to be changed from the default (<code>dr4.master</code>) to alternatives like <code>dr2.master</code> or <code>dr1.fs_photometry</code> by adding a <code>CATALOG=</code> specifier to the Cone Search URL.</p> <p> </p> <hr /> <h3><a name="aus_cutout"></a>Image Cutout Service<a class="back-to-top" href="#">^ Back to top</a></h3> <p><span style="font-size:12pt">This website also provides an interface to the </span><a href="/image-cutout/" style="font-size: 12pt;">DR4 Image Cutout service</a><span style="font-size:12pt">, which conforms to Version 1.0 of the Virtual Observatory </span><em>Simple Image Access</em><span style="font-size:12pt"> protocol (SIAP). At a minimum, an image cutout request requires:</span></p> <ul> <li>A sky position (in either ICRS or Galactic coordinates, or a SIMBAD object identifier);</li> <li>An image size (currently restricted to <10 arcmin on a side)</li> </ul> <p>Note: the image size is calculated along the x and y <strong>image</strong> axes, which roughly align with E-W and N-S, respectively. For images with PA=0, North is up and East is left; for PA=180, the PNG versions have been rotated to display North-up and East-left, although the FITS versions retain the original orientation (with suitably rotated WCS parameters).</p> <p>Further query options are also available:</p> <ul> <li><span style="font-size:12pt">Restrict to certain filters (combination of </span><em>u,v,g,r,i,z</em><span style="font-size:12pt">);</span></li> <li>Restrict to a range of observation dates (specified as MJD or UT);</li> <li>An intersection keyword (see below);</li> <li>Amount of image metadata returned (e.g. image quality, WCS parameters)</li> </ul> <p>The website will validate your inputs to avoid any errors. The default output is to return a PNG preview, as well as download links for the FITS image and bitmask.</p> <p>The intersection keyword <span style="font-size:12pt">allows you to narrow your query to select only those images that completely cover the requested cutout region (</span><code>COVERS</code><span style="font-size:12pt">), at least contain the centre of the area (</span><code>CENTER</code><span style="font-size:12pt">, default behaviour), or overlap any part of the area (</span><code>OVERLAPS</code><span style="font-size:12pt">). This may give cutouts that are smaller than the dimensions requested. Note that the image centre given in the results table (</span><code>ra_cntr</code><span style="font-size:12pt">, </span><code>dec_cntr</code><span style="font-size:12pt">) and image name is that of the actual cutout, not the requested centre.</span></p> <p>On the results page you can sort the columns by clicking on the headers, or filter the rows to select only those images meeting further criteria. The table can then be saved as a VOTable (XML), CSV or tab separated file, or the entire table sent to TOPCAT <span style="font-size:12pt">(if it is running) </span><span style="font-size:12pt">or another Virtual Observatory client for further processing. </span>The individual FITS files can be sent to Aladin or saved to your computer along with the image bitmasks. You can also select multiple images and download them as a ZIP file. <em>Note that this feature sometimes does not work properly on earlier versions of Safari, or results in a file called 'Unknown' with no .zip extension. </em></p> <h4><a name="aus_siap"></a>Virtual Observatory Access (Simple Image Access v1)<a class="back-to-top" href="#">^ Back to top</a></h4> <p>Instead of using the website you may also submit requests directly to the image cutout service via TOPCAT, CDS Aladin or your favourite Virtual Observatory <em>Simple Image Access</em> tool. Instructions for using TOPCAT are <a href="http://www.star.bris.ac.uk/~mbt/topcat/sun253/SiapTableLoadDialog.html" target="_blank">available here</a>. <span style="font-size:12pt">More details on the </span><em>Simple Image Access</em><span style="font-size:12pt"> standard and interpreting the results can be found in the SIAP v1.0 documentation, </span><a href="http://www.ivoa.net/documents/PR/DAL/PR-SIA-1.0-20090521.html" style="font-size: 12pt;" target="_blank">available here</a><span style="font-size:12pt">. </span></p> <p>For manual queries, the URL to submit your requests to is:</p> <p><code>https://api.skymapper.nci.org.au/public/siap/dr4/query?</code></p> <p>If constructing the URL yourself, use the required parameters <code>POS</code> ('RA,Dec' in ICRS degrees), <code>SIZE</code> ('X[,Y]' in degrees) and the optional parameters <code>VERB</code> (0=minimum to 3=maximum), <code>BAND</code> (comma separated list of SkyMapper filters), <code>FORMAT</code> (<span style="background-color:#eeeeee; font-family:monospace">image/fits</span><span style="font-size:12pt"> and/or </span><span style="background-color:#eeeeee; font-family:monospace">image/png</span><span style="font-size:12pt"> MIME types, or the special values </span><code>ALL</code><span style="font-size:12pt">: all formats, </span><code>METADATA</code><span style="font-size:12pt">: service metadata only, </span><code>GRAPHIC</code><span style="font-size:12pt">: PNG output), </span><code>INTERSECT</code><span style="font-size:12pt"> (one of </span><code>COVERS</code><span style="font-size:12pt">, </span><code>CENTER</code><span style="font-size:12pt">, </span><code>OVERLAPS</code><span style="font-size:12pt">), </span><code>MJD_START</code><span style="font-size:12pt"> (Modified Julian Date) and/or </span><code>MJD_END</code><span style="font-size:12pt">. </span></p> <p>For example:</p> <p><code>https://api.skymapper.nci.org.au/public/siap/dr4/query?POS=189.99763,-11.62305&SIZE=0.05&BAND=g,r,i&FORMAT=GRAPHIC&VERB=3</code></p> <p>will return a list of nine 3'x3' <em>maximum</em> PNG images around the Sombrero galaxy where the central coordinates are inside the cutout region (<code>INTERSECT=CENTER</code>). Three of these images do not cover the full region and could be removed by specifying <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">INTERSECT=COVERS</span><span style="font-size:12pt">). All available image metadata columns will be returned. </span></p> <p><span style="font-size:12pt">Another example:</span></p> <p><code><span style="font-size:12pt">https://api.skymapper.nci.org.au/public/siap/dr4/query?POS=189.99763,-11.62305&SIZE=0.05,0.1&FORMAT=image/fits&INTERSECT=covers&MJD_END=56970</span></code></p> <p>will generate a list of six 3'x6' rectangular FITS cutouts in all available filters (default <code>BAND=all</code>) from images taken before 2014 November 09 which completely cover the cutout region <span style="font-size:12pt">(</span><code>INTERSECT=covers</code><span style="font-size:12pt">)</span><span style="font-size:12pt">. </span></p> <p><span style="font-size:12pt">You may also change the table format returned by the service using the optional</span><span style="font-size:12pt"> </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">RESPONSEFORMAT</span><span style="font-size:12pt"> parameter and choosing either </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">HTML</span><span style="font-size:12pt"> (sortable, filterable table for viewing in a browser), </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">VOTABLE</span><span style="font-size:12pt"> (VOTable XML file with full metadata), </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">CSV</span><span style="font-size:12pt"> (comma separated file), </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">TSV</span><span style="font-size:12pt"> (tab separated file) or their associated MIME-types (e.g. </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">application/xml</span><span style="font-size:12pt"> or </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">text/tab-separated-values</span><span style="font-size:12pt">). For instance, adding </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">RESPONSEFORMAT=CSV</span><span style="font-size:12pt"> to the above query will download the image list as a comma separated file.</span><span style="font-size:12pt"> </span><span style="font-size:12pt"> </span></p> <p><span style="font-size:12pt">Note that </span><strong>the service does not directly return images</strong><span style="font-size:12pt">, only a list of cutouts meeting your requirements. Once downloaded, the table can be further filtered by your client (e.g. TOPCAT or a Python script) and the images themselves downloaded at the URL in the </span><code>get_image</code><span style="font-size:12pt"> column for the requested <span style="background-color:#eeeeee; font-family:monospace">FORMAT</span>, or equivalently </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">get_fits</span><span style="font-size:12pt"> or </span><span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">get_mask</span><span style="font-size:12pt"> for the FITS images and bitmasks. </span></p> <p>If you know the image ID and CCD number (from an ADQL query against the <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">photometry</span> or <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">ccds</span> tables, for instance), you can directly generate images by querying the service /<span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">get_image</span><span style="font-size:12pt"> endpoint:</span></p> <p><code>https://api.skymapper.nci.org.au/public/siap/dr4/get_image?IMAGE=20140425124821-10&SIZE=0.0833&POS=189.99763,-11.62305&FORMAT=png</code></p> <p>This will generate a 5'x5' PNG cutout around the Sombrero galaxy from CCD 10 of the g-band image wth ID 20140425124821. Using <code>FORMAT=fits</code> will download the corresponding FITS file and <span style="background-color:#eeeeee; font-family:monospace; font-size:12pt">FORMAT=mask</span><span style="font-size:12pt"> will download the FITS bitmask, which can be used to identify bad or saturated pixels. </span></p> <p><span style="font-size:12pt">For bandwith reasons we do not offer full CCD images (38 x 19 arcmin, 4096 x 2048 pix) for download as part of DR4. If these would be useful, please </span><a href="mailto:skymapper@anu.edu.au" style="font-size: 12pt;">contact us</a><span style="font-size:12pt"> and we will consider offering them as part of later data releases, or as a bulk download.</span></p> <p> </p> <hr /> <h3><a name="aus_adql"></a>Full Catalogue Search (ADQL)<a class="back-to-top" href="#">^ Back to top</a></h3> <p>The most powerful way to access SkyMapper and co-hosted external catalogues is through a <a href="/tap">Full Catalogue Search</a> using the <a href="http://www.ivoa.net/documents/latest/ADQL.html" target="_blank">Astronomical Data Query Language</a> (ADQL), a Virtual Observatory standard almost identical to the SQL used by relational databases such as MySQL, PostgreSQL and the <a href="http://skyserver.sdss.org/casjobs/" target="_blank">SDSS CasJobs service</a>. Requests of this type are processed by the VO-standard Table Access Protocol (TAP). A typical ADQL query might be:</p> <p><code>SELECT * FROM dr4.master WHERE dej2000<-80 AND g_psf<16 AND FLAGS=0</code></p> <p>which would select all columns from the SkyMapper <code>dr4.master</code> catalogue for stars below a declination of -80 degrees with <em>g</em>-band magnitudes < 16 and good flags.</p> <p>For simple queries <span style="font-size:12pt">(fast-running, <2,000 rows)</span><span style="font-size:12pt"> </span><span style="font-size:12pt">you can use the <a href="/tap">website</a> to perform your search. Several example ADQL queries are provided with the form to get you started – simply click on the name of an example to populate the query box. You can </span><span style="font-size:12pt">find further information on ADQL and detailed tutorials </span><a href="http://is.gd/ADQLTutorial" style="font-size: 12pt;" target="_blank">here</a><span style="font-size:12pt">, </span><a href="http://docs.g-vo.org/adql/html/twoup.pdf" style="font-size: 12pt;" target="_blank">here</a><span style="font-size:12pt"> and </span><a href="http://tapvizier.u-strasbg.fr/adql/help.html" style="font-size: 12pt;" target="_blank">here</a><span style="font-size:12pt">.</span><span style="font-size:12pt"> To help you formulate your queries you can also browse the available tables and columns using the </span><a href="/table-browser" style="font-size: 12pt;">Table Browser</a><span style="font-size:12pt">.</span></p> <p><span style="font-size:12pt">To avoid long queries tying up resources on the server and crashing your browser, results are limited to 100 rows by default for queries from the website. You may override this limit by specifying <code>SELECT TOP nnn</code> in your request or changing the value in the drop-down box. However, if you attempt to request over 2,000 results, the system will automatically scale your request back to that limit, with no guarantee of the same rows each time the query is run. <strong>This is only a hard limit on access from the website and larger requests (up to 1 million rows) are possible using other TAP clients (e.g. TOPCAT).</strong></span></p> <p><span style="font-size:12pt">Requests submitted via the website will be validated for both ADQL syntax errors and compatibility with the tables and columns available in database. For reference, your ADQL query is displayed on the results page and saved to the header of the VOTable returned by the service. </span><span style="font-size:12pt">You can sort the columns on the results page by clicking on the headers, or filter the output to select only those rows meeting further criteria. </span><span style="font-size:12pt">The table can then be saved as a VOTable (XML), CSV or tab separated file, or the entire table sent to TOPCAT </span><span style="font-size:12pt">(if it is running) </span><span style="font-size:12pt">or another Virtual Observatory client for further processing.</span></p> <h4><a name="aus_tap"></a>Virtual Observatory Access (TAP)<a class="back-to-top" href="#">^ Back to top</a></h4> <p>You may also submit requests directly to the TAP service via tools such as TOPCAT or <a href="http://docs.g-vo.org/tapsh-manual.html" target="_blank">TAPsh</a>.</p> <p><span style="font-size:12pt">For large, complex or long-running requests we recommend using the '<strong>asynchronous</strong>' query option if your client permits it. This allows your query to run in the background without your client blocking or timing out, and will save the results on the server for a period of time (currently 24 hours) for you to collect. In TOPCAT this is accomplished by selecting the 'Asynchronous' mode in the <a href="http://www.star.bris.ac.uk/~mbt/topcat/sun253/TapTableLoadDialog_query.html" target="_blank">Enter Query</a> window.</span></p> <p>For manual queries, the TAP endpoint is:</p> <p><code>https://api.skymapper.nci.org.au/public/tap/</code></p> <p>and has the IVOA identifier <code>ivo://nci.org.au/skymapper/tap</code>. <span style="font-size:12pt">Synchronous and asynchonous queries of up to 1 million rows can be made to the </span><code>tap/sync/</code><span style="font-size:12pt"> and </span><code>tap/async/</code><span style="font-size:12pt"> endpoints, respectively. The results of asynchronous queries are currently held on the server for 24 hours from the time of query submission, unless deleted earlier by the user. </span><span style="font-size:12pt">A full description of manipulating asynchronous TAP jobs through the Universal Worker Service (UWS) is beyond the scope of this documentation, but is discusssed in Section 5 of the <a href="http://www.ivoa.net/documents/TAP/20100327/REC-TAP-1.0.html" target="_blank">TAP standard</a>. </span></p> <p>You can view all available table metadata (in XML format) at the <code>tables/</code> endpoint:</p> <p><code>https://api.skymapper.nci.org.au/public/tap/tables</code></p> <p>or directly query the <code>TAP_SCHEMA.tables</code> and <code>TAP_SCHEMA.columns</code> tables within the TAP service itself. </p> <p>Please <a href="mailto:skymapper@anu.edu.au">contact us</a> if extra metadata, columns, tables, stored procedures or other catalogues would be useful for your work with SkyMapper and we will consider offering them as part of upcoming data releases. </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 © 2024 <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>