On Sat, Aug 25, 2012 at 5:04 PM, Maarten Dammers <[email protected]>wrote:
> 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=ua&**format=html&limit=0<http://toolserver.org/%7Eerfgoed/api/api.php?action=statistics&stcountry=ua&format=html&limit=0> > > All the statistics are linked from https://commons.wikimedia.org/** > wiki/Commons:Monuments_**database/Statistics<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 Thank you for the tool, it is great! Samat
_______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
