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