Hi Nuno, On Wed, Aug 24, 2011 at 02:57:04PM +0100, Nuno Tavares wrote: > Yes, it is. It will be simple to breakdown by municipality for the > fields mapped to monuments_all - I just hadn't the time yet. > > The others will be more difficult, and won't be ready in time, if it > depends on me.
The fields in monuments_all will be enough. Most important ones are the number of monuments, and the number of pictures. All the others is at most a 'nice to have' and certainly not important for the competition, only usefull for volunteers who try to complete the lists on wikipedia. Regards, Andre > > Since you are compiling (a part of?) the database, could you please give > a hand to Maarten to fix the current database? Let me know if I can help. > > Best, > -- > 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 > > > > Andre Koopal escreveu: > > 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 > > > > _______________________________________________ > 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
