210 likes | 370 Views
Overview. BackgroundObjectivesMethodologyTimelineChallengesAnticipated ResultsQuestions. Boise and Sewer. 650 miles of sewer lines51,760 customers30 million dollars annual revenue150 users in Public Works. Background Objectives Methodology Timeline Challenges Anticipa
E N D
1. 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
4. Sewer in the Field GIS Data
Manholes
Mainlines
Service Laterals
5. GPS vs CCTV GPS
Since 1995
22,431 records
Better representation
CCTV
Pre 1990
60,454 records
6. CCTV
7. Current Process
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
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
10. Project Management
11. Linear Referencing
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
13. Development Approach
14. Timeline April
Project planning
Literature review
Requirements planning
May
Requirements gathering
Document current processes
June
Prototype
Finalize requirements
Present to peers
15. Challenges Hansen 8 upgrade
Synchronization between GIS and Hansen
Appropriate level of solution sophistication
Models
Python scripts
Out of the box functionality
16. Challenges Continued Reverse Setups
12:00 and 6:00 observations
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
18. Prototype Results
19. Anticipated Results: Bonus More data, better decisions
Wastewater pretreatment
Rehabilitation/reconstruction
Construction
Alternative to Hansen
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