The National Stormwater Quality Database (NSQD) Version 4

Date / Time:
Tuesday, Sep 16 4:55pm to 5:25pm
Location:
Garden 1 & 2
Track / Session:
Description/Abstract: 

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.

Primary Speaker:
Alexander Maestre, The University of Alabama
Alex Maestre is a postdoctoral researcher here at the University of Alabama. He is currently in charge of updating the National Stormwater Quality Database (NSQD). He has more than 15 years of experience in the area of water resources combined with statistics, telematics, and computer science. Dr. Maestre is conducting research on nutrient discharges using regression methods, the use of cyberinfrastructure in the analysis of coastal hazards, analysis of rain deposition constituents in urban environments, and the evaluation of evapotranspiration in floodplain areas. He received his doctorate degree in Environmental Engineering and a Master degree in Applied Statistics in May 2005 at the University of Alabama, Tuscaloosa and a Master in Computer Science at the University of West Florida in 2013.
Supporting Speaker 1:
Robert Pitt, The University of Alabama
Supporting Speaker 2:
Jane Clary, Wright Water Engineers, Inc.