<p>There are plates beyond 3006 (up to #12547) but there are considerable gaps in the sequence, corresponding to the different surveys that have run as part of SDSS during its (long) <a href="https://www.sdss.org/dr18/completed_surveys/" rel="nofollow noreferrer">history</a>.</p>
<p>I think the easiest way to find out what's available, if you are planning on downloading a large fraction of the available spectra, is to use the <code>plates-dr17.fits</code> FITS binary table from the <a href="https://www.sdss4.org/dr17/spectro/spectro_access/" rel="nofollow noreferrer">Available Optical Spectral Data</a> which list all the plates taken, along with a large amount of other data (131 columns in total).</p>
<p>This table can be accessed using e.g. AstroPy in Python or using table tools such as TOPCAT; a screenshot of the table (with many columns hidden, jump in PLATE number rows highlighted) shows the jump from <code>PLATE=3006</code> which looks to be the last plate taken under the legacy survey (see <code>SURVEY</code> and <code>PROGRAMNAME</code> columns), and then <code>PLATE=3105</code> which is the first of the new (at the time) of the <a href="https://www.sdss4.org/surveys/segue/" rel="nofollow noreferrer">SEGUE2</a> survey during the SDSS-III era:
<a href="https://i.sstatic.net/8iPga.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8iPga.png" alt="Screenshot from the TOPCAT software showing the contents of the plates-dr17.fits FITS binary table" /></a></p>
<p>Use of this table, possibly combined with suitable cuts on the quality e.g. using the <code>PLATEQUALITY</code> column, should give you a list of useful/valid plates to query for the associated spectra.</p>

CC BY-SA 4.0
2023-08-24T23:44:22.057Z
2023-08-24T23:44:22.057Z
astrosnapper
<p>I'm trying to automate downloading FITS files from SDSS. Currently, I'm getting information on the plate, mjd, and fiberID of certain objects from an SQL query on SpecObj, which I'm using in an url like <a href="https://dr18.sdss.org/sas/dr18/spectro/sdss/redux/26/spectra/PLATE/spec-PLATE-MJD-FIBERID.fits" rel="nofollow noreferrer">https://dr18.sdss.org/sas/dr18/spectro/sdss/redux/26/spectra/PLATE/spec-PLATE-MJD-FIBERID.fits</a> to download the .fits files. However, some of the plates I got are not present in SDSS SAS, namely ones past 3006. Does anybody know an automatable way to get SDSS spectra for all the plates?</p>

<fits><sloan-dss>
Not finding some FITS Spectra files in SDSS
obl1t
# Not finding some FITS Spectra files in SDSS

(Asked by: username_0 on 2023-08-24)

I'm trying to automate downloading FITS files from SDSS. Currently, I'm getting information on the plate, mjd, and fiberID of certain objects from an SQL query on SpecObj, which I'm using in an url like <https://dr18.sdss.org/sas/dr18/spectro/sdss/redux/26/spectra/PLATE/spec-PLATE-MJD-FIBERID.fits> to download the .fits files. However, some of the plates I got are not present in SDSS SAS, namely ones past 3006. Does anybody know an automatable way to get SDSS spectra for all the plates?

**Tags:** fits, sloan-dss

---

## 1 answers

### Answer by username_1 on 2023-08-24. Score: 1 | Accepted answer

There are plates beyond 3006 (up to #12547) but there are considerable gaps in the sequence, corresponding to the different surveys that have run as part of SDSS during its (long) [history](https://www.sdss.org/dr18/completed_surveys/).

I think the easiest way to find out what's available, if you are planning on downloading a large fraction of the available spectra, is to use the `plates-dr17.fits` FITS binary table from the [Available Optical Spectral Data](https://www.sdss4.org/dr17/spectro/spectro_access/) which list all the plates taken, along with a large amount of other data (131 columns in total).

This table can be accessed using e.g. AstroPy in Python or using table tools such as TOPCAT; a screenshot of the table (with many columns hidden, jump in PLATE number rows highlighted) shows the jump from `PLATE=3006` which looks to be the last plate taken under the legacy survey (see `SURVEY` and `PROGRAMNAME` columns), and then `PLATE=3105` which is the first of the new (at the time) of the [SEGUE2](https://www.sdss4.org/surveys/segue/) survey during the SDSS-III era:
[![Screenshot from the TOPCAT software showing the contents of the plates-dr17.fits FITS binary table](https://i.sstatic.net/8iPga.png)](https://i.sstatic.net/8iPga.png)

Use of this table, possibly combined with suitable cuts on the quality e.g. using the `PLATEQUALITY` column, should give you a list of useful/valid plates to query for the associated spectra.


---

