Hi Nuno, Is this clear now? Otherwise can we perhaps have a chat on irc about it?
Regards, Andre On Mon, Aug 22, 2011 at 12:48:49AM +0200, Andre Koopal wrote: > 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/Monuments_database > > ... 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&item[]=total&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&breakdown=municipality > > > > 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_Erfgoed_Inventarisatie/RijksmonumentenTeller > > > > > > 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_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 > > > > > > > _______________________________________________ > > 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
