popsyn region table structure

popsyn region table structure#

Lists all population synthesis regions used in the model. These are the areas at which Polaris will perform population synthesis And must correspond exactly to the popsyn region identifiers shown in the sf1 file in your model’s folder structure.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

popsyn_region*

INTEGER

NO

ID for the popsyn region, could be census tract, block group or group or any custom spatial identifier

geo

MULTIPOLYGON

NO

‘’

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "PopSyn_Region" (
    popsyn_region  INTEGER NOT NULL   PRIMARY KEY
);
SELECT AddGeometryColumn( 'PopSyn_Region', 'geo', SRID_PARAMETER, 'MULTIPOLYGON', 'XY', 1);
SELECT CreateSpatialIndex( 'PopSyn_Region' , 'geo' );
CREATE INDEX IF NOT EXISTS "IDX_POPSYN_REGION_COUNTY" ON "PopSyn_Region" ("popsyn_region");