SPARCL - Field Names

Field Names

(SDSS-DR17-test)

Sort by clicking on a column header.

Storage Field name Units Description Default All Provenance field name File HDU
A cz None z of Normal unit vector in J2000 False True CZ specObj-dr17 1
A elodie_z None Redshift fit to ELODIE star False True ELODIE_Z specObj-dr17 1
A specsegue None Set to 1 for primary SDSS SEGUE program observation of object (including SEGUE-1 and SEGUE-2), 0 otherwise False True SPECSEGUE specObj-dr17 1
A anyandmask None For each bit, records whether any pixel in the spectrum has that bit set in its ANDMASK False True ANYANDMASK specObj-dr17 1
A elodie_rchi2 None Reduced chi-squared of fit to best ELODIE star False True ELODIE_RCHI2 specObj-dr17 1
A nturnoff None Number of stars used for SNTURNOFF determination False True NTURNOFF specObj-dr17 1
A vdispdof None Number of degrees of freedom in velocity dispersion fit False True VDISPDOF specObj-dr17 1
A specsegue1 None Set to 1 for primary SDSS SEGUE-1 program observation of object, 0 otherwise False True SPECSEGUE1 specObj-dr17 1
A elodie_z_err None Error in redshift fit to ELODIE star False True ELODIE_Z_ERR specObj-dr17 1
A lambda_eff AA Effective wavelength drilling position was optimized for False True LAMBDA_EFF specObj-dr17 1
A eboss_target1 None eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey False True EBOSS_TARGET1 specObj-dr17 1
A snturnoff None Signal to noise measure for MS turnoff stars on plate (-9999 if not appropriate) False True SNTURNOFF specObj-dr17 1
A spec1_i None Signal-to-noise squared for spectrograph #1, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra False True SPEC1_I specObj-dr17 1
A specsegue2 None Set to 1 for primary SDSS SEGUE-2 program observation of object, 0 otherwise False True SPECSEGUE2 specObj-dr17 1
A spectrographid None Which spectrograph (1 or 2) False True SPECTROGRAPHID specObj-dr17 1
A objid None SDSS photometric object identification numbers (RUN, RERUN, CAMCOL, FIELD, ID) False True OBJID specObj-dr17 1
A z_conf_person None Visual-inspection confidence (0=not inspected or no confidence, 1,2=low confidence, 3,4=high confidence) False True Z_CONF_PERSON specObj-dr17 1
A z_person None Visual-inspection redshift False True Z_PERSON specObj-dr17 1
A elodie_feh None Metallicity [Fe/H] of ELODIE star False True ELODIE_FEH specObj-dr17 1
A spectrosynflux nanomaggy Best-fit template spectrum projected onto ugriz filters False True SPECTROSYNFLUX specObj-dr17 1
A spec2_r None Signal-to-noise squared for spectrograph #2, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra False True SPEC2_R specObj-dr17 1
A sourcetype None String expressing type of source (similar to OBJTYPE in DR8 and earlier) False True SOURCETYPE specObj-dr17 1
A plate None Plate number (each plate corresponds to an actual plug plate) False True PLATE specObj-dr17 1
A chi68p None 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 CHI68P specObj-dr17 1
A fluxobjid None Unique database ID of flux-based photometric match based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version) False True FLUXOBJID specObj-dr17 1
A spec2_i None Signal-to-noise squared for spectrograph #2, at i=19.90 for SDSS spectrograph spectra, i=20.20 for BOSS spectrograph spectra False True SPEC2_I specObj-dr17 1
A eboss_target_id None EBOSS unique target identifier for every spectroscopic target False True EBOSS_TARGET_ID specObj-dr17 1
A segue2_target2 None Secondary (calibration) target flags for SEGUE-2 targets False True SEGUE2_TARGET2 specObj-dr17 1
A fracnsighi None Fraction of pixels high by more than N sigma relative to best-fit (for 1,2,..,10 sigma) False True FRACNSIGHI specObj-dr17 1
A elodie_logg None log10(gravity) of ELODIE star False True ELODIE_LOGG specObj-dr17 1
A theta None Template coefficients of best fit False True THETA specObj-dr17 1
A firstrelease None Name of first release this PLATE, MJD, FIBERID, RUN2D was associated with False True FIRSTRELEASE specObj-dr17 1
A elodie_dof None Degrees of freedom in fit to best ELODIE star False True ELODIE_DOF specObj-dr17 1
A anyormask None For each bit, records whether any pixel in the spectrum has that bit set in its ORMASK False True ANYORMASK specObj-dr17 1
A sn_median_all None Median signal-to-noise per pixel across full spectrum False True SN_MEDIAN_ALL specObj-dr17 1
A primtarget None Target selection information at plate design, primary science selection (for backwards compatibility) False True PRIMTARGET specObj-dr17 1
A run2d None Spectroscopic 2D reduction (extraction of spectra) name False True RUN2D specObj-dr17 1
A tile None Tile number (each tile can have several plates drilled for it) False True TILE specObj-dr17 1
A thing_id None Resolve THING_ID in SDSS imaging for best positional match False True THING_ID specObj-dr17 1
A elodie_object None Star name for ELODIE star False True ELODIE_OBJECT specObj-dr17 1
A special_target2 None Secondary (calibration) target flags for SDSS-I and SDSS-II special program targets False True SPECIAL_TARGET2 specObj-dr17 1
A vdispz_err None Error in redshift associated with best-fit velocity dispersion False True VDISPZ_ERR specObj-dr17 1
A calibflux nanomaggy ugriz fluxes used for calibrations False True CALIBFLUX specObj-dr17 1
A vdisp_err km s-1 Error in velocity dispersion False True VDISP_ERR specObj-dr17 1
A segue1_target2 None Primary (science) target flags for SEGUE-1 targets False True SEGUE1_TARGET2 specObj-dr17 1
A nspecobs None Number of spectroscopic observations of this source False True NSPECOBS specObj-dr17 1
A boss_target1 None Primary (science) target flags for BOSS targets False True BOSS_TARGET1 specObj-dr17 1
A wcoverage None Coverage in wavelength, in units of log10 wavelength False True WCOVERAGE specObj-dr17 1
A speclegacy None Set to 1 for primary SDSS Legacy program observation of object, 0 otherwise False True SPECLEGACY specObj-dr17 1
A xfocal mm Hole position on plate (+X = +RA) False True XFOCAL specObj-dr17 1
A spectroskyflux nanomaggy Sky flux in each of the ugriz imaging filters False True SPECTROSKYFLUX specObj-dr17 1
A specboss None Set to 1 for primary BOSS spectrograph observation of object, 0 otherwise False True SPECBOSS specObj-dr17 1
A subclass None Best spectroscopic subclassification False True SUBCLASS specObj-dr17 1
A comments_person None Visual-inspection comments False True COMMENTS_PERSON specObj-dr17 1
A sectarget None Deprecated version of secondary (calibration) target flags (meanings highly overloaded) False True SECTARGET specObj-dr17 1
A spectroflux_ivar nanomaggy-2 Inverse variance of spectrum projected onto ugriz filters False True SPECTROFLUX_IVAR specObj-dr17 1
A targetobjid None Unique database ID of targeting object based on RUN, RERUN, CAMCOl, FIELD, ID (same as SkyServer version) False True TARGETOBJID specObj-dr17 1
A tcolumn None Columns of template files that correspond to each template False True TCOLUMN specObj-dr17 1
A spectroflux nanomaggy Spectrum projected onto ugriz filters False True SPECTROFLUX specObj-dr17 1
A rchi2 None Reduced chi-squared of best fit False True RCHI2 specObj-dr17 1
A fracnsiglo None Fraction of pixels low by more than N sigma relative to best-fit (for 1,2,..,10 sigma) False True FRACNSIGLO specObj-dr17 1
A spectrosynflux_ivar nanomaggy-2 Inverse variance of best-fit template spectrum projected onto ugriz filters False True SPECTROSYNFLUX_IVAR specObj-dr17 1
A class_person None Visual-inspection classification (0=not inspected or unknown, 1=star, 2=narrow emission-line galaxy, 3=QSO, 4=galaxy) False True CLASS_PERSON specObj-dr17 1
A ancillary_target1 None BOSS ancillary science target selection information at plate design False True ANCILLARY_TARGET1 specObj-dr17 1
A boss_specobj_id None Identification number internal to BOSS for SPECBOSS=1 objects False True BOSS_SPECOBJ_ID specObj-dr17 1
A survey None Survey name False True SURVEY specObj-dr17 1
A platerun None Drilling run that this plate was drilled in False True PLATERUN specObj-dr17 1
A targettype None General type of target (SCIENCE, STANDARD, or SKY) False True TARGETTYPE specObj-dr17 1
A designid None Design identification number for plate False True DESIGNID specObj-dr17 1
A segue2_target1 None Primary (science) target flags for SEGUE-2 targets False True SEGUE2_TARGET1 specObj-dr17 1
A legacy_target2 None Secondary (calibration) target flags for SDSS-I and SDSS-II Legacy survey False True LEGACY_TARGET2 specObj-dr17 1
A ancillary_target2 None BOSS ancillary target selection information at plate design False True ANCILLARY_TARGET2 specObj-dr17 1
A platesn2 None Overall signal-to-noise-squared measure for plate (only for SDSS spectrograph plates) False True PLATESN2 specObj-dr17 1
A class_noqso None Spectroscopic classification for Z_NOQSO redshift False True CLASS_NOQSO specObj-dr17 1
A chunk None Name of tiling chunk that this spectrum was tiled in (boss1, boss2, etc), important for tracking large-scale structure samples False True CHUNK specObj-dr17 1
A bluefiber None 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 BLUEFIBER specObj-dr17 1
A elodie_teff Kelvin Effective temperature of ELODIE star False True ELODIE_TEFF specObj-dr17 1
A thing_id_targeting None Resolve THING_ID in SDSS imaging for targeted object False True THING_ID_TARGETING specObj-dr17 1
A elodie_sptype None ELODIE star spectral type False True ELODIE_SPTYPE specObj-dr17 1
A spec2_g None Signal-to-noise squared for spectrograph #2, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra False True SPEC2_G specObj-dr17 1
A vdispz None Redshift associated with best-fit velocity dispersion False True VDISPZ specObj-dr17 1
A marvels_target2 None Secondary (calibration) target flags for MARVELS targets False True MARVELS_TARGET2 specObj-dr17 1
A fracnsigma None Fraction of pixels deviant by more than N sigma relative to best-fit (for 1,2,..,10 sigma) False True FRACNSIGMA specObj-dr17 1
A spec1_r None Signal-to-noise squared for spectrograph #1, at r=20.25 for SDSS spectrograph spectra, r=20.20 for BOSS spectrograph spectra False True SPEC1_R specObj-dr17 1
A zwarning_noqso None Warnings in z_noqso redshift (BOSS spectra only) False True ZWARNING_NOQSO specObj-dr17 1
A npoly None Number of polynomial terms in fit False True NPOLY specObj-dr17 1
A run1d None Spectroscopic 1D reduction (redshift and classification) name False True RUN1D specObj-dr17 1
A eboss_target2 None eBOSS, TDSS and SPIDERS target selection flags for main eBOSS survey False True EBOSS_TARGET2 specObj-dr17 1
A rchi2diff_noqso None Difference in reduced chi-squared between best and second best fit for Z_NOQSO redshift False True RCHI2DIFF_NOQSO specObj-dr17 1
A subclass_noqso None Spectroscopic subclassification for Z_NOQSO redshift False True SUBCLASS_NOQSO specObj-dr17 1
A dof None Number of degrees of freedom in best fit False True DOF specObj-dr17 1
A z_err_noqso None Error in Z_NOQSO redshift False True Z_ERR_NOQSO specObj-dr17 1
A fiberid None Fiber number False True FIBERID specObj-dr17 1
A cx None x of Normal unit vector in J2000 False True CX specObj-dr17 1
A mjd days Modified Julian Day of observation False True MJD specObj-dr17 1
A specsdss None Set to 1 for primary SDSS spectrograph observation of object, 0 otherwise False True SPECSDSS specObj-dr17 1
A tfile None File that best fit template comes from in idlspec2d product False True TFILE specObj-dr17 1
A calibflux_ivar nanomaggy-2 Inverse variances of ugriz fluxes used for calibrations False True CALIBFLUX_IVAR specObj-dr17 1
A elodie_z_modelerr None Standard deviation in redshift among the 12 best-fit ELODIE stars False True ELODIE_Z_MODELERR specObj-dr17 1
A special_target1 None Primary (science) target flags for SDSS-I and SDSS-II special program targets False True SPECIAL_TARGET1 specObj-dr17 1
A vdispchi2 None Chi-squared for best-fit velocity dispersion False True VDISPCHI2 specObj-dr17 1
A vdisp km s-1 Velocity dispersion False True VDISP specObj-dr17 1
A platequality None Final quality of plate this spectrum came from (good, marginal, or bad) False True PLATEQUALITY specObj-dr17 1
A spec1_g None Signal-to-noise squared for spectrograph #1, at g=20.20 for SDSS spectrograph spectra, g=21.20 for BOSS spectrograph spectra False True SPEC1_G specObj-dr17 1
A cy None y of Normal unit vector in J2000 False True CY specObj-dr17 1
A segue1_target1 None Primary (science) target flags for SEGUE-1 targets False True SEGUE1_TARGET1 specObj-dr17 1
A plateid None Unique database ID of plate based on PLATE, MJD, RUN2D (same as SkyServer version) False True PLATEID specObj-dr17 1
A deredsn2 None Dereddened overall signal-to-noise-squared measure for plate (only for BOSS spectrograph plates) False True DEREDSN2 specObj-dr17 1
A marvels_target1 None Primary (science) target flags for MARVELS targets False True MARVELS_TARGET1 specObj-dr17 1
A elodie_bv mag (B-V) color index for ELODIE star False True ELODIE_BV specObj-dr17 1
A legacy_target1 None Primary (science) target flags for SDSS-I and SDSS-II Legacy survey False True LEGACY_TARGET1 specObj-dr17 1
A rchi2diff None Difference in reduced chi-squared between best and second best fit False True RCHI2DIFF specObj-dr17 1
A sn_median None Median signal-to-noise per pixel within each of the ugriz bandpasses False True SN_MEDIAN specObj-dr17 1
A zoffset micron Washer thickness used for backstopping BOSS quasar targets, so they are closer to 4000 Angstrom focal plan False True ZOFFSET specObj-dr17 1
A vdispnpix None Number of pixels overlapping the templates used in the velocity dispersion fit False True VDISPNPIX specObj-dr17 1
A boss_target2 None Always set to zero (placeholder for BOSS target flags never used) False True BOSS_TARGET2 specObj-dr17 1
A yfocal mm Hole position on plate (+Y = +DEC) False True YFOCAL specObj-dr17 1
A elodie_filename None File name for best-fit ELODIE star False True ELODIE_FILENAME specObj-dr17 1
A programname None Program within each survey that the plate was part of False True PROGRAMNAME specObj-dr17 1
A z_noqso None 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 Z_NOQSO specObj-dr17 1
C redshift_warning None Bitmask with warning on redshift result False True ZWARNING spZbest 1
C exptime second Exposure time in seconds False True EXPTIME spPlate 0
C extra_files None Additional files read for ingest False False N/A N/A N/A
C ra deg Right Ascension in degrees True True PLUG_RA spZbest 1
C file None File used for this record False False N/A N/A N/A
C specid None Dataset-specific spectrum identifier (may not be unique) True True SPECOBJID specObj-dr17 1
C wavemax AA Maximum value of wavelength coverage in Angstroms False True WAVEMAX spZbest 1
C dateobs_center None Central value of the dateobs range False True DATE-OBS spPlate 0
C dec deg Declination in degrees True True PLUG_DEC spZbest 1
C data_release None [Categorical] Data release of a given record (with a common data structure, e.g., SDSS-DR16, BOSS-DR16) False True N/A N/A N/A
C spectype None [Categorical] Spectral type of the object (STAR, GALAXY, QSO) False True CLASS spZbest 1
C site None [Categorical] Site of observations False True N/A N/A N/A
C telescope None [Categorical] Telescope used for the observation False True N/A N/A N/A
C specprimary None Whether an entry is the primary spectrum for a given target object False True SPECPRIMARY specObj-dr17 1
C datasetgroup None [Categorical] Common name for a coherent set of spectra published as a single release (e.g., SDSS_BOSS) False True N/A N/A N/A
C targetid None Dataset-specific photometric target identifier False True BESTOBJID specObj-dr17 1
C updated None Date and time when the record was created/updated False False N/A N/A N/A
C sparcl_id None Universally Unique Identifier for spectrum in SPARCL True True N/A N/A N/A
C redshift None Measured redshift, or radial velocity in units of redshift False True Z spZbest 1
C dateobs None Range of observational dates for a given spectrum (single value for a single date) False True DATE-OBS spPlate 0
C wavemin AA Minimum value of wavelength coverage in Angstroms False True WAVEMIN spZbest 1
C instrument None [Categorical] Instrument used for observation False True N/A N/A N/A
C redshift_err None Uncertainty on the measured redshift, or radial velocity in units of redshift False True Z_ERR spZbest 1
S mask None and_mask False True N/A spPlate 2
S sky 1e-17 erg cm-2 s-1 AA-1 Subtracted sky flux False True N/A spPlate 6
S model 1e-17 erg cm-2 s-1 AA-1 Pipeline best model fit used for classification and redshift False True N/A spZbest 2
S ivar 1e+34 cm4 s2 AA2 erg-2 Inverse variance of flux False True N/A spPlate 1
S wave_sigma pixel Line-spread function width (sigma of approximating Gaussian) in units of number of pixel False True N/A spPlate 4
S flux 1e-17 erg cm-2 s-1 AA-1 Coadded calibrated flux True True N/A spPlate 0
S wavelength AA Wavelength in units of Angstroms True True CRVAL1, COEFF1 spPlate 0

Legend

CCORE field
SSPECTRA field
AAUX field