Utilities Focused Asset Management & Mapping for Parks

1. By: David G. Lautenschleger, P.S., GISP Surveying and Facilities GIS Coordinator Utilities Focused Asset Management & Mapping for Parks

2. Muskingum Watershed Conservancy District (MWCD) Background Largest watershed in Ohio (8,000 sq. miles / 20% of state) Spanning five counties and portions of 22 others Established in 1933 for flood control after the Great Flood of 1913, Ohio's greatest natural disaster with nearly 500 deaths System of 16 dams and reservoirs (all dry dams planned prior to Dust Bowl era) Provided Public's Works projects during depression $8 Billion in flood damage prevented Park system started in 1960's

3. Atwood Lake Park • Charles Mill Lake Park • Pleasant Hill Lake Park • Seneca Lake Park • Tappan Lake Park

4. What is the problem? Parks are over 50 years old and have endured a variety of modifications Inconsistent record keeping - Information in variety of formats and locations Unknown utility locations Excavations can lead to “surprises” Unsafe conditions for construction crews Interruption of utility service Unhappy campers IMAGE: http://donkeystocollege.blogspot.com/2012_03_01_archive.html

5. Avoid Expensive ExcavationSimple projects turn into BIG problems! Lack of utility knowledge creates additional expenses for future projects

6. Employee safety and Utility interruption http://blog.level3.com/wp-content/uploads/2011/08/landownerfibercut.jpg http://hamptonroads.com/2011/04/incidents-gas-line-power-pole-tangle-va-beach-traffic http://www.nbcnewyork.com/news/local/Bayonne-Water-Main-Break-Avenue-E-52-Street-208420521.html

7. Current Location Methods MEMORY?

8. Current Location Methods Prints and historical documents Ohio Utilities Protection Service (OUPS) Not for private utilities Utility Locator (metal only) Utility Camera

9. Sewer Cam!

10. Existing Data Types Historical data: hand drawings on linens and mylar (1960's-1980's) CAD design files from expansions (1980's- present) Misc. field survey data from in-house survey (2001) Existing in-house CAD engineering drawings Institutional knowledge - MEMORY

11. Scanned historical documents

12. Existing CAD documents

13. Where is the data? MWCD Engineering Department has majority of plans at Main Office in New Philadelphia, Ohio Conservation Department has limited amount of plans from easements and projects not directly affecting parks Parks keep miscellaneous maps and notes in Maintenance buildings Additional data stored in off-site location http://www.newsgroupdirect.com/blog/2011/01/20/binary-retention-reaches-810-days/raiders_of_the_lost_ark_government_warehouse_new/

14. Goals • Develop a system in which multiple departments can easily access utility data • Maintain data in one location and make available to all staff via the Internet • Increase the amount of sharing of data district-wide • Increase efficiency for Utilities and Construction Crews • Make the information not typically available to field staff by implementing tablets/handheld GPS units, allowing problems to be resolved faster and generating a self- sufficient environment • Uncover potential problems • Create and implement a Geographic Information System (GIS)

15. What is a Geographic Information System or GIS? GIS combines graphic (maps/CAD data) and non-graphic (dbase/tabular)data A picture is worth a thousand words…right?! GIS

16. How to get data into GIS? Scan historical drawings and aerials Georeference & digitize historical data Georeference past projects and surveys created during construction projects NEW SURVEY!

17. Horizontal and Vertical Survey Control A CORDINATE SYSTEM IS NECCESSARY!! Use standardized local system Ohio State Plane System – North Zone (NAD83 US Survey Feet-FIPS 3401) Elevation Datum (NGVD29) Well monumented for future use

18. Permanent Monumentation All future surveys to utilize new control monuments on Ohio State Plane Coordinate System 10” Diameter by 42” deep with aluminum cap and witness post. 10 placed throughout campground

19. Field survey of the current conditions Locate ALL utility components Manholes Culverts Water valves/boxes Electrical boxes Power Poles Structures

20. Field survey environment 4 Day work week: 10 hr. days: Monday-Thursday to minimize disruption to visitors Signage and safety gear (vests, cones) Communication with Park Manager & Park Rangers

21. Field survey - QC/QA Walk-through of entire project by surveyor with field collected data Walk-through of first set of deliverables by MWCD staff Video of area provided for additional checks from office

22. Contour Video Contour Video (similar to GoPro) linked to Google Earth

23. Develop Database Standards and SchemaReview with end-users • Engineering • Water/Waste-water maintenance • Park Managers • Park Maintenance staff • Recreation Management

24. Database Standards and domains for consistency Database also to include method of data collection for each entity to determine level of “trust” for each actual location. i.e. Survey Grade, Aerial, CAD, Handheld GPS, Scanned Document, etc.

25. Database consistency Create forms for field staff to populate. Use with tablet. Internet service not required for entire duration of task. IMAGES: www.doforms.com

26. Merge historical plans by using the new survey data

27. End Users - Field Staff Smart Phone (Android or iOS) Mobile options for quick reference of utility locations Handheld GPS (Trimble GeoExplorer or Juno) with ArcPAD for improved accuracy IMAGE: http://www.trimble.com/mappingGIS/geo-7-series.aspx Survey crew to stake-out locations prior to excavation similar to Ohio Utilities Protection Service (OUPS)

28. End Users - Office Staff ArcGIS Desktop for Survey / GIS staff for updates and maintenance ArcGIS ONLINE for non-technical staff in Recreation and Conservation Departments Embed in MWCD website for construction updates Create web applications for MWCD staff as needed

29. Public – MWCD Website

30. GIS Desktop & Tablet Demo

31. Future Maintenance Future projects and utility installs documented Work-flow document be created Utility planning (Project Engineer) Construction (Const. & Utility Crews) As-built survey (Survey Technician) GIS updates (GIS Specialist) MWCD Engineering Dept. consists of Survey and GIS staff to fulfill this need

32. Benefits of GIS in Park Management Limit duplication of data capture and maintenance Consistency with multiple parks Education/transfer of knowledge Managing Facilities with current information Discover or verify suspected problems (I&I)

33. Simplified Cost Analysis based aroundInflow and Infiltration (I&I) IMAGE: http://www.cityoflakeport.com/departments/page.aspx?deptID=48&id=84

34. Simplified Cost Analysis ofInflow and Infiltration (I&I) at Tappan Lake Park

35. Project Timeline

36. Chippewa GPS/GIS 2009-2010

37. Equipment

38. Fieldwork

39. Data Collected • Approximately 1800 features • Tile Drains • Culverts • Misc. Utilities • Undocumented Drains • Encroachments • Channel Maintenance

40. How do I get started? Data Inventory Who are the stake-holders? • Engineering • Maintenance End-users? In-house or Consultant? Software? • ESRI • Open Source –OpenGEO/QGIS, GRASS (Geographic Resources Analysis Support System)

41. Lessons Learned Consultant Communication: Survey staff needs to have understanding of final product Internal Communication: Maintain constant communication with end-users (primarily park staff) Project Schedule: Perform fieldwork in off season with less traffic and obstructions Marathon, not a sprint IMAGE: http://honeyyyimhome.tumblr.com/post/6290342248/its-a-marathon-not-a-sprint-its-the-journey

42. Acknowledgements Boris Slogar, P.E., M.P.M., MWCD Chief Engineer Joseph Bishop, PhD, PSU Advisor Jeremy Hoffer, MWCD Tappan Lake Park Manager Michael Kobilarcsik, MWCD Survey Technician Gary Taylor & the MWCD Utilities Staff Bodo & Associates, Inc., Surveying & Mapping

43. Questions? Muskingum Watershed Conservancy District 1319 Third St. NW PO Box 349 New Philadelphia, OH 44663 Ph: (330) 343-6647 www.mwcd.org davidl@mwcd.org