ElasticSearch to geomap

Grafana Elasticsearch
,
1

Greetings,

  • What Grafana version and what operating system are you using?

  • v8.4.5 Windows 10

  • What are you trying to achieve?
    map lon lat from elastic search

  • How are you trying to achieve it?
    in grafana pointing to our elastic search

  • What happened?
    I am not able to plot the lon lat

image
image1242×220 19.4 KB

  • What did you expect to happen?
    I expected to be able to see and plot my long/lat data

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    None

  • Did you follow any online instructions? If so, what is the URL?
    Cant find one for the specific thing that I am trying to do for the last 3 days

2

Coords specifies that your query holds coordinate data. You will get prompted to select numeric data fields for latitude and longitude from your database query.

Your fields are not numeric, but strings, so their format is quite weird to be processed by geomap.

Quick demo with SQL datasource to prove that geomap is working with correct numeric data correctly:

image
image2216×1220 237 KB

1 Like
3

Thanks very much @jangaraj . So found the numeric values in another field set
location.lat
41.866

location.lon
-89.277

But for some reason they do not show up in grafana’s elastic search query. Something else for me to tackle, but you have answered my question. Thanks much!