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


Ignore:
Timestamp:
11/17/11 15:43:00 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Event/2011/GCI

    v39 v40  
    8585'''Reevaluate  : ''' [[BR]]
    8686
    87 * 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]
     87=== (5.4) Provide UTF8 names for Locations exported from [http://gadm.org GADM] in Vietnam ===
     88Mentor: Fran
     89
     90e.g. using [http://en.wikipedia.org/wiki/Vietnam#Administrative_subdivisions Wikipedia]
    8891 * 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)
    89 
     92{{{
     93table = db.gis_location
     94query = (table.level == "L1")
     95db(query & (table.code == "3289")).update(name="Bắc Trung Bộ (North Central Coast)")
     96db(query & (table.code == "3290")).update(name="Đông Bắc (North East)")
     97db(query & (table.code == "3291")).update(name="đồng bằng sông Cửu Long (Mekong River Delta)")
     98db(query & (table.code == "3292")).update(name="Đồng Bằng Sông Hồng (Red River Delta)")
     99db(query & (table.code == "3293")).update(name="Đông Nam Bộ (South East)")
     100db(query & (table.code == "3294")).update(name="Nam Trung Bộ (South Central Coast)")
     101db(query & (table.code == "3295")).update(name="Tây Bắc (North West)")
     102db(query & (table.code == "3296")).update(name="Tây Nguyên (Central Highlands)")
     103db.commit()
     104}}}
    90105== '''(6.0) Training''' ==
    91106* 2 x Construct FAQ (From personal experience, mailing list, IRC)