zone tnc repositioning statistics table structure#
Table stores information related to zone-level outcomes after the ‘joint_evcr’ TNC strategy is solved. This is a strategy-specific table and is only generated when using the ‘joint_evcr’ strategy in the TNC fleet model file.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
id* |
INTEGER |
NO |
Record identifier |
||
time |
INTEGER |
NO |
0 |
Simulation time in seconds when the output of the solver is condensed and logged |
|
zone |
INTEGER |
NO |
0 |
0-based zone ID (for zones 0 through n-1) |
|
idle_veh |
INTEGER |
NO |
0 |
Number of idle vehicles in the zone before optimization |
|
avg_soc_idle |
REAL |
YES |
0 |
Average state of charge of all idle vehicles in zone |
|
avail_plugs |
INTEGER |
NO |
0 |
Total unused plugs at charging stations in the zone |
|
out_repositioning_trips |
INTEGER |
NO |
0 |
Number of vehicles repositioned to leave the zone after optimization |
|
in_repositioning_trips |
INTEGER |
NO |
0 |
Number of vehicles repositioned to arrive at the zone after optimization |
|
out_charging_trips |
INTEGER |
NO |
0 |
Number of vehicles sent to charge outside of the zone |
|
in_charging_trips |
INTEGER |
NO |
0 |
Number of vehicles that are asked to come to the zone to charge |
|
slack |
INTEGER |
NO |
0 |
Slack value of requirement unment at the zone from solving the optimization problem |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Zone_TNC_Repositioning_Statistics" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"time" INTEGER NOT NULL DEFAULT 0,
"zone" INTEGER NOT NULL DEFAULT 0,
"idle_veh" INTEGER NOT NULL DEFAULT 0,
"avg_soc_idle" REAL NULL DEFAULT 0,
"avail_plugs" INTEGER NOT NULL DEFAULT 0,
"out_repositioning_trips" INTEGER NOT NULL DEFAULT 0,
"in_repositioning_trips" INTEGER NOT NULL DEFAULT 0,
"out_charging_trips" INTEGER NOT NULL DEFAULT 0,
"in_charging_trips" INTEGER NOT NULL DEFAULT 0,
"slack" INTEGER NOT NULL DEFAULT 0)