# ------------------------------------------------------------------------------------------------------ # # Begin METADATA documentation # # METADATA Date: June 7, 2010 # 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: # # Filename: Appendix5.txt # # The data provided herein are the urban stream-water site information discussed in # U.S. Geological Survey Scientific Investigations Report 2010-5139, Trends in Pesticide Concentrations # in Urban Streams in the United States, 1992-2008 # URL http://pubs.usgs.gov/sir/2010/5139/ # # Characteristics of 27 stream-water sites are provided in this tab-delimited ASCII file. # # NOTE: This is a "row" format data file. Each row contains information about one stream-water site. # # This data file contains 27 rows of data (excludes rows of METADATA comments, 1 row of # attribute labels, and 1 row of field descriptions). # # ------------------------------------------------------------------------------------------------------ # # METADATA Basic documentation of data set elements: # # Data Attributes: # # mapnum 9N # region 9S # shortname 9S # pstaid 15S # suid 4S # state 2S # drnsqmi 9N # pctinus 9N # lu 5S # lev1ag 9N # lev1urb 9N # huc_code 8S # huc_name 39S # lat 9N # long 9N # datum 6S # llacc 5S # urb2001 9N # urb1992 9N # pctdiffurb 9N # popden2000 9N # popden1990 9N # pctdiffpopden 9N # sname 63S # # # Note: The row in the data file that follows the row of attribute labels describes the # width of the field and the data type. S or s indicates a text attribute, # D or d indicates a date attribute, and N or n indicates a numeric attribute. # For example: 15s indicates a 0- to 15-character text attribute whereas # 9N indicates a 0- to 9-digit numeric attribute. Attribute labels may be longer # than the width of the field. # # # Attribute label: mapnum # # Attribute description: The map number from table 1 of the report # # # Attribute label: region # # Attribute description: The region of the United States where the stream-water site is located # # # Attribute label: shortname # # Attribute description: Short name of the stream-water site (pstaid) from table 1 of the report # # # Attribute label: pstaid # # Attribute description: U.S. Geological Survey (USGS) site identification number. # # Note: pstaid is the "parent" site identification number. At some sites, the actual # location of sample collection (at the "child" site identification number) # may have changed during the period of sample collection, but the sites # are considered equivalent. # # # Attribute label: suid # # Attribute description: National Water-Quality Assessment Program (NAWQA) Study Unit identifier. # # Code Description # ---- ----------------------------------------------------------- # acfb Apalachicola-Chattahoochee-Flint River Basin # albe Albemarle-Pamlico Drainage Basin # conn Connecticut, Housatonic, and Thames River Basins # grsl Great Salt Lake Basins # hdsn Hudson River Basin # leri Lake Erie-Lake Saint Clair Drainages # linj Long Island-New Jersey Coastal Drainages # mise Mississippi Embayment # mobl Mobile River Basin # necb New England Coastal Basins # podl Potomac River Basin and Delmarva Peninsula # pugt Puget Sound Basin # sacr Sacramento River Basin # sana Santa Ana Basin # sant Santee River Basin and Coastal Drainages # sctx South-Central Texas # trin Trinity River Basin # uirb Upper Illinois River Basin # umis Upper Mississippi River Basin # whmi White, Great Miami, and Little Miami River Basins # will Willamette Basin # wmic Western Lake Michigan Drainages # # # Attribute label: state # # Attribute description: State postal abbreviation for stream-water site # # # Attribute label: drnsqmi # # Attribute description: Size of the drainage basin, in square miles # # Source: Determined from drainage basin coverages provided by Study Unit teams as of 03-11-2009. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: pctinus # # Attribute description: Percentage of the drainage basin in the United States # # Source: Determined from drainage basin coverages provided by Study Unit teams as of 03-11-2009 # overlain with a 1:2,000,000-scale coverage of USA international boundaries. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: lu # # Attribute description: Drainage basin land-use class # # Source: Determined from drainage basin coverages provided by Study Unit teams as of 03-11-2009 # overlain with 30-meter resolution NLCD 2001 land-cover data. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # Code Description # ----- ----------------------------------------------------------------------------------- # agric Greater than 50% agricultural land and less than or equal to 5% urban land # undev Less than or equal to 25% agricultural land and less than or equal to 5% urban land # urban Greater than 25% urban land and less than or equal to 25% agricultural land # mixed All other combinations of land use # # Note: 30-meter resolution NLCD 2001 land-cover data was only available for the USA, # consequently, drainage basin land-use class was assigned based on the land-use # proportions in the USA-part of the drainage basin # # # Attribute label: lev1ag # # Attribute description: Percentage of agricultural land use in the USA-part of the drainage basin # # Source: Determined from drainage basin coverages provided by Study Unit teams as of 03-11-2009 # overlain with 30-meter resolution NLCD 2001 land-cover data. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: lev1urb # # Attribute description: Percentage of urban land use in the USA-part of the drainage basin # # Source: Determined from drainage basin coverages provided by Study Unit teams as of 03-11-2009 # overlain with 30-meter resolution NLCD 2001 land-cover data. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: huc_code # # Attribute description: Eight-digit Hydrologic-Unit Code of the stream-water site location # # Source: Determined by overlaying stream-water site locations (lat and long) with # 1:250,000-scale Hydrologic-Unit Code boundaries. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: huc_name # # Attribute description: Name of eight-digit Hydrologic-Unit Code (huc_code) # # Source: Determined by overlaying stream-water site locations (lat and long) with # 1:250,000-scale Hydrologic-Unit Code boundaries. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: lat # # Attribute description: Latitude, decimal degrees # # Source: NAWQA Data Warehouse site information retrieval 04-08-2009. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: long # # Attribute description: Longitude, decimal degrees # # Source: NAWQA Data Warehouse site information retrieval 04-08-2009. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # # Attribute label: datum # # Attribute description: Horizontal datum # # Source: NAWQA Data Warehouse site information retrieval 04-08-2009. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # Code Description # ----- ---------------------------- # NAD27 North American Datum of 1927 # NAD83 North American Datum of 1983 # # # Attribute label: llacc # # Attribute description: Latitude/longitude accuracy code # # Source: NAWQA Data Warehouse site information retrieval 04-08-2009. # Data reported in appendix 4 of Martin, J.D., 2009, Sources and preparation of data # for assessing trends in concentrations of pesticides in streams of the United States, # 1992-2006: U.S. Geological Survey Scientific Investigations Report 2009-5062, 41 p. # Available at http://pubs.usgs.gov/sir/2009/5062/ # # Code Description # ---- ------------------------------------------------------------------------- # S Accurate to +/- 1 second # F Accurate to +/- 5 seconds # # # Attribute label: urb2001 # # Attribute description: Percentage of urban land use in the drainage basin in 2001 # # Sources: U.S. Geological Survey, 2007, National Land Cover Database (NLCD) 1992/2001 retrofit # land cover change product multi-zone download site, [digital files], accessed December 11, 2007 # at http://www.mrlc.gov/mrlc2k_multizone.asp # and # Fry, J.A., Coan, M.J., Homer, C.G., Meyer, D.K., and Wickham, J.D., 2009, Completion of the # National Land Cover Database (NLCD) 1992-2001 Land Cover Change Retrofit product: U.S. # Geological Survey Open-File Report 2008-1379, 18 p. # # # Attribute label: urb1992 # # Attribute description: Percentage of urban land use in the drainage basin in 1992 # # Sources: U.S. Geological Survey, 2007, National Land Cover Database (NLCD) 1992/2001 retrofit # land cover change product multi-zone download site, [digital files], accessed December 11, 2007 # at http://www.mrlc.gov/mrlc2k_multizone.asp # and # Fry, J.A., Coan, M.J., Homer, C.G., Meyer, D.K., and Wickham, J.D., 2009, Completion of the # National Land Cover Database (NLCD) 1992-2001 Land Cover Change Retrofit product: U.S. # Geological Survey Open-File Report 2008-1379, 18 p. # # # Attribute label: pctdiffurb # # Attribute description: Change in urban land use from 1992 to 2001, in percent. Calculated as # (urb2001 - urb1992) / urb1992 * 100 percent # # # Attribute label: popden2000 # # Attribute description: Population density in the drainage basin in 2000, in people per square kilometer # # Sources: Geolytics, Inc., 2001, Census CD 2000 Short Form Blocks, digital files on CD-ROM, # East Brunswick, N.J. # and # U.S. Bureau of the Census, 2001, 2000 Census block group cartographic boundary files: U.S. Census # Bureau, Geography Division, Cartographic Products Management Branch, rev. April 22, 2005, accessed # October 25, 2007, at http://www.census.gov/geo/www/cob/bg2000.html # # # Attribute label: popden1990 # # Attribute description: Population density in the drainage basin in 1990, in people per square kilometer # # Sources: U.S. Bureau of the Census, 1992, Census of population and housing, 1990--Summary Tape file 3A, # U.S. Bureau of the Census, Washington, D.C. # and # U.S. Bureau of the Census, 2001, 1990 Census block group cartographic boundary files: U.S. Census # Bureau, Geography Division, Cartographic Products Management Branch, rev. April 22, 2005, accessed # October 25, 2007, at http://www.census.gov/geo/www/cob/bg1990.html # # # Attribute label: pctdiffpopden # # Attribute description: Change in population density from 1990 to 2000, in percent. Calculated as # (popden2000 - popden1990) / popden1990 * 100 percent # # # Attribute label: sname # # Attribute description: Name of the stream-water site (pstaid) # # # End METADATA documentation # # ------------------------------------------------------------------------------------------------------ mapnum region shortname pstaid suid state drnsqmi pctinus lu lev1ag lev1urb huc_code huc_name lat long datum llacc urb2001 urb1992 pctdiffurb popden2000 popden1990 pctdiffpopden sname 9N 9S 9S 15S 4S 2S 9N 9N 5S 9N 9N 8S 39S 9N 9N 6S 5S 9N 9N 9N 9N 9N 9N 63S 1 Northeast ABERJ 01102500 necb MA 23.07 100 urban 1.64 79.24 01090001 Charles 42.447318 -71.13894 NAD27 S 79.3 78.0 1.7 1141 1126 1.3 Aberjona River at Winchester, MA 2 Northeast CHRLS 01104615 necb MA 268.16 100 urban 6.36 41.21 01090001 Charles 42.364819 -71.18978 NAD27 S 41.2 40.1 2.7 571 534 6.9 Charles River above Watertown Dam at Watertown, MA 3 Northeast NRWLK 01209710 conn CT 32.87 100 urban 2.74 27.62 01100006 Saugatuck 41.135374 -73.42623 NAD27 S 27.6 27.1 1.7 281 255 10.2 Norwalk River at Winnipauk, CT 4 Northeast LISHA 01356190 hdsn NY 15.43 100 urban 4.64 51.01 02020004 Mohawk 42.783688 -73.85679 NAD27 S 51.2 49.3 3.9 552 524 5.3 Lisha Kill near Niskayuna, NY 5 Northeast BOUND 01403900 linj NJ 48.51 100 urban 3.77 61.21 02030105 Raritan 40.585 -74.50778 NAD83 S 61.2 60.3 1.6 1391 1292 7.7 Bound Brook at Middlesex, NJ 6 Northeast ACCOT 01654000 podl VA 23.44 100 urban 10.6 61.66 02070010 Middle Potomac-Anacostia-Occoquan 38.812891 -77.22832 NAD27 S 61.8 59.0 4.8 1610 1440 11.8 Accotink Creek near Annandale, VA 7 South SWIFT 02087580 albe NC 20.82 100 urban 2.83 73.63 03020201 Upper Neuse 35.718889 -78.75222 NAD83 S 73.9 64.4 14.8 726 489 48.5 Swift Creek near Apex, NC 8 South GILLS 02169570 sant SC 59.64 100 urban 3.19 51.79 03050110 Congaree 33.9896 -80.97426 NAD27 S 51.8 50.7 2.2 481 445 8.1 Gills Creek at Columbia, SC 9 South SOPEC 02335870 acfb GA 30.71 100 urban 1.45 74.3 03130001 Upper Chattahoochee 33.953889 -84.44333 NAD83 S 74.4 68.3 9.0 902 793 13.7 Sope Creek near Marietta, GA 10 South CHATT 02338000 acfb GA 2413.38 100 urban 10.84 28.72 03130002 Middle Chattahoochee-Lake Harding 33.477058 -84.90077 NAD27 S 28.8 25.4 13.3 311 231 34.6 Chattahoochee River near Whitesburg, GA 11 South CAHAB 0242354750 mobl AL 25.51 100 urban 6.88 30.1 03150202 Cahaba 33.313446 -86.80638 NAD27 S 30.2 28.4 6.4 275 216 27.3 Cahaba Valley Creek at Cross Creek Road at Pelham, AL 16 Midwest LBUCK 03353637 whmi IN 17.2 100 urban 9.01 86.67 05120201 Upper White 39.666712 -86.19638 NAD27 S 86.9 71.9 20.9 749 572 30.9 Little Buck Creek near Indianapolis, IN 17 Midwest LINCO 040869415 wmic WI 10.03 100 urban 4.61 91.62 04040003 Milwaukee 43.096956 -87.97231 NAD27 S 91.6 91.0 0.7 2222 2184 1.7 Lincoln Creek at 47th Street at Milwaukee, WI 18 Midwest CLINT 04161820 leri MI 309.97 100 urban 9.87 48.41 04090003 Clinton 42.614478 -83.02659 NAD27 S 48.5 46.6 4.1 469 413 13.6 Clinton River at Sterling Heights, MI 19 Midwest SHING 05288705 umis MN 28.2 100 urban 2.82 78.33 07010206 Twin Cities 45.049965 -93.31023 NAD27 S 78.4 76.3 2.7 1093 1045 4.6 Shingle Creek at Queen Avenue at Minneapolis, MN 20 Midwest SALTC 05531500 uirb IL 112.2 100 urban 0.13 90.74 07120004 Des Plaines 41.825833 -87.90028 NAD83 S 90.7 87.0 4.3 1183 1116 6.0 Salt Creek at Western Springs, IL 21 Midwest DPLAI 05532500 uirb IL 630.95 100 urban 18.55 62.98 07120004 Des Plaines 41.822254 -87.82089 NAD27 S 63.0 60.0 5.0 868 780 11.3 Des Plaines River at Riverside, IL 12 South FLTCH 07031692 mise TN 30.48 100 urban 6.68 84.86 08010210 Wolf 35.169534 -89.86592 NAD27 F 85.0 70.7 20.3 847 442 91.6 Fletcher Creek at Sycamore View Road at Memphis, TN 13 South WHITE 08057200 trin TX 66.79 100 urban 3.26 91.04 12030105 Upper Trinity 32.889292 -96.75667 NAD27 F 91.2 77.1 18.2 1510 987 53.0 White Rock Creek at Greenville Avenue at Dallas, TX 14 South SALAD 08178800 sctx TX 195.3 100 urban 0.15 53.47 12100301 Upper San Antonio 29.35718 -98.41279 NAD27 F 53.7 46.1 16.6 624 508 22.8 Salado Creek at Loop 13 at San Antonio, TX 22 West LCOTT 10168000 grsl UT 45.14 100 urban 0.19 28.99 16020204 Jordan 40.663836 -111.9019 NAD27 S 29.0 28.1 3.3 493 473 4.2 Little Cottonwood Creek at Jordan River near Salt Lake City, UT 23 West WARMC 11060400 sana CA 11.93 100 urban 0 96.14 18070203 Santa Ana 34.078346 -117.3003 NAD27 F 96.1 95.6 0.5 1900 1887 0.7 Warm Creek near San Bernardino, CA 24 West SANTA 11074000 sana CA 2261.41 100 urban 5.77 32.56 18070203 Santa Ana 33.883349 -117.6453 NAD27 F 39.1 37.5 4.2 539 451 19.5 Santa Ana River below Prado Dam, CA 25 West ARCAD 11447360 sacr CA 31.48 100 urban 0 99.98 18020111 Lower American 38.641849 -121.3827 NAD27 S 100.0 97.9 2.1 2034 1986 2.4 Arcade Creek near Del Paso Heights, CA 26 West THORN 12128000 pugt WA 11.28 100 urban 0 95.8 17110012 Lake Washington 47.695654 -122.2762 NAD27 S 95.8 95.7 0.1 2364 2205 7.2 Thornton Creek near Seattle, WA 27 West FANNO 14206950 will OR 31.17 100 urban 0.91 86.96 17090010 Tualatin 45.403452 -122.7548 NAD27 S 87.0 85.2 2.1 1502 1202 25.0 Fanno Creek at Durham, OR 15 Midwest HOLES 393944084120700 whmi OH 20.05 100 urban 3.52 85.53 05080002 Lower Great Miami 39.662281 -84.20188 NAD27 S 85.5 82.4 3.8 650 572 13.6 Holes Creek at Huffman Park at Kettering, OH