Pakistan Union Councils

We would like to have all the Locations hierarchy for Pakistan populated in the Sahana database (although it would also be available for OpenStreetMap & Ushahidi). This will allow easy un-duplicated data-entry for field users & also allow us to proper Reporting.

We already have Levels 1-3 of the hierarchy (Provinces, Districts & Tehsils). What we're missing are the Union Councils (L4):

Instructions

1. Open the spreadsheet for:

• ​Khyber Pakhtunkhwa Province (also used by OSM)
• ​Punjab Province
• ​Other Provinces

1. Choose a District and search for the Union Councils within the Tehsils (the best source of data for this is the Pakistan government source at the bottom of the page - although there's no front-end to the data I know of, so need to open up pages mostly 'blind').
2. Enter each Union Council in a new row in the spreadsheet, which includes correct Tehsil (or District if that's all that is available)
3. Add the lat and lon, if available, and the Source (geonames_id &/or Wikipedia URL)
4. Putting any villages which you know are in a specific Union Council would be even better.

• We have many villages in Punjab which just need Lat/Lons, looking those up in Geonames (& cross-checking the hierarchy using spatial checks would be ideal)

Data Sources

• Wikipedia (there are many wiki pages currently not linked well - improving that too could help everyone!):
  • ​http://en.wikipedia.org/wiki/Union_councils_of_Pakistan
  • ​http://en.wikipedia.org/wiki/Districts_of_Pakistan
  • ​http://en.wikipedia.org/wiki/List_of_talukas_of_Sindh
  • e.g. ​http://en.wikipedia.org/wiki/Okara_District#Administration
• Lat/Lons for villages from ​Falling Rain or ​Geonames
  • If automating the Geonames, it would be a great longer-term investment to add support to the ​core GeoCoder API with an option to work offline (​download routine) or online.
• Yahoo WoE
  • Processed (doesn't appear too useful)
  • Raw
• Pakistan Government
  • ​http://www.statpak.gov.pk/depts/pco/statistics/admin_unit/admin_list_tehsil.html
  • Khyber Pakhtunwa District, Tehsil and Union code Reference Maps: ​http://www.pdma.gov.pk/documents/
  • Balochistan: ​http://www.bemis.edu.pk/LIST%20of%20School.xls
  • ​http://www.nrb.gov.pk/lg_election/lge_03.asp (lists totals, so you can see how much progress we're making)

Punjab	​Lahore
Punjab	​Attock
Punjab	​Bahawalpur
Punjab	​Bhakkar
Punjab	​Bahawalnagar
Punjab	​Chakwal
Punjab	​DG Khan
Punjab	​Faisalabad
Punjab	​09
Punjab	​10
Punjab	​11
Punjab	​12
Punjab	​Jhang
Punjab	​Kasur
Punjab	​Khushab
Punjab	​16
Punjab	​17
Punjab	​Layyah
Punjab	​Mianwali
Punjab	​20
Punjab	​Multan (partial)
Punjab	​Muzaffargarh
Punjab	​23
Punjab	​Okara
Punjab	​25
Punjab	​26
Punjab	​Rajanpur
Punjab	​Rahim Yar Khan
Punjab	​29
Punjab	​30
Punjab	​31
Punjab	​32
Punjab	​Toba Tek Singh
Punjab	​Vehari
Sindh	​Malir
Sindh	​Hyderabad
Sindh	​Dadu
Sindh	​Thatta
Sindh	​Badin
Sindh	​Mirpur Khas
Sindh	​Sanghar
Sindh	​Tharparkar
Sindh	​Sukkur
Sindh	​Nawabshah
Sindh	​Naushahro Feroze
Sindh	​Khairpur
Sindh	​Ghotki
Sindh	​Larkana
Sindh	​Shikarpur
Sindh	​Jacobabad
Khyber Pakhtunkhwa	​Peshawar
Khyber Pakhtunkhwa	​Charsadda
Khyber Pakhtunkhwa	​Mardan
Khyber Pakhtunkhwa	​DI Khan
Khyber Pakhtunkhwa	​Lakki Marwat
Khyber Pakhtunkhwa	​Bannu
Khyber Pakhtunkhwa	​Karak
Khyber Pakhtunkhwa	​Hangu
Khyber Pakhtunkhwa	​Kohat
Khyber Pakhtunkhwa	​Swabi
Khyber Pakhtunkhwa	​Shangla
Khyber Pakhtunkhwa	​Swat
Khyber Pakhtunkhwa	​Upper Dir
Khyber Pakhtunkhwa	​Lower Dir
Khyber Pakhtunkhwa	​Chitral
Khyber Pakhtunkhwa	​Kohistan
Khyber Pakhtunkhwa	​Battagram
Khyber Pakhtunkhwa	​Mansehra
Khyber Pakhtunkhwa	​Abbottabad
Khyber Pakhtunkhwa	​Haripur
Balochistan	​Quetta
Balochistan	​Kech
Balochistan	​Khuzdar
Balochistan	​Killa Abdullah
Balochistan	​Pishin
Balochistan	​Lasbela
Balochistan	​Loralai	​http://en.wikipedia.org/wiki/Loralai_District
Balochistan	​Zhob
Balochistan	​Nasirabad	​http://en.wikipedia.org/wiki/Nasirabad_District
Balochistan	​Kalat
Balochistan	​Panjgur	​http://en.wikipedia.org/wiki/Panjgur_District
Balochistan	​Chagai	​http://en.wikipedia.org/wiki/Chagai_District
Balochistan	​Kharan
Balochistan	​Killa Saifullah
Balochistan	​Gwadar	​http://en.wikipedia.org/wiki/Gwadar_District
Balochistan	​Sibi
Balochistan	​Mastung
Balochistan	​93
Balochistan	​Kohlu
Balochistan	​Ziarat
Balochistan	​Dera Bugti
Balochistan	​Jhal Magsi
Balochistan	​Barkhan
Balochistan	​99
Balochistan	​Bolan
Balochistan	​Musakhel
Balochistan	​Nushki

Import Process

The data is being imported using this technique:

• UserGuidelinesGISData

---

Pakistan

UserGuidelinesGISData