Class GeometryIndexTableCreator

Geometry Index Extension Table Creator

Hierarchy

GeoPackageTableCreator
- GeometryIndexTableCreator

Constructors

constructor

new GeometryIndexTableCreator(geoPackage: GeoPackage): GeometryIndexTableCreator
Constructor
Parameters
- geoPackage: GeoPackage
  
  GeoPackage
Returns GeometryIndexTableCreator
Overrides GeoPackageTableCreator.constructor
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:34

Properties

connection

connection: GeoPackageConnection

geoPackage

geoPackage: GeoPackage

`Static` `Readonly` GEOMETRY_INDEX

GEOMETRY_INDEX: "geometry_index" = 'geometry_index'

Geometry Index property

`Static` `Readonly` INDEX_GEOMETRY_INDEX

INDEX_GEOMETRY_INDEX: "geometry_index_index" = 'geometry_index_index'

Index Geometry Index property

`Static` `Readonly` TABLE_INDEX

TABLE_INDEX: "table_index" = 'table_index'

Table Index property

`Static` `Readonly` UNINDEX_GEOMETRY_INDEX

UNINDEX_GEOMETRY_INDEX: "geometry_index_unindex" = 'geometry_index_unindex'

Unindex Geometry Index property

`Static` `Readonly` sqlScripts

sqlScripts: {
    contents: string[];
    contents_id: string[];
    data_column_constraints: string[];
    data_columns: string[];
    extended_relations: string[];
    extensions: string[];
    feature_tile_link: string[];
    geometry_columns: string[];
    geometry_index: string[];
    geometry_index_index: string[];
    geometry_index_unindex: string[];
    metadata: string[];
    metadata_reference: string[];
    spatial_reference_system: string[];
    table_index: string[];
    tile_matrix: string[];
    tile_matrix_set: string[];
    tile_scaling: string[];
} = ...

Type declaration

contents: string[]
contents_id: string[]
data_column_constraints: string[]
data_columns: string[]
extended_relations: string[]
extensions: string[]
feature_tile_link: string[]
geometry_columns: string[]
geometry_index: string[]
geometry_index_index: string[]
geometry_index_unindex: string[]
metadata: string[]
metadata_reference: string[]
spatial_reference_system: string[]
table_index: string[]
tile_matrix: string[]
tile_matrix_set: string[]
tile_scaling: string[]

Methods

createContents

createContents(): boolean
Creates the contents tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createContents
- Defined in lib/db/geoPackageTableCreator.ts:72

createContentsId

createContentsId(): boolean
Creates the contentsId tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createContentsId
- Defined in lib/db/geoPackageTableCreator.ts:163

createDataColumnConstraints

createDataColumnConstraints(): boolean
Creates the data column constraints tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createDataColumnConstraints
- Defined in lib/db/geoPackageTableCreator.ts:107

createDataColumns

createDataColumns(): boolean
Creates the data columns tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createDataColumns
- Defined in lib/db/geoPackageTableCreator.ts:100

createExtendedRelations

createExtendedRelations(): boolean
Creates the extended relations tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createExtendedRelations
- Defined in lib/db/geoPackageTableCreator.ts:156

createExtensions

createExtensions(): boolean
Creates the extensions tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createExtensions
- Defined in lib/db/geoPackageTableCreator.ts:128

createFeatureTileLink

createFeatureTileLink(): boolean
Creates the feature tile link tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createFeatureTileLink
- Defined in lib/db/geoPackageTableCreator.ts:149

createGeometryColumns

createGeometryColumns(): boolean
Creates the geometry columns tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createGeometryColumns
- Defined in lib/db/geoPackageTableCreator.ts:79

createGeometryIndex

createGeometryIndex(): boolean
Create Geometry Index table

Returns
executed statements

Returns boolean
Overrides GeoPackageTableCreator.createGeometryIndex
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:66

createMetadata

createMetadata(): boolean
Creates the metadata tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createMetadata
- Defined in lib/db/geoPackageTableCreator.ts:114

createMetadataReference

createMetadataReference(): boolean
Creates the metadata reference tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createMetadataReference
- Defined in lib/db/geoPackageTableCreator.ts:121

createRequired

createRequired(): boolean
Creates all required tables and Spatial Reference Systems, in addition to EPSG:3857

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createRequired
- Defined in lib/db/geoPackageTableCreator.ts:49

createSpatialReferenceSystem

createSpatialReferenceSystem(): boolean
Creates the spatial reference system tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createSpatialReferenceSystem
- Defined in lib/db/geoPackageTableCreator.ts:65

createTableIndex

createTableIndex(): boolean
Create Table Index table

Returns
executed statements

Returns boolean
Overrides GeoPackageTableCreator.createTableIndex
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:57

createTileMatrix

createTileMatrix(): boolean
Creates the tile matrix tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createTileMatrix
- Defined in lib/db/geoPackageTableCreator.ts:93

createTileMatrixSet

createTileMatrixSet(): boolean
Creates the tile matrix set tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createTileMatrixSet
- Defined in lib/db/geoPackageTableCreator.ts:86

createTileScaling

createTileScaling(): boolean
Creates the tileScaling tables

Returns

Returns boolean
Inherited from GeoPackageTableCreator.createTileScaling
- Defined in lib/db/geoPackageTableCreator.ts:170

createUserTable

createUserTable(userTable: UserTable<UserColumn>): {
changes: number;
lastInsertRowid: number;
}
Create the given user table.

Returns
the result of run

Throws
if the table already exists
Parameters
- userTable: UserTable<UserColumn>
  
  user table to create
Returns {
changes: number;
lastInsertRowid: number;
}
- changes: number
- lastInsertRowid: number
Inherited from GeoPackageTableCreator.createUserTable
- Defined in lib/db/geoPackageTableCreator.ts:200

dropTable

dropTable(table: string): void
Drop the table if it exists
Parameters
- table: string
  
  table name
Returns void
Inherited from GeoPackageTableCreator.dropTable
- Defined in lib/db/geoPackageTableCreator.ts:216

dropView

dropView(view: string): void
Drop the view if it exists
Parameters
- view: string
  
  view name
Returns void
Inherited from GeoPackageTableCreator.dropView
- Defined in lib/db/geoPackageTableCreator.ts:224

execScript

execScript(creationScriptName: SqlScripts): boolean
Creates all tables necessary for the specified table creation script name in the GeoPackage

Returns
Parameters
- creationScriptName: SqlScripts
  
  creation scripts to run
Returns boolean
Inherited from GeoPackageTableCreator.execScript
- Defined in lib/db/geoPackageTableCreator.ts:178

getAuthor

getAuthor(): string
Inherit Doc

Returns string
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:41

getName

getName(): string
Inherit Doc

Returns string
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:48

indexGeometryIndex

indexGeometryIndex(): boolean
Create Geometry Index table column indexes

Returns
executed statements

Returns boolean
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:75

unindexGeometryIndex

unindexGeometryIndex(): boolean
Un-index (drop) Geometry Index table column indexes

Returns
executed statements

Returns boolean
- Defined in lib/extension/nga/index/geometryIndexTableCreator.ts:83

Class GeometryIndexTableCreator

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

geoPackage: GeoPackage

Returns GeometryIndexTableCreator

Properties

connection

geoPackage

Static Readonly GEOMETRY_INDEX

Static Readonly INDEX_GEOMETRY_INDEX

Static Readonly TABLE_INDEX

Static Readonly UNINDEX_GEOMETRY_INDEX

Static Readonly sqlScripts

Type declaration

contents: string[]

contents_id: string[]

data_column_constraints: string[]

data_columns: string[]

extended_relations: string[]

extensions: string[]

feature_tile_link: string[]

geometry_columns: string[]

geometry_index: string[]

geometry_index_index: string[]

geometry_index_unindex: string[]

metadata: string[]

metadata_reference: string[]

spatial_reference_system: string[]

table_index: string[]

tile_matrix: string[]

tile_matrix_set: string[]

tile_scaling: string[]

Methods

createContents

Returns

Returns boolean

createContentsId

Returns

Returns boolean

createDataColumnConstraints

Returns

Returns boolean

createDataColumns

Returns

Returns boolean

createExtendedRelations

Returns

Returns boolean

createExtensions

Returns

Returns boolean

createFeatureTileLink

Returns

Returns boolean

createGeometryColumns

Returns

Returns boolean

createGeometryIndex

Returns

Returns boolean

createMetadata

Returns

Returns boolean

createMetadataReference

Returns

Returns boolean

createRequired

Returns

Returns boolean

createSpatialReferenceSystem

Returns

Returns boolean

createTableIndex

Returns

`Static` `Readonly` GEOMETRY_INDEX

`Static` `Readonly` INDEX_GEOMETRY_INDEX

`Static` `Readonly` TABLE_INDEX

`Static` `Readonly` UNINDEX_GEOMETRY_INDEX

`Static` `Readonly` sqlScripts

Returns {
changes: number;
lastInsertRowid: number;
}