- Before
- Builds the renewal programme in spreadsheets from a GIS export and last year's list. “I can tell the board which pipes are oldest. I can't tell them which will break.”
- Now
- Draws a project on the risk-coloured map and sees breaks avoided, customer-hours avoided, cost and its rank as she draws.
How water main break prediction works: one burst, to a signed renewal programme
Lumina Utilities runs 3,912 km of water mains. On Monday 12 October 2026 Leila Mansour, capital planner for water distribution, is building the 2027 renewal programme for the Capital Review Board on 4 November, with a budget of AED 64M. The 2026 programme was ranked by age. On Friday a cast-iron main burst on Old Souk Street. Here is what happens next, screen by screen, in the working solution.
- 0105:30–05:40
The overnight refresh rescores every main
Likelihood modellerThe Break matcher reads 3 new repair work orders. The Likelihood modeller refits the 10 cohort curves — 1970s cast iron now has a median life to first break of 41 years, down from 42 — and scores every main for 2027 from age, soil, pressure swings, traffic and each pipe's own break history. 14,712 mains are rescored, and the Project drafter re-ranks 24 candidate projects.
“Back-test on 2025 breaks · Top 10% of mains held 58% of breaks · threshold 45% · passed, scores published”
- 02Friday 02:40
Friday's burst, matched to its pipe
Break matcherYusuf Rahman's crew report on WO-26-31877 reads: circumferential crack on DN200 grey iron, wall heavily graphitised, water through six shop fronts; valves V-HQ-112 and V-HQ-118 shut at 03:05, supply back at 10:00. 1,840 customers were without water for 7 h 20 min. The Break matcher places the break on Old Souk Street, picks WM-HQ-0417 over a DN100 service main because the crew measured 218 mm outside diameter, and gives the match 0.94.
“Conflict: the next pipe east, WM-HQ-0421, is recorded as ductile iron, but the crew's photo of the trench end shows the same cast iron” — sent to Daniel Okoro to decide
- 03Morning
Which mains break next in 2027
Leila Mansour · Capital plannerLeila opens the network map. Every main is coloured by its chance of a break in 2027, from under 2% to over 50%, with last month's breaks marked and the General Hospital, Dialysis Centre and Secondary School on the map. The Harbour Quarter cast iron is the darkest red. The list beside it reads WM-HQ-0417 on Old Souk Street at 82%, WM-HQ-0419 at 76% and WM-HQ-0433 on Pearl Divers Lane at 75%.
“The Old Souk Street cast iron burst on Friday. Draw around it to see what renewing it buys.”
- 04One click
Seventies cast iron breaks first, at 41
Leila Mansour · Capital plannerBeside the map are the survival curves for each pipe cohort, material by decade laid: the share of pipe length never broken, against age. Leila clicks Cast iron, 1970s and its pipes light up on the map. 186 km of it is in the network, it breaks 38 times per 100 km a year, and only 28% of its length has never broken at 52 years.
“Cast iron, 1970s: 186 km · median life to first break 41 years · 38 breaks per 100 km a year”
- 05The pipe
Why 82%: every driver, with its weight
Likelihood modeller and Consequence scorerWM-HQ-0417 is cast iron, DN200, 268 m, laid 1972. Its cohort baseline is multiplied by sabkha soil (×1.70), 14 pressure swings over 3 bar a day from the Harbour pumping station (×1.60), 5 breaks in 36 months (×4.21) buses and lorries on an arterial road (×1.25) and its age past the cohort median (×1.18): 1.72 expected breaks in 2027. If it breaks, 1,840 customers lose water between valves V-HQ-112 and V-HQ-118 and the old souk's shops and basements flood.
Consequence 4 of 5 · about AED 196,800 a break · risk AED 338,000 a year
- 0610:02
She draws the project and sees what it buys
Leila Mansour · Capital plannerWith Trace pipes, Leila clicks junctions along Old Souk Street, Pearl Divers Lane and Customs House Road, and the route follows the mains. The panel counts up as she draws: 2.4 km, AED 3.6M, 11 breaks avoided a year and 68,600 customer-hours without water avoided. It also feeds Harbour Quarter General Hospital, weighted ×3.
3.08 breaks avoided per AED 1M — rank #1 of 31, against 1.16 for the 2027 programme and 0.34 for an oldest-first plan
- 07Saved as RP-27-014
Renew before the road is resurfaced
Coordination checkerSaved as RP-27-014, the Harbour Quarter cast-iron renewal costs AED 3,580,480 at the 2027 open-cut unit rates, for 9 pipes. The Coordination checker reads the City Roads Department resurfacing plan and Lumina's electricity capital programme. Customs House Road is resurfaced in May 2027, then closed to digging for five years: renewing first saves about AED 410,000 of reinstatement. On Pearl Divers Lane, the 11 kV cable replacement E-27-118 opens the street in March–April 2027, so the trench can be shared.
“Drafted a joint-trench request for the electricity team — not sent: waiting for Leila”
- 08The programme
31 projects, ranked by what each dirham buys
Project drafterThe renewal projects are ranked by breaks avoided per AED 1M, with a line where the AED 64M budget runs out. 31 projects fit: 44.1 km of mains, 74 breaks avoided a year and 377,000 customer-hours avoided. Planners drew 7 of the candidates; the Project drafter proposed 24, each a contiguous run that can be built valve to valve under one street-works permit.
Projects below the AED 64M line wait for 2028.
- 09Same budget
The same AED 64M, three ways to choose the pipes
Leila Mansour · Capital plannerOldest first, as in 2026, renews 42.6 km and avoids 22 breaks a year. Most breaks first avoids 46. Risk removed per dirham avoids 74, and 377,000 customer-hours without water against 86,000. Over ten years at the same budget, network breaks in 2036 fall to 117 against 181 for oldest first, and 357 with no renewal.
“3.4× the breaks avoided for the same AED 64M.”
- 10Signed · 15:05
A cited board paper, signed for the board
Karim Aziz · Head of Water Asset ManagementThe Programme writer drafts paper CRB-26-41 for the Capital Review Board — recommendation, why the ranking changed, the largest project, the top six and the risks — with 6 citations to the scenario run, the back-test and the work order, and checks every total against the project list. Mei Tan confirms the unit rates and phasing at 11:40; Leila sends it at 11:52. Karim signs with the meaning “approved for the Capital Review Board”.
“Agents draft and check. Only Karim can approve the programme, and only the board can release the budget.”