<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1513007832333_58639">Hi Michal</div><div id="yui_3_16_0_ym19_1_1513007832333_58689"><br></div><div id="yui_3_16_0_ym19_1_1513007832333_58690">See this overpass script that extract all nodes with any tag that has been modified since a specific date. I dont think that we can filter action=delete.</div><div id="yui_3_16_0_ym19_1_1513007832333_58691"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513007832333_58682"><a href="http://overpass-turbo.eu/s/tKD" class="" id="yui_3_16_0_ym19_1_1513007832333_58681">http://overpass-turbo.eu/s/tKD</a><br></div><div id="yui_3_16_0_ym19_1_1513007832333_58692"><br></div><div id="yui_3_16_0_ym19_1_1513007832333_58707" dir="ltr">regard<br></div><div id="yui_3_16_0_ym19_1_1513007832333_58638"><span></span><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;"></span><br><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;"></span></div><div class="signature" id="yui_3_16_0_ym19_1_1513007832333_58636"><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;" id="yui_3_16_0_ym19_1_1513007832333_58753"><font id="yui_3_16_0_ym19_1_1513007832333_58752" face="garamond, new york, times, serif">Pierre </font><br></span></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1513007832333_58635"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1513007832333_58624" style="display: block;"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 13px;" id="yui_3_16_0_ym19_1_1513007832333_58623"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, linéale; font-size: 16px;" id="yui_3_16_0_ym19_1_1513007832333_58622"> <div dir="ltr" id="yui_3_16_0_ym19_1_1513007832333_58621"> <font id="yui_3_16_0_ym19_1_1513007832333_58620" size="2" face="Arial"> <hr id="yui_3_16_0_ym19_1_1513007832333_58634" size="1"> <b><span style="font-weight:bold;">De :</span></b> Michał Brzozowski <www.haxor@gmail.com><br> <b><span style="font-weight: bold;">À :</span></b> dev@openstreetmap.org <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> lundi 11 décembre 2017 19h13<br> <b><span style="font-weight: bold;">Objet :</span></b> [OSM-dev] Getting POI nodes deleted by user<br> </font> </div> <div class="y_msg_container"><br><div id="yiv6916770297"><div dir="ltr"><div>Hi all, so I have a problem with user rowers2 who has been tracing buildings (with Tracer2) quite carelessly. After doing this (which he does in quite high volume) he then merges address nodes with building outlines. E.g. <a rel="nofollow" target="_blank" href="https://nrenner.github.io/achavi/?changeset=53993885">https://nrenner.github.io/achavi/?changeset=53993885</a><br></div><div>JOSM has an option to merge (by copying tags and deleting the node) address nodes into building outlines. However, it can also merge POI whenever they have address tags, which isn't always appropriate, e.g. for ATMs or anything that doesn't occupy the whole building (quite easy to tell by common sense, but not really automatically).</div><div><br></div><div>I stumbled into this ATM shenanigans purely by chance in PostGIS when searching for nodes inside areas which both have same amenity value. But this pertains also to other POI like tourism=information.<br></div><div><br></div><div>How can I, having a full history dump for an area, find all POI nodes (having shop/amenity/office...) that were deleted by user rowers2?</div><div><br></div><div>Or, which DB schema can deal with history reasonably?</div><div><br></div><div>Michał<br></div></div></div>_______________________________________________<br>dev mailing list<br><a ymailto="mailto:dev@openstreetmap.org" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br><a href="https://lists.openstreetmap.org/listinfo/dev" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br><br><br></div> </div> </div> </div></div></body></html>