Track Map - Grafana Panel Plugin

A map plugin to visualise coordinates as markers, hexbin, ant path, or heatmap.

Earlier versions

This is a new version of the Track Map plugin - now built with React, which works with Grafana 7+.

Note that this plugin is not backwards compatible with the old Grafana 6 versions.

For Grafana 6 and older, please use our 1.x branch instead.

How to use

Query

The query in Grafana can be formatted as Table or Time series and contain the fields latitude and longitude or just lat and lon. To add intensity to the heatmap (instead of using only coordinates), the intensity field should be added.

To add a text popup to the markers, a popup, text or desc field should be added. If no popup field exists, latitude and longitude are displayed in the popup.

To add a mouseover tooltip to the markers, add a tooltip field. The tooltips can be shown permanently by toggling the Always show tooltips option (may require map reload).

Data query example (TimescaleDB with PostGIS):

SELECT
avg("lat") as "latitude",  
avg("long") as "longitude",  
max(abs("rssi")) as "intensity",
max("rssi") as "tooltip",
clusters
FROM (SELECT lat,
long,
geo,
rssi,
ST_ClusterKMeans(geo, 100) over() as clusters
FROM table_name) table_name_clustered
GROUP BY clusters
ORDER BY clusters;

Configuration

The panel has general configuration options as well as options specific to each visualisation type.

Map center and zoom can be changed with the Map center latitude, Map center longitude and Zoom properties.

Centering the map on the first/last position or zooming to fit all data within the map bounds on load can be achieved by using the Map center to first position, Map center to last position and Zoom map to fit data bounds switches.

To update query variables when the map bounds are updated turn on Use map bounds in query. See section "Updating query based on map bounds" below.

Switch between views (Markers, Ant Path, Ant Path With Markers, Hexbin, Heatmap) by selecting a Visualisation type .

Note that some options are disabled when others are enabled - e.g. you cannot set a specific zoom level and also zoom the map to fit all data at the same time.

Markers

Size: The size of the markers
Size of last marker: The size of the last marker
Show only last marker: Shows only last marker
Use secondary icon for last marker: Uses secondary icon image for last marker
Use secondary icon for all markers: Uses secondary icon image for all markers
Always show tooltips: Always show the mouseover tooltips

Ant Path

Delay: The delay of the animation
Weight: The width of the path
Color: The color of the path
Pulse color: The color of the pulse running along the path
Paused: Pause/start the animation
Reverse: Reverse the animation direction

Ant Path With Markers

Delay: The delay of the animation
Weight: The width of the path
Color: The color of the path
Pulse color: The color of the pulse running along the path
Paused: Pause/start the animation
Reverse: Reverse the animation direction
Show only last marker: Shows only last marker
Use secondary icon for last marker: Uses secondary icon image for last marker
Use secondary icon for all markers: Uses secondary icon image for all markers
Always show tooltips: Always show the mouseover tooltips

Hexbin

Opacity: The opacity of the hexagons
Color range from (hex): Color ranges from this value
Color range to (hex): Color ranges to this value
Radius range from: Min radius
Radius range to: Max radius

Heatmap

Fit bounds on load: Fit the heatmap inside the map bounds on load
Fit bounds on update: Fit the heatmap inside the map bounds on update

Changing marker icons

To change the icons used for the markers, replace the marker.png and marker_secondary.png files in the /src/img folder.

Updating query based on map bounds

To update the query dynamically based on the map bounds turn on Use map bounds in query. To use this you must manually add four variables to the dashboard (via settings in the top right corner). Add four variables of type constant with names minLat, minLon, maxLat, and maxLon. The values can be anything, e.g. 1, 2, 3, 4 - they will be overwritten by the plugin. Remember to save the dashboard. The variables can then be used in a query. Here is an example that limits the query to the bounds of the map:

SELECT
  avg("lat") as "latitude",
  avg("long") as "longitude",
  max(abs("rssi")) as "intensity",
  max("rssi") as "tooltip",
FROM (
  SELECT sys_time, lat, long, geo, rssi, ST_ClusterKMeans(geo, 15) over() as clusters from table_name
  Where lat >= $minLat
    AND lat <= $maxLat
    AND long >= $minLon
    AND long <= $maxLon
) table_name_clustered
GROUP BY clusters

Installation

If you are running Grafana locally, you can clone or download the repository directly into the plugin directory, reset the Grafana server, and the plugin should get detected automatically.

If you are using Docker, a guide can be found here.

For more information on Grafana plugins look here.

Development

To compile the plugin you need either npm (default) or yarn.

1. Install dependencies

npm install

2. Build plugin in development mode

npm run-script dev

or run in watch mode

npm run-script watch

3. Build plugin in production mode

npm run-script build

snetcher/alexandra-trackmap-panel