TMD: Trunk Main Database
A strategy, planning & assurance decision support tool enabling asset owners to understand risk and prioritise asset investment.
The trunk main database (TMD) help utilities to understand better the true state of their trunk main network by combining condition, performance and spatial asset information in a central location. The TMD has been designed to provide historical information to help schedule future work targeting poorly performing assets and to provide the necessary evidence to support those decisions.
Need: Historically, trunk main data and asset information have been maintained on several different systems by different departmental staff and, in some cases, independently of one another. This has led to duplication of information and effort and the inability to fully understand the condition, status, characteristics or location of all trunk main assets. Storing pertinent information about trunk mains in a centrally located repository enables effective reporting of current or historic asset status and offers the ability to schedule future work.
Challenges: First, various key business decisions about trunk mains were being made without a true understanding of the overall network and, often, without the asset management team’s buy-in. The asset management team needed a tool that supported business processes to ensure that the correct assets were receiving investment that offered the greatest return for their investment. Second, the asset management team needed a tool that would provide up-to-date, accurate reports that represented one version of the truth. Third, obtaining and maintaining asset information from across a business and determining the relationships would enable accurate reporting of trunk main assets.
Solution: The TMD is a decision support tool that pulls information from across a business and combines them to provide an overall picture of a trunk main asset. It is designed to be run by staff as a business-as-usual tool and will provide key information on leak or burst history, main surveys, monitoring, related valve checks and asset risk or consequence. Binnies’ expertise in business process and data architecture was implemented to ensure that all the pertinent information would be funnelled through the TMD so that it would become a one-stop shop for all trunk main related queries.
- Centralises trunk main information previously stored across departments and personnel to help maintain data
- Provides a platform to obtain greater insights and remove duplication
- Brings together different datasets to provide a more complete picture of a main’s status and history
- Matches all the information to a main in a GIS
- Stores and provides the information used within the trunk mains risk model
- Organises the data into useful information that can be output as reports and data exports
- Provides detail to support business processes, helps to establish procedures and provides due diligence
- Easy to maintain to keep information up to date
- Clearer understanding of trunk main asset location and life cycle
- Centrally located information relating to trunk mains
- Better control over the trunk main leakage repair process
- Accurate reporting
- The correct assets selected for maintenance
- The asset management team
- Does not have to file several requests from across the business, as the TMD can report the current status of trunk main assets
- Can respond to trunk main related queries quickly and accurately
- Has a clear overview of the trunk main leakage or burst status