Op 25-8-2012 13:56, Platonides schreef:
On 25/08/12 09:23, Андрій Бондаренко wrote:
Just one more question, I'm interested to see what region is the most succesful with geo-coordinates. I suppose Lwów won't be first with this parameter ;)
select municipality, count(*) as count from `monuments_ua_(uk)` where lat is not null and lon is not null group by municipality order by count desc;
Thanks to Nuno we already have most of these statistics in a nice webinterface, see http://toolserver.org/~erfgoed/api/api.php?action=statistics&stcountry=u...
All the statistics are linked from https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics so you can see this for all countries in the database.
Maarten
Ps. The countries we added to the database yesterday and today will show up tomorrow after the nightly run