Basics of Asset Management and GIS April 11, 2013 Whats it all about? - PowerPoint PPT Presentation

Leann Wheeler Senior GIS Specialist SCAUG Conference Basics of Asset Management and GIS April 11, 2013 What’s it all about?

Basics of Asset Management and GIS What’s it all about? Leann Wheeler Asset Management, broadly defined, Senior GIS Specialist refers to any system that monitors and SCAUG Conference maintains things of value to an entity or group. Asset management is a systematic April 11, 2013 process of operating, maintaining, upgrading, and disposing of assets cost- effectively.

Basics of Asset Management and GIS What’s it all about? Leann Wheeler From the engineering perspective….. Senior GIS Specialist The process of monitoring and SCAUG Conference maintaining facilities systems, with the objective of providing the best possible service to users (appropriate for public April 11, 2013 infrastructure assets).

Basics of Asset Management and GIS What’s it all about? Leann Wheeler Senior GIS Specialist SCAUG Conference April 11, 2013

Basics of Asset Management and GIS What’s it all about? Leann Wheeler Public asset management expands the Senior GIS Specialist definition of enterprise asset management (EAM) by incorporating the management of all SCAUG Conference things of value to a municipal jurisdiction and its citizens' expectations. April 11, 2013

What’s it all about? Leann Wheeler EAM requires… Senior GIS Specialist Asset Registry… inventory of assets and their SCAUG Conference attributes CMMS… Computerized Maintenance April 11, 2013 Management System

Asset Registry = GIS Leann Wheeler Senior GIS Specialist Hard Assets = typical physical assets SCAUG Conference or infrastructure Soft Assets = permits, license, code enforcement, right-of-ways and other April 11, 2013 land-focused work activities.

CMMS = Computerized Maintenance Management System Leann Wheeler Senior GIS Specialist A software package designed to maintain a database for an organization’s maintenance operations SCAUG Conference and human resources functions. Typically a CMMS will address the following… April 11, 2013 Work Orders and Descriptions Managing Inventory Managing Assets Safety

Pulling it all together Leann Wheeler Senior GIS Specialist SCAUG Conference Failure Data Failure Data Location Data Location Data April 11, 2013 Field Data Field Data Anecdotal/Historical Anecdotal/Historical HM ‐ ‐ Criticality Criticality HM Data Data Modeling Data Modeling Data

1. Gather Raw Data – Field Data, GIS Coverages, 1. Gather Raw Data Location Data, etc. Leann Wheeler Senior GIS Specialist SCAUG Conference April 11, 2013 Break Data Break Data Pipe Coupons Pipe Coupons Location of Rails & Roads Location of Rails & Roads

Failure Data – Leaks and Break Leann Wheeler Data Opportunities Data Challenges • Data Opportunities • Data Challenges • • Senior GIS Specialist • Data only exists for a short • Shows the impact of all “window” of time (i.e. 20 parameters (age, SCAUG Conference years) relative to pipe life materials, soils, etc.) Many pipe types have not Helps establish pipe • • reached the end of their performance over a time April 11, 2013 service lives – data is period incomplete • Can be readily analyzed • Inconsistent reporting and with statistical software QA/QC data problems to find correlations (patterns) • Often lacks failure mode data • Cheap and easy to collect – Corrosion induced • GIS capable – Mechanical – Construction related

Field Data – Soils, Pipe Samples, etc. Leann Wheeler Data Opportunities Data Opportunities Data Challenges Data Challenges Senior GIS Specialist • Detailed information • Snapshot of on specific pipe conditions SCAUG Conference segments • Expensive to collect • Several parameters and/or requires a long can be collected at the time to collect April 11, 2013 same time (opportunistic • Good for assessing sampling) failure modes – • Pipe testing can be forensic analysis expensive • Can be combined with • Data can be readily other data sources analyzed with • GIS capable, but statistical software to requires a lot of data find patterns – if there collection to be useful is enough data

Sample Field Data – Predicted Lifespan Based on Corrosion Rate Data Leann Wheeler Senior GIS Specialist SCAUG Conference April 11, 2013

Location Data Data Challenges Data Challenges Data Opportunities Data Opportunities Leann Wheeler Senior GIS Specialist • Often available as a • Too much data can be GIS coverage from distracting – what’s SCAUG Conference government agencies important and what’s and other utilities not? • Can be cheap to • Requires GIS expertise obtain to fit data into models April 11, 2013 • Powerful for viewing • Inconsistent reporting many factors and QA/QC data simultaneously problems • Can be readily combined with other data sources • Data is available to modeling software Underground Train Station

Anecdotal and Historical Data Data Opportunities Data Challenges Leann Wheeler Data Opportunities Data Challenges Senior GIS Specialist • Inconsistent reporting • Obvious patterns can and QA/QC data be spotted without SCAUG Conference problems analysis • Knowledge is not well • Cheap to obtain preserved over time (record search • Difficult to combined sometimes required) April 11, 2013 with other data sources • Powerful for looking at • Not really used for many factors modeling with software simultaneously • Helpful for starting data validation and analysis • Can narrow data sources to be reviewed

Using the Tools Together Leann Wheeler Senior GIS Specialist 2. Clean and QA/QC Data 2. Clean and QA/QC Data � Make sure pipe data is consistent (for example, SCAUG Conference material is consistent with the age) � Use known information to fill in blanks (for example, pipe installed before 1920 must be pit cast iron) 3. Perform Statistical Analysis 3. Perform Statistical Analysis � Using Failure Data, calculate predicted break rate April 11, 2013 (PBR) by characteristic (age, size materials, etc.) � Determine if Location Data (i.e. proximity to rail lines) or Field Data (i.e. soils) plays a significant role in failures � Use PBR and other key variables found from statistics for Macro Modeling � “Truth check” with Anecdotal Data

Using the Tools Together ‐ LEYP Leann Wheeler LEYP – – Linear Extended Yule Process Linear Extended Yule Process LEYP Senior GIS Specialist � Advanced multiple linear regression model SCAUG Conference � Considers the inter-relation of risk factors, pipe characteristics and time between breaks April 11, 2013 LEYP Model Definition Key function → Intensity of the process

LEYP Data Sources LEYP Data Sources Leann Wheeler Senior GIS Specialist SCAUG Conference Stray Currents Stray Currents Soils Soils April 11, 2013 Water Table Levels Water Table Levels Stray Currents Stray Currents

Average Age and Service Life Average Age and Service Life Expectancy Expectancy Leann Wheeler Senior GIS Specialist SCAUG Conference REMAINING 10% 50% 100% % MATERIAL low high low high low high April 11, 2013 PCI1 140 160 115 135 70 100 PCI2 160 180 135 155 90 120 CI1 110 130 90 110 50 60 CI2 130 140 110 130 70 80 CICL 110 130 90 110 50 60 DICL1 80 100 55 75 5 15 DICL2 120 140 75 95 15 35 PCI2R 10 20 20 30 30 40 CI2R 10 20 20 30 30 40 DICL2R 15 35 75 95 120 140

Spatial Data Sources Spatial Data Sources Historic Shorelines Water Age Historic Shorelines Economic Water Age Economic Leann Wheeler Zones Zones Senior GIS Specialist SCAUG Conference April 11, 2013 Valve Isolation Valve Isolation Critical Users Critical Users Zones Zones Low Pressure Roads and Tunnels Roads and Tunnels Hydraulic Low Pressure Hydraulic Areas Criticality Areas Criticality

Summary • A combination of data sources and modeling tools is Leann Wheeler Senior GIS Specialist needed to develop a complete asset management plan SCAUG Conference • Data is often lacking or suspect in certain areas • One set of data can help “shore up” another source – data from one source can validate another source April 11, 2013 • Tools rely on information provided by other tools • Statistics packages are powerful for spotting trends and weighting decision factors • A good plan studies both the macro level (entire system) and the micro model (pipe segments)

Basics of Asset Management and GIS What’s it all about? Leann Wheeler Senior GIS Specialist SCAUG Conference GIS RULES! April 11, 2013 Questions?

HOW IS ASSET MANAGEMENT DEFINED? • A management paradigm and a body of best Leann Wheeler Senior GIS Specialist appropriate management practices •Applied to the entire portfolio of infrastructure SCAUG Conference assets at all levels of an organization •Seeking to minimize total costs of acquiring, operating, maintaining, and renewing assets… April 11, 2013 •Within an environment of limited resources •While continuously delivering the service levels that customers desire and Regulators require… •And at an acceptable level of risk to the organization.