Database fields, all categories

Sample identification
rec_noA sequential record number assigned during reformatting process
prime_idPrimary laboratory sample identification number
replcReplicate code
doelabDepartment of Energy (DOE) laboratory responsible for collecting and analyzing the sample
laslidLos Alamos Scientific Laboratory site identification number
ornlidOak Ridge Gaseous Diffusion Plant sample number
srlidSavannah River Laboratory sample number
lllidLawrence Livermore Laboratory sample number
siteAdditional site number (Definition of field varies slightly with lab responsible for the sample)
Geographic location
latitudeLatitude in decimal degrees (NAD27, Clarke 1866)
longitudeLongitude in decimal degrees (negative = west; NAD27, Clarke 1866)
stateState in which the sample was collected (Post office abbreviation)
quadThe name of the USGS 1° by 2° quadrangle in which the sample was reported collected
mapcodeAlphanumeric NTMS map code for the USGS 1° by 2° quadrangle (incompletely populated and not diagnostic)
fipsFIPS code of county and state calculated from geographic coordinates
huc88-Digit Hydrologic Unit Code calculated from geographic coordinates
ls_mapHierarchical code that identifies different scale USGS quadrangles calculated from geographic coordinate
studyA code that identifies the Pilot/Orientation study or Detailed Study for which the sample was collected
phaseSampling phase
strbasinDrainage basin identification number and stream order
b_lat_cLatitude of basin centroid
b_long_cLongitude of basin centroid
coordprbComments added during the reformatting process to document problems specifically with latitude and longitude coordinates in the
Processing information
specmsAn indicator for when special measurements were recorded for a sample site
tapedataTape release data
analdateDate on which the multielement analysis was completed
batch_esORGDP analytical laboratory batch number for multielement emission spectroscopy analyses
asbatchORGDP analytical laboratory batch number for arsenic and selenium analyses
clbatchORGDP analytical laboratory batch number for chlorine and sulfate analyses
no3batchORGDP analytical laboratory batch number for nitrate analyses
po4batchORGDP analytical laboratory batch number for orthophosphate analyses
rnbatchORGDP analytical laboratory batch number for radon analyses
henbatchORGDP analytical laboratory batch number for helium/neon ratios
ubatch_dnORGDP analytical laboratory batch number for delayed neutron counting uranium analyses
ubatch_flORGDP analytical laboratory batch number for fluorescence spectroscopy uranium analyses
ubatch_msORGDP analytical laboratory batch number for mass spectrometry uranium analyses
tapefileThe original NURE tape name and file number used as the primary source of information for each record
reformatComments added during the reformatting process to document problems, changes, additions, and data sources in the record
Sample characteristics
samptypSample type code that identifies the source, medium, and treatment of the sample
rec_cntMultiple record counter that was incremented for additional records on a single sample
sampsrcSource of the sample that was collected and analyzed as derived from the SAMPTYP code
smptreatField treatment of water samples with respect to acidification and filtering
osamptypORGDP sample type and sample source classification
lsamptypORGDP Laboratory sample type classification
wtrtreatWater sample treatment (apparently field pre-treatment information)
sampdatSample collection date, reformatted to YYYY/MM/DD
samphrSample collection time rounded to the nearest whole hour (24-hour clock)
samplerSampler initials or sampling team number (Definition of field varies slightly with lab responsible for the sample)
grabsNumber of grabs or subsamples collected at a site to composite the sample
Site characteristics
weatherA description of the prevalent weather conditions at the time of sampling
airtempThe air temperature measured at the sample site, reported in degrees Celsius
wtrtempThe water temperature measured at the sample site, reported in degrees Celsius
phThe pH of water at the site as determined by a pH meter
ph_loionThe pH of water at the site as determined by Lo-Ion paper
condThe specific conductance measured in water at the site with a conductivity meter (in µmhos/cm)
labcondThe specific conductance measured in the water sample at the laboratory (in µmhos/cm)
alkField measurement of the total alkalinity in water at the site (Definition, method, and reporting unit varies by lab)
alkpField measurement of phenolphthalein alkalinity in water at the site (Definition and reporting unit varies by lab)
alkmField measurement of ALKP plus remaining alkalinity in water at the site to get approximate total alkalinity (reporting units no
o_dissAmount of oxygen dissolved in water at site, reported in ppm
scinScintillometer measurement of the local gamma-ray activity at a sample site, expressed as equivalent uranium in ppm
orgn_pctField estimate of the percentage of organic material present in the sample
sampodorAn indication of any odor from the sampled material
smpcolrColor of sample material collected
sgeounitA two to four letter code that designates the formation name or the age of the surface bedrock at the sampling site
rocktypThe predominant type of surficial bedrock in the vicinity of the sample site
rockclrDominant color of local bedrock exposures
sedtypeType of dominant bed material or loose sediment at the sample site
sedcolrDominant color of loose sediment at sample site
strwdthEstimated width of the stream at the sample site, in meters
strwdthcEstimated width range (in feet) of the stream at the sample site
strdpthEstimated depth of the stream at the sample site, in meters
strdpthcEstimated depth range (in feet) of the stream at the sample site
wtrlevelA field judgement of the water level at the sample site
strflowThe average velocity of the stream flow reported in meters/second
strflowcA field judgement of the stream flow velocity at the sample site
wtrdchrgThe discharge rate of the well or spring, in liters/minute
wtrcolrAmount and type of dissolved or suspended load in water at the site based on its color or appearance
vsbldpthDepth of visibility estimated from water collected in a liter bottle and reported in meters
strchanlA field judgement of the stream channel depositional character at the sample site when the sample was collected
vegtypeDominant type of vegetation in the area of the sampled location
vegdensDensity of plant cover at the sample site
reliefAn estimate of the relief or difference in elevation in the vicinity of the sample site (reported as a range in meters)
contamcA field judgement of possible contaminant sources or major activities near the sample site
wellpumpType of pump used to draw water from the sampled well
welltypeType of well that was sampled
wellusePrimary use of well
welluse2Most typical use of well water
wellfreqFrequency of well pumping or use
wlsmplocAn indication of where in the water system a well water sample was collected
wldist_mAn estimate of the distance from the well head to the location where the sample was collected, in meters
wellpipeComposition of the pipe from which the well water sample was collected
wellcaseComposition of the well casing below the water table
welldiamInside diameter of the well casing, in inches
welldpthTotal drilled depth of well from the surface, in feet
wldptsrcSource of total well depth (WELLDPTH) information
wldptcnfAn indication of the confidence in the accuracy of the total well depth (WELLDPTH) information
wwtrdpthDepth from the ground surface to the water level in a well, in feet
wlprdpthDepth from the ground surface to the top of the producing horizon in the well, in feet
wlpdsrcSource of information for the depth to top of producing horizon (WLPRDPTH) information
wlpdcnfAn indication of the confidence in the accuracy of the depth to top of producing horizon (WLPRDPTH) information
wellageAge of the sampled well recorded to the nearest whole year
wlagecnfAn indication of the confidence in the accuracy of the well age (WELLAGE) information
punitA 2 to 4 letter code that designates the formation name, aquifer name, or the age of the producing unit
punitsrcSource of producing horizon geologic unit (PUNIT) information
punitcnfAn indication of the confidence in the accuracy of the producing horizon geologic unit (PUNIT) identification
commentsSample collector's comments
comment2Sample collector's comments (continued)
Chemical analysis
u_xx_mthdAnalytical method code for extra or multiple uranium analyses (U_XX_PPM or U_XX_PPB)
u_xx_ppbConcentration of uranium in water, in parts per billion, determined by an extra or multiple uranium analysis
u_dn_ppbConcentration of uranium in water, in parts per billion, determined by delayed neutron counting
u_fl_ppbConcentration of uranium in water, in parts per billion, determined by fluorescence spectroscopy
u_ms_ppbConcentration of uranium in water, in parts per billion, determined by mass spectrometry
ag_ppbConcentration of silver in water, in parts per billion
al_ppbConcentration of aluminum in water, in parts per billion
as_ppbConcentration of arsenic in water, in parts per billion
b_ppbConcentration of boron in water, in parts per billion
ba_ppbConcentration of barium in water, in parts per billion
be_ppbConcentration of beryllium in water, in parts per billion
br_ppbConcentration of bromide ions in water, in parts per billion
ca_ppmConcentration of calcium in water, in parts per million
cd_ppbConcentration of cadmium in water, in parts per billion
ce_ppbConcentration of cerium in water, in parts per billion
cl_ppmConcentration of chloride ions in water or sediments, in parts per million
co_ppbConcentration of cobalt in water, in parts per billion
cr_ppbConcentration of chromium in water, in parts per billion
cu_ppbConcentration of copper in water, in parts per billion
dy_ppbConcentration of dysprosium in water, in parts per billion
f_ppbConcentration of fluoride ions in water, in parts per billion
fe_ppbConcentration of iron in water, in parts per billion
he_ppmConcentration of helium in water, in parts per million
k_ppmConcentration of potassium in water, in parts per million
li_ppbConcentration of lithium in water, in parts per billion
mg_ppmConcentration of magnesium in water, in parts per million
mn_ppbConcentration of manganese in water, in parts per billion
mo_ppbConcentration of molybdenum in water, in parts per billion
na_ppmConcentration of sodium in water, in parts per million
nb_ppbConcentration of niobium in water, in parts per billion
ni_ppbConcentration of nickel in water, in parts per billion
p_ppbConcentration of phosphorus in water, in parts per billion
pb_ppbConcentration of lead in water, in parts per billion
sc_ppbConcentration of scandium in water, in parts per billion
se_ppbConcentration of selenium in water, in parts per billion
si_ppmConcentration of silicon in water, in parts per million
sr_ppbConcentration of strontium in water, in parts per billion
th_ppbConcentration of thorium in water, in parts per billion
ti_ppbConcentration of titanium in water, in parts per billion
v_ppbConcentration of vanadium in water, in parts per billion
y_ppbConcentration of yttrium in water, in parts per billion
zn_ppbConcentration of zinc in water, in parts per billion
zr_ppbConcentration of zirconium in water, in parts per billion
meth_ppmConcentration of methane in water, in parts per million
eth_ppmConcentration of ethane in water, in parts per million
prop_ppmConcentration of propane in water, in parts per million
but_ppmConcentration of butane in water, in parts per million
rn_pci_lConcentration of radon in water, in picocuries per liter (pCi/l)
no3_ppmConcentration of nitrate in water, in parts per million
po4_ppmConcentration of phosphate in water or sediments, in parts per million
so4_ppmConcentration of sulfate in water or sediments, in parts per million
henratioThe measured ratio of helium/neon in water
methodsAnalytical method codes for each method used to determine the element concentrations listed in the record