vgi-mvt extension for DuckDB enables vector tile querying

The author explains how the vgi-mvt extension for DuckDB allows users to decode and query Mapbox Vector Tiles and PMTiles files directly within the database. The extension handles feature deduplication across tile edges and enables efficient spatial queries, such as filtering a worldwide places dataset by bounding box to read only a fraction of the file. Additionally, the worker supports writing datasets back into PMTiles format using a single COPY statement. Open article →