Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Jasmine Patel, Police Data Steward (Public Safety Analyst)
View as Administrator Data engineer Utilities steward Police steward
Metric migration / UT-02

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

As held in the legacy performance database (PerfDB)

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

CDR value against PerfDB

Calculation as run by the CDR

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.

Reproduced 13 months in 26 ms from the curated layer; 13 of 13 match the values stored by the latest run.
Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026Jun 2026Jul 2026Aug 2026Sep 2026Oct 2026
9.257.697.036.686.847.388.409.6111.3212.4212.8311.139.26

Monthly reconciliation, latest run

MonthPerfDBCDRDifferenceResult
Oct 20259.39.251-0.049Within tolerance
Nov 20257.77.692-0.008Within tolerance
Dec 20257.07.0300.030Within tolerance
Jan 20266.76.683-0.017Within tolerance
Feb 20266.86.8410.041Within tolerance
Mar 20267.47.381-0.019Within tolerance
Apr 20268.48.4020.002Within tolerance
May 20269.69.6090.009Within tolerance
Jun 202611.311.3170.017Within tolerance
Jul 202612.412.4190.019Within tolerance
Aug 202612.812.8340.034Within tolerance
Sep 202611.111.1350.035Within tolerance

Reconciliation history

RunResultMonths
L-20261101-0100Within tolerance12
R-20261102-0200Within tolerance12
R-20261103-0200Within tolerance12
R-20261104-0200Within tolerance12
R-20261105-0200Within tolerance12
R-20261106-0200Within tolerance12
R-20261107-0200Within tolerance12
R-20261108-0200Within tolerance12
R-20261109-0200Within tolerance12
R-20261110-0200Within tolerance12
R-20261111-0200Within tolerance12

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