[Part 2] Geocode addresses – Documentation - Awesome Table Support

In the previous tutorial, you learned how to install GeoCode. Here, you'll learn how to use the GeoCode add-on to transform postal addresses into coordinates.

info To immerse yourself in this tutorial, we recommend using this sample data in the following walk-through exercises.

1 - Initialize the GeoCode add-on wizard.

To start using GeoCode, open an existing Google Sheets with postal addresses in it. Once you're on the pertinent sheet (tab), select Add-ons > Geocode by Awesome Table > Start Geocoding.

Image A

info Depending on your use-case, you're not restricted to using just the complete postal address for GeoCode to work. You can even enter partial addresses using any of these combinations: city and state, city or state and country or just the country.

2 - Configure the address field.

If the complete address is stored in just 1 column, choose the appropriate column name from the dropdown menu under Address column (image B). Otherwise, click Are your addresses in multiple columns? (image C).

Image B

Image C

The Multiple Columns window shows the column names on the left and checkboxes on the right. You simply need to check the boxes where your separate address fields are stored (image D). Then click the Insert column button.

Image D

This will create a new column labeled Full Address right next to the country column - containing the concatenated values of the address fields you checked earlier (image E).

Image E

info Google Maps API has a built-in error management system. If addresses are not recognized, it will perform a broader search, guaranteeing you get the proper coordinates for each row.

* Note: Make sure that the Try wider results checkbox is checked.

3 - Start Geocoding.

Now click the Geocode! button (image F) to transform your addresses into coordinates.

Image F

not_interested Do not terminate or close the sidebar while GeoCode is running.

After the script executes, two new columns will be added immediately after the Address column: Latitude and Longitude (image G) .

Image G

info If you prefer not to have the longitude and latitude columns inserted between your datasource (to avoid altering your current column-order), simply place the address column(s) at the end of the datasource.

warning Information about the number of geocoded addresses is displayed in the sidebar (image G).

4 - Create your interactive Map with just 1 click.

Finally, click the Create Map button (image H).

Image H

The script will 1) insert a new row on your datasource that will be reserved for filters and keywords (image I) and 2) automatically generate your AwesomeTable view using the Map visualization type.

Image I

info The GeoCode script applies the appropriate filter based on the data-type of each column (i.e., numeric, string, or date). You can opt to accept the suggested filters, modify, or remove them.

Learn more about filters here.

warning The GeoCode add-on offers a pre-configured AwesomeTable Map-view allowing you to quickly sort, filter, and find the locations you need. If you click on a specific row in the table-view, the map-view will dynamically focus the corresponding marker-location linked to the pertinent row.

Geocoding phase: Complete.

You're now presented with the option to: Customize the Tooltip (which we'll tackle next) or Open the Map view (image J). For now, choose Open map to see the default view.

Image J

When you click on any marker, you'll be presented with a plain-vanilla tooltip displaying the city & country (image K). You can choose to accept this default or you could further customize your Tooltip to enhance it.

Image K

warning The generated map-view displays Markers (a single location on a map that resembles a red balloon, a.k.a. Map Pin, Drop Pin, or Push Pin) corresponding to each coordinate in your Google Sheets datasource.

info If there are too many markers in a single location, the GeoCode script performs automatic clustering to improve the map view (image L).

Image L

navigate_nextNext article :

In this tutorial, you learned how to use the GeoCode add-on to transform your addresses into coordinates. In the next tutorial, you'll learn how to Customize the Tooltip.

Comments

8 comments

Ding He April 26, 2018 08:59

Hi team,

Is there a way to customize the pin image shown on the map?

Thanks!

0

Awesome Table April 26, 2018 15:18

Hi Ding He,

Sure! It is possible to customize your pin image using:

- the ColorType keyword to change the color of your pin
- the MapsMarker keyword to display an image

You can consult this article to know what are our available keywords with a map view.

Kind regards,
Thomas

0

Diego Sorgato June 22, 2018 10:10

Hi, it's possibile create polygon in the same maps withs pins?

0

Awesome Table June 22, 2018 10:27

Hello Diego,

It is not possible to use polygon with pins in a Awesome Table map view.

Kind regards,
Thomas

0

Nahdi Lazar September 19, 2018 12:36

Bug report - I'm using the GeoCode plugin on a Hebrew database. When it encountered an address with two aposrophes in the street name (המלך ג'ורג' 44, ירושלים, ישראל), the script stopped, saying "ScriptError: Action not allowed". It didn't happen in addresses with one apostrophe in the city name (דגניה ב', ישראל).

Problem was solved when I removed all apostrophes from the addresses (which is wrong, but Google maps can handle it).

Also, would be nice to have an option to manually stop the plugin.

0

Awesome Table September 24, 2018 08:34

Hello Nahdi Lazar,

This problem is related to Google Maps. I suggest to not use apostrophes in your address and, as you said, it doesn't affect your view.

Kind regards,
Thomas

0

Henri Dubuisson September 28, 2018 19:06

Hello

Is it possible to disable the automatic clustering ?

Thx,

Henri

0

Awesome Table October 03, 2018 14:03

Hello Henri Dubuisson,

Indeed it is possible to desactivate the automatic clustering (see the screenshot below).

Kind regards,
Thomas

1