How do I plot average water levels for nested piezometers on a log?

Hi

I have a borehole with multiple standpipe piezometers installed.  Water level data has been collected over a six month period and recorded in the monitoring group and monitoring data tables (MONG & MOND).

We're reporting detailed monitoring data, but also want to display the average, min and max water levels for each standpipe on the borehole log.

I can grab the average for one Monitoring Point easily enough with a SQL query, but I'm not sure of the best approach to display multiple water level graphics.  Individual discrete graphics would be unaware of each other, and would likely overlap - is there a better log type?

Has anyone approached this problem before?

Thanks

<<Sql(SELECT [MONG].[PointID], [MONG].[ItemKey] _
(SELECT AVG([MOND].[MOND_RDNG]) FROM [MOND] WHERE [MOND].[ItemKey] = [MONG].[ItemKey] AND [MOND].[PointID] = <<CurrSetKey>>) as avg_reading _
FROM [MONG] _
)>>

Parents
  • To be honest, I wouldn't be using a standard BH Log to show that type of info. As you say, the symbols are likely to overlap and make the info very unclear. I would be inclined to knock up a custom log with just depth, strata description and maybe a column for each piezo with the average, min & max water level symbols showing. It could be a smart log, dividing the space up for the piezo columns by counting the piezos. You could have a table at the bottom of the log showing the Min, Ave & Max values for each piezo. Output your BH log and then your "Piezo" log following it (Output to PDF, appending as you go, building up BH Log, Piezo Log, BH Log Piezo Log etc. )
Reply
  • To be honest, I wouldn't be using a standard BH Log to show that type of info. As you say, the symbols are likely to overlap and make the info very unclear. I would be inclined to knock up a custom log with just depth, strata description and maybe a column for each piezo with the average, min & max water level symbols showing. It could be a smart log, dividing the space up for the piezo columns by counting the piezos. You could have a table at the bottom of the log showing the Min, Ave & Max values for each piezo. Output your BH log and then your "Piezo" log following it (Output to PDF, appending as you go, building up BH Log, Piezo Log, BH Log Piezo Log etc. )
Children