+alanfreed Posted August 20, 2004 Posted August 20, 2004 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? Quote
+cameltrekor Posted August 20, 2004 Posted August 20, 2004 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. Quote
+PDOP's Posted August 20, 2004 Posted August 20, 2004 Have a look at ST2GPX . It's a command line utility which may do what you want. Quote
BootPrint Posted August 20, 2004 Posted August 20, 2004 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. Quote
+park2 Posted August 21, 2004 Posted August 21, 2004 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. Quote
+alanfreed Posted August 24, 2004 Author Posted August 24, 2004 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. Quote
+cameltrekor Posted August 24, 2004 Posted August 24, 2004 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. Quote
Recommended Posts
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.