zone fmlm success table structure

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.

Table Structure#

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)