1jeaxYy4z.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "windanlagen", "url": "/d/1jeaxYy4z/windanlagen", "expires": "0001-01-01T00:00:00Z", "created": "2023-05-04T07:24:24Z", "updated": "2023-06-22T11:30:12Z", "updatedBy": "pw@tpwd.de", "createdBy": "dk+klimadashboard@tpwd.de", "version": 7, "hasAcl": false, "isFolder": false, "folderId": 35, "folderUid": "MPxabYy4z", "folderTitle": "Landesvermessung und Geobasisinformation Brandenburg (LGB)", "folderUrl": "/dashboards/f/MPxabYy4z/landesvermessung-und-geobasisinformation-brandenburg-lgb", "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": 36, "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": "purple", "value": null}]}}, "overrides": [{"matcher": {"id": "byName", "options": "latitude"}, "properties": [{"id": "custom.hideFrom", "value": {"legend": false, "tooltip": true, "viz": false}}]}, {"matcher": {"id": "byName", "options": "longitude"}, "properties": [{"id": "custom.hideFrom", "value": {"legend": false, "tooltip": true, "viz": false}}]}]}, "gridPos": {"h": 20, "w": 24, "x": 0, "y": 0}, "id": 2, "options": {"basemap": {"config": {}, "name": "Layer 0", "type": "default"}, "controls": {"mouseWheelZoom": true, "showAttribution": true, "showDebug": false, "showMeasure": false, "showScale": true, "showZoom": true}, "layers": [{"config": {"showLegend": false, "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": true, "type": "markers"}], "tooltip": {"mode": "details"}, "view": {"allLayers": true, "id": "coords", "lat": 52.268166, "lon": 12.435163, "zoom": 10}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"LGB\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"windkraftanlagen_in_brandenburg\")\n  |> filter(fn: (r) => r[\"_field\"] == \"latitude\" or\n                        r[\"_field\"] == \"longitude\" or\n                        r[\"_field\"] == \"anl_nr\" or\n                        r[\"_field\"] == \"lw_tag\" or\n                        r[\"_field\"] == \"nabenhoehe\" or\n                        r[\"_field\"] == \"bst_nr\" or\n                        r[\"_field\"] == \"bst_name\" or\n                        r[\"_field\"] == \"anl_bez\" or\n                        r[\"_field\"] == \"stand_abw\" or\n                        r[\"_field\"] == \"ostwert\" or\n                        r[\"_field\"] == \"genehmigt\" or\n                        r[\"_field\"] == \"wka_id\" or\n                        r[\"_field\"] == \"leistung\" or\n                        r[\"_field\"] == \"rotordurch\" or\n                        r[\"_field\"] == \"ortsteil\" or\n                        r[\"_field\"] == \"lw_nacht\" or\n                        r[\"_field\"] == \"nordwert\" or\n                        r[\"_field\"] == \"land\" or\n                        r[\"_field\"] == \"alt_an_anz\" or\n                        r[\"_field\"] == \"objectid\" or\n                        r[\"_field\"] == \"plz\")\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": {"alt_an_anz": 25, "anl_bez": 9, "anl_nr": 10, "betreiber": 5, "bst_name": 11, "bst_nr": 12, "geme_kenn": 4, "genehmigt": 13, "kreis": 0, "land": 14, "latitude": 6, "leistung": 15, "longitude": 7, "lw_nacht": 16, "lw_tag": 17, "nabenhoehe": 18, "nordwert": 19, "objectid": 20, "ort": 2, "ortsteil": 3, "ostwert": 21, "plz": 1, "rotordurch": 22, "stand_abw": 23, "status": 8, "wka_id": 24}, "renameByName": {}}}], "type": "geomap"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "1999-12-31T23:00:00.000Z", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Windanlagen", "uid": "1jeaxYy4z", "version": 7, "weekStart": ""}}