• Home
• mil.nga.geopackage
• geopackage-core
• 2.0.1
• source code
• nga_geometry_index

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.nga_geometry_index Maven / Gradle / Ivy

CREATE TABLE nga_geometry_index (
  table_name TEXT NOT NULL,
  geom_id INTEGER NOT NULL,
  min_x DOUBLE NOT NULL,
  max_x DOUBLE NOT NULL,
  min_y DOUBLE NOT NULL,
  max_y DOUBLE NOT NULL,
  min_z DOUBLE,
  max_z DOUBLE,
  min_m DOUBLE,
  max_m DOUBLE,
  CONSTRAINT pk_ngi PRIMARY KEY (table_name, geom_id),
  CONSTRAINT fk_ngi_nti_tn FOREIGN KEY (table_name) REFERENCES nga_table_index(table_name)
);

CREATE INDEX idx_nga_geometry_index_min_x ON nga_geometry_index ( min_x );

CREATE INDEX idx_nga_geometry_index_max_x ON nga_geometry_index ( max_x );

CREATE INDEX idx_nga_geometry_index_min_y ON nga_geometry_index ( min_y );

CREATE INDEX idx_nga_geometry_index_max_y ON nga_geometry_index ( max_y );

CREATE INDEX idx_nga_geometry_index_min_z ON nga_geometry_index ( min_z );

CREATE INDEX idx_nga_geometry_index_max_z ON nga_geometry_index ( max_z );

CREATE INDEX idx_nga_geometry_index_min_m ON nga_geometry_index ( min_m );

CREATE INDEX idx_nga_geometry_index_max_m ON nga_geometry_index ( max_m );