Is there Lead in My Water Mike Edwards

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

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

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- o 1986: 8% Lead allowed o 2014: 0. 25% Lead allowed • Responsibility: City owns from water main up to curb stop (shut-off valve). Customer owns past curb stop

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:

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

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

Is there Lead in My Water? OEPA submitted map:

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

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

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

Is there Lead in My Water? MXD, with necessary layers, supplied to Do. T to build AGO app

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

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

Is there Lead in My Water? AGO Web Application Design Process: 1) Define Users 2) Estimate Anticipated Load 3) Determine Layers to Host Using Arc. GIS 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

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

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

Is there Lead in My Water? AGO Web Application Design Process: 4) Select Base Map(s) - AGO Base maps (Imagery as default) - Needed to 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

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

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

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

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

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

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

Is there Lead in My Water? Live Demo: http: //columbus. maps. arcgis. com/apps/webappviewer /index. html? id=a 2 afaed 47 dbd 41059 b 1399 fb 60 b 51586 www. tinyurl. com/zl 5 f 24 e

Is there Lead in My Water? Questions? Mike Edwards mgedwards@columbus. gov GIS Manager 910 Dublin Road Columbus, OH 43215 Direct: 614. 645. 6810 www. columbus. gov Melissa Williams, PE, GISP MAWilliams@columbus. gov Software Engineer 1111 East Broad Street, 3 rd Floor Columbus, OH 43205 Direct: 614. 724. 2868 www. columbus. gov