I’ve had a bit of fun recently with visualising some open data from onderwijs.vlaanderen.be where I downloaded the address list of flemish schools for kindergarten and “lower” schools.
- imported the csv list via “base” in an sqlite database
- added longitude and latitude fields to the db
- wrote a small script that used geopy to query google for each address and add the coordinates to the db
- then created another small script using pygmaps to create a custom html file which includes the necessary coordinates for each point on the google map.
The result is that I never knew how many schools there were in Vlaanderen !
You can read more in the original post (in Flemish) that I made on the dataconnect website, where I advertise for my web site design and consultancy. For the full map, click on the above image to go there.