Creating Spatial Index for GeoPackage using QGIS

Question

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

score 20 · Answer 1 · edited Sep 08 '21 at 05:59

20

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

edited Sep 08 '21 at 05:59

Taras

32,823
4
66
137

answered Dec 16 '17 at 03:50

ndawson

27,620
3
61
85

Does this option also enable spatial index auto updates? – Comrade Che Sep 15 '20 at 07:35

score 9 · Accepted Answer · edited Nov 06 '19 at 21:00

9

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

edited Nov 06 '19 at 21:00

Community

1

answered Dec 15 '17 at 11:37

user30184

65,331
4
65
118

I think you need "SELECT Create..." to make it work – JaakL Nov 06 '19 at 20:18

score 1 · Answer 3 · answered Sep 08 '21 at 05:41

1

There's also the processing tool: Create spatial index:

Creates an index to speed up access to the features in a layer based on their spatial location. Support for spatial index creation is dependent on the layer's data provider.

answered Sep 08 '21 at 05:41

BERA

72,339
13
72
161

1

Yes, thanks. I guess this processing tool has been around since QGIS 2.16, which worked only for shapefiles at the time of the question. – Kazuhito Sep 08 '21 at 13:12

Creating Spatial Index for GeoPackage using QGIS

3 Answers3

Linked