Understanding Soil Layers for Foundation Design

I recently worked on a project where the soil composition turned out to be quite variable. It made me realize how crucial soil analysis is for foundation design. Has anyone else dealt with unexpected soil conditions? What methods or tools did you find helpful in assessing the layers?

‌⁠‍⁠​‍​‍‌⁠‌​​‍​‍​⁠‍‍​‍​‍‌‍‌⁠‌‍​⁠‌‍‌‌‌‍‍‍​‍​‍​‍⁠​​‍​‍‌‍‍⁠​‍​‍​⁠‍‍​‍​‍‌‍⁠‍‌‍‌‌‌⁠‌⁠‌‌⁠⁠‌⁠‌​‌‍⁠⁠‌⁠​​‌‍‍‌‌‍​⁠​‍​‍​‍⁠​​‍​‍‌‍‍‌‌‍‌​​‍​‍​⁠‍‍​‍​‍‌‍⁠‍‌‍‌‌‌⁠‌⁠​‍​‍​‍⁠​​‍​‍‌‍‌​​‍​‍​⁠‍‍​‍​‍​⁠​‍​⁠​​​⁠​‍​⁠‌‍​⁠​​​⁠‍‌​⁠​​​⁠‌​​‍​‍​‍⁠​​‍​‍‌‍‍​​‍​‍​⁠‍‍​‍​‍‌‌‍​​‍⁠‌‌⁠‌‍​‍⁠‌​⁠‌‍‌‌​‌‌‌‍‍‌⁠‌⁠‌‍⁠​‌‌​​‌​​‍‌‍‌‌‌​‌​‌​⁠‍‌​‍‍‌‍‌⁠​‍​‍‌⁠⁠‌​