Version 32 (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
- 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 | 79 |
Balochistan | Pishin |
Balochistan | Lasbela |
Balochistan | 82 |
Balochistan | Zhob |
Balochistan | Nasirabad |
Balochistan | Kalat |
Balochistan | 86 |
Balochistan | 87 |
Balochistan | 88 |
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.