#  Begin METADATA documentation
------------------------------------------------------------------------------------------------------
#  DATASET_NAME: NitrateRept_NetworkAve.txt	
#  DATASET_DESCRIPTION:	Data averaged by network that was used for the linear regression model.
#			
#  DATA_SET FORMAT: tab delimeted text
#  DATA_SET URL: http://water.usgs.gov/nawqa-only/aq/PADataArchive.html
#
#-------------------------------------------------------------------------------------------------------- 
#  REPORT TITLE: Nitrate and the relations that affect the probability and prediction in private wells of the glacial aquifer system, United States	
# 
#  REPORT SERIES/NUMBER (JOURNAL NAME/VOLUME): SIR 2009-XXXX getting ready for director's approval 11/20/2009   
#  REPORT URL: 
#
#-------------------------------------------------------------------------------------------------------
#  NAWQA STUDY:	National Water-Quality Asessment Program 
#               Groundwater Status and Trends
#               Glacial Principal Aquifer	
#
#-------------------------------------------------------------------------------------------------------
#
#  METADATA DATE:    11/20/2009	
#  METADATA CONTACT: 
#                    Terri Arnold	
#                    U.S. Geological Survey
#                    Illinois Water Science Center
#                    1201 W. University Ave, Suite 100
#                    Urbana, Illinois 61801
#                    voice: (217)328-9702
#                    email: tlarnold@usgs.gov
#
#  SECONDARY CONTACT: 
#                    Kelly Warner
#                    U.S. Geological Survey
#                    Illinois Water Science Center
#                    1201 W. University Ave, Suite 100
#                    Urbana, Illinois 61801
#                    voice: (217)328-9727
#                    email: klwarner@usgs.gov
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Data Description: 
#
#  ABSTRACT: 
#      This data set was used to calculate a linear regression model for 
#  the subject report. The data were aveaged for all of the domestic wells 
#  in a network in the glacial aquifer system. Only networks with 5 or more 
#  wells were used for the linear regression model	
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#          Data were retrieved from the National Water-Quality Assessment 
#       Program (NAWQA) Data Warehouse for all wells identified as being in 
#       the glacial aquifer system. Nitrate data was retrieved as part of a 
#       larger data set and then subset into a smaller dataset with just 
#       nitrite plus nitrate as nitrogen, PCODE 00631, (hereafter called 
#       nitrate)and ancillary data.
#
#        The remark columns have a '<' for censored data, an 'E' for 
#        estimated data, a '-' for measured data, and an NA for missing data.
#
#      PROCESS STEP:
#        The field parameter, major ion, trace element, and nutrient 
#        data were retrieved from the NAWQA Internal Data Warehouse 
#        September 16, 2005. The Conditions used to retrieve the data 
#        are as follows:
#
#        Pre-set Data Warehouse conditions used for retrieving data:
#        1) Eliminate 'V' Coded data
#        2) Groundwater Chemical Environmental Data 
#        3) Groundwater Sites Only
#        4) GW POSV Patch Last Value of Day
#        5) Remove 'Set Number' and 'Surrogate' from the search
#
#        Additional Conditions for glacial aquifer wells:
#        Select SUCODES and create DECODE calculation to only select 
#        wells that were determined by the Glacial Aquifer Planning Team to 
#        be sampling from the Glacial Aquifer (based on lithology and 
#        knowledge of NAWQA study unit teams)
#
#        Su Code IN 'almnsus2', 'ccptlusag2a', 'ccptlusag2b', 'ccptlusor1a', 
#        'ccptlusor1b', 'cnbrluscr1', 'cnbrrefcr1','cnbrrefpa1', 'conndwgs1', 
#        'connfpsur1', 'connlusag1', 'connlusfo1', 'connlusrc1', 'connlusur1',
#        'connreffo1','connsus2', 'cooksus1a', 'cooksus1b', 'delrsus3', 
#        'eiwaluscr1', 'eiwalusrc1', 'eiwaspcg1', 'eiwasus2', 'hdsnfpsag1', 
#        'hdsnlusag1', 'hdsnlusag2', 'hdsnlusur1', 'hdsnsus1', 'hdsnsus2', 
#        'hpgwdwgs1','hpgwlusag3','hpgwsus4', 'leriluscr1', 'lerilusrc1', 
#        'lerispcg1', 'lerisus1', 'linjsus1','lirbluscr1', 'lirbluscr2', 
#        'lirbsus1', 'lirbsus2', 'miamluscr1', 'miamluscr1a', 'miamlusrc1', 
#        'miamrefot1', 'miamspcb1', 'miamsus1', 'necblusrc1', 'necbsus3', 
#        'pugtfpscr1', 'pugtluscr1', 'pugtlusrs1', 'pugtsus1', 'rednfpsag1', 
#        'rednfpsag2', 'rednlusag1', 'rednlusag2', 'rednsus1', 'rednsus2', 
#        'rednsus3', 'rednsus4', 'rednsus5', 'uirbluscr1', 'uirblusrc1', 
#        'uirbsus1', 'uirbsus2', 'umisfpsur1', 'umisluscr1', 'umislusfo1', 
#        'umislusrc1', 'whitfpsag1', 'whitfpsag2', 'whitluscr1', 'whitluscr2',
#        'whitluscr3a', 'whitluscr3b', 'whitlusur1a', 'whitlusur1b', 
#        'whitrefcr1','whmidwgs1', 'whmilusrc1','wmicfpsag1a', 'wmicfpsag1b', 
#        'wmicfpsag1c', 'wmicfpsag1d', 'wmicfss', 'wmiclusag1a', 'wmiclusag1b',
#        'wmiclusag2', 'wmicrefcr1','wmicreffo1','wmicsus2'
#                      
#        DECODE(Geographic Places.Staid,'462038118595001','NOT GLACIAL',
#        '462643119044001','NOT GLACIAL','462734119020801','NOT GLACIAL',
#        '463258119133801','NOT GLACIAL','463627119031801','NOT GLACIAL',
#        '464108119103801','NOT GLACIAL','464857119040701','NOT GLACIAL',
#        '465648119353901','NOT GLACIAL','465736119262701','NOT GLACIAL',
#        '47023#        The remark columns have a '<' for censored data, an 'E' for 
#        estimated data, a '-' for measured data, and an NA for missing data.
#
#      PROCESS STEP:
#        The field parameter, major ion, trace element, and nutrient 
#        data were retrieved from the NAWQA Internal Data Warehouse 
#        September 16, 2005. The Conditions used to retrieve the data 
#        are as follows:
#
#        Pre-set Data Warehouse conditions used for retrieving data:
#        1) Eliminate 'V' Coded data
#        2) Groundwater Chemical Environmental Data 
#        3) Groundwater Sites Only
#        4) GW POSV Patch Last Value of Day
#        5) Remove 'Set Number' and 'Surrogate' from the search
#
#        Additional Conditions for glacial aquifer wells:
#        Select SUCODES and create DECODE calculation to only select 
#        wells that were determined by the Glacial Aquifer Planning Team to 
#        be sampling from the Glacial Aquifer (based on lithology and 
#        knowledge of NAWQA study unit teams)
#
#        Su Code IN 'almnsus2', 'ccptlusag2a', 'ccptlusag2b', 'ccptlusor1a', 
#        'ccptlusor1b', 'cnbrluscr1', 'cnbrrefcr1','cnbrrefpa1', 'conndwgs1', 
#        'connfpsur1', 'connlusag1', 'connlusfo1', 'connlusrc1', 'connlusur1',
#        'connreffo1','connsus2', 'cooksus1a', 'cooksus1b', 'delrsus3', 
#        'eiwaluscr1', 'eiwalusrc1', 'eiwaspcg1', 'eiwasus2', 'hdsnfpsag1', 
#        'hdsnlusag1', 'hdsnlusag2', 'hdsnlusur1', 'hdsnsus1', 'hdsnsus2', 
#        'hpgwdwgs1','hpgwlusag3','hpgwsus4', 'leriluscr1', 'lerilusrc1', 
#        'lerispcg1', 'lerisus1', 'linjsus1','lirbluscr1', 'lirbluscr2', 
#        'lirbsus1', 'lirbsus2', 'miamluscr1', 'miamluscr1a', 'miamlusrc1', 
#        'miamrefot1', 'miamspcb1', 'miamsus1', 'necblusrc1', 'necbsus3', 
#        'pugtfpscr1', 'pugtluscr1', 'pugtlusrs1', 'pugtsus1', 'rednfpsag1', 
#        'rednfpsag2', 'rednlusag1', 'rednlusag2', 'rednsus1', 'rednsus2', 
#        'rednsus3', 'rednsus4', 'rednsus5', 'uirbluscr1', 'uirblusrc1', 
#        'uirbsus1', 'uirbsus2', 'umisfpsur1', 'umisluscr1', 'umislusfo1', 
#        'umislusrc1', 'whitfpsag1', 'whitfpsag2', 'whitluscr1', 'whitluscr2',
#        'whitluscr3a', 'whitluscr3b', 'whitlusur1a', 'whitlusur1b', 
#        'whitrefcr1','whmidwgs1', 'whmilusrc1','wmicfpsag1a', 'wmicfpsag1b', 
#        'wmicfpsag1c', 'wmicfpsag1d', 'wmicfss', 'wmiclusag1a', 'wmiclusag1b',
#        'wmiclusag2', 'wmicrefcr1','wmicreffo1','wmicsus2'
#                      
#        DECODE(Geographic Places.Staid,'462038118595001','NOT GLACIAL',
#        '462643119044001','NOT GLACIAL','462734119020801','NOT GLACIAL',
#        '463258119133801','NOT GLACIAL','463627119031801','NOT GLACIAL',
#        '464108119103801','NOT GLACIAL','464857119040701','NOT GLACIAL',
#        '465648119353901','NOT GLACIAL','465736119262701','NOT GLACIAL',
#        '470233119490501','NOT GLACIAL','470515119025801','NOT GLACIAL',
#        '470803119362401','NOT GLACIAL','470820119480201','NOT GLACIAL',
#        '470848119125501','NOT GLACIAL','470940119443901','NOT GLACIAL',
#        '470947119392901','NOT GLACIAL','471225119362501','NOT GLACIAL',
#        '462943119152201','NOT GLACIAL','463321119121501','NOT GLACIAL',
#        '463342119101501','NOT GLACIAL','465305119333701','NOT GLACIAL',
#        '465349119200401','NOT GLACIAL','465441119331701','NOT GLACIAL',
#        '465448119322601','NOT GLACIAL','465527119184601','NOT GLACIAL',
#        '465649119513901','NOT GLACIAL','425027074393701','NOT GLACIAL',
#        '425056074381501','NOT GLACIAL','425428073542501','NOT GLACIAL',
#        '411631074284201','NOT GLACIAL','411728074100001','NOT GLACIAL',
#        '411748074195601','NOT GLACIAL','411938073595201','NOT GLACIAL',
#        '411939073595301','NOT GLACIAL','412536074324301','NOT GLACIAL',
#        '413016074282101','NOT GLACIAL','413050074084101','NOT GLACIAL',
#        '413205074145101','NOT GLACIAL','413400074212701','NOT GLACIAL',
#        '421130073412001','NOT GLACIAL','421150073353001','NOT GLACIAL',
#        '421909073382001','NOT GLACIAL','422415073251001','NOT GLACIAL',
#        '422554073415601','NOT GLACIAL','422753073240501','NOT GLACIAL',
#        '422846073593501','NOT GLACIAL','422950073591201','NOT GLACIAL',
#        '423241074064901','NOT GLACIAL','423416073553201','NOT GLACIAL',
#        '423847074043701','NOT GLACIAL','423851073545201','NOT GLACIAL',
#        '424051073414501','NOT GLACIAL','424354073532101','NOT GLACIAL',
#        '424429073585801','NOT GLACIAL','425129074303501','NOT GLACIAL',
#        '425217074061401','NOT GLACIAL','425235074204401','NOT GLACIAL',
#        '425454074322101','NOT GLACIAL','425502074260601','NOT GLACIAL',
#        '425515074254201','NOT GLACIAL','425535074341501','NOT GLACIAL',
#        '425545074185601','NOT GLACIAL','425545074185602','NOT GLACIAL',
#        '425657074174101','NOT GLACIAL','425716074294901','NOT GLACIAL',
#        '425731074172901','NOT GLACIAL','425813074304201','NOT GLACIAL',
#        '425837074475101','NOT GLACIAL','425851074085801','NOT GLACIAL',
#        '430302074462601','NOT GLACIAL','430532075281101','NOT GLACIAL',
#        '430536075034501','NOT GLACIAL','430549075031701','NOT GLACIAL',
#        '431157075015601','NOT GLACIAL','431212075191501','NOT GLACIAL',
#        '425659075013001','NOT GLACIAL','430328074461501','NOT GLACIAL',
#        '421222083450501','NOT GLACIAL','423209083431301','NOT GLACIAL',
#        '420049084235000','NOT GLACIAL','474247097401301','NOT GLACIAL',
#        '474859097572201','NOT GLACIAL','474926098141901','NOT GLACIAL',
#        '475846097141501','NOT GLACIAL','480606097101901','NOT GLACIAL',
#        '480816097592701','NOT GLACIAL','481001098584701','NOT GLACIAL',
#        '482033099594901','NOT GLACIAL','394523085523302','NOT GLACIAL',
#        '385533086582801','NOT GLACIAL','390722087054501','NOT GLACIAL',
#        '425033074403401','NOT GLACIAL','403902074595601','NOT GLACIAL',
#        '404126074482501','NOT GLACIAL','404251074354101','NOT GLACIAL',
#        '404347074473901','NOT GLACIAL','404453074473501','NOT GLACIAL',
#        '404543074401101','NOT GLACIAL','404625074334401','NOT GLACIAL',
#        '404700074411201','NOT GLACIAL','404717074340201','NOT GLACIAL',
#        '404944074443101','NOT GLACIAL','405003074480101','NOT GLACIAL',
#        '405555074352001','NOT GLACIAL','405557074280701','NOT GLACIAL',
#        '405605074241101','NOT GLACIAL','405650074243601','NOT GLACIAL',
#        '405725074292801','NOT GLACIAL','405833074205801','NOT GLACIAL',
#        '410115074313101','NOT GLACIAL','410208074233501','NOT GLACIAL',
#        '410320074273801','NOT GLACIAL','410404074192801','NOT GLACIAL',
#        '410507074222901','NOT GLACIAL','410546074153001','NOT GLACIAL',
#        '410744074213101','NOT GLACIAL','410930074235901','NOT GLACIAL',
#        '411022074103201','NOT GLACIAL','411432074094101','NOT GLACIAL',
#        '411631074064301','NOT GLACIAL','405103074344701','NOT GLACIAL',
#        'GLACIAL')
#
#        Create DECODE calculation to assign REGIONs according to the Glacial 
#        Aquifer stratification:
#        DECODE(SUID,'LERI','CENTRAL','LIRB','CENTRAL','MIAM','CENTRAL',
#        'UIRB','CENTRAL','WHIT','CENTRAL','WHMI','CENTRAL','WMIC','CENTRAL',
#        'ALMN','EAST','CONN','EAST','DELR','EAST','HDSN','EAST','NECB','EAST',
#        'LINJ','EAST','EIWA','WEST','HPGW','WEST','REDN','WEST','UMIS','WEST',
#        'PUGT','FAR WEST','COOK','FAR WEST','CCYK','FAR WEST','CNBR','WEST')
#
#        Selected items for display:
#        Net Sites
#            Su Code
#        Geographic Places
#            Suid
#            Staid
#        Samples
#            Sample Id
#        Results
#            Result Datetime
#            Remrk (Detail)
#            Value (Detail)
#        Parameters
#            Parameter Code
#            Parameter Code Nmae
#            Report Units
#
#      Process_Step:
#        Some wells had more than one line of data - some on the same date.  
#        The 'GW POSV Patch Last Value of Day' condition took care of most of 
#        these situations; however, some still remained.  For statistical 
#        analysis, only one line of data per well was desired. To get one line
#        of data per well, multiple lines of data for the same well were 
#        combined into one line as follows:
#        1) Select most recent sample or sample with most data on one line to 
#           keep
#        2) If data is missing in the sample you chose to keep but is available
#           from another sample for the same well, copy it from the other 
#           sample and paste it in the sample you chose to keep.
#
#        After the lines were combined, then the un-needed line was deleted.  
#        After all wells only had one line of data then the sample data and 
#        sample number columns were deleted.  These lines were no longer 
#        accurate since the samples were combined into one line. 
#
#      Process_Step:
#        Some wells still had multiple entries because they occured as samples 
#        in different ground-water networks (SUCODES).  Duplicate lines were 
#        deleted and the SUCODE information was retained in two additonal 
#        columns ('Su Code Alt 1' and 'Su Code Alt 2').  The most networks 
#        any well was included in was 3 networks.
#
#        The wells that occured in more than one network are as follows (the
#        first number is the number of networks and the second number is 
#        the STAID)
#        2 383525087175001
#        2 413427072355501
#        2 415545073000601
#        2 415856072263101
#        2 433720088014901
#        2 452726088434401
#        2 454350088560301
#        2 460122096535203
#        2 460727096561702
#        2 461620097081101
#        2 462157097245801
#        2 462448097184101
#        2 462724097204601
#        2 462748097053301
#        2 463029097283401
#        2 463053097081201
#        2 463140095344601
#        2 463221097140101
#        2 463355097030701
#        2 463415097215502
#        2 463618095353301
#        2 463859095371201
#        2 463928095362501
#        2 463956095352601
#        2 464113095341901
#        2 471240095390101
#        2 471415096260701
#        2 471421097304601
#        2 471809097534401
#        2 472958097392101
#        2 473247097092401
#        2 473422095241901
#        2 473512095163201
#        2 473931097272101
#        2 474116098071701
#        2 474443098585701
#        2 474532097344901
#        2 475234097333601
#        2 475308098424801
#        2 475658098571901
#        2 480357099481901
#        2 484502097462301
#        2 485444097533601
#        3 462907097214201
#        3 475043097344401
#        3 475928097395701
#        3 480625097450801
#        3 481749097481501
#
#      PROCESS STEP:
#        The data retrieved had muliple censoring levels for most constituents.
#        Censored data is indicated by a '<' or '>' in the remark column 
#        (remark columns begin with a 'R_' in the final data set.) Glacial 
#        data will be compared with data for the Cambrian-Ordovician and
#        New York-New England aquifers so when dealing with censored values, 
#        data for these aquifers was also considered. For analysis, censored 
#        values were handled similar to the method employed by the NAWQA Trace 
#        Elements National Synthesis Team as follows (original data prior to 
#        handling censored values is stored in columns with a title begining 
#        with a 'P'. Post handling of censored values is stored in columns 
#        whose titles begin with a 'A_'):
#        1) For any constituent that has censored values, insert an 
#           additional column to the right of the value column (titled with 
#           the PCODE prefixed by 'P') and label the new column with the 
#           PCODE number prefixed by a 'A_'.
#        2) Look at all the censored values for each constituent. Identify 
#           the most common detection or reporting. 
#           i) Values that are censored above the most common detection or 
#              reporting limit: delete them and place a '-' in the 'A_' column.
#          ii) Censored values including the E-marked values below the 
#              common detection or reporting limit: convert them to the 
#              most common detection or reporting limit in the 
#             'A_' column.
#         iii) E-remarked values that are above the common reporting limit: 
#              keep that E-remarked value in the 'A_' column.
#
#	 PCODE	censored value 
#	 00631	0.05
#
#      PROCESS STEP:
#        The retrieved Station IDs (STAID) were compared to a complete list of 
#        STAIDs to determine if any wells were missing fromt he data retrieval 
#        (due to no data for the requested PCODEs). The following STAIDs were 
#        missing: 
#        414448096412701
#        422831073100101
#        424610083223201
#        433708088020801
#        433715088015804
#        433715088015805
#        433715088015806
#        433720088014904
#        433720088014905
#
#        Lines were added to the data file for these missing wells with a 
#        '-' for all columns of data.
#
#
#      PROCESS STEP:
#        Corrected site 484502097462301 to have 'su code' = 'rednsus3' and 
#        'sucode alt 1' = 'rednsus1' to make the data sort correctly
#      Revisions:       
#  
#      PROCESS STEP:
#        Ancillary data was compiled from the NAWQA internal GIS resources 
#        web page: http://water.usgs.gov/nawqa-only/gis/gis_data.html
#
#      PROCESS STEP:
#      Some wells were in multiple networks, some with conflicting types.  
#      Only domestic wells in major-aquifer study (MAS) networks were used 
#      as domestic wells; domestic wells that were in land use (LUS) networks 
#      were eliminated from the data set. Likewise, only public suply wells in
#      MAS networks were used as public supply wells; public suply wells that 
#      were in LUS  networks were eliminated from the data set. Only 
#      monitoring wells in LUS networks were kept in this dataset; monitoring 
#      wells in MAS networks were eliminated.
#
#      PROCESS STEP:
#      All chemical data except nirate was eliminated from the data set.
#
#      PROCESS STEP:
#      all data (nitrate and ancillary data) were averaged for all of the 
#      wells in each nework.
#
# Related_Spatial_and_Tabular_Data_Sets:  
#      	NitrateRept_SiteData.txt
#	NitrateRept_ReferenceWells.txt
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#     DATA FIELD LABELS: 
#     SUCODE
#     residuals
#     pred.fit
#     pred.LCL95
#     pred.UCL95
#     mDiamOIin
#     mwtdepave
#     msiltave
#     morda
#     mnfarm.10y
#     moilength.
#     mdepthtoi.
#     meanno3
#     medno3
#     ratio
#     nobs
#     nd
#	
#     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.
#
#     Missing data is indicated by a '.'
#
#     DATA SOURCES:
#     DWH or dwh = USGS NAWQA data warhouse 
#                  http://infotrek.er.usgs.gov/pls/nawqa_www
#     CALC or calc = calculated for this report

#--------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#--------------------------------------------------------------------------------
#
#	Data FIELD GROUP: Site identification
#
#       DATA FIELD LABEL:  	SUCODE
#       Data Field Description:	network identification
#	Data Field Length/Type:	12s	
#	Data Units:		none
#       Data Source: 		dwh	
#       Retrieval Date:		Sept. 16, 2005
#		
#--------------------------------------------------------------------------------
#
#	Data FIELD GROUP: Predictions, calculations, and results
#
#       DATA FIELD LABEL:  	residuals
#       Data Field Description:	residuals of predicted (pred.fit) against 
#                               observed (mean.no3)from linear regression model
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen
#       Data Source: 		calc	
#       Retrieval Date:  	April 2007	
#
#       DATA FIELD LABEL:  	pred.fit
#       Data Field Description:	predicted mean nitrate plus nitrite as nitrogen 
#                               concentration for a network of wells
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen
#       Data Source: 		calc	
#       Retrieval Date:  	April 2007	
#
#       DATA FIELD LABEL:  	pred.LCL95
#       Data Field Description:	lower 95th confidence level for predicted values
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:  	pred.UCL95
#       Data Field Description:	upper 95th confidence level for predicted values
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:	meanno3
#       Data Field Description:	mean observed nitrite plus nitrate as nitrogen 
#				concentration for the network of wells
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007

#       DATA FIELD LABEL:  	medno3
#       Data Field Description:	median observed nitrite plus nitrate as nitrogen 
#				concentration for the network of wells
#	Data Field Length/Type:	15n	
#	Data Units:		milligrams per liter as nitrogen	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007

#       DATA FIELD LABEL:  	ratio
#       Data Field Description:	ratio of number no data (nd) to number of observations (nobs)	
#	Data Field Length/Type:	4n	
#	Data Units:		dimensionless	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:  	nobs
#       Data Field Description:	number of observations	
#	Data Field Length/Type:	2n	
#	Data Units:		wells	
#       Data Source: 		calc	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:  	nd
#       Data Field Description:	number of no data	
#	Data Field Length/Type:	2n	
#	Data Units:		wells	
#       Data Source: 		calc
#       Retrieval Date:		April 2007

#--------------------------------------------------------------------------------
#
#	Data FIELD GROUP: Predictor variables/ancillary data		
#
#       DATA FIELD LABEL:	mDiamOIin		
#       Data Field Description:	Mean diameter of open interval for all the wells in a network	
#	Data Field Length/Type:	15n	
#	Data Units:		inches
#       Data Source: 		calc/dwh
#       Retrieval Date:		April 2007
#		
#       DATA FIELD LABEL:  	mwtdepave	
#       Data Field Description:	mean depth to seasonally high water table 
#                               (within 500-meters of the well) for all the wells in a network	
#	Data Field Length/Type:	15n	
#	Data Units:		feet	
#       Data Source: 		calc/dwh	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:	msiltave
#       Data Field Description:	mean percent silt in soil (within 500-meters of a well)
#                               for all the wells in a network	
#	Data Field Length/Type:	15n	
#	Data Units:		percent
#       Data Source: 		calc/dwh	
#       Retrieval Date:  	April 2007	
#
#       DATA FIELD LABEL:	morda
#       Data Field Description:	mean percent Alfisols (within 500-m of the well)
#                               for all the wells in a network	
#	Data Field Length/Type:	15n 	
#	Data Units:		percent	
#       Data Source: 		calc/dwh	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:	mnfarm.10y
#       Data Field Description:	mean 10-year ave (1992-2001) nitrogen applied to farms 
#                               (within 500-m of the well) for all the wells in a network	
#	Data Field Length/Type:	15n	
#	Data Units:		kilograms per year	
#       Data Source: 		calc/dwh	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:	moilength.
#       Data Field Description:	mean length of open interval for all the wells in a network	
#	Data Field Length/Type:	15n	
#	Data Units:		inches	
#       Data Source: 		calc/dwh	
#       Retrieval Date:		April 2007
#
#       DATA FIELD LABEL:	mdepthtoi.
#       Data Field Description:	mean depth to top of open interval for all the wells in a network
#	Data Field Length/Type:	15n	
#	Data Units:		inches	
#       Data Source: 		calc/dwh	
#       Retrieval Date:  	April 2007	
#
#-------------------------------------------------------------------------------
#
#  End METADATA documentation
#
#  BEGIN DATA: 
# ------------------------------------------------------------------------------------------------------
SUCODE	residuals	pred.fit	pred.LCL95	pred.UCL95	mDiamOIin	mwtdepave	msiltave	morda	mnfarm.10y	moilength.	mdepthtoi.	meanno3	medno3	ratio	nobs	nd
rednsus1	-2.086112457	2.156112457	1.207168796	3.105056118	5.75	3.2508	29.4054	0.8088	4341.4648	129	660	0.07	0.07	0.8	5	4
delrsus3	-0.545339623	1.668839623	0.311809104	3.025870141	5.25	4.4714	49.0183	3.0249	305.1575	10	1083.71	1.1235	0.493	0	12	0
lerisus1	-0.520232067	0.617532067	-0.681522435	1.916586568	3.898148	2.5401	45.8779	68.7481	2904.1177	58.6667	1064	0.0973	0.0028	0.89	27	24
almnsus2	-0.42331356	1.80681356	0.518445501	3.09518162	5.966667	2.8899	54.3368	31.855	603.916	71.4	855.36	1.3835	0.17	0.37	30	11
uirbsus1	-0.386041953	1.042441953	-0.051040679	2.135924584	5.378519	4.4411	45.1153	61.9175	1800.7766	49.3333	883.1111	0.6564	0.1007	0.59	27	16
uirbsus2	-0.235143892	1.290943892	-0.008485304	2.590373089	4.004348	2.9741	16.4449	15.0243	4341.4891	58.9565	459.6522	1.0558	0.0137	0.74	23	17
lirbsus1	-0.202647875	0.259247875	-1.668315426	2.186811176	4.4	3.6017	59.9878	21.1629	5959.6598	72	2955.2308	0.0566	0.0534	0.54	26	14
pugtsus1	-0.031511591	1.789711591	0.856778251	2.722644931	5.918276	3.7952	38.5296	2.2712	440.4677	82.125	756.2143	1.7582	1	0.03	29	1
connsus2	-0.027797368	1.418297368	0.098833039	2.737761697	7.909091	4.2331	39.4142	0	279.1273	48.7909	1262.4818	1.3905	0.764	0.27	26	7
lirbsus2	0.2637313	5.6528687	3.637361406	7.668375994	23.67857	3.558	65.8086	49.834	5260.2366	280.7143	447.8571	5.9166	1.9	0.21	28	6
eiwasus2	0.340428587	3.082571413	1.871665305	4.293477522	9.419355	3.7929	51.4132	20.6404	4566.9183	105	792	3.423	0.1629	0.47	32	15
wmicsus2	0.397402486	1.037797514	0.253685022	1.821910006	5.461538	3.641	33.7004	18.9115	677.6841	39	894	1.4352	0.829	0	13	0
rednsus2	0.447330575	0.618669425	-0.943195481	2.180534331	3.366667	5.1287	22.4863	27.4636	1578.6794	70.4	744.56	1.066	0.034	0.73	15	11
hpgwsus4	0.482477938	2.481022062	0.549085526	4.412958599	4.272727	5.5866	64.3636	0	6334.8947	256.3636	1959.8182	2.9635	2.4925	0	22	0
miamsus1	0.609527486	1.600672514	0.219460933	2.981884095	5.509333	4.2738	50.8453	72.8632	3415.2595	46.8969	694.556	2.2102	0.3535	0.33	30	10
rednsus5	1.110084578	1.753315422	0.644904984	2.86172586	4.666667	3.4903	45.3455	0	4395.5349	70	1392	2.8634	0.0001	0.67	6	4
cooksus1a	.	.	.	.	6	.	.	.	.	72	1405.6364	0.6184	0.0952	0.5	22	11
