path multimodal links table structure

Contents

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.

Table Structure#
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#

Enum Values#
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#

Enum Values#
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#

Enum Values#
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