Database fields, all categories

Sample identification
	`REC_NO`	A sequential record number assigned during reformatting process
	`PRIME_ID`	Primary laboratory sample identification number
	`REPLC`	Replicate code
	`DOELAB`	Department of Energy (DOE) laboratory responsible for collecting and analyzing the sample
	`LASLID`	Los Alamos Scientific Laboratory site identification number
	`ORNLID`	Oak Ridge Gaseous Diffusion Plant sample number
	`SRLID`	Savannah River Laboratory sample number
	`LLLID`	Lawrence Livermore Laboratory sample number
	`SITE`	Additional site number (Definition of field varies slightly with lab responsible for the sample)
Geographic location
	`LATITUDE`	Latitude in decimal degrees (NAD27, Clarke 1866)
	`LONGITUDE`	Longitude in decimal degrees (negative = west; NAD27, Clarke 1866)
	`STATE`	State in which the sample was collected (Post office abbreviation)
	`QUAD`	The name of the USGS 1° by 2° quadrangle in which the sample was reported collected
	`MAPCODE`	Alphanumeric NTMS map code for the USGS 1° by 2° quadrangle (incompletely populated and not diagnostic)
	`FIPS`	FIPS code of county and state calculated from geographic coordinates
	`HUC8`	8-Digit Hydrologic Unit Code calculated from geographic coordinates
	`LS_MAP`	Hierarchical code that identifies different scale USGS quadrangles calculated from geographic coordinate
	`STUDY`	A code that identifies the Pilot/Orientation study or Detailed Study for which the sample was collected
	`PHASE`	Sampling phase
	`STRBASIN`	Drainage basin identification number and stream order
	`B_LAT_C`	Latitude of basin centroid
	`B_LONG_C`	Longitude of basin centroid
	`COORDPRB`	Comments added during the reformatting process to document problems specifically with latitude and longitude coordinates in the
Processing information
	`SPECMS`	An indicator for when special measurements were recorded for a sample site
	`TAPEDATA`	Tape release data
	`ANALDATE`	Date on which the multielement analysis was completed
	`BATCH_ES`	ORGDP analytical laboratory batch number for multielement emission spectroscopy analyses
	`ASBATCH`	ORGDP analytical laboratory batch number for arsenic and selenium analyses
	`CLBATCH`	ORGDP analytical laboratory batch number for chlorine and sulfate analyses
	`NO3BATCH`	ORGDP analytical laboratory batch number for nitrate analyses
	`PO4BATCH`	ORGDP analytical laboratory batch number for orthophosphate analyses
	`RNBATCH`	ORGDP analytical laboratory batch number for radon analyses
	`HENBATCH`	ORGDP analytical laboratory batch number for helium/neon ratios
	`UBATCH_DN`	ORGDP analytical laboratory batch number for delayed neutron counting uranium analyses
	`UBATCH_FL`	ORGDP analytical laboratory batch number for fluorescence spectroscopy uranium analyses
	`UBATCH_MS`	ORGDP analytical laboratory batch number for mass spectrometry uranium analyses
	`TAPEFILE`	The original NURE tape name and file number used as the primary source of information for each record
	`REFORMAT`	Comments added during the reformatting process to document problems, changes, additions, and data sources in the record
Sample characteristics
	`SAMPTYP`	Sample type code that identifies the source, medium, and treatment of the sample
	`REC_CNT`	Multiple record counter that was incremented for additional records on a single sample
	`SAMPSRC`	Source of the sample that was collected and analyzed as derived from the SAMPTYP code
	`SMPTREAT`	Field treatment of water samples with respect to acidification and filtering
	`OSAMPTYP`	ORGDP sample type and sample source classification
	`LSAMPTYP`	ORGDP Laboratory sample type classification
	`WTRTREAT`	Water sample treatment (apparently field pre-treatment information)
	`SAMPDAT`	Sample collection date, reformatted to YYYY/MM/DD
	`SAMPHR`	Sample collection time rounded to the nearest whole hour (24-hour clock)
	`SAMPLER`	Sampler initials or sampling team number (Definition of field varies slightly with lab responsible for the sample)
	`GRABS`	Number of grabs or subsamples collected at a site to composite the sample
Site characteristics
	`WEATHER`	A description of the prevalent weather conditions at the time of sampling
	`AIRTEMP`	The air temperature measured at the sample site, reported in degrees Celsius
	`WTRTEMP`	The water temperature measured at the sample site, reported in degrees Celsius
	`PH`	The pH of water at the site as determined by a pH meter
	`PH_LOION`	The pH of water at the site as determined by Lo-Ion paper
	`COND`	The specific conductance measured in water at the site with a conductivity meter (in µmhos/cm)
	`LABCOND`	The specific conductance measured in the water sample at the laboratory (in µmhos/cm)
	`ALK`	Field measurement of the total alkalinity in water at the site (Definition, method, and reporting unit varies by lab)
	`ALKP`	Field measurement of phenolphthalein alkalinity in water at the site (Definition and reporting unit varies by lab)
	`ALKM`	Field measurement of ALKP plus remaining alkalinity in water at the site to get approximate total alkalinity (reporting units no
	`O_DISS`	Amount of oxygen dissolved in water at site, reported in ppm
	`SCIN`	Scintillometer measurement of the local gamma-ray activity at a sample site, expressed as equivalent uranium in ppm
	`ORGN_PCT`	Field estimate of the percentage of organic material present in the sample
	`SAMPODOR`	An indication of any odor from the sampled material
	`SMPCOLR`	Color of sample material collected
	`SGEOUNIT`	A two to four letter code that designates the formation name or the age of the surface bedrock at the sampling site
	`ROCKTYP`	The predominant type of surficial bedrock in the vicinity of the sample site
	`ROCKCLR`	Dominant color of local bedrock exposures
	`SEDTYPE`	Type of dominant bed material or loose sediment at the sample site
	`SEDCOLR`	Dominant color of loose sediment at sample site
	`STRWDTH`	Estimated width of the stream at the sample site, in meters
	`STRWDTHC`	Estimated width range (in feet) of the stream at the sample site
	`STRDPTH`	Estimated depth of the stream at the sample site, in meters
	`STRDPTHC`	Estimated depth range (in feet) of the stream at the sample site
	`WTRLEVEL`	A field judgement of the water level at the sample site
	`STRFLOW`	The average velocity of the stream flow reported in meters/second
	`STRFLOWC`	A field judgement of the stream flow velocity at the sample site
	`WTRDCHRG`	The discharge rate of the well or spring, in liters/minute
	`WTRCOLR`	Amount and type of dissolved or suspended load in water at the site based on its color or appearance
	`VSBLDPTH`	Depth of visibility estimated from water collected in a liter bottle and reported in meters
	`STRCHANL`	A field judgement of the stream channel depositional character at the sample site when the sample was collected
	`VEGTYPE`	Dominant type of vegetation in the area of the sampled location
	`VEGDENS`	Density of plant cover at the sample site
	`RELIEF`	An estimate of the relief or difference in elevation in the vicinity of the sample site (reported as a range in meters)
	`CONTAMC`	A field judgement of possible contaminant sources or major activities near the sample site
	`WELLPUMP`	Type of pump used to draw water from the sampled well
	`WELLTYPE`	Type of well that was sampled
	`WELLUSE`	Primary use of well
	`WELLUSE2`	Most typical use of well water
	`WELLFREQ`	Frequency of well pumping or use
	`WLSMPLOC`	An indication of where in the water system a well water sample was collected
	`WLDIST_M`	An estimate of the distance from the well head to the location where the sample was collected, in meters
	`WELLPIPE`	Composition of the pipe from which the well water sample was collected
	`WELLCASE`	Composition of the well casing below the water table
	`WELLDIAM`	Inside diameter of the well casing, in inches
	`WELLDPTH`	Total drilled depth of well from the surface, in feet
	`WLDPTSRC`	Source of total well depth (WELLDPTH) information
	`WLDPTCNF`	An indication of the confidence in the accuracy of the total well depth (WELLDPTH) information
	`WWTRDPTH`	Depth from the ground surface to the water level in a well, in feet
	`WLPRDPTH`	Depth from the ground surface to the top of the producing horizon in the well, in feet
	`WLPDSRC`	Source of information for the depth to top of producing horizon (WLPRDPTH) information
	`WLPDCNF`	An indication of the confidence in the accuracy of the depth to top of producing horizon (WLPRDPTH) information
	`WELLAGE`	Age of the sampled well recorded to the nearest whole year
	`WLAGECNF`	An indication of the confidence in the accuracy of the well age (WELLAGE) information
	`PUNIT`	A 2 to 4 letter code that designates the formation name, aquifer name, or the age of the producing unit
	`PUNITSRC`	Source of producing horizon geologic unit (PUNIT) information
	`PUNITCNF`	An indication of the confidence in the accuracy of the producing horizon geologic unit (PUNIT) identification
	`COMMENTS`	Sample collector's comments
	`COMMENT2`	Sample collector's comments (continued)
Chemical analysis
	`U_XX_MTHD`	Analytical method code for extra or multiple uranium analyses (U_XX_PPM or U_XX_PPB)
	`U_XX_PPB`	Concentration of uranium in water, in parts per billion, determined by an extra or multiple uranium analysis
	`U_DN_PPB`	Concentration of uranium in water, in parts per billion, determined by delayed neutron counting
	`U_FL_PPB`	Concentration of uranium in water, in parts per billion, determined by fluorescence spectroscopy
	`U_MS_PPB`	Concentration of uranium in water, in parts per billion, determined by mass spectrometry
	`AG_PPB`	Concentration of silver in water, in parts per billion
	`AL_PPB`	Concentration of aluminum in water, in parts per billion
	`AS_PPB`	Concentration of arsenic in water, in parts per billion
	`B_PPB`	Concentration of boron in water, in parts per billion
	`BA_PPB`	Concentration of barium in water, in parts per billion
	`BE_PPB`	Concentration of beryllium in water, in parts per billion
	`BR_PPB`	Concentration of bromide ions in water, in parts per billion
	`CA_PPM`	Concentration of calcium in water, in parts per million
	`CD_PPB`	Concentration of cadmium in water, in parts per billion
	`CE_PPB`	Concentration of cerium in water, in parts per billion
	`CL_PPM`	Concentration of chloride ions in water or sediments, in parts per million
	`CO_PPB`	Concentration of cobalt in water, in parts per billion
	`CR_PPB`	Concentration of chromium in water, in parts per billion
	`CU_PPB`	Concentration of copper in water, in parts per billion
	`DY_PPB`	Concentration of dysprosium in water, in parts per billion
	`F_PPB`	Concentration of fluoride ions in water, in parts per billion
	`FE_PPB`	Concentration of iron in water, in parts per billion
	`HE_PPM`	Concentration of helium in water, in parts per million
	`K_PPM`	Concentration of potassium in water, in parts per million
	`LI_PPB`	Concentration of lithium in water, in parts per billion
	`MG_PPM`	Concentration of magnesium in water, in parts per million
	`MN_PPB`	Concentration of manganese in water, in parts per billion
	`MO_PPB`	Concentration of molybdenum in water, in parts per billion
	`NA_PPM`	Concentration of sodium in water, in parts per million
	`NB_PPB`	Concentration of niobium in water, in parts per billion
	`NI_PPB`	Concentration of nickel in water, in parts per billion
	`P_PPB`	Concentration of phosphorus in water, in parts per billion
	`PB_PPB`	Concentration of lead in water, in parts per billion
	`SC_PPB`	Concentration of scandium in water, in parts per billion
	`SE_PPB`	Concentration of selenium in water, in parts per billion
	`SI_PPM`	Concentration of silicon in water, in parts per million
	`SR_PPB`	Concentration of strontium in water, in parts per billion
	`TH_PPB`	Concentration of thorium in water, in parts per billion
	`TI_PPB`	Concentration of titanium in water, in parts per billion
	`V_PPB`	Concentration of vanadium in water, in parts per billion
	`Y_PPB`	Concentration of yttrium in water, in parts per billion
	`ZN_PPB`	Concentration of zinc in water, in parts per billion
	`ZR_PPB`	Concentration of zirconium in water, in parts per billion
	`METH_PPM`	Concentration of methane in water, in parts per million
	`ETH_PPM`	Concentration of ethane in water, in parts per million
	`PROP_PPM`	Concentration of propane in water, in parts per million
	`BUT_PPM`	Concentration of butane in water, in parts per million
	`RN_PCI_L`	Concentration of radon in water, in picocuries per liter (pCi/l)
	`NO3_PPM`	Concentration of nitrate in water, in parts per million
	`PO4_PPM`	Concentration of phosphate in water or sediments, in parts per million
	`SO4_PPM`	Concentration of sulfate in water or sediments, in parts per million
	`HENRATIO`	The measured ratio of helium/neon in water
	`METHODS`	Analytical method codes for each method used to determine the element concentrations listed in the record