EXIF Analyzer?

<span style="color: #003300;"]I hope this is the proper forum for this question but it relates to software processing so....


Can any one recommend a EXIF analyzer that works on Canon RAW files (I rarely shoot JPGs anymore)?


I asked The Google, and found a few tools out there but the forum
threads were years old and the tools appeared to only work on JPGs.


I am looking for an analysis of how I take pictures. Yeah, I know I am
getting deep into my neurosis, but hey, aren't most of us here a little
off? I would like to know what focal lengths I use the most. My friend
is prepared to buy a very expensive, long lens and he wanted to know
how I use my Canon 70-200 2.8 IS II? After thinking about it, I
probably use it most at 200mm. Therefore, why buy a zoom and not get a
prime thus either saving some money or maybe getting a better lens?
Hmmmm.... Well that got the geek-ball rolling and now I want to know
what f-stop, etc etc etc.


Any help with this request? Even a software tool to dump EXIF data
would be great as I am a wiz at Excel and therefore can generate the
analysis if I can just get my hands o

n the data. My camera is a 5D MK
II.

I think you could batch-convert your RAW files to Adobe's DNG. Since DNG is an open format, you should be able to find some kind of parser to extract the EXIF data and then export it to a file the format you consider useful (CSV, XML, TXT, etc).


I'm not very knowledgeable about Visual Basic, but I think you could code a script to run DPP, launch the File Properties dialog, extract the necessary EXIF data and paste it in the app/file you want.


BTW, statistical analysis of EXIF data might be really useful to photographers

You could bugger Canon until they release a full specification of their RAW file format...


...since for some reason they believe that it is in their best commercial interest to withhold the information from the customers and the world, thereby preventing 3rd party tools, that could otherwise be easily written, from performing just such tasks!


End of rant.

Lightroom 3 will allow you to filter your library of raw images using EXIF data such as lens and focal length. You would be able to select all images taken with your 70-200mm lens, then see a breakdown of how many were taken at various focal lengths. You could also analyse your aperture settings, shutter speeds, ISO etc.

If you have Adobe Bridge it gives you all that filter information with every file. You just have to click on it. Simple to sort and see what pics were at each setting you are researching in each file.

Quote:

---

Originally Posted by Andy Stringer

Lightroom 3 will allow you to filter your library of raw images using EXIF data such as lens and focal length. You would be able to select all images taken with your 70-200mm lens, then see a breakdown of how many were taken at various focal lengths. You could also analyse your aperture settings, shutter speeds, ISO etc.

---

In case somebody is wondering: Aperture does the same thing.


(It still wouldn't be bad to have a command-line tool to extract the information &mdash; a simple Unix-shell-script could then generate a CSV-file for further processing in Excel or even Gnuplot).


Ciao, Colin

heh, I get the feeling he was wanting to go oldschool programming/data entry. You

I know the fastest and in my opinion the best way to analyse Exif data.


First question: do you know the program Total Commander?


It is the very powerful, very comfortable, very fast file manager program which uses less computer resources than others. If you use Windows Explorer for your file browsing, copying, moving, deleting so with this program you can do all these actions 3 or 4 times faster. I can not imagine using computer without this program [;)]


Ok, now when you have this program on your computer you can add plug-in for your total commander which can show EXIF data in the list while you are browsing your directories (folders). It shows all files EXIF data which are in the directory, not only selected.


That you could see EXIF data, you have to configure total commander columns of list view type. And configuring columns you can add to show all EXIF data columns because of this plug-in. Maybe it sound complex, but it is realy easy [:)] And you can add what ever you want columns of your EXIF data. For example: Software with which was edited photo, photo Owner, camera firmware, camera model and many other thing, which you wouldn't see in typical exif viewer.


It completely works with CR2 files and JPEG and i think with all others.


There is a screenshot, how it looks (only the left program window side)


[img]/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/13/5123.totalcmdExifPlugin.png[/img]


When you want to see photo, just double-click on it and you know, what camera configuration was used on that view.


if you are interested, tell me, and i will tell you how to install, configure and several hints [:)]


I would strongly advise to all members to use such type of EXIF browsing [:)]


I can add one more screenshot of how much information we can extract from the EXIF.


[img]/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/13/5734.exifdata.png[/img]

Aha, he who searches shall find ... at least if he uses the shell:





$ exiv2 IMG_0013.CR2


File name : IMG_0013.CR2
<span style="font-size: 11.6667px;"]File size : 28054102 Bytes
<span style="font-size: 11.6667px;"]MIME type : image/x-canon-cr2
<span style="font-size: 11.6667px;"]Image size : 5616 x 3744
<span style="font-size: 11.6667px;"]Camera make : Canon
<span style="font-size: 11.6667px;"]Camera model : Canon EOS 5D Mark II
<span style="font-size: 11.6667px;"]Image timestamp : 2010:05:13 17:58:14
<span style="font-size: 11.6667px;"]Image number :
<span style="font-size: 11.6667px;"]Exposure time : 1/60 s
<span style="font-size: 11.6667px;"]Aperture : F2.8
<span style="font-size: 11.6667px;"]Exposure bias : 0 EV
<span style="font-size: 11.6667px;"]Flash : No, compulsory
<span style="font-size: 11.6667px;"]Flash bias : 0 EV
<span style="font-size: 11.6667px;"]Focal length : 24.0 mm
<span style="font-size: 11.6667px;"]Subject distance: 0
<span style="font-size: 11.6667px;"]ISO speed : 3200
<span style="font-size: 11.6667px;"]Exposure mode : Aperture priority
<span style="font-size: 11.6667px;"]Metering mode : Multi-segment
<span style="font-size: 11.6667px;"]Macro mode : Off
<span style="font-size: 11.6667px;"]Image quality : RAW
<span style="font-size: 11.6667px;"]Exif Resolution : 5616 x 3744
<span style="font-size: 11.6667px;"]White balance : Auto
<span style="font-size: 11.6667px;"]Thumbnail : image/jpeg, 11630 Bytes
<span style="font-size: 11.6667px;"]Copyright :
<span style="font-size: 11.6667px;"]Exif comment :
<div>$ exiv2 -p t IMG_0013.CR2</div>
<div></div>
<div><span style="font-size: 11.6667px;"]Exif.Image.ImageWidth Short 1 5616</div>
<div>
<div>Exif.Image.ImageLength Short 1 3744</div>
<div>Exif.Image.BitsPerSample Short 3 8 8 8</div>
<div>Exif.Image.Compression Short 1 JPEG (old-style)</div>
<div>Exif.Image.Make Ascii 6 Canon</div>
<div>Exif.Image.Model Ascii 21 Canon EOS 5D Mark II</div>
<div>Exif.Image.StripOffsets Long 1 56092</div>
<div>Exif.Image.Orientation Short 1 top, left</div>
<div>Exif.Image.StripByteCounts Long 1 1781532</div>
<div>Exif.Image.XResolution Rational 1 72</div>
<div>Exif.Image.YResolution Rational 1 72</div>
<div>Exif.Image.ResolutionUnit Short 1 inch</div>
<div>Exif.Image.DateTime Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Image.Artist Ascii 1 </div>
<div>Exif.Image.Copyright Ascii 1 </div>
<div>Exif.Image.ExifTag Long 1 434</div>
<div>Exif.Photo.ExposureTime Rational 1 1/60 s</div>
<div>Exif.Photo.FNumber Rational 1 F2.8</div>
<div>Exif.Photo.ExposureProgram Short 1 Aperture priority</div>
<div>Exif.Photo.ISOSpeedRatings Short 1 3200</div>
<div>Exif.Photo.ExifVersion Undefined 4 2.21</div>
<div>Exif.Photo.DateTimeOriginal Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Photo.DateTimeDigitized Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Photo.ComponentsConfiguration Undefined 4 YCbCr</div>
<div>Exif.Photo.ShutterSpeedValue SRational 1 1/64 s</div>
<div>Exif.Photo.ApertureValue Rational 1 F2.8</div>
<div>Exif.Photo.ExposureBiasValue SRational 1 0 EV</div>
<div>Exif.Photo.MeteringMode Short 1 Multi-segment</div>
<div>Exif.Photo.Flash Short 1 No, compulsory</div>
<div>Exif.Photo.FocalLength Rational 1 24.0 mm</div>
<div>Exif.Photo.MakerNote Undefined 41144 (Binary value suppressed)</div>
<div>Exif.MakerNote.Offset Long 1 900</div>
<div>Exif.MakerNote.ByteOrder Ascii 3 II</div>
<div>Exif.CanonCs.Macro Short 1 Off</div>
<div>Exif.CanonCs.Selftimer Short 1 Off</div>
<div>Exif.CanonCs.Quality Short 1 RAW</div>
<div>Exif.CanonCs.FlashMode Short 1 Off</div>
<div>Exif.CanonCs.DriveMode Short 1 Single / timer</div>
<div>Exif.CanonCs.FocusMode Short 1 One shot AF</div>
<div>Exif.CanonCs.ImageSize Short 1 Small</div>
<div>Exif.CanonCs.EasyMode Short 1 Manual</div>
<div>Exif.CanonCs.DigitalZoom Short 1 None</div>
<div>Exif.CanonCs.Contrast Short 1 High</div>
<div>Exif.CanonCs.Saturation Short 1 (32767)</div>
<div>Exif.CanonCs.Sharpness Short 1 (32767)</div>
<div>Exif.CanonCs.ISOSpeed Short 1 (32767)</div>
<div>Exif.CanonCs.MeteringMode Short 1 Evaluative</div>
<div>Exif.CanonCs.FocusType Short 1 Not known</div>
<div>Exif.CanonCs.AFPoint Short 1 (0)</div>
<div>Exif.CanonCs.ExposureProgram Short 1 Aperture priority (Av)</div>
<div>Exif.CanonCs.LensType Short 1 Canon EF 24-70mm f/2.8L</div>
<div>Exif.CanonCs.Lens Short 3 24.0 - 70.0 mm</div>
<div>Exif.CanonCs.MaxAperture Short 1 F2.8</div>
<div>Exif.CanonCs.MinAperture Short 1 F23</div>
<div>Exif.CanonCs.FlashActivity Short 1 Did not fire</div>
<div>Exif.CanonCs.FlashDetails Short 1 </div>
<div>Exif.CanonCs.FocusContinuous Short 1 (65535)</div>
<div>Exif.CanonCs.AESetting Short 1 (65535)</div>
<div>Exif.CanonCs.ImageStabilization Short 1 (65535)</div>
<div>Exif.CanonCs.DisplayAperture Short 1 0</div>
<div>Exif.CanonCs.ZoomSourceWidth Short 1 0</div>
<div>Exif.CanonCs.ZoomTargetWidth Short 1 0</div>
<div>Exif.CanonCs.SpotMeteringMode Short 1 (65535)</div>
<div>Exif.CanonCs.PhotoEffect Short 1 (65535)</div>
<div>Exif.CanonCs.ManualFlashOutput Short 1 n/a</div>
<div>Exif.CanonCs.ColorTone Short 1 32767</div>
<div>Exif.CanonCs.SRAWQuality Short 1 n/a</div>
<div>Exif.Canon.FocalLength Short 4 24.0 mm</div>
<div>Exif.CanonSi.ISOSpeed Short 1 3200</div>
<div>Exif.CanonSi.MeasuredEV Short 1 2051.88</div>
<div>Exif.CanonSi.TargetAperture Short 1 F2.8</div>
<div>Exif.CanonSi.TargetShutterSpeed Short 1 1/64 s</div>
<div>Exif.CanonSi.WhiteBalance Short 1 Auto</div>
<div>Exif.CanonSi.Sequence Short 1 0</div>
<div>Exif.CanonSi.AFPointUsed Short 1 0 focus points; none used</div>
<div>Exif.CanonSi.FlashBias Short 1 0 EV</div>
<div>Exif.CanonSi.SubjectDistance Short 1 0</div>
<div>Exif.CanonSi.ApertureValue Short 1 F2.8</div>
<div>Exif.CanonSi.ShutterSpeedValue Short 1 1/59 s</div>
<div>Exif.CanonSi.MeasuredEV2 Short 1 4.00</div>
<div>Exif.Canon.ImageType Ascii 21 Canon EOS 5D Mark II</div>
<div>Exif.Canon.FirmwareVersion Ascii 24 Firmware Version 2.0.4</div>
<div>Exif.Canon.OwnerName Ascii 32 </div>
<div>...and it goes on for another one or two pages...</div>
<div></div>
</div>

Aha, he who searches shall find ... at least if he uses the shell:





$ exiv2 IMG_0013.CR2


File name : IMG_0013.CR2
<span style="font-size: 11.6667px;"]File size : 28054102 Bytes
<span style="font-size: 11.6667px;"]MIME type : image/x-canon-cr2
<span style="font-size: 11.6667px;"]Image size : 5616 x 3744
<span style="font-size: 11.6667px;"]Camera make : Canon
<span style="font-size: 11.6667px;"]Camera model : Canon EOS 5D Mark II
<span style="font-size: 11.6667px;"]Image timestamp : 2010:05:13 17:58:14
<span style="font-size: 11.6667px;"]Image number :
<span style="font-size: 11.6667px;"]Exposure time : 1/60 s
<span style="font-size: 11.6667px;"]Aperture : F2.8
<span style="font-size: 11.6667px;"]Exposure bias : 0 EV
<span style="font-size: 11.6667px;"]Flash : No, compulsory
<span style="font-size: 11.6667px;"]Flash bias : 0 EV
<span style="font-size: 11.6667px;"]Focal length : 24.0 mm
<span style="font-size: 11.6667px;"]Subject distance: 0
<span style="font-size: 11.6667px;"]ISO speed : 3200
<span style="font-size: 11.6667px;"]Exposure mode : Aperture priority
<span style="font-size: 11.6667px;"]Metering mode : Multi-segment
<span style="font-size: 11.6667px;"]Macro mode : Off
<span style="font-size: 11.6667px;"]Image quality : RAW
<span style="font-size: 11.6667px;"]Exif Resolution : 5616 x 3744
<span style="font-size: 11.6667px;"]White balance : Auto
<span style="font-size: 11.6667px;"]Thumbnail : image/jpeg, 11630 Bytes
<span style="font-size: 11.6667px;"]Copyright :
<span style="font-size: 11.6667px;"]Exif comment :
<div>$ exiv2 -p t IMG_0013.CR2</div>
<div></div>
<div><span style="font-size: 11.6667px;"]Exif.Image.ImageWidth Short 1 5616</div>
<div>
<div>Exif.Image.ImageLength Short 1 3744</div>
<div>Exif.Image.BitsPerSample Short 3 8 8 8</div>
<div>Exif.Image.Compression Short 1 JPEG (old-style)</div>
<div>Exif.Image.Make Ascii 6 Canon</div>
<div>Exif.Image.Model Ascii 21 Canon EOS 5D Mark II</div>
<div>Exif.Image.StripOffsets Long 1 56092</div>
<div>Exif.Image.Orientation Short 1 top, left</div>
<div>Exif.Image.StripByteCounts Long 1 1781532</div>
<div>Exif.Image.XResolution Rational 1 72</div>
<div>Exif.Image.YResolution Rational 1 72</div>
<div>Exif.Image.ResolutionUnit Short 1 inch</div>
<div>Exif.Image.DateTime Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Image.Artist Ascii 1 </div>
<div>Exif.Image.Copyright Ascii 1 </div>
<div>Exif.Image.ExifTag Long 1 434</div>
<div>Exif.Photo.ExposureTime Rational 1 1/60 s</div>
<div>Exif.Photo.FNumber Rational 1 F2.8</div>
<div>Exif.Photo.ExposureProgram Short 1 Aperture priority</div>
<div>Exif.Photo.ISOSpeedRatings Short 1 3200</div>
<div>Exif.Photo.ExifVersion Undefined 4 2.21</div>
<div>Exif.Photo.DateTimeOriginal Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Photo.DateTimeDigitized Ascii 20 2010:05:13 17:58:14</div>
<div>Exif.Photo.ComponentsConfiguration Undefined 4 YCbCr</div>
<div>Exif.Photo.ShutterSpeedValue SRational 1 1/64 s</div>
<div>Exif.Photo.ApertureValue Rational 1 F2.8</div>
<div>Exif.Photo.ExposureBiasValue SRational 1 0 EV</div>
<div>Exif.Photo.MeteringMode Short 1 Multi-segment</div>
<div>Exif.Photo.Flash Short 1 No, compulsory</div>
<div>Exif.Photo.FocalLength Rational 1 24.0 mm</div>
<div>Exif.Photo.MakerNote Undefined 41144 (Binary value suppressed)</div>
<div>Exif.MakerNote.Offset Long 1 900</div>
<div>Exif.MakerNote.ByteOrder Ascii 3 II</div>
<div>Exif.CanonCs.Macro Short 1 Off</div>
<div>Exif.CanonCs.Selftimer Short 1 Off</div>
<div>Exif.CanonCs.Quality Short 1 RAW</div>
<div>Exif.CanonCs.FlashMode Short 1 Off</div>
<div>Exif.CanonCs.DriveMode Short 1 Single / timer</div>
<div>Exif.CanonCs.FocusMode Short 1 One shot AF</div>
<div>Exif.CanonCs.ImageSize Short 1 Small</div>
<div>Exif.CanonCs.EasyMode Short 1 Manual</div>
<div>Exif.CanonCs.DigitalZoom Short 1 None</div>
<div>Exif.CanonCs.Contrast Short 1 High</div>
<div>Exif.CanonCs.Saturation Short 1 (32767)</div>
<div>Exif.CanonCs.Sharpness Short 1 (32767)</div>
<div>Exif.CanonCs.ISOSpeed Short 1 (32767)</div>
<div>Exif.CanonCs.MeteringMode Short 1 Evaluative</div>
<div>Exif.CanonCs.FocusType Short 1 Not known</div>
<div>Exif.CanonCs.AFPoint Short 1 (0)</div>
<div>Exif.CanonCs.ExposureProgram Short 1 Aperture priority (Av)</div>
<div>Exif.CanonCs.LensType Short 1 Canon EF 24-70mm f/2.8L</div>
<div>Exif.CanonCs.Lens Short 3 24.0 - 70.0 mm</div>
<div>Exif.CanonCs.MaxAperture Short 1 F2.8</div>
<div>Exif.CanonCs.MinAperture Short 1 F23</div>
<div>Exif.CanonCs.FlashActivity Short 1 Did not fire</div>
<div>Exif.CanonCs.FlashDetails Short 1 </div>
<div>Exif.CanonCs.FocusContinuous Short 1 (65535)</div>
<div>Exif.CanonCs.AESetting Short 1 (65535)</div>
<div>Exif.CanonCs.ImageStabilization Short 1 (65535)</div>
<div>Exif.CanonCs.DisplayAperture Short 1 0</div>
<div>Exif.CanonCs.ZoomSourceWidth Short 1 0</div>
<div>Exif.CanonCs.ZoomTargetWidth Short 1 0</div>
<div>Exif.CanonCs.SpotMeteringMode Short 1 (65535)</div>
<div>Exif.CanonCs.PhotoEffect Short 1 (65535)</div>
<div>Exif.CanonCs.ManualFlashOutput Short 1 n/a</div>
<div>Exif.CanonCs.ColorTone Short 1 32767</div>
<div>Exif.CanonCs.SRAWQuality Short 1 n/a</div>
<div>Exif.Canon.FocalLength Short 4 24.0 mm</div>
<div>Exif.CanonSi.ISOSpeed Short 1 3200</div>
<div>Exif.CanonSi.MeasuredEV Short 1 2051.88</div>
<div>Exif.CanonSi.TargetAperture Short 1 F2.8</div>
<div>Exif.CanonSi.TargetShutterSpeed Short 1 1/64 s</div>
<div>Exif.CanonSi.WhiteBalance Short 1 Auto</div>
<div>Exif.CanonSi.Sequence Short 1 0</div>
<div>Exif.CanonSi.AFPointUsed Short 1 0 focus points; none used</div>
<div>Exif.CanonSi.FlashBias Short 1 0 EV</div>
<div>Exif.CanonSi.SubjectDistance Short 1 0</div>
<div>Exif.CanonSi.ApertureValue Short 1 F2.8</div>
<div>Exif.CanonSi.ShutterSpeedValue Short 1 1/59 s</div>
<div>Exif.CanonSi.MeasuredEV2 Short 1 4.00</div>
<div>Exif.Canon.ImageType Ascii 21 Canon EOS 5D Mark II</div>
<div>Exif.Canon.FirmwareVersion Ascii 24 Firmware Version 2.0.4</div>
<div>Exif.Canon.OwnerName Ascii 32 </div>
<div>...and it goes on for another one or two pages...</div>
<div></div>
</div>

So an analysis of which focal lengths are used how often is quite easy:


$ exiv2 -g Exif.Photo.FocalLength *CR2 | cut -b 82- | uniq | sort -n | uniq -c


4 24.0 mm


1 27.0 mm


1 28.0 mm


1 34.0 mm


3 35.0 mm


1 45.0 mm


1 48.0 mm


6 50.0 mm


8 70.0 mm


1 85.0 mm


1 97.0 mm


1 127.0 mm


1 135.0 mm


1 173.0 mm


7 200.0 mm
<div></div>

Perhaps this is more useful:


&gt; exiv2 -g Exif.Photo.FocalLength -g Exif.Canon.LensModel *CR2 | cut -b 83- | streplace -x " mm\\n= mm " - | uniq | sort -n | uniq -c


4 24.0 mm EF24-70mm f/2.8L USM


1 27.0 mm EF24-70mm f/2.8L USM


1 28.0 mm EF24-70mm f/2.8L USM


1 34.0 mm EF24-70mm f/2.8L USM


3 35.0 mm EF24-70mm f/2.8L USM


1 45.0 mm EF24-70mm f/2.8L USM


1 48.0 mm EF24-70mm f/2.8L USM


4 50.0 mm EF24-70mm f/2.8L USM


2 50.0 mm EF50mm f/1.8 II


5 70.0 mm EF24-70mm f/2.8L USM


3 70.0 mm EF70-200mm f/4L IS USM


1 85.0 mm EF85mm f/1.8 USM


1 97.0 mm EF70-200mm f/4L IS USM


1 127.0 mm EF70-200mm f/4L IS USM


1 135.0 mm EF70-200mm f/4L IS USM


1 173.0 mm EF70-200mm f/4L IS USM


7 200.0 mm EF70-200mm f/4L IS USM

PS: This was on a Mac, will work equally on Linux, but don

Oops, the first invocation to "uniq" is of course one to many, only the finaly uniq -c must stay.

Since I use Lightroom 3 anyways, I use Lightroom to read out the EXIF. It looks like this:


http://www.actieinbeeld.nl/tdp/exif-stats.jpg


And you can adjust it by your own wanted specifications.


Good luck,


Jan