Sewer Pipe Inspection Reports -> Condition Layer

[mshanaghan]

Hi all. I want to create an overall pipe condition layer that takes into account a condition score from a sewer pipe inspection report as well as pipe age. Does anyone have any examples of this or resources you used to accomplish this? Thank you in advance. 

[RobertKrisher · Accepted solution]

If you put all the charateristics for the score on a single layer, you can use the Calculate Composite Index tool to create a weighted score.

Here are some articles that give an overview of things to consider for weights and process:

• Enterprise GIS and Infrastructure Management
• Calculating the Consequence of Failure
• Infrastructure Maintenance and the Geographic Approach

If you do end up taking the composite index approach, you can find quite a few articles and tutorials online form Esri on how to use them.

[mshanaghan]

This is exactly what I was looking for. Thank you!

[OsvaldoDiaz]

Hi mshanaghan, glad to hear that solved it!  Just as a tip for your future projects, adding Arcade expressions to that workflow  can give you even more flexibility for dynamic visualizations of your network state.

Keep Up the great work!

Best regards,

Osvaldo Diaz