Changes between Version 39 and Version 40 of Event/2011/GCI

Timestamp:

11/17/11 15:43:00 (13 years ago)

Author:

Fran Boon

Comment:

--

Event/2011/GCI

@@ -85 +85 @@
 '''Reevaluate  : ''' [[BR]]
 
-* Easy (Fran): Provide UTF8 names for Locations exported from [http://gadm.org GADM] in Vietnam, e.g. using [http://en.wikipedia.org/wiki/Vietnam#Administrative_subdivisions Wikipedia]
+=== (5.4) Provide UTF8 names for Locations exported from [http://gadm.org GADM] in Vietnam ===
+Mentor: Fran
+
+e.g. using [http://en.wikipedia.org/wiki/Vietnam#Administrative_subdivisions Wikipedia]
  * see attached spreadsheet [http://eden.sahanafoundation.org/raw-attachment/wiki/Projects/GCI/VNM_adm4.7z VNM_adm4.7z] (L1 has been done, focus on L2 1st, then L3, then finally L4 if you can)
-
+{{{
+table = db.gis_location
+query = (table.level == "L1")
+db(query & (table.code == "3289")).update(name="Bắc Trung Bộ (North Central Coast)")
+db(query & (table.code == "3290")).update(name="Đông Bắc (North East)")
+db(query & (table.code == "3291")).update(name="đồng bằng sông Cửu Long (Mekong River Delta)")
+db(query & (table.code == "3292")).update(name="Đồng Bằng Sông Hồng (Red River Delta)")
+db(query & (table.code == "3293")).update(name="Đông Nam Bộ (South East)")
+db(query & (table.code == "3294")).update(name="Nam Trung Bộ (South Central Coast)")
+db(query & (table.code == "3295")).update(name="Tây Bắc (North West)")
+db(query & (table.code == "3296")).update(name="Tây Nguyên (Central Highlands)")
+db.commit()
+}}}
 == '''(6.0) Training''' ==
 * 2 x Construct FAQ (From personal experience, mailing list, IRC)