AI Analysis: Municipal operating costs: Water, waste, recreation and culture

Executive Summary

Statistics Canada's Table 10100173 tracks municipal operating costs across 216 Canadian municipalities from 2020 to 2023, covering seven service categories including water, waste, recreation, and culture, with 12,810 records ranging from $1K to nearly $369 million. All seven spending categories grew consistently over the period, with recreational and sporting services leading growth at $1.2 billion, while the data is heavily right-skewed — a median of $1,668K versus a mean of $6,183K — indicating that a small number of large cities dominate overall expenditure. Twenty-six municipalities were flagged as statistical outliers, spending above the $650,274K IQR threshold, underscoring the vast disparity in municipal service costs across Canada.

Key Findings

• All 7 CCOFOG spending categories grew consistently from 2020 to 2023, with recreational and sporting services seeing the largest absolute increase of $1.2 billion (from ~$3.9B to ~$5.1B).
• The dataset is heavily right-skewed, with a mean operating cost of $6,183K per record compared to a much lower median of $1,668K, reflecting the outsized influence of a few large municipalities.
• Cultural Services shows the most extreme skew of any category, with a mean of $3,730K but a median of only $540K, indicating that spending is concentrated among a small number of large cities.
• 26 municipalities were identified as statistical outliers using IQR-based detection, all spending above the upper threshold of $650,274K in total costs across the 2020–2023 period.
• Water supply and waste water management are the two largest categories by record count (~2,280–2,297 records each), with mean costs above $6,800K per record.
• Rain water management had the smallest growth of any category, rising by $73.6 million over the four-year period, though it still trended upward without any annual declines.
• Recreation, culture, and religion n.e.c. was the second-fastest growing category, increasing by $688 million between 2020 and 2023.