Ibis, DuckDB, and GeoParquet: Making geospatial analytics fast, simple, and Pythonic
summary
Connected an Ibis session to DuckDB, reading Amsterdam OpenStreetMap GeoParquet from S3, filtering 50+ geospatial formats into a geometry column. Create a Shapely point for the Van Gogh museum, Ibis defers to DuckDB to ST_transform/convert coordinates, buffer 1,000 m and 100 m, intersect building polygons and POIs, and return nearby drinking water, toilets and ATMs (one drinking water at ~173 m). All steps execute in the engine and render with the plotting integration.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 0:21Why use DuckDB?
- 2:17Geospatial with DuckDB
- 4:32Geoparquet advantages
- 5:57Introduction to Ibis
- 7:35Live demo and geospatial SQL
- 13:49Visualization and wrapping up
- 15:35Questions and answers
related talks
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
30mGeospatial analysis made easy with PostGIS and Geoalchemy
14mMosaic: A Framework for Geospatial Analytics at Scale
28mAnalyze data easily with duckdb - and the implications on data architectures
30mMaps, Maps, Maps!
22mTake your Business to a New Geography
31mUnpacking the geospatial engineering toolbox – an overview of data science techniques for spatial da
26mInteractive Mapmaking with Python