{"id":2095,"date":"2022-01-20T20:20:40","date_gmt":"2022-01-20T19:20:40","guid":{"rendered":"https:\/\/www.pa3hcm.nl\/?p=2095"},"modified":"2022-01-20T20:25:14","modified_gmt":"2022-01-20T19:25:14","slug":"ecowither-logging-ecowitt-weather-data-to-influxdb","status":"publish","type":"post","link":"https:\/\/www.pa3hcm.nl\/?p=2095","title":{"rendered":"Ecowither: logging Ecowitt weather data to InfluxDB"},"content":{"rendered":"\n
\"\"<\/a><\/figure><\/div>\n\n\n\n

Last summer my old WS2300 weather station finally gave up, after 15 years of service. So I bought a new one, the Waldbeck Halley Professional Weather Station<\/em> (also known as WH2650A-WIFI6C6F). This device can log some data (basic outdoor measurements) to online weather services (Wunderground, WeatherCloud, WOW, etc). However, I wanted my data stored locally, also to allow me to browse and publish the data my own way. The vendor does not publish software for this purpose, so I had to code it myself.<\/p>\n\n\n\n\n\n\n\n

\"\"<\/a>
WSview configuration screen to log to a custom weather service<\/figcaption><\/figure><\/div>\n\n\n\n

The new weather station has an option to post data to a webserver (API). It supports two formats: Wunderground and Ecowitt. I studied both formats and found out that the Wunderground format only reports basic weather data and does not include data of additional sensors. The Ecowitt protocol however reports really all measurements registered by the station, so Ecowitt is the way to go.<\/p>\n\n\n\n

The Ecowitt protocol posts data to a weather service using a HTTP POST command. I built a very simple webserver to capture the POST statement, this is how it looks like:<\/p>\n\n\n\n

POST \/ HTTP\/1.1\nHOST: localhost\nConnection: Close\nContent-Type: application\/x-www-form-urlencoded\nContent-Length:537 \nPASSKEY=307826236D0133E06009CE7FAFBBAFC4&stationtype=WH2650A_V1.6.8&dateutc=2021-12-24+11:31:57&tempinf=66.0&humidityin=51&baromrelin=29.565&baromabsin=29.565&tempf=47.8&humidity=91&winddir=261&windspeedmph=8.95&windgustmph=14.76&maxdailygust=21.70&solarradiation=57.25&uv=0&rainratein=0.000&eventrainin=0.071&hourlyrainin=0.000&dailyrainin=0.012&weeklyrainin=0.110&monthlyrainin=1.421&yearlyrainin=24.256&totalrainin=24.256&temp1f=49.46&humidity1=98&temp2f=63.50&humidity2=51&wh65batt=0&wh25batt=0&batt1=0&batt2=0&freq=868M&model=WH2650<\/pre>\n\n\n\n
Although I’m most familiar with MySQL\/MariaDB databases, I decided to use InfluxDB. This is a “time series database” and should easier handle the measurements than a SQL database. Also, InfluxDB v2 has some builtin reporting functions, including a nice dashboard. Also, it is very easy to link Grafana to InfluxDB and create even fancier dashboards!<\/p>\n\n\n\n
There was still one piece missing: the API\/webserver to catch the HTTP POST’s from the weather station and store the data into InfluxDB. This was the right moment to start experimenting with Flask. This is a web framework for Python and allows you to build an API in just a few lines of code. You basically define URL’s and attach code to each URL. In my case, some metrics had to be converted too: rain in mm instead of inches, temperatures in Celsius instead of Fahrenheit. I named my program ‘Ecowither’, which is a conjunction of ‘Ecowitt’ and ‘Weather’.<\/p>\n\n\n\n
I published my code on Github<\/a>. The repository also includes a kubernetes deployment file, since I run both Ecowither and InfluxDB on my Kubernetes cluster.<\/p>\n\n\n\n
\"\"<\/a>
Example of my weather data in InfluxDB, showing the air shockwave caused by a vulcano erruption near Tonga, on January 15th 2022.<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"
Last summer my old WS2300 weather station finally gave up, after 15 years of service. So I bought a new one, the Waldbeck Halley Professional Weather Station (also known as WH2650A-WIFI6C6F). This device can log some data (basic outdoor measurements) to online weather services (Wunderground, WeatherCloud, WOW, etc). However, I wanted my data stored locally, […]<\/p>\n","protected":false},"author":1,"featured_media":2098,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[105,104,106],"class_list":["post-2095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software","tag-flask","tag-python","tag-weather"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/posts\/2095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2095"}],"version-history":[{"count":3,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/posts\/2095\/revisions"}],"predecessor-version":[{"id":2103,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/posts\/2095\/revisions\/2103"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=\/wp\/v2\/media\/2098"}],"wp:attachment":[{"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pa3hcm.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}