And spatial filtering is working, it was due to BBOX sorting that it was not being very efficient in the spatial filtering.
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. Mike -- Michael Smith RSGIS Center – ERDC CRREL NH US Army Corps From: Even Rouault <[email protected]> Date: Monday, July 21, 2025 at 10:05 AM To: Michael Smith <[email protected]>, MapServer-dev <[email protected]> Subject: Re: [MapServer-dev] Using OGR geoparquet data in mapserver - no spatial filtering Mike, 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. I haven't tried but I would assume this should work 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. Yes this is "expected". I noticed that the Arrow API of duckdb tends to ingest everything in memory before paging results. Even -- http://www.spatialys.com My software is free, but my time generally not.
_______________________________________________ MapServer-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-dev
