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