DqwfrUwVk.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "schadstufen", "url": "/d/DqwfrUwVk/schadstufen", "expires": "0001-01-01T00:00:00Z", "created": "2023-05-30T10:48:44Z", "updated": "2023-06-14T17:02:06Z", "updatedBy": "pw@tpwd.de", "createdBy": "dk+klimadashboard@tpwd.de", "version": 28, "hasAcl": false, "isFolder": false, "folderId": 55, "folderUid": "UT2Nu8QVz", "folderTitle": "Waldzustandsbericht des Landes Brandenburg", "folderUrl": "/dashboards/f/UT2Nu8QVz/waldzustandsbericht-des-landes-brandenburg", "provisioned": false, "provisionedExternalId": "", "annotationsPermissions": {"dashboard": {"canAdd": true, "canEdit": true, "canDelete": true}, "organization": {"canAdd": true, "canEdit": true, "canDelete": true}}, "publicDashboardAccessToken": "", "publicDashboardUid": "", "publicDashboardEnabled": false}, "dashboard": {"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": 56, "links": [], "liveNow": false, "panels": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": []}, "gridPos": {"h": 3, "w": 4, "x": 0, "y": 0}, "id": 6, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "vertical", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"alle Baumarten\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "%-Punkte"}, "overrides": []}, "gridPos": {"h": 2, "w": 4, "x": 0, "y": 3}, "id": 7, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["diff"], "fields": "", "values": false}, "text": {}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"alle Baumarten\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": []}, "gridPos": {"h": 3, "w": 4, "x": 0, "y": 5}, "id": 5, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Kiefer\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "%-Punkte"}, "overrides": []}, "gridPos": {"h": 2, "w": 4, "x": 0, "y": 8}, "id": 8, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["diff"], "fields": "", "values": false}, "text": {}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Kiefer\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": []}, "gridPos": {"h": 3, "w": 4, "x": 0, "y": 10}, "id": 4, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Eiche\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "%-Punkte"}, "overrides": []}, "gridPos": {"h": 2, "w": 4, "x": 0, "y": 13}, "id": 9, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["diff"], "fields": "", "values": false}, "text": {}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Eiche\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": []}, "gridPos": {"h": 3, "w": 4, "x": 0, "y": 15}, "id": 3, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Buche\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "%-Punkte"}, "overrides": []}, "gridPos": {"h": 2, "w": 4, "x": 0, "y": 18}, "id": 10, "options": {"colorMode": "none", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["diff"], "fields": "", "values": false}, "text": {}, "textMode": "value"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Buche\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "2021: https://forst.brandenburg.de/sixcms/media.php/9/wze2021.pdf\n2022: https://mluk.brandenburg.de/sixcms/media.php/9/Waldzustandsbericht-2022.pdf", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "fillOpacity": 80, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineWidth": 1, "scaleDistribution": {"type": "linear"}}, "mappings": [], "max": 100, "min": 0, "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": []}, "gridPos": {"h": 9, "w": 4, "x": 0, "y": 20}, "id": 2, "options": {"barRadius": 0, "barWidth": 0.96, "groupWidth": 0.7, "legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "orientation": "horizontal", "showValue": "auto", "stacking": "normal", "tooltip": {"mode": "multi", "sort": "none"}, "xTickLabelRotation": 0, "xTickLabelSpacing": 0}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Waldzustandsbericht\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Schadstufen\")\n  |> filter(fn: (r) => r[\"Baumart\"] == \"Buche\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Schadstufe 0\" or r[\"_field\"] == \"Schadstufe 1\" or r[\"_field\"] == \"Schadstufe 2-4\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Buche - Waldzustansbericht 2022", "transformations": [{"id": "labelsToFields", "options": {"mode": "columns", "valueLabel": "Baumart"}}, {"id": "joinByField", "options": {"byField": "Time", "mode": "outer"}}, {"id": "organize", "options": {"excludeByName": {"Buche 1": false, "Buche 2": false, "Buche 3": false, "alle Baumarten 1": false}, "indexByName": {}, "renameByName": {"Buche 1": "ohne Sch\u00e4den (Schadstufe 0)", "Buche 2": "Warnstufe (Schadstufe 1)", "Buche 3": "deutliche Sch\u00e4den (Schadstufe 2-4)"}}}], "type": "barchart"}], "refresh": false, "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "2020-12-30T23:00:00.000Z", "to": "2022-12-30T23:00:00.000Z"}, "timepicker": {}, "timezone": "", "title": "Schadstufen", "uid": "DqwfrUwVk", "version": 28, "weekStart": ""}}