Home Help Tools Create Account Login   Not Logged in

Help

CasJobs FAQ (PS1)
CasJobs FAQ (SDSS)
SQL Tutorial (SDSS)
Advanced Query Examples (SDSS)
PS1 survey documentation
Simple PS1 search form
PS1 image access

Frequently Asked Questions - PS1 specific 

Why does my query give me an error saying that the function I was using (e.g. fGetNearbyObjEq) is an invalid object? name?
This error usually indicates that the context is set incorrectly. Check that the context says PanSTARRS_DR1 and not MyDB.

I created an output catalog a while ago, and when I go to the Output tab it is no longer there. What happened to it?
There is a lifetime for output of 1 week.

What does 'Query results exceed memory limitations' mean?
This means the result of the query which you've submitted is greater than the memory buffer will allow. This message only applies to 'quick' queries; queries using 'submit' do not have any memory restrictions. The easiest thing to do is just use submit instead of quick.

How do I see all the searches I have done?
The History page will show all the queries you have done, as well as summary information (submit date, returned rows, status). If you click on Info, you can see the exact query that executed. You can also resubmit queries from this page. The previous query appears on the Query page and can be edited before it is submitted again.

How do I see all the results I have generated?
The MyDB page shows you all the catalogs you have generated. Clicking on the catalog name will show you the details of the catalog.

How do I see all the available PS1 tables?
On the MyDB page, set the context to PanSTARRS_DR1. Clicking on the table name will show you the details of the table. Click the 'Sample' button above the table to see some sample rows.

Some tables appear in the separate 'Views' list that is selected by clicking 'Views' just under the context menu. These tables have been constructed by the database administrator for more convenient access to certain kinds of data. Generally you can query them exactly as you would a normal table.