Import School Data from OpenData Kenya

[mikelmaron]

Here's OpenDataKE data on primary and secondary schools https://www.opendata.go.ke/Education/Nairobi-Primary-and-Secondary-Schools/5rfy-ghjf https://www.opendata.go.ke/Education/Kenya-Primary-Schools-2007/p452-xb7c https://www.opendata.go.ke/Education/Kenya-Secondary-Schools-2007/i6vz-a543

[mikelmaron]

Socrata does not export in standard formats. Process to convert to GeoJSON, covering only Nairobi, is as follows.

• Export as CSV form Socrata

https://github.com/mapkibera/education/blob/master/data/Kenya_Primary_Schools__2007.csv

• The location is in a Geolocation column with format "(-0.525169, 37.017411)".
• This perl oneliner converts to seperate columns

cat Kenya_Primary_Schools__2007.csv  | perl -pi.back -e 's/\"\((.*), (.*)\)\"/$1,$2/g;' > Kenya_Primary_Schools__2007_geo.csv

https://github.com/mapkibera/education/blob/master/data/Kenya_Primary_Schools__2007_geo.csv

• Also manually edit the single column into two Latitude,Longitude

This part could be scripted, but just did manually for now.

• Now open in QGIS as a "Delimited Text Layer". Also open the OpenStreetMap schools GeoJSON https://github.com/mapkibera/education/blob/master/data/osm-schools.geojson
• Select points from the csv layer similar to boundary of OSM data.
• Right click on layer, and "Save Selection As" a GeoJSON file.

https://github.com/mapkibera/education/blob/master/data/Kenya_Primary_Schools_2007_Nairobi.geojson