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

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.

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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.

    GeoEQ Lab In development Planned link
  7. 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
  8. 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.

    GeoEQ SPT Logs Available Logs here; report text in your own tools

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.

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 · Available

Start with the logs.

GeoEQ SPT Logs is free for Windows. Import your field data and export finished borehole logs.