Wellington City Council Assets Investment Asset Management Wednesday

Wellington City Council Assets Investment & Asset Management Wednesday, 11 November 2015

Themes § Background to Wellington Asset Challenges § The Wellington Asset Problem § Business Process Issues – Actions we have taken § Current Status and Ongoing Work § Where to next…

Our Challenges

The Wellington Asset Challenge Source: WCC Infrastructure Strategy 2015 -25

Business Process Issues – When we began § § § § § No single source of data Unstable link between Arc. SDE and AMIS(s) Inability to directly import electronic files Duplication of manual data entry Inability to import, extract and report on existing data in current systems No intelligence or automation Connectivity / Topology rules not enforced Poor 3 D capability Revision of current data model required

Connectivity Trace Blue assets not connected to main network

Age of the Storm Water Asset

Age of the Storm Water AC Asset

Real World Problem WCC’s Assets are decaying at a rate of $2 m per week

The Practical Problem – Asset Deterioration Affordability & Sustainability

The Financial Problem Wellington City’s 3 -Water Assets Problem

Actions we have taken

Data Collection Wastewater Pipes (All) Date Installed (99%) Material (99%) Diameter (99%) Complete (99%) 38406 38532 115 241 115 38532 38563 84 Stormwater Pipes (All) Complete (56%) Material (97%) Diameter (97%) 22955 Date Installed (56%) 23093 39949 17881 887 39816 1020 17743

Data Collection - Property Construction Date Address Asset Name 165 203 213 48 - 10 Data collected To collect Condition Replacement Cost 199 14 Data collected To collect Remaining Life 199 14 Data collected To collect

Data Collection - Housing Asset Name Address 2, 153 Construction Date 2, 153 - - - Data collected To collect Condition Replacement Cost 1, 822 Remaining Life 1, 822 331 331 Data collected To collect NOTE: Arlington and Kotuku are to HUP'd - We have not been able to survey 16 units

Investment Analytics – Any Road Pavement… Wellington City Council – Local Roads NZTA Wellington Region – State Highway

Investment Analytics – Any Pipe… Wellington City Council – Wastewater Network Wellington City Council – Stormwater Network

Investment Analytics – Pipe in any Suburb…

Investment Analytics – Any House, or Houses…

Import of electronic records to AMIS

The (Technical) context of the standard for as-builts Data Standards CAD ‘Plugins’ Multiple formats Micro-station Multiple formats AMIS Updates Auto. CAD Revit Updates (Human and machine consumable format) CAD and Surveying Products 12 D 1 2 Infrastructure As-Builts “Portal” (QA and format conversion) Responsibility of ‘TAGG As-Builts Project’ to deliver (as well as data flows) Source: Simon Gough, Auckland Transport Project Setup Multiple formats Loading ‘Tool’ Updates SAP Tech. One Others GIS RAMM UDT Manageme nt

Marshall Court

BIM Enabled Investment Analytics Multiple Applications… Bracken Rd Flats - WGTN Wellington City Council – Retrospective Data Collection Tool 77 Burke Street, CHCH HNZC – New Build Data Collection Tool Berkeley Dallard City Housing Estate WGTN Wellington City Council – Refurbishment Data Collection Tool

§ The Challenge: Data and Finance § Current status and work New System Configuration § Investment analytics § Electronic data import § BIM § Benefits

System Interface(s) to Tech One for Assets REPORTING & ANALYTIC LTP / Annual Plan / KPI FORECASTS FIXED ASSET REGISTER Revaluation Depreciation Contractors Infonet RAMM One Council SPATIAL ARC GIS City. Care CEM SPM

System Interface(s) to Tech One for Assets Simply put Stub data copies the key data about an asset item from the master dataset to another system. Data includes: § § § § § Asset ID Which system holds the Master data What it is Where it is Spatial NZTM x and y co-ordinates and Address When it was installed Costs for Valuation and Depreciation Who Owns and Maintains Current Asset Condition, and Its expected Life

Next Generation 4 D BIM – Asset Manager Visualisation Tools E. g. Tenancy Manager Visualisation Tools

What are ‘Our’ Benefits?

Interdisciplinary Benefits – In Practice § Engineering (Asset / BU) – Operational & Capital § Forwards Works Programs – clear line of sight • Investigation (e. g. Condition Assessments, R&M, Materials Sampling, CCTV) • Replacement (incl. Interactivity – Roading Reseals vs. Pipe Renewals) § Identify where to Carry ‘Risk’ – based on Criticality • Run-to-Fail § Asset Performance (Practical & Financial)

§ Financial § Forwards Works Programs – transparency (30+ years) • Renewals Forecasting (depreciation commitments) • Growth Forecasting (LOS and Dev. Cont. Commitments) § WCC Borrowing Implications (e. g. Funding Caps) § Asset Performance • Financial – Economic Development Headroom § Carrying ‘Risk’ – on Cost / Benefit / Risk Paradigm § Meeting OAG Audit Requirements • 30 year Infrastructure Plan

§ Spatial Planning § Economic Development (evidence base decision-making) • Economic Utility – Optimised urban planning – infrastructural capacity • Opportunity Cost of Investment – by Suburb (e. g. Karori vs. Miramar vs. Lincolnshire Farm) § Spatial Planning • Capacity Metrics – e. g. HEU’s maximum density • Social Metrics – e. g. Walking distance to a park

References & Acknowledgements § Marlow DR & Burn S (2008). Effective use of condition assessment within asset management. J Am Water Works Assoc 100(1): 54 -63. § Hammond M & Jones P (2000). Effective AM. Maint Asset Mgt 15(4): 3 -8. § Dominion Post (14 July 2012). Katie Chapman, Insight, Running the Ruler over Rates. § Parsons (2006). Regulating asset management, 12 th Middle East Forum on Maintenance Management, Dubai. § Thanks to the following for their contributions and encouragement: Haydn Read, Martyn Simpson, Paul Johnson, Brendan Eckert of Wellington City Council. § Louise Lindsay, of JBCL.

Wellington City Council QUESTIONS? Andrew Nixon Programme Manager, Wellington City Council Andrew. nixon@wcc. govt. nz