https://bugs.kde.org/show_bug.cgi?id=495985
Bug ID: 495985
Summary: Feature idea: Image metadata analytics
Classification: Applications
Product: digikam
Version: unspecified
Platform: Other
OS: Other
Status: REPORTED
Severity: wishlist
Priority: NOR
Component: Database-Schema
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
***
If you're not sure this is actually a bug, instead post about it at
https://discuss.kde.org
If you're reporting a crash, attach a backtrace with debug symbols; see
https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
Please remove this comment after reading and before submitting - thanks!
***
SUMMARY
Feature request. Not a bug
STEPS TO REPRODUCE
1. Not a bug
2.
3.
OBSERVED RESULT
EXPECTED RESULT
SOFTWARE/OS VERSIONS
Windows:
macOS:
(available in the Info Center app, or by running `kinfo` in a terminal window)
Linux/KDE Plasma:
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
One if the features I really like in Lightroom is the ability to look at counts
of images using information from my image metadata. It helps me understand my
favorite bodies, lenses, focal lengths, shutter speed, f/stop, ISO and other
camera settings. It would be nice to have a screen where the user could select
different metadata properties, and values or value ranges and then digiKam
could populate a grid with the number of images matching the parameters. For
example, I'm considering a new wide-angle lens. It would be nice to be able to
see how many images I already have in my library with a focal length of less
than 28mm. What aperture did I use for most of the images? What ISO? Does it
make sense to buy a faster wide-angle lens? Would I use it enough?
I know I can make SQL queries directly against the SQLite or MariaDB databases,
but most people don't have the tools or the knowledge to do so.
Here are a few of my favorite SQL queries. If we could create a UI in digiKam
so all users can see this information, I think it would be a great addition to
the program.
Helps me understand the focal lengths and lenses I use most:
SELECT make,model,lens,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY"
GROUP BY make,model,lens,focalLength
ORDER BY count(*) DESC;
Tells me my favorite lenses for my current body:
SELECT make,model,lens,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY" AND model="ILCE-7RM3A"
GROUP BY lens
ORDER BY count(*) DESC;
Tells me my favorite ISO settings for a given focal length:
SELECT make,model,lens,sensitivity,focalLength,count(*) FROM ImageMetadata
WHERE make="SONY" AND model="ILCE-7RM3A"
GROUP BY sensitivity
ORDER BY count(*) DESC;
--
You are receiving this mail because:
You are watching all bug changes.
