Eric Wing, GISP July 6, 2010 Penn State Advisor: Dr. Todd Bacastow

1. Leveraging Linear Referencing to Map Sewer Events from CCTV Logs Eric Wing, GISP July 6, 2010 Penn State Advisor: Dr. Todd Bacastow

2. Overview • Background • Objectives • Methodology • Timeline • Challenges • Anticipated Results • Questions

3. Boise and Sewer • 650 miles of sewer lines • 51,760 customers • 30 million dollars annual revenue • 150 users in Public Works Background Objectives Methodology Timeline Challenges Anticipated Results

4. Sewer in the Field • GIS Data • Manholes • Mainlines • Service Laterals Background Objectives Methodology Timeline Challenges Anticipated Results

5. GPS vs CCTV • GPS • Since 1995 • 22,431 records • Better representation • CCTV • Pre 1995 • 60,454 records Background Objectives Methodology Timeline Challenges Anticipated Results

6. CCTV • Service Laterals • Roots • Material Changes • Cracks • Grease Background Objectives Methodology Timeline Challenges Anticipated Results

7. Current Process Background Objectives Methodology Timeline Challenges Anticipated Results

8. Issues • 12 year old UNIX server • ARC/INFO 7 AML and coverages • Many manual steps • Automated processes take 62 hours • Current solution has known limitations Background Objectives Methodology Timeline Challenges Anticipated Results

9. Objectives • Streamline the process • Reduce manual steps • Automate where possible • Use ESRI ArcGIS 9.3 technology • No new extensions • No additional software • Correct for current limitations • Evaluate expansion opportunities Background Objectives Methodology Timeline Challenges Anticipated Results

10. Project Management • Sponsorship • Coordination • Accountability • Guide the paradigm shift Background Objectives Methodology Timeline Challenges Anticipated Results

11. Linear Referencing Background Objectives Methodology Timeline Challenges Anticipated Results

12. Research Approach • Understand the problem before solving • Document current workflow • Literature review • Peer discussions with neighboring sewer agencies • Study linear referencing in ESRI software • Document business requirements Background Objectives Methodology Timeline Challenges Anticipated Results

13. Development Approach • Iterative Design Background Objectives Methodology Timeline Challenges Anticipated Results

14. Timeline • April • Project planning • Literature review • Requirements planning • May • Requirements gathering • Document current processes • June • Prototype • Finalize requirements • Present to peers • July • Conceptual design • Draft new process • Start development • August • Continue development • Document new processes • September • Implement solution • Closeout project • Present at conference Background Objectives Methodology Timeline Challenges Anticipated Results

15. Challenges • Hansen 8 upgrade • Synchronization between GIS and Hansen • Appropriate level of solution sophistication • Models • Python scripts • Out of the box functionality Background Objectives Methodology Timeline Challenges Anticipated Results

16. Challenges Continued • Reverse Setups • 12:00 and 6:00 observations Background Objectives Methodology Timeline Challenges Anticipated Results

17. Anticipated Results • Significant time savings • Fewer manual steps • More automation • Eliminate UNIX server and ARC/INFO 7 • Open the opportunity to significantly expand capabilities Background Objectives Methodology Timeline Challenges Anticipated Results

18. Prototype Results Background Objectives Methodology Timeline Challenges Anticipated Results

19. Anticipated Results: Bonus • More data, better decisions • Wastewater pretreatment • Rehabilitation/reconstruction • Construction • Alternative to Hansen Background Objectives Methodology Timeline Challenges Anticipated Results

20. Acknowledgements • City of Boise • Barbara Edney, GIS Analyst • Jim Pardy, Assistant City Engineer • Melissa Rushton, Public Works Project Coordinator / Hansen Specialist • Penn State • Dr. Todd Bacastow, Advisor

21. References • Cadkin, J., & Brennan, P. (2002). Dynamic Segmentation in ArcGIS. ArcUser, July-Sept. Retrieved from http://www.srnr.arizona.edu/rnr/rnr420/dynseg.pdf • Clancy, D., Gustafson, J., & Higgins, L. (2002). Economical Sewer Main Rehabilitation Utilizing ArcGIS and Dynamic Segmentation. Retrieved from http://proceedings.esri.com/library/userconf/proc02/pap1181/p1181.htm • Curtin, K., Nicoara, G. & Arifin, R.R, (2007). A Comprehensive Process for Linear Referencing. Journal of the Urban and Regional Information Systems Association, 19 (2): 41-50. Retrieved from http://www.urisa.org/curtin • ESRI. (2001). Linear Referencing and Dynamic Segmentation in ArcGIS 8.1. Retrieved from http://www.esri.com/library/whitepapers/pdfs/lrds_arcgis.pdf • ESRI. (2003) Linear Referencing in ArcGIS: Practical Considerations for the Development of an Enterprisewide GIS. Retrieved from http://downloads2.esri.com/support/whitepapers/ao_/Linear_Referencing_in_ArcGIS.pdf • ESRI. (2006) GIS for Utilities [PowerPoint slides]. Retrieved from http://www.iowagic.org/resources/user-groups/eastern-iowa-user-group/past-events/january-25-2006/arcgis-tools-for-water-and-wastewater.pdf • Ferreira, A., & Duarte, A. (2005) A GIS-Based Integrated Infrastructure Management System. Retrieved from http://www.fig.net/pub/cairo/papers/ts_37/ts37_09_ferreira_duarte.pdf • Goodman, J.E. (2001). Maps in the Fast Lane – Linear Referencing and Dynamic Segmentation. Retrieved from http://www.directionsmag.com/article.php?article_id=126 • Meehl, J. (2004). Pipeline Integrity Management Using Linear Referencing With ArcObjects. Retrieved from http://proceedings.esri.com/library/userconf/proc04/docs/pap1976.pdf • Pierre, J., Mosher, J., Hargis, A. (2006). Linear Referencing in Boulder County, CO: Getting Started [PowerPoint slides]. Retrieved from http://proceedings.esri.com/library/userconf/proc06/papers/papers/pap_2071.pdf

22. Questions