[OSM-talk] Frederik declares war on data imports...

[Anthony]

On Sun, Aug 8, 2010 at 2:44 PM, John Smith <deltafoxtrot256 at gmail.com> wrote:
> I think that is considerably on the high side of things, since someone
> gave an estimate of total number of contributors at about 75k

Good call.  There are 5,404,188 changesets.  Only 11,631 changesets
are completely anonymous (no user id).  Of the remainder, there are
128,250 unique users who have created a changeset.  46,495 (36%) of
those users have contributed in the last 6 months.

I guess the 286,291 figure counts users who've created an account and
then never edited?  I'm a bit surprised it's that much higher, but I
guess there are a lot of people who never figure out how to save a
changeset in Potlatch, or not before having created a second/third/Nth
account anyway.  We should probably email them, and ask them what's
up, but I guess that's a topic for another thread.

Incidentally, I'd also guess the "30,000 'CT 1.0' signups" is a
similarly misleading figure.

---

data=# select count(*) from changesets;
  count
---------
 5404188
(1 row)

data=# select count(*) from changesets where uid is null;
 count
-------
 11631
(1 row)

data=# select count(distinct uid) from changesets;
 count
--------
 128250
(1 row)

data=# select created_at from changesets order by created_at desc limit 1;
     created_at
---------------------
 2010-08-05 03:39:12
(1 row)

data=# select count(distinct uid) from changesets where created_at>'2010-02-05';
 count
-------
 46495
(1 row)