zoneaccessibility table structure

zoneaccessibility table structure#

ZoneAccessibility table stores the general and transit-based accessibility values for each TAZ Zone in the model, including average travel attributes (e.g. distance, time, cost) by mode and time periods. The accessibility variables refer to the access to number of employment of a particular type available with the zone as origin based on an exponential decay of auto travel time As there a large number of columns in this table a guide to interpreting their names is required. Columns are generally composites of attribute/mode/time - for instance ‘avg_ampeak_pnr_ivtt_inbound’ is the average in-vehicle travel time for park and ride trips during the morning peak.

The following dimensions are commonly used:

time_period:

  • 06:00 - 09:00 (AM peak),

  • 09:00 - 16:00 (off peak),

  • 16:00 - 19:00 (PM peak),

  • 19:00 - 06:00 (night).

mode:

  • auto (SOV - single-occupancy vehicle),

  • park-and-ride (pnr),

  • park-and-rail (pnrail),

  • rail,

  • transit,

  • walk,

  • bike.

attributes (in general, avg_ refers to AVERAGE):

  • accessibility - access to number of employment of particular type available with the zone as origin based on an exponential decay of auto travel time

  • ivtt - in-vehicle travel time

  • ovtt - access/egress travel time

  • fare - fares of a mode

  • transfers - number of transfers

  • wait - waiting time

  • ttime - travel time

  • ttime_var - travel time variability

  • cost - travel cost of a mode

  • distance - distance traveled.

Additionally, many metrics are also duplicated with their ‘_inbound’ version which describes the values only for the inbound direction of travel.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

zone*

INTEGER

NO

The unique identifier of the zone consistent with the Zone table in Supply database

accessibility_employment_government

REAL

NO

0

Accessibility to employment

accessibility_employment_industrial

REAL

YES

0

accessibility_employment_manufacturing

REAL

YES

0

accessibility_employment_other

REAL

YES

0

accessibility_employment_retail

REAL

YES

0

accessibility_employment_services

REAL

YES

0

avg_walk_ttime

REAL

YES

0

Avg travel time by walk

avg_bike_ttime

REAL

YES

0

Avg travel time by bike

avg_ampeak_pnr_auto_ovtt

REAL

YES

0

avg_ampeak_pnr_fare

REAL

YES

0

avg_ampeak_pnr_ivtt

REAL

YES

0

avg_ampeak_pnr_transfers

REAL

YES

0

avg_ampeak_pnr_wait

REAL

YES

0

avg_ampeak_pnr_walk_ovtt

REAL

YES

0

avg_ampeak_pnrail_auto_ovtt

REAL

YES

0

avg_ampeak_pnrail_fare

REAL

YES

0

avg_ampeak_pnrail_ivtt

REAL

YES

0

avg_ampeak_pnrail_transfers

REAL

YES

0

avg_ampeak_pnrail_wait

REAL

YES

0

avg_ampeak_pnrail_walk_ovtt

REAL

YES

0

avg_ampeak_rail_auto_ovtt

REAL

YES

0

avg_ampeak_rail_fare

REAL

YES

0

avg_ampeak_rail_ivtt

REAL

YES

0

avg_ampeak_rail_transfers

REAL

YES

0

avg_ampeak_rail_wait

REAL

YES

0

avg_ampeak_rail_walk_ovtt

REAL

YES

0

avg_ampeak_transit_auto_ovtt

REAL

YES

0

avg_ampeak_transit_fare

REAL

YES

0

avg_ampeak_transit_ivtt

REAL

YES

0

avg_ampeak_transit_transfers

REAL

YES

0

avg_ampeak_transit_wait

REAL

YES

0

avg_ampeak_transit_walk_ovtt

REAL

YES

0

avg_cost_auto_ampeak

REAL

YES

0

avg_cost_auto_night

REAL

YES

0

avg_cost_auto_offpeak

REAL

YES

0

avg_cost_auto_pmpeak

REAL

YES

0

avg_distance

REAL

YES

0

avg_night_pnr_auto_ovtt

REAL

YES

0

avg_night_pnr_fare

REAL

YES

0

avg_night_pnr_ivtt

REAL

YES

0

avg_night_pnr_transfers

REAL

YES

0

avg_night_pnr_wait

REAL

YES

0

avg_night_pnr_walk_ovtt

REAL

YES

0

avg_night_pnrail_auto_ovtt

REAL

YES

0

avg_night_pnrail_fare

REAL

YES

0

avg_night_pnrail_ivtt

REAL

YES

0

avg_night_pnrail_transfers

REAL

YES

0

avg_night_pnrail_wait

REAL

YES

0

avg_night_pnrail_walk_ovtt

REAL

YES

0

avg_night_rail_auto_ovtt

REAL

YES

0

avg_night_rail_fare

REAL

YES

0

avg_night_rail_ivtt

REAL

YES

0

avg_night_rail_transfers

REAL

YES

0

avg_night_rail_wait

REAL

YES

0

avg_night_rail_walk_ovtt

REAL

YES

0

avg_night_transit_auto_ovtt

REAL

YES

0

avg_night_transit_fare

REAL

YES

0

avg_night_transit_ivtt

REAL

YES

0

avg_night_transit_transfers

REAL

YES

0

avg_night_transit_wait

REAL

YES

0

avg_night_transit_walk_ovtt

REAL

YES

0

avg_offpeak_pnr_auto_ovtt

REAL

YES

0

avg_offpeak_pnr_fare

REAL

YES

0

avg_offpeak_pnr_ivtt

REAL

YES

0

avg_offpeak_pnr_transfers

REAL

YES

0

avg_offpeak_pnr_wait

REAL

YES

0

avg_offpeak_pnr_walk_ovtt

REAL

YES

0

avg_offpeak_pnrail_auto_ovtt

REAL

YES

0

avg_offpeak_pnrail_fare

REAL

YES

0

avg_offpeak_pnrail_ivtt

REAL

YES

0

avg_offpeak_pnrail_transfers

REAL

YES

0

avg_offpeak_pnrail_wait

REAL

YES

0

avg_offpeak_pnrail_walk_ovtt

REAL

YES

0

avg_offpeak_rail_auto_ovtt

REAL

YES

0

avg_offpeak_rail_fare

REAL

YES

0

avg_offpeak_rail_ivtt

REAL

YES

0

avg_offpeak_rail_transfers

REAL

YES

0

avg_offpeak_rail_wait

REAL

YES

0

avg_offpeak_rail_walk_ovtt

REAL

YES

0

avg_offpeak_transit_auto_ovtt

REAL

YES

0

avg_offpeak_transit_fare

REAL

YES

0

avg_offpeak_transit_ivtt

REAL

YES

0

avg_offpeak_transit_transfers

REAL

YES

0

avg_offpeak_transit_wait

REAL

YES

0

avg_offpeak_transit_walk_ovtt

REAL

YES

0

avg_pmpeak_pnr_auto_ovtt

REAL

YES

0

avg_pmpeak_pnr_fare

REAL

YES

0

avg_pmpeak_pnr_ivtt

REAL

YES

0

avg_pmpeak_pnr_transfers

REAL

YES

0

avg_pmpeak_pnr_wait

REAL

YES

0

avg_pmpeak_pnr_walk_ovtt

REAL

YES

0

avg_pmpeak_pnrail_auto_ovtt

REAL

YES

0

avg_pmpeak_pnrail_fare

REAL

YES

0

avg_pmpeak_pnrail_ivtt

REAL

YES

0

avg_pmpeak_pnrail_transfers

REAL

YES

0

avg_pmpeak_pnrail_wait

REAL

YES

0

avg_pmpeak_pnrail_walk_ovtt

REAL

YES

0

avg_pmpeak_rail_auto_ovtt

REAL

YES

0

avg_pmpeak_rail_fare

REAL

YES

0

avg_pmpeak_rail_ivtt

REAL

YES

0

avg_pmpeak_rail_transfers

REAL

YES

0

avg_pmpeak_rail_wait

REAL

YES

0

avg_pmpeak_rail_walk_ovtt

REAL

YES

0

avg_pmpeak_transit_auto_ovtt

REAL

YES

0

avg_pmpeak_transit_fare

REAL

YES

0

avg_pmpeak_transit_ivtt

REAL

YES

0

avg_pmpeak_transit_transfers

REAL

YES

0

avg_pmpeak_transit_wait

REAL

YES

0

avg_pmpeak_transit_walk_ovtt

REAL

YES

0

avg_ttime_auto_ampeak

REAL

YES

0

avg_ttime_auto_night

REAL

YES

0

avg_ttime_auto_offpeak

REAL

YES

0

avg_ttime_auto_pmpeak

REAL

YES

0

avg_ttime_var_auto_ampeak

REAL

YES

0

avg_ttime_var_auto_night

REAL

YES

0

avg_ttime_var_auto_offpeak

REAL

YES

0

avg_ttime_var_auto_pmpeak

REAL

YES

0

avg_ampeak_pnr_auto_ovtt_inbound

REAL

YES

0

avg_ampeak_pnr_fare_inbound

REAL

YES

0

avg_ampeak_pnr_ivtt_inbound

REAL

YES

0

avg_ampeak_pnr_transfers_inbound

REAL

YES

0

avg_ampeak_pnr_wait_inbound

REAL

YES

0

avg_ampeak_pnr_walk_ovtt_inbound

REAL

YES

0

avg_ampeak_pnrail_auto_ovtt_inbound

REAL

YES

0

avg_ampeak_pnrail_fare_inbound

REAL

YES

0

avg_ampeak_pnrail_ivtt_inbound

REAL

YES

0

avg_ampeak_pnrail_transfers_inbound

REAL

YES

0

avg_ampeak_pnrail_wait_inbound

REAL

YES

0

avg_ampeak_pnrail_walk_ovtt_inbound

REAL

YES

0

avg_ampeak_rail_auto_ovtt_inbound

REAL

YES

0

avg_ampeak_rail_fare_inbound

REAL

YES

0

avg_ampeak_rail_ivtt_inbound

REAL

YES

0

avg_ampeak_rail_transfers_inbound

REAL

YES

0

avg_ampeak_rail_wait_inbound

REAL

YES

0

avg_ampeak_rail_walk_ovtt_inbound

REAL

YES

0

avg_ampeak_transit_auto_ovtt_inbound

REAL

YES

0

avg_ampeak_transit_fare_inbound

REAL

YES

0

avg_ampeak_transit_ivtt_inbound

REAL

YES

0

avg_ampeak_transit_transfers_inbound

REAL

YES

0

avg_ampeak_transit_wait_inbound

REAL

YES

0

avg_ampeak_transit_walk_ovtt_inbound

REAL

YES

0

avg_cost_auto_ampeak_inbound

REAL

YES

0

avg_cost_auto_night_inbound

REAL

YES

0

avg_cost_auto_offpeak_inbound

REAL

YES

0

avg_cost_auto_pmpeak_inbound

REAL

YES

0

avg_distance_inbound

REAL

YES

0

avg_night_pnr_auto_ovtt_inbound

REAL

YES

0

avg_night_pnr_fare_inbound

REAL

YES

0

avg_night_pnr_ivtt_inbound

REAL

YES

0

avg_night_pnr_transfers_inbound

REAL

YES

0

avg_night_pnr_wait_inbound

REAL

YES

0

avg_night_pnr_walk_ovtt_inbound

REAL

YES

0

avg_night_pnrail_auto_ovtt_inbound

REAL

YES

0

avg_night_pnrail_fare_inbound

REAL

YES

0

avg_night_pnrail_ivtt_inbound

REAL

YES

0

avg_night_pnrail_transfers_inbound

REAL

YES

0

avg_night_pnrail_wait_inbound

REAL

YES

0

avg_night_pnrail_walk_ovtt_inbound

REAL

YES

0

avg_night_rail_auto_ovtt_inbound

REAL

YES

0

avg_night_rail_fare_inbound

REAL

YES

0

avg_night_rail_ivtt_inbound

REAL

YES

0

avg_night_rail_transfers_inbound

REAL

YES

0

avg_night_rail_wait_inbound

REAL

YES

0

avg_night_rail_walk_ovtt_inbound

REAL

YES

0

avg_night_transit_auto_ovtt_inbound

REAL

YES

0

avg_night_transit_fare_inbound

REAL

YES

0

avg_night_transit_ivtt_inbound

REAL

YES

0

avg_night_transit_transfers_inbound

REAL

YES

0

avg_night_transit_wait_inbound

REAL

YES

0

avg_night_transit_walk_ovtt_inbound

REAL

YES

0

avg_offpeak_pnr_auto_ovtt_inbound

REAL

YES

0

avg_offpeak_pnr_fare_inbound

REAL

YES

0

avg_offpeak_pnr_ivtt_inbound

REAL

YES

0

avg_offpeak_pnr_transfers_inbound

REAL

YES

0

avg_offpeak_pnr_wait_inbound

REAL

YES

0

avg_offpeak_pnr_walk_ovtt_inbound

REAL

YES

0

avg_offpeak_pnrail_auto_ovtt_inbound

REAL

YES

0

avg_offpeak_pnrail_fare_inbound

REAL

YES

0

avg_offpeak_pnrail_ivtt_inbound

REAL

YES

0

avg_offpeak_pnrail_transfers_inbound

REAL

YES

0

avg_offpeak_pnrail_wait_inbound

REAL

YES

0

avg_offpeak_pnrail_walk_ovtt_inbound

REAL

YES

0

avg_offpeak_rail_auto_ovtt_inbound

REAL

YES

0

avg_offpeak_rail_fare_inbound

REAL

YES

0

avg_offpeak_rail_ivtt_inbound

REAL

YES

0

avg_offpeak_rail_transfers_inbound

REAL

YES

0

avg_offpeak_rail_wait_inbound

REAL

YES

0

avg_offpeak_rail_walk_ovtt_inbound

REAL

YES

0

avg_offpeak_transit_auto_ovtt_inbound

REAL

YES

0

avg_offpeak_transit_fare_inbound

REAL

YES

0

avg_offpeak_transit_ivtt_inbound

REAL

YES

0

avg_offpeak_transit_transfers_inbound

REAL

YES

0

avg_offpeak_transit_wait_inbound

REAL

YES

0

avg_offpeak_transit_walk_ovtt_inbound

REAL

YES

0

avg_pmpeak_pnr_auto_ovtt_inbound

REAL

YES

0

avg_pmpeak_pnr_fare_inbound

REAL

YES

0

avg_pmpeak_pnr_ivtt_inbound

REAL

YES

0

avg_pmpeak_pnr_transfers_inbound

REAL

YES

0

avg_pmpeak_pnr_wait_inbound

REAL

YES

0

avg_pmpeak_pnr_walk_ovtt_inbound

REAL

YES

0

avg_pmpeak_pnrail_auto_ovtt_inbound

REAL

YES

0

avg_pmpeak_pnrail_fare_inbound

REAL

YES

0

avg_pmpeak_pnrail_ivtt_inbound

REAL

YES

0

avg_pmpeak_pnrail_transfers_inbound

REAL

YES

0

avg_pmpeak_pnrail_wait_inbound

REAL

YES

0

avg_pmpeak_pnrail_walk_ovtt_inbound

REAL

YES

0

avg_pmpeak_rail_auto_ovtt_inbound

REAL

YES

0

avg_pmpeak_rail_fare_inbound

REAL

YES

0

avg_pmpeak_rail_ivtt_inbound

REAL

YES

0

avg_pmpeak_rail_transfers_inbound

REAL

YES

0

avg_pmpeak_rail_wait_inbound

REAL

YES

0

avg_pmpeak_rail_walk_ovtt_inbound

REAL

YES

0

avg_pmpeak_transit_auto_ovtt_inbound

REAL

YES

0

avg_pmpeak_transit_fare_inbound

REAL

YES

0

avg_pmpeak_transit_ivtt_inbound

REAL

YES

0

avg_pmpeak_transit_transfers_inbound

REAL

YES

0

avg_pmpeak_transit_wait_inbound

REAL

YES

0

avg_pmpeak_transit_walk_ovtt_inbound

REAL

YES

0

avg_ttime_auto_ampeak_inbound

REAL

YES

0

avg_ttime_auto_night_inbound

REAL

YES

0

avg_ttime_auto_offpeak_inbound

REAL

YES

0

avg_ttime_auto_pmpeak_inbound

REAL

YES

0

avg_ttime_var_auto_ampeak_inbound

REAL

YES

0

avg_ttime_var_auto_night_inbound

REAL

YES

0

avg_ttime_var_auto_offpeak_inbound

REAL

YES

0

avg_ttime_var_auto_pmpeak_inbound

REAL

YES

0

roadway_length

REAL

YES

0

transit_accessibility_employment_government

REAL

YES

0

transit_accessibility_employment_industrial

REAL

YES

0

transit_accessibility_employment_manufacturing

REAL

YES

0

transit_accessibility_employment_other

REAL

YES

0

transit_accessibility_employment_retail

REAL

YES

0

transit_accessibility_employment_services

REAL

YES

0

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "ZoneAccessibility" (
  "zone" INTEGER NOT NULL PRIMARY KEY,
  "accessibility_employment_government" REAL NOT NULL DEFAULT 0,
  "accessibility_employment_industrial" REAL NULL DEFAULT 0,
  "accessibility_employment_manufacturing" REAL NULL DEFAULT 0,
  "accessibility_employment_other" REAL NULL DEFAULT 0,
  "accessibility_employment_retail" REAL NULL DEFAULT 0,
  "accessibility_employment_services" REAL NULL DEFAULT 0,
  "avg_walk_ttime" REAL NULL DEFAULT 0,
  "avg_bike_ttime" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_fare" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_ivtt" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_transfers" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_wait" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_fare" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_ivtt" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_transfers" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_wait" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_fare" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_ivtt" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_transfers" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_wait" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_fare" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_ivtt" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_transfers" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_wait" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_cost_auto_ampeak" REAL NULL DEFAULT 0,
  "avg_cost_auto_night" REAL NULL DEFAULT 0,
  "avg_cost_auto_offpeak" REAL NULL DEFAULT 0,
  "avg_cost_auto_pmpeak" REAL NULL DEFAULT 0,
  "avg_distance" REAL NULL DEFAULT 0,
  "avg_night_pnr_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_night_pnr_fare" REAL NULL DEFAULT 0,
  "avg_night_pnr_ivtt" REAL NULL DEFAULT 0,
  "avg_night_pnr_transfers" REAL NULL DEFAULT 0,
  "avg_night_pnr_wait" REAL NULL DEFAULT 0,
  "avg_night_pnr_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_night_pnrail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_night_pnrail_fare" REAL NULL DEFAULT 0,
  "avg_night_pnrail_ivtt" REAL NULL DEFAULT 0,
  "avg_night_pnrail_transfers" REAL NULL DEFAULT 0,
  "avg_night_pnrail_wait" REAL NULL DEFAULT 0,
  "avg_night_pnrail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_night_rail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_night_rail_fare" REAL NULL DEFAULT 0,
  "avg_night_rail_ivtt" REAL NULL DEFAULT 0,
  "avg_night_rail_transfers" REAL NULL DEFAULT 0,
  "avg_night_rail_wait" REAL NULL DEFAULT 0,
  "avg_night_rail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_night_transit_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_night_transit_fare" REAL NULL DEFAULT 0,
  "avg_night_transit_ivtt" REAL NULL DEFAULT 0,
  "avg_night_transit_transfers" REAL NULL DEFAULT 0,
  "avg_night_transit_wait" REAL NULL DEFAULT 0,
  "avg_night_transit_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_fare" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_ivtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_transfers" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_wait" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_fare" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_ivtt" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_transfers" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_wait" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_fare" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_ivtt" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_transfers" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_wait" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_fare" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_ivtt" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_transfers" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_wait" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_fare" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_ivtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_transfers" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_wait" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_fare" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_ivtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_transfers" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_wait" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_fare" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_ivtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_transfers" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_wait" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_auto_ovtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_fare" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_ivtt" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_transfers" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_wait" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_walk_ovtt" REAL NULL DEFAULT 0,
  "avg_ttime_auto_ampeak" REAL NULL DEFAULT 0,
  "avg_ttime_auto_night" REAL NULL DEFAULT 0,
  "avg_ttime_auto_offpeak" REAL NULL DEFAULT 0,
  "avg_ttime_auto_pmpeak" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_ampeak" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_night" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_offpeak" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_pmpeak" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_fare_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_wait_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnr_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_pnrail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_rail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_fare_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_wait_inbound" REAL NULL DEFAULT 0,
  "avg_ampeak_transit_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_cost_auto_ampeak_inbound" REAL NULL DEFAULT 0,
  "avg_cost_auto_night_inbound" REAL NULL DEFAULT 0,
  "avg_cost_auto_offpeak_inbound" REAL NULL DEFAULT 0,
  "avg_cost_auto_pmpeak_inbound" REAL NULL DEFAULT 0,
  "avg_distance_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_fare_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_wait_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnr_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_night_pnrail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_night_rail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_fare_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_wait_inbound" REAL NULL DEFAULT 0,
  "avg_night_transit_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_fare_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_wait_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnr_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_pnrail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_rail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_fare_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_wait_inbound" REAL NULL DEFAULT 0,
  "avg_offpeak_transit_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_fare_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_wait_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnr_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_pnrail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_fare_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_wait_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_rail_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_auto_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_fare_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_ivtt_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_transfers_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_wait_inbound" REAL NULL DEFAULT 0,
  "avg_pmpeak_transit_walk_ovtt_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_auto_ampeak_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_auto_night_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_auto_offpeak_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_auto_pmpeak_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_ampeak_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_night_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_offpeak_inbound" REAL NULL DEFAULT 0,
  "avg_ttime_var_auto_pmpeak_inbound" REAL NULL DEFAULT 0,
  "roadway_length" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_government" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_industrial" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_manufacturing" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_other" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_retail" REAL NULL DEFAULT 0,
  "transit_accessibility_employment_services" REAL NULL DEFAULT 0
  )