Visualize GPS coordinates in Map

Grafana InfluxDB
, ,
1

Good morning,

I’m quite new in Grafana. I’m using Grafana (v8.4.6) together with an influxdb, which is feeded from Openhab3. I want to visualize the following GPS coordinates (which are yet still all the same) in a map:

image
image1807×484 42.1 KB

I was already playing around a bit with the Geomap visualization, but unfortunately I do not manage. This is how I set the data layer section:

image
image1663×1578 82.8 KB

Maybe one of you could guide me into the the right direction - mayn thanks!

Matthias

2

Have you checked out this sample dashboard?

let me ask around and see if we have any more samples…

https://play.grafana.org/d/f6aHs_0nz/new-dashboard-geomap?orgId=1

3

Hi @matthias007 , just stumbled over your question as I tried to solve the same problem. Finally I found the following solution.

Grafana needs the fields “lat” and “lon” in the result to use them as geodata. With influxdb version 2 and flux queries, the solution is then to add a mapping to the flux query. This works for me:

import "strings"

from(bucket: "openhab/autogen")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Flash_Location")
  |> map(fn: (r) => ({r with lat: float(v: strings.split(v: r._value, t:",")[0]) , lon: float(v: strings.split(v: r._value, t:",")[1]) }))
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: true)
  |> fill(usePrevious: true)

Check out whether it works for you also.

4

Wondering why you are doing the mapping and aggregation? Does the lon, lat data have something that needs to be cleaned up and converted to float?