Using GIS to Manage One Call Tickets
Using GIS to Manage One Call Tickets
Presented By:
John Cutcher
SEMCO Energy Gas Co Port Huron, MI
Serving 284,000 Customers Throughout Michigan
• SEMCO’s One Call – Korterra admin informed that the State is offering an opportunity to manage One Call tickets more efficiently. • In 2009 SEMCO Energy received over 60,000 One Call tickets
– Opportunity for Improvement using Geography? ‐ SURE Let’s look at it!
• Currently SEMCO receives One Call tickets using the (Places) methodology.
Example of Current Places Method Using the Places method, SEMCO receives tickets for the entire municipality resulting in many tickets being cleared.
• State offering a (Gridding) methodology to help reduce tickets – Korterra admin asks if GIS could be used here to try this new method out. Oh YEAH!!
Selling the Concept • • •
Buffer Pipes Present to Management Next Steps
• Create final grid selection – Select GIS features using ½ mile buffer
Pipes Service Lines Transmission Mains Meter Points Regulator Stations Town Border Stations
– Dissolve into one grid selection
Back to Selling the Concept • Present to Management – Review full grid selection
• Get One Call Data out of Korterra • Plot One Call points on the map – Perform Analysis
• Close‐up view of placed One Call Points – Points falling in the grid selection were considered valid tickets – Points falling outside of the grids were considered to be cleared tickets.
Further Analysis • Verify that all tickets outside of grid where “Cleared” – 18 Staked Tickets Found Outside of Grid • How can that be?
A little more Selling….. • Positive Results from Analysis • Management approves Grid Method • SEMCO GIS sends grid selection to State Grids were submitted to Miss Dig via individual text files of each grid name.
Final review and sign‐off from SEMCO on the grid selection the State will use for sending One Call Tickets
All continuing grid maintenance (additions / subtractions) are completed using the Miss Dig Web Application with a member username and login.
So ……
What Kind of One Call Ticket Reduction Are We Talking About?
Using Grid Formula 2009 one call tickets would have been reduced by 25%
Using Grid Formula 2009 one call tickets would have been reduced by 32%
Using Grid Formula 2009 one call tickets would have been reduced by 24%
Using Grid Formula 2009 one call tickets would have been reduced by 26%
Using Grid Formula 2009 one call tickets would have been reduced by 30%
Using the Grid Methodology Formula 2009 one call tickets would have been reduced by:
29% Or
17,317 Less Tickets
All is well Until … Contractor places Miss Dig call at 12200 Lippert Rd. SEMCO does not get the ticket and doesn’t stake the job. The contractor knowing that SEMCO has facilities at the location contacts local division and requests staking at the job site. What Went Wrong? Why didn’t we get a ticket since the location was in a Grid?
• SEMCO contacts Miss Dig to inquire how their data is Geo‐Coded – State uses Tiger data (2000) Note: Google maps located the point the same as Tiger, MapQuest placed the point where the actual customer is, and Yahoo placed the point west of Pulaski Rd.
• SEMCO created a Geo‐Coder to Match States • Geo – Code SEMCO customer locations Note: 20 locations similar to the Lippert Road example were found.
Lippert Road with New grids added
Grid Review going forward • SEMCO will conduct annual grid reviews to ensure that new infrastructure has not moved out beyond existing grids. – This review will be using Geo‐Processing Tools • Grid Reviews will also be part of our JTX Design Workflows.
Wrap Up……..
Questions? Thank You For Attending Enjoy EGUG 2010
Presented By:
John Cutcher
SEMCO Energy Gas Co Port Huron, MI
Serving 284,000 Customers Throughout Michigan
• SEMCO’s One Call – Korterra admin informed that the State is offering an opportunity to manage One Call tickets more efficiently. • In 2009 SEMCO Energy received over 60,000 One Call tickets
– Opportunity for Improvement using Geography? ‐ SURE Let’s look at it!
• Currently SEMCO receives One Call tickets using the (Places) methodology.
Example of Current Places Method Using the Places method, SEMCO receives tickets for the entire municipality resulting in many tickets being cleared.
• State offering a (Gridding) methodology to help reduce tickets – Korterra admin asks if GIS could be used here to try this new method out. Oh YEAH!!
Selling the Concept • • •
Buffer Pipes Present to Management Next Steps
• Create final grid selection – Select GIS features using ½ mile buffer
Pipes Service Lines Transmission Mains Meter Points Regulator Stations Town Border Stations
– Dissolve into one grid selection
Back to Selling the Concept • Present to Management – Review full grid selection
• Get One Call Data out of Korterra • Plot One Call points on the map – Perform Analysis
• Close‐up view of placed One Call Points – Points falling in the grid selection were considered valid tickets – Points falling outside of the grids were considered to be cleared tickets.
Further Analysis • Verify that all tickets outside of grid where “Cleared” – 18 Staked Tickets Found Outside of Grid • How can that be?
A little more Selling….. • Positive Results from Analysis • Management approves Grid Method • SEMCO GIS sends grid selection to State Grids were submitted to Miss Dig via individual text files of each grid name.
Final review and sign‐off from SEMCO on the grid selection the State will use for sending One Call Tickets
All continuing grid maintenance (additions / subtractions) are completed using the Miss Dig Web Application with a member username and login.
So ……
What Kind of One Call Ticket Reduction Are We Talking About?
Using Grid Formula 2009 one call tickets would have been reduced by 25%
Using Grid Formula 2009 one call tickets would have been reduced by 32%
Using Grid Formula 2009 one call tickets would have been reduced by 24%
Using Grid Formula 2009 one call tickets would have been reduced by 26%
Using Grid Formula 2009 one call tickets would have been reduced by 30%
Using the Grid Methodology Formula 2009 one call tickets would have been reduced by:
29% Or
17,317 Less Tickets
All is well Until … Contractor places Miss Dig call at 12200 Lippert Rd. SEMCO does not get the ticket and doesn’t stake the job. The contractor knowing that SEMCO has facilities at the location contacts local division and requests staking at the job site. What Went Wrong? Why didn’t we get a ticket since the location was in a Grid?
• SEMCO contacts Miss Dig to inquire how their data is Geo‐Coded – State uses Tiger data (2000) Note: Google maps located the point the same as Tiger, MapQuest placed the point where the actual customer is, and Yahoo placed the point west of Pulaski Rd.
• SEMCO created a Geo‐Coder to Match States • Geo – Code SEMCO customer locations Note: 20 locations similar to the Lippert Road example were found.
Lippert Road with New grids added
Grid Review going forward • SEMCO will conduct annual grid reviews to ensure that new infrastructure has not moved out beyond existing grids. – This review will be using Geo‐Processing Tools • Grid Reviews will also be part of our JTX Design Workflows.
Wrap Up……..
Questions? Thank You For Attending Enjoy EGUG 2010
