managing assets in your gis
Post on 02-Jul-2015
232 Views
Preview:
DESCRIPTION
TRANSCRIPT
EGUG 2007 1
GIS Asset Management at NIPSCO
Diane Buche & Skye Perry
Managing Assets in Your GISHistory in the Making
EGUG 2007 2
The NIPSCO Challenge
•Background:
–Asset Management Data in DB2
• Homegrown COBOL System
–Graphical Data in AutoCAD
•Challenge:
–Merge Graphical and Asset Data
–Remove Duplicate Data Entry
–Gain Efficiencies via Technology
EGUG 2007 3
The NIPSCO Challenge
•System Stakeholders:
–Records Department
–Storerooms (purchasing, operating)
–Engineering
–Distribution Planning
–Customer Information and Billing
–Outage Management
–Capital Asset Sales
–Material Accounting
EGUG 2007 4
The NIPSCO Challenge
•Technology:
–ESRI
• ArcGIS Desktop, ArcSDE, ArcIMS, ArcReader
–ArcFM
–SQL Server
–Microsoft .Net
• C#.Net, ASP.Net
EGUG 2007 5
Data Modeling
• It all starts with the data…
–Started with standard Electric data model
–Updated object model with additional Asset tables
–Hub and Spoke Model for Rotating Assets:
• Designed around the asset life cycle
• Capture detail for every event
• Reporting on assets at every stage
Current state
Forecasting
Predictive failure
EGUG 2007 6
Data Modeling
Transformer
Unit
Stock
Install Removal
Sold / Leased Condemned
Testing
Transformer
Bank
Manufacturer & Warranty Data
Storeroom Location & Date
Phase, Status, Location, Ticket # Removal Reason, Date, Ticket #
Oil, PCB Contamination, Function
Mechanical/Electrical Issues,
Stolen, Contaminated, AgedTo REMC / Municipality, etc
EGUG 2007 7
Data Model in Action
•What does this look like in the GIS?
EGUG 2007 8
Application Customization
•Filling the Application Gap
–Diverse User Groups
• Storeroom Clerks
• GIS Record Clerks
• Engineers
• General Query Users
Asset Queries
GIS Queries
–Right Technology, Right Tools, Right People
Web GIS
EGUG 2007 9
Application Customization
•Extending ArcMap & ArcFM
–Many assets are managed directly in GIS
Validations
EGUG 2007 10
Application Customization
•Extending ArcMap & ArcFM
Retirement Tools
EGUG 2007 11
Application Customization
•Extending ArcMap & ArcFM
Analysis Tools
EGUG 2007 12
SAGE
•Asset Management Online
–StandAlone GeoDatabase Editor (SAGE)
Microsoft ASP.Net Web Application
Uses ESRI Multi-Version Views
SQL Access Against Versioned Data
Edit Attribute Data Only
SAGE
DB Access
LayerWeb App SDE
GeodatabaseViews
ViewsMulti-Version
Views
EGUG 2007 13
SAGE - Architecture
•Asset Management Online
–StandAlone GeoDatabase Editor (SAGE)
Concerns with Multi-Version Access
Domains are Binary
Auto-Updaters Not Available
Other Option is ArcGIS Server / ArcFM Server
May be cost prohibitive
SAGE
DB Access
LayerWeb App SDE
Geodatabase
ArcGIS
Server
ArcFM
Server
EGUG 2007 14
SAGE – Where does it fit?
•Asset Management
Non-graphical tasks
Storeroom
GIS Clerks
EGUG 2007 15
SAGE – Where does it fit?
EGUG 2007 16
SAGE – Where does it fit?
•Records Management
Records Management Dashboard
• Manage KPI’s with regard to assets
• Asset Interface to Material Accounting
EGUG 2007 17
SAGE – Where does it fit?
•Records Management
Manage SAGE Access
EGUG 2007 18
SAGE – Where does it fit?
•Records Management
Manage GIS Record Clerks
•Asset Reporting
Batch – Nightly, Monthly, Annual
Real-time
Available in SAGE
EGUG 2007 19
SAGE – Where does it fit?
•Batch Reports• FERC Form-1
• SEC 10K
• Assets In Stock
• Condemnation Approval
• Annual Asset Counts
• Asset Failure Reports
• …
EGUG 2007 20
SAGE – Where does it fit?
•On Demand Reports• Capital Assets For Sale
• Rated KVA by Circuit
• Pad Inspections
• Pole/Pad Inquiry
• Multi Pole/Pad Inquiry
• …
EGUG 2007 21
SAGE – Where does it fit?
• In Summary…Challenge of Merging Spatial and Asset Data
Best of Breed Technologies
Hub and Spoke Data Modeling
Application Customization in the GIS
Validations
Retirement Tools
Analysis Tools
SAGE
Asset Management
SAGE – Records Management
SAGE – Asset Reporting
•Demo… Rotating Asset Lifecycle
EGUG 2007 22
Managing Assets in Your GIS
Questions & Comments
Welcomed
EGUG 2007 23
Managing Assets in Your GIS
Diane Buche – NIPSCO / NiSourcedlbuche@nisource.com
Skye Perry – SSP Innovations, LLCskye.perry@sspinnovations.com
------------- -------------------------------- ----------------This work was supported under subcontract NAD-5-33652-01
(Technical Manager Thomas_Basso@nrel.gov ) with the
National Renewable Energy Laboratory managed by the
Midwest Research Institute for the US DOE under contract
Number DE-AC36-99GO10337
top related