Sometimes it will be awfull to link external data to MapPoint, because the join field in mapPoint is the name of territory. There is a match table between french municipality and key code census (INSEE) in five digit (two for départements and three for the municipality)
le blog decigeo
Go to the new titled (Commune MapPoint INSEE) . You can download the excel table.
It will be great if some MapPoint users join to the way to offer a world matching table with official census codes!!!

Hi,

I'm not sure I understeand what you ask. Can you elaborate ?

If you have external data (cf census demographic data) , the link with MapPoint spatial database is on the name of territory . With Spain, Italy,Germany and France, you have to take care of of Municipality name to make a correct link.

To make a sample i have some external data:


38403 SAINT-JEAN-D'HERANS 241

So that is official data from census office in France

In MapPoint, you cannot link data with the official number of that territory (38403)
So you need to link it with name field

But in MapPoint the name is
Saint-Jean-d'Hérans

the name is not matching with census table
(in France we have 36 565 municipality, so imagine what a nightmare!)

I make a national french table to match MapPoint municipality name with official census code to match it quickly

Perhaps I'm not understanding the question properly, but I'm assuming you want to convert a string like

38403 SAINT-JEAN-D'HERANS 241

to a string like

SAINT-JEAN-D'HERANS

for 30,000+ records. This can be done very easily in Excel using the LEN(), RIGHT() and LEFT() functions in that order ie. find the length of each string, then chop off 6 to the left and 4 to the right. Then read into MapPoint.

Hope this helps

David

hello,
No this is not a string conversion problem: simply the MapPoint territories name is not matching official name. so what do we do with several external data source with different ortography for the same municipality ?

Hi,

I see. The accent is missing in the external data because it is in capitals. I think the solution is to see if you can get the external data in lowercase. then all accents should be correct. Maybe there are other solutions, but I dont see it at the moment.

hello!
i'm not looking for a solution : i found one! a matching table between MapPoint name and official french code (that you can download from my blog site). I think that it will be great that other users share matching table for Italy, Spain Germany , etc etc

regards

Hi,

Great that you found solution
What is the site URL ? Because it can benefit other user too.

to download the file go to my blog : le blog decigeo
the post is : Commune MapPoint INSEE / Matching muncipality table

Regards

Antoine Dirat

thanks Antoine