GIS-based Water Utility apps from Esri’s Local Government Information Model are improving the way field crews and citizens use and interact with water, sewer, and storm water GIS data by enabling field personnel to actively participate in communicating with the GIS department and with citizens.

Frontier Precision (formerly Elecdata) has worked with the City of Twin Falls for many years providing high-accuracy data collection hardware, software, and training.  Now we are also helping the city to implement some of the maps and apps available from Esri’s Local Government Information Model.

Multiple objectives were identified at the city’s public works department, including migrating water and sewer GIS data into a standard schema, providing better access to this data in the field, enabling field crews to find and report water outages electronically, communicating more efficiently with citizens, and reducing calls to the city regarding water restrictions and outages.  Boil orders are relatively common in the older parts of town, and the public works department works hard to continually improve communication with its customers.  By migrating data to the Local Government geodatabase water and sewer networks, and implementing the Water Isolation Trace, Outage Viewer, Map Change Request, and Water Restriction maps and apps, we hope to help in achieving these objectives and improve workflows and communication.  The City of Twin Falls GIS system is well-established and well-managed, and we have been able to leverage their ArcGIS Server and ELA (Enterprise License Agreement with Esri) to assist in these tasks.

Data Migration

The biggest challenge of the project was the data migration… isn’t data management always the biggest challenge?  The City of Twin Falls is a long-time user of Trimble mapping hardware and software, and TerraSync was, and still is, used to map most of the assets in the field.  Over the years, data dictionaries have evolved to accommodate new and changing data collection requirements.  This resulted in varying attribute values and inconsistent field naming conventions.  The city desired a standard schema moving forward.  The Local Government geodatabase provided that standardization and was modified only slightly to accommodate some additional layers and specific attribute needs.  Domains were reduced to be more appropriate for the city’s assets.

The city’s field crews continued to collect additional data in the field and many users were accessing the water and sewer data from day to day, so it was important that there not be a long period of down time as data was migrated.  Therefore, Frontier Precision decided to leverage the Data Interoperability extension to build an ETL (Extract, Transform, Load) tool that would allow us to automate the migration.  Once the tool was ready, the city shut down data collection and data access for only one day.  Frontier migrated all data to the new schema, updated data dictionaries to match, replaced the old data on the server, and helped to ensure that any maps and scripts that touched this data remained intact and functional.

Geometric Network

The Isolation Trace application was the biggest target for this project.  However, this application does not work without a working geometric network.  This had not been set up in the existing data.  To make data entry as efficient as possible, the local government geometric network was edited by adding rules to ensure the correcting fittings and valves were created as water lines were connected.  The network is now functional enough to run the geoprocessing tool hosted on the city’s server, but the work is ongoing to connect all the meters in the city to the main lines and update all the connections with the proper valves.  The functionality of the trace application will continue to improve as this work continues.

Local Government Apps

City of Twin Falls field crews work with laptops in the field and utilize Cityworks software for many of their asset management tasks.  This existing access to secure GIS data allowed Frontier to easily configure web applications to run on these field laptops.  The four major applications that were created for the City of Twin Falls’ water department include two secure applications: a Map Change Request app and the Water Isolation Trace app, and two public-facing apps: the Water Restriction and the Outage Viewer app.  Additionally, Frontier had configured the Water Alert app, but the city preferred to have outage and boil order information all available in the same application.  Frontier modified the applications slightly to combine the two applications and add some additional layers suggested by the users.  For additional details and demonstrations of these applications, look for our upcoming webinar on this customer story.

Get More Information

For additional information on Frontier’s GIS Services and to discuss how we may be able to help you, contact Chase Fly – chase@frontierprecision.com.

 

Authored by Karissa Giles and Alison Walker

Solutions

Frontier Precision has a 30-year plus track record of helping you provide a measure of excellence. It all ladders back to our core philosophy of How You Measure Matters. It’s why each day, we seamlessly connect the physical and digital worlds through technology to improve how we all better interact with the earth in meaningful ways. Our tools and solutions make you more efficient, productive, and most importantly, profitable.

Products

Frontier Precision knows that every measurement its customers take is important. It’s why Frontier Precision not only offers the latest, cutting-edge measurement tools, but also understand the continuing need for service and support — because How You Measure Matters encompasses the total customer experience.

Professional Services

From Geospatial Services to GIS Professional Services to Water Resources Data Acquisition Services, Frontier Precision delivers leading-edge measurement technology. We’ve been there, every centimeter of the way, as geospatial technology has evolved. No matter what your need for accurate measurement, we have the experience and expertise to create a customized solution for you.

 

Training & Events

We give you the proper training on the solutions we sell. Sign up for Professional Certified Training to get up and running quickly — all backed by the most experience in the industry. Whether onsite, online or in the classroom, we are helping make our customers efficient, productive, and profitable with today’ s and tomorrow’s technology.

Support

Frontier Precision provides world-class support from centers across a wide section of the western United States. Need support for any geospacial products, software or services?

Contact Frontier Precision at 800-359-3703.

About Frontier Precision

Frontier Precision’s measure of excellence can be traced back to 1988. Four years later, in 1991, Frontier Precision partnered with Trimble — a United States-based GPS equipment manufacturer at the time, and the rest is history. Since then, Frontier Precision has grown with Trimble to be one their largest and best geospatial distributors in the world.

We’ve been at the frontier of technology for three decades, continually offering customers new tools and solutions, all with our end goal in mind to help make our customers efficient, productive, and profitable with today’s and tomorrow’s technology. Frontier Precision is an employee-owned company — each of our team members is committed to your success.

Contact Frontier Precision

WHEREVER YOU ARE, WE ARE.

From our original office in Bismarck, North Dakota, we’ve grown our footprint thousands of miles in every direction.Today, you’ll also find us in South Dakota, Minnesota, Colorado, Alaska, Montana, Idaho, Hawaii, Wyoming, Oregon and Washington — delivering the Frontier Precision difference to more people each day.