#  Begin METADATA documentation
------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	MRB4A.explanatory.10.txt
#  DATASET_DESCRIPTION:	This data set was used as part of a nutrient, sediment, and streamflow trend 
#			assessment for the Missouri River Basin.
#  DATA_SET FORMAT:	Tab-delimited ascii file
#  DATA_SET URL:
#
#-------------------------------------------------------------------------------------------------------- 
#  REPORT TITLE: 	Nutrient and Suspended-Sediment Trends in the Missouri River Basin, 1993-2003    
#  REPORT SERIES/NUMBER (JOURNAL NAME/VOLUME): USGS Scientific Investigation Report (SIR 2006-5231)     
#  REPORT URL:		http://pubs.usgs.gov/sir/2006/5231/
#
#-------------------------------------------------------------------------------------------------------
#  NAWQA STUDY:		Major River Basin 4
#
#-------------------------------------------------------------------------------------------------------
#
#  METADATA DATE:    	January 24, 2007
#  METADATA CONTACT: 	Lori Sprague
#                    	USGS-WRD, Colorado Water Science Center 
#                    	Major River Basin study  Missouri River Basin
#                    	Denver Federal Center, Bldg. 53, MS 415,
#	 	     	Lakewood, CO 80225	
#                    	voice: 303-236-4882 x262
#                    	fax:   303-236-4912
#                    	email:  lsprague@usgs.gov
#
#  SECONDARY CONTACT:   Jennifer Flynn
#                    	USGS-WRD, Colorado Water Science Center 
#                    	Major River Basin study  Missouri River Basin
#                    	Denver Federal Center, Bldg. 53, MS 415,
#	 	     	Lakewood, CO 80225	
#                    	voice: 303-236-4882 x300
#                    	fax:   303-236-4912
#                    	email:  jlflynn@usgs.gov
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Data Description:  
#
#  ABSTRACT:	This data set contains nutrient sources and landscpape characteristics for the 
#	10-percent drainage area nearest to each site.  Additional modifications were made to the data 
#	in the original retrieval; these modifications are detailed in Sprague and others, 2006 
#	(SIR 2006-5231). The data were used in a report documenting trends in the Missouri River Basin 
#	as part of the U.S. Geological Survey, National Water-Quality Assessment Program.
#
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#
#	To use the data for nutrient sources and landscape characteristics in weighted least-squares 
#	regression, a single number representing the change in a given data series over time was 
#	generated. When a data series had more than two observations (for example, an annual data 
#	series for fertilizer), the Sen slope estimate for that series was determined for each site. 
#	The Sen slope estimate was calculated as the median of all possible pairwise slopes (Helsel 
#	and Hirsch, 1992). When a data series had only two observations (for example, 1990 and 2000 
#	estimates of population density), the percentage change between the first year and the last 
#	year was determined for each site.
#
#	The data in this file (for all fields except pointsc.n.10.slope) were obtained from one of 
#	2 NAWQA websites (http://water.wr.usgs.gov/pnsp/gis/data/swancil/mrb.html, or 
#	http://water.wr.usgs.gov/pnsp/gis/data/swancil/cycle2.html).  These two websites contained 
#	data that had originally been compiled from other external sources, which are listed below 
#	in the field descriptions and further described in Sprague and others, 2006 (SIR 2006-5231).  
#	Data processing procedures are also described in Sprague and others, 2006 (SIR 2006-5231).  
#
#	All data were obtained from the website 
#	http://water.wr.usgs.gov/pnsp/gis/data/swancil/mrb.html for these sites:
#	06088500
#	06089000
#	06115200
#	06130500
#	06154410
#	06178000
#	06274300
#	06338490
#	06341410
#	06341800
#	06441500
#	06452000
#	06461500
#	06463500
#	06468250
#	06610000
#	06817700
#	06818000
#	06821190
#	06889000
#	06902000
#	06905500
#	06926510
#	06930800
#	06934500
#
#	Data were obtained from http://water.wr.usgs.gov/pnsp/gis/data/swancil/cycle2.html for 
#	these sites:
#	06192500
#	06329500
#	06436180
#	06713500
#	06714000
#	06720500
#	06752260
#	06752280
#	06753990
#	06754000
#	06758500
#	06768000
#	06775900
#	06800000
#	06805500
#	06921070
#
#	Original data for point sources of nitrogen (pointsc.n.10.slope) were obtained from 
#	http://www.epa.gov/enviro/html/pcs/.  Data were processed as described in Appendix 1 of 
#	Sprague and others, 2006 (SIR 2006-5231).  Total N from all point sources within each site 
#	basin were aggregated and summed to provide an annual time series of point source N for 
#	each site.  These data are in the archive file MRB4A.ptsrc.N.txt.
#
#
#  RELATED SPATIAL AND TABULAR DATA SETS:
#
#	All files listed below were used in the analysis for the report Sprague and others, 2006 
#	 (SIR 2006-5231).  These files	are all being documented and archived for this report.
#
#	Trends from 1993 to 2003:		
#		Streamflow: MRB4A.Q.txt
#		Water quality: MRB4A.TN.txt, MRB4A.NOX.txt, MRB4A.NH3.txt, MRB4A.TP.txt, 
#		MRB4A.OP.txt, MRB4A.SS.txt 
#	Base-flow nitrate loads:
#		MRB4A.baseflow.NOX.txt, MRB4A.baseflow.Q.txt, MRB4A.baseflow.NOX.loads.txt
#	Trends from 1985 to 2003:
#		Streamflow: MRB4A.Q.85.03.txt
#		Water quality: MRB4A.TN.85.03.txt, MRB4A.NOX.85.03.txt, MRB4A.TP.85.03.txt, 
#		MRB4A.OP.85.03.txt, MRB4A.SS.85.03.txt  		
#	Suspended-sediment yields:
#		MRB4A.sussed.loads.calibration.txt, MRB4A.Q.sussed.loads.txt, MRB4A.sussed.loads.txt
#	Nutrient sources and landscape characteristics:
#		MRB4A.explanatory.10.txt, MRB4A.explanatory.100.txt, MRB4A.ptsrc.N.txt,
#		MRB4A.spsed.txt, MRB4A.drainagebasins.txt
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#     DATA FIELD LABELS:
#
#	STAID
#	atmdep.n.10.slope
#	fert.n.10.slope
#	fert.p.10.slope
#	manure.n.10.slope
#	manure.p.10.slope
#	pointsc.n.10.slope
#	popden.10.%change
#	consprac.10.%change
#	irrigation.10.%change
#
#     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.
#
#--------------------------------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#
#	DATA FIELD LABEL:		STAID
#       Data Field Description:		USGS Station Number
#	Data Field Length/Type:		15s
#       Data Source: 			USGS National Water Information System (NWIS)
#       Retrieval Date:  		June 1, 2006
#
#
#	DATA FIELD LABEL:		atmdep.n.10.slope
#	Data Field Description:		change in nitrogen input from atmospheric deposition
#					in kilograms per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://pubs.usgs.gov/sir/2006/5012/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		fert.n.10.slope
#	Data Field Description:		change in nitrogen input from fertilizer in kilograms
#					per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://pubs.usgs.gov/sir/2006/5012/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		fert.p.10.slope
#	Data Field Description:		change in phosphorus input from fertilizer in kilograms
#					per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://pubs.usgs.gov/sir/2006/5012/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		manure.n.10.slope
#	Data Field Description:		change in nitrogen input from manure in kilograms
#					per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://pubs.usgs.gov/sir/2006/5012/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		manure.p.10.slope
#	Data Field Description:		change in phosphorus input from manure in kilograms
#					per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://pubs.usgs.gov/sir/2006/5012/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		pointsc.n.10.slope
#	Data Field Description:		change in nitrogen input from point sources in kilograms
#					per square kilometer per year
#	Data Field Length/Type:		6n
#	Data Source:			http://www.epa.gov/enviro/html/pcs/
#					MRB4A.ptsrc.N.txt
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		popden.10.%change
#	Data Field Description:		change in population density
#	Data Field Length/Type:		6n
#	Data Source:			http://www.census.gov/main/www/cen1990.html
#					http://www.census.gov/main/www/cen2000.html
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		consprac.10.%change
#	Data Field Description:		percent change in acreage in conservation practices
#	Data Field Length/Type:		6n
#	Data Source:			http://www.nrcs.usda.gov/TECHNICAL/NRI/
#	Retrieval Date:			June 1, 2006
#
#
#	DATA FIELD LABEL:		irrigation.10.%change
#	Data Field Description:		percent change in irrigated acreage
#	Data Field Length/Type:		6n
#	Data Source:			http://www.nrcs.usda.gov/TECHNICAL/NRI/
#	Retrieval Date:			June 1, 2006
#
#
#  End METADATA documentation
#
#  BEGIN DATA: MRB4A.EXPLANATORY.10.txt
# ------------------------------------------------------------------------------------------------------
STAID	atmdep.n.10.slope	fert.n.10.slope	fert.p.10.slope	manure.n.10.slope	manure.p.10.slope	pointsc.n.10.slope	popden.10.%change	consprac.10.%change	irrigation.10.%change
15s	6n	6n	6n	6n	6n	6n	6n	6n	6n
06088500	-0.028	-27.028	-5.237	-45.763	-12.983	0.000	25.000	-100.000	-3.405
06089000	0.207	-38.695	-8.199	-49.437	-13.902	0.000	20.000	-100.000	-3.530
06115200	0.682	-18.397	-3.457	-15.455	-3.686	-0.013	0.000	-100.000	99.766
06130500	1.367	-1.377	-0.258	-25.067	-6.099	0.000	0.000	15.789	0.460
06154410	0.000	0.000	0.000	-3.688	-0.738	0.000	0.000	0.000	0.000
06178000	3.636	20.209	3.619	5.327	2.101	0.000	0.000	0.000	8.333
06274300	-0.329	-12.589	-3.032	-11.713	-2.427	0.000	0.000	-100.000	6.931
06329500	6.693	-2.275	-0.085	18.254	3.638	-0.417	0.000	3.202	5.316
06338490	6.738	52.508	8.832	38.170	5.584	0.000	0.000	-42.825	5.587
06341410	0.575	124.786	22.112	-0.884	1.496	0.000	0.000	0.000	-1.481
06341800	-1.750	27.616	6.441	36.119	13.383	0.000	100.000	-100.000	-1.481
06436180	2.315	-2.940	-0.738	-36.040	-8.855	0.000	11.111	-100.000	3.226
06441500	-1.872	46.019	7.671	-75.763	-25.037	0.000	0.000	-100.000	-10.000
06452000	-0.519	100.196	17.231	84.133	12.729	0.000	0.000	-48.357	-0.405
06461500	-2.743	5.003	2.697	-29.872	-11.623	0.000	0.000	0.000	-1.783
06463500	0.178	-20.850	10.349	45.115	2.954	0.000	100.000	0.000	-22.414
06468250	-1.668	-112.847	-14.910	11.855	-7.287	0.000	0.000	-68.448	6.250
06713500	3.356	1.613	-2.420	-0.081	0.000	0.000	14.494	0.000	0.000
06714000	1.806	9.245	0.172	-35.110	-10.413	-0.221	26.456	-72.422	-1.836
06752260	-0.385	-20.383	-1.549	-79.572	-25.487	0.000	15.217	0.000	3.776
06752280	-0.698	-40.359	-1.923	-130.675	-38.678	0.000	15.232	0.000	3.776
06753990	0.945	-144.500	-3.406	-233.593	-100.194	0.000	42.857	60.262	10.033
06754000	-0.615	-131.161	-3.500	-245.675	-94.384	-12.763	45.283	60.262	9.239
06758500	-0.305	-81.827	-1.291	-57.782	-41.567	-6.330	23.810	58.655	6.549
06775900	4.059	0.000	0.000	92.999	2.629	0.000	-100.000	0.000	0.000
06800000	-7.458	107.255	36.164	-73.633	-43.388	0.000	50.000	25.773	-5.714
06805500	-5.465	-45.346	23.036	-58.998	-44.618	-5.272	10.000	-15.856	4.140
06817700	-1.473	64.573	12.751	-221.255	-87.991	0.000	-40.000	-8.028	-78.353
06818000	0.000	0.000	0.000	0.000	0.000	0.000		-17.625	
06902000	-3.078	36.841	6.788	39.246	4.172	0.000	0.000	-70.184	-6.863
06905500	-6.925	-25.091	-3.955	28.150	3.414	0.000	0.000	-100.000	-21.159
06921070	-4.607	-8.162	-0.714	182.230	74.245	0.000	50.000	-52.929	-38.211
06926510	-14.972	12.447	2.191	126.680	48.655	0.000	25.000	0.000	14.569
06930800	-12.864	19.090	3.535	74.987	23.137	0.000	42.308	0.251	20.833
06934500	0.000	0.000	0.000	0.000	0.000	0.000		-100.000	

