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.

selected geodata

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.

geodata pasted into excel

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.

excel menu for text to columns

A pop-up window appears. Make sure the Delimited button is selected.

select the delimited button

Press Next. Now, make sure only the Semicolon box is checked, since each data type is separated by a semicolon.

select only the semicolon checkbox

Press Next. In the final window, we simply keep the General button selected, then press Finish.

in this panel choose general and finish

As a result, the information will be distributed into columns.

the new columns with separated data

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.

save as csv

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.

image of local path to image file

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.

find and replace the image path

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.

image of first row selection

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:

  • Latitude
  • Longitude
  • 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:

newly labeled columns

Save the file. You now have a .csv file that can be uploaded to ZeeMaps to create a photo map.