draw a Soil long profile
draw a Soil long profile
(OP)
Hello ladies and gentlemen,
I have a question regarding the modeling of the soil data. I have 3 CPT results like that :
CPT1 : Distance on the axis 0m
Depth(m) Soil
0.5 Sand
1 Clay
1.5 Sand
2 Sand
CPT2: Distance on the axis 50m
Depth(m) Soil type
0.5 Clay
1 Clay
1.5 Galcial till
2 Sand
CPT3: Distance on the axis 100m
Depth(m) Soil type
0.5 Sand
1 Sand
1.5 Clay
2 Galcial till
I want now to create a long profile (100m long) showing the soil classification at each depth with different colors like Yellow for sand, Green for Clay and Gray for Glacial till (such a normal subsurface profile). How can I do that? Is there any free software or maybe an excel sheet ? I am not expert on that but I tried and I did not found anything.
Please check an example of the profile needed in the attachment.
Appreciate your time and help.
I have a question regarding the modeling of the soil data. I have 3 CPT results like that :
CPT1 : Distance on the axis 0m
Depth(m) Soil
0.5 Sand
1 Clay
1.5 Sand
2 Sand
CPT2: Distance on the axis 50m
Depth(m) Soil type
0.5 Clay
1 Clay
1.5 Galcial till
2 Sand
CPT3: Distance on the axis 100m
Depth(m) Soil type
0.5 Sand
1 Sand
1.5 Clay
2 Galcial till
I want now to create a long profile (100m long) showing the soil classification at each depth with different colors like Yellow for sand, Green for Clay and Gray for Glacial till (such a normal subsurface profile). How can I do that? Is there any free software or maybe an excel sheet ? I am not expert on that but I tried and I did not found anything.
Please check an example of the profile needed in the attachment.
Appreciate your time and help.





RE: draw a Soil long profile
For 3 CPTs it would be quicker to do it in CAD or by hand, especially where theyre 2m deep.
RE: draw a Soil long profile
If I were in your shoes and the results could have a material affect, I would refuse to draw the long section and simply provide the profiles- let others interpret it how they'd like. If you are interpreting it yourself, I would assume the worst-case profile for the line of work you are looking at and just go with that, subject to more data being provided.
A side note- I'm not sure how you have 3 CPT tests that only go to 2m depth? These tests are expensive and usually used for deep ground investigations. Another important point is that unless the CPT results are verified by test holes, you will never know exactly what soils you are dealing with in any case.
All the best,
Mike
RE: draw a Soil long profile
The results have been provided to us based on scientific studies. For us, it is enough to draw such a profile showing the soil type to know which tool we have to use for the dredging.
So I just rely want to visualize the data in beautiful colored profile instead of having numbers and photos on each location of CPT or VC. I did that manually using AutoCAD but it is time consuming, so I thought maybe someone here can advice.
Thanks again.