Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

 Subscribe to receive our newsletter. Subscribe Unsubscribe

## Improving On The MapPoint Geocoding Algorithm

This is a discussion on Improving On The MapPoint Geocoding Algorithm within the MP2K Magazine Articles forums, part of the Map Forums category; Rainer Barthels shares a method for getting better geocodes in MapPoint than the built-in routine by using the return values ...

1. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## Improving On The MapPoint Geocoding Algorithm

Rainer Barthels shares a method for getting better geocodes in MapPoint than the built-in routine by using the return values from FindAddressResults

Part II of the article has now appeared at: http://www.mp2kmag.com/articles.asp?...AddressResults

2. Junior Member White Belt
Join Date
May 2003
Posts
1

## Improving On The MapPoint Geocoding Algorithm

We've also found lots of discrepancies in Canadian data. See http://www.infinitegravity.ca/MapPoint.asp for a short article on it.

We've been spending a _huge_ amount of CPU time tracking down these problems for the whole of Canada. As we go along, we're creating cross-reference data to map from Canada-Post standard formats to what MapPoint wants to see to match correctly. At the same time, we're recording the coordinates for faster lookup in the next time we need to map an address.

3. It seems like it would be more efficient to just invest in a real geocoder, although I don't know what is available for Canada. But how many streets can there be, eh?

4. Junior Member White Belt
Join Date
Oct 2002
Posts
2
Hi,

I guess I am a little perplexed when I read the article concerning improving Mappoint geocoding. Unless I have missed something, this article only seems to present some kind of basic methods that are explained in the online help.
I have tested the code available for download and it works properly. But it doesn't seem to go further than informing the user on the way MapPoint has geocode each point.
The company I work for also developped an application which lets the user improve MapPoint geocoding. I guess we first geocode the different points the same way that it is done in the code linked to the article. And we also give a grid as a result of the geocoding process, with color alerts which makes it more readable. this grid contains different informations such as the way MapPoint has geocoded the point, informations on the point itself (in our case, we use this application to geocode clients so it gives us information about our clients) etc... The difference is that this grid is not a simple static grid. As it shows the different levels of geocoding (street, city, post code, country or even no geocoding at all...), the user can double clik on each row to modify the geocoding given by MapPoint. It is also possible to directly act on the map by moving the pushpin associated with each geocoded point.
That is true that if you have a huge database with a great amount of data, it is sometime a hard job to do, because you need to check all the points. But I guess it is important to let the user decide where he wants the point to be placed.
I think the best thing would be that Microsoft improve themself the part of the algorithm which is supposed to find the adress. The article gives specific exemples concerning cities which have the same post code in germany. It is in fact kind of hard case to solve. But we can even consider some small errors in the adress that MapPoint cannot detect. Here is one; the second adress has only a "-" added :
10 rue des Belles Feuilles, 75016, Paris is geocoded on post code
10 rue des Belles-Feuilles, 75016, Paris, is geocoded on street
I don't know how MapPoint performs the research of the point corrsponding to the adress but it is clear that the search engine could be improved, only by verifying the degree of similarity between two given adresses. And I guess this would be the best way to obtain a really good geocoding tool...

Take care everyone !

5. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## Interesting but....

This tool is very interesting but it seems odd that country names should be in a 'one letter' format (such as "D" for "Germany"). In Europe that would not work.

Why not use the full name, as MapPoint understands that.
If it's not possible to change, what logic is used? (e.g. De for Denmark?)

If I want to test the application properly on my dataset, I would really need and welcome any response.

Kind regards

Pieter Joost Verhoef
pjverhoef@marketpoint.nl
http://www.marketpoint.nl

6. Member Green Belt
Join Date
Nov 2002
Posts
52
I used ISO 3361 codes for the country, because I think this is a standard.
Have a look at

http://userpage.chemie.fu-berlin.de/.../ISO_3166.html

7. Member Green Belt
Join Date
Nov 2002
Posts
52
Sorry, this comes with next version. There you can select ISOAlphaCode,
ISOAlpha2Code and car-licence number.

In the moment this is only licence-number. (D=Germany, DK=Denmark,
A=Austria, GB=Great Britain, CH = Suisse, E = Spain, NL = Netherlands, B = Belgium, P = Portugal, L = Luxembourg, I = Italy, F = Fracnce, USA, CAN)

8. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## MapPoint

I found this very good web site on MapPoint:

http://users.pandora.be/worldstandards/

Just check it out !

9. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
Hi,

I wish I could use this tool but I can't.
I'm using MS Acess 2002 (XP) and Mappoint Western Europe 2004

I manage to select the database and the table
I manage to select the good field (even if I had trouble to find out that double type was réel double in Franch
But when I continue to the next step I got an error message.

The translation is somrthink close to "wrong class chain".
Then none of the adresses (from your customer.mdb file) will be geocoded. One or all adresses geocoding will fail.
I tried to put the geocode.exe in the mappoint folder then to an outside folder. But unsuccessful.
Where did I f\$*^!ed up ?

10. Member Green Belt
Join Date
Nov 2002
Posts
52
Hi,

I corrected the tool for MP2004. You can make an ftp-download from

server:www.free-routing.de
user:anonymous
path:/fr/free-routing.de

Cheers
Rainer

Page 1 of 2 12 Last

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•