[[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
}}} * 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&dn=Lahore 01]||Punjab||Lahore|| ||[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&dn=Bahawalnagar 05]||Punjab||Bahawalnagar|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=6&dn=Chakwal 06]||Punjab||Chakwal|| ||[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&dn=Faisalabad 08]||Punjab||Faisalabad|| ||[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 13]||Punjab||Jhang|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=14&dn=Kasur 14]||Punjab||Kasur|| ||[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&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 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&dn= 20]||Punjab||?|| ||[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&dn= 23]||Punjab||?|| ||[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&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 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&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 33]||Punjab||Toba Tek Singh|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=34&dn=Vehari 34]||Punjab||Vehari|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=35&dn=Malir 35]||Sindh||Malir|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=36&dn=Hyderabad 36]||Sindh||Hyderabad|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=37&dn=Dadu 37]||Sindh||Dadu|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=38&dn=Thatta 38]||Sindh||Thatta|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=39&dn=Badin 39]||Sindh||Badin|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=40&dn=Mirpur%20Khas 40]||Sindh||Mirpur Khas|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=41&dn=Sanghar 41]||Sindh||Sanghar|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=42&dn=Tharparkar 42]||Sindh||Tharparkar|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=43&dn=Sukkur 43]||Sindh||Sukkur|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=44&dn=Nawabshah 44]||Sindh||Nawabshah|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=45&dn=Naushahro%20Feroze 45]||Sindh||Naushahro Feroze|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=46&dn=Khairpur 46]||Sindh||Khairpur|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=47&dn=Ghotki 47]||Sindh||Ghotki|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=48&dn=Larkana 48]||Sindh||Larkana|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=49&dn=Shikarpur 49]||Sindh||Shikarpur|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=50&dn=Jacobabad 50]||Sindh||Jacobabad|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=51&dn=Peshawar 51]||Khyber Pakhtunkhwa||Peshawar|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=52&dn=Charsadda 52]||Khyber Pakhtunkhwa||Charsadda|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=53&dn=Mardan 53]||Khyber Pakhtunkhwa||Mardan|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=55&dn=DI%20Khan 55]||Khyber Pakhtunkhwa||DI Khan|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=57&dn=Lakki%20Marwat 57]||Khyber Pakhtunkhwa||Lakki Marwat|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=58&dn=Bannu 58]||Khyber Pakhtunkhwa||Bannu|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=59&dn=Karak 59]||Khyber Pakhtunkhwa||Karak|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=60&dn=Hangu 60]||Khyber Pakhtunkhwa||Hangu|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=61&dn=Kohat 61]||Khyber Pakhtunkhwa||Kohat|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=63&dn=Swabi 63]||Khyber Pakhtunkhwa||Swabi|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=66&dn=Shangla 66]||Khyber Pakhtunkhwa||Shangla|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=67&dn=Swat 67]||Khyber Pakhtunkhwa||Swat|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=68&dn=Upper%20Dir 68]||Khyber Pakhtunkhwa||Upper Dir|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=69&dn=Lower%20Dir 69]||Khyber Pakhtunkhwa||Lower Dir|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=70&dn=Chitral 70]||Khyber Pakhtunkhwa||Chitral|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=71&dn=Kohistan 71]||Khyber Pakhtunkhwa||Kohistan|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=72&dn=Battagram 72]||Khyber Pakhtunkhwa||Battagram|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=73&dn=Mansehra 73]||Khyber Pakhtunkhwa||Mansehra|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=74&dn=Abbottabad 74]||Khyber Pakhtunkhwa||Abbottabad|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=75&dn=Haripur 75]||Khyber Pakhtunkhwa||Haripur|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=76&dn=Quetta 76]||Balochistan||Quetta|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=77&dn=Kech 77]||Balochistan||Kech|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=78&dn=Khuzdar 78]||Balochistan||Khuzdar|| ||[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 80]||Balochistan||Pishin|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=81&dn=Lasbela 81]||Balochistan||Lasbela|| ||[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 83]||Balochistan||Zhob|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=84&dn=Nasirabad 84]||Balochistan||Nasirabad|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=85&dn=Kalat 85]||Balochistan||Kalat|| ||[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 91]||Balochistan||Sibi|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=92&dn=Mastung 92]||Balochistan||Mastung|| ||[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 94]||Balochistan||Kohlu|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=95&dn=Ziarat 95]||Balochistan||Ziarat|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=96&dn=Dera%20Bugti 96]||Balochistan||Dera Bugti|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=97&dn=Jhal%20Magsi 97]||Balochistan||Jhal Magsi|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=98&dn=Barkhan 98]||Balochistan||Barkhan|| ||[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 100]||Balochistan||Bolan|| ||[http://www.nrb.gov.pk/lg_election/union.asp?district=101&dn=Musakhel 101]||Balochistan||Musakhel|| ||[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 103]||Balochistan||Nushki|| == Import Process == The data is being imported using this technique: * [wiki:UserGuidelinesGISData#Shapefiles] ---- [wiki:Pakistan] [wiki:UserGuidelinesGISData#ImportData]