Re: [Wiki Loves Monuments] Re : European stats and other cool tools

-- Nuno Tavares Wikimedia Portugal http://www.wikimedia.pt Imagine um mundo onde é dada a qualquer pessoa a possibilidade de ter livre acesso ao somatório de todo o conhecimento humano. É isso o que estamos a fazer. Participe também: http://www.wikimedia.pt Em 19-08-2011 20:51, Andre Koopal escreveu: > On Fri, Aug 19, 2011 at 07:34:13PM +0100, Nuno Tavares wrote: >> We have that also, at the bottom of the page: >> http://www.wikilovesmonuments.org.pt/tools/stats/ >> >> I believe a map for Europe (never seen google charts for Europe divided >> by municipality, though) could be refreshed, say, daily and automatically. >> >> Andre, the data is (or really should be) at the unified database >> (monuments_all), and that's what I've been using - it's just not >> updated, as I'm waiting for some database fixes from Maarten. >> >> However I have this strange impression that I'm missing something. Is it >> the tables you're interested in? I can manage to generate them >> (dinamically) the next few days. > > Hi Nuno, > > Yes, I am intrested in just the tables. Just like the page I started with: > > http://nl.wikipedia.org/wiki/Wikipedia:Wikiproject/Erfgoed/Nederlandse_Erfgo... > > Regards, > > Andre >> >> -- >> Nuno Tavares >> Wikimedia Portugal >> http://www.wikimedia.pt >> >> Imagine um mundo onde ? dada a qualquer pessoa a possibilidade de ter >> livre acesso ao somat?rio de todo o conhecimento humano. ? isso o que >> estamos a fazer. >> >> Participe tamb?m: http://www.wikimedia.pt >> >> Em 19-08-2011 14:34, Otourly Wiki escreveu: >>> In France we have it : >>> http://fr.wikipedia.org/wiki/Fichier:France_Density_of_Monuments_historiques... >>> >>> http://fr.wikipedia.org/wiki/Fichier:France_Density_of_Monuments_historiques_by_department.svg >>> I assume it could be easly done for Neederlands and cie... >>> >>> Florian Farge aka Otourly >>> Sur lesprojets wikim?diens >>> http://commons.wikimedia.org/wiki/User:Otourly et l'Association >>> fran?aise http://www.wikimedia.fr/index.php/Accueil,sur OxyRadio >>> http://www.oxyradio.net/membre-436.html, OSM >>> http://www.openstreetmap.org/user/Otourly, et sur MOVIM >>> http://www.movim.eu/ >>> Socio di Wikimedia Italia >>> http://www.wikimedia.it/index.php/Pagina_principale >>> >>> ------------------------------------------------------------------------ >>> *De :* Jane Darnell jane023@gmail.com >>> *? :* Wiki Loves Monuments Photograph Competition >>> wikilovesmonuments@lists.wikimedia.org >>> *Envoy? le :* Vendredi 19 Ao?t 2011 15h07 >>> *Objet :* Re: [Wiki Loves Monuments] European stats and other cool tools >>> >>> Andre, >>> It would be cool to have a "heat map" of Europe with the number of >>> monuments per municipality like this one in the States for the >>> National Register of Historic Places: >>> >>> http://en.wikipedia.org/wiki/File:NRHP_USA_Map.svg >>> >>> Is this possible with the data we have now? >>> Jane >>> >>> 2011/8/19 Andre Koopal <andre@molens.org mailto:andre@molens.org> >>> >>> On Fri, Aug 19, 2011 at 12:06:14AM +0100, Nuno Tavares wrote: >>> > Andre, >>> > >>> > We can easily report on the fields that are mapped against >>> > 'monuments_all' table, other combinations would be too weird >>> to allow >>> > (although that's possible as well). >>> > >>> > What are you trying to achieve, in the end? Just dumping all >>> fields status? >>> >>> Hi Nuno, >>> >>> Per 'municiple', or whatever distinction there is in a country >>> we want >>> at least to know the number of monuments there, and the numbers >>> of pictures >>> taken (which lead to how much to do). The others can be >>> intresting as well, >>> like 'number of coordinates'. That way people can deal with the >>> lists in >>> a structured manner dealing with these things, and, most >>> important for >>> WLM, decide were still a lot of pictures are needed, so go there >>> to take >>> pictures. >>> >>> Regards, >>> >>> Andre >>> > >>> > -- >>> > Nuno Tavares >>> > Wikimedia Portugal >>> > http://www.wikimedia.pt >>> > >>> > Imagine um mundo onde ? dada a qualquer pessoa a possibilidade >>> de ter >>> > livre acesso ao somat?rio de todo o conhecimento humano. ? >>> isso o que >>> > estamos a fazer. >>> > >>> > Participe tamb?m: http://www.wikimedia.pt >>> > >>> > Em 18-08-2011 18:04, Andre Koopal escreveu: >>> > > Has there been any update for this? >>> > > >>> > > For NL we have the followonig statisticspage: >>> > > >>> > > >>> http://nl.wikipedia.org/wiki/Wikipedia:Wikiproject/Erfgoed/Nederlandse_Erfgo... >>> > > >>> > > That is done outsite the database at the moment by somebody >>> else, but of >>> > > course all data is in the database. >>> > > >>> > > Can something like this already be generated via the Api? I >>> have a request >>> > > from Romaine if this can be done for BE as well, and it is >>> probably of >>> > > intrest to all countries? >>> > > >>> > > Regards, >>> > > >>> > > Andre >>> > > >>> > > On Thu, Aug 11, 2011 at 10:21:14PM +0100, Nuno Tavares wrote: >>> > >> I've added a new option: 'groupby', values: country or item. >>> > >> >>> > >> Grouping by country may be more interesting for countries >>> in particular. >>> > >> >>> > >> >>> > >> Example: >>> > >> >>> > >> >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=graph&a... >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=graph&item[]=name_pct&item[]=address_pct&item[]=municipality_pct&item[]=coordinates_pct&item[]=image_pct&width=1000&height=700&filter[]=pt&filter[]=es&filter[]=es-vc&filter[]=es-ct&groupby=country >>> > >> >>> > >> >>> > >> PS: By the way, graph for 'pt' looks pretty ugly, we really >>> should >>> > >> update our database :P >>> > >> >>> > >> >>> > >> -- >>> > >> Nuno Tavares >>> > >> Wikimedia Portugal >>> > >> http://www.wikimedia.pt >>> > >> >>> > >> Imagine um mundo onde ? dada a qualquer pessoa a >>> possibilidade de ter >>> > >> livre acesso ao somat?rio de todo o conhecimento humano. ? >>> isso o que >>> > >> estamos a fazer. >>> > >> >>> > >> Participe tamb?m: http://www.wikimedia.pt >>> > >> >>> > >> Em 11-08-2011 03:24, Nuno Tavares escreveu: >>> > >>> Maarten and all, >>> > >>> >>> > >>> I've done already the most part for the statistics. I'll >>> have to recall >>> > >>> how to get in to the toolserver to merge it into the API, >>> but here is a >>> > >>> preview (based on an old DB dump): >>> > >>> >>> > >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php >>> > >>> >>> > >>> Here is a graph example: >>> > >>> >>> > >>> >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=graph&a... >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=graph&item[]=name_pct&item[]=address_pct&item[]=municipality_pct&item[]=coordinates_pct&item[]=image_pct&width=1000&height=700&filter[]=pt&filter[]=es&filter[]=es-vc&filter[]=es-ct >>> > >>> >>> > >>> Here is a table example: >>> > >>> >>> > >>> >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=table&a... >>> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=table&item[]=name_pct&item[]=address_pct&item[]=municipality_pct&item[]=coordinates_pct&item[]=image_pct&width=1000&height=700&filter[]=pt&filter[]=es&filter[]=es-vc&filter[]=es-ct >>> > >>> >>> > >>> Not sure what else would be usefull, though. >>> > >>> >>> > >> >>> > >> _______________________________________________ >>> > >> Wiki Loves Monuments mailing list >>> > >> WikiLovesMonuments@lists.wikimedia.org >>> mailto:WikiLovesMonuments@lists.wikimedia.org >>> > >> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> > >> http://www.wikilovesmonuments.eu >>> > > >>> > > _______________________________________________ >>> > > Wiki Loves Monuments mailing list >>> > > WikiLovesMonuments@lists.wikimedia.org >>> mailto:WikiLovesMonuments@lists.wikimedia.org >>> > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> > > http://www.wikilovesmonuments.eu >>> > > >>> > >>> > _______________________________________________ >>> > Wiki Loves Monuments mailing list >>> > WikiLovesMonuments@lists.wikimedia.org >>> mailto:WikiLovesMonuments@lists.wikimedia.org >>> > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> > http://www.wikilovesmonuments.eu >>> >>> _______________________________________________ >>> Wiki Loves Monuments mailing list >>> WikiLovesMonuments@lists.wikimedia.org >>> mailto:WikiLovesMonuments@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> http://www.wikilovesmonuments.eu >>> >>> >>> >>> _______________________________________________ >>> Wiki Loves Monuments mailing list >>> WikiLovesMonuments@lists.wikimedia.org >>> mailto:WikiLovesMonuments@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> http://www.wikilovesmonuments.eu >>> >>> >>> >>> _______________________________________________ >>> Wiki Loves Monuments mailing list >>> WikiLovesMonuments@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> http://www.wikilovesmonuments.eu >> >> _______________________________________________ >> Wiki Loves Monuments mailing list >> WikiLovesMonuments@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >> http://www.wikilovesmonuments.eu > > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu >