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 Commented 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. Commented Sep 4, 2020 at 15:03


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.