zone walk times table structure

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.

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 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)