<!DOCTYPE html><html><head><title></title><style type="text/css">#qt p.qt-MsoNormal{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:0in;font-size:12pt;font-family:"Aptos", sans-serif;}
#qt a:link{color:blue;text-decoration-color:currentcolor;text-decoration-line:underline;text-decoration-style:solid;text-decoration-thickness:auto;}
#qt pre{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:0in;font-size:10pt;font-family:"Courier New";}
</style></head><body><div>Hi Mike,</div><div><br></div><div>I don't think so, but coincidentally I was checking yesterday as it would allow some of the functions such as:</div><div><br></div><div>DATA "SELECT ObjectId, ST_Z(geometry) Z FROM mydata"</div><div><br></div><div>There is the CONNECTIONOPTIONS block, but this doesn't support a "--dialect" equivalent when testing. It would be nice to do something as follows:</div><div><br></div><div>CONNECTIONOPTIONS</div><div> "dialect" "sqlite"</div><div>END</div><div><br></div><div>Or alternatively adding in:</div><div><br></div><div>PROCESSING 'ogr_dialect=sqlite'</div><div><br></div><div>The MapServer OGR code would also need to be updated. </div><div><br></div><div>Seth<br></div><div><br></div><div id="sig62266145"><div class="signature">--</div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a></div><div class="signature">mastodon: @<a href="mailto:geographika@mastodon.social">geographika@mastodon.social</a></div></div><div><br></div><div>On Mon, Jul 21, 2025, at 5:52 PM, Michael Smith via MapServer-dev wrote:</div><blockquote type="cite" id="qt" style="overflow-wrap:break-word;"><div class="qt-WordSection1"><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;">And spatial filtering is working, it was due to BBOX sorting that it was not being very efficient in the spatial filtering.</span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;"> </span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;">Is there a method to use SQLite dialect with MapServer queries with parquet and OGR? Wanted to use SAMPLE but this is only supported via SQLite dialect.</span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;"> </span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;">Mike</span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;"> </span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;"> </span></p><div><div><p class="qt-MsoNormal">-- </p></div><div><p class="qt-MsoNormal">Michael Smith</p><p class="qt-MsoNormal">RSGIS Center – ERDC CRREL NH</p></div></div><p class="qt-MsoNormal">US Army Corps<span class="font" style="font-family:"Calibri", sans-serif;"></span></p><p class="qt-MsoNormal"><span class="font" style="font-family:"Calibri", sans-serif;"> </span></p><div style="border-right-width:medium;border-right-style:none;border-right-color:currentcolor;border-bottom-width:medium;border-bottom-style:none;border-bottom-color:currentcolor;border-left-width:medium;border-left-style:none;border-left-color:currentcolor;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;border-top-width:1pt;border-top-style:solid;border-top-color:rgb(181, 196, 223);padding-top:3pt;padding-right:0in;padding-bottom:0in;padding-left:0in;"><p class="qt-MsoNormal"><b><span style="color:black;"><span class="font" style="font-family:"Calibri", sans-serif;">From: </span></span></b><span style="color:black;"><span class="font" style="font-family:"Calibri", sans-serif;">Even Rouault <even.rouault@spatialys.com><br><b>Date: </b>Monday, July 21, 2025 at 10:05 AM<br><b>To: </b>Michael Smith <michael.smith.erdc@gmail.com>, MapServer-dev <mapserver-dev@lists.osgeo.org><br><b>Subject: </b>Re: [MapServer-dev] Using OGR geoparquet data in mapserver - no spatial filtering</span></span></p></div><div><p class="qt-MsoNormal"> </p></div><p class="qt-MsoNormal">Mike,</p><blockquote style="margin-top:5pt;margin-bottom:5pt;"><pre> </pre><pre>Anyone know a current way to get mapserver to add spatial filtering on OGR geoparquet layers. Have been unable to get the actual sql query being used with CPL_DEBUG inside mapserver with CONFIG "CPL_DEBUG" "ON" but from the performance, it appears no spatial filtering is being done. I suspect code changes to mapogr would be needed to do this but wondering if anyone else has looked into this.</pre></blockquote><p class="qt-MsoNormal"><br></p><div>I haven't tried but I would assume this should work</div><p><br></p><blockquote style="margin-top:5pt;margin-bottom:5pt;"><pre> </pre><pre> </pre><pre>Also, I tried using ADBC connection to parquet, and while it worked (technically) it really used an excessive amount of CPU and memory over using the geoparquet driver. </pre></blockquote><p>Yes this is "expected". I noticed that the Arrow API of duckdb tends to ingest everything in memory before paging results.</p><p>Even</p><pre>-- </pre><pre><a href="http://www.spatialys.com">http://www.spatialys.com</a></pre><pre>My software is free, but my time generally not.</pre></div><div>_______________________________________________</div><div>MapServer-dev mailing list</div><div><a href="mailto:MapServer-dev@lists.osgeo.org">MapServer-dev@lists.osgeo.org</a></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-dev">https://lists.osgeo.org/mailman/listinfo/mapserver-dev</a></div><div><br></div></blockquote><div><br></div></body></html>