Language is most likely going to be English

Don't use http://en.wikipedia.org/wiki/List_of_heritage_sites_in_South_Africa - seems not to be matched properly to SAHRA yet.

The have the data, started some notes at https://commons.wikimedia.org/wiki/User:Multichill/Monuments_notes#South_Africa . Not sure what the status is right now. Send them an email.

Ready for import. See http://en.wikipedia.org/wiki/Template:SAHRA_heritage_site_row for documentation.

Elke made the config and database query

mysql> SELECT COUNT(*) FROM monuments_za_(en);
+----------+

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

+----------+
1 row in set (0.00 sec)

Manual merge works:

mysql> REPLACE INTO monuments_all (country, lang, id, adm0, adm1, adm2, adm3, adm4, name, address, municipality, lat, lon, lat_int, lon_int, image, source, changed, monument_article, registrant_url )

-> SELECT 'za' AS `country`,
->  'en' AS `lang`,
->  `sitereference` AS `id`,
->    'za' AS `adm0`,
->    LOWER(`province_iso`) AS `adm1`,
->    `magisterial_district` AS `adm2`,
->    `town` AS `adm3`,
->    NULL AS `adm4`,
->  `site_name` AS `name`,
->  `site_name` AS `address`,
->  `town` AS `municipality`,
->  `lat` AS `lat`,
->  `lon` AS `lon`,
->    ROUND(`lat` * @granularity) AS `lat_int`,
->    ROUND(`lon` * @granularity) AS `lon_int`,
->  `image` AS `image`,
->  `source` AS `source`,
->  `changed` AS `changed`,
->   '' AS `monument_article`,
->  '' AS `registrant_url` FROM `monuments_za_(en)`;

Query OK, 3549 rows affected (1 min 2.07 sec)
Records: 3549 Duplicates: 0 Warnings: 0