On Sun, Aug 8, 2010 at 5:20 PM, Anthony <[email protected]> wrote: > On Sun, Aug 8, 2010 at 5:08 PM, Anthony <[email protected]> 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) _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
