Can you specify your workaround a little more:
Did anyone encounter: “Unable to parse locations” if you replaced one of the existing .json files with a custom one? I think it is not an issue with my json format.
Thanks
In our case the file was uploaded to the “/public/gazetteer” folder, and in the GEOMAP option of data layer we typed the Geojson URL as: /public/gazetteer/image.geojson
Hope it helps!
Thanks! It’s hard to notice that one can write a custom path there.
If anybody is trying to get it to work with german postal codes:
Get the file DE.tab here:
And then run the following python script in that folder:
import sys
import pandas as pd
import json
dat = pd.read_csv("DE.tab",sep='\t')
dat = dat[dat["plz"].notnull()]
dat = dat[dat["lat"].notnull()]
dat = dat[["plz","lat","lon","name"]]
dat.columns = ["key","latitude","longitude","name"]
for i,row in dat.iterrows():
if "," in row["key"]:
for alt in row["key"].split(','):
tmp = row.copy()
tmp["key"] = alt
dat = dat.append(tmp,ignore_index=True)
dat = dat[~dat["key"].str.contains(",")]
parsed = json.loads(dat.to_json(orient='records'))
tmp = json.dumps(parsed, indent=4, ensure_ascii=False).encode('utf8')
print(tmp.decode())
I have set up a server that serves geoJSON files and thought that I could have grafana query my server for the files by adding the url to the server as stated above, but it does not show me anything. Have anyone managed to do this?
i can enter my files no problem.
has anyone been able to pass a variable into the GeoJSON URL
ie
public/maps/${variable}.geojson
or is my syntax off.
A node server or what kind of server?
Can this work with a servwr that serves geojson files? Make it grab different routes?
This is working for me using nodejs/express.js for a rest api
app.get("/provinces", (req, res) => {
let raw = fs.readFileSync(
"/public/maps/limits_IT_provinces.geojson"
);
let geojson = JSON.parse(raw);
let properties = geojson.features.map((p) => p.properties);
return res.send(properties);
});
app.get("/provinces/:prov_istat_code_num", (req, res) => {
let geojson = fs.readFileSync(
"/public/maps/limits_IT_provinces.geojson"
);
let featureCollection = JSON.parse(geojson);
let prov_istat_code_num = req.params.prov_istat_code_num
let feature = featureCollection.features.filter(function (feature) {
return feature.properties.prov_istat_code_num === parseInt(prov_istat_code_num);
});
province = {};
province.type = "FeatureCollection";
province.bbox = [
6.62662136853768, 35.493691935511417, 18.52038159909892, 47.091783746462159,
];
province.features = feature;
return res.send(province);
});
using another geomap plugin: GitHub - orchestracities/map-panel: This plugin extends Grafana Geomap panel with several functionalities: Support for GeoJSON shapes, Support for icons, Support for pop up visualizations of data from a specific point, Multiple layers for the different queries.
hi, could you give a little more explanation please.
I’m a little lost . 
how conf variable?
thank you very much , one additional question ,I have a problem with the Multi-value and Include All option
do you know any way to make them work?
Are you going to use the nodejs/express approach?
Yes, I’m using node express, and I can’t use Multi-value and Include All option. thanks.
Yes you can. The issue is more javascript/typescript issue. You will have to sort out how to parse the multi values on the node side.
i need to know more on this. Where is your node.js located? on the same Grafana server? I have about 700 geojson files, and statically assining them is a pain.
Mine is separate node rest api host. But location does not matter but best to separate concerns
You could implement dynamic loading of geojson files from a folder
But I would recommend you import these files into better suited GIS database
Ok. And you use the json data source for Grafana to query the geojson data?
no I use nodejs as that is what this thread is all about.
Ok. Sorry, just tryin to wrap my mind arount this.
just like you can serve data in a database via rest api, you can also serve file data on disk as rest api but I would not recommend it. these files should really be in a database.
then your rest api for geolocation is served from a database and not a file.
