#  Begin METADATA documentation
------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	MRB4A.explanatory.spsed.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 31, 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 landscpape characteristics for sites used in spatial sediment 
#	analysis.  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:
#

#	Landscape characteristics were characterized for each site by overlaying the boundary of the 
#	contributing drainage area (Godberson and others, 2006) on the following GIS digital thematic 
#	maps: State Soils Geographic Database (STATSGO) soil properties (Natural Resources Conservation
#	Service, 1994), physiographic divisions (Fenneman and Johnson, 1946), hydrologic landscape 
#	regions (Winter, 2001; Wolock, 2003), the 1:100,000 scale national hydrography data set, and 
#	the 1992 multiresolution land characteristics data set (Vogelmann and others, 2001). 
#	Physiographic divisions are composed of related physiographic provinces, areas of similar 
#	terrain that have been shaped by a common geologic history; hydrologic landscape regions 
#	identify areas with similar hydrologic characteristics. When the basins only partially extended 
#	into one or more counties, county-level data was apportioned according to the amount of 
#	agricultural or urban land contained within the drainage basin, as described by Nakagaki
#	and Wolock (2005). From these data sets, eight primary factors were derived to represent the 
#	landscape characteristics: (1) soil-erodibility factor, K; (2) soil-runoff factor, R; 
#	(3) percentage cultivated area; (4) percentage in the Interior Plains physiographic division; 
#	(5) percentage in the hydrologic landscape regions categorized as Plains; (6) stream density; 
#	(7) the natural logarithm of contributing drainage area; and (8) percentage unregulated area. 
#	The K and R factors were computed as the mean values for each drainage basin. The percentage 
#	cultivated area reflected the sum of four categories (orchards/vineyards/other, row crops, 
#	small grains, and fallow) given in the 1992 land cover data. The percentage of the basin area 
#	in the Interior Plains physiographic division was used as an index to describe the basin 
#	physiography. A similar index was used to describe the hydrologic landscape regions by summing 
#	any of the hydrologic landscape regions associated with the plains (hydrologic landscape 
#	regions 1-8). Stream density was calculated as the length of the hydrography divided by the 
#	basin area. Because of the large range in drainage areas, the natural logarithm of drainage 
#	area was used as a representative index in the comparisons. The percentage of unregulated area 
#	was used to represent the part of the basin not affected by reservoirs with more than 
#	49.3 x 106 m3 of storage.
#
#	The original data for soils, soil properties, physiographic divisions, hydrologic landscape 
#	regions, land use, and stream density 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).  
#
#	Data were obtained from the website http://water.wr.usgs.gov/pnsp/gis/data/swancil/mrb.html 
#	for these sites:
#	06130500
#	06441500
#	06934500
#
#	Data were obtained from http://water.wr.usgs.gov/pnsp/gis/data/swancil/cycle2.html for 
#	these sites:
#	06187915
#	06191500
#	06208500
#	06214500
#	06279500
#	06295000
#	06298000
#	06324970
#	06326500
#	06329500
#	06714000
#	06720500
#	06754000
#	06759910
#	06800000
#	06800500
#	06805500
#	06923150
#	06929315


Godberson, J.A., Zelt, R.B., and Zoller, A.L., 2006, Drainage areas for selected stream-sampling 
stations, Missouri River Basin: U.S. Geological Survey data available on the Web, accessed 
January 2006 at URL http://water.usgs.gov/lookup/getspatial?NE-3071.
#
#	Data from these sites were obtained by processing the national spatial datasets to the 
#	drainage basins that are available at http://water.usgs.gov/GIS/metadata/usgswrd/XML/NE-3071.xml.
#	06452000
#	06705500
#	06714400
#	06714800
#	06879100
#	06882000
#	06884025
#	06887000
#	06888500
#	06891500
#
#
#	Data for Contributing Drainage area were obtained from the USGS National Water Information 
#	System, at http://waterdata.usgs.gov/nwis/inventory.
#
#	The percent unregulated was calculated using these procedures:
#	1st: National inventory of dams (NID) downloaded for the nation 
#	(http://crunch.tec.army.mil/nid/webpages/nid.cfm)
#	2nd: A subset of large dams within MRB4 were extracted from the NID using the criterion of 
#	40,000 acre-ft normal storage or greater
#	3rd: The NID subset from step 2 was then clipped by drainage boundary to obtain a 
#	basin-specific list of large dams
#	4th: For each basin containing large dams, dams that were 'nested' (or located upstream of 
#	another large dam) were removed from the analysis
#	5th: The drainage area of the remaining large dams was spot-checked for accuracy, then 
#	summed for each basin to obtain the 'regulated area'
#	6th: The regulated drainage area computed in step 5 was subtracted from the total drainage 
#	area to obtain the 'unregulated area'
#	7th: The % unregulated area was computed as the unregulated area divided by the total 
#	drainage area
#
#
#  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
#	K
#	R
#	LULC.cultiv
#	Phys.IntPlains
#	HLR.Plains
#	StrmDens
#	CDA
#	NID.unreg
#
#
#     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:		K
#	Data Field Description:		soil-erodability factor
#	Data Field Length/Type:		5n
#	Data Source:			http://www.ncgc.nrcs.usda.gov/products/datasets/statsgo/
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		R
#	Data Field Description:		soil-runoff factor
#	Data Field Length/Type:		5n
#	Data Source:			http://www.ncgc.nrcs.usda.gov/products/datasets/statsgo/
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		LULC.cultiv
#	Data Field Description:		percentage cultivated area
#	Data Field Length/Type:		5n
#	Data Source:			http://edc.usgs.gov/products/landcover/nlcd.html
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		Phys.IntPlains
#	Data Field Description:		percentage in the Interior Plains physiographic division
#	Data Field Length/Type:		6n
#	Data Source:			http://water.usgs.gov/lookup/getspatial?physio
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		HLR.Plains
#	Data Field Description:		percentage in the hydrologic landscape regions 
#					categorized as Plains
#	Data Field Length/Type:		6n
#	Data Source:			http://water.usgs.gov/lookup/getspatial?hlrus
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		StrmDens
#	Data Field Description:		stream density (calculated using stream length)
#	Data Field Length/Type:		6n
#	Data Source:			http://nhd.usgs.gov/data.html
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		CDA
#	Data Field Description:		contributing drainage area
#	Data Field Length/Type:		8n
#	Data Source:			http://waterdata.usgs.gov/nwis/inventory
#	Retrieval Date:			June 1, 2006
#
#	DATA FIELD LABEL:		NID.unreg
#	Data Field Description:		percentage unregulated area (using data from the 
#					National Inventory of Dams)
#	Data Field Length/Type:		5n
#	Data Source:			http://crunch.tec.army.mil/nid/webpages/nid.cfm
#	Retrieval Date:			June 1, 2006
#
#
#  End METADATA documentation
#
#  BEGIN DATA: MRB4A.explanatory.spsed.txt
# ------------------------------------------------------------------------------------------------------
STAID	K	R	LULC.cultiv	Phys.IntPlains	HLR.Plains	StrmDens	CDA	NID.unreg
15s	5n	5n	5n	6n	6n	6n	6n	8n	5n
06130500	0.303	18.4	13.6	89.99	13.60	0.71	20312	100
06187915	0.13	35.7	0.0	0.00	0.00	0.54	81	100
06191500	0.19	25.6	0.0	0.00	2.52	0.50	6780	100
06208500	0.24	21.4	4.3	3.08	0.81	0.93	5235	100
06214500	0.24	22.8	6.3	21.98	1.88	0.77	29534	100
06279500	0.3	16.8	1.3	0.00	3.08	0.79	40806	51
06295000	0.28	19.8	5.4	26.64	4.92	0.81	102144	50
06298000	0.25	41.8	0.0	0.20	0.00	0.59	533	100
06324970	0.31	30.4	1.6	100.00	0.00	0.73	3202	100
06326500	DNU	DNU	DNU	DNU	DNU	DNU	DNU	DNU
06329500	DNU	DNU	DNU	DNU	DNU	DNU	DNU	DNU
06441500	0.342	54.3	19.5	100.00	25.63	0.99	8044	100
06452000	0.316	55.3	11.9	100.00	21.35	0.99	25733	100
06705500	0.123	34.8	0.0	0.00	0.00	0.46	193	100
06714000	0.17	33.2	0.4	20.74	1.75	0.60	9996	55
06714400	0.109	34.2	0.0	0.00	0.00	0.35	31	100
06714800	0.109	36.3	0.0	0.00	0.00	0.34	31	100
06720500	0.17	33.9	1.3	25.53	4.34	0.60	12344	63
06754000	0.19	34.5	8.9	38.62	12.93	0.72	25006	99
06759910	0.22	36.8	16.5	63.39	23.59	0.67	43035	99
06800000	0.32	129	81.0	100.00	51.61	0.91	953	100
06800500	0.26	115	56.1	100.00	67.21	0.60	15197	100
06805500	0.255	62	20.8	73.05	29.16	0.60	183811	63
06879100	0.304	11.1	41.7	100.00	53.90	0.85	116163	17
06882000	0.33	14.9	77.4	100.00	92.67	0.86	11313	100
06884025	0.325	14.3	68.1	100.00	84.25	1.04	7125	100
06887000	0.331	15.8	66.3	100.00	76.66	0.88	24957	1
06888500	DNU	DNU	DNU	DNU	DNU	DNU	DNU	DNU
06891500	0.348	22.8	25.4	100.00	32.17	1.03	1100	11
06923150	DNU	DNU	DNU	DNU	DNU	DNU	DNU	DNU
06929315	DNU	DNU	DNU	DNU	DNU	DNU	DNU	DNU
06934500	0.292	72.8	27.0	80.47	31.19	0.68	1352690	34
