Just a note for others that I've found for querying parquet files with GDAL 3.12.2 and libarrow 23 that USE_PARQUET_GEO_TYPES=yes, and in my case, since geometries are in 4326, using EDGES=spherical, that the performance has doubled.
Query time with spatial filter: GDAL Geom as wkb: time: 0:01:37.471977 GDAL Geom as geo: time: 0:00:47.025982 DuckDB geom as wkb: time: 0:00:15.171584 DuckDB geom as geo: time: 0:00:07.801056 -- Michael Smith RSGIS Center – ERDC CRREL NH US Army Corps _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
