Wikimedia Bugzilla is closed!

Removing keyword i18n from all these issues. You don't have to tag with this relatively low volume. If you really need you, please create a component "Internationaliastion".

Looks like they currently only work with category-structures. Arg! http://en.wikipedia.org/wiki/Philippine_Registry_of_Cultural_Property 

They do refer to an external website on http://www.nhcphistoricsites.blogspot.nl/ but that site says they are a work in progress.

We have an excel file now, needs to be converted still. Quite easy (only 900 monuments) but first need more info.

Can be imported now. See documentation on http://en.wikipedia.org/wiki/Template:Philippine_cultural_property_row/doc

I'll probably have a shot at it tomorrow (unless someone else beats me to it)

Anything unclear which I can clarify?

* project - wikipedia
* lang - en
* headerTemplate - Philippine cultural property header
* rowTemplate - Philippine cultural property row
* commonsTemplate - WMPH-ID
* commonsTrackerCategory - Cultural heritage monuments in the Philippines with known IDs
* commonsCategoryBase - ?
* autoGeocode - ?
* unusedImagesPage - ?
* imagesWithoutIdPage - ?
* registrantUrlBase - none
* namespaces - 0
* table - cultural_property_Philippines_(en) ?
* truncate - 10?
* primkey - ?

Done 

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 'ph' AS `country`,
    ->        'en' AS `lang`,
    ->         `cp-wmph-id` AS `id`,'ph' AS `adm0`,`region-iso` AS `adm1`,`province` AS `adm2`, /* province-iso is still empty, could be used later */`location` AS `adm3`,NULL AS `adm4`,
    ->         `site_name` AS `name`,
    -> `address` AS `address`,
    -> `location` AS `municipality`,
    -> `lat` AS `lat`,
    -> `lon` AS `lon`,
    -> ROUND(`lat` * @granularity) AS `lat_int`,
    -> ROUND(`lon` * @granularity) AS `lon_int`,
    -> `image` AS `image`,
    -> NULL AS `source`,
    -> `changed` AS `changed`,
    ->         NULL AS `monument_article`,
    ->         NULL AS `registrant_url`
    -> FROM `monuments_ph_(en)`;
Query OK, 687 rows affected, 2061 warnings (1 min 16.77 sec)
Records: 687  Duplicates: 0  Warnings: 2061