Solutions · Soil laboratories
Software for soil testing laboratories: from raw test data to classified results
Where laboratory software fits between the bench and the report, and which GeoEQ tools cover each step.
The short answer
Reduction and classification, not sample management.
Software for soil testing laboratories covers the step between the bench and the report: reducing grain size and Atterberg limit data, classifying the soil by USCS and AASHTO, and passing results to the engineer. GeoEQ Lab is being built for that step and is in development; it is not a laboratory information management system.
The workflow below shows every step of a laboratory job. Steps GeoEQ does not cover are marked as outside GeoEQ, so you can see exactly where it helps.
The workflow
From sample to signed result, step by step.
- 01
Receive, log and prepare samples
Sample receipt, identification, storage and preparation follow your own procedures and systems. GeoEQ does not track samples or manage the laboratory.
Done in your own tools Outside GeoEQ - 02
Run the tests at the bench
Sieve and hydrometer analysis, liquid limit and plastic limit are performed to the standard your client specifies, such as ASTM D6913, D7928 and D4318, or the AASHTO equivalents. The physical work and its calibration records stay with the laboratory.
Done in your own tools Outside GeoEQ - 03
Reduce grain size and Atterberg data
Retained masses become percent passing and a grain size curve with D10, D30 and D60; blow counts and water contents become a flow curve, the liquid limit at 25 blows and the plasticity index.
GeoEQ Lab In development - 04
Classify the soil
Gravel, sand and fines fractions, the coefficients of uniformity and curvature and the plasticity chart give a USCS group symbol; the same data give an AASHTO group.
GeoEQ Lab In development - 05
Check a result independently
Any reduction can be repeated in a few lines of the open-source geoeq library, which includes soil classification and laboratory testing reduction, so a disputed value can be reproduced and inspected.
geoeq for Python Available - 06
Put results next to the field record
Laboratory results are meant to sit with the borehole log, so the engineer reads the strata, samples and test results together. Logs are produced in GeoEQ SPT Logs today; the flow of GeoEQ Lab results into those logs is planned.
GeoEQ SPT Logs Available - 07
Review, approve and issue the report
Technician checks, supervisor approval, accreditation records, client reports and invoicing are done in your own systems and templates. The engineer who signs the results reviews them.
Done in your own tools Outside GeoEQ
What the work involves
The three results every laboratory report starts from.
Grain size distribution
A sieve analysis measures the coarse fraction down to the 0.075 mm (No. 200) sieve; a hydrometer analysis characterises the finer material by sedimentation. The curve gives D10, D30 and D60, the coefficient of uniformity Cu = D60 / D10, and the coefficient of curvature Cc = D30² / (D10 × D60).
Atterberg limits
The liquid limit is read from a flow curve of water content against the logarithm of blow count, taken at 25 blows, with blow counts that bracket 25. The plastic limit is the water content at which a thread of soil crumbles, and the plasticity index is PI = LL − PL.
Classification
USCS (ASTM D2487) separates coarse from fine soil at 50 percent passing the 0.075 mm sieve, then uses gradation for coarse soils and the plasticity chart for fine soils. AASHTO M 145 groups soils for highway use with a different threshold and a group index, so one soil can have two correct answers.
Common pitfalls
- Too few or poorly spread points on the liquid limit flow curve, so the value at 25 blows is an extrapolation.
- Fines content mixed up between the sieve result and the hydrometer result when the two curves are joined.
- Cu and Cc reported for a soil with so many fines that D10 does not exist on the curve.
- A USCS symbol written into the log without checking the plasticity chart, especially near the A-line and for dual symbols.
- Results typed twice, into a worksheet and again into a report, which is where transcription errors enter.
Keep reading
The plasticity chart and the A-line explains how liquid limit and plasticity index become a USCS symbol. Browse the applications GeoEQ covers or the full software catalogue.
Tools for this work
What GeoEQ offers a laboratory.
- In development
GeoEQ Lab
Soil laboratory testing
Grain size, Atterberg limits and USCS and AASHTO classification.
- Available
GeoEQ SPT Logs
Borehole and boring log software · soil to rock
Log boreholes from soil to rock and export finished log sheets.
Direct answers
Questions from soil testing laboratories.
More solutions are listed on the solutions hub.
Is GeoEQ a laboratory information management system?
No. GeoEQ Lab is being built for test reduction and classification, not sample tracking, chain of custody, approvals or billing. A laboratory that needs those uses its own system beside it.
What software do soil testing laboratories use?
Most use a mix of spreadsheets, instrument software and, in larger laboratories, a laboratory information management system for sample tracking and reporting. GeoEQ Lab is for the reduction and classification of grain size and Atterberg results.
What will GeoEQ Lab cover?
Grain size distribution, Atterberg limits and USCS and AASHTO classification. It is in development, and only that scope is described.
Is GeoEQ Lab available now?
Not yet. It is in development. Choose Get notified and you will be told when it is released.
How do laboratory results get into a borehole log?
Laboratory results are planned to flow into GeoEQ SPT Logs borehole logs, so field and laboratory records stay together. GeoEQ SPT Logs is available now and is free.
How is the liquid limit found from a flow curve?
Plot water content against the logarithm of blow count, fit a straight line through the points, and read the water content at 25 blows. The test method sets the number of points and the blow range.
Can a laboratory check a result in code?
Yes. The open-source geoeq library for Python includes soil classification and laboratory testing reduction, installed with pip install geoeq, so a value can be reproduced in a script. Documentation is at docs.geoeq.org.
Who is this for?
Soil laboratories, laboratory technicians and the engineers who use their results. Drilling and site investigation contractors and consultants have their own pages in the solutions list.
Soil laboratories
Test data to classified results.
GeoEQ Lab is in development. Choose Get notified and you will be told when it is released. GeoEQ SPT Logs is available to download now.