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