UT-02 Average residential water use per account

Owner: Utilities. Unit: thousand gal. Reconciliation tolerance: 0.1.

Written definition

Source: Munis Utility Billing
Calculation: Average billed consumption in thousand gallons per residential account for the service month.
Inclusions: Service class Residential.
Exclusions: Negative consumption corrections (held in quarantine for Utility Billing review).
Time frame: Service month.
Definition status: Accepted Office of Data and Innovation, 11/05/2026

Name: Average residential water use per account
Note: Average billed consumption in thousand gallons per residential account for the service month.
Script: perf_ut_02.sql

select service_month::date as month, avg(consumption_kgal) as value from curated.fact_utility_bill where service_class = 'Residential' group by 1

Reproduce now from the curated layer Runs the SQL above against the current curated tables, read only.

Month	PerfDB	CDR	Difference	Result
Oct 2025	9.3	9.251	-0.049	Within tolerance
Nov 2025	7.7	7.692	-0.008	Within tolerance
Dec 2025	7.0	7.030	0.030	Within tolerance
Jan 2026	6.7	6.683	-0.017	Within tolerance
Feb 2026	6.8	6.841	0.041	Within tolerance
Mar 2026	7.4	7.381	-0.019	Within tolerance
Apr 2026	8.4	8.402	0.002	Within tolerance
May 2026	9.6	9.609	0.009	Within tolerance
Jun 2026	11.3	11.317	0.017	Within tolerance
Jul 2026	12.4	12.419	0.019	Within tolerance
Aug 2026	12.8	12.834	0.034	Within tolerance
Sep 2026	11.1	11.135	0.035	Within tolerance

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.