Wikimedia Bugzilla is closed!

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)`;
+----------+
| COUNT(*) |
+----------+
|     3549 |
+----------+
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