One SQL statement to create a web map of Pizza places

By Stephan in General on

The post explores an SQL query using DuckDB and OvertureMaps data to extract, filter, and visualize pizza places in Switzerland. All these steps can be done in one line, and the generated map of Swiss pizza places can be viewed immediately using PMTiles.

Swiss Rooftop Explorer - or how to serve a Low Cost Geo App with no maintenance

By Stephan in Feature on

The Swiss Rooftop Explorer is a cloud-native web app that retrieves Swiss building roof heights without a GIS server. Using PMTiles, Geoparquet, and DuckDB-WASM, it enables fast, low-maintenance geospatial queries. This post explores the data pipeline and its benefits of cloud-optimized formats, and how static files can replace traditional GIS infrastructure.