Constructor
RTree extension
user custom data access object
feature DAO
Protected Readonly geoGeoPackage
Protected progressProgress
Protected projectionProjection
Protected toleranceQuery range tolerance
Builds a where args array
argument values to push
Add a new column
new column
Alter a column
column
Alter columns
columns
Build where (or selection) args for the value
where args
value
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
Count the features within the bounds
count
min x
min y
max x
max y
where clause
where arguments
Count the features within the bounds
count
count column name
min x
min y
max x
max y
where clause
where arguments
Count the features within the bounds
count
distinct column values
min x
min y
max x
max y
where clause
where arguments
Count the features within the bounds
count
distinct column values
count column name
min x
min y
max x
max y
where clause
where arguments
Query for all features
feature results
Optional distinct: booleandistinct column values
Optional column: stringcolumn
Optional where: stringwhere
Optional whereArgs: any[]where args
Count the features within the bounds
count
distinct column values
count column name
min x
min y
max x
max y
field values
Count the Features within the Geometry Envelope
count
count column name
geometry envelope
where clause
where arguments
Count the Features within the Geometry Envelope
count
distinct column values
geometry envelope
where clause
where arguments
Count the Features within the Geometry Envelope
count
distinct column values
count column name
geometry envelope
where clause
where arguments
Query for the row where the field equals the value
Optional groupBy: stringOptional having: stringOptional orderBy: stringCount where all fields match their values
count
field values
Get the count in the nested SQL query
count
Optional nestedSQL: stringnested SQL
Optional nestedArgs: string[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: string[]where arguments
Get the count in the nested SQL query
count
Optional column: stringcount column name
Optional nestedSQL: stringnested SQL
Optional nestedArgs: string[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: string[]where arguments
Get the count in the nested SQL query
count
Optional distinct: booleandistinct column values
Optional nestedSQL: stringnested SQL
Optional nestedArgs: string[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: string[]where arguments
Get the count in the nested SQL query
count
Optional distinct: booleandistinct column values
Optional column: stringcount column name
Optional nestedSQL: stringnested SQL
Optional nestedArgs: string[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: string[]where arguments
Get the count of the result set and close it
count
result set
Count of rows within the bounds
results
BoundingBox
Optional projection: ProjectionProjection
Count of rows within the bounds
results
columns
BoundingBox
Optional projection: ProjectionProjection
Count of rows within the bounds
results
distinct rows
BoundingBox
Optional projection: ProjectionProjection
Count of rows within the bounds
results
distinct rows
columns
BoundingBox
Optional projection: ProjectionProjection
Count of rows within the bounds
results
distinct rows
columns
min x
min y
max x
max y
Create the RTree extension for the feature table
extension
Creates an object from results
Delete the row passed in
Delete rows matching the field values
deleted count
field values
Drop a column
column
Drop columns
columns
Query for the bounds of the feature table index
bounding box
Protected getProtected
Not supported
Query for the feature index bounds and return in the provided projection
bounding box
desired projection
Get the table columns
columns
Gets the count
Optional where: stringOptional whereArgs: [] | DBValue[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberGets the count
Optional where: stringOptional whereArgs: [] | DBValue[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberGets the count
Optional where: stringOptional whereArgs: [] | DBValue[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberGets the count
Optional where: stringOptional whereArgs: [] | DBValue[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberGet the database connection
database connection
Get the feature DAO
feature DAO
Get the feature row from the RTree Index Table row
feature row
RTree Index Table row
Get the feature row from the RTree Index Table row
feature row
result set
Get the feature row from the user custom row
feature row
custom row
Get the GeoPackage
Get the primary key column
primary key column
Protected getProtected getGet the RTree index extension
RTree index extension
Get the RTree Index Table row from the user custom row
RTree Index Table row
custom row
Get the RTree Index Table row from the current result set location
RTree Index Table row
result set
Get the table
table
Get the user database connection
user database connection
Inserts a new row
row id
content values
Inserts a new row
row id, -1 on error
content values
Generates a new row for this user custom dao
Protected preparePrepare the result before returning
prepared result
result
Project the provided bounding box in the declared projection to the user DAO projection
projected bounding box
bounding box
projection
Query for rtree index records
Optional where: stringOptional whereArgs: any[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for all features
feature results
Optional where: stringwhere
Optional whereArgs: any[]where args
Query for features within the bounds, starting at the offset and returning no more than the limit
results
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
where clause
chunk limit
chunk query offset
Query for features within the bounding box ordered by id, starting at the offset and returning no more than the limit
feature results
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box ordered by id, starting at the offset and returning no more than the limit
feature results
columns
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection ordered by id, starting at the offset and returning no more than the limit
feature results
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection ordered by id, starting at the offset and returning no more than the limit
feature results
columns
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
bounding box
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
min x
min y
max x
max y
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
columns
min x
min y
max x
max y
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
distinct rows
min x
min y
max x
max y
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
distinct rows
columns
min x
min y
max x
max y
where clause
chunk limit
chunk query offset
Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit
feature results
geometry envelope
where clause
chunk limit
chunk query offset
Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit
feature results
columns
geometry envelope
where clause
chunk limit
chunk query offset
Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
geometry envelope
where clause
chunk limit
chunk query offset
Query for features within the geometry envelope ordered by id, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
geometry envelope
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
columns
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
distinct rows
where clause
chunk limit
chunk query offset
Query for features within the bounds ordered by id, starting at the offset and returning no more than the limit
results
distinct rows
columns
where clause
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
columns
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
distinct rows
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
bounding box
field values
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
columns
bounding box
field values
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
distinct rows
bounding box
field values
order by
chunk limit
chunk query offset
Query for features within the bounding box, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
bounding box
field values
order by
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit
feature results
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit
feature results
columns
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit
feature results
distinct rows
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounding box in the provided projection, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
bounding box
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
min x
min y
max x
max y
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
columns
min x
min y
max x
max y
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
min x
min y
max x
max y
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
columns
min x
min y
max x
max y
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
columns
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
columns
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
min x
min y
max x
max y
field values
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
columns
min x
min y
max x
max y
field values
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
min x
min y
max x
max y
field values
order by
chunk limit
chunk query offset
Query for features within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
columns
min x
min y
max x
max y
field values
order by
chunk limit
chunk query offset
Query for features within the geometry envelope, starting at the offset and returning no more than the limit
feature results
geometry envelope
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the geometry envelope, starting at the offset and returning no more than the limit
feature results
columns
geometry envelope
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the geometry envelope, starting at the offset and returning no more than the limit
feature results
distinct rows
geometry envelope
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the geometry envelope, starting at the offset and returning no more than the limit
feature results
distinct rows
columns
geometry envelope
where clause
where arguments
order by
chunk limit
chunk query offset
Query for features within the bounds
results
min x
min y
max x
max y
Optional where: stringOptional whereArgs: any[]Query for features within the bounds
results
columns
min x
min y
max x
max y
Optional where: stringOptional whereArgs: any[]Query for features within the bounds
results
distinct rows
min x
min y
max x
max y
Optional where: stringOptional whereArgs: any[]Query for features within the bounds
results
distinct rows
columns
min x
min y
max x
max y
Optional where: stringOptional whereArgs: any[]Query for all features
feature results
Optional columns: string[]columns
Optional where: stringwhere
Optional whereArgs: any[]where args
Query for all features
feature results
Optional distinct: booleandistinct column values
Optional where: stringwhere
Optional whereArgs: any[]where args
Query for all features
feature results
Optional distinct: booleandistinct column values
Optional columns: string[]columns
Optional where: stringwhere
Optional whereArgs: any[]where args
Query for features within the geometry envelope
feature results
geometry envelope
Optional where: stringOptional whereArgs: any[]Query for features within the geometry envelope
feature results
columns
geometry envelope
Optional where: stringOptional whereArgs: any[]Query for features within the geometry envelope
feature results
distinct rows
geometry envelope
Optional where: stringOptional whereArgs: any[]Query for features within the geometry envelope
feature results
distinct rows
columns
geometry envelope
Optional where: stringOptional whereArgs: any[]Query for all rows
result
Query for ordered rows starting at the offset and returning no more than the limit.
Optional where: stringOptional whereArgs: any[]Optional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for rows within the bounding box, starting at the offset and returning no more than the limit
results
bounding box
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
columns
bounding box
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
distinct rows
bounding box
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
distinct rows
columns
bounding box
order by
chunk limit
chunk query offset
Query for rows within the bounds, starting at the offset and returning no more than the limit
results
min x
min y
max x
max y
order by
chunk limit
chunk query offset
Query for rows within the bounds, starting at the offset and returning no more than the limit
results
columns
min x
min y
max x
max y
order by
chunk limit
chunk query offset
Query for rows within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
min x
min y
max x
max y
order by
chunk limit
chunk query offset
Query for rows within the bounds, starting at the offset and returning no more than the limit
results
distinct rows
columns
min x
min y
max x
max y
order by
chunk limit
chunk query offset
Query for ordered rows starting at the offset and returning no more than the limit.
Optional where: stringOptional whereArgs: any[]Optional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for ordered rows starting at the offset and returning no more than the limit.
Optional where: stringOptional whereArgs: any[]Optional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for ordered rows starting at the offset and returning no more than the limit.
Optional where: stringOptional whereArgs: any[]Optional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for rows within the bounding box, starting at the offset and returning no more than the limit
results
geometry envelope
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
columns
geometry envelope
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
distinct rows
geometry envelope
order by
chunk limit
chunk query offset
Query for rows within the bounding box, starting at the offset and returning no more than the limit
results
distinct rows
columns
geometry envelope
order by
chunk limit
chunk query offset
Query for the row where all fields match their values
result
property name
property value
Optional groupBy: stringOptional having: stringOptional orderBy: stringQuery for the row where all fields match their values
result
columns
property name
property value
Optional groupBy: stringOptional having: stringOptional orderBy: stringQuery for the row where all fields match their values
result
distinct rows
property name
property value
Optional groupBy: stringOptional having: stringOptional orderBy: stringQuery for the row where the field equals the value
Optional groupBy: stringOptional having: stringOptional orderBy: stringQuery for the row where the field equals the value
result
field name
value
Query for the row where all fields match their values
result
field values
Query for the row where all fields match their values
result
columns
field values
Query for the row where all fields match their values
result
distinct rows
field values
Query for the row where all fields match their values
result
distinct rows
columns
field values
Query for the row with the provided id
row
id
Query for the row with the provided id
row
id
Gets the rows in this table by id
rows array
ids to query for
Query for the rows that are like the column
result
Query for rows by ids in the nested SQL query
result
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.
result
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Optional groupBy: stringgroup by
Optional having: stringhaving
Optional orderBy: stringorder by
Optional limit: numberchunk limit
Optional offset: numberchunk offset
Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.
result
columns
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Optional groupBy: stringgroup by
Optional having: stringhaving
Optional orderBy: stringorder by
Optional limit: numberchunk limit
Optional offset: numberchunk offset
Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.
result
distinct rows
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Optional groupBy: stringgroup by
Optional having: stringhaving
Optional orderBy: stringorder by
Optional limit: numberchunk limit
Optional offset: numberchunk offset
Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.
result
distinct rows
columns
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Optional groupBy: stringgroup by
Optional having: stringhaving
Optional orderBy: stringorder by
Optional limit: numberchunk limit
Optional offset: numberchunk offset
Query for rows by ids in the nested SQL query
result
columns
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Query for rows by ids in the nested SQL query
result
distinct rows
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Query for rows by ids in the nested SQL query
result
Optional distinct: booleandistinct rows
Optional columns: string[]columns
Optional nestedSQL: stringnested SQL
Optional nestedArgs: any[]nested SQL args
Optional where: stringwhere clause
Optional whereArgs: any[]where arguments
Query for typed values from the first column
single column values
sql statement
sql arguments
Optional limit: numberQuery for rows within the bounds
results
BoundingBox
Optional projection: ProjectionProjection
Query for rows within the bounds
results
columns
BoundingBox
Optional projection: ProjectionProjection
Query for rows within the bounds
results
distinct rows
BoundingBox
Optional projection: ProjectionProjection
Query for rows within the bounds
results
distinct rows
columns
BoundingBox
Optional projection: ProjectionProjection
Query for rows within the bounds
results
min x
min y
max x
max y
Query for rows within the bounds
results
columns
min x
min y
max x
max y
Query for rows within the bounds
results
distinct rows
min x
min y
max x
max y
Query for rows within the bounds
results
distinct rows
columns
min x
min y
max x
max y
Query for rtree index records
Optional where: stringOptional whereArgs: any[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for rtree index records
Optional where: stringOptional whereArgs: any[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for rtree index records
Optional where: stringOptional whereArgs: any[]Optional join: stringOptional groupBy: stringOptional having: stringOptional orderBy: stringOptional limit: numberOptional offset: numberQuery for rows within the bounds
results
geometry envelope
Query for rows within the bounds
results
columns
geometry envelope
Query for rows within the bounds
results
distinct rows
geometry envelope
Query for rows within the bounds
results
distinct rows
columns
geometry envelope
Raw query
result
SQL
Optional selectionArgs: []selection args
Raw query
result
SQL
subset of table columns defined in the SQL
selection args
Rename column
column
new column name
Protected renameSet the progress tracker
progress tracker
Updates a row
Update all rows matching the where clause with the provided values
updated count
content values
Optional whereClause: stringwhere clause
Optional whereArgs: []where arguments
Static readRead the table
Generated using TypeDoc
RTree Index Table DAO for reading geometry index ranges