Extract coordinates from image

[Nicolas_Feldman]

Hi all,

Can AppSheet extract coordinates from an uploaded image with a form to autopopulate a LatLong column?

Thanks

[Steve]

Nope.

[LeventK]

Not directly. However there’s a REST API service that can return EXIF data from an image. You need to construct Google Apps Script, publish it as a webhook and use its URL as an webhook endpoint URL in an AppSheet workflow. You need to convert that convert that image to a base64encode and then pass it to the REST API service’s endpoint URL as a post body param. The JSON response from the API service will include all the EXIF information of that image including the lat long if it exists. Then you can record it to your gSheet back-end.

Cloudinary

API for Extracting Semantic Image Data - Colors, Faces, Exif Data, and More

Learn how to leverage Cloudinary's cloud-based API for applying effects on images to automatically blur faces using the pixelate effect

[Nicolas_Feldman]

Wow! Thanks @LeventK
I thought it was going to be something easier.
I think I can do it manually for the moment.
Will try that when I have more time…

[LeventK]

You’re welcome

[Carl_Fischer]

This is really clever, but part of me feels like it’s starting to get more complicated to use the no-code platform than it is to just write the solution in Python with lambdas.

[Fabian_Weller]

Hi @Nicolas_Feldman this is also possible by using the Google Cloud Vision API. I’m using it together with Integromat. You can up-vote here:

OCR detection with XY Coordinates Feature Requests

Using the Google Cloud Vision API and Integromat we are able to extract Text / Number from an image and add XY Pins automatically. You will get something like this without any manual work: [image] How it’s done: I would like to use this directly in AppSheet. Adding @tony @Grant_Stead @Bahbus @tsuji_koichi @Rich

[Fabian_Weller]

@LeventK thank you for the hint. Why do you prefer Cloudinary API?

[LeventK]

Hi @Fabian,
I’m using Cloudinary web services and its API may be for 2 years or more. They have a quality of service and offer various image and video editing, overlay options on the fly. The cons is their REST API coding is a bit confusing and though they have a very good API documentation, it’s not indexed well, therefore sometimes it’s not easy to find what you are looking for. And the prices are very good. They even offer a free service up-to a certain amount of uploading. Their support service is good and reliable as well. I’m quite happy with Cloudinary actually.

Besides; Google Vision API cannot extract EXIF data from an image. It can extract image properties only.
https://cloud.google.com/vision/docs/detecting-properties

[Fabian_Weller]

Thank you so much for those insights @LeventK.
Yes, Google Vision API is limited. But it’s for free

[LeventK]

Fabian:

Yes, Google Vision API is limited. But it’s for free

@Fabian
Google Vision API is free up-to a certain extent…Just like all other REST API services i.e. Cloudinary in this case…
https://cloud.google.com/vision/pricing

Cloudinary

Cloudinary - Pricing and Plans

Select a plan that best suits your needs. A Free plan with generous usage limits available without any time limit. Activate your account within seconds.

[LeventK]

Fabian:

Thank you so much for those insights @LeventK.
Yes, Google Vision API is limited. But it’s for free

And besides it does not provide the info what @Nicolas_Feldman is asking for

[Fabian_Weller]

LeventK:

And besides it does not provide the info what @Nicolas_Feldman is asking for

Maybe I didn’t understand the request.
Google Vision API gives you 4 coordinates of every symbol or word in an image. So that’s upper left, upper right, bottom left, bottom right. In this example it’s the word “Stand:”

And it also gives you the width and the hight of the image.

With those information you can calculate the XY for AppSheet:
(X / width * 100) , (Y / hight * 100)

For the pricing you are right. 1000 images / month are free. Actually I don’t reach this limit

[LeventK]

@Fabian
It might be a good thing when working with XY type columns and images however @Nicolas_Feldman was asking if it’s possible to retrieve the Lat Long (GPS Exif) value from the image uploaded to an AppSheet app.

[Fabian_Weller]

Oh man I was so confused Sorry…

[Nicolas_Feldman]

Thanks @Fabian and @LeventK for that masterclass.

I believe Fabian was talking about this post at the end:
XY coordinates generator for images

[Fabian_Weller]

Hi @Nicolas_Feldman you saved me
Yes I saw your name and connected it with XY