July 10- The City of Monroe, North Carolina, a municipality with electric, gas, water, and sewer utilities, has recently completed its geographic information system (GIS) migration to ArcFM/ArcGIS 8.x technology with the help of Miner & Miner (M&M). The utility completed the implementation of a powerful, full-scale GIS that provides integrated problem solving, greater operational and engineering efficiencies, improved decision making, and tremendous cost savings. The City of Monroe uses ArcFM along with ESRI’s ArcGIS and ArcSDE on an Oracle database.
The city is using ArcFM for its energy services including the gas and electric departments and for its water resources including the water and the sewer departments. In addition, many other functional areas are using ArcGIS such as administration, collections, planning, engineering, economic development, building standards, and the police and fire departments.
Prior to the implementation of its GIS, Monroe had maintained data in various formats across the utility, which did not allow internal users to effectively share information. Hence, large efforts were required to maintain and disseminate information with data creation, collection, and analysis often being duplicated within various departments.
In September 2000, M&M began assisting the city in migrating AutoCAD data, attribute data stored in external database management systems, and applications from the ARC/INFO 7.2 environment to ArcGIS and ArcFM 8.x technology. ArcInfo coverages were created from the various data sources, then moved into the target ArcFM/ArcSDE database. A series of data quality assurance/quality control routines were run against the database in preparation for the data and application installation and a review process was in place to ensure data quality.
To support immediate business requirements, M&M began migration with production data conversion of the wastewater system, followed by the electric and gas conversions. In addition to the core implementation, M&M developed an application to link customer information to service meters. The application provided a batch update to populate and update GIS data with appropriate information from the city’s customer information system (CIS). The city now has the ability to be more proactive on customer service needs, and it opens the door for further GIS/CIS integration.
The City of Monroe is now benefiting from one integrated cohesive data repository for all electric, gas, water, and sewer records, which allows users to share information throughout the enterprise. The ArcFM solution also provides the city with one common application environment to more efficiently maintain its utility data.