@amapanda oh! tell me more about #postpass !!!

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

Postpass – a public OSM PostGIS instance

https://community.openstreetmap.org/t/postpass-a-public-osm-postgis-instance/128649
#OpenStreetMap #OSM #postpass #gis