Creating a map with live sensors on it

Grafana
,
1

Hello,

My company has several Libelium sensors around the country that send data through LoRaWAN and 4G. How can I create a map of the country where I can see all the sensors and their data if I hover my mouse over them? What plug-ins should I use?

I am using the cloud-based Grafana and have next to no experience.

Thank you!

2

Welcome

You can use Geomap plugin

3

Hello, thank you! But how can I display the sensors on the map? I cannot find anything on the internet.

4

Could you please provide sample data? As csv, json minus sensitive data?

Here we go. Downloaded lots of USA cities from US Cities Database | Simplemaps.com

Uploaded them to sql server. added a readingdatetime datetime column and populated it with random dates so grafana does not complain about missing time column.
Use GeoMap plugin, for Data Layer config I used Marker
Here is the query with census data as sensors data (get it census / sensors :joy: )

SELECT
  lat, lng,
  city as 'Sensor Name'
FROM
  sensors
WHERE
  $__timeFilter(readingdatetime)
  and state_name = 'California'
ORDER BY
  readingdatetime ASC

image