rule-driven, fully-configurable asset tracking with gis

2106 Esri GeoConX Conference

Rule-Driven, Fully-Configurable Asset Tracking with GISFacilitating Preventive Maintenance Activities at MLGW

October 19, 2016

Arnisa Davis, PMP, GISP| MLGW• Project Inspire GIS Lead• ArcGIS Enterprise P.M.• ArcGIS/Designer

Implementations Joaquin Madrid, PhD| SSP Innovations• Senior Consultant• GIS – ESB Integrations• GIS Workflows & Applications

Introductions

ABOUT MLGW

1937: Memphis Light Gas and Water is created.Headquarters: Memphis Tennessee.Service Area: Memphis and Shelby County.

785 mi²Num. customers: 

Electric: About 425,000.Gas: About 325,00.Water: About 260,000.About 1,000,000 meters

The nation's largest three-service municipal utility.

ABOUT SSP

• Eleven-year old GIS consulting company • Work exclusively in the U.S. utility/telecom industries• Team of ~35 Based in the Denver area• 100% of our work is performed at utilities & telecoms with Esri-

based GIS• 100% aligned with Esri platform strategy• 70+ clients; 100+ combined years working with Esri software• Industry-leading reputation for quality, successful solutions to

requirements

Business Drivers

1. Asset Identification and DescriptionPoles, Gas and Water Valves, Fire Hydrants…

2. Asset Management: Scheduled ActivitiesOptimal Lifecycle Maintenance

3. Asset Geographic Location

Support MLGW Preventive Maintenanceand more…

SOLUTION: EAM

Oracle Enterprise Asset Management®Asset Record

1. Drive Maintenance Best PracticesSingle Repository: costing, metrics, forecasting…

2. Manage Lifecycle in relation to its environment:• Additional Equipment• Surrounding Conditions

3. Track EvolutionInstallation, maintenance, replacement, retirement…

SOLUTION: GIS

Esri ArcGIS® and SE ArcFM®Asset Feature

1. Geographic Location

2. (Partial) Attribution Repository

3. Engineering and Field Crew ToolsDesign, on-site construction, field maintenance…

eAM/GIS… Enterprise Systems Integration

GIS:

Asset Tracking

SOLUTION: GIS/eAM Integration

FOIDASSET#Lat/LonATTR 1ATTR 2ATTR 3ATTR 4…ATTR N

SOA IntegrationAsset

Feature

eAM:

Asset Mgmt

RECIDASSET#PROP A

PROP BPROP CPROP DPROP E

…PROP XYZ

Asset Record

Integration Key

Field Mapping

Rule-Driven/Fully-Configurable

Status:CreateUpdateDelete

SOLUTION: GIS Asset Tracking

1. Asset Number: Assignment/MaintenanceRule-Driven

2. Asset Attributes: UpdatesRule-Driven

3. Asset Feature: Status Evolution• Creation/Update/Deletion

Asset Feature Descriptor: Versioned TablePosting → eAM

SOLUTION: Rule-Driven

SOLUTION: Rule-Driven

SOLUTION: Rule-Driven

SOLUTION: GIS/eAM Integration

SOLUTION: GIS/eAM Integration

SOLUTION: Fully-Configurable

1. Rules are collected in Excel spread sheets, then imported into DB tables during Integration start up.

2. Rules updated by business needs.

3. Updates reflected as changes in configuration; then re-start integration.

SOLUTION: Rule-Driven

SDE.CFG_ATTR_MAPPING

Preventive Maintenance

Business Benefits

1. Rule-Driven/Fully-Configurable Asset Tracking

2. Asset Location and Description

3. Asset Management Lifecycle

Support MLGW Preventive Maintenanceand more…

Questions?

Arnisa Davisadavis@mlgw.orgwww.mlgw.com

Joaquin Madridjoaquin.madrid@sspinnovations.co

mwww.sspinnovations.com