Add a Note in OSM … Stats & Personal Profiles
by Pascal Neis - Published: May 5th, 2013
Since April 23th, 2013 each visitor, user or contributor of the OpenStreetMap (OSM) project can “add a note” to the map in order to easily mark an error or missing object in the map data. You can find more information about this new feature in the OSM wiki. It is a great new way for people to contribute to the project by improving the data in a simple way. To provide a better overview I created a new webpage which shows some statistics about the new feature. You can find it here: resultmaps.neis-one.org/osm-notes
Besides some general information the webpage also shows the overall, opened and closed number of notes per country. The second table illustrates the OSM contributors who already opened, commented or closed a note. All tables on the page are sortable by clicking on the column headers.
Additionally I integrated the individual contributor note stats to the OSM personal profiles @ “How did you contribute to OpenStreetMap?“. The following image shows the new add-on, of course with Harry, our guinea pig No. 1, and as always, great work here too! 🙂
¡Muchas gracias maɪˈæmɪ Dennis
Ha!
I was waiting to see what you would do with this
Great work as always Pascal. Any chance of a country by country breakdown that can be subscribed to, similar to what you did with the new contributors -> http://resultmaps.neis-one.org/newestosmlist.php
Thanks for your comment, DaCor. There u go: http://resultmaps.neis-one.org/osm-notes or e.g. Ireland 🙂 http://resultmaps.neis-one.org/osm-notes-country?c=Ireland
Nice one!
[…] created a website with some statistics and contributor rankings of the latest OSM “Add a Note” […]
[…] открыл сайт со статистикой и рейтингом участников по новой функциональности заметок в […]
[…] creó un sitio web con algunas estadísticas y rankings de contribuyentes de la nueva función OSM “Agregar una […]
Hello,
Good, having access to all these statistics.
About notes, I would propose an additional column, with something like « closed minus opened ». It would be more fair to the « note closers (few opened, many closed) », compared to the « note addicts (many opened, many closed) ».
JB.
PS: your captcha are unreadable!
Hi JB, thanks for your comment and your idea 🙂
Hello,
I just discovered the country feeds for opened notes. Just a question there: are the already closed notes deleted from the feed? I can’t figure this out, as some of them seem to dissappear, but some closed are still in it.
JB.
Hi JB,
normally the feed for open notes should not contain any closed notes. Do you have an example for me? thx
All the notes I saw yesterday have disappeared (1 week old), but I just found this one at the bottom: 84645, that is said was closed 12 hours ago on osm.org.
Mhm, my database updates the OSM notes of the last 6 days on a hourly basis. Older notes are updated once a day in the morning. Which URL are you using?
Hello,
I first guessed it was on the 6th or 7th day the problem occured, but here is a good one: Note: 87506.
I’m using: http://resultmaps.neis-one.org/osm-notes-country-feed?c=France&a=opened
Hi JB, ok, last time I wrote 6 days, but you are right, the problem “occurs” after 4 days. The OSM notes of the last 4 days are updated on an hourly basis. All other notes are updated on a daily basis. This means, your mentioned note should not be anymore in today’s feed of France, right?
Right!
Hello, one more thought:
Could the latest-commented-notes (http://resultmaps.neis-one.org/osm-notes-country-feed?c=France&a=commented) be sorted by date of last comment, rather than by opening date/note number?
Hi,
in the graph “Users who Opened, Commented or Closed an OSM Note (except anonymous)” is the line from yesterday going back to the first day. Probably bug…
Hi xkomczax,
thx for your comment. It was not directly a bug. However, the axis should now show the correct date.
All the best,
Pascal
Hi Pascal,
Thanks for your work on this. Is it possible to bulk download all notes generated so far? I’m interested in downloading all notes generated by certain users in the US and mapping them, and their state (open, close). I’m also interested in the content / metadata for the notes — i.e. time of opening, location, text etc.
What is the best way you suggest I do this?
Hi Abhishek,
first of all, sorry for my late answer. I created an export of all OSM US notes for you. It’s a joined table (csv-file) which contains all notes (40,000), their state (open, commented, closed), comments (limited to 255 char), uids, timestamps, etc.: http://tools.neis-one.org/tmp/osm_notes_latest_United_States_export_20140620.csv.zip
I hope that it helps you.
All the best,
Pascal
Hello Pascal,
A problem apparently occured recently with the note overview. A lot of notes (43k) are now in “unknown” country.
It doesn’t seem corrrect.
Great job and best regards,
the_knife
Hi, thx for your comment! Yes, the update-script was not running today. All the best, Pascal
Ok, it looks a bit better now.
But still ~17000 notes in unknown country :
http://resultmaps.neis-one.org/osm-notes-country?c=unknown
A geocoding problem ?
nope, OSM has many notes in the middle of nowhere, e.g. around lat 0 lon 0, see http://www.openstreetmap.org/#map=19/0.00009/-0.00042&layers=N
Now 10 339 notes in the middle of nowhere.
Why does this number decrease ?
I guess this is the result after the failed update script. Anyway, you are right, looks strange :-/
Hi,
I’ve also been noticing this strange behavior. Yesterday the unknown country had 100k notes in it, now it is down to 5000, but I’m pretty sure the two notes I still seem to have there belong to some known countries.
Also, some of the notes I touched seem to be missing from your database. For example this: http://www.openstreetmap.org/note/375141 (and also note #318240, #335193, just to list some of the recent ones) doesn’t appear on my “Noteboard”.
Is this also some bug in the script, or is it some database issue?
Thanks, kdano
Thanks the_knife and kdano for noticing.
Due to several issues (updating) with the existing OSM notes database, I created a new one. Hopefully it will be finish and online tomorrow.
All the best,
Pascal
hm. I don’t know what could be the issue (maybe the note database?), but I closed 13 notes in Budapest during the past week, and still none of them appear on the rss feed for Hungary.
Hi kdano,
thank you very much! Had a bug in the new postgres query for the feeds.
All the best,
Pascal
Hi,
I’m a beginner to OSM. Your works look so amazing to me. I’m going to write undergraduate thesis about OSM contributors and changeset. I’m wondering how do you get the data of the contributors contribution in different countries? Does it through downloading the whole history dump data and then extract by different countries? I’m interested in mapping contributors contribution in Canada, and see the characteristics of the contributors in terms of the number of nodes, ways, relations and edited type they have contributed in different provinces. Do you think it is feasible? And is it possible to retrieve the data in a month?
Thank you so much
Hi Lisa,
the contributors changes per country is based on the changeset dump, which is available here [1] (changesets-latest.osm.bz2). Furthermore I use the changeset’s bbox center for counting the changes.
Regarding your question, maybe the iOSMAnalyzer tool [2] could be useful for you. Based on the history dump file (a selected OSM area), it generates sveral data quality analyses, statistics and maps, e.g. for Canada.
Hope that it helps you.
All the best,
Pascal
[1] http://planet.osm.org/planet/
[2] https://github.com/zehpunktbarron/iOSMAnalyzer
Hi Pascal,
Thank you for replying. I downloaded changeset dump from changesets-lastest.osm.bz2 and used osm2pgsql to import file into postgresql. However the result doesn’t contain changeset id or uid. Then I read the default.style file which is used in importing, and it mentions”Special database columns”which can be populated by osm2pgsql if present it in the .style file. Some useful data like uid, changeset, timestamp, etc are included.
So I guess if I can edit dafault.style file, presenting special database columns, I can get contributors changes.
I’m not sure whether my thought is right? And do you what kind of language does default.style use? I’m wondering how to edit it.
Thank you
Hi Lisa,
sadly, I have to mention that I didn’t use osm2pgsql so far. Furthermore, I’m not sure if osm2pgsql is the right tool for you.
Maybe you could try to use the following script:
https://github.com/zhm/osmchanges-postgres
Hope that it helps you.
All the best,
Pascal