Notebooks using DuckDB with the H3 Extension and Overture Maps Data

The latest DuckDB 1.1.0 now reads geoparquet natively. So that means all of these queries with ST_GeomFromWKB will break

• Now all are updated.

In tlc_overture_lonboard.ipynb and tlc_overture_kepler.ipynb I demonstrate how you can generate H3 from taxi data and merge it with Overture Buildings with those respective mapping libraries.

In montpelier_water_buildings.ipynb, I visualize the volume of buildings near water.

In egypt_building_density.ipynb I look at building density.