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] _
)>>

  • Damn clients! :-) Have you thought of creating a landscape log (if it's not landscape already) You loose m/page but you get extra width, so you could squeeze in separate columns for each piezos average / min / max water levels all on a "normal" log style. If you go to A3 landscape you have loads of space to play with. I've made quite a few A3 Landscape logs for various clients and they tend to look really good. A bit of extra work to fold them into the printed report, but...
    Miles
  • Hi Miles

    Thanks for the response.

    I'm with you on this one - its not my preferred way of doing things! I'd prefer to graph all of the monitoring data - average is pretty misleading by itself. Client rules though - and what they request.....!
  • 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. )