Develop and Analyze ATRI Database

Principal Investigator(s):

Chen-Fu Liao, Researcher, Mechanical Engineering

Project summary:

One of the key measures of freight performance along interstate corridors in the United States is the average speed of travel. This report documented the findings and analysis of the ATRI Freight Performance Measure (FPM) database systems and investigated a potential FPM system design that can efficiently and effectively process more and larger Automatic Vehicle Location (AVL) datasets collected from various trucking companies. The current FPM system at ATRI evolved from its previous system based on GIS software. The averaged speed calculations resulting from the data process of each FPM system are somewhat different. Analysis of the average speed calculation and investigation of speed differences are discussed in the first chapter of the report. FPM database system analysis and comparison are included in the second chapter. The final chapter presents an ideal FPM system and requirements needed for migration.

Project details:

  • Project number: 2007076
  • Start date: 02/2007
  • Project status: Completed
  • Research area: Transportation Safety and Traffic Flow
  • Topics: Data and modeling, Trucking