CONDITION ASSESSMENT of Pinery Water and Wastewater District’s System for GASB 34/35 and CMOM

1. CONDITION ASSESSMENTofPinery Water and Wastewater District’s Systemfor GASB 34/35 and CMOM

2. Pinery Water and Wastewater District Charles J. Krogh, Paul Makowski, Kevin Clark Presented by Farnsworth Group Doug Barker, GIS Specialist Ceila Rethamel, P.E. Jim Pardy, P.E.

3. PINERY INFORMATION • Pinery Water and Wastewater District - located south of Parker • Staff with 20+ years of experience • Facilities range in age from 30 years to brand new • Primarily residential users with a golf course

4. Vicinity Map

5. INTRODUCTION • Pinery wants to more efficiently manage repairs, maintenance, and replacement of facilities due to upcoming regulations (GASB 34 & CMOM)

6. INTRODUCTION (cont’d) • Pinery has data and information in various sources • paper as-builts • CAD files • staff’s extensive knowledge • records: breaks, billing, metering

7. INTRODUCTION(cont’d) Pinery hired Farnsworth Group to: • Compile data in central location • Complete hydraulic analysis • Develop condition assessment • Efficiently link different tools and software to the database

8. TOPICS OF DISCUSSION • Geographic Information System (GIS) • Doug Barker, GIS Specialist • Hydraulic Modeling • Ceila Rethamel, P.E. • Engineering Condition Assessment • Jim Pardy, P.E.

9. Geographic Information System Uses • Compile inventory of assets into digital format • Prepare data for hydraulic modeling software • Prepare data for condition assessment • Create 11x17 field atlas for staff use • Future use with billing and/or maintenance software • Support GASB 34 and CMOM compliance

10. Geographic Information System Benefits • Efficient access to information • Hydraulic modeling set-up much easier • Condition assessment performed with our existing GIS software • Excellent cartographic/presentation tool • Potential to link the GIS to other software

14. Example of GIS Map

15. Example of Field Atlas

16. Example of GIS Database

17. Hydraulic Modeling

18. Hydraulic Modeling • Tool used to locate • bottlenecks • low pressure areas • functionally obsolete piping

19. Software Evaluation WaterCAD (proprietary software) vs. EPANet (freeware) EPANet chosen: • freeware • ArcView extension to extract *.inp files • water quality modeling

20. Physical Model • Coordinated data entry into GIS database to ensure information works for the physical model. • Items left to add or check are: • directionality of PRVs and pumps • tank data • pump data • controls • demands Converts to PRV or pump Will not convert to a PRV or pump

21. Demand Analysis • Allowed more time for analysis of demands and usage

22. Adding Pipe to the Model • Fairly simple with GIS and EPANet • Pipes have been added several times for proposed development • Updated the background map

23. Storing Hydraulic Results • Store results in the GIS - track scenario • maps of pipe velocity or node pressure • tie pressures to addresses • use results in the condition assessment

24. Pressure Map - EPANet

25. Pressure Map - GIS

26. Asset Condition

27. Asset Condition • Created asset condition standards and quality thresholds • Prepared current condition assessment report • Create a Facility Condition Index • Asset Condition will help meet requirements of GASB 34 and CMOM

28. Engineering Condition Assessment (ECA) 1=Excellent Condition 2=Good Condition 3=Acceptable 4=Unacceptable 5=No Longer Serviceable A score of: 5-14 - Adequate (Green) 15-24 - Degraded (Yellow) >24 - Unsatisfactory (Red)

29. Example of ECA GIS

30. Facility Condition Index (FCI) • objective tool used to track an element of infrastructure • general forecast of what type of reserves need to be available to maintain or improve The FCI is commonly defined Deficiencies FCI= -------------------------------------- Current Replacement Value FCI<5% Good Condition FCI 5%-10% Fair Condition FCI>10% Poor Condition

31. Replacement Values and Deficiencies Values • Length of pipe from the GIS database • Assign costs

32. Replacement Values and Deficiencies Values (cont’d) Assign a percentage of the replacement cost to each of the ECA categories: Adequate – reserve of 2% of the total replacement cost Degraded –reserve of 20% of the total replacement cost Unsatisfactory - reserve of 100% of the total replacement cost

33. Replacement Values and Deficiencies Values(cont’d) • Deficiencies $102,162 • FCI= -------------------------------------- = --------------- = 10% Fair Conditions • Current Replacement Value $1,053,435

34. CONCLUSION Farnsworth Group helped the Pinery develop new tools to manage repairs, maintenance, and replacement of their facilities. • The tools included: • GIS • hydraulic model • Engineering Condition Assessment and Facility Condition Index

35. CONCLUSION (cont’d) • The Pinery will use the GIS maps for: • locates • any projects related to the system • queries

36. CONCLUSION (cont’d) • The Pinery will use the hydraulic model to: • assist with new development decisions • support their cases with developers • assist with operation decisions • system flushing • water quality issues

37. CONCLUSION (cont’d) • The Pinery will use the ECA/FCI to: • communicate to customers and board members • why reserve funds are needed • how funds are going to be spent on various projects • track conditions • help meet requirements of GASB 34 and CMOM

38. QUESTIONS?