Posted - Chris Wright: Recently I have been working with one of our customers, Staffordshire County Council (SCC), around address matching. The area of addressing is one not traditionally ‘addressed’ by 1Spatial, as in some cases there is no geocode and hence the data is deemed to be non-spatial. However, our Radius Studio solution is just as proficient with non-spatial data as it is with spatial data.
SCC needed to provide accurate address locations to the emergency services, enabling them to carry out safety checks on homes within their areas in a co-ordinated manner. This was all part of their Data Quality Mission Statement. However, the problem was that no specific details about levels of data quality were available, so we helped SCC conduct an initial baseline assessment of their data. This initial assessment confirmed that it was of varying quality - much of the information did not appear to meet any address standard format such as BS7666. The BS7666 standard enabled us to build a useful catalogue of rules for addressing this area.
After the data quality baseline assessment was completed, we helped SCC move to the next stage and supported them in putting a Data Quality Management process in place. This stage of the exercise meant we could:
Working through the exercise allowed us to realise a number of benefits for the customer.
SCC needed to provide accurate address locations to the emergency services, enabling them to carry out safety checks on homes within their areas in a co-ordinated manner. This was all part of their Data Quality Mission Statement. However, the problem was that no specific details about levels of data quality were available, so we helped SCC conduct an initial baseline assessment of their data. This initial assessment confirmed that it was of varying quality - much of the information did not appear to meet any address standard format such as BS7666. The BS7666 standard enabled us to build a useful catalogue of rules for addressing this area.
After the data quality baseline assessment was completed, we helped SCC move to the next stage and supported them in putting a Data Quality Management process in place. This stage of the exercise meant we could:
- Retain the original address data entries
- Automate the validation and correction of as many errors in the data as possible
- Find the exact/best match to trusted national address datasets
- Add value to the data by adding a Spatial Reference
- Provide an indication of ‘confidence’ level of match
Working through the exercise allowed us to realise a number of benefits for the customer.
- Data Conformance - Using the rule based methodology we were able to identify errors within the data including; syntax/typing errors, invalid characters, invalid postcodes, redundant records, etc.
- Perform Data Reconciliation - Using the action abilities within Studio we were able to fix common problems in the data, such as replacing or removing invalid syntax.
No comments:
Post a Comment