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 |
Name |
Description |
---|---|---|
0 |
SOV |
Car driver |
1 |
AUTO_NEST |
Car modes aggregate nest alternative |
2 |
HOV |
Car passenger |
3 |
TRUCK |
|
4 |
BUS |
Mode identifier associated with an articulated 60 ft bus vehicle, if the |
5 |
RAIL |
Public transit with walk access and egress to any combination of rail sub-modes (subway, light |
6 |
NONMOTORIZED_NEST |
|
7 |
BICYCLE |
Privately owned bicycle |
8 |
WALK |
Walking |
9 |
TAXI |
Taxi and TNC ride hailing for passengers |
10 |
SCHOOLBUS |
School bus |
11 |
PARK_AND_RIDE |
Public transit, accessed by driving and parking the car. The egress leg is walk. Can |
12 |
KISS_AND_RIDE |
Public transit, accessed by car with someone dropping off. The egress leg is walk. |
13 |
PARK_AND_RAIL |
Public transit, accessed by driving and parking the car. The egress leg is walk. Can |
14 |
KISS_AND_RAIL |
Public transit, accessed by car with someone dropping off. The egress leg is walk. |
15 |
TNC_AND_RIDE |
Public transit, with access and/or egress by taxi or rideshare. |
17 |
MD_TRUCK |
Medium Duty Trucks, Classes 3-6 (10,001-26,000 lbs) according to FHWA classification |
18 |
HD_TRUCK |
Heavy Duty Trucks, Class 7-8 (> 26,001 lbs) according to FHWA classification |
19 |
BPLATE |
Pickup trucks and vans (Chicago model only), Class 2 (< 10,000 lbs) according to FHWA |
20 |
LD_TRUCK |
Light Duty Trucks, Class 2 (< 10,000 lbs) according to FHWA classification |
21 |
RAIL_NEST |
Rail modes aggregate nest alternative |
22 |
BUS40 |
|
23 |
BUS60 |
|
24 |
PNR_BIKE_NEST |
Park and ride, and bike modes aggregate nest alternative |
25 |
RIDE_AND_UNPARK |
Public transit, access is walk and egress is by parked car. Can use any any |
26 |
RIDE_AND_REKISS |
Public transit, access is walk and egress is by being picked up by a car. Can use |
27 |
RAIL_AND_UNPARK |
Public transit, access is walk and egress is by parked car. Can only use rail modes |
28 |
RAIL_AND_REKISS |
Public transit, access is walk and egress is by being picked up by a car. Can only |
29 |
MICROM |
Docked micromobility mode (if micromobility and transit has bike time but no transit time) |
30 |
MICROM_NODOCK |
Dockless micromobility modes (if dockless micromobility and transit has bike time but |
31 |
MICROM_AND_TRANSIT |
Docked micromobility modes for access/egress to transit |
32 |
MICROM_NODOCK_AND_TRANSIT |
Dockless micromobility and transit modes combination |
33 |
ODDELIVERY |
Groceries and meals delivery |
999 |
FAIL_MODE |
If a traveler left home using drive-to-transit but returning home via transit and |
1000 |
FAIL_ROUTE |
Not used |
1001 |
FAIL_REROUTE |
|
1002 |
FAIL_UNPARK |
If the traveler arrives to their parked vehicle on a return (transit-and-drive) trip |
1003 |
FAIL_UNPARK2 |
|
1004 |
FAIL_MODE1 |
|
1005 |
FAIL_MODE2 |
|
1006 |
FAIL_MODE3 |
|
1007 |
FAIL_ROUTE_ACTIVE |
If the multimodal routing fails for a walking or biking trip the mode becomes |
1008 |
FAIL_ROUTE_WALK_AND_TRANSIT |
|
1009 |
FAIL_ROUTE_DRIVE_TO_TRANSIT |
|
1010 |
FAIL_ROUTE_DRIVE_FROM_TRANSIT |
If the multimodal routing fails for a drive-from-transit trip; |
1011 |
FAIL_ROUTE_TNC_AND_TRANSIT |
|
1012 |
FAIL_ROUTE_TNC |
If the multimodal routing fails for a tnc trip; replan mode is triggered |
1013 |
FAIL_ROUTE_SOV |
Not used |
1014 |
FAIL_ROUTE_MICROMOBILITY |
|
1015 |
NO_MOVE |
If the origin and destination locations are the same, no movement needs to happen |
9999 |
UNSIMULATED |
If both the origin and destination locations fall into the no-simulation portion of |