PDA

View Full Version : Is it possible to Export Mappoint Route as Polyline/WKT?



holmesm
01-11-2012, 05:20 PM
Hello,

I have been searching all over for a solution to this...I am hoping someone here on the forum might have the expertise to point me in the right direction.

What I am trying to do is to take a road route in Mappoint (with start and end point), and translate that route into a Polyline that can be stored in a geographically enabled database (WKT format...essentially a series of x,y coordinates that define the route)....

I find that it only appears possible to extract waypoints along the route, but nothing that describes the geometric shape of the route. I feel there must be a way to do this since the Mappoint application itself can visually display where the route goes along the roads...

Thanks,

Mike.

Winwaed
01-12-2012, 07:29 AM
As you have found, you cannot get at the road coordinates, or even coordinates along a route using the standard interface. Some (possibly all) of these restrictions are due to sub-licensing issues (ie. the road data provider does not allow it to be exported).


However, if you need data points along your route, and if your route is a "shortest route" (rather than fastest), then there is a workaround. Switch route rest stops to on, set the rest stop length to be very short (eg. 1 minute) and the interval between rest stops to be as short as possible.
Then when you loop over the route and the directions, you will find "directions" for each rest stop. These will have the correct location for the rest stop - ie. on the road.
(locations for directions are usually "for best view" - there's no guarantee they'll be on the route unless they correspond to a rest stop or waypoint)

To export shapes, then the API allows this (although there's an open/closed ambiguity in the API) and there are a number of add-in tools which will do this (eg. our MPSuperShape).

Eric Frost
01-12-2012, 09:34 AM
I'm not that familiar with this, but it might be worthwhile to try the "Export to GPX" feature in the Data menu.

Also, I wrote a tool in the MapForums Downloads section that extracts the approximate route path. The code was fairly easy. If you decide to write this yourself, let us know how it goes and I'll see what I can do to help.

"This tool writes out the coordinates of all the direction objects along a route, approximating the actual coordinates of the route path. By setting a rest stop every minute and setting all the speeds to 1 mile per hour, you are actually able to get the route coordinates with fairly fine resolution."

http://www.mapforums.com/extracting-coordinates-route-16777.html

Route Factory Spreadsheet, MapPoint Videos on Youtube, MapForums Downloads Section (http://www.mp2kmag.com/update/mappoint.newsletter/2011-05-05/)

It is also discussed in this thread --

http://www.mapforums.com/how-get-gps-coordinates-interval-route-mappoint-15120.html

Let us know how it goes!

Eric

Mattys Consulting
01-13-2012, 10:01 AM
Re-post to correct thread :stuart:

I did this a few years ago for a company requiring stops every x-amount of feet for the purpose of picking up handicapped/seniors nearby their homes.

The program worked well, but there were shortfalls going around clover-leaf highway-exits and such.

Anyway, I would be willing to work on it again to adapt to your needs
(ie; it is custom development and I do not make source code available.)

PROFIT100 Consulting
01-14-2012, 03:40 AM
Hi Mike,

we developed a software that creates optimized polylines from a MapPoint-Route. You can export those route-polygones to CSV, KML and ESRI. Send me an email and you will get the software for free.

Manfred