ESRI WATER CONFERENCE
January 29-February 1, 2018 | Hilton San Diego Bayfront

Agenda

Location:
Hilton San Diego Bayfront

Monday, January 29

Time Presentation/Session Presenter(s) Room
7:30 a.m. - 8:30 a.m.  Continental Breakfast
Sapphire West Foyer CD
7:30 a.m. - 5:00 p.m.  Registration  Sapphire West Foyer CD
8:30 a.m. - 10:00 a.m.  Plenary Session
Sapphire DH
10:00 a.m. - 10:30 a.m.  Morning Break Sapphire Foyer
10:30 a.m. - noon  Plenary Session Continued    Sapphire DH
noon - 1:30 p.m.   Hosted Lunch Promenade Plaza 
1:30 p.m. - 5:00 p.m.   Data Health Check/Hands-On Learning Lab Cobalt 502
1:30 p.m. - 2:30 p.m.  Stormwater in the Cloud (Moderated Paper Session)
Sapphire 400 A
Removing Technical Barriers for the City of Salinas Stormwater Program
Municipal stormwater managers have a balancing act: comply with regulations while running an efficient program that improves the environment. Like most cities, the City of Salinas stormwater program has struggled to be compliant and communicate program effectiveness. Needing a new approach, City managers have turned to cloud-based GIS services to streamline data collection, management, analysis, and reporting. By combining technology and spatial data, the City is checking required regulatory boxes while obtaining data that directly inform decisions. Mobile applications allow field personnel to inventory and inspect stormwater assets and results  inform where maintenance actions are needed. An urban hydrology and pollutant-loading model in the cloud is used to prioritize,  plan and fund water quality improvement strategies. The collective environmental benefits of the City’s stormwater program are summarized in simple maps and bar charts to communicate priorities and report environmental progress. With this improved communication, Salinas hopes to inspire citizen scientists to crowd source field data and to advocate for a well-funded and effective City stormwater program.
Maggie Mathias (2NDNATURE LLC)
A Mobile, Cloud-Based GIS for Stormwater Management
Management of stormwater runoff in urban areas requires significant resource commitment from local governments, but available data is generally insufficient to provide for the large information demands of long-term planning. Combatting this deficiency requires the collection and storage of large amounts of watershed data. For maximum benefit, field collection and database management requires an easily accessible interface for the data needs of various end-point users. This presentation will describe how Virginia Tech researchers worked with various municipalities to implement innovative mobile, cloud-based GIS to develop, deploy, and utilize data for watershed master planning, hydrologic/hydraulic modeling, stormwater inspections, regulatory compliance, and infrastructure asset management. Procedures taken to build, troubleshoot, and improve the stormwater GIS are described, as are required personnel needs, data collection rates, and workflow scaling considerations. Various innovative scripts and tools used to develop and use this cloud-based GIS will be described, and the outcomes of this workflow will be presented with examples from two Virginia localities.
Marcus Aguilar (Virginia Tech)
1:30 p.m. - 2:30 p.m. 
Improving Locate Workflows (Moderated Paper Session) Sapphire 400 B
Locates Application
Five years ago the GIS department at the San Antonio Water System inherited the job duty of writing service requests for utility locates. A locate is a request to mark an underground main before an excavator digs. Toni Jackson, GIS Analyst and Cindy Tuttle, GIS manager  developed an application for local contractors  to request a locate at the site of excavation.  Toni  designed a workflow with web services in GeoCortex to allow the contractor  to draw a polygon in the excavation area.  Once drawn, GeoCortex would send the polygon to the work management system to generate a service request which triggered a locator to mark the site.  Block maps  and  a reference number  track  progress.  

From a spatial approach, it seemed simple.  But, this had to interface with the work management software as well as a front end for the user to log into.  Other departments had a stake in the application as well.  The locators wanted a perimeter size for a locate.  Risk management wanted a database to track if locates were made.  The customers had a long list.    Savings to the utility was 4 fulltime positions and self-serve customers.
Cindy Tuttle (San Antonio Water System)
Enhancing 811 Ticket Locating with GIS
The Western Area Water Supply Authority (WAWSA) maintains over 200 miles of transmission water mains in the northwestern North Dakota. In the past, WAWSA field operators spent an enormous amount of time each day reviewing 811 – “call before you dig” – tickets to locate these waterlines in relation to non-WAWSA construction. Time consumption was due to the task of having to infer spatial information from non-spatial data found on the 811 ticket. To simplify this workflow, WAWSA now incorporates the information from the tickets – using ArcGIS Pro and a little Python – into a web map dedicated to the operators and their duties. On this map, the tickets are displayed as polygons, attributed with the details from the tickets. With this, operators only need to reference the one web map for up-to-date information about tickets generated from the ND 811 One Call center. Here they can query tickets, change statuses, and insert notes for any other operator (or manager) in the system. And before all of this data is displayed on the map, GIS is used to make some spatially logical decisions about the relevance of the tickets. All this contributes to the efficiency of field operations for WAWSA.
Jacob Monson (Western Area Water Supply Authority)
1:30 p.m. - 2:30 p.m. 
Big Data: Getting to Know Your Customers (Moderated Paper Session)
Sapphire 410
Enterprise GIS Water Utility Data Migration: Service Location Case Study
Does your utility/organization have a need to integrate customer account information with billing data, customer notifications requests, as-built drawings, and asset management records?  How do you do this if the customer account information is not accurately mapped?  Our presentation will show an integrated approach into how to efficiently map a large customer dataset and effectively prepare the data to be integrated with other existing datasets. The presentation will detail the software, automated processes, and web applications used to develop, review, and communicate service location information to a project team working from multiple physical locations.  The resulting data will be used to improve workflows, analysis, and customer response times.
Anthony Pologruto (Municipal Authority of Westmoreland County) 
Using Big Data to Achieve “Big Results”
Trying to determine the average consumption of non residential users across a municipality with a population of 1.2 million residents can be daunting. Even more scary is the idea of determining the water consumption trends over the past few years when the data is spread across different departments and in different formats, totaling up to about 9 million data points. This paper will describe the process the Region embarked to use large amounts of data to determine what is the right criteria to use to predict future non residential flows. It was quickly determined that location is everything, and ArcGIS offers tools that simplify these processes and helped us efficiently analyse these large amounts of data, combine data, visualize data and quickly make decisions that in the long run will have technical and financial implications in our water servicing program and budgets.
Miriam Polga (Region of Peel)
1:30 p.m. - 2:30 p.m. 
Increasing Efficiency with Workflow Manager (Moderated Paper Session)
Sapphire 411
Using Esri's WMX to Manage Water Projects
AE2S has taken the lead in implementing Esri's Workflow Manager (WMX) for two large scale water projects in North Dakota 1. The Fargo-Moorehead Diversion project, which is a 20,000 cubic feet per second, 30-mile long, 1,500 foot-wide diversion channel with 32,500 acres of upstream staging that will establish permanent flood protection measures for the region. 2. The Red River Valley Water Supply project, which will provide supplemental water to central and eastern North Dakota during times of water scarcity so as to protect public health, ensure ongoing economic vitality, and provide for environmental benefits in the river systems. Currently, the project calls for a 72” pipe to deliver 165 cfs of water, and is approximately 165 miles in length. WMX has been key in letting a diverse team of stakeholders coordinate landowner information, surveys, and project status on a parcel level basis in both projects.
Lucas Rengstorf (AE2S)
Bowling Green Municipal Utilities Dispatch Operations and Infrastructure Condition Analytics
Since adopting Esri’s Small Utility ELA program, our GIS capability has grown by leaps and bounds. We would like to showcase two examples of implementing ESRI technology: (1) implementing the Esri’s DigAlert solution at our utility, and (2) developing a Water/Wastewater Infrastructure Condition and Criticality Rating System using Esri’s Spatial Analyst and Geoprocessing toolsets. On average, our utility receives more than 500 locate requests a month through Kentucky’s Call Before You Dig program. Esri’s DigAlert solution, our “KY811 Ticket System”, provides a way for locate requests to be managed and automated through Workflow Manager Web Edition. The KY811 Ticket System is saving our utility time, money, and increasing efficiency.  Water and wastewater infrastructure condition is a constant concern for any utility, especially in a geographic region known for caves and karst. By utilizing the ArcGIS spatial analytical and geoprocessing tools, along with multiple raster and vector datasets, we developed a rating system to assess the condition and criticality of new and aging infrastructure. This asset condition index allows us to effect a proactive asset maintenance strategy.
Becky Brown (Bowling Green Municipal Utilities)
2:30 p.m. - 2:45 p.m.  Afternoon Break   Sapphire Foyer
2:45 p.m. - 3:45 p.m.  Watershed Erosion (Moderated Paper Session) Sapphire 400 A



Streambank Stabilization: How GIS Helped Create an Assessment and Educational Tool
Streambank erosion, the loss of soil and other material from the streambank, is a common occurance in Kansas. It is a naturally occurring process, but the rate at which it occurs is often increased by human activities, such as urban development and agriculture.

KWO used GIS to create a  streambank erosion assessment. The purpose of the assessment is to identify areas, or hotspots, with erosion concerns and estimate erosion losses to provide a better understanding of erosion trends and rates in particular watersheds for mitigation purposes. It also helps to guide prioritization of streambank stabilization projects by identifying reaches of streams where erosion is most severe in the watersheds above our water supply reservoirs.   

As a result of this tool, KWO has been able to identify over 1,200 streambank hotspots and implement 223 streambank stabilization projects, with more planned for 2018. These have been a key component in the reduction of sediment entering our water supply reservoirs.     

Audience members can learn how KWO worked with multiple local and state agencies to utilize the resources of each to accomplish streambank protection work and educated the public using Story Maps. 
Katie Goff (Kansas Water Office)
Urban Erosion Potential Risk Mapping with GIS
With increased regulatory focus on eroded sediment and its bound pollutants, methods are needed to predict areas with high erosive potential (EP) in urban areas. Using EP to prioritize urban areas for maintenance, installation of Stormwater Control Measures (SCMs), stream restoration or monitoring is crucial. This study utilizes commonly available geospatial layers in conjunction with a computational procedure for prioritizing the contribution of splash and transport erosion to compute relative EP risk throughout a target urban watershed.  Contributing erosive factors evaluated include local cell slope, soil erodibility, land cover, runoff volume, distance and slope to nearest stormwater conveyance point along a surface flow travel path. The ArcGIS Python API automated the process for computing several of the factors used for computing erosive risk.  A case study of the developed methodology was performed on watersheds in Blacksburg, VA, to generate EP risk maps.  Sensitivity of model parameters within the case study area were tested and reported. Resulting maps have been field verified to confirm the efficacy of the methodology.
Randy Dymond (Virginia Tech)
2:45 p.m. - 3:45 p.m. 
Supporting Customer Assets (Moderated Paper Session) Sapphire 400 B
Lead Services Replacements
Manage lead services work replacements. Be able to work with much information and obtain directions to manage the lead replacements.
Locate all the lead services by:
a) Type: main to curb stop / curb stop to property line / property line
b) Material: lead and non lead (total or partial)
c) Diameter.
By using this schema we can significantly cut time and give precise/accurate responses to replacement lead services.
Antonio Lemos
2:45 p.m. - 3:45 p.m. 
Leveraging Billing Data in GIS (Moderated Paper Session)
Sapphire 410
An Innovative Approach: Integrating Billing Software with Esri Workforce to Create Operational Efficiencies
Several rural water systems in Ohio have been leveraging data from their billing systems into Esri Workforce.  Scioto Water1 was the first of these systems, launched in April 2017. Office personnel create work orders through their existing billing system and this data is uploaded through a proprietary synchronization program to Workforce. Field staff have the advantages associated with a mobile work order dispatch system while enabling office staff to track work orders in the existing billing system. Upon work order completion, field staff enter data into Workforce that is uploaded directly into the billing system, eliminating the necessity for manual data entry by office staff. Scioto Water1 averages over 500 work orders a month. Work orders are generated both from the billing system using the synchronization program and through a batch work order creation program that facilitates the simultaneous creation of multiple work orders in Workforce. Leveraging billing system information, batch creation of work orders, and dashboards is saving time and money and improving system-wide communication (both within the utility and between the utility and their customers).
Kerry Zwierschke (Bennett & Williams)
Streamlined Customer Notification Using ArcGIS Online
Efficient communication is paramount in keeping customers safe and well-informed. Using GeoDecisions Notify, Lehigh County Authority (LCA) has been able to seamlessly integrate billing system contact information, critical utility GIS data (e.g. water lines, service connections, valves, and hydrants), and communication tools in one interface. LCA now has the capability to create specific alert areas and send out high-speed phone, text, and email notifications to thousands of customers within minutes.     By leveraging the ArcGIS Online platform, Notify has provided LCA with a Common Operating Platform shared by both management and field staff across multiple devices. Outage polygons created by field staff can now be shared with management, which can then deliver time-sensitive information to customers in real-time.     Better customer communication has resulted in significant return on investment for LCA. In addition to emergency notifications, LCA has started sending out payment reminders to customers scheduled for water service termination. LCA has significantly reduced the number of water shutoffs, which has allowed resources to be redirected to other tasks.
Mark Bowen (Lehigh County Authority)
2:45 p.m. - 3:45 p.m. 
How to Get Started with Drones (Moderated Paper Session) Sapphire 411
Starting from Scratch- UAS Program
Demonstrate how OCWA – Central New York’s Water Authority, a small- medium sized water utility, implemented a UAS program.  -  Demonstrate how OCWA married its UAS and GIS programs with Drone2Map / ArcGIS Pro (emphasis on this)   -  Provide a framework for other utilities to follow in setting up a similar program      
What will be covered:   
- Justifying equipment purchases in a utility environment   
- Low cost equipment selection   
- After the purchase – “OK, now what do we do?”   
- Learning the equipment: common flight settings + planning   
- Pre vs. post UAS program methods for:        
   o Infrastructure inspections (tanks/dam/retention areas/ buildings)   
   o Surface water quality observations (hunt for algal blooms)   
   o Project planning    
   o Construction monitoring   
Combing the UAS program with our GIS program via  Drone2Map
Will Bianchini (OCWA - Central New York's Water Authority)
Improving Drone Output with High Precision Ground Control
Having a drone is a great first step to making your utility more capable of adapting to change quickly. This discussion assumes you’re operating under FAA best practices with certified pilots and a robust safety management system.     

Just having a drone is the first step, adding high precision GNSS ground control points allows you to lock down your imagery and ultimately provide more accurate imagery outputs.  

Add the two workflows together and you have the benefit of imagery data that is much more accurate than stock drone images and you can digitize the details of the flight later without slowing down the field work.
Joel Smith (American Water)
3:45 p.m. - 4:15 p.m.  Afternoon Break Sapphire Foyer
4:15 p.m. - 5:00 p.m.  Living Atlas Content is Ready and Waiting for You (Technical Workshop)
The Living Atlas has become the foremost collection of authoritative, ready-to-use geographic information in the world. This session will provide an update on the Living Atlas and highlight the layers, maps, apps and tools that are most relevant to the water community.  We'll demonstrate the usage of some of these applications and walk through the steps required to contribute to the Living Atlas (including real-time data from stream gauges).
Jonas Rugys (Esri) Sapphire 400 A
4:15 p.m. - 5:00 p.m. 
ArcGIS Solutions Update (Technical Workshop)
Oh the times they are a changing!  In this session we will explore our new utility solutions, ArcGIS Online, and other pieces of ArcGIS that have been updated or added in the last 12 months.   From the new stormwater solutions to the awesome infographic webapp builder template you will be introduced to the latest that we have to offer, and how you can quickly use these new pieces of ArcGIS inside of your organization.
Derek Lorbiecki (Esri) Sapphire 400 B
4:15 p.m. - 5:00 p.m
ArcGIS Pro: It's Time (Technical Workshop)
With the release of the Utility Network just around the corner, it is time for water, sewer, and stormwater customers to start making the transition to ArcGIS Pro.  This session is the place to start learning what you’ll need to know to get your staff ready for the next generation of desktop GIS.  We will cover everything you need to know, from migration, data management, editing, analysis, sharing, and solution deployment—all from the perspective of water, sewer, and stormwater utilities and their needs.
Matt Kennedy (Esri) Sapphire 410
4:15 p.m. - 5:00 p.m
A Complete Mobile Workflow for Your Organization (Technical Workshop)
ArcGIS field apps help you use the power of location to improve coordination and achieve operational efficiencies in field workforce activities. Learn how ArcGIS Apps and ArcGIS for Water Solutions can help you plan, coordinate, navigate, collect, and monitor information in and out of the field. This session will focus on strategies for deploying information to the field using a variety of ArcGIS Apps and Solutions. In this workshop, we will also discuss techniques such as app linking and authoring mobile map packages for offline use in the field.
Jason Channin (Esri) Sapphire 411
5:00 p.m. - 7:00 p.m.  GIS Solutions EXPO and Welcome Social
Sapphire GC

Tuesday, January 30

Time Presentation/Session Presenter(s) Room
7:30 a.m. - 8:30 a.m.  Continental Breakfast
Sapphire West Foyer CD 
7:30 a.m. - 5:00 p.m.  Registration Sapphire West Foyer CD
8:30 a.m. - 4:30 p.m.  GIS Solutions EXPO
Sapphire GC
8:30 a.m. - 4:00 p.m.   Data Health Check/Hands-On Learning Lab Cobalt 502
8:30 a.m. - 10:00 a.m. Water Chemistry (Moderated Paper Session) Sapphire 400 A
Effects of Natural Radioactivity in Surface Water Quality
The presence of uranium and thorium nuclides and their associated decay progeny is predominantly obvious in groundwater where geochemical process allows for the dissolution and transport of radionuclides. Uranium is an element commonly found in rock, soil and water.  WHO has made the recommendation for drinking water limit as 15 µg per liter.  Terrestrial radionuclides also directly impact on the water quality and become available in extracted waters used by humans.  The research area was determined around the village in Turkey. Radium   concentration in water varies dramatically between surface and groundwater. The natural background environmental radiation level varies due to the change in the concentration of naturally occurring series of uranium and thorium in the soil.  The radiological impact of water due to consumption of drinking water was calculated. The effective dose equivalents have been calculated in the range of 50–180   µ  Sv y -1 . Majority of the effective dose equivalents comes from the radon.  The ingestion of radium gives the higher impact factor of natural radioactivity in drinking water of the research area and appropriated remedies should be taken.
Ahmet Osmanlioglu (Instanbul University) 
Comparison Between The Results of Applications of The Canadian, Weighted Arithmetic and Bhargava Methods for Drinking Water Quality Index at Multi Locations in Euphrates River Using GIS Mapping
To understand the Iraqi surface water quality for any intended use, it is important to study the quality of the water & concentration of several parameters by applying Water Quality Indices (WQIs) & GIS techniques which can give an accurate & adequate evaluation as well as indicating pollution, saving required time, water quality management & decision-making. Therefore, three WQIs methods were adopted in this study to assess, compare & judge the suitability of Euphrates River at multi locations inside Iraqi land for drinking purpose. These methods include Bhargava (BWQI), Weighted Arithmetic (WAWQI) & Canadian (CCMEWQI). The  analysis includes several water quality parameters: pH, Temp., DO, PO 4  -3 , NO 3 , Ca +2 , Mg +2 , T.H, K +1 , Na +1 , SO 4 , Cl, TDS, Alk. & EC. These parameters were recorded at the intakes of five water treatment plants selected for the years 2015 & 2016. The results of WQIs classification linked with ArcGIS to produce layers & spatial distribution maps of these indices to show the pollution zones in the river. The spatial analyst tool was employed for interpreting the data by applying Inverse Distance Weighted (IDW) interpolation method.
Mustafa Muwafaq Noori (University of Baghdad)
Extraction, Separation and Characterization of Endotoxins in Water Samples
This study focuses on development of sensitive and reliable analytical methods for determination of one of the key environmental threats, endotoxins, also known as lipopolysaccharides (LPS). For the determination of trace amounts of endotoxins and to remove possible interference materials in environmental samples, a solid phase extraction (SPE) pre-concentration technique was applied. A capillary electrophoresis (CE) method in combination with laser induced fluorescence (LIF) detection was developed for the analysis of endotoxins from different bacterial strains. The SPE targeted at polysaccharide moieties of LPSs and showed LPS enrichment effects. CE migration time could also reveal the O-antigen chain lengths of LPSs. This CE method with SPE pretreatment showed high sensitivity (limit of detection of 5 ng/mL), good linearity (99.84%) and satisfactory repeatabilities (8.44%).  The method was applied successfully in the determination of LPS levels in spiked water samples, and demonstrated sensitive, reproducible and reliable results.
Sam Li (NUS)
8:30 a.m. - 10:00 a.m.
Water Technology (Moderated Paper Session) Sapphire 400 B
Water Flow and Flood Stage Visualization in 360 Viewing
Esri Emerging Business Partners FishViews and GroundVU are working together with Dr. David Maidment of the University of Texas to enable water flow and flood stage visualization in a 360° surface-level view at key locations inCentral Texas' Flash Flood Alley. The pilot project is along Onion Creek in the area of SE Austin, the site of devastating flash floods in 2013.  The team collected imagery and point-cloud data to mesh with existing water flow data.  The expected result is the ability to visualize and model water flows in the horizontal perspective.  This visualization can be used by waterway managers as a decision and analysis tool, by civic leaders for development planning near waterways, and by first responders as a training and real-time tool for disaster response.  When complete, we'll be able to scale hydrologic flows and visually model flood inundation at variable flow rates.
Courtney Gallagher (FishViews Inc.)
Challenges in Building Water Distribution Models one-to-one with GIS
Geographic Information Systems (GIS) are often the best base on which to build accurate water distribution models, and with the rapid expansion in scope and quality of utilities’ spatial data, a frequently cited goal of modeling is to reach a one-to-one relationship with GIS. While the benefits of this correspondence are numerous, ranging from the ease of setting and updating model attributes to importing model results back into the GIS dataset, significant challenges can arise. Network connectivity troubles can cause modeling issues and facility piping can lead to discrepancies between the model and GIS, not to mention the task of efficiently updating existing models in order to bring the piping alignment in concert with more recent GIS. This presentation will provide examples of some model-building strategies by detailing the method for developing large-scale water distribution models for the city of Los Angeles using InfoWater, an integrated modeling add-on for  ArcMap, as well as the challenges of building these specific models to be one-to-one with the city’s extensive GIS.
Ben Chenevey (Arcadis)
Flood and Water Monitoring Systems with GIS + Industrial IoT Sensors
Flood and Water Monitoring Systems with GIS + Industrial IoT Sensors - How does Your organization monitor water? 
Your water monitoring systems are crucial for effective water resources management. With today’s remote monitoring sensor technology and Industrial IoT, you, your teams, and your organization are able to rapidly deploy cost-effective water monitoring solutions.  Whether you need to monitor water wells, piezometers, transducers, water usage with flow meters, levees, water levels, flood warning systems, or anything else, you’ll make best use of your measurement information if it’s integrated with your Esri ArcGIS platform.     

We’ll share our GIS project experiences, successes, and lessons learned with water monitoring and flood warning systems deployed by organizations and Smart Cities that utilize GIS + IoT water level sensors on the east coast of the U.S. – Newport News and Virginia Beach.     

You’ll learn how government agencies, private companies, and Smart Cities become safer, while saving time and money, with cloud tools and GIS for mapping, graphing, alerting, and analyzing real-time intelligence from water monitoring systems.
Pawel Sasik (Valarm LLC)
8:30 a.m. - 10:00 a.m.
Improving the Bottom Line (Moderated Paper Session)
Sapphire 410
Residential Stormwater Fee Tier Setting – A Data Driven Interactive Approach
For St. Petersburg, Stantec created an innovative, data-driven method to understand parcel-specific impacts of implementing more equitable stormwater rate structures.     

Stand-alone stormwater utilities generally employ a fee on  properties to fund their operations and capital investment needs.  These fees can sometimes take the form of an equal per parcel charge, or more commonly, a fee that is the same per equivalent residential unit, reflecting a number of square feet of total or impervious area. The use of tiered impervious area fees can recognize and price the proportionally larger runoff contributions generated by parcels with large areas of impervious areas. Often the challange is in generating the impervious areas for parcels. In this project, impervious surfaces were generated by using the Image Classification Wizard in ArcGIS Pro 1.4 The presentation will describe the time savings recognized through the use of image classification in ArcGIS Pro.
James Hale (Stantec)
How GIS Can Win Your Rate Case
EPCOR provides water and wastewater services throughout the southwestern United States. The utility’s rates are regulated by public utility commissions, such as the Arizona Corporation Commission, which requires proof of water revenue through rate case submittals. Historically, these backward-looking submittals often relied on outdated test years, and geographic information systems (GIS) were not a substantial component until the recent introduction of the system improvement benefit (SIB) rate mechanism. This mechanism helps utilities collect small step increases between major rate cases to help cover asset replacement costs. Like rate cases, the SIB requires justification through accurate and a ditable GIS records. Capturing these crucial records was the focus of EPCOR’s recent GIS-centric asset management system (AMS) implementation in Arizona. While EPCOR’s goals for implementing this AMS go well beyond rate case development, the fully digital and easily auditable GIS-centric work management system will support more efficient filing for future SIB and full rate cases. This  resentation will showcase EPCOR’s AMS in Arizona as well as the implementation benefits realized.
Christina Martinez (Woolpert)
Construction Cost Estimating and GIS
Opelika Utilities is using the ArcGIS platform to perform quick construction cost estimates for their grant-funded capital improvement projects in 2018. For the first time ever, RSMeans Data (North America’s leading source of construction cost information) is available in Esri’s ArcGIS platform through GISinc’s Cost Map. Cost Map is a web-based solution that integrates RSMeans Data API from Gordian with the ArcGIS Platform from Esri to deliver a quick and reliable construction cost estimation process through hosted content, services and costing information. Opelika is using Cost Map to validate construction cost estimates pre and post construction, perform “what-if” scenarios, and forecast future year’s CIPs that leverages RSMeans data’s 3-year forecasted construction cost information.
Alan Lee (Opelika Utilities) 
8:30 a.m. - 10:00 a.m.
Apps in Action (Moderated Paper Session) Sapphire 411
Using GIS For Confined Space Safety
Our health and safety committee is comprised of employees from different business units working toward a common goal of safety. At Illinois American Water, large customer vaults are not company owned. However, we are required to perform meter testing on an annual basis. Because we do not own and are therefore not responsible for the maintenance of these vaults, their condition has deteriorated and presents safety concerns to our employees (missing ladder rungs, collapsing walls, and water infiltration). Because vaults are inspected annually, hazards from the previous year are easily forgotten. Each of our districts currently records inspection results using a different excel or paper based template. In response to these concerns, using input from supervisors and field employees, we have created a vault safety map that provides a platform for communicating these issues to other field users and with management in the office. This presentation will demonstrate how GIS can be used to create a solution to address confined space/vault safety concerns. The how and why behind the creation of this application are very important takeaways that demonstrate the power of collaboration.
Kaitlin Szedlar (American Water)
Collecting Main Breaks with Collector, Survey123 and GNSS Receivers
Fairfax Water in Virginia uses mobile applications to collect field data for workflows spanning infrastructure additions, valve inspections, main breaks, and more. In the past, Fairfax Water used a (now unsupported) highly customized Esri-based mobile application to collect data on legacy devices. Recognizing the need to replace failing GPS equipment and unsupported applications, Fairfax Water sought a non-customized, highly configurable solution that would allow the use of new GPS technology.

Fairfax was already using Collector for ArcGIS and ArcGIS Enterprise to conduct valve inspections. The GIS team explored how Collector, along with a recent release of Survey123 supporting external GNSS / GPS devices, could provide a new solution to main break workflows.
After recommending the use of Collector, Survey123, and the external GNSS/GPS receiver solution internally, the GIS team successfully implemented a solution. Up to 100 non-GIS users were trained on the new ESRI application workflow. Fairfax has found a “sweet spot” in the low-cost, highly accurate, future-proof solution. They have already expanded the workflow for a meter collection project covering 240,000 meters system-wide.
Maria Nieves (Fairfax Water)
Hurricane Harvey Situational Awareness and Response
From August 25 through September 10, 2017 the Beaumont Emergency Operations Center (EOC) prepared, observed, assessed, planned, and executed a response to Hurricane Harvey. During this event, the city sustained damage to critical infrastructure including several sanitary sewer lift stations and eventually Beaumont's drinking water. Using field observations from residents, first responders, remotely controlled drones, and mobile data collectors, Beaumont EOC was able to collect data and create maps with GIS to inform Incident Command and help plan search & rescue, shelter, food & water distribution, and damage assessment operations. The result of these efforts led to a implementation of a mobile emergency operations center platform capable of deploying with short notice to document, plan, and execute the appropriate response during a natural disaster.
Carlos Aviles (City of Beaumont)
10:00 a.m. - 10:15 a.m.  Morning Break Sapphire Foyer
10:15 a.m. - 11:45 a.m.   Predicting Water Supply (Moderated Paper Session)
Sapphire 400 A
Assessment of Watershed Vulnerability to Urbanization and Climate Change
Surface water is a vital resource for humans and  aquatic ecosystems, but hydrologic extremes can produce devastating effects like floods or frequent or prolonged droughts. Understanding how land use and climate interact to influence hydrologic processes is critical for assessing risks associated with future change. This study assessed the combined effects of increased urbanization (forest loss) and climate change on streamflow in a large watershed. The Soil and Water Assessment Tool (SWAT) was used to simulate future streamflow conditions for four paired climate and land use scenarios. The results show that streamflow patterns are generally projected to increase for three of the paired scenarios and decrease in one paired scenario. Base flow decreased in all the paired scenarios, but the decreases were largest in the subwatersheds that lost the most forest. The effects of land use change and climate change are additive when they are combined therefore amplifying the increases in streamflow and decreases in base flow. The most extreme projected increases in streamflow resulted in high flows for half of a year and a ninety-six percent increase in the magnitude of the 100 year flood.
Kelly Suttles (Center for Integrated Forest Science - USFS)
Deficit versus Water Excess
The Southern El Niño (ENSO) oscillation phenomenon determines the climatic regime of extreme events accentuated by climate change in Colombia. The territory presents deficit in the middle of the water abundance. The ENSO effects in dry phase have compromised the supply of municipal aqueducts in Caldas, Colombia due to the reduction of flows. The objective is to estimate the threat of water deficit in municipal aqueducts with supply problems in the Caldas under the context of variability and climate change. The methodology considers hydrological modeling with historical and future climate series for the analysis of water supply and probabilistic estimation of low flows. The results have allowed the identification of the magnitude, frequency and duration of low flows in times of drought and in contrast to the demand, defines shortage scenarios in the municipal aqueducts of Salamina, La Merced and Norcasia. The conclusions allow to alert the aqueducts of the recurrence of such events that will allow, through future Works, to adopt adaptation and mitigation measures, ending the hydro-illogical water cycle detected in Colombia.
Alejandro Marulanda (Universidad Nacional de Colombia)
Assessing High Plains Aquifer Units on the Pine Ridge Reservation in Southwestern South Dakota
Groundwater is a major source of drinking water on the Pine Ridge Reservation. Many reservation wells are completed in the Arikaree aquifer. Water is also pumped from the Ogallala aquifer, then mixed 50/50 with water piped from the Missouri River. The Arikaree and Ogallala units comprise the northernmost extent of the High Plains Aquifer. The Arikaree Formation consists of claystone, siltstone, and poorly consolidated sandstone. The Ogallala Formation consists of fine-grained sandstone as well as poorly consolidated clay, silt, and sand. Silty volcanic ash is also present in this unit.   

Hydrogeologic models have been produced for the study area by the U.S. Geological Survey but as of this date, a comprehensive source-water assessment for the Pine Ridge Reservation has not been completed. Reservation water use has ad-hoc oversight and management. Mixed land ownership within reservation boundaries means that various entities regulate water resources, often with little coordination between entities. Building the geodatabase for this project was the first step in integrating available data from all sources, allowing for water resources to  be quantified.  Aquifer vulnerability assessment is used by scientists and water-resource administrators to guide management of groundwater resources. Assessment parameters include proximity of contaminants to the groundwater system, contaminant load, environmental factors, geochemical properties of contaminants, and fate/transport of contaminants in the groundwater system.   

The goal of this project is to produce products that can be used to demonstrate the value of integrated water resource management. A process-based model published by the US Geological Survey in 2014 will provide data related to physical parameters of the aquifer system. A geodatabase has been built in order to integrate data from the several entities that play a role in water resource use and management on the reservation. Site-specific contaminant and water quality data from several entities are being integrated into one geodatabase so that analysis can be erformed.
Lilly Jones (SD School of Mines and Technology)
10:15 a.m. - 11:45 a.m.  Asset Management (Moderated Paper Session) Sapphire 400 B
Utilizing the LGIM to Enhance Asset Management
The City of Westminster recently implemented the LGIM to enhance utility operation's asset management system. The presentation will highlight the features of the LGIM that directly influence the management of assets and operations for both field personnel and supervisory staff. Leverage the fields in the LGIM helped the City supplement their operations while choosing a new asset management system.
John Nolte (City of Westminster)
A Change Is Gonna Come – Continual Water/Wastewater Asset Management through GIS
Identifying the need for a more proactive approach in managing their horizontal and vertical assets, the Department of Public Utilities sought to develop a streamlined, targeted, and unified process, supported by GIS architecture, to maintain and upgrade its infrastructure. This was an effort to bring increased intelligence to decision-making, aligning dollars to data, to guide effective stewardship and improved sustainability of a water and sanitary sewer system.
Bentley Chan (County of Henrico Department of Public Utilities)
Taking Calculated Risk using ArcGIS Model Builder
GHD assisted the Region of Peel in undertaking a detailed risk analysis of its 4,000 transmission mains and evaluating numerous risk scenarios and events – a GIS tool was created to assist with utilizing and manipulating large data sets in the form of spatial, tabular and institutional knowledge.  The result was 153 of 4000 pipe segments were identified as extreme or high risk of failure in which many were not in the Region’s current capital program.
Ron Galos (GHD)
10:15 a.m. - 11:45 a.m. 
Beyond the App: The Changing Face of GIS (Moderated Paper Session) Sapphire 410
Service Area Facilities "Mapzilla" Portal Web Application
We replaced an existing big box application with a new Portal application. The problem we set out to solve, getting away from the big box do everything application, was more difficult than we realized.  We unwittingly created another big box application, “Mapzilla” was born! Mapzilla is a good example of not escaping the all functionality in one application mindset. 

By trying to replicate the previous application, we made the work harder on ourselves.  Every department was using the previous application but in a different capacity – sometimes completely different then what was intended.

This is a good example of trying to do too much in one application.  Make sure you know what your different users really need.  Meet with your users and show them what is possible, as well as, what is not possible.  We have started creating focused group and user specific applications.
Debra Stein (Sweetwater Authority) 
Knowledge Retention of an Aging Workforce: GPS Data Collection for Water Utilities
It is estimated that we will lose a good chunk of our workforce to retirement. At Illinois-American Water, we are seeing this reality across our service areas. This has prompted the questions “How do we minimize knowledge loss?” and “How do we set up our next generation with the tools needed to be successful?” One answer: A GPS Data Collection program.  Most of us will agree that the foundation of a utility worker’s knowledge is knowing where the piping is installed.

Quick and effective response to planned work, customer issues, and emergencies requires that crews know where and how the piping lays, as well as locations on valves, taps, and customer connections. Even with a seasoned workforce, we estimate that without GIS/GPS, crews spending around 15% of their time, if not more, searching for an asset. Add to that a new workforce and that time is expected to increase exponentially.       

This presentation will discuss the importance of GPS Data Collection to the success of a water utility and how it can be a viable and thorough solution to mitigating knowledge loss. We will also discuss additional advantages of a GPS Data Collection Program and implementation strategies.
Shawn Simpson (Illinois- American Water)
GIS’s Trickling Effect through Yucaipa Valley Water District
Yucaipa Valley Water District approaches the use of GIS differently than most companies We’ve integrated GIS into a variety of purposes and positions. All levels of our organizations use GIS in one way or another. We don’t use the GIS application for a certain project or goal, we use it for almost everything. Any project, goal, task, problem we look to GIS to assist us. Our organization does not employ a GIS professional, we have multiple people that use Esri GIS for completely different uses and outcomes.    

This presentation will discuss how GIS is being used in different departments, in various ways, by a wide range of employees. At Yucaipa Water, you don’t have to be a GIS expert to reap benefits: maps of assets, online resources for shutdown information, streamlined permitting processes, simplified customer notifications, up to date water quantity & quality information, and much more. Yucaipa Valley Water Districts’ GIS functionality is used at every level of the organization.
Kathryn Hallberg (Yucaipa Valley Water District)
10:15 a.m. - 11:45 a.m.  Remote Sensing (Moderated Paper Session)
Sapphire 411
Water Scarcity Adaptations in Agriculture Detected with Remote Sensing
Irrigated agriculture in arid basins is susceptible to rising salinity,  infrastructure damage and declining predictability of flows. While aridland farmers adapt to many forms of water scarcity, regional managers are challenged to customize support across a region.   This study asks: How do farmers adapt to water scarcity?   Our study uses remote sensing of MODIS vegetation indices (NDVI) to detect trends in agricultural activity. We observe Northern Mexico’s Rio 
Colorado Irrigation District from 2007 to 2016. In ArcMap and R Studio we reproject imagery, stack images for an annual mean and perform an unsupervised classification. We cluster classes into a typology of  trends in water availability and develop a statistical decision tree to reclassify the image stack. Hotspot analysis of enhanced greenness (greenspots) or reduced activity (brownspots) identifies regional trends and affected farmers. Lastly, we design field tools with ArcCollector and Survey123 to interpret the trends by surveying farmers about the drivers behind their management decisions.
Joel Kramer (San Diego State University)
A “Big Data” Alternative to SNOTEL Snow Water Equivalent: MODIS Snow Cover Extent and Snowpack-streamflow Dynamics of Western U.S. Mountain Watersheds
Mountain snowpack provides essential water for people and economies around the world with over two billion people relying on snowmelt water for some portion of their daily needs. To understand the mechanisms that connect snowpack to the streamflow that supports the world’s cities, fields, and industries, we must take a hard look at the tools and data at our disposal.     

Snow water equivalent (SWE) is the most prevalent variable in analyzing the snowpack-streamflow connection and provides a measurement of snow water content at a given point. However, measuring SWE faces significant challenges due to limited access, harsh climate, and expensive equipment. In  addition, many places with a substantial dependence on snowmelt, such as Nepal, have few, if any, weather stations that measure SWE.     

Satellite-based snow metrics may allow researchers to study these remote and unmonitored regions to gain new insight into watershed mechanics. Snow cover extent (SCE) is a measurement of the presence of snow within an area as a proportion of the total area and is available daily with near-global coverage from two of NASA’s satellites. This research explores SCE’s potential value as a “big data” approach to snowpack-streamflow dynamics research through (a) an analysis of the relationship between SCE and SWE, (b) an analysis of the relationship of SCE-based metrics to hydrological, climatological, and topographical variables, and (c) a case study of two hydrologically distinct watersheds, the Gila River Watershed in southwestern New Mexico and the Yellowstone River Watershed in northwestern Montana.
Jennifer Van Osdel (University of New Mexico)
Utilizing Advanced Satellite Imagery and GIS to Re-think Leak Detection
A recent United Nations Water study estimates 46 billion liters of drinking water are lost every day. The non-revenue water problem is important, but solving it is hindered by labor availability and limited acoustic hardware used in today’s leak detection technologies.       

Hydromax USA, in partnership with Utilis LTD, is employing a groundbreaking technology which utilizes spectral aerial imaging taken from satellite mounted sensors to spot leakage in underground distribution pipes. The imagery is overlaid on GIS systems and then processed through algorithms seeking a spectral signature correlated to drinking water. Combining this with client data, we can identify and direct field crews to areas with a high probability of finding leaks.   

Clients are ultimately presented with a graphic interface that depicts each satellite finding via web-enabled GIS.  This is overlaid on a  map of the clients’ system features, and is paired with live GIS data from the field, allowing managers and supervisors to access real-time progress reports. This technology presents utilities with a new opportunity to reduce non-revenue water in a cost-effective manner that far exceeds conventional leak detection.
Andrew Fry (Hydromax USA)
11:45 a.m. - 1:00 p.m.  Hosted Lunch
Promanade Plaza
1:00 p.m. - 1:45 p.m.  Open Data Options for Utilities (Technical Workshop)
The open data movement, inspired by the desire for transparency in government and the need for innovation, created the foundation for ArcGIS Open Data and ArcGIS Hub.  This session will cover how open data relates to utilities and the larger civic ecosystems to which they belong and will provide an technical overview of ArcGIS Open Data and ArcGIS Hub.  We'll take a deep dive into configuring an open data site (both for internal and external audiences) and putting this data to work in the form of initiatives which are managed and administered by ArcGIS Hub.
Jonas Rugys (Esri) Sapphire 400 A 
1:00 p.m. - 1:45 p.m. 
Integrating ArcGIS Enterprise with the IoT (Technical Workshop)
Is your Utility IoT ready? The Internet of Things or IoT is changing the way we do business and manage information. Learn how ArcGIS supports IoT and how you can ensure your utility is IoT ready. This technical workshop will focus on ArcGIS Enterprise and the GeoEvent and GeoAnalytics Server Roles. In this session, we will also discuss the different types of Data Stores and their importance within the overall strategy for your utility's location data management.
Jason Channin (Esri) Sapphire 400 B
1:00 p.m. - 1:45 p.m. 
A Complete Drone2Map Workflow for Your Organization (Technical Workshop)
Drones are used for everything from delivering packages to taking the perfect selfie. But did you know you can make your drone work for you? With Drone2Map for ArcGIS you can update aerial imagery basemaps, perform safer inspections, model your infrastructure in 3D, and much more. In this session, we will discuss the complete Drone2Map workflow for a water organization including flight-planning, processing data, creating products, and managing all that information.
Corey Gens (Esri) Sapphire 410
1:00 p.m. - 1:45 p.m. 
The Utility Network - What Your Need to Know About What's Coming (Technical Workshop)
The Utility Network is a new extension specifically for utility professionals in water, sewer, and stormwater industries. It's designed to improve the way you deliver, manage, and analyze your data by working natively across the entire ArcGIS platform. This session will give an overview of the technology and of the new data structure to aid your understanding of this fundamental new ESRI technology.
Andrew Hargreaves (Esri) Sapphire 411
1:45 p.m. - 2:00 p.m.  Afternoon Break
Sapphire Foyer
2:00 p.m. - 3:30 p.m.  Using GIS for Flood Management (Moderated Paper Session)   Sapphire 400 A
City of New Braunfels Leverages Solutions from ArcGIS to Improve Flood Preparedness and Response
The City of New Braunfels, Texas is situated near the Guadalupe and Comal rivers which pose a continual threat of flooding. In 2016, the City’s GIS Department started utilizing ArcGIS Solutions for Flood to empower various departments and decision makers to help them understand how potential flood events will impact their community. Utilizing data analysis and enterprise spatial technology has provided the City a better way to prepare for, mitigate, and respond to flood events.
Greg Brown (City of New Braunfels, TX)
Flood Inundation Mapping Using GIS Techniques
Flooding has been recognized as one of the most common natural hazard faced by many countries.  Geographic Information System (GIS) has made  substantial contribution in various fields including flood protection applications.  
 
Derivation of flood inundation mapping is the first step for the analysis on flood protection measures. GIS and Remote Sensing with other datasets provide enormous potential for identification, monitoring and assessment of flood disaster. This paper covers firstly, the analysis of satellite images for identification of flood followed by derivation of flood inundation map, secondly catchment delineation  through well defined processes of Arc GIS and finally assessment of accuracy of the flood inundation map.  

A catastrophic flood in the year 2011 was taken as the case study for this research. Landsat 7 satellite images were used. The images with band composite RGB:453 were combined together and performed image classification to derive the flood inundation map.    

The flood inundation map was overlaid on the catchment delineation to decide the most flood prone rive Accuracy assessment was done using Kappa statistic
 method combining with Arc GIS tool.
Meera Sahibu Mohamed Rizwan (National Water Supply & Drainage Board)
Increased Flood Scenarios in San Juan County, WA
The Federal Emergency Management Agency (FEMA) develops a series of Regulatory and Non-Regulatory products to analyze flood hazards. Regulatory Products include Flood Insurance Rate Maps (FIRMs) and Flood Insurance Studies (FISs). These products are used as the basis for official federal requirements, such as determining the flood insurance rating system and construction standards. 

Non-Regulatory Products are supplemental to Regulatory Products and give the user a broader view of the analyzed flooding. This presentation will focus on describing the production of one of the Non-Regulatory Products, Increased Flood Scenarios (IFS), for San Juan County, WA. The IFS product shows how the extent of inland flooding with hypothetical sea level rise or increased Base Flood Elevation (BFE) changes values. 

Atkins performed a coastal flood study for San Juan County in Washington. The County is in the Salish Sea between the US and Canada; it is an archipelago composed by 8 main islands (Stuart, Waldron, Orcas, Blakely, Decatur, Lopez, Shaw, and San Juan Island) and several smaller islands. The coastal study was followed by the development of Non-Regulatory Products, including Coastal Flood Depth Grids (CFDG) and IFS.  

In this case, the IFS shows what the flooding would be if the BFE were 1, 2, or 3 feet higher than present-day FIRM elevations. ArcGIS used to develop the deliverable. The IFS products are derived from the 1% annual chance CFDG (1% annual chance values are the BFEs on the FIRM). To develop the IFS, a hypothetical value of 1 foot is added to the 1% annual chance CFDG to account for future sea level rise. After this is done, the topography is subtracted from the raster with the added hypothetical value. The output raster is converted to a polygon which represents the +1 foot scenario.  These steps were repeated with +2 and +3 feet hypothetical BFE+ scenarios. 

For the most part, the San Juan Islands region is characterized by steep shorelines. The horizontal flooding difference will likely not affect people living on cliffs or higher areas. However, there are flatter areas like the Orcas Island Airport where the difference between the 1% base flood and the +3 feet scenario can be as high as 500 feet. 

This product can inform planners to assess mitigation options, for example, buy outs versus elevating structures on piers versus shoreline protection.
Naomy Perez-Sanchez (Atkins)
2:00 p.m. - 3:30 p.m.  Leveraging CMMS Solutions (Moderated Paper Session) Sapphire 400 B
Mapping and Publishing Proposed Infrastructure to Facilitate Utility Inspections and Development Impact Evaluations
Facility IDs are created when features are digitized into our GIS, utility inspectors had to create temp Facility IDs to link our CMMS (Lucity) and GIS for inspections during a projects construction phase. As a result, we had a big problem not being able to match temp Facility IDs to the permanent Facility IDs and, therefore, inspection data was not linked to the proper features. To rectify this, we started mapping and then, using ArcGIS for Server, publishing proposed infrastructure once the construction plans were approved, thus creating a Facility ID that will forever be associated with those features. In the short time we have been doing this we have realized several benefits. First, there is no longer any confusion trying to match Facility IDs in Lucity and GIS. Next, using the web application, inspectors are able to get a big picture view of projects to ensure they are being installed as designed. Finally, planners, engineers, and utility managers are able to see where projects are proposed so they are able to evaluate overall system impact, coordinate with other developments, account for capacities, and better answer citizen inquiries about new construction in their area.
Mike Pappas (Gwinnett County DWR)
Digital Transformation in Victorville
Located in the High Desert of Southern California, the City of Victorville is home to over 120,000 people. The city manages nearly 700 miles of pipe in their potable water system and 440 miles of sewer line to serve over 35,000 connections. The City has turned to Sedaru to help build their GIS data and transform how work is assigned and completed. The Sedaru services team worked with the city to enhance their GIS data, building all the attribute information for their infrastructure and ensuring that locations were accurate.     The City also implemented Sedaru to transform how work is created, dispatched, and completed. In the field, crews use Sedaru to access their work along with GIS data, so they understand how the assets they are working on are connected to the rest of the water network. This enables them to make more informed decisions and improve interactions with customers. As they complete their work, the Sedaru mobile app provides a customized streamlined interface for crews to consistently enter all the information needed to complete the work order, thus significantly reducing the need for paper, and eliminating duplicated data entry.
Brandon Cales (City of Victorville)
GIS and Asset Management, an Effective Stormwater Planning Tool
The City of South Lake Tahoe GIS program continues to evolve with the addition of an Asset Management Program, VUEWorks. This AM-GIS combination provides new possibilities in stormwater planning by integrating GIS, Operations & Maintenance and the public. GIS is used to map stormdrain infrastructure, flood zones and localized flooding, but many problem areas have gone unreported. The City’s VUEWorks system features a web portal that allows the public to report concerns and request services. O&M crews immediately receive Service Requests and create Work Orders to respond to Service Requests. Work orders are assigned to specific assets and tracked using GIS and VUEWorks databases. Back in the office, VUEWorks allows the GIS Manager to track Work Orders along with their associated assets. Many are in similar locations, and a single asset may receive multiple Service Requests. The GIS Manager can flag these locations and cross reference the data with known flooding/problem areas.  By mapping known problem areas that receive multiple Service Requests, the Stormwater Manager can now justify stormwater projects in those locations.
Eric Friedlander (City of South Lake Tahoe)
2:00 p.m. - 3:30 p.m. 
Customer Success Stories (Moderated Paper Session) Sapphire 410
ArcGIS Network Editing Tools simplifies Data Management
Until recently, San Jose Water leveraged Intergraph GeoMedia Professional tools coupled with Oracle/Oracle Spatial database for its GIS platform that was used for over ten years. With recent transition to Esri technology, several Oracle triggers were replaced with   Attribute Assistant functionality of the Water Utility Network Editing toolset while continuing to use Oracle and Oracle spatial as the backend which makes the implementation standout. 

 As part of data model development several triggers were developed to auto populate certain attributes and several Water Network Editing Construction tools were configured to auto generate laterals while placing point features to streamline the data maintenance process and as well as maintain overall integrity of the data being edited/inputted by GIS Specialists. 
Leena Gautam (San Jose Water Company)
Keep It Flowing - A Water Utility GIS Story
The Oldham County Water District of Kentucky began using GIS in 2001. Since that time there has been a huge growth in the number of customers served. To better manage and maintain the water infrastructure, OCWD has also grown their mapping efforts.  Definitive moments along the way will be discussed.  As this is a tale of growth and adaptation, the Esri Story Map will be the method of communication for work flows past and present, goals for the future, and lessons learned along the way.  Most recently, the agency committed to the Small Utility Enterprise License Agreement with Esri.  This has led to increased development and use of mobile solutions for capturing field  information as accurately as possible.  All staff are able to view the latest spatial infrastructure information for enhancing system operations and customer service.  Leveraging resources made available by this decision, technical aspects will be presented demonstrating the movement to a true Enterprise GIS.
Kenny Ratliff (Oldham County Water District)
Using GIS to Realign Valve and Hydrant Maintenance Routes
In May of 2013, Illinois-American Water (ILAW) implemented a GIS. One of our first tasks, based on several needs assessments completed with our Operations groups, was to map out our district’s valve exercising and hydrant inspection maintenance routes. In doing so, we were able to see the geographic extent each route covers, the degree of overlap amongst the routes, as well as the path our field crews were taking when traveling from asset to asset. The resulting maps showed an extremely high degree of overlap, as well as widely varying extents and paths that did not follow a logical asset-to-asset sequence. By using the analytical tools within our GIS, we have been able to easily realign our maintenance routes for several of our districts, giving us a total reduction in miles of over 10,000 miles!   This presentation will showcase how we were able to use GIS to not only generate the visuals and information about the current state of our maintenance routes, but how we were able to use the analytical tools within GIS to realign our maintenance routes, as well as a short discussion on the operational efficiencies gained through this analysis.
Shawn Simpson (Illinois-American Water)
2:00 p.m. - 3:30 p.m. 
Mobile Field Optimization (Moderated Paper Session) Sapphire 411
Streamlining Operations with Collector for ArcGIS
In the utility field, collecting and keeping up-to-date GIS data is essential for keeping business processes operating at peak performance. Recent advances in software and hardware have enabled American Water, the largest publicly traded U.S. water and wastewater utility company, to collect and record data more quickly and easily than before. This presentation will show how Collector for ArcGIS, paired with high accuracy GPS equipment, has enabled American  Water to collect and view GPS-based digital as-builts in real time. We will discuss challenges overcome as well as the benefits of using Collector for ArcGIS-based digital as-builts.  We will also provide demonstrations to explore our collection process, and the products of our data collection.
John Winston (Indiana American Water)
Using Collector to Improve Water Distribution Flow & Pressure Testing
Mobile GIS applications can greatly enhance the efficiency and implementation of non-routine water distribution system testing, such as that performed during hydraulic model building and calibration.  Water resource specialists have used ESRI’s Collector platform to organize field data ranging from flow and roughness tests to widespread ressure surveys. Despite the diversity of projects, Collector retains consistent functionality: mobile maps replace paper mapbooks during site identification, field data is recorded directly to a geodatabase rather than jotted down as a note, and office staff can track team progress and provide support in real time through ArcGIS Online. This presentation will provide multiple examples of mobile software utilization in field work conducted along the west coast.
Ben Chenevey (Arcadis)
Holistically Enhancing Field Operations with GIS
The Camrosa water district improved operational efficiencies utilizing GIS. The district was facing fragmented information, communication breakdowns, and a very reactive posture.  It was determined that a GIS based solution was optimal. Five different mobile GIS capabilities were developed and compiled into
 a single interface. These include field asset management, “as built” retrieval, GIS change order, billing integration, and emergency meter reading apps.   

 As a result, unprecedented real time information is now available to field operators, including historical maintenance trends/records. Due to a common operating picture, the district improved communication, dispatching, and cut response times. By providing the necessary data an analytically based preventative maintenance program was adopted.  Furthermore, management now has the right tools for optimal resource allocation.  

These efforts have proven that GIS technology is mature and streamlined enough to be introduced as a powerful tool to non-GIS professionals. Implementing GIS directly into the hands of water operators has drastically increased capabilities, improved decision making, and significantly saved time and money.
Eric Garcia (Camrosa Water District)
3:30 p.m. - 3:45 p.m.  Afternoon Break Sapphire Foyer
3:45 p.m. - 4:30 p.m.  Insights for ArcGIS: The New Frontier in Spatial Business Intelligence (Technical Workshop)
Most utilities have an array of data about their daily operations, living in the various systems they manage.  The challenge is how to understand these vast amounts of data that build up over time. Big datasets, and the many subtle patterns and trends hiding within, are not always easy to handle with traditional analysis tools.  Insights for ArcGIS is a web-based data analytics tool that lets you explore spatial and non-spatial data all in one place.  Insights’ data exploration and iteration capabilities will help you uncover the secrets that lie in your data, helping you to uncover the next questions to ask as you seek to better manage your operations.  Come and see how Insights can help you connect, explore, and analyze your organization’s data.
Matt Kennedy (Esri) Sapphire 400 A
3:45 p.m. - 4:30 p.m. 
Getting Real with Workforce for ArcGIS (Technical Workshop)
Smart devices, smart workers, and real-time awareness have been transforming daily operations for water organizations. Workforce for ArcGIS allows you to plan, coordinate, and assign work more efficiently. This session will help you understand how to use Workforce for ArcGIS along with the ArcGIS Apps for the field to maximize efficiency in your field workforce.
Deilson DaSilva (Esri) Sapphire 400 B
3:45 p.m. - 4:30 p.m. 
Survey123: The App You Aren't Using But Should Be (Technical Workshop)
One of the most underutilized applications in the water industry is Survey123 for ArcGIS. Survey123 is an intuitive form-centric data collection application that all organizations can use. In this session, we will cover important concepts of Survey123 including how to get started, advanced capabilities, and how to analyze data once it's collected.
Corey Gens (Esri) Sapphire 410
3:45 p.m. - 4:30 p.m. 
Getting Your Organization Ready for The Utility Network (Technical Workshop)
The Utility Network is designed to work natively across the entire ArcGIS platform. However, you'll need  more than just  the suite of ESRI apps to be UN ready. Join us in this session to learn how you'll need to also get your data in order for this migration in order to take full advantage of all of the capabilities offered by this new, fundamental ESRI technology.
Derek Lorbiecki, Andrew Hagreaves (Esri) Sapphire 411
4:30 p.m. - 5:00 p.m. Closing Session Sapphire DH
5:30 p.m. - 7:30 p.m.  Networking Social 
To Be Announced

Wednesday, January 31

Time Presentation/Session Presenter(s) Room
7:30 a.m. - 8:30 a.m.  Continental Breakfast
Cobalt Foyer 
7:30 a.m.  - noon Registration 
Sapphire West Foyer CD
8:00 a.m. - 4:30 p.m.  Using ArcGIS for Water Utility Training-Separate Registration is Required
Cobalt 502
8:00 a.m. - noon Tour #1 - Advanced Water Purification-Separate Registration is Required
8:00 a.m. - noon Tour #2 - Carlsbad Desalination Plant-Separate Registration is Required 
8:30 a.m. - noon  Flood Symposium  David Totman, Dean Djokic (Esri) Cobalt 520

Thursday, February 1

Time Presentation/Session Presenter(s) Room
8:30 a.m. - 4:30 p.m.   Using ArcGIS for Water Utility Training-Separate Registration is Required   Cobalt 502
noon - 1:00 p.m.   Lunch   Promenade Plaza