|Cooking with Sloan|
|Search Form Guide|
|SQL in SkyServer|
|Sample SQL Queries|
|Contact Help Desk|
When you first launch the Search Form, you will see a screen like the one on the right. Read over the sentence described by the form. Here are what the different menu choices on the form mean:
Object types and positions
lets you specify what region of sky you want to search. "Anywhere" will return objects anywhere in the sky. If you change the menu to "around: ", a new item will appear just below:
lets you specify what region of the sky you want to search. RA (Right Ascension) and dec (Declination) are sky
coordinates; Right Ascension is like longitude and Declination is like latitude. Here are two good
explanations of how the right ascension and declination system works:
RA runs from 0 to 360 degrees (note that SkyServer always uses decimal degrees rather than hours-minutes-seconds), and dec runs from -90 to 90 degrees. Also, enter a search radius in arcminutes (60 arcminutes = 1 degree). The maximum radius the form can accept is 600 arcminutes (10 degrees). If you select "around: " for the region, be sure to enter an ra, dec, and radius here.
Check SDSS Footprint
This button will allow you to check whether the region you chose has been seen by the SDSS. After you have entered your region, click the button. A new window will open telling you whether or not this region is part of the SDSS.
Magnitudes and Colors
lets you specify what magnitudes and colors your results should have. Magnitude is a measure of how bright an object is. This magnitude page gives a good explanation of how the magnitude scale works. Color is defined as the difference in an object's magnitude when seen through two different filters; see SkyServer's Color project for more information.
You can search for objects of different magnitudes by specifying upper and lower limits in each wavelength filter (u,g,r,i,z). Enter the lower limit in the left-hand textbox and the upper limit in the right-hand textbox. You can enter either one or two limits. "20 < g" would return only objects with a magnitude greater than 20 in the g filter; similarly, "g < 20" would return only objects with a magnitude less than 20 in the g filter. "18 < g < 20" would return only objects with magnitudes between 18 and 20.
Remember that the magnitude scale runs backwards, so if you want objects with g brighter than magnitude 18, you should enter g < 18. The g magnitude is the one closest to what you see with your eyes.
Searching by color works in the same way as searching by magnitude.
The number textboxes accept only the following reasonable values:
Spectra and Redshift
lets you choose whether the form will return all objects or only objects for which the SDSS has measured a spectrum. A spectrum is a graph of how much light an object emits as a function of wavelength; this page from the University of Illinois gives a good introduction to spectra. A spectrum can tell you a lot of information about an object, but the SDSS has measured far fewer spectra than images and magnitudes. Your menu choices are "all objects" and "only objects with spectra". If you change the menu to "all objects with spectra", a new item will appear just below:
lets you specify the possible redshifts of your results. Redshift is a measure of how fast a galaxy or quasar is moving away from Earth. SkyServer's Redshift page (part of the Universe project) gives more information. The textboxes will only accept the (reasonable) values of between 0 and 6. Also, the number in the first textbox must be smaller than the number in the second textbox.
lets you control what types of data your search will return. (Note that the third line, beginning with "redshift," will only appear if you selected "only objects with spectra" above.) The first line tells how many results the search will return. "Count only" means the search will return only the number of results that meet your search criteria, and not the actual data from those results. "100" and "1000" will return selected data for the first 100 or 1000 matches to your search. "All" will return data for all matching objects - but the search might take a very long time.
The rest of the checkboxes control what data your search will return:
Check a box, and your search will return that piece of data. Uncheck a box, and it will not.
Generating and Updating Your Query
lets you generate the SQL statement that will send your search request to SkyServer. When you have finished selecting all the options you want to select, click "Generate Query" to see the SQL statement. ALWAYS click Generate Query before clicking one of the buttons below to search the database.
Your complete SQL query will appear in the box below "SQL Query". Study the query - it will help you learn how SQL works. If you want, you may return to the menus and select other options to change your query. If you do this, click "Update Query" to load the new version of your query.
If you want to edit your query directly by typing in the query box, click "Edit Query." Make your changes; when you are satisfied with your edited query, click "Done Edit." However, keep in mind that once you click Edit Query, you will NOT be able to make any further selections from the menus above unless you reset the form.
Submitting Your Query to SkyServer and Image List
lets you submit your query to the SDSS database, either through either the SkyServer Search tool or Image List tool. Click "Submit Your Query to SkyServer" to submit your query to the Search tool. You will receive numerical data for your results. You may choose from one of two formats for these data by clicking one of the radio buttons:
After you have selected your response format, click "Submit Your Query to SkyServer." If there are any errors in your query, you will see a message like this alerting you of the error:
If you requested Object IDs, and you plan to open CSV files in spreadsheet programs, you will need to take steps to make sure the IDs don't get cut off. See SkyServer's Graphing Tutorial to learn how to open the CSV file.
Submitting Your Query to Image List
lets you submit your query directly to SkyServer's Image List tool. The Image List tool will let you see thumbnail pictures of the objects match your search. This can be a powerful way to get a quick understanding of your search results.
When you click the "Submit Query to Image List" button, you will see a screen that looks something like this:
Click "Send to List" to load your search results into the Image List tool. The screen will change to look like this:
The thumbnails show all the objects that met your search criteria. Click on one of the "page" links at the top of the page to go to another page of search results. Click any of the thumbnails to open the Object in the Navigate Tool.
resets all menu choices to their default values, and clears any SQL query in the box
Hints for Better Searches
SkyServer is a very large database, with complete information on 180 million sky objects. The server that runs SkyServer has limits on the length of time that searches can run. If you don't plan your search carefully, you could get a message that says, "Timeout Expired," which means that your search will not return any data. Here are some tips to make sure your queries complete in a reasonable amount of time:
Your search may also return a message that says, "No objects have been found". If you expected to find objects, try the following:
If you have questions about this form, contact us.