---------------------------------------------------------------------- QWdata.txt - Water quality data (Note some records are duplicated if a well is included in two SITETYPEs, for example, some NAWQA aquifer study wells ("Mas") are also Public supply ("Pws") wells and are included twice in this table. Column Data Type Description -------- ---------- ------------ STAID text Station identifier SITETYPE text Dom, domestic well; Mas, well included in NAWQA aquifer study; Pws, Public-supply well DATATYPE text AWWARF, sampled as part of AWWARF study; NAWQA, sampled by USGS NAWQA program; RETRO, sampled by USGS or other agencies prior to the NAWQA program SAMPDATE text date of sample, in the form YYYYMMDD PCODE text USGS Parameter code (see qwpcodes.txt) REMRK text USGS Remark code: "<" not detected at value CVALUE "E" detected, concentration estimated to be CVALUE "-" detected at concentration CVALUE CVALUE number concentration (micrograms per liter) ---------------------------------------------------------------------- QWparam.txt - Water quality parameters (constituents) Column Data Type Description -------- ---------- ------------ PCODE text Station identifier CAS text CAS-ID NAME text IUPAC Name GROUP text VOC Group (groups used in report) HBSLVAL text Health-based screening level, "-" if not available MCLVAL text EPA Drinking water reporting limit, "-" if not available ---------------------------------------------------------------------- QWsites.txt - Information about wells included in the study STAID* text Station identifier DATATYPE** text AWWARF, sampled as part of AWWARF study; NAWQA, sampled by USGS NAWQA program; RETRO, sampled by USGS or other agencies prior to the NAWQA program LATDD*** number Geographic location, latitude LONDD*** number Geographic location, longitude LUTYPE text Type of NAWQA study for which well was sampled: MAS, major aquifer study; URBAN, urban land-use study; AG, agricultural land-use study; -, not studied as part of NAWQA NAWQAYR number Year of NAWQA study: 1991, 1994, 1997, or 0 (not sampled as part of NAWQA) STUDY text Aquifer study code DOMESTIC number 0, not a domestic well; 1, domestic well AQUIFERS number 0, well not sampled in NAWQA or RETRO aquifer study; 1, well sampled in NAWQA or RETRO aquifer study PUBLIC number 0, Well is not a public-supply well; 1, Well is a public-supply well * For AWWARF and RETRO sites, this is a nominal identifier For NAWQA sites, this is a USGS National Water Information System (NWIS) station number ** Column definition updated to match data file *** Locations are referenced to the North American Datum of 1983. Public-supply well locations have been rounded to the nearest 0.1 degree for this public release to conform to USGS data release policies. These files were updated 11/05/2010