#1 Updated by Giulio Di Anastasio about 5 years ago
- Target version set to poll
- Assignee set to Philippe May
I was thinking about the dry wells issue.
If we add a column with only YES or NOT saying if the well is dry or not, it will not sort out the problem, because it is not a dynamic value. Unless we put a condition like "if the well water level is higher than x, then there should be a sort of Red Alert saying" The well is dry!!" Still I cannot imagine how to represent in a graph something like this, maybe a text oriented in vertical shape as the graph bar, or may be with a different color. If the color might be the way, then we can possibly change the fuchsia color which is the default now, change it in blue, and keep the red for the dry well.
What do you think about all this?
I hope I am not wasting your time
Waiting for your kind revert
#2 Updated by Philippe May about 5 years ago
2 different things: the data and the presentation.
About data: your idea of max (or, rather, min) level is interesting.
If i understood well, it could be, for example, a "depth" attribute in the well's table. If the level is more (or less) than the depth, then it means that it's dy.
Sounds promising, but with some possible issue: if the depth of the well changes, the basic logic of determining the dryness would break for the level recorded previous to that change.
=> to be discussed.
About the presentation:
- the values put in the graph are computed from the database, including the "dryness" logic
- its visual aspect fine tuned (to the extend of the graphic library).
In short: the presentation will come afterwards, and depends on the data design choices.
#3 Updated by Giulio Di Anastasio about 5 years ago
yes, we can use the depth data of the well to give the condition for the dry well. I should have the depth data already sorted out, I will send you tomorrow (hopefully).
About the presentation, meaning the graphics, we can see it and discuss
Did you see my post on weather station?
#4 Updated by Philippe May about 5 years ago
If we consider that the depth of a well is fixed once for all, then it's fine.
But, if the depth might be changed (for whatever reason: more drilling, etc), then we should consider the "dry" boolean attribute, with a tick box in the interface.
- today 22/3/2017: the reading is 50m, and the depth is 50m
> dry. tomorrow 23/3/2017: the well is drilled deeper, to 100m . The problem: the reading for the 22/3/2017 would be: there was 50m of water available in the well, which was not true.