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
Results 1 to 10 of 10

MapPoint Matching table with census codes

This is a discussion on MapPoint Matching table with census codes within the MapPoint Desktop Discussion forums, part of the Map Forums category; Sometimes it will be awfull to link external data to MapPoint, because the join field in mapPoint is the name ...

  1. #1
    adirat is offline Junior Member Yellow Belt
    Join Date
    Sep 2005
    Posts
    17

    MapPoint Matching table with census codes

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

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: MapPoint Matching table with census codes

    Hi,

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

  3. #3
    adirat is offline Junior Member Yellow Belt
    Join Date
    Sep 2005
    Posts
    17

    Re: MapPoint Matching table with census codes

    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

  4. #4
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: MapPoint Matching table with census codes

    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

  5. #5
    adirat is offline Junior Member Yellow Belt
    Join Date
    Sep 2005
    Posts
    17

    Re: MapPoint Matching table with census codes

    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 ?

  6. #6
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: MapPoint Matching table with census codes

    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.

  7. #7
    adirat is offline Junior Member Yellow Belt
    Join Date
    Sep 2005
    Posts
    17

    Re: MapPoint Matching table with census codes

    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

  8. #8
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: MapPoint Matching table with census codes

    Hi,

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

  9. #9
    adirat is offline Junior Member Yellow Belt
    Join Date
    Sep 2005
    Posts
    17

    Re: MapPoint Matching table with census codes

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

    Regards

    Antoine Dirat

  10. #10
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Want to Purchase Zip Code Mileage Table
    By FreightDude in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 10-30-2008, 10:14 AM
  2. How can I link an Excel pivot table with Mappoint?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-27-2004, 05:19 AM
  3. Performance: UDL vs Access Linked table
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-19-2004, 04:19 PM
  4. how to export the data of an Excel table on a chart mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-17-2004, 05:37 AM
  5. Census 2000 SP1 - Geocoding using mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-25-2002, 01:54 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96