I have a site with a large number of boreholes and I need to assess the depth to a certain SPT value at each borehole across the site to zone it. Is it possible to create a query to identify the depth at each point and output this as a the labels on a site map to enable me to visualise it? I am a relative novice to gINT but I know that this kind of thing is possible with HoleBASE for eg creating plans showing contamination exceedances etc so feel this should be possible - if only I could work out how!
If this is possible, could anyone write the SQL for me to copy and paste in? And give me some step by step instructions.
Not knowing your data structure it is difficult to give you a specific solution. However the general procedure would be as follows:
Create a graph report with <<Point.East>> set as the Independent data (X axis) and <<Point.North>> set as the dependent data (Y-axis). This will plot your borings in a simple x-y plot. You can control the data markers as much as you want.
Then in the data postings tab of the graph entity add a line for the boring number <<Point.PointID>> at 12:00 and a line for:
<<Min(<<SAMPLE.Depth>>,<<SAMPLE.SPTN>> >= 50)>> at 6:00
This will plot the boring number above the point and the depth to the first SPTN value that is greater than or equal to 50 below the sample. You can get fancier if you want. See example below.
Note that the expressions used are based on my data structure, table names, and field names. Yours are likely different and you will have to modify the expressions accordingly. Further, if you need to calculate the SPTN from other fields (rather than reading it directly from a single field) the above simple aggregate function will have to be replaced with a Sql function. If this is not what you are looking for please clarify your question.
Answer Verified By: Sue D'Nymm
Thanks. That's perfect. Took me a bit of playing around with the parameters in the properties and working out the expressions required but got there in the end. I KNEW there must be a way!