GIS After the Conversion

1
GIS After the Conversion

• Mid West ESRI Utility Users Group 2007

2
Presented by
A
Jeffrey A. Grussing Leader, GIS
Development jgrussing_at_usgweb.com
3
Background

• Kandiyohi Power Cooperative
• Worked two years on their GIS system and field
  verification.
• United Services Group (USG)
• I have been with USG for 14 years where I have
  worked with several different cooperatives and
  municipals on GIS and field collection projects.
• I am currently the Leader of GIS development for
  USG.

4
The conversion is done, now what do I do?

• GPS field inventory to make your data more
  accurate both the attributes and positional Pros
  and Cons.
• Explore using GIS for corridor and ROW
  management, new route planning and storing
  easement data.
• Using the GIS system to manage and store PCB and
  pole testing data.
• Using GIS systems in conjunction with trouble
  call system, truck tracking, automated staking
  and CIS applications.
• Other uses for GIS - the sky is the limit.

5
GPS Field Inventory Pros

• Data is positionally accurate
• With a complete system inventory
• Accurate system worth
• Know where all foreign attachments are
• You can do retirement staking from the data
• Helps crews know what was there in a storm damage
  restoration
• It is a good way to field verify that everything
  came across from the conversion
• For Cooperatives, RUS will fund 75of the
  project.

6
GPS Vs. ExistingMapping Data
7
GPS Field Inventory Cons

• Spatial Mismatch/Map Matching Problems
• Accurate GIS base map with less accurate GPS
  points.
• Accurate GPS data placed into a less accurate GIS
  base map.
• Accurate GPS data placed into a GIS base map that
  has a scale too small to differentiate the GPS
  points.
• Costly
• GPS equipment
• Work expenses
• Data collection
• Integration into GIS system
• GIS clean-up
• Maintenance

8
GPS Field Inventory Cons?

• Visual representation
• Actual location may hinder ability to interpret
  map

9
GIS for ROW Clearing

• Right of way clearing data can be attached to
  parcels of land in the GIS.
• Keep track of areas that were trimmed or sprayed
  in a particular year.
• Attach digital photos of existing vegetation
  encroachments to parcels in the GIS.
• Clearing contractors can be given area maps
  generated from GIS data.

10
Example of ROW Clearing Database
11
Example of Using Digital Photos
12
Example of Contractors Service Territory Maps
13
Detail Printed Maps for Contractors
14
Using the GIS System for Storing Easement
Information

• Storing the easement information in the GIS
  database.
• Storing the easement information in an external
  database or Land Information Systems (LIS).
• Attach scanned easement documents to parcels in
  the GIS system.

15
Example of Easement Database
16
Example of Hyperlinked Easement
17
Using GIS for Route Planning

• Developing or acquiring parcel information.
• Creating proposed route centerline.
• Create and store alternative routes.
• Generating a contact list using the final
  proposed route centerline .
• Use in conjunction with automated staking
  software and or easement generation software.

18
Developing or AcquiringEasement Parcels

• Get Digital Parcel Data from Counties.
• Make sure that it is usable data
• Digitize or COGO Parcels from Paper Records.
• Use GPS and Automated Staking or Easement
  Generation Software.

19
Example of Defining Proposed Routes
20
Example of Generating a Mailing List
21
Example of Staking/Easement Software
22
Example of Staking/Easement Software
23
PCB and Pole Testing Data

• PCB test data for transformers and other primary
  equipment
• Produce maps that highlight equipment the needs
  to be changed out
• Store test data in related tables in the GIS
  database
• Pole testing and change out programs
• Produce maps that highlight pole change out areas
  and symbolize danger pole so you can dispatch
  crews to the worst pole first
• Store Pole test data in a related table in the GIS

24
(No Transcript)
25
Creating Ties to Other Systems

• Ties to CIS
• Real time, Near real time, import export and
  MultiSpeak.
• Ties to AVL or truck tracking systems
• For safety and ease of dispatching crews.
• Ties to Outage Management and Trouble call
  systems
• Using Automated Staking systems to maintain the
  GIS data

26
(No Transcript)
27
Example of a Trouble Call
In this case this Fuse is probable cause of the
outage
Customer 3
Customer 2
Customer 1
28
Other Uses for GIS

• Great River Energy is using GIS to track failures
  in heat shield tiles in combustion turbines.
• Building cable management.
• Model substations.
• Model padmounted switchgear.
• Anything that has a spatial component and data
  behind it can be a candidate for GIS.

29
(No Transcript)
30
Recap

• GPS Field Inventory
• ROW and Route Planning
• PCB and Pole Testing
• Ties to Other Systems
• Some Alternative Uses of GIS

31
Thank You !