Help and Support

Data Quality Project

Introduction

The quality of the Road Assessment and Maintenance Management (RAMM) software data being used by Transport Insights is assessed annually by the Te Ringa Maimoa Transport Excellence Partnership.

The published data quality reports are the result of Transport Insights’s annual assessment of every Road Controlling Authority’s (RCA’s) data quality. It details your network based on a framework of 30 indicators and 35 data quality metrics. These metrics interrogate your RAMM data for completeness, accuracy and timeliness.

What this report tells me

The intention is to identify opportunities for improvement in the way individual RCAs, and the industry collects, manages and uses data to support the decision-making processes. The report shows, for each metric, how you are positioned against what’s considered good (the expected standard) and where the industry sits.

The background behind the metrics

The metrics have been grouped into categories and sub-categories. Each has several metrics interrogating data completeness, accuracy and timeliness. Each metric has a graded result on a scale of one to three. Metrics graded two or three means a reduced confidence in data quality.

What is the source of the data being used?

These reports use RAMM data from the snapshot loaded to Transport Insights. The data source for the original two data quality reports was the New Zealand Transport Agency data warehouse. Sourcing data from RAMM has allowed additional metrics to be included that were previously excluded due to restrictions in the source data. The scripts used to generate the results are available on the Transport Insight website’s data quality page.

What's next?

Te Ringa Maimoa expects RCAs to improve their data quality to achieve the expected standard, shifting the RCA and national result into the “green zone” for each metric.

We suggest each RCA considers their results and incorporates improvements in their AMP improvement plan and work programmes.

Te Ringa Maimoa has considered the three sets of results and has developed an improvement programme to help RCAs address data quality issues. The improvement programme is available on the Te Ringa Maimoa website.

Please send any questions or feedback to TeRingaMaimoa@nzta.govt.nz.