[GRASS-user] GeoPackage and multiple tables

[Ken Mankoff]

Hello,

I'm trying to export a vector to GeoPackage. The vector has 3 layers and each layer has an associated table. When I view the data (pre-export) in GRASS it looks good, but when I export and open in QGIS I only see the layer1 table. Am I doing something wrong or is this a bug/limit in the GeoPackage exporter? Here is an MWE using the nc_spm_08_grass7 data set. I'm using grass 7.4.0. I note v.out.ogr does warn

> # WARNING: The combination of types is not supported by all formats.

But I think this is always printed and that GeoPackage can support a combination of types.

  -k.


grass ./nc_spm_08_grass7/PERMANENT

g.mapset -c gpgk
g.copy vector=poi_names_wake at PERMANENT,points
g.copy vector=lakes at PERMANENT,areas
g.copy vector=railroads at PERMANENT,lines

v.category in=areas out=areas_2 op=chlayer layer=1,2
v.category in=lines out=lines_3 op=chlayer layer=1,3
v.patch in=points,areas_2,lines_3 output=pal

v.db.addtable map=pal table="tbl_points" layer=1
v.db.addtable map=pal table="tbl_areas" layer=2
v.db.addtable map=pal table="tbl_lines" layer=3

v.db.connect -p map=pal
# Vector map <pal> is connected by:
# layer <1/tbl_points> table <tbl_points> in database </home/kdm/data/grass/nc_spm_08_grass7/gpgk/sqlite/sqlite.db> through driver <sqlite> with key <cat>
# layer <2/tbl_areas> table <tbl_areas> in database </home/kdm/data/grass/nc_spm_08_grass7/gpgk/sqlite/sqlite.db> through driver <sqlite> with key <cat>
# layer <3/tbl_lines> table <tbl_lines> in database </home/kdm/data/grass/nc_spm_08_grass7/gpgk/sqlite/sqlite.db> through driver <sqlite> with key <cat>
# GRASS 7.4.0 (nc_spm_08_grass7):~/data/grass > 

v.db.addcolumn map=pal layer=1 column="pt INT"
v.db.addcolumn map=pal layer=2 column="ar INT"
v.db.addcolumn map=pal layer=3 column="ln INT"

v.db.update map=pal layer=1 column=pt value=42
v.db.update map=pal layer=2 column=ar value=43
v.db.update map=pal layer=3 column=ln value=44

v.out.ogr -c input=pal output=pal.gpkg --o
# WARNING: The combination of types is not supported by all formats.

-- 
Ken Mankoff
Geological Survey of Denmark and Greenland (GEUS)
Department of Glaciology and Climate