For any modern municipality, the water utility is the backbone of community health and economic stability. Yet the management of these critical linear and vertical assets often suffers from a "visibility gap." In Regina, our research into the current state of Water, Wastewater, and Stormwater infrastructure identified a common set of strategic hurdles: fragmented data silos, "un-intelligent" asset identification, and a lack of a formal asset hierarchy to support sophisticated lifecycle planning. Without a unified "source of truth," utilities are forced into a reactive cycle—
addressing failures as they happen rather than by strategy.
To bridge this gap, the Asset Management team at City has developed a comprehensive
Asset Registry Project, creating a standardized
Asset Integrity Foundation that harmonizes data across all three water branches. This isn't just a technical database; it is a business framework designed to deliver
Clean Data and Clear Views for decision-makers at every level.
The framework follows a logical flow from raw data ingestion to high-level data intelligence:
- Defining the Scope (Descriptions, Inclusions & Exclusions): Before categorization, we established Asset Descriptions. By clearly defining "Inclusions" and "Exclusions," we eliminated ambiguity regarding physical asset boundaries. This step ensures that every component—from a main line to a specific fitting—is recognized at the correct level, preventing overlap and ensuring technical consistency between linear networks and vertical facilities.
- The Foundation (Identification & Hierarchy): We replaced legacy, siloed labels with a unified, intelligent identification system. By componentizing assets into a structured hierarchy, we ensure that every valve, pipe, and lift station is recognized as a distinct entity for maintenance and renewal planning.
- The Intelligence (Static vs. Dynamic Attributes): Our model distinguishes between an asset’s "DNA"—its Static Attributes like Asset ID, Material, and Ownership—and its "Pulse"—the Dynamic Attributes. This allows us to track real-time operational health, including maintenance status, life-cycle costs (LCC), risk assessment parameters, and KPI-driven condition assessments.
- The Payoff (Strategic Lifecycle Management): By creating a blueprint for refined data insertion into GIS and Financial systems, we have established a closed-loop data flow. This enables a proactive shift from complaint-driven repairs to planned, condition-based interventions that stabilize budgets and provide data-backed justification for capital funding.
While currently established as a strategic framework, this project serves as the critical blueprint for Regina’s future utility operations. By completing this essential 'pre-work'—standardizing hierarchies and attribute models now—the City is positioned for a seamless transition into a sophisticated Work Order Asset Management System (WCAS) or Asset Management System (AMS).
Attendees will learn how this foundational registry ensures that when implementation begins, the City’s digital systems will be powered by 'Clean Data' from day one. Ultimately, this framework provides the roadmap to transform Regina’s Water, Wastewater, and Stormwater networks into a transparent, managed portfolio, ensuring long-term financial stewardship and infrastructure resilience.
