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:
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
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:
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 <jane023(a)gmail.com>
>> *? :* Wiki Loves Monuments Photograph Competition
>> <wikilovesmonuments(a)lists.wikimedia.org>
>> *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 <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