Mapping the City of Windsor’s Open Data

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:

red dot Large red = Community Centres
purple dot Large purple = Libraries
blue dot Large blue = Arenas
green-circle 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.

  1. download csv files from the City of Windsor Site
  2. 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.
  3. import all spreadsheets into Google Fusion Tables
  4. modify data to recognize lat & long coordinates as Location
  5. Visualize map to view the data points on GoogleMaps.
  6. Embed map in blog.
  7. 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.