[[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:
== 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 or Tehsil (a sub region within a district) and search for the Union Councils within the Tehsil.
 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
  * 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
  * 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)

||[http://www.nrb.gov.pk/lg_election/union.asp?district=1 01]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=2&dn=Attock 02]||Punjab||Attock||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=3&dn=Bahawalpur 03]||Punjab||Bahawalpur||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=4&dn=Bhakkar 04]||Punjab||Bhakkar||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=5 05]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=6 06]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=7&dn=DG%20Khan 07]||Punjab||DG Khan||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=8 08]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=9 09]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=10 10]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=11 11]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=12 12]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=13&dn=Jhang 13]||Punjab||Jhang||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=14 14]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=15&dn=Khushab 15]||Punjab||Khushab||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=16 16]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=17 17]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=18&dn=Layyah 18]||Punjab||Layyah||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=19&dn=Mianwali 19]||Punjab||Mianwali||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=20 20]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=21&dn=Multan 21]||Punjab||Multan (partial)||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=22&dn=Muzaffargarh 22]||Punjab||Muzaffargarh||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=23 23]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=24&dn=Okara 24]||Punjab||Okara||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=25 25]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=26 26]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=27&dn=Rajanpur 27]||Punjab||Rajanpur||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=28&dn=Rahim%20Yar%20Khan 28]||Punjab||Rahim Yar Khan||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=29 29]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=30 30]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=31 31]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=32 32]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=33 33]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=34 34]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=35 35]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=36 36]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=37 37]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=38 38]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=39 39]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=40 40]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=41 41]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=42 42]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=43 43]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=44 44]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=45 45]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=46 46]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=47 47]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=48 48]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=49 49]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=50 50]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=51 51]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=52 52]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=53 53]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=54 54]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=55 55]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=56 56]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=57 57]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=58 58]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=59 59]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=60 60]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=61 61]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=62 62]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=63 63]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=64 64]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=65 65]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=66 66]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=67 67]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=68 68]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=69 69]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=70 70]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=71 71]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=72 72]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=73 73]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=74 74]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=75 75]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=76 76]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=77 77]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=78 78]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=79 79]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=80 80]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=81 81]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=82 82]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=83 83]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=84 84]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=85 85]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=86 86]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=87 87]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=88 88]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=89 89]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=90 90]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=91 91]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=92 92]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=93 93]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=94 94]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=95 95]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=96 96]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=97 97]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=98 98]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=99 99]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=100 100]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=101 101]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=102 102]||?||?||
||[http://www.nrb.gov.pk/lg_election/union.asp?district=103 103]||?||?||

----
[wiki:Pakistan]

[wiki:UserGuidelinesGISData#ImportData]