www.rmsi.comwww.rmsi.com
Biju Misra | Enbridge Gas DistributionSridhar Devineni | RMSI
Integrated Enterprise GIS solution for Gas Utility Distribution
11th October, 2011
www.rmsi.com
Outline
Introduction
Enterprise GIS Implementation
Enterprise GIS Data Migration
www.rmsi.com
Profile
Enbridge Gas Distribution is Canada’s largest gas distribution utility and one of the fastest growing in North America.
Delivering energy for over 160 years
Enbridge Gas Distribution and its affiliates serve about 2 million customers in central and eastern Ontario, southwestern Quebec and parts of northern New York State.
Enbridge Gas Distribution adds approximately 40,000 customers each year
Among Canada’s Top 100 employers for 2011
www.rmsi.com
Context
GE SmallWorld Customer. A good start for Enbridge 10+ years ago
Leveraged in Distribution Planning but not in other business units
Proprietary and closed technology architecture
Resourcing and ongoing maintenance was difficult
No clear roadmap from GE
Limited 3rd party solution providers
Evolving business needs with more focus on asset management capabilities
4
www.rmsi.com
Preparation & Procurement
Strategy– A holistic view and not just focused on GIS– Developed a 3-5 year Capabilities/Information/Technology Roadmap– Asset management, mobility, and GIS became the focus – A 3-year GIS implementation program emerged
Definition – 60+ stakeholders across business units involved in requirements definition– Requirements used as base for procurement process
Procurement– Extensive evaluation criteria list– Reference checks: Deals won vs Deals lost– Detailed benchmarking with key stakeholders evaluating
5
www.rmsi.com
Implementation
Program Scope– Business process changes– WebGIS and GIS Edit using ArcFM/ArcMap – 9.3.1– Seamless integration with SynerGee for Network Analysis– Integration with legacy system(s)– Data migration/conversion to Geodatabase using Oracle Spatial– Training: WebGIS- 600 users; GISEdit – 80 users– Post implementation support
Governance– Executive checkpoints– Steering Committee with senior managers/Directors– Working committee with core project team– Business stakeholder group
6
www.rmsi.com
Post-Implementation
Support– User support & change management– Application/System performance
Compliance– Process
Governance– Changes and releases– Prioritization
Next steps..– Focus on stabilization, training, usability, efficiency, and program closeout– Develop and execute a roadmap for the next 3 years– Align with Work and Asset management business and technology strategy
7
www.rmsi.com
Key Points…
Get the full picture– Out of the box vs Customization vs 3rd party– Ask for references of the latest wins and of latest losses – Do the best to understand implications to business processes
Build a new end state– Visualize how you will operate in the future and why– Make sure everyone understands– Best time to change anything is when you get there. Don’t miss the opportunity
Governance– Governance does not stop at the end of implementation– Govern towards an end state. The end state may change, but that is ok– Be open to change what does not work and change quickly– Compliance vs Change management thinking– Effective Governance vs Bureaucracy
8
www.rmsi.com
Profile
Delivering a world of solutions
RMSI established in the year 1992, is a focused geo-spatial services provider with a history of over 19 years of experience in providing GIS
data solutions and application software services to utilities worldwide.
RMSI's processes are ISO 9001-2008 & CMMi Level 5 certified, while
data and information security measures are ISO 27001 compliant and
certified.
RMSI Manages landbase, Distribution network database and GIS
applications to provide real-time unified network information for
various business applications
www.rmsi.com
No Data Loss
Minimum Downtime
Ensuring the same “look and feel” of the GIS data for users
Enterprise GIS Data Migration
Migrate from SmallWorld into ESRI
– Facility Network and Associated Landbase
Key Challenges
www.rmsi.com
Enterprise GIS Data Migration
What to Migrate?
Facility Network - Mains,
Services, Valves, Regulator Stations,
Drips, Shutoff Fittings, Rectifiers,
Test Points, etc
Landbase Network - Street
centerlines, Curb lines, lot lines,
Municipal boundaries, Address
Points, building footprints etc
www.rmsi.com
Design and Development of Data Model
Data Migration
Data Validation
Enterprise GIS Data Migration
Process Phases
www.rmsi.com
Detailed study of existing environment,
data and the associated relationships
with various integrated environments
Enterprise GIS Data Model
development
Evaluate the data model to meet
business function requirements.
Enterprise GIS Data Migration
Data Model
www.rmsi.com
Export data from existing system to XML
Import XML data into ESRI staging environment
Migrate from staging to enterprise GIS
Generate logs for validation at every stage– Feature Counts (Values, Mains, Regulator Stations etc)
– Feature Length (mains Length, Services length)
– Attribute data
Enterprise GIS Data Migration
Data Migration
www.rmsi.com
Audit reports (Feature / Subtype counts at various stages of the
migration)
Validation of test results
Final migrated data is deployed into ArcFM database
Enterprise GIS Data Migration
Quality Test & Finalization
www.rmsi.com
Domain values - Feature count validation based on domain values (Subtypes)Ex: Gas Main with 2” Pipe size with PE material and IP pressure class.
Relationships - Feature relationship with different feature class.Ex: Gas Mains and Regulator station or valve.
Database consistency – Database level checksEx: Valid Attribute information checks, Geometry network checks.
Enterprise GIS Data Migration
Data ValidationFeat ure
Class
Subty pe
Code
No of Features in Smallworld (Export)
No of Features in
ArcFM (Import)
Length (Smallworl
d)
Length (ArcFM)
Main
2 5750 5750 625990.13 625989.323 1437 1437 158560.88 158560.814 8570 8570 3238806.31 3238805.715 7793 7793 1517114.12 1517113.676 973 973 114765.31 114765.287 249698 249698 29518629.33 29518619.678 4920 4920 320419.65 320419.919 207 207 26569.64 26569.64
11 23556 23556 1779958.10 1779955.5112 201 201 14328.57 14328.5613 940 940 49126.49 49126.4614 28 28 4702.50 4702.5015 2623 2623 207702.74 207702.4916 1537 1537 417142.83 417142.75
www.rmsi.com
Connectivity rules - Snapping rulesEx: Valve/Service Line to be snapped to Gas Main
Split/Merge rules – Business Rules.
Ex: Gas main split at values and intersections.
White space management –Annotation alignment etc.
Enterprise GIS Data Migration
Data Validation
White space before White space after
www.rmsi.com
Enterprise GIS Data Migration
Results: Positional Accuracy
www.rmsi.com
Enterprise GIS Data Migration
Results: Relative position with Landbase
www.rmsi.com
Enterprise GIS Data Migration
Smallworld Typical issues
Resolved using controls in
XML over annotation
Results: Whitespace management
www.rmsi.com
Enterprise GIS Data Migration
Smallworld Typical issues
Resolved using controls in
XML over annotation
Results: Whitespace management
www.rmsi.com
Enterprise GIS Data Migration
Representation in Smallworld XML Representation in ESRI
Results: “Look and Feel”
www.rmsi.com
– A well defined Data model & standards that meet all business functions is key.
– Process based approach with less manual intervention helped in meeting desired
objectives.
– Migration of over 33,000 KM length of distribution network and landbase data within 3
days of downtime.
– 100% of distribution network data migration to ESRI
– No precision / positional accuracy loss
– Cartography styles & symbology as old environment with no notable “change” for the
users.
Enterprise GIS Data Migration
Summary
www.rmsi.com
Sridhar [email protected] Private Limited, A-8, Sector 16NOIDA 201301, IndiaTel: +91 120 2511102, 2512101http://www.rmsi.com
Questions?
Biju [email protected] Consumers Road North York, ONM2J 1P8416 - 529 – 6352http://www.enbridgegas.com