Cooking with Sloan: General Tasks: Find Close Pairs
 
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 Close Pairs

Back to General Tasks index

How do I...

View thumbnails (open Image List in new window)


  1. In the Image List tool, click on the Use query to fill form link, near the top left of the tool. You will see a textbox appear in the main panel of the window.

  2. Queries in the Image List tool must take a slightly different form than queries in the SQL Search tool. All Image List queries must have the following for their SELECT blocks:

    SELECT name, ra, dec

    So you must rewrite your query as:

    SELECT top 100 P1.objID as name, P1.ra as ra, P1.dec as dec
    FROM PhotoTag P1, -- P1 is the first object
        Neighbors N, -- N is the pre-computed neighbor objects
        PhotoTag P2 -- P2 is the second object
    WHERE P1.objID = N. objID -- P1 and P2 are neighbors
        AND P2.objID = N.NeighborObjID
        AND N.Distance < .05 -- objects are within 3 arcseconds

    Note that this will return only the name and position of the first object in the pair (although you should be able to see both objects in the thumbnail image). Also, note that the top 100 means that the query will be limited to return 100 objects.

  3. Click Submit, then Send to List. You will see thumbnail images for each of the objects that match your search criteria. The object at the center of the image will be only one of the objects, but both should be visible in the frame. You may find it helpful to turn on the Grid and PhotoObjs checkbox options.

  4. Note that if you run this query without the top 100, the query will return many results. To get all results you will probably need to use CasJobs (link opens in new window). See the CasJobs help pages (new window) for more information.


 Go to the previous page

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