The Greater Cincinnati Water Works (GCWW) has been using GIS since 1989. During the past 22 years, our agency has managed to stay abreast of the rapid changes and expansions of GIS pertaining to different facets of water utilities. The latest change has been the development of a fully functional, interactive Web-based GIS platform. With Web-based mapping, regular updating and maintenance of the GIS on individual workstations is no longer needed. And with more than 100 GIS workstations at the GCWW, responding to and solving functional GIS problems has been made easier.

The GCWW works closely with the Cincinnati Area Geographic Information System (CAGIS) consortium. This consortium provides GIS services for departments in Hamilton County, Cincinnati and municipalities throughout the Greater Cincinnati area. CAGIS went live with a Web-based countywide GIS interface in January 2010 (Figure 1). This provided a base for which all consortium members could use to build or expand their own GIS layers and their respective attribute information.

 


Figure 1: View of the Cincinnati Area CAGIS home page.


The front-end interface was developed using Adobe products and Esri ArcGIS Server Web services. The GCWW is currently migrating all of the water data over to this Web-based interactive map. When completed, users will be able to see all water-main data throughout the service area, along with facilities, hydrants, branches, valves, fittings, critical need customers, premises and capital project areas as an overlay of CAGIS, aerial photography, topography and planimetric-tiled layers.

The back end of this system supports these Web maps, and potentially 100 or more internal users. It’s a distributed environment involving five servers that consist of two ArcGIS Server Object Manager (SOM) machines and three ArcGIS Server Object Container (SOC) machines. The SOM machines are “server managers” that handle all incoming requests. They manage the SOC machines and offload all processing to the three SOC machines. The SOC machines are the workhorses. All data is stored on the SOC machines in Esri’s file geodatabase (FGDB) format. The FGDB exists on all three machines and each FGDB houses the GCWW’s water data and other planimetric data. The data in each FGDB is replicated from our production Oracle database. The SOC machines spawn processes for each request generated from the SOM. These processes perform the work to provide data back to the map. This created a distributed environment that provides processing power, data redundancy and fail protection.

One of the problems faced by the GIS users at the GCWW was the increased complexity of the GIS as it evolved over time. The accompanying photos (2a and 2b) show the old and new interface when using the zoom tool to locate a specific water service area. The new version made the process more user-friendly by eliminating the display of all the layers, tools and options that were formerly on one window. With the new Web-based version, tools and options relevant to a user’s requested function are displayed inside the widget that pops up when a tool is selected from the main toolbar across the top of the main page.

Data is shared through CAGIS with other members of the consortium. However, due to the security of sensitive infrastructure data, permissions are carefully set to allow only authorized users to access certain tools and functionality (i.e., the locations of water mains and all their respective attribute data such as flow rates, pressure, pump station statistics, etc.) will only be available to GCWW engineers and distribution and supply personnel. 

The GCWW’s move from client-based to Web-based GIS services has increased production for current users and has made inroads for new people to learn the system due to its user-friendliness. The fact that it is now Web-based allows easy access for users limited to a Web connection. Field personnel with laptops can access it with a simple wireless connection.

An interactive Web-based GIS service eliminates a huge portion of maintenance and troubleshooting normally done with local client-based services. The future time and labor hours saved by moving in this direction can be significant, especially if the organization is responsible for hundreds of client workstations. One measure of the return on investment can be realized in just a few months — after deployment of the Web-based service — by measuring the reduction of time spent on maintenance and updates to client workstations.


Figure 2a: Old client-based GIS



Figure 2b. New Web-based GIS


Keith Wempe and Lorraine Jordan of the Greater Cincinnati Water Works contributed to this article.

Chris Mencini  |  GIS Administrator, Greater Cincinnati Water Works

Mencini is a GIS administrator for Greater Cincinnati Water Works.