[[TOC]]
= Pakistan Union Councils =
We would like to have all the [PakistanUserGuide#LocationsHierarchy 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:
 * [http://bit.ly/pkflood_kp Khyber Pakhtunkhwa]  Province (also used by OSM)
 * [https://spreadsheets.google.com/ccc?key=0AgESuewSG-wodEd2X19NV0ZpbjlRWWhHOFRrbXVkWWc&hl=en_GB&authkey=CLHCw_YH#gid=0 Punjab] Province
 * [https://spreadsheets.google.com/ccc?key=0AgESuewSG-wodGUtZUhrOUlQYmdQYlQtSFEzWm1ORlE&hl=en_GB&authkey=CL_SpSQ 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').
 1. Enter each Union Council in a new row in the spreadsheet, which includes correct Tehsil (or District if that's all that is available)
 1. Add the lat and lon, if available, and the Source (geonames_id &/or Wikipedia URL)
 1. 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 [http://www.fallingrain.com/world/PK/ Falling Rain] or [http://www.geonames.org Geonames]
{{{
#!html
<form name="searchForm" method="GET" action="http://www.geonames.org/advanced-search.html?">
<input name="q" size="40" value="" type="text">
<input type="hidden" name="country" value="PK">
<input type="hidden" name="featureClass" value="P">
<input type="hidden" name="fuzzy" value="0.6">
<input type="submit" value="Search Geonames">
</form>
}}}
  * If automating the Geonames, it would be a great longer-term investment to add support to the [http://bazaar.launchpad.net/~flavour/sahana-eden/trunk/annotate/head:/modules/s3gis.py#L3614 core GeoCoder API] with an option to work offline ([http://bazaar.launchpad.net/~flavour/sahana-eden/trunk/annotate/head:/modules/s3gis.py#L742 download routine]) or online.
 * Yahoo WoE
  * [http://eden.sahanafoundation.org/wiki/PakistanDataEntry/pakistan.hierarchy.yahoo.txt Processed] (doesn't appear too useful)
  * [wiki:UserGuidelinesGISData#Yahoo 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||[http://www.nrb.gov.pk/lg_election/union.asp?district=1&dn=Lahore Lahore]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=2&dn=Attock Attock]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=3&dn=Bahawalpur Bahawalpur]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=4&dn=Bhakkar Bhakkar]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=5&dn=Bahawalnagar Bahawalnagar]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=6&dn=Chakwal Chakwal]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=7&dn=DG%20Khan DG Khan]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=8&dn=Faisalabad Faisalabad]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=9&dn= 09]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=10&dn= 10]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=11&dn= 11]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=12&dn= 12]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=13&dn=Jhang Jhang]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=14&dn=Kasur Kasur]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=15&dn=Khushab Khushab]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=16&dn= 16]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=17&dn= 17]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=18&dn=Layyah Layyah]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=19&dn=Mianwali Mianwali]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=20&dn= 20]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=21&dn=Multan Multan (partial)]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=22&dn=Muzaffargarh Muzaffargarh]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=23&dn= 23]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=24&dn=Okara Okara]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=25&dn= 25]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=26&dn= 26]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=27&dn=Rajanpur Rajanpur]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=28&dn=Rahim%20Yar%20Khan Rahim Yar Khan]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=29&dn= 29]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=30&dn= 30]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=31&dn= 31]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=32&dn= 32]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=33&dn=Toba%20Tek%20Singh Toba Tek Singh]||
||Punjab||[http://www.nrb.gov.pk/lg_election/union.asp?district=34&dn=Vehari Vehari]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=35&dn=Malir Malir]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=36&dn=Hyderabad Hyderabad]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=37&dn=Dadu Dadu]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=38&dn=Thatta Thatta]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=39&dn=Badin Badin]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=40&dn=Mirpur%20Khas Mirpur Khas]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=41&dn=Sanghar Sanghar]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=42&dn=Tharparkar Tharparkar]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=43&dn=Sukkur Sukkur]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=44&dn=Nawabshah Nawabshah]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=45&dn=Naushahro%20Feroze Naushahro Feroze]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=46&dn=Khairpur Khairpur]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=47&dn=Ghotki Ghotki]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=48&dn=Larkana Larkana]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=49&dn=Shikarpur Shikarpur]||
||Sindh||[http://www.nrb.gov.pk/lg_election/union.asp?district=50&dn=Jacobabad Jacobabad]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=51&dn=Peshawar Peshawar]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=52&dn=Charsadda Charsadda]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=53&dn=Mardan Mardan]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=55&dn=DI%20Khan DI Khan]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=57&dn=Lakki%20Marwat Lakki Marwat]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=58&dn=Bannu Bannu]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=59&dn=Karak Karak]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=60&dn=Hangu Hangu]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=61&dn=Kohat Kohat]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=63&dn=Swabi Swabi]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=66&dn=Shangla Shangla]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=67&dn=Swat Swat]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=68&dn=Upper%20Dir Upper Dir]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=69&dn=Lower%20Dir Lower Dir]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=70&dn=Chitral Chitral]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=71&dn=Kohistan Kohistan]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=72&dn=Battagram Battagram]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=73&dn=Mansehra Mansehra]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=74&dn=Abbottabad Abbottabad]||
||Khyber Pakhtunkhwa||[http://www.nrb.gov.pk/lg_election/union.asp?district=75&dn=Haripur Haripur]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=76&dn=Quetta Quetta]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=77&dn=Kech Kech]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=78&dn=Khuzdar Khuzdar]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=79&dn= 79]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=80&dn=Pishin Pishin]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=81&dn=Lasbela Lasbela]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=82&dn= 82]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=83&dn=Zhob Zhob]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=84&dn=Nasirabad Nasirabad]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=85&dn=Kalat Kalat]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=86&dn= 86]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=87&dn= 87]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=88&dn= 88]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=89&dn= 89]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=90&dn= 90]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=91&dn=Sibi Sibi]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=92&dn=Mastung Mastung]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=93&dn= 93]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=94&dn=Kohlu Kohlu]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=95&dn=Ziarat Ziarat]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=96&dn=Dera%20Bugti Dera Bugti]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=97&dn=Jhal%20Magsi Jhal Magsi]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=98&dn=Barkhan Barkhan]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=99&dn= 99]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=100&dn=Bolan Bolan]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=101&dn=Musakhel Musakhel]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=102&dn= 102]||
||Balochistan||[http://www.nrb.gov.pk/lg_election/union.asp?district=103&dn=Nushki Nushki]||

== Import Process ==

The data is being imported using this technique:
 * [wiki:UserGuidelinesGISData#Shapefiles]

----
[wiki:Pakistan]

[wiki:UserGuidelinesGISData#ImportData]