Working in QGIS 2.18.14 standalone on Windows, is there a way to create a Spatial Index for Geopackage (gpkg) layers?


I don't believe that it is possible through the QGIS UI at the moment. Read the GDAL GeoPackage vector manual http://www.gdal.org/drv_geopackage.html and use ogrinfo.

ogrinfo -SQL "SELECT CreateSpatialIndex('table_name', 'geom_column_name')" geopackage.gpkg
| improve this answer | |
  • I think you need "SELECT Create..." to make it work – JaakL Nov 6 '19 at 20:18

It's possible in QGIS3. You can click "Create Spatial index" from the Layer Properties Dialog:

enter image description here

| improve this answer | |
  • Does this option also enable spatial index auto updates? – Comrade Che Sep 15 at 7:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.