Trunk Main Risk Model

  • 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, BV 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.

Key benefits
  • 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.

Thames Water, Trunk Mains, Risk Model, Burst Model, Consequence Model