Sloan Digital Sky Survey
SkyServer DR14  
Not logged in Login Help

DR14 Help
 Start Here
 Cooking with Sloan
     - General
     - Solar System
     - Stars
     - Galaxies
     - QSOs/Cosmology
     - Teaching/Labs
 Contact Help Desk
 Searching SDSS
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 About the Database
 Table Descriptions
 Schema Browser
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.


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