#postpass — Public Fediverse posts

@stevenfeldman
🕶️🙂 Don't thank me.
😎 Thank #Postpass!

@foxy I want to add something to #postpass to do some server side caching for this.

Today's #Postpass quickie: The same address points (same number & street) but too close together. Possible mapping mistakes?

https://overpass-turbo.eu/s/2pEJ
#openStreetMap

# Wochenrückblick, Ausgabe 139 (2026-17)

Themen:

🗺️ Bikerouter Route Manager verfügbar ✨

🗺️ Eigene Overpass-API-Instanz für Bikerouter oder lieber postpass?

🧭 Navigation im Blog aufgeräumt

✈️ Neuer Mastodon-Account für Flugsimulator-Screenshots

🔊 In dieser Woche gehört: Sisterhood 9, Katja Kilig, Ida Scheppert

#Wochenrückblick #Bikerouter #RouteManager #OverpassAPI #Overpass #OpenStreetMap #postpass #Blog #FlightSim #Techno

https://www.marcusjaschen.de/blog/2026/2026-17/

# Wochenrückblick, Ausgabe 139 (2026-17)

Themen:

🗺️ Bikerouter Route Manager verfügbar ✨

🗺️ Eigene Overpass-API-Instanz für Bikerouter oder lieber postpass?

🧭 Navigation im Blog aufgeräumt

✈️ Neuer Mastodon-Account für Flugsimulator-Screenshots

🔊 In dieser Woche gehört: Sisterhood 9, Katja Kilig, Ida Scheppert

#Wochenrückblick #Bikerouter #RouteManager #OverpassAPI #Overpass #OpenStreetMap #postpass #Blog #FlightSim #Techno

https://www.marcusjaschen.de/blog/2026/2026-17/

# Wochenrückblick, Ausgabe 139 (2026-17)

Themen:

🗺️ Bikerouter Route Manager verfügbar ✨

🗺️ Eigene Overpass-API-Instanz für Bikerouter oder lieber postpass?

🧭 Navigation im Blog aufgeräumt

✈️ Neuer Mastodon-Account für Flugsimulator-Screenshots

🔊 In dieser Woche gehört: Sisterhood 9, Katja Kilig, Ida Scheppert

#Wochenrückblick #Bikerouter #RouteManager #OverpassAPI #Overpass #OpenStreetMap #postpass #Blog #FlightSim #Techno

https://www.marcusjaschen.de/blog/2026/2026-17/

# Wochenrückblick, Ausgabe 139 (2026-17)

Themen:

🗺️ Bikerouter Route Manager verfügbar ✨

🗺️ Eigene Overpass-API-Instanz für Bikerouter oder lieber postpass?

🧭 Navigation im Blog aufgeräumt

✈️ Neuer Mastodon-Account für Flugsimulator-Screenshots

🔊 In dieser Woche gehört: Sisterhood 9, Katja Kilig, Ida Scheppert

#Wochenrückblick #Bikerouter #RouteManager #OverpassAPI #Overpass #OpenStreetMap #postpass #Blog #FlightSim #Techno

https://www.marcusjaschen.de/blog/2026/2026-17/

# Wochenrückblick, Ausgabe 139 (2026-17)

Themen:

🗺️ Bikerouter Route Manager verfügbar ✨

🗺️ Eigene Overpass-API-Instanz für Bikerouter oder lieber postpass?

🧭 Navigation im Blog aufgeräumt

✈️ Neuer Mastodon-Account für Flugsimulator-Screenshots

🔊 In dieser Woche gehört: Sisterhood 9, Katja Kilig, Ida Scheppert

#Wochenrückblick #Bikerouter #RouteManager #OverpassAPI #Overpass #OpenStreetMap #postpass #Blog #FlightSim #Techno

https://www.marcusjaschen.de/blog/2026/2026-17/

@queerthoughts you can use #postpass ! It's minutely updated and global, but it's in SQL not overpass language!

RE: https://en.osm.town/@MapAmore/116254253660987536

More praise for #Postpass, the modern replacement to #Overpass

RE: https://en.osm.town/@MapAmore/116254253660987536

More praise for #Postpass, the modern replacement to #Overpass

RE: https://en.osm.town/@MapAmore/116254253660987536

More praise for #Postpass, the modern replacement to #Overpass

RE: https://en.osm.town/@MapAmore/116254253660987536

More praise for #Postpass, the modern replacement to #Overpass

RE: https://en.osm.town/@MapAmore/116254253660987536

More praise for #Postpass, the modern replacement to #Overpass

@SonstHarmlos #PostPass macht's möglich!

https://overpass-turbo.eu/s/2m35

I'm a proud member of the #Postpass Evangelism Strike Force!

RE: https://en.osm.town/@watmildon/115999393169314773

Also, because we're truly living in the future, this uses Postpass from @geofabrik to pull data each night.

TV ad voice: Overpass troubles have you pulling your hair out? Postpass may be right for you!

#postpass

@mvexel @dschep you can use it with #postpass BTW!

@mvexel have you tried #Postpass? It's a great alternative, and pure SQL!

@watmildon I'll have to look in Jan when I'm at a computer.
One tip, try add a && geom bbox filtering, in addition to the St_Intersects. Yes I know #postgis is supposed to do it, but IME it can be faster
But I've wanted to add a server side cache for #Postpass for a while. But hasn't been done yet.

RE: https://en.osm.town/@watmildon/115793587184062200

The Global view for MascotMap can now run against Postpass. It's crazy fast. Still working out why subregion queries are crazy slow. Computers.. amirite?

You can try it yourself!

https://overpass-ultra.us/#map&query=url:https://raw.githubusercontent.com/watmildon/HighSchoolMascotMap/refs/heads/main/HSMascotMap_Postpass.ultra

#MascotMap #OpenStreetMap #Postpass

RE: https://en.osm.town/@watmildon/115793587184062200

The Global view for MascotMap can now run against Postpass. It's crazy fast. Still working out why subregion queries are crazy slow. Computers.. amirite?

You can try it yourself!

https://overpass-ultra.us/#map&query=url:https://raw.githubusercontent.com/watmildon/HighSchoolMascotMap/refs/heads/main/HSMascotMap_Postpass.ultra

#MascotMap #OpenStreetMap #Postpass

RE: https://en.osm.town/@watmildon/115793587184062200

The Global view for MascotMap can now run against Postpass. It's crazy fast. Still working out why subregion queries are crazy slow. Computers.. amirite?

You can try it yourself!

https://overpass-ultra.us/#map&query=url:https://raw.githubusercontent.com/watmildon/HighSchoolMascotMap/refs/heads/main/HSMascotMap_Postpass.ultra

#MascotMap #OpenStreetMap #Postpass

RE: https://en.osm.town/@watmildon/115793587184062200

The Global view for MascotMap can now run against Postpass. It's crazy fast. Still working out why subregion queries are crazy slow. Computers.. amirite?

You can try it yourself!

https://overpass-ultra.us/#map&query=url:https://raw.githubusercontent.com/watmildon/HighSchoolMascotMap/refs/heads/main/HSMascotMap_Postpass.ultra

#MascotMap #OpenStreetMap #Postpass

RE: https://en.osm.town/@watmildon/115793587184062200

The Global view for MascotMap can now run against Postpass. It's crazy fast. Still working out why subregion queries are crazy slow. Computers.. amirite?

You can try it yourself!

https://overpass-ultra.us/#map&query=url:https://raw.githubusercontent.com/watmildon/HighSchoolMascotMap/refs/heads/main/HSMascotMap_Postpass.ultra

#MascotMap #OpenStreetMap #Postpass

I am trying to work out how to get MascotMap pulling from Postpass. My current best result is that Postpass takes twice as long as Overpass to return the same data. Hopefully I can nerdsnipe someone into showing me a more efficient query.

Fortunately, I am an absolute noob so it's probably easy to do something better!

https://github.com/watmildon/HighSchoolMascotMap/issues/41

#OpenStreetMap #MascotMap #Postpass #Overpass

I am trying to work out how to get MascotMap pulling from Postpass. My current best result is that Postpass takes twice as long as Overpass to return the same data. Hopefully I can nerdsnipe someone into showing me a more efficient query.

Fortunately, I am an absolute noob so it's probably easy to do something better!

https://github.com/watmildon/HighSchoolMascotMap/issues/41

#OpenStreetMap #MascotMap #Postpass #Overpass

I am trying to work out how to get MascotMap pulling from Postpass. My current best result is that Postpass takes twice as long as Overpass to return the same data. Hopefully I can nerdsnipe someone into showing me a more efficient query.

Fortunately, I am an absolute noob so it's probably easy to do something better!

https://github.com/watmildon/HighSchoolMascotMap/issues/41

#OpenStreetMap #MascotMap #Postpass #Overpass

I am trying to work out how to get MascotMap pulling from Postpass. My current best result is that Postpass takes twice as long as Overpass to return the same data. Hopefully I can nerdsnipe someone into showing me a more efficient query.

Fortunately, I am an absolute noob so it's probably easy to do something better!

https://github.com/watmildon/HighSchoolMascotMap/issues/41

#OpenStreetMap #MascotMap #Postpass #Overpass

I am trying to work out how to get MascotMap pulling from Postpass. My current best result is that Postpass takes twice as long as Overpass to return the same data. Hopefully I can nerdsnipe someone into showing me a more efficient query.

Fortunately, I am an absolute noob so it's probably easy to do something better!

https://github.com/watmildon/HighSchoolMascotMap/issues/41

#OpenStreetMap #MascotMap #Postpass #Overpass

Today's work lunch conversation was about duplicate place names. So naturally I looked at #OpenStreetMap to see how common it was (#postpass to the rescue!)

OK this is much more common than I thought. (This is all `place=*` excl `p=locality` & `=isolate_dwelling`)

[query](https://overpass-ultra.us/#m=3.30/55.6640/9.6984&q=LQhQBcE8AcFMC4AE0D2Bnc0CGa2g5ADYKiKKFaSwBOa8pZiwiUcSAxgJbXvEOOIuPYsGpYAJpwCudRAFZ+jIb1jAM1FAGtVAd07jwACyQAGAHQBORWWUj1W1exSEU1JACMK7TdcHcVwE4ubr5kzABEnAB24DSoFLHAFO7hoUyIANrhhNGwWNThALppzFkA5rDg4QA0iOFRUgC2APo6zUacaM1RWI2wRSWIAEyD4dSw4qkCAswAjCYmo2XjsFGpIMCgoHpGoNBesGiIOIgAsgCCACoAogBKAJLnADL3AFrXACKIABQAytdPa4AYUuLCwZTQwAAfFCAOQ9PqwxAI2C1cDgyEw2H7LDsWBInF42oVFCNRAAMw0ZNQGGwuGaqGi4GQiB0hhosEQJLJADIeWRfpdmqcsNprlEAG6wFxwb7AIYANlqAGZlbU5ENagB2TWIAAsysVAEpEOcAHJfbmIPmIQXC0WwcVSmWwb4AbzdOjQqwAvj7qgbjaaLWCIQB+bEHJHmr7o8Pw3r445RcShzFwwlJs0AeVB9zNP1hLnYWByUFhtVhnWcWFi4ma4h00pyUTKsKNRq21UzXTaTikMVNv0QjVrNE4pc4AC8Jj9vcR2MyUbV+zFvgAqE0oKXUH7YajgTiHlBRRDuSDIxMmhotNodLrL5AHYmwUkUqlP3GHTugariKRwN0iZHOcw6jrE1ATjkM6pt886wIuiDru+b49q0zSrsybIcsiTTofeQF9IgUKILMP7wYhyGUm+-6ASiRyuOINBnheN74YYnSEZyODsKAQA)

@feuerrot @karotte

Aber dank @woodpeck's Postpass kann man PostGIS fertig mit OSM Daten einfach online in Overpass {Turbo,Ultra} oder mit curl verwenden, siehe https://github.com/woodpeck/postpass-ops/blob/main/README.md.
PostGIS ist PostgreSQL mit Extras für Geodaten und hat u.a. levenshtein().

Der Rest ist trivial und wird dem Leser überlassen!

#OSM #Postpass #PostGIS

@hareldan If it's not a lot of data, and geojson is OK, you could download it from #postpass?

@geofabrik

oh boy. with #postpass & #OverpassUltra I can generate heatmaps directly from OSM data.

Here's a heatmap of `place` tag's with this query

```
---
type: postpass
style:
layers:
- type: heatmap
heatmap-radius: 20
heatmap-weight: ["get", "count"]
heatmap-intensity: 0.0001
---

select count(*), geom from (
select ST_SnapToGrid(geom, 0.1) as geom from postpass_point where tags?'place' AND geom && ST_MakeEnvelope(-26, 33, 52, 72, 4326)) t group by geom
```
#OpenStreetMap

Number of AEDs per million buildings in #Italy for each Italian region.

made with #postpass

Number of Fire Hydrants in #Italy in #OpenStreetMap per million buildings for each `admin_level=4`

made with #postpass

@yetzt A #postpass query to find “vegan” named, w/o `diet:vegan`, and excluding anything in Norway is: https://overpass-turbo.eu/s/2gnP
```sql
{{data:sql,server=https://postpass.geofabrik.de/api/0.2/}}
select * from postpass_pointlinepolygon v
where tags?'diet:vegan' AND tags->>'name' ILIKE '%vegan%'

and not (ST_Intersects(geom, (select geom from postpass_polygon where tags->>'boundary' = 'administrative' and tags->>'ISO3166-1' = 'NO' AND geom && st_makepoint(7.64,55.44) limit 1)))
```

@yetzt A simple #Postpass version of your query is here: https://overpass-turbo.eu/s/2gnJ
```sql
{{data:sql,server=https://postpass.geofabrik.de/api/0.2/}}

select * from postpass_pointlinepolygon v
where tags?'diet:vegan' AND tags->>'name' ILIKE '%vegan%'
```

I am still excited that I am able to generate hexagons in #postgresql in the Irish Grid (srs 29903) projection. #Postpass just got more useful for me!

https://wiki.openstreetmap.org/wiki/User:Am%E1%B5%83%E1%B5%96anda#Postpass_queries

I wondered how many roads, in each county of Ireland, are named?

Then I used #Postpass to tell me how many roads there are in each county (& how many km of roads for each county km²), and how many km of roads are _named_.

I can understand why NI is highly ranked, but WTF is going on in Cavan? Do we have some really good mappers there or something?

#Ireland #OpenStreetMap

RE: https://cupoftea.social/@moof/115521240053010548

English towns without a Wetherspoons, you say?
*cracks knuckles*
There are *62* towns/cities in England without a Wetherspoons!

Here's the big SQL query: <https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2>

#OpenStreetMap #postpass #sql #england #wetherspoons #pub #MapTheWinchester #TheWorldsEnd

RE: https://cupoftea.social/@moof/115521240053010548

English towns without a Wetherspoons, you say?
*cracks knuckles*
There are *62* towns/cities in England without a Wetherspoons!

Here's the big SQL query: <https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2>

#OpenStreetMap #postpass #sql #england #wetherspoons #pub #MapTheWinchester #TheWorldsEnd

RE: https://cupoftea.social/@moof/115521240053010548

English towns without a Wetherspoons, you say?
*cracks knuckles*
There are *62* towns/cities in England without a Wetherspoons!

Here's the big SQL query: <https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2>

#OpenStreetMap #postpass #sql #england #wetherspoons #pub #MapTheWinchester #TheWorldsEnd

RE: https://cupoftea.social/@moof/115521240053010548

English towns without a Wetherspoons, you say?
*cracks knuckles*
There are *62* towns/cities in England without a Wetherspoons!

Here's the big SQL query: <https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2>

#OpenStreetMap #postpass #sql #england #wetherspoons #pub #MapTheWinchester #TheWorldsEnd

RE: https://cupoftea.social/@moof/115521240053010548

English towns without a Wetherspoons, you say?
*cracks knuckles*
There are *62* towns/cities in England without a Wetherspoons!

Here's the big SQL query: <https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2>

#OpenStreetMap #postpass #sql #england #wetherspoons #pub #MapTheWinchester #TheWorldsEnd

So, ich habe gerade mal die #Postpass Datenbank bezüglich des tödlichen Unfalls von Frau #Dahlmeier befragt.
In #Openstreetmap gibt es vier Gipfel mit der Bezeichnung "Laila Peak". Zwei davon sind im Karakorum Gebirge. Ich vermute, der gesuchte Gipfel ist der östlichere der beiden:
https://overpass-turbo.eu/s/294X

So, ich habe gerade mal die #Postpass Datenbank bezüglich des tödlichen Unfalls von Frau #Dahlmeier befragt.
In #Openstreetmap gibt es vier Gipfel mit der Bezeichnung "Laila Peak". Zwei davon sind im Karakorum Gebirge. Ich vermute, der gesuchte Gipfel ist der östlichere der beiden:
https://overpass-turbo.eu/s/294X

So, ich habe gerade mal die #Postpass Datenbank bezüglich des tödlichen Unfalls von Frau #Dahlmeier befragt.
In #Openstreetmap gibt es vier Gipfel mit der Bezeichnung "Laila Peak". Zwei davon sind im Karakorum Gebirge. Ich vermute, der gesuchte Gipfel ist der östlichere der beiden:
https://overpass-turbo.eu/s/294X

So, ich habe gerade mal die #Postpass Datenbank bezüglich des tödlichen Unfalls von Frau #Dahlmeier befragt.
In #Openstreetmap gibt es vier Gipfel mit der Bezeichnung "Laila Peak". Zwei davon sind im Karakorum Gebirge. Ich vermute, der gesuchte Gipfel ist der östlichere der beiden:
https://overpass-turbo.eu/s/294X

So, ich habe gerade mal die #Postpass Datenbank bezüglich des tödlichen Unfalls von Frau #Dahlmeier befragt.
In #Openstreetmap gibt es vier Gipfel mit der Bezeichnung "Laila Peak". Zwei davon sind im Karakorum Gebirge. Ich vermute, der gesuchte Gipfel ist der östlichere der beiden:
https://overpass-turbo.eu/s/293d