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 |
---|---|---|---|---|---|
cx | AUX | — | x of Normal unit vector in J2000 | ✘ | ✔ |
theta | AUX | — | Template coefficients of best fit | ✘ | ✔ |
zwarning_noqso | AUX | — | Warnings in z_noqso redshift (BOSS spectra only) | ✘ | ✔ |
primtarget | AUX | — | Target selection information at plate design, primary science selection (for backwards compatibility) | ✘ | ✔ |
cz | AUX | — | z of Normal unit vector in J2000 | ✘ | ✔ |
survey | AUX | — | Survey name | ✘ | ✔ |
special_target2 | AUX | — | Secondary (calibration) target flags for SDSS-I and SDSS-II special program targets | ✘ | ✔ |
eboss_target_id | AUX | — | EBOSS unique target identifier for every spectroscopic target | ✘ | ✔ |
thing_id | AUX | — | Resolve THING_ID in SDSS imaging for best positional match | ✘ | ✔ |
run1d | AUX | — | Spectroscopic 1D reduction (redshift and classification) 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) | ✘ | ✔ |
legacy_target2 | AUX | — | Secondary (calibration) target flags for SDSS-I and SDSS-II Legacy survey | ✘ | ✔ |
spectrographid | AUX | — | Which spectrograph (1 or 2) | ✘ | ✔ |
vdispz_err | AUX | — | Error in redshift associated with best-fit velocity dispersion | ✘ | ✔ |
eboss_target1 | AUX | — | eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey | ✘ | ✔ |
chi68p | AUX | — | 68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit) | ✘ | ✔ |
segue2_target1 | AUX | — | Primary (science) target flags for SEGUE-2 targets | ✘ | ✔ |
firstrelease | AUX | — | Name of first release this PLATE, MJD, FIBERID, RUN2D was associated with | ✘ | ✔ |
eboss_target0 | AUX | — | SEQUELS, TDSS and SPIDERS target selection flags | ✘ | ✔ |
fiberid | AUX | — | Fiber number | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
sky | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Subtracted sky flux | ✘ | ✔ |
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit used for classification and redshift | ✘ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of 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 | ✘ | ✔ |
mask | SPECTRA | — | and_mask | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
ancillary_target1 | AUX | — | BOSS ancillary science target selection information at plate design | ✘ | ✔ |
ancillary_target2 | AUX | — | BOSS ancillary target selection information at plate design | ✘ | ✔ |
anyandmask | AUX | — | For each bit, records whether any pixel in the spectrum has that bit set in its ANDMASK | ✘ | ✔ |
anyormask | AUX | — | For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK | ✘ | ✔ |
bluefiber | AUX | — | Set to 1 if this was requested to be a blue fiber target, 0 if it was a red fiber (in BOSS high redshift LRGs are requested to be on red fibers) | ✘ | ✔ |
boss_specobj_id | AUX | — | Identification number internal to BOSS for SPECBOSS=1 objects | ✘ | ✔ |
boss_target1 | AUX | — | Primary (science) target flags for BOSS targets | ✘ | ✔ |
boss_target2 | AUX | — | Always set to zero (placeholder for BOSS target flags never used) | ✘ | ✔ |
calibflux | AUX | nanomaggy | ugriz fluxes used for calibrations | ✘ | ✔ |
calibflux_ivar | AUX | nanomaggy-2 | Inverse variances of ugriz fluxes used for calibrations | ✘ | ✔ |
chi68p | AUX | — | 68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit) | ✘ | ✔ |
chunk | AUX | — | Name of tiling chunk that this spectrum was tiled in (boss1, boss2, etc), important for tracking large-scale structure samples | ✘ | ✔ |
class_noqso | AUX | — | Spectroscopic classification for Z_NOQSO redshift | ✘ | ✔ |
class_person | AUX | — | Visual-inspection classification (0=not inspected or unknown, 1=star, 2=narrow emission-line galaxy, 3=QSO, 4=galaxy) | ✘ | ✔ |
comments_person | AUX | — | Visual-inspection comments | ✘ | ✔ |
cx | AUX | — | x of Normal unit vector in J2000 | ✘ | ✔ |
cy | AUX | — | y of Normal unit vector in J2000 | ✘ | ✔ |
cz | AUX | — | z of Normal unit vector in J2000 | ✘ | ✔ |
deredsn2 | AUX | — | Dereddened overall signal-to-noise-squared measure for plate (only for BOSS spectrograph plates) | ✘ | ✔ |
designid | AUX | — | Design identification number for plate | ✘ | ✔ |
dof | AUX | — | Number of degrees of freedom in best fit | ✘ | ✔ |
eboss_target0 | AUX | — | SEQUELS, TDSS and SPIDERS target selection flags | ✘ | ✔ |
eboss_target1 | AUX | — | eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey | ✘ | ✔ |
eboss_target2 | AUX | — | eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey | ✘ | ✔ |
eboss_target_id | AUX | — | EBOSS unique target identifier for every spectroscopic target | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
wave_sigma | SPECTRA | pixel | Line-spread function width (sigma of approximating Gaussian) in units of number of pixel | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
sky | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Subtracted sky flux | ✘ | ✔ |
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit used for classification and redshift | ✘ | ✔ |
mask | SPECTRA | — | and_mask | ✘ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
sv2_mws_target | AUX | — | MWS (bright time program) target selection bitmask for SV2 | ✘ | ✔ |
sv2_scnd_target | AUX | — | Secondary target selection bitmask for SV2 | ✘ | ✔ |
sv3_bgs_target | AUX | — | BGS (bright time program) target selection bitmask for SV3 | ✘ | ✔ |
sv3_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV3 | ✘ | ✔ |
sv3_mws_target | AUX | — | MWS (bright time program) target selection bitmask for SV3 | ✘ | ✔ |
sv3_scnd_target | AUX | — | Secondary target selection bitmask for SV3 | ✘ | ✔ |
sv_nspec | AUX | — | Number of coadded spectra for this TARGETID in SV (SV1+2+3) | ✘ | ✔ |
sv_primary | AUX | — | Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3) | ✘ | ✔ |
tsnr2_bgs | AUX | — | BGS template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
tsnr2_elg | AUX | — | ELG template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
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 | ✘ | ✔ |
tsnr2_lrg | AUX | — | LRG template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
tsnr2_lya | AUX | — | LYA template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
tsnr2_qso | AUX | — | QSO template (S/N)^2 summed over B,R,Z | ✘ | ✔ |
zcat_nspec | AUX | — | Number of coadded spectra for this TARGETID in this zcatalog | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit | ✘ | ✔ |
mask | SPECTRA | — | Mask value | ✘ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
wave_sigma | SPECTRA | AA | Line-spread function width (sigma of approximating Gaussian) in units of Angstroms | ✘ | ✔ |
wavelength | SPECTRA | AA | Wavelength in units of Angstroms | ✔ | ✔ |
flux | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Coadded calibrated flux | ✔ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
tsnr2_gpbdark | AUX | — | GPBDARK template (S/N)^2 summed over BRZ | ✘ | ✔ |
sv_primary | AUX | — | Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3) | ✘ | ✔ |
sv3_desi_target | AUX | — | DESI (dark time program) target selection bitmask for SV3 | ✘ | ✔ |
tsnr2_gpbbackup | AUX | — | GPBBACKUP template (S/N)^2 summed over BRZ | ✘ | ✔ |
survey | AUX | — | Survey name | ✘ | ✔ |
sv3_mws_target | AUX | — | MWS (bright time program) target selection bitmask for SV3 | ✘ | ✔ |
zcat_nspec | AUX | — | Number of coadded spectra for this TARGETID in this zcatalog | ✘ | ✔ |
desi_target | AUX | — | DESI (dark time program) target selection bitmask | ✘ | ✔ |
ncoeff | AUX | — | Number of Redrock template coefficients | ✘ | ✔ |
npixels | AUX | — | Number of unmasked wavelengths that contributed to the redshift fit | ✘ | ✔ |
mean_delta_y | AUX | mm | Mean (over exposures) fiber difference requested - actual CS5 Y location on focal plane | ✘ | ✔ |
mean_fiber_ra | AUX | deg | Mean (over exposures) RA of actual fiber position | ✘ | ✔ |
lastnight | AUX | — | Last calendar date of the exposures used in the coadded spectrum as YYYYMMDD of the beginning of the observing night | ✘ | ✔ |
mean_fiber_dec | AUX | deg | Mean (over exposures) DEC of actual fiber position | ✘ | ✔ |
firstnight | AUX | — | First calendar date of the exposures used in the coadded spectrum as YYYYMMDD of the beginning of the observing night | ✘ | ✔ |
mean_mjd | AUX | days | Mean (over exposures) of the Modified Julian Date (MJD) when the shutter was opened | ✘ | ✔ |
Name | Storage | Units | Description | Default | All |
---|---|---|---|---|---|
model | SPECTRA | 1e-17 erg cm-2 s-1 AA-1 | Pipeline best model fit | ✘ | ✔ |
mask | SPECTRA | — | Mask value | ✘ | ✔ |
ivar | SPECTRA | 1e+34 cm4 s2 AA2 erg-2 | Inverse variance of flux | ✘ | ✔ |
wave_sigma | SPECTRA | AA | Line-spread function width (sigma of approximating Gaussian) in units of Angstroms | ✘ | ✔ |
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 |
---|---|---|---|---|---|
ancillary_target1 | AUX | — | BOSS ancillary science target selection information at plate design | ✘ | ✔ |
ancillary_target2 | AUX | — | BOSS ancillary target selection information at plate design | ✘ | ✔ |
anyandmask | AUX | — | For each bit, records whether any pixel in the spectrum has that bit set in its ANDMASK | ✘ | ✔ |
anyormask | AUX | — | For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK | ✘ | ✔ |
bluefiber | AUX | — | Set to 1 if this hole was designated a blue fiber, 0 if designated a red fiber (high redshift LRGs are preferentially in red fibers) | ✘ | ✔ |
boss_specobj_id | AUX | — | Identification number internal to BOSS for SPECBOSS=1 objects | ✘ | ✔ |
boss_target1 | AUX | — | Primary (science) target flags for BOSS targets | ✘ | ✔ |
boss_target2 | AUX | — | Always set to zero (placeholder for BOSS target flags never used) | ✘ | ✔ |
calibflux | AUX | nanomaggy | ugriz fluxes used for calibrations | ✘ | ✔ |
calibflux_ivar | AUX | nanomaggy-2 | Inverse variances of ugriz fluxes used for calibrations | ✘ | ✔ |
chi68p | AUX | — | 68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit) | ✘ | ✔ |
chunk | AUX | — | Name of tiling chunk that this spectrum was tiled in (boss1, boss2, etc), important for tracking large-scale structure samples | ✘ | ✔ |
class_noqso | AUX | — | Spectroscopic classification for Z_NOQSO redshift | ✘ | ✔ |
class_person | AUX | — | Visual-inspection classification (0=not inspected or unknown, 1=star, 2=narrow emission-line galaxy, 3=QSO, 4=galaxy) | ✘ | ✔ |
comments_person | AUX | — | Visual-inspection comments | ✘ | ✔ |
cx | AUX | — | x of Normal unit vector in J2000 | ✘ | ✔ |
cy | AUX | — | y of Normal unit vector in J2000 | ✘ | ✔ |
cz | AUX | — | z of Normal unit vector in J2000 | ✘ | ✔ |
deredsn2 | AUX | — | Dereddened overall signal-to-noise-squared measure for plate (only for BOSS spectrograph plates) | ✘ | ✔ |
designid | AUX | — | Design identification number for plate | ✘ | ✔ |
dof | AUX | — | Number of degrees of freedom in best fit | ✘ | ✔ |
eboss_target1 | AUX | — | eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey | ✘ | ✔ |
eboss_target2 | AUX | — | eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey | ✘ | ✔ |
eboss_target_id | AUX | — | EBOSS unique target identifier for every spectroscopic target | ✘ | ✔ |
elodie_bv | AUX | mag | (B-V) color index for ELODIE star | ✘ | ✔ |
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 | ✘ | ✔ |