Orchestra Cities dont plot data on maps

Hello everyone,

I am using Grafana 10.2.3 Orchestra Cities Map and it drives me crazy. Because i dont get the position shown on the map.

this is my insert
data = "loco,uic=111111111ups_load_voltage="+str(load_voltage)+",ups_current="+str(current)+",ups_power="+str(power)+",ups_percent="+str(percent)+",ups_hs="+str(hs)

and the data of the insert look like that
car,uic=11111111 gps_hdop=0.8,gps_height=458.1,gps_latitude=40.4665013,gps_longitude=13.513669566666668,gps_quality=1i,gps_satellites=6i,gps_speed=0

so this all works for me.

my request in grafana looks like this

from(bucket: "bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "loco")
  |> filter(fn: (r) => r["uic"] == "11111111 ")
  |> filter(fn: (r) => r["_field"] == "gps_latitude" or r["_field"] == "gps_longitude" or r["_field"] == "gps_speed")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

And again everything is fine i am getting the data like i wrote upstairs

So this is the config i did in the plugin everything fine as well i think

The only thing what I cant explain and what makes me suspicious is that i can choose 3 times the

So on this problem now for 3 days. Any ideas?

Same issue here. I think, after hours searching, that the data that I get from the API, changes and add a new json which contains “refId:undefined”


field which I suppose that is needed for selecting the correct series in “query” field which is filled with 2 fields but with no name (is very difficult to see but the drop-down control contains 2 null items if you have 2 series), so despite I have 2 queries available in datatable view, I don’t have this option in “query” field, so, finally the first query is used by all the layers

you need to pivot the data.

something like this but change according to your data

  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")  
  |> drop(columns: ["_start", "_stop", "_measurement", "type"])