Full Catalogue Search (ADQL)
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 TOPCAT with the asynchronous TAP service, as described on the How To Access page.
Queries are made to this service using the Astronomical Data Query Language (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 here, here and here.
TAP queries are data-release agnostic – all tables from all releases are available via our TAP server.
Note: By using SkyMapper data, you agree to observe the SkyMapper policies published on this website.
23 Mar 2018: We have identified an issue with our external ADQL validation provider. Until we can rectify this issue, we have disabled validation against table and column names. Your ADQL query will still be checked for syntactic validity, but will not be tested to see if the tables/columns you are asking for actually exist.
▶ Example ADQL Queries
Click on an example to show it in the ADQL Query box.
Get all columns from table | Get specific columns and rows | Multiple row constraints | Cone search (geometric query) | Aggregating rows | Grouping rows | Joining tables | Joining SkyMapper to other tables | Using Cross-matches | Returning RA/Dec in HMS/DMS