airport table structure

airport table structure#

The Airport Point of Entry (POE) table contains the attributes of airports that are within the modelled city, including the airport name, the geographic information, and the airport capacity

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

airport*

INTEGER

NO

The unique identifier of the airport

x

NUMERIC

NO

0

x coordinate of the airport. Automatically added by Polaris

y

NUMERIC

NO

0

y coordinate of the airport. Automatically added by Polaris

name

TEXT

NO

Name of the airport, as commonly known

capacity

NUMERIC

NO

0

Annual landed weights of the airport (units: metric tons)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Airport (
    "airport"       INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT,
    "x"             NUMERIC NOT NULL DEFAULT 0,
    "y"             NUMERIC NOT NULL DEFAULT 0,
    "name"          TEXT    NOT NULL,
    "capacity"      NUMERIC NOT NULL DEFAULT 0
);
SELECT AddGeometryColumn( 'Airport', 'geo', SRID_PARAMETER, 'POINT', 'XY', 1);
SELECT CreateSpatialIndex( 'Airport' , 'geo' );
CREATE INDEX IF NOT EXISTS "AIRPORT_I" ON "Airport" ("airport");