sdr-enthusiasts/docker-readsb-protobuf

Map Overview in grafana dashboard

RyanPostema opened this issue · 1 comments

Hi!

First of all thank you work on this!
However i found i was missing something in the grafana dashboard itself, so i decided to make it myself and share it with you trough an issue.

This is what i made:
a geo map that queries the database for the following aircraft data:

  • lat
  • long
  • Alt ( extra value when icon on map is clicked, icon scales depending on this value)
  • Spd ( extra value when icon on map is clicked)
  • Trak ( used for heading, geomap rotates the icon depending on this value)

ordered by ICAO and CALL
image

when the icon is clicked:

image

i hope this is something you can use to upgrade/update your dashboard to rev5!

below is the json output of the panel::

{ "id": 35, "gridPos": { "h": 32, "w": 15, "x": 0, "y": 5 }, "type": "geomap", "title": "Currently Tracked Aircraft map", "datasource": { "type": "influxdb", "uid": "" }, "pluginVersion": "9.2.3", "timeFrom": "1m", "hideTimeOverride": true, "description": "A map with the position data of aircraft in the last minute", "fieldConfig": { "defaults": { "custom": { "hideFrom": { "tooltip": false, "viz": false, "legend": false } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "color": { "mode": "thresholds" } }, "overrides": [] }, "options": { "view": { "id": "fit", "lat": 46, "lon": 14, "zoom": 15, "allLayers": true, "lastOnly": false, "layer": "Layer 1" }, "controls": { "showZoom": true, "mouseWheelZoom": true, "showAttribution": true, "showScale": true, "showMeasure": true, "showDebug": false }, "tooltip": { "mode": "details" }, "basemap": { "config": {}, "name": "Layer 0", "type": "osm-standard" }, "layers": [ { "config": { "showLegend": true, "style": { "color": { "fixed": "#000000" }, "opacity": 1, "rotation": { "field": "Heading", "fixed": 0, "max": 360, "min": -360, "mode": "mod" }, "size": { "field": "Altitude", "fixed": 5, "max": 15, "min": 10 }, "symbol": { "fixed": "img/icons/marker/plane.svg", "mode": "fixed" }, "text": { "field": "Call", "fixed": "", "mode": "field" }, "textConfig": { "fontSize": 12, "offsetX": 0, "offsetY": 30, "textAlign": "center", "textBaseline": "middle" } } }, "location": { "latitude": "aircraft.Lat", "longitude": "aircraft.Long", "mode": "auto" }, "name": "Aircraft", "tooltip": true, "type": "markers" } ] }, "targets": [ { "datasource": { "type": "influxdb", "uid": "IfTatmoVz" }, "groupBy": [ { "params": [ "Icao" ], "type": "tag" }, { "params": [ "Call" ], "type": "tag" } ], "measurement": "aircraft", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "Lat" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Latitude" ], "type": "alias" } ], [ { "params": [ "Long" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Longitude" ], "type": "alias" } ], [ { "params": [ "Alt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Altitude" ], "type": "alias" } ], [ { "params": [ "Spd" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Speed" ], "type": "alias" } ], [ { "params": [ "Trak" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Heading" ], "type": "alias" } ] ], "tags": [ { "key": "Call", "operator": "!=", "value": "" } ] } ] }

Thanks for the info... I've got an updated dashboard in the works and have added this panel to it...

image