List of Fields available via Retrieve
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
data_release | CORE | — | [Categorical] Data release of a given record (with a common data structure, e.g., SDSS-DR16, BOSS-DR16) | ✘ | ✔ |
datasetgroup | CORE | — | [Categorical] Common name for a coherent set of spectra published as a single release (e.g., SDSS_BOSS) | ✘ | ✔ |
dateobs | CORE | — | Range of observational dates for a given spectrum (single value for a single date) | ✘ | ✔ |
dateobs_center | CORE | — | Central value of the dateobs range | ✘ | ✔ |
dec | CORE | deg | Declination in degrees | ✔ | ✔ |
exptime | CORE | second | Exposure time in seconds | ✘ | ✔ |
extra_files | CORE | — | Additional files read for ingest | ✘ | ✘ |
file | CORE | — | File used for this record | ✘ | ✘ |
instrument | CORE | — | [Categorical] Instrument used for observation | ✘ | ✔ |
ra | CORE | deg | Right Ascension in degrees | ✔ | ✔ |
redshift | CORE | — | Measured redshift, or radial velocity in units of redshift | ✘ | ✔ |
redshift_err | CORE | — | Uncertainty on the measured redshift, or radial velocity in units of redshift | ✘ | ✔ |
redshift_warning | CORE | — | Bitmask with warning on redshift result | ✘ | ✔ |
site | CORE | — | [Categorical] Site of observations | ✘ | ✔ |
sparcl_id | CORE | — | Universally Unique Identifier for spectrum in SPARCL | ✔ | ✔ |
specid | CORE | — | Dataset-specific spectrum identifier (may not be unique) | ✔ | ✔ |
specprimary | CORE | — | Whether an entry is the primary spectrum for a given target object | ✘ | ✔ |
spectype | CORE | — | [Categorical] Spectral type of the object (STAR, GALAXY, QSO) | ✘ | ✔ |
targetid | CORE | — | Dataset-specific photometric target identifier | ✘ | ✔ |
telescope | CORE | — | [Categorical] Telescope used for the observation | ✘ | ✔ |
updated | CORE | — | Date and time when the record was created/updated | ✘ | ✘ |
wavemax | CORE | AA | Maximum value of wavelength coverage in Angstroms | ✘ | ✔ |
wavemin | CORE | AA | Minimum value of wavelength coverage in Angstroms | ✘ | ✔ |
.csv
Download .json
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
spec1_i | AUX | — | Signal-to-noise squared for spectrograph #1, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra | ✘ | ✔ |
spec1_r | AUX | — | Signal-to-noise squared for spectrograph #1, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra | ✘ | ✔ |
spec2_g | AUX | — | Signal-to-noise squared for spectrograph #2, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra | ✘ | ✔ |
spec2_i | AUX | — | Signal-to-noise squared for spectrograph #2, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra | ✘ | ✔ |
spec2_r | AUX | — | Signal-to-noise squared for spectrograph #2, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra | ✘ | ✔ |
specboss | AUX | — | Set to 1 for primary BOSS spectrograph observation of object, 0 otherwise | ✘ | ✔ |
special_target1 | AUX | — | Primary (science) target flags for SDSS-I and SDSS-II special program targets | ✘ | ✔ |
special_target2 | AUX | — | Secondary (calibration) target flags for SDSS-I and SDSS-II special program targets | ✘ | ✔ |
speclegacy | AUX | — | Set to 1 for primary SDSS Legacy program observation of object, 0 otherwise | ✘ | ✔ |
specsdss | AUX | — | Set to 1 for primary SDSS spectrograph observation of object, 0 otherwise | ✘ | ✔ |
specsegue | AUX | — | Set to 1 for primary SDSS SEGUE program observation of object (including SEGUE-1 and SEGUE-2), 0 otherwise | ✘ | ✔ |
specsegue1 | AUX | — | Set to 1 for primary SDSS SEGUE-1 program observation of object, 0 otherwise | ✘ | ✔ |
specsegue2 | AUX | — | Set to 1 for primary SDSS SEGUE-2 program observation of object, 0 otherwise | ✘ | ✔ |
spectroflux | AUX | nanomaggy | Spectrum projected onto ugriz filters | ✘ | ✔ |
spectroflux_ivar | AUX | nanomaggy-2 | Inverse variance of spectrum projected onto ugriz filters | ✘ | ✔ |
spectrographid | AUX | — | Which spectrograph (1 or 2) | ✘ | ✔ |
spectroskyflux | AUX | nanomaggy | Sky flux in each of the ugriz imaging filters | ✘ | ✔ |
spectrosynflux | AUX | nanomaggy | Best-fit template spectrum projected onto ugriz filters | ✘ | ✔ |
spectrosynflux_ivar | AUX | nanomaggy-2 | Inverse variance of best-fit template spectrum projected onto ugriz filters | ✘ | ✔ |
subclass | AUX | — | Best spectroscopic subclassification | ✘ | ✔ |
subclass_noqso | AUX | — | Spectroscopic subclassification for Z_NOQSO redshift | ✘ | ✔ |
survey | AUX | — | Survey name | ✘ | ✔ |
targetobjid | AUX | — | Unique database ID of targeting object based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version) | ✘ | ✔ |
targettype | AUX | — | General type of target (SCIENCE, STANDARD, or SKY) | ✘ | ✔ |
tcolumn | AUX | — | Columns of template files that correspond to each template | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
mask | SPECTRA | — | and_mask | ✘ | ✔ |
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
wave_sigma | SPECTRA | pixel | Line-spread function width (sigma of approximating Gaussian) in units of number of pixel | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit used for classification and redshift | ✘ | ✔ |
sky | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Subtracted sky flux | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
nspecobs | AUX | — | Number of spectroscopic observations of this source | ✘ | ✔ |
nturnoff | AUX | — | Number of stars used for SNTURNOFF determination | ✘ | ✔ |
objid | AUX | — | SDSS photometric object identification numbers (RUN, RERUN, CAMCOL, FIELD, ID) | ✘ | ✔ |
plate | AUX | — | Plate number (each plate corresponds to an actual plug plate) | ✘ | ✔ |
plateid | AUX | — | Unique database ID of plate based on PLATE, MJD, RUN2D (same as SkyServer version) | ✘ | ✔ |
platequality | AUX | — | Final quality of plate this spectrum came from (good, marginal, or bad) | ✘ | ✔ |
platerun | AUX | — | Drilling run that this plate was drilled in | ✘ | ✔ |
platesn2 | AUX | — | Overall signal-to-noise-squared measure for plate (only for SDSS spectrograph plates) | ✘ | ✔ |
primtarget | AUX | — | Target selection information at plate design, primary science selection (for backwards compatibility) | ✘ | ✔ |
programname | AUX | — | Program within each survey that the plate was part of | ✘ | ✔ |
rchi2 | AUX | — | Reduced chi-squared of best fit | ✘ | ✔ |
rchi2diff | AUX | — | Difference in reduced chi-squared between best and second best fit | ✘ | ✔ |
rchi2diff_noqso | AUX | — | Difference in reduced chi-squared between best and second best fit for Z_NOQSO redshift | ✘ | ✔ |
run1d | AUX | — | Spectroscopic 1D reduction (redshift and classification) name | ✘ | ✔ |
run2d | AUX | — | Spectroscopic 2D reduction (extraction of spectra) name | ✘ | ✔ |
sectarget | AUX | — | Deprecated version of secondary (calibration) target flags (meanings highly overloaded) | ✘ | ✔ |
segue1_target1 | AUX | — | Primary (science) target flags for SEGUE-1 targets | ✘ | ✔ |
segue1_target2 | AUX | — | Secondary (calibration) target flags for SEGUE-1 targets | ✘ | ✔ |
segue2_target1 | AUX | — | Primary (science) target flags for SEGUE-2 targets | ✘ | ✔ |
segue2_target2 | AUX | — | Secondary (calibration) target flags for SEGUE-2 targets | ✘ | ✔ |
sn_median | AUX | — | Median signal-to-noise per pixel within each of the ugriz bandpasses | ✘ | ✔ |
sn_median_all | AUX | — | Median signal-to-noise per pixel across full spectrum | ✘ | ✔ |
snturnoff | AUX | — | Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate) | ✘ | ✔ |
sourcetype | AUX | — | String expressing type of source (similar to OBJTYPE in DR8 and earlier) | ✘ | ✔ |
spec1_g | AUX | — | Signal-to-noise squared for spectrograph #1, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit used for classification and redshift | ✘ | ✔ |
sky | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Subtracted sky flux | ✘ | ✔ |
mask | SPECTRA | — | and_mask | ✘ | ✔ |
wave_sigma | SPECTRA | pixel | Line-spread function width (sigma of approximating Gaussian) in units of number of pixel | ✘ | ✔ |
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
chi2 | AUX | — | Best fit chi-squared | ✘ | ✔ |
bgs_target | AUX | — | BGS (Bright Galaxy Survey) target selection bitmask | ✘ | ✔ |
sv1_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV1 | ✘ | ✔ |
sv2_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV2 | ✘ | ✔ |
sv3_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV3 | ✘ | ✔ |
tsnr2_bgs | AUX | — | BGS template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
obsconditions | AUX | — | Bit-coded of allowed observing conditions | ✘ | ✔ |
coadd_fiberstatus | AUX | — | Bitwise AND of the FIBERSTATUS values of the spectra used in the coadd | ✘ | ✔ |
main_primary | AUX | — | Boolean flag (True/False) for the primary coadded spectrum in Main survey | ✘ | ✔ |
sv_primary | AUX | — | Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3) | ✘ | ✔ |
plate_dec | AUX | deg | Declination to be used by PlateMaker | ✘ | ✔ |
deltachi2 | AUX | — | Delta-chi-squared for template fit from Redrock | ✘ | ✔ |
desi_target | AUX | — | DESI (dark time program) target selection bitmask | ✘ | ✔ |
sv1_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV1 | ✘ | ✔ |
sv2_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV2 | ✘ | ✔ |
sv3_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV3 | ✘ | ✔ |
desiname | AUX | — | DESI JXXX.XXXX[+/-]YY.YYYY where X, Y are TARGET_{RA, DEC} truncated to 4 decimals | ✘ | ✔ |
program | AUX | — | DESI program type - BRIGHT, DARK, BACKUP, OTHER | ✘ | ✔ |
tsnr2_elg | AUX | — | ELG template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
fa_type | AUX | — | Fiberassign internal target type (science, standard, sky, safe, suppsky) | ✘ | ✔ |
tsnr2_gpbbackup | AUX | — | GPBBACKUP template (S/N)^2 summed over BRZ | ✘ | ✔ |
tsnr2_gpbbright | AUX | — | GPBBRIGHT template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
tsnr2_gpbdark | AUX | — | GPBDARK template (S/N)^2 summed over BRZ | ✘ | ✔ |
healpix | AUX | — | HEALPixel containing this location at NSIDE=64 in the NESTED scheme | ✘ | ✔ |
numobs_init | AUX | — | Initial number of observations for target calculated across target selection bitmasks and OBSCONDITIONS | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
mask | SPECTRA | — | Mask value | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
wave_sigma | SPECTRA | AA | Line-spread function width (sigma of approximating Gaussian) in units of Angstroms | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
spgrpval | AUX | — | Value corresponding to the grouping type indicated in the spgrp column. This is the same as the healpix column | ✘ | ✔ |
deltachi2 | AUX | — | Delta-chi-squared for template fit from Redrock | ✘ | ✔ |
mws_target | AUX | — | Milky Way Survey targeting bits | ✘ | ✔ |
tsnr2_gpbbright | AUX | — | GPBBRIGHT template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
rms_delta_y | AUX | mm | RMS (over exposures) of the fiber difference between measured and requested CS5 Y location on focal plane | ✘ | ✔ |
coeff | AUX | — | Redrock template coefficients | ✘ | ✔ |
sv2_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV2 | ✘ | ✔ |
coadd_fiberstatus | AUX | — | Bitwise AND of the FIBERSTATUS values of the spectra used in the coadd | ✘ | ✔ |
chi2 | AUX | — | Best fit chi-squared | ✘ | ✔ |
subtype | AUX | — | Spectral subtype | ✘ | ✔ |
cmx_target | AUX | — | Target selection bitmask for commissioning | ✘ | ✔ |
program | AUX | — | DESI program type - BRIGHT, DARK, BACKUP, OTHER | ✘ | ✔ |
mean_delta_x | AUX | mm | Mean (over exposures) fiber difference between measured and requested CS5 X location on focal plane | ✘ | ✔ |
coadd_numnight | AUX | — | Number of different nights included in the coadd for this target | ✘ | ✔ |
tsnr2_lrg | AUX | — | LRG template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
sv2_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV2 | ✘ | ✔ |
bgs_target | AUX | — | BGS (Bright Galaxy Survey) target selection bitmask | ✘ | ✔ |
fa_target | AUX | — | Targeting bit internally used by fiberassign (linked with FA_TYPE) | ✘ | ✔ |
numobs_init | AUX | — | Initial number of observations for target calculated across target selection bitmasks and OBSCONDITIONS | ✘ | ✔ |
rms_delta_x | AUX | mm | RMS (over exposures) of the fiber difference between measured and requested CS5 X location on focal plane | ✘ | ✔ |
sv3_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV3 | ✘ | ✔ |
sv1_scnd_target | AUX | — | Secondary target selection bitmask for SV1 | ✘ | ✔ |
coadd_numtile | AUX | — | Number of different tiles included in the coadd for this target | ✘ | ✔ |
sv3_scnd_target | AUX | — | Secondary target selection bitmask for SV3 | ✘ | ✔ |
objtype | AUX | — | Object type: TGT, SKY, NON, BAD | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
mask | SPECTRA | — | Mask value | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
wave_sigma | SPECTRA | AA | Line-spread function width (sigma of approximating Gaussian) in units of Angstroms | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
nturnoff | AUX | — | Number of stars used for SNTURNOFF determination | ✘ | ✔ |
objid | AUX | — | SDSS photometric object identification numbers (RUN, RERUN, CAMCOL, FIELD, ID) | ✘ | ✔ |
plate | AUX | — | Plate number (each plate corresponds to an actual plug plate) | ✘ | ✔ |
plateid | AUX | — | Unique database ID of plate based on PLATE, MJD, RUN2D (same as SkyServer version) | ✘ | ✔ |
platequality | AUX | — | Final quality of plate this spectrum came from (good, marginal, or bad) | ✘ | ✔ |
platerun | AUX | — | Drilling run that this plate was drilled in | ✘ | ✔ |
platesn2 | AUX | — | Overall signal-to-noise-squared measure for plate (only for SDSS spectrograph plates) | ✘ | ✔ |
primtarget | AUX | — | Target selection information at plate design, primary science selection (for backwards compatibility) | ✘ | ✔ |
programname | AUX | — | Program within each survey that the plate was part of | ✘ | ✔ |
rchi2 | AUX | — | Reduced chi-squared of best fit | ✘ | ✔ |
rchi2diff | AUX | — | Difference in reduced chi-squared between best and second best fit | ✘ | ✔ |
rchi2diff_noqso | AUX | — | Difference in reduced chi-squared between best and second best fit for Z_NOQSO redshift | ✘ | ✔ |
run1d | AUX | — | Spectroscopic 1D reduction (redshift and classification) name | ✘ | ✔ |
run2d | AUX | — | Spectroscopic 2D reduction (extraction of spectra) name | ✘ | ✔ |
sectarget | AUX | — | Deprecated version of secondary (calibration) target flags (meanings highly overloaded) | ✘ | ✔ |
segue1_target1 | AUX | — | Primary (science) target flags for SEGUE-1 targets | ✘ | ✔ |
segue1_target2 | AUX | — | Primary (science) target flags for SEGUE-1 targets | ✘ | ✔ |
segue2_target1 | AUX | — | Primary (science) target flags for SEGUE-2 targets | ✘ | ✔ |
segue2_target2 | AUX | — | Secondary (calibration) target flags for SEGUE-2 targets | ✘ | ✔ |
sn_median | AUX | — | Median signal-to-noise per pixel within each of the ugriz bandpasses | ✘ | ✔ |
sn_median_all | AUX | — | Median signal-to-noise per pixel across full spectrum | ✘ | ✔ |
snturnoff | AUX | — | Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate) | ✘ | ✔ |
sourcetype | AUX | — | String expressing type of source (similar to OBJTYPE in DR8 and earlier) | ✘ | ✔ |
spec1_g | AUX | — | Signal-to-noise squared for spectrograph #1, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra | ✘ | ✔ |
spec1_i | AUX | — | Signal-to-noise squared for spectrograph #1, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
mask | SPECTRA | — | and_mask | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit used for classification and redshift | ✘ | ✔ |
sky | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Subtracted sky flux | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
wave_sigma | SPECTRA | pixel | Line-spread function width (sigma of approximating Gaussian) in units of number of pixel | ✘ | ✔ |