Hi experts,
I have a sensor that is used to measure the potential level of water on a (flooded) street.
I want to display the sensor’s position on a Grafana dashboard, using the map panel.
My problem is that sensor sends its GPS position only when it is moved. That’s comfortable, when the sensor is deployed, but once it sits somewhere for a year, two years, three years , … one has to look far back in the data to find the position information.
What would be the best way to handle such a situation?
- What would be the correct query (preferably in InfluxQL, if needed in Flux)?
- Do have to worry about the performance when I have to look through all available data for a GPS position? In worst case the position would be sent once when the sensor is installed an then never again for a long time.
I’m using InfluxDB v2.7.11 (OSS). The data from the sensor is written to the InfluxDB via telegraf and the MQTT input plugin.