Transit Trips

Overview

The transit trips table contains information about fully disaggregate, individual public transit trips for a typical weekday and weekend day in each season. Our data includes trips from over 300 transit agencies and 11,000 routes. Each row of data corresponds to one trip. This dataset can be utilized to generate a number of metrics including origin destination tables and transit line/agency volumes. Data is released twice a year and is currently available for 2019, 2021, 2022 and 2023. It is available for download in CSV format.

Demographic, socioeconomic and employment information about the trip taker can be added for each individual trip by joining this table with the Demographics & Employment table using the person_id and household_id fields.

Schema

Field Name	Content Type	Sample Value	Description
activity_id	String	15323941267251300000	A 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_id	String	4339817784218880000	A randomly assigned unique identifier for each person modeled within the synthetic population.
household_id	String	14408018579505000000	A randomly assigned unique identifier for each household modeled within the synthetic population.
mode	String	PUBLIC_TRANSIT	The 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: • PUBLIC_TRANSIT: Trips that primarily used public transit, such as buses, light rail, and subways
travel_purpose	String	WORK	The destination activity assigned to a synthetic person. For example, if a person is traveling to work, the purpose of the trip is 'Work,' whereas if a person is traveling to a restaurant the activity is 'Eat.' Valid values are: • COMMERCIAL: Trips by medium and heavy trucks for deliveries and other commercial purposes • EAT: Trips to restaurants • HOME: Trips where the destination is the person's home • LODGING: Trips by visitors to overnight accommodation such as a hotel • MAINTENANCE: Trips to hairdressers, auto shops, banks, and a variety of other locations for the purpose of conducting errands • OTHER: Catch-all category for all other trips not assigned any of the purposes listed herein • RECREATION: Trips to recreational destinations such as parks and swimming pools • REGION_DEPARTURE: Trips by visitors to a port-of-exit, such as an airport, or major train station • SCHOOL: Trips to schools such as community colleges and universities • SHOP: Trips to stores and other commercial centers • SOCIAL: Trips for social activities • STAGE: Trips made by non-residents that start and end outside the region • WORK: Trips where the destination is the person's workplace • WORK FROM HOME: Trips where a resident is returning home to work (specifically for residents who are working from home on the modeled day). For example, if a person goes out to lunch during the work day, their return trip home will be labeled “work_from_home"
tour_type	String	COMMUTE	Indicates what type of tour included this trip. Tours are travel events that start at one location and return to that same location. For example, when a person travels to work and returns home, it is a home-based work tour. A tour can have two or more trips. Valid values are: • WORK_BASED: Tours that started and ended at work, excluding commute e.g. Work > Eat > Work • COMMUTE: Tours from home to work and back home including intermediate stops at other destinations e.g. Home > Recreation > Work > Shop > Home • OTHER_HOME_BASED: Tours that started and ended at home, excluding commutes e.g. Home > Shop > Eat > Home
previous_activity_type	String	HOME	The activity assigned to a synthetic person prior to starting travel. Valid values are: • COMMERCIAL: Trips by medium and heavy trucks for deliveries and other commercial purposes • EAT: Trips to restaurants • HOME: Trips where the destination is the person's home • LODGING: Trips by visitors to overnight accommodation such as a hotel • MAINTENANCE: Trips to hairdressers, auto shops, banks, and a variety of other locations • OTHER: Catch all category for all other trips not assigned any of the purposes listed herein • RECREATION: Trips to recreational destinations such as parks and swimming pools • REGION_DEPARTURE: Trips by visitors to a port-of-exit, such as an airport, or major train station • SCHOOL: Trips to schools such as community colleges and universities • SHOP: Trips to stores and other commercial centers • SOCIAL: Trips for social activities • STAGE: Trips made by non-residents that start and end outside the region • WORK: Trips where the destination is the person's workplace
timezone	String	America/Los_Angeles	Timezone of the trip’s start location, using standard tz naming conventions.
start_time	Time	2019-01-10 06:08:00 America/Los_Angeles	Date and 24-hour time of trip start, reported as yyyy-mm-dd hh:mm:ss timezone.
start_local_hour	Integer	12	Hour 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_time	Time	2019-01-10 07:11:04 America/Los_Angeles	Date and 24-hour time of trip end, reported as yyyy-mm-dd hh:mm:ss timezone.
end_local_hour	Integer	14	Hour 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_minutes	Integer	63	Duration of trip in minutes, calculated as the difference between the trip start_time and end_time.
distance_miles	Float	10.79997335	Distance in miles measured along the trip route.
transit_route_ids	String	Capital Metro:803	The ID of the transit route used for a trip. Only applies to trips with mode as “PUBLIC_TRANSIT.” Transit Agency name and Route ID pulled from agency’s GTFS feed.
network_link_ids	String	10541610554341416382	Unique ID assigned to the link (road segment) that the trip is associated with.
vehicle_type	String (Len 20)		NULL for this table
vehicle_fuel_type	STRING		NULL for this table
vehicle_fuel_technology	String		NULL for this table
origin_bgrp	String(Len 12)	410510010004	The US Census Bureau-assigned FIPS code of the block group from which the trip originated.
origin_bgrp_lat	Float	45.492294	Latitude of the geometric centroid for the origin block group, reported in decimal degrees, WGS 84.
origin_bgrp_lng	Float	-122.65334	Longitude of the geometric centroid for the origin block group, reported in decimal degrees, WGS 84.
destination_bgrp	String (Len 12)	410510079001	US Census Bureau-assigned FIPS of the block group in which the trip ended.
destination_bgrp_lat	Float	45.557407	Latitude of the geometric centroid for the destination block group, reported in decimal degrees, WGS 84.
destination_bgrp_lng	Float	-122.54931	Longitude of the geometric centroid for the destination block group, reported in decimal degrees, WGS 84.
origin_land_use_l1	String	residential	The 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_l2	String	single_family	The 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_l1	String	commercial	The 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_l2	String	non_retail_attraction	The 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_l1	String	residential	The 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_l2	String	single_family	The 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_l1	String	commercial	The 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_l2	String	non_retail_attraction	The 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_type	String	II	Indicates 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
agency_name	String	VTA	Agency name pulled from agency GTFS feed of target modeled season.
route_color	String	# AA60BF	Route color pulled from agency GTFS feed of target modeled season. This hexademical code represents the color used in public facing material.
route_id	String	VTA:900	Concatenation of: • agency_name • route_id Pulled from agency GTFS feed of target season.
route_long_name	String	OHLONE/CHYNOWETH-ALMADEN	Long name of route pulled from agency GTFS feed of target modeled season.
route_short_name	String	900	Short name of route pulled from agency GTFS feed of target modeled season.
route_type	integer	1	Route type pulled from agency GTFS feed of target modeled season, using the google GTFS specifications incremented by one by account for an unknown type. For instance, route_type "3" corresponds to rail and route_type "4" corresponds to bus.