1

I have a GeoPackage of many layers which I have added and deleted over time. I think because of that, I get several entries of the same layer. For example when I use the statistics tool, I get a list of all my layers in my GeoPackage, but most layers appear up to 5 times. It makes it difficult to find the right layer.

I guess each version (new and old) gets stored within the GeoPackage whenever I add a layer with the same name even though the layer exist only one time.

How can I clean up my GeoPackage?

Improve this question
2
  • 1
    That sounds like a bug in QGIS, can you replicate the "delete layer but the entry remains" or "add layer with same name is possible" and then post to github.com/qgis/QGIS ? – bugmenot123 Jul 29 '19 at 7:53
  • 1
    wondering whether you just need to do some VACUUM – nmtoken Jan 29 '20 at 10:35
1

This is a manual fix, no guarantees that it will work without side effects. Make sure you backup your file beforehand. Make sure the file is not opened by another program (like QGIS).

GeoPackage is a SQLite based format, a database in one file. You can use a SQLite client to connect to this file and execute SQL statements on it to alter its contents. For Linux you can use the sqlite3 tool, for a cross-platform GUI I like DB Browser for SQLite.

The list of available layers is stored in a table called gpkg_contents. In your case I assume that there are multiple, identical lines in it. Delete all duplicates and just leave one entry. If they are not identical, remove all but the latest (when ordered by id).

How you do that in the GUI should hopefully be self-explanatory. How you alternatively do it via SQL queries is another question.

Improve this answer
-1

I would suggest you to use GDAL command line to create or manipulate OGC GeoPackage instead of UI. QGIS is good to visualise vector data or raster data stored in geopackage.

Improve this answer
-1

In QGIS Browser, search the GPKG, right click on it and use VACUUM.

Improve this answer
1
  • VACUUM does not do anything here! – bugmenot123 Aug 1 '20 at 9:15

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.