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
