Geopackage - select on geometry column returns null

Question

In DB Manager in QGIS 2.18.26

I want to select geometries in geopackage table. The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the geometry text.

Source Layer:

Select on geometry column

How can i get the geometries?

EDIT: Here is the file

Use just select geom from deljin*_lines. Or select ST_AsText(geom)…if you want to see the WKT presentation of geometries. — user30184, Feb 27 '19 at 14:33
nothing returned with the simple select or with select ST_AsText(geom) — jlSta, Feb 27 '19 at 15:52
you have different names for the fields "id" and "fid", as well as "geom" and "geometry" ...select * from delijn_lines_za; select * from delijn_stops; select * from delijn_lines; — Cyril Mikhalchenko, Apr 23 '19 at 18:42

PieterB · Answer 1 · 2019-04-19T11:11:07.470

4

I also get empty values when I query the geopackage. (I tried both, QGIS 2.18.26 and 3.6) Perhaps it is a bug...

But, when you query the qgis-layers on the other hand, the query returns results.

In DB-manager go to virtual layers > QGIS layers
add following query:

select AsText(geometry) as geom, * from "transports_en_commun delijn_lines"

You get a result.

edited Apr 19 '19 at 11:11

answered Apr 19 '19 at 08:49

PieterB

5,287
22
37

Exactly the same behavior here with QGIS 3.8.3-Zanzibar – Paulo Cardoso Sep 26 '19 at 14:00
1

@PauloCardoso more info on https://github.com/qgis/QGIS/issues/27914 – PieterB Oct 09 '19 at 08:03

Geopackage - select on geometry column returns null

1 Answers1

Linked