• Storing H3 Efficiently: BIGINT vs String, Dictionary Encoding, and Parquet Compression Tips

  Dec 18, 2025

• H3 + Admin Boundaries: Fast Province/Country Summaries with Precomputed Lookup Tables

  Dec 10, 2025

• H3 Resolution Guide for Web Maps: Choosing Resolution by Zoom and Understanding Performance Tradeoffs

  Dec 4, 2025

• Spatial Analysis with DuckDB: Performance at Scale — Partitioning, BBox Prefilters, Lookup Tables, and Publishing

  Nov 27, 2025

• Spatial Analysis with DuckDB: Spatial Extension Basics, Geometry, CRS, and “How DuckDB Thinks”

  Nov 19, 2025

• SQL Patterns for Geospatial Analytics in DuckDB: Clip, Intersect, Group, Quantiles, Time Windows

  Nov 12, 2025

• GeoParquet 101: Geometry Storage, Bounding Boxes, Metadata, and Interoperability

  Nov 5, 2025

• DuckDB Spatial as an ETL Engine: GeoPackage/Shapefile → Parquet/GeoParquet

  Oct 27, 2025

• Global Drought Map is Live: Serverless, Cloud-Native Drought Analytics with H3 + Parquet + DuckDB WASM

  Oct 17, 2025

• Running Python in the Browser with Pyodide: Building a Modular SPI Calculator

  Oct 6, 2025

• Hello World — Starting to Write Again

  Oct 3, 2025