zone table structure#
Lists all traffic analysis zones (TAZs) in the model, along with socio-economic data associated to each zone.
Forms the building block and is typicaly the first layer created for a new model.
Required by all models.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
zone* |
INTEGER |
NO |
Zone ID |
||
x |
REAL |
NO |
0 |
X coordinate of the zone centroid. Automatically added by Polaris. |
|
y |
REAL |
NO |
0 |
Y coordinate of the zone centroid. Automatically added by Polaris. |
|
z |
REAL |
YES |
Not currently in use |
||
area_type |
INTEGER |
NO |
100 |
Area_Type(area_type) |
Area type of the zone. Default is 0. |
area |
REAL |
NO |
0 |
Area of the zone in square meters. Automatically created |
|
entertainment_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
industrial_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
institutional_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
mixed_use_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
office_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
other_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
residential_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
retail_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
school_area |
REAL |
NO |
0 |
Land use specific area in square meters for use in destination choice. Automatically created. Optional. |
|
pop_households |
INTEGER |
NO |
0 |
Number of households present in the TAZ. Used in population synthesis as a target for the TAZ. Mandotory for model run. |
|
pop_persons |
INTEGER |
NO |
0 |
Number of people living in the TAZ. Used in population synthesis as a target for the TAZ. Mandotory for model run. |
|
pop_group_quarters |
INTEGER |
NO |
0 |
Number of people living in a group quarters setting in the TAZ. Used in the population synthesis as a target for the TAZ. Mandotory for model run. |
|
employment_total |
INTEGER |
NO |
0 |
Total number of jobs across all types available in the zone. Mandotory for model run. |
|
employment_retail |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
employment_government |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
employment_manufacturing |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
employment_services |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
employment_industrial |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
employment_other |
INTEGER |
NO |
0 |
Number of jobs of specific type in the TAZ. Used with destination choice. |
|
percent_white |
REAL |
NO |
0 |
Percent of population within TAZ that is Caucasian. Not used except if needed in choice models. |
|
percent_black |
REAL |
NO |
0 |
Percent of population within TAZ that is Afican-American. Not used except if needed in choice models. |
|
hh_inc_avg |
REAL |
NO |
0 |
Average household income of all households within the TAZ. Not used except if needed in choice models. |
|
electric_grid_transmission |
INTEGER |
NO |
1 |
Electricity_Grid_Transmission(electric_grid_transmission) |
Foreign key reference to the Electricity_Grid_Transmission table to determine which transmission bus the zone falls under. |
electricity_provider |
INTEGER |
NO |
1 |
Electricity_Provider(electricity_provider) |
Foreign key reference to the Electricity_Provider table to determine which utility covers the zone. |
geo |
MULTIPOLYGON |
YES |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE IF NOT EXISTS "Zone" (
"zone" INTEGER NOT NULL PRIMARY KEY,
"x" REAL NOT NULL DEFAULT 0,
"y" REAL NOT NULL DEFAULT 0,
"z" REAL,
"area_type" INTEGER NOT NULL DEFAULT 100,
"area" REAL NOT NULL DEFAULT 0,
"entertainment_area" REAL NOT NULL DEFAULT 0,
"industrial_area" REAL NOT NULL DEFAULT 0,
"institutional_area" REAL NOT NULL DEFAULT 0,
"mixed_use_area" REAL NOT NULL DEFAULT 0,
"office_area" REAL NOT NULL DEFAULT 0,
"other_area" REAL NOT NULL DEFAULT 0,
"residential_area" REAL NOT NULL DEFAULT 0,
"retail_area" REAL NOT NULL DEFAULT 0,
"school_area" REAL NOT NULL DEFAULT 0,
"pop_households" INTEGER NOT NULL DEFAULT 0,
"pop_persons" INTEGER NOT NULL DEFAULT 0,
"pop_group_quarters" INTEGER NOT NULL DEFAULT 0,
"employment_total" INTEGER NOT NULL DEFAULT 0,
"employment_retail" INTEGER NOT NULL DEFAULT 0,
"employment_government" INTEGER NOT NULL DEFAULT 0,
"employment_manufacturing" INTEGER NOT NULL DEFAULT 0,
"employment_services" INTEGER NOT NULL DEFAULT 0,
"employment_industrial" INTEGER NOT NULL DEFAULT 0,
"employment_other" INTEGER NOT NULL DEFAULT 0,
"percent_white" REAL NOT NULL DEFAULT 0,
"percent_black" REAL NOT NULL DEFAULT 0,
"hh_inc_avg" REAL NOT NULL DEFAULT 0,
"electric_grid_transmission" INTEGER NOT NULL DEFAULT 1,
"electricity_provider" INTEGER NOT NULL DEFAULT 1,
FOREIGN KEY("area_type") REFERENCES "Area_Type"("area_type") deferrable initially deferred,
FOREIGN KEY("electric_grid_transmission") REFERENCES "Electricity_Grid_Transmission"("Transmission_Bus_ID") deferrable initially deferred,
FOREIGN KEY("electricity_provider") REFERENCES "Electricity_Provider"("Provider_ID") deferrable initially deferred
);
SELECT AddGeometryColumn( 'Zone', 'geo', SRID_PARAMETER, 'MULTIPOLYGON', 'XY' );
SELECT CreateSpatialIndex( 'Zone' , 'geo' );
CREATE INDEX IF NOT EXISTS "IDX_ZONE_AREA" ON "Zone" ("area_type");