Dear list members,
I have been trying to use the GDAL tools from within QGIS, more specifically 
the "Points Along Lines" tool, to find the lines' midpoints in line shapefiles. 
However, regardless of which file I try, I keep getting this error:


GDAL command output:ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(SELECT 
ST_Line_Interpolate_Point(geometry, 0.5) AS geometry,* FROM "myshapefile"):
no such function: ST_Line_Interpolate_Point


Searching online, the only reference to that problem is a 5 years old thread 
from this very list: 
https://lists.osgeo.org/pipermail/gdal-dev/2015-May/041800.html. Following it, 
the first obvious thing to suspect is that Spatialite is either missing or 
outdated. However, neither seem to be the case in my 64bits Ubuntu 18.04 system:

> sudo apt-get install -y spatialite-binReading package lists... DoneBuilding 
> dependency tree       Reading state information... Donespatialite-bin is 
> already the newest version (4.3.0-2build1).

For reference, it seems that GDAL version being used is 3.0.2 and PROJ version 
is 6.2.1:

QGIS version: 3.10.1-A CoruñaQGIS code revision: 1e6b1a3eQt version: 5.12.6GDAL 
version: 3.0.2GEOS version: 3.7.2-CAPI-1.11.2 b55d2125PROJ version: Rel. 6.2.1, 
November 1st, 2019

I am at a loss: if both GDAL and Spatialite are present in my system and 
up-to-date enough to contain "ST_Line_Interpolate_Point", how could I solve the 
mentioned issue?
Thanks!
Ann Tulliani

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to