Monday, 17 October 2016

Creating Spatial Index for Geopackage using QGIS?



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



Answer



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

No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...