Andre, You can get the tables like this, following the earlier concepts:
http://www.wikilovesmonuments.org.pt/tools/stats-eu/index2.php?format=table&item[]=total&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[]=lu&breakdown=municipality&groupby=item (url probably wrapped) Considerations: * format=graph - I don't think it's useful for this purpose so it's currently buggy and it will probably keep that way; * This is index2.php because some things are hardcoded for simplicity. Maybe I'll merge it to index.php later, but just maybe... Hope it helps, -- 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 24-08-2011 15:48, Andre Koopal escreveu: > 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 > _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
