Oregon Freight Data Mart

Figliozzi, Miguel; Tufte, Kristin A. · 2010 · ROSA P / Oregon Transportation Research and Education Consortium

archive: archived pipeline: cataloged verified

Get this paper ↗ (full text — opens at the source; we link to it, we don't host it)

Summary

This report addresses the challenges of integrating and visualizing freight transportation data to support economic development and efficient resource allocation in Oregon. Increasing freight volumes place pressure on the transportation system, yet data accessibility is hindered by confidentiality issues, dataset complexity, and disparate collection methods. The primary objective was to develop the Oregon Freight Data Mart (OFDM), a web-based mapping prototype that leverages existing public interfaces to provide an intuitive, cost-effective tool for storing, accessing, and communicating freight data. The study aims to streamline data integration, enhance visualization capabilities, and identify institutional and technical barriers to widespread implementation. The OFDM system architecture utilizes Google Maps as the visualization platform, leveraging its Application Programming Interface (API) to overlay diverse data layers. Data storage and retrieval are handled by PORTAL, a PostgreSQL database archive maintained by Portland State University. The system integrates data from multiple sources, including the Port of Portland, the Oregon Department of Transportation (ODOT), and Metro. Data types include truck incidents, truck volumes, bottleneck locations, weigh-in-motion station data, and highway speed reliability. The research team addressed significant integration challenges, such as inconsistent geo-location accuracy, the difficulty of integrating raw data versus static documents (PDFs/Word), and data overlap from conflicting sources. To manage large datasets and reduce user load-times, the authors evaluated four algorithmic simplification methods (Lat/Long Differences, Distance, Triangulation, and Douglas-Peucker) to reduce the number of points in polygon displays while maintaining topological integrity. The findings demonstrate that the OFDM successfully integrates disparate data sources into a single, interactive map interface. Users can visualize truck incidents, volumes, and bottlenecks, with clickable markers providing detailed metadata such as incident times, truck counts, and performance metrics. The system allows for dynamic selection of data layers and date ranges, enhancing the ability to correlate spatial information. The evaluation of simplification algorithms revealed trade-offs between display quality and load-time; while higher point fidelity improves map accuracy, it significantly increases wait times. The Douglas-Peucker algorithm and other simplification strategies were found effective in balancing visual appeal with performance. However, the report identifies that geo-location accuracy varies significantly across sources, with some data requiring manual coordinate identification. Furthermore, data provided as static images or documents limits dynamic querying capabilities compared to raw database formats. The significance of this work lies in demonstrating that Internet-based mapping provides a powerful, low-cost solution for freight data visualization, despite technical hurdles. The authors conclude that institutional barriers, rather than technological limitations, are the most demanding obstacles to implementing such systems. The report recommends standardized data collection methods, improved metadata documentation, and the use of raw data formats to facilitate seamless integration. By leveraging existing web technologies like Google Maps and robust database archives like PORTAL, agencies can accelerate product development and improve the dissemination of freight information. The strategies outlined are applicable to other regions and linear transportation data, offering a framework for future freight planning and data sharing initiatives.

Key finding

Institutional barriers, not technology, are the most demanding hurdles to widely implementing a freight data web-based mapping application.

Methodology

other

Provenance

The full processing record for this entry. Every stage of this paper's journey through the pipeline is logged — what ran, with which tool and model, how many attempts it took, and when it last completed. Discovered via bulk_ingest_rosap on 2026-05-23 (6 acquisition events logged).

Summary generated by qwen3.6-27b-prismaquant on 2026-06-10; verification: verified.

Topics

Ranked by relevance to this paper. Hover a topic for its definition.

• exposure measurement

Information type

What kind of knowledge this paper contributes, grouped by family — independent of topic (what it is about) and method (how it was studied).

• Methodological Resource: dataset resource