<div style="color:;font: 10pt Helvetica Neue;">
<div><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;">Hi Andrew, thanks for your reply.</span><br>
</div>
<div>
<div><span style="font-family: Arial, Helvetica, sans-serif;"><br>
</span></div>
<div><span style="color: maroon; font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;">> What is your platform?</span><br>
</div>
<div>
<div><span style="font-family: Arial, Helvetica, sans-serif;">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:</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif;"><br>
</span></div>
<div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">QGIS version: 3.10.1-A Coruña</div>
</div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">QGIS code revision: 1e6b1a3e</div>
</div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">Qt version: 5.12.6</div>
</div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">GDAL version: 3.0.2</div>
</div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">GEOS version: 3.7.2-CAPI-1.11.2 b55d2125</div>
</div>
<div style="font-family: arial, helvetica; font-size: 13.3333px;">
<div style="font-family: Arial, Helvetica, sans-serif;">PROJ version: Rel. 6.2.1, November 1st, 2019</div>
</div>
</div>
<div><span style="font-family: Arial, Helvetica, sans-serif;"><br>
</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif;">What other platform details would be helpful for me to detail?</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif;"><br>
</span></div>
<div><span style="color: maroon;"><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;">> How did you verify Spatialite is installed?</span><br>
</span></div>
</div>
<div><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;">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:</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;"><br>
</span></div>
<div><span style="background-color: transparent;">
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">SpatiaLite version ..: 4.3.0a<span style="white-space: pre;"> </span>Supported Extensions:</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualShape'<span style="white-space:pre"> </span>[direct Shapefile access]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualDbf'<span style="white-space:pre"> </span>[direct DBF access]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualXL'<span style="white-space:pre"> </span>[direct XLS access]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualText'<span style="white-space:pre"> </span>[direct CSV/TXT access]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualNetwork'<span style="white-space:pre"> </span>[Dijkstra shortest path]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'RTree'<span style="white-space:pre"> </span>[Spatial Index - R*Tree]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'MbrCache'<span style="white-space:pre"> </span>[Spatial Index - MBR cache]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualSpatialIndex'<span style="white-space:pre"> </span>[R*Tree metahandler]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualElementary'<span style="white-space:pre"> </span>[ElemGeoms metahandler]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualXPath'<span style="white-space:pre"> </span>[XML Path Language - XPath]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualFDO'<span style="white-space:pre"> </span>[FDO-OGR interoperability]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualGPKG'<span style="white-space:pre"> </span>[OGC GeoPackage interoperability]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'VirtualBBox'<span style="white-space:pre"> </span>[BoundingBox tables]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre"> </span>- 'SpatiaLite'<span style="white-space:pre"> </span>[Spatial SQL - OGC]</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">PROJ.4 version ......: Rel. 7.0.0, March 1st, 2020</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">GEOS version ........: 3.8.0-CAPI-1.13.1 </span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">TARGET CPU ..........: x86_64-linux-gnu</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">the SPATIAL_REF_SYS table already contains some row(s)</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">SQLite version ......: 3.22.0</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">Enter ".help" for instructions</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">SQLite version 3.22.0 2018-01-22 18:45:57</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">Enter ".help" for instructions</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">Enter SQL statements terminated with a ";"</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;"><br>
</span></div>
<div style=""><span style="font-family: Arial, Helvetica, sans-serif;">
<div><span style="color: maroon;">> Have you successfully used Spatialite at all?</span></div>
<div>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).</div>
<div><br>
</div>
<div>Thanks again,</div>
<div><br>
</div>
<div>Ann Tulliani</div>
</span></div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt;"><br>
</div>
</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;"><br>
</span></div>
<div><span style="font-family: Arial, Helvetica, sans-serif; background-color: transparent; font-size: 10pt;"><br>
</span></div>
<div><br>
</div>
<div><br>
<br>
<div style="font-family:arial,helvetica;font-size:10pt;color:black">
<div class="">
<div>-----Original Message-----<br>
From: Andrew Bell <andrew.bell.ia@gmail.com><br>
To: Ann Tulliani <anntulliani@aol.com><br>
Cc: gdal dev <gdal-dev@lists.osgeo.org><br>
Sent: Tue, Feb 2, 2021 6:19 pm<br>
Subject: Re: [gdal-dev] no such function: ST_Line_Interpolate_Point when Spatialite and GDAL are installed and quite up-to-date<br>
<br>
<div id="yiv3781370086">
<div>
<div>Have you successfully used Spatialite at all?
<div><br clear="none"></div>
<div>What is your platform? How did you verify Spatialite is installed?</div>
</div>
<br clear="none">
<div class="yiv3781370086gmail_quote">
<div class="yiv3781370086yqt2769677707" id="yiv3781370086yqt59063">
<div class="yiv3781370086gmail_attr" dir="ltr">On Tue, Feb 2, 2021, 6:13 PM Ann Tulliani via gdal-dev <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:gdal-dev@lists.osgeo.org" target="_blank" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>> wrote:<br clear="none"></div>
<blockquote class="yiv3781370086gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><span style="font-family:Arial, Helvetica, sans-serif;">Dear list members,</span>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">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:</span></div>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px;">
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">GDAL command output:</span></div>
</div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(SELECT ST_Line_Interpolate_Point(geometry, 0.5) AS geometry,* FROM "myshapefile"):</span></div>
</div>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">no such function: ST_Line_Interpolate_Point</span></div>
</div>
</blockquote>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<div><span style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</span></div>
<div style="font-family:Arial, Helvetica, sans-serif;">Searching online, the only reference to that problem is a 5 years old thread from this very list: <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://lists.osgeo.org/pipermail/gdal-dev/2015-May/041800.html">https://lists.osgeo.org/pipermail/gdal-dev/2015-May/041800.html</a>. 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:</div>
<div style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</div>
</div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px;">
<div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">> sudo apt-get install -y spatialite-bin</div>
</div>
</div>
<div>
<div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">Reading package lists... Done</span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">Building dependency tree </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">Reading state information... Done</span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div><span style="font-family:Arial, Helvetica, sans-serif;">spatialite-bin is already the newest version (4.3.0-2build1).</span></div>
</div>
</div>
</div>
</blockquote>
<div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</div>
</div>
<div style="font-family:Arial, Helvetica, sans-serif;">For reference, it seems that GDAL version being used is 3.0.2 and PROJ version is 6.2.1:</div>
<div style="font-family:Arial, Helvetica, sans-serif;"><br clear="none">
</div>
</div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px;">
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>QGIS version: 3.10.1-A Coruña</div>
</div>
</div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>QGIS code revision: 1e6b1a3e</div>
</div>
</div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>Qt version: 5.12.6</div>
</div>
</div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>GDAL version: 3.0.2</div>
</div>
</div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>GEOS version: 3.7.2-CAPI-1.11.2 b55d2125</div>
</div>
</div>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div>PROJ version: Rel. 6.2.1, November 1st, 2019</div>
</div>
</div>
</blockquote>
<div>
<div style="font-family:Arial, Helvetica, sans-serif;">
<div><br clear="none">
</div>
<div>I am at a loss: if both GDAL and Spatialite are present in my system and up-to-date enough to contain "<span style="font-size:13.3333px;background-color:transparent;">ST_Line_Interpolate_Point", how could I solve the mentioned issue?</span></div>
<div><span style="font-size:13.3333px;background-color:transparent;"><br clear="none">
</span></div>
<div><span style="font-size:13.3333px;">Thanks!</span></div>
<div><span style="font-size:13.3333px;"><br clear="none">
</span></div>
<div><span style="font-size:13.3333px;">Ann Tulliani</span></div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
</div>
</div>
</div>
_______________________________________________<br clear="none">
gdal-dev mailing list<br clear="none">
<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:gdal-dev@lists.osgeo.org" target="_blank" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br clear="none">
<a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br clear="none">
</blockquote></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>