Page MenuHomePhabricator

Add the Philippines to the monuments database
Closed, ResolvedPublic

Description

Not sure if it's possible.


Version: unspecified
Severity: enhancement

Details

Reference
bz38328

Event Timeline

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

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.

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