Changes between Version 124 and Version 125 of GIS/Data

Timestamp:

10/24/17 11:37:44 (5 years ago)

Author:

Fran Boon

Comment:

+CO

GIS/Data

@@ -369 +369 @@
 db.commit()
 filename = "CL_L3.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
+
+=== Colombia ===
+Admin Boundaries:
+* [http://eden.sahanafoundation.org/downloads/CO_Lx.7z CO_Lx.7z]
+
+Source is [https://data.humdata.org/dataset/colombia-administrative-boundaries-levels-0-3 HDX].
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d CO_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 = "CO_L0.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "CO_L1.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "CO_L2.csv"
 File = open(filename, "r")
 resource.import_xml(File, format="csv", stylesheet=stylesheet)