Changes between Version 130 and Version 131 of GIS/Data

Timestamp:

10/24/17 15:46:39 (5 years ago)

Author:

Fran Boon

Comment:

+EC

GIS/Data

@@ -493 +493 @@
 db.commit()
 filename = "DO_L2.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
+
+=== Ecuador ===
+Admin Boundaries:
+* [http://eden.sahanafoundation.org/downloads/EC_Lx.7z EC_Lx.7z]
+
+Source is [http://gadm.org GADM] since the [https://data.humdata.org/dataset/ecuador-admin-level-1-boundaries HDX] version is based on an older export and is harder to use.
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d EC_Lx.7z
+python web2py.py -S eden -M
+
+auth.override = True
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
+resource = s3db.resource("gis_location")
+filename = "EC_L0.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "EC_L1.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "EC_L2.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "EC_L3.csv"
 File = open(filename, "r")
 resource.import_xml(File, format="csv", stylesheet=stylesheet)