Same goes when records come from WLLDriver, same mismatch in rounding/conversion
mysql> select from_unixtime(weewx.archive.datetime),weewx.archive.outtemp,weewxtest.archive.outtemp,weewx.archive.windspeed,weewxtest.archive.windspeed from weewx.archive,weewxtest.archive where weewx.archive.datetime=weewxtest.archive.datetime and from_unixtime(weewx.archive.datetime) like '2020-07-07 12%' and weewxtest.archive.outtemp > -100 limit 10; +---------------------------------------+--------------------+--------------------+-----------+--------------------+ | from_unixtime(weewx.archive.datetime) | outtemp | outtemp | windspeed | windspeed | +---------------------------------------+--------------------+--------------------+-----------+--------------------+ | 2020-07-07 12:00:00 | 16.77777777777778 | 16.72 | 4.4704 | 4.729354838709677 | | 2020-07-07 12:01:00 | 16.72222222222222 | 16.714444444444446 | 4.02336 | 4.171818181818182 | | 2020-07-07 12:02:00 | 16.72222222222222 | 16.69142857142857 | 4.02336 | 4.038064516129032 | | 2020-07-07 12:03:00 | 16.72222222222222 | 16.67 | 4.4704 | 4.577878787878787 | | 2020-07-07 12:04:00 | 16.72222222222222 | 16.67 | 3.57632 | 3.422812499999999 | | 2020-07-07 12:05:00 | 16.666666666666668 | 16.655 | 3.57632 | 3.7718749999999988 | | 2020-07-07 12:06:00 | 16.72222222222222 | 16.661428571428573 | 4.02336 | 3.648064516129032 | | 2020-07-07 12:07:00 | 16.77777777777778 | 16.69222222222222 | 4.4704 | 4.321515151515152 | | 2020-07-07 12:08:00 | 16.88888888888889 | 16.7975 | 4.02336 | 4.036875 | | 2020-07-07 12:09:00 | 17 | 16.9 | 4.91744 | 4.638125000000001 | +---------------------------------------+--------------------+--------------------+-----------+--------------------+ 10 rows in set (1.92 sec) Op dinsdag 7 juli 2020 12:10:45 UTC+2 schreef Maarten van der Hoeven: > > Did testing with WLLArchive. > > WLLArchive is picking up archived records, just from the point where > records are missing.Thats good. I've stopped weewx for two days (weewxtest > in my case, not production), and Weatherlink.com is queried to get the > missing records. > > I see in mysql there's a mismatch in rounding, or perhaps typecasting > between float and double. The first column (outtemp, windspeed) is from my > production database (which I consider as correct, as this driver is live > for several years now), the second column (outtemp, windspeed) is from my > test-enviroment. Records shown are coming from WLLArchive. Maybe, not sure, > this rounding-mismatched is cause by calculating temp (F->C) and windspeed > (mph->m/s) within the driver itself (float? double?), instead of letting > weewx doing the conversion. Whatever the case, I would prefer to skip the > conversion withing the driver, and make use of the weewx-tooling thats > available for unit-conversions. That makes is more stable, like, for > example, I decided in the future to report my windspeed in km/h in stead of > m/s. Now it's fixed in the driver to m/s, when using metricwx > > mysql> select > from_unixtime(weewx.archive.datetime),weewx.archive.outtemp,weewxtest.archive.outtemp,weewx.archive.windspeed,weewxtest.archive.windspeed > > from weewx.archive,weewxtest.archive where > weewx.archive.datetime=weewxtest.archive.datetime and > from_unixtime(weewx.archive.datetime) like '2020-07-07%' and > weewxtest.archive.outtemp > -100 limit 10; > > +---------------------------------------+--------------------+---------+-----------+-----------+ > | from_unixtime(weewx.archive.datetime) | outtemp | outtemp | > windspeed | windspeed | > > +---------------------------------------+--------------------+---------+-----------+-----------+ > | 2020-07-07 00:00:00 | 11.38888888888889 | 11.33 | > 1.34112 | 1.39 | > | 2020-07-07 00:05:00 | 11.38888888888889 | 11.33 | > 1.34112 | 1.2 | > | 2020-07-07 00:10:00 | 11.38888888888889 | 11.33 | > 1.34112 | 1.53 | > | 2020-07-07 00:15:00 | 11.333333333333334 | 11.28 | > 1.34112 | 1.62 | > | 2020-07-07 00:20:00 | 11.333333333333334 | 11.28 | > 1.34112 | 1.26 | > | 2020-07-07 00:25:00 | 11.277777777777777 | 11.22 | > 0.89408 | 0.92 | > | 2020-07-07 00:30:00 | 11.222222222222223 | 11.17 | > 0.89408 | 1.09 | > | 2020-07-07 00:35:00 | 11.166666666666666 | 11.11 | > 1.34112 | 1.26 | > | 2020-07-07 00:40:00 | 11.11111111111111 | 11.06 | > 1.34112 | 1.23 | > | 2020-07-07 00:45:00 | 11.11111111111111 | 11.06 | > 1.34112 | 1.28 | > > +---------------------------------------+--------------------+---------+-----------+-----------+ > 10 rows in set (0.88 sec) > > > Op zondag 5 juli 2020 12:06:24 UTC+2 schreef [email protected]: >> >> Hi, >> >> Yes I see. I put speed 2min on current_conditions, and UDP packet, it's >> speed 10min. >> >> I fix it. >> Thank's a lot. >> >> Le dimanche 5 juillet 2020 à 01:17:44 UTC+2, [email protected] a écrit : >> >>> Updated the driver, thanks for that. Windspeed/-gust is much better now. >>> However, I see some differences in the windgust, when it is within a >>> UDP-packet and when it's within a current-condition-packet. Some piece of >>> syslog, where I highlighted the difference in values. For what I >>> understand, windgust is the max speed that occured in the last 2 minutes. >>> So I expect it to be the same when it's getting reported by UDP and >>> current-conditions, at least within a timespan of two minutes... >>> >>> Jul 5 01:10:23 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904223, 'usUnits': 17, 'outTemp': 18.11, >>> 'outHumidity': 97.0, 'dewpoint': 17.61, 'heatindex': 19.06, 'windchill': >>> 17.17, 'windSpeed': 3.58, 'windDir': 229, '*windGust': 6.71*, >>> 'windGustDir': 224, 'barometer': 1009.89, 'pressure': 1009.49, 'rain': 0.0, >>> 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity': 71.1, 'inDewpoint': 16.06}: >>> Jul 5 01:10:23 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:23 CEST (1593904223) >>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904225, 'usUnits': 17, 'windSpeed': 4.02, >>> 'windDir': 229,* 'windGust': 7.15,* 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:26 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:25 CEST (1593904225) >>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904228, 'usUnits': 17, 'windSpeed': 5.36, >>> 'windDir': 217, *'windGust': 7.15**,* 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:28 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:28 CEST (1593904228) >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904230, 'usUnits': 17, 'windSpeed': 5.81, >>> 'windDir': 232, 'windGust': 7.15, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG urllib3.connectionpool: >>> Starting new HTTP connection (1): 192.168.2.33:80 >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG urllib3.connectionpool: >>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200 None >>> Jul 5 01:10:31 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:30 CEST (1593904230) >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904230, 'usUnits': 17, 'outTemp': 18.11, >>> 'outHumidity': 97.0, 'dewpoint': 17.61, 'heatindex': 19.06, 'windchill': >>> 17.17, 'windSpeed': 5.81, 'windDir': 232,* 'windGust': 6.71*, >>> 'windGustDir': 224, 'barometer': 1009.89, 'pressure': 1009.49, 'rain': 0.0, >>> 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity': 71.1, 'inDewpoint': 16.06}: >>> Jul 5 01:10:31 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:30 CEST (1593904230) >>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904233, 'usUnits': 17, 'windSpeed': 5.36, >>> 'windDir': 225, *'windGust': 7.15*, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:33 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:33 CEST (1593904233) >>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904235, 'usUnits': 17, 'windSpeed': 4.02, >>> 'windDir': 225, *'windGust': 7.15*, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:36 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:35 CEST (1593904235) >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904238, 'usUnits': 17, 'windSpeed': 3.58, >>> 'windDir': 227, *'windGust': 7.15*, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG urllib3.connectionpool: >>> Starting new HTTP connection (1): 192.168.2.33:80 >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG urllib3.connectionpool: >>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200 None >>> Jul 5 01:10:38 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:38 CEST (1593904238) >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904238, 'usUnits': 17, 'outTemp': 18.11, >>> 'outHumidity': 96.9, 'dewpoint': 17.61, 'heatindex': 19.06, 'windchill': >>> 17.17, 'windSpeed': 3.58, 'windDir': 227, *'windGust': 6.71*, >>> 'windGustDir': 224, 'barometer': 1009.89, 'pressure': 1009.49, 'rain': 0.0, >>> 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity': 71.1, 'inDewpoint': 16.06}: >>> Jul 5 01:10:38 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:38 CEST (1593904238) >>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904240, 'usUnits': 17, 'windSpeed': 3.58, >>> 'windDir': 227,* 'windGust': 7.15*, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:41 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:40 CEST (1593904240) >>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this >>> period: 0.0 >>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Set Previous >>> period rain to: 3 >>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet received >>> from WLL module {'dateTime': 1593904243, 'usUnits': 17, 'windSpeed': 3.58, >>> 'windDir': 213,* 'windGust': 7.15*, 'windGustDir': 249, 'rain': 0.0, >>> 'rainRate': 0.0}: >>> Jul 5 01:10:43 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published >>> record 2020-07-05 01:10:43 CEST (1593904243) >>> >>> >>> Op zaterdag 4 juli 2020 om 18:09:42 UTC+2 schreef [email protected]: >>> >>>> Thank you ! >>>> >>>> I'm very stupid ahah, this is an error that I put on code ! I push to >>>> my git a fix to windSpeed and windGust. >>>> >>>> For others sensors, I make this change this we. >>>> >>>> Le samedi 4 juillet 2020 à 17:41:33 UTC+2, [email protected] a écrit : >>>> >>>>> Jul 4 17:39:37 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet >>>>> received from WLL module {'dateTime': 1593877175, 'usUnits': 17, >>>>> 'windSpeed': 5.36, 'windDir': 210, 'windGust': 8.05, 'windGustDir': 211, >>>>> 'rain': 0.0, 'rainRate': 0.0}: >>>>> Jul 4 17:39:37 ubuntu weewx[20924] INFO weewx.restx: MQTT: Published >>>>> record 2020-07-04 17:39:35 CEST (1593877175) >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain this >>>>> period: 0.0 >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Set Previous >>>>> period rain to: 0 >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet >>>>> received from WLL module {'dateTime': 1593877178, 'usUnits': 17, >>>>> 'windSpeed': 4.47, 'windDir': 217, 'windGust': 8.05, 'windGustDir': 211, >>>>> 'rain': 0.0, 'rainRate': 0.0}: >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG urllib3.connectionpool: >>>>> Starting new HTTP connection (1): 192.168.2.33:80 >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG urllib3.connectionpool: >>>>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200 None >>>>> Jul 4 17:39:40 ubuntu weewx[20924] INFO weewx.restx: MQTT: Published >>>>> record 2020-07-04 17:39:38 CEST (1593877178) >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain this >>>>> period: 0.0 >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Set Previous >>>>> period rain to: 0 >>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet >>>>> received from WLL module {'dateTime': 1593877178, 'usUnits': 17, >>>>> 'outTemp': >>>>> 17.33, 'outHumidity': 93.3, 'dewpoint': 16.22, 'heatindex': 18.06, >>>>> 'windchill': 15.72, 'windSpeed': 10.0, 'windDir': 217, 'windGust': 14.0, >>>>> 'windGustDir': 213, 'barometer': 1012.67, 'pressure': 1012.26, 'rain': >>>>> 0.0, >>>>> 'rainRate': 0.0, 'inTemp': 22.61, 'inHumidity': 63.2, 'inDewpoint': >>>>> 15.28}: >>>>> Jul 4 17:39:40 ubuntu weewx[20924] INFO weewx.restx: MQTT: Published >>>>> record 2020-07-04 17:39:38 CEST (1593877178) >>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain this >>>>> period: 0.0 >>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Set Previous >>>>> period rain to: 0 >>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet >>>>> received from WLL module {'dateTime': 1593877180, 'usUnits': 17, >>>>> 'windSpeed': 4.47, 'windDir': 204, 'windGust': 8.05, 'windGustDir': 211, >>>>> 'rain': 0.0, 'rainRate': 0.0}: >>>>> Jul 4 17:39:42 ubuntu weewx[20924] INFO weewx.restx: MQTT: Published >>>>> record 2020-07-04 17:39:40 CEST (1593877180) >>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain this >>>>> period: 0.0 >>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Set Previous >>>>> period rain to: 0 >>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet >>>>> received from WLL module {'dateTime': 1593877183, 'usUnits': 17, >>>>> 'windSpeed': 3.58, 'windDir': 214, 'windGust': 8.05, 'windGustDir': 211, >>>>> 'rain': 0.0, 'rainRate': 0.0}: >>>>> Jul 4 17:39:45 ubuntu weewx[20924] INFO weewx.restx: MQTT: Published >>>>> record 2020-07-04 17:39:43 CEST (1593877183) >>>>> >>>>> MySQL-output latest 5 records >>>>> mysql> select >>>>> datetime,from_unixtime(datetime),outtemp,windspeed,windgust,radiation,uv,et,rain,extratemp1 >>>>> >>>>> from archive order by datetime desc limit 5; >>>>> >>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+ >>>>> >>>>> | datetime | from_unixtime(datetime) | outtemp | >>>>> windspeed | windgust | radiation | uv | et | rain | >>>>> extratemp1 | >>>>> >>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+ >>>>> | 1593877200 | 2020-07-04 17:40:00 | 17.33 | >>>>> 5.195454545454546 | 14 | NULL | NULL | NULL | 0 | >>>>> NULL | >>>>> | 1593877140 | 2020-07-04 17:39:00 | 17.30857142857143 | >>>>> 4.514193548387096 | 15 | NULL | NULL | NULL | 0 | >>>>> NULL | >>>>> | 1593877080 | 2020-07-04 17:38:00 | 17.33 | >>>>> 6.058125000000001 | 15 | NULL | NULL | NULL | 0 | >>>>> NULL | >>>>> | 1593877020 | 2020-07-04 17:37:00 | 17.33 | >>>>> 6.1765625 | 17 | NULL | NULL | NULL | 0 | NULL | >>>>> | 1593876960 | 2020-07-04 17:36:00 | 17.33 | >>>>> 6.4096875 | 18 | NULL | NULL | NULL | 0 | NULL | >>>>> >>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+ >>>>> >>>>> 5 rows in set (0.00 sec) >>>>> >>>>> >>>>> >>>>> Op zaterdag 4 juli 2020 om 15:40:52 UTC+2 schreef [email protected]: >>>>> >>>>>> Hm it's strange because you show that the packet including value for >>>>>> Wind and Rain.... >>>>>> >>>>>> On syslog, can you share packet where all sensor are display. >>>>>> >>>>>> Thank you >>>>>> >>>>>> -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/3808d60f-9ffd-479b-9006-fd59287bb0f8o%40googlegroups.com.
