I just read this interesting post after finding a link to it over at brilliantdays. Some more searching and clicking, I also found this, and I came to think of the following story:
A couple of years ago I traveled through Alsace in France by bicycle. I had my GPS attached to the handlebars and took lots of pictures with my digital camera during the trip.
When I came home, I transfered the pictures to my laptop as usual. I also transfered the GPS-log with all the coordinates to the same machine. I started thinking about how nice it would have been if the GPS was built into my camera so that I could have placed all my pictures on the map.
Thinking a bit further, I realized that I actually had the data to do exactly that:
1. A track from the GPS. Basically a long list of time stamps and GPS coordinates
2. Huge amounts of pictures. All of them time stamped
3. OZI Explorer software, supporting links to pictures in the maps
So, I have data telling me where I was when. And I have pictures telling me when they where taken. There is a link here: when.
I figured, how difficult could it be to match the time stamps from the pictures to the closest time stamp in the GPS-log? That would actually place the picture quite accurate. Well, that was not too difficult. I imported a list of the pictures and the complete GPS-log into Excel. A little VBA code, and voila: a file that was compatible with OZI-explorer placing all my pictures amazingly accurate on the map.
You can click the picture in this post to see one of the results.
For the people that are familiar with excel and visual basic for applications (VBA) you can download the very undocumented excel sheet with the code that match gps points with pictures here:
If you manage to import a list of pictures with time stamps in the sheet called pictures and a tracklog into the sheet called track, keeping the right data in the right coloumns, running the script called PlacePics2() will match the closest track point to each picture. Running the script called GenerateOziMapComments() will generate a text file with the information needed to place the pictures on a map in OziExplorer. The last script, cleandups() is simply a script that you can run if you want to delete the rows where several pictures is placed on the same GPS-point.
This whole process is very undocumented, but if you want to try it out please do not hesitate to ask questions through comments here. If people show any interest I will consider a major upgrade of the documentation!
15 thoughts on “Travelling with a GPS and a digital camera”
[…] – “Yeah. Right. I found all the technology and some food. Now, where is all that travel?” – Try this one, or maybe this one. […]
Is there any way that I can be traced using a GPS reciver thorugh internet, like if am outside and my GPS is working is there any application by which anybody can trace me sitting on computer? lg-462.blogspot.com
Most GPS devices are just recievers. They don’t transmit to anyone where you are.
Most tracking solutions I have seen are combinations of a GPS and a mobile phone with a data connection.
I would look for a combination of a bluetooth enabeled GPS in combination with an advanced mobile phone. Symbian or Windows Mobile.
the only thing you have to watch out for when your not want to be fund is your cellphone
What a great adventure and a fantastice way to track your journey. Have you got any other journeys planed as I would be interested to see the results.
There is another interesting way to make maps like this with Gallery from menalto.gallery.com and a plugin that connects pictures with GPS information to Google earth. An example can be found here.
Sadly the markers for albums doesn’t work right now. …
One of the interesting things about this combinations is that you can import pictures with GPS information and draw lines between to show a route.
And now the map page is up and working. Pretty nifty I must say 🙂
Heres another way to use Google Maps in your blog. http://www.sandvik.bz/2008/02/06/bildet-mitt
Embed a Google map in a blog article.
Log in to Google. Go to this page http://maps.google.com/. Create a new map. Edit it with routes and placemarks and embed it in your blog. Very easy and utterly cool! The only thing to remember is to turn off the visual editor when embedding the map.
[…] years ago I did an experiment after returning from a trip in France. I matched the time stamps of my digital images with the time […]
Hey, I found your info regarding matching photos and GPS tracks very interesting and may be doing a HUGE project for my current GIS class. Have you made any updates to the excel file? I havn’t used it yet, because I havn’t gone out with my camera and gps together, but was wondering. Thanks if you can help!
Haven’t done any updates to the excel file because I’ve found a lot of software that does this job way better:
Stands back from the keyboard in ameameznt! Thanks!
Thank you for the sensible critique. Me & my cousin were just preparing to do some research on this. We got a book from our local library but I think I learned better from this post. Iâ€™m very glad to see such great info being shared freely out thereâ€¦