mode table structure

Contents

mode table structure#

Dictionary of all modes supported for simulation within POLARIS.

This table is currently only used for providing a text based representation of the hard-coded modes defined in POLARIS (Vehicle_Type_Keys enum).

Table Structure#
Field	Type	NULL allowed	Default Value	Foreign key	Description
mode_id*	INTEGER	NO			Unique identifier for mode Values at mode_id.
mode_description	TEXT	NO			Text input describing the mode

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Mode" (
  "mode_id" INTEGER NOT NULL PRIMARY KEY,
  "mode_description" TEXT NOT NULL)

Enums#

The following enums are used in this table.

mode_id#

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