Google area map

[ 1 Overview ] [ 2 What data do I need for this widget? ] [ 3 Creating a Google area map ] [ 4 Working with Google area maps ] [ 5 Shortcut keys ] [ 6 Query example ]

Overview

This chart displays data as geolocated hexagons over a world map, where the Color field represents the value and the Radius represents the coverage area. This chart may be used, for example, to represent mobile antennas and their coverage.

What data do I need for this widget?

The option to create this map will be disabled unless your query contains at least three columns with numeric values or one with numeric and one with string. Furthermore, to show meaningful content on the map, two of those columns must correspond to longitude and latitude and your data must be grouped.

Creating a Google area map

Working with Google area maps

Hover over an area on the map to see at the bottom the value and position in the color range.

To change the visualization area you can perform the following actions:

Click the + button to zoom in.
Click the - button to zoom out.
Left-click and drag to pan the map to the desired area.
Double-click to zoom in.
Double-right-click to zoom out.
Click the button at the top right to toggle fullscreen mode.

Shortcut keys

You can hit the following keys to perform different visualization actions:

Shortcut keys	Description

Shortcut keys	Description
W / S	Changes to the next color gradient for temperature representation. This will change the color scale for another with a different base color and number of colors to represent the lowest/coldest and highest/warmest. When you get to the last available gradient, pressing the key will go back to the first. This might be useful when the values are very similar and belong to the same range so they would be represented in the same or very similar color. This way we might be overlooking the differences in the values because of the lack of contrast and changing the gradient could help so that the values would be represented differently.
z	Increases the opacity of the areas for easier visualization of the areas represented.
x	Decreases the opacity of the areas for easier visualization of the base map.
n	Reset configuration to revert the applied operations applied to normalize and visualize data on the map.
l	Applies a logarithmic operation to normalize the data, which will be reflected in the areas represented on the map. This might be useful when some values are too far from the general range so normalization is needed for a more cohesive representation.
a	Applies an arctangential operation to normalize the data, which will be reflected in the areas represented on the map. This might be useful when some values are too far from the general range so normalization is needed for a more cohesive representation.
m	Toggles markers visibility. This shows/hides the points in the center of the areas.
r	Toggles radius visibility. This shows/hides the areas' contour and fill to show only the points in the center.
p	Toggles polygons visibility.
i	Toggles intersection mode (inner). This shows only the coinciding parts of the areas that intersect.
o	Toggles intersection mode (outer). This hides the coinciding parts of the areas that intersect.
d	Changes the map style to adapt it to your visualization needs. You can choose from black or white backgrounds.
u	Toggles limit/unlimit. This limits the results shown in the displayed area showing only the most relevant to improve performance. You can check it at the bottom of the map window; Infinity means all results are shown while a number means it is limited to that number.
?	Shows/hides the list of shortcuts keys.

Query example

You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:

Query	Required field	Column added

Query	Required field	Column added
`from demo.ecommerce.data select mmlatitude(clientIpAddress) as latitude, mmlongitude(clientIpAddress) as longitude group every 5m by latitude, longitude, timeTaken, bytesTransferred, method every 5m`	Latitude	latitude
	Longitude	longitude
	Value/Color	bytesTransferred
	Path	method
	Radius	timeTaken