Cooking with Sloan: General Tasks: Find Data for Objects
 
DR7 Help
 Site News
 Introduction
 Cooking with Sloan
     - General
     - Solar System
     - Stars
     - Galaxies
     - QSOs/Cosmology
     - Teaching/Labs
 FAQ
 
 Search Form Guide
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Graphing
 Query Limits
 Searching Advice
 
 Archive Intro
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 Web Browsers
 
 Download
 Data Publications
 API
 SkyServer Sites
 
 Contact Help Desk
Find Data for Objects

Back to General Tasks index

Find by Position (open tool in new window)


One of the constraints you can use is to find objects only in a specific part of the sky. Use the Position Constraints box to choose constraints. You can choose not to use any position constraints (None), or you can choose one of three types (Rectangle, Cone, and Proximity).

  1. Rectangle finds objects within a rectangle between a minimum and maximum RA and Dec. Enter minimums and maximums for RA and Dec, either in decimal degrees or in HMS/DMS. HMS input can be formatted as either HH:MM:SS.ss or HH MM SS.ss.

  2. Cone finds objects within a radial patch of sky defined by a center RA/Dec and a radius. The default value is a search around RA = 180, Dec = 0.2.

  3. Proximity finds objects near to a list of positions. You give the list, either by pasting into the textbox or by uploading a file. You can optionally specify a maximum separation in which to search.

  4. When you have finished entering all your constraints, click Submit Request. The tool will return only the objects you asked for, in the output format you specified. You now have your results; read the next step to see how to get the same results using SQL.

  5. If you would rather use SQL to search by position, write your query so that it uses one of the position functions, either dbo.fGetNearbyObjEq(ra,dec,radius) or dbo.fGetObjFromRect(ra1,ra2,dec1,dec2). Specify the function in the FROM block, and be sure to check that the object IDs are the same in the WHERE block. So here is a query to search a radial patch of sky, returning IDs and positions (click Submit to run):

 

Format HTML XML CSV

Enter your SQL query in the text box. The query is limited to 10 minutes and 100,000 rows.


Next: Find by Magnitude

 Go to the previous page Go to the next page

Back to Cooking with Sloan main page
Back to Help main page
Contact Help Desk