Hi Irmage,

can you verify that the coordinates are properly read from exit when uploading/synching pictures? I have the issues that latitude and longitude aren't set correctly in PiWigo (proabably due to shortcomings in the php library used to read exif data) and pictures don#t show up on the openstreetmap (see discussion in http://piwigo.org/forum/viewtopic.php?id=25997).

Once I overwrite the exit data directly in the database things work correctly. But a bit slow with approx. 8000 pictures with coordinates...

HTH,
Thomas

Thank you very much for supporting in this issue, as I got stuck on my own..

TheDoc wrote:

can you verify that the coordinates are properly read from exit when uploading/synching pictures?

Hm. At the moment I can only state, that the OSM icon (globe) is missing, when I view those pictures in Piwigo. What do I have to do to verify this?

The coordinates are stored in the meta data in the images as mentioned above. I have re-downloaded some images from Piwigo to verify that GPS datas are truly there and so they are.

TheDoc wrote:

I have the issues that latitude and longitude aren't set correctly in PiWigo (proabably due to shortcomings in the php library used to read exif data) and pictures don#t show up on the openstreetmap (see discussion in http://piwigo.org/forum/viewtopic.php?id=25997).

Sorry, I do not fully understand how this solved the problem :-/
You also show a link to the source code, but I am not that familiar with coding to use this information :-//

TheDoc wrote:

Once I overwrite the exit data directly in the database things work correctly. But a bit slow with approx. 8000 pictures with coordinates...

How exactly did you overwrite the exif data in the database?

flop25 wrote:

How do you upload? Do you have something in your local config?

To upload I used ftp transfer to /gallerie and then syncing files and folders including meta datas.
I also used the upload function of Shotwell, also including meta datas

By the way: Keywords (tags) from exif data are only shown, if uploaded by Shotwell (but still no GPS datas). Upload by ftp transfer (including sycing) does not show any of those tags.

Only little information is shown (ftp and shottwell connect):

Exif-Metadaten
Make
    SAMSUNG TECHWIN CO., LTD.
Model
    Samsung S85
DateTimeOriginal
    2015:08:23 14:26:10
ApertureFNumber
    f/4.9

flop25 wrote:

Do you have something in your local config?

What do you mean with local config?

Thanks for guiding me further through this issue :-)

regards

Irmage

----------------
BTW: As the space of the / partition is limited due to a 16 GB microSD card, I shifted all big datas of Piwigo to the external drive mounted at /media/pi/core/piwigo.
http://piwigo.org/forum/viewtopic.php?id=26033

TheDoc wrote:

The plugin doesn't use the data from the exif. Instead in the piwigo database there are fields latitude and longitude for each image that are used.

OK, I understand

TheDoc wrote:

In my case the php exif parser fails and therefore the data in the piwigo database (not the exif of the pictures!) is wrong. As a result the pictures don't show up in the map.

Could be the same with me

TheDoc wrote:

I do that via a SQL script that sets the fields latitude and longitude in the database to the correct values

I have no clue with SQL scripting - would you let me use your script? This would be a great favour :-))

TheDoc wrote:

Have you tried looking at the exif info for a picture in your gallery?

Yes, but there is very little information shown (ref. my posting above), there is much more meta data in the picture. Information looks correct.

Do you know, if there is a bug report filed regarding the issues with exif parsing?
Its quite a drawback in usability :-(

Thanks for your great help so far

Irmage

---------------
PS: Now I also installed and activated Exif View 2.7.c and I resynced all files an folders including meta data.

Metadata synchronisation results

    26 photo information synchronised with file metadata
    26 candidate photos for metadata synchronisation
    Metadata used : filesize, width, height, date_creation, latitude, longitude

But still no GEO tags available.

Then I checked the database with phpMyAdmin.
In piwigo_images there are columns for latitude and longitude but they all contain NULL (except for those, I localized manually)

So my conclusion: It seems to be a synchronization issue

Last edited by Irmage (2015-11-07 17:53:24)

Hi, it seems I'm stuck with the same problem.

System: Debian GNU/Linux 9 (Stretch) with nginx, PHP 7.0 (php7.0-fpm), MariaDB;
current version of Piwigo (2.9.3 I guess, cannot find the version in the dashboard);
Plugins: OSM, Photo Update, (later) Exiftools GPS (and others that do not matter here);
Camera: Canon EOS 750D with gps receiver Canon GP-E2

I bought the gps receiver only a short time ago and used it the first time a few days ago for a series of around 120 photos. The gps data are in the exif data; exif (from exiftools) can „see“ them. The OSM plugin cannot. The files are in Piwigo's batch manager and additionally in an internal album I use for uploads.

What I already tried:

* installed Exiftools GPS (nothing happenend);
* updated one of the photos with the idea that the gps data might only get read in that process, but it did not help;
* tried to upload one of the photos again, but the photo_add got stuck for an unknown reason;
* tried synchronizing the meta data, but it said it processed 0 photos (dry mode and real mode).

What I found out: The problem could be the so called maker notes, a binary, proprietary data block of around 8kB in the exif data of each file. The description of the plugin Exiftools GPS explicitly mention those. I have no clue what happens if I try to remove them with the exiftools (and as I don't have experience with them, I even don't know how to accomplish that).

Example for the gps data in the exif data the gps receiver writes:

GPS Tag Version     |2.3.0.0
North or South Latit|N
Latitude            |51, 12.0512,  0
East or West Longitu|E
Longitude           | 6, 50.2843,  0
Altitude Reference  |Sea level
Altitude            |45.4
GPS Time (Atomic Clo|13:56:11.00
GPS Satellites      |12
GPS Receiver Status |A
GPS Measurement Mode|3
Measurement Precisio|2.3
Geodetic Survey Data|WGS-84
GPS Date            |2019:02:09

So, how am I supposed to get those data into Piwigo's database so that the OSM plugin can and will use them?