zone table structure

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.

Table Structure#

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