Using Grafana 9.1.4 and PostgreSql 12.12 database running on Ubuntu 20.04
Datapoint for my test is:
select 55.60225977918819 latitude, 12.479173970814054 longitude, 10 sz, ‘Site1’ site
This is a point just south of the Copenhagen-marker on the default base layer.
I expected a marker to show up at that point, but no matter what I have tried - it does not show up. Moving the mouse to the point makes the tooltip appear - so the point is acceptet by the GeoMap.
I have never used the GeoMap panel before, but I feel my options searching for new approaches has exhausted.
I have tried in Chrome and Egde with the same result.
Below is the dashboard’s JSON:
{
“annotations”: {
“list”: [
{
“builtIn”: 1,
“datasource”: {
“type”: “grafana”,
“uid”: “-- Grafana --”
},
“enable”: true,
“hide”: true,
“iconColor”: “rgba(0, 211, 255, 1)”,
“name”: “Annotations & Alerts”,
“target”: {
“limit”: 100,
“matchAny”: false,
“tags”: ,
“type”: “dashboard”
},
“type”: “dashboard”
}
]
},
“editable”: true,
“fiscalYearStartMonth”: 0,
“graphTooltip”: 0,
“id”: 193,
“links”: ,
“liveNow”: false,
“panels”: [
{
“datasource”: {
“type”: “postgres”,
“uid”: “EJANwmQMz”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“custom”: {
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
}
},
“mappings”: ,
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”,
“value”: null
},
{
“color”: “red”,
“value”: 80
}
]
}
},
“overrides”:
},
“gridPos”: {
“h”: 20,
“w”: 20,
“x”: 0,
“y”: 0
},
“id”: 2,
“options”: {
“basemap”: {
“config”: {},
“name”: “Layer 0”,
“type”: “default”
},
“controls”: {
“mouseWheelZoom”: true,
“showAttribution”: true,
“showDebug”: false,
“showScale”: false,
“showZoom”: true
},
“layers”: [
{
“config”: {
“showLegend”: true,
“style”: {
“color”: {
“fixed”: “dark-green”
},
“opacity”: 0.4,
“rotation”: {
“fixed”: 0,
“max”: 360,
“min”: -360,
“mode”: “mod”
},
“size”: {
“field”: “sz”,
“fixed”: 5,
“max”: 15,
“min”: 2
},
“symbol”: {
“fixed”: “img/icons/marker/circle.svg”,
“mode”: “fixed”
},
“textConfig”: {
“fontSize”: 12,
“offsetX”: 0,
“offsetY”: 0,
“textAlign”: “center”,
“textBaseline”: “middle”
}
}
},
“filterData”: {
“id”: “byRefId”,
“options”: “A”
},
“location”: {
“latitude”: “latitude”,
“longitude”: “longitude”,
“mode”: “coords”
},
“name”: “Sites”,
“opacity”: 0,
“tooltip”: true,
“type”: “markers”
}
],
“tooltip”: {
“mode”: “details”
},
“view”: {
“id”: “coords”,
“lat”: 55,
“lon”: 8,
“zoom”: 6
}
},
“pluginVersion”: “9.1.4”,
“targets”: [
{
“datasource”: {
“type”: “postgres”,
“uid”: “EJANwmQMz”
},
“format”: “table”,
“group”: ,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: "select 55.60225977918819 latitude, 12.479173970814054 longitude, 10 sz, ‘Site1’ site ",
“refId”: “A”,
“select”: [
[
{
“params”: [
“value”
],
“type”: “column”
}
]
],
“timeColumn”: “time”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: ,
“type”: “macro”
}
]
}
],
“title”: “GHS Sites”,
“transformations”: ,
“type”: “geomap”
}
],
“schemaVersion”: 37,
“style”: “dark”,
“tags”: ,
“templating”: {
“list”:
},
“time”: {
“from”: “now-6h”,
“to”: “now”
},
“timepicker”: {},
“timezone”: “”,
“title”: “TestGeoMap”,
“uid”: “npmtq-VVz”,
“version”: 13,
“weekStart”: “”
}