[[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 * 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=Panjgur Panjgur]|| ||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]