Awesome Table: A new Google Maps view

Post date: Feb 14, 2015 12:57:58 AM

So we played with the Maps API, added a bit of live geocoding, even use extra libraries to do some clustering, mixing everything with the powerful filters available in Awesome Table and you can now enjoy a new, prettier and more powerful Maps view:

Highlighted features

• • no marker number limit (previously you weren't able to display more than 400 markers)

  • marker clustering

  • management of markers on the exact same spot

  • zoom with mouse wheel

Settings

As before, data values can be coordinates (lat-long pairs) or addresses:

• Latitude / longitude coordinates

• The two columns are designated by the labels : MapsLat, MapsLong

• Quick and safe, you should prefer this configuration.

• Postal addresses

• The column containing the addresses must be labeled : MapsAddress

• This setting imply the live geo-coding of all addresses fed to Awesome Table. It is much slower than using lat/long pair, and the addresses will not always give a match and will not be displayed on the map.

To add a tool-tip displaying useful informations above the markers, use the label : MapsTooltip on the right column.

Below you can see the header of a spreadsheet using Lat/long coordinates (columns H and I) and a tool-tip (column K) with a template. The keyword Hidden is added on each of these column because this spreadsheet is the source for the below demonstration of the dual table/map view and we don't want to display the coordinates in the table !

Dual view : Table + Maps

This new map view comes with the possibility to display both a table view and a map view, linked to the same filters. Very useful if you have a lot of info to display!

And a few more updates...

You may have noticed, the configuration view underwent some changes.

• • A new Open the Spreadsheet button in the Sheet tab was added.

• There is now a third column in the View tab, to reorder the elements displayed (filters, chart,...).

• When you choose to display both a map and a table, you can also reorder the two of them and the filters like you want.

• The Region setting, used for the Geochart Maps view has a drop-down helper to select the region displayed.