Geo coordinates generation
What is Geo Coordinates?
A Geo coordinates system is a coordinate system that enables every location on Earth to be specified by a set of numbers, letters or symbols.
Why Geo Coordinates need to be generated?
Geo coordinates contains latitude and longitude. Google Maps require Geo coordinates to plot the map.
If your Google sheet records have address fields, but there is no Geo coordinates for those records, Google Map cannot directly plot your records on the map. So, Map my sheet will generate Geo coordinates before plotting your data on Google Map.
How to Manage Geo Coordinates Generation
Geo coordinates generation need to be managed well to present Google Sheet data on the Google Map.
Is it a big deal to generate Geo coordinates?
Not really, but you need to be cautious of the following
- Google Maps has a quota limitation of per second and per day access to the Geo Coordinates generation API
- Also, there is execution time limitation.
We need to manage these well to work with Google Maps platform smoothly
While generating Geo Coordinates you may get following problems,
- Exceeded Execution Time.
- Service invoked too many times for one day: Geo code.
Don't worry, every problem has solution.
Problem 1 : Exceeded Execution Time.
Solution : Just click save button and and you will get a popup with actual information about total records and out of that how many records has Geo coordinates, then click generate again.
Problem 2 : Service invoked too many times for one day: Geo code.
It has 2 solution.
- You have to wait for one day.
- Use another account to generate Geo coordinates.
If you use another account you have to give Google sheet access to that new account and generate Geo coordinates. After that go back to your initial account and view your map.