#  Begin METADATA documentation
#------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	camord_radium_nawqa_blanks.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 radium-226 and radium-228 that were 
#		used to evaluate Field Blanks.
#
#		Data were retrieved from the NAWQA Internal Data Warehouse on or about April 28, 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 28, 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)
#	 Sample Type = Blank
#	 Groundwater Sites Only
#	 Parameter Code IN = (09511, 81366)
#
#
#	 **************************************************************************************
#	 *Analysis of NAWQA replicate pairs for radium uses data available in the NAWQA Data  * 
#	 *Warehouse for the period 2005-2007.                                                 *
#	 **************************************************************************************
#
#
#
# Related_Spatial_and_Tabular_Data_Sets:  
#
#		camord_radium_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
#	RL_226
#	radium226_rmk
#	radium226
#	LabStdDev_226
#	RL_228
#	radium228_rmk
#	radium228
#	LabStdDev_228
#
#
#     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
#       				----    	-----------------
#					OAQ		Blank water
#
#	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
#       				-----------------
#					Blank
#
#	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, RADIUM
#		
#
#       DATA FIELD LABEL:  		RL_226
#       Data Field Description:		reporting level for radium-226  
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radium226_rmk
#       Data Field Description:		remark code for radium-226 value, see explanation of remark codes below
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radium226
#       Data Field Description:		radium-226, pcode 09511
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		LabStdDev_226
#       Data Field Description:		laboratory standard deviation for radium-226  
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		RL_228
#       Data Field Description:		reporting level for radium-228 
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radium228_rmk
#       Data Field Description:		remark code for radium-228 value, see explanation of remark codes below
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		radium228
#       Data Field Description:		radium-228, pcode 81366
#	Data Field Length/Type:		9N
#	Data Units:			picocuries per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		April 2010
#		
#
#       DATA FIELD LABEL:  		LabStdDev_228
#       Data Field Description:		laboratory standard deviation for radium-228 
#	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_radium_nawqa_blanks.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	RL_226	radium226_rmk	radium_226	LabStdDev_226	RL_228	radium228_rmk	radium228	LabStdDev_228
EIWA	430800092540301	IOWA	eiwasus3	43.1296926	-92.9021415	1123.00	1288.00000	096N17W18CDBA 09845 1958RUDD 2	JORDAN SANDSTONE	PUBLIC SUPPLY	OAQ	BLANK	2005-07-11 1240	0.015	-	0.04	0.012	0.29	<	0.29	0.12
UIRB	425100091490001	IOWA	uirbsus3	42.8416477	-91.8109965	1068.00	1238.00000	093N08W29ACAD 17048 1964FAYETTE 2	JORDAN SANDSTONE	PUBLIC SUPPLY	OAQ	BLANK	2007-09-18 1005	0.017	-	0.093	0.017	0.2	<	0.2	0.085
