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

Back to Stars index

Search for CVs by color (open tool in new window)


  1. Go to the SQL Search tool (link opens in new window). From the astronomers' main page, look under Search Tools. From the public main page, look under SkyServer Tools, then Search.

  2. In the main window, type the following query (or run the query from the query box at the bottom of this page):

    SELECT objID, ra, dec   -- get object ID, ra, dec of binary star
    FROM PhotoPrimary   -- From all primary objects (best detections)
    WHERE u - g < 0.4   -- Search based on known colors of CVs
       AND g - r < 0.7
       AND r - i > 0.4
       AND i - z > 0.4

    The query returns the object ID, RA, and dec of each binary star. By changing the color constraints (such as u - g < 0.4) to the color constraints of another type of object you want to find, you can search for those objects instead.

Use the query box below to practice running the query shown above. You can modify the query to return other data if you want. Click Submit to run the query or Reset to reset the query box.

 

Format HTML XML CSV

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


Next: View the CVs

 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