Bug 151233

Summary: MAINTENANCE : add advanced statistics for all images for each albums
Product: [Applications] digikam Reporter: Christian Mayer <bug>
Component: Maintenance-DatabaseAssignee: Digikam Developers <digikam-bugs-null>
Status: CONFIRMED ---    
Severity: wishlist CC: aevseev, caulier.gilles, Julien, piotr270977, tpr
Priority: NOR    
Version: 0.9.2   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Christian Mayer 2007-10-23 14:02:47 UTC
Version:           0.9.2-final (using KDE KDE 3.5.8)
Installed from:    Ubuntu Packages

I'd like to be able to show statistics about all images in an selected folder (with the ability to select multiple folders at the same time...)

Especially I'm interested about:
- how is the distribution of focal lengths (directly and converted to a normal cameral w/o crop)
  => should I buy a wide angle or an tele next...
- how it the distribution of used aperture
  => can I get the f/4 or do I need an f/2.8 lens next...

There are tools that give me that information through the command line, but integrated in digikam would be great (and doesn't the new database scheme support exactly such an query?)
Comment 1 caulier.gilles 2007-10-23 14:11:55 UTC
Christian,

The new database format used with new 0.10.0 release (KDE4) will store these values.

http://websvn.kde.org/trunk/extragear/graphics/digikam/DBSCHEMA.ODS?view=log

Gilles Caulier
Comment 2 Christian Mayer 2007-10-23 14:45:01 UTC
Gilles,

then I did guess correctly.

So I only want an "histogram" of the information in ImageMetadata for all pictures in the selected folder(s).
Comment 3 Arnd Baecker 2007-10-23 15:02:25 UTC
Doing a good histogram for this is non-trivial: 
According to my experience with a home-brew solution, 
the bin-width to be chosen very much depends on the number of entries.
Moreover, it can become very spiked. And a separation according
to lenses would be helpful as well.

Also: where should one put such a statistical information?
Maybe another side-bar could carry the needed plots,
together with a selection of all lenses or specific lenses.

Comment 4 Christian Mayer 2007-10-23 16:00:32 UTC
> According to my experience with a home-brew solution,
> the bin-width to be chosen very much depends on the number of entries.

Yes, that's not that easy. If there's no easy way to determine the width (I'd *try* e.g. (max-min)/10 or 20...) it could be made setable.

A custom query could help here. How many pictures have a focal length > 100mm?

> Moreover, it can become very spiked. 

Why not? I'm interested in the values and not in an "pretty" histogram...

> And a separation according to lenses would be helpful as well. 

As an option/filter: yes.
But *I* am mainly interested in all pictures at once (as I want to decide which type of lens I should buy next)

> Also: where should one put such a statistical information? 

I was thinking of a right click context menu (e.g. named "Statistics") - but an side bar also would be fine. 
Comment 5 Theresa 2008-04-09 18:30:34 UTC
Having read this conversation at flickr
http://www.flickr.com/groups/olympus_e500/discuss/72157594427198068

I thought it would be pretty useful and a nice feature to digikam!

So, here comes my vote for this "bug" errrr wish ;)
Comment 6 Simon Oosthoek 2008-06-21 17:59:16 UTC
I saw this link: http://www.cpr.demon.nl/prog_plotf.html
posted on http://forums.dpreview.com/forums/read.asp?forum=1037&message=27818592

I thought it would be a nifty feature for digikam, and apparently I'm not alone ;-)

/Simon
Comment 7 Simon Oosthoek 2008-06-21 17:59:37 UTC
*** This bug has been confirmed by popular vote. ***
Comment 8 Julien Narboux 2009-01-11 12:51:26 UTC
I think this wish would be a nice addition.
But I think that first this wish
http://bugs.kde.org/show_bug.cgi?id=180322
should be solved, because for the statistics, the proper 35mm equivalent focal length is needed.

Here is an example of what it could look like :

http://flickr.com/photos/dartar/2108504971/in/set-310890/

Here is an utility to do that on your flickr pictures: 
http://stats.ghusse.com/

Julien
Comment 9 Christian Mayer 2013-10-07 16:53:51 UTC
Now I have the same question / task as 6 years ago - and the new DB should be working...

What's the status here?
Comment 10 caulier.gilles 2013-12-06 22:53:19 UTC
*** Bug 286778 has been marked as a duplicate of this bug. ***
Comment 11 Teemu Rytilahti 2013-12-07 23:54:31 UTC
This would be such a nice addition, but think the status is that the information is available in the database, but there's no one working on it.

About what was mentioned in comment #8, it looks like digikam shows the 35mm equivalent focal length in the UI, but it is not stored in the database?
Comment 12 caulier.gilles 2014-02-24 13:20:22 UTC
*** Bug 331457 has been marked as a duplicate of this bug. ***
Comment 13 Justin Zobel 2021-03-09 05:51:39 UTC
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.