A GI borehole is a drilled hole in the ground used to collect soil and rock samples for analysing subsurface conditions. The resulting bore log documents the soil layers, groundwater levels, rock levels, and other geotechnical properties, which engineers use to design safe and effective foundations, retaining structures, and other civil and structural engineering elements.

Geotechnical bore logs are commonly presented in tabular format, listing detailed soil properties for each borehole individually. However, with multiple boreholes on a site, this format can be unintuitive and time-consuming for engineers to interpret the overall subsurface conditions quickly and holistically.

The GI Bore Log to Revit plugin transforms traditional tabular geotechnical data into intuitive 3D visualisations directly within Revit. By allowing users to input borehole depths and soil layer information into a structured Excel table, the plugin automatically generates accurate 3D bore logs, helping engineers and geologists better understand and communicate subsurface conditions across a site. This enhances both design insight and collaboration in geotechnical and civil engineering projects.

The Rockhead surface and Pile Length Optimisation plugin can import rock head profiles generated in Surfer into the Revit environment and automatically determines pile lengths based on the subsurface conditions. This enhances design accuracy and efficiency in geotechnical and structural workflows.

The objectives of developing the tool are:
- To develop a GI Bore Log to Revit plugin that can automatically generate 3D model of bore holes from bore log data in excel.
- To develop a Revit plugin that can import rock head profile from Surfer into Revit, and also optimise the pile length based on the imported rock head profile.

The GI Bore Log to Revit plugin converts traditional tabular geotechnical data into intuitive 3D visualisations within Revit. Users prepare a CSV file containing borehole coordinates, elevations, depths, and soil layer information, which can be imported into Revit through the plugin interface. Once the data is loaded, the plugin automatically generates corresponding 3D bore log models, providing a clear and efficient representation of subsurface conditions.

The Rockhead Surface and Pile Length Optimisation plugin facilitates the integration of rock head profile data into Revit for pile foundation design. The workflow begins with recording borehole coordinates and rock head levels in a CSV file, which is then processed in Surfer to generate a rock head surface and exported as a CSV file. After importing this CSV into a Revit model using the Revit Topo surface tool, the plugin retrieves both the pile and surface data, calculates the required pile lengths based on the rock head profile, and updates the model accordingly—streamlining the design process with accurate geological context.

A comprehensive user guide is already available to introduce the tool's functions and provide instructions on its use.

User Guide can be downloaded from: https://drive.google.com/file/d/1tkxBcWDNLWeuBNiwNlPkHcH_wMnnfd-a/view?usp=sharing

1 - Is the plugin free of charge?

Yes. But you have to sign a Material Transfer Agreement before you could officially use it.

2 - What version(s) of Revit could the plugin work with?

The plugin works with Revit 2019 and later.

Please find below documents for your review at the links here:

1. User Guide: Provides an overview of the tool’s features and step-by-step instructions for use.
   https://drive.google.com/file/d/1tkxBcWDNLWeuBNiwNlPkHcH_wMnnfd-a/view?usp=sharing 
   
   
2. Plug-in Package: Includes the installer, template file, sample files, and installation instructions.
   https://drive.google.com/file/d/1PlrJkTO_TBClziwni_cP96ZLuHNlXzBt/view?usp=sharing 
   
   
3. Watch the demonstration video by clicking the link below:
   https://cms.bim.cic.hk/Upload/template/44/self/307be23f9eda40a890cda64a64027b11.mp4 

Should you have any inquiries, please contact Ms. Cecilia Wan at [email protected] .