Soil test data intelligent display method and system based on three-dimensional terrain model

Abstract

The invention provides a soil test data intelligent display method and system based on a three-dimensional terrain model, and the method comprises the steps: collecting terrain data and soil test data, and carrying out the preprocessing of the collected terrain data and soil test data; constructing a three-dimensional terrain model by using the terrain data, generating a terrain surface by using digital elevation model (DEM) data, carrying out terrain surface fine processing by using laser radar LiDAR data, and mapping the preprocessed soil test data into the three-dimensional terrain model through a geographic information system according to geographic coordinates of the preprocessed soil test data; displaying the soil test data on the three-dimensional terrain model in different visual modes; and statistical analysis is carried out on soil test data, a data change trend chart and a correlation chart and curve are generated, and a test report is automatically generated. The problem that two-dimensional display is insufficient in the prior art can be solved, and intelligent, visual and interactive display of soil test data in a three-dimensional space is achieved.

Description

Technical Field

[0001] The present invention relates to the fields of geotechnical engineering and geotechnical testing, and in particular to a method and system for intelligently displaying geotechnical testing data based on a three-dimensional terrain model. Background Art

[0002] Geotechnical testing is one of the important links in geotechnical engineering investigation. Traditional geotechnical test data display mainly relies on two-dimensional plane diagrams and tables, which makes it difficult to intuitively display the spatial distribution and change patterns of geotechnical test data, especially when dealing with complex terrain and large-scale data. In addition, traditional methods lack dynamic interaction and multi-dimensional analysis of data, which limits the deep mining and application of data. Therefore, there is an urgent need for a method that can intelligently display geotechnical test data in three-dimensional space to improve the intuitiveness, interactivity and analysis depth of data display. Summary of the invention

[0003] The purpose of the present invention is to provide a method for intelligent display of geotechnical test data based on a three-dimensional terrain model to solve the problem of insufficient two-dimensional display in the prior art and to achieve intelligent, intuitive and interactive display of geotechnical test data in three-dimensional space.

[0004] A method for intelligently displaying geotechnical test data based on a three-dimensional terrain model comprises the following steps:

[0005] Data collection and processing: Collect topographic data and geotechnical test data, and pre-process the collected topographic data and geotechnical test data;

[0006] Three-dimensional terrain model construction: construct a three-dimensional terrain model using the terrain data, generate a terrain surface using digital elevation model DEM data, perform fine processing of the terrain surface using laser radar LiDAR data, and map the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system;

[0007] Data visualization: geotechnical test data can be displayed on the 3D terrain model in different visualization ways, including color coding to display soil layers at different depths, and using contour lines and contour surfaces to display the distribution of soil parameters; using the 3D visualization library to build an interactive interface, allowing users to view test data from different angles and areas by rotating, zooming, and panning;

[0008] Data analysis and presentation: Statistical analysis of geotechnical test data is performed to generate data trend charts and correlation charts and curves, and test reports containing text descriptions, charts, and 3D visualizations are automatically generated, and report export is supported.

[0009] Furthermore, the preprocessing includes denoising, data cleaning and format conversion, wherein denoising is to remove noise in the data using a filtering algorithm, data cleaning is to check and correct outliers, and format conversion is to unify the data output by different devices into a CSV format.

[0010] Furthermore, the pre-processed geotechnical test data is mapped to the three-dimensional terrain model according to its geographic coordinates through a geographic information system, specifically including:

[0011] Coordinate transformation: transform the geographic coordinates of the preprocessed geotechnical test data into the same coordinate system as the three-dimensional terrain model;

[0012] Data mapping: Map the converted geotechnical test data to the corresponding position of the terrain model; if the geotechnical test data is vector data, it is directly mapped to the corresponding point of the terrain model; if it is raster data, it needs to be interpolated or resampled to adapt to the resolution of the terrain model.

[0013] Furthermore, the display of soil layers of different depths by color coding includes: color coding according to soil layer depth and soil parameters, and using gradient colors to display different parameter values, and the soil parameters include water content and density.

[0014] Furthermore, the contour lines are generated by linear interpolation or cubic spline interpolation.

[0015] An intelligent display system for geotechnical test data based on a three-dimensional terrain model, comprising:

[0016] Data acquisition and processing module, used to collect topographic data and geotechnical test data, and pre-process the collected topographic data and geotechnical test data;

[0017] A three-dimensional terrain model construction module is used to construct a three-dimensional terrain model using the terrain data, generate a terrain surface using a digital elevation model (DEM) data, perform a fine processing of the terrain surface using a laser radar (LiDAR) data, and map the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system;

[0018] The data visualization module is used to display geotechnical test data on a three-dimensional terrain model in different visualization methods, including color coding to display soil layers at different depths, and using contour lines and contour surfaces to display the distribution of soil parameters; using a three-dimensional visualization library to build an interactive interface, allowing users to view test data from different angles and areas by rotating, zooming, and panning.

[0019] The data analysis and display module is used to perform statistical analysis on geotechnical test data, generate data trend charts and correlation charts and curves, automatically generate test reports containing text descriptions, charts and 3D visualization diagrams, and support report export.

[0020] Furthermore, the preprocessing includes denoising, data cleaning and format conversion, wherein denoising is to remove noise in the data using a filtering algorithm, data cleaning is to check and correct outliers, and format conversion is to unify the data output by different devices into a CSV format.

[0021] Furthermore, the pre-processed geotechnical test data is mapped to the three-dimensional terrain model according to its geographic coordinates through a geographic information system, specifically including:

[0022] Coordinate transformation: transform the geographic coordinates of the preprocessed geotechnical test data into the same coordinate system as the three-dimensional terrain model;

[0023] Data mapping: Map the converted geotechnical test data to the corresponding position of the terrain model; if the geotechnical test data is vector data, it is directly mapped to the corresponding point of the terrain model; if it is raster data, it needs to be interpolated or resampled to adapt to the resolution of the terrain model.

[0024] Furthermore, the display of soil layers of different depths by color coding includes: color coding according to soil layer depth and soil parameters, and using gradient colors to display different parameter values, and the soil parameters include water content and density.

[0025] Furthermore, the contour lines are generated by linear interpolation or cubic spline interpolation.

[0026] In general, the present invention has important application value in the field of geotechnical engineering survey. It improves the intuitiveness of geotechnical test data display, more intuitively displays the spatial distribution and changes of data through a three-dimensional terrain model, and enhances the interactivity of data display. Users can view and analyze from multiple angles and scales through an interactive interface, and it provides multi-dimensional data analysis and intelligent report generation functions to help users understand and use geotechnical test data more efficiently. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 It is a flow chart of the intelligent display method of geotechnical test data based on a three-dimensional terrain model of the present invention. DETAILED DESCRIPTION

[0028] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0029] Figure 1 The figure is a flow chart of a method for intelligently displaying geotechnical test data based on a three-dimensional terrain model according to an embodiment of the present invention. The method comprises the following steps:

[0030] Step 1: Data collection and processing

[0031] Collect topographic data and geotechnical test data of a certain project area. Topographic data include: drilling location (design information, geographic information), drilling diameter, formation depth, formation lithology, geological structure, physical and mechanical properties, groundwater, core sampling rate, in-situ test data, sampling location, sampling depth, sample type, sample structure; geotechnical test data include: sampling location, sampling depth, sample type, sample structure, physical test data, conventional test data, standard penetration test data, static penetration test data, mechanical test data. Use software to preprocess the data and generate a standardized data format. The specific steps are as follows:

[0032] Step 1.1, data collection: Use GPS, total station and other equipment to obtain topographic data; obtain geotechnical test data through drilling sampling, standard penetration test (SPT), static penetration test (CPT), etc.

[0033] Step 1.2: Data preprocessing:

[0034] Denoising: Use filtering algorithms to remove noise from data, such as Gaussian filtering.

[0035] Data cleaning: Check and correct outliers.

[0036] Format conversion: Convert data into a unified format, such as unifying data output from different devices into CSV format.

[0037] Step 2: 3D terrain model construction

[0038] The terrain data is used to construct a three-dimensional terrain model, and a digital elevation model (DEM) or laser radar (LiDAR) data is used to generate a terrain surface; the pre-processed geotechnical test data is mapped to the three-dimensional terrain model according to its geographic coordinates through a geographic information system. The specific steps are as follows:

[0039] Step 2.1: Construction of 3D terrain model:

[0040] The terrain data is used to construct a three-dimensional terrain model, a digital elevation model (DEM) data is used to generate a terrain surface, and an interpolation algorithm (such as inverse distance weighted, IDW) is used to interpolate the terrain data.

[0041] The LiDAR data is used to refine the terrain surface to ensure the high accuracy of the model.

[0042] DEM data is usually stored in the form of a regular grid, and each grid point contains an elevation value. LiDAR data is more detailed and contains a large amount of point cloud data, each point has precise geographic coordinates and elevation values. Some implementation codes are as follows:

[0043]

[0044] Step 2.2, data mapping:

[0045] The preprocessed geotechnical test data are mapped onto the three-dimensional terrain model according to geographic coordinates, and the linear interpolation method is used to ensure the matching of the data with the three-dimensional terrain model.

[0046] The specific steps are as follows: 1. Coordinate conversion: convert the geographic coordinates of the preprocessed geotechnical test data into the same coordinate system as the three-dimensional terrain model; 2. Data mapping: map the converted geotechnical test data to the corresponding position of the terrain model; if the geotechnical test data is vector data, it is directly mapped to the corresponding point of the terrain model; if it is raster data, interpolation or resampling is required to adapt to the resolution of the terrain model.

[0047] Step 3: Data visualization and presentation

[0048] In the 3D terrain model, soil layers of different depths are displayed by color coding, and the distribution of soil parameters is displayed by isolines and isosurfaces. Users can interact with the model through the GUI. The specific steps are as follows:

[0049] Step 3.1, color coding:

[0050] Color coding is performed according to soil layer depth and soil parameters (such as water content and density), and gradient colors are used to display different parameter values.

[0051] importmatplotlib.pyplot as plt

[0052] from mpl_toolkits.mplot3d importAxes3D

[0053] #Color-coded 3D terrain display

[0054] defvisualize_3d_terrain(grid_x,grid_y,grid_z,soil_data):

[0055] fig = plt.figure()

[0056] ax=fig.add_subplot(111,projection='3d')

[0057] surface=ax.plot_surface(grid_x,grid_y,grid_z,facecolors=plt.cm.terrain(soil_data))

[0058] plt.colorbar(surface, shrink=0.5, aspect=5)

[0059] plt.show()

[0060] Step 3.2, isolines and isosurfaces:

[0061] The spatial distribution of soil parameters is displayed using contour lines and contour surfaces, and contour lines are generated using linear interpolation or cubic spline interpolation.

[0062] from matplotlib import cm

[0063] #Contour line display

[0064] defvisualize_contours(grid_x,grid_y,grid_z):

[0065] plt.figure()

[0066] cp=plt.contourf(grid_x,grid_y,grid_z,cmap=cm.viridis)

[0067] plt.colorbar(cp)

[0068] plt.show()

[0069] Step 3.3, interactive interface:

[0070] Use a 3D visualization library (such as PyVista or Plotly) to build an interactive interface, where users can view test data from different angles and regions by rotating, zooming, and panning.

[0071] Step 4: Data analysis and report generation

[0072] Perform statistical analysis on geotechnical test data, generate data trend charts and correlation charts, automatically generate test reports containing text descriptions and graphics, and support report export. Users can save or send reports to relevant personnel in PDF or other formats. The specific steps are as follows:

[0073] Step 4.1: Data statistical analysis:

[0074] Calculate statistical indicators of soil parameters such as mean, standard deviation, maximum and minimum values.

[0075] import pandas as pd

[0076] #Statistical analysis

[0077] defanalyze_soil_data(soil_data):

[0078] df=pd.DataFrame(soil_data,columns=['Depth','Parameter'])

[0079] stats = df.describe()

[0080] return stats

[0081] Step 4.2, data change trend chart:

[0082] Generate trend graphs of soil parameters changing with depth, and use line graphs or bar graphs to display data changes.

[0083] #Data change trend chart

[0084] defplot_trend(soil_data):

[0085] plt.figure()

[0086] plt.plot(soil_data[:,0],soil_data[:,1],marker='o')

[0087] plt.xlabel('Depth')

[0088] plt.ylabel('Parameter')

[0089] plt.title('Soil ParameterTrend')

[0090] plt.show()

[0091] Step 4.3, report generation and export:

[0092] Based on the analysis results, a test report containing text descriptions and graphics is automatically generated, and the report can be exported to PDF or other formats.

[0093] from fpdfimport FPDF

[0094] #Report Generation and Export

[0095] defgenerate_report(analysis_results,trend_plot_path):

[0096] pdf=FPDF()

[0097] pdf.add_page()

[0098] pdf.set_font("Arial",size=12)

[0099] pdf.cell(200,10,txt="Soil Test Report",ln=True,align='C')

[0100] #Add analysis results

[0101] for key,value in analysis_results.items():

[0102] pdf.cell(200,10,txt=f"{key}:{value}",ln=True)

[0103] #Add trend chart

[0104] pdf.image(trend_plot_path,x=10,y=50,w=150)

[0105] pdf.output("soil_test_report.pdf")

[0106] The embodiment of the present invention further provides a geotechnical test data intelligent display system based on a three-dimensional terrain model, comprising:

[0107] Data acquisition and processing module, used to collect topographic data and geotechnical test data, and pre-process the collected topographic data and geotechnical test data;

[0108] A three-dimensional terrain model construction module is used to construct a three-dimensional terrain model using the terrain data, generate a terrain surface using a digital elevation model (DEM) data, perform a fine processing of the terrain surface using a laser radar (LiDAR) data, and map the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system;

[0109] The data visualization module is used to display geotechnical test data on a three-dimensional terrain model in different visualization methods, including color coding to display soil layers at different depths, and using contour lines and contour surfaces to display the distribution of soil parameters; using a three-dimensional visualization library to build an interactive interface, allowing users to view test data from different angles and areas by rotating, zooming, and panning.

[0110] The data analysis and display module is used to perform statistical analysis on geotechnical test data, generate data trend charts and correlation charts and curves, automatically generate test reports containing text descriptions, charts and 3D visualization diagrams, and support report export.

[0111] The above is a specific implementation method of a method and system for intelligent display of geotechnical test data based on a three-dimensional terrain model. By implementing this technical solution, intelligent, intuitive and interactive display of geotechnical test data in three-dimensional space can be achieved.

[0112] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. A method for intelligent display of geotechnical test data based on a three-dimensional terrain model, characterized in that: The following steps are involved: Data collection and processing: Collect topographic data and geotechnical test data, and pre-process the collected topographic data and geotechnical test data; Three-dimensional terrain model construction: construct a three-dimensional terrain model using the terrain data, generate a terrain surface using digital elevation model DEM data, perform fine processing of the terrain surface using laser radar LiDAR data, and map the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system; Data visualization: Geotechnical test data can be displayed on the 3D terrain model in different visualization ways, including color coding to display soil layers at different depths, and using contour lines and contour surfaces to display the distribution of soil parameters; an interactive interface can be built using a 3D visualization library, allowing users to view test data from different angles and areas by rotating, zooming, and panning. Data analysis and presentation: Statistical analysis of geotechnical test data is performed to generate data trend charts and correlation charts and curves, and test reports containing text descriptions, charts, and 3D visualizations are automatically generated, and report export is supported.

2. The method for intelligently displaying geotechnical test data based on a three-dimensional terrain model according to claim 1, characterized in that: The preprocessing includes denoising, data cleaning and format conversion, wherein denoising is to remove noise in the data using a filtering algorithm, data cleaning is to check and correct outliers, and format conversion is to unify the data output by different devices into a CSV format.

3. The method for intelligently displaying geotechnical test data based on a three-dimensional terrain model according to claim 1, characterized in that: The process of mapping the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system specifically includes: Coordinate transformation: transform the geographic coordinates of the preprocessed geotechnical test data into the same coordinate system as the three-dimensional terrain model; Data mapping: Map the converted geotechnical test data to the corresponding position of the terrain model; if the geotechnical test data is vector data, it is directly mapped to the corresponding point of the terrain model; if it is raster data, it needs to be interpolated or resampled to adapt to the resolution of the terrain model.

4. The method for intelligently displaying geotechnical test data based on a three-dimensional terrain model according to claim 1, characterized in that: The display of soil layers of different depths by color coding includes: color coding according to soil layer depth and soil parameters, and using gradient colors to display different parameter values, wherein the soil parameters include water content and density.

5. The method for intelligently displaying geotechnical test data based on a three-dimensional terrain model according to claim 1, characterized in that: The contour lines are generated by linear interpolation or cubic spline interpolation.

6. An intelligent display system for geotechnical test data based on a three-dimensional terrain model, characterized in that: include: Data acquisition and processing module, used to collect topographic data and geotechnical test data, and pre-process the collected topographic data and geotechnical test data; A three-dimensional terrain model construction module is used to construct a three-dimensional terrain model using the terrain data, generate a terrain surface using a digital elevation model (DEM) data, perform a fine processing of the terrain surface using a laser radar (LiDAR) data, and map the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system; The data visualization module is used to display geotechnical test data on a three-dimensional terrain model in different visualization methods, including color coding to display soil layers at different depths, and using contour lines and contour surfaces to display the distribution of soil parameters; using a three-dimensional visualization library to build an interactive interface, allowing users to view test data from different angles and areas by rotating, zooming, and panning. The data analysis and display module is used to perform statistical analysis on geotechnical test data, generate data trend charts and correlation charts and curves, automatically generate test reports containing text descriptions, charts and 3D visualization diagrams, and support report export.

7. The intelligent display system for geotechnical test data based on a three-dimensional terrain model according to claim 6, characterized in that: The preprocessing includes denoising, data cleaning and format conversion, wherein denoising is to remove noise in the data using a filtering algorithm, data cleaning is to check and correct outliers, and format conversion is to unify the data output by different devices into a CSV format.

8. The intelligent display system for geotechnical test data based on a three-dimensional terrain model as claimed in claim 6, characterized in that: The process of mapping the pre-processed geotechnical test data to the three-dimensional terrain model according to its geographic coordinates through a geographic information system specifically includes: Coordinate transformation: transform the geographic coordinates of the preprocessed geotechnical test data into the same coordinate system as the three-dimensional terrain model; Data mapping: Map the converted geotechnical test data to the corresponding position of the terrain model; if the geotechnical test data is vector data, it is directly mapped to the corresponding point of the terrain model; if it is raster data, it needs to be interpolated or resampled to adapt to the resolution of the terrain model.

9. The intelligent display system for geotechnical test data based on a three-dimensional terrain model as claimed in claim 6, characterized in that: The display of soil layers of different depths by color coding includes: color coding according to soil layer depth and soil parameters, and using gradient colors to display different parameter values, wherein the soil parameters include water content and density.

10. The intelligent display system for geotechnical test data based on a three-dimensional terrain model according to claim 6, characterized in that: The contour lines are generated by linear interpolation or cubic spline interpolation.

Images