# Begin METADATA documentation ------------------------------------------------------------------------------------------------------ # DATASET_NAME: IR-1_PEST_USE_DATA.txt # DATASET_DESCRIPTION: This data set was used as part of an assessment of trends in # pesticides in streams of the Corn Belt # # DATA_SET FORMAT: Tab-delimited ascii file # DATA_SET URL: # #-------------------------------------------------------------------------------------------------------- # REPORT TITLE: Trends in Pesticide Concentrations in Corn-Belt Streams, 1996-2006 # REPORT SERIES/NUMBER: USGS Scientific Investigations Report 2009-5132 # REPORT URL: http://pubs.usgs.gov/sir/2009/5132/ # #------------------------------------------------------------------------------------------------------- # NAWQA STUDY: Major River Basins 1, 3, and 4 (and Pesticide National Synthesis) # #------------------------------------------------------------------------------------------------------- # # METADATA DATE: October 16, 2009 # METADATA CONTACT: Dan Sullivan # USGS Wisconsin Water Science Center # 8505 Research Way # Middleton, WI 53562 # voice: 608-821-3869 # fax: 608-821-3817 # email: djsulliv@usgs.gov # # Alternate # METADATA Contact: Jeffrey D. Martin # U.S. Geological Survey # NAWQA Pesticide Synthesis Project # 5957 Lakeside Boulevard # Indianapolis, IN 46278-1996 # voice: (317) 290-3333 x148 # fax: (317) 290-3313 # email: jdmartin@usgs.gov# # ------------------------------------------------------------------------------------------------------ # METADATA Data Description: # # ABSTRACT: Annual estimates of agricultural use of each pesticide during 1996-2006 were developed for # all counties in the conterminous U.S. using proprietary data (dmrkynetec, Inc.) on the mass of # pesticides applied to agricultural crops each year and data on county-harvested crop acreage. # Pesticide use estimates, which were based on surveys of major row crops and specialty crops, were # reported for multi-county areas referred to as “Crop Reporting Districts” (CRDs). The estimates were # combined with annual harvested acres available from the 1992, 1997, 2002, and 2007 Census of # Agriculture and NASS annual crop acreage to calculate pesticide application rates for individual crops. # The CRD-level use estimates were disaggregated to county-level application rates by dividing the mass # of pesticides applied to a crop by the acres of that crop in the CRD to yield a rate per harvested # acre. Pesticide estimates were not available for all of the 304 CRDs in the conterminous U.S., nor # for every crop or year; in such cases a crop application rate was estimated from median surveyed # rates for surrounding CRDs. Pesticide-crop application rates were then applied to crop acreages for # each county. Annual pesticide-use intensities for individual watersheds were calculated on the basis # of county-level pesticide use estimates and information on the proportion of agricultural land use in # each of the watersheds. Using a geographic information system, mapped land cover was combined with # the digital maps of drainage basins and county boundaries to compute the basin’s areal weights of # agricultural land in each intersecting county. The basin’s areal weights, or “weighting factors” of # agricultural land, were computed such that a county entirely within the basin had a weighting factor # of 1.0; a county entirely consisting of agricultural land and intersected half-way into the basin # had a value of 0.5; and so forth. The estimated pesticide use for a basin was computed by multiplying # the basin’s county weighting factors by the total county pesticide use and summing the results. The # source for mapped agricultural land for 1996 and 1997 pesticide estimates was U.S. Geological # Survey’s National Land Cover Dataset 1992 (Vogelmann and others, 2001), as enhanced by Nakagaki and # others (2001); for 1998 through 2006 pesticide estimates, the source was U.S. Geological Survey’s # National Land Cover Database 2001 (Homer and others, 2001). # # SUPPLEMENTAL INFORMATION: # # # Related Tabular_Data_Sets: # # All files listed below were used in the analysis for USGS Scientific Investigations Report 2009-5132 # and accompany this file in the archive for this report. # # Files that contain the streamflow data used in the report # # IR-1_flow.txt # # # Files used to .... # # FILE1 HERE # FILE2 HERE # # -------------------------------------------------------------------------------------------------------- # # METADATA Basic documentation of dataset elements: # # DATA FIELD LABELS: # # SITE_ID # DRAINAGE AREA # AREA IN BASIN IN ROWCROPS # YEAR # # DATA TYPES: # # Character: # Numeric: SITE_ID, DRAINAGE AREA, PESTICIDE USE, YEAR # Date/time: # # DATA SOURCES: # Proprietary data (DMRKynetec, Inc.): PESTICIDE USE # The source for mapped agricultural land for 1996 and 1997 pesticide estimates was U.S. Geological # Survey’s National Land Cover Dataset 1992 (Vogelmann and others, 2001), as enhanced by Nakagaki and # others (2001); for 1998 through 2006 pesticide estimates, the source was U.S. Geological Survey’s # National Land Cover Database 2001 (Homer and others, 2001). # #-------------------------------------------------------------------------------- # METADATA Detailed documentation of dataset elements: #-------------------------------------------------------------------------------- # # Data FIELD GROUP: Pesticide Use DATA # # DATA FIELD LABEL: STAID # Data Field Description: Station identifier # Data Field Length/Type: Numeric # Data Source: USGS National Water Information System Web Interface # Retrieval Date: 01/01/2009 # # DATA FIELD LABEL: ST # Data Field Description: Indicates the state from which the portion of the basin area are from. # Data Field Length/Type: Character # Data Units: # Data Source: The source for mapped agricultural land for 1996 and 1997 pesticide estimates was U.S. Geological # Survey’s National Land Cover Dataset 1992 (Vogelmann and others, 2001), as enhanced by Nakagaki and # others (2001); for 1998 through 2006 pesticide estimates, the source was U.S. Geological Survey’s # National Land Cover Database 2001 (Homer and others, 2001). # Retrieval Date: 06/31/2009 # # DATA FIELD LABEL: SITE_ID # Data Field Description: Station identifier # Data Field Length/Type: Numeric # Data Source: USGS National Water Information System Web Interface # Retrieval Date: 01/01/2009 # # DATA FIELD LABEL: DRAINAGE_AREA # Data Field Description: Drainage area # Data Field Length/Type: Numeric # Data Units: Square kilometers # Data Source: USGS National Water Information System Web Interface # Retrieval Date: 01/01/2009 # # # End METADATA documentation # # BEGIN DATA: # ------------------------------------------------------------------------------------------------------ STAID ST AG_KM2 ST_AG_KM2 perc_st_ag_in_basin 03612500 NY 1367.84 31672.43 0.0432 03612500 PA 9580.40 31773.41 0.3015 03612500 OH 41355.01 63125.36 0.6551 03612500 IL 21881.86 113179.30 0.1933 03612500 IN 55849.08 69061.14 0.8087 03612500 WV 6077.80 7838.09 0.7754 03612500 MD 255.11 9641.50 0.0265 03612500 VA 4086.75 24151.13 0.1692 03612500 KY 33151.73 35559.95 0.9323 03612500 NC 1195.98 29762.67 0.0402 03612500 TN 21266.19 33363.19 0.6374 03612500 SC 0.12 17236.03 0.0000 03612500 GA 462.13 35475.23 0.0130 03612500 AL 6317.35 26702.37 0.2366 03612500 MS 165.69 41121.03 0.0040 03303280 NY 1367.84 31672.43 0.0432 03303280 PA 9580.40 31773.41 0.3015 03303280 OH 40687.17 63125.36 0.6445 03303280 IN 6383.81 69061.14 0.0924 03303280 WV 6077.63 7838.09 0.7754 03303280 MD 255.11 9641.50 0.0265 03303280 VA 2520.95 24151.13 0.1044 03303280 KY 12977.64 35559.95 0.3650 03303280 NC 370.88 29762.67 0.0125 03303280 TN 0.31 33363.19 0.0000 05587455 MN 74461.05 110438.42 0.6742 05587455 MI 16.46 49524.30 0.0003 05587455 WI 47249.98 65508.98 0.7213 05587455 MI 16.46 49524.30 0.0003 05587455 SD 3787.67 91340.26 0.0415 05587455 IA 80195.31 119238.62 0.6726 05587455 IL 71976.81 113179.30 0.6360 05587455 IN 6503.22 69061.14 0.0942 05587455 MO 13293.20 97594.89 0.1362 06934500 MT 76323.03 79581.02 0.9591 06934500 MN 4480.20 110438.42 0.0406 06934500 ND 50918.54 110511.96 0.4608 06934500 SD 86249.92 91340.26 0.9443 06934500 WY 8389.74 10042.22 0.8354 06934500 IA 39214.94 119238.62 0.3289 06934500 NE 86655.95 86655.95 1.0000 06934500 CO 22599.66 35369.54 0.6390 06934500 MO 55926.32 97594.89 0.5730 06934500 KS 53269.00 106163.25 0.5018 06805500 WY 4393.33 10042.22 0.4375 06805500 NE 40763.09 86655.95 0.4704 06805500 CO 11414.66 35369.54 0.3227 04193500 MI 921.28 49524.30 0.0186 04193500 OH 10575.90 63125.36 0.1675 04193500 IN 2855.87 69061.14 0.0414 05465500 MN 2407.65 110438.42 0.0218 05465500 IA 24837.46 119238.62 0.2083 05586100 WI 1877.98 65508.98 0.0287 05586100 MI 14.91 49524.30 0.0003 05586100 IL 46729.61 113179.30 0.4129 05586100 IN 6503.22 69061.14 0.0942 05420500 MN 68144.20 110438.42 0.6170 05420500 MI 1.55 49524.30 0.0000 05420500 WI 33579.96 65508.98 0.5126 05420500 SD 3787.67 91340.26 0.0415 05420500 IA 11155.84 119238.62 0.0936 05420500 IL 1794.49 113179.30 0.0159 03378500 OH 671.54 63125.36 0.0106 03378500 IL 11730.03 113179.30 0.1036 03378500 IN 46385.76 69061.14 0.6717 07022000 MT 76347.37 79581.02 0.9594 07022000 MN 79023.59 110438.42 0.7155 07022000 ND 50918.54 110511.96 0.4608 07022000 MI 16.46 49524.30 0.0003 07022000 WI 47249.98 65508.98 0.7213 07022000 MI 16.46 49524.30 0.0003 07022000 SD 90021.05 91340.26 0.9856 07022000 WY 8389.74 10042.22 0.8354 07022000 IA 119238.62 119238.62 1.0000 07022000 NE 86655.95 86655.95 1.0000 07022000 IL 91150.15 113179.30 0.8054 07022000 IN 6503.22 69061.14 0.0942 07022000 CO 22599.66 35369.54 0.6390 07022000 MO 76164.53 97594.89 0.7804 07022000 KS 53269.00 106163.25 0.5018 #