Linkato sotto un interessante tool per statistiche sulle liste sei monumenti. ---------- Messaggio inoltrato ---------- Da: "Maarten Dammers" maarten@mdammers.nl Data: 25/ago/2012 17:04 Oggetto: Re: [Wiki Loves Monuments] Statistic question A: wikilovesmonuments@lists.wikimedia.org
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=0http://toolserver.org/~erfgoed/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/Statisticshttps://commons.wikimedia.org/wiki/Commons:Monuments_database/Statisticsso 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
______________________________**_________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.**wikimedia.orgWikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/**wikilovesmonumentshttps://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.**org http://www.wikilovesmonuments.org