Utility GIS Migration
Brookfield Utilities
Jan 2013 – May 2014
GIS4BUSINESS completed a GIS migration for Brookfield Utilities, a multi-utility client that install and manage gas, electricity, water and fibre networks.
Technical consultancy was provided by GIS4BUSINESS in the following areas as part of the GIS migration from their existing Esri ArcGIS 9.2 solution to version 10.1:
- Architecting the new version 10.1 Esri solution, including database, server and desktop components.
- Installation of all Esri components, including ArcGIS Desktop and ArcGIS Server.
- Configuration of the SQL Server 2012 enterprise SDE geodatabase, including active directory based security.
- Configuration of ArcGIS Server, including security and migration of existing map services.
- Dry-run and live GIS migration including migration of existing data from the Oracle SDE 9.2 database to a SQL Server 2012 SDE geodatabase.
- Development and execution of post-migration data transformation and cleansing scripts to improve data quality and completeness.
- Provision of onsite training, documentation and support during and following the migration.
- Production of various options reports, including for proposed integration of GIS with Microsoft AX Dynamics.
The system was successfully implemented in a live environment and formed the basis for Brookfield Utilities to improve workflows and integration with other corporate systems.
Related Projects
Corporate Address Management
GIS4BUSINESS were involved in design, development and implementation of changes to existing systems, including GIS, during the implementation of a corporate address management solution at Severn Trent Water.
AddressBase Premium Migration
Migration to OS AddressBase Premium represented a significant change. GIS4BUSINESS undertook the design and development of required changes to the existing database schema and custom gazetteer tools within Portsmouth Water’s enterprise Esri GIS solution.
Water Utility GIS Strategy
GIS4BUSINESS were asked to assist Portsmouth Water with defining and documenting a long-term high-level GIS strategy that will drive future improvements, integration and exploitation of GIS within the business.
Related Products & Services
GIS Data Conversion & Loading
GIS4BUSINESS can simplify the maintenance of your GIS data by converting most datasets into the native format that is required by your software or database. We can assist with loading GIS data directly into your database and building processes to simplify regular updates.
System Integration
Increasingly location is embedded into business systems where visualising and analysing data requires system integration. GIS4BUSINESS has undertaken many projects involving integration of GIS functionality with other business systems.
GIS Strategy & Feasibility
A coherent and achievable future strategy for geographic information can enable organisations to successfully implement and fully exploit location within their operations.
GIS Architecture & Design
GIS4BUSINESS has many years of GIS architecture and design experience, working with customers, stakeholders and third-parties to design integrated GIS solutions that deliver operational and financial benefits to our customers.
GIS Database Design & Loading
GIS4BUSINESS can help with designing spatial databases and modelling spatial data to ensure that the design is tailored to intended use cases and performance is not compromised.