Page MenuHomePhabricator

Add Chile in Spanish to the monuments database
Closed, ResolvedPublic

Description

Osmar was putting lists online.


Version: unspecified
Severity: enhancement

Details

Reference
bz38319

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 1:06 AM
bzimport set Reference to bz38319.
bzimport added a subscriber: Unknown Object (MLST).

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;
+------+-------+-------------+

adm0adm1COUNT(adm1)

+------+-------+-------------+

clCL-AI13
clCL-AN47
clCL-AP25
clCL-AR20
clCL-AT24
clCL-BI42
clCL-CO45
clCL-LI42
clCL-LL51
clCL-LR18
clCL-MA36
clCL-ML45
clCL-RM211
clCL-TA57
clCL-VS28

+------+-------+-------------+
15 rows in set (0.00 sec)