We provided geographic information services (GIS) and computerized maintenance management system (CMMS) implementation services to the Water Pollution Control (WPC) division. The WPC needed to transition from a CAD-based mapping system for its collection system features to a GIS-based system to better support planning, operations and maintenance. Additionally, WPC needed to leverage current software versions and capabilities.
Our team worked with WPC to migrate the existing CAD data into the ESRI Local Government information model. The migration included adjustments and customizations to the template that tailored the data structure to WPC’s needs as well as analyzing their overall department workflows. Once the workflow analysis and data migration were complete, WPC was able to manage all collection system assets within an enterprise ESRI SQL Server database.
As part of the workflow analysis, we reviewed WPC’s key software systems; maintenance/asset management systems were among the most important. The utility had existing software systems to support maintenance management for both the collection system and the treatment facilities, but they weren’t realizing the full benefits of these systems. We set out to help the utility analyze these systems and determine if the existing systems could be better utilized or if a new system was needed. The solution was determined to be the expansion of the Lucity CMMS already used in the city's transportation department.
The first phase of the Lucity CMMS implementation was for the collection system features. This included the analysis of existing maintenance management workflows and re-engineering of the workflows to optimize them within the Lucity system. The existing CMMS data and processes were used as guidance and where appropriate data was migrated from the legacy system. Once the collection system implementation was complete, the Fats, Oils and Grease (FOG) module and and the Facilities module were deployed for the utility's treatment facilities.
In all deployments of the Lucity system, the desktop- and web-based versions of Lucity are being used. We helped WPC and Unified Government central mapping implement and configure the ArcGIS Server tools necessary to support full GIS mapping and integration within the Lucity web tools. This has allowed the utility to provide access to fully GIS-integrated maintenance-related workflows across a wide range of users and departments.
- GIS implementation
- CMMS implementation
- Workflow definition
- System integration
- Database design
- Data conversion
- Ongoing support services