Add city of london to query of borough boundaries

hughkelley · 2024-08-17T21:04:20.309Z

I have this query that pulls the london borough boundaries from OSM.

[out:json][timeout:25];
relation["admin_level"="8"][ ~"^designation.*$"~"_london_borough$"];
(._; way(r); node(w););out meta;

If i add a clause querying the official_name tag of the city of london:

[out:json][timeout:25];
relation["admin_level"="8"][ ~"^designation.*$"~"_london_borough$"];
relation["official_name" = "City and County of the City of London"];
(._; way(r); node(w););out meta;

Instead of all of the boroughs plus city of london, I get only the city of london.

haven’t been able to find where I went wrong yet. any suggestions or solutions appreciated.

ivanbranco · 2024-08-17T21:43:43.009Z

hughkelley:

[out:json][timeout:25];
relation["admin_level"="8"][ ~"^designation.*$"~"_london_borough$"];
relation["official_name" = "City and County of the City of London"];
(._; way(r); node(w););out meta;

Missing brackets, so only the last line is taken into account, try:

[out:json][timeout:25];
(
relation["admin_level"="8"][ ~"^designation.*$"~"_london_borough$"];
relation["official_name" = "City and County of the City of London"];
);
(._; way(r); node(w););out meta;

DaveF · 2024-08-18T12:18:33.377Z

As noted union brackets are required.
Also cleaned up regex. (I, personally, prefer to state the search criteria explicitly, if known, as it speeds search up & makes it clear when referring ot it a year later.)
Unsure of your requirements, but most won’t need to have every node listed, so just used out geom;
Plus: used rel & removed unnecessary quote marks.

(
  rel[admin_level=8][designation~"outer_london_borough|inner_london_borough"];
  rel[official_name="City and County of the City of London"];
);
//(._; way(r); node(w););
out geom;

hughkelley · 2024-08-20T13:36:09.609Z

Thanks, is there an elegant way to remove the handful of nodes that are still included in that query, only including the polygons? I’ve been doing that in post processing so far.

DaveF · 2024-08-20T16:04:10.794Z

Again, unsure of your requirements as you don’t state them, but recursing down to ways returns just the ways (but no relations data)

(
  rel[admin_level=8][designation~"outer_london_borough|inner_london_borough"];
  rel[official_name="City and County of the City of London"];
);
way(r);
out geom;