> > Not sure what else would be usefull, though. > _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

Has there been any update for this? For NL we have the followonig statisticspage: http://nl.wikipedia.org/wiki/Wikipedia:Wikiproject/Erfgoed/Nederlandse_Erfg… 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&… > > > 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&… >> >> Here is a table example: >> >> http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=table&… >> >> Not sure what else would be usefull, though. >> > > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

In France we have it : http://fr.wikipedia.org/wiki/Fichier:France_Density_of_Monuments_historique… <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 &lt;jane023(a)gmail.com&gt; *? :* Wiki Loves Monuments Photograph Competition &lt;wikilovesmonuments(a)lists.wikimedia.org&gt; *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 &lt;andre(a)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_Erfg… > > > > 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&… <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&… <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&… <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(a)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(a)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(a)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(a)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(a)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(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

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_Erfg… 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_historique… >> >> <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 &lt;jane023(a)gmail.com&gt; >> *? :* Wiki Loves Monuments Photograph Competition >> &lt;wikilovesmonuments(a)lists.wikimedia.org&gt; >> *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 &lt;andre(a)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_Erfg… >> > > >> > > 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&… >> <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&… >> <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&… >> <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(a)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(a)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(a)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(a)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(a)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(a)lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >> http://www.wikilovesmonuments.eu > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

On Sun, Aug 21, 2011 at 11:24:37PM +0100, Nuno Tavares wrote: > Andre, > > I understand different things between your e-mail in 19-08-2011 08:44 > and 19-08-2011 20:51. > > Let's see if I can explain: > > The table you pointed (in the first) is specific to NL. Each country' > table has only some fields mapped to a "global table" (monuments_all). > For those fields, the tool I've shown already does what you want. > > For other fields (like architect), that would need to be addressed on > individual basis, which is too overwhelming (there are 22 different > tables, I suppose each one with more or less fields, with different > names for each one, etc.). > > That's why the table you see at: > http://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_2011/Monumen… > ... only shows some fields (the ones that are common and mapped to > monuments_all). > > > For this table, you can get it with the tool I mentioned (URL probably > spanned in multiple lines): > > > http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=table > &item[]=name&item[]=name_pct&item[]=address&item[]=address_pct&item[]=municipality&item[]=municipality_pct&item[]=coordinates&item[]=coordinates_pct&item[]=image&item[]=image_pct&width=1000&height=700&filter[]=ad&filter[]=be-vlg&filter[]=ch&filter[]=es&filter[]=es-ct&filter[]=es-vc&filter[]=fr&filter[]=ie&filter[]=it-88&filter[]=nl&filter[]=pt > > (There are only some countries because, as I said before, my database is > pretty old). Hi Nuno, This table is only showing countries. What I want is to see for a given country, the numbers per municipal. Regards, Andre > Now, back to Jane: > > ?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? > > What we can do is breakdown by a field, like municipality. Then you > could generate a table with all municipalities (of selected countries) > and request non "_pct" (per-cent) fields. In your example, you would > request only the totals, like this, but breaking down each country by > its municipalities: > > http://www.wikilovesmonuments.org.pt/tools/stats-eu/index.php?format=table&… > > Is that it? > > > Also note that the statistics are independent from the loading of the > databases (each country has their own staff working on that) - if there > is data on the database, it will just show automatically. > > > -- > 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_Erfg… >> >> 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_historique… >>>> >>>> <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 &lt;jane023(a)gmail.com&gt; >>>> *? :* Wiki Loves Monuments Photograph Competition >>>> &lt;wikilovesmonuments(a)lists.wikimedia.org&gt; >>>> *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 &lt;andre(a)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_Erfg… >>>> > > >>>> > > 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&… >>>> <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&… >>>> <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&… >>>> <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(a)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(a)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(a)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(a)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(a)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(a)lists.wikimedia.org >>>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>>> http://www.wikilovesmonuments.eu >>> _______________________________________________ >>> Wiki Loves Monuments mailing list >>> WikiLovesMonuments(a)lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >>> http://www.wikilovesmonuments.eu >> _______________________________________________ >> Wiki Loves Monuments mailing list >> WikiLovesMonuments(a)lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >> http://www.wikilovesmonuments.eu >> > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

"color=heatpct": > > http://www.wikilovesmonuments.org.pt/tools/stats-eu/index2.php?format=table… > > > _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

> > > > > > > > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu > _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu