Enhanced Traffic Pattern Knowledge Abstraction and Presentation from 511 Database

Authors

• Jiannan Ding, Purdue UniversityFollow
• Liya Koshy, Purdue UniversityFollow
• Tanay Maheshwari, Purdue UniversityFollow
• Abin Mathew, Purdue UniversityFollow
• Jue Zhou, Purdue UniversityFollow
• Stanley Chien, Purdue UniversityFollow
• Tianyi Li, Purdue UniversityFollow
• Chengcheng Tao, Purdue UniversityFollow
• Yaobin Chen, Purdue UniversityFollow

Abstract

The explosive growth in the volume, variety, and velocity of transportation data has placed considerable strain on traditional data infrastructures employed by state departments of transportation (state DOTs). Existing traffic information systems are constrained by fragmented data streams, limited historical archiving, and inadequate interoperability, thereby hindering their utility for comprehensive analysis, causal inference, and predictive modeling. This study addresses these challenges by presenting the design and initial implementation of a traffic data integration platform that unifies multi-source datasets and establishes a foundation for more applications. The platform focuses on data integration and access, incorporating systematic data ingestion pipelines, schema harmonization, quality management, and visualization capabilities. Three consecutive steps are performed: 1) identification of data sources, 2) platform data design and implementation, and 3) user interface design. Data source identification classifies source categories and formalizes collection and quality control procedures. Platform data design and implementation demonstrates database structures, ingestion pipelines, and interface protocols. Finally, user interface design supports dynamic user queries and customizable data display formats. It delivers a scalable and interoperable architecture, laying the groundwork for data-driven transportation systems and intelligent planning.

Keywords

traffic databases, data visualization, data ingestion, user interface design

Report Number

FHWA/IN/JTRP-2025/43

SPR Number

4937

Sponsoring Organization

Indiana Department of Transportation

Performing Organization

Joint Transportation Research Program

Publisher Place

West Lafayette, Indiana

Date of Version

2025

DOI

10.5703/1288284318608

Recommended Citation

Ding, J., Koshy, L., Maheshwari, T., Mathew, A., Zhou, J., Chien, S. Y.-P., Li, T., Tao, C., & Chen, Y. (2025). Enhanced traffic pattern knowledge abstraction and presentation from 511 database (Joint Transportation Research Program Publication No. FHWA/IN/JTRP-2025/43). West Lafayette, IN: Purdue University. https://doi.org/10.5703/1288284318608