Oxford Water Works & Sewer Board is located in Oxford, Alabama - about an hour east of Birmingham, Alabama. Oxford has a population of 22,300 and Oxford Water has about 9,800 H2O customers in the community.
A few years ago, Oxford Water was facing a number of data-related challenges prior to partnering with GISinc. With no GIS, teams were relying on old CAD maps, hand-drawn valve location drawings, and very few as-built maps. Their field crews were working off of memory and old paper maps that were in poor condition and the GPS equipment they eventually purchased for locating assets was not providing the accuracy they needed. The equipment was also cumbersome to work with, as it required quite a bit of the data to be hand-typed into their database. Even their billing system, at the time, did not make it possible for the transfer of data - so all of it needed to be hand-typed into their database. They needed help creating a far more efficient data environment that would cut down on the workload and provide easy and accurate access to the wide variety of people who would need it.
To meet their challenges, GISinc traveled to Oxford to take a look at the data environment Oxford Water had in place and plan the road ahead. After offering suggestions, solutions, and analyzing their data transfer issues we got to work on a plan of action that involved setup on Esri's Local Government Information Model (LGIM). We initiated and applied a few editing templates and ETL tools to make data transfer easier from the data collectors to the database. Since the setup of LGIM, we have worked with Oxford Water on additional solutions for online mapping and data collection applications for field crews as well as other team members who need access to the data.
Today Oxford Water is up and running with an upgrade to Enterprise Server, their editing environment has greatly improved, data within their billing system can now be viewed through ArcGIS, field crews and office staff have mobile applications that allow them to interact with data including an Isolation Trace app, FH Inspection app, Infrastructure app, Map Change Request app and a Main Break & Leak Response app.
Their vision for the future is to provide access to all city departments into the server environment. They also plan to expand even more apps for capital improvement, sewer CCTV maintenance, grease traps, production wells, tanks, telemetry, pump and lift stations, and more.