path multimodal links table structure#
Path_multimodal_links table shows the trajectory in detail for each multimodal path logged in the Path_Multimodal table. Each record in the Path_multimodal_links table is a link that was traversed by the traveler using various modes.
Link-specific router-estimates and experienced values are logged in this table. Definitions for the variable in columns known as ‘value_{variable}’ can be found in the Path_Multimodal table description. Unique column descriptions are logged below.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
object_id |
INTEGER |
NO |
Path_Multimodal(object_id) |
The multimodal path that this link is a part of (foreign key to Path_Multimodal table) |
|
index |
INTEGER |
NO |
Sequence number for this link within the overall path |
||
value_link |
INTEGER |
NO |
0 |
The link which makes up this part of the overall path (foreign key to Link table) |
|
value_dir |
INTEGER |
NO |
The direction of travel on the link {0: a->b, 1: b->a} |
||
value_link_type |
INTEGER |
NO |
0 |
Integer refering to the type of link. Values at value_link_type. |
|
value_transit_vehicle_trip |
INTEGER |
NO |
0 |
If this path utilised transit to traverse this link, the id of the corresponding transit trip (foreign key to Transit_Trips table) |
|
value_transit_vehicle_stop_sequence |
INTEGER |
NO |
0 |
Non-zero integer represents a valid transit stop sequence used to distinguish transit stop or transfers. Zero when transit stop sequence is not used. |
|
value_Est_Arrival_Time |
REAL |
YES |
0 |
||
value_Act_Arrival_Time |
REAL |
YES |
0 |
||
value_Est_Gen_Cost |
REAL |
YES |
0 |
||
value_Act_Gen_Cost |
REAL |
YES |
0 |
||
value_Est_Duration |
REAL |
YES |
0 |
||
value_Act_Duration |
REAL |
YES |
0 |
||
value_Est_Wait_Count |
INTEGER |
NO |
0 |
||
value_Act_Wait_Count |
INTEGER |
NO |
0 |
||
value_Est_TNC_Wait_Count |
INTEGER |
NO |
0 |
||
value_Est_Bus_Wait_Time |
REAL |
YES |
0 |
||
value_Act_Bus_Wait_Time |
REAL |
YES |
0 |
||
value_Est_Rail_Wait_Time |
REAL |
YES |
0 |
||
value_Act_Rail_Wait_Time |
REAL |
YES |
0 |
||
value_Est_Comm_Rail_Wait_Time |
REAL |
YES |
0 |
||
value_Act_Comm_Rail_Wait_Time |
REAL |
YES |
0 |
||
value_Est_Walk_Time |
REAL |
YES |
0 |
||
value_Act_Walk_Time |
REAL |
YES |
0 |
||
value_Est_Bike_Time |
REAL |
YES |
0 |
||
value_Act_Bike_Time |
REAL |
YES |
0 |
||
value_Est_Bus_IVTT |
REAL |
YES |
0 |
||
value_Act_Bus_IVTT |
REAL |
YES |
0 |
||
value_Est_Rail_IVTT |
REAL |
YES |
0 |
||
value_Act_Rail_IVTT |
REAL |
YES |
0 |
||
value_Est_Comm_Rail_IVTT |
REAL |
YES |
0 |
||
value_Act_Comm_Rail_IVTT |
REAL |
YES |
0 |
||
value_Est_Car_Time |
REAL |
YES |
0 |
||
value_Act_Car_Time |
REAL |
YES |
0 |
||
value_Est_Transfer_Pen |
REAL |
YES |
0 |
||
value_Act_Transfer_Pen |
REAL |
YES |
0 |
||
value_Est_Standing_Pen |
REAL |
YES |
0 |
||
value_Act_Standing_Pen |
REAL |
YES |
0 |
||
value_Est_Capacity_Pen |
REAL |
YES |
0 |
||
value_Act_Capacity_Pen |
REAL |
YES |
0 |
||
value_exit_position |
REAL |
YES |
0 |
||
value_Number_of_Switches |
INTEGER |
NO |
0 |
||
value_Est_Monetary_Cost |
REAL |
YES |
0 |
||
value_Act_Monetary_Cost |
REAL |
YES |
0 |
||
value_Est_Status |
INTEGER |
NO |
0 |
The expected person status when traversing this link at the routing stage. Values at value_Est_Status. |
|
value_Act_Status |
INTEGER |
NO |
0 |
The actual experienced person status when traversing this link. Values at value_Act_Status. |
|
value_Switch_Cause |
INTEGER |
NO |
0 |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Path_Multimodal_links" (
"object_id" INTEGER NOT NULL,
"index" INTEGER NOT NULL,
"value_link" INTEGER NOT NULL DEFAULT 0,
"value_dir" INTEGER NOT NULL,
"value_link_type" INTEGER NOT NULL DEFAULT 0,
"value_transit_vehicle_trip" INTEGER NOT NULL DEFAULT 0,
"value_transit_vehicle_stop_sequence" INTEGER NOT NULL DEFAULT 0,
"value_Est_Arrival_Time" REAL NULL DEFAULT 0,
"value_Act_Arrival_Time" REAL NULL DEFAULT 0,
"value_Est_Gen_Cost" REAL NULL DEFAULT 0,
"value_Act_Gen_Cost" REAL NULL DEFAULT 0,
"value_Est_Duration" REAL NULL DEFAULT 0,
"value_Act_Duration" REAL NULL DEFAULT 0,
"value_Est_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"value_Act_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"value_Est_TNC_Wait_Count" INTEGER NOT NULL DEFAULT 0,
"value_Est_Bus_Wait_Time" REAL NULL DEFAULT 0,
"value_Act_Bus_Wait_Time" REAL NULL DEFAULT 0,
"value_Est_Rail_Wait_Time" REAL NULL DEFAULT 0,
"value_Act_Rail_Wait_Time" REAL NULL DEFAULT 0,
"value_Est_Comm_Rail_Wait_Time" REAL NULL DEFAULT 0,
"value_Act_Comm_Rail_Wait_Time" REAL NULL DEFAULT 0,
"value_Est_Walk_Time" REAL NULL DEFAULT 0,
"value_Act_Walk_Time" REAL NULL DEFAULT 0,
"value_Est_Bike_Time" REAL NULL DEFAULT 0,
"value_Act_Bike_Time" REAL NULL DEFAULT 0,
"value_Est_Bus_IVTT" REAL NULL DEFAULT 0,
"value_Act_Bus_IVTT" REAL NULL DEFAULT 0,
"value_Est_Rail_IVTT" REAL NULL DEFAULT 0,
"value_Act_Rail_IVTT" REAL NULL DEFAULT 0,
"value_Est_Comm_Rail_IVTT" REAL NULL DEFAULT 0,
"value_Act_Comm_Rail_IVTT" REAL NULL DEFAULT 0,
"value_Est_Car_Time" REAL NULL DEFAULT 0,
"value_Act_Car_Time" REAL NULL DEFAULT 0,
"value_Est_Transfer_Pen" REAL NULL DEFAULT 0,
"value_Act_Transfer_Pen" REAL NULL DEFAULT 0,
"value_Est_Standing_Pen" REAL NULL DEFAULT 0,
"value_Act_Standing_Pen" REAL NULL DEFAULT 0,
"value_Est_Capacity_Pen" REAL NULL DEFAULT 0,
"value_Act_Capacity_Pen" REAL NULL DEFAULT 0,
"value_exit_position" REAL NULL DEFAULT 0,
"value_Number_of_Switches" INTEGER NOT NULL DEFAULT 0,
"value_Est_Monetary_Cost" REAL NULL DEFAULT 0,
"value_Act_Monetary_Cost" REAL NULL DEFAULT 0,
"value_Est_Status" INTEGER NOT NULL DEFAULT 0,
"value_Act_Status" INTEGER NOT NULL DEFAULT 0,
"value_Switch_Cause" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "object_id_fk"
FOREIGN KEY ("object_id")
REFERENCES "Path_Multimodal" ("id")
ON DELETE CASCADE)
Enums#
The following enums are used in this table.
value_link_type#
Value |
Description |
---|---|
0 |
FREEWAY |
1 |
ON_RAMP |
2 |
OFF_RAMP |
3 |
EXPRESSWAY |
4 |
ARTERIAL |
5 |
LOCAL |
6 |
EXTERNAL |
7 |
BIKEWAY |
8 |
WALK |
9 |
LIGHT_RAIL |
10 |
RAIL |
11 |
COMMUTER_RAIL |
12 |
BUS |
13 |
FERRY |
14 |
CABLE_TRAM |
15 |
AERIAL_LIFT |
16 |
FUNICULAR |
17 |
TROLLEY_BUS |
18 |
MONO_RAIL |
value_Est_Status#
Value |
Description |
---|---|
-2 |
WALKING_EGRESS |
-1 |
WALKING_ACCESS |
0 |
UNLOADED |
1 |
OUT_NETWORK |
2 |
WALKING |
3 |
DRIVING |
4 |
WAITING |
5 |
ON_BOARD_SEATED |
6 |
ON_BOARD_STANDING |
7 |
REROUTING |
8 |
ON_BOARD_TNC |
9 |
UNPARKING |
10 |
BIKING |
11 |
ON_DOCKLESS_VEHICLE |
12 |
ON_DOCKED_VEHICLE |
value_Act_Status#
Value |
Description |
---|---|
-2 |
WALKING_EGRESS |
-1 |
WALKING_ACCESS |
0 |
UNLOADED |
1 |
OUT_NETWORK |
2 |
WALKING |
3 |
DRIVING |
4 |
WAITING |
5 |
ON_BOARD_SEATED |
6 |
ON_BOARD_STANDING |
7 |
REROUTING |
8 |
ON_BOARD_TNC |
9 |
UNPARKING |
10 |
BIKING |
11 |
ON_DOCKLESS_VEHICLE |
12 |
ON_DOCKED_VEHICLE |