Integrating Smallworld Data into an Esri Environment At Puget Sound Energy

Project Summary

Project Type:

Data Conversion

Locations: 

Western United States

Number of Customers: 

1.1 Million +

Applications:

To convert Smallworld Data into
an Esri environment

Solutions Implemented:

EpochSync

Customer Benefits

Converting legacy data

Enhanced geospatial data

Use of Esri products

The Challenge

Puget Sound Energy, a gas and electric utility company serving 1.1 million customers in the Pacific Northwest, has continued to supply their customers with natural gas and electricity since 1997. With their customers continuing to grow, PSE needed to have a better way to visualize their geospatial data across the enterprise. Esri was chosen for its web and portal technology and being able to disseminate the geospatial asset data. In order to complete this, PSE needed a way to efficiently extract the data from their legacy Smallworld system.

The Solution

Users throughout the PSE Organization can now access GIS Data any time they are connected to the web on the PSE Network. In the future, PSE may decide to expand this to public-facing servers that would allow access to users using any device connected to the internet.

Epoch Solutions Group recommended the use of EpochSync, an application to seamlessly migrate Smallworld data into an Esri enterprise geodatabase hosted in SQL Server. This involved an initial full synchronization of the data and, afterwards, ongoing periodic synchronization of incremental changes from Smallworld. Once this data was available on the Esri Server, the web architecture was leveraged to provide applications to end users that allowed them to log in through a single portal and access several different geographic datasets, whether or not that data originated in Smallworld.

PSE also had a need for several custom tools to be provided to their users, including an electric and gas distribution network tracing tool and a web markup tool allowing users to submit change requests to the electric distribution data administrators. Epoch Solutions Group built these tools into applications.

The Results

Users throughout the PSE organization can now access GIS data any time they are connected to the web on the PSE Network. In the future, PSE may decide to expand this to public-facing servers that would allow access to users using any device connected to the internet.

Related Posts