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.
What data does SDSS have? What can SDSS tell me about the sky?
The SDSS releases its data in batches, the most recent of which is SDSS Data Release 18 (DR18). Data releases are cumulative, so each release includes all the sky coverage and all the spectroscopic targets from all past releases. The Data section of this site will always bring you to the latest, most complete data.
I am a teacher. How can I use SDSS data in my classes?
The Education and Public Outreach of this site describes some of the many ways teachers have made use of our amazing resources.
Our SDSS Voyages website offers a series of hands-on lessons for students from elementary school through college majors, designed not only to teach astronomy, but also concepts from all over the science, math, and technology standards. Additional projects are available through the DR16 SkyServer Projects website.
Why doesn’t the SDSS have data for well-known visible stars (Sirius, Vega, etc.)?
The SDSS had a very sensitive camera. Stars that you can see with your unaided eyes are 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 the SkyServer Navigate tool), but the image processing software is unable to handle these images, so there are no entries for these bright stars in the SDSS imaging 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.
How do I access older data releases?
Since all our data releases are cumulative, we encourage new users to work with the most recent data. But for reproducibility, we make all previous data releases available online, and always will. See the Data Release Papers page for links and references to these prior releases.
About Data Release 18
What is new in Data Release 18?
Data Release 18 contains all images and image catalog data taken with the 2.5-meter Sloan Foundation Telescope at Apache Point Observatory, as well as all spectroscopic data from all prior phases and components of the Sloan Digital Sky Survey. New in DR18 are the spectroscopic targeting data for the three mappers that make up the fifth and newest phase of the SDSS project:
- Milky Way Mapper uses optical and infrared spectroscopy to find the spatial distribution and stellar parameters of more than 5 million Milky Way stars, to unravel the formation history of the Milky Way and its satellites.
- Local Volume Mapper is conducting a detailed multiwavelengh survey of galaxies at an unprecedented scale, millions of spectra at a time. The dataset will feature spatial resolution down to a few tens of parsecs, giving researchers their clearest view yet of how galaxies form and evolve.
- Black Hole Mapper measures the spectra of quasars – hundreds of thousands of quasars, over and over again hundreds of times over the course of several years. Its highly detailed measurements of quasar variability will help astronomers understand how black holes accrete gas and release x-rays.
What help is available for DR18?
Please note that your helpdesk email may be shared with SDSS collaboration members and contributors who we think can help answering with your question. We will retain your email and our responses for archival purposes. These questions posed may be used to guide the development of our online documentation, but no identifying or proprietary information from your email will be published in that documentation or elsewhere. We will delete your email if you request us to do so. None of the information from your email will be sold.
What is the sky coverage of DR18? Where in the sky do DR18 data come from?
The SDSS includes 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. DR18 includes data collected using the BOSS spectrograph for the BOSS, eBOSS and MaNGA surveys, and data collected using the APOGEE spectrographs for the APOGEE-1 and APOGEE-2 surveys.
How can I see if DR18 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 DR18 has an image for your object.
If there is an image for your object, you can also check to see whether DR18 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 DR17.
Whether or not your object has a spectrum in DR17, 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 DR18 Datasets 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 DR17?
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 the DR17 site.
About DR18 Data Interfaces
What interfaces are available to SDSS data?
There are multiple interfaces to SDSS data, including:
- SkyServer: Also known as the Catalog Archive Server (CAS), SkyServer is designed for astronomers, students and the general public.
- CasJobs: For bigger queries, CasJobs provides a batch (asynchronous) system for querying the database and storing results, designed to allow astronomers to search SDSS catalog data flexibly and efficiently.
- Science Archive Server: The Science Archive Server (SAS) provides direct access to the full SDSS data archive, including all directories and files listed in the Data Model.
- Science Archive Webapp: The Science Archive Webapp provides a searchable interface for optical and infrared spectra, images of fields and mosaics, and includes an interactive view of optical spectra and infrared spectra, and a data download facility (supports both rsync and wget). All searches are cached on the server so that you can return later, via a permalink, or email the permalink to share your search results.
My query no longer works – what happened?
Data Release 18 includes several small schema changes to handle the new data.
The SkyServer DR18 Schema Browser documents the latest catalog data schema in its entirety.
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 of Data Release 17.
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 DR17, 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 catalog archive – how can I get a copy of all the data?
A copy of the current publicly-available SDSS catalog archive is available from the SkyServer support site, which also contains information on how to host a Skyserver mirror site. Click on the Skyserver SDSS Mirrors link on that site.
Why can’t I log in to CasJobs?
As of May 10, 2016, CasJobs is part of the new SciServer collaborative data-driven science framework, and CasJobs users need to register on the SciServer portal with their original CasJobs credentials so that they can obtain a new account on the SciServer single-sign-on system that is linked to their existing CasJobs account.
Why doesn’t my query work on SDSS CasJobs? It works on other SkyServer 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 DR18, the context should be set to DR18. 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.