<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Mike,<span style="white-space: pre-wrap">
</span>
<blockquote type="cite"
cite="mid:31A80768-FB93-47C6-B51C-090430FD59A5@gmail.com">
<pre class="moz-quote-pre" wrap="">
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>
I haven't tried but I would assume this should work<br>
<blockquote type="cite"
cite="mid:31A80768-FB93-47C6-B51C-090430FD59A5@gmail.com">
<pre class="moz-quote-pre" wrap="">
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>
<span style="white-space: pre-wrap">
</span>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>