Let's use data to make Ottawa better

Improving collection of Ottawa's coyote data

The City currently collects data on coyote sightings using an online form (https://so311.serviceottawa.ca/selfserve/?reqId=2000190&lang=en). In its current iteration however, the form does not prompt the user for any details that will be useful to inform the 2023-planned development of a Coyote Management Plan. In reality, the fact that a Plan can be developed without yet having any of this information is a real concern. Modifications to the form to obtain specific data such as: - date, time, and duration of the interaction (is it mating or pupping season?) - type of interaction (i.e. sighting, encounter, incident, pet attack: Attended/Unattended, Human Attack, etc) - presence of attractants (garbage, intentional wildlife feeding, pet food) - if it involved a pet was the pet leashed? - human behaviour prior to and after the interaction and be worded carefully to avoid creating any potential bias (the form currently refers to a report of the "problem" and asks the user to explain the "issue").

Link data to Term of Council Priorities. Include the Benchmarks,Metrics and Data that enable trend analysis.Track progress to key goals.

PotSnap: Messenger based high speed pothole reporting

http://potsnap.ca/ https://www.facebook.com/PotSnap https://m.me/PotSnap https://www.cbc.ca/news/canada/ottawa/ottawa-pothole-reporting-fill-app-1.5073348 PotSnap is an Facebook Messenger based, automated pothole reporting tool. Potsnap is very simple to use. It only asks a few simple questions and then reports your pothole anonymously to the City of Ottawa. PotSnap is faster then any other means and hopes to be the tool of choice for Canada’s Pothole hunters. PotSnap is also a proof of concept of a first party tool, for the Universal Reporting System. It demonstrates the use of an independent API to service Endpoints with service requests, using the Open 311 framework provided by the City of Ottawa. The URT expands on the base provided by the City and provides richer feature set that focuses on reducing and eliminating common pain points for governance. Created by Citizen Softworks from Bayshore with ❤

https://infograph.venngage.com/ps/JprJTOw1GyQ/wallacethea_coms2200_infographick

An infographic on a case study demonstrating how large-scale construction makes the roads safer

Ottawa Traffic Camera interface

I have created a site that allows you to display multiple traffic cameras at once based on a street name filter. https://ottawawebcams.000webhostapp.com/

The Former Landfills dataset is missing

The former landfill dataset from the old open data portal is no longer available (it seems it got lost in the move to the new portal). Can you please re-add? (it used to be here: http://data.ottawa.ca/dataset/former-landfills)

Use OpenStreetMap base layer

The OpenStreetMap community in Ottawa is very active and works to quickly include updates from open.ottawa.ca into the base map in a timely fashion. The old CKAN based portal uses OSM base map. The new open.ottawa.ca should also use OSM base map. In the ESRI platform, the city can customize which OSM elements appear on the map using vector tiles. https://www.esri.com/arcgis-blog/products/arcgis-living-atlas/mapping/new-osm-vector-basemap/

More data should be downloadable

Datasets used to create graphs and infographics should be available for download

Use portal to track progress to key O.P. and Master Plan goals

Improve the URLs

The URL for construction projects is https://open.ottawa.ca/datasets/b2395e56baf148ee88eef9e20c43e12c_1/data. All those jumble of alpha-numeric characters are not intuitive. https://open.ottawa.ca/datasets/construction/data or similar would be much better

Street lights dataset accuracy needs an update

https://open.ottawa.ca/datasets/street-lights should be 0-30m accuracy, not 0-2m

List of buildings by rental price

Approximate price could work too.

Real time traffic accident data

The city should release real-time traffic accident data. Occasionally, (usually during a winter storm) the Ottawa Police will announce on twitter how many traffic accidents have been reported so far that day. I would like to get consistent real-time access to that data to provide useful information about how dangerous each day's commute is. I run the @YOW_Weather twitter account that uses real-time weather data to produce alerts and I would like to use real-time traffic accident data to do the same thing. This could be very useful information to allow people to decide whether they should drive during any particular winter storm.

Revenue per property (or equivalent)

The city collects taxes on all private properties in order to fund city services. While the aggregate municipal tax revenue is reported in the annual budgets, the breakdown of municipal tax levied by property (or related but less accurate information such as assessed land value, assessed building value etc) is not easily available at scale, even for previous tax years. Ideally, this information would be added to the Municipal Address Points Dataset. One potential use of this information is to compare the amount of tax levied per property to the size (area) of property to determine the financial productivity and health of the city.

Add RSS feed for engage ottawa

For any topic in engage ottawa I should be able to get an RSS feed for any new topics posted. Also there should be an RSS feed to know about all the new topics that area available for engagement.