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