Use Grafana to visualize geospatial data stored in Timescale

In your Grafana dashboard, create a new panel, select New Visualization, and select Worldmap Panel.

Navigate to the Queries tab.

Select your data source.

In the Format as dropdown, select Table. Click Edit SQL and enter the query you want to use. This examples uses this query:

SELECT time_bucket('5m', rides.pickup_datetime) AS time,
       rides.trip_distance AS value,
       rides.pickup_latitude AS latitude,
       rides.pickup_longitude AS longitude
FROM rides
WHERE $__timeFilter(rides.pickup_datetime) AND
  ST_Distance(pickup_geom,
              ST_Transform(ST_SetSRID(ST_MakePoint(-73.9851,40.7589),4326),2163)
  ) < 2000
GROUP BY time,
         rides.trip_distance,
         rides.pickup_latitude,
         rides.pickup_longitude
ORDER BY time
LIMIT 500;

Copy

Configure the visualization by navigating to the Visualization tab. Make sure the Map Data Options are set to table and current.

In the Field Mappings section, set the Table Query Format to Table.

Map the Latitude Field to the latitude variable, the Longitude Field to the longitude variable, and the Metric field to the value variable.

In the Map Visual Options section, set the Min Circle Size to 1, and the Max Circle Size to 5.

In the Threshold Options section, set the Thresholds to 2,5,10. This automatically configures a set of colors, which you can adjust later.