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

Anthony osm at inbox.org
Sun Aug 8 22:42:52 BST 2010


On Sun, Aug 8, 2010 at 5:20 PM, Anthony <osm at inbox.org> wrote:
> On Sun, Aug 8, 2010 at 5:08 PM, Anthony <osm at inbox.org> wrote:
>> Incidentally, I'd also guess the "30,000 'CT 1.0' signups" is a
>> similarly misleading figure.
>
> What's the UID of the first user to sign up under "CT 1.0"?  Can I
> assume that any higher uids have likewise agreed to the contributor
> terms, and any lower uids have not?

I'm guessing about 250252, which means there are about 19,418
contributors who have signed up under the new contributor terms.
That's 15% of all 128,250 contributors, and 51% of the 37,843
contributors that have contributed since the contributor terms have
been implemented (3/22/10).

---

data=# select uid from changesets where uid is not null and
created_at<'2010-03-22' order by uid desc limit 1;
  uid
--------
 250252
(1 row)

data=# select count(distinct uid) from changesets where uid>250252;
 count
-------
 19418
(1 row)

data=# select * from changesets where uid>250252 and created_at<'2010-03-22';
[there were none]
data=# select count(distinct uid) from changesets where created_at>'2010-03-22';
 count
-------
 37843
(1 row)




More information about the talk mailing list