- Start Date
- 1975-04-15
- End Date
- 2017-11-16
- Publication Date
- 2018-11-19
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.
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 [...]
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 compiled from 37 studies as documented in 113 scientific or technical reports. The dataset includes data from 242 highway sites across the country. It includes data from 6,837 storm events with dates ranging from April 1975 to November 2017. Therefore, these data span more than 40 years; vehicle emissions and background sources of highway-runoff constituents have changed markedly during this time. For example, some of the early data are affected by use of leaded gasoline, phosphorus-based detergents, and industrial atmospheric deposition. The dataset includes 106,441 concentration values with data for 414 different water-quality constituents. This dataset was assembled from various sources and the original data were collected and analyzed by using various protocols. Where possible, the USGS worked with State departments of transportation and the original researchers to obtain, document, and verify the data that were included in the HRDB. However, inclusion in this dataset does not constitute endorsement by the USGS or the FHWA. People who use these data are responsible for ensuring that the data are complete and correct and that it is suitable for their intended purposes.
Click on title to download individual files attached to this item.
MetaData_HighwayRunoffDatabaseV01b.xml
“FDGC compliant metadata”
Original FGDC Metadata
|
View
|
16.6 KB |
application/fgdc+xml |
tblQWHighwayDataSet.txt
“Highway data sets”
|
|
1.66 KB |
text/plain |
tdsAnalysisMethod.txt
“Methods of chemical analysis”
|
|
21.69 KB |
text/plain |
tdsCollectionMethod.txt
“EMC collection methods”
|
|
73 Bytes |
text/plain |
tdsDrainageSystemType.txt
“Highway-site drainage system type”
|
|
114 Bytes |
text/plain |
tdsPavementType.txt
“Highway-site pavement type”
|
|
83 Bytes |
text/plain |
tdsSectionType.txt
“Highway-site section type”
|
|
98 Bytes |
text/plain |
tdsUSEPAParameterCodes.txt
“Chemical parameter definitions”
|
|
771.01 KB |
text/plain |
tdxState.txt
“States and state codes”
|
|
1.4 KB |
text/plain |
HRDBv1.0.1bDataDictionary.txt
“Text-file database dictionary see internal Access documentation”
|
|
187.6 KB |
text/plain |
qryMakeTextTableStormEvents.txt
“Text file of storm-event data”
|
|
1.08 MB |
text/plain |
qryMakeTextTableQAQC.txt
“Text file of dataset QA/QC measures”
|
|
8.31 KB |
text/plain |
qryMakeTextTableLaboratories.txt
“Text file list of Laboratories”
|
|
8.47 KB |
text/plain |
qryMakeTextTableHighwaySites.txt
“Text file of highway-site data”
|
|
92.37 KB |
text/plain |
qryMakeTextTableEMCValues.txt
“Text file of event mean concentrations”
|
|
17.94 MB |
text/plain |
qryMakeTextTableCitations.txt
“Text file of data-set citations”
|
|
31.19 KB |
text/plain |
DOT_FHWA.ico
“Federal highway icon for database”
|
|
12.56 KB |
image/x-icon |
HighwayQWV01.0.0b.accdb
“Microsoft Access 2016 database”
|
|
17.59 MB |
application/x-msaccess |
HighwayQWV01.0.0b.accde
“Compiled Microsoft Access 2016 database”
|
|
17.27 MB |
application/x-msaccess |
HRDBv1.0.0b.exe
“MS Access 2016 installation package”
|
|
245.42 MB |
application/x-msdownload |
ReadMeHRDB.txt
“ASCII read me file”
|
|
13.4 KB |
text/plain |
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
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.