Documentation / Logging
Strata, soil type letters and symbols in GeoEQ SPT Logs
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?
| Letter | Soil | Symbol on the sheet |
|---|---|---|
| C | Clay | Solid brown |
| S | Sand | Yellow with dots |
| M | Silt | Light tan with fine dots |
| G | Gravel | Pale with stone outlines |
| F | Fill | Light grey cross-hatch |
| O | Organic | Dark grey with dots |
| R | Rock | Blue-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.