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