| Asset | breaks in 10 year | Dia | Age | Sand | Clay | Low Traffic | Heavy Traffic | Trees | no trees | shallow unde 6 | deep bury | pressure | Ductile | GI | PVC | AC | HDPE |
| water main | 17 | 2 | 45 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 0 | 0 | 0 | 1 | 0 |
| water main | 11 | 2 | 45 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 0 | 0 | 0 | 1 | 0 |
| water main | 12 | 2 | 45 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 0 | 0 | 0 | 1 | 0 |
| water main | 10 | 2 | 45 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 0 | 0 | 0 | 1 | 0 |
| water main | 2 | 4 | 50 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 1 | 0 | 0 | 0 | 0 |
| water main | 3 | 6 | 60 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 55 | 1 | 0 | 0 | 0 | 0 |
| water main | 1 | 6 | 60 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 55 | 1 | 0 | 0 | 0 | 0 |
| water main | 1 | 6 | 60 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 55 | 1 | 0 | 0 | 0 | 0 |
| water main | 0 | 6 | 20 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 55 | 0 | 0 | 1 | 0 | 0 |