Recent developments in the digitalization of infrastructure expansion require a digital representation of
the underlying data for such projects. Geotechnical investigations represent a key discipline in planning
these projects. In this field numerous borehole investigations serve as the data basis which are typically
appended to geotechnical reports and passed on to the relevant planners. This data exchange is usually done in the form of non-editable PDF files, which are unsuitable for further use and do not adequately
address the volume of data (Tegtmeier u. a. 2014). In this context the aim of this thesis is to represent
borehole investigations in an existing data model and make them suitable for three-dimensional visualization in a Geographic Information System (GIS).
Within the framework of an infrastructure project by Deutsche Bahn InfraGO AG (referred to as DB),
three application scenarios were developed. These include the visualization of data in an interactive
3D map as well as the integration with BIM models and the export of the data. The data model chosen
for this purpose is SEP 3, specifically designed for borehole databases, and serves as the foundation
for further considerations. For integration with building information models, the IFC data model is used,
while the export is based on the object-oriented data exchange format BoreholeML.
The implementation is carried out by storing the data in a PostgreSQL database and visualizing it in
QGIS. The results demonstrate that a three-dimensional representation of layer and groundwater data
can be realized using the SEP 3 data model through open-source software. In this case, the visualization was achieved by representing the boreholes as cylinders, allowing for an intuitive 3D depiction of the
subsurface layers. Additionally, the export of this data into a valid GML file based on the BoreholeML
schema can be successfully achieved.
«
Recent developments in the digitalization of infrastructure expansion require a digital representation of
the underlying data for such projects. Geotechnical investigations represent a key discipline in planning
these projects. In this field numerous borehole investigations serve as the data basis which are typically
appended to geotechnical reports and passed on to the relevant planners. This data exchange is usually done in the form of non-editable PDF files, which are unsuitable for furthe...
»