Pitney Bowes MapInfo Professional User Manual
Page 378
matching is not case sensitive; upper and lower case letters are successfully matched with one another.
MapInfo Professional does not get an exact match in many cases and uses a file of abbreviation
equivalences to improve its "hit rate". Once you understand the various ways in which a match can fail,
you are in a better position to understand what you can do to improve things.
The next table illustrates exact matching. The first column contains a street name from a target table
and the second column contains the corresponding street name from a source table. The third column
says why they do not match. The fourth column indicates whether the particular problem is one which
can be corrected through using the abbreviation file. This table assumes that the addresses are the
contents of a single column in a table. While the street number would often be in the same column, we
do not indicate street numbers here because they are handled differently than street names.
Correctable with
Abbreviation File?
Comment
Source Address
Target Address
No
"LaSal" is the wrong
spelling.
LaSalle St
LaSal St
No
"La Salle" is the wrong
spelling.
LaSalle St
La Salle St
No
"Ave" does not match
"St".
LaSalle St
LaSalle Ave
Yes
"Street" does not match
"St".
LaSalle St
LaSalle Street
Yes
"Ave" does not match
"Av".
LaSalle Av
LaSalle Ave
Yes
The target address has
a period after "St". That
LaSalle St
LaSalle St.
period is not in the
source and causes the
match to fail.
No
"St" is missing from
target.
LaSalle St
LaSalle
No
Target has "St" and
source does not.
LaSalle
LaSalle St
No
Target has "North,"
which is not in source.
LaSalle St
LaSalle St North
Yes
Target has "North"
instead of "N".
LaSalle St N
LaSalle St North
Yes
Target has "North"
instead of "N".
N LaSalle St
North LaSalle St
No
Target has "North,"
which is not in source.
LaSalle St
North LaSalle St
Yes
Target has an apartment
number which does not
LaSalle St
LaSalle St Apt 3
match anything in the
source.
Yes
"Tenth" and "10th" do
not match.
10th St
Tenth St
MapInfo Professional 12.5
378
Geocoding - Assigning Coordinates to Records