[gdal-dev] no such function: ST_Line_Interpolate_Point when Spatialite and GDAL are installed and quite up-to-date

[Andrew Bell]

Have you successfully used Spatialite at all?

What is your platform? How did you verify Spatialite is installed?

On Tue, Feb 2, 2021, 6:13 PM Ann Tulliani via gdal-dev <
gdal-dev at lists.osgeo.org> wrote:

> 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-bin
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> spatialite-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ña
> QGIS code revision: 1e6b1a3e
> Qt version: 5.12.6
> GDAL version: 3.0.2
> GEOS version: 3.7.2-CAPI-1.11.2 b55d2125
> PROJ 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210202/2cbfa862/attachment-0001.html>