<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Malgun Gothic";
panose-1:2 11 5 3 2 0 0 2 0 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:remialcxesans;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:zone-1;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:zones-AQ;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"\@Malgun Gothic";}
@font-face
{font-family:template-7e3j9F-6EeuYiSgYeMNe5A;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Confirming that installing sqlite to /usr/local instead of /usr/local/</span>install-sqlite-trusted-schema-off and just overwriting the system sqlite fixes the problem.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Jon<span style="font-size:11.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<div dir="ltr" style="mso-line-height-rule:exactly;-webkit-text-size-adjust:100%;font-size:1px;direction:ltr;"><table dir="ltr" cellpadding="0" cellspacing="0" border="0" style="width:100%;direction:ltr;border-collapse:collapse;font-size:1px;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:10px 0 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;color:#4A4A49;font-style:normal;font-weight:700;white-space:nowrap;"><tr style="font-size:14.67px;"><td align="left" style="padding:0;vertical-align:top;font-family:Arial;">e: </td><td align="left" style="padding:0 0 0 4px;vertical-align:top;color:#F6A124;font-family:Arial;font-weight:400;"><a href="mailto:Jon.Morris@jbarisk.com" target="_blank" id="LPlnk689713" style="text-decoration:none;color:#F6A124;">Jon.Morris@jbarisk.com</a></td></tr><tr style="font-size:14.67px;"><td align="left" style="padding:0;vertical-align:top;font-family:Arial;">d:</td><td align="left" style="padding:0 0 0 4px;vertical-align:top;color:#F6A124;font-family:Arial;font-weight:400;">+44 (0)1756 587229<br /></td></tr><tr style="font-size:14.67px;"><td align="left" style="padding:0;vertical-align:top;font-family:Arial;">t: </td><td align="left" style="padding:0 0 0 4px;vertical-align:top;color:#F6A124;font-family:Arial;font-weight:400;"><a href="tel:+44%20(0)1756%20799919" target="_blank" id="LPlnk689713" style="text-decoration:none;color:#F6A124;">+44 (0)1756 799919</a></td></tr><tr style="font-size:0;"><td align="left" style="padding:0;vertical-align:top;"></td><td align="left" style="padding:0 0 0 4px;vertical-align:top;"></td></tr></table></td></tr></table></td></tr><tr style="font-size:14.67px;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><td align="left" style="vertical-align:top;font-family:Arial;"><a href="http://www.jbarisk.com/" target="_blank" id="LPlnk689713" title="Click to visit our website" style="text-decoration:none;color:#F6A124;">www.jbarisk.com</a></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:10px 0 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td rowspan="3" align="left" style="padding:0 0 5px;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:2px 0 14px;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;border-collapse:collapse;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><img src="cid:image017610.png@E55455F3.8AE03206" width="149" height="52" border="0" alt="" style="width:149px;min-width:149px;max-width:149px;height:52px;min-height:52px;max-height:52px;font-size:0;" /></td><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="left" style="padding:0 0 0 14px;vertical-align:top;"><img src="cid:image639965.png@C3EC0CB5.208A2699" width="31" height="52" border="0" alt="" style="width:31px;min-width:31px;max-width:31px;height:52px;min-height:52px;max-height:52px;font-size:0;" /></td></tr></table></td></tr></table></td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:0 0 12px;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="height:30px;border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="left" style="padding:0 3px 3px 0;vertical-align:top;"><a href="https://www.linkedin.com/company/jba-risk-management/" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="cid:image116692.png@487AB766.48DE112A" width="28" height="28" border="0" alt="" style="width:28px;min-width:28px;max-width:28px;height:28px;min-height:28px;max-height:28px;font-size:0;" /></a></td></tr></table></td><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="left" style="padding:0 3px 3px 0;vertical-align:top;"><a href="https://www.youtube.com/channel/UC0iatom2jYbW96voW0rlpCw" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="cid:image104301.png@F1089D4E.650CBF3E" width="28" height="28" border="0" alt="" style="width:28px;min-width:28px;max-width:28px;height:28px;min-height:28px;max-height:28px;font-size:0;" /></a></td></tr></table></td></tr></table></td></tr></table></td></tr></table></td><td style="padding:0;"> </td></tr><tr style="font-size:0;"><td style="padding:0;"> </td></tr><tr style="font-size:0;"><td style="padding:0;"> </td></tr></table></td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:7px 0 5px;border-top:solid 1px #4A4A49;border-right:none;border-bottom:none;border-left:none;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="white-space:normal;color:#444444;font-size:14.67px;font-family:Calibri,Arial,sans-serif;font-weight:400;font-style:normal;text-align:left;line-height:12px;border-collapse:collapse;"><tr style="font-size:9px;"><td style="font-family:Arial;"><span style="background-color:#FFFFFF;">All JBA Risk Management's email messages contain confidential information and are intended only for the individual(s) named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.</span><br /><span style="background-color:#FFFFFF;">Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system.</span> <br /><span style="background-color:#FFFFFF;">JBA Risk Management Limited is registered in England, company number 07732946, 1 Broughton Park, Old Lane North, Broughton, Skipton, North Yorkshire, BD23 3FD, England</span><span style="color:#000001;">.</span><br /></td></tr></table></td></tr></table></td></tr></table><span style="font-family:remialcxesans;"> <span style="font-family:'template-7e3j9F-6EeuYiSgYeMNe5A';"> </span><span style="font-family:'zone-1';"> </span><span style="font-family:'zones-AQ';"> </span></span></div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm;font-size:pt">
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif">From:</span></b><span style="font-family:"Calibri",sans-serif"> gdal-dev <gdal-dev-bounces@lists.osgeo.org>
<b>On Behalf Of </b>Jon Morris via gdal-dev<br>
<b>Sent:</b> 15 May 2025 12:25<br>
<b>To:</b> gdal dev <gdal-dev@lists.osgeo.org><br>
<b>Subject:</b> Re: [gdal-dev] Building GDAL with rtree support<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:13.0pt;background:#FFEB9C"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#9C6500">CAUTION:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> This email originated
from outside of JBA and </span><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#9C6500">contains one or more links and one or more attachments</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">. DO
NOT click links or open attachments unless you recognise the sender's email address and are absolutely certain that the content is safe.<br>
See the Phishing page on IMS on SP for more information about how to spot and report suspicious messages.<o:p></o:p></span></p>
</div>
<div>
<div style="border:solid #9C0006 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:13.0pt;background:#FFC7CE"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#9C0006">WARNING: This email contains one or more attachments with links within the attachment(s)</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">.
Please take extra care when handling the attachments.<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Jukka,<br>
<br>
If I just run sqlite3 on the command line (/usr/local/bin/sqlite3) then ENABLE_RTREE is not there, but if I run the version I compiled, /usr/local/install-sqlite-trusted-schema-off/bin/sqlite3, then it is.<br>
<br>
I suspect one of the downstream dependencies is using the wrong version of sqlite but I'm pretty sure I've specified the correct one for proj, spatialite, and gdal.
<br>
<br>
The sqlite build step has been copied from <a href="https://github.com/OSGeo/gdal/blob/master/.github/workflows/ubuntu_20.04/Dockerfile.ci#L247">
https://github.com/OSGeo/gdal/blob/master/.github/workflows/ubuntu_20.04/Dockerfile.ci#L247</a> - is there a good reason to configure with --prefix=/usr/local/install-sqlite-trusted-schema-off rather than just replacing the sqlite in /usr/local/bin?<br>
<br>
Jon<o:p></o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#4A4A49">e: <o:p></o:p></span></b></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 3.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#F6A124"><a href="mailto:Jon.Morris@jbarisk.com" target="_blank"><span style="color:#F6A124;text-decoration:none">Jon.Morris@jbarisk.com</span></a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#4A4A49">d:<o:p></o:p></span></b></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 3.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#F6A124">+44 (0)1756 587229<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#4A4A49">t: <o:p></o:p></span></b></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 3.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#F6A124"><a href="tel:+44%20(0)1756%20799919" target="_blank"><span style="color:#F6A124;text-decoration:none">+44 (0)1756 799919</span></a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm"></td>
<td valign="top" style="padding:0cm 0cm 0cm 3.0pt"></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#000001"><a href="http://www.jbarisk.com/" target="_blank" title="Click to visit our website"><span style="color:#F6A124;text-decoration:none">www.jbarisk.com</span></a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td rowspan="3" valign="top" style="padding:0cm 0cm 3.75pt 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:1.5pt 0cm 10.5pt 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:1.0pt"><img border="0" width="149" height="52" style="width:1.552in;height:.5416in" id="Picture_x0020_4" src="cid:image001.png@01DBC5B2.31357880"></span><span style="font-size:1.0pt"><o:p></o:p></span></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 10.5pt">
<p class="MsoNormal"><span style="font-size:1.0pt"><img border="0" width="31" height="52" style="width:.3229in;height:.5416in" id="Picture_x0020_3" src="cid:image002.png@01DBC5B2.31357880"></span><span style="font-size:1.0pt"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 9.0pt 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 2.25pt 2.25pt 0cm">
<p class="MsoNormal"><a href="https://www.linkedin.com/company/jba-risk-management/" target="_blank"><span style="font-size:1.0pt;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_2" src="cid:image003.png@01DBC5B2.31357880"></span></a><span style="font-size:1.0pt"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0cm 2.25pt 2.25pt 0cm">
<p class="MsoNormal"><a href="https://www.youtube.com/channel/UC0iatom2jYbW96voW0rlpCw" target="_blank"><span style="font-size:1.0pt;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_1" src="cid:image004.png@01DBC5B2.31357880"></span></a><span style="font-size:1.0pt"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:1.0pt"> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:1.0pt"> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:1.0pt"> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="border:none;border-top:solid #4A4A49 1.0pt;padding:5.25pt 0cm 3.75pt 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="line-height:9.0pt;mso-line-height-rule:exactly"><span style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#444444;background:white">All JBA Risk Management's email messages contain confidential information and are intended
only for the individual(s) named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.</span><span style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#444444"><br>
<span style="background:white">Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system.</span>
<br>
<span style="background:white">JBA Risk Management Limited is registered in England, company number 07732946, 1 Broughton Park, Old Lane North, Broughton, Skipton, North Yorkshire, BD23 3FD, England</span></span><span style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#000001">.</span><span style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#444444"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:1.0pt;font-family:"remialcxesans",serif"> </span><span style="font-size:1.0pt;font-family:"template-7e3j9F-6EeuYiSgYeMNe5A",serif"> </span><span style="font-size:1.0pt;font-family:"zone-1",serif"> </span><span style="font-size:1.0pt;font-family:"zones-AQ",serif"> </span><span style="font-size:1.0pt"><o:p></o:p></span></p>
</div>
<p class="MsoNormal">-----Original Message-----<br>
From: Rahkonen Jukka <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>>
<br>
Sent: 15 May 2025 12:16<br>
To: gdal dev <<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>>; Jon Morris <<a href="mailto:Jon.Morris@jbarisk.com">Jon.Morris@jbarisk.com</a>><br>
Subject: Re: Building GDAL with rtree support<br>
<br>
CAUTION: This email originated from outside of JBA and contains one or more links. DO NOT click links unless you recognise the sender's email address and are absolutely certain that the content is safe.<br>
See the Phishing page on IMS on SP for more information about how to spot and report suspicious messages.<br>
<br>
Hi,<br>
<br>
If you suppose that rtree is missing, compile only SQLite and then run this in SQLite<br>
<br>
pragma compile_options;<br>
<br>
It should show "ENABLE_RTREE".<br>
<br>
If that is ok then the error happens in some other place.<br>
<br>
-Jukka-<br>
<br>
________________________________________<br>
Lähettäjä: gdal-dev käyttäjän Jon Morris via gdal-dev puolesta<br>
Lähetetty: Torstai 15. toukokuuta 2025 13.37<br>
Vastaanottaja: gdal dev<br>
Aihe: [gdal-dev] Building GDAL with rtree support<br>
<br>
Hello all, I'm trying to build GDAL python wheels and am having some autotest fails that is preventing the build. I think most if not all of these fails are due to rtree not being available in sqlite. AFAIK I've done everything needed but the build recipe must
be missing something. The dockerfile contents are below and I run it with the command `DOCKER_BUILDKIT=0 docker build -f Dockerfile -t gdal-wheelbuilder`. It gets as far as `ctest -V` then exits with the following test fails: 46 - autotest_gdrivers (Failed)
48 - autotest_ogr (Failed) 50 - autotest_pyscripts (Failed) Thanks, Jon FROM quay.io/pypa/manylinux_2_28_x86_64 # Arrow install instructions from
<a href="https://arrow.apache.org/install/RUN">https://arrow.apache.org/install/RUN</a> dnf update -y \ && dnf groupinstall -y "Development Tools" \ && dnf install -y epel-release \ && dnf install -y
<a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-$(cut">https://dl.fedoraproject.org/pub/epel/epel-release-latest-$(cut</a> -d: -f5 /etc/system-release-cpe | cut -d. -f1).noarch.rpm \ && dnf install -y
<a href="https://packages.apache.org/artifactory/arrow/almalinux/$(cut">https://packages.apache.org/artifactory/arrow/almalinux/$(cut</a> -d: -f5 /etc/system-release-cpe | cut -d. -f1)/apache-arrow-release-latest.rpm \ && dnf config-manager --set-enabled epel
\ && dnf config-manager --set-enabled powertools \ && dnf install -y arrow-devel \ && dnf install -y arrow-dataset-devel \ && dnf install -y parquet-develRUN dnf install -y \ ant \ autoconf \ automake \ bash-completion \ cmake \ ca-certificates \ ccache \
clang \ cmake \ curl-devel \ doxygen \ git \ gnupg \ gpsbabel \ lcov \ hdf5-devel \ json-devel \ json-c-devel \ libaec-devel \ libdeflate-devel \ libjpeg-devel \ libkml-devel \ libpng-devel \ libpq-devel \ libtiff-devel \ libtool \ libwebp-devel \ libxml2-devel
\ libzstd-devel \ make \ minizip-devel \ numactl \ openssl-devel \ openjpeg2-devel \ pkg-config \ poppler-devel \ postgresql \ postgresql-contrib \ python3-devel \ python38-devel \ python3-lxml \ python3-numpy \ python3-pip \ python3-pytest \ python3-setuptools
\ python3-virtualenv \ swig \ unzip \ wget \ zip \ zlib-devel # Install geosRUN mkdir -p /src \ && cd /src \ && curl -f -L -O
<a href="https://download.osgeo.org/geos/geos-3.13.0.tar.bz2">https://download.osgeo.org/geos/geos-3.13.0.tar.bz2</a> \ && tar jxf geos-3.13.0.tar.bz2 \ && cd /src/geos-3.13.0 \ && mkdir build \ && cd build \ && cmake -DCMAKE_INSTALL_PREFIX=/usr -DBUILD_TESTING=OFF
-DCMAKE_BUILD_TYPE=Release .. \ && make -j$(nproc) \ && make install \ && cd / \ && rm -rf /src # Build a SQLite version with -DSQLITE_TRUSTED_SCHEMA=0RUN mkdir sqlite \ && wget -q
<a href="https://sqlite.org/2023/sqlite-autoconf-3430100.tar.gz">https://sqlite.org/2023/sqlite-autoconf-3430100.tar.gz</a> -O - \ | tar xz -C sqlite --strip-components=1 \ && cd sqlite \ && CFLAGS="-O2 -DSQLITE_TRUSTED_SCHEMA=0 -DSQLITE_ENABLE_COLUMN_METADATA
-DSQLITE_ENABLE_RTREE" ./configure --prefix=/usr/local/install-sqlite-trusted-schema-off \ && make -j$(nproc) \ && make -j$(nproc) install \ && cd .. \ && rm -rf sqlite # Fix proj versionRUN mkdir -p /src \ && cd /src \ && curl -f -L -O
<a href="https://download.osgeo.org/proj/proj-9.1.1.tar.gz">https://download.osgeo.org/proj/proj-9.1.1.tar.gz</a> \ && tar xzf proj-9.1.1.tar.gz \ && cd /src/proj-9.1.1 \ && mkdir build \ && cd build \ && cmake -DEXE_SQLITE3=/usr/local/install-sqlite-trusted-schema-off/bin/sqlite3
.. \ && cmake --build . \ && cmake --build . --target install \ && rm -rf /src # Build libgeotiff (system libgeotiff pulls in system libproj as a dependency)RUN mkdir -p /src \ && cd /src \ && curl -f -L -O
<a href="https://github.com/OSGeo/libgeotiff/releases/download/1.7.3/libgeotiff-1.7.3.tar.gz">
https://github.com/OSGeo/libgeotiff/releases/download/1.7.3/libgeotiff-1.7.3.tar.gz</a> \ && tar xzf libgeotiff-1.7.3.tar.gz \ && cd libgeotiff-1.7.3 \ && mkdir build_autoconf \ && cd build_autoconf \ && export LD_LIBRARY_PATH=/usr/local/lib64:/usr/local/lib:/usr/lib:/lib
\ && CFLAGS="-Wall -Wextra -Werror" ../configure \ && make -j$(nproc) \ && make check \ && cd .. \ && mkdir build_cmake \ && cd build_cmake \ && cmake -DCMAKE_C_COMPILER_LAUNCHER=ccache -DCMAKE_C_FLAGS="-Wall -Wextra -Werror" .. \ && make -j$(nproc) \ && rm
-rf /src # Build freexl (spatialite dependency)RUN mkdir -p /src \ && cd /src \ && curl -f -L -O
<a href="https://www.gaia-gis.it/gaia-sins/freexl-2.0.0.tar.gz">https://www.gaia-gis.it/gaia-sins/freexl-2.0.0.tar.gz</a> \ && tar xzf freexl-2.0.0.tar.gz \ && cd /src/freexl-2.0.0 \ && ./configure \ && make -j$(nproc) \ && make install \ && rm -rf /src # Build
spatialite so it uses correct PROJ and sqlite3RUN mkdir -p /src \ && cd /src \ && curl -f -L -O
<a href="https://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.1.0.tar.gz">
https://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.1.0.tar.gz</a> \ && tar xzf libspatialite-5.1.0.tar.gz \ && cd /src/libspatialite-5.1.0 \ && SQLITE3_CFLAGS="-I/usr/local/install-sqlite-trusted-schema-off/include/" SQLITE3_LIBS="-Wl,--enable-new-dtags,-rpath=/usr/local/install-sqlite-trusted-schema-off/lib
-L/usr/local/install-sqlite-trusted-schema-off/lib -lsqlite3" ./configure --disable-rttopo \ && make -j$(nproc) \ && make install \ && rm -rf /src # configure shared librariesRUN ldconfig -v # Add GDAL source to container# and checkout current branch and commit
(see README.md).# Also patch in commits <a href="https://github.com/OSGeo/gdal/commit/b36072fa1539b8ac97ea7864071d3468ac5b49ab#">
https://github.com/OSGeo/gdal/commit/b36072fa1539b8ac97ea7864071d3468ac5b49ab#</a> and
<a href="https://github.com/OSGeo/gdal/commit/222e1c111437f9fd6e43eb384f0903684735750b">
https://github.com/OSGeo/gdal/commit/222e1c111437f9fd6e43eb384f0903684735750b</a> to get rid of# arrow/parquet deprecation warningsARG GITHUB_WORKSPACE=/src RUN mkdir -p $GITHUB_WORKSPACE \ && cd $GITHUB_WORKSPACE \ && git config --global user.email
<a href="mailto:you@example.com">you@example.com</a> \ && git config --global user.name "Your Name" \ && git clone -b release/3.10
<a href="https://github.com/OSGeo/gdal.git">https://github.com/OSGeo/gdal.git</a> superbuild \ && cd superbuild \ && git checkout 9b7a7c8 \ && git cherry-pick b36072fa \ && git cherry-pick 222e1c11 # Install test requirementsRUN python3.8 -m pip install -U
pip setuptools numpy importlib_metadata \ && python3.8 -m pip install -r $GITHUB_WORKSPACE/superbuild/autotest/requirements.txt ## This section based on build-linux-ubuntu-focal job in .github/workflows/cmake_builds.yml ## ARG CMAKE_UNITY_BUILD=OFF # - name:
ConfigureRUN set -eu \ && cd $GITHUB_WORKSPACE/superbuild \ && export CXXFLAGS="-march=native -O2 -Wodr -flto-odr-type-merging -Werror" \ && export CFLAGS="-O2 -march=native -Werror" \ && mkdir build \ && cd build \ && cmake .. \ -Werror=dev \ -DCMAKE_INSTALL_PREFIX=$GITHUB_WORKSPACE/install-gdal
\ -DCMAKE_UNITY_BUILD=${CMAKE_UNITY_BUILD} \ -DGDAL_USE_PUBLICDECOMPWT:BOOL=ON \ -DPUBLICDECOMPWT_URL=https://github.com/rouault/PublicDecompWT \ -DWERROR_DEV_FLAG="-Werror=dev" \ -DPython_LOOKUP_VERSION=3.8 \ -DUSE_CCACHE=OFF \ -DCMAKE_INTERPROCEDURAL_OPTIMIZATION=ON
\ -DGDAL_USE_TIFF_INTERNAL=ON \ -DGDAL_USE_GEOTIFF_INTERNAL=ON \ -DSQLite3_INCLUDE_DIR=/usr/local/install-sqlite-trusted-schema-off/include \ -DSQLite3_LIBRARY=/usr/local/install-sqlite-trusted-schema-off/lib/libsqlite3.so \ -DBUILD_CSHARP_BINDINGS:BOOL=OFF
\ && unset CXXFLAGS \ && unset CFLAGS # - name: BuildRUN GIT_LFS_SKIP_SMUDGE=1 cmake --build $GITHUB_WORKSPACE/superbuild/build -- -j$(nproc) # - name: test (with command targets)RUN cmake --build $GITHUB_WORKSPACE/superbuild/build --target quicktest -- -j$(nproc)
# - name: test (with ctest)RUN cd $GITHUB_WORKSPACE/superbuild/build \ && ctest -V # - name: installRUN cmake --build $GITHUB_WORKSPACE/superbuild/build --target install -- -j$(nproc) ## END build-linux-ubuntu-focal job in .github/workflows/cmake_builds.yml
## Jon MorrisSoftware Developer-- e: <a href="mailto:Jon.Morris@jbarisk.comd:+44">
Jon.Morris@jbarisk.comd:+44</a> (0)1756 587229t: +44 (0)1756 799919www.jbarisk.com[X][X][X][X] All JBA Risk Management's email messages contain confidential information and are intended only for the individual(s) named. If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. JBA Risk Management Limited is registered in England, company number
07732946, 1 Broughton Park, Old Lane North, Broughton, Skipton, North Yorkshire, BD23 3FD, England.<o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>