Here is a list of possible sources for the datasets we’ll be using.
- https://open.ottawa.ca
- https://data.ontario.ca/
- https://search.open.canada.ca/opendata/
- https://data.ottawapolice.ca/
- Free copies of previously released access-to-information requests: https://open.canada.ca/en/search/ati
- Analytics on the open data portal: https://open.canada.ca/en/content/open-government-analytics
?
Facility Hours spent after being admitted City Avg wait times after triage (hours)
CHEO 11.6 Ottawa 2.3
Queensway-Carleton Hospital 13 Ottawa 3.5
“Sault Area Hospital-Sault Ste. Marie ” 29.3 ottawa 2.7
“Hopital Montfort ” 14.3 Ottawa 2.4
“Ottawa Hospital (The)-Civic Site ” 17.6 Ottawaaaaa 2.6
“Perth And Smiths Falls District Hospital – Perth Site ” 19.2 Perth 1.8
“Ottawa Hospital (The)-General Site ” 20.3 Ottawa 3.4
Messy Data: Ottawa Red Light Camera Violations 2024
Clean Data changes:
– Removed rows without any violations
– Fixed inconsistent capitalization including added Abbrevations
– Removed columns with unneeded data (Longitutde, Latitude, installation year)
– Better headings
Question: Which intersation in Ottawa seen the most red light violation since 2021
Next Steps: I plan on calculating the yearly changes per intersection to find the ones with the most violations and also identify potential reasons.
Messy Data: Ottawa Red Light Camera Violations 2024
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::red-light-camera-violations-2024
Clean Data changes:
– Removed rows without any violations
– Fixed inconsistent capitalization including added Abbrevations
– Removed columns with unneeded data (Longitutde, Latitude, installation year)
– Better headings
Question: Which intersation in Ottawa seen the most red light violation since 2021
Next Steps: I plan on calculating the yearly changes per intersection to find the ones with the most violations and also identify potential reasons.