How do I...

Find out if SDSS's imaging data for an object are reliable?

The SDSS does automatic processing to determine the reliability of the imaging data for each of the 300 million objects that it has seen. The reliability data are referred to as flags. You can view flags for any object through the SDSS's Catalog Archive Server (CAS); the flags are stored in the PhotoObj table in the CAS database. Understanding the flags is extremely important for doing science, so that you can understand what data are reliable.

By using several flags together, you can search for only objects that have clean photometry. (skip to clean photometry search guide)

Flags are yes/no parameters. If a certain flag (such as Saturated) is present for an object, the object possesses that characteristic (i.e. its image is saturated). To save space in the database, the flags are stored as zeros (absent) or ones (present). Each object has a long bitwise number associated with it, where each set of digits corresponds to one flag. The CAS database includes functions that translate back and forth between the binary numbers and the flag names.

You can view flag names directly with the Explore tool (link opens in new window), but to work with flags in search results, you will need to know how to use the translate functions.

Get flags for a single object (open Explore in new window)

1. Use the Explore tool (link opens in a new window) to look at a single object. See the How do I get an image of my favorite object? tutorial to learn how to use the Explore tool.
2. Look at flags, the third row of data just below the object's coordinates. You will see the object's flags listed, one after the other with one space in between. See the list of flags in the Schema Browser for what they mean. Instructions for using the Schema Browser are in the next section, Interpret Flags.

Interpret Flags (open Schema Browser in new window)

1. Use the Schema Browser (link opens in a new window) to study the list of the SDSS's flags.
2. Type flags into the Search window and click Go.
3. Results of your search will show up in the right-hand window of the Schema Browser. Click on the very first PhotoObj link, next to the name flags. You will go to the schema browser entry for the PhotoObj view.
4. The 13^th entry in the table is flags. Click on the link to the right of flags.
5. The Data Values table shows the name, value, and description of each flag. Name is the name of the flag; this is what you will see in the Explore tool. Value is the bitmask value for the flag. Description is a short description of what the flag means.
6. The Access Functions, fPhotoFlags and fPhotoFlagsN, are needed to use the flag names in SQL queries.

Search for Flags in a Query

You can search through flags as part of your searches with the Imaging Query Form (link opens in a new window). You can request that the tool return only objects that possess one or more flags, such as searching for moving objects by looking for the MOVED flag. Or you can search for only those objects that do not possess certain flags, such as searching for unsaturated objects by checking that the SATURATED flag is off.

1. Go to the Imaging Query Form. From the astronomers' main page, look under Search Tools. For more on how to use the Imaging Query Form, see the guide How do I find data for all objects in a given RA/Dec/Magnitude/Absolute Magnitude range?
2. Select any parameters you like on the form, then look at the Obj Flags drop-down menus at the bottom of the form.
3. To guarantee that your results will possess a certain flag, select the flag from the At least one of these flags ON menu. To select more than one flag to check, hold down the CTRL key while selecting.
4. To guarantee that your results will not possess a certain flag, select the flag from the All of these flags OFF menu. To select more than one flag to check, hold down the CTRL key while selecting.
5. The flags will not show up in the search results unless you specifically request them in the Imaging menu of the Parameters to Return section above. But the flags will be searched, and the search will return only objects that meet your flag criteria.
6. Click Submit Request to send your query to the database.

Search for Flags with SQL

You can also search through flags as part of your searches using SQL. SQL searches will search for and return flags as long decimal numbers that have been converted from binary - but you translate between these numbers and the flag names with the functions dbo.fPhotoFlags and dbo.fPhotoFlagsN.

1. Go to the SQL Search tool (opens in new window), under the Search menu. To get there from the astronomers' main page, look under Search Tools. To get there from the public main page, look for Search under SkyServer tools.
2. To constrain your search based on flags, add one of the following to the WHERE block of your query:
   1. To find only objects for which a certain flag is present:
      WHERE (p.flags & dbo.fPhotoFlags('flag')) > 0

      Replace flag with the name of the flag you want to search.

      For example, this query will find IDs and positions of objects that have been flagged as having moved:

      SELECT objid, ra, dec

      FROM photoTag

      WHERE (flags & dbo.fPhotoFlags('MOVED')) > 0

      
      
   2. To find only objects for which a certain flag is absent:

      WHERE (p.flags & dbo.fPhotoFlags('flag')) = 0

      Replace flag with the name of the flag you want to search.

      For example, this query will screen out IDs and positions of objects that have been flagged as not being saturated:

      SELECT objid, ra, dec

      FROM photoTag

      WHERE (flags & dbo.fPhotoFlags('SATURATED')) = 0

      
      

Search for Objects with Clean Photometry

By using several flags together, you can limit your searches to return only objects that have clean photometry, thereby ensuring that you have a good sample. The flags you use differ depending on whether you are looking at stars or extended objects.

The queries below run slowly. These are test versions that use TOP 10 to return only the first 10 matching objects. To return all matching objects, remove the top 10 and use the CasJobs batch query system (link opens in a new window), which lets you run queries that take up to 8 hours. Also, note that lines that start with "--" are comments that are not executed as SQL statements.

For stars, use the following query to return IDs, positions, colors, and flags:

For extended objects, use the following query to return IDs, positions, colors, and flags:

Back to Tutorials index