SPARCL - SPARCL Field Catalog (SFC)

SPARCL Field Catalog

List of Fields available via Retrieve

CORE fields (common to all Data Sets)

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
Download .csv Download .json

AUX and SPECTRA fields (unique to each Data Set)

Data Set: BOSS-DR16, AUX fields

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

Data Set: BOSS-DR16, SPECTRA fields

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

Data Set: SDSS-DR16, AUX fields

Name Storage Units Description Default All
tfile AUX File that best fit template comes from in idlspec2d product
theta AUX Template coefficients of best fit
thing_id AUX Resolve THING_ID in SDSS imaging for best positional match
thing_id_targeting AUX Resolve THING_ID in SDSS imaging for targeted object
tile AUX Tile number (each tile can have several plates drilled for it)
vdisp AUX km s-1 Velocity dispersion
vdispchi2 AUX Chi-squared for best-fit velocity dispersion
vdispdof AUX Number of degrees of freedom in velocity dispersion fit
vdisp_err AUX km s-1 Error in velocity dispersion
vdispnpix AUX Number of pixels overlapping the templates used in the velocity dispersion fit
vdispz AUX Redshift associated with best-fit velocity dispersion
vdispz_err AUX Error in redshift associated with best-fit velocity dispersion
wcoverage AUX Coverage in wavelength, in units of log10 wavelength
xfocal AUX mm Hole position on plate (+X = +RA)
yfocal AUX mm Hole position on plate (+Y = +DEC)
z_conf_person AUX Visual-inspection confidence (0=not inspected or no confidence, 1,2=low confidence, 3,4=high confidence)
z_err_noqso AUX Error in Z_NOQSO redshift
z_noqso AUX 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
zoffset AUX micron Washer thickness used for backstopping BOSS quasar targets, so they are closer to 4000 Angstrom focal plan
z_person AUX Visual-inspection redshift
zwarning_noqso AUX Warnings in z_noqso redshift (BOSS spectra only)

Data Set: SDSS-DR16, SPECTRA fields

Name Storage Units Description Default All
wave_sigma SPECTRA pixel Line-spread function width (sigma of approximating Gaussian) in units of number of pixel
sky SPECTRA 1e-17 erg cm-2 s-1 AA-1 Subtracted sky 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
flux SPECTRA 1e-17 erg cm-2 s-1 AA-1 Coadded calibrated flux
wavelength SPECTRA AA Wavelength in units of Angstroms

Data Set: SDSS-DR17, AUX fields

Name Storage Units Description Default All
elodie_bv AUX mag (B-V) color index for ELODIE star
elodie_dof AUX Degrees of freedom in fit to best ELODIE star
elodie_feh AUX Metallicity [Fe/H] of ELODIE star
elodie_filename AUX File name for best-fit ELODIE star
elodie_logg AUX log10(gravity) of ELODIE star
elodie_object AUX Star name for ELODIE star
elodie_rchi2 AUX Reduced chi-squared of fit to best ELODIE star
elodie_sptype AUX ELODIE star spectral type
elodie_teff AUX Kelvin Effective temperature of ELODIE star
elodie_z AUX Redshift fit to ELODIE star
elodie_z_err AUX Error in redshift fit to ELODIE star
elodie_z_modelerr AUX Standard deviation in redshift among the 12 best-fit ELODIE stars
fiberid AUX Fiber number
firstrelease AUX Name of first release this PLATE, MJD, FIBERID, RUN2D was associated with
fluxobjid AUX Unique database ID of flux-based photometric match based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version)
fracnsighi AUX Fraction of pixels high by more than N sigma relative to best-fit (for 1,2,..,10 sigma)
fracnsiglo AUX Fraction of pixels low by more than N sigma relative to best-fit (for 1,2,..,10 sigma)
fracnsigma AUX Fraction of pixels deviant by more than N sigma relative to best-fit (for 1,2,..,10 sigma)
lambda_eff AUX AA Effective wavelength drilling position was optimized for
legacy_target1 AUX Primary (science) target flags for SDSS-I and SDSS-II Legacy survey
legacy_target2 AUX Secondary (calibration) target flags for SDSS-I and SDSS-II Legacy survey
marvels_target1 AUX Primary (science) target flags for MARVELS targets
marvels_target2 AUX Secondary (calibration) target flags for MARVELS targets
mjd AUX days Modified Julian Day of observation
npoly AUX Number of polynomial terms in fit

Data Set: SDSS-DR17, SPECTRA fields

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

Data Set: DESI-EDR, AUX fields

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

Data Set: DESI-EDR, SPECTRA fields

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
SPARCL Field Cat(alog)