[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