Nuno, That chart (my portuguese is bad, but I assume it shows percentage of pictures to monuments) is also very interesting for the purposes of the competition, but I was looking for something much less dynamic - just the number of monuments per municipality in a chart which I suppose would show lots of monuments near historic cities and nothing in the mountain ranges. I guess at the stage we are going though, that may be difficult to create if we are still working so hard on getting those lists into the database.
I also never thought about a map of Europe by municipality before, but theoretically this should already be on Wikipedia in some form or other, it seems to me. Jane 2011/8/19 Nuno Tavares <[email protected]> > 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. > > -- > 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_by_department.svg > > > > < > 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 <[email protected]> > > *À :* Wiki Loves Monuments Photograph Competition > > <[email protected]> > > *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 <[email protected] <mailto:[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 > > < > 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 > > < > 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 > > < > 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] > > <mailto:[email protected]> > > > >> > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > >> http://www.wikilovesmonuments.eu > > > > > > > > _______________________________________________ > > > > Wiki Loves Monuments mailing list > > > > [email protected] > > <mailto:[email protected]> > > > > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > > http://www.wikilovesmonuments.eu > > > > > > > > > > _______________________________________________ > > > Wiki Loves Monuments mailing list > > > [email protected] > > <mailto:[email protected]> > > > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > http://www.wikilovesmonuments.eu > > > > _______________________________________________ > > Wiki Loves Monuments mailing list > > [email protected] > > <mailto:[email protected]> > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > http://www.wikilovesmonuments.eu > > > > > > > > _______________________________________________ > > Wiki Loves Monuments mailing list > > [email protected] > > <mailto:[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
