We need a geocoding script

kartoza / least-cost-electrification-somalia

Global Electrification Platform for Global

1 stars 0 forks source link

We need a geocoding script #18

Open timlinux opened 3 years ago

timlinux commented 3 years ago

The script should take as input a CSV file containing

District, Village, Lon, Lat

It should use nominatum API to return the best spatial level coordinate if the lat and lon are not populated.

https://nominatim.openstreetmap.org/ui/search.html?q=Dharkenley

timlinux commented 3 years ago

Create a script to go through the file:

If the lat lon are present, write those out to the new file If not do a nominatum lookup on village If no result on village, do a lookup on district For the returned result, take the centerpoint and populate the lat lon

Write everything out to a new file with same content as original but lat lon populated

timlinux commented 3 years ago

We need to do this for

[x] primary schools - https://cloud.kartoza.com/f/34172 (requires authenticated user)
[x] high schools
[x] hospitals

meomancer commented 3 years ago

hi @timlinux here is the output from using nominatim https://cloud.kartoza.com/f/36305

But found that some of data are outside of somalia And those data are from original one (that already has lat/lon, but wrong one) Selection_039

AndreasSahlberg commented 3 years ago

Thank you for this @meomancer!

Could you please run the script also for secondary schools available here, and send a message on Slack when done: https://drive.google.com/drive/u/0/folders/1imFibs2NdrvciD1SzOHte5pPpNstnomX

Recon is also working on collecting the same data for health facilities.

meomancer commented 3 years ago

hi @AndreasSahlberg @timlinux the secondary schools already updated: https://cloud.kartoza.com/f/38729

AndreasSahlberg commented 3 years ago

Awesome, thank you @meomancer ! Could you please run these two as well? puntland_primary.csv puntland_secondary.csv

They are from a different source (http://www.moepuntland.com/primary/, http://www.moepuntland.com/secondary/). I have tried to put them in the same format with the required columns, using the school name as village. Let me know if there are any issues

meomancer commented 3 years ago

@AndreasSahlberg puntland_primary : https://cloud.kartoza.com/f/38844 puntland_secondary : https://cloud.kartoza.com/f/38842

meomancer commented 3 years ago

hi @timlinux @AndreasSahlberg i think this is done?

AndreasSahlberg commented 3 years ago

Thanks @meomancer! I have moved thid to "Review" in the project. I think we get some 70-80% accuracy, there are probably some manual fixes that can be applied to increase it by ~10%.