Post #1009790
2025-06-05 14:36 UTC
If you want to find the longest `opening_hours` tag in #OpenStreetMap, you can use this #Postpass SQL query!
SELECT tags, geom
FROM postpass_pointlinepolygon
ORDER BY length(tags->>'opening_hours') desc nulls last
limit 1
That's it. #SQL is really powerful. 🙂
https://overpass-turbo.eu/?Q=%7B%7Bdata%3Asql%2Cserver%3Dhttps%3A%2F%2Fpostpass.geofabrik.de%2Fapi%2F0.2%2F%7D%7D%0A%0ASELECT%20tags%2C%20geom%0AFROM%20postpass_pointlinepolygon%0AORDER%20BY%20length%28tags-%3E%3E%27opening_hours%27%29%20desc%20nulls%20last%0Alimit%201
Replies (0)
No replies.