Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Getting matched location from MapPoint

Posted on 2003-03-06
Medium Priority
Last Modified: 2008-02-01
I am programming an Excel add-in for MapPoint 2002, and have come across a small problem.  My application will plot the nearest points between two datasets (as in nearest warehouse for N customers), and exports the whole thing to an Excel sheet.

When I import address files into MapPoint, I usually have some locations it can't match automatically, and it asks to pick one from a list of choices.  It plots a pushpin in the selected location and all is well.  When I export the information (all data associated with the pushpin), it exports the original, non-matching addresses.

That's sometimes useful, but in general I will be putting the data back through MapPoint to create different maps.  I run into the same problem as the original match, some locations don't match automatically.

I need to find a way to export the actual pushpin location, to export what MapPoint matched my address to and not necessarily the original address.

I can use Lat/Lon code to do it, but I want the actual address/location.  Any ideas?
Question by:DullsVillager
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 8482880
No, MapPoint does not do the "reverse geocoding" necessary to go from Lat/Lon to address.  This generally isn't all that useful, since rarely do the MapPoint databases actually have the correct specific address.

Author Comment

ID: 8493403
Well, it's not so much lat/lon to address as address->matched address...

My problem is matching the input address to the output address.  When I map and analyse the same data set several times, I end up having to match the same addresses to the same locations when MapPoint isn't smart enough to figure out where i'm talking about.

I input address XYZ
MapPoint doesn't know what XYZ is, but it gives me a list of what it figures I really meant: ABC, DEF, GHI

I pick ABC, and it slaps a dot on the map at point ABC

When I do a radius circle or something of that sort, I can get back all the information I put in (XYZ), but I'm looking for ABC, specifically the address that MapPoint used instead of the address that I gave it.

I'll try to come up with a concrete example, in case any of you GeoWizards want some real data to fiddle with.

Expert Comment

ID: 8500388
I understand, but I don't think MapPoint allows you to retrieve the address that you manually select... maybe they will in a newer version...
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 8662615
I finally found the functions that allow this... FindAddressResults then the StreetAddress property.

So I run something like:

FindAddressResults("123 Sesame Street", "New York", ,"NY",,geoCountryUnitedStates)

and then I can use ResultsQuality and Type to see what kind of results I get back.

If I get a geoFirstResultGood match or better and a geoShowByStreetAddress, I can look at the StreetAddress property of the Location that was returned.  Anytime the match isn't great, I can display the list of locations and get the user to pick one of the locations MapPoint knows about.

If it's a match for a Location (museum, tavern, etc.), I can also look at PlaceCategory to match it versus extracting a street address.

The only caveat with this is: It only works when mapping.  I can't "extract" it as I would like after the points have been mapped, only when i'm doing my first-round match.  It also means I'll have to write my own import routines, no Data Mapping Wizard for me!

Moderators: I'd like this question to be PAQd and refunded, will post in Community Support to that effect.

gj62, look for a "Points for..." question in a comment to follow, I'll give 25 for a valliant try.

Accepted Solution

SpideyMod earned 0 total points
ID: 8662634
PAQ'd and points refunded.

Community Support Moderator @Experts Exchange

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I feel like more and more people want to know how to programmatically convert addresses into geospatial locations. So in this article, I will show you how you can do it with Bing Maps. I'm going to use PowerShell, which is a nice scripting language,…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question