TY  - JOUR
A1  - Koumarelas, Ioannis
A1  - Kroschk, Axel
A1  - Mosley, Clifford
A1  - Naumann, Felix
T1  - Experience: Enhancing address matching with geocoding and similarity measure selection
JF  - Journal of Data and Information Quality
N2  - Given a query record, record matching is the problem of finding database records that represent the same real-world object. In the easiest scenario, a database record is completely identical to the query. However, in most cases, problems do arise, for instance, as a result of data errors or data integrated from multiple sources or received from restrictive form fields. These problems are usually difficult, because they require a variety of actions, including field segmentation, decoding of values, and similarity comparisons, each requiring some domain knowledge. In this article, we study the problem of matching records that contain address information, including attributes such as Street-address and City. To facilitate this matching process, we propose a domain-specific procedure to, first, enrich each record with a more complete representation of the address information through geocoding and reverse-geocoding and, second, to select the best similarity measure per each address attribute that will finally help the classifier to achieve the best f-measure. We report on our experience in selecting geocoding services and discovering similarity measures for a concrete but common industry use-case.
KW  - Address matching
KW  - record linkage
KW  - duplicate detection
KW  - similarity measures
KW  - conditional functional dependencies
KW  - address normalization
KW  - address parsing
KW  - geocoding
KW  - geographic information systems
KW  - random forest
Y1  - 2018
U6  - https://doi.org/10.1145/3232852
SN  - 1936-1955
VL  - 10
IS  - 2
SP  - 1
EP  - 16
PB  - Association for Computing Machinery
CY  - New York
ER  -