This page is meant to help users to prepare queries to download data from the PanSTARRS archive.
Where to start
To start a query for public PanSTARRS data go to the PS1 archive at Space Telescope http://panstarrs.stsci.edu/ and access with your username and password. To obtain a username and password write a request to firstname.lastname@example.org.
On the main page you will find these links:
- Main: you can access the website Index Map, the News, look for help, change your profile settings and logout.
Query Page: You can submit a SQL query to download catalogs from the different photometric surveys (Select Database: PanSTARRS_3PI, i.e. the complete survey, PanSTARRS_M01-10, i.e. the Medium Deep Field survey, etc..). If you prepared a query in SQL you can directly upload it by clicking on Upload Query File Form. If you are not an expert of SQL you can find some useful query examples by clicking on Query Examples Forms. Quality Flag Tool allows you to interpret the quality flag informations present in the different tables (Object table, Detection table, etc..).
Queued Jobs: here you will find the status of your submitted search. The status will be Ready if the search was successful; Failed if it encountered problems/errors, and Progress if the search is still going on. The search can be successful but it will provide a table with 0 rows if the result of the search is null. Under the option Query there is the possibility to click on Edit and go back to the Query page and modify and/or correct the query under the option Result you will be able to click on the available link and eventually download the queried table.
- MyDB: here you will find all the tables you queried for. You have the possibility to download them by clicking on Table Extraction Form, select one of the table from your MyDb table list, select the file format you prefer (CSV, FITS, TVCS, VOTable) and then click on Extract (Note that the CSV format table you download here uses " as separators.)
- Graphing: here you will have the possibility to draw plots based on the content of one of your MyDB tables.
- Postage Stamps: here you will be able to query for postage stamps from the different PanSTARRS surveys.
How to proceed
Some example queries are listed here:
- Retrieve mean magnitudes, forces magnitudes, single epoch detections and difference imaging light curves for a sample of 13 RR Lyrae stars from the Catalina Sky Survey SAS 40: Light curves, forced light curves, and difference image light curves of an RR Lyrae list
- More general examples of easy quieries: Useful PSPS Queries (Update to the new schema)