Digital Media | Spotlight: Photography | Inside Lightroom | Blogs
Get a Look at Your Equipment Habits
The metadata browser in Lightroom offers an informative hierarchical tree of information based on the various bits and bobs of metadata that are associated with your images. From the moment I saw this, I became fascinated with the way that it allowed me to browse my images. For example, I could look at all of the images taken with my 135 f/2 lens and compare them without any interference from shots taken with a wide angle lens. But then, as time went on, I found it not only served as a way to browse images, it also told me a lot of information about my equipment habits, at least in terms of usage.
To show you this in action, here's a screenshot of the metadata browser for a library that has several of my recent jobs loaded into it. Some of these jobs, I shot alone. Others, I shot with Pinar Ozger, who has been working with me some this year. Looking at the browser, you can immediately tell a few things. First of all, my Canon 70-200mm f/2.8 IS USM lens is my absolute go to lens. If there is any one lens that is essential to my work, it's this one and the numbers back that up by showing that it's used for half the images taken. This tells me that if there's any single lens that I have to ensure is in working order, it's the 70-200. Second, if there's any piece of glass I can leave at home, it's my 20mm lens. I've not been happy with the image quality it produces and it shows in the usage numbers. I shouldn't even be lugging it around at this point and I should probably replace it with a lens that produces better results if I want to work at that focal length.
Another gem of information in this data centers on the two 300mm lenses in the listing. For the Web 2.0 Expo last month, I rented a Canon 300mm f/2.8 and put it to good use. It turned out to be such a sharp lens and worked so well, that I ended up buying the newer Image Stabilized version of it and using it at the MySQL Conference the next week for the bulk of the keynote shots. Even though I've only had it for a few weeks, it already accounts for a significant number of shots. I expect that soon, it'll be right up there with the 70-200mm lens as far as number of shots taken.
Unfortunately, the lens listings are only as good as the metadata that the cameras embed into the original files. For example, you can see that there are entries in the metadata tree for a EF 70-200mm f/2.8 IS USM lens and a 70.0-200.0mm lens. This is actually the same lens, but it shows up as two different entries because of the different amounts of metadata that various cameras embed. In this case, the Canon EOS 5D and 30D bodies embed enough data for Lightroom to call out the correct lens, but the Canon EOS 20D body on embeds enough data for Lightroom to show the focal length range. Even so, there's more than enough information here to sort out what's going on.
There's one thing that I wish I could do with this data that isn't currently possible. I'd like to be able to see an actual pattern of focal length usage in one place. Maybe something like a histogram display of the focal lengths used to create all of the images in my library. You see, now that I know that not only do I use my 70-200 a lot, but that it accounts for half of my shooting, I'd like to know at what focal lengths I'm really working. Am I spending a lot of time at 70 or 80mm? 135mm? Or all the way tight at 200? If I knew the answer to those questions, then I could target future lens aquisions appropriately.
Comments (9)


I think this is just a good chance for you to show off the expensive list of L glass you own... ;-)
It looks like this would be a good place to extend the use of synonyms. Allow the user to define equivalences and choose a default for which displays in the metadata browser.
Is there any way to *modify* the metadata to put in which lens you are using? I'm using an older lens that is not recognized (a film lens for my K10D)
I went through the same thing a month or so ago. If you have XMP exporting turned on, then it's pretty trivial to extract focal lengths from the XMP files and summarize using Unix tools.
Haven't had time to work something out yet, but have a look at
http://www.ch-werner.de/sqliteodbc/html/index.html (sqlite odbc) and use excell!
Otherwise, knowing that you're more of a mac person, you could use the dump command in the actual sqlite tool and import the whole shebang in MySQL, although other (transactional) databases might be a better choice ;-)
Otherwise, the xmp exporting also seems a good idea to grab the information you need !
You can use the SQLite browser to achieve the same without having to export individual XMP files. See my comment on Scott Laird's blog article at
http://scottstuff.net/blog/articles/2007/04/17/focal-lengths
Daveed... The focal lengths are in a a table field containing the complete xmp data ;-)
So whether you get it out of the xmp files, or xmp fields in the database: same difference ;-)
MIke: Right. However, I don't really want to create thousands of XMP files just to get all the focal length data. So instead I can use the SQLite browser to generate a single file that contains all those XMP fields, extract the info I'm interested in (the focal lengths in this case), and them delete the one file dump. If you always export XMP files, it probably doesn't matter much, of course.
Guy: I'm a strong believer that the image is the important thing, equipment is just how you get there.
AndyP: I agree, this would be an awesome place for synonyms and equivalence.
Shazron: Unfortunatly, I don't know of a way to modify that metadata in the LR interface.
Mike, Scott, and Daveed: Nice ideas and interesting implementations in the links. Thanks! I'm really looking forward to the LR SDK so that I can poke around through the API rather than digging through the back end data. :)