G2ium-sVk.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "visualisierungsvorlagen", "url": "/d/G2ium-sVk/visualisierungsvorlagen", "expires": "0001-01-01T00:00:00Z", "created": "2023-05-03T08:10:10Z", "updated": "2023-06-07T07:41:02Z", "updatedBy": "dk+klimadashboard@tpwd.de", "createdBy": "superuser@tpwd.de", "version": 42, "hasAcl": false, "isFolder": false, "folderId": 26, "folderUid": "zjPWYTEVz", "folderTitle": "Admin & Editor", "folderUrl": "/dashboards/f/zjPWYTEVz/admin-and-editor", "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": 30, "links": [], "liveNow": false, "panels": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Vertikale Anordnung, Anzeige von Value und Name, keine Graphen, zentrierter Text", "fieldConfig": {"defaults": {"mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#224f72", "value": null}, {"color": "#27865a", "value": 80}]}, "unit": "short"}, "overrides": [{"matcher": {"id": "byName", "options": "frei__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der unversiegelten Fl\u00e4che in Prozent"}]}, {"matcher": {"id": "byName", "options": "versiegelt__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der versiegelten Fl\u00e4che in Prozent"}]}]}, "gridPos": {"h": 7, "w": 6, "x": 0, "y": 0}, "id": 12, "options": {"colorMode": "background", "graphMode": "none", "justifyMode": "center", "orientation": "vertical", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "text": {"titleSize": 12}, "textMode": "value_and_name"}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"landusage\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"12069\")\n  |> filter(fn: (r) => r[\"_field\"] == \"frei__Prozent\" or r[\"_field\"] == \"versiegelt__Prozent\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n", "refId": "A"}], "title": "Zwei Kacheln", "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Abstand 0,8, Breite 1, Farbverteilung nach Fl\u00e4chengr\u00f6\u00dfe, Radius 0,25, Fill 100", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "fillOpacity": 100, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineWidth": 0, "scaleDistribution": {"type": "linear"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "watt"}, "overrides": [{"matcher": {"id": "byName", "options": "Solar_elektrische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "Photovoltaik"}, {"id": "color", "value": {"fixedColor": "#27865a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "Solarthermie_thermische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "Solarthermie"}, {"id": "color", "value": {"fixedColor": "#5b5d6b", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "Biomasse_elektrische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "Biomasse (elektrisch)"}, {"id": "color", "value": {"fixedColor": "#8b0d7a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "Biomasse_thermische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "Biomasse (thermisch)"}, {"id": "color", "value": {"fixedColor": "#224f72", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "Wasser_elektrische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "Wasser"}, {"id": "color", "value": {"fixedColor": "#ec4f1d", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "W\u00e4rmepumpe_thermische_Leistung_kW"}, "properties": [{"id": "displayName", "value": "W\u00e4rmepumpe"}, {"id": "color", "value": {"fixedColor": "#0b662f", "mode": "fixed"}}]}]}, "gridPos": {"h": 9, "w": 18, "x": 6, "y": 0}, "id": 4, "options": {"barRadius": 0.25, "barWidth": 1, "groupWidth": 0.8, "legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "orientation": "auto", "showValue": "never", "stacking": "none", "text": {}, "tooltip": {"mode": "single", "sort": "none"}, "xTickLabelRotation": 0, "xTickLabelSpacing": 0}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "hide": false, "query": "from(bucket: \"Energieagentur-Brandenburg\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"gemeinde\"] == \"Bad Belzig\")\n  |> filter(fn: (r) => r[\"_measurement\"] == \"strom-_und_waermeerzeugung_ee_komplett__summe\")\n  |> filter(fn: (r) => r[\"_field\"] == \"Biomasse_elektrische_Leistung_kW\" or r[\"_field\"] == \"Biomasse_thermische_Leistung_kW\" or r[\"_field\"] == \"Solar_elektrische_Leistung_kW\" or r[\"_field\"] == \"Solarthermie_thermische_Leistung_kW\" or r[\"_field\"] == \"Wasser_elektrische_Leistung_kW\" or r[\"_field\"] == \"W\u00e4rmepumpe_thermische_Leistung_kW\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "B"}], "title": "Sechs vertikale Balken", "transformations": [], "type": "barchart"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}}, "mappings": []}, "overrides": [{"matcher": {"id": "byName", "options": "AI0106__Anteil_der_Flaeche_fuer_Siedlung_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der Fl\u00e4che f\u00fcr Siedlung in Prozent"}, {"id": "color", "value": {"fixedColor": "#7bb7d4", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0107__Anteil_der_Flaeche_fuer_Verkehr_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der Fl\u00e4che f\u00fcr Verkehr in Prozent"}, {"id": "color", "value": {"fixedColor": "#5088aa", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0108__Anteil_der_Flaeche_fuer_Landwirtschaft_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der Fl\u00e4che f\u00fcr Landwirtschaft in Prozent"}, {"id": "color", "value": {"fixedColor": "#27865a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0109__Anteil_der_Flaeche_fuer_Wald_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der Fl\u00e4che f\u00fcr Wald in Prozent"}, {"id": "color", "value": {"fixedColor": "#1c7353", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0110__Anteil_Sport-,_Freizeit-,_Erholungsflaeche_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der Sport-, Freizeit-, Erholungsfl\u00e4che in Prozent"}, {"id": "color", "value": {"fixedColor": "#224f72", "mode": "fixed"}}]}]}, "gridPos": {"h": 11, "w": 6, "x": 0, "y": 7}, "id": 14, "options": {"displayLabels": ["percent"], "legend": {"displayMode": "list", "placement": "bottom", "showLegend": true, "values": []}, "pieType": "pie", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "tooltip": {"mode": "single", "sort": "none"}}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"landusage\")\n  |> range(start: -20y)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"12069\")\n  |> filter(fn: (r) => r[\"_field\"] == \"AI0106__Anteil_der_Flaeche_fuer_Siedlung_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0107__Anteil_der_Flaeche_fuer_Verkehr_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0108__Anteil_der_Flaeche_fuer_Landwirtschaft_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0109__Anteil_der_Flaeche_fuer_Wald_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0110__Anteil_Sport-,_Freizeit-,_Erholungsflaeche_an_Gesamtflaeche__Prozent\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n", "refId": "A"}], "title": "Fl\u00e4chennutzung im Landkreis Potsdam Mittelmark 2020 ", "type": "piechart"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Brand und Accent Color, gef\u00fcllte Balken", "fieldConfig": {"defaults": {"color": {"fixedColor": "#27865a", "mode": "fixed"}, "mappings": [], "max": 100, "min": 0, "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}, "unit": "percent"}, "overrides": [{"matcher": {"id": "byName", "options": "versiegelt__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Anteil der versiegelten Fl\u00e4che in Prozent"}, {"id": "color", "value": {"fixedColor": "#224f72", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "frei__Prozent"}, "properties": [{"id": "displayName", "value": "Anteil der unversiegelten Fl\u00e4che in Prozent"}]}]}, "gridPos": {"h": 7, "w": 18, "x": 6, "y": 9}, "id": 10, "options": {"displayMode": "gradient", "minVizHeight": 5, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showUnfilled": false, "text": {"titleSize": 12}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"landusage\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"12069\")\n  |> filter(fn: (r) => r[\"_field\"] == \"frei__Prozent\" or r[\"_field\"] == \"versiegelt__Prozent\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n", "refId": "A"}], "title": "Horizontale Balken", "type": "bargauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Einfach Linie in der Brand Color, Linienst\u00e4rke 3", "fieldConfig": {"defaults": {"color": {"fixedColor": "#27865a", "mode": "fixed"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 3, "pointSize": 7, "scaleDistribution": {"type": "linear"}, "showPoints": "never", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "decimals": 3, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}]}}, "overrides": []}, "gridPos": {"h": 9, "w": 18, "x": 6, "y": 16}, "id": 26, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"apw\")\n  |> range(start: 2006-12-01T23:30:00Z)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"38413430\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Eine Linie", "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Farbschema green-yellow-red (vorgegebene Farben)\nFill auf 100", "fieldConfig": {"defaults": {"color": {"mode": "continuous-GrYlRd"}, "custom": {"fillOpacity": 100, "lineWidth": 0, "spanNulls": false}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}}, "overrides": [{"matcher": {"id": "byName", "options": "value"}, "properties": [{"id": "displayName", "value": "Wasserstand(NHN)"}]}]}, "gridPos": {"h": 6, "w": 6, "x": 0, "y": 18}, "id": 22, "options": {"alignValue": "left", "legend": {"displayMode": "list", "placement": "bottom", "showLegend": true}, "mergeValues": true, "rowHeight": 1, "showValue": "auto", "tooltip": {"mode": "single", "sort": "none"}}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"apw\")\n  |> range(start: 2006-12-01T23:30:00Z)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"38404690\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Farbverlauf", "type": "state-timeline"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}}, "decimals": 0, "mappings": [{"options": {"10": {"color": "red", "index": 0, "text": "test"}}, "type": "value"}], "max": 50, "min": -20, "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}, {"color": "blue", "value": -10}, {"color": "light-blue", "value": 0}, {"color": "green", "value": 5}, {"color": "#EAB839", "value": 10}, {"color": "orange", "value": 20}, {"color": "red", "value": 30}]}, "unit": "celsius"}, "overrides": [{"matcher": {"id": "byName", "options": "latitude"}, "properties": [{"id": "custom.hideFrom", "value": {"legend": false, "tooltip": false, "viz": false}}, {"id": "unit", "value": "none"}, {"id": "decimals", "value": 5}]}, {"matcher": {"id": "byName", "options": "longitude"}, "properties": [{"id": "custom.hideFrom", "value": {"legend": false, "tooltip": false, "viz": false}}, {"id": "unit", "value": "none"}, {"id": "decimals", "value": 5}]}]}, "gridPos": {"h": 11, "w": 6, "x": 0, "y": 24}, "id": 32, "options": {"basemap": {"config": {}, "name": "Layer 0", "opacity": 1, "type": "osm-standard"}, "controls": {"mouseWheelZoom": true, "showAttribution": true, "showDebug": false, "showMeasure": false, "showScale": true, "showZoom": true}, "layers": [{"config": {"showLegend": true, "style": {"color": {"field": "lastMeasurementValue", "fixed": "dark-green"}, "opacity": 1, "rotation": {"fixed": 0, "max": 360, "min": -360, "mode": "clamped"}, "size": {"fixed": 15, "max": 100, "min": 1}, "symbol": {"fixed": "img/icons/marker/circle.svg", "mode": "fixed"}, "text": {"field": "lastMeasurementValue", "fixed": "", "mode": "field"}, "textConfig": {"fontSize": 12, "offsetX": 0, "offsetY": 0, "textAlign": "center", "textBaseline": "bottom"}}}, "name": "Temperature", "tooltip": true, "type": "markers"}], "tooltip": {"mode": "details"}, "view": {"allLayers": true, "id": "coords", "lat": 52.13686, "lon": 12.48698, "shared": true, "zoom": 12}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"OpenSenseMap\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"sensore_title\"] == \"Temperatur\")\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Arensnest Heuweide\" or r[\"_measurement\"] == \"Wieseburg Schlosspark\" or r[\"_measurement\"] == \"Zukunftsschusterei\")\n  |> filter(fn: (r) => r[\"_field\"] == \"lastMeasurementValue\" or r[\"_field\"] == \"latitude\" or r[\"_field\"] == \"longitude\")\n  |> last()\n  |> pivot(rowKey:[\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")\n  |> group()  \n  |> drop(columns: [\"_start\", \"_stop\", \"_time\",\"_measurement\", \"box_id\", \"sensor_id\", \"sensore_title\"])", "refId": "A"}], "title": "Bunte Karte mit dynamischen Markern", "type": "geomap"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Unterschiedliche Linien, Hervorhebung der Eckpunkte (12), Farben ohne Logik, Strichst\u00e4rke 3", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 3, "pointSize": 12, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}]}}, "overrides": [{"matcher": {"id": "byName", "options": "verbrauch_strom_menge_einwohner_kwh_ew"}, "properties": [{"id": "displayName", "value": "Stromverbrauch"}, {"id": "color", "value": {"fixedColor": "#224f72", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "verbrauch_gas_menge_einwohner_kwh_ew {gemeinde=\"Bad Belzig\", landkreis=\"Potsdam-Mittelmark\", landkreis_id=\"12069000\", region=\"Havelland-Fl\u00e4ming\", region_id=\"1\", schluessel=\"12069020\", typ=\"Amtsfreie Stadt\"}"}, "properties": [{"id": "displayName", "value": "Gasverbrauch"}, {"id": "color", "value": {"fixedColor": "#27865a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "verbrauch_waerme_menge_einwohner_kwh_ew"}, "properties": [{"id": "displayName", "value": "Verbrauch Nah- und Fernw\u00e4rme"}, {"id": "color", "value": {"fixedColor": "#ec4f1d", "mode": "fixed"}}]}]}, "gridPos": {"h": 11, "w": 18, "x": 6, "y": 25}, "id": 2, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Energieagentur-Brandenburg\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"gemeinde\"] == \"Bad Belzig\")\n  |> filter(fn: (r) => r[\"_measurement\"] == \"energiesteckbrief_daten_komplett\")\n  |> filter(fn: (r) => r[\"_field\"] == \"verbrauch_strom_menge_einwohner_kwh_ew\" or r[\"_field\"] == \"verbrauch_gas_menge_einwohner_kwh_ew\" or r[\"_field\"] == \"verbrauch_waerme_menge_einwohner_kwh_ew\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Drei Linien", "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Marker in Brand", "fieldConfig": {"defaults": {"color": {"fixedColor": "#27865a", "mode": "fixed"}, "custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "purple", "value": null}]}}, "overrides": []}, "gridPos": {"h": 18, "w": 6, "x": 0, "y": 35}, "id": 6, "options": {"basemap": {"config": {}, "name": "Layer 0", "type": "default"}, "controls": {"mouseWheelZoom": true, "showAttribution": true, "showDebug": false, "showMeasure": false, "showScale": true, "showZoom": true}, "layers": [{"config": {"showLegend": true, "style": {"color": {"fixed": "#27865a"}, "opacity": 1, "rotation": {"fixed": 0, "max": 360, "min": -360, "mode": "mod"}, "size": {"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"}}}, "location": {"mode": "auto"}, "name": "Layer 1", "tooltip": false, "type": "markers"}], "tooltip": {"mode": "details"}, "view": {"allLayers": true, "id": "coords", "lat": 52.130442, "lon": 12.608295, "shared": true, "zoom": 11.02}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "  from(bucket: \"apw\")\n  |> range(start: 2006-12-01T23:30:00Z)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"38413485\" or r[\"_measurement\"] == \"37413750\" or r[\"_measurement\"] == \"38404661\" or r[\"_measurement\"] == \"38404670\" or r[\"_measurement\"] == \"38404690\" or r[\"_measurement\"] == \"38413420\" or r[\"_measurement\"] == \"38413421\" or r[\"_measurement\"] == \"38413430\" or r[\"_measurement\"] == \"38413440\" or r[\"_measurement\"] == \"38413441\" or r[\"_measurement\"] == \"38413442\" or r[\"_measurement\"] == \"38413443\" or r[\"_measurement\"] == \"38413453\" or r[\"_measurement\"] == \"38413454\" or r[\"_measurement\"] == \"38413470\" or r[\"_measurement\"] == \"38413471\" or r[\"_measurement\"] == \"38413472\" or r[\"_measurement\"] == \"38413486\" or r[\"_measurement\"] == \"38413490\" or r[\"_measurement\"] == \"38423150\" or r[\"_measurement\"] == \"38423250\" or r[\"_measurement\"] == \"39400001\" or r[\"_measurement\"] == \"39413095\" or r[\"_measurement\"] == \"39413110\" or r[\"_measurement\"] == \"39423102\")\n  |> filter(fn: (r) => r._field == \"status\" or r._field == \"longitude\" or r._field == \"latitude\")\n  |>last()\n  |> pivot(rowKey:[\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")\n  |> group()  \n  |> drop(columns: [\"_start\", \"_stop\", \"_time\",\"_measurement\"])", "refId": "A"}], "title": "Helle Karte", "transformations": [{"id": "organize", "options": {"excludeByName": {}, "indexByName": {}, "renameByName": {"p2Value": "Wert"}}}], "type": "geomap"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Strichst\u00e4rke 3, Punkte 12", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 3, "pointSize": 16, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "percentage", "steps": [{"color": "green", "value": null}]}}, "overrides": [{"matcher": {"id": "byName", "options": "AI0106__Anteil_der_Flaeche_fuer_Siedlung_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Siedlungsfl\u00e4che (%)"}, {"id": "color", "value": {"fixedColor": "#27865a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0107__Anteil_der_Flaeche_fuer_Verkehr_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Verkehrsfl\u00e4che (%)"}, {"id": "color", "value": {"fixedColor": "#224f72", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0108__Anteil_der_Flaeche_fuer_Landwirtschaft_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Landwirtschaftsfl\u00e4che (%)"}, {"id": "color", "value": {"fixedColor": "#af7c16", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0109__Anteil_der_Flaeche_fuer_Wald_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Waldsfl\u00e4che (%)"}, {"id": "color", "value": {"fixedColor": "#8b0d7a", "mode": "fixed"}}]}, {"matcher": {"id": "byName", "options": "AI0110__Anteil_Sport-,_Freizeit-,_Erholungsflaeche_an_Gesamtflaeche__Prozent Potsdam-Mittelmark, Landkreis"}, "properties": [{"id": "displayName", "value": "Sport-, Freizeit-, Erholungsfl\u00e4che (%)"}, {"id": "color", "value": {"fixedColor": "#777986", "mode": "fixed"}}]}]}, "gridPos": {"h": 11, "w": 18, "x": 6, "y": 36}, "id": 8, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"landusage\")\n  |> range(start: -20y)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"12069\")\n  |> filter(fn: (r) => r[\"_field\"] == \"AI0106__Anteil_der_Flaeche_fuer_Siedlung_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0107__Anteil_der_Flaeche_fuer_Verkehr_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0108__Anteil_der_Flaeche_fuer_Landwirtschaft_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0109__Anteil_der_Flaeche_fuer_Wald_an_Gesamtflaeche__Prozent\" or r[\"_field\"] == \"AI0110__Anteil_Sport-,_Freizeit-,_Erholungsflaeche_an_Gesamtflaeche__Prozent\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n", "refId": "A"}], "title": "F\u00fcnf Linien", "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Linienst\u00e4rke 3, Brand Color f\u00fcr positiven Bereich, Error Color f\u00fcr negativen Bereich, Fl\u00e4che zur Hervorhebung des Threshold ", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 100, "gradientMode": "scheme", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "smooth", "lineWidth": 3, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}, {"color": "#c82b17", "value": 164}]}}, "overrides": [{"matcher": {"id": "byName", "options": "value"}, "properties": [{"id": "displayName", "value": "Wasserstand(NHN)"}]}]}, "gridPos": {"h": 12, "w": 18, "x": 6, "y": 47}, "id": 20, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": false}, "tooltip": {"mode": "single", "sort": "none"}}, "pluginVersion": "9.2.4", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"apw\")\n  |> range(start: 2006-12-01T23:30:00Z)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"38404690\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Eine Linie mit Threshold und Fl\u00e4che", "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Textsize 40, Farben sind Brand, Warning und Error\n\nAchtung: Thresholds k\u00f6nnen NICHT dynamisch gesetzt werden, sondern nur in festen Werten oder in Prozent.", "fieldConfig": {"defaults": {"mappings": [], "max": 96.2, "min": 0, "thresholds": {"mode": "absolute", "steps": [{"color": "#c82b17", "value": null}, {"color": "#d19c1f", "value": 4.2}, {"color": "#27865a", "value": 54}]}, "unit": "lengthmm"}, "overrides": []}, "gridPos": {"h": 9, "w": 6, "x": 6, "y": 59}, "id": 16, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["sum"], "fields": "", "values": false}, "showThresholdLabels": true, "showThresholdMarkers": true, "text": {"titleSize": 40, "valueSize": 40}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"DWD\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"5546\")\n  |> filter(fn: (r) => r[\"_field\"] == \"RSK\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Gauge mit Thresholds", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Brand color, Text 40", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}]}}, "overrides": []}, "gridPos": {"h": 9, "w": 6, "x": 12, "y": 59}, "id": 30, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true, "text": {"titleSize": 40, "valueSize": 40}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Feinstaub\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"62992\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Gauge ohne Threshold, aber mit Threshold marker", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Brand color, Text 40", "fieldConfig": {"defaults": {"color": {"fixedColor": "#27865a", "mode": "fixed"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}]}}, "overrides": []}, "gridPos": {"h": 9, "w": 6, "x": 18, "y": 59}, "id": 35, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": false, "text": {"titleSize": 40, "valueSize": 40}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Feinstaub\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"62992\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Gauge ohne Threshold", "type": "gauge"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "2014-12-31T23:00:00.000Z", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Visualisierungsvorlagen", "uid": "G2ium-sVk", "version": 42, "weekStart": ""}}