area type table structure

area type table structure#

Area types are used throughout the demand model to differentiate different regions within the modeled area (e.g. CBD, inner suburb, outer suburb, industrial).

Values for area_type are fixed and in the set (1,2,3,4,5,6,7,8,98,99), and Polaris models have particular parameters for these area types. Do not change them without being certain of it.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

area_type*

INTEGER

NO

Unique identifier for the area type

name

TEXT

NO

‘’

Simple description of the area type

notes

TEXT

YES

User notes

(* - Primary key)

The SQL statement for table and index creation is below.

create TABLE IF NOT EXISTS "Area_Type" (
    "area_type" INTEGER NOT NULL PRIMARY KEY,
    "name"      TEXT    NOT NULL DEFAULT '',
    "notes"     TEXT
);