zone walk times table structure#
Zone_Walk_Times aggregates the average walk time experienced when using a shared mobility service (TNCs) The information in this table is relevant especially when a strategy actively requires requests to shift origins and destinations. If not all travel using the TNC mode is considered door-to-door.
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 |
|
walk_time_minutes |
REAL |
YES |
0 |
Average walk time experienced by requests in the zone at the specific hour |
|
trips |
INTEGER |
NO |
0 |
Number of trips used to aggregate the information |
|
end |
INTEGER |
NO |
0 |
Simulation time in seconds when data aggregation ENDS |
|
zone |
INTEGER |
NO |
0 |
0-based zone ID (for zones 0 through n-1) for recording zone-specific information |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Zone_Walk_Times" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"start" INTEGER NOT NULL DEFAULT 0,
"walk_time_minutes" REAL NULL DEFAULT 0,
"trips" INTEGER NOT NULL DEFAULT 0,
"end" INTEGER NOT NULL DEFAULT 0,
"zone" INTEGER NOT NULL DEFAULT 0)