Changes between Version 98 and Version 99 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
09/18/10 07:23:39 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v98 v99  
    118118# L4
    119119db(table.name == "Noorpur Tehsil").update(name="Noorpur Thal Tehsil")
    120 jhang = db(table.name == "Jhang").select(table.id, limitby=(0, 1)).first().id
     120jhang = db((table.name == "Jhang") & (table.level==L2)).select(table.id, limitby=(0, 1)).first().id
    121121table.insert(name="Ahmadpur Sial", parent=jhang, level="L3", url="http://en.wikipedia.org/wiki/Ahmedpur_Sial_Tehsil")
    122122gis.import_csv("punjab_l4.csv", check_duplicates=False)
     
    124124db(table.name == "Mirwah Taluka").update(name="Thari Mirwah Taluka")
    125125db(table.name == "Shah Bunder Taluka").update(name="Shah Bandar Taluka")
    126 badin = db(table.name == "Badin").select(table.id, limitby=(0, 1)).first().id
     126badin = db((table.name == "Badin") & (table.level==L2)).select(table.id, limitby=(0, 1)).first().id
    127127table.insert(name="Talhar", parent=badin, level="L3", url="http://en.wikipedia.org/wiki/Talhar")
    128 jamshoro = db(table.name == "Jamshoro").select(table.id, limitby=(0, 1)).first().id
     128jamshoro = db((table.name == "Jamshoro") & (table.level==L2)).select(table.id, limitby=(0, 1)).first().id
    129129table.insert(name="Manjhand Taluka", parent=jamshoro, level="L3", url="http://en.wikipedia.org/wiki/Jamshoro_District")
    130130gis.import_csv("sindh_l4.csv", check_duplicates=False)
     
    132132db(table.name == "F.r Kala Dhaka").update(name="F.R. Kala Dhaka")
    133133db(table.name == "Martoong Tehsil").update(name="Martung Tehsil")
    134 dikhan = db(table.name == "D. I. Khan").select(table.id, limitby=(0, 1)).first().id
     134dikhan = db((table.name == "D. I. Khan") & (table.level==L2)).select(table.id, limitby=(0, 1)).first().id
    135135table.insert(name="Daraban Tehsil", parent=dikhan, level="L3")
    136136table.insert(name="Paroa Tehsil", parent=dikhan, level="L3")
     137upperdir = db((table.name == "Upper Dir") & (table.level==L2)).select(table.id, limitby=(0, 1)).first().id
     138table.insert(name="Barawal Tehsil", parent=upperdir, level="L3")
     139table.insert(name="Chapar Tehsil", parent=upperdir, level="L3")
     140table.insert(name="Dir Tehsil", parent=upperdir, level="L3")
     141table.insert(name="Khal Tehsil", parent=upperdir, level="L3")
     142table.insert(name="Kalkot Tehsil", parent=upperdir, level="L3")
     143table.insert(name="Wari Tehsil", parent=upperdir, level="L3")
    137144gis.import_csv("khyber_l4.csv", check_duplicates=False)
    138145db.commit()