New answers tagged

0 votes

Write layer style .qml as predefined within a gpkg using R

Thanks to @Spacedman I manage to do so by : -in Qgis(3.2) save your style in database (Geopackage) and export as .gpkg in R : #I save my style layer as an object mystyle <- sf::st_read("...
user avatar
0 votes
Accepted

PyQGIS script (.py) runs correctly on Windows but not on Mac

I found a solution, even if it doesn't solve all my doubts. The mac computer does not seem to recognise the relative path given, in any of the tried formulations (".\", ".", "....
user avatar
  • 47
0 votes

GDAL loop through gpkg layers

It is not straight forward to do that with a Windows batch file. The first step would be to read the layer list with ogrinfo, for example ogrinfo algeria.gpkg INFO: Open of `algeria.gpkg' using ...
user avatar
  • 51.5k
0 votes

Handling too many geopackages in QGIS

Your screenshot just show that you have a lot of gpkg. As I understand, you have only one layer per gpkg. As a start point, I suggest you to have one gpkg with multiple layers!
user avatar
  • 600
5 votes
Accepted

GeoPackage, SQLite: features count but don't exist (QGIS)

GDAL and QGIS want to know how many features there are on a layer but SELECT COUNT(*) is slow for big tables. Therefore GDAL creates an additional metadata table gpkg_ogr_contents from where the ...
user avatar
  • 51.5k
0 votes

Is there a fix for "sqlite3_exe(COMMIT) failed: database is locked" QGIS 3.6 Python 3.7

Turn off labeling, then save your changes.
user avatar
  • 1

Top 50 recent answers are included