waterport table structure

The waterport table contains a listing of all the waterports within the modelled region, including their geographic information and capacity.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
waterport*	INTEGER	NO			The unique identifier of the county
x	REAL	YES	0		The x-coordinate of the waterport
y	REAL	YES	0		The y-coordinate of the waterport
name	TEXT	YES	‘’		The name of the waterport
capacity	REAL	YES	0		Annual landed weights of the waterport (units: metric tons)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Waterport" (
    "waterport"  INTEGER NOT NULL PRIMARY KEY,
    "x"          REAL DEFAULT 0,
    "y"          REAL DEFAULT 0,
    "name"       TEXT DEFAULT '',
    "capacity"   REAL DEFAULT 0
);
SELECT AddGeometryColumn( 'Waterport', 'geo', SRID_PARAMETER, 'POINT', 'XY', 1);
SELECT CreateSpatialIndex( 'Waterport' , 'geo' );
CREATE INDEX IF NOT EXISTS idx_polaris_waterport_waterport ON "Waterport" ("waterport");