Is there Lead in My Water?

1. Is there Lead in My Water? Melissa Williams, P.E., GISP Software Engineer Department of Technology, City of Columbus Mike Edwards GIS Manager Department of Public Utilities, City of Columbus Ohio GIS Conference September 25 – 27, 2017 Hyatt Regency Columbus Columbus, Ohio

2. Is there Lead in My Water? • Outline: • Background • Map Guidelines • Static Map compilation • DPU data • AGO Design • Live Demo

3. Is there Lead in My Water? • Background: • Flint, MI and Sebring, Ohio water crisis • HB 512 – Effective September 9 ,2016 • Identify and maps areas known or likely contain lead service lines • Communities to use records to identify areas • Plumbing codes- • 1986: 8% Lead allowed • 2014: 0.25% Lead allowed • Responsibility: City owns from water main up to curb stop (shut-off valve). Customer owns past curb stop

4. Is there Lead in My Water? • OEPA map guidelines: • Submit by March 9 ,2017 • Updated every 5 years • Plot entire distribution system • Different colors • PDF preferred • Appropriate scale, identify majors streets, landmarks, bodies of water etc. • Parcels and buildings recommended • Legend Recommendations:

5. Is there Lead in My Water? • Background: • Columbus used GIS attribution compiled from tap records.

6. Is there Lead in My Water? • DPU data background: • Division of Water conversion project (2011) • Tap card information • Current Plans

7. Is there Lead in My Water? • OEPA submitted map:

8. Is there Lead in My Water? All 1851 Water Systems are posted online. Check your community: http://epa.ohio.gov/ddagw/pws/leadandcopper/map.aspx

9. Is there Lead in My Water? • DPU Webmap preparation: • Point needed on each house that has a lead service • Show pipe diameter • Also show Abandoned lead services

10. Is there Lead in My Water? • GIS Shortcomings / Geoprocessing logic: • Customer Information on Curb Stop / Meter layer • Material Type on service line • Spatial Joins to pass material information to curb stop, onto to Building Footprint centroid • Abandoned service – curb stop without associated meter

11. Is there Lead in My Water? • MXD, with necessary layers, supplied to DoT to build AGO app

12. Is there Lead in My Water? • Operational Data Layers in MXD: • 1) Lead Services • 2) Abandoned Lead Services • 3) City of Columbus Water Service Area • 4) Other Water Service Areas • Base Map Layers Requested: • 1) City base map service • 2) 2015 orthophoto

13. Is there Lead in My Water? • Features Requested: • 1) Disclaimer with information, web link, email address, phone number • 2) Instructions how to use map • 3) Legend • 4) Search by Address, Owner, or Parcel ID • 5) Ability to switch between topographic base map and orthophoto

14. Is there Lead in My Water? AGO Web Application Design Process: 1) Define Users 2) Estimate Anticipated Load 3) Determine Layers to Host Using ArcGIS Server vs AGO 4) Select Base Map(s) 5) Create AGO Map and Share 6) Create AGO Web Application and Share 7) Test! 8) Publish App

15. Is there Lead in My Water? AGO Web Application Design Process: 1) Define Users - Public (metropolitan area residents) 2) Estimate Anticipated Load - Expected initial heavy load due to high profile subject matter and publicity from news agencies

16. Is there Lead in My Water? AGO Web Application Design Process: 3) Determine Layers to Host Using ArcGIS Server vs AGO - AGO for all operational data layers ArcGIS Online Credit Consumption:

17. Is there Lead in My Water? AGO Web Application Design Process: 4) Select Base Map(s) - AGO Base maps (Imagery as default) - Needed to add address and street labels - Added address points, street centerlines as AGO-hosted layers - Reduced file size by deleting extra fields and dissolving features before uploading to AGO

18. Is there Lead in My Water? AGO Web Application Design Process: 5) Create AGO Map and Share - Set symbology to match DPU mxd - Set visibility range for layers - Configured pop-ups - Added Pop-up Media for Possible Publicly Owned Lead Service Line

19. Is there Lead in My Water? AGO Web Application Design Process: 6) Create AGO Web Application and Share - Set theme to match branding standards - Primary widgets: - Splash - Instructions - Legend - Search - Basemap Gallery - Layer List

20. Is there Lead in My Water? AGO Web Application Design Process: 7) Test! - Comment: Image on pop-up window is incorrect Issue: pop-up media image had been updated after first round of testing while image url remained the same Solution: cleared test user’s cache

21. Is there Lead in My Water? AGO Web Application Design Process: 7) Test! - Comment: Have instructions appear by default with legend when app opens Issue 1: can only set one widget to be open when the app opens Solution: created a “grouped” widget by dragging and dropping one widget onto another

22. Is there Lead in My Water? AGO Web Application Design Process: 7) Test! - Comment: Have instructions appear by default with legend when app opens Issue 2: new grouped Map Details widget does not always open automatically in IE Solution: added comment to bottom of disclaimer to open Map Details widget if legend and instructions do no appear

23. Is there Lead in My Water? AGO Web Application Design Process: 8) Publish App

24. Is there Lead in My Water? Live Demo: • http://columbus.maps.arcgis.com/apps/webappviewer/index.html?id=a2afaed47dbd41059b1399fb60b51586 www.Tinyurl.com/zl5f24e

25. Is there Lead in My Water? Questions? Mike Edwards mgedwards@columbus.gov GIS Manager 910 Dublin RoadColumbus, OH 43215 Direct: 614.645.6810 www.columbus.gov Melissa Williams, PE, GISP MAWilliams@columbus.gov Software Engineer 1111 East Broad Street, 3rd FloorColumbus, OH 43205 Direct: 614.724.2868 www.columbus.gov