The National Stormwater Quality Database (NSQD) Version 4
The initial version of the National Stormwater Quality Database (NSQD) was created in 2003. Subsequently, the database has been storing results of thousands of Event Mean Concentration (EMC) records of stormwater sampling efforts conducted nationwide. The database stores stormwater sampling results from the Nationwide Urban Runoff Program (NURP), the National Pollutant Discharge Elimination System (NPDES) permit program for Municipal Separate Storm Sewer Systems (MS4), and the United States Geological Survey (USGS) Urban Stormwater Database. Additional stormwater events are being added to being up the total number of records to about 10,000 storms. The new version of the NSQD will be completed in coordination with the International Stormwater Best Management Practices (BMP) Database project.
Version 4 of the database involved three major significant improvements: retrieval of the database in multiple formats, addition of Site Description Reports (SDR) and metadata update, and generation of Stormwater Quality Charts (SQC). Previous versions of the NSQD database were available in Microsoft Excel. In the previous version (version 3) site information and monitoring results were combined in the same spreadsheet. In this new version, the database is also available in text format with a new orientation. In addition to the current format, NSQD can be now downloaded in two text files (one for site information, and one for stormwater results). The new format allows data to be imported easily into statistical programs for further analyses.
In addition to the availability in two different formats, the new version includes reports of each sampling location. These SDR have maps and figures that facilitate the identification of the sampling location and land use characteristics of the runoff catchment. The report includes information about sampling stations, sampling procedures, quality control, sample parameters, analytical methods, and monitoring problems encountered. The metadata information of this new version has been updated. Finally, the new spreadsheet version includes a tab that shows correlations between two or more constituents (i.e., COD and BOD, Ammonia and TKN) to identify unusual observations and outliers.
This presentation will encourage audience to discuss stormwater characteristics from multiple land uses, sampling procedures, and application of the results in the design of stormwater controls.