geotagging and mapping photos
Creating a CSV File
We will create a CSV file in Excel. A CSV file is essentially a set of data that, in this case, includes the web address of each photo, the latitude, longitude, image names, and any other information you ultimately decide to include.
Paste the Geotagged Data in Excel
First select all of the matched photo and location data in the HoudahGeo window by clicking on one of the entries and pressing Apple-A.
Then copy the entries by pressing Apple-C.
Open Excel and create a new blank workbook document.
Press Apple-V to paste the data into the document.
Separate the Data into Columns
You will see a string of characters, each existing only in the first column.
Each set of data is separated by a semicolon. For example, the photo name and file path is separated by a semicolon from the date ad time. We want to separate each of these types of data into separate columns. To do this, go to the top menu and choose Data: Text to Columns.
A pop-up window appears. Make sure the Delimited button is selected.
Press Next. Now, make sure only the Semicolon box is checked, since each data type is separated by a semicolon.
Press Next. In the final window, we simply keep the General button selected, then press Finish.
As a result, the information will be distributed into columns.
If any column is full of pound signs (#######), simply widen the column by clicking the top column button and dragging the margin to the right.
Before continuing, save the file as a CSV file in a folder associated with your project. The resulting file name should end with .csv, NOT .xls.
Correct the Photo Paths
We need to make sure that the photo URLs are correct in this file. Right now, the path is based on the local folders in your computer. We will do a find and replace to match the online location.
Here you can see the local path to the .jpg file. Highlight the entire path, except for the image title, and press Apple-C to copy it.
Next, go to the top menu and choose Edit: Replace.
In the pop-up window, paste in the local folder path in the Find what field.
Then, copy the web address of the path to your images. Using the example from the last step, the path would be: http://mysite.com/photos/photowalk/ Don't forget to include the final forward slash at the end of the address. Paste that address into the Replace with field. Click Replace All.
Now, the proper web addresses should exist for each photo in the list.
Label the Columns
Next we must label each column by creating a header row.
Click the "1" button on the Excel document to select the entire first row.
Go to the top menu and choose Insert: Rows. A new row will appear.
In that new top row, label each of the columns in the same order they are labeled in HoudahGeo; the only difference is that the photo column should be labeled "Photo URL." We won't use the altitude data, so you can delete that.
The important column headers for use in ZeeMaps are:
- Photo URL
- Name -- You can create this in an empty column into an empty column and then add a name to each image row.
The resulting file ought to look something like this:
Save the file. You now have a .csv file that can be uploaded to ZeeMaps to create a photo map.