Hi, is there a way to link geojson files to queries? we need to represent statistical data for areas. Create a new geojson for every value or set of values is not viable, we have hundreds of maps and thousands of values. It could be very useful link table to geojson data with a key field.

Mapgl plugin can render Geojson from static files, urls, and datasource queries. With styles by thresholds Grafana

Thanks for suggestions. #1: it could be viable, but how can I then load GeoJSON in Grafana? when I choose GeoJSON as layer type it expects a file.

that is what I also thought that is has to be a file but look at the label carefully [image] GeoJSON URL. URL so this is what we did. might be a bit overkill but works perfectly for us app.get('/postgis', (req, res) => { db.one('SELECT geo FROM public.stores', 123) .then((data) => { …

Thank you for your very precious suggestions. I am new to Grafana: where do I have to put code fragments in order to create these web services as you did?

So what I did was I created a simple rest api using nodejs/express.js see here yosiasz/apis4grafana/blob/main/server.js const express = require('express') const cors = require('cors'); const bodyParser = require('body-parser') const parse = require('csv').parse const mysql = requi…

Ok, so I have to use an external software to realize a web service. There isn’t a way to do only with Grafana. Fine, I understand. Thank you for the very complete lesson!

there might be a plugin to aggregate geojson files. not sure how many you have. let’s try json plugins

ehm, at the moment 2400 and counting. Every year in Italy some territory changes, and we have to represent data for over 25 years in at least 5 levels of detail, from Country to village.

mama mia! Mannaggia! :laughing:

As an example, please visit: https://nubia.istitutodegliinnocenti.it/index1.jsf it’s still under development. As you will see, maps may vary over years. At left there are data to visualize. As a simpler example, please see: https://www.minoritoscana.it/dati-del-territorio I think your solution …

you can get close to this with grafana also using variables to choose the different filtering mechanisms Not as mature as what you have but close? [image]

Geomap: represent data with coloured areas

Grafana Geomap Panel

consumi July 4, 2022, 7:51pm 24

Geomap + geojson. I obtain values + geometries, but I can’t use values to select colors.

Why Geomap was not used for Polygon Dataset in Grafana

Topic		Replies	Views
GeoMap, new feature requests, influx work-arounds Geomap Panel geomap-panel , influxdb	17	2261	June 27, 2022
Paint areas in map according to query - impossible? Grafana plugins , geomap-panel , config-help	8	1482	February 25, 2024
Dynamic geoJSON Plugin (Alpha) structure from JSON API data source Geomap Panel	11	977	February 4, 2025
Why Geomap was not used for Polygon Dataset in Grafana Grafana geomap-panel	4	262	April 24, 2025
Dynamic GeoJSON Layer Dashboards geomap-panel	14	1269	October 7, 2024

Geomap: represent data with coloured areas

Related topics