Not sure if it's possible.
Version: unspecified
Severity: enhancement
Not sure if it's possible.
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 | T40328 Add the Philippines to the monuments database |
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
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