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.
