Constructor
GeoPackage object this dao belongs to
Readonly dbDatabase connection to the sqlite file
Readonly geoGeoPackage
Readonly gpkgName of the table within the GeoPackage
Readonly idID Columns for this DAO
Builds a where args array
argument values to push
Build where or selection statement for fields
where clause
columns and values
Optional operation: string = 'and'AND or OR
Builds a where args array
argument values to push
Build where (or selection) LIKE statement for fields
where clause
columns and values
Optional operation: stringAND or OR
Builds a where clause from the field and value with an optional operation. If the value is empty, 'is null' is added to the query for the field
where clause
field name
Optional value: DBValueoptional value to filter on
Optional operation: string = '='optional operation
Count rows in the table optionally filtered by the parameters specified
count of objects
Optional fields: string | FieldValuesEither a ColumnValues object or a string specifying a field name
Optional value: DBValuevalue to filter on if fields is a string
Verify optional tables have been created
Get the bounding box for the table in the table's projection
bounding box
table name
Get the bounding box for the table in the provided projection
bounding box
desired bounding box projection
table name
Get the bounding box for all tables in the provided projection
bounding box
desired bounding box projection
Get a bounding box in the provided projection
bounding box
desired projection
desired projection
Gets the Contents for a particular table type
Optional tableType: string | ContentsDataTypeGets the Contents matching any of the table types
Optional tableTypes: (string | ContentsDataType)[]Gets the contents of the GeometryColumns
contents
Get the GeometryColumns for the Contents
Contents
Get table names by data type
table names
Optional dataType: ContentsDataTypedata type
Get table names for the provided data types
table names
Optional dataTypes: ContentsDataType[]data type
Get the tile matrix for the provided contents
Get the TileMatrixSet for the Contents
Contents
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
Optional where: stringOptional where clause
Optional whereArgs: DBValue[]Optional where args array
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
Optional where: stringOptional where clause
Optional whereArgs: DBValue[]Optional where args array
Query for all rows in the table that match
array of raw database objects
field to match
value to match
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Queries for all items in the table with a page size and page number
raw object array from the database
size of the chunk to query for
chunk number to query for
Queries for all matches and returns them. Only queries for the specified column name Be aware this pulls all results into memory
raw object array from the database
name of the column to query for
Optional fieldValues: FieldValuesoptional values to filter on
Iterate all items in the table one at a time. If no parameters are passed, iterates the entire table. Returns an Iterable object
iterable of database objects
Optional field: stringfield to filter on
Optional value: DBValuevalue to filter on
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Optional columns: string[]columns to retrieve
Iterate all objects in thet able that match the ColumnValues passed in
ColumnValues to query for
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
name of the field to query for
value of the like clause
Iterate all matching objects
join clause
Optional where: stringwhere clause
Optional whereArgs: DBValue[]array of where query values
Optional columns: string[]columns to query for
Iterate all matching rows
Optional where: stringwhere clause
Optional whereArgs: DBValue[]array of where query values
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Optional limit: numberlimit clause
Iterate all distinct matching rows in the table
where clause
Optional whereArgs: DBValue[]array of where query values
Update all rows that match the query
number of objects updated
Static createGenerated using TypeDoc
Contents object. Provides identifying and descriptive information that an application can display to a user in a menu of geospatial data that is available for access and/or update.