Geomap - longitude/ latitude set manually

Grafana Geomap Panel
1

Hello,

I have grafana and geomap setup, but I have problem, that in my Datasource (influxdb) are NOT any data with longitude/latitude.

So my question is - is it possible to put location long/lat manually ? And where ?

I use influxdb and my query is

from(bucket: “SData”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “SPoints”)
|> filter(fn: (r) => r[“location”] == “ID28405”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
|> yield(name: “mean”)

Thank you for any advice

Frank

2

Is the geodata in another database? In a csv file?

3

No, there are not geodata in another database.

But I can make CSV file and put into CSV file manualy.

Could you, please, write any “Step by step” instruction ? Where should I CSV file save ? How can I pair location data from CSV file and query from Influxdb ?

Thank you, for any advice

Frank

4

I could but even better, here is the docu for how to do it. Read the docu, try it and when you are stuck post back here with your questions. Try yhis query of csv in influx query explorer itself first