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 6 of 6
Like Tree1Likes
  • 1 Post By Winwaed

Geocoding European addresses (unparsed data)

This is a discussion on Geocoding European addresses (unparsed data) within the MapForums Plus Chat forums, part of the MapForums Plus category; Hello Everybody, Is there a way to Geocode European addresses (unparsed data) using Mappoint? Sample Data format: SCHYTTTESVEJ 7 8700 ...

  1. #1
    ukomat3 is offline Junior Member White Belt
    Join Date
    Apr 2011
    Posts
    5

    Geocoding European addresses (unparsed data)

    Hello Everybody,

    Is there a way to Geocode European addresses (unparsed data) using Mappoint?

    Sample Data format:

    SCHYTTTESVEJ 7 8700 HORSENS, Denmark
    GRENVÄGEN 10 14171 HUDDINGE, Sweden

    From simple Google search 8700/14171 doesn't seem like zipcodes.

    Thanks!
    Uday

  2. #2
    PROFIT100 Consulting is offline Member Green Belt
    Join Date
    Sep 2009
    Location
    Darmstadt, Germany
    Posts
    94

    Re: Geocoding European addresses (unparsed data)

    Hello,

    Our MapPoint-Tool IC-AddressValidation will validate and geocode addresses. Addresses of (most) European-countries and addresses of USA and Canada.
    Look at the manual(WEBHELP) : IC-AddressValidation

    We geocoded your 2 addresses in Sveden and Denmark.
    Just have a look to the screenshots.

    If you, or somebody else, is interested to get a trial version, please send us an email.

    mail@profit100.de

    Kind reagards
    Manfred


    PROFIT1oo™ Consulting - Microsoft® MapPoint ISV (Independent Software Vendor)
    Internet: http://www.mappoint2010.info , MS MapPoint - Geoanalyse - Vertriebsgebiete - Routenplanung - MapPoint Training - MapPoint Schulung
    Attached Images Attached Images
    Last edited by PROFIT100 Consulting; 04-22-2011 at 01:51 AM.

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    4,563
    Blog Entries
    4

    Re: Geocoding European addresses (unparsed data)

    In this case it's easy to separate the address, postcode, city, country just looking at the spaces, you could use Excel String functions, but in cases where the address has an additional space or the city has two words, this could get complicated.

    SCHYTTTESVEJ 7 8700 HORSENS, Denmark
    GRENVÄGEN 10 14171 HUDDINGE, Sweden

    Can you post more of your list?

    Eric
    ~ Order MapPoint MapPoint 2011 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    ukomat3 is offline Junior Member White Belt
    Join Date
    Apr 2011
    Posts
    5

    Re: Geocoding European addresses (unparsed data)

    Thanks Manfred and Eric for your suggestions. Sorry for the delay in replying to the thread.

    Eric - As you suggested I have been trying to parse the data using Excel and map it using mappoint, but as you guessed due to the nature of the data there was lot of massaging involved which is so time consuming. Thats why I wanted to see if there is a way to map unparsed data.

    At the moment I have decided to take the excel route and map the data, but one of the challenges I came across is Mappoint's ability to cluster cities to Counties/Provinces. For instance if my input has $100 revenue for all the cities mapped in Sweden, when I cluster the data by Provinces mappoint shows only $80 revenue.

    Did anyone come across this issue?


    Uday

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Posts
    1,722
    Blog Entries
    50

    Re: Geocoding European addresses (unparsed data)

    If working through the API, then a useful trick is to try various variations until you get a 'hit'.

    I had this problem with a load of Scottish data when I first started coding MapPoint years ago. UK addresses are generally not as structured as US ones (which all the examples use!), so there can be legitimate variations in the city/other city/region fields. also the data could be badly formatted (we were using local gov housing association data - ie. the land owners, but they were still inconsistent in their database formatting!).

    So for example if you have 5 fields. The first is probably street. But is the second one "City", "Other City" or "Region"? Try all variations with the most likely first.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    ukomat3 is offline Junior Member White Belt
    Join Date
    Apr 2011
    Posts
    5

    Re: Geocoding European addresses (unparsed data)

    That sounds like a good idea. I will try that see how the match rate looks.


    Uday

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fast Geocoding of Addresses in C# with MapPoint
    By Eric Frost in forum News and Announcements
    Replies: 0
    Last Post: 01-17-2011, 12:33 PM
  2. MapPoint 2009 Construction Data Update for European Edition
    By cardu in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 07-24-2009, 09:31 AM
  3. Special Characters in European Addresses
    By pzanis in forum Bing Maps and MapPoint Web Service
    Replies: 3
    Last Post: 08-27-2007, 08:53 AM
  4. Low Cost European and Canadian Geocoding Option in Upgrade
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 06-16-2003, 11:02 PM
  5. I have over 500 data points/addresses and I would ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-09-2002, 10:53 AM

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