[[TOC]] = 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. == 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 (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://geonames.org Geonames] * 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]