The Power of Information and Reporting in Damage Prevention
2011 Esri Electric and Gas User Group Conference
The Power of Information and Reporting in Damage Prevention Eric Williams, Chesapeake Midstream John Christiansen, KorTerra
NYSE: CHKM
www.chkm.com
1
Current One Call Landscape
Chesapeake Midstream
Chesapeake Operating Inc
5000 miles of pipeline in one call 250 facility locations in one call
5600 miles of pipeline in one call 2500 facility locations in one call
(~600 Miles in 5 states in 2006) NYSE: CHKM
www.chkm.com
2
What’s our goal? Data Collect the building blocks “It”
Information Piece together the blocks “What is it?”
Knowledge Understand the whole “What does it mean?”
Wisdom Apply the knowledge “How do we improve it?”
Knowledge is power, but Wisdom is an advantage NYSE: CHKM
www.chkm.com
3
What’s our goal? Technology + Processes: Implemented together to collect and protect data
Analysis + Reporting: Using data to create intelligent information
Data Governance and Processes
Analysis and Reporting
Informed Decisions Informed Decisions: Proper use of data and information allows for knowledge based business decisions NYSE: CHKM
www.chkm.com
4
Systems Integration (The Big Picture)
NYSE: CHKM
www.chkm.com
5
Data/Process KorTerra
Standard Process
Standard Process
Reporting
NYSE: CHKM
www.chkm.com
6
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
7
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
8
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
9
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
10
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
11
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
12
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Utility Map
KorTerra User Screens Home Screen Dispatching Ticket View
Completion Easy to learn and train Only 5 screens User friendly Workflow driven
NYSE: CHKM
www.chkm.com
13
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Ability to see tickets instantly on a map in the field as they are delivered
NYSE: CHKM
www.chkm.com
14
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Locators able to see the dig boxes and locations sent directly from the call centers
NYSE: CHKM
www.chkm.com
15
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
With GIS integration to Sharepoint, and the Esri functionality in the application, users are able to access construction records, ROW surveys, as-builts, and construction photos for a pipeline without ever exiting KorTerra
NYSE: CHKM
www.chkm.com
16
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Key Benefits
NYSE: CHKM
www.chkm.com
17
Data/Process MS Sharepoint
DIRT Data
Incident Data
Damage/Near Miss Incident Data Data Collection Historically captured in EHS Incident Management System (One size fits all) Developed DIRT digital collection form
Data Governance Digital form data is populated into MS Sharepoint list for querying, reporting, and analysis Submission to CGA DIRT and state compliance reporting
DIRT – Digital Form
DIRT - Sharepoint
(Still Under Construction!) NYSE: CHKM
www.chkm.com
18
Analysis/Reporting ESRI
Geospatial Data
CDC Boundaries/Buffers
Geospatial Data for One Call Submissions CDC Boundaries
One Call Buffers
Where do I operate? CDC boundaries are used to “clip” the buffers for each area.
What do I operate? Buffers layer is produced nightly from asset and CDC boundaries with GIS automation.
NYSE: CHKM
www.chkm.com
19
Analysis/Reporting ESRI
Geospatial Data
Ticket/Incident Locations
Geospatial Data for Damage Prevention Ticket Locations Ticket data is pulled from KorTerra database and replicated to GIS
Incident Locations DIRT data is pulled from Sharepoint and replicated to GIS
DIRT - Sharepoint
*GIS data can be delivered in various ESRI, Delorme Xmap, web based, and mobile phone applications depending on the needs of the customer.
NYSE: CHKM
www.chkm.com
20
Analysis/Reporting TIBCO Spotfire
Reporting
Ticket/Incident Reports
Real Time, Location Based Reports Trending over time Geographic analysis
NYSE: CHKM
www.chkm.com
21
Analysis/Reporting TIBCO Spotfire
Reporting
Ticket/Incident Reports
Ticket Query Reports Ability to instantly pull ticket information for a given area, office, locator, region, state, city, etc for any unit of time
NYSE: CHKM
www.chkm.com
22
Improved Damage Prevention Overall Benefits of Data Collection and Reporting Data governance Real-time information Empowered decision making Gained One Call process efficiencies Allow for growing workload Public awareness activity improvements Root cause analysis
NYSE: CHKM
www.chkm.com
23
Information or Questions Eric Williams Coordinator – Damage Prevention and Public Awareness [email protected] or 405-935-1547 John Christiansen KorTerra, Inc. [email protected] or 952-368-1911
NYSE: CHKM
www.chkm.com
24
The Power of Information and Reporting in Damage Prevention Eric Williams, Chesapeake Midstream John Christiansen, KorTerra
NYSE: CHKM
www.chkm.com
1
Current One Call Landscape
Chesapeake Midstream
Chesapeake Operating Inc
5000 miles of pipeline in one call 250 facility locations in one call
5600 miles of pipeline in one call 2500 facility locations in one call
(~600 Miles in 5 states in 2006) NYSE: CHKM
www.chkm.com
2
What’s our goal? Data Collect the building blocks “It”
Information Piece together the blocks “What is it?”
Knowledge Understand the whole “What does it mean?”
Wisdom Apply the knowledge “How do we improve it?”
Knowledge is power, but Wisdom is an advantage NYSE: CHKM
www.chkm.com
3
What’s our goal? Technology + Processes: Implemented together to collect and protect data
Analysis + Reporting: Using data to create intelligent information
Data Governance and Processes
Analysis and Reporting
Informed Decisions Informed Decisions: Proper use of data and information allows for knowledge based business decisions NYSE: CHKM
www.chkm.com
4
Systems Integration (The Big Picture)
NYSE: CHKM
www.chkm.com
5
Data/Process KorTerra
Standard Process
Standard Process
Reporting
NYSE: CHKM
www.chkm.com
6
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
7
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
8
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
9
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
10
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
11
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
KorTerra Process Overview
NYSE: CHKM
www.chkm.com
12
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Utility Map
KorTerra User Screens Home Screen Dispatching Ticket View
Completion Easy to learn and train Only 5 screens User friendly Workflow driven
NYSE: CHKM
www.chkm.com
13
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Ability to see tickets instantly on a map in the field as they are delivered
NYSE: CHKM
www.chkm.com
14
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Locators able to see the dig boxes and locations sent directly from the call centers
NYSE: CHKM
www.chkm.com
15
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
With GIS integration to Sharepoint, and the Esri functionality in the application, users are able to access construction records, ROW surveys, as-builts, and construction photos for a pipeline without ever exiting KorTerra
NYSE: CHKM
www.chkm.com
16
Data/Process
One Call Ticket Data
KorTerra One Call Ticket Data
Key Benefits
NYSE: CHKM
www.chkm.com
17
Data/Process MS Sharepoint
DIRT Data
Incident Data
Damage/Near Miss Incident Data Data Collection Historically captured in EHS Incident Management System (One size fits all) Developed DIRT digital collection form
Data Governance Digital form data is populated into MS Sharepoint list for querying, reporting, and analysis Submission to CGA DIRT and state compliance reporting
DIRT – Digital Form
DIRT - Sharepoint
(Still Under Construction!) NYSE: CHKM
www.chkm.com
18
Analysis/Reporting ESRI
Geospatial Data
CDC Boundaries/Buffers
Geospatial Data for One Call Submissions CDC Boundaries
One Call Buffers
Where do I operate? CDC boundaries are used to “clip” the buffers for each area.
What do I operate? Buffers layer is produced nightly from asset and CDC boundaries with GIS automation.
NYSE: CHKM
www.chkm.com
19
Analysis/Reporting ESRI
Geospatial Data
Ticket/Incident Locations
Geospatial Data for Damage Prevention Ticket Locations Ticket data is pulled from KorTerra database and replicated to GIS
Incident Locations DIRT data is pulled from Sharepoint and replicated to GIS
DIRT - Sharepoint
*GIS data can be delivered in various ESRI, Delorme Xmap, web based, and mobile phone applications depending on the needs of the customer.
NYSE: CHKM
www.chkm.com
20
Analysis/Reporting TIBCO Spotfire
Reporting
Ticket/Incident Reports
Real Time, Location Based Reports Trending over time Geographic analysis
NYSE: CHKM
www.chkm.com
21
Analysis/Reporting TIBCO Spotfire
Reporting
Ticket/Incident Reports
Ticket Query Reports Ability to instantly pull ticket information for a given area, office, locator, region, state, city, etc for any unit of time
NYSE: CHKM
www.chkm.com
22
Improved Damage Prevention Overall Benefits of Data Collection and Reporting Data governance Real-time information Empowered decision making Gained One Call process efficiencies Allow for growing workload Public awareness activity improvements Root cause analysis
NYSE: CHKM
www.chkm.com
23
Information or Questions Eric Williams Coordinator – Damage Prevention and Public Awareness [email protected] or 405-935-1547 John Christiansen KorTerra, Inc. [email protected] or 952-368-1911
NYSE: CHKM
www.chkm.com
24
