zonewaittimes table structure#
Table records the average wait times observed for a shared mobility request to be picked up. Values are stored across all operators operating in the simulated region and by hour in day and origin zone.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
id* |
INTEGER |
NO |
Record identifier |
||
start |
INTEGER |
NO |
0 |
Simulation time in seconds when data aggregation STARTS |
|
avg_wait_minutes |
REAL |
YES |
0 |
Average wait time for a request to be picked up in minutes |
|
trips |
INTEGER |
NO |
0 |
Number of trip requests that contributed to calculating the average |
|
requests |
INTEGER |
NO |
0 |
Unused. Will be removed. |
|
end |
INTEGER |
NO |
0 |
Simulation time in seconds for when data aggregation ENDS |
|
mode |
INTEGER |
NO |
0 |
Mode of travel for which average wait time is stored. Values at mode. |
|
zone |
INTEGER |
NO |
0 |
0-based zone ID (or 0 through n-1 zones) to store average wait time |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "ZoneWaitTimes" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"start" INTEGER NOT NULL DEFAULT 0,
"avg_wait_minutes" REAL NULL DEFAULT 0,
"trips" INTEGER NOT NULL DEFAULT 0,
"requests" INTEGER NOT NULL DEFAULT 0,
"end" INTEGER NOT NULL DEFAULT 0,
"mode" INTEGER NOT NULL DEFAULT 0,
"zone" 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 |