#  Begin METADATA documentation
--------------------------------------------------------------------------------------------------------
#  DATASET_NAME: METADATA.fertilizer_P_02_04.txt
#
#  DATASET_DESCRIPTION:	This data set consists of 2002-2004 annual phosphorus 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 phosphorus 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
#	FARMP02
#       FARMP03
#	FARMP04
#	NONFP02
#	NONFP03
#	NONFP04
#
#     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:		FARMP02	
#       Data Field Description:		2002 phosphorus 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:		FARMP03	
#       Data Field Description:		2003 phosphorus 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:		FARMP04	
#       Data Field Description:		2004 phosphorus 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:		NONFP02	
#       Data Field Description:		2002 phosphorus 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:		NONFP03	
#       Data Field Description:		2003 phosphorus 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:		NONFP04	
#       Data Field Description:		2004 phosphorus 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	FARMP02	FARMP03	FARMP04	NONFP02	NONFP03	NONFP04
9s	9n	9n	9n	9n	9n	9n
01A050	132348	169248	170342	2987	6460	4526
03A060	94631	121015	121798	2808	6129	4269
03B050	14535	18587	18708	516	1122	784
07A090	47215	60379	60769	20193	43204	29844
07C070	4424	5657	5694	1596	3423	2369
07D050	19490	24924	25085	9151	19524	13444
07D130	609	779	784	3072	6555	4514
09A080	22666	28986	29173	41539	88620	61022
09A190	10	13	14	101	217	149
10350	1778258	2349353	2906351	31997	19194	92126
10355	211863	279904	346266	15576	9359	44928
10386	24104	31846	39396	2424	1456	6992
10406	39656	52392	64814	235	142	684
10407	392671	518778	641773	398	236	1129
10411	978005	1292094	1598433	10596	6514	32471
10508	37631	49716	61503	7084	4370	21857
10555	3623063	4786626	5921466	56762	34149	164634
10640	1006424	1329642	1644881	8262	4982	24125
10663	12789	16897	20903	557	334	1607
10674	45727	60413	74736	8777	5247	24922
10948	419623	554387	685824	1452	882	4300
10A070	36575	46773	47075	16297	35055	24131
11140	227457	300506	371752	7043	4231	20312
11233	179699	237410	293697	8622	5210	25409
11321	30442	40219	49755	33421	19953	94419
11478	33529	44296	54799	219	130	616
11490	10009	13224	16359	106	62	299
12005	20736	27396	33891	152	91	441
12027	1032551	1364159	1687582	2282	1379	6629
12058	0	0	0	0	0	0
12101500	37528	47992	48301	17122	36835	25356
12200500	73484	93972	94579	2482	5414	3771
12391950	1708240	1472152	1659659	167514	121384	122892
12392000	1708712	1472630	1660180	167531	121394	122904
12414900	10791	10917	11886	460	293	308
12416000	37	37	40	16	11	12
12447200	94002	120211	120988	519	1098	757
12447390	0	0	0	0	0	0
12472900	6658761	8326610	8439223	109099	134216	111614
12552	8	10	13	79	47	229
12657	0	0	0	0	0	0
13070	9231	12196	15087	656	396	1935
13087995	20421205	20650031	22494643	139393	91095	100419
13150430	32458	32837	35751	8	5	6
13203510	71234	72064	78461	605	390	423
13206000	76972	77869	84781	45327	29435	32262
13211445	620663	627897	683630	66937	44736	50005
13213000	2099235	2123701	2312205	354532	232544	256665
13238322	5	5	6	0	0	0
13317000	212743	215222	234326	2402	1524	1639
13331500	862	1139	1409	1	0	4
13342500	3090520	3126538	3404057	11405	7281	7797
13353200	42372198	44235575	48227465	617828	409094	452603
13A060	17922	22919	23067	2862	6219	4336
14048000	204886	270686	334862	286	168	799
14128910	63745918	70194263	76139367	962702	749836	797966
14246900	63986440	70505481	76478602	1028031	858770	926754
16C090	0	0	0	0	0	0
27D090	2327	2975	2995	1770	3892	2769
32A070	1124923	1448856	1532291	3026	5392	5558
3701002	794867	1050141	1299115	86399	52277	253933
3701333	586714	775139	958915	54501	33017	160737
3701391	507693	670740	829763	18429	11176	54523
3701528	154303	203858	252190	4728	2867	13991
3701612	89728	118544	146650	918	556	2716
3701715	1375	1817	2247	163	99	484
3805048	4085	5397	6676	26	16	79
3810015	31014	40975	50689	2878	1746	8518
3820012	51969	68659	84937	32859	19892	96708
3824020	1714	2264	2801	2036	1229	5942
3824072	1714	2264	2801	772	462	2201
3835020	30707	40568	50187	788	478	2332
3850006	8072	10664	13192	583	353	1726
45A070	98819	126371	127188	801	1727	1201
45A110	6291	8044	8096	63	135	94
46A070	9537	12196	12275	32	70	49
48A070	14927	19089	19213	298	629	434
48A140	9018	11532	11607	174	368	254
49A070	93739	119875	120650	481	1017	702
53A070	1365265	1557243	1626107	100703	116112	99033
54A120	944641	1020253	1085362	86460	88389	79327
EMM013	592631	599539	652755	11900	7699	8335
GAR120	44	44	48	642	418	462
MAL002	19799	26157	32359	6	3	17
MAL011	163849	216469	267791	101	60	288
MAL110	3231	4269	5281	0	0	1
MAL111	4208	5560	6878	1	1	4
MAL112	3230	4267	5279	0	0	1
MAL113	470	621	769	0	0	1
MAL144	281771	372263	460521	140	83	397
MAL172	545	721	891	0	0	1
OWY101	454641	574611	676098	191	148	263
12056500	0	0	0	0	0	0
12061500	3615	4624	4654	25	56	39
12108500	10604	13560	13648	2742	5850	4028
12112600	1087	1390	1399	16709	35647	24546
12113375	14	18	18	5135	10956	7544
12113390	22491	28761	28947	39942	85213	58676
12128000	0	0	0	4973	10610	7306
12210700	12540	16036	16140	734	1588	1112
12212100	16785	21465	21604	374	809	566
12213140	134569	172088	173201	2905	6282	4401
12413000	768	777	846	292	188	204
12413470	170	172	187	2133	1342	1408
12413860	25839	26141	28461	4851	3111	3361
12414500	57	57	62	43	27	28
12419000	295020	298721	325133	54179	35557	39662
12449950	14735	18844	18966	297	628	433
12464770	229490	293473	295370	190	409	283
12471400	768712	983035	989388	185	399	274
12472600	383570	490513	493683	234	507	350
12500450	593422	758872	763777	7432	16010	11081
12505450	76375	97670	98301	103	222	153
12510500	1741084	2226512	2240901	12916	27842	19264
13010065	0	0	0	0	0	0
13027500	135282	133490	143804	1928	1515	1955
13055000	1207098	1220762	1328934	2388	1587	1757
13056500	3652156	3694317	4022047	18120	11966	13264
13069500	9230370	9331259	10156470	84288	56264	63230
13073000	336075	339991	370170	488	308	329
13075500	715588	723928	788185	20402	12882	13777
13081500	15918153	16094216	17533729	126860	83176	92040
13090000	22241563	22491644	24499531	141100	92201	101624
13092747	250612	253533	276037	5551	3636	3943
13094000	25695663	25986001	28304053	169991	111057	122089
13120500	110	111	121	3	2	2
13152500	988069	999586	1088310	8371	5430	5876
13154500	29177013	29510063	32137746	186099	121503	133414
13348000	122674	136704	143875	2715	2002	1999
13351000	2190562	2595717	2676566	11324	9216	8787
14200400	893	1179	1459	22	13	66
14201300	77917	102941	127346	22	13	64
14202000	1299684	1717083	2124179	10202	6154	29820
14206950	196	259	320	20292	12224	58881
14207500	793102	1047810	1296231	86442	52302	254057
14211720	7886522	10419309	12889579	254869	153556	740977

