1 hour ago · Life · hide · 0 comments

I mentioned here that, over the years, I’ve linked to 133 places on OpenStreetMap from the space.I set out to find a way to see those all on a map together.I started by pulled out the OpenStreetMap IDs from my blog posts, with a MySQL query:SELECT DISTINCT REGEXP_SUBSTR(field_body_value, '(?<=openstreetmap\.org/node/)[0-9]+') AS node_id FROM node__field_body WHERE field_body_value LIKE '%openstreetmap.org/node/%';I then took that list of IDs and fed it to to Overpass Turbo as a query:[out:json][timeout:25]; // Query all specified OpenStreetMap node IDs node(id: 3635784842, 3685963653, 3993674129, 4035609636, 4219153895, 3964961857, 4354449846, 4368123936, 4486042006, 4212707889, 4602261458, 3693372328, 3968667591, 3958645088, 773014435, 3980190956, 4013819799, 5011996054, 3969063933, 4038653569, 3158817668, 3964875104, 3969441406, 5169624992, 3801233358, 4593194200, 3969441407, 3982594975, 4010401866, 5832876155, 1708994432, 1309334554, 1036621453, 3969441408, 5838493293, 4426845996,…

No comments yet. Log in to reply on the Fediverse. Comments will appear here.