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.
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 using Esri’s Web AppBuilder, which integrate with the Esri ArcGIS Online platform. This allowed the electric and gas distribution network data in ArcGIS to be traced in the same manner as in Smallworld’s Electric Office application.
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.