2025-11-15 –, Area
This talks presents the "Postpass" service, a database that services OSM data for public querying much like Overpass, but uses PostGIS under the hood. With a few extra characters added to your query, you can have the power of PostGIS at your fingertips from within Overpass Turbo.
Overpass and Overpass Turbo are indispensable tools for OSM contributors - everyone uses them whenever you need to glance at the data and go beyond what's visible on the map. Show me pizza places in Dundee, which playgrounds in Paris have age restrictions - stuff like that can be done quickly with Overpass and doesn't require any data downloading or software installation.
Because such "rapid prototyping" is so easy with Overpass, a lot of community projects small and large have come to depend on Overpass and its two domain-specific query languages as a backbone. Pages upon pages on the community forum and wiki deal with how to solve this or that query with Overpass - and there are cases where a PostGIS query could to the same thing more efficiently or easier than Overpass.
The missing link to allow the same "rapid prototyping" and experimenting with PostGIS that we already see with Overpass is a publicly accessible PostGIS instance. The author has been running exactly that for half a year (Github repos https://github.com/woodpeck/postpass and https://github.com/woodpeck/postpass-ops) and this talk explains how to use it, and what its strengths and weaknesses are.
postgis,database
Frederik is one of the authors of the first book about OSM, he's a frequent guest at SotMs and has co-hosted SotM-EU in Karlsruhe many years ago. He's been on the OSMF board and still is a member of the OSMF Data Working Group. Frederik is one of the directors of Geofabrik but holds this talk in a private capacity.