#  Begin METADATA documentation
--------------------------------------------------------------------------------------------------------
#  DATASET_NAME: METADATA.fertilizer_N_02_04.txt
#
#  DATASET_DESCRIPTION:	This data set consists of 2002-2004 annual nitrogen from fertilizer for selected 
#  surface-water sites sampled in the MRB7 NAWQA program.
#  
#   			
#  DATA_SET FORMAT: ASCII (tab delimited)	
#  DATA_SET URL:
#
#-------------------------------------------------------------------------------------------------------- 
#  REPORT TITLE: Nutrient and Suspended-Sediment Transport and Trends in the Columbia River and Puget Sound
#  Basins, 1993-2003	
# 
#  REPORT SERIES/NUMBER (JOURNAL NAME/VOLUME): USGS Scientific Investigation Report (SIR 2007-5186)   
#  REPORT URL:
#
#--------------------------------------------------------------------------------------------------------
#  NAWQA STUDY:	Major River Basin 7 (MRB7)	
#
#--------------------------------------------------------------------------------------------------------
#
#  METADATA DATE:	8/13/07   	
#  METADATA CONTACT:    Dan Wise	
#                    	voice: 503.251.3213
#                    	fax:   503.251.3470
#                    	email: dawise@usgs.gov
#
#  SECONDARY CONTACT:   Curt Hughes 
#                    	voice: 503.251.3207
#                    	fax:   503.251.3470
#                    	email: cahughes@usgs.gov
#  
# ------------------------------------------------------------------------------------------------------
#  METADATA Data Description:
#  
#  This data set consists of 2002-2004 annual nitrogen from fertilizer for selected surface-water sites sampled in
#  the MRB7 NAWQA program. The data are based on state fertilizer sales compiled by the Association of American
#  Plant Food control Officials (AAPFCO). Allocation to the county level is based on fertilizer expenditures for
#  farm fertilizer, and on population density for non-farm fertilizer.
#		
#  SUPPLEMENTAL INFORMATION: 
#   
#  Selection of the analysis period and site criteria are detailed in Wise and others, 2007 (SIR 2007-5186). The data sets
#  contain the ancillary data for 136 sites, even though we only used 91 of those. Seven sites were added later and have no ancillary data
#  (sites 10729, 10386, 11386, 10332, 10616, 12012, 11489) and two sites were located too close to the Canadian border to get useful
#  ancillary data (sites 12400520 and 61A070). See Table 1 in Wise and others, 2007 (SIR 2007-5186) for complete site listing.
#
#  Related_Spatial_and_Tabular_Data_Sets:  
#         	
#  Data listed in these files were used in the analysis for the report by Wise and others, 2007 (SIR 2007-5186)
#  
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#     DATA FIELD LABELS:
#
#	STAID
#	FARMN02
#       FARMN03
#	FARMN04
#	NONFN02
#	NONFN03
#	NONFN04
#
#     DATA TYPES: Note-- The row in the data file that follows the row of variable name describes the width of the field and the data type.
#
#		Code:		Variable Type		Variable Length
#	 ---------------------------------------------------------------------------
#		S or s		text variable		numeric value preceding code
#		N or n		numeric variable	numeric value preceding code
#
#	For example: 7n indicated a 0- to 7-character numeric variable whereas 9s indicated a 0- to 9-digit character text variable.
#
#
#--------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#--------------------------------------------------------------------------------
#		
#
#       DATA FIELD LABEL: 		STAID
#       Data Field Description:		Station Identifier
#	Data Field Length/Type:		9s
#       Data Units			Text variable
#	Data Source: 			See metadata files under loads subdirectory for specific agency source
#					(USGS, USBR, Clean Water Services, Oregon DEQ, Washington Dept. of Ecology)				
#       Retrieval Date:  		April 2006
#
#       DATA FIELD LABEL:		FARMN02	
#       Data Field Description:		2002 nitrogen from farm fertilizer (kg)
#	Data Field Length/Type:		9n	
#	Data Units:			numeric		
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:  		April 2006
#
#       DATA FIELD LABEL:		FARMN03	
#       Data Field Description:		2003 nitrogen from farm fertilizer (kg)
#	Data Field Length/Type:		9n	
#	Data Units:			numeric	
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:  		April 2006
#
#       DATA FIELD LABEL:		FARMN04	
#       Data Field Description:		2004 nitrogen from farm fertilizer (kg)
#	Data Field Length/Type:		9n	
#	Data Units:			numeric	
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:			April 2006
#
#       DATA FIELD LABEL:		NONFN02	
#       Data Field Description:		2002 nitrogen from non-farm fertilizer (kg)
#	Data Field Length/Type:		9n	
#	Data Units:			numeric	
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:			April 2006
#
#       DATA FIELD LABEL:		NONFN03	
#       Data Field Description:		2003 nitrogen from non-farm fertilizer (kg)
#	Data Field Length/Type:			
#	Data Units:			numeric	
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:			April 2006
#
#       DATA FIELD LABEL:		NONFN04	
#       Data Field Description:		2004 nitrogen from non-farm fertilizer (kg)
#	Data Field Length/Type:		9n	
#	Data Units:			numeric	
#       Data Source:			Association of American Plant Food control Officials (AAPFCO)		
#       Retrieval Date:			April 2006
#
#  End METADATA documentation
#
#  BEGIN DATA: 
# ------------------------------------------------------------------------------------------------------
STAID	FARMN02	FARMN03	FARMN04	NONFN02	NONFN03	NONFN04
9s	9n	9n	9n	9n	9n	9n
01A050	1248347	1625991	1728557	26731	30217	38931
03A060	892591	1162614	1235951	25130	28669	36725
03B050	137101	178576	189840	4617	5249	6748
07A090	445345	580069	616660	180685	202077	256692
07C070	41728	54352	57780	14286	16010	20382
07D050	183839	239453	254558	81889	91322	115641
07D130	5747	7485	7958	27494	30661	38825
09A080	213796	278473	296039	371691	414499	524866
09A190	102	133	141	911	1016	1287
10350	17232557	21407119	21139093	283427	173063	428726
10355	2053107	2550470	2518537	137975	84389	209081
10386	233593	290180	286547	21474	13134	32540
10406	384300	477397	471419	2086	1283	3183
10407	3805254	4727071	4667886	3533	2131	5258
10411	9477550	11773474	11626065	93864	58743	151111
10508	364671	453012	447340	62755	39410	101717
10555	35110005	43615353	43069271	502802	307900	766154
10640	9752953	12115592	11963900	73186	44924	112270
10663	123942	153967	152039	4936	3019	7480
10674	443134	550482	543590	77748	47314	115982
10948	4066439	5051529	4988281	12868	7959	20014
10A070	344988	449352	477697	145830	163964	207555
11140	2204221	2738190	2703907	62390	38154	94525
11233	1741413	2163268	2136183	76381	46980	118249
11321	295011	366477	361888	296051	179904	439398
11478	324919	403630	398577	1941	1177	2866
11490	97001	120499	118990	942	567	1395
12005	200954	249635	246509	1346	828	2055
12027	10006141	12430114	12274484	20219	12438	30852
12058	0	0	0	0	0	0
12101500	353979	461063	490146	153211	172290	218093
12200500	693125	902806	959754	22209	25326	32439
12391950	7930016	6611532	6911328	619470	427042	799508
12392000	7931891	6613684	6913614	619565	427104	799602
12414900	42805	49115	52172	2663	1698	2483
12416000	147	168	179	97	64	100
12447200	886657	1154884	1227734	4652	5136	6518
12447390	0	0	0	0	0	0
12472900	58947248	76345214	81158322	763431	677185	932258
12552	78	97	96	704	431	1067
12657	0	0	0	0	0	0
13070	89459	111130	109738	5817	3578	9006
13087995	81898696	93689470	99599298	812287	504952	810712
13150430	128751	147730	156925	48	32	48
13203510	282558	324210	344391	3503	2262	3401
13206000	305318	350325	372131	262092	170656	259313
13211445	2461934	2824844	3000677	387045	259364	401929
13213000	8326864	9554316	10149026	2049961	1348218	2062995
13238322	21	24	26	0	0	0
13317000	843871	968265	1028535	13890	8837	13179
13331500	8356	10381	10251	13	8	20
13342500	12258911	14065982	14941520	65947	42218	62669
13353200	195679229	230228599	242939933	3599027	2344771	3615357
13A060	169049	220190	234079	25612	29088	37298
14048000	1985493	2466475	2435594	2529	1526	3720
14128910	373110554	453013965	475632536	5502935	3901548	6073980
14246900	375401740	455948460	478674443	6085573	4466607	6942240
16C090	0	0	0	0	0	0
27D090	21949	28589	30392	15846	18204	23818
32A070	10673400	13760291	14407032	27018	27146	39380
3701002	7702810	9568805	9448999	765339	471352	1181730
3701333	5685668	7063014	6974582	482775	297697	748021
3701391	4919894	6111732	6035210	163246	100772	253736
3701528	1495308	1857545	1834287	41885	25857	65113
3701612	869528	1080170	1066646	8132	5020	12641
3701715	13327	16556	16349	1450	895	2254
3805048	39587	49177	48562	238	147	370
3810015	300553	373361	368687	25500	15742	39642
3820012	503617	625618	617785	291071	179357	450051
3824020	16612	20637	20378	18040	11083	27655
3824072	16612	20637	20378	6839	4169	10244
3835020	297573	369660	365032	6985	4311	10855
3850006	78224	97174	95957	5169	3191	8035
45A070	932092	1214065	1290647	7167	8078	10331
45A110	59338	77288	82164	563	635	812
46A070	89957	117170	124561	293	331	423
48A070	140802	183397	194966	2667	2945	3737
48A140	85064	110797	117786	1561	1723	2187
49A070	884179	1151657	1224303	4310	4758	6039
53A070	9017606	11311072	12021884	688311	592512	824051
54A120	5068719	6169673	6556182	567009	461428	655350
EMM013	2350743	2697263	2865154	68809	44643	66986
GAR120	175	201	214	3716	2427	3712
MAL002	191866	238346	235362	54	32	80
MAL011	1587810	1972455	1947759	902	544	1341
MAL110	31314	38899	38412	4	2	7
MAL111	40782	50661	50027	16	9	23
MAL112	31300	38883	38396	4	2	7
MAL113	4560	5665	5594	3	2	5
MAL144	2730557	3392031	3349561	1243	750	1849
MAL172	5288	6569	6487	3	2	5
OWY101	3700094	4563134	4554128	869	667	1011
12056500	0	0	0	0	0	0
12061500	34106	44424	47226	229	262	340
12108500	100021	130279	138497	24538	27364	34650
12112600	10257	13360	14203	149510	166730	211124
12113375	134	174	186	45951	51243	64888
12113390	212142	276318	293748	357399	398562	504686
12128000	3	4	4	44502	49628	62842
12210700	118285	154068	163787	6572	7429	9572
12212100	158326	206222	219230	3348	3784	4876
12213140	1269298	1653280	1757568	25996	29386	37860
12413000	3048	3498	3715	1689	1090	1642
12413470	676	775	824	12336	7781	11319
12413860	102496	117605	124925	28052	18039	27016
12414500	226	259	275	251	158	230
12419000	1175594	1350322	1434382	313293	206138	318801
12449950	138992	181039	192459	2662	2939	3730
12464770	2164612	2819441	2997288	1702	1913	2436
12471400	7250694	9444142	10039870	1655	1868	2363
12472600	3617936	4712419	5009674	2099	2373	3011
12500450	5597312	7290586	7750470	66496	74883	95314
12505450	720397	938328	997517	926	1041	1324
12510500	16422361	21390382	22739670	115572	130223	165699
13010065	0	0	0	2	0	2
13027500	1004199	1014394	1112711	12448	3935	16472
13055000	4844305	5541828	5891009	13830	9131	14132
13056500	14542914	16670098	17711959	104796	69305	106623
13069500	37541978	42802255	45536349	493653	303013	511795
13073000	1333081	1529589	1624798	2823	1786	2648
13075500	2838466	3256880	3459605	117969	74688	110733
13081500	64041801	73200724	77833862	739813	459042	743359
13090000	89119742	101975064	108400537	822156	511370	820389
13092747	994082	1140619	1211617	32101	21084	31696
13094000	102820834	117695817	125099831	989207	620693	984880
13120500	437	501	532	18	11	17
13152500	3919295	4497033	4776952	48406	31479	47235
13154500	116623700	133535006	141926989	1082122	681086	1075348
13348000	744395	923130	981074	16283	11176	16221
13351000	16455798	20960461	22279708	69790	50235	71728
14200400	8654	10750	10615	202	124	310
14201300	755075	937990	926246	195	120	299
14202000	12594844	15645927	15450034	90371	55485	138775
14206950	1902	2363	2333	179750	110224	274017
14207500	7685711	9547564	9428024	765714	471584	1182306
14211720	76425861	94939917	93751229	2257661	1384522	3448284
