DuckDB's Spatial Extension

DuckDB can now open 50+ GIS file formats. I use it to help examine the Bing Maps team's AI road detection project.

Geospatial DuckDB

I walk through basic geospatial workflows in DuckDB.

European Route Planning

I build a pan-European Bus Route Planner.

Faster PostgreSQL To BigQuery Transfers

I compare shipping data via CSV and Parquet from PostgreSQL to BigQuery.

Awesome Isochrones

I show how you can create beautiful isochrone maps using Valhalla and QGIS.

Pretty Maps in Python

I show how you can create beautiful maps in Python.

Making Heatmaps

I walk through a GIS toolchain for creating heatmaps.

Deploying 5G Around Trees

I explain how Open5G digs through 3.5 trillion records produced by a deep learning algorithm trained on a massive cluster in Switzerland that was fed imagery of the entire earth from two satellites to decide how to roll out 5G in California.

The Streets of Monaco

I walk through a GIS toolchain for visualising the streets of Monaco and its Formula 1 circuit.

Faster Geospatial Enrichment

I compare latitude and longitude to h3 binning times between PostgreSQL, BigQuery and ClickHouse.