I use an app on my droid called MyTracks to track my mileage biking, hiking, or whatever. MyTracks lets you email your data to yourself as a file (gpx, kml,csv,tcx) or upload your data to Google Maps, to a spreadsheet in Google Docs, or to Google Fusion Tables. I had never heard of google fusion tables until it popped up as an option after I upgraded to a newer version of mytracks. It seemed cool but I didn’t really know what to do with it. Tonight I figured out how to get multiple rides into one google fusion table so I can see them all on one map.
This seemed like a fun visual way to keep track of my rides for 30 Days of Biking.
So far I’ve ridden 66 miles though I’ve covered some of the same ground a bunch of times.
But I’ve covered the ground in the driveway a lot!
I think tracking my miles this way will encourage me to try to cover new ground, to paint every road red. Brian says I should try to spell my name.
How to Get Multiple MyTracks Files in one Google Fusion Table
1. Go to ‘Tracks’ in the MyTracks app and hold down on the track you want to upload
2. Choose “Send to google”, check the box for Google Fusion Tables, and send
3. Do this again with another file that you want to merge with this one.
4. Go to http://www.google.com/fusiontables/
You might have to set up an account if you haven’t used fusion tables before. I can’t remember. I did this a while ago.
5. Open one of the tables and go to File > Export and it should dump a .csv file on to your computer somewhere. You know where. Mine goes in my downloads folder.
6. Open the other table from the data you just uploaded, this will be your big file, go to File > Import More Rows. Find the csv you just exported, select it, and follow the basic instructions.
7. Repeat until you have squashed all your rides into one table.
There may be better ways of doing this but I’m new to Google Fusion Tables. I’m in that phase where I’m super excited about something new, but really have no idea what I’m doing. I am happy to spread my minimal and possibly inaccurate knowledge far and wide. Let me know if you have better methods or know of other awesome things I could be doing with this.
Comments are closed.