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