A Case History - Data Mining OneCall Information using ESRI Tools
A Case History Data Mining OneCall Information using ESRI Tools
Data Mining
Discuss 2 Data Mining Activities 1 - Potential Risk Points on Pipelines 2 - Public Awareness - Excavators
Copyright 2007 Petris Technology, Inc.
1999 - Petris involvement with Pipeline OneCall Process 2003 - Questions about Data Mining Onecall Information 2004 - Potential Risk Point Calculations 2005 to Present - Addition Data Mining
Copyright 2007 Petris Technology, Inc.
OneCall Ticket Information Who was notified? Where is the Dig? How Big an Area?
Copyright 2007 Petris Technology, Inc.
Who is Digging? How Do I Contact Them? Where is the Dig? Where is the Dig?
Copyright 2007 Petris Technology, Inc.
Ticket Management System Database of Information
Copyright 2007 Petris Technology, Inc.
Computer Mapping
Location Stored in the Database
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Data Mining Potential Risk Point Analysis Risk Rank pipeline segments based on the proximity and frequency of excavations along you pipeline
Copyright 2007 Petris Technology, Inc.
Excavation Location 5 Methods of determining Location 1 - Latitude Longitude Point 2 - Street Address 3 - Intersection Address 4 - Polygon Footprint or Point 5 - Grid Footprint or Point
Copyright 2007 Petris Technology, Inc.
Excavation Location Latitude Longitude Point Latitude Longitude fields on the OneCall Tickets Latitude Longitude captured from a GPS device Virginia OneCall experimenting capturing Latitude Longitude from a cell phone when a OneCall ticket is generated
Copyright 2007 Petris Technology, Inc.
Excavation Location Geocode an address Street Address – Intersection Address
Copyright 2007 Petris Technology, Inc.
Excavation Location Polygon or Grid location
Copyright 2007 Petris Technology, Inc.
Excavation Location Excavation Latitude Longitude
Copyright 2007 Petris Technology, Inc.
Excavation Location Potential Risk Points on Pipeliine
Copyright 2007 Petris Technology, Inc.
Excavation Location Potential Risk Segments Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Copyright 2007 Petris Technology, Inc.
Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Data Mining - Benefits Potential Risk Point Analysis Qualify the Public Awareness Effort Qualify the Mailing Campaign Qualify placement of pipeline signage Identify Changing Demographics Identify areas to increase OneCall processing knowledge Copyright 2007 Petris Technology, Inc.
Data Mining Public Awareness Programs The Onecall Database contains information about your excavator community that can be used in your Public Awareness Programs
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Validate that excavators working near your pipelines are on your mailing lists Target a mailing list to infrequent or new excavators Determine where new excavators are working
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Harris County Jul – Dec ’04
Jan – Jun ‘05
Jul – Dec ‘05
Total Tickets
5265
5162
7468
Excav Email
1031
2423
4309
Excav Fax
3252
1413
2695
982
281
482
No Contact
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Harris County Excavator Ticket Volume
Jul – Dec ’04
Jan – Jun ‘05
Jul – Dec ‘05
601 NHPL
565 RD Cr
920 HNPL
236 Micke
474 NHPL
394 RD Cr
218 RD Cr
177 CityW
272 CityW
177 CENT
101 CENT
259 Eddie
157 MICA
100 MJ Sh
239 MJ Sh
142 COH
89 BacTr
168 CENT
Copyright 2007 Petris Technology, Inc.
Data Mining Onecall Information Eddie’s Backhoe Service – the location of each excavation could be plotted using ESRI tools to visually highlight new excavations
Copyright 2007 Petris Technology, Inc.
A Case History Data Mining OneCall Information using ESRI Tools
Data Mining
Discuss 2 Data Mining Activities 1 - Potential Risk Points on Pipelines 2 - Public Awareness - Excavators
Copyright 2007 Petris Technology, Inc.
1999 - Petris involvement with Pipeline OneCall Process 2003 - Questions about Data Mining Onecall Information 2004 - Potential Risk Point Calculations 2005 to Present - Addition Data Mining
Copyright 2007 Petris Technology, Inc.
OneCall Ticket Information Who was notified? Where is the Dig? How Big an Area?
Copyright 2007 Petris Technology, Inc.
Who is Digging? How Do I Contact Them? Where is the Dig? Where is the Dig?
Copyright 2007 Petris Technology, Inc.
Ticket Management System Database of Information
Copyright 2007 Petris Technology, Inc.
Computer Mapping
Location Stored in the Database
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Data Mining Potential Risk Point Analysis Risk Rank pipeline segments based on the proximity and frequency of excavations along you pipeline
Copyright 2007 Petris Technology, Inc.
Excavation Location 5 Methods of determining Location 1 - Latitude Longitude Point 2 - Street Address 3 - Intersection Address 4 - Polygon Footprint or Point 5 - Grid Footprint or Point
Copyright 2007 Petris Technology, Inc.
Excavation Location Latitude Longitude Point Latitude Longitude fields on the OneCall Tickets Latitude Longitude captured from a GPS device Virginia OneCall experimenting capturing Latitude Longitude from a cell phone when a OneCall ticket is generated
Copyright 2007 Petris Technology, Inc.
Excavation Location Geocode an address Street Address – Intersection Address
Copyright 2007 Petris Technology, Inc.
Excavation Location Polygon or Grid location
Copyright 2007 Petris Technology, Inc.
Excavation Location Excavation Latitude Longitude
Copyright 2007 Petris Technology, Inc.
Excavation Location Potential Risk Points on Pipeliine
Copyright 2007 Petris Technology, Inc.
Excavation Location Potential Risk Segments Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Copyright 2007 Petris Technology, Inc.
Pipe Segment •Begin ES •End ES •Begin Lat •Begin Lon •End Lat •End Lon
Data Mining - Benefits Potential Risk Point Analysis Qualify the Public Awareness Effort Qualify the Mailing Campaign Qualify placement of pipeline signage Identify Changing Demographics Identify areas to increase OneCall processing knowledge Copyright 2007 Petris Technology, Inc.
Data Mining Public Awareness Programs The Onecall Database contains information about your excavator community that can be used in your Public Awareness Programs
Copyright 2007 Petris Technology, Inc.
Ticket and Processing Information All Information Stored in the Database
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Validate that excavators working near your pipelines are on your mailing lists Target a mailing list to infrequent or new excavators Determine where new excavators are working
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Harris County Jul – Dec ’04
Jan – Jun ‘05
Jul – Dec ‘05
Total Tickets
5265
5162
7468
Excav Email
1031
2423
4309
Excav Fax
3252
1413
2695
982
281
482
No Contact
Copyright 2007 Petris Technology, Inc.
Public Awareness Programs Excavator Information Harris County Excavator Ticket Volume
Jul – Dec ’04
Jan – Jun ‘05
Jul – Dec ‘05
601 NHPL
565 RD Cr
920 HNPL
236 Micke
474 NHPL
394 RD Cr
218 RD Cr
177 CityW
272 CityW
177 CENT
101 CENT
259 Eddie
157 MICA
100 MJ Sh
239 MJ Sh
142 COH
89 BacTr
168 CENT
Copyright 2007 Petris Technology, Inc.
Data Mining Onecall Information Eddie’s Backhoe Service – the location of each excavation could be plotted using ESRI tools to visually highlight new excavations
Copyright 2007 Petris Technology, Inc.
A Case History Data Mining OneCall Information using ESRI Tools
