Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • Ok, does it mean that it's useless to load_module('mod_spatialite') when I start to query on the GPKG with python, or is it still necessary for usage of spatial operators ? Is there a better way to do so ? Commented Apr 24, 2018 at 20:08
  • You need spatialite for the spatial operators. In that case it may be that you can use the spatial index of gpkg transparently through the "virtual gpkg" system. Try to find documentation from the spatialite site. If may be a challenge. Commented Apr 24, 2018 at 20:49
  • Wiki page about virtual gpkg is at gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0+functions#8. I don't know if it is possible to make r-tree queries with select ROWID from SpatialIndex where f_table_name= for virtual gpkg tables. Commented Apr 25, 2018 at 6:12
  • when I select AutoGPKGStart(), it doesn't create virtual tables...I'll find another trick ; thanks anyway ! Commented Apr 25, 2018 at 7:41
  • Spatialite-gui is good reference implementation. Commented Apr 25, 2018 at 8:10