When I try to do some spatial query in the DB Manager (as Virtual Layer Provider) or in the Virtual Layer Window (Layer > Add new Layer > Create Virtual Layer...) it returns a NULL array, as it doesn't understand the GEOM field.

This happens with GPKG and KML. Although it doesn't happen with SHP. I tried with a KML layer (original), then I converted to GPKG and SHP. When queried in the BD Manager in GeoPackage Provider, it worked.

Is this an issue or exists an explanation?

I searched about it, but I didn't understand the conclusion.

DISCUSSION: Geopackage - select on geometry column returns null ;

  • I tried the same query for all them. SELECT * FROM layer SELECT st_buffer(geom, 1) FROM layer Sep 4, 2020 at 14:58
  • The first one is a control query: worked well with all formats. The second the test. Others ST_ have the same result. Sep 4, 2020 at 15:03


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.