BOUNTY: identify changesets where street names were inserted

Posted by naoliv on 16 March 2017 in English (English)

I will pay one cake, beverage or even send a T-shirt if somebody teach/give me code to identify changesets where street names were inserted.

ie, there was a lot of already traced highways and then somebody modified them, inserting names.

What I would like to do:

  1. identify every changeset where street names were inserted in a specific area (Brazil, for example); sorting by the number of affected ways in each changeset would be nice
  2. filter by a specific username
  3. filter where street names were inserted and some specific value is not present in changeset's source, source:name or imagery_used

I can host a postgis database with the data if needed (I guess that some SQL black magic will solve this)

Cake, beverage, T-shirt and US$ 100 via paypall if somebody gives me all these 3 features.

Comment from ImreSamu on 17 March 2017 at 02:20

Hi naoliv,

I have started ..

I have created a simple sheet for 2017-01.

maybe the 1.,2. requirement is not hard , [ for a v3. I need to add the changeset values )

Hide this comment

Comment from naoliv on 17 March 2017 at 03:10

@ImreSamu I will need it since the beggining :-)

It also needs to be continuously updated (so some code/script/etc will be necessary here).
Or at least be able to generate the data on demand (for a specific user, or date range, if possible).

And it seems to be going the right way here.

Hide this comment

Comment from ImreSamu on 19 March 2017 at 16:11

status: [1]

Now :

  • the input:
  • Now I am using "osmium tool" + minimal python code.
  • the result can be load to Postgres / Sqlite / google sheet / Excel / Libreoffice
    • see Goole Spreedsheet link [1]
  • The current algorithm:
    • The actual version has key:highway + key:name and the previous version has not key:name


  • Need some formating / testing / tunning
  • Need recreating brazil.osh.pbf ( for up to date )
  • "filter where street names were inserted" - this is the (nearest) city or region name?
    • this is not so easy .. need some geocoding + database :(
  • Check alternative solutions ..


  • What is your technical background ( python ? sql? linux scripting? )

( next status report : maybe end of the next week )

Hide this comment

Comment from KVLA-HRO-Mei on 23 March 2017 at 07:15

Same here, a tool for dealing with new / altered / removed streetnames would be pretty useful for QA :)

Hide this comment

Leave a comment

Parsed with Markdown

  • Headings

    # Heading
    ## Subheading

  • Unordered list

    * First item
    * Second item

  • Ordered list

    1. First item
    2. Second item

  • Link

  • Image

    ![Alt text](URL)

Login to leave a comment