Changes between Version 74 and Version 75 of UserGuidelines/GIS/Data

Timestamp:

09/06/10 15:27:22 (14 years ago)

Author:

Fran Boon

Comment:

PEP8 ;)

UserGuidelines/GIS/Data

@@ -88 +88 @@
 table = db[tablename]
 db.executesql("DROP INDEX name__idx on %s;" % tablename)
-db(table.id<166).delete()
-db(table.id>166).delete()
+db(table.id < 166).delete()
+db(table.id > 166).delete()
 db.commit()
 # L0
 import csv
 csv.field_size_limit(2**20 * 10)  # 10 megs
-db.import_from_csv_file(open('L0.csv','rb'))
+db.import_from_csv_file(open("L0.csv", "rb"))
 db.commit()
 # L1
-gis.import_csv('pak_adm1.csv')
+gis.import_csv("pak_adm1.csv")
 db.commit()
 # L2
-db(table.name=="Baluchistan").update(name="Balochistan")
-db(table.name=="Northern Areas").update(name="Gilgit Baltistan")
-db(table.name=="N.W.F.P.").update(name="Khyber Pakhtunkhwa")
-db(table.name=="F.A.T.A.").update(name="FATA")
-db(table.name=="F.C.T.").update(name="Islamabad")
-db(table.name=="Azad Kashmir").update(name="AJK")
-gis.import_csv('pak_adm2.csv')
-db(table.name=="Sind").update(name="Sindh")
-db(table.name=="AJK").update(name="Pakistan Administered Kashmir")
-db(table.name=="Islamabad").update(name="Federal Capital Territory")
-db(table.name=="FATA").update(name="Federally Administered Tribal Areas")
+db(table.name == "Baluchistan").update(name="Balochistan")
+db(table.name == "Northern Areas").update(name="Gilgit Baltistan")
+db(table.name == "N.W.F.P.").update(name="Khyber Pakhtunkhwa")
+db(table.name == "F.A.T.A.").update(name="FATA")
+db(table.name == "F.C.T.").update(name="Islamabad")
+db(table.name == "Azad Kashmir").update(name="AJK")
+gis.import_csv("pak_adm2.csv")
+db(table.name == "Sind").update(name="Sindh")
+db(table.name == "AJK").update(name="Pakistan Administered Kashmir")
+db(table.name == "Islamabad").update(name="Federal Capital Territory")
+db(table.name == "FATA").update(name="Federally Administered Tribal Areas")
 db.commit()
 # L2
-db(table.name=="Islamabad Capital Territory").update(name="Islamabad")
-db(table.name=="Jaccobabad").update(name="Jacobabad")
-db(table.name=="Tando Allahyar").update(name="Tando Allah Yar")
-db(table.name=="Qambar Shahdad kot").update(name="Qambar Shahdadkot")
-gis.import_csv('pak_adm3.csv')
-db(table.name=="Islamabad").update(name="Islamabad Capital Territory")
-db(table.name=="Tando Allah Yar").update(name="Tando Allahyar")
-db(table.name=="Qambar Shahdadkot").update(name="Qambar Shahdad Kot")
-db(table.name=="Leiah").update(name="Layyah")
-db(table.name=="Leiah Tehsil").update(name="Layyah Tehsil")
-db(table.name=="Kalur Kot Tehsil").update(name="Kallur Kot Tehsil")
-db(table.name=="De-excluded Area").update(name="Tribal Area")
-db(table.name=="De-excluded Area D.g Khan").update(name="Tribal Area")
+db(table.name == "Islamabad Capital Territory").update(name="Islamabad")
+db(table.name == "Jaccobabad").update(name="Jacobabad")
+db(table.name == "Tando Allahyar").update(name="Tando Allah Yar")
+db(table.name == "Qambar Shahdad kot").update(name="Qambar Shahdadkot")
+gis.import_csv("pak_adm3.csv")
+db(table.name == "Islamabad").update(name="Islamabad Capital Territory")
+db(table.name == "Tando Allah Yar").update(name="Tando Allahyar")
+db(table.name == "Qambar Shahdadkot").update(name="Qambar Shahdad Kot")
+db(table.name == "Leiah").update(name="Layyah")
+db(table.name == "Leiah Tehsil").update(name="Layyah Tehsil")
+db(table.name == "Kalur Kot Tehsil").update(name="Kallur Kot Tehsil")
+db(table.name == "De-excluded Area").update(name="Tribal Area")
+db(table.name == "De-excluded Area D.g Khan").update(name="Tribal Area")
 db.commit()
 field = "name"