Pat Bickerton
@pbickerton.bsky.social
60 followers 37 following 71 posts
I like hobbies, data, and hobbies that involve data. Opinions are my own. https://github.com/bickertonpa
Posts Media Videos Starter Packs
pbickerton.bsky.social
Bylaw officers should modernize their tools and move away from a complaint based model.

Example of modern tools. Storm sewer rates will soon be calculated by how much impermeable area you have on your property (asphalt, concrete, etc).The analysis involves aircraft imagery, GIS and AI tools.
Reposted by Pat Bickerton
sjamieit.bsky.social
I head again today from Ottawa By-law, they're no longer accepting reports for illegal driveway expansions or hardscaping or front yard parking. Apparently there are only 4 officers for these zoning issues and there are far too many reports than they can keep up with. They need more resources.
pbickerton.bsky.social
Yes I understand but resurfacing is not the same sewer repair. Just wanted to give you that information. Thanks for the reply.
pbickerton.bsky.social
You mentioned that the city will be digging up the sewers in 10-15 yrs. I assume you mean on Gladstone?

FYI the only "old" section of sewer is between Lyon and Kent (1935). The remaining sewer/water pipes on Gladstone were installed 1993-2016. Is the city really going to dig them up in 10-15 yrs?
pbickerton.bsky.social
Over at @strongtownsottawa.ca we've calculated the productivity of different development patterns in #OttCity. Tax per hectare is easy.

Lately, I've been estimating the cost of servicing. These numbers are much more abstract but it's been fun.

Here is some data I'm tracking.
pbickerton.bsky.social
I made an error in the original graph for Stittsville. The original graph said 85th percentile speed but it actually showed average speed. My bad :(

Here are corrected graphs for Stittsville.
* Average speed
* 85th percentile speed
* Speed limit compliance (%)
* High-end speeding (%)
pbickerton.bsky.social
City wide graphs of the effects of ASE camera installation on the percent of high-end speeders, and general speed limit compliance. These cameras work
pbickerton.bsky.social
More Automated Speed Enforcement (ASE) data for College Ward.

Once the cameras were installed, the percentage of high-end speeds drops dramatically and general speed limit compliance improves.

#OttCity
pbickerton.bsky.social
An interesting observation. Drivers took ~750 days to drop speeds by 10 kph at Greenbank and Meadowlands.

Cassidy and Old Richmond Rd cameras are newer (~100 days in service) and initial speeds are closer to the limit.

Does this mean that the effects of ASE extend beyond their immediate area.
pbickerton.bsky.social
Slightly improved chart. Speed limits are included in the legend.
pbickerton.bsky.social
#OttCity has open data on Automated Speed Enforcement (ACE). Below driver behaviour from Stittsville.

The data show that Stittsville drivers slowed down after each ASE camera was installed. The changes are lasting too.
pbickerton.bsky.social
#OttCity has open data on the effectiveness of Automated Speed Enforcement cameras.

The data show that once installed, drivers slow down and keep their speed down.
pbickerton.bsky.social
More data showing the effectiveness of Automated Speed Enforcement (ASE) cameras in Barrhaven East.

Once the cameras go up, drivers start slowing down and keep slowing down.

#OttCity
pbickerton.bsky.social
Automated Speed Enforcement (ASE) is working in River ward.

You can see how quickly people slow down once the camera is installed.

Interestingly, speeds on the younger cameras started out fairly low. I wonder if this is because the effects of ASE extend beyond their immediate area.
pbickerton.bsky.social
Automated Speed Enforcement (ASE) cameras work in Knoxdale-Merivale.

The data show how speeds gradually decrease, and stay down, once the cameras are installed.

#OttCity
pbickerton.bsky.social
Automated Speed Enforcement (ASE) cameras are working in College Ward.

I graphed the 85th percentile speed of cars by the age of the camera. College Ward has two older cameras (1000+ days) and 2 x younger (100 days).

You can see how speeds quickly trend downward once the cameras are installed.
pbickerton.bsky.social
Old post but the oldest water main at that intersection is only 35 years old! yikes