Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

How to get the 'place name' based on Location data?

  • 20 August 2018
  • 3 replies
  • 626 views
N

Hello,


I have only the location data (Latitude and Longitude). Using that information I would like to calculate the name of the location dynamically. Any suggestions on how to do that ?


Thanks!

3 replies

romain.ducarrouge
Rank
Userlevel 3
Badge

Hey @nathan1 that is an interesting use case!

We have an article on achieving the similar process, just the other way around where we extract the value to a Google Sheet, then call the Google Map API to get the values we want, and then with BigQuery read the output directly into Looker:



In your use case you would want to use Reverse Geocoding list showed here: https://developers.google.com/maps/documentation/javascript/examples/geocoding-reverse

I hope this helps!

N

thanks @romain.ducarrouge this helps.

Lucas_Abreu

Hey, Nathan1,


did u manage to accomplish what u were trying?

I’m somewhat newbie to programming and couldn’t quite understand what we could in order to achieve the place’s name based on Location data

Reply


Terms of Service