#  Begin METADATA documentation
#------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	camord_nawqa_rasa_majors.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).
#
#			Water-quality data in this data set are from samples collected in Iowa by the
#			NAWQA Program or the USGS's Regional Aquifer-System Analysis (RASA) Program
#			
#
#  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 20, 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 groundwater data for major ions and TDS at six wells in Iowa.  
#		The wells were sampled by the Regional Aquifer-System Analysis (RASA) Program
#		in 1980 or 1981. The wells were later sampled by the NAWQA Program in 2005 or 2007.
#		The data are used in an analysis of the temporal variability of major ions. 
#
#
#		Data were retrieved from the NAWQA Internal Data Warehouse on or about February 13, 2008.
#		RASA data were obtained from the data table in the RASA report: 
#		Siegel, D.I., 1989, Geochemistry of the Cambrian-Ordovician aquifer system in the Northern
#		Midwest, United States: U.S. Geological Survey Professional Paper 1405-D.
#  
#		The data will be used in a report to characterize the water quality of the Cambrian-Ordovician 
#		Aquifer System as part of the U.S. Geological Survey, National Water-Quality Assessment Program.
#
#
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#
#
#
#
#
# Related_Spatial_and_Tabular_Data_Sets:  
#
#		camord_majors_nawqa.txt
#		camord_majors_nutrients_all.txt
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#
#	DATA FIELD LABELS:
#
#	mapno	
#	staid
#	state
#	source
#	lat_dd
#	long_dd
#	altitude
#	well_depth
#	lithology
#	place_name
#	primary_aquifer
#	group
#	aquifer_range
#	water_use
#	well_type
#	date
#	time
#	bicarbonate
#	TDS
#	hardness
#	calcium
#	chloride
#	fluoride
#	magnesium
#	potassium
#	silica
#	sodium
#	sulfate
#	
#
#
#     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, 
#			group, aquifer_range
#
#
#
#---------------------------------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#---------------------------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  ANCILLARY WELL & AQUIFER INFORMATION
#
#
#       DATA FIELD LABEL:		mapno 		
#       Data Field Description:		Arbitrary number assigned to well for map labels, numbers generally increase in order of suid and staid 		
#	Data Field Length/Type:		4N
#	Data Units:			none	
#       Data Source:			Assigned by JT Wilson		
#       Retrieval Date:			none
#
#		
#       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:			February 2008 
#		
#
#       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:  		February 2008
#		
#
#       DATA FIELD LABEL:  		source
#       Data Field Description:		Source of water-quality data (NAWQA, RASA)
#	Data Field Length/Type:		6S
#	Data Units:			none
#       Data Source: 			Assigned by JT Wilson
#       Retrieval Date:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       DATA FIELD LABEL:  		lithology
#       Data Field Description:		Lithology (rock types) of open interval
#
#       				Code    	Description
#       				----    	-----------------
#					DLMT		Dolomite
#					LMSN		Limestone
#					SNDS		Sandstone
#					SHLE		Shale
#					SLSN		Siltstone
#
#	Data Field Length/Type:		15S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse & well logs, modified by JT Wilson
#       Retrieval Date:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       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:  		February 2008
#		
#
#       DATA FIELD LABEL:  		group		
#       Data Field Description:		Mostly Group name(s) for aquifer and other formations in the open interval,
#			       		but also uses names that are not Group names to identify a range of Groups 
#
#       				Code    	Description
#       				----    	-----------------
#					OMAQ, MAQ	Maquoketa (Upper Ordovician)
#					OSIN, SIN	Sinnipee (Middle Ordovician)
#					OANC, ANC	Ancell (Middle Ordovician)
#					OPDC, PDC	Prairie du Chien (Lower Ordovician)
#					OCMPL		Champlainian Series: Upper Ordovician through Middle Ordovician,
#								Maquoketa Shale through St. Peter Sandstone
#					ORDO		Ordovician rocks
#					CAMORD		Ordovician-Cambrian Rocks
#					CTMP, TMP	Trempealeau (Cambrian)
#					CTNC, TNC	Tunnel City (Cambrian)
#					CEKM, EKM	Elk Mound (Cambrian)
#					CAMB		Cambrian rocks
#
#	Data Field Length/Type:		15S	
#	Data Units:			none
#       Data Source: 			Assigned by JT Wilson
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		aquifer_range
#       Data Field Description:		Range of System and Series for open interval
#
#       				Code    Description
#       				----    -----------------
#					UO	Upper Ordovician
#					MO	Middle Ordovician
#					LO	Lower Ordovician
#					C	Cambrian
#					CAMORD	Cambrian & Ordovician Systems
#					PC	Precambrian
#
#	Data Field Length/Type:		7S
#	Data Units:			none
#       Data Source: 			Assigned by JT Wilson
#       Retrieval Date:  		not applicable
#		
#
#       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:  		February 2008
#		
#
#       DATA FIELD LABEL:  		well_type
#       Data Field Description:		Type of well, private or public supply
#	Data Field Length/Type:		15S
#	Data Units:			none	
#       Data Source: 			Assigned by JT Wilson
#       Retrieval Date:  		not applicable
#		
#	
#
#--------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  SAMPLE INFORMATION
#
#       DATA FIELD LABEL:  		date
#       Data Field Description:		Date sample was collected
#	Data Field Length/Type:		8D
#	Data Units:			YYYYMMDD
#       Data Source: 			NAWQA Data Warehouse, RASA report or NWIS database
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		time
#       Data Field Description:		Time sample was collected
#	Data Field Length/Type:		4S
#	Data Units:			HH:MM
#       Data Source: 			NAWQA Data Warehouse, NWIS database
#       Retrieval Date:  		February 2008
#			
#
#---------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  WATER QUALITY PARAMETERS, FIELD PARAMETERS, TDS, HARDNESS
#
#       DATA FIELD LABEL:  		bicarbonate
#       Data Field Description:		bicarbonate as CaCO3, in milligrams per liter
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse or RASA report, or solved by JT Wilson (bicarbonate = alkalinity / 0.8202)
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		TDS
#       Data Field Description:		Total dissolved solids (residue on evaporation at 180 degrees Celcius, pcode 70300 for NAWQA samples)
#							       (sum of constituents for RASA samples)
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		Hardness
#       Data Field Description:		Hardness, in mg/L (the sum of Calcium and Magnesium in milliequivalents per liter multiplied by 50)
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			Ca & Mg from NAWQA Data Warehouse or RASA report, hardness calculated by JT Wilson
#       Retrieval Date:  		February 2008
#		
#
#------------------------------------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  WATER QUALITY PARAMETERS, MAJOR IONS
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#       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, RASA report	
#       Retrieval Date:  		February 2008
#		
#
#------------------------------------------------------------------------------------------------------------
#       DATA FIELD GROUP:  WATER QUALITY PARAMETER REMARK CODES
#
#	Remark codes are not included with this data set because all constituents were detected in each sample.
#
#
#----------------------------------------------------------------------------------------------------------------
# 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_nawqa_rasa_majors.txt
# ------------------------------------------------------------------------------------------------------
mapno	staid	state	source	lat_dd	long_dd	altitude	well_depth	lithology	place_name	primary_aquifer	group	aquifer_range	water_use	well_type	date	time	bicarbonate	TDS	hardness	calcium	chloride	fluoride	magnesium	potassium	silica	sodium	sulfate
4N	15S	12S	6S	12N	12N	5N	5N	15S	55S	45S	15S	7S	15S	15S	8D	4S	9N	9N	9N	9N	9N	9N	9N	9N	9N	9N	9N
4	413931093292001	Iowa	RASA	41.658600	-93.489102	980	2530	DLMT SNDS	079N23W11DCDD 23701 1976ALTOONA 3	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19810901		305	440	243	58	14	1.7	24	12	11	53	110
4	413931093292001	Iowa	NAWQA	41.658600	-93.489102	980	2530	DLMT SNDS	079N23W11DCDD 23701 1976ALTOONA 3	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20050614	1400	300.8	427	251	55.68	11.12	1.71	27.36	12.19	12.25	51.9	101.9
16	422611092552501	Iowa	RASA	42.435259	-92.924366	1094	2050	SNDS DLMT	088N18W14BCBC 10984 1960WELLSBURG 1	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19800902	1115	329	570	326	78	11	1.2	32	21	8.0	74	180
16	422611092552501	Iowa	NAWQA	42.435259	-92.924366	1094	2050	SNDS DLMT	088N18W14BCBC 10984 1960WELLSBURG 1	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20050623	1130	369.8	597	346	81.36	9.37	1.20	34.82	20.24	8.57	71.8	179.7
17	422855093481501	Iowa	RASA	42.481918	-93.804387	1038	2000	DLMT SNDS	089N25W33BDAA 25409 1979Webster City 6	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19800902	1350	363	960	476	120	71	1.3	43	20	8.4	140	370
17	422855093481501	Iowa	NAWQA	42.481918	-93.804387	1038	2000	DLMT SNDS	089N25W33BDAA 25409 1979Webster City 6	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20050622	1030	333.4	961	471	116.7	71.48	1.38	43.8	18.73	8.33	133.0	360.6
20	423840095135001	Iowa	RASA	42.644425	-95.230830	1403	1690	SNDS DLMT	090N37W05AAD 10125 1959STORM LAKE 4	PDC-JRDN-SLRC-TNC	PDCTMPTNC	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19800904	1630	329	1900	962	280	30	1.7	64	43	8.3	170	1100
20	423840095135001	Iowa	NAWQA	42.644425	-95.230830	1403	1690	SNDS DLMT	090N37W05AAD 10125 1959STORM LAKE 4	PDC-JRDN-SLRC-TNC	PDCTMPTNC	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20050714	0930	327.3	1922	980	280.2	27.71	1.70	68.19	42.91	8.43	151.4	1068.9
27	430800092540301	Iowa	RASA	43.129693	-92.902142	1123	1288	DLMT SNDS	096N17W18CDBA 09845 1958RUDD 2	PRAIRE DU CHIEN-JORDAN AQUIFER	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19800626	0900	317	330	272	66	2.0	0.70	26	6.8	7.0	16	48
27	430800092540301	Iowa	NAWQA	43.129693	-92.902142	1123	1288	DLMT SNDS	096N17W18CDBA 09845 1958RUDD 2	PRAIRE DU CHIEN-JORDAN AQUIFER	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20050711	1300	237.8	346	288	69.78	1.46	0.77	27.59	7.26	7.90	15.4	56.3
38	430337092190701	Iowa	RASA	43.063585	-92.323232	1162	1325	DLMT SNDS	095N13W12ABDD 15936 1964NEW HAMPTON 5	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	19800625	1100	263	250	216	52	0.9	0.60	21	4.3	6.8	6.9	27
38	430337092190701	Iowa	NAWQA	43.063586	-92.323232	1162	1325	DLMT SNDS	095N13W12ABDD 15936 1964NEW HAMPTON 5	PDC-JRDN-SLRC	PDCTMP	LO-CM	PUBLIC SUPPLY	PUBLIC SUPPLY	20070911	1200	251	243	223	53.92	0.53	0.48	21.62	4.52	6.84	6.4	26.6

