Re: [OSM-talk] Duplicate Buildings
Le 11.03.23 à 13:35, Frederik Ramm a écrit : it would be a good idea to try and find out what the root cause of the problem is - bad software, bad imports, bad instructions? I have already encountered 3 cases: - as Warin says: create something in josm, save it as faile, send to osm, don't save after send, close and reopen the file, send to osm - imports (cadastre) done (in France in a "legal" way, in Switzerland, Fribourg done with in an undocumented/incompatible source, repetitive issue with the same guy again) - rare problems during a network outage while sending. The only thing that remains incomprehensible is when this happens iD several days apart example with the first one on your list: https://www.openstreetmap.org/way/1122282039 sent with iD 3 months ago. duplicate of a building sent 5 years ago with josm https://www.openstreetmap.org/way/553715102 the HOT validator didn't see anything, neither did the task validators, but that's another problem. I'm willing to look at some examples of the quadruple list but in this format, it will be difficult to work on it with several people as it is impossible to mark elements as processed Translated with www.DeepL.com/Translator (free version) ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Duplicate Buildings
Many thanks for putting some numbers on this. Warin's comment would suggest it may also be more than just buildings that are involved. For buildings the total number as a percentage is small unfortunately they tend to cluster so are more of a problem than if they were more spread out. John On Sat, Mar 11, 2023, 07:40 Frederik Ramm wrote: > Hi, > > I think an automatic fix of the problem is possible, however it would be > a good idea to try and find out what the root cause of the problem is - > bad software, bad imports, bad instructions? > > To get an idea of how big the issue is, I did this on a standard > rendering database: > > create table buildings as (select way,osm_id from planet_osm_polygon > where building is not null) > > select a.osm_id, b.osm_id into duplicates from buildings a, buildings b > where a.osm_id < b.osm_id and a.way ~= b.way and st_equals(a.way,b.way); > > This took a few days - probably it could have been done more efficiently > - and resulted in a list of about 70k buldings world-wide that are exact > duplicates (geoetry-wise) of other buildings. The list is here: > > http://www.remote.org/frederik/tmp/duplicatebuildings.csv > > Some buildings are in OSM three or four times (contained i nthe above in > the form of "a is duplicate of b, b is duplicate of c") but I've > extracted them in extra files: > http://www.remote.org/frederik/tmp/triplcatebuildings.csv and > http://www.remote.org/frederik/tmp/quadruplicatebuildings.csv) > > I don't have the time to analyse the situation in more detail at present > so if anyone wants to take the above lists as a basis for deeper > analysis... > > Cheers > Frederik > > -- > Frederik Ramm ## eMail frede...@remote.org ## N49°00'09" E008°23'33" > > ___ > talk mailing list > talk@openstreetmap.org > https://lists.openstreetmap.org/listinfo/talk > ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[OSM-talk-fr] hebdoOSM Nº 659 2023-02-28-2023-03-06
Bonjour, Le résumé hebdomadaire n° 659 de l'actualité OpenStreetMap vient de paraître *en français*. Un condensé à retrouver sur : https://www.weeklyosm.eu/fr/archives/16366/ Bonne lecture ! Saviez-vous que vous pouvez vous aussi soumettre des messages pour la note hebdomadaire sans être membre ? Il vous suffit de vous connecter sur https://osmbc.openstreetmap.de/login avec votre compte OSM. Pour en savoir plus sur la rédaction d'un article, cliquez ici: https://www.weeklyosm.eu/fr/this-news-should-be-in-weeklyosm hebdoOSM ? Qui : https://wiki.openstreetmap.org/wiki/WeeklyOSM#Available_Languages Où : https://umap.openstreetmap.fr/en/map/weeklyosm-is-currently-produced-in_56718#2/8.6/108.3 ___ Talk-fr mailing list Talk-fr@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-fr
[Talk-tr] weeklyOSM #659 2023-02-28-2023-03-06
OSM ile ilgili haberlerin derlendiği ve OpenStreetMap dünyasındaki pek çok gelişmelerin paylaşıldığı haftalık bülten, 659. bölümüyle çevrimiçi ve Türkçe olarak erişilebilir durumda: https://www.weeklyosm.eu/tr/archives/16366/ İyi okumalar! weeklyOSM'e sizin de ekleme yapabileceğinizi biliyor muydunuz? Sadece https://osmbc.openstreetmap.de/login adresine OSM hesabınızla giriş yapın. Yeni bir haber yüklemek için yapmanız gerekenleri buradan öğrenebilirsiniz: https://www.weeklyosm.eu/this-news-should-be-in-weeklyosm weeklyOSM? Kim?: https://wiki.openstreetmap.org/wiki/WeeklyOSM#Available_Languages Nerede?: https://umap.openstreetmap.fr/en/map/weeklyosm-is-currently-produced-in_56718#2/8.6/108.3 ___ Talk-tr mailing list Talk-tr@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-tr
[OSM-talk] weeklyOSM #659 2023-02-28-2023-03-06
The weekly round-up of OSM news, issue # 659, is now available online in English, giving as always a summary of a lot of things happening in the openstreetmap world: https://www.weeklyosm.eu/archives/16366 Enjoy! Did you know that you can also submit messages for the weeklyOSM? Just log in to https://osmbc.openstreetmap.de/login with your OSM account. Read more about how to write a post here: https://www.weeklyosm.eu/this-news-should-be-in-weeklyosm weeklyOSM? who: https://wiki.openstreetmap.org/wiki/WeeklyOSM#Available_Languages where?: https://umap.openstreetmap.fr/en/map/weeklyosm-is-currently-produced-in_56718#2/8.6/108.3 ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[talk-ph] weeklyOSM #659 2023-02-28-2023-03-06
The weekly round-up of OSM news, issue # 659, is now available online in English, giving as always a summary of a lot of things happening in the openstreetmap world: https://www.weeklyosm.eu/archives/16366 Enjoy! Did you know that you can also submit messages for the weeklyOSM? Just log in to https://osmbc.openstreetmap.de/login with your OSM account. Read more about how to write a post here: https://www.weeklyosm.eu/this-news-should-be-in-weeklyosm weeklyOSM? who: https://wiki.openstreetmap.org/wiki/WeeklyOSM#Available_Languages where?: https://umap.openstreetmap.fr/en/map/weeklyosm-is-currently-produced-in_56718#2/8.6/108.3 ___ talk-ph mailing list talk-ph@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-ph
Re: [OSM-talk] Duplicate Buildings
On 11/3/23 23:35, Frederik Ramm wrote: Hi, I think an automatic fix of the problem is possible, however it would be a good idea to try and find out what the root cause of the problem is - bad software, bad imports, bad instructions? I have duplicated an entry the following way in JOSM; save the data locally download the data to OSM exit from JOSM .. without a save locally after the upload. Later, open the saved file in JOSM, possibly make further changes/addition and upload the date to OSM... -- The locally saved file data indicates that the data has not been uploaded to OSM (even though it has) .. thus the second upload will duplicates all the changes made in the file.. I did catch this some time ago (years?) and have been careful since. But it is a way of doing it.. I think JOSM now has a warning for this? ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk