topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 11:00 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Google Photo: Query/s re related info  (Read 5624 times)

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Google Photo: Query/s re related info
« on: January 22, 2018, 05:04 PM »
One of my sisters wants to share family photos online, somewhere that others can also edit related descriptive text.
Google Photos seems perfect.
She has already added info to the 'Subject' field in the file -- this gets read by google and shown in the Info panel: ideal.

Once the related info has been edited, it differs from the info saved within the file (as said above: in 'Subject' field) i.e. the info is *not* added to the file metadata. Google offer no way of downloading this info --
Question:
does anyone here know a possible way to download the info related to the photo? -- just relating it to the filename would be fine. (The info panel also has filename & upload date -- see below.)

Note the 'Album' URL has a unique identifying number, so wondering might it be possible to strip the info somewhow for all pages/photos in the album?

Screenshot - 2018-01-22 , 23_07_49.pngGoogle Photo: Query/s re related info
Tom

4wd

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 5,641
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #1 on: January 22, 2018, 06:47 PM »
Don't know if it'll download any added photo info but you can try Google data download (Link - need to sign in).

You can export and download your data from the Google products you use, like your email, calendar, and photos.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #2 on: January 23, 2018, 04:56 AM »
Don't know if it'll download any added photo info but you can try Google data download (Link - need to sign in).

You can export and download your data from the Google products you use, like your email, calendar, and photos.

that did work!
(the info I had that it was un-downloadable was from 2016)

The info comes through as a .json file e.g.
Photo-name.jpg.json
Spoiler
Code: Text [Select]
  1. {
  2.   "title": "1936 xxxx.jpg",
  3.   "description": "1936 Jack and Neil, 1st and 2nd from left. Back of photo: \"xxxx - June 28-1936\". Additional info here please.",
  4.   "url": "https://lh3.googleusercontent.com/.../1936%2Bxxxx.jpg",
  5.   "imageViews": "0",
  6.   "creationTime": {
  7.     "timestamp": "1516701602",
  8.     "formatted": "23 Jan 2018, 10:00:02 UTC"
  9.   },
  10.   "modificationTime": {
  11.     "timestamp": "1516701796",
  12.     "formatted": "23 Jan 2018, 10:03:16 UTC"
  13.   },
  14.   "geoData": {
  15.     "latitude": 0.0,
  16.     "longitude": 0.0,
  17.     "altitude": 0.0,
  18.     "latitudeSpan": 0.0,
  19.     "longitudeSpan": 0.0
  20.   },
  21.   "geoDataExif": {
  22.     "latitude": 0.0,
  23.     "longitude": 0.0,
  24.     "altitude": 0.0,
  25.     "latitudeSpan": 0.0,
  26.     "longitudeSpan": 0.0
  27.   }
  28. }


Which leads to the next question:

is there any software that will show the photo and read the info in the json file simultaneously?
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #3 on: January 23, 2018, 06:45 AM »
is there any software that will show the photo and read the info in the [related] json file simultaneously?

haven't found anything in a quick search,
but I guess one could use two viewers, one for each file, and manually move to next file on each viewer.
Tom

ayryq

  • Supporting Member
  • Joined in 2009
  • **
  • Points: 101
  • Posts: 289
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #4 on: January 23, 2018, 11:14 AM »
ExifTool might do this automatically? I haven't tested it but see the following thread:
http://u88.n24.queen...dex.php?topic=8154.0

And get the executable from:
http://owl.phy.queen...u.ca/~phil/exiftool/

To clarify: What the command-line ExifTool will do is read the description from the json file(s), and write it to the metadata attached to the picture(s). Then you'll have to find another program that lets you view them together (though this should be easy).
« Last Edit: January 23, 2018, 11:25 AM by ayryq »

Deozaan

  • Charter Member
  • Joined in 2006
  • ***
  • Points: 1
  • Posts: 9,747
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #5 on: January 23, 2018, 12:19 PM »
is there any software that will show the photo and read the info in the json file simultaneously?

Does Picasa still sync with Google Photos?

ayryq

  • Supporting Member
  • Joined in 2009
  • **
  • Points: 101
  • Posts: 289
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #6 on: January 23, 2018, 04:49 PM »
Does Picasa still sync with Google Photos?

That's a good thought (and I don't know the answer), because the description typed into Picasa does wind up stored in the photo metadata. I don't know if Google Photos uses that metadata when uploaded; what I read indicates it might not (or maybe keywords do but descriptions don't).

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 7,540
  • @Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #7 on: January 23, 2018, 10:21 PM »
Prompted by this and some other related discussions, I have just posted: Google Picasa "Sunset" version - Mini-Review and anchor-point - which has some information and links to further information regarding the last released version of Google Picasa3 ("Sunset" version, as I call it) and switching/migrating to Google Photos.

There is quite a lot that probably needs to be said regarding Picasa3's extensive use of metadata, and that already has been said elsewhere on the DC Forum, so I shall try and pull it together under the "anchor-point" Picasa3 review.
It would be helpful if members with experience/information to contribute could independently add to that discussion thread as well as this one (simply cross-posting it would probably do the trick). Thanks.

Apologies. I could have done this ages ago, but did not get a round tuit.
Hope it all helps or is of use to someone, anyway.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #8 on: January 24, 2018, 03:38 AM »
Thanks for the tips people --

Does Picasa still sync with Google Photos?
That's a good thought (and I don't know the answer), because the description typed into Picasa does wind up stored in the photo metadata. I don't know if Google Photos uses that metadata when uploaded; what I read indicates it might not (or maybe keywords do but descriptions don't).

I dont know I/they want to sync with google photos, will have to see what that involves, whether it can be a limited sync etc.
Re the downloaded phot + json file:
unfortunately Picasa does not read nor find the json file.
unfortunately Picasa does not read nor find the json file.
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: Google Photo: Query/s re related info
« Reply #9 on: January 24, 2018, 03:47 AM »
ExifTool might do this automatically? I haven't tested it but see the following thread:
http://u88.n24.queen...dex.php?topic=8154.0

And get the executable from:
http://owl.phy.queen...u.ca/~phil/exiftool/

To clarify: What the command-line ExifTool will do is read the description from the json file(s), and write it to the metadata attached to the picture(s). Then you'll have to find another program that lets you view them together (though this should be easy).

for the long term, this would be the ideal solution :Thmbsup:
I dont know when I'll get time to try it (up to my eyeballs at the minute, or maybe my sister might give it a go).

Tom