Develop and Analyze ATRI Database

Principal Investigator

Chen-Fu Liao, Senior Systems Engineer, 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.


  • American Transportation Research Institute

Project Details

  • Start date: 02/2007
  • Project Status: Completed
  • Research Area: Transportation Safety and Traffic Flow
  • Topics: Data and modeling, Trucking

Reports or Products: