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: SDSS-DR16, AUX fields

Name Storage Units Description Default All
boss_target1 AUX Primary (science) target flags for BOSS targets
elodie_dof AUX Degrees of freedom in fit to best ELODIE star
specsegue1 AUX Set to 1 for primary SDSS SEGUE-1 program observation of object, 0 otherwise
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
tile AUX Tile number (each tile can have several plates drilled for it)
eboss_target_id AUX EBOSS unique target identifier for every spectroscopic target
vdispchi2 AUX Chi-squared for best-fit velocity dispersion
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
elodie_feh AUX Metallicity [Fe/H] of ELODIE star
marvels_target2 AUX Secondary (calibration) target flags for MARVELS targets
class_person AUX Visual-inspection classification (0=not inspected or unknown, 1=star, 2=narrow emission-line galaxy, 3=QSO, 4=galaxy)
programname AUX Program within each survey that the plate was part of
vdispz_err AUX Error in redshift associated with best-fit velocity dispersion
run1d AUX Spectroscopic 1D reduction (redshift and classification) name
thing_id_targeting AUX Resolve THING_ID in SDSS imaging for targeted object
npoly AUX Number of polynomial terms in fit
snturnoff AUX Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate)
segue2_target2 AUX Secondary (calibration) target flags for SEGUE-2 targets
fluxobjid AUX Unique database ID of flux-based photometric match based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version)
z_conf_person AUX Visual-inspection confidence (0=not inspected or no confidence, 1,2=low confidence, 3,4=high confidence)
anyormask AUX For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK
elodie_logg AUX log10(gravity) of ELODIE star
plate AUX Plate number (each plate corresponds to an actual plug plate)
marvels_target1 AUX Primary (science) target flags for MARVELS targets
specboss AUX Set to 1 for primary BOSS spectrograph observation of object, 0 otherwise

Data Set: SDSS-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: 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: DESI-DR1, AUX fields

Name Storage Units Description Default All
zcat_nspec AUX Number of coadded spectra for this TARGETID in this zcatalog
tsnr2_qso AUX QSO template (S/N)^2 summed over B,R,Z
tsnr2_lya AUX LYA template (S/N)^2 summed over B,R,Z
tsnr2_lrg AUX LRG template (S/N)^2 summed over B,R,Z
tsnr2_gpbdark AUX GPBDARK template (S/N)^2 summed over BRZ
tsnr2_gpbbright AUX GPBBRIGHT template (S/N)^2 summed over B,R,Z
tsnr2_gpbbackup AUX GPBBACKUP template (S/N)^2 summed over BRZ
tsnr2_elg AUX ELG template (S/N)^2 summed over B,R,Z
tsnr2_bgs AUX BGS template (S/N)^2 summed over B,R,Z
sv_primary AUX Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3)
sv_nspec AUX Number of coadded spectra for this TARGETID in SV (SV1+2+3)
sv3_scnd_target AUX Secondary target selection bitmask for SV3
sv3_mws_target AUX MWS (bright time program) target selection bitmask for SV3
sv3_desi_target AUX DESI (dark time program) target selection bitmask for SV3
sv3_bgs_target AUX BGS (bright time program) target selection bitmask for SV3
sv2_scnd_target AUX Secondary target selection bitmask for SV2
sv2_mws_target AUX MWS (bright time program) target selection bitmask for SV2
sv2_desi_target AUX DESI (dark time program) target selection bitmask for SV2
sv2_bgs_target AUX BGS (bright time program) target selection bitmask for SV2
sv1_scnd_target AUX Secondary target selection bitmask for SV1
sv1_mws_target AUX MWS (bright time program) target selection bitmask for SV1
sv1_desi_target AUX DESI (dark time program) target selection bitmask for SV1
sv1_bgs_target AUX BGS (bright time program) target selection bitmask for SV1
survey AUX Survey name
subtype AUX Spectral subtype

Data Set: DESI-DR1, 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

Data Set: DESI-EDR, AUX fields

Name Storage Units Description Default All
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

Data Set: DESI-EDR, SPECTRA fields

Name Storage Units Description Default All
model SPECTRA 1e-17 erg cm-2 s-1 AA-1 Pipeline best model fit
flux SPECTRA 1e-17 erg cm-2 s-1 AA-1 Coadded calibrated flux
wavelength SPECTRA AA Wavelength in units of Angstroms
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

Data Set: SDSS-DR17-test, AUX fields

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

Data Set: SDSS-DR17-test, 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
SPARCL Field Cat(alog)