New Tools for the Friends Album

I’m almost halfway through with blog posts about the 75* people featured in the Friends Album. I felt I needed to do two things to better wrap my head around these folks, where they’re from and how they are connected.

Firstly, I created yet another map in Google Maps, showing the locations for each of the friends featured so far (previously, I created a map showing the locations of the photographers I’ve found in Danbury, Connecticut). The photos were taken in New York, Connecticut and Massachusetts. A large number were taken in Danbury, Connecticut. Yonkers, New York, and New Milford, Connecticut, also were the sites of several photos each.

Friends Album Photo Location Google Map (links to Google Map)

It’s good to see the geographic dispersal of these photos, but I wanted a way to more intricately compare the data I’ve compiled from each image. I next created a Google spreadsheet that shows (where known) the names, locations, approximate dates, ages, photo types and assorted notes, along with thumbnail images for each photo.

Friends Album Google Doc Spreadsheet (links to spreadsheet)

I still have to go through and try all of the different sorts and filters available to me now that I’ve populated this with data. I’m trying to figure out if I can link the thumbnail images to their larger versions on the web. I’ll continue to update the spreadsheet as I investigate each photo. The link provided here will automatically update with my changes. I invite folks to check out both of these tools and let me know if you notice any patterns that I might be missing.

* Originally, I counted 75 people in the album, but now have found a couple of people with more than one photo included. As of now, the number of distinct individuals is probably closer to 70.

4 thoughts on “New Tools for the Friends Album

  1. hummer says:

    I really love this how creative. Someday I will get this organized to compile my information.

    • baysideresearch says:

      Thanks! Setting up the Google spreadsheet was pretty easy. The biggest pain was sizing all the photos for the thumbnails.

  2. Aillin says:

    This is a great idea. I will have to try to do something similar with an unknown album of photographs I have.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s