Last week, Switzerland’s Birchgletscher collapsed and caused a major rock avalanches, altering the landscape and burying the village of Blatten. With the data of the federal Rapid Mapping service and the help of individual experts, a first open post-event elevation model was made available. I used the model to create pre- and post-event visualizations and prints at a local scale.
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.
Introducing Topoprint.ch, a platform for creating personalized, 3D-printable topographic models of any location in Switzerland, accessible through social media bots. This post explains the "what," the "why," and a bit of the "how.".
