City of Windsor’s Open Data: Map of Libraries, Arenas, Community Centres & Heritage Sites
This map uses open data from the City of Windsor Open Data Catalogue. If you’re interested in the process used to make this map I’ve included step-by-steps at the bottom of the page. Drag and zoom to explore.
Key to icons:
 |
Large red = Community Centres |
 |
Large purple = Libraries |
 |
Large blue = Arenas |
 |
Small green = Heritage Sites (listed & designated) |
Process
This is how I made this map, but not exactly what I’d do next time. See note below.
- download csv files from the City of Windsor Site
- refine data using Excel* (see note below): columns were in different order on different spreadsheets, not all included all columns, added data type and icon type.
- import all spreadsheets into Google Fusion Tables
- modify data to recognize lat & long coordinates as Location
- Visualize map to view the data points on GoogleMaps.
- Embed map in blog.
- Share!
*Next time I plan to use Google Refine to clean the data. Working across multiple spreadsheets was a pain.
Total time to make the map: 30 mins.
21 February 2011, 1:25 am
[…] This post was mentioned on Twitter by John Foliot and Candace Nast, Miriam Posner. Miriam Posner said: RT @candace_nast: Here's a (very brief) description of how I used Fusion Tables & #opendata to map bits of Windsor, ON http://bit.ly/hIAuVr […]