trip table structure#
All person trips executed during simulation in POLARIS is logged here as a separate record. Note that only the SOV-related record can be counted as a vehicle trip for person-related travel. All freight trips can also be counted as a vehicle trip
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
trip_id* |
INTEGER |
NO |
Unique identifier of this trip |
||
hhold |
INTEGER |
NO |
0 |
Not used |
|
path |
INTEGER |
YES |
path is not NULL if there exists trajectory-related information in the Path table referenced by this value. (foreign key to the Path table) |
||
path_multimodal |
INTEGER |
YES |
Path_Multimodal(path_multimodal) |
path_multimodal is not NULL if there exists multimodal trajectory-related information in the Path_Multimodal table referenced by this value. (foreign key to the Path_Multimodal table) |
|
tour |
INTEGER |
NO |
0 |
Not used |
|
trip |
INTEGER |
NO |
0 |
Not used |
|
start |
REAL |
YES |
0 |
Simulation time when this trip starts (units: seconds) |
|
end |
REAL |
YES |
0 |
Simulation time when this trip ends (units: seconds) |
|
duration |
REAL |
YES |
0 |
Not used |
|
experienced_gap |
REAL |
YES |
0 |
Gap experienced by person based on executed travel time (provided by end minus start) compared to routed travel time. |
|
origin |
INTEGER |
NO |
0 |
The location where this trip begins (foreign key to the Location table) |
|
destination |
INTEGER |
NO |
0 |
The location where this trip ends (foreign key to the Location table) |
|
purpose |
INTEGER |
NO |
0 |
Currently used only to distinguish freight trips as E-Commerce or not |
|
mode |
INTEGER |
NO |
0 |
The mode used to execute the trip. Values at mode. |
|
constraint |
INTEGER |
NO |
0 |
Not used |
|
priority |
INTEGER |
NO |
0 |
Not used |
|
vehicle |
INTEGER |
YES |
Vehicle(vehicle) |
Vehicle ID used to complete the travel. Can be NULL for non-motorized trips. |
|
passengers |
INTEGER |
NO |
0 |
Not used |
|
type |
INTEGER |
NO |
0 |
Trip type is logged as either an ABM, External, External_TNC, TNC, Fixed, Transit, or Unsimulated. |
|
partition |
INTEGER |
NO |
0 |
Not used |
|
person |
INTEGER |
YES |
Person(person) |
Person who was primarily involved in the trip (foreign key to the Person table) |
|
travel_distance |
REAL |
YES |
0 |
Distance traveled in executing this trip (units: meters) |
|
skim_travel_time |
REAL |
YES |
0 |
Travel time from the skim table for comparison with execution (units: seconds) |
|
routed_travel_time |
REAL |
YES |
0 |
Travel time from the router for comparison with execution (units: seconds) |
|
toll |
REAL |
YES |
0 |
Toll paid in executing the trip (units: $USD) |
|
has_artificial_trip |
INTEGER |
NO |
0 |
Integer to denote the type of artificial trip and can include: All good (0), Not routed (1), congestion removal (2), simulation ended (3), stuck in entry queue (4) |
|
number_of_switches |
INTEGER |
NO |
0 |
Integer value indicating the number of times the path was changed to account for downstream congestion or when waiting too long at a link |
|
request |
INTEGER |
NO |
0 |
Not used |
|
monetary_cost |
REAL |
YES |
0 |
Dollar amount paid when making the trip (units: $USD) |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Trip" (
"trip_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"hhold" INTEGER NOT NULL DEFAULT 0,
"path" INTEGER NULL,
"path_multimodal" INTEGER NULL,
"tour" INTEGER NOT NULL DEFAULT 0,
"trip" INTEGER NOT NULL DEFAULT 0,
"start" REAL NULL DEFAULT 0,
"end" REAL NULL DEFAULT 0,
"duration" REAL NULL DEFAULT 0,
"experienced_gap" REAL NULL DEFAULT 0,
"origin" INTEGER NOT NULL DEFAULT 0,
"destination" INTEGER NOT NULL DEFAULT 0,
"purpose" INTEGER NOT NULL DEFAULT 0,
"mode" INTEGER NOT NULL DEFAULT 0,
"constraint" INTEGER NOT NULL DEFAULT 0,
"priority" INTEGER NOT NULL DEFAULT 0,
"vehicle" INTEGER NULL,
"passengers" INTEGER NOT NULL DEFAULT 0,
"type" INTEGER NOT NULL DEFAULT 0,
"partition" INTEGER NOT NULL DEFAULT 0,
"person" INTEGER NULL,
"travel_distance" REAL NULL DEFAULT 0,
"skim_travel_time" REAL NULL DEFAULT 0,
"routed_travel_time" REAL NULL DEFAULT 0,
"toll" REAL NULL DEFAULT 0,
"has_artificial_trip" INTEGER NOT NULL DEFAULT 0,
"number_of_switches" INTEGER NOT NULL DEFAULT 0,
"request" INTEGER NOT NULL DEFAULT 0,
"monetary_cost" REAL NULL DEFAULT 0,
CONSTRAINT "path_multimodal_fk"
FOREIGN KEY ("path_multimodal")
REFERENCES "Path_Multimodal" ("id")
DEFERRABLE INITIALLY DEFERRED,
CONSTRAINT "vehicle_fk"
FOREIGN KEY ("vehicle")
REFERENCES "Vehicle" ("vehicle_id")
DEFERRABLE INITIALLY DEFERRED,
CONSTRAINT "person_fk"
FOREIGN KEY ("person")
REFERENCES "Person" ("person")
DEFERRABLE INITIALLY DEFERRED)
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 |