MapForums

I want to plan sales trips (driving) to various locations.. and export a list of the customers along the way (say within 5 miles of my route) and while I can get the list in the Nearby Places box, I cant seem to figure out how to export them without drawing a box along my route by hand! This wont work since some of the routes are entirely across the US and back.

I would think this is a simple procedure and one commonly used.. Is there a way to export a list of customers along a route?

From the lack of response.. I take it that this isnt possible.

Anyone have any ideas on doing it another way?

Haribante:

Can you do it with the QueryCircle method? from the help file:
"Given a location as a circle center point and the radius distance from it, returns a Recordset object containing the records within the area of the circle. "

For points of interest, see the FindNearby method..

"Finds nearby places around a specified location, route, or route segment. Results are sorted in distance order, from closest to farthest, and are limited to the currently visible PlaceCategory objects. Returns a FindResults collection."

Unfortunately you can't really do a buffer say five miles on either side of a road, for that you might try exporting the route to a GIS package running in the background, creating the buffer and then re-importing it into MapPoint.

best,
Eric

__________________

Actually you can. If you select a route on the map screen and then right click you can select "find nearby places". This will return all places (points of interest) and pushpins within X miles (or KM) of the active route. That is it will return all results within X mils on either side of the route... all along the route. Also programmatically the following code will return all places (points of interest) and pushpins within X miles (pr KM) of the active route:

Dim fs As MapPoint.FindResults
Set fs = g_oApp.ActiveMap.ActiveRoute.Directions.FindNearby (X)

You will then need to sort the pushpins from the POI's.

This is actually something that has been in Coordinate Exchange ( http://www.hypercubed.com/projects/coordex/ ) for a while. The user can extract pushpins or POIs within X miles of the active route, screen center, or selected object. It is fairly simple to extract the name and lat/long of each point or POI along the route.

Haribante: Try Coordinate Exchange and if it is that address information your looking for try extracting to the "Coordinate Exchange Everything" file format which includes the address. If that doesn't suit your needs let me know and I can add a file format for you.

By the way... it is very easy to send a route to the GPS and then send all POIs along the route. I do it all the time.

Oh, very cool. I stand corrected.
Thank you for pointing that out!
Eric

__________________