| Sewer Overflows per 100 Miles of MainWTR-Water |
Analysis | |
Measure Definition & Importance |
This is a measure of the sanitary sewer collection system integrity and efficiency using an industry standard of overflows per 100 miles of sanitary sewer main. The target is set based on the AWWA benchmarking study for combined utilities.
Attributes |
Sewer overflows per 100 miles of main |
| AWWA Benchmarking |
Attachments |
# Sewer overflows |
Sewer Overflows |
Measure Data | Last Calculated a month ago |
| Period | | Status | Actual | # of overflows | # Miles of main | Overall Target | High Variance (FY Target) | Low Variance |
|---|---|---|---|---|---|---|---|---|
| Oct-18 |  | Insufficient Progress | 2.43 | 84.00 | 3,459.00 | 1.30 | 10.00 | |
| Nov-18 | | On Target | 0.38 | 13.00 | 3,459.00 | 1.30 | 10.00 | |
| Dec-18 | | On Target | 0.32 | 11.00 | 3,459.00 | 1.30 | 10.00 | |
| Jan-19 | | On Target | 0.52 | 18.00 | 3,459.00 | 1.30 | ||
| Feb-19 | | On Target | 0.35 | 12.00 | 3,459.00 | 1.30 | ||
| Mar-19 | | On Target | 0.23 | 8.00 | 3,459.00 | 1.30 | ||
| Apr-19 | | On Target | 0.75 | 26.00 | 3,459.00 | 1.30 | ||
| May-19 | | Insufficient Progress | 1.39 | 48.00 | 3,459.00 | 1.30 | ||
| Jun-19 | | On Target | 0.17 | 6.00 | 3,459.00 | 1.30 | ||
| Jul-19 | | On Target | 0.26 | 9.00 | 3,459.00 | 1.30 | ||
| Aug-19 | | On Target | 0.12 | 4.00 | 3,459.00 | 1.30 | ||
| Sep-19 | | On Target | 0.29 | 10.00 | 3,459.00 | 1.30 | ||
| Oct-19 | | On Target | 0.29 | 10.00 | 3,459.00 | 1.30 | ||
| Nov-19 | | On Target | 0.43 | 15.00 | 3,459.00 | 1.30 | ||
| Dec-19 | | On Target | 0.17 | 6.00 | 3,459.00 | 1.30 | ||
| Jan-20 | | On Target | 0.35 | 12.00 | 3,459.00 | 1.30 | ||
| Feb-20 | | On Target | 0.23 | 8.00 | 3,459.00 | 1.30 | ||
| Mar-20 | | On Target | 1.24 | 43.00 | 3,459.00 | 1.30 | ||
| Apr-20 | | On Target | 0.09 | 3.00 | 3,459.00 | 1.30 | ||
| May-20 | | On Target | 0.26 | 9.00 | 3,459.00 | 1.30 | ||
| Jun-20 | | On Target | 0.20 | 7.00 | 3,459.00 | 1.30 | ||
| Jul-20 | | On Target | 0.29 | 10.00 | 3,459.00 | 1.30 | ||
| Aug-20 | | On Target | 0.17 | 6.00 | 3,459.00 | 1.30 | ||
| Sep-20 | | On Target | 0.23 | 8.00 | 3,459.00 | 1.30 | ||
| Oct-20 | | On Target | 0.33 | 12.00 | 3,624.00 | 1.30 | ||
| Nov-20 | | On Target | 0.36 | 13.00 | 3,624.00 | 1.30 | ||
| Dec-20 | | On Target | 0.33 | 12.00 | 3,624.00 | 1.30 | ||
| Jan-21 | | On Target | 0.33 | 12.00 | 3,624.00 | 1.30 | ||
| Feb-21 | | On Target | 0.25 | 9.00 | 3,624.00 | 1.30 | ||
| Mar-21 | | On Target | 0.39 | 14.00 | 3,624.00 | 1.30 | ||
| Apr-21 | | On Target | 0.30 | 11.00 | 3,624.00 | 1.30 | ||
| May-21 | | On Target | 0.44 | 16.00 | 3,624.00 | 1.30 | ||
| Jun-21 | | On Target | 0.30 | 11.00 | 3,624.00 | 1.30 | ||
| Jul-21 | | On Target | 0.22 | 8.00 | 3,624.00 | 1.30 | ||
| Aug-21 | | On Target | 0.22 | 8.00 | 3,624.00 | 1.30 | ||
| Sep-21 | | On Target | 0.06 | 2.00 | 3,624.00 | 1.30 | ||
| Oct-21 | | On Target | 3,624.00 | 1.30 | 10.00 | |||
| Nov-21 | | On Target | 3,624.00 | 1.30 | 10.00 | |||
| Dec-21 | | On Target | 3,624.00 | 1.30 | 10.00 | |||
| Jan-22 |  | Monitoring/No Info | ||||||
| Feb-22 | | Monitoring/No Info | ||||||
| Mar-22 | | Monitoring/No Info | ||||||
| Apr-22 | | Monitoring/No Info | ||||||
| May-22 | | Monitoring/No Info | ||||||
| Jun-22 | | Monitoring/No Info | ||||||
| Jul-22 | | Monitoring/No Info | ||||||
| Aug-22 | | Monitoring/No Info | ||||||
| Sep-22 | | Monitoring/No Info |
Data Source Details & Calculation Information |
The data is retrieved by running a database query on the Maximo work management system and a GIS mapping system. Maximo provides the number of overflows during the given time period. Miles of pipe is retrieved by using GIS to determine the length of sanitary sewer 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.reportdate, workorder.description, workorder.wolo2, workorder.failurecode, workorder.problemcode
FROM MAXPROD_RESTORE.dbo.workorder workorder
WHERE (workorder.reportdate>{ts '2011-10-01 00:00:00'}) AND (workorder.problemcode='overflow') AND (workorder.status<>'5B-CAN') This gives you the basic data. Download the data into a pivot table to get the overflows per month. To get the GIS data use the smainline 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 - (Overflows)/(miles of main/100)
Measure Type |
Performance Liaison |
| DW | Donail Williams (WTR- Water) |
Data Owner |
Target Type |
Measure ID |
Administrator Notes |
Performance Liaison Notes |