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

[Ann Tulliani]

Hi Andrew, thanks for your reply.

> What is your platform?
In my original email, I mentioned that I am working in a 64 bits Ubuntu 18.04 system, as said calling ST_Line_Interpolate via QGIS GDAL tools, with:
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
What other platform details would be helpful for me to detail?
> How did you verify Spatialite is installed?
In my original email, I printed the output of the message saying which version I have installed when I try intalling/upgrading. But also, if I run "spatialite" in a terminal, I get the output:
SpatiaLite version ..: 4.3.0a Supported Extensions: - 'VirtualShape' [direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualXL' [direct XLS access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache' [Spatial Index - MBR cache] - 'VirtualSpatialIndex' [R*Tree metahandler] - 'VirtualElementary' [ElemGeoms metahandler] - 'VirtualXPath' [XML Path Language - XPath] - 'VirtualFDO' [FDO-OGR interoperability] - 'VirtualGPKG' [OGC GeoPackage interoperability] - 'VirtualBBox' [BoundingBox tables] - 'SpatiaLite' [Spatial SQL - OGC]PROJ.4 version ......: Rel. 7.0.0, March 1st, 2020GEOS version ........: 3.8.0-CAPI-1.13.1 TARGET CPU ..........: x86_64-linux-gnuthe SPATIAL_REF_SYS table already contains some row(s)SQLite version ......: 3.22.0Enter ".help" for instructionsSQLite version 3.22.0 2018-01-22 18:45:57Enter ".help" for instructionsEnter SQL statements terminated with a ";"
> Have you successfully used Spatialite at all?If you mean directly using Spatialite, in the past, yes. Recently in this system, did not have to (just tools I think rely on it).
Thanks again,
Ann Tulliani





-----Original Message-----
From: Andrew Bell <andrew.bell.ia at gmail.com>
To: Ann Tulliani <anntulliani at aol.com>
Cc: gdal dev <gdal-dev at lists.osgeo.org>
Sent: Tue, Feb 2, 2021 6:19 pm
Subject: Re: [gdal-dev] no such function: ST_Line_Interpolate_Point when Spatialite and GDAL are installed and quite up-to-date

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-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 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/040030a2/attachment.html>