|
Address Cleansing & Standardization
LinkageWiz is a powerful Address Cleansing & List
Management tool used by
businesses, government agencies,
universities and other organizations in the
USA, Canada, United Kingdom, Australia and France.
Address cleaning is the process of
converting street addresses to a standardized format. Spelling mistakes are
corrected,
superfluous punctuation is removed, capitalization is standardized and address
components are translated into standard
abbreviations. A standardized address field is usually output along with key
elements of that address (building number,
street name, street name and street type).
Cleaning and standardizing address data prior to Data Matching results in
higher match rates, and also facilitates geocoding
of the address data
Address
Standardization Example:
|
Input address |
24 MAIN. SOUTH ROAD WEST |
|
Standardized Address |
24 MAIN SOUTH RD W |
|
Street Name |
MAIN SOUTH |
|
Street Type |
RD |
|
House Number |
24 |
|
Suffix |
W |
LinkageWiz
includes a wizard that makes it very easy to undertake address cleansing &
standardization:
The cleaned addresses and address
subcomponents are saved as new fields. LinkageWiz also contains a large
library of
lookup tables for street types, ordinal numbers, property types,
suffixes, postal boxes, suburbs and cities which you can
customize to suit your
own address cleaning requirements:
|
Property Types |
Maintenance of
property types (e.g. Hotel, Nursing Home, Trailer Park etc)
|
|
Street Types
|
Maintenance of
street type spelling variations and standardized abbreviations (e.g.
Avenue, Circuit, Highways, Road etc).
|
|
Street Suffixes |
Maintenance of
street suffixes spelling variations and standardized abbreviations
(e.g. South, North-West, Extension)
|
|
Postal Boxes |
Maintenance of
postal box spelling variations and standardized abbreviations
|
Geocoding
LinkageWiz includes a powerful geocoding engine that allows you
to geocode your address data.
Latitudes and Longitude coordinates
can be
assigned to your data using any available geographical reference file.
Geocoding
results are stored in three new fields that are appended to the
data file:
|
Match Type |
Description |
|
E |
Exact Match |
|
T |
Near Exact Match (street type disagrees) |
|
F |
Fuzzy Match (house number, street type and suburb agree but street name
has one or two differences) |
|
D |
Fuzzy Match (house number, street name, street type agree but suburb has
one or two differences) |
|
G |
Fuzzy Match (house number and suburb agree but street type disagrees and
street name has one or two differences) |
|
N |
Fuzzy Match (house number suffix disagrees e.g. 23 vs. 23b) |
|
O |
Fuzzy Match (house number disagrees but is on same side of street) |
|
K |
Fuzzy Match (house number disagrees but is on opposite side of street) |
|
Null |
Non-Match |
Try LinkageWiz today and explore it's powerful data
cleaning capabilities for yourself:
Download a free trial of LinkageWiz.
Click here to
explore LinkageWiz's other Data Cleansing Features
Click here to go to the LinkageWiz
Home Page.
| 
