# The workbench

**URL:** https://community.panodata.org/c/workbench/11.md

[Latest](https://community.panodata.org/latest.md) · [Categories](https://community.panodata.org/categories.md) · [Tags](https://community.panodata.org/tags.md)

---

## [About the workbench](https://community.panodata.org/t/about-the-workbench/66)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0

</div>

The collective workbench. We are working with PostGIS, InfluxDB, Grafana and other software for making more sense of data.

---

## [Logbook of code changes](https://community.panodata.org/t/logbook-of-code-changes/16)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 8568\
**Last updated:** [November 21, 2026, 9:45am UTC](https://community.panodata.org/t/logbook-of-code-changes/16 "2026-11-21T09:45:52Z")

</div>

If you are interested in the activities on the Panodata GitHub repositories, please track this thread. We are feeding push notifications from GitHub into Discourse by using the fine GitHub - huw/github-to-discourse: For…

---

## [grafana-import: Import and export Grafana dashboards](https://community.panodata.org/t/grafana-import-import-and-export-grafana-dashboards/295)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [April 25, 2024, 12:30am UTC](https://community.panodata.org/t/grafana-import-import-and-export-grafana-dashboards/295 "2024-04-25T00:30:36Z")

</div>

About grafana-import is a program for elegantly importing and exporting Grafana dashboards using the Grafana HTTP API. It is based on grafana-client, and supports dashboard-as-code workflows. Features Export dashboards…

---

## [Grafana Client migrated from Requests to Niquests](https://community.panodata.org/t/grafana-client-migrated-from-requests-to-niquests/293)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 3\
**Last updated:** [April 5, 2024, 4:46pm UTC](https://community.panodata.org/t/grafana-client-migrated-from-requests-to-niquests/293 "2024-04-05T16:46:41Z")

</div>

Feature Request :bookmark\_tabs: Recently, there was a feature request by Andrea Ghensi about adding async support to the grafana-client library we are maintaining. – https://github.com/panodata/grafana-client/issues/1…

---

## [grafana-wtf](https://community.panodata.org/t/grafana-wtf/67)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 3\
**Last updated:** [March 31, 2024, 3:13pm UTC](https://community.panodata.org/t/grafana-wtf/67 "2024-03-31T15:13:34Z")

</div>

About grafana-wtf is a command-line program for accessing Grafana in ways beyond we have been able to do before. Features Use the Grafana HTTP API to inquire detailed information about what’s inside your Grafa…

---

## [Learning Singer and Meltano](https://community.panodata.org/t/learning-singer-and-meltano/283)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 2\
**Last updated:** [December 13, 2023, 10:39pm UTC](https://community.panodata.org/t/learning-singer-and-meltano/283 "2023-12-13T22:39:08Z")

</div>

Introduction We recently had the pleasure to look into what the lovely people of the Singer and Meltano communities are conceiving. https://www.singer.io/ https://meltano.com/ This article outlines a few struggles w…

---

## [Technical advancements in Sphinx](https://community.panodata.org/t/technical-advancements-in-sphinx/278)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 8\
**Last updated:** [August 2, 2023, 11:42am UTC](https://community.panodata.org/t/technical-advancements-in-sphinx/278 "2023-08-02T11:42:00Z")

</div>

About Coming from recent endeavors aiming to modernize different Sphinx documentation repositories we are maintaining, let me start by reporting about different advancements in the area of the Sphinx documentation gene…

---

## [Plugin updates needed for Grafana 9](https://community.panodata.org/t/plugin-updates-needed-for-grafana-9/248)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [June 1, 2022, 6:46pm UTC](https://community.panodata.org/t/plugin-updates-needed-for-grafana-9/248 "2022-06-01T18:46:50Z")

</div>

Timur Olzhabayev concisely outlines the list of breaking changes which might be relevant for plugins.

---

## [Developing GribMagic](https://community.panodata.org/t/developing-gribmagic/233)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 1\
**Last updated:** [October 28, 2021, 9:32pm UTC](https://community.panodata.org/t/developing-gribmagic/233 "2021-10-28T21:32:22Z")

</div>

Hi there, we would like to write some notes about the GribMagic program, which received some love just recently and finally got published to PyPI a few days ago, see Client Challenge. About Originally conceived by Dani…

---

## [\[WIP\] A hands-on introduction to Wetterdienst](https://community.panodata.org/t/wip-a-hands-on-introduction-to-wetterdienst/224)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 1\
**Last updated:** [October 9, 2021, 12:37pm UTC](https://community.panodata.org/t/wip-a-hands-on-introduction-to-wetterdienst/224 "2021-10-09T12:37:16Z")

</div>

Hi there, following up on the development of https://community.panodata.org/t/wetterdienst-a-new-toolset-for-accessing-weather-data-from-german-weather-service-dwd-based-on-pandas/165, people are asking for a hands-on i…

---

## [»dwdweather2« - a Python client to access weather data from Deutscher Wetterdienst (DWD)](https://community.panodata.org/t/dwdweather2-a-python-client-to-access-weather-data-from-deutscher-wetterdienst-dwd/98)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 1\
**Last updated:** [September 12, 2021, 8:50pm UTC](https://community.panodata.org/t/dwdweather2-a-python-client-to-access-weather-data-from-deutscher-wetterdienst-dwd/98 "2021-09-12T20:50:37Z")

</div>

About Python client to access weather data from Deutscher Wetterdienst (DWD), the federal meteorological service in Germany. https://github.com/panodata/dwdweather2 Installation pip install dwdweather2 Usage See https…

---

## [Panodata Map Panel for Grafana](https://community.panodata.org/t/panodata-map-panel-for-grafana/121)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [December 5, 2019, 2:44pm UTC](https://community.panodata.org/t/panodata-map-panel-for-grafana/121 "2019-12-05T14:44:07Z")

</div>

About The Panodata Map Panel is a map panel for Grafana with improved convenience, robustness, features and under active development. It builds upon the original Grafana Worldmap Panel, integrates different contributi…

---

## [Converting InfluxDB TSM and line protocol formats to Parquet](https://community.panodata.org/t/converting-influxdb-tsm-and-line-protocol-formats-to-parquet/216)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [May 18, 2021, 4:48pm UTC](https://community.panodata.org/t/converting-influxdb-tsm-and-line-protocol-formats-to-parquet/216 "2021-05-18T16:48:38Z")

</div>

Hi there, with the advent of https://github.com/influxdata/influxdb\_iox, there is some sweet tooling which supports different migration and data shoveling scenarios. InfluxDB IOx offers a command line tool to convert b…

---

## [InfluxDB Fetcher - Export data in InfluxDB line protocol format](https://community.panodata.org/t/influxdb-fetcher-export-data-in-influxdb-line-protocol-format/188)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [January 23, 2021, 5:47pm UTC](https://community.panodata.org/t/influxdb-fetcher-export-data-in-influxdb-line-protocol-format/188 "2021-01-23T17:47:30Z")

</div>

About InfluxDB Fetcher is a program to fetch data from InfluxDB using the HTTP query API and export it into InfluxDB line protocol format. It has been conceived by Henri Gomez. Features Export data from InfluxDB in…

---

## [Datetime offset calculations with Flux](https://community.panodata.org/t/datetime-offset-calculations-with-flux/213)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [March 5, 2021, 5:39pm UTC](https://community.panodata.org/t/datetime-offset-calculations-with-flux/213 "2021-03-05T17:39:52Z")

</div>

About @wtf is deeply involved with Flux and found a suggestion at https://community.grafana.com/t/transitioning-from-influxdb-1-x-influxql-to-2-x-flux-query-language/34058/4 about how to optimally perform datetime offset…

---

## [grafanimate](https://community.panodata.org/t/grafanimate/205)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [February 18, 2021, 11:29am UTC](https://community.panodata.org/t/grafanimate/205 "2021-02-18T11:29:48Z")

</div>

About Animate timeseries data with Grafana. Description grafanimate captures screenshots while animating a Grafana dashboard by manipulating its time range control, i.e. navigating through time. The result can be re…

---

## [Air quality information for specific regions](https://community.panodata.org/t/air-quality-information-for-specific-regions/197)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [February 16, 2021, 6:22pm UTC](https://community.panodata.org/t/air-quality-information-for-specific-regions/197 "2021-02-16T18:22:59Z")

</div>

Hi there, in order to receive, process and display air quality information for specific regions, https://community.panodata.org/t/luftdatenpumpe/21 and friends are well suited. Some people interested into that topic ha…

---

## [Luftdatenpumpe Development](https://community.panodata.org/t/luftdatenpumpe-development/196)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [February 16, 2021, 5:51pm UTC](https://community.panodata.org/t/luftdatenpumpe-development/196 "2021-02-16T17:51:12Z")

</div>

Hi there, this topic is dedicated to carry on with the development of https://community.panodata.org/t/luftdatenpumpe/21, originally happening on the Hiveeyes user forum \[1,2,3\]. All contributions are welcome. With ki…

---

## [Flexible Variable Updates for Grafana](https://community.panodata.org/t/flexible-variable-updates-for-grafana/125)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 2\
**Last updated:** [December 6, 2020, 1:32pm UTC](https://community.panodata.org/t/flexible-variable-updates-for-grafana/125 "2020-12-06T13:32:29Z")

</div>

Variable panel @wtf just asked again for a specific feature he would like to see coming to Grafana. Thanks for bringing it up again! Other people also have been asking for things like that. See also: Background We …

---

## [Cross filtering between multiple panels in Grafana](https://community.panodata.org/t/cross-filtering-between-multiple-panels-in-grafana/126)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 3\
**Last updated:** [November 8, 2020, 1:33pm UTC](https://community.panodata.org/t/cross-filtering-between-multiple-panels-in-grafana/126 "2020-11-08T13:33:50Z")

</div>

Introduction Regularly, people are asking about how to implement cross filtering between multiple panels within the same Grafana dashboard.

---

## [Wetterdienst: A new toolset for accessing weather data from German Weather Service (DWD) based on pandas](https://community.panodata.org/t/wetterdienst-a-new-toolset-for-accessing-weather-data-from-german-weather-service-dwd-based-on-pandas/165)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 1\
**Last updated:** [June 11, 2020, 8:08pm UTC](https://community.panodata.org/t/wetterdienst-a-new-toolset-for-accessing-weather-data-from-german-weather-service-dwd-based-on-pandas/165 "2020-06-11T20:08:10Z")

</div>

Best-in-class DWD CDC data access library for Python We just discovered a new gem in the world of data acquisition from DWD CDC using Python.

---

## [Calculate travel-distance from GPS-track with fluxlang](https://community.panodata.org/t/calculate-travel-distance-from-gps-track-with-fluxlang/164)

<div class="topic-metadata">

**Author:** [@wtf](https://community.panodata.org/u/wtf)\
**Replies:** 0\
**Last updated:** [June 8, 2020, 8:46pm UTC](https://community.panodata.org/t/calculate-travel-distance-from-gps-track-with-fluxlang/164 "2020-06-08T20:46:54Z")

</div>

Calculate travel-distance from GPS-track with fluxlang See the demonstration within a Grafana dashboard and this forum-post for discussion. The Haversine formula is used. This query is quite slow. I see paths for improv…

---

## [Experiences migrating from InfluxDB to TimescaleDB/PostgreSQL](https://community.panodata.org/t/experiences-migrating-from-influxdb-to-timescaledb-postgresql/163)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [May 28, 2020, 6:02pm UTC](https://community.panodata.org/t/experiences-migrating-from-influxdb-to-timescaledb-postgresql/163 "2020-05-28T18:02:17Z")

</div>

Others’ thoughts on this very topic resonate with us, so we are linking this here. Enjoy reading.

---

## [Attach annotations and discussions to time-series and other resources to encourage collaborative data analysis](https://community.panodata.org/t/attach-annotations-and-discussions-to-time-series-and-other-resources-to-encourage-collaborative-data-analysis/153)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [January 8, 2020, 11:55am UTC](https://community.panodata.org/t/attach-annotations-and-discussions-to-time-series-and-other-resources-to-encourage-collaborative-data-analysis/153 "2020-01-08T11:55:57Z")

</div>

Annotations with Hypothesis In order to attach out-of-band annotations to resources, we might want to have a look at Hypothesis. Discussions with Discourse For intertwining resources with Discourse, i.e. putting discu…

---

## [Grafana wishlist](https://community.panodata.org/t/grafana-wishlist/72)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 4\
**Last updated:** [December 13, 2019, 3:18pm UTC](https://community.panodata.org/t/grafana-wishlist/72 "2019-12-13T15:18:53Z")

</div>

Over at https://community.hiveeyes.org/t/wunschliste-fur-verbesserungen-in-grafana/1834, we started collecting things we would like to see within Grafana. The topics over there mostly revolved around Grafana Worldmap, ho…

---

## [Developing Panodata Map Panel](https://community.panodata.org/t/developing-panodata-map-panel/122)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 3\
**Last updated:** [December 9, 2019, 12:18pm UTC](https://community.panodata.org/t/developing-panodata-map-panel/122 "2019-12-09T12:18:14Z")

</div>

Introduction Through working on Grafana Map Panel \[1\], we see many opportunities to improve on the aspects of interactive use. The development and requirements within Supporting the Flanders Environment Agency (VMM) by …

---

## [Grafana things worth a look](https://community.panodata.org/t/grafana-things-worth-a-look/89)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 1\
**Last updated:** [November 20, 2019, 6:15pm UTC](https://community.panodata.org/t/grafana-things-worth-a-look/89 "2019-11-20T18:15:08Z")

</div>

Occasionally, we come across different Grafana plugins and addons we would like to try out but wouldn’t find the time then. Sometimes, we find something interesting on the Grafana user forum. So, we are trying to add th…

---

## [Luftdatenpumpe EEA preview](https://community.panodata.org/t/luftdatenpumpe-eea-preview/63)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [November 7, 2019, 10:46pm UTC](https://community.panodata.org/t/luftdatenpumpe-eea-preview/63 "2019-11-07T22:46:09Z")

</div>

luftdatenpumpe stations --network=eea --country=CZ --reverse-geocode --progress --station=CZ0UULM { "station\_id": "CZ0UULM", "station\_namespace": "CZ.CHMI-Prague-Komorany.AQ", "station\_network\_code": "NET-…

---

## [Maintenance of our bare-metal servers](https://community.panodata.org/t/maintenance-of-our-bare-metal-servers/43)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [October 28, 2019, 4:51pm UTC](https://community.panodata.org/t/maintenance-of-our-bare-metal-servers/43 "2019-10-28T16:51:33Z")

</div>

Dear community, we are in the process of giving our bare-metal machines some maintenance. We will Upgrade the Debian OS to its most recent version Debian Buster (10.x) in order to run the most recent software. Tweak s…

---

## [Talking about the Hiveeyes project and some Panodata technologies at the 5th Geospatial Sensor Web Conference in Münster, 3. September 2019](https://community.panodata.org/t/talking-about-the-hiveeyes-project-and-some-panodata-technologies-at-the-5th-geospatial-sensor-web-conference-in-munster-3-september-2019/18)

<div class="topic-metadata">

**Author:** [@Andreas.Motl](https://community.panodata.org/u/Andreas.Motl)\
**Replies:** 0\
**Last updated:** [September 4, 2019, 10:00pm UTC](https://community.panodata.org/t/talking-about-the-hiveeyes-project-and-some-panodata-technologies-at-the-5th-geospatial-sensor-web-conference-in-munster-3-september-2019/18 "2019-09-04T22:00:00Z")

</div>

About We have been invited by the lovely people of 52°North to the 5th Geospatial Sensor Web Conference in Münster to tell a bit about the things we are doing over at https://community.hiveeyes.org/ and https://community…

[Next page](https://community.panodata.org/c/workbench/11.md?page=1)
