Guides

Commercial Freight Trips

Overview

The commercial freight table contains information about fully disaggregate, individual commercial freight trips for a typical weekday and weekend day in each season. Each row of data corresponds to one trip. Data is released twice a year and is currently available for 2019, 2021, 2022 and 2023. It is available for download in CSV format.

Schema

Field NameContent TypeSample ValueDescription
activity_idString15323941267251300000A randomly assigned unique identifier defined for each trip. A trip is defined as travel between two locations with a discrete purpose at the origin and destination. Some intermediate stops with short dwell time may be captured within a single trip. Criteria for this dwell time may vary. Examples of trips:
• Home > Work,
• Work > Gym,
• Shop > Eat,
• Home > Starbucks drive-thru > Work
person_idString4339817784218880000A randomly assigned unique identifier for each person modeled within the synthetic population.
household_idString14408018579505000000A randomly assigned unique identifier for each household modeled within the synthetic population.
modeStringCOMMERCIALThe primary transportation mode used for the trip. A trip is often made up of multiple travel modes, such as a journey to work that includes a walk to a rail station followed by a subway ride. In this case two modes were used by the traveler during their trip, walking and public transit. Only the primary mode of travel across a set of trip segments is included. The primary mode is determined using the following ranking: 1) Public transit, 2) Driving (private auto)/Auto passenger/Taxi/TNC, 3) Biking, 4) Walking. This table is limited to the following:
• COMMERCIAL: Trips made by medium and heavy trucks
travel_purposeStringCOMMERCIALAll values in this table are:
• COMMERCIAL: Trips by medium and heavy trucks for deliveries and other commercial purposes
tour_typeStringOTHER_HOME_BASEDIndicates what type of tour included this trip. Tours are travel events that start at one location and return to that same location. All values in this table are:
• OTHER_HOME_BASED: Tours that started and ended at home, excluding commutes e.g. Home > Shop > Eat > Home
previous_activity_typeStringCOMMERCIALThe activity assigned to a synthetic person prior to starting travel. All values in this table are:
• COMMERCIAL: Trips by medium and heavy trucks for deliveries and other commercial purposes
timezoneStringAmerica/Los_AngelesTimezone of the trip’s start location, using standard tz naming conventions.
start_timeTime2019-01-10 06:08:00 America/Los_AngelesDate and 24-hour time of trip start, reported as yyyy-mm-dd hh:mm:ss timezone.
start_local_hourInteger12Hour of day that the trip started, reported in the local time zone in 24-hour time format. Values in this field range between 0 and 23.
end_timeTime2019-01-10 07:11:04 America/Los_AngelesDate and 24-hour time of trip end, reported as yyyy-mm-dd hh:mm:ss timezone.
end_local_hourInteger14Hour of day that the trip ended, reported in the local time zone in 24-hour time format. Values in this field range between 0 and 23.
duration_minutesInteger63Duration of trip in minutes, calculated as the difference between the trip start_time and end_time.
distance_milesFloat10.79997335Distance in miles measured along the trip route.
transit_route_idsStringNULL for this table
network_link_idsString10541610554341416382Unique ID assigned to the link (road segment) that the trip is associated with.
vehicle_typeString (Len 20)MEDIUM_COMMERCIALThe vehicle type assigned to the vehicle of the synthetic trip. Valid values are:
• MEDIUM_COMMERCIAL: Medium-duty commercial vehicles (14,000 - 26,000 lbs)
• HEAVY _ COMMERCIAL: Heavy-duty commercial vehicles (>26,00 lbs)
Note: If values are NULL, this means that this data is not available for the region yet but we hope to have it soon.
vehicle_fuel_technologyStringICEThe fuel technology assigned to the vehicle of the synthetic trip. Valid values are:
• ICE
• BEV
• FCV
• PHEV
• UNKNOWN_FUEL_TECHNOLOGY
Note: If values are NULL, this means that this data is not available for the region yet but we hope to have it soon.
origin_bgrpString(Len 12)410510010004The US Census Bureau-assigned FIPS code of the block group from which the trip originated.
origin_bgrp_latFloat45.492294Latitude of the geometric centroid for the origin block group, reported in decimal degrees, WGS 84.
origin_bgrp_lngFloat-122.65334Longitude of the geometric centroid for the origin block group, reported in decimal degrees, WGS 84.
destination_bgrpString (Len 12)410510079001US Census Bureau-assigned FIPS of the block group in which the trip ended.
destination_bgrp_latFloat45.557407Latitude of the geometric centroid for the destination block group, reported in decimal degrees, WGS 84.
destination_bgrp_lngFloat-122.54931Longitude of the geometric centroid for the destination block group, reported in decimal degrees, WGS 84.
origin_land_use_l1StringresidentialThe primary land use category of the trip origin. Valid values are:
• residential
• commercial
• mixed_use
• industrial
• civic_institutional
• transportation_utilities
• open space
• agriculture
• other
• unknown
origin_land_use_l2Stringsingle_familyThe secondary land use category of the trip origin. Valid values are:
• single_family
• multi_family
• office
• retail
• non_retail_attraction
• education
• healthcare
• military
• civic_institutional
• ​​transportation_utilities
• open_space
• agriculture
• other
• unknown
destination_land_use_l1StringcommercialThe primary land use category of the trip destination. Valid values are:
• residential
• commercial
• mixed_use
• industrial
• civic_institutional
• transportation_utilities
• open space
• agriculture
• other
• unknown
destination_land_use_l2Stringnon_retail_attractionThe secondary land use category of the trip destination. Valid values are:
• single_family
• multi_family
• office
• retail
• non_retail_attraction
• education
• healthcare
• military
• civic_institutional
• ​​transportation_utilities
• open_space
• agriculture
• other
• unknown
origin_building_use_l1StringresidentialThe primary building use category of the trip origin. Valid values are:
• residential
• commercial
• industrial
• civic_institutional
• transportation_utilities
• open space
• agriculture
• other
• unknown
origin_building_use_l2Stringsingle_familyThe secondary building use category of the trip origin. Valid values are:
• single_family
• multi_family
• office
• retail
• non_retail_attraction
• education
• healthcare
• military
• civic_institutional
• ​​transportation_utilities
• open_space
• agriculture
• other
• unknown
destination_building_use_l1StringcommercialThe primary building use category of the trip destination. Valid values are:
• residential
• commercial
• industrial
• civic_institutional
• transportation_utilities
• open space
• agriculture
• other
• unknown
destination_building_use_l2Stringnon_retail_attractionThe secondary building use category of the trip destination. Valid values are:
• single_family
• multi_family
• office
• retail
• non_retail_attraction
• education
• healthcare
• military
• civic_institutional
• ​​transportation_utilities
• open_space
• agriculture
• other
• unknown
trip_typeStringIIIndicates whether or not the trip started or ended inside or outside of the core model region. Valid values are:
• II: core > core region
• IE: core > donut region
• EI: donut region > core region
• EE: donut region > donut region