This is a measure of water distribution system integrity using an industry standard of breaks and leaks per 100 miles of water main. The target is based on the AWWA Benchmarking Survey - median for combined operations.

The data is retreived by running a database query on the Maximo work management system and a GIS mapping system. Maximo provides the number of leaks and breaks on distribution system pipelines, valves, hydrants, appurtenances, or service connections during the given time period. Miles of pipe is retrieved by using GIS to determine the length of water mains owned by the City of Fort Worth. The query is run against the maxprod_restore database on the maxt03 server. The language is as follows: SELECT workorder.wonum, workorder.description, workorder.wolo2, workorder.reportdate, workorder.failurecode, workorder.problemcode, workorder.assetsize

FROM MAXPROD_RESTORE.dbo.workorder workorder

WHERE (workorder.failurecode In ('WTRPIPE','wtrserv')) AND (workorder.problemcode In ('LEAK','BREAK')) AND (workorder.status<>'5B-CAN') AND (workorder.wolo1='WTRDIS') AND (workorder.reportdate>{ts '2005-10-01 00:00:00'}) This gives you the basic data. Download the data into a pivot table to get the breaks and leaks per month. To get the GIS data, use the wmainline feature class in GIS on SLQ04v/water. In the properties of the layer SQL the statement to only have the owner field equal Fort Worth or null. Open the attribute table and summarize the length field to get the number of feet. Convert to miles (divide by 5280) and include in the calculation.

Actual = (Distribution System Breaks+ Leaks)/(Miles of Main/100)

For FY18 the overall target was changed from <31 to <=12.7 per the request of the Assistant Director, Travis Andrews. Thus, this also included the lowering of the High and Low Variances.