Overpass has a useful function to query historic data using the data parameter. It also supports a CSV output.
Putting them together, this query will give a CSV of the OSM id and names of banks and atms: http://overpass-turbo.eu/s/sms . This should hopefully match the spreadsheet and be useful for such tasks in future. Theres also a super handy script to update data from a CSV to OSM https://github.com/srividyacb/osm-name-translation. It was mainly created to update translations, but this seems like a good use case as well. We should just get consensus that we want to do this. On Sat, Oct 14, 2017 at 2:43 AM, Warin <61sundow...@gmail.com> wrote: > Revert the name changesets and start again? > > The new changes should then place the original name into old_name and > introduce the new name. > > On 13-Oct-17 11:08 PM, Srihari Thalla wrote: > > Chetan, Is there any possibility to update them via script? > > I am not sure if Overpass API can download based on changes in changesets. > If not, manually going through the spreadsheet would be the obvious choice. > > It would be better to write a script to query the histories of Bank > amenity objects > and import them into JOSM and update. > > Scripting would, of course, need approval from the community! > > Here are my changesets: OSMCha: https://goo.gl/V76HoH > > I bundled all the changes into two changesets. (There are 5 other singled > out changesets too.) > > Manually :: Downloading the changeset -> going through each object history > -> updating each object > > What do you say would be a good idea? > > On Fri 13 Oct, 2017, 17:03 Chetan H A, <chetanh...@gmail.com> wrote: > >> Srihari, makes sense. I wonder how to get back deleted old names and add >> it in old_name tag in one go like you added? >> >> >> >> On Fri, Oct 13, 2017 at 2:37 PM, Srihari Thalla <thallasrih...@gmail.com> >> wrote: >> >>> Hi, >>> >>> Back in May 2017, we have updated the name tags of merged Associate >>> State Banks from their old names (State Bank of xxx) to the new name, >>> "State Bank of India". >>> >>> We have identified and tracked the entries in a spreadsheet [1]. I have >>> updated many entries. >>> However, I forgot to add the old_name tag with the old name (State Bank >>> of xxx) and just updated the name tag to State Bank of India. >>> >>> I think it is good to have the old names in the old_name tag as people >>> might still remember the banks with their old names. >>> >>> Thoughts? >>> >>> Cheers, >>> Srihari >>> >>> [1] - https://docs.google.com/spreadsheets/d/ >>> 17VXVWQVF1rujmQiSQVrXiTOi2sRImh29I2JCGWCKaxc/edit#gid=1622201629 >>> >>> talk-in Discussions >>> [1] - https://lists.openstreetmap.org/pipermail/talk-in/2017- >>> April/002862.html >>> [2] - https://lists.openstreetmap.org/pipermail/talk-in/2017- >>> May/002888.html >>> >>> cc Chetan, Bharata >>> -- >>> Cheers, >>> Srihari >>> >>> _______________________________________________ >>> Talk-in mailing list >>> Talk-in@openstreetmap.org >>> https://lists.openstreetmap.org/listinfo/talk-in >>> >>> >> _______________________________________________ >> Talk-in mailing list >> Talk-in@openstreetmap.org >> https://lists.openstreetmap.org/listinfo/talk-in >> > -- > Cheers, > Srihari > > > _______________________________________________ > Talk-in mailing > listTalk-in@openstreetmap.orghttps://lists.openstreetmap.org/listinfo/talk-in > > > > _______________________________________________ > Talk-in mailing list > Talk-in@openstreetmap.org > https://lists.openstreetmap.org/listinfo/talk-in > >
_______________________________________________ Talk-in mailing list Talk-in@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-in