MapForums

adirat · #1 (**permalink**) 12-06-2006

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!!!

**Wilfried** · #2 (**permalink**) 12-07-2006

Hi,

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

adirat · #3 (**permalink**) 12-11-2006

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

**davidb** · #4 (**permalink**) 12-11-2006

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

adirat · #5 (**permalink**) 12-12-2006

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 ?

**Wilfried** · #6 (**permalink**) 12-12-2006

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.

adirat · #7 (**permalink**) 12-12-2006

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

**Wilfried** · #8 (**permalink**) 12-12-2006

Hi,

Great that you found solution

What is the site URL ? Because it can benefit other user too.

adirat · #9 (**permalink**) 12-13-2006

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

Regards

Antoine Dirat

**Wilfried** · #10 (**permalink**) 12-14-2006

thanks Antoine

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/mappoint-matching-table-census-codes-5442.html
Posted By	For	Type	Date
Microsoft MapPoint 2006 - MP2K Magazine	This thread	Refback	12-12-2006 01:18 PM
Improving On The MapPoint Geocoding Algorithm - Pt. I - MapPoint Articles - MP2K Magazine	This thread	Refback	12-09-2006 06:07 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to Purchase Zip Code Mileage Table	FreightDude	MapPoint 2006/2009 Discussion	2	09-09-2006 09:07 AM
How can I link an Excel pivot table with Mappoint?	Anonymous	MapPoint 2006/2009 Discussion	0	10-27-2004 04:19 AM
Performance: UDL vs Access Linked table	Anonymous	MapPoint 2006/2009 Discussion	0	10-19-2004 03:19 PM
how to export the data of an Excel table on a chart mappoint	Anonymous	MapPoint 2006/2009 Discussion	0	02-17-2004 04:37 AM
Census 2000 SP1 - Geocoding using mappoint	Anonymous	MapPoint 2006/2009 Discussion	1	07-25-2002 12:54 PM

MapForums

MapPoint Matching table with census codes

MapPoint Matching table with census codes

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/mappoint-matching-table-census-codes-5442.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

MapPoint Matching table with census codes

MapPoint Matching table with census codes

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/mappoint-matching-table-census-codes-5442.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/mappoint-matching-table-census-codes-5442.html