Feature Table Index NGA Extension implementation. This extension is used to index Geometries within a feature table by their minimum bounding box for bounding box queries.

Hierarchy

Constructors

Properties

Methods

close count countColumnFeatures countFeatures countFeaturesWithBoundingBox countFeaturesWithBoundingBoxAndColumns countFeaturesWithBoundingBoxAndDistinct countFeaturesWithBoundingBoxAndDistinctAndColumns countFeaturesWithBoundingBoxAndProjection countFeaturesWithBoundingBoxAndProjectionAndColumns countFeaturesWithBoundingBoxAndProjectionAndDistinct countFeaturesWithBoundingBoxAndProjectionAndDistinctAndColumns countFeaturesWithColumn countFeaturesWithDistinct countFeaturesWithDistinctAndColumn countFeaturesWithGeometryEnvelope countFeaturesWithGeometryEnvelopeAndColumns countFeaturesWithGeometryEnvelopeAndDistinct countFeaturesWithGeometryEnvelopeAndDistinctAndColumns countWithBoundingBox countWithBoundingBoxAndProjection countWithGeometryEnvelope createExtension createGeometryIndexTable createTableIndexTable deleteIndex deleteIndexWithFeatureRow deleteIndexWithGeometryId get getBoundingBox getBoundingBoxWithProjection getChunkLimit getColumnName getExtension getFeatureRow getGeoPackage getGeometryIndexDao getLastIndexed getOrCreate getPkColumnName getProjection getTableIndex getTableIndexDao getTableName getTolerance hasExtension hasExtensions index indexFeatureRow indexGeometryIndexTable indexTable indexWithGeometryIdAndGeometryData isIndexed projectBoundingBox query queryBuilder queryBuilderWithGeometryEnvelope queryFeatures queryFeaturesForChunk queryFeaturesForChunkIdOrder queryFeaturesForChunkIdOrderWithColumns queryFeaturesForChunkIdOrderWithDistinct queryFeaturesForChunkIdOrderWithDistinctAndColumns queryFeaturesForChunkIdOrderWithGeometryEnvelope queryFeaturesForChunkIdOrderWithGeometryEnvelopeAndColumns queryFeaturesForChunkIdOrderWithGeometryEnvelopeAndDistinct queryFeaturesForChunkIdOrderWithGeometryEnvelopeAndDistinctAndColumns queryFeaturesForChunkWithBoundingBox queryFeaturesForChunkWithBoundingBoxAndColumns queryFeaturesForChunkWithBoundingBoxAndDistinct queryFeaturesForChunkWithBoundingBoxAndDistinctAndColumns queryFeaturesForChunkWithBoundingBoxAndProjection queryFeaturesForChunkWithBoundingBoxAndProjectionAndColumns queryFeaturesForChunkWithBoundingBoxAndProjectionAndDistinct queryFeaturesForChunkWithBoundingBoxAndProjectionAndDistinctAndColumns queryFeaturesForChunkWithColumns queryFeaturesForChunkWithDistinct queryFeaturesForChunkWithDistinctAndColumns queryFeaturesForChunkWithFieldValues queryFeaturesForChunkWithFieldValuesAndColumns queryFeaturesForChunkWithFieldValuesAndDistinct queryFeaturesForChunkWithFieldValuesAndDistinctAndColumns queryFeaturesForChunkWithGeometryEnvelope queryFeaturesForChunkWithGeometryEnvelopeAndColumns queryFeaturesForChunkWithGeometryEnvelopeAndDistinct queryFeaturesForChunkWithGeometryEnvelopeAndDistinctAndColumns queryFeaturesWithColumns queryFeaturesWithDistinct queryFeaturesWithDistinctAndColumns queryFeaturesWithGeometryEnvelope queryFeaturesWithGeometryEnvelopeAndColumns queryFeaturesWithGeometryEnvelopeAndDistinct queryFeaturesWithGeometryEnvelopeAndDistinctAndColumns queryWithBoundingBox queryWithBoundingBoxAndProjection queryWithGeometryEnvelope setChunkLimit setProgress setTolerance unindexGeometryIndexTable updateLastIndexed updateLastIndexedWithTableIndex verifyWritable getGeometryIndexDao getTableIndexDao

Constructors

Properties

chunkLimit: number = 1000

Query single chunk limit

Connection to the GeoPackage

extensionDefinition: string

Definition for the extension

extensionName: string

Name of the extension

extensionsDao: ExtensionsDao

ExtensionDao

geoPackage: GeoPackage

GeoPackage

Progress

tableName: string

extension table name

tolerance: number = 0.00000000000001

Query range tolerance

EXTENSION_AUTHOR: string = NGAExtensionsConstants.EXTENSION_AUTHOR

Extension author

EXTENSION_DEFINITION: "http://ngageoint.github.io/GeoPackage/docs/extensions/geometry-index.html" = 'http://ngageoint.github.io/GeoPackage/docs/extensions/geometry-index.html'

Extension definition URL

EXTENSION_NAME: string = ...

Extension, with author and name

EXTENSION_NAME_NO_AUTHOR: string = 'geometry_index'

Extension name without the author

Methods

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • column: string

      count column name

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • column: string

      count column name

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • column: string

      count column name

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the bounding box in the provided projection

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • column: string

      count column name

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count features

    Returns

    count

    Parameters

    • Optional column: string

      column

    • Optional where: string

      where

    • Optional whereArgs: any[]

      where args

    Returns number

  • Count features

    Returns

    count

    Parameters

    • Optional distinct: boolean

      distinct rows

    • Optional where: string

      where

    • Optional whereArgs: any[]

      where args

    Returns number

  • Count features

    Returns

    count

    Parameters

    • Optional distinct: boolean

      distinct rows

    • Optional column: string

      column

    • Optional where: string

      where

    • Optional whereArgs: any[]

      where args

    Returns number

  • Count the Features within the Geometry Envelope

    Returns

    count

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the Geometry Envelope

    Returns

    count

    Parameters

    • column: string

      count column name

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the Geometry Envelope

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Count the Features within the Geometry Envelope

    Returns

    count

    Parameters

    • distinct: boolean

      distinct column values

    • column: string

      count column name

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    Returns number

  • Query for Geometry Index count within the Geometry Envelope

    Returns

    count

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    Returns number

  • Create the extension

    Parameters

    • extensionName: string
    • tableName: string
    • columnName: string
    • definition: string
    • scopeType: string

    Returns number

  • Get the extension for the name, table name and column name

    Returns

    Parameters

    • extensionName: string

      extension name

    • Optional tableName: string

      table name

    • Optional columnName: string

      column name

    Returns Extensions

  • Determine if the GeoPackage has the extension

    Returns

    if the extension exists

    Parameters

    • extensionName: string

      extension name

    • tableName: string

      table name

    • columnName: string

      column name

    Returns boolean

  • Build a query builder to query for all Geometry Index objects

    Returns

    query builder

    Returns {
        where: string;
        whereArgs: any[];
    }

    • where: string
    • whereArgs: any[]
  • Build a query builder to query for Geometry Index objects within the Geometry Envelope

    Returns

    query builder

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    Returns {
        where: string;
        whereArgs: any[];
    }

    • where: string
    • whereArgs: any[]
  • Query for features

    Returns

    feature results

    Parameters

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • boundingBox: BoundingBox

      bounding box

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • boundingBox: BoundingBox

      bounding box

    • projection: Projection
    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • fieldValues: FieldValues

      field values

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • fieldValues: FieldValues

      field values

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • envelope: GeometryEnvelope

      geometry envelope

    • fieldValues: FieldValues

      field values

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • fieldValues: FieldValues

      field values

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for features within the geometry envelope, starting at the offset and returning no more than the limit

    Returns

    feature results

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • envelope: GeometryEnvelope

      geometry envelope

    • where: string

      where clause

    • whereArgs: any[]

      where arguments

    • orderBy: string

      order by

    • limit: number

      chunk limit

    • offset: number

      chunk query offset

    Returns FeatureResultSet

  • Query for all Features

    Returns

    feature results

    Parameters

    • Optional distinct: boolean

      distinct rows

    • Optional columns: string[]

      columns

    • Optional where: string

      where

    • Optional whereArgs: any[]

      where args

    Returns FeatureResultSet

  • Query for features within the geometry envelope

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • columns: string[]

      columns

    • Optional where: string
    • Optional whereArgs: any[]

    Returns FeatureResultSet

  • Query for features within the geometry envelope

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • distinct: boolean

      distinct rows

    • Optional where: string
    • Optional whereArgs: any[]

    Returns FeatureResultSet

  • Query for features within the geometry envelope

    Returns

    feature results

    Parameters

    • envelope: GeometryEnvelope

      geometry envelope

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • Optional where: string
    • Optional whereArgs: any[]

    Returns FeatureResultSet

Generated using TypeDoc