activity table structure#
An output table for activities a person perticipates in. Note this table contains both palnned activities which are not assigned to the network yet (trip == 0) as well as assigned activities (trip > 0).
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
id* |
INTEGER |
NO |
Unique identifier of this activity |
||
seq_num |
INTEGER |
NO |
0 |
Order in which activities were generated per person; note home activities are +=100 and split activities +=1000 |
|
location_id |
INTEGER |
NO |
0 |
Location at which this activity took place (foreign key to the Location table) |
|
start_time |
REAL |
YES |
0 |
Simulation time in seconds when this activity starts (units: seconds) |
|
duration |
REAL |
YES |
0 |
Duration of the activity in seconds of simulation time (units: seconds) |
|
mode |
TEXT |
NO |
‘’ |
Mode to reach this activity, possible values are keys in Values at mode. |
|
type |
TEXT |
NO |
‘’ |
Type of the activity, possible values are keys in Values at type. |
|
person |
INTEGER |
NO |
Person(person) |
Person undertaking this activity (foreign key to the Person table) |
|
trip |
INTEGER |
NO |
The trip which was used to reach this activity (foreign key to trip table); 0 indicates this is a planned activity without trip |
||
origin_id |
INTEGER |
NO |
0 |
The location of the previous activity (foreign key to the Location table) |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Activity" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"seq_num" INTEGER NOT NULL DEFAULT 0,
"location_id" INTEGER NOT NULL DEFAULT 0,
"start_time" REAL NULL DEFAULT 0,
"duration" REAL NULL DEFAULT 0,
"mode" TEXT NOT NULL DEFAULT '',
"type" TEXT NOT NULL DEFAULT '',
"person" INTEGER NOT NULL,
"trip" INTEGER NOT NULL,
"origin_id" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "person_fk"
FOREIGN KEY ("person")
REFERENCES "Person" ("person")
DEFERRABLE INITIALLY DEFERRED)
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 |
type#
Value |
Name |
Description |
---|---|---|
-1 |
DELETED |
|
-2 |
EMPTY |
|
0 |
WORK_AT_HOME_ACTIVITY |
|
1 |
AT_HOME_ACTIVITY |
|
2 |
PRIMARY_WORK_ACTIVITY |
|
3 |
OTHER_WORK_ACTIVITY |
|
4 |
SCHOOL_ACTIVITY |
|
5 |
MAJOR_SHOPPING_ACTIVITY |
|
6 |
OTHER_SHOPPING_ACTIVITY |
|
7 |
SERVICE_VEHICLE_ACTIVITY |
|
8 |
HEALTHCARE_ACTIVITY |
|
9 |
PERSONAL_BUSINESS_ACTIVITY |
|
10 |
ERRANDS_ACTIVITY |
|
11 |
PICK_UP_OR_DROP_OFF_ACTIVITY |
|
12 |
EAT_OUT_ACTIVITY |
|
13 |
RELIGIOUS_OR_CIVIC_ACTIVITY |
|
14 |
LEISURE_ACTIVITY |
|
15 |
RECREATION_ACTIVITY |
|
16 |
SOCIAL_ACTIVITY |
|
17 |
CHANGE_TRANSPORTATION_ACTIVITY |
|
18 |
OTHER_ACTIVITY |
|
22 |
PART_TIME_WORK_ACTIVITY |
|
23 |
EV_CHARGING_ACTIVITY |