Storage |
Field |
Units |
Description |
Default |
All |
A |
cz |
|
z of Normal unit vector in J2000 |
False |
True |
A |
special_target2 |
|
Secondary (calibration) target flags for SDSS-I and SDSS-II special program targets |
False |
True |
A |
eboss_target_id |
|
EBOSS unique target identifier for every spectroscopic target |
False |
True |
A |
thing_id |
|
Resolve THING_ID in SDSS imaging for best positional match |
False |
True |
A |
run1d |
|
Spectroscopic 1D reduction (redshift and classification) name |
False |
True |
A |
targetobjid |
|
Unique database ID of targeting object based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version) |
False |
True |
A |
targettype |
|
General type of target (SCIENCE, STANDARD, or SKY) |
False |
True |
A |
legacy_target2 |
|
Secondary (calibration) target flags for SDSS-I and SDSS-II Legacy survey |
False |
True |
A |
spectrographid |
|
Which spectrograph (1 or 2) |
False |
True |
A |
vdispz_err |
|
Error in redshift associated with best-fit velocity dispersion |
False |
True |
A |
zoffset |
microns |
Washer thickness used (for backstopping BOSS quasar targets, so they are closer to 4000 Angstrom focal plan |
False |
True |
A |
eboss_target1 |
|
eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey |
False |
True |
A |
chi68p |
|
68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit) |
False |
True |
A |
segue2_target1 |
|
Primary (science) target flags for SEGUE-2 targets |
False |
True |
A |
firstrelease |
|
Name of first release this PLATE, MJD, FIBERID, RUN2D was associated with |
False |
True |
A |
eboss_target0 |
|
SEQUELS, TDSS and SPIDERS target selection flags |
False |
True |
A |
fiberid |
|
Fiber number |
False |
True |
A |
specboss |
|
Set to 1 for primary BOSS spectrograph observation of object, 0 otherwise |
False |
True |
A |
z_conf_person |
|
Visual-inspection confidence (0=not inspected or no confidence, 1,2=low confidence, 3,4=high confidence) |
False |
True |
A |
programname |
|
Program within each survey that the plate was part of |
False |
True |
A |
marvels_target2 |
|
Secondary (calibration) target flags for MARVELS targets |
False |
True |
A |
yfocal |
mm |
Hole position on plate (+Y = +DEC) |
False |
True |
A |
elodie_feh |
|
Metallicity [Fe/H] of ELODIE star |
False |
True |
A |
segue1_target1 |
|
Primary (science) target flags for SEGUE-1 targets |
False |
True |
A |
elodie_z_modelerr |
|
Standard deviation in redshift among the 12 best-fit ELODIE stars |
False |
True |
A |
specsegue |
|
Set to 1 for primary SDSS SEGUE program observation of object (including SEGUE-1 and SEGUE-2), 0 otherwise |
False |
True |
A |
boss_target1 |
|
Primary (science) target flags for BOSS targets |
False |
True |
A |
elodie_dof |
|
Degrees of freedom in fit to best ELODIE star |
False |
True |
A |
specsegue1 |
|
Set to 1 for primary SDSS SEGUE-1 program observation of object, 0 otherwise |
False |
True |
A |
spec2_i |
|
Signal-to-noise squared for spectrograph #2, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra |
False |
True |
A |
tile |
|
Tile number (each tile can have several plates drilled for it) |
False |
True |
A |
rchi2diff_noqso |
|
Difference in reduced chi-squared between best and second best fit for Z_NOQSO redshift |
False |
True |
A |
boss_target2 |
|
Always set to zero (placeholder for BOSS target flags never used) |
False |
True |
A |
class_noqso |
|
Spectroscopic classification for Z_NOQSO redshift |
False |
True |
A |
rchi2diff |
|
Difference in reduced chi-squared between best and second best fit |
False |
True |
A |
elodie_logg |
|
log10(gravity) of ELODIE star |
False |
True |
A |
elodie_bv |
mag |
(B-V) color index for ELODIE star |
False |
True |
A |
segue2_target2 |
|
Secondary (calibration) target flags for SEGUE-2 targets |
False |
True |
A |
snturnoff |
|
Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate) |
False |
True |
A |
class_person |
|
Visual-inspection classification (0=not inspected or unknown, 1=star, 2=narrow emission-line galaxy, 3=QSO, 4=galaxy) |
False |
True |
A |
thing_id_targeting |
|
Resolve THING_ID in SDSS imaging for targeted object |
False |
True |
A |
npoly |
|
Number of polynomial terms in fit |
False |
True |
A |
elodie_teff |
Kelvin |
Effective temperature of ELODIE star |
False |
True |
A |
spec2_g |
|
Signal-to-noise squared for spectrograph #2, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra |
False |
True |
A |
fluxobjid |
|
Unique database ID of flux-based photometric match based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version) |
False |
True |
A |
vdispchi2 |
|
Chi-squared for best-fit velocity dispersion |
False |
True |
A |
anyormask |
|
For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK |
False |
True |
A |
spectroflux_ivar |
nanomaggies^-2 |
Inverse variance of spectrum projected onto ugriz filters |
False |
True |
A |
plate |
|
Plate number (each plate corresponds to an actual plug plate) |
False |
True |
A |
marvels_target1 |
|
Primary (science) target flags for MARVELS targets |
False |
True |
A |
boss_specobj_id |
|
Identification number internal to BOSS for SPECBOSS=1 objects |
False |
True |
A |
special_target1 |
|
Primary (science) target flags for SDSS-I and SDSS-II special program targets |
False |
True |
A |
objid |
|
SDSS photometric object identification numbers (RUN, RERUN, CAMCOL, FIELD, ID) |
False |
True |
A |
dof |
|
Number of degrees of freedom in best fit |
False |
True |
A |
calibflux |
nanomaggies |
ugriz fluxes used for calibrations |
False |
True |
A |
lambda_eff |
Angstroms |
Effective wavelength drilling position was optimized for |
False |
True |
A |
vdispnpix |
|
Number of pixels overlapping the templates used in the velocity dispersion fit |
False |
True |
A |
z_person |
|
Visual-inspection redshift |
False |
True |
A |
spectroflux |
nanomaggies |
Spectrum projected onto ugriz filters |
False |
True |
A |
xfocal |
mm |
Hole position on plate (+X = +RA) |
False |
True |
A |
fracnsiglo |
|
Fraction of pixels low by more than N sigma relative to best-fit (for 1,2,..,10 sigma) |
False |
True |
A |
sn_median |
|
Median signal-to-noise per pixel within each of the ugriz bandpasses |
False |
True |
A |
anyandmask |
|
For each bit, records whether any pixel in the spectrum has that bit set in its ANDMASK |
False |
True |
A |
spec1_r |
|
Signal-to-noise squared for spectrograph #1, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra |
False |
True |
A |
elodie_object |
|
Star name for ELODIE star |
False |
True |
A |
segue1_target2 |
|
Primary (science) target flags for SEGUE-1 targets |
False |
True |
A |
speclegacy |
|
Set to 1 for primary SDSS Legacy program observation of object, 0 otherwise |
False |
True |
A |
spectrosynflux_ivar |
nanomaggies^-2 |
Inverse variance of best-fit template spectrum projected onto ugriz filters |
False |
True |
A |
legacy_target1 |
|
Primary (science) target flags for SDSS-I and SDSS-II Legacy survey |
False |
True |
A |
designid |
|
Design identification number for plate |
False |
True |
A |
ancillary_target2 |
|
BOSS ancillary target selection information at plate design |
False |
True |
A |
elodie_rchi2 |
|
Reduced chi-squared of fit to best ELODIE star |
False |
True |
A |
eboss_target2 |
|
eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey |
False |
True |
A |
platequality |
|
Final quality of plate this spectrum came from (good, marginal, or bad) |
False |
True |
A |
platesn2 |
|
Overall signal-to-noise-squared measure for plate (only for SDSS spectrograph plates) |
False |
True |
A |
spec1_i |
|
Signal-to-noise squared for spectrograph #1, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra |
False |
True |
A |
comments_person |
|
Visual-inspection comments |
False |
True |
A |
tcolumn |
|
Columns of template files that correspond to each template |
False |
True |
A |
z_err_noqso |
|
Error in Z_NOQSO redshift |
False |
True |
A |
platerun |
|
Drilling run that this plate was drilled in |
False |
True |
A |
run2d |
|
Spectroscopic 2D reduction (extraction of spectra) name |
False |
True |
A |
subclass |
|
Best spectroscopic subclassification |
False |
True |
A |
plateid |
|
Unique database ID of plate based on PLATE, MJD, RUN2D (same as SkyServer version) |
False |
True |
A |
vdispz |
|
Redshift associated with best-fit velocity dispersion |
False |
True |
A |
mjd |
|
Modified Julian Day of observation |
False |
True |
A |
tfile |
|
File that best fit template comes from in idlspec2d product |
False |
True |
A |
spec1_g |
|
Signal-to-noise squared for spectrograph #1, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra |
False |
True |
A |
cy |
|
y of Normal unit vector in J2000 |
False |
True |
A |
sn_median_all |
|
Median signal-to-noise per pixel across full spectrum |
False |
True |
A |
vdispdof |
|
Number of degrees of freedom in velocity dispersion fit |
False |
True |
A |
nspecobs |
|
Number of spectroscopic observations of this source |
False |
True |
A |
bluefiber |
|
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) |
False |
True |
A |
sourcetype |
|
String expressing type of source (similar to OBJTYPE in DR8 and earlier) |
False |
True |
A |
spec2_r |
|
Signal-to-noise squared for spectrograph #2, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra |
False |
True |
A |
elodie_z_err |
|
Error in redshift fit to ELODIE star |
False |
True |
A |
ancillary_target1 |
|
BOSS ancillary science target selection information at plate design |
False |
True |
A |
specsdss |
|
Set to 1 for primary SDSS spectrograph observation of object, 0 otherwise |
False |
True |
A |
wcoverage |
|
Coverage in wavelength, in units of log10 wavelength |
False |
True |
A |
spectrosynflux |
nanomaggies |
Best-fit template spectrum projected onto ugriz filters |
False |
True |
A |
rchi2 |
|
Reduced chi-squared of best fit |
False |
True |
A |
elodie_filename |
|
File name for best-fit ELODIE star |
False |
True |
A |
vdisp |
km/s |
Velocity dispersion |
False |
True |
A |
fracnsighi |
|
Fraction of pixels high by more than N sigma relative to best-fit (for 1,2,..,10 sigma) |
False |
True |
A |
z_noqso |
|
Best redshift when ignoring QSO fits, recommended for BOSS CMASS and LOWZ targets; calculated only for survey=boss spectra, not for any SDSS spectrograph data |
False |
True |
A |
deredsn2 |
|
Dereddened overall signal-to-noise-squared measure for plate (only for BOSS spectrograph plates) |
False |
True |
A |
elodie_z |
|
Redshift fit to ELODIE star |
False |
True |
A |
vdisp_err |
km/s |
Error in velocity dispersion |
False |
True |
A |
elodie_sptype |
|
ELODIE star spectral type |
False |
True |
A |
sectarget |
|
Deprecated version of secondary (calibration) target flags (meanings highly overloaded) |
False |
True |
A |
specsegue2 |
|
Set to 1 for primary SDSS SEGUE-2 program observation of object, 0 otherwise |
False |
True |
A |
subclass_noqso |
|
Spectroscopic subclassification for Z_NOQSO redshift |
False |
True |
A |
calibflux_ivar |
nanomaggies^-2 |
Inverse variances of ugriz fluxes used for calibrations |
False |
True |
A |
nturnoff |
|
Number of stars used for SNTURNOFF determination |
False |
True |
A |
fracnsigma |
|
Fraction of pixels deviant by more than N sigma relative to best-fit (for 1,2,..,10 sigma) |
False |
True |
A |
spectroskyflux |
nanomaggies |
Sky flux in each of the ugriz imaging filters |
False |
True |
A |
chunk |
|
Name of tiling chunk that this spectrum was tiled in (boss1, boss2, etc), important for tracking large-scale structure samples |
False |
True |
A |
cx |
|
x of Normal unit vector in J2000 |
False |
True |
A |
theta |
|
Template coefficients of best fit |
False |
True |
A |
zwarning_noqso |
|
Warnings in z_noqso redshift (BOSS spectra only) |
False |
True |
A |
primtarget |
|
Target selection information at plate design, primary science selection (for backwards compatibility) |
False |
True |
A |
survey |
|
Survey name |
False |
True |
C |
ra |
deg |
Right Ascension in degrees |
True |
True |
C |
dateobs |
|
Range of observational dates for a given spectrum (single value for a single date) |
False |
True |
C |
redshift_warning |
|
Bitmask with warning on redshift result |
False |
True |
C |
dateobs_center |
|
Central value of the dateobs range |
False |
True |
C |
updated |
|
Date and time when the record was created/updated |
False |
False |
C |
site |
|
Site of observations |
False |
True |
C |
datasetgroup |
|
Common name for a coherent set of spectra published as a single release (e.g., SDSS_BOSS-DR16) |
False |
True |
C |
specid |
|
Dataset-specific spectrum identifier (may not be unique) |
True |
True |
C |
instrument |
|
Instrument used for observation |
False |
True |
C |
redshift |
|
Measured redshift, or radial velocity in units of redshift |
False |
True |
C |
filename |
|
Basename of ingested file. Prepend with "dirpath" for full absolute path |
False |
False |
C |
targetid |
|
Dataset-specific photometric target identifier |
False |
True |
C |
specprimary |
|
Whether an entry is the primary spectrum for a given target object |
False |
True |
C |
dirpath |
|
Full path of ingested file directory (mostly for internal use) |
False |
False |
C |
data_release |
|
Data release of a given record (with a common data structure, e.g., SDSS-DR16, BOSS-DR16) |
False |
True |
C |
wavemin |
Å |
Minimum value of wavelength coverage in Angstroms |
False |
True |
C |
spectype |
|
Spectral type of the object (STAR, GALAXY, QSO) |
False |
True |
C |
filesize |
bytes |
Size of the file |
False |
False |
C |
dec |
deg |
Declination in degrees |
True |
True |
C |
telescope |
|
Telescope used for the observation |
False |
True |
C |
redshift_err |
|
Uncertainty on the measured redshift, or radial velocity in units of redshift |
False |
True |
C |
wavemax |
Å |
Maximum value of wavelength coverage in Angstroms |
False |
True |
C |
sparcl_id |
|
Universally Unique Identifier for spectrum in SPARCL |
True |
True |
C |
extra_files |
|
Additional files read for ingest |
False |
False |
C |
exptime |
sec |
Exposure time in seconds |
False |
True |
S |
model |
10^-17 ergs/s/cm^2/Å |
Pipeline best model fit used for classification and redshift |
False |
True |
S |
sky |
10^-17 ergs/s/cm^2/Å |
Subtracted sky flux |
False |
True |
S |
flux |
10^-17 ergs/s/cm^2/Å |
Coadded calibrated flux |
True |
True |
S |
wave_sigma |
pixels |
Line-spread function width (sigma of approximating Gaussian) in units of number of pixel |
False |
True |
S |
ivar |
flux^-2 |
Inverse variance of flux |
False |
True |
S |
wavelength |
Å |
Wavelength in units of Angstroms |
True |
True |
S |
mask |
|
and_mask |
False |
True |