#  Begin METADATA documentation
#------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	camord_umis_nitrate_nawqa_resample.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
#			the Minneapolis-St. Paul (Twin Cities) Metro Area of Minnesota and western Wisconsin.
#			These wells were located in the NAWQA study unit referred to as UMIS (Upper Mississippi
#			River Basin).
#
#  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 23, 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 nitrate (nitrate + nitrite) samples 
#		collected from 23 NAWQA wells from the UMIS sampling network in 1996 and again in 2007. 
#		These data were used as part of the analysis of near decadal-scale changes in nitrate 
#		concentrations.
#		
#		Data were retrieved from the NAWQA Internal Data Warehouse on or about February 13, 2008.
#		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.
#
#		All nitrate non-detections are recensored to < 0.05 for purposes of comparison.
#		
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#
#        The data are a subset of data retrieved from the NAWQA Internal Data Warehouse on or about 
#        February 13, 2008.
#
#
#
#	 ***************************************************************************************************************
#	 *Analysis of near decadal-scale changes in nitrate concentrations uses samples collected at each well during  *
#	 *the first decade of NAWQA and the second decade of NAWQA. Two well networks were sampled during each decade  *
#	 *of NAWQA, one in the Minneapolis-St. Paul metro area (UMIS study unit) and one in eastern Wisconsin and the  *
#	 *Upper Peninsula of Michigan (WMIC study area).                                                               *
#	 ***************************************************************************************************************
#
#
#
# Related_Spatial_and_Tabular_Data_Sets:  
#
#		camord_nutrients_nawqa_mdl.txt
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#
#	DATA FIELD LABELS:
#
#	mapno
#	suid	
#	staid
#	state
#	source
#	sucode
#	lat_dd
#	long_dd
#	altitude
#	well_depth
#	lithology
#	place_name
#	primary_aquifer
#	group
#	aquifer_range
#	casing_depth
#	open_length
#	depth2bedrock
#	diam
#	water_use
#	well_type
#	landuse_500m
#	landuse_1mile
#	age
#	region
#	date
#	time
#	nitrate_1996_rmk
#	nitrate_1996
#	nitrate_2007_rmk
#	nitrate_2007
#	nitrate_diff
#	do_rmk
#	do
#
#
#     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, casing_depth, open_length, depth2bedrock, and diam
#
#			enhanced version of the USGS 1992 National Land Cover Data (NLCD): used for determining
#			landuse_500m and landuse_1mile					 
#
#
#
#---------------------------------------------------------------------------------------------------------
#  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:		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:			February 2008  
#
#		
#       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)
#	Data Field Length/Type:		6S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		February 2008
#		
#
#       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:  		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:  		casing_depth
#       Data Field Description:		description: Depth of casing from land surface, in feet
#	Data Field Length/Type:		5N
#	Data Units:			Feet
#       Data Source: 			Assigned by JT Wilson after viewing well logs
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		open_length
#       Data Field Description:		Length of open interval, in feet
#	Data Field Length/Type:		5N
#	Data Units:			Feet
#       Data Source: 			Assigned by JT Wilson after viewing well logs
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		depth2bedrock
#       Data Field Description:		Depth to bedrock, in feet
#	Data Field Length/Type:		5N
#	Data Units:			Feet
#       Data Source: 			Assigned by JT Wilson after viewing well logs
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		diam
#       Data Field Description:		Smallest diameter of open interval, casing or hole, in inches
#	Data Field Length/Type:		3N
#	Data Units:			Inches
#       Data Source: 			Assigned by JT Wilson after viewing well logs
#       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 LABEL:  		landuse_500m
#       Data Field Description:		Predominant land use within a 500-meter circular buffer around the well
#
#					Code	Description
#					-----	---------------------
#					ag	Agricultural: >50% agricultural land and <5% urban land
#					urban	Urban: >25% urban land and <25% agricultural land
#					undev	Undeveloped: <5% urban land and <25% agricultural land
#					mix	Mixed: all other combinations of agricultural, urban, and undeveloped
#
#	Data Field Length/Type:		6S
#	Data Units:			none
#       Data Source: 			Determined by MH KIM, Indiana WSC using GIS methods
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		landuse_1mile
#       Data Field Description:		Predominant land use within a 1-mile circular buffer around the well--same codes as landuse_500m
#	Data Field Length/Type:		6S
#	Data Units:			none
#       Data Source: 			Determined by MH KIM, Indiana WSC using GIS methods
#       Retrieval Date:  		not applicable
#		
#
#       DATA FIELD LABEL:  		age
#       Data Field Description:		Tritium-based groundwater age
#
#					Code		Description
#					-----		---------------------
#					modern		tritium value above threshold for what value would be after
#							radioactive decay of 8 T.U. from 1953 to sample date (year),
#							indicating elevated tritium levels in precipitation from nuclear testing after 1953
#
#					pre-1953	tritium value at or below threshold for what value would be after
#							radioactive decay of 8 T.U. from 1953 to sample date (year),
#							indicating that recharge pre-dates 1953
#
#	Data Field Length/Type:		9S
#	Data Units:			none
#       Data Source: 			Tritium values from NAWQA Data Warehouse water-quality data retrieval,
#					age solved by JT Wilson using pre-1953 background value of 8 T.U. from
#					Thatcher (1962), tritium decay function, and sample date (year) for elapsed time
#					[Thatcher, L.L., 1962, The distribution of tritium fallout in precipitation over North America: 
#					Bulletin of the International Association of Scientific Hydrology, v. 7, p. 48-58.]
#       Retrieval Date: 		February 2008 
#		
#
#       DATA FIELD LABEL:  		region
#       Data Field Description:		Regional confinement, based on presence or absence of Maquoketa Shale and younger bedrock units
#
#					Region		Description
#					------------------------------
#					Confined	Regionally confined: The aquifer system is covered by the Upper Ordovician
#						     	Maquoketa Shale and/or younger bedrock
#
#					Unconfined	Regionally unconfined: The aquifer system is exposed at the bedrock surface
#							where the Maquoketa Shale and younger bedrock are absent
#
#	Data Field Length/Type:		11S
#	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
#       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
#       Retrieval Date:  		February 2008
#		
#
#---------------------------------------------------------------------------------------
#
#       DATA FIELD GROUP:  WATER QUALITY PARAMETERS, NITRATE, DISSOLVED OXYGEN
#
#
#       DATA FIELD LABEL:  		nitrate_1996_rmk
#       Data Field Description:		remark code for nitrate (nitrate + nitrite) value, see explanation of remark codes below
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		nitrate_1996
#       Data Field Description:		nitrate + nitrite, pcode 00631, sampled date of 1996
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		nitrate_2007_rmk
#       Data Field Description:		remark code for nitrate (nitrate + nitrite) value, see explanation of remark codes below
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		nitrate_2007
#       Data Field Description:		nitrate + nitrite, pcode 00631, sampled date of 2007
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		nitrate_diff
#       Data Field Description:		difference in nitrate value (nitrate + nitrite), pcode 00631, 2007 - 1996
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse	
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		do_rmk
#       Data Field Description:		Remark code for dissolved oxygen, see explanation of remark codes below
#	Data Field Length/Type:		1S
#	Data Units:			none
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		February 2008
#		
#
#       DATA FIELD LABEL:  		do
#       Data Field Description:		Dissolved oxygen, in milligrams per liter
#	Data Field Length/Type:		9N
#	Data Units:			milligrams per liter
#       Data Source: 			NAWQA Data Warehouse
#       Retrieval Date:  		February 2008
#		
#
#------------------------------------------------------------------------------------------------------------
#       DATA FIELD GROUP:  WATER QUALITY PARAMETER REMARK CODES
#
#	Data Source: USGS/NAWQA Data warehouse
#	RETRIEVAL DATE: February 2008
#
#
#	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_umis_nitrate_nawqa_resample.txt
# ------------------------------------------------------------------------------------------------------
mapno	suid	staid	state	source	sucode	lat_dd	long_dd	altitude	well_depth	lithology	place_name	primary_aquifer	group	aquifer_range	casing_depth	open_length	depth2bedrock	diam	water_use	well_type	landuse_500m	landuse_1mile	age	region	date	time	nitrate_1996_rmk	nitrate_1996	nitrate_2007_rmk	nitrate_2007	nitrate_diff	do_rmk	do				
4N	4S	15S	12S	6S	10S	12N	12N	5N	5N	15S	55S	45S	15S	7S	5N	5N	5N	3N	15S	15S	6S	6S	9S	11S	8D	4S	1S	9N	1S	9N	9N	1S	9N				
68	UMIS	443042092570401	MINNESOTA	NAWQA	umissus3	44.511614	-92.951081	862	320	SNDS DLMT	PDCJ-U09 112N18W14BADCAB01	JORDAN SANDSTONE	PDCTMP	LO-CM	279	41	30	4	DOMESTIC	PRIVATE	undev	ag	Modern	Unconfined	19960815	1100	-	0.48	-	0.381	-0.099	<	0.18				
69	UMIS	443112092513901	MINNESOTA	NAWQA	umissus3	44.518564	-92.867375	883	339	SNDS	PDCJ-U16 112N17W09CAADDA01	JORDAN SANDSTONE	CTMP	CM	301	38	4	4	DOMESTIC	PRIVATE	ag	ag	pre-1953	Unconfined	19960829	1000	<	0.05	<	0.05	0	<	0.18				
70	UMIS	443119093050101	MINNESOTA	NAWQA	umissus3	44.522131	-93.084242	905	137	DLMT	PDCJ-U08 112N19W10DABBAD01 DD34 0000443920	PRAIRIE DU CHIEN FORMATION	OPDC	LO	105	32	105	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960808	1000	-	0.07	<	0.05	-0.02	<	0.18				
72	UMIS	443328093184701	MINNESOTA	NAWQA	umissus3	44.557783	-93.312944	1140	235	DLMT	PDCJ-U02 113N21W35BABCBA01 0000212377	PRAIRIE DU CHIEN FORMATION	OPDC	LO	207	28	207	4	DOMESTIC	PRIVATE	mix	ag	pre-1953	Unconfined	19960730	1400	-	0.09	<	0.05	-0.04	-	0.28				
73	UMIS	443502092212301	WISCONSIN	NAWQA	umissus3	44.583567	-92.322519	710	66	LMSN	PDCT-U7 024N16W09AA 01	PRAIRIE DU CHIEN GROUP	OPDC	LO	56	10	53	6	DOMESTIC	PRIVATE	urban	mix	Modern	Unconfined	19960805	1600	-	0.05	<	0.05	0						
77	UMIS	443703092261301	WISCONSIN	NAWQA	umissus3	44.617781	-92.440097	740	140	LMSN	PDCT-U6 025N17W28DD 01	PRAIRIE DU CHIEN GROUP	OPDC	LO	120	20	120	6	DOMESTIC	PRIVATE	mix	ag	Modern	Unconfined	19960812	1100	-	0.07	-	0.135	0.065	-	1.45				
78	UMIS	443808093012801	MINNESOTA	NAWQA	umissus3	44.635431	-93.024764	875	220	SNDS	PDCJ-U03 114N18W31DBCBBA01 0000198261	JORDAN SANDSTONE	CTMP	CM	195	25	9	4	DOMESTIC	PRIVATE	mix	mix	pre-1953	Unconfined	19960903	1300	-	0.07	<	0.05	-0.02	<	0.18				
79	UMIS	443934092565601	MINNESOTA	NAWQA	umissus3	44.659425	-92.948947	905	270	SNDS	PDCJ-U07 114N18W23CDCCCC01 0000412478	JORDAN SANDSTONE	CTMP	CM	250	20	8	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960812	1000	-	7.9	-	11.5	3.6	-	3.97				
82	UMIS	444211092544601	MINNESOTA	NAWQA	umissus3	44.703019	-92.913461	820	320	SNDS	PDCJ-U10 114N17W06CCCCBD01	JORDAN SANDSTONE	CTMP	CM	284	36	280	4	DOMESTIC	PRIVATE	mix	ag	pre-1953	Unconfined	19960814	1200	<	0.05	<	0.05	0	<	0.18				
83	UMIS	444214092490401	MINNESOTA	NAWQA	umissus3	44.702983	-92.817906	842	245	SNDS	PDCJ-U15 114N17W02DCDADB01	JORDAN SANDSTONE	CTMP	CM	220	25	75	4	DOMESTIC	PRIVATE	mix	ag	Modern	Unconfined	19960826	1200	-	4.7	-	5.2	0.5	-	7.06				
90	UMIS	445010092422201	WISCONSIN	NAWQA	umissus3	44.835922	-92.702036	920	230	LMSN	PDCT-U1 027N19W08D 01	PRAIRIE DU CHIEN GROUP	OPDC	LO	40	190	40	6	DOMESTIC	PRIVATE	mix	mix	Modern	Unconfined	19960807	1000	-	6.2	-	5.59	-0.61	-	10.5				
94	UMIS	445117093042701	MINNESOTA	NAWQA	umissus3	44.854769	-93.074225	968	335	DLMT	PDCJ-U06 027N22W05DBBBAB01 0000427141	PRAIRIE DU CHIEN FORMATION	OPDC	LO	295	40	295	4	DOMESTIC	PRIVATE	mix	mix	Modern	Unconfined	19960813	1200	<	0.05	<	0.05	0	<	0.18				
97	UMIS	445245092545501	MINNESOTA	NAWQA	umissus3	44.879008	-92.915119	920	143	SNDS	PDCJ-U11 028N21W27CDABDD01	PRAIRIE DU CHIEN FORMATION	OPDC	LO	139	4	129	4	DOMESTIC	PRIVATE	mix	ag	Modern	Unconfined	19960814	0900	-	2.9	-	1.35	-1.55	-	1.95				
104	UMIS	445919092500101	MINNESOTA	NAWQA	umissus3	44.988386	-92.834067	930	143	DLMT	PDCJ-U14 029N20W20BDAABC01	PRAIRIE DU CHIEN FORMATION	OPDC	LO	126	17	82	4	DOMESTIC	PRIVATE	ag	mix	Modern	Unconfined	19960808	1400	-	4.2	-	3.38	-0.82	-	2.97				
105	UMIS	445933092222301	WISCONSIN	NAWQA	umissus3	44.992572	-92.373939	1160	104	LMSN	PDCT-U5 029N16W18CC 01	PRAIRIE DU CHIEN GROUP	OPDC	LO	84	20	84	6	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960820	1300	-	4.5	-	5.33	0.83	-	7.6				
112	UMIS	450603092500201	MINNESOTA	NAWQA	umissus3	45.101558	-92.834000	904	110	SNDS	PDCJ-U13 030N20W08CAAAAB01	JORDAN SANDSTONE	CTMP	CM	108	2	95	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960815	1400	-	0.15	<	0.05	-0.1	<	0.18				
113	UMIS	450635092302201	WISCONSIN	NAWQA	umissus3	45.109714	-92.506472	1000	77	LMSN	PDCT-U2 030N18W01CD 01 FK 344	PRAIRIE DU CHIEN GROUP	OPDC	LO	57	20	57	6	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960801	1400	-	11	-	11.78	0.78	-	9.32				
115	UMIS	450810092583501	MINNESOTA	NAWQA	umissus3	45.135942	-92.976664	938	118	DLMT	PDCJ-U05 031N21W33BBCADA01 0000182149	PRAIRIE DU CHIEN FORMATION	OPDC	LO	85	33	83	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960827	0900	-	3.9	-	0.964	-2.936	-	4.76				
117	UMIS	451027092142901	WISCONSIN	NAWQA	umissus3	45.173833	-92.241344	1160	180	LMSN	PDCT-U8 031N15W17DA 01	PRAIRIE DU CHIEN GROUP	OPDC	LO	121	59	20	6	DOMESTIC	PRIVATE	mix	ag		Unconfined	19960808	1100	-	2.4	-	2.1	-0.3	-	4.85				
119	UMIS	451242092433201	WISCONSIN	NAWQA	umissus3	45.212192	-92.726650	1000	278	SNDS	PDCT-U03 032N19W33CC 01	TREMPEALEAU FORMATION	CTMP	CM	248	30	127	4	DOMESTIC	PRIVATE	mix	mix	Modern	Unconfined	19960820	1000	-	4.2	-	5.52	1.32	-	9.74				
121	UMIS	451602092515601	MINNESOTA	NAWQA	umissus3	45.267136	-92.865686	943	87	SNDS	PDCJ-U12 032N20W17BAAADB01	PRAIRIE DU CHIEN FORMATION	OPDC	LO	86	1	70	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960807	1400	-	0.64	-	0.514	-0.126	-	0.6				
122	UMIS	452102092212201	WISCONSIN	NAWQA	umissus3	45.349675	-92.358833	1100	120	SNDS	PDCT-U4 033N16W16BA 01	TREMPEALEAU FORMATION	CTMP	CM	103	17	90	4	DOMESTIC	PRIVATE	ag	ag	Modern	Unconfined	19960806	1100	-	0.3	-	0.196	-0.104	-	2.66				
123	UMIS	452709092141101	WISCONSIN	NAWQA	umissus3	45.452611	-92.236339	1190	94	SNDS	PDCT-U9 034N15W09BB 01	TREMPEALEAU FORMATION	CTMP	CM	90	4	88	6	DOMESTIC	PRIVATE	ag	mix	Modern	Unconfined	19960821	1500	<	0.05	<	0.05	0	-	1.74				
