GeoPackageConnection object this dao belongs to
Readonly dbDatabase connection to the sqlite file
Readonly geoGeoPackageConnection object this dao belongs to
Readonly gpkgTable Name
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
Insert the object into the table
id of the inserted object
object to be inserted
Create a new SpatialReferenceSystem object
Optional results: Record<string, DBValue>Queries for the object by id, and if it exists, updates it, otherwise creates a new object
number of objects modified
object to update or create
Creates the required Undefined Cartesian Spatial Reference System (spec Requirement 11)
id of the created row
Creates the required Undefined Geographic Spatial Reference System (spec Requirement 11)
id of the created row
Creates the Web Mercator Spatial Reference System if it does not already exist
id of the created row
Creates the required EPSG WGS84 Spatial Reference System (spec Requirement 11)
id of the created row
Creates the required EPSG WGS84 Geographical 3D Spatial Reference System
spatial reference system
SQLException upon creation failure
Delete the object passed in. Object is deleted by id
number of objects deleted
object to delete
Delete the Spatial Reference System, cascading
deleted count
spatial reference system
Get the Spatial Reference System for the provided id
srs id
Get or Create the Spatial Reference System from the projection
srs
projection
Get or Create the Spatial Reference System for the provided organization and id
srs
organization
coordsys id
Get or Create the Spatial Reference System for the provided epsg
srs
epsg
Return the proj4 projection specified by this SpatialReferenceSystem
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
Query for equal
Iterate all objects in thet able that match the ColumnValues passed in
ColumnValues to query for
Query for object by id
object created from the raw database object
ID of the object 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
Query for object by multi id
object created from the raw database object
ColumnValues with the multi id
Query for the organization coordsys id
srs
organization
organization coordsys id
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
Refreshes the object by id
object to refresh
Set the CRS WKT Extension
CRS WKT Extension
Update the object specified
number of objects updated
object with updated values
Update all rows that match the query
number of objects updated
Static createGenerated using TypeDoc
Spatial Reference System Data Access Object