Solutions · Site investigation
Geotechnical site investigation software workflow, from field data to borehole logs
Drilling and SPT, strata, samples, groundwater and rock cores, borehole logs, the factual report and the laboratory hand-off, with each step matched to the tool that covers it.
The short answer
One investigation, several tools, honestly mapped.
Geotechnical site investigation software supports the path from drilling and in-situ testing to borehole logs, laboratory results and the factual report; GeoEQ covers the logging step today with the free GeoEQ SPT Logs and is building the laboratory step in GeoEQ Lab.
Below, each step of a typical investigation is marked with the GeoEQ tool that covers it, the status of that tool, or "your own tools" where GeoEQ does not. For the tools themselves, see all GeoEQ software and the applications they cover.
The workflow
From the drill rig to the factual report.
Eight steps, in the order most investigations run them. Steps marked as your own tools are done outside GeoEQ; nothing here implies GeoEQ covers them.
- Step 01
Plan the investigation
Decide borehole locations, depths, sampling and in-situ tests from the proposed works and the desk study.
Your own tools Done in your own tools - Step 02
Drill, sample and test in the field
Advance the borehole, run SPTs, take disturbed and undisturbed samples, core rock and record groundwater. The field sheet is the original record.
Your own tools Field work, outside GeoEQ - Step 03
Log strata, samples, groundwater and cores
Turn field sheets into a structured record: blow counts, strata with USCS symbols, samples, groundwater levels and rock core runs. Existing Excel or CSV sheets can be imported with column mapping.
GeoEQ SPT Logs Available - Step 04
Test samples in the laboratory
The laboratory runs the tests and records the raw data. The test procedures themselves happen at the bench.
Your own tools Laboratory work, outside GeoEQ - Step 05
Reduce and classify laboratory results
Grain size curves, Atterberg limits and USCS and AASHTO classification, computed and charted from the raw test data.
GeoEQ Lab In development - Step 06
Bring laboratory results back onto the logs
Check the lab classification against the field description and show the results beside the strata. The flow from GeoEQ Lab into GeoEQ SPT Logs logs is planned, not available yet.
- Step 07
Correct and check field data
Apply SPT corrections and correlations or script checks across many boreholes. GeoEQ SPT Logs records the field N value; corrected values are computed in the open-source library.
geoeq for Python Available - Step 08
Issue the logs and the factual report
Export the borehole logs as a PDF for the whole site, then assemble the report text, site plan, notes and laboratory appendices in your own word processor.
What the task involves
What a site investigation produces.
A site investigation gathers factual information about the ground, which is then reported as borehole logs, test results and groundwater observations before anyone interprets it. Interpretation, such as a ground model, design parameters and foundation recommendations, is a separate piece of work that builds on those facts.
Typical factual outputs
- Borehole logs: strata, samples, SPT N values, groundwater and rock core runs for every borehole
- Groundwater observations, with the level and when it was read
- Laboratory test results and classification for the samples that were tested
- Borehole location plan and explanatory notes for the symbols and terms used
- A statement of procedures: what was drilled, sampled and tested, and how
What the logging step records
- SPT blow counts in 150 mm increments, or direct N values
- Strata with USCS soil symbols and descriptions
- Disturbed and undisturbed samples and groundwater levels
- Rock core runs with TCR, SCR and RQD
- One A4 PDF for the whole site, on company letterhead
How blow counts become design values is explained in SPT N-value corrections: N60 and N1(60). For how laboratory index tests are read, see reading the plasticity chart.
Common pitfalls
Where investigation records go wrong.
- Logs that do not match the field sheet
- Retyping field data by hand introduces depth and blow-count errors. Importing the existing spreadsheet and reviewing it once is safer than typing it again.
- SPT refusal recorded as a number
- Where the test stops at refusal, the record should say so (for example 50/75) rather than a made-up N value. The N value is the sum of the second and third 150 mm increments; the first increment is seating.
- Groundwater with no context
- A water level is only meaningful with the date and time it was read and the borehole condition. Record when it was observed, not only the depth.
- Rock core numbers that cannot be right
- RQD can never exceed SCR, and SCR can never exceed TCR. A quick check of every run catches transcription slips before the log is issued.
- Laboratory results never reconciled
- A field description of silty clay and a laboratory classification of sand disagree for a reason: the sample, the description or the test. Compare them before the report goes out.
- Facts mixed with interpretation
- The factual report states what was found. Ground models, design parameters and recommendations belong in the interpretive report and should be separated clearly.
Tools for this work
The GeoEQ tools for site investigation.
- Available
GeoEQ SPT Logs
Logging and borehole log sheets
Log boreholes from soil to rock and export finished log sheets.
- In development
GeoEQ Lab
Laboratory results and classification
Grain size, Atterberg limits and USCS and AASHTO classification.
- Available
geoeq for Python
Corrections, correlations and scripted checks
170+ geotechnical functions, and the engine behind the desktop programs.
Direct answers
Questions about site investigation software.
Answers are kept in visible HTML and structured data so people, search engines and AI systems receive the same answer.
What software is used for a geotechnical site investigation?
No single program covers the whole investigation; teams combine logging software, laboratory software, scripts and a word processor. GeoEQ SPT Logs covers borehole logging and log sheets today, GeoEQ Lab for laboratory results is in development, and the open-source geoeq library for Python covers corrections and calculations.
What is the difference between a factual and an interpretive geotechnical report?
A factual report presents what was found: procedures, borehole logs, in-situ and laboratory test results and groundwater observations. An interpretive report builds on those facts with a ground model, design parameters and recommendations. Keeping them separate lets others check the data.
What goes on a borehole log?
A borehole log records the borehole identity and location, the strata with soil or rock descriptions, SPT blow counts or N values, samples taken, groundwater levels and, in rock, core recovery and RQD. GeoEQ SPT Logs draws all of these on one sheet with USCS soil symbols.
How is the SPT N value calculated from a field record?
The N value is the sum of the blows for the second and third 150 mm increments of the test; the first 150 mm is seating. Where the test reaches refusal the notation, such as 50/75, is reported as written. GeoEQ SPT Logs accepts increments or a direct N value.
How do laboratory results get onto the borehole log?
Today they are entered or typed alongside the field record by hand. GeoEQ Lab is in development, and results flowing from it into GeoEQ SPT Logs borehole logs are planned, so field and laboratory records can stay together. It is not available yet.
Does GeoEQ write the factual report?
No. GeoEQ SPT Logs produces the borehole logs as a single PDF for the whole site, which becomes an appendix. The report text, site plan, procedures and laboratory appendices are written in your own tools, and the engineer reviews and signs the result.
Can I bring in my existing field data?
Yes, if it is in Excel or CSV. GeoEQ SPT Logs reads files with any column headings and shows a mapping dialog so you confirm which column is depth, blow counts or description before any row enters the project. Photographs of handwritten sheets are not read.
Is the site investigation software free?
GeoEQ SPT Logs is free; create a free GeoEQ account to download the Windows installer. The geoeq library for Python is open source. GeoEQ Lab is not released yet.
Keep going
Related pages.
GeoEQ SPT Logs
Borehole log software for SPT, strata, samples, groundwater and rock cores.
GeoEQ Lab
Soil laboratory testing software in development.
All software and applications
The full catalogue and the engineering tasks it covers.
All solutions
Task and audience pages for the rest of GeoEQ.
GeoEQ SPT Logs · Available
Start with the logs.
GeoEQ SPT Logs is free for Windows. Import your field data and export finished borehole logs.