search

alexandrainst / alexandra-trackmap-panel

Grafana map plugin to visualise coordinates as markers, hexbin, ant path, or heatmap.
MIT License
78 stars 26 forks source link

Markers showing up with longitude=0 #62

Closed bijwaard closed 3 years ago

bijwaard commented 3 years ago

Dear developers, I just upgraded your plugin from githup, re-installed and re-build with npm, and restarted grafana (v7.5.7 on Ubuntu 20.04.2), I am still using the TestData DB plugin for the metrics. For some reason the longitude is now always 0, I get an error about null longitude in 1970 but it is there in the inspect panel with valid timestamp (see below). The map positioned itself in the correct area of the Netherlands (as in #31), I zoomed out to find the marker. image. Adding "longitude" in the second "Custom latitude column name" does not help, changing that to "latitude" gets me south of Russia, shows my markers but not the tooltip. image Any idea why this happens and how to resolve it?

Kind regards, Dennis

mapleafGWN commented 3 years ago

Similar issue as bijwaard - the locations plot at Latitude / Longitude of 0,0

Using Trace Map v2.2.1; Enterprise Grafana v7.5.4; Oracle SQL Developer.

Query format is 'Table'. Query inspector data table shows two correct non-zero latitude / longitude locations:

Query_Inspector

Issue is that the locations plot at Latitude / Longitude of 0,0. Also, map does not center as toggled, 'Map center to first position':

Plotting_0_0

Display Parameters: Display_Parameters

mapleafGWN commented 3 years ago

This appears to be similar to issue #58. I've attempted to get this to plot locations through Docker containers for Grafana versions 7.5.4 and 7.5.9 with the same result - only plots at lat/lon 0,0. Same results on company's Enterprise version of Grafana (7.5.4). So, if I am getting same results with different versions of Grafana is this an issue with the plugin?

Again, its using format 'Table' - Query correctly retrieves the location data into the plugin's table. If locations are displayed properly in the query table then why are they not displayed on the map? No error notifications - and the json generated appears fine.

mapleafGWN commented 3 years ago

Still looking for why markers are not at lat/lon locations shown in query table.
Reviewing again the 'Query' tab and it shows "series:null" and "dataframes:null". Why? Image below shows the correct values extracted. What is causing this?
Query-tab

bijwaard commented 3 years ago

Hi, Not sure why your query results look empty, the data may be in the columns and rows instead of dataframe/series. My query result looked strange in my grafana 7.6.5 as well, while the inspect data showed latitude and longitude separately, but when I tried to join them the data list is empty. I updated to grafana 8.0.5 and allowed the unsigned trackmap panel: ` [plugins]

allow_loading_unsigned_plugins = alexandra-trackmap-panel ` The inspect data still looks the same, still no joined data, which may be causing the issue: image image image

The query result now looks like this: image

Unfortunately, the markers are still at the wrong place.

bijwaard commented 3 years ago

Hi, As proposed by Ryan in the related grafana ticket, a work-around in e.g. grafana 8.0.5 is to add an outer-join transform to join the metrics in time. image Kind regards, Dennis

ZhongyuWang commented 3 years ago

To sum up, the reason seems to be latitude and longitude should be in the same row.

Close for now and feel free to post more information.