[Qgis-developer] ​Geophoto management

[Albin Blaschka]

Hello!

I see the storing of pictures inside the database as problematic - due 
to the pure file size to be expected, especially if it also possible to 
store RAW-files: Just an example from my own work (ecological study):
In a project I have 16 plots studying the development of vegetation, 
working there for three years, just if I make 5 photos per year (which 
is almost nothing), we end up with 16 * 3 * 5 = 240 pics. I own an 
Olympus E1, so a relatively old camera with "just" 5 Megapixel, the 
RAW-file has 10.2 MB, so that would be around 2.5 GB of Data overall in 
this theoretical case. Small project, old camera, meaning relatively 
small resolution...
Even if we take just the jpg (for me and my camera, most of the time 
something between 0.5 - 1.2 MB) still around 200 MB... so specially for 
mobile devices or portability between devices not ideal I'd say... Maybe 
storing just a thumbnail and defining a root-directory were the pictures 
are would be an option?

I hope, not being a developer, my thoughts are not taken as an offense! 
The features discussed are great and I would be very pleased if they are 
implemented, but storing big binary data in a database could be 
problematic, as I said...

Thank you all for your efforts!
Greetings,
Albin


Am 04.07.2016 01:34 PM, schrieb Matthias Kuhn:
> Hi Mark
> 
> On 07/04/2016 12:35 PM, Mark Johnson wrote:
>> ​Work is being done in this area, intended to be an extension of the
>> RasterLite2 library (of the spatialite project), which will hopefully
>> come out this year.
>> 
>> The Raster-support in RasterLite2 supports Georeferenced images called
>> Raster-Coverage's.
>> 
>> The idea would be to add support for Geotaged images in the form of an
>> 'Album'
>> - one Album containing images
>> - each Album could belong to another Album
> 
> Will it easily be possible to extract such a photo from the spatialite 
> file?
> 
> Thinking about QField (mobile application), I like the in-database
> approach for its portability but fear that the photos will be locked in
> there and that it will be quite hard to use them for a report written 
> in
> an application that does not support RasterLite2.
> 
> Matthias
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
| Dr.rer.nat. Albin Blaschka
| Etrichstrasse 26, A-5020 Salzburg
| * www.standortsanalyse.net *
| * www.researchgate.net/profile/Albin_Blaschka *
| - It's hard to live in the mountains, hard but not hopeless!