putting dtims outputs in front of asset managers

RIMS Conference 2013Innovation Awards

Putting dTIMS outputs in front of Asset Managers: Improved accessibility in favourite format

RIMS Conference - March 2013

Presenter:

Ken Mitchell

Opus International Consultants - Napier

The Challenge…

Traditionally dTIMS outputs have been difficult to translate back to the roading network at a project level.

How to provide accessible treatment forecasts

GIS outputs are developing but a simple accessible output was required to indicate where optimised decision making could make a difference in Road Network Asset Management

How could we do it better?

RIMS Conference March 2013

The Situation…

Traditionally dTIMS outputs have focussed on network level outputs and summaries

− Reseal /Rehab/AC 10 year averages

− Condition trends : e.g.: PCI, SCI, Roughness etc.

− Investment patterns linked to FWP/Trigger and optimised treatment forecasts

Translating this back to the project level of the network the analysis was performed on has been limited.

What could we do?


The solution - Iteration 1

Extract dTIMS budget scenario treatment forecast outputs and work on more accessible formats for the analysis results.

Trial an excel format that Asset Managers easily access and use to and see results at a treatment length level. Not Rocket Science V1: Basic sorted excel sheet, some conditional colour V2: A slightly smarter version with more filtering, summary network length

“..engineers love excel…..” Anon

Intention: Keep it simple and accessible. Client: Wairoa District Council



The solution - Iteration 1 v1 -Simple searchable, sorted, colour coded excel.


The solution - Iteration 1 v2-filtered, sorted, colour coded, summarised excel.

Clients: Wairoa DC and Wellington CC

The solution - Iteration 2

Use Excel and conditional colour for PCI (Pavement Condition Index) condition comparison between budget scenarios.

Intent: Show the difference between the current non-optimised FWP

and the investment limited optimised treatment forecast.

Make it easy to see relative differences in condition (Green is good, Red is Bad)

Client: Wairoa District Council


Iteration 2a: PCI RainbowsConditional Formatting, Sorting, Stats Highlight


Not Pretty, But you see the difference

The solution - Iteration 3 Use Excel Pivot tables to allow asset

managers to drill down into summarised treatment and investment forecasts to Road, Treatment length, Hierarchy level

Issue: You need a certain level of excel knowledge to be comfortable using these?

Client:


Iteration 3: Pivot tables: filtered, annual summary, easy search

This is not very difficult to achieve and simple to use once you know how…

allows rapid drilldown and summarisation


Iteration 2-3: Putting it on a MapdTIMS output to RAMM GIS

Wellington City has taken the data a step further and created a RAMM user defined table (UDT) based on these model outputs

In UDT form it is viewable as a layer in RAMM GIS. Putting the data in a spatial format will be native in dTIMS v9 but

that is still a bit further down the track for NZ RAMM GIS is evolving and you need to keep and eye on the

releases. Look for it on your RAMM Apps page.


Taking it a step further:

Kirsten Brown, WCC Asset Data Analyst “I created the UDT to help identify roads/sections for our reseals

programme. The initial list comprises all roads that have at least one section recommended by TSA or dTIMS for the next year, excluding those with reseal jobs on them in the current year.

The engineers visit each road to choose which roads/sections to reseal. The TSA and job data is in RAMM as well as all the other data the engineers require (seal age, length, type, carriageway hierarchy, footpath and kerb & channel condition).

By adding the dTIMS data I was able to write a single RAMM SQL that identified the roads to check and produced a results set with all the required data in it.”


WCC RAMM GIS Layer


Yellow = Reseal, Pink = AC

Normal RAMM filtering

Filtering changes display transparency


RAMM GIS Layer View with Filter

• Contextual data can also be displayed. • Layers from other sources also able to be

displayed• Comes with your RAMM database

Summary: Keep it Simple & Effective

Target turning data into usable information

Look at what you can do and try and keep it simple where possible.

Use tools that people can tolerate easily if required

Build on what works and adapt as new tools develop and people want more.

Thanks to Wairoa District Council

Wellington City Council



Thank You

putting dtims outputs in front of asset managers

Technology

data

simple

pci

iteration

iteration

udt

putting

created