Visualize Groundwater Levels and Depth Annotations in Profile View

[RDWimmers]

I want to generate a profile view that renders groundwater levels alongside numerical depth annotations, So that I can see water table's behavior relative to the ground surface and geological layers.

make Column object except the water filter top and bottom.

[HMEUW]

Groundwater levels are time dependent. GeoProfile is not time dependent at the moment.

Suggestion is that in GeoProfile option is included to plot the layout of standpipes (top of standpipe, filter screen, sand trap). That is time independent information. Optionally charateristics of time series can be added, when user pre-processes this. E.g. mean, seasonal characteristics. When user wants to add time dependency to the plot, that is outside the scope of GeoProfile. GeoProfile can facilitiate further analysis.

Suggested workflow is that user pre-processes groundwater observations using HydroPandas, e.g. by downloading data from Broloket. HydroPandas uses a Observation Collection as data format. It is a Pandas DataFrame with on each row all meta-information of the standpipe and a column called 'obs' that holds timeseries of the observation well. Suggestion is that the user adds columns to the Observation Collection with statistics to plot, e.g. mean, winter and summer groundwater level. User saves Observation Collection as pandas DataFrame and leaves out the 'obs' column with the timeseries.

Suggestion for columns in DataFrame as input to GeoProfile: name (index, usually location-tube_nr), x, y, location (usally the bro_id, so equal for all tubes), tube_nr, screen_top, screen_bottom, ground_level, tube_top, columns starting with gwl_ represent water levels to plot, e.g. gwl_mean, gwl_winter_mean, gwl_summer_mean. See attached CSV.file
df_grondwater.csv

Example of plotting below. The screen is visualized with a vertical line. The average water level is the horizontal line. Both have same color. The blue line represents water level in a deeper filter (not in image).

Suggestion is that in the plotted profile the index of plotted stand pipes and their x on the plot are returned. So they can be used by the user for time dependent fancy afterwards.