[GRASS-user] GeoPackage and multiple tables

[Moritz Lennert]

Am 17. März 2019 18:16:44 MEZ schrieb Ken Mankoff <mankoff at gmail.com>:
>
>On 2019-03-17 at 10:03 -0700, Ken Mankoff <mankoff at gmail.com> wrote...
>> After learning from Markus & Moritz I see that the GPKG files are as
>> they should be - vector features are not in triplicate. I think there
>> are some strange QGIS import issues where it imports everything 3x
>but
>> this is not a GRASS issue.
>
>Actually, I am still confused about something with the file sizes. The
>data/metadata all appear correct. But if I export a three-layer vector
>w/ three tables 1x, the GPGK file is 12 MB and contains 1 table. It is
>missing two tables. If I then export each of the databases associated
>with each of the layers, they are 0.2 MB. If export the vector 3x, once
>per layer, with update, as advised earlier in this thread, the
>resulting GPKG is ~34 MB, or ~3x as large as I would expect it to be.
>
>v.out.ogr -c input=pal output=pal_all.gpkg --o # 12 MB, but only layer1
>table
>db.out.ogr input=pal output=l1.csv layer=1 # 7.5k
>db.out.ogr input=pal output=l2.csv layer=2 # 124K
>db.out.ogr input=pal output=l3.csv layer=3 # 85k
>
>v.out.ogr -c input=pal output_layer=tbl2_points output=pal.gpkg layer=1
>--o
>v.out.ogr -c input=pal output_layer=tbl2_areas output=pal.gpkg layer=2
>-u --o
>v.out.ogr -c input=pal output_layer=tbl2_lines output=pal.gpkg layer=3
>-u --o

Note that you are still using the -c flag, and so at each export all the geometries are exported, even those that have no category value in the respective layer.

Moritz