Frequently Asked Questions
This page gives a list of frequently asked questions about the SDSS and Data Release 12.
Don’t see your question answered here, or elsewhere on the DR12 website? Email the SDSS-III Helpdesk!
About the SDSS
- What is the Sloan Digital Sky Survey?
- What is SDSS-III? Why the “three”?
- What data does SDSS have? What can SDSS tell me about the sky?
- I am a teacher. How can I use SDSS data in my classes?
- Why doesn’t SDSS have data for well-known visible stars (Sirius, Vega, etc.)?
- Why are some bright stars classified as galaxies?
About DR12 catalog data
- What interfaces are available to SDSS catalog data?
- My query no longer works in DR12 – what happened?
- What is the difference between
SpecObjAll? What do
- What are the differences between
- How do I get photometry for spectroscopic objects? What are the
- Why do some values (such as
SpecObj) have different numerical precision?
- What is the difference between
typefor spectroscopic objects, and which one should I use?
- I want to mirror the SDSS archive – how can I get a copy of all the data?
- Why can’t I log in to CasJobs?
- Why doesn’t my query work on SDSS-III CasJobs? It works on other SDSS-III sites.
- How do I recover my CasJobs password?
About Data Release 12
- What help is available for DR12?
- What is the sky coverage of DR12? Where in the sky do the data come from?
- How can I see if DR12 has an image or spectrum of my favorite object?
- How can I search for data?
- How can I match a list of objects to see what data are available for them in DR12?
- How do I convert from the SDSS’s ugriz magnitudes to UBVRI magnitudes?
About the SDSS
What is the Sloan Digital Sky Survey?
The Sloan Digital Sky Survey is an ongoing astronomy project that has been working since 1998 to make a detailed map of the universe, including our Milky Way galaxy. Since 2008, the survey has been in operating its third phase. Results and from the first two phases are available at www.sdss.org. Results and data from the current (third) phase are available on this website, www.sdss3.org.
What is SDSS-III? Why the "three"?
The Sloan Digital Sky Survey has been funded to operate in three phases. Phase one, from 1998 to 2005, was the original Sloan Digital Sky Survey.
Phase two, from 2005 to 2008, was the Sloan Digital Sky Survey II (SDSS-II), which consisted of three interrelated surveys. The SDSS Legacy Survey completed observations on the full coverage area of the SDSS as originally planned. The SDSS-II Supernova Survey scanned the same area of sky each clear night for three years, and found hundreds of type Ia supernovae. The SDSS-II SEGUE survey (Sloan Extension for Galactic Understanding and Exploration) mapped the structure and composition of the Milky Way.
Phase three, the Sloan Digital Sky Survey III (SDSS-III), is the current phase of operations. This website, accessible from the SDSS-III home page, describes SDSS-III, its four component surveys, and its science results. This site also includes data collected by the SDSS-III. The latest data is Data Release 12, made public on January 6, 2015.
What data does SDSS have? What can SDSS tell me about the sky?
The most recent SDSS data release is SDSS Data Release 12 (DR12), made public on January 6, 2015. It includes most data from prior data releases; so to get the most recent, up-to-date data for anywhere in the sky, use Data Release 12.
Data Release 12 includes imaging data for about one-third of the night sky. The imaging data include images from the camera on the SDSS’s 2.5-meter telescope as preview images (JPGs) and as FITS files. The data also include catalogs of detected objects, with parameters measured from imaging, including positions and magnitudes. DR12 also includes spectroscopic data for more than three million stars, galaxies, and quasars, Spectra are available as preview images (PNGs) and FITS files. Spectroscopic catalog data include object types and redshifts.
All DR12 data are available from this site. See DR12 Data Access to learn how to view and download DR12 data.
Prior SDSS-III data releases are also available on this site. Data Release 9 (DR9) was made public on July 31, 2012. Data Release 8 (DR8) was made public on January 11, 2011.
The final data release for SDSS-I and SDSS-II is Data Release 7.
I am a teacher. How can I use the data in my classes?
The SDSS-III Education page describes what educational resources are available from the SDSS-III project.
The SDSS-III SkyServer website includes a variety of educational projects that use SDSS data to teach topics in astronomy and other sciences, using guided and open inquiry. With our Projects, you and your students can learn about spectra and colors of stars, galaxy types, the history of the universe, and much more.
You are welcome to use and adapt any of our projects in your classes, free of charge. For more information on what you can do with SkyServer in the classroom, see our Teacher FAQ.
Why doesn't the SDSS have data for well-known visible stars (Sirius, Vega, etc.)?
The SDSS has a very sensitive camera. Stars that you can see with your unaided eyes are a too bright for the SDSS’s camera; they are saturated, and the light from them spills all over the detector. The SDSS still gets an image of those stars (for example, here is an image of Pollux from SkyServer), but the image processing software is unable to handle these images, and there are no entries in the SDSS catalog.
Why are some bright stars classified as galaxies?
The SDSS distinguishes between stars and galaxies based on their shapes: single points of light are stars, and fuzzy patches of light are galaxies. Some stars are bright enough that their light saturates the camera, and thus the light spills over the image, so to the SDSS’s camera, they look like fuzzy disks instead of single points of light. Their appearance fools the SDSS’s software into classifying them as galaxies.
About Data Release 12
What help is available for DR12?
Apart from this page there is a Glossary of SDSS-III terms. Each SkyServer tool also has its own Help section. Finally, the SDSS-III helpdesk is there to help.
What is the sky coverage of DR12? Where in the sky do DR12 data come from?
The SDSS takes imaging data in long, narrow “stripes”, 2.5 degrees wide. Part of the processing of SDSS images is to select some objects as targets for follow-up spectroscopy. The SDSS then collects spectra later. Most spectra were collected using the original SDSS-I/-II spectrograph. DR12 includes data collected using the BOSS spectrograph and for the first time, data collected using the APOGEE spectrograph.
The Scope of DR12 page shows what areas of sky (sky coverage) are included in DR12. The Scope page also includes a Coverage Check form that allows you to see what data DR12 has for a given point on the sky.
How can I see if DR12 has an image or spectrum of my favorite sky object?
Go to the SkyServer Navigate tool. Enter the name of your object in the “Name” box, then press Enter. The RA/dec coordinates of the object will appear in the boxes below. Then, click Get Image.
If a sky image appears in the main Navigate frame, then DR12 has an image for your object.
If there is an image for your object, you can also check to see whether DR12 includes a spectrum. Under the RA/Dec boxes, find the Drawing options. Click the checkbox next to Objects with spectra. If a red square appears around your object, then your object has a measured spectrum in DR12.
Whether or not your object has a spectrum in DR12, the object’s magnitude data will appear in the right-hand pane. Click Quick Look to go see additional basic data about that object. Click Explore for more detailed data.
How can I search for data?
When you search for data in the SDSS, you are going through the SDSS database and looking for objects that match criteria you choose. For simple searches of photometric data, use the Imaging Query Form. For simple searches of spectroscopic data, use the Spectroscopic Query Form. For more complex searches, use Structured Query Language (SQL). See SkyServer’s guide on Searching for Data to learn more about SQL. To see thumbnail results of objects that meet your criteria, use the Image List tool.
For large, complex queries that will take a long time to run, use CasJobs, the SDSS’s batch query interface.
Many other search tools are available. See the DR12 Data Access pages for more options.
An important note if you are using Excel with the SkyServer educational projects: SDSS object IDs are so long that they get cut off in Excel, and show up with 000 as the last three digits. This means you won’t be able to find your objects anymore! To get around this problem, see this workaround.
How can I match a list of objects to see what data are available for them in DR12?
If you have a fairly small list of objects to match – a few hundred or so – use the SkyServer Cross-ID tool. Paste your list of objects, or upload a file containing data with the last two columns as (ra, dec) in decimal degrees. Click Submit. The next page will show only those objects that appear in the SDSS, with SDSS Object IDs that link to the Explore tool.
To see a thumbnail SDSS image of each matching object, use the Image List tool. Enter your list in the textbox on the upper left and click “Get Image”. Click on one of the thumbnails to go to that position in the Navigate tool, or on one of the object names to go to that object’s Explore tool entry.
For longer lists, use the Neighbors Search feature of CasJobs. See the CasJobs FAQ entry on “How can I cross-identify (find matching objects in SDSS) for my list of sources for which I have RA,decs?” for more information.
How do I convert from the SDSS's ugriz magnitudes to UBVRI magnitudes?
The SDSS measures magnitudes through ugriz filters, which give ugriz AB magnitudes. These magnitudes can be converted into UBVRI magnitudes using a set of transformations described on the Algorithms page of this site.
About DR12 catalog data
What interfaces are available to SDSS-III catalog data?
SkyServer (also known as the Catalog Archive Server [CAS]) is the website that hosts SDSS-III’s catalog data. The Science Archive Server (SAS) serves flat files and provides searches for FITS spectra, images of fields, and mosaics.
There are multiple interfaces to the SDSS-III catalog data, including:
- an interface to the Catalog Archive Server designed for astronomers, students and the general public
- a batch (asynchronous) system for querying the database and storing results, designed to allow astronomers to search SDSS-III catalog data flexibly and efficiently
- a command-line Python interface to SkyServer
- Emacs buffer
- an Emacs interface to SkyServer for running queries
- Science Archive Server (SAS)
- simple queries for retrieval of individual spectra and field binary FITS images, plus direct download of flat files
My query no longer works in DR12 - what happened?
Data Release 12 includes several small schema changes to handle the new data.
The SkyServer DR12 Schema Browser documents the DR12 catalog data schema in its entirety. Compare this documentation to the DR8 Schema Browser and the DR7 Schema Browser.
What is the difference between
SpecObjAll? What do
SpecObjAll table contains all spectroscopic objects, even duplicate spectra of the same object. Thus, we have created the
SpecObj view, which contains data for only those fibers defined as sciencePrimary – essentially, the best spectrum that the SDSS has obtained for that object. That is,
specObj contains no duplicate observations.
sciencePrimary, another parameter called
bossPrimary flags the best spectrum that BOSS has obtained for an object. Exact definitions of
bossPrimary can be found in the spectroscopic catalogs documentation.
What are the differences between
PhotoObjAll is a table that contains all of the measured photometric quantities for all of the imaging detections for every object. Because we measure hundreds of parameters for each of 1.2 billion detections, this is a very large table, and queries can take very long to run. Also,
PhotoObjAll includes duplicate and “special” detections such as parent or bright detections, which are normally not of interest to science users.
In an effort to speed up catalog data queries, we have created
PhotoTag, a view (virtual or logical table) of PhotoObjAll with only a subset of the photometric parameters that are most often requested. Queries on this “thin” version of PhotoObjAll run much faster usually than queries on the larger table. If you have a query that uses and returns only values stored in
PhotoTag, then you should definitely use
In addition, we have created
PhotoObj, a view of
PhotoObjAll that contains only those objects that are survey primary or survey secondary.
PhotoObj excludes special objects such as parent or bright detections. Because
PhotoObj contains the same parameters as
PhotoObjAll but effectively contains fewer objects, any queries for survey primary or survey secondary objects will run faster on
Finally, there is
PhotoPrimary, a view of
PhotoObjAll that only includes survey primary detections; if you are not interested in duplicate detections at all, this is the view to use.
To summarize, the
PhotoTag view is a vertical partition of
PhotoObjAll (fewer columns), and
PhotoSecondary are horizontal partitions of
PhotoObjAll (fewer rows).
Given the above, you should consider:
- Querying from
PhotoTagif it contains all the parameters you are using to search and all the parameters you want returned
- Querying from
PhotoObjotherwise, UNLESS you are interested in data for objects that are neither PRIMARY nor SECONDARY. In that case, you will need to use the full
- Importantly, the “shorthand” quantities u,g,r,i,z do not exist in
PhotoTag(because we want to keep the view as thin as possible). Instead, you must use the modelMag_[ugriz] columns. HOWEVER, in
PhotoObjAlland its views, only the u,g,r,i,z are indexed, and NOT the ModelMags! This difference in indexed columns is to save space (since indexes on a huge table like
PhotoObjAllare expensive), not to confuse you!
PhotoTag has many fewer parameters, larger portions of it can be cached, improving performance. We have found that for almost all queries that contain parameters fully in
PhotoTag, it is faster.
How do I get photometry for spectroscopic objects? What are the
SpecPhotoAll table and
The SpecPhotoAll table is a precomputed join between the PhotoObjAll and SpecObjAll tables. It includes the most requested parameters from these two tables. Because the join has already been performed, it can be faster than computing the join on the fly. The
SpecPhoto view contains the same parameters as
SpecPhotoAll, but only for objects that are survey primary or survey secondary.
Why do some values (such as
SpecObj) have different numerical precisions?
Internally, these numbers are stored to their full precision as they come out of the spectroscopic pipeline. When you perform a query, they have some default string format applied that cuts them to what you see.
But you can use SQL’s
str() function to change the string format to whatever you like.
To get z to 6 decimals, for example, change your query to search for
select str(z,8,6) as z instead of just
z, and analogously for
zErr. This applies the function
str() to the values in column
z and returns the result with column label
z (without the “as”, the result of a function has no column label). The function
str(col,length,dec) takes the numerical value in
col and formats it as a string of length length and with dec significant digits. In other words,
str(z,8,6) is the SQL equivalent to the C function
str() function rounds the result to the number of decimals you request.
What is the difference between class and type for spectroscopic objects, and which one should I use?
For any object in DR12, the
type parameter in
SpecObj and other tables was set when that object was targeted for spectroscopy (i.e., it is based on its morphology in the imaging data). The
class parameter is set by the spectroscopic pipeline after the spectrum is observed (i.e., it is based on features in the spectrum).
In nearly all cases, you should believe the classification in
class, since it tells you what the measured spectrum actually was. The
type field tells you about why it was targeted. (However, there is more information about the object’s target selection history in the target bits; see the target bitmasks pages for more information.
I want to mirror the SDSS archive - how can I get a copy of all the data?
A copy of the current publicly-available SDSS data release is available from UIC (University of Illinois at Chicago) for worldwide distribution over fast links. Please see the SkyServer support site at skyserver.org for further details on how to host a mirror site and where to get the data. Click on the SDSS Mirrors link on that site.
Why can't I log in to CasJobs?
There are actually two CasJobs sites. SDSS-I/-II CasJobs hosts data from the original SDSS-I and SDSS-II, up through Data Release 7. SDSS-III CasJobs hosts data from Data Releases 8 and 9. If you have a login on SDSS-I/-II CasJobs, you will need to create a new account on SDSS-III CasJobs to work with SDSS-III data.
Why doesn't my query work on SDSS-III CasJobs? It works on other SDSS-III sites.
CasJobs uses the idea of query contexts, allowing you to specify what data sources you can query. The default context is to search your MyDB personal database space. To search DR12, the context should be set to DR12. You can choose from the Context drop-down menu above the area where you run queries. Before you run a CasJobs query, check what context you are searching. See the CasJobs user guide for more information.
How do I reset my CasJobs password?
CasJobs does not include a password recovery utility. To reset your CasJobs password, email the SDSS-III helpdesk. We will create a temporary password that you should change when you log in.