On 27/06/12 23:43, Béria Lima wrote:

No Portuguese or Spanish city? :D _____ /Béria Lima/

The best place for a Wiki Takes in the Iberian Peninsula would be Lisboa, with the second one in (pt, es) being in Menorca. :)

+---------+--------------------------------------------------+---------------------+ | country | municipality | COUNT(municipality) | +---------+--------------------------------------------------+---------------------+ | pt | [[Lisboa]] | 293 | | es | Ciutadella | 216 | | es | [[Ceuta]] | 186 | | pt | [[Porto]] | 179 | | es | Llucmajor | 178 | | es | Madrid | 156 | | es | Alaior | 152 | | es | Manacor | 127 | | es | Palma | 126 | | es | Maó | 120 |

I don't know the table has been done, but there are some Iberian cities with more than 200 monuments. For example, Ciutadella in Balearic Islands has 216 [1], Sabadell 214 [2], Terrassa 223 [3], Tarragona 226 [4], Vic 218 [5], Girona more than 400 [6], Olot mora than 200,[7] Barcelona with more than 700 [8] and Figueres, Tortosa, Reus and sant Feliu de Llobregat in Catalonia. Cartagena more than 200 [9], Madrid the same or Bilbao more than 300, etc. Yes, Bilbao or Cartagena have not yet all monuments listed on Wikipedia.

[1] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Ciutadella [2] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Sabadell [3] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Terrassa [4] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Tarragona [5] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Vic [6] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Girona_(centre) and http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Girona_(perif%C3%A8ria) [7] http://ca.wikipedia.org/wiki/Llista_de_monuments_d%27Olot_(nucli) and http://ca.wikipedia.org/wiki/Llista_de_monuments_d%27Olot_(est) [8] http://ca.wikipedia.org/wiki/Llista_de_monuments_de_Barcelona [9] http://www.patrimur.com/bienesin/res_bic.php?titulo=&municipio=Cartagena...

Santi (Millars)

From: beria.lima@wikimedia.pt Date: Wed, 27 Jun 2012 18:43:36 -0300 To: wikilovesmonuments@lists.wikimedia.org Subject: Re: [Wiki Loves Monuments] Where to do a Wiki Takes?

No Portuguese or Spanish city? :D_____ Béria Lima

Imagine um mundo onde é dada a qualquer pessoa a possibilidade de ter livre acesso ao somatório de todo o conhecimento humano. Ajude-nos a construir esse sonho.

On 27 June 2012 18:28, Maarten Dammers maarten@mdammers.nl wrote:

Hi everyone,

I wondered what the best place was to organize a "Wiki Takes ..." event so I did a query :-)

Picked out some places :

At the top is:

* Edinburgh 4829

Than it's all Flanders:

* Gent/Gand : 4829

* Antwerpen/Anver : 4471

* Brugge/Buges : 4420

(and a lot more cities in Flanders, I'll skip the rest)

Than major European cities start showing up

* Bukarest : 2251

* Bratislava : 2168

* Glasgow : 1846

(and some more from Scotland, I'll skip the rest)

* Tallinn : 1512

* Copenhagen : 1240

* Kraków : 1171

* Brakel: 780 (that's Dutch, but I had to look it up on the map)

* Oslo : 424

* Gotland : 309

* St. Louis, Missouri : 297

The full list is at http://toolserver.org/~multichill/temp/queries/erfgoed/where_wiki_takes.txt (and the query at http://toolserver.org/~multichill/temp/queries/erfgoed/where_wiki_takes.sql )

This might server as some inspiration to organize your local Wiki Takes! How to organize such an event is documented at https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Organizing_a... .

Maarten

_______________________________________________

Wiki Loves Monuments mailing list

WikiLovesMonuments@lists.wikimedia.org

https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments

http://www.wikilovesmonuments.eu

_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

On 28/06/12 00:31, Andre Koopal wrote:

I assume the table is number of monuments who don't have a picture yet.

Regards,

Andre

Maarten list does indeed only take into account entries with no registered photo, but there's little change in the order:

+------------+--------------------------------------------------------------------------+---------------------+ | country | municipality | COUNT(municipality) | +------------+--------------------------------------------------------------------------+---------------------+ | at | | 44040 | | fr | non | 11747 | | be-vlg | Gent | 5028 | | be-vlg | Gand | 5003 | | sct | [[Edinburgh]] | 4829 | | be-vlg | Anvers | 4616 | | be-vlg | Antwerpen | 4615 | | be-vlg | Brugge | 4539 | | be-vlg | Bruges | 4539 | | at | Wien | 3158 | | be-vlg | Leuven | 2966 | | ro | municipiul [[Bucure?ti|Bucure?ti]] | 2642 | | sk | Bratislava | 2541 | | be-vlg | Mechelen | 2360 | | ee | Tallinn | 2225 | | be-vlg | Dendermonde | 1899 | | sct | [[Glasgow]] | 1846 | | be-vlg | Courtrai | 1743 | | be-vlg | Kortrijk | 1743 | | be-vlg | Ieper | 1702 | | be-vlg | Waregem | 1697 | | be-vlg | Oudenaarde | 1602 | | be-vlg | Lier | 1446 | | nl | Utrecht | 1415 | | be-vlg | Tielt | 1406 | | be-vlg | Diksmuide | 1354 | | be-vlg | Ronse | 1350 | | be-vlg | Menen | 1340 | | be-vlg | Wevelgem | 1307 | | us | [[Middlesex County, Massachusetts]] | 1301 |

...

PS: Austria is cheating by not providing municipalities :)

Hi Platonides,

Op 28-6-2012 0:38, Platonides schreef:

On 28/06/12 00:18, Santiago Navarro Sanz wrote:

...

I don't know the table has been done, but there are some Iberian cities with more than 200 monuments. For example, Ciutadella in Balearic Islands has 216 [1], Sabadell 214 [2], Terrassa 223 [3], Tarragona 226 [4], Vic 218 [5], Girona more than 400 [6], Olot mora than 200,[7] Barcelona with more than 700 [8] and Figueres, Tortosa, Reus and sant Feliu de Llobregat in Catalonia. Cartagena more than 200 [9], Madrid the same or Bilbao more than 300, etc. Yes, Bilbao or Cartagena have not yet all monuments listed on Wikipedia.

Seems we miss "some" monuments in our lists... +-------------------------+---------------------+ | Barcelona | 915 | | Sant Feliu de Llobregat | 174 | | Madrid | 156 | | Girona | 23 | | Tortosa | 21 | | Tarragona | 17 | | Vic | 9 | | Olot | 7 | | Terrassa | 5 | | Sabadell | 4 | | Figueres | 4 | | Reus | 4 | +-------------------------+---------------------+

We have no entries for Cartagena, Bilbao or Reus :(

Oh, and those (except Madrid) were listed as being in the "es-ct country" instead of es, so my previous mail missed all Catalonian and Valèncian monuments. Can we change them in monuments_all to be filled as 'es'?

Don't know. Depends on how the registers are organized. How are they organized?

I think we should do the same thing for other "sub-countries", too (Belgium, Germany, Denmark, Italy).

Please don't. You would break the primary key of the database and create a royal mess. In Belgium we have three registers, Germany dozens, Denmark two and I don't know about Italy. Reminds me that we still have to untangle the two registers of Sweden. Any locals on this list to help out with that?

Maarten

Ah, so this means we should do the Wiki Takes in Gent (Belgium)

You're welcome :-)

Regards, Maarten

2012/6/28 Samat samat78@gmail.com

Budapest has 1564 state monuments ;)

Samat

On Wed, Jun 27, 2012 at 11:28 PM, Maarten Dammers maarten@mdammers.nlwrote:

...

Hi everyone,

I wondered what the best place was to organize a "Wiki Takes ..." event so I did a query :-) Picked out some places :

At the top is:

• Edinburgh 4829

Than it's all Flanders:

• Gent/Gand : 4829
• Antwerpen/Anver : 4471
• Brugge/Buges : 4420

(and a lot more cities in Flanders, I'll skip the rest) Than major European cities start showing up

• Bukarest : 2251
• Bratislava : 2168
• Glasgow : 1846

(and some more from Scotland, I'll skip the rest)

• Tallinn : 1512
• Copenhagen : 1240
• Kraków : 1171
• Brakel: 780 (that's Dutch, but I had to look it up on the map)
• Oslo : 424
• Gotland : 309
• St. Louis, Missouri : 297

The full list is at http://toolserver.org/~**multichill/temp/queries/** erfgoed/where_wiki_takes.txthttp://toolserver.org/%7Emultichill/temp/queries/erfgoed/where_wiki_takes.txt(and the query at http://toolserver.org/~**multichill/temp/queries/** erfgoed/where_wiki_takes.sqlhttp://toolserver.org/%7Emultichill/temp/queries/erfgoed/where_wiki_takes.sql)

This might server as some inspiration to organize your local Wiki Takes! How to organize such an event is documented at https://commons.wikimedia.org/**wiki/Commons:Wiki_Loves_** Monuments/Organizing_a_Wiki_**takeshttps://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Organizing_a_Wiki_takes.

Maarten

---

Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu

On 29/06/12 16:49, Bas vb wrote:

The Statistics page on commons seems to not get all monuments? Does this mean the database doesn't get all monuments as well?

http://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics it sais 26000 monuments for nl on nl, which is clearly wrong (it should be around 62.000) also it sais 2 for be-wal on nl, which should be above 4000 (it has the same source as on fr, so number should be around the same)

The table has exactly 2 monuments:

62015 | CLT-0001-01 - Site gevormd door vijf lindebomen rond de kleine kapel van Saint-Anne: gebied van bijzondere 62015 | CLT-0003-01 - Een rode beuk en de directe omgeving in het park naast het gemeentehuis

It may be a problem with handling the double primary key. Marteen, can you look at it?