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 "CreateSpatialIndex('table_name', 'geom_column_name')" geopackage.gpkg

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

enter image description here

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.