# 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 # # ------------------------------------------------------------------------------------------------------ # 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 used to .... # # FILE1 HERE # FILE2 HERE # # Files used to .... # # FILE1 HERE # FILE2 HERE # # -------------------------------------------------------------------------------------------------------- # # METADATA Basic documentation of dataset elements: # # DATA FIELD LABELS: # # STAID # YEAR # PESTICIDE_NAME # BASIN_PEST_USE # # DATA TYPES: # # Character: PESTICIDE_NAME # Numeric: STAID, BASIN_PEST_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: WATER-QUALITY 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: YEAR # Data Field Description: # Data Field Length/Type: Numeric # # DATA FIELD LABEL: PESTICIDE_NAME # Data Field Description: Name of pesticide # Data Field Length/Type: Character # # DATA FIELD LABEL: BASIN_PESTICIDE_USE # Data Field Description: See abstract in this file for how these numbers were computed. # Data Field Length/Type: Numeric # Data Units: Kilograms # Data Source: Proprietary data (DMRKynetec, Inc.) # Retrieval Date: 06/31/2009 # # # End METADATA documentation # # BEGIN DATA: # ------------------------------------------------------------------------------------------------------ STAID YEAR PESTICIDE_NAME BASIN_PEST_USE 03303280 1992 Acetochlor 0 03303280 1993 Acetochlor 0 03303280 1994 Acetochlor 108,917 03303280 1995 Acetochlor 389,162 03303280 1996 Acetochlor 581,245 03303280 1997 Acetochlor 872,282 03303280 1998 Acetochlor 531,477 03303280 1999 Acetochlor 596,896 03303280 2000 Acetochlor 595,223 03303280 2001 Acetochlor 520,258 03303280 2002 Acetochlor 595,466 03303280 2003 Acetochlor 786,342 03303280 2004 Acetochlor 582,495 03303280 2005 Acetochlor 525,240 03303280 2006 Acetochlor 350,187 03378500 1992 Acetochlor 0 03378500 1993 Acetochlor 0 03378500 1994 Acetochlor 74,794 03378500 1995 Acetochlor 1,155,089 03378500 1996 Acetochlor 1,209,942 03378500 1997 Acetochlor 1,316,800 03378500 1998 Acetochlor 1,250,557 03378500 1999 Acetochlor 1,116,608 03378500 2000 Acetochlor 1,495,043 03378500 2001 Acetochlor 1,561,055 03378500 2002 Acetochlor 1,289,273 03378500 2003 Acetochlor 1,573,118 03378500 2004 Acetochlor 1,448,437 03378500 2005 Acetochlor 1,020,736 03378500 2006 Acetochlor 1,000,283 03612500 1992 Acetochlor 0 03612500 1993 Acetochlor 0 03612500 1994 Acetochlor 191,117 03612500 1995 Acetochlor 1,844,285 03612500 1996 Acetochlor 2,114,949 03612500 1997 Acetochlor 2,575,352 03612500 1998 Acetochlor 2,298,210 03612500 1999 Acetochlor 2,148,527 03612500 2000 Acetochlor 2,532,703 03612500 2001 Acetochlor 2,516,077 03612500 2002 Acetochlor 2,199,396 03612500 2003 Acetochlor 2,604,405 03612500 2004 Acetochlor 2,350,185 03612500 2005 Acetochlor 1,804,172 03612500 2006 Acetochlor 1,713,406 04193500 1992 Acetochlor 0 04193500 1993 Acetochlor 0 04193500 1994 Acetochlor 50,631 04193500 1995 Acetochlor 193,106 04193500 1996 Acetochlor 157,379 04193500 1997 Acetochlor 314,401 04193500 1998 Acetochlor 279,636 04193500 1999 Acetochlor 238,547 04193500 2000 Acetochlor 269,487 04193500 2001 Acetochlor 269,567 04193500 2002 Acetochlor 256,888 04193500 2003 Acetochlor 363,933 04193500 2004 Acetochlor 300,733 04193500 2005 Acetochlor 206,368 04193500 2006 Acetochlor 195,518 05420500 1992 Acetochlor 0 05420500 1993 Acetochlor 0 05420500 1994 Acetochlor 647,470 05420500 1995 Acetochlor 1,642,767 05420500 1996 Acetochlor 2,160,577 05420500 1997 Acetochlor 2,079,032 05420500 1998 Acetochlor 2,314,954 05420500 1999 Acetochlor 2,219,454 05420500 2000 Acetochlor 1,936,755 05420500 2001 Acetochlor 1,918,068 05420500 2002 Acetochlor 2,229,744 05420500 2003 Acetochlor 1,864,856 05420500 2004 Acetochlor 2,135,871 05420500 2005 Acetochlor 1,874,825 05420500 2006 Acetochlor 1,465,697 05465500 1992 Acetochlor 0 05465500 1993 Acetochlor 0 05465500 1994 Acetochlor 176,233 05465500 1995 Acetochlor 867,034 05465500 1996 Acetochlor 986,769 05465500 1997 Acetochlor 922,203 05465500 1998 Acetochlor 895,263 05465500 1999 Acetochlor 774,281 05465500 2000 Acetochlor 930,981 05465500 2001 Acetochlor 885,104 05465500 2002 Acetochlor 825,801 05465500 2003 Acetochlor 826,931 05465500 2004 Acetochlor 897,623 05465500 2005 Acetochlor 694,515 05465500 2006 Acetochlor 784,734 05586100 1992 Acetochlor 0 05586100 1993 Acetochlor 0 05586100 1994 Acetochlor 457,157 05586100 1995 Acetochlor 1,250,889 05586100 1996 Acetochlor 1,087,121 05586100 1997 Acetochlor 1,289,837 05586100 1998 Acetochlor 1,214,232 05586100 1999 Acetochlor 1,644,522 05586100 2000 Acetochlor 1,598,880 05586100 2001 Acetochlor 1,618,127 05586100 2002 Acetochlor 1,596,948 05586100 2003 Acetochlor 1,665,740 05586100 2004 Acetochlor 1,563,319 05586100 2005 Acetochlor 1,506,855 05586100 2006 Acetochlor 1,121,350 05587455 1992 Acetochlor 0 05587455 1993 Acetochlor 0 05587455 1994 Acetochlor 1,887,392 05587455 1995 Acetochlor 5,997,712 05587455 1996 Acetochlor 6,750,829 05587455 1997 Acetochlor 6,623,123 05587455 1998 Acetochlor 6,707,866 05587455 1999 Acetochlor 6,764,251 05587455 2000 Acetochlor 6,737,594 05587455 2001 Acetochlor 6,728,334 05587455 2002 Acetochlor 6,788,551 05587455 2003 Acetochlor 6,647,711 05587455 2004 Acetochlor 6,965,685 05587455 2005 Acetochlor 6,404,193 05587455 2006 Acetochlor 5,280,874 06805500 1992 Acetochlor 0 06805500 1993 Acetochlor 0 06805500 1994 Acetochlor 68,929 06805500 1995 Acetochlor 576,455 06805500 1996 Acetochlor 628,952 06805500 1997 Acetochlor 431,387 06805500 1998 Acetochlor 804,098 06805500 1999 Acetochlor 646,777 06805500 2000 Acetochlor 733,549 06805500 2001 Acetochlor 832,011 06805500 2002 Acetochlor 774,889 06805500 2003 Acetochlor 1,067,928 06805500 2004 Acetochlor 1,164,154 06805500 2005 Acetochlor 923,220 06805500 2006 Acetochlor 634,612 06934500 1992 Acetochlor 0 06934500 1993 Acetochlor 0 06934500 1994 Acetochlor 1,414,409 06934500 1995 Acetochlor 2,228,218 06934500 1996 Acetochlor 3,578,831 06934500 1997 Acetochlor 3,728,944 06934500 1998 Acetochlor 4,136,163 06934500 1999 Acetochlor 3,420,915 06934500 2000 Acetochlor 4,145,622 06934500 2001 Acetochlor 3,925,195 06934500 2002 Acetochlor 3,688,517 06934500 2003 Acetochlor 3,785,796 06934500 2004 Acetochlor 4,362,166 06934500 2005 Acetochlor 3,308,883 06934500 2006 Acetochlor 2,884,072 07022000 1992 Acetochlor 0 07022000 1993 Acetochlor 0 07022000 1994 Acetochlor 3,320,252 07022000 1995 Acetochlor 8,406,263 07022000 1996 Acetochlor 10,620,793 07022000 1997 Acetochlor 10,646,437 07022000 1998 Acetochlor 11,305,183 07022000 1999 Acetochlor 10,535,172 07022000 2000 Acetochlor 11,330,549 07022000 2001 Acetochlor 10,966,350 07022000 2002 Acetochlor 10,849,985 07022000 2003 Acetochlor 10,754,442 07022000 2004 Acetochlor 11,732,642 07022000 2005 Acetochlor 10,068,534 07022000 2006 Acetochlor 8,468,701 #