Export Tracks To Streets & Trips?

[+alanfreed]

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?

[+cameltrekor]

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.

[+PDOP's]

Have a look at ST2GPX . It's a command line utility which may do what you want.

[BootPrint]

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.

[+park2]

I haven't used ST2 or Bable but a year or two back I did use Excel and it worked OK.

 

It worked a lot better after I wrote a macro to do all the formatting for me, it was kind of neat watch it chug away.

[+alanfreed]

Thanks for the ideas! I didn't realize I could export the track file from MapSource... the whole Excel thing worked great! Thanks again for the ideas... this worked out really well.

[+cameltrekor]

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 , 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.