There are a range of complex underlying issues contributing to poor data quality.
In 2018, Te Ringa Maimoa developed a survey for the sector to gain a greater understanding of the root causes for inconsistent data quality to support the development of a sector-wide improvement programme.
The following common themes affecting data quality were identified:
Te Ringa Maimoa is very pleased with the quality and openness of the responses received, and shares thanks with the 130 respondents who took the time to complete the survey.
Te Ringa Maimoa has produced several guidance documents and case studies to support RCAs improve their data quality to the expected standard. These have been identified through root cause analysis from findings on the survey results in 2018 plus common themes identified through analysis of the annual national results.
Guidance and case studies produced to help RCAs improve their data quality for their AMPs are as follows:
Guidance Type |
Name and Purpose |
Current Version |
Date |
Overviews |
|||
Overview |
Treatment Length Management(external link) This overview document is intended to provide high level support and direction to better understand the criticality of treatment lengths, and how to management them. |
v2.0 |
Jun-18 |
Overview |
Maintenance Activity Data(external link) This overview document is intended to provide high level support and direction to better understand the criticality of maintenance activity data, and how to maintain this dataset. |
v2.0 |
Jun-18 |
Overview |
Traffic Count Data(external link) This overview document is intended to provide high level support and direction to better understand the criticality of robust traffic count data at a network level, and how to develop a traffic count strategy and structured count programme. |
v2.0 |
Jun-18 |
Overview |
Traffic Estimate Data(external link) This overview document is intended to provide high level support and direction to better understand the criticality of robust traffic estimate data and how to maintain this dataset. |
v2.0 |
Jun-18 |
Overview |
Carriageway Sections(external link) This overview document is intended to provide high level support and direction to better understand the criticality of defining carriageway sections and attributes, and how to maintain this dataset. |
v1.0 |
Oct-18 |
Overview |
This overview document is intended to provide high level support and direction to better understand the criticality of crash data within Road Assessment and Maintenance Management (RAMM), and how to maintain this dataset. |
v1.0 |
Oct-18 |
Overview |
Work Origin and Original Cost(external link) This overview document is intended to provide high level support and direction to better understand the criticality of populating the work origin and original cost fields. |
v2.0 |
Mar-19 |
Overview |
This overview document is intended to provide high level support and direction to better understand the criticality of pavement surfacing data, and how to maintain this dataset. |
v2.1 |
Mar-19 |
Overview |
Managing Expected Surface Lives in RAMM(external link) This overview is intended to provide high level support and direction in managing expected surface lives in the Road Assessment and Maintenance Management (RAMM) software. Supplementary detailed support is provided in the guideline; Maintaining Expected Surface Lives in RAMM. |
v1.0 |
Jun-19 |
Overview |
Smooth Travel Exposure(external link) This overview document is intended to provide high level support and direction to better understand Smooth Travel Exposure, where it is used and reported, and how it is calculated. |
v1.0 |
Nov-19 |
Overview |
Data Quality Framework(external link) This overview document is intended to provide high level support and direction to better understand the intent and purpose of the data quality framework developed by the Te Ringa Maimoa. |
v3.0 |
Aug-21 |
Overview |
Data Quality Dimensions(external link) This overview document is supplementary to the Data quality framework overview document and is intended to provide a more detailed level of support and direction to better understand the three quality dimensions of accuracy, completeness and timeliness. |
v3.0 |
Aug-21 |
Overview |
Understanding the Data Quality Results(external link) This overview document is supplementary to the Data quality framework overview document and is intended to provide a more detailed level of support and direction in reading and understanding the results of the annual data quality reports. |
v3.0 |
Aug-21 |
Guidelines |
|||
Guideline |
Maintaining Expected Surface Lives in RAMM(external link) This guideline is intended to provide detailed support and direction in maintaining expected surface lives in the Road Assessment and Maintenance Management (RAMM) software. Supplementary higher-level guidance is provided in the practise overview; Managing Expected Surface Lives in RAMM. |
v1.0 |
Jun-19 |
Guideline |
Data Quality Management(external link) This guideline is intended to provide a more detailed level of support and direction in the role and importance of data quality management and how to develop appropriate data processes and plans. |
v1.0 |
Jun-19 |
Case Studies |
|||
Case Study |
RATA – Data Quality Improvement Through Collaboration(external link) This case study is intended to provide a detailed look at how the Waikato Regional Asset Technical Accord (RATA) has supported the improvement of data quality at an individual RCA level through a regionally collaborative model. |
v1.0 |
Dec-19 |
Case Study |
Taupo DC: Holistic approach to improving data quality(external link) This case study is intended to provide a detailed look at how Taupō District Council has approached the capture, recording and managing of quality asset data to support their decision-making and reporting needs. |
- |
May-20 |
Reference Material |
|||
Reference |
Data Quality Sector Survey Results(external link) Te Ringa Maimoa developed a survey for the sector to gain a greater understanding of the root causes for inconsistent data quality to support the development of a sector-wide improvement programme. |
- |
Jun-18 |
Reference |
A metric library that provides detail about each data quality metric, including: metric purpose, the consequence of poor-quality data, potential reason(s) for not being at the expected standard and change history unique to each metric. |
- |
- |
Reference |
Calculation of the “Score”(external link) The purpose of the overall asset management score is to indicate the quality of available data in the asset system to support investment and decision-making processes, weighted by a level of importance. |
- |
- |
Reference |
Data Quality Programme Overview Factsheet(external link) The DQP overview factsheet provides you with a systems-based view of the different components local authority and national government agency strategic decision-makers, and operational managers need to consider within a process flow. The types of information they need to consider have a slightly different focus but are complementary and aligned. |
- |
- |
Reference |
Transport Insights - Data Quality Functionality(external link) By using Transport Insights data quality functionality RCAs can learn more about the quality of their roading data, where it is excellent and where it can be improved. |
- |
- |