HRDB: Highway Runoff DataBase - Software page

See the SELDM project web page here

Abstract

The highway-runoff database (HRDB) was developed to serve as a data warehouse for current and future highway-runoff data sets. The database can be used by transportation agencies and researchers as a data warehouse to document information about a data set, monitoring site(s), highway- runoff data (including precipitation and runoff), and event mean concentrations. The current version of the HRDB (v 1.1.1a)  includes 37 tables with data for 107,260 event mean concentration (EMC) measurements (including over 414 water-quality constituents) from 6,852 storm events, monitored at 242 highway-runoff monitoring sites in the conterminous United States, as documented in 37 selected highway-runoff data sets. These data include the 1990 FHWA runoff-quality model data compilation and results from 36 other data sets collected during the period 1992–2018. The HRDB application, which is the graphical-user interface and associated computer code, can be used to facilitate estimation of statistical properties of runoff coefficients, runoff-quality statistics, and relations between water-quality variables in highway runoff from the available data. The database application facilitates retrieval and processing of the available data.

Data from Smith and Granato (2010) also are stored in Version 1.0.0a, which includes data from 9 highway-runoff data sets with 117 stations, 4,186 storms, and 54,383 individual stormwater-quality measurements.

The HRDB application can serve as a data preprocessor for the Stochastic Empirical Loading and Dilution Model, which is designed to facilitate the estimation of runoff flows, concentrations, and loads of constituents from highways and in receiving waters at unmonitored sites on the basis of site characteristics.

History

Version 1.1.0a

Granato, G.E. and Friesz, P.J., 2021, Model archive for assessing long-term annual yields of highway and urban runoff in selected areas of California with the Stochastic Empirical Loading Dilution Model (SELDM) U.S. Geological Survey data release, https://doi.org/10.5066/P9B02EUZ. (in review)

Version 1.1.0

Granato, G.E., 2019, Highway-Runoff Database (HRDB) Version 1.1.0: U.S. Geological Survey data release, https://doi.org/10.5066/P94VL32J.

Version 1.0.0b

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.

Version 1.1.0a

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-R. https://pubs.usgs.gov/sir/2009/5269/disc_content_100a_web/ReadMe.htm

Version 1.0.0

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. Report On Line (https://pubs.usgs.gov/sir/2009/5269/disc_content_100a_web/FHWA-HEP-09-004.pdf ) Database-Design Map On Line (https://pubs.usgs.gov/sir/2009/5269/disc_content_100a_web/FHWA-HEP-09-00...)

System Requirements

The HRDB is written in Visual Basic for Applications and therefore use is limited to computers running Microsoft Access. The graphical display forms require a screen resolution exceeding 1024 x 768 pixels.

32-Bit Microsoft Access vs 64-Bit Microsoft Access

This application is developed for the 32-bit version of Microsoft Access. Microsoft recommends the 32-bit version of Office for most users, because it’s more compatible with most other applications. That is why the 32-bit version of Office is the default installation for 32 and 64 bit versions of Windows. The 32-bit Office client is supported as a Windows-32-on-Windows-64 (WOW64) installation. WOW64 is the x86 emulator that enables 32-bit Windows-based applications to run seamlessly on 64-bit Windows systems. This lets users continue to use existing Microsoft ActiveX Controls and COM add-ins with 32-bit Office. Only people who have to manipulate extremely large recordsets (such as spreadsheets with more than one-million rows) would need to use the 64-bit version of Office. Furthermore, 64-bit files are not backward compatible. As such, this database application was created and compiled by using the 32-bit version of MS Access.

If you have the 64-bit version of MS Office use the decompiled version of the 32-bit database (.accdb), copy it over to a 64-bit version of MS Access. Compact and repair the database, then compile the code. At this point you will need to address any errors (such as missing references) and once you have successfully compiled the  database, compact and repair it again. You may make an executable version but keep an uncompiled version for future updates.

Data Requirements

The HRDB is a database application to provide data and statistics for data already in the database.

Support

Limited support is provided for correcting bugs and clarification of how the code is intended to work. Currently, there are no known bugs or suggestions for improvement. For support or to provide feedback or suggestions for improvement, please contact Greg Granato (link to prof page https://www.usgs.gov/staff-profiles/gregory-granato ).

User Rights

Product Disclaimer

Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government.