On Fri, Aug 19, 2011 at 03:07:52PM +0200, Jane Darnell wrote: > 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
Hi Jane, I am first trying to get the data itself. The pretty pictures should be possible, but are really a next step. Regards, Andre > > 2011/8/19 Andre Koopal <[email protected]> > > > 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_Erfgoed_Inventarisatie/RijksmonumentenTeller > > > > > > > > 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&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&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&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 > > > >> [email protected] > > > >> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > >> http://www.wikilovesmonuments.eu > > > > > > > > _______________________________________________ > > > > Wiki Loves Monuments mailing list > > > > [email protected] > > > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > > http://www.wikilovesmonuments.eu > > > > > > > > > > _______________________________________________ > > > Wiki Loves Monuments mailing list > > > [email protected] > > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > http://www.wikilovesmonuments.eu > > > > _______________________________________________ > > Wiki Loves Monuments mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > http://www.wikilovesmonuments.eu > > > _______________________________________________ > Wiki Loves Monuments mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
