How to add another layer to GeoPackage in QGIS?

Question

QGIS 2.12 has support for saving a layer on the map in the GeoPackage format and that is great. However, I don't see a way to add another layer to the GPKG file, even though GeoPackage supports multiple layers. Is this functionality that is yet to come in QGIS or is there a way to do it with QGIS 2.12?

At least you do it from command line with ogr2ogr tool. – user30184 Dec 25 '15 at 21:35 — user30184, Dec 25 '15 at 21:35
ogr2ogr -f "GPKG" out.gpkg in.[shp|gpkg] -append -update – jgrocha Jul 04 '16 at 02:57 — jgrocha, Jul 04 '16 at 02:57

score 30 · Answer 1 · edited Apr 16 '19 at 13:34

30

I'm seeing this years later, but if someone still wonders...

In addition to the "save as" method, with QGIS 3.0, you can click and drag layers inside a GeoPackage within the Browser panel.

edited Apr 16 '19 at 13:34

b_jugger

103
12

answered Mar 21 '18 at 15:03

Nat Azodnem

451
4
8

1

This worked great for me. I had to create several different layers with the same basic Attributes(fields) . I just kept dragging them in from a file and re-naming them. Thanks! – Cary H May 01 '19 at 21:53
1

thank you, this saved so much time! – sn1ks Mar 24 '20 at 13:08
I discovered that (QGIS 3.10) you can create a new GeoPackage layer and specify the GeoPackage file you aleady have, and QGIS will warn you whether you want to "Overwrite" or "Add Layer" to existing file. – Tom Charles Zhang Oct 24 '23 at 11:33

score 8 · Answer 2 · answered Apr 11 '16 at 13:56

8

You could use DB Manager in Menu >> Databases.

Select the Database (Spatialite/Geopackage)
Import layer

answered Apr 11 '16 at 13:56

Carlos López Quintanilla

1,519
10
15

This method works for me using spatialite but not for geopackage. I get "error 11 connetion to database failed". – Colin Jan 10 '17 at 03:18
BTW I forgot to mention that I'm using QGIS 2.14.9 – Colin Jan 10 '17 at 05:27

score 7 · Answer 3 · answered Dec 23 '19 at 12:47

7

Right Click on the layer --> Export --> Save features as, change format to GeoPackage and choose the existing geopackage, change the layer name to what you wish and save.

answered Dec 23 '19 at 12:47

Enock4seth

127
1
6

This approach works for me. – Abdul Dec 16 '22 at 14:06

score 1 · Answer 4 · edited Apr 13 '17 at 12:34

1

DB Manager seems to have a bug working with geopackage data and can't be used to add another layer to a geopackage. You can use the 'save as' functionality in versions 2.18.1 and above. See: Add layer to existing geopackage not working in QGIS?.

edited Apr 13 '17 at 12:34

Community

1

answered Jan 12 '17 at 02:54

Colin

787
8
21

How to add another layer to GeoPackage in QGIS?

4 Answers4

Linked