SoilStats is a free software program designed for engineers to generate geotechnical, geological, environmental, and oil and gas well borehole logs, summarize and visualize borehole data, visualize ground surface data and other general objects.

The database and borehole log templates of SoilStats are fully customizable to meet any requirements. SQLite database is used to store borehole data and Python is used to generate borehole log and visualization template, and provide related data. Since Python is used for the log templates, the templates can be designed with extremely high flexibility and complexity. Many types of logs and different languages can be implemented in one template. 

Existing borehole data (Excel files, gINT files, etc.), as long as they are able to be read with Python directly or indirectly, can be imported to generate borehole logs or visualize the data with SoilStats.

Borehole locations, associated borehole information, and soil stick logs can be exported as kmz files and visualized with Google Earth. Boreholes and cross-sections can be exported in dxf format.

Three dimensional ground surface data (*.xyz) can be easily imported to construct ground surfaces. Users can also construct three dimensional geometries and show them by construction steps.

If you are familiar with Python and SQLite, you are more than welcome to create your own datamap file and other templates. In the program folder, there is an example project and an default template, which should be able to provide you with some basics about how to customize the program for your projects.

Borehole Log generation

Fully customizable log template

Multiple versions of logs in one template

Multiple languages in one template

Log template generated by Python script

SQLite database

Spreadsheet data input

Fully customizable table and associated data structure

Table structures specified with JSON 

Soil strata visualization based on depth or elevation

Select a specific soil type

User defined data summary tabs

Moisture content summary

SPT N values summary

Show soil sample depth, elevations

Show groundwater levels

Atterberg limits and any other laboratory results

Regroup soil names

Specify display colors for soils

3D borehole visualization

Link to borehole logs or pdf borehole logs

Vertical and borehole diameter scale settings

kmz file export

Borehole location and associated information

Soil stick logs

Batch coordinates conversion


Borehole stick logs along cross-sections

3D ground surface construction based on xyz data points

Construction of ground surface contours

Cut ground surface cross-section

Visualization of grid field data

Construction of general objects, piles with GUI or Python script

Show general objects by steps

Master database to manage different projects

Dynamically feed data to Google Earth

Dynamically generate borehole logs based on Google Earth Request