2003 Seattle Annual Meeting (November 2–5, 2003)

Paper No. 11
Presentation Time: 10:30 AM

USGS NATIONAL WATER QUALITY DATA AND MAPS ON THE WEB


WILLIAMSON, Sandy, Water Resources, US Geol Survey, 1201 Pacific Ave, Suite 600, tacoma, WA 98402 and BOOTH, Nate L., Water Resources, US Geol Survey, 8505 Research Way, Middleton, WI 53562, akwill@usgs.gov

The U.S. Geological Survey’s National Water-Quality Assessment (NAWQA) Program began collecting chemical, biological, and physical water-quality data from 51 large watersheds across the Nation in 1991. In 1999, USGS developed a data warehouse (DWH) for national and regional analysis of data, making most of it available to the public in 2000. Several mapping capabilities were added in 2001. The 2nd decade of NAWQA, in which 42 basins will be resampled, began in 2002. Graphing capabilities and more ecological data were added to the DWH in 2003. The DWH currently contains and links the following data:

• Chemical concentrations in water, sediment, and aquatic tissues • Ecological data on stream habitat and community data on fish, algae and invertebrates • Related quality control data • Stream site, basin, well, and surrounding area characteristics, including thousands of variables such as land use, soils, population density. • Daily stream flow and temperature for several sites in each basin

These data were collected from about 6,100 stream sites and 7,000 wells selected to represent various land uses. About 52,000 water samples were analyzed for nutrients, 34,000 for pesticides, and 11,000 for volatile organic compounds. At about 2,000 sites, streambed sediment and aquatic tissue samples were analyzed for trace elements, pesticides and other organic compounds. About 2,000 fish and 5,000 invertebrate community counts are in the DWH. Most samples were analyzed for 40 to over 100 compounds. Collectively they represent over 10 million water-quality results. The current data set is the largest, nationally consistent water-quality data set for streams and ground water ever assembled. Selected water-quality data can be retrieved in a file or mapped on a web browser for any (or several) county, basin, state, or for all of the U.S. in seconds. These data are readily available to government agencies, universities and the general public to address critical questions about the nation's water quality.

Development principles to maximize functionality while staying on time and on budget included maximum use of state-of-the-art off-the-shelf Oracle and MapInfo software [no product endorsement implied], and development by USGS staff with outside consultants.

More information, data retrieval and mapping tools are at http://water.usgs.gov/nawqa/data.