Trunk Main Database

A decision support tool for Thames Waters’ Strategy, Planning & Assurance Team
  • Details

  • Contact

The Trunk Main Database (TMD) has fundamentally helped Thames Water’s Asset Management understand the true state of their trunk main network by relating condition, performance and spatial asset information together in one central location. The TMD has been designed to not only provide historical information but help schedule future work by targeting their poorly performing assets and provide the necessary evidence to support those decisions.


Need: During PR14 Thames Water (TW) Asset Management (AM) identified a requirement to store pertinent information about Trunk Mains in a centrally located repository, to effectively report current or historic asset status together with the ability to schedule future works. Historically, trunk main data and asset information has been maintained on a number of different systems, by different departmental staff, in some cases, independently of one another. This led to duplication of information, effort and the inability to fully understand the condition, status, characteristics or location of all trunk main assets.

Challenge:  First, A number of key decisions around the business were made to Trunk Mains without having a true understanding of the overall network and often made without AM buy-in. AM needed a tool that supported their new business processes to ensure that the correct assets were receiving investment that provided the greatest return for their investment. Second, AM needed a tool that would provide up-to-date, accurate reports that represented one version of the truth. Thirdly, to obtain and maintain the asset information from across the business and implementing the relationships to enable the accurate reporting of TM assets.

Solution: The TMD is a decision support tool that pulls information from across the business and combines them together to provide a overall picture of a TM asset. It is designed to be run by TW 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. Along with the TMD, B&V expertise in business process & data architecture was implemented to ensure that all pertinent information would be funneled through the TMD and would become a ‘one stop shop’ for all TM related queries.

Benefits: The TMD is a flexible support tool that provides a clearer understanding Trunk Main asset location and life cycle. Not only that but provides the detail to support business processes, help establish procedures and provide due-diligence to ensure TW can report accurately and select the ‘correct’ assets to be maintained. The TMD has centralised TM information previously stored across departments and personnel to help maintai data and provided a platform to obtain greater insight and remove duplication.

How does it make the client's life easier?
  • Asset Management now have a tool at their disposal that can report the current status of Trunk Main assets without having to file a number of requests from across the business.
  • Can respond to TM related queries quickly and accurately;
  • Provides a clear overview of the TM leakage or Burst status;
  • Regularly maintain to keep information up-to-date.


Key features:
  • Central location for information relating to Trunk Mains.
  • Matches all information to a main in GIS.
  • Brings together a number of different datasets providing a more complete picture of a main’s status and history.
  • Provides better control over the Trunk Main leakage repair process.
  • Stores and provides information used within the Trunk Mains Risk Model.
  • Organises the data into useful information that can be outputted via reports and data exports.
  • This database is out of scope of WAMI and therefore has identified a gap and fulfilled a requirement to maintain and store pertinent asset information during the transition.
Typical Buyer:

Utility companies needing to understand what and where their poor performing assets are. Those clients who have the information in disparate datasets and require a mechanism to join up the data to provide new insights in to their assets

Pain points or what to listen for:
  • The amount of data generated is vast so having a reliable data model is critical.
  • The information needs to be regularly updated and connected.
  • The data within needs to be shared throughout the organisation if its to have buy-in and acceptance.

Trunk Mains, Leak, Repairs, Monitoring, Sahara Survey, Critical Valves