#  Begin METADATA documentation
#------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	camord_radon_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 radon-222 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 29, 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 29, 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)
#	 Groundwater Sites Only
#	 Parameter Code IN = (76002, 82303)
#
#
#	 *************************************************************************************
#	 *Analysis of NAWQA replicate pairs for radon-222 uses                               *
#	 *data available in the NAWQA Data Warehouse for the period 1995-2007.               *
#	 *************************************************************************************
#
#
#
# Related_Spatial_and_Tabular_Data_Sets:  
#
#		camord_radon_nawqa.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
#	radon_rmk
#	radon
#	radon_prec
#
#
#     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 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 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, RADON-222
#		
#
#       DATA FIELD LABEL:  		radon_rmk
#       Data Field Description:		remark code for radon value
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radon
#       Data Field Description:		radon-222, pcode 82303 
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radon_prec
#       Data Field Description:		radon-222 2-sigma combined standard uncertainty, pcode 76002 
#	Data Field Length/Type:		9N
#	Data Units:			picocuries 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 29, 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_radon_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	radon_rmk	radon	radon_prec
4S	15S	12S	10S	12N	12N	5N	5N	55S	45S	15S	4S	12S	16S	1S	9N	9N
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	-	458	37
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	-	422	36
EIWA	430800092540301	IOWA	eiwasus3	43.1296926	-92.9021415	1123	1288	096N17W18CDBA 09845 1958RUDD 2	JORDAN SANDSTONE	PUBLIC SUPPLY	WG	REPLICATE	2005-07-11 1300	-	57	14
EIWA	430800092540301	IOWA	eiwasus3	43.1296926	-92.9021415	1123	1288	096N17W18CDBA 09845 1958RUDD 2	JORDAN SANDSTONE	PUBLIC SUPPLY	WGQ	REPLICATE	2005-07-11 1305	-	64	15
UIRB	431638091282801	IOWA	uirbsus3	43.2771984	-91.4745838	1285	662	098N05W30ACDC 08170 1957WAUKON 4	JORDAN SANDSTONE	PUBLIC SUPPLY	WG	REPLICATE	2007-09-12 1100	-	148	20
UIRB	431638091282801	IOWA	uirbsus3	43.2771984	-91.4745838	1285	662	098N05W30ACDC 08170 1957WAUKON 4	JORDAN SANDSTONE	PUBLIC SUPPLY	WGQ	REPLICATE	2007-09-12 1101	-	133	19
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	-	83	16
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	-	89	16
UMIS	450520092543401	MINNESOTA	umissus4	45.0887528	-92.9095694	1001	175	PDCJ-C15 030N21W15ACADDB01 0000413597		DOMESTIC	WG	REPLICATE	1996-08-06 1300	-	690	28
UMIS	450520092543401	MINNESOTA	umissus4	45.0887528	-92.9095694	1001	175	PDCJ-C15 030N21W15ACADDB01 0000413597		DOMESTIC	WGQ	SPIKE	1996-08-06 1301	-	740	29
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	-	550	25
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	-	550	25
UMIS	443112092513901	MINNESOTA	umissus3	44.5185639	-92.8673750	883	339	PDCJ-U16 112N17W09CAADDA01 0000162685	JORDAN SANDSTONE	DOMESTIC	WG	REPLICATE	1996-08-29 1000	-	230	29
UMIS	443112092513901	MINNESOTA	umissus3	44.5185639	-92.8673750	883	339	PDCJ-U16 112N17W09CAADDA01 0000162685	JORDAN SANDSTONE	DOMESTIC	WGQ	REPLICATE	1996-08-29 1001	-	280	30
UMIS	443641093110701	MINNESOTA	umissus4	44.6119667	-93.1857139	932	110	PDCJ-C11 113N20W11ACBDDA01 W805 0000119678		DOMESTIC	WG	REPLICATE	1996-09-04 1000	-	190	19
UMIS	443641093110701	MINNESOTA	umissus4	44.6119667	-93.1857139	932	110	PDCJ-C11 113N20W11ACBDDA01 W805 0000119678		DOMESTIC	WGQ	REPLICATE	1996-09-04 1001	-	170	19
UMIS	443042092570401	MINNESOTA	umissus3	44.5116139	-92.9510806	862	320	PDCJ-U09 112N18W14BADCAB01 0000145903	JORDAN SANDSTONE	DOMESTIC	WG	REGULAR	2002-08-05 1030	-	250	20
UMIS	443042092570401	MINNESOTA	umissus3	44.5116139	-92.9510806	862	320	PDCJ-U09 112N18W14BADCAB01 0000145903	JORDAN SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-08-05 1031	-	232	20
WMIC	435602089165401	WISCONSIN	wmicsus1	43.9340556	-89.4679444	895	179	MQ-17/09E/19-0107	SANDSTONE	DOMESTIC	WG	REGULAR	1995-06-13 0940	-	150	17
WMIC	435602089165401	WISCONSIN	wmicsus1	43.9340556	-89.4679444	895	179	MQ-17/09E/19-0107	SANDSTONE	DOMESTIC	WGQ	DUPLICATE	1995-06-13 0941	-	150	17
WMIC	441500088074201	WISCONSIN	wmicsus1	44.2501389	-88.1707778	760	675	BN-21/19E/35-0300	SANDSTONE	PUBLIC SUPPLY	WG	REGULAR	1995-06-14 1300	-	230	22
WMIC	441500088074201	WISCONSIN	wmicsus1	44.2501389	-88.1707778	760	675	BN-21/19E/35-0300	SANDSTONE	PUBLIC SUPPLY	WGQ	DUPLICATE	1995-06-14 1301	-	210	22
WMIC	450533088020501	WISCONSIN	wmicsus1	45.0938611	-88.0340000	690	346	MT-30/20E/11-0029	SANDSTONE	PUBLIC SUPPLY	WG	REGULAR	1995-06-15 1030	-	690	47
WMIC	450533088020501	WISCONSIN	wmicsus1	45.0938611	-88.0340000	690	346	MT-30/20E/11-0029	SANDSTONE	PUBLIC SUPPLY	WGQ	DUPLICATE	1995-06-15 1031	-	610	43
WMIC	453542087324401	MICHIGAN	wmicsus1	45.5952778	-87.5483889	865	483	37N 26W 17 CDC 01	SANDSTONE	PUBLIC SUPPLY	WG	REGULAR	1995-06-15 1330	-	580	43
WMIC	453542087324401	MICHIGAN	wmicsus1	45.5952778	-87.5483889	865	483	37N 26W 17 CDC 01	SANDSTONE	PUBLIC SUPPLY	WGQ	DUPLICATE	1995-06-15 1331	-	620	43
WMIC	435907088462502	WISCONSIN	wmicsus1	43.9849722	-88.7758056	831	102	WI-18/14E/36-0841	SANDSTONE	DOMESTIC	WG	REPLICATE	2002-05-23 1100	-	1466	84
WMIC	435907088462502	WISCONSIN	wmicsus1	43.9849722	-88.7758056	831	102	WI-18/14E/36-0841	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-05-23 1101	-	1495	86
WMIC	451154087361501	MICHIGAN	wmicsus1	45.1984722	-87.6047500	640	432	32N 27W 02 AAC 01	SANDSTONE	DOMESTIC	WG	REPLICATE	2002-06-25 1000	-	527	25
WMIC	451154087361501	MICHIGAN	wmicsus1	45.1984722	-87.6047500	640	432	32N 27W 02 AAC 01	SANDSTONE	DOMESTIC	WGQ	REPLICATE	2002-06-25 1001	-	525	25
