GeopackageDb class
A geopackage database.
@author Andrea Antonello (www.hydrologis.com)
Constructors
- GeopackageDb(String? _dbPath)
- GeopackageDb.memory()
Properties
- doRtreeTestCheck ↔ bool
-
getter/setter pair
- forceRasterMobileCompatibility ↔ bool
-
getter/setter pair
- forceVectorMobileCompatibility ↔ bool
-
If true, this forces vector or raster mobile compatibility, which means that:
getter/setter pair
- hashCode → int
-
The hash code for this object.
no setteroverride
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- supportsSpatialIndex → bool
-
no setter
- version → String?
-
no setter
Methods
-
addCRS(
int srid, String srsName, String organization, int organizationCoordSysId, String definition, String description) → void -
addCRSSimple(
String auth, int srid, String wkt) → void - Adds a crs to the geopackage, registering it in the spatial_ref_sys table.
-
addDefaultSpatialReferences(
) → void -
addGeometryColumnsEntry(
TableName tableName, String geometryName, String geometryType, int srid, bool hasZ, bool hasM) → void -
addGeometryXYColumnAndIndex(
TableName tableName, String geomColName, String geomType, String epsg) → void -
addGeoPackageContentsEntry(
TableName tableName, int srid, String? description, Envelope? crsBounds) → void -
checkStyleTable(
) → void -
close(
) → void -
createFeatureEntry(
QueryResultRow rs) → FeatureEntry -
createFunctions(
) → void -
createSpatialIndex(
TableName tableName, String geometryName) → void - Create a spatial index
-
createSpatialTable(
TableName tableName, int tableSrid, String geometryFieldData, List< String> fieldData, List<String> ? foreignKeys, bool avoidIndex) → void -
createTileEntry(
QueryResultRow row) → TileEntry -
execute(
String sql, {List? arguments, bool getLastInsertId = false}) → int? -
Execute a insert, update or delete using
sql
in normal or prepared mode usingarguments
. -
feature(
TableName name) → FeatureEntry? - Looks up a feature entry by name.
-
features(
) → List< FeatureEntry> - Lists all the feature entries in the geopackage. */
-
geometryToSql(
Geometry geom) → dynamic -
getBasicStyle(
TableName tableName) → BasicStyle - Get the basic style for a table.
-
getGeometriesIn(
TableName tableName, {Envelope? envelope, Geometry? intersectionGeometry, List< String?> ? prePostWhere, int limit = -1, String? userDataField}) → List<Geometry?> - Get the geometries of a table inside a given envelope.
-
getGeometriesIntersecting(
TableName tableName, {Geometry? geometry, List< String> ? prePostWhere, int limit = -1, String? userDataField}) → List<Geometry?> -
Get the geometries of a
tableName
intersecting a givengeometry
. -
getGeometryColumnNameAndSridForTable(
TableName tableName) → Future< List?> -
getGeometryColumnsForTable(
TableName tableName) → GeometryColumn? -
getPrimaryKey(
TableName tableName) → String? -
getSld(
TableName tableName) → String? - Get the SLD xml for a given table.
-
getSpatialindexBBoxWherePiece(
TableName tableName, String? alias, double x1, double y1, double x2, double y2) → String? -
getSpatialindexGeometryWherePiece(
TableName tableName, String? alias, Geometry geometry) → String? -
getSpatialIndexName(
FeatureEntry feature) → String -
getTableBounds(
TableName tableName) → Envelope -
getTableColumns(
TableName tableName) → List< List> -
Get the
tableName
columns as array of name, type, isPrimaryKey, notnull. -
getTableData(
TableName tableName, {Envelope? envelope, Geometry? geometry, String? where, int? limit}) → FeatureCollection -
getTables(
bool doOrder) → List< TableName> -
getTablesMap(
bool doOrder) → Map< String, List< String> > -
getTile(
TableName tableName, int tx, int ty, int zoom) → List< int> ? - Get a Tile's image bytes from the database for a given table.
-
getTileDirect(
TableName tableName, int tx, int ty, int zoom) → List< int> ? -
getTileZoomLevelsWithData(
TableName tableName) → List< int> - Get the list of zoomlevels that contain data.
-
hasCrs(
int srid) → bool -
hasSpatialIndex(
TableName table) → bool - Verifies if a spatial index is present
-
hasTable(
TableName tableName) → bool -
isOpen(
) → bool -
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
openOrCreate(
{Function? dbCreateFunction}) → dynamic -
select(
String sql) → QueryResult -
tile(
TableName name) → TileEntry? - Looks up a tile entry by name.
-
tiles(
) → List< TileEntry> - Lists all the tile entries in the geopackage. */
-
toString(
) → String -
A string representation of this object.
inherited
-
updateMap(
TableName table, Map< String, dynamic> values, String where) → int? - Update a new record using a map and a where condition.
-
updateSld(
TableName tableName, String sldString) → void - Update the sld string in the geopackage
Operators
-
operator ==(
Object other) → bool -
The equality operator.
override
Static Methods
Constants
- COL_TILES_TILE_COLUMN → const String
- COL_TILES_TILE_DATA → const String
- COL_TILES_TILE_ROW → const String
- COL_TILES_ZOOM_LEVEL → const String
- DATE_FORMAT_STRING → const String
- HM_STYLES_TABLE → const String
- MERCATOR_SRID → const int
- SELECTQUERY_POST → const String
- SELECTQUERY_PRE → const String
- WGS84LL_SRID → const int