hass-weatherflow2mqtt
hass-weatherflow2mqtt copied to clipboard
Published
20 hours ago •
briis
briis
No high/low-values (sqlite & NoneType)
Home Assistant Version?
2022.4.5
Add-On or Self Hosted?
HA Supervised (Add-On)
Weatherflow2MQTT version?
3.0.7
What happened?
Hi,
I experience the same as #103. Fresh install of both HA (Supervised) and weatherflow2mqtt.
I can, of course, delete the database (as was done in #103), but since this is a fresh install, I feel that this should have worked "out of the box"... maybe we should find the root cause and fix it?
Relevant log output
INFO:weatherflow2mqtt.weatherflow_mqtt:🏠 Home Assistant Supervisor Mode 🏠
INFO:weatherflow2mqtt.weatherflow_mqtt:Timezone is Europe/Oslo
INFO:weatherflow2mqtt.weatherflow_mqtt:Connected to the MQTT server at core-mosquitto:1883
INFO:weatherflow2mqtt.weatherflow_mqtt:The UDP server is listening on port 50222
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Hub sensor: Status
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Status
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Absolute Humidity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Air Density
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Voltage
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Battery
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Battery Mode
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Beaufort Scale
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Cloud Base Altitude
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Delta T
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Dew Point
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Dewpoint Comfort Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Feels Like Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Freezing Level Altitude
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Illuminance
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (Last hour)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (3 hours)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (Today)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Distance
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Energy
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Last Lightning Strike
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Precipitation Type
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Pressure Trend
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Duration (Today)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Duration (Yesterday)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Intensity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Rate
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Last Rain start
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Today
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Yesterday
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Humidity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Sea Level Pressure
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Solar Radiation
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Station Pressure
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Temperature Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: UV Index
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: UV Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Visibility
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wet Bulb Globe Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wet Bulb Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Bearing
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Bearing Avg
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Direction
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Direction Avg
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Gust
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Lull
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Speed
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Speed Avg
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
The logs had wrapped around, and everything in it was that error line. Maybe it would be a good idea to add timestamp to the logs? (so you could know without having to restart it).
Seems to happen after a restart, at least. This is the log fresh after a restart;
INFO:weatherflow2mqtt.weatherflow_mqtt:🏠 Home Assistant Supervisor Mode 🏠
INFO:weatherflow2mqtt.weatherflow_mqtt:Timezone is Europe/Oslo
INFO:weatherflow2mqtt.weatherflow_mqtt:Connected to the MQTT server at core-mosquitto:1883
INFO:weatherflow2mqtt.weatherflow_mqtt:The UDP server is listening on port 50222
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Hub sensor: Status
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Status
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Absolute Humidity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Air Density
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Voltage
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Battery
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Battery Mode
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Beaufort Scale
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Cloud Base Altitude
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Delta T
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Dew Point
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Dewpoint Comfort Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Feels Like Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Freezing Level Altitude
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Illuminance
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (Last hour)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (3 hours)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Count (Today)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Distance
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Lightning Energy
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Last Lightning Strike
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Precipitation Type
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Pressure Trend
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Duration (Today)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Duration (Yesterday)
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Intensity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Rate
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Last Rain start
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Today
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Rain Yesterday
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Humidity
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Sea Level Pressure
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Solar Radiation
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Station Pressure
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Temperature Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: UV Index
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: UV Level
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Visibility
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wet Bulb Globe Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wet Bulb Temperature
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Bearing
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Bearing Avg
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Direction
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Direction Avg
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Gust
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Lull
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Speed
INFO:weatherflow2mqtt.weatherflow_mqtt:Setting up Tempest sensor: Wind Speed Avg
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
Do you have all the sensors showing up in HA? Can you tell if any of the High/Low data is not available (i.e. which sensor)? Just trying to narrow things down.
I have 1 device + 1 entity for the hub (status). I have 1 device + 49 entities for the station.
That corresponds with the logs, at least (50 sensors in total). I assume this is default/correct amount?
The hub has "status 3 months ago", but that seems to be when it was initially set up, and does not change?
I see values for all of the 49 station sensors. Some of them has 0 as value (lightning count etc), but that is expected.
Is there an easy way to spot missing high/low data for all of the sensors? I know I can get them from the statistics sensor using value_min and value_max, but somewhat cumbersome to check all sensors that way.
Number of entries checks out.
The easiest way (unless you already have a card setup with attributes) is to look at the dev tools for each of the sensors listed for High/low and see if you have those hi/low attributes: Sensor | high value| low value air_temperature | Yes | Yes dewpoint | Yes | Yes illuminance | Yes | No lightning_strike_count_today | Yes | No lightning_strike_energy | Yes | No rain_rate | Yes | No rain_duration_today | Yes | No relative_humidity | Yes | Yes sealevel_pressure | Yes | Yes solar_radiation | Yes | No uv | Yes | No wind_gust | Yes | No wind_lull | Yes | No wind_speed_avg | Yes | No
See if you are missing any of the above. This might take some time but I'm curious as to what is not recording (if anything).
Sorry, had some busy weeks. Uhm, I'm not that familiar with HA yet, so not sure where I would find those high/low values within HA?
"Developer Tools" -> "States / Entities" had no useful info.
Going to the "Attributes" section of the entities, shows some more, but not the "high/low value" as you show in your example;
Ok, so at least it is picking up the MQTT auto generate for the attributes but it is not getting the data. Have you tried the 'debug' tag to get more information? @briis Any thoughts?
Sorry for the long delay, also I have been busy (New job). This is back to the local WF2MQTT database, that for some reason has some invalid data. The best thing is to delete the database and then restart WF2MQTT to let it be reinitiated.
I hope I can find time this some to find a more stabile approach to this - long term stats in HA might be the solution, thus avoiding the database at all, but I think most people will need some help on how to get the data - so I need to spend some time on that.
@GlennGoddard, I have not done any changes (nor deleted any databases) since this issue was opened. The issue seems to be still present;
The goal for this issue, at least from my point of view, would be to avoid the need to manually delete the database to fix it (especially since there has been several reported cases of the same problem).
Brand new install on a supervised x86:
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
ERROR:weatherflow2mqtt.sqlite:Could not write to High and Low Table. Error message: '>' not supported between instances of 'float' and 'NoneType'
Will try deleting db
Found a workaround if you don't want to nuke your database. Can be further adjusted if only certain high/low values are affected by this bug.
- Create backups and whatever other precautions needed
- Stop the weatherflow2mqtt add-on
- Copy
/mnt/data/supervisor/addons/data/67f4b1af_weatherflow2mqtt/weatherflow2mqtt.dbfrom the host to somewhere where you can modify it (as neither the container nor the host hassqlite3command line utilities) - Execute the following queries against the database (adjust timestamp if needed, the one in example equals to "19 April 2022 at 00:00:58");
UPDATE high_low
SET latest = NULL ,
max_day_time = '1650319257.78299' ,
min_day_time = '1650319257.78299' ,
max_yday_time = '1650319257.78299' ,
min_yday_time = '1650319257.78299' ,
max_week_time = '1650319257.78299' ,
min_week_time = '1650319257.78299' ,
max_month_time = '1650319257.78299' ,
min_month_time = '1650319257.78299' ,
max_year_time = '1650319257.78299' ,
min_year_time = '1650319257.78299' ,
max_all_time = '1650319257.78299' ,
min_all_time = '1650319257.78299' ;
UPDATE high_low
SET max_day = 0 , min_day = 0 , max_yday = 0 , min_yday = 0 ,
max_week = 0 , min_week = 0 , max_month = 0 , min_month = 0 ,
max_year = 0 , min_year = 0 , max_all = 0 , min_all = 0 ;
UPDATE high_low
SET max_day = -9999 , min_day = 9999 , max_yday = -9999 , min_yday = 9999 ,
max_week = -9999 , min_week = 9999 , max_month = -9999 , min_month = 9999 ,
max_year = -9999 , min_year = 9999 , max_all = -9999 , min_all = 9999
WHERE sensorid = 'dewpoint' OR
sensorid = 'relative_humidity' OR
sensorid = 'sealevel_pressure' OR
sensorid = 'air_temperature' ;
- Copy the modified database back
- Start the weatherflow2mqtt add-on
- Success!
I do not know why it works to delete the whole database. Maybe there is a difference between re-initializing the database after installation, compared to during installation?
Also, it might not be needed to set all the columns to sane values like I did above (as initializeHighLow seems to only set max_day and min_day).
I do not know what a "clean" database looks like, but my broken high_low table before above "fix" looks like this;
sensorid latest max_day max_day_time min_day min_day_time max_yday max_yday_time min_yday min_yday_time max_week max_week_time min_week min_week_time max_month max_month_time min_month min_month_time max_year max_year_time min_year min_year_time max_all max_all_time min_all min_all_time
---------------------------- ------ ------- ---------------- ------- ---------------- -------- ---------------- -------- ---------------- -------- ---------------- -------- ---------------- --------- ---------------- --------- ---------------- -------- ---------------- -------- ---------------- ------- ------------ ------- ----------------
dewpoint NULL NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 -9999.0 NULL NULL 1650319257.78299
relative_humidity NULL NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 -9999.0 NULL NULL 1650319257.78299
illuminance NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
sealevel_pressure NULL NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 -9999.0 NULL NULL 1650319257.78299
rain_duration_today NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
rain_rate NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
solar_radiation NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
lightning_strike_count_today NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
lightning_strike_energy NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
air_temperature NULL NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 NULL 1650319257.78299 -9999.0 NULL NULL 1650319257.78299
uv NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
wind_gust NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
wind_lull NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
wind_speed_avg NULL 0.0 1671922817.90174 0.0 NULL 0.0 1671836401.0727 0.0 NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 1650319257.78305 NULL NULL 0.0 NULL NULL NULL
And after the "fix" it looks like this;
sensorid latest max_day max_day_time min_day min_day_time max_yday max_yday_time min_yday min_yday_time max_week max_week_time min_week min_week_time max_month max_month_time min_month min_month_time max_year max_year_time min_year min_year_time max_all max_all_time min_all min_all_time
---------------------------- ------ ------- ---------------- ------- ---------------- -------- ---------------- -------- ---------------- -------- ---------------- -------- ---------------- --------- ---------------- --------- ---------------- -------- ---------------- -------- ---------------- ------- ---------------- ------- ----------------
dewpoint NULL -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299
relative_humidity NULL -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299
illuminance NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
sealevel_pressure NULL -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299
rain_duration_today NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
rain_rate NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
solar_radiation NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
lightning_strike_count_today NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
lightning_strike_energy NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
air_temperature NULL -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299 -9999.0 1650319257.78299 9999.0 1650319257.78299
uv NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
wind_gust NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
wind_lull NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
wind_speed_avg NULL 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299 0.0 1650319257.78299
