Skip to main content
USGS - science for a changing world

Highway-Runoff Database (HRDB) Version 1.0.0b

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

Dates

Start Date
1975-04-15
End Date
2017-11-16
Publication Date

Citation

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, https://doi.org/10.5066/P9YG44VQ.

Summary

The Highway-Runoff Database (HRDB) was developed by the U.S. Geological Survey (USGS), in cooperation with the Federal Highway Administration (FHWA) 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. 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. This data release provides highway-runoff data, including information about monitoring sites, precipitation, runoff, and event-mean concentrations of water-quality constituents. The dataset was [...]

Contacts

Attached Files

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

tblQWHighwayDataSet.txt
“Highway data sets”
1.66 KB
tdsAnalysisMethod.txt
“Methods of chemical analysis”
21.69 KB
tdsCollectionMethod.txt
“EMC collection methods”
73 Bytes
tdsDrainageSystemType.txt
“Highway-site drainage system type”
114 Bytes
tdsPavementType.txt
“Highway-site pavement type”
83 Bytes
tdsSectionType.txt
“Highway-site section type”
98 Bytes
tdsUSEPAParameterCodes.txt
“Chemical parameter definitions”
771.01 KB
tdxState.txt
“States and state codes”
1.4 KB
HRDBv1.0.1bDataDictionary.txt
“Text-file database dictionary see internal Access documentation”
187.6 KB
qryMakeTextTableStormEvents.txt
“Text file of storm-event data”
1.08 MB
qryMakeTextTableQAQC.txt
“Text file of dataset QA/QC measures”
8.31 KB
qryMakeTextTableLaboratories.txt
“Text file list of Laboratories”
8.47 KB
qryMakeTextTableHighwaySites.txt
“Text file of highway-site data”
92.37 KB
qryMakeTextTableEMCValues.txt
“Text file of event mean concentrations”
17.94 MB
qryMakeTextTableCitations.txt
“Text file of data-set citations”
31.19 KB
DOT_FHWA.ico
“Federal highway icon for database”
12.56 KB
HighwayQWV01.0.0b.accdb
“Microsoft Access 2016 database”
17.59 MB
HighwayQWV01.0.0b.accde
“Compiled Microsoft Access 2016 database”
17.27 MB
HRDBv1.0.0b.exe
“MS Access 2016 installation package”
245.42 MB
ReadMeHRDB.txt
“ASCII read me file”
13.4 KB
MetaData_HighwayRunoffDatabaseV01b.xml
“FDGC compliant metadata”
Original FGDC Metadata

View
16.46 KB

Purpose

The Highway-Runoff Database (HRDB) was developed by the U.S. Geological Survey, in cooperation with the Federal Highway Administration, to serve as a data warehouse for current and future highway-runoff data sets. 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). Reference Works: 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. https://pubs.usgs.gov/sir/2009/5269/disc_content_100a_web/FHWA-HEP-09-004.pdf Granato, G.E., and Cazenas, P.A., 2009, Data structures of the Highway-Runoff Database (HRDB): Washington, D.C., U.S. Department of Transportation, Federal Highway Administration, FHWA-HEP-09-004, 1 Plate 24 x 18 inches. https://pubs.usgs.gov/sir/2009/5269/disc_content_100a_web/FHWA-HEP-09-004-Plate.pdf 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 https://doi.org/10.3133/sir20095269 Granato, G.E., 2013, Stochastic empirical loading and dilution model (SELDM) version 1.0.0: U.S. Geological Survey Techniques and Methods, book 4, chap. C3, 112 p., CD-ROM https://pubs.usgs.gov/tm/04/c03 Smith, K.P., Sorenson, J.R., and Granato, G.E., 2018, Characterization of stormwater runoff from bridge decks in eastern Massachusetts, 2014-16: U.S. Geological Survey Scientific Investigations Report 2018-5033, 73 p. https://doi.org/10.3133/sir20185033

Rights

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 Federal government. This information 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 FHWA may not be held liable for any damages resulting from their use. The use of trade or product names is for identification purposes only and does not constitute endorsement by the U.S. Government. 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 the 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.

Additional Information

Identifiers

Type Scheme Key
DOI https://www.sciencebase.gov/vocab/category/item/identifier doi:10.5066/P9YG44VQ

Item Actions

View Item as ...

Save Item as ...

View Item...