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