[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 --- Comment #4 from Effeietsanders effeietsand...@wikipedia.be 2012-08-31 10:24:57 UTC --- Ready for import. See http://en.wikipedia.org/wiki/Template:SAHRA_heritage_site_row for documentation. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 Effeietsanders effeietsand...@wikipedia.be changed: What|Removed |Added Priority|Unprioritized |High -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 Maarten Dammers maar...@mdammers.nl changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #5 from Maarten Dammers maar...@mdammers.nl 2012-08-31 19:01:34 UTC --- 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 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 --- Comment #3 from Maarten Dammers maar...@mdammers.nl 2012-08-19 16:33:45 UTC --- 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. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 --- Comment #2 from Effeietsanders effeietsand...@wikipedia.be 2012-08-13 07:12:13 UTC --- Don't use http://en.wikipedia.org/wiki/List_of_heritage_sites_in_South_Africa - seems not to be matched properly to SAHRA yet. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 Effeietsanders effeietsand...@wikipedia.be changed: What|Removed |Added CC||effeietsand...@wikipedia.be --- Comment #1 from Effeietsanders effeietsand...@wikipedia.be 2012-08-11 16:52:34 UTC --- Language is most likely going to be English -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 38330] Add South Africa to the monuments database
https://bugzilla.wikimedia.org/show_bug.cgi?id=38330 Sam Reed (reedy) s...@reedyboy.net changed: What|Removed |Added Keywords||i18n Severity|normal |enhancement -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
