Hi Klaus, as far as I understand it, geopackage does not support spatial functions - opposite to spatialite (see [1]). I mean, this topic was also discussed at the QGIS user meeting in Essen.
[1] https://gis.stackexchange.com/questions/228210/using-geopackage-instead-of-spatialite-and-vice-versa Regards Burghardt > -----Ursprüngliche Nachricht----- > Von: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von > Mithoefer > Gesendet: Montag, 29. Oktober 2018 14:36 > An: qgis-user@lists.osgeo.org > Betreff: [Qgis-user] geopackage spatial query > > Dear List, > > I have a geopackage database and tried to use a spatial sql function > (st_area) using the db manager in qgis 3.4 --> select st_area(geom) > from polygon_filename. The function is available, but the result is > Null. What is the problem? > > Thanks a lot > > Kind regards > > Klaus > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user