-
|
Hello, E/SQLiteLog: (1) no such function: st_area W/System.err: android.database.sqlite.SQLiteException: no such function: st_area (code 1 SQLITE_ERROR): , while compiling: SELECT "fid", "dimension", "name", "the_geom" FROM "grids" WHERE st_area(grids.the_geom) > 121; W/System.err: at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) Can anyone point me as to how should I perform spatial functions? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
GeoPackages uses basic SQLite (not SpatialLite), so the st_area method is not available. GeoPackage supports a RTree Spatial Index extension (see SQLite RTree) to help with geometry range queries. You'll find some geometry utility methods for already in memory geometries in this included source. If you really need to query from the area sizes, you could add an area column and save that info with each geometry. |
Beta Was this translation helpful? Give feedback.
GeoPackages uses basic SQLite (not SpatialLite), so the st_area method is not available.
GeoPackage supports a RTree Spatial Index extension (see SQLite RTree) to help with geometry range queries.
You'll find some geometry utility methods for already in memory geometries in this included source.
If you really need to query from the area sizes, you could add an area column and save that info with each geometry.