08-13-2016, 04:12 PM
(06-15-2016, 04:20 PM)Pheidippides Wrote: Thanks to Zanate over on the cycling thread pointing out the that the City of Waterloo's active transportation counters on their trails was available via their open data portal I have been playing around with visualizing the data in Tableau.
Feel free to explore:
https://public.tableau.com/views/ActiveT...n?:embed=y&:display_count=yes&:showTabs=y
The data is not a real-time feed so I'll have to manually download the data every month, but it currently up to 31-May-2016.
I'm still new to Tableau so let me know if you see anything wonky and I'll try and fix it!
As an update, the City of Waterloo trail counter data now refreshed daily. I'm still trying to figure out how to read it in to Tableau (public) automatically (rather than downloading it in excel format each day).
Also, the City of Kitchener assured me at the end of June that their trail data would be made open data in about 6 weeks, which should be any day now. I will try to add that data in as well as soon as it is out.
Everyone move to the back of the bus and we all get home faster.