To follow up from my previous post, I did some further work on generating and putting online a table of OSM node/way ranks
The data that’s there right now is from today (2018-03-01) and the deltas are vs. 2 weeks ago (2018-02-12).
Standard disclaimer: Last-modified-rank is only vaguely related to contribution, there is no way at all to measure actual quality or value of contribution across users, because it’s subjective, and users are very different from each other. However, this table can be very useful for an individual mapper to see how their amount of contribution changes over time, and to identify, for example, accounts that are moving up rapidly which usually indicates they are doing an import. Similarly, if your rank moves down, it can mean that someone (correctly or not) has modified or deleted your mapping work.
For those curious about the technical mess that’s currently involved, here is what I did:
- Download of the weekly planet file from Planet OSM (39 GB), this takes around 12 hours.
- Running a small Linux C++ app that uses Osmium to parse the pbf and generate a CSV of users along with number of nodes and ways that they are the last modifier of.
- On Windows, running SQLiteStudio to ingest that CSV as a table in a database.
- Run a C++ app that uses SQLite to query the database and generate the HTML output.
- FTP that HTML up to a server.