Highway-Runoff Database (HRDB) Version 1.1

The Highway-Runoff Database (HRDB) was developed by the U.S. Geological Survey (USGS), in cooperation with the Federal Highway Administration (FHWA) Office of Project Delivery and Environmental Review to provide planning-level information for decision makers, planners, and highway engineers to assess and mitigate possible adverse effects of highway runoff on the Nation's receiving waters (Granato and Cazenas, 2009; Granato, 2013; Granato and others, 2018). The HRDB was assembled by using a Microsoft Access database application to facilitate use of the data and to calculate runoff-quality statistics with methods that properly handle censored-concentration data. The HRDB was first published as version 1.0 in cooperation with the FHWA in 2009 (Granato and Cazenas, 2009). The second version (1.0.0a) was published in cooperation with the Massachusetts DOT Highway Division to include data from Ohio and Massachusetts (Smith and Granato, 2010). The third version (1.0.0b) was published in cooperation with the Federal Highway Administration to include a substantial amount of additional data (Granato and others, 2018; Granato and Jones, 2019). This version includes data from 242 highway sites across the country; data from 6,837 storm events; and 106,441 concentration values with data for 414 different water-quality constituents. This new version (1.1.0) of the database contains software updates to provide data-quality information within the Graphical User Interface (GUI), calculate statistics for multiple sites in batch mode, and output additional statistics.