Changes between Version 50 and Version 51 of UserGuidelines/GIS/Data

Timestamp:

09/03/10 17:46:31 (14 years ago)

Author:

Fran Boon

Comment:

Pakistan example of using the new s3gis.import_csv() function

UserGuidelines/GIS/Data

@@ -55 +55 @@
 NB AS_WKT requires OGR v1.6+
 
-Some tools for importing locations from CSV files are available in {{{controllers/bulk_gis.py}}}
- * These will move to {{{controllers/importer.py}}}
-
+There is a function available in {{{modules/s3gis.py}}} to import from CSV.
+
+Example for Pakistan:
+{{{
+db.gis_location.truncate()
+# L0
+import csv
+csv.field_size_limit(2**20 * 10)  # 10 megs
+db.import_from_csv_file(open('L0.csv','rb'))
+db.commit()
+# L1
+gis.import_csv('pak_adm1.csv')
+db.commit()
+# L2
+db(db.gis_location.name=="Baluchistan").update(name="Balochistan")
+db(db.gis_location.name=="Northern Areas").update(name="Gilgit Baltistan")
+db(db.gis_location.name=="N.W.F.P.").update(name="Khyber Pakhtunkhwa")
+db(db.gis_location.name=="F.A.T.A.").update(name="FATA")
+db(db.gis_location.name=="F.C.T.").update(name="Islamabad")
+db(db.gis_location.name=="Azad Kashmir").update(name="AJK")
+gis.import_csv('pak_adm2.csv')
+db(db.gis_location.name=="Sind").update(name="Sindh")
+db(db.gis_location.name=="AJK").update(name="Pakistan Administered Kashmir")
+db(db.gis_location.name=="Islamabad").update(name="Federal Capital Territory")
+db(db.gis_location.name=="FATA").update(name="Federally Administered Tribal Areas")
+db.commit()
+# L2
+db(db.gis_location.name=="Islamabad Capital Territory").update(name="Islamabad")
+db(db.gis_location.name=="Jaccobabad").update(name="Jacobabad")
+db(db.gis_location.name=="Tando Allahyar").update(name="Tando Allah Yar")
+db(db.gis_location.name=="Qambar Shahdad kot").update(name="Qambar Shahdadkot")
+gis.import_csv('pak_adm3.csv')
+db(db.gis_location.name=="Islamabad").update(name="Islamabad Capital Territory")
+db(db.gis_location.name=="Tando Allah Yar").update(name="Tando Allahyar")
+db(db.gis_location.name=="Qambar Shahdadkot").update(name="Qambar Shahdad Kot")
+db.commit()
+}}}
 === WFS ===
 It is possible to use the WFS Plugin to get data into qGIS & thence export into other formats.