Jump to content

Export Tracks To Streets & Trips?


alanfreed
Followers 0

Recommended Posts

I highly doubt that this can be done, but I thought I'd ask in case anyone has come up with something...

 

It would be really handy to be able to import *tracks* into Microsoft Streets & Trips. I have a few tracks (bike rides, mainly) that would be really slick if they were overlayed on this program.

 

I can do this with the maps in MapSource easy enough, but it would be much more visually appealing with the mapping of S&T.

 

Anyone?

Link to comment

Since you have mapsource, I did the following:

Load data into mapsource, then export as a text file.

 

Load this text file into excel, at the top is the waypoints. Down a ways is the trackpoints (of the track or tracks). Delete all rows but the trackpoints you want. Now delete all columns but the latitude and longitude (for me Nxxx and Wyyy). split this into two columns using 'text to columns' under data. Now remove the N and W (or equivalent) and change the W to a negative number (eg W105 to -105). Save this as a CSV file.

 

Load this csv file into SnT using the data wizard. Select latitude and longitude as the two data types and there you go. finally change the symbols to somethings small and unobtrusive.

Link to comment
Since you have mapsource, I did the following:

Load data into mapsource, then export as a text file.

 

Load this text file into excel, at the top is the waypoints. Down a ways is the trackpoints (of the track or tracks). Delete all rows but the trackpoints you want. Now delete all columns but the latitude and longitude (for me Nxxx and Wyyy). split this into two columns using 'text to columns' under data. Now remove the N and W (or equivalent) and change the W to a negative number (eg W105 to -105). Save this as a CSV file.

 

Load this csv file into SnT using the data wizard. Select latitude and longitude as the two data types and there you go. finally change the symbols to somethings small and unobtrusive.

You could also export the track from mapsource as .mps, then run it through gpsbabel.

gpsbabel -t -i mapsource -o s_and_t drive.mps drive.csv

 

And finally import it into S&T.

Link to comment
You could also export the track from mapsource as .mps, then run it through gpsbabel.

gpsbabel -t -i mapsource -o s_and_t  drive.mps  drive.csv

 

And finally import it into S&T.

thanks, gpsbabel works great :lol: , I figured there was a way ... just never tried it.

 

One thing, with excel you can see the other entries like speed and bearing.

But gpsbabel seems faster and easier.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Followers 0
×
×
  • Create New...