[OSM-talk] Activity statistics per city (or region)

Jóhannes Birgir Jensson joi at betra.is
Tue Oct 27 10:05:04 UTC 2015


Þann 27.10.2015 07:09, Paul Norman reit:
> On 10/26/2015 8:24 AM, Fabian Schmidt wrote:
>> It is rare but there are users who renamed their account, so there are 
>> more user names than numeric user ids.
> 
> No. Although users have renamed their account, this doesn't increase
> the number of user names, it changes one of them.
> 
> Additionally, user IDs are a PostgreSQL serial so there can be gaps,
> and spam users are sometimes completely deleted.

I'm guessing he meant that there are more user names in the changelogs 
than actually exist, if you are parsing changelogs over several time 
periods. I'm guessing the user name change is reflected instantly in the 
changelog after renaming.



More information about the talk mailing list