Majority of street lights are mapped as power poles in Haapsalu instead of street lights. Talking of ~1700 lights (OverPass Turbo query, screenshot of below and query below). Also note #4885492. I have checked on-site (where humanly possible) and it really seems like a human error: an incorrect tag was chosen. OR the lighting has changed significantly since 2015, when the edit was made.
[out:json][timeout:25];
// Define your area
{{geocodeArea:Haapsalu}}->.searchArea;
// Find all power=pole nodes in the area
node["power"="pole"](area.searchArea)->.allpoles;
// Find all power=line ways in the area
way["power"="line"](area.searchArea)->.lines;
// Find all poles that are part of power lines
node(w.lines)["power"="pole"]->.connectedpoles;
// Get poles that are NOT connected to power lines
(.allpoles; - .connectedpoles;);
out body;
I think first step could be handling nodes inserted in changeset 34776751 that haven’t been updated yet. I can’t run overpass right now, but i guess first step could take care of like 1500..1600 nodes. Then remaining poles would need more nuanced approach.
If you wish, you could also use advanced techniques with postpass, such as identifying nodes that are not within 15m of street centerline and analyse them more thoroughly.
Speaking of streetlights, in later phases i suggest something should be done about Kristiine’s streetlights. At some point i accidentally mapped some streetlights twice. Tallinn has public dataset of streetlight locations, but idk where it can be accessed.
I agree with @fghj753 that we need to filter by the person who added most of those street lights, and then the automatic retagging is fine. I’ve confirmed with Google Street View that those are indeed lamps (on poles) and not poles. Maybe we could also add support=pole to those.
Some are deleted or changed.