Exporting GPS Data from a folder of images & writing to a CSV
While at #educon @alvintrusty was talking about fusion tables which is a tool from Google that allows you to map and plot data. The conversation came up about attaching GPS data from images into the map. There are several apps for IOS, Windows, and Mac that will allow you to see this data. I wanted to share a quick tip using one of my favorite tools, EXIFTool to pull out the GPS EXIF data from a folder of images.
The goal for this post is to extract Longitude and Latitude data from a folder of images and export the data in a CSV so it can be easily imported into a Fusion Table.
To get started navigate to http://www.sno.phy.queensu.ca/~phil/exiftool/ and download exiftool.
Install the software on your computer.
Once the installation is finished, open up Terminal or open up your Command Line on Windows.
Here is the line that you need to enter:
“exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv”
This command will go to the folder that you input and read through all of the images and pull out the filename, the image size, the GPS Latitude and the GPS Longitude and export everything to a CSV.
Here is the finished CSV that is opened in Excel:
If you have any issues feel free to comment or email me at firstname.lastname@example.org
Find Me Online:
My name is TJ Houston.
I am the Director of Technology at Huron City Schools. I love integrating technology into the classroom and helping teachers find the way on the information super highway. Things I love: My family, My awesome Girlfriend, Technology, Education, and Photography.
I run PD sessions twice a week and run community training the first Saturday of the month. I love teaching people new things.