HRDB: Highway Runoff DataBase - Software page

Documentation

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 and related files on-line

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.           Report and related files on-line

See the SELDM project web page here

Abstract

This report documents highway-runoff database (HRDB), which 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, runoff, and event mean concentrations). The HRDB currently includes 37 tables with data for 39,713 event mean concentration (EMC) measurements (including over 100 water-quality constituents) from 2,650 storm events, monitored at 103 highway-runoff monitoring sites in the conterminous United States, as documented in 7 selected highway-runoff data sets. These data include the 1990 FHWA runoff-quality model data compilation and results from 6 other data sets collected during the period 1993–2005. 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 of constituents, and loads of constituents from highways and in receiving waters at unmonitored sites on the basis of site characteristics.

History

HRDB version 1.0.0 - Initial release 2009

HRDB version 1.0.0a - Added Mass DOT data November 2010

System Requirements

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

Installation package

For best results use the HRDB installation file, it ensures that you have the proper drivers and settings. If you do not own a copy of Access, the installation file will provide a runtime version for use with the HRDB. The installation file was created with the Sagekey Access Deployment Wizard. The uncompiled version is available for advanced Access users. The uncompiled Microsoft Access files listed under source code are provided for future use by model developers.
 
HRDB installation file -- HRDB installation instructions are on the CD-ROM

Source Code (Version 1.0.0)

The HRDB is a Microsoft Access database application, but the model code can be incorportated into stand-alone software.
  Access 2000 format -- Uncompiled version in a .zip file with the application icon (forward compatible)
  Access 2003 format -- Uncompiled version in a .zip file with the application icon (forward compatible)

Interpretive modules
  modPublicStats.bas -- Subroutines and functions necessary for calculating runoff statistics

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. The installed runtime version of the 32-bit application should run, but the compiled version will not run if the user has the 64-bit version of Office installed.

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 sucessfully 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.

User Rights

This software and related material (data and documentation) are made available by the USGS to be used in the public interest and the advancement of science. You may, without any fee or cost, use, copy, modify, or distribute this software, and any derivative works thereof, and its supporting documentation, subject to the USGS Software User Rights Notice

Product Disclaimer

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