Osmar was putting lists online.
Version: unspecified
Severity: enhancement
Osmar was putting lists online.
Version: unspecified
Severity: enhancement
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | None | T40648 Wiki Loves Monuments 2012 (tracking) | |||
Resolved | None | T40314 Add sources to Wiki Loves Monuments 2012 monuments database (tracking) | |||
Resolved | None | T40319 Add Chile in Spanish to the monuments database |
Osmar is working on it. He already put the lists on Commons and will now move them to the Spanish Wikipedia.
From Osmar
Here you can see the lists: http://es.wikipedia.org/wiki/Especial:LoQueEnlazaAqu%C3%AD/Plantilla:MonumentoChile/encabezado
The header is {{MonumentoChile/encabezado}} and uses the parameter ISO for the ISO code (ex. {{MonumentoChile/encabezado|ISO=RM}}). Each row uses {{MonumentoChile}} which has the following parameters:
{{MonumentoChile
id = <id> |
monumento = <name> |
monumento_desc = <description> |
comuna = <municipality> |
lat = <latitude> |
long = <longitude> |
dirección = <address> |
decreto = <decree> |
fecha = <date of the decree> |
imagen = <image at Commons> |
tipo = <type of monument: MH, historical monument; ZT: traditional neighborhood; SN: natural sanctuary> |
}}
Had to do some improvements, but now it seems to work:
mysql> SELECT adm0, adm1, COUNT(adm1) FROM monuments_all WHERE adm0='cl' GROUP BY adm1;
+------+-------+-------------+
adm0 | adm1 | COUNT(adm1) |
+------+-------+-------------+
cl | CL-AI | 13 |
cl | CL-AN | 47 |
cl | CL-AP | 25 |
cl | CL-AR | 20 |
cl | CL-AT | 24 |
cl | CL-BI | 42 |
cl | CL-CO | 45 |
cl | CL-LI | 42 |
cl | CL-LL | 51 |
cl | CL-LR | 18 |
cl | CL-MA | 36 |
cl | CL-ML | 45 |
cl | CL-RM | 211 |
cl | CL-TA | 57 |
cl | CL-VS | 28 |
+------+-------+-------------+
15 rows in set (0.00 sec)