More Maps, More Users
More Maps, More Users Bringing Engineering Analysis back into GIS
Kurt Towler Sulphur Springs Valley Electric Cooperative [email protected]
Software Model of GIS Users and Tasks
Basic
• Basic Map Viewing • Printing
Intermediate
• Run Queries • Create Maps
Advanced
• Run Analysis • Create Data • Manage Data
User’s View of GIS Tools
More GIS
Less GIS
Monday
Tuesday
Wednesday
Thursday
Friday
• New Service Requests • Review system maps to better understand work projects.
• Create scenario options for best work plans. • Meet crew in field to discuss project. Print map.
• Check voltage problems. • Respond to outage issue by supplying correct fuse size.
• Write Report for Manager • Attend meetings to discuss project costs.
• Answer emails • Create new project plan based on meetings.
Traditional Project Data Flows in GIS Project Start
Design
As-Built Posting to GIS
Permits
Construction
Engineering Review
Connecting… Users Engineers Linemen
Information Facilities Consume
Managers Real Estate Accounting Customer Service Marketing
Network Model Land
GIS
Analyzed/Derived Legal Jursidictions Maintenance
Create
AMI …over time rich data sets are available to more users
High Risk Distribution Line Analysis Project Requirements 1. 2. 3. 4. • • •
Use weighted values to assess where focused maintenance work should be performed. Estimate risk to power lines by creating an aggregate risk value to the line. Use pole test results, replacement cost, distance from office, heavy equipment loading, etc. Rank poles by importance (e.g 1 – 89,500) Number of customers downstream from every pole. Amount of KW on the line that a pole is supporting. Data pre-calculated in Milsoft. Need to work with it.
Example:
Pole that is 30 years old, is a southern pine, costs $4,000 to replace, is located in McNeal and supports a recloser.
Scale
0
1
2
3
Pole Age Osmose Reject
X X
Pole Species
X
Replacement Cost
X
Drive Time
X
Joint Use
X
Years since Rejected
X
Special Equipment
4
X
5
Overall steps to estimate risk using a weighted index.
Calculate Pole Replacement Cost Calculate Pole Index Values Create Lines from Milsoft XML Exports Create Line Index Values Filter all Lines for High Risk Calculate total risk index for those lines.
Weighted Index Values Criteria
0
Osmose Rejects
No
Pole Age
1
2
3
4
5 Yes
0-20
20-30
Pole Species
30-40
40-50
50-70
Yes & Age
Yes & Age
Yes & Age
Replacement Cost
$1815
$2,740
$3,365
$4,185
$4,185 +
Distance from Office
5
10
20
40
70
Joint Use Attachments
1
2 Small xfmr
Large xfmr
ACR, Reg, Cap
9
14
18
Special Equipment Years Since Osmose Rejected
5
Consumer Count
Dynamic Range
Through KW
Dynamic Range
Environmental Areas
No
30
Yes
The risk of structural failure is to the line. We need to associate pole risk to the importance of the line.
KW: 1,270 Consumers: 985
Only one Osmose Reject Recloser on an old pole
Pole 1
Also old pole
Pole 2
Pole 3
Pole 4
Power Line that is close to a substation with lots of residential meters.
Scale
0
1
2
3
4
Number of Consumers Downstream
5 X
Peak KW Downstream
X
Power Line that is far from a substation with primarily irrigation meters.
Scale Number of Consumers Downstream Peak KW Downstream
0
1
2
3
4
X X
Each line is indexed within that Feeder. This allows comparison between substations with different KW and consumer counts. Each line has a "locally" relevant value.
5
Xml Translation Process 1. ‘Flatten’ sets of elements into features with attributes. (FME XML readers) 2. Create primary key relationships. 3. Join element features together so that all attributes are on single features. 4. Rename attributes and format data to make it more useful. 5. Write all features to geodatabase.
Xml of Line Feature
Xml of Calculated Load Flow
Xml of Short Circuit Analysis
FME creating features from xml
Index Examples
Line risk is calculated for all poles supporting that line.
Scale
0
1
2
3
4
Number of Consumers Downstream
X
Peak KW Downstream Environmental areas
5
X X
Any Osmose Reject
X
Any old Southern Pine
X
For All Poles Supporting That Line Avg Pole Age
X
Avg Replacement Cost
X
Avg Drive Time
X
Avg Joint Use
X
Avg Special Equipment
X
Avg Years Since Rejected
X
High Risk Summary Table Substation Name
Count of Poles
Pole Cost
Line Feet
Substation 1
3
$10,954
126
Substation 2
23
$91,388
2,310
Substation 3
3
$10,471
414
Substation 4
65
$232,011
6,278
Substation 5
142
$474,102
37,687
Substation 6
14
$53,801
4,905
Substation 7
18
$97,211
2,389
Substation 8
4
$19,644
364
Substation 9
17
$83,674
1,963
Substation 10
4
$17,479
781
Substation 11
6
$24,446
334
Substation 12
4
$18,377
444
Substation 13
33
$156,320
5,752
Substation 14
16
$77,304
3,155
Substation 15
2
$9,909
95
Substation 16
12
$52,484
2,331
Substation 17
112
$530,951
9,412
Grand Total
478
$1,960,526
78,739
Results of Project 1. 2.
3.
4.
Discrete locations of pole lines needing immediate maintenance. Reports by map or by table, including cost – immediately put into construction work plan. GIS users now have immediate access to 60 model calculated attributes for every one of the 55,000 lines. Further processing steps yield nicely formatted fault current data.
Map Demo
Kurt Towler Sulphur Springs Valley Electric Cooperative [email protected]
Kurt Towler Sulphur Springs Valley Electric Cooperative [email protected]
Software Model of GIS Users and Tasks
Basic
• Basic Map Viewing • Printing
Intermediate
• Run Queries • Create Maps
Advanced
• Run Analysis • Create Data • Manage Data
User’s View of GIS Tools
More GIS
Less GIS
Monday
Tuesday
Wednesday
Thursday
Friday
• New Service Requests • Review system maps to better understand work projects.
• Create scenario options for best work plans. • Meet crew in field to discuss project. Print map.
• Check voltage problems. • Respond to outage issue by supplying correct fuse size.
• Write Report for Manager • Attend meetings to discuss project costs.
• Answer emails • Create new project plan based on meetings.
Traditional Project Data Flows in GIS Project Start
Design
As-Built Posting to GIS
Permits
Construction
Engineering Review
Connecting… Users Engineers Linemen
Information Facilities Consume
Managers Real Estate Accounting Customer Service Marketing
Network Model Land
GIS
Analyzed/Derived Legal Jursidictions Maintenance
Create
AMI …over time rich data sets are available to more users
High Risk Distribution Line Analysis Project Requirements 1. 2. 3. 4. • • •
Use weighted values to assess where focused maintenance work should be performed. Estimate risk to power lines by creating an aggregate risk value to the line. Use pole test results, replacement cost, distance from office, heavy equipment loading, etc. Rank poles by importance (e.g 1 – 89,500) Number of customers downstream from every pole. Amount of KW on the line that a pole is supporting. Data pre-calculated in Milsoft. Need to work with it.
Example:
Pole that is 30 years old, is a southern pine, costs $4,000 to replace, is located in McNeal and supports a recloser.
Scale
0
1
2
3
Pole Age Osmose Reject
X X
Pole Species
X
Replacement Cost
X
Drive Time
X
Joint Use
X
Years since Rejected
X
Special Equipment
4
X
5
Overall steps to estimate risk using a weighted index.
Calculate Pole Replacement Cost Calculate Pole Index Values Create Lines from Milsoft XML Exports Create Line Index Values Filter all Lines for High Risk Calculate total risk index for those lines.
Weighted Index Values Criteria
0
Osmose Rejects
No
Pole Age
1
2
3
4
5 Yes
0-20
20-30
Pole Species
30-40
40-50
50-70
Yes & Age
Yes & Age
Yes & Age
Replacement Cost
$1815
$2,740
$3,365
$4,185
$4,185 +
Distance from Office
5
10
20
40
70
Joint Use Attachments
1
2 Small xfmr
Large xfmr
ACR, Reg, Cap
9
14
18
Special Equipment Years Since Osmose Rejected
5
Consumer Count
Dynamic Range
Through KW
Dynamic Range
Environmental Areas
No
30
Yes
The risk of structural failure is to the line. We need to associate pole risk to the importance of the line.
KW: 1,270 Consumers: 985
Only one Osmose Reject Recloser on an old pole
Pole 1
Also old pole
Pole 2
Pole 3
Pole 4
Power Line that is close to a substation with lots of residential meters.
Scale
0
1
2
3
4
Number of Consumers Downstream
5 X
Peak KW Downstream
X
Power Line that is far from a substation with primarily irrigation meters.
Scale Number of Consumers Downstream Peak KW Downstream
0
1
2
3
4
X X
Each line is indexed within that Feeder. This allows comparison between substations with different KW and consumer counts. Each line has a "locally" relevant value.
5
Xml Translation Process 1. ‘Flatten’ sets of elements into features with attributes. (FME XML readers) 2. Create primary key relationships. 3. Join element features together so that all attributes are on single features. 4. Rename attributes and format data to make it more useful. 5. Write all features to geodatabase.
Xml of Line Feature
Xml of Calculated Load Flow
Xml of Short Circuit Analysis
FME creating features from xml
Index Examples
Line risk is calculated for all poles supporting that line.
Scale
0
1
2
3
4
Number of Consumers Downstream
X
Peak KW Downstream Environmental areas
5
X X
Any Osmose Reject
X
Any old Southern Pine
X
For All Poles Supporting That Line Avg Pole Age
X
Avg Replacement Cost
X
Avg Drive Time
X
Avg Joint Use
X
Avg Special Equipment
X
Avg Years Since Rejected
X
High Risk Summary Table Substation Name
Count of Poles
Pole Cost
Line Feet
Substation 1
3
$10,954
126
Substation 2
23
$91,388
2,310
Substation 3
3
$10,471
414
Substation 4
65
$232,011
6,278
Substation 5
142
$474,102
37,687
Substation 6
14
$53,801
4,905
Substation 7
18
$97,211
2,389
Substation 8
4
$19,644
364
Substation 9
17
$83,674
1,963
Substation 10
4
$17,479
781
Substation 11
6
$24,446
334
Substation 12
4
$18,377
444
Substation 13
33
$156,320
5,752
Substation 14
16
$77,304
3,155
Substation 15
2
$9,909
95
Substation 16
12
$52,484
2,331
Substation 17
112
$530,951
9,412
Grand Total
478
$1,960,526
78,739
Results of Project 1. 2.
3.
4.
Discrete locations of pole lines needing immediate maintenance. Reports by map or by table, including cost – immediately put into construction work plan. GIS users now have immediate access to 60 model calculated attributes for every one of the 55,000 lines. Further processing steps yield nicely formatted fault current data.
Map Demo
Kurt Towler Sulphur Springs Valley Electric Cooperative [email protected]
