CROP

CROP copied to clipboard

For some reason the development database has a factor ~200 more data than the prod one. We should figure out what this is (presumably a mistake, something being written many...

nbarlowATI

Particularly for missing weather data. Could do something along the lines of what is implemented in the ARIMA model. This imputes missing data based on past history.

rmward61

Currently get ``` AttributeError: Can only use .dt accessor with datetimelike values ``` from `File "/CROP/webapp/app/home/routes.py", line 122, in aranet_query`

nbarlowATI

Currently there is a bug that means if you change the number of ACH/ias pairs the code falls over. Also, the code is not calibrating well - additional flexibility to...

rmward61

Sensors that report multiple metrics

1

There are now CO2 sensors that also report T&RH. Our database model can't handle this elegantly. Currently we simply ignore the T&RH data, because we consider the sensor to be...

mhauru

There is probably scope for making the console output of the GES function more useful - at the moment there is a lot of counting (without much indication of how...

nbarlowATI

v3, which we are on, reached end of life in December 2022 and will get no further support: https://learn.microsoft.com/en-us/azure/azure-functions/functions-versions?tabs=v4&pivots=programming-language-csharp

mhauru

Currently we use SQLAlchemy for interactions with the database for the webapp and the ingress functions, but for the Arima and GES models we use psycopg2 and JinjaSQL. This necessitates...

nbarlowATI

In an email on 2022-10-24 Jakob described two kinds of views into crop data that the farm uses in their operations, one a daily view and another one checked weekly....

mhauru

The `zensie_trh_data` tables are still there. Drop 'em?

mhauru