Skip to main content

Highway-Runoff Database (HRDB) Version 1.1.0

A data warehouse and preprocessor for the Stochastic Empirical Loading and Dilution Model


Publication Date
Start Date
End Date


Granato, G.E., 2019, Highway-Runoff Database (HRDB) Version 1.1.0: U.S. Geological Survey data release,


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 [...]


Originator :
Gregory E Granato
Metadata Contact :
Gregory E Granato
Publisher :
U.S. Geological Survey
Distributor :
U.S. Geological Survey - ScienceBase
SDC Data Owner :
New England Water Science Center
USGS Mission Area :
Water Resources

Attached Files

Click on title to download individual files attached to this item.

“Schematic diagram”
thumbnail 78.34 KB image/jpeg
“Screen Grab 1”
thumbnail 56.21 KB image/jpeg
“Screen Grab 2”
thumbnail 103.8 KB image/jpeg
thumbnail 36.97 KB image/png
“HRDB icon file”
12.56 KB image/x-icon
“The highway-runoff database”
17.48 MB application/x-msaccess
“Compiled highway-runoff database”
17.39 MB application/msaccess.exec
“Code to calculate the statistics”
21.53 KB text/plain
“Release notes”
26.39 KB text/xml
“Release notes in XML format”
348.67 KB application/pdf
“Read me text file”
12.72 KB text/plain


The HRDB was developed to serve as a data warehouse for current and future highway-runoff data sets (Granato and Cazenas, 2009; Granato, 2013; Granato and others, 2018). The database can be used to document information about a data set, monitoring site(s), highway-runoff data (including precipitation, runoff, and event-mean concentrations of water-quality constituents). The HRDB provides information and data that may be used to assess potential effects of highway runoff on receiving waters and the need for management measures to mitigate the potential for adverse effects on receiving waters. The HRDB application also was developed to serve as a data preprocessor for the Stochastic Empirical Loading and Dilution Model (SELDM).


The Highway-Runoff Database (HRDB) was prepared by the U.S. Geological Survey (USGS) in cooperation with the Federal Highway Administration (FHWA), which are agencies of the U.S. Federal government. The database was compiled from multiple sources including reports and data from the FHWA, state agencies, universities and colleges, and individual researchers. Although the information, metadata, and computer files have been subjected to rigorous review and are substantially complete and accurate, this information is presented without warranty, expressed or implied, as to accuracy or completeness. The USGS and the FHWA reserve the right to revise this database pursuant to further analysis and review. This database has been used by the USGS and is released on condition that the USGS or the FHWA may not be held liable for any damages resulting from their use. Information and numerical methods used in this relational database are attributable to the cited works. Copyright protection under Title 17 is not available for any work of the U.S. Government (17 USC §105). This database application is provided solely for the purposes of private study, scholarship, or research. Therefore, the information in this database is in the public domain for these purposes but may not be available for some commercial uses. By using the HRDB, you agree to appropriately acknowledge the authors, the USGS, and FHWA in publications that result from the use of this database or in products that include this database in whole or in part. Because the database and related material are free and provided "as is," the authors, the USGS, the FHWA, and the United States Government are not obligated to provide users with any support, consulting, training, or assistance of any kind with regard to the use, operation, and performance of this database nor to provide users with any updates, revisions, new versions, or "bug fixes". The use of trade or product names in this database is for identification purposes only and does not constitute endorsement by the U.S. Government.


Spatial Services

ScienceBase WMS


  • USGS Data Release Products
  • USGS New England Water Science Center



Granato, G.E., and Cazenas, P.A., 2009, Highway-Runoff Database (HRDB Version 1.0)--A data warehouse and preprocessor for the stochastic empirical loading and dilution model: Washington, D.C., U.S. Department of Transportation, Federal Highway Administration, FHWA-HEP-09-004, 57 p. Smith, K.P., and Granato, G.E., 2010, Quality of stormwater runoff discharged from Massachusetts highways, 2005-07: U.S. Geological Survey Scientific Investigations Report 2009-5269, 198 p., with CD-ROM Granato, G.E., Desmarais, K.L., Smith, K.P., Weaver, J.C., Glover-Cutter, K.M., Stonewall, A.J., and Fitzgerald, S.A., 2018, Highway-Runoff Database (HRDB) Version 1.0.0b: U.S. Geological Survey data release,

Additional Information


Type Scheme Key
DOI doi:10.5066/P94VL32J

Item Actions

View Item as ...

Save Item as ...

View Item...