wiki:PakistanUnionCouncils

Context Navigation

Version 39 (modified by Fran Boon, 14 years ago) ( diff )
--

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

Open the spreadsheet for:

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

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').
Enter each Union Council in a new row in the spreadsheet, which includes correct Tehsil (or District if that's all that is available)
Add the lat and lon, if available, and the Source (geonames_id &/or Wikipedia URL)
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!):
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
Balochistan	Zhob
Balochistan	Nasirabad
Balochistan	Kalat
Balochistan	Panjgur	http://en.wikipedia.org/wiki/Panjgur_District
Balochistan	Chagai	http://en.wikipedia.org/wiki/Chagai_District
Balochistan	Kharan
Balochistan	89
Balochistan	90
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	102
Balochistan	Nushki