The core BTS ATRI FMI database contains location and time information logged from a sample of approximately 350,000 unique truck tractors and reflects the movements made by these vehicles within a subset of North America (i.e., the continental United States, Alaska, Hawaii, Puerto Rico, Canada, and a five-mile buffer into Mexico) since October 1, 2018.  

The database currently exceeds 450 billion rows, and new data are added to the database bi-weekly. BTS have long-term plans to add data from 2010 to October 2018.

Every row of the database represents one processed GPS "ping" emitted from a truck and contains thirteen (13) attributes.

The first seven (7) attributes of each ping are provided to users exactly as received from ATRI: 

1. latitude
2. longitude
3. date-time (UTC)
4. vehicle-recorded speed
5. vehicle-recorded heading
6. a unique, anonymized identification code for each truck with most trucks reporting a position update every one to five minutes.
7. FHWA vehicle weight class (1-8)*

BTS then uses these spatial and temporal information to append six (6) additional attributes to each ping:

1. Census Bureau county FIPS codes
2. time zone
3. date-time (local time zone)
4. calculated Haversine distance from previous ping
5. calculated time since previous ping
6. calculated heading from previous ping

The database does not include individual characteristics of the truck that emitted each ping, e.g., size, length, weight, contents/commodity, owner, operator, etc.

* Only available for processed GPS pings received since January 1, 2024.

County to County travel times

Background

This experimental product estimates the county-to-county travel times observed among the trucks in the BTS ATRI FMI database as they traveled throughout North America during 2023. For each unique county pair, BTS calculated the 25th, 50th, and 75th percentile travel times among all the instances where a truck was observed moving between them, referencing the total elapsed time (stopped and moving) between the truck’s last ping in the origin county and its first ping in the destination county. A full summary of the methodology underlying this product is available on ROSA-P.

Notes

Please note two elements of this product that were altered for data confidentiality purposes:

1. county pairs connected by a truck on fewer than one hundred (100) instances are excluded
2. the number of trucks observed on each county pair are indicated using four large bins (100 to 999; 1,000 to 9,999; 10,000 to 99,999; and over 100,000). 

Links

• Data download: Link
• Methodology document: Link

• What kinds of trucks are represented in the BTS ATRI FMI database? The database contains trucks of all FHWA weight classes, although the majority are heavy-duty, fleet-based trucks that belong to FHWA classes 7 and 8. When using these data, be aware that the database has an over-represention of long-distance, fleet trucks and an under-represention of short-distance, drayage trucks, and all resultant statistics will reflect these known biases unless otherwise noted. All processed GPS pings received since January 1, 2024, include an attribute indicating that truck's class designation.
• What restrictions or limitations exist on the database? BTS ATRI FMI data can be used for statistical and research analyses to inform national transportation planning, policy, investment, and operations to freight. BTS ATRI FMI data cannot be used or shared for any regulatory, law enforcement, or adjudicatory purpose, or any federal policy initiative whose stated purpose would clearly and directly negatively affect the rights, privileges, or benefits of an identifiable industry.
• Who can access and use the BTS ATRI FMI data? Access to the BTS ATRI FMI database is strictly limited to federal government employees and their designated contractors. Public-facing products developed from this database, however, are freely accessible, having been approved for release by the BTS data confidentiality officer. BTS ATRI FMI data are the property of ATRI and/or its subcontractors and shall not be disclosed to any third party or released into the public domain, and shall not be duplicated, used, or disclosed, in whole or in part, for any purpose other than as may be authorized in writing by ATRI
• Where are the data stored and analyzed? Authorized federal users can access the BTS ATRI FMI data through the BTS Transportation Data Platform (TDP), a secured, high-powered, cloud-based computing platform used to store, analyze, and visualize confidential big data using common scripting languages. Within the TDP, users can (1) collaborate with designated team members through code and file sharing and (2) upload and interact with outside data files, including geographic information systems (GIS) layers.
• Can the BTS ATRI FMI "ping" data be displayed publicly? BTS ATRI FMI ping data cannot leave the TDP in an unaltered form, although users are permitted to export aggregate analyses performed on the core dataset after those outputs are approved by the BTS disclosure review board and data confidentiality officer. Files that directly or indirectly reveal the operations of an individual business cannot leave the TDP.

If you have any questions about the BTS ATRI FMI program, are interested in working with these data, have feedback about one of the experimental statistics, or are interested in other potential applications of the data, please consult the following resources:

• For questions about BTS publications and data products—including any methodological publications related to BTS ATRI FMI products—contact the BTS National Transportation Library.
• The BTS ATRI Freight Mobility Initiative (FMI) Team is available at btsfmi@dot.gov.