h2x-HdoVk.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "community-daten", "url": "/d/h2x-HdoVk/community-daten", "expires": "0001-01-01T00:00:00Z", "created": "2023-01-20T11:52:11Z", "updated": "2023-09-11T10:58:33Z", "updatedBy": "pw@tpwd.de", "createdBy": "admin", "version": 39, "hasAcl": false, "isFolder": false, "folderId": 12, "folderUid": "YovVVOT4z", "folderTitle": "Lokale Feinstaub-Daten (Community-Daten)", "folderUrl": "/dashboards/f/YovVVOT4z/lokale-feinstaub-daten-community-daten", "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": 13, "links": [], "liveNow": false, "panels": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "blue", "value": 0}, {"color": "green", "value": 10}, {"color": "#EAB839", "value": 20}, {"color": "orange", "value": 30}, {"color": "red", "value": 40}, {"color": "dark-red", "value": 50}]}}, "overrides": []}, "gridPos": {"h": 10, "w": 24, "x": 0, "y": 0}, "id": 15, "options": {"basemap": {"config": {}, "name": "Layer 0", "opacity": 1, "tooltip": true, "type": "osm-standard"}, "controls": {"mouseWheelZoom": true, "showAttribution": true, "showDebug": false, "showMeasure": false, "showScale": true, "showZoom": true}, "layers": [{"config": {"showLegend": true, "style": {"color": {"field": "p2Value", "fixed": "red"}, "opacity": 0.7, "rotation": {"fixed": 0, "max": 360, "min": -360, "mode": "mod"}, "size": {"field": "p2Value", "fixed": 5, "max": 20, "min": 10}, "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"}, "name": "P2.5(\u00b5g/m\u00b3)", "tooltip": true, "type": "markers"}], "tooltip": {"mode": "details"}, "view": {"allLayers": true, "id": "coords", "lat": 52.121, "lon": 12.50151, "zoom": 11.7}}, "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\"] == \"58256\" or r[\"_measurement\"] == \"62992\")\n  |> filter(fn: (r) => r._field == \"p2Value\" 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"}], "transformations": [{"id": "organize", "options": {"excludeByName": {}, "indexByName": {}, "renameByName": {"p2Value": "Wert"}}}], "type": "geomap"}, {"collapsed": false, "gridPos": {"h": 1, "w": 24, "x": 0, "y": 10}, "id": 4, "panels": [], "title": "Sensor-ID: 58256", "type": "row"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "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": 1, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": [{"matcher": {"id": "byName", "options": "p1Value"}, "properties": [{"id": "displayName", "value": "PM10"}]}, {"matcher": {"id": "byName", "options": "p2Value"}, "properties": [{"id": "displayName", "value": "PM2.5"}]}]}, "gridPos": {"h": 10, "w": 14, "x": 0, "y": 11}, "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: \"Feinstaub\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\" or r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 14, "y": 11}, "id": 6, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "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\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Feinstaub PM10", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 19, "y": 11}, "id": 8, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "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\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Feinstaub PM2.5", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}, {"color": "red", "value": 50}]}, "unit": "locale"}, "overrides": [{"matcher": {"id": "byName", "options": "p1Value"}, "properties": [{"id": "displayName", "value": "Feinstaub PM10:"}]}, {"matcher": {"id": "byName", "options": "p2Value"}, "properties": [{"id": "displayName", "value": "Feinstaub PM2,5:"}, {"id": "thresholds", "value": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}, {"color": "red", "value": 25}]}}]}]}, "gridPos": {"h": 10, "w": 5, "x": 9, "y": 21}, "id": 19, "options": {"colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "text": {"titleSize": 20, "valueSize": 40}, "textMode": "value_and_name"}, "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\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\" or r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a"}, {"color": "red", "value": 50}]}, "unit": "locale"}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 14, "y": 21}, "id": 16, "options": {"colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "auto"}, "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\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Feinstaub PM10", "type": "stat"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a"}, {"color": "red", "value": 25}]}, "unit": "locale"}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 19, "y": 21}, "id": 17, "options": {"colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "textMode": "auto"}, "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\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Feinstaub PM2.5", "type": "stat"}, {"collapsed": false, "gridPos": {"h": 1, "w": 24, "x": 0, "y": 31}, "id": 10, "panels": [], "title": "Sensor-ID: 62992", "type": "row"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "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": 1, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": [{"matcher": {"id": "byName", "options": "p1Value"}, "properties": [{"id": "displayName", "value": "PM10"}]}, {"matcher": {"id": "byName", "options": "p2Value"}, "properties": [{"id": "displayName", "value": "PM2.5"}]}]}, "gridPos": {"h": 10, "w": 14, "x": 0, "y": 32}, "id": 11, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "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\" or r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transformations": [], "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 14, "y": 32}, "id": 12, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "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": "Feinstaub PM10", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 10, "w": 5, "x": 19, "y": 32}, "id": 13, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "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\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Feinstaub PM2.5", "type": "gauge"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "now-6h", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Community-Daten", "uid": "h2x-HdoVk", "version": 39, "weekStart": ""}}