SoilStats
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.
Please feel free to let us know if you need template customization services.
Borehole Log generation
Fully customizable log template
Log template generated by Python script
SQLite database
Multiple versions of logs in one template
Multiple languages in one template
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
Cross-Sections
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