[Qgis-user] geopackage spatial query

[Burghardt.Scholle at stadt.wolfsburg.de]

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-bounces at lists.osgeo.org] Im Auftrag von
> Mithoefer
> Gesendet: Montag, 29. Oktober 2018 14:36
> An: qgis-user at 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 at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user