OpenStreetMap 로고 OpenStreetMap

naoliv의 일기

BOUNTY: identify changesets where street names were inserted

naoliv님이 English로 2017년 3월 16일에 게시함.

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.

이메일 아이콘 Bluesky 아이콘 Facebook 아이콘 LinkedIn 아이콘 마스토돈 아이콘 텔레그램 아이콘 X 아이콘

토론

2017년 3월 17일 02:20에 ImreSamu님의 의견

Hi naoliv,

I have started ..

  • What is the “first date” and “last date” you need ?
  • The earliest streetname changeset is from 2007-02-27 osm.org/changeset/225008

I have created a simple sheet for 2017-01. https://docs.google.com/spreadsheets/d/1nYblVf6ZKT7AKoqk729BVyqY6ZDTAhaLPBQuBQMf70o/edit?usp=sharing

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

2017년 3월 17일 03:10에 naoliv님의 의견

@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.

2017년 3월 19일 16:11에 ImreSamu님의 의견

status: [1] https://docs.google.com/spreadsheets/d/1DBCm6AQ7k7VCdy99bnYYpRvrzfvPyppsHDIprTCOdVk/edit?usp=sharing

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

ToDo:

  • 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 ..

Naoliv:

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

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

2017년 3월 21일 19:19에 andygol님의 의견

naoliv could you try http://osmcha.mapbox.com/ ?

osm.org/user/PlaneMad/diary/40722

2017년 3월 23일 07:15에 KVLA-HRO-Mei님의 의견

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

2017년 3월 24일 09:27에 jinalfoflia님의 의견

naoliv I’d suggest the same tool as andygol suggested. Here’s how you can filter changesets using OSMCHA.

osmcha

It also provides a way for you to monitor changesets for a particular bounding box.

2017년 3월 24일 09:32에 SomeoneElse님의 의견

@jinalfoflia - OsmCha, while useful, doesn’t actual do what is requested here, does it - “identify changesets where street names were inserted”?

If it does, perhaps you could explain how?

2017년 3월 24일 09:41에 naoliv님의 의견

@ImreSamu I will send you a message

@andygol @jinalfoflia Yes, I already took a look at http://osmcha.mapbox.com/features?reasons=13
While it gives some related results with what I need, it’s necessary to post-process/scrap the data from it.

2017년 3월 24일 09:44에 jinalfoflia님의 의견

@jinalfoflia - OsmCha, while useful, doesn’t actual do what is requested here, does it - “identify changesets where street names were inserted”?

Yes, at this point the filter identifies all the objects whose name tags are changed, but @SomeoneElse - one can write a compare function https://github.com/mapbox/osm-compare to detect a street with a new name, and then we can flag those changesets in osmcha.

2017년 3월 24일 09:50에 jinalfoflia님의 의견

@andygol @jinalfoflia Yes, I already took a look at http://osmcha.mapbox.com/features?reasons=13 While it gives some related results with what I need, it’s necessary to post-process/scrap the data from it.

@naoliv you can try writing a compare function and that should make it easy for you to filter these changesets/streets.

2017년 3월 24일 09:55에 andygol님의 의견

@naoliv If you need to get data for post-processing just add render_csv=True to osmcha URL http://osmcha.mapbox.com/?reasons=13&render_csv=True
☝️don’t run without adding some extra filters due to big amount of data.

댓글을 남기려면 로그인하세요