path multimodal table structure#
Aggregated trajectory information for multimodal trips are logged in this table. None of these records are related to an auto-only trip.
Columns starting with Est_ are values as estimated by the router, while columns starting with Act_ represent the actual experienced value during simulation.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
id* |
INTEGER |
NO |
Unique identifier for this multimodal path |
||
traveler_id |
INTEGER |
NO |
0 |
Traveler ID related to the multimodal path (foreign key to Person table) |
|
origin_activity_location |
INTEGER |
NO |
0 |
Origin location from which this path started (foreign key to Location table) |
|
destination_activity_location |
INTEGER |
NO |
0 |
Destination location at which this path ended (foreign key to Location table) |
|
origin_link |
INTEGER |
NO |
0 |
The id of the first link in the path sequence (foreign key to Link table) |
|
destination_link |
INTEGER |
NO |
0 |
The id of the last link in the path sequence (foreign key to Link table) |
|
num_links |
INTEGER |
NO |
0 |
Number of links traversed when executing this multimodal path |
|
departure_time |
INTEGER |
NO |
0 |
The time at which this path started (units: seconds) |
|
Mode |
INTEGER |
NO |
0 |
Mode identifier for trips Values at Mode. |
|
Est_Arrival_Time |
REAL |
YES |
0 |
The time at which this path finished traversing the last link (units: seconds) |
|
Act_Arrival_Time |
REAL |
YES |
0 |
||
Est_Gen_Cost |
REAL |
YES |
0 |
Generalized cost for this path |
|
Act_Gen_Cost |
REAL |
YES |
0 |
||
Est_Duration |
REAL |
YES |
0 |
Time taken to traverse this multimodal link (units: seconds) |
|
Act_Duration |
REAL |
YES |
0 |
||
Est_Wait_Count |
INTEGER |
NO |
0 |
Number of transfers |
|
Act_Wait_Count |
INTEGER |
NO |
0 |
||
Est_TNC_Wait_Count |
INTEGER |
NO |
0 |
Number of transfers to and from a TNC mode |
|
Est_Bus_Wait_Time |
REAL |
YES |
0 |
Wait time to board a bus. Can be 0 if bus is not the next transfer. (units: seconds) |
|
Act_Bus_Wait_Time |
REAL |
YES |
0 |
||
Est_Rail_Wait_Time |
REAL |
YES |
0 |
Wait time to board a rail. Can be 0 if rail is not the next transfer. (units: seconds) |
|
Act_Rail_Wait_Time |
REAL |
YES |
0 |
||
Est_Comm_Rail_Wait_Time |
REAL |
YES |
0 |
Wait time to board a commuter rail. Can be 0 if commuter rail is not the next transfer. (units: seconds) |
|
Act_Comm_Rail_Wait_Time |
REAL |
YES |
0 |
||
Est_Walk_Time |
REAL |
YES |
0 |
Walk time along this link (units: seconds) |
|
Act_Walk_Time |
REAL |
YES |
0 |
||
Est_Bike_Time |
REAL |
YES |
0 |
Bike time along this link (units: seconds) |
|
Act_Bike_Time |
REAL |
YES |
0 |
||
Est_Bus_IVTT |
REAL |
YES |
0 |
Bus in-vehicle travel time along this link (units: seconds) |
|
Act_Bus_IVTT |
REAL |
YES |
0 |
||
Est_Rail_IVTT |
REAL |
YES |
0 |
Rail in-vehicle travel time along this link (units: seconds) |
|
Act_Rail_IVTT |
REAL |
YES |
0 |
||
Est_Comm_Rail_IVTT |
REAL |
YES |
0 |
Commuter rail in-vehicle travel time along this link (units: seconds) |
|
Act_Comm_Rail_IVTT |
REAL |
YES |
0 |
||
Est_Car_Time |
REAL |
YES |
0 |
Auto in-vehicle travel time along this link (units: seconds) |
|
Act_Car_Time |
REAL |
YES |
0 |
||
Est_Transfer_Pen |
REAL |
YES |
0 |
Total transfer penalty incurred in traversing the path (units: seconds) |
|
Act_Transfer_Pen |
REAL |
YES |
0 |
||
Est_Standing_Pen |
REAL |
YES |
0 |
Total penalty for standing in a crowded transit mode incurred in traversing the path (units: seconds) |
|
Act_Standing_Pen |
REAL |
YES |
0 |
||
Est_Capacity_Pen |
REAL |
YES |
0 |
Estimated capacity penalty (using CapacityAlpha from MultimodalRouting.json) when load exceeds a threshold (obtained from inflating transit vehicle capacity by CapacityBeta in MultimodalRouting.json) (units: seconds) |
|
Act_Capacity_Pen |
REAL |
YES |
0 |
||
Est_Monetary_Cost |
REAL |
YES |
0 |
Monetary cost that is incurred in traversing the path (units: $USD) |
|
Act_Monetary_Cost |
REAL |
YES |
0 |
||
Number_of_Switches |
INTEGER |
NO |
0 |
Total number of reroutes/detours that occured during path execution |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Path_Multimodal" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"traveler_id" INTEGER NOT NULL DEFAULT 0,
"origin_activity_location" INTEGER NOT NULL DEFAULT 0,
"destination_activity_location" INTEGER NOT NULL DEFAULT 0,
"origin_link" INTEGER NOT NULL DEFAULT 0,
"destination_link" INTEGER NOT NULL DEFAULT 0,
"num_links" INTEGER NOT NULL DEFAULT 0,
"departure_time" INTEGER NOT NULL DEFAULT 0,
"Mode" INTEGER NOT NULL DEFAULT 0,
"Est_Arrival_Time" REAL NULL DEFAULT 0,
"Act_Arrival_Time" REAL NULL DEFAULT 0,
"Est_Gen_Cost" REAL NULL DEFAULT 0,
"Act_Gen_Cost" REAL NULL DEFAULT 0,
"Est_Duration" REAL NULL DEFAULT 0,
"Act_Duration" REAL NULL DEFAULT 0,
"Est_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"Act_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"Est_TNC_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"Est_Bus_Wait_Time" REAL NULL DEFAULT 0,
"Act_Bus_Wait_Time" REAL NULL DEFAULT 0,
"Est_Rail_Wait_Time" REAL NULL DEFAULT 0,
"Act_Rail_Wait_Time" REAL NULL DEFAULT 0,
"Est_Comm_Rail_Wait_Time" REAL NULL DEFAULT 0,
"Act_Comm_Rail_Wait_Time" REAL NULL DEFAULT 0,
"Est_Walk_Time" REAL NULL DEFAULT 0,
"Act_Walk_Time" REAL NULL DEFAULT 0,
"Est_Bike_Time" REAL NULL DEFAULT 0,
"Act_Bike_Time" REAL NULL DEFAULT 0,
"Est_Bus_IVTT" REAL NULL DEFAULT 0,
"Act_Bus_IVTT" REAL NULL DEFAULT 0,
"Est_Rail_IVTT" REAL NULL DEFAULT 0,
"Act_Rail_IVTT" REAL NULL DEFAULT 0,
"Est_Comm_Rail_IVTT" REAL NULL DEFAULT 0,
"Act_Comm_Rail_IVTT" REAL NULL DEFAULT 0,
"Est_Car_Time" REAL NULL DEFAULT 0,
"Act_Car_Time" REAL NULL DEFAULT 0,
"Est_Transfer_Pen" REAL NULL DEFAULT 0,
"Act_Transfer_Pen" REAL NULL DEFAULT 0,
"Est_Standing_Pen" REAL NULL DEFAULT 0,
"Act_Standing_Pen" REAL NULL DEFAULT 0,
"Est_Capacity_Pen" REAL NULL DEFAULT 0,
"Act_Capacity_Pen" REAL NULL DEFAULT 0,
"Est_Monetary_Cost" REAL NULL DEFAULT 0,
"Act_Monetary_Cost" REAL NULL DEFAULT 0,
"Number_of_Switches" INTEGER NOT NULL DEFAULT 0)
Enums#
The following enums are used in this table.
Mode#
Value |
Description |
|---|---|
0 |
SOV |
1 |
AUTO_NEST |
2 |
HOV |
3 |
TRUCK |
4 |
BUS |
5 |
RAIL |
6 |
NONMOTORIZED_NEST |
7 |
BICYCLE |
8 |
WALK |
9 |
TAXI |
10 |
SCHOOLBUS |
11 |
PARK_AND_RIDE |
12 |
KISS_AND_RIDE |
13 |
PARK_AND_RAIL |
14 |
KISS_AND_RAIL |
15 |
TNC_AND_RIDE |
17 |
MD_TRUCK |
18 |
HD_TRUCK |
19 |
BPLATE |
20 |
LD_TRUCK |
21 |
RAIL_NEST |
22 |
BUS40 |
23 |
BUS60 |
24 |
PNR_BIKE_NEST |
25 |
RIDE_AND_UNPARK |
26 |
RIDE_AND_REKISS |
27 |
RAIL_AND_UNPARK |
28 |
RAIL_AND_REKISS |
29 |
MICROM |
30 |
MICROM_NODOCK |
31 |
MICROM_AND_TRANSIT |
32 |
MICROM_NODOCK_AND_TRANSIT |
33 |
ODDELIVERY |
999 |
FAIL_MODE |
1000 |
FAIL_ROUTE |
1001 |
FAIL_REROUTE |
1002 |
FAIL_UNPARK |
1003 |
FAIL_UNPARK2 |
1004 |
FAIL_MODE1 |
1005 |
FAIL_MODE2 |
1006 |
FAIL_MODE3 |
1007 |
FAIL_ROUTE_ACTIVE |
1008 |
FAIL_ROUTE_WALK_AND_TRANSIT |
1009 |
FAIL_ROUTE_DRIVE_TO_TRANSIT |
1010 |
FAIL_ROUTE_DRIVE_FROM_TRANSIT |
1011 |
FAIL_ROUTE_TNC_AND_TRANSIT |
1012 |
FAIL_ROUTE_TNC |
1013 |
FAIL_ROUTE_SOV |
1014 |
FAIL_ROUTE_MICROMOBILITY |
1015 |
NO_MOVE |
9999 |
UNSIMULATED |