Skip to content
GeoEQ · Geotechnical software research lab · University of Utah

Documentation / Logging

Strata, soil type letters and symbols in GeoEQ SPT Logs

Applies to 1.0 and later · current 1.2 2 min read

Short answer

On the Strata tab, give each layer's bottom depth, a description and a soil type letter: C clay, S sand, M silt, G gravel, F fill, O organic or R rock. The letter is guessed from the description and sets the coloured symbol. A USCS symbol ending the description is printed in bold.

7 families
C S M G F O R symbols
15 symbols
USCS groups printed bold (ASTM D2487)
Last term wins
Sandy SILT is M, Silty SAND is S

What goes on the Strata tab?

The Strata tab takes one row per layer with three columns: bottom depth, description and soil type letter. Each layer starts where the previous one ended, so you only type bottoms. A row is drawn when it has a description and its bottom is deeper than the previous layer’s bottom.

Descriptions are free text, for example Grey Medium Dense Silty SAND, SM. The sheet wraps them in the description column and sets thickness, symbol and colour beside them.

What are the soil type letters?

LetterSoilSymbol on the sheet
CClaySolid brown
SSandYellow with dots
MSiltLight tan with fine dots
GGravelPale with stone outlines
FFillLight grey cross-hatch
OOrganicDark grey with dots
RRockBlue-grey with a plus pattern

These are the seven symbol families, and they appear in the sheet legend. The letter you type in the Type cell wins. Leave it blank and the app guesses it.

How is the letter guessed?

The guess uses the last soil word in the description, because the last word is the primary soil. Sandy SILT gives M, and Silty SAND gives S. Rock names such as SANDSTONE, LIMESTONE or SHALE give R, and PEAT or ORGANIC give O. With no soil word, the default is clay.

What does the bold USCS symbol mean?

When a description ends with a Unified Soil Classification System group symbol, the app prints it in bold. Recognised symbols are GW, GP, GM, GC, SW, SP, SM, SC, ML, CL, OL, MH, CH, OH and PT, plus dual symbols such as SC-SM. The symbol follows a comma or a space, so Brown Firm Silty CLAY, CL prints CL in bold.

Classification itself follows ASTM D2487, and visual-manual description follows ASTM D2488; the default classification standard in the Header tab reads “ASTM D-2487 & D-2488”. See USCS in the glossary. To classify fines from lab results, see reading the plasticity chart.

How do strata and SPT rows relate?

They are independent tables. The strata set the symbols and descriptions, and the SPT rows set samples, blow counts and the N-value graph. If you have SPT rows but no strata, a warning badge under the sheet reads “Add strata descriptions”.

Consecutive rows with the same description merge into one stratum when you import from a spreadsheet; see Excel and CSV import.

What about rock layers?

Give the rock stratum the letter R. Core runs go on the Rock core tab, and core run boundaries do not cross the description or symbol columns, which describe the stratum rather than the run.

Step-by-step tutorials

Frequently asked questions

How does the app pick the soil type letter?

It reads the primary soil term, which is the last one in the description. Sandy SILT becomes M and Silty SAND becomes S. If no soil term is found it defaults to clay, and you can overtype the letter at any time.

What is the bold text at the end of a description?

A USCS group symbol such as CL, SM or ML. When a description ends with one, as in Brown Firm Silty CLAY, CL, the symbol is printed in bold so the soil class reads at a glance.

Which USCS symbols are recognised?

GW, GP, GM, GC, SW, SP, SM, SC, ML, CL, OL, MH, CH, OH and PT, plus dual symbols joined by a hyphen or slash such as SC-SM or CL/ML.

Why is a stratum row missing from the sheet?

A row needs a description and a bottom depth below the previous layer's bottom to be drawn. Check that depths increase down the table.