[gdal-dev] DuckDB queries in GDAL/OGR master branch

Scott public at postholer.com
Fri Dec 27 12:30:52 PST 2024


Yes, s3 (httpfs) and of course local (filesystem) both have read/write 
capabilities. httpfs is the reason duckdb works over network.

http(s) is the most ubiquitous internet protocol/data storage. 
geoparquet files on a web server http(s) *will not work*. Drop FGB on 
any http* server and it just works.

Rant over. :)

Thanks again, Mike!

On 12/27/24 10:54, Michael Smith wrote:
> I've used it with geoparquet files from s3, local geopackage files etc. Duckdb works well with geoparquet, for the other formats its using GDAL to read. You certainly can use flatgeobuf.
> 
> Yep, for just bbox queries, no need for alternative sql methods. This is more for doing more data analytics etc.
> 
> Mike
> 
> 



More information about the gdal-dev mailing list