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
po4batchORGDP analytical laboratory batch number for orthophosphate analyses
snbatchORGDP analytical laboratory batch number for tin analyses
hgbatchORGDP analytical laboratory batch number for mercury analyses
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
ubatch_xxORGDP analytical laboratory batch number for extra or multiple 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
smpmediaType of sample media that was collected and analyzed as derived from the SAMPTYP code
sampsrcSource of the sample that was collected and analyzed as derived from the SAMPTYP code
sedcondCondition (wet or dry) of sediment collected as derived from the SAMPTYP code
sizefrxnSeive size fraction of the sediment material that was ultimately analyzed as derived from the SAMPTYP code
osamptypORGDP sample type and sample source classification
lsamptypORGDP Laboratory sample type classification
ssamptypSavannah River Laboratory sample type classification
sedtreatSediment 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
condThe specific conductance measured in water at the site with a conductivity meter (in µmhos/cm)
alkField measurement of the total alkalinity in water at the site (Definition, method, and reporting unit varies by lab)
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
wtrcolrAmount and type of dissolved or suspended load in water at the site based on its color or appearance
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
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_ppmConcentration of uranium in sediments, in parts per million, determined by an extra or multiple uranium analysis
u_dn_ppmConcentration of uranium in sediments, in parts per million, determined by delayed neutron counting
u_fl_ppmConcentration of uranium in sediments, in parts per million, determined by fluorescence spectroscopy
u_ms_ppmConcentration of uranium in sediments, in parts per million, determined by mass spectrometry
u_na_ppmConcentration of uranium in sediments, in parts per million, determined by neutron activation
ag_ppmConcentration of silver in sediments, in parts per million
al_pctConcentration of aluminum in sediments, in percent
as_ppmConcentration of arsenic in sediments, in parts per million
au_ppmConcentration of gold in sediments, in parts per million
b_ppmConcentration of boron in sediments, in parts per million
ba_ppmConcentration of barium in sediments, in parts per million
be_ppmConcentration of beryllium in sediments, in parts per million
bi_ppmConcentration of bismuth in sediments, in parts per million
br_ppmConcentration of bromine in sediments, in parts per million
ca_pctConcentration of calcium in sediments, in percent
cd_ppmConcentration of cadmium in sediments, in parts per million
ce_ppmConcentration of cerium in sediments, in parts per million
cl_ppmConcentration of chloride ions in water or sediments, in parts per million
co_ppmConcentration of cobalt in sediments, in parts per million
cr_ppmConcentration of chromium in sediments, in parts per million
cs_ppmConcentration of cesium in sediments, in parts per million
cu_ppmConcentration of copper in sediments, in parts per million
dy_ppmConcentration of dysprosium in sediments, in parts per million
eu_ppmConcentration of europium in sediments, in parts per million
f_ppmConcentration of fluorine in sediments, in parts per million
fe_pctConcentration of iron in sediments, in percent
hf_ppmConcentration of hafnium in sediments, in parts per million
hg_ppmConcentration of mercury in sediments, in parts per million
k_pctConcentration of potassium in sediments, in percent
la_ppmConcentration of lanthanum in sediments, in parts per million
li_ppmConcentration of lithium in sediments, in parts per million
lu_ppmConcentration of lutetium in sediments, in parts per million
mg_pctConcentration of magnesium in sediments, in percent
mn_ppmConcentration of manganese in sediments, in parts per million
mo_ppmConcentration of molybdenum in sediments, in parts per million
na_pctConcentration of sodium in sediments, in percent
nb_ppmConcentration of niobium in sediments, in parts per million
ni_ppmConcentration of nickel in sediments, in parts per million
p_ppmConcentration of phosphorus in sediments, in parts per million
pb_ppmConcentration of lead in sediments, in parts per million
pt_ppmConcentration of platinum in sediments, in parts per million
rb_ppmConcentration of rubidium in sediments, in parts per million
sb_ppmConcentration of antimony in sediments, in parts per million
sc_ppmConcentration of scandium in sediments, in parts per million
se_ppmConcentration of selenium in sediments, in parts per million
sm_ppmConcentration of samarium in sediments, in parts per million
sn_ppmConcentration of tin in sediments, in parts per million
sr_ppmConcentration of strontium in sediments, in parts per million
ta_ppmConcentration of tantalum in sediments, in parts per million
tb_ppmConcentration of terbium in sediments, in parts per million
th_ppmConcentration of thorium in sediments, in parts per million
ti_ppmConcentration of titanium in sediments, in parts per million
v_ppmConcentration of vanadium in sediments, in parts per million
w_ppmConcentration of tungsten in sediments, in parts per million
y_ppmConcentration of yttrium in sediments, in parts per million
yb_ppmConcentration of ytterbium in sediments, in parts per million
zn_ppmConcentration of zinc in sediments, in parts per million
zr_ppmConcentration of zirconium in sediments, in parts per million
po4_ppmConcentration of phosphate in sediments, in parts per million
so4_ppmConcentration of sulfate in water or sediments, in parts per million
methodsAnalytical method codes for each method used to determine the element concentrations listed in the record