zone fmlm success table structure#
Zone_FMLM_Success stores the number of successful first-mile-last-mile (FMLM) trips to and from transit, by hour of day separately aggregated by origin and destination.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
id* |
INTEGER |
NO |
Record identifier |
||
start |
INTEGER |
NO |
0 |
Simulation time in seconds when information aggregation starts |
|
end |
INTEGER |
NO |
0 |
Simulation time in seconds when information aggregation ends |
|
zone |
INTEGER |
NO |
0 |
0-based zone ID (for zones 0 through n-1) |
|
o_success_prop |
REAL |
YES |
0 |
Proportion of trips that successfully executed a FMLM trip with zone being an origin |
|
d_success_prop |
REAL |
YES |
0 |
Proportion of trips that successfully executed a FMLM trip with zone being a destination |
|
o_attempts |
INTEGER |
NO |
0 |
Total number of trips from demand model for which a router query was attempted with zone being an origin |
|
d_attempts |
INTEGER |
NO |
0 |
Total number of trips from demand model for which a router query was attempted with zone being a destination |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Zone_FMLM_Success" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"start" INTEGER NOT NULL DEFAULT 0,
"end" INTEGER NOT NULL DEFAULT 0,
"zone" INTEGER NOT NULL DEFAULT 0,
"o_success_prop" REAL NULL DEFAULT 0,
"d_success_prop" REAL NULL DEFAULT 0,
"o_attempts" INTEGER NOT NULL DEFAULT 0,
"d_attempts" INTEGER NOT NULL DEFAULT 0)