#  Begin METADATA documentation
#------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	camord_majors_nutrients_nawqa_replicates.txt
#  DATASET_DESCRIPTION:	This data set was used in a report to characterize the Cambrian-Ordovician Aquifer  
#			System as part of the US Geological Survey National Water Quality Assessment Program (NAWQA).
#
#			All water-quality data in this data set are from NAWQA samples collected in
#			Illinois, Iowa, Michigan (U.P.), Minnesota, and Wisconsin
#
#  DATA_SET FORMAT:	Tab-delimited ascii file
#  DATA_SET URL:        http://water.usgs.gov/nawqa-only/aq/data_archive/SIR2011_5229_Data.zip
#
#-------------------------------------------------------------------------------------------------------- 
#  REPORT TITLE: 		Water-quality assessment of the Cambrian-Ordovician aquifer system in the northern
#				Midwest, United States
#  REPORT SERIES/NUMBER:	USGS Scientific Investigation Report (SIR 2011-5229)     
#  REPORT URL:          	http://pubs.usgs.gov/sir/2011/5229/
#
#-------------------------------------------------------------------------------------------------------
#  NAWQA STUDY:		Principal Aquifer: Cambrian-Ordovician Aquifer System
#
#-------------------------------------------------------------------------------------------------------
#
#  METADATA DATE:    	July 28, 2011
#  METADATA CONTACT: 	John Wilson
#                    	USGS-WRD, Indiana Water Science Center 
#                    	5957 Lakeside Boulevard
#	 	     	Indianapolis, IN 46278	
#                    	voice: (317) 600-2752
#                    	fax:   (317) 290-3313
#                    	email:  jtwilson@usgs.gov
#
#  SECONDARY CONTACT:   Kelly Warner, Principal Aquifer Lead Scientist for Glacial Aquifer System, Cambrian-
#				      Ordovician Aquifer system, and New England Crystalline Aquifers 
#                    	USGS-WRD, Illinois Water Science Center 
#                       1201 West University Avenue, Suite 100       
#                       Urbana, IL 61801	
#                    	voice: (217) 328-9727
#                    	fax:   (217) 344-0082
#                    	email:  klwarner@usgs.gov
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Data Description:  
#
#   Abstract:	This data set contains NAWQA groundwater data for major ions, ammonia, nitrate, and dissolved
#		organic carbon that were used to evaluate the variability of concentrations in replicate pairs. 
#
#		Replicate pairs are comprised of an environmental sample and a replicate sample. A replicate
#		pair was included in the analysis if both the environmental sample and the replicate sample
#		had a quantifiable detection (non-detections were not used).
#
#		Data were retrieved from the NAWQA Internal Data Warehouse on or about April 23, 2010.
#		The data will be used in a report to characterize the Cambrian-Ordovician Aquifer System 
#		as part of the U.S. Geological Survey, National Water-Quality Assessment Program.
#
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#
#        The data was retrieved from the NAWQA Internal Data Warehouse on or about 
#        April 23, 2010. The Conditions used to retrieve the data are as follows:
#
#
#	 Suid IN (UMIS, EIWA, UIRB, WMIC)
#        Su Code IN (eiwasus3, eiwadwss1, uirbsus3, umisdwgs1, umissus3, umissus4, umistrn3, wmictrn, wmicsus1)
#	 Parameter Code IN = (00608, 00623, 00631, 00613, 00671, 00666, 71870, 00915, 00940, 00950, 01046, 00925,
#	 00935, 70300, 00955, 00930, 90095, 00945, 00403, 62854, 39086, 00453, 00452, 00300, 00095, 00010, 00400,
#	 00301, 00681, 00076, 63676, 63675, 00900, 07000)
#	 Groundwater Sites Only
#
#
#	 ***************************************************************************************************************
#	 *Analysis of NAWQA replicate pairs for major ions, ammonia, nitrate, and dissolved organic carbon uses        *
#	 *data available in the NAWQA Data Warehouse for the period 1995-2007.                                         *
#	 ***************************************************************************************************************
#
#
#
# Related_Spatial_and_Tabular_Data_Sets:  
#
#		camord_majors_nawqa_mdl.txt
#		camord_nutrients_nawqa_mdl.txt
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#
#	DATA FIELD LABELS:
#
#	suid	
#	staid
#	state
#	sucode
#	lat_dd
#	long_dd
#	altitude
#	well_depth
#	place_name
#	primary_aquifer
#	water_use
#	medium_code
#	sample_type
#	begin_date_time
#	ammonia_rmk
#	ammonia
#	nitrate_rmk
#	nitrate
#	doc_rmk
#	doc
#	bicarbonate
#	bromide_rmk
#	bromide
#	calcium_rmk
#	calcium
#	chloride_rmk
#	chloride
#	fluoride_rmk
#	fluoride
#	magnesium_rmk
#	magnesium
#	potassium_rmk
#	potassium
#	silica_rmk
#	silica
#	sodium_rmk
#	sodium
#	sulfate_rmk
#	sulfate
#	TDS_rmk
#	TDS
#
#
#     DATA TYPES: Note:  The row in the data file that follows the row of variable names describes the 
#                 width of the field and the data type. 
#			
#			Code:		Variable Type		Variable Length
#                 ----------------------------------------------------------------			
#			S or s 	text variable		numeric value preceding code 
#           		D or d	date variable		numeric value preceding code
#			N or n	numeric variable	numeric value preceding code
#									 
#                 For example: 15s indicates a 0- to 15-character text variable whereas
#                 9N indicates a 0- to 9-digit numeric variable.
#
#
#
#     DATA SOURCES: 	NAWQA Internal Data Warehouse: Water quality data and most ancillary well information
#
#			groundwater Site Inventory (GWSI) and on-line well log data bases from State Agencies:
#			well information and aquifer information used to modify lithology, primary_aquifer.
#
#
#
#---------------------------------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#---------------------------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  ANCILLARY WELL & AQUIFER INFORMATION
#
#
#       DATA FIELD LABEL:		suid		
#       Data Field Description:		NAWQA study unit identifier
#
#                			Code   Description
#                			-----  --------------------------------------------------
#                			eiwa   Eastern Iowa Basins
#                			uirb   Upper Illinois River Basin
#                			umis   Upper Mississippi River Basin
#                			wmic   Western Lake Michigan Drainages
#	Data Field Length/Type:		4S	
#	Data Units:			none	
#       Data Source:			NAWQA Data Warehouse		
#       Retrieval Date:			April 2010  
#
#		
#       DATA FIELD LABEL:		staid		
#       Data Field Description:		Primary well identifier	
#	Data Field Length/Type:		15S	
#	Data Units:			none	
#       Data Source:			NAWQA Data Warehouse			
#       Retrieval Date:			April 2010 
#		
#
#       DATA FIELD LABEL:  		state		
#       Data Field Description:		State where well is located
#	Data Field Length/Type:		12S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sucode	
#       Data Field Description:		Unique identifier for NAWQA groundwater network 
#	Data Field Length/Type:		10S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		lat_dd
#       Data Field Description:		Latitude, decimal degrees. Horizontal datum: NAD83.
#	Data Field Length/Type:		12N
#	Data Units:			decimal degrees
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		long_dd
#       Data Field Description:		Longitude, decimal degrees. Horizontal datum: NAD83.
#	Data Field Length/Type:		12N
#	Data Units:			decimal degrees
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		altitude
#       Data Field Description:		Altitude of land surface
#	Data Field Length/Type:		5N
#	Data Units:			Feet above sea level
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		well_depth 
#       Data Field Description:		Depth of well
#	Data Field Length/Type:		5N
#	Data Units:			Feet
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#	Data Field Length/Type:		15S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse & well logs, modified by JT Wilson
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		place_name
#       Data Field Description:		USGS name of well
#	Data Field Length/Type:		55S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		primary_aquifer
#       Data Field Description:		Aquifers and formations within the open interval
#
#       				ABBREV    	Description
#       				------    	-----------------
#					STPR		St. Peter Sandstone (Middle Ordovician)
#					PDC		Prairie du Chien (Lower Ordovician)
#					JRDN		Jordan Sandstone (Cambrian)
#					SLRC		St. Lawrence (Cambrian)
#					TNC		Tunnel city Group (Cambrian)
#
#	Data Field Length/Type:		45S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse water-quality data retrieval and modified by JT Wilson
#					after viewing well logs. Some abbreviations used to shorten text string.
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		water_use
#       Data Field Description:		Primary use of sampled well
#	Data Field Length/Type:		15S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse			
#       Retrieval Date:  		April 2010
#
#		
#--------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  SAMPLE INFORMATION
#
#
#       DATA FIELD LABEL:  		medium_code
#       Data Field Description:		sample medium code
#
#       				Code    	Description
#       				----    	-----------------
#					WG		Regular groundwater
#					WGQ		Quality-control sample
#
#	Data Field Length/Type:		4S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse			
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sample_type
#       Data Field Description:		sample type
#
#       				Type
#       				-----------------
#					Regular
#					Replicate
#					Duplicate
#
#	Data Field Length/Type:		12S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse			
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		begin_date_time
#       Data Field Description:		Date and time sample was collected
#	Data Field Length/Type:		16S
#	Data Units:			YYYY-MM-DD HHMM
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#------------------------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  WATER QUALITY PARAMETERS, NUTRIENTS & DISSOLVED ORGANIC CARBON
#
#
#       DATA FIELD LABEL:  		ammonia_rmk
#       Data Field Description:		remark code for ammonia value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		ammonia
#       Data Field Description:		ammonia, pcode 00608
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		nitrate_rmk
#       Data Field Description:		remark code for nitrate (nitrate + nitrite) value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		nitrate
#       Data Field Description:		nitrate + nitrite, pcode 00631
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		doc_rmk
#       Data Field Description:		remark code for dissolved organic carbon value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		doc
#       Data Field Description:		dissolved organic carbon, pcode 00681
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#------------------------------------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  WATER QUALITY PARAMETERS, MAJOR IONS AND TDS
#
#
#       DATA FIELD LABEL:  		bicarbonate
#       Data Field Description:		bicarbonate, pcode 00453
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		bromide_rmk
#       Data Field Description:		remark code for bromide value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		bromide
#       Data Field Description:		bromide, pcode 71870
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		calcium_rmk
#       Data Field Description:		remark code for calcium value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		calcium
#       Data Field Description:		calcium, pcode 00915
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		chloride_rmk
#       Data Field Description:		remark code for chloride value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		chloride
#       Data Field Description:		chloride, pcode 00940
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		fluoride_rmk
#       Data Field Description:		remark code for fluoride value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		fluoride
#       Data Field Description:		fluoride, pcode 00950
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		magnesium_rmk
#       Data Field Description:		remark code for magnesium value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		magnesium
#       Data Field Description:		magnesium, pcode 00925
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		potassium_rmk
#       Data Field Description:		remark code for potassium value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		potassium
#       Data Field Description:		potassium, pcode 00935
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		silica_rmk
#       Data Field Description:		remark code for silica value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		silica
#       Data Field Description:		silica, pcode 00955
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sodium_rmk
#       Data Field Description:		remark code for sodium value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sodium
#       Data Field Description:		sodium, pcode 00930
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sulfate_rmk
#       Data Field Description:		remark code for sulfate value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		sulfate
#       Data Field Description:		sulfate, pcode 00945
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		TDS
#       Data Field Description:		Total dissolved solids (residue on evaporation at 180 degrees Celcius), pcode 70300
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#------------------------------------------------------------------------------------------------------------
#       DATA FIELD GROUP:  WATER QUALITY PARAMETER REMARK CODES
#
#	Data Source: USGS/NAWQA Data warehouse
#	RETRIEVAL DATE: April 23, 2010
#
#
#	Attribute label: name_rmk (All variables of the form name_rmk, where name is the constituent name)	
#	
#	Attribute description: Remark code associated with each parameter value
#       Source: NAWQA Data Warehouse water-quality data retrieval
#	
#                Code     Description	
#                -----    --------------------------------------------------------------------------------	
#                <        Not Detected. Value reported as less than the Laboratory Reporting Level.	
#
#                -	  Detected.	
#
#                E        Detected. Concentration is estimated. Estimated concentration may result from	
#                         any of the following reasons:	
#                         1. The compound is characterized as a "poor performer" in the method on the 	
#                            basis of laboratory QC samples. In general compounds with less than 60 %	
#                            recovery, greater than 120 % recovery, or greater than 25 % relative standard	
#                            deviation of recovery are considered poor performers. All detections of	
#                            these compounds are remarked E.	
#                         2. The compound was detected at a concentration less than the reporting level	
#                            or less than the lowest calibration standard.	
#                         3. The sample was diluted to bring the concentration into the calibration range.	
#	
#
#	
#
#
#----------------------------------------------------------------------------------------------------------------
# NOTE: Columns are separated by tabs. If you open file in an ascii reading program, the columns might not align
#       correctly. Be sure to use 'tab delimited' when importing data file into spreadsheet-style programs. 
#-----------------------------------------------------------------------------------------------------------------
#                         
#
#  End METADATA documentation
#
#  BEGIN DATA: camord_majors_nutrients_nawqa_replicates.txt
# ------------------------------------------------------------------------------------------------------
suid	staid	state	sucode	lat_dd	long_dd	altitude	well_depth	place_name	primary_aquifer	water_use	medium_code	sample_type	begin_date_time	ammonia_rmk	ammonia	nitrate_rmk	nitrate	doc_rmk	doc	bicarbonate	bromide_ rmk	bromide	calcium_ rmk	calcium	chloride_ rmk	chloride	fluoride_rmk	fluoride	magnesium_ rmk	magnesium	potassium_rmk	potassium	silica_ rmk	silica	sodium_ rmk	sodium	sulfate_ rmk	sulfate	TDS
4S	15S	12S	10S	12N	12N	5N	5N	55S	45S	15S	4S	12S	16S	1S	9N	1S	9N	1S	9N	9N	1S	9N	1S	9N	1S	9N	1S	9N	1S	9N	1S	9N	1S	9N	1S	9N	1S	9N	9N
EIWA	430800092540301	IOWA	eiwasus3	43.1296926	-92.9021415	1123	1288	096N17W18CDBA 09845 1958RUDD 2	JORDAN SANDSTONE	PUBLIC SUPPLY	WG	REPLICATE	2005-07-11 1300	<	0.04	-	0.349	-	0.3802	237.8	E	0.0141	-	69.78	-	1.459	-	0.769	-	27.59	-	7.259	-	7.904	-	15.41	-	56.306	345.93
EIWA	430800092540301	IOWA	eiwasus3	43.1296926	-92.9021415	1123	1288	096N17W18CDBA 09845 1958RUDD 2	JORDAN SANDSTONE	PUBLIC SUPPLY	WGQ	REPLICATE	2005-07-11 1305	<	0.04	-	0.341	-	0.3569	311.4	-	0.15012	-	69.04	-	1.383	-	0.766	-	27.6	-	7.516	-	7.421	-	15.61	-	56.463	337.63
EIWA	432339094500101	IOWA	eiwasus3	43.3941256	-94.8338751	1280	750	099N34W14BCDB 39723 1972ESTHERVILLE 10	ORDOVICIAN-CHAMBRIAN SYSTEMS	PUBLIC SUPPLY	WG	REPLICATE	2005-07-12 1630	-	1.649	<	0.06	-	2.2589	494.8	-	0.0847	-	227.7	-	2.225	-	0.44	-	71.7	-	5.517	-	24.19	-	58.43	-	549.259	1259.3
EIWA	432339094500101	IOWA	eiwasus3	43.3941256	-94.8338751	1280	750	099N34W14BCDB 39723 1972ESTHERVILLE 10	ORDOVICIAN-CHAMBRIAN SYSTEMS	PUBLIC SUPPLY	WGQ	REPLICATE	2005-07-12 1635					-	2.2466	489.6																			
EIWA	432339094500101	IOWA	eiwasus3	43.3941256	-94.8338751	1280	750	099N34W14BCDB 39723 1972ESTHERVILLE 10	ORDOVICIAN-CHAMBRIAN SYSTEMS	PUBLIC SUPPLY	WGQ	DUPLICATE	2005-07-12 1640							494.5																			
EIWA	432501093320001	IOWA	eiwasus3	43.4168991	-93.5335458	1275	460	099N23W02CCDB 25699 1979LAKE MILLS 3	ORDOVICIAN SYSTEM	PUBLIC SUPPLY	WG	REPLICATE	2005-07-06 1015	-	0.46	<	0.05	-	1.801	458.1	-	0.0241	-	100.4	<	1	-	0.352	-	36.54	-	2.5	-	19.48	-	21	-	37	420
EIWA	432501093320001	IOWA	eiwasus3	43.4168991	-93.5335458	1275	460	099N23W02CCDB 25699 1979LAKE MILLS 3	ORDOVICIAN SYSTEM	PUBLIC SUPPLY	WGQ	REPLICATE	2005-07-06 1020	-	0.792	<	0.06	-	1.8996	457.7	-	0.0214	-	98.88	-	0.784	-	0.357	-	36.66	-	2.432	-	19.48	-	18.77	-	37.758	424.18
UIRB	431638091282801	IOWA	uirbsus3	43.2771984	-91.4745838	1285	662	098N05W30ACDC 08170 1957WAUKON 4	JORDAN SANDSTONE	PUBLIC SUPPLY	WG	REPLICATE	2007-09-12 1100	<	0.02	-	1.368	E	0.2954	316.4	E	0.0196	-	83.11	-	8.042	-	0.144	-	20.85	-	0.926	-	13.01	-	4.322	-	18.871	319.4
UIRB	431638091282801	IOWA	uirbsus3	43.2771984	-91.4745838	1285	662	098N05W30ACDC 08170 1957WAUKON 4	JORDAN SANDSTONE	PUBLIC SUPPLY	WGQ	REPLICATE	2007-09-12 1101	<	0.02	-	1.349	-	0.4016		-	0.0202	-	82.43	-	8.09	-	0.139	-	20.76	-	0.914	-	13.26	-	4.246	-	18.996	321.64
UIRB	405427090385501	ILLINOIS	uirbsus3	40.9075382	-90.6487465	761	2445	11N 2W-29.8A1	ORDOVICIAN-CAMBRIAN SYSTEMS	PUBLIC SUPPLY	WG	REPLICATE	2007-10-02 0900	-	1.09178	<	0.04	E	0.2518		-	0.446	-	61.23	-	110.565	-	1.73	-	27.72	-	14.27	-	8.491	-	237.6	-	420.5	1071.42
UIRB	405427090385501	ILLINOIS	uirbsus3	40.9075382	-90.6487465	761	2445	11N 2W-29.8A1	ORDOVICIAN-CAMBRIAN SYSTEMS	PUBLIC SUPPLY	WGQ	REPLICATE	2007-10-02 0901					E	0.3203																				
UIRB	412421090334401	ILLINOIS	uirbsus3	41.4269781	-90.5648577	665	1739	17N 2W-36.7H1	ORDOVICIAN-CAMBRIAN SYSTEMS	PUBLIC SUPPLY	WG	REPLICATE	2007-09-25 1000	-	1.41999	<	0.06	<	0.4		-	1.1667	-	67.01	-	348.641	-	1.149	-	32.41	-	15.7	-	8.799	-	291.9	-	207.643	1109.79
UIRB	412421090334401	ILLINOIS	uirbsus3	41.4269781	-90.5648577	665	1739	17N 2W-36.7H1	ORDOVICIAN-CAMBRIAN SYSTEMS	PUBLIC SUPPLY	WGQ	REPLICATE	2007-09-25 1001	-	1.36702	<	0.06	<	0.4		-	1.1967	-	67.02	-	349.313	-	1.139	-	31.97	-	15.65	-	8.785	-	293.6	-	207.141	1133.38
UMIS	443112092513901	MINNESOTA	umissus3	44.5185639	-92.8673750	883	339	PDCJ-U16 112N17W09CAADDA01 0000162685	JORDAN SANDSTONE	DOMESTIC	WG	REPLICATE	1996-08-29 1000	-	0.02	<	0.05	-	0.4	338.9	-	0.09	-	77	-	0.5	-	0.2	-	28	-	1.3	-	13	-	2.1	-	27	318
UMIS	443112092513901	MINNESOTA	umissus3	44.5185639	-92.8673750	883	339	PDCJ-U16 112N17W09CAADDA01 0000162685	JORDAN SANDSTONE	DOMESTIC	WGQ	REPLICATE	1996-08-29 1001	-	0.02	<	0.05	-	0.5	343.8	-	0.07	-	76	-	0.6	-	0.2	-	28	-	1.2	-	13	-	2.1	-	27	318
UMIS	443328093184701	MINNESOTA	umissus3	44.5577833	-93.3129444	1140	235	PDCJ-U02 113N21W35BABCBA01 W812 0000212377		DOMESTIC	WG	REGULAR	2007-04-24 1100	-	0.85669	<	0.06	-	1.7746	466.4	E	0.0124	-	91.81	-	0.419	-	0.407	-	29.73	-	3.169	-	19.46	-	11.03	-	6.951	427.67
UMIS	443328093184701	MINNESOTA	umissus3	44.5577833	-93.3129444	1140	235	PDCJ-U02 113N21W35BABCBA01 W812 0000212377		DOMESTIC	WGQ	REPLICATE	2007-04-24 1102	-	0.86708	<	0.06	-	1.6701	466.4	E	0.0131	-	95.45	-	0.424	-	0.413	-	30.73	-	3.347	-	19.5	-	11.39	-	6.795	447.65
UMIS	443641093110701	MINNESOTA	umissus4	44.6119667	-93.1857139	932	110	PDCJ-C11 113N20W11ACBDDA01 W805 0000119678		DOMESTIC	WG	REPLICATE	1996-09-04 1000	-	0.04	-	0.08	-	0.4	338.9	-	0.05	-	71	-	0.4	-	0.2	-	25	-	1.3	-	16	-	4.2	-	8.7	289
UMIS	443641093110701	MINNESOTA	umissus4	44.6119667	-93.1857139	932	110	PDCJ-C11 113N20W11ACBDDA01 W805 0000119678		DOMESTIC	WGQ	REPLICATE	1996-09-04 1001	-	0.04	-	0.08	-	0.3	338.9	-	0.05	-	73	-	0.4	-	0.2	-	25	-	1.3	-	16	-	4.1	-	8.7	287
UMIS	443703092261301	WISCONSIN	umissus3	44.6177806	-92.4400972	740	140	PDCT-U6 025N17W28DD 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WG	REPLICATE	2007-10-11 1200	<	0.02	-	0.135	-	0.4387	361.4	E	0.0126	-	68.36	-	1.501	E	0.109	-	34.44	-	1.502	-	13.57	-	2.049	-	12.964	326.72
UMIS	443703092261301	WISCONSIN	umissus3	44.6177806	-92.4400972	740	140	PDCT-U6 025N17W28DD 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WGQ	REPLICATE	2007-10-11 1202	<	0.02	-	0.139	E	0.3042	356.7	E	0.0108	-	68.91	-	1.533	E	0.099	-	34.82	-	1.514	-	13.63	-	2.072	-	12.94	322.62
UMIS	445933092222301	WISCONSIN	umissus3	44.9925722	-92.3739389	1160	104	PDCT-U5 029N16W18CC 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WG	REPLICATE	2007-10-15 0900	E	0.01018	-	5.328	-	1.2665	183.3	E	0.0139	-	47.46	-	13.656	E	0.08	-	17.59	-	3.065	-	10.83	-	5.114	-	11.836	222.58
UMIS	445933092222301	WISCONSIN	umissus3	44.9925722	-92.3739389	1160	104	PDCT-U5 029N16W18CC 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WGQ	REPLICATE	2007-10-15 0902	<	0.02	-	5.446	-	1.231	172.2	E	0.0198	-	47.76	-	13.653	E	0.075	-	17.41	-	3.069	-	10.9	-	5.012	-	11.917	239.08
UMIS	450332093124401	MINNESOTA	umisdwgs1	45.0589722	-93.2121111		345	NBRGHTN15030N23W30ADC 0000582628	PRAIRIE DU CHIEN FORMATION	PUBLIC SUPPLY	WG	REGULAR	2004-11-10 1330	-	0.136	<	0.06	-	1.0715	339	-	0.033	-	72.58	-	13.499	-	0.217	-	30.08	-	2.141	-	23.74	-	6.638	-	19.988	340.28
UMIS	450332093124401	MINNESOTA	umisdwgs1	45.0589722	-93.2121111		345	NBRGHTN15030N23W30ADC 0000582628	PRAIRIE DU CHIEN FORMATION	PUBLIC SUPPLY	WGQ	REPLICATE	2004-11-10 1332	-	0.134	<	0.06	-	1.0323		-	0.029	-	71.3	-	13.474	-	0.239	-	29.63	-	2.13	-	23.48	-	6.534	-	20.066	340.49
UMIS	450520092543401	MINNESOTA	umissus4	45.0887528	-92.9095694	1001	175	PDCJ-C15 030N21W15ACADDB01 0000413597		DOMESTIC	WG	REPLICATE	1996-08-06 1300	<	0.015	-	8.4	-	0.4	137.8	-	0.03	-	43	-	12	-	0.2	-	19	-	0.8	-	24	-	3.4	-	21	231
UMIS	450520092543401	MINNESOTA	umissus4	45.0887528	-92.9095694	1001	175	PDCJ-C15 030N21W15ACADDB01 0000413597		DOMESTIC	WGQ	REPLICATE?	1996-08-06 1301	<	0.015	-	8.3	-	0.4	148.7	-	0.03	-	44	-	12	-	0.2	-	19	-	0.9	-	25	-	3.4	-	21	228
UMIS	450635092302201	WISCONSIN	umissus3	45.1097139	-92.5064722	1000	77	PDCT-U2 030N18W01CD 01 FK 344	PRAIRIE DU CHIEN GROUP	DOMESTIC	WG	REPLICATE	2007-10-15 1200	E	0.01222	-	11.779	-	0.6689	248.5	-	0.0214	-	62.16	-	19.594	E	0.094	-	31.97	-	0.951	-	18.43	-	3.339	-	10.134	325.78
UMIS	450635092302201	WISCONSIN	umissus3	45.1097139	-92.5064722	1000	77	PDCT-U2 030N18W01CD 01 FK 344	PRAIRIE DU CHIEN GROUP	DOMESTIC	WGQ	REPLICATE	2007-10-15 1202	<	0.02	-	11.698	-	0.4268	247	-	0.0219	-	60.07	-	19.435	E	0.107	-	30.96	-	0.915	-	18.42	-	3.235	-	10.167	313.51
UMIS	451027092142901	WISCONSIN	umissus3	45.1738333	-92.2413444	1160	180	PDCT-U8 031N15W17DA 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WG	REPLICATE	1996-08-08 1100	-	0.02	-	2.4	-	0.4		-	0.02	-	40	-	4	<	0.1	-	18	-	0.6	-	19	-	2.2	-	6.4	195
UMIS	451027092142901	WISCONSIN	umissus3	45.1738333	-92.2413444	1160	180	PDCT-U8 031N15W17DA 01	PRAIRIE DU CHIEN GROUP	DOMESTIC	WGQ	REPLICATE	1996-08-08 1101	-	0.02	-	2.4	-	0.6		-	0.02	-	37	-	3.8	<	0.1	-	18	-	0.6	-	19	-	2.4	-	6.4	190
WMIC	433542089204601	WISCONSIN	wmicsus1	43.5951111	-89.3462222	829	123	CO-13/10E/19-0737	SANDSTONE	DOMESTIC	WG	REPLICATE	2005-06-13 1015	<	0.04	-	2.943				E	0.0172	-	52.64	-	5.938	-	0.106	-	31.63	-	1.46	-	14.43	-	1.57	-	6.934	261.02
WMIC	433542089204601	WISCONSIN	wmicsus1	43.5951111	-89.3462222	829	123	CO-13/10E/19-0737	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2005-06-13 1016	<	0.04	-	2.94				E	0.0122	-	54.84	-	5.926	E	0.096	-	30.01	-	1.341	-	13.79	-	1.512	-	6.917	252.29
WMIC	435907088462502	WISCONSIN	wmicsus1	43.9849722	-88.7758056	831	102	WI-18/14E/36-0841	SANDSTONE	DOMESTIC	WG	REPLICATE	2002-05-23 1100	<	0.04	-	11.919	-	0.7979		-	0.045	-	107.59295	-	46.88	E	0.074	-	57.67572	-	2.3	-	20.00794	-	12.59257	-	56.24	579.82
WMIC	435907088462502	WISCONSIN	wmicsus1	43.9849722	-88.7758056	831	102	WI-18/14E/36-0841	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-05-23 1101	<	0.04	-	11.931	-	0.79																				
WMIC	440015089053301	WISCONSIN	wmicsus1	44.0040000	-89.0925000	800	95	WS-18/12E/29-1006	SANDSTONE	DOMESTIC	WG	REPLICATE	2002-05-22 1010	<	0.04	-	19.293	-	1.0196		E	0.0282	-	67.85717	-	13.56	E	0.0966	-	34.12534	-	1.43	-	14.893	-	25.88964	-	23.22	430.19
WMIC	440015089053301	WISCONSIN	wmicsus1	44.0040000	-89.0925000	800	95	WS-18/12E/29-1006	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-05-22 1011	<	0.04	-	18.485	-	0.9398		-	0.031	-	67.88984	-	13.81	E	0.0966	-	35.13103	-	1.47	-	15.025	-	26.09679	-	23.84	410.37
WMIC	442912088224101	WISCONSIN	wmicsus1	44.4864444	-88.3780278	785	114	OU-23/17E/12-0202	SANDSTONE	DOMESTIC	WG	REPLICATE	1995-06-14 1200	-	0.1	<	0.05	-	1.2		-	0.03	-	78	-	1.6	-	0.3	-	38	-	3	-	16	-	3.2	-	93	385
WMIC	442912088224101	WISCONSIN	wmicsus1	44.4864444	-88.3780278	785	114	OU-23/17E/12-0202	SANDSTONE	DOMESTIC	WGQ	DUPLICATE	1995-06-14 1201	-	0.09	<	0.05	-	1.2		-	0.03	-	78	-	1.5	-	0.3	-	38	-	2.9	-	16	-	3.3	-	93	402
WMIC	451154087361501	MICHIGAN	wmicsus1	45.1984722	-87.6047500	640	432	32N 27W 02 AAC 01	SANDSTONE	DOMESTIC	WG	REPLICATE	2002-06-25 1000	-	0.295	<	0.05	E	0.2207		-	0.4194	-	550.44	-	67.17	-	1.45	-	111.73	-	6.22	-	22.32	-	59.15	-	1704.21	2862.69
WMIC	451154087361501	MICHIGAN	wmicsus1	45.1984722	-87.6047500	640	432	32N 27W 02 AAC 01	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-06-25 1001					E	0.2237		-	0.4083	-	557.89	-	66.97	-	1.61	-	137.75	-	5.91	-	22.614	-	59.755	-	1705.24	2875.47
WMIC	453101087414901	MICHIGAN	wmicsus1	45.5169722	-87.6972222	790	123	36N 28W 13 ADA 01	SANDSTONE	DOMESTIC	WG	REGULAR	1995-06-19 1400	-	0.04	<	0.05	-	1		-	0.09	-	64	-	2.9	<	0.1	-	28	-	0.8	-	11	-	1.9	-	16	272
WMIC	453101087414901	MICHIGAN	wmicsus1	45.5169722	-87.6972222	790	123	36N 28W 13 ADA 01	SANDSTONE	DOMESTIC	WGQ	DUPLICATE	1995-06-19 1401	-	0.04	<	0.05	-	1.1		-	0.07	-	64	-	3.1	<	0.1	-	28	-	0.8	-	11	-	1.9	-	16	273
