Changes between Version 6 and Version 7 of GIS/Data

Timestamp:

11/07/13 14:59:29 (12 years ago)

Author:

Fran Boon

Comment:

VN_Lx

GIS/Data

@@ -33 +33 @@
 db.commit()
 import_file = "IN_L3.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
+
+=== Vietnam ===
+Admin Boundaries:
+* [http://eden.sahanafoundation.org/downloads/VN_Lx.7z VN_Lx.7z]
+
+These have come originally from [http://gadm.org GADM] but with their L1 removed (so we use their L2 as our L1, etc)
+* GADM file has terrible problems with place names: at least 3 different encodings!
+* These have mostly been resolved & the file contains place names with no diacritics (to make it easier for non-Vietnamese to search for such places) as well as Vi name_l10n
+* Many updated boundaries from http://gis.chinhphu.vn by selecting the place & then using this JS:
+{{{
+points = plHighlight[0].latlngs[0];
+output = 'POLYGON ((';
+for (var i=0; i < points.length; i++) {
+    p = points[i];
+    output += p.longitude;
+    output += ' ';
+    output += p.latitude;
+    output += ',';
+}
+output = output.slice(0, -1);
+output += '))';
+}}}
+or
+{{{
+output = 'MULTIPOLYGON (((';
+points = plHighlight[0].latlngs[0];
+for (var i=0; i < points.length; i++) {
+    p = points[i];
+    output += p.longitude;
+    output += ' ';
+    output += p.latitude;
+    output += ',';
+}
+output = output.slice(0, -1); // Strip comma
+output += ')),((';
+points = plHighlight[1].latlngs[0];
+for (var i=0; i < points.length; i++) {
+    p = points[i];
+    output += p.longitude;
+    output += ' ';
+    output += p.latitude;
+    output += ',';
+}
+output = output.slice(0, -1); // Strip comma
+output += ')))';
+}}}
+& then converted to WGS84 using:
+{{{
+ogr2ogr -f CSV CSV '.\VN2000 Polygons.csv' -s_srs EPSG:3405 -t_srs EPSG:4326 -lco GEOMETRY=AS_WKT
+}}}
+* Old boundaries have been left and start / end dates have been added from Wikipedia.
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d VN_Lx.7z
+python web2py.py -S eden -M
+
+auth.override = True
+resource = s3db.resource("gis_location")
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
+import_file = "VN_L0.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "VN_L1.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "VN_L2.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "VN_L3.csv"
 File = open(import_file, "r")
 resource.import_xml(File, format="csv", stylesheet=stylesheet)