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

Timestamp:

09/06/10 15:25:55 (14 years ago)

Author:

Fran Boon

Comment:

Drop/Restore Indexes

UserGuidelines/GIS/Data

@@ -85 +85 @@
 Example for Pakistan:
 {{{
-db(db.gis_location.id<166).delete()
-db(db.gis_location.id>166).delete()
+tablename = "gis_location"
+table = db[tablename]
+db.executesql("DROP INDEX name__idx on %s;" % tablename)
+db(table.id<166).delete()
+db(table.id>166).delete()
 db.commit()
 # L0
@@ -97 +100 @@
 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")
+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(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(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(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")
+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(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(db.gis_location.name=="Leiah").update(name="Layyah")
-db(db.gis_location.name=="Leiah Tehsil").update(name="Layyah Tehsil")
-db(db.gis_location.name=="Kalur Kot Tehsil").update(name="Kallur Kot Tehsil")
-db(db.gis_location.name=="De-excluded Area").update(name="Tribal Area")
-db(db.gis_location.name=="De-excluded Area D.g Khan").update(name="Tribal Area")
-db.commit()
+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"
+db.executesql("CREATE INDEX %s__idx on %s(%s);" % (field, tablename, field))
 }}}
 === Yahoo ===