<div dir="auto">Have you successfully used Spatialite at all?<div dir="auto"><br></div><div dir="auto">What is your platform? How did you verify Spatialite is installed?</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Feb 2, 2021, 6:13 PM Ann Tulliani via gdal-dev <<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank" rel="noreferrer">gdal-dev@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_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>
</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>
</span></div>

<div><span style="font-family:Arial,Helvetica,sans-serif"><br>
</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>
</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>
</span></div>

<div><span style="font-family:Arial,Helvetica,sans-serif"><br>
</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 href="https://lists.osgeo.org/pipermail/gdal-dev/2015-May/041800.html" rel="noreferrer noreferrer" target="_blank">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>
</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>
</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>
</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>
</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>
</span></div>

<div><span style="font-size:13.3333px">Thanks!</span></div>

<div><span style="font-size:13.3333px"><br>
</span></div>

<div><span style="font-size:13.3333px">Ann Tulliani</span></div>

<div><br>
</div>

<div><br>
</div>
</div>
</div>
</div>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" rel="noreferrer noreferrer" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div>