Data Model and Relational Database Design for Highway Runoff Water-Quality Metadata

Gregory E. Granato; Steven Tessler

doi:10.3133/ofr2000480

Home/Archive/USGS

USGS · ofr2000480

Data Model and Relational Database Design for Highway Runoff Water-Quality Metadata

Gregory E. Granato·Steven Tessler

View original source ↗Export metadata ↓

Abstract

A National highway and urban runoff waterquality metadatabase was developed by the U.S. Geological Survey in cooperation with the Federal Highway Administration as part of the National Highway Runoff Water-Quality Data and Methodology Synthesis (NDAMS). The database was designed to catalog available literature and to document results of the synthesis in a format that would facilitate current and future research on highway and urban runoff. This report documents the design and implementation of the NDAMS relational database, which was designed to provide a catalog of available information and the results of an assessment of the available data. All the citations and the metadata collected during the review process are presented in a stratified metadatabase that contains citations for relevant publications, abstracts (or previa), and reportreview metadata for a sample of selected reports that document results of runoff quality investigations. The database is referred to as a metadatabase because it contains information about available data sets rather than a record of the original data. The database contains the metadata needed to evaluate and characterize how valid, current, complete, comparable, and technically defensible published and available information may be when evaluated for application to the different dataquality objectives as defined by decision makers. This database is a relational database, in that all information is ultimately linked to a given citation in the catalog of available reports. The main database file contains 86 tables consisting of 29 data tables, 11 association tables, and 46 domain tables. The data tables all link to a particular citation, and each data table is focused on one aspect of the information collected in the literature search and the evaluation of available information. This database is implemented in the Microsoft (MS) Access database software because it is widely used within and outside of government and is familiar to many existing and potential customers. The stratified metadatabase design for the NDAMS program is presented in the MS Access file DBDESIGN.mdb and documented with a data dictionary in the NDAMS_DD.mdb file recorded on the CD-ROM. The data dictionary file includes complete documentation of the table names, table descriptions, and information about each of the 419 fields in the database.

Explore related subjects

Open-File Report Report

Keep this discovery

Explore connections, maps & timelines

BibTeX RIS

Gregory E. Granato, Steven Tessler. 2001. Data Model and Relational Database Design for Highway Runoff Water-Quality Metadata. https://doi.org/10.3133/ofr2000480

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related USGS reports

USGS2026

ECCOE Landsat quarterly calibration and validation report—Quarter 2, 2026

Open-File Report↗

USGS2026

ECCOE Landsat quarterly calibration and validation report—Quarter 1, 2026

Executive Summary The U.S. Geological Survey Earth Resources Observation and Science Calibration and Validation (Cal/Val) Center of Excellence (ECCOE) focuses on improving the accuracy, precision, calibration, and product quality of remote-sensing data, leveraging years of multiscale optical system geometric and radiometric calibration and characterization experience. The ECCOE Landsat Cal/Val Team continually monitors the geometric and radiometric performance of active Landsat missions and makes calibration adjustments, as needed, to maintain data quality at the highest level. This report provides observed geometric and radiometric analysis results for Landsats 8 and 9 for quarter 1 (January–March) of 2026. All data used to compile the Cal/Val analysis results presented in this report are freely available from the U.S. Geological Survey EarthExplorer website: https://earthexplorer.usgs.gov . One specific activity that the ECCOE Landsat Cal/Val Team closely monitored was a Landsat 8 Thermal Infrared Sensor encoder alerts anomaly. On March 18, 2026, the Thermal Infrared Sensor instrument’s mechanism control electronics board reset, driving several parameters to default power-on values. Subsequent telemetry and analysis determined that no persistent hardware misconfiguration was present and no radiometric or geometric degradation was observed.

Open-File Report↗

USGS2026

Floods of June 20–July 6, 2024, in the Big Sioux River, Rock River, Little Sioux River, Ocheyedan River, and Floyd River Basins, northwestern Iowa

Major flooding occurred on June 20–July 6, 2024, in northwestern Iowa affecting the Big Sioux, Rock, Little Sioux, Ocheyedan, and Floyd River Basins. Heavy rain fell in northwestern Iowa, southwestern Minnesota, and southeastern South Dakota on June 20–22, 2024. Parts of northwestern Iowa recorded 2–6 inches of rainfall and localized amounts exceeding 12 inches. A maximum peak-of-record streamflow of 175,000 cubic feet per second at the U.S. Geological Survey streamgage Big Sioux River at Akron, Iowa (06485500), was recorded on June 22, 2024, and had an annual exceedance probability range of 0.2–0.49 percent. High-water marks were measured at four locations along the Big Sioux River between U.S. Interstate 29 at Sioux City, Iowa, upstream to Iowa Highway 10 north of Hawarden, Iowa, a distance of 75.7 river miles. A maximum peak-of-record streamflow of 157,000 cubic feet per second at the U.S. Geological Survey streamgage Rock River near Rock Valley, Iowa (06483500), was recorded on June 22, 2024, and had an annual exceedance probability of less than 0.2 percent. High-water marks were measured at eight locations along the Rock River between County Road B30 east of Hudson, South Dakota, upstream to Iowa Highway 9 at Rock Rapids, Iowa, a distance of 39.3 river miles. A maximum peak-of-record streamflow of 63,000 cubic feet per second at the U.S. Geological Survey streamgage Little Sioux River at Correctionville, Iowa (06606600), was recorded on June 24, 2024, and had an annual exceedance probability range of 0.2–0.49 percent. High-water marks were measured at 11 locations along the Little Sioux River between Iowa Highway 31 west of Correctionville, Iowa, upstream to U.S. Highway 18 north of Spencer, Iowa, a distance of 134.8 river miles. A maximum streamflow of 24,500 cubic feet per second at the U.S. Geological Survey streamgage Ocheyedan River near Spencer, Iowa (06605000), was recorded on June 22, 2024, and had an annual exceedance probability range of 0.2–0.49 percent. High-water marks were measured at three locations along the Ocheyedan River between County Road M38 west of Spencer, Iowa, upstream to U.S. Highway 18 west of Everly, Iowa, a distance of 12.8 river miles. A maximum streamflow of 41,000 cubic feet per second at the U.S. Geological Survey streamgage Floyd River at Alton, Iowa (06600100), was recorded on June 22, 2024, and had an annual exceedance probability range of 1–1.99 percent. High-water marks were measured at six locations along the Floyd River between Iowa Highway 3 at Le Mars, Iowa, upstream to Iowa Highway 10 at Alton, Iowa, a distance of 27.5 river miles. The high-water marks were used to develop flood profiles for the Big Sioux, Rock, Little Sioux, Ocheyedan, and Floyd Rivers.

Iowa, Minnesota, South Dakota↗