• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 33 subscribers
  • Views 2113 views
  • Users 0 members are here

Depths out of order when outputting.

Andrew Mortimer
Offline

Hi All,

I'm having some trouble trying to create a soilbore profile which had a stockpile on top. The stockpile was .45m high AGL, below it was natural ground which was augered to 0.3m BGL. Ideally it'd look something similar to the table below:

Depth - mBGL     |   Lithological Description. 

-0.45 m Stockpile - red
-0.3 m Stockpile - grey
-0.1 m Stockpile - red
Ground level HDPE liner - black
0.2 m Natural sand - blue

To represent the above ground stockpile, I entered the stockpile depths as a negative. This almost worked, except the order of the depths is wrong, it has just sandwiched the -0.45m depth at ground level, in the same cell/box as the -0.1m data. This results in it looking like:

Depth - mBGL     |   Lithological Description. 

-0.3 m Stockpile - grey

-0.1 m

-0.45

Stockpile - red

Stockpile - red
Ground level HDPE liner - black
0.2 m Natural sand - blue

Does anyone know how I can change this so the log appears as it does in the first table? 

Thanks,

Andrew Mortimer

Parents
  • 0 Offline
    I have run into this problem before when dealing with Well Stickup above the ground surface entered as a negative depth. gINT does not properly sort negative depth values when outputting to a graphic report and misplaces text that is associated with a negative depth as you describe. To solve this problem, I used a crude hack that simply created another field in the table called depth1000. this field is automatically populated using a gint rule as the depth + 1000 which gets rid of the negatives. I then use formulas in the report to plot it and subtract the 1000 at output time. I can provide more specifics if this seems to answer your problem.
Reply
  • 0 Offline
    I have run into this problem before when dealing with Well Stickup above the ground surface entered as a negative depth. gINT does not properly sort negative depth values when outputting to a graphic report and misplaces text that is associated with a negative depth as you describe. To solve this problem, I used a crude hack that simply created another field in the table called depth1000. this field is automatically populated using a gint rule as the depth + 1000 which gets rid of the negatives. I then use formulas in the report to plot it and subtract the 1000 at output time. I can provide more specifics if this seems to answer your problem.
Children
No Data
Communities
Support and Services
Training and Learning
Social Media