Canada's 15.8M Addresses

I use Statistics Canada's National Address Register to produce centroids of Canada's major settlements.

Wyvern's Open Satellite Feed

I review Wyvern's 130 GBs of open satellite imagery.

Satellogic's Open Satellite Feed

I review Satellogic's 10 TBs of open satellite imagery.

Overture Maps' Refreshed Global Geospatial Datasets

I look at Overture's latest open and global geospatial dataset update.

Smaller Satellite Images

I look at a newer compression technique for satellite imagery.

Foursquare's 104M Points of Interest

I look at Foursqaure's Open and Global Points of Interest (POI) Dataset.

OpenStreetMap's New Vector Tiles

I look at OpenStreetMap's new sharp, clear and customisable vector tiles.

131M American Buildings

I look at Oak Ridge National Laboratory's AI-generated US Building Dataset.

Land Cover from Satellite Imagery

I look over Overture's 84 GB Land Cover dataset.

Japan's Building Footprints

I look at "Flateau", a Parquet-based Japanese Building Footprint Dataset.

Baltic Maritime Traffic Feed

I look at an open ship tracking feed.

AI on Street View

I look at the results of several models running inference on 10M images taken in cities across the globe.

Capella's Open Satellite Feed

I explore Capella's freely available satellite imagery.

Revisiting Overture's Global Geospatial Datasets

I look over some of the changes made to Overture's datasets over the past six months.

Maxar's HD Global Imagery Basemap

I explore satellite imagery of eleven cities on Maxar's 30cm Global Basemap.

Umbra's Open Satellite Feed

I explore Umbra's freely available satellite imagery.

Global EV Charging Points with Open Charge Map

I walk through Open Charge Map's EV Charging Station dataset.

Aircraft Route Analysis

I explore ways to track individual aircraft found in adsb.lol's flight tracking dataset.

Tokyo Walking Tour Guide

I build a walking tour guide using DuckDB and QGIS.

Extracting OSM Features

I break up an OSM file into 1,087 themed GeoPackage files.

Global Flight Tracking

I explore adsb.lol's flight tracking dataset.

Mapping Estonia with LiDAR

I explore the Estonian Land Board's LiDAR scans dataset.

Natural Earth's Global Geospatial Datasets

I explore Natural Earth's freely available global geospatial datasets.

Maxar's Open Satellite Feed

I explore 1 TB of Maxar's freely available satellite imagery.

Overture's Global Geospatial Datasets

I explore Overture's three global and free-to-use mapping dataset releases.

A Review of Esri's Imagery in Action MOOC

A review of their six-week spatial imagery course.

A Review of Esri's Spatial Data Science MOOC

A review of their six-week course which focuses on their ArcGIS Pro offering.

Enhancing ClickHouse's Geospatial Support

I review Clickgis, a Rust-based extension that adds WKB and GeoJSON support to ClickHouse.

Geospatial Clustering with Uber's H3 in DuckDB & QGIS

I revisit Uber's H3 with a more concise method for producing geospatial clusters.

Popular Airline Passenger Routes Refresh

I've extracted the most popular commercial airline passenger routes from 21 GB of Wikipedia articles.

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.

Linting UK Postcodes

Parsing and linting UK postcodes is ripe with edge cases.