Feature #3803

Dry Wells

Added by Giulio Di Anastasio about 5 years ago. Updated about 5 years ago.

Target version:
Start date:
Due date:
% Done:


Spent time:

Related issues

Duplicates Gisaf - Feature #3790: Dry Wells Closed 18/03/2017


#1 Updated by Giulio Di Anastasio about 5 years ago

  • Target version set to poll
  • Assignee set to Philippe May

Dear Philippe,
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

Dear Philippe,
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.

For example:
- 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.

#5 Updated by Philippe May about 5 years ago

#6 Updated by Philippe May about 5 years ago

  • Status changed from New to Closed

Also available in: Atom PDF