Skip to main content


Buy Article:

$9.50 plus tax (Refund Policy)

Or sign up for a free trial

When Nashville Metro Water Services (MWS) – which includes water, sanitary sewer, and storm water systems – decided to revisit its existing GIS and CMMS, decision makers knew they were ready to move to the next level: migrate the GIS to a geodatabase so more people could simultaneously use the system, and update the CMMS to enable asset management, analysis, and more.

Nashville MWS has been a longtime user of ESRI's GIS software and Hansen's CMMS software. For years the two systems have operated independently; for example, GIS data was recreated in the CMMS as needed, and CMMS data was recreated in the GIS as needed. But as MWS' applications and users have increased – now at least 200 employees access the systems periodically, and 50 people access the systems daily – MWS knew an integrated GIS/CMMS would produce significant efficiencies.

MWS began with a functional needs assessment, performed by Woolpert LLP, to define and gain consensus on MWS' GIS and CMMS goals. The assessment included an in-depth study of how a GIS/CMMS affects data, standards, applications, business processes, information technology, and staffing and organizational needs. Employees at all levels were interviewed about existing and future workflow processes as well as GIS goals.

It was determined that many goals relate to data, businesses processes, and applications. Woolpert and MWS analyzed the goals from a workflow perspective and presented four key issues that had to be addressed:

Issue 1: Hansen/GIS integration;

Issue 2: Infrastructure data maintenance;

Issue 3: Integration with other systems and functions (such as hydraulic and hydrologic modeling, document management, customer information systems, supervisory control and data acquisition, project management systems, and budget management systems); and

Issue 4: System architecture.

Along the way, MWS evaluated a variety of CMMS software options to determine whether staying with Hansen was the best option. MWS chose to stay with Hansen but upgrade to a more sophisticated suite of Hansen products that would expand uses and increase efficiencies. MWS also determined that a custom software application could be written to integrate the new geodatabase and the CMMS.

This paper discusses MWS' functional needs assessment; the technical aspects of the GIS migration to a geodatabase; the CMMS expansion and integration with the GIS to allow crossdirectional data access; and uses and benefits of the integrated GIS/CMMS.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Article Media
No Metrics

Document Type: Research Article

Publication date: 2004-01-01

More about this publication?
  • Proceedings of the Water Environment Federation is an archive of papers published in the proceedings of the annual Water Environment Federation® Technical Exhibition and Conference (WEFTEC® ) and specialty conferences held since the year 2000. These proceedings are not peer reviewed.

    A subscription to the Proceedings of the Water Environment Federation includes access to most papers presented at the annual WEF Technical Exhibition and Conference (WEFTEC) and other conferences held since 2000. Subscription access begins 12 months after the event and is valid for 12 months from month of purchase. A subscription to the Proceedings of the Water Environment Federation is included in Water Environment Federation (WEF) membership.

    WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access. Access begins 12 months after the conference or event
  • Subscribe to this Title
  • Membership Information
  • About WEF Proceedings
  • WEFTEC Conference Information
  • Learn about the many other WEF member benefits and join today
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free trial content
Cookie Policy
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more