Version 40 (modified by 14 years ago) ( diff ) | ,
---|
Table of Contents
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.
We already have Levels 1-3 of the hierarchy (Provinces, Districts & Tehsils). What we're missing are the Union Councils (L4):
Instructions
- Open the spreadsheet for:
- Khyber Pakhtunkhwa Province (also used by OSM)
- Punjab Province
- Other Provinces
- 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').
- Enter each Union Council in a new row in the spreadsheet, which includes correct Tehsil (or District if that's all that is available)
- Add the lat and lon, if available, and the Source (geonames_id &/or Wikipedia URL)
- 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!):
- Lat/Lons for villages from Falling Rain or Geonames
- If automating the Geonames, it would be a great longer-term investment to add support to the core GeoCoder API with an option to work offline (download routine) or online.
- Yahoo WoE
- 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 | Lahore | |
Punjab | Attock | |
Punjab | Bahawalpur | |
Punjab | Bhakkar | |
Punjab | Bahawalnagar | |
Punjab | Chakwal | |
Punjab | DG Khan | |
Punjab | Faisalabad | |
Punjab | 09 | |
Punjab | 10 | |
Punjab | 11 | |
Punjab | 12 | |
Punjab | Jhang | |
Punjab | Kasur | |
Punjab | Khushab | |
Punjab | 16 | |
Punjab | 17 | |
Punjab | Layyah | |
Punjab | Mianwali | |
Punjab | 20 | |
Punjab | Multan (partial) | |
Punjab | Muzaffargarh | |
Punjab | 23 | |
Punjab | Okara | |
Punjab | 25 | |
Punjab | 26 | |
Punjab | Rajanpur | |
Punjab | Rahim Yar Khan | |
Punjab | 29 | |
Punjab | 30 | |
Punjab | 31 | |
Punjab | 32 | |
Punjab | Toba Tek Singh | |
Punjab | Vehari | |
Sindh | Malir | |
Sindh | Hyderabad | |
Sindh | Dadu | |
Sindh | Thatta | |
Sindh | Badin | |
Sindh | Mirpur Khas | |
Sindh | Sanghar | |
Sindh | Tharparkar | |
Sindh | Sukkur | |
Sindh | Nawabshah | |
Sindh | Naushahro Feroze | |
Sindh | Khairpur | |
Sindh | Ghotki | |
Sindh | Larkana | |
Sindh | Shikarpur | |
Sindh | Jacobabad | |
Khyber Pakhtunkhwa | Peshawar | |
Khyber Pakhtunkhwa | Charsadda | |
Khyber Pakhtunkhwa | Mardan | |
Khyber Pakhtunkhwa | DI Khan | |
Khyber Pakhtunkhwa | Lakki Marwat | |
Khyber Pakhtunkhwa | Bannu | |
Khyber Pakhtunkhwa | Karak | |
Khyber Pakhtunkhwa | Hangu | |
Khyber Pakhtunkhwa | Kohat | |
Khyber Pakhtunkhwa | Swabi | |
Khyber Pakhtunkhwa | Shangla | |
Khyber Pakhtunkhwa | Swat | |
Khyber Pakhtunkhwa | Upper Dir | |
Khyber Pakhtunkhwa | Lower Dir | |
Khyber Pakhtunkhwa | Chitral | |
Khyber Pakhtunkhwa | Kohistan | |
Khyber Pakhtunkhwa | Battagram | |
Khyber Pakhtunkhwa | Mansehra | |
Khyber Pakhtunkhwa | Abbottabad | |
Khyber Pakhtunkhwa | Haripur | |
Balochistan | Quetta | |
Balochistan | Kech | |
Balochistan | Khuzdar | |
Balochistan | Killa Abdullah | |
Balochistan | Pishin | |
Balochistan | Lasbela | |
Balochistan | Loralai | http://en.wikipedia.org/wiki/Loralai_District |
Balochistan | Zhob | |
Balochistan | Nasirabad | |
Balochistan | Kalat | |
Balochistan | Panjgur | http://en.wikipedia.org/wiki/Panjgur_District |
Balochistan | Chagai | http://en.wikipedia.org/wiki/Chagai_District |
Balochistan | Kharan | |
Balochistan | 89 | |
Balochistan | 90 | |
Balochistan | Sibi | |
Balochistan | Mastung | |
Balochistan | 93 | |
Balochistan | Kohlu | |
Balochistan | Ziarat | |
Balochistan | Dera Bugti | |
Balochistan | Jhal Magsi | |
Balochistan | Barkhan | |
Balochistan | 99 | |
Balochistan | Bolan | |
Balochistan | Musakhel | |
Balochistan | 102 | |
Balochistan | Nushki |
Import Process
The data is being imported using this technique:
Note:
See TracWiki
for help on using the wiki.