CN111339691A

CN111339691A - Intelligent geotechnical engineering parameter three-dimensional analysis and evaluation system and method based on voxler software

Info

Publication number: CN111339691A
Application number: CN202010343378.7A
Authority: CN
Inventors: 饶开永; 董平; 李俊才; 曹晶晶; 林春明; 刘松玉; 贺锦美; 张鹏
Original assignee: Nanjing Intelligent Geotechnical Engineering Technology Research Institute Co ltd
Current assignee: Nanjing Intelligent Geotechnical Engineering Technology Research Institute Co ltd
Priority date: 2020-04-27
Filing date: 2020-04-27
Publication date: 2020-06-26

Abstract

The invention discloses a smart geotechnical engineering parameter three-dimensional analysis and evaluation system and method based on voxler software, wherein the system takes geotechnical engineering investigation data as a core, and the evaluation system comprises a geotechnical engineering investigation data management module, a geotechnical engineering investigation data processing and analysis module, a geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module, a geotechnical engineering investigation data visual display module and a geotechnical engineering investigation drawing and data output module. Each module has a set of complete new methods and data processing, analysis and evaluation processes. The invention carries out three-dimensional comprehensive analysis and evaluation on drilling sampling, in-situ testing, geotechnical testing and geophysical prospecting data. The three-dimensional modeling technology constructed by the system is easy to learn and use, has higher precision, better accords with the real stratum condition, and can be better applied to three-dimensional analysis and evaluation of geotechnical engineering survey parameters.

Description

Intelligent geotechnical engineering parameter three-dimensional analysis and evaluation system and method based on voxler software

Technical Field

The invention relates to the technical field of geotechnical engineering investigation, in particular to a geotechnical engineering parameter data processing and three-dimensional analysis and evaluation system based on voxler software.

Background

Geotechnical engineering investigation relates to engineering geological survey, drilling and sampling, in-situ testing, indoor geotechnical testing, physical and chemical exploration and other working links, and is widely applied to various stages of engineering planning, design, construction, maintenance and the like. The aim of geotechnical engineering investigation is to find out the conditions of engineering geology, hydrogeology, environmental geology and the like of various engineering sites, to comprehensively evaluate the sites and various related geological problems, to analyze and predict the possible geological condition changes and the influence on design and construction under the action of engineering construction, and to provide geotechnical engineering parameters. However, most of the existing geotechnical engineering surveys are based on the collection of basic chart information and rely on manual data processing, and the processing method is simple, but the procedures are complicated, and the consumed manpower and material resources are large.

The engineering geological profile map is the most common and intuitive tool for distribution of various rock-soil layers and attribute characteristics of rock-soil bodies in the field of engineering geology. The method is one of the important concerns of construction, design and construction units, the traditional two-dimensional section drawing method is complex and tedious, is easy to make mistakes, can only display part of soil layer numbers, rock and soil layer legends, in-situ tests and conventional geotechnical test data mostly, and needs to be combined with the in-situ tests and geotechnical test statistical data for comprehensive analysis. The defects of large workload, low efficiency and non-visual display content are highlighted day by day. In particular, it has the following disadvantages:

(1) data are difficult to share, and repeated statistical workload is large. The designer or engineer must compare and analyze the engineering geological profile, the planar position diagram of the building and the exploration point and various geotechnical and in-situ test reports, which has simpler content originally, but virtually increases the workload of the report writer and reader greatly. The two-dimensional and three-dimensional integrated section of the engineering geology is drawn, data needs to be frequently interacted in a three-dimensional system and a two-dimensional AutoCAD, files need to be converted into an intermediate format by using a traditional method and are processed after being imported, and the interactivity is poor;

(2) the drawing workload is large and the efficiency is low. In the traditional section drawing method, geometric projection, intersection and drawing are finished manually, the working mode is relatively original, and the influence of subjective factors is relatively large. The calculation result and the design drawing are managed separately, the data are dispersed, and the work efficiency is counted;

(3) and the modification of the achievement drawing is complicated. Whether the change of the layered data of the rock and soil layers or the screening statistics of related in-situ test and geotechnical test parameters causes the corresponding change of all the flows of profile drawing, so that more frequent repetitive work is generated;

(4) the calculation result is not intuitive enough. In-situ test, geotechnical test data statistics, pile foundation and foundation pit parameter calculation processes and results are limited in a single CAD system, namely the spatial change of a section in each geotechnical layer cannot be intuitively reflected, and the visualization degree is low.

(5) And the later stage labeling is complicated. The design needs further calculation by using an engineering geological profile and various achievement tables, and a plurality of design drawings are output. Different marking information needs to be added to each drawing, for example, the special parameters of various geotechnical tests, and the workload of manually adding the marking information is large.

Due to the defects of the work, three-dimensional geological modeling and analysis evaluation are carried forward in the geological industry. It plays an important role in urban engineering construction. At present, data sources of three-dimensional geological modeling mainly comprise engineering geological drilling, geophysical exploration, field drawing and the like. The traditional three-dimensional geological modeling method is a point surface generation method, a section frame method and a modeling method of combining various data. Through repeated interpretation and modification, a geologic body mathematical structure model is established, and the geometric and physical properties of the rock-soil layer are simulated by a computer. However, the three-dimensional geological modeling still has the following bottleneck problems at the present stage:

(1) the three-dimensional geological modeling technology is less applied to geotechnical engineering investigation. The three-dimensional geological modeling technology at the present stage is still mainly applied to the technical fields of mines, energy sources and the like, such as GOCAD, Earth Vision, Geocom and the like, and the research and the application in the technical field of geotechnical engineering investigation are less; and part of modeling systems are huge and complex to operate, and are difficult to master by technicians; the constraint condition is tighter, and the editing workload is larger;

(2) horizontal geological profile techniques are not yet mature. The three-dimensional slicing technology at the present stage is still mainly based on a vertical geological profile technology, can only describe the stratum distribution on a certain vertical surface, cannot effectively reflect the integral rock-soil layer distribution of different elevations or different target layers, and cannot provide comprehensive and effective technical support for engineering investigation, design, construction and the like;

(3) the modeling standard of three-dimensional data for geotechnical engineering investigation is lacked, and the sharing performance is poor. Due to the lack of a unified modeling standard, the interactivity of model data and other software or platforms is poor, so that a large amount of survey data cannot be directly applied to engineering design and construction. Two-dimensional engineering geological vertical slice images derived by existing three-dimensional geological modeling are often analyzed based on the drill holes connected by the profiles. The method is still simple in essence, and the formation line between two drilled holes is subjected to spline curve connection, and is not comprehensively analyzed according to related reasonably-utilized in-situ test, geotechnical test and other data;

(4) the simulation of the three-dimensional geological curved surface lacks timeliness and continuity. The conventional three-dimensional geological modeling technology is essentially to perform two-dimensional analysis to obtain a profile diagram, and then connect the wire frames of the profiles with the same interface to form a three-dimensional geological curved surface. And the traditional database is not accompanied with accurate geological attribute information. Meanwhile, because the stratum boundary is usually a working area boundary rather than a natural boundary of an engineering stratum, the three-dimensional geologic body needs to be updated due to the change of the two-dimensional map, and the timeliness and continuity of the three-dimensional geologic body result are difficult to ensure.

At the present stage, a three-dimensional visual analysis and evaluation technology which can cover the dispersion, interpolation and fitting of drilling data, in-situ test and geotechnical test data and engineering geophysical prospecting data, the establishment of a space data model and a three-dimensional data structure, good three-dimensional geological curved surface timeliness, clear and simple flow and easy learning and use is urgently needed.

Disclosure of Invention

In view of the above, the present invention provides a system and a method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software, which directly complete vertical and horizontal engineering geological profile maps and various three-dimensional achievement maps of geotechnical engineering investigation in a three-dimensional visual environment, and comprehensively analyze various in-situ tests, geotechnical tests and geophysical prospecting data to obtain more achievements beneficial to engineering construction, thereby solving the urgent needs for informatization, intellectualization and automation of geotechnical engineering investigation at the present stage.

In order to achieve the purpose, the invention adopts the following technical scheme:

the system takes geotechnical engineering investigation data as a core, and the evaluation system comprises a geotechnical engineering investigation data management module, a geotechnical engineering investigation data processing and analyzing module, a geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module, a geotechnical engineering investigation data visual display module and a geotechnical engineering investigation drawing and data output module.

The geotechnical engineering investigation data management module mainly realizes the management work of geotechnical engineering investigation data. The database system adopts a distributed database and a mixed distribution mode. The data management module is compatible with the input of various data sources, and acquires original data of exploration field work including but not limited to drilling geology cataloged data, drilling hole three-dimensional position information, hydrogeological data, geophysical prospecting data and related indoor geotechnical and in-situ test data according to the requirements of relevant technical specifications of geotechnical engineering exploration. The method realizes the editing of the survey data and the management of the drilling data, including data organization, editing and modification, lithology (soil) normalization processing and virtual drilling editing. The module method comprises the following steps:

a1: establishing engineering and information standardization, comprising the following specific steps:

(1) establishing a project, namely establishing the project according to the project name at the current stage;

(2) standardizing various information of each rock and soil layer, and defining attribute information of stratum layering nodes. The geological information on one side above the stratum layering node in the geological drilling hole is attribute information of the stratum layering node;

a2: preparing drilling data, converting coordinates, calculating elevation values of the data, and importing the data into a data management module, wherein the method comprises the following specific steps of:

(1) and preprocessing the drilling data. The borehole data includes contents such as a layering serial number, a borehole number, a position coordinate of an orifice plane, an orifice elevation, a stratum bottom depth, a stratum name, a sub-layer name, a stratum geological age, a stratum description and the like. The first six of which are essential and the last two of which are optional.

(2) And (4) checking data entry errors. Sometimes, it is necessary to reject portions of the borehole data or perform formation merging to optimize the model.

(3) And (3) coordinate conversion, which comprises the following specific steps:

a) comparing the accuracy of the drill hole number, the drill hole orifice coordinates and the orifice coordinates in the standardized geological information;

b) converting the coordinates and elevations of all nodes on the boundary line of the stratum and all the survey data into coordinates in the standardized three-dimensional geological information according to the corresponding relation;

(4) and importing a data management module.

The drilling data importing method comprises the following specific steps: open Voxler software → File → Load Date → choose data File.

A3: preparing indoor geotechnical and in-situ test data and importing data management module

Geotechnical test and in situ test data include, but are not limited to, the following three types: the water level data, the in-situ test data and the rock-soil sample test data are respectively in the following formats:

water level data: drilling hole number, initial water level depth, stable water level depth and test position information;

in-situ test data: drilling serial numbers, in-situ test starting and stopping depths and in-situ test values;

testing data of a rock soil sample: drilling hole number, sample start-stop depth and geotechnical test values.

A4: preparing geophysical prospecting data and importing the geophysical prospecting data into a data management module, and specifically comprising the following steps:

(1) preprocessing and inverting geophysical prospecting data;

(2) and importing geophysical inversion data into a data management module. The geophysical prospecting data comprise engineering geophysical prospecting data such as a high-density electrical method, a ground penetrating radar, a common resistivity method, a nano TEM, a wave velocity test, shallow seismic reflection, seismic tomography and the like, are made into excel or csv table data, and are imported.

A5: and importing style data, and importing various existing style data into a data management module.

A6: and importing the graphic data, and importing various existing graphic data into a data management module for auxiliary calculation and analysis.

A7: data saving, statistics and query editing

After the steps are completed, all data are stored, and the survey data are edited and modified, lithology (soil) normalization processing and virtual drilling editing are realized according to specific query conditions.

Preferably, in the step a2, the system may import drilling text data derived by the geological survey software of huaning and correcting project into the system, or import the drilling database of the system into the database of huaning or correcting project, so as to implement data sharing with the mainstream survey software. The derived data is in a text format and a standard XML format.

Preferably, in step a2, the common menu imported by the voxler data includes:

worksheet Worksheet

Function lattice

Geometry \ Geometry map

PointSet \ set of data points

TestLattice \ test grid data

In step a2, the format of the drilling data is text txt format or excel table format, with the suffix of · xlsx or · csv, which is described as follows:

the drilling data file is divided into 10 columns in total, the first action attribute row is the data corresponding to each layer of each hole. The first column is all serial numbers (numbers), the second column is a borehole number (arbitrary character), the third column is a coordinate (number) in the borehole X direction, the fourth column is a coordinate (number) in the borehole Y direction, the fifth column is an orifice elevation value (number), the sixth column is a layer number (arbitrary character), the seventh column is a layer bottom depth (number), the eighth column is a layer name (arbitrary character), the ninth column is a formation year, and the tenth column is a formation description.

Preferably, the module can be used by a user to conveniently and timely backup and restore the whole database.

Preferably, the test values in the in-situ test data in the step a3 include a standard penetration number, a conical dynamic penetration number, a static penetration test value, a cross plate shear test value, a lateral pressure test value, a load test value, a field shear test value, a flat shovel test value, a wave velocity test value, a rock in-situ test value, a foundation soil dynamic parameter test value, a soil radon test value, and a soil erosion test value;

preferably, the test values in the geotechnical test data in the step A3 include a soil sample number, a layering number, a sampling depth water content (W), a soil particle specific gravity (Gs), a wet density (ρ), a dry density (ρ d), a saturation (Sr), a pore ratio (e) of each level, and a liquid limit (W)_L) Plastic limit (W)_P) Plasticity index (I)_P) Liquidity index (I)_L) A compressibility (a), a compression modulus (Es), a permeability coefficient (Kv, Kh), and the like;

the format of the geotechnical test data file is as follows: the first behavior is an attribute row, and the following is data corresponding to each layer of each hole. The first column is all layering serial numbers (numbers), the second column is drilling soil layer numbers (any characters), the third column is drilling soil sample numbers (any characters), the fourth column is coordinates (numbers) in the drilling X direction, the fifth column is coordinates (numbers) in the drilling Y direction, the sixth column is an orifice elevation value H (numbers), the seventh column is a sampling depth (numbers), and other columns are all geotechnical test values.

Preferably, in step a4, the format of each geophysical data is as follows:

high density electrical data: the system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, an AB polar distance, an MN polar distance and resistivity;

ground penetrating radar data: the method comprises the following steps of (1) sequence number, measuring line number, measuring point number, X coordinate, Y coordinate, H elevation, measuring depth, reflected radar wave frequency and reflected radar wave amplitude;

general resistivity method data: the system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, an AB polar distance, an MN polar distance and resistivity;

NanoTEM data: the system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, sampling time, sampling depth, an Ex value, a Hy value and resistivity;

wave speed test data: the test system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, a test depth, a compression wave velocity, a shear wave velocity, a frequency and an amplitude;

shallow seismic reflection data: the system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, a test depth, travel time, frequency and amplitude;

seismic tomography data: the test system comprises a serial number, a measuring line number, a measuring point number, an X coordinate, a Y coordinate, an H elevation, a test depth, a compression wave velocity, a shear wave velocity, a frequency and an amplitude.

Preferably, the data management system adopts a data exchange mode of a mobile terminal and a PC (personal computer), so that the intellectualization and the rapidness of the internal and external business data of geotechnical engineering can be realized;

preferably, the mobile terminal can be an Android smart phone, an IOS smart phone or a tablet computer;

The geotechnical engineering investigation data processing and analyzing module (Computational) mainly realizes the processing and analyzing of geotechnical engineering investigation data and other work. The module carries out standardization and intellectualization of reconnaissance three-dimensional data processing and analysis according to the type and process of engineering reconnaissance data analysis and the form of output results and various data statistics and analysis methods of geotechnical engineering reconnaissance. The module method comprises the following steps:

b1: parameter extraction, data value removal and correction, and the method specifically comprises the following steps:

(1) the technical personnel checks the survey data;

(2) extracting isosurface data, comprising the following steps: selecting Grider → Right Key → Graphics Output → Isosurface; establishing and adjusting the coordinate system is similar to the steps.

B2: computing module selection, module connection

In this example, grider (gridding model) in Computational (computation module) is called to perform data processing, module selection and module connection, that is, gridding interpolation computation is performed on the imported data.

B3: and setting module attributes, and defining the geological boundary and attribute information of each data point.

B4: the method comprises the following steps of data gridding and interpolation calculation:

(1) gridding and interpolation are performed by first operating Create → Computational → GridDel → Properties → Action → Begin Gridding. And adding a Grider model in a Network management Network window, and connecting the Grider model with various types of survey data imported in the previous step. Performing property setting on the Grider model, such as selecting a proper interpolation method (such as Kriging interpolation), density of grid data nodes, space and the like;

(2) the calculation comprises the following specific steps: ExtractPoints → ChangeType → DuplicateFilter → Filter → Gradient → Merge → Resample → Transform;

and carrying out XY plane smooth filtering on the grid file by using Math-Filter so that the surface of a model built behind the grid file is not prone to severe fluctuation and jump.

B5: the method comprises the following steps of data discretization, type conversion, data statistics and error value elimination, and specifically comprises the following steps:

(1) discretizing the data, and converting the data into a type identified by a three-dimensional data volume;

(2) data statistics, namely performing statistical treatment on in-situ test and geotechnical test data to obtain the number, maximum value, minimum value, average value, standard deviation, variation coefficient, standard value and the like of the data;

(3) mutation or unreasonable data were rejected.

B6: data analysis

And carrying out statistical analysis on the discretized data, determining a threshold value, and analyzing and comparing each parameter of geotechnical engineering investigation.

B7: and (4) data storage.

Preferably, step B4 employs 13 interpolation methods as follows:

(1) kriging interpolation;

(2) a moving average method;

(3) least square method

(4) The minimum curvature method;

(5) natural neighbor interpolation;

(6) nearest neighbor interpolation;

(7) inverse distance weighted interpolation;

(8) DSI discrete smoothing algorithm.

(9) A local polynomial method;

(10) a multiple regression method;

(11) a linear interpolation triangulation method;

(12) improving the Sheberd method;

(13) a radial basis function method;

the technical personnel should reasonably select the interpolation method according to the conditions of each project and the familiarity degree of the technical personnel;

preferably, in step B6, the threshold value should be determined according to the geological conditions of each project, in combination with the relevant specifications, measured values and the relevant expert experience.

The geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module mainly realizes three-dimensional modeling and visual analysis and evaluation based on geotechnical engineering investigation data. The module automatically constructs a three-dimensional earth surface model, a stratum model and a geological model according to the acquired geotechnical engineering investigation data, and dynamic association and updating among the data can be realized; the geological attributes of each model can be inquired in real time, and the visual analysis of geotechnical engineering parameters can be completed. The module method comprises the following steps:

c1: establishing a voxler geotechnical engineering investigation three-dimensional data frame and whitening treatment, and specifically comprising the following steps of:

(1) the geotechnical engineering investigation three-dimensional data frame is determined by the red line range of the project, and three-dimensional coordinate axes, namely an X axis, a Y axis and a Z axis, are suggested. Generating a bounding box by using the BoundingBox; setting a coordinate axis attribute by using 'Axes';

(2) and in the whitening treatment, grids of the Grider module are divided at certain intervals according to latitude and longitude lines of geodetic coordinates, and grid nodes are arranged at the periphery of a measuring area and are interpolated. And (3) importing a drilling hole orifice elevation two-dimensional gridding file (drilling hole orifice coordinates, grd) which is generated by Surfer software and has whitened the dots outside the measuring area, adding a 'Math' calculation module, and setting the node penetration number value exceeding the measuring area range to be-2. The whitening processing can be realized by taking the Grider module as an A parameter, taking the drilling hole coordinate and grd as a B parameter, inputting the B parameter, linking the B parameter to the Math module, and adding an IF Z < B and A = -2 formula into an expression in a General page of a Math module attribute manager.

C2: establishing a three-dimensional drilling model, a terrain model, a geologic body initial stratum model and an attribute model, and specifically comprising the following steps:

(1) the method for generating the three-dimensional drilling model by utilizing WellData comprises the following specific steps:

a) connecting a three-dimensional geological database to obtain layered underground three-dimensional information (three-dimensional coordinate information and stratum information) of the drill hole;

b) calculating data (planar coordinates, layer top elevation, layer bottom elevation, layering thickness, layer number and expression color of the corresponding layer number) required by drawing each three-dimensional drilling hole according to the information acquired from the database;

c) setting the amplification factor and the display precision of the drilling hole;

d) drawing a three-dimensional drilling hole model of the drilling hole in the view area, and endowing each layer with different colors;

e) and repeating a) to d), drawing a three-dimensional drilling layered model of all the drilling holes and visually displaying.

(2) Generating three-dimensional terrain models

Generating a terrain Isosurface map by using the module Isosurface, and acquiring terrain images of different angles of a survey field; converting all the obtained images into corresponding point cloud data; and correcting wrong points and bad points in the point cloud data.

(3) Generating a stratum model, which comprises the following specific steps:

a) acquiring layered sampling points of each stratum from a geological database, and if the sampling points are too few, obtaining a virtual borehole by an extrapolation or reasonable interpolation method according to the existing borehole data;

b) carrying out DEM interpolation on the sampling points to obtain a regular grid which can directly describe the stratum interface;

c) different colors are set on each stratum surface in sequence so as to distinguish different stratums.

(4) Generating a three-dimensional geological model, which comprises the following specific steps:

a) surface for building structure

B, generating a stratum topographic curved surface according to the point set generated in the step A, if nodes on the generated point surface are not coincident with control points, carrying out geometric fitting, hiding unnecessary limitations through hide constraints, and finally attaching contour lines and elevation values;

b) modeling of rock-soil layer surface and structure surface

The method comprises the steps of leading the stratum surface of a rock stratum into voxler to obtain a curve object, converting the rock stratum attitude into a tangent vector of a surface, stretching the surface curve object for a certain distance along the tangent vector to obtain a surface object (surface), fitting the surface to obtain a curved surface, repeating the above processes, and respectively modeling each stratum surface and each fault surface.

C3: the method comprises the following steps of stratum structure and attribute data coupling modeling and stratum pinch-out, and comprises the following specific steps:

(1) carrying out coupling modeling on the stratum structure and the attribute data, and solving an intersection point of the stratum structure and the attribute;

(2) collecting the original drilling data read in the step A2, and adding missing stratums to the original drilling holes of the missing stratums according to a standard stratum sequence table;

(3) reading boundary point data of a modeling area, and constructing a boundary virtual drilling hole according to coordinates of the boundary points;

(4) performing grid discretization on the range of the modeling area, constructing a discrete point virtual drilling hole according to the coordinates of discrete points of the modeling area, and integrating the discrete point virtual drilling hole with the virtual drilling hole;

(5) and carrying out triangular difference by taking the range of the modeling area as a constraint condition and the coordinates of the original drilling hole, the discrete point virtual drilling hole and the boundary virtual drilling hole as reference points, and carrying out stratum pinch-out treatment.

C4: generating a geotechnical engineering investigation one-way slicing, crossing and comprehensive parameter geological information model, which comprises the following specific steps:

(1) the invention relates to automatic connection of sections, which adopts a drilling interval optimization identification method to automatically connect sections and stratums. The method comprises the steps of firstly dividing stratums among 2 drilled holes into a plurality of large intervals according to a layer group, identifying the stratums with the least ambiguity in the intervals, connecting the stratums, subdividing the original intervals into 2-3 small intervals, and repeating the steps in sequence.

(2) Slice analysis, namely, utilizing the 'ObbliqImage' and the 'sources' to slice the 'Math _ Filter' grid module and the contour line image, and creating a plurality of required slice images according to the requirement;

(3) and (4) cross sectioning, and acquiring a three-dimensional orthogonal sectioning map for geotechnical engineering investigation by using the OrthoImage.

(4) The borehole and the stratum interface are 'crossed', and the crossed line segment is projected to a space plane. And calculating a plane projection matrix according to the normal vector and the scaling coefficient of the projection plane, and multiplying the space coordinate of the borehole and the intersection line segment of the stratum and the section by the matrix to obtain the corresponding projection coordinate on the plane.

C5: analysis and evaluation of various geotechnical engineering parameter models

(1) Directly outputting the obtained intersection line and the projected line segment of the drill hole to AutoCAD to generate a two-dimensional profile, and automatically adding drawing frames, a scale, the elevation of the drill hole and the marking information of the drill hole interval during output;

(2) and C, analyzing the characteristics of different geotechnical engineering parameters one by one according to the parameter data calculated in the step B and the three-dimensional geological model obtained in the step C4, and evaluating the form of each parameter.

C6: basic design analysis and evaluation

(1) Analysis and evaluation of bearing capacity of single pile of pile foundation

Generally, the bearing capacity of a single pile of the pile foundation can be calculated according to the following formula, three-dimensional image display is carried out on the bearing capacity parameters of the pile foundation, and technicians obtain the distribution form of the bearing capacity in the space by means of a three-dimensional geological model.

The vertical ultimate bearing capacity of the single pile can be estimated according to formula 5.3.5 in technical Specification for building pile foundations (JGJ 94-2008), namely:

when the cast-in-place pile adopts a large diameter (d is more than or equal to 800 mm), the calculation can be carried out according to a formula 5.3.6 in technical Specifications for building pile foundations (JGJ 94-2008):

in the formula:q _sik-limit side resistance standard value (kPa) of pile side layer i soil;

q _pk-extreme end resistance criterion value (kPa);

(2) analysis and evaluation of pile foundation uplift bearing capacity

T _uk＝∑λ _i q _sik u _i l _i

In the formula:T _uk-standard value of uplift limit bearing capacity of the foundation pile;

q _sik-a standard value of extreme lateral resistance of the soil surrounding the pile;

u _ithe perimeter of the pile body is the same as the perimeter of the pile body,u _i=πd；

λ _i-resistance to plucking factor.

C7: analysis and evaluation of foundation pit design

(1) Foundation pit seepage analysis

(2) Checking and calculating the anti-floating stability of the foundation pit:

in the formula:G _k-the sum of the building's dead weight and the weight (kN);

N _w,k-a buoyancy effect value (kN);

K _wthe anti-floating stability safety coefficient can be 1.05 under general conditions.

C8: other analysis and evaluation

When engineering risk assessment caused by geology or other analysis and evaluation needs to be carried out, the system can also be used for carrying out analysis and evaluation.

Preferably, in the step C5, the drilling data, the in-situ test (the standard penetration number, the cone dynamic penetration test hit value, the static penetration test Ps value, etc.), and the parameters of the geotechnical test (such as the liquidity index, the consolidation coefficient, the compression modulus, the permeability coefficient, the compressive strength, the softening coefficient, the bearing capacity limit value, the bearing capacity characteristic value, etc.) may be screened and subjected to single analysis and comprehensive analysis and evaluation to obtain more direct and intuitive useful information.

The geotechnical engineering investigation data visualization display module realizes visualization investigation result display. The module integrates a ground surface three-dimensional model and a geological three-dimensional model of an engineering investigation working area based on software such as Voxler, Surfer, Grapher and AutoCAD and the like so as to simulate engineering investigation results. The module method comprises the following steps:

d1: obtaining discrete point data

Acquiring discrete data generated in the step B5, and making a vector diagram by using VectorPlot.

D2: and generating a three-dimensional topographic map, a contour map and an exploration point map. A contour map is created by using the contour, and a poster is created by using the post.

D3: three-dimensional rendering map and scatter diagram for displaying various types of survey data

During modeling of the Voxler three-dimensional data, a surface rendering map can be made by using a FaceRender, a vertical shaft rendering map is made by using a WellRender, a shape rendering map is made by using a VolRender, and a scatter diagram is made by using a Scatterplot.

D4: displaying various survey vertical horizontal slice images, orthogonal images and oblique images

Entering the Slice menu, a scatter diagram is made by using the ScatterPlot, an orthogonal diagram is made by using the OrthoImage, and a section diagram is made by using the ObliqImage.

D5: the method comprises the following steps of three-dimensional roaming and three-dimensional space information query, and specifically comprises the following steps:

(1) setting the color, texture and attribute of the geologic body model in a roaming environment, so that the model has more reality;

(2) the generated geologic body model is subjected to real-time interactive three-dimensional roaming, and the linkage of a three-dimensional plane navigation chart and a two-dimensional plane navigation chart can be realized;

(3) and (5) inquiring spatial information. And the stratum information and the drilling information are inquired in a relevant way by picking up the three-dimensional drilling model and the three-dimensional geological model.

D6: displaying various plan views, section views, bar charts, etc

And displaying an actual material diagram, an exploration point plan, an engineering geological profile, an engineering geological longitudinal section diagram, a cross section diagram, a horizontal geological profile, contour maps of all rock and soil layers, a rose diagram, a red horizontal projection diagram, a polar diagram, a static sounding bar diagram, a consolidation test result diagram, a triaxial shearing (UU, CU and CD) result diagram, a high-pressure consolidation result diagram, a visual resistivity section diagram, a slice diagram, a stereogram and the like by utilizing a graphical interface developed by the system.

D7: saving image data and closing the window.

The geotechnical engineering investigation drawing and data Output module (Graphics Output) realizes the function of drawing various engineering geological drawings. The module finishes drawing most of drawings and tables of geotechnical engineering investigation based on an engineering investigation database, and comprises an actual material map, an exploration point plane arrangement map, a drilling hole histogram, a comprehensive stratum histogram, a flat hole display map, a section map, a tangent plane map, a contour map, a rose map, a polar diagram, a red plane projection map and the like. The module can output various achievement forms such as geotechnical tests, in-situ tests, engineering geophysical prospecting and the like. The module method comprises the following steps:

e1: updating and correcting data; when there is new data, data addition and deletion are performed through step a2, and the technician performs correction.

E2: and (5) deriving a three-dimensional topographic map, contour lines and an exploration point map.

E3: and exporting or intercepting three-dimensional rendering images and scatter diagrams of various types of survey data.

E4: and (3) deriving or intercepting various survey vertical horizontal slice images, orthogonal images and oblique images.

E5: a roaming video is derived.

E6: drawing for exporting various two-dimensional results

By utilizing the module, a Surfer graph, a Grapher graph, an actual material graph with formats of AutoCAD, BMP, JPG and the like, an exploration point plan, an engineering geological profile, an engineering geological longitudinal section, a cross section, a horizontal geological profile, contour maps of all rock and soil layers, a rose diagram, a red-horizontal projection diagram, a polar diagram, a static sounding bar diagram, a consolidation test result diagram, a triaxial (UU, CU and CD) result diagram, a high-pressure consolidation result diagram, a visual resistivity section diagram, a slice diagram, a three-dimensional diagram and the like are derived.

E7: export various achievement forms

The module can derive a survey work list, a soil test, a rock layering statistical table, an in-situ test layering statistical table, a physical mechanics, electrics, seismology and other aspects layering statistical table, a liquefaction judgment and liquefaction index calculation result table, a wave velocity test table and the like.

Preferably, in the step E6, when the drawing is output, the drawing frame, the scale, the drill hole elevation, and the drill hole interval marking information are automatically added.

Compared with the prior art, the invention provides a system and a method for three-dimensional analysis and evaluation of intelligent geotechnical engineering parameters based on voxler software, which have the following beneficial effects:

(1) the invention provides a whole set of method for carrying out three-dimensional modeling analysis and evaluation of intelligent geotechnical engineering investigation, which is highly targeted and easy to master, can quickly construct three-dimensional models of geological elements such as drilling holes, stratums, in-situ tests, geotechnical tests and the like, realizes the unification and standardization of the manufacturing process of engineering investigation charts, improves the efficiency, saves the cost and ensures the accuracy, reliability and scientificity of chart drawing;

(2) in the data management link, a method of combining a relational database and a non-relational database is adopted to construct an engineering investigation database and carry out organization and management on investigation original data, intermediate data and result data. Realizing data interchange with professional software such as AutoCAD, Surfer, Grapher, Huaning, Liang, MapGIS, ArcGIS, CASS and the like, and realizing digital management and dynamic query of geotechnical engineering investigation by utilizing an attribute query function;

(3) in the data processing link, various interpolation methods are optimized and selected, and an optimal interpolation and gridding method is provided for processing various kinds of original data;

(4) in the three-dimensional data analysis and display link, profile analysis operation can be directly carried out in a three-dimensional environment by utilizing a two-dimensional geological section map attribute information automatic identification method, stratum pinch-out and data whitening treatment, and three-dimensional visual display of drilling, working area terrain and three-dimensional profiles is realized;

(5) in the links of drawing and table output, a user can set section lines at will, and the system automatically draws a section diagram according to the section lines, so that automatic drawing and exporting of a geological model II and a three-dimensional section analysis diagram are realized;

(6) the three-dimensional horizontal geological profile and the oblique section produced by the invention can clearly and comprehensively reveal the stratum distribution of different elevation planes including but not limited to +/-0.00 of buildings, all elevation planes of structural bottom plates and the like, shallow foundations and pile foundation support layers, and reflect the depression trend and the distribution rule and the change trend of the geotechnical parameters of all the geotechnical layers along with different elevations and depths in three-dimensional space. Providing technical supports which cannot be provided by the traditional engineering geological profile map for pile type selection, pile foundation distribution, foundation pit support design, foundation pit excavation construction scheme design and implementation and the like;

(7) the integrated data processing and visual analysis platform established by the invention avoids the conversion loss of data among different stages, can convert the data into conventional survey data in time, and is beneficial to the improvement of survey efficiency and achievement precision.

Drawings

FIG. 1 is a schematic diagram of a modular structure of a smart geotechnical engineering parameter three-dimensional analysis and evaluation system based on voxler software according to the present invention;

FIG. 2 is a flow chart of a data management module of the intelligent geotechnical engineering parameter three-dimensional analysis and evaluation method based on voxler software according to the present invention;

FIG. 3 is a flow chart of a data processing and analyzing module of the intelligent geotechnical engineering parameter three-dimensional analysis and evaluation method based on voxler software according to the present invention;

FIG. 4 is a flow chart of the three-dimensional modeling and visual analysis and evaluation module of the intelligent geotechnical engineering parameter three-dimensional analysis and evaluation method based on voxler software;

FIG. 5 is a flow chart of a visual display module of the intelligent three-dimensional analysis and evaluation method of geotechnical engineering parameters based on voxler software according to the present invention;

FIG. 6 is a flow chart of the use of a mapping and data output module of the smart geotechnical engineering parameter three-dimensional analysis and evaluation method based on voxler software according to the present invention;

FIG. 7 is a three-dimensional modeling drilling data format based on voxler software proposed by the present invention;

FIG. 8 is a three-dimensional modeling in-situ test, geotechnical test data format based on voxler software proposed by the present invention;

FIG. 9 is a three-dimensional modeling engineering geophysical prospecting data format based on voxler software according to the present invention;

FIG. 10 is a schematic diagram of a three-dimensional modeling drilling rendering based on voxler software according to the present invention;

FIG. 11 is a schematic diagram of a three-dimensional vector diagram based on voxler software according to the present invention;

FIG. 12 is a schematic diagram of a voxler software-based terrain map of survey data according to the present invention;

FIG. 13 is a schematic view of a voxler software-based survey slice according to the present invention;

FIG. 14 is a schematic view of a voxler software-based rendering of a volume of survey data according to the present invention;

FIG. 15 is a schematic diagram of a scatter diagram of survey data based on voxler software according to the present invention;

FIG. 16 is a schematic diagram of a contour map of survey data based on voxler software according to the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.

Example 1:

the technical solution of the present invention is described in detail with reference to fig. 1 to 16 by specific embodiments.

As shown in figure 1, the intelligent geotechnical engineering parameter three-dimensional analysis and evaluation system and method based on Voxler software, which are disclosed by the invention, take geotechnical engineering investigation data as a core, and comprise a geotechnical engineering investigation data management module A, a geotechnical engineering investigation data processing and analyzing module B, a geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module C, a geotechnical engineering investigation data visual display module D and a geotechnical engineering investigation drawing and data output module E.

As shown in fig. 2, the geotechnical engineering investigation data management module a mainly implements management work on geotechnical engineering investigation data. The module method comprises the following steps:

a1: and (5) establishing engineering and information standardization, and establishing the engineering by the project name at the current stage.

The method comprises the following specific steps: defining attribute information of stratigraphic layering nodes; the geological information on one side above the stratum layering node in the geological drilling hole is attribute information of the stratum layering node;

a2: preparing drilling data, converting coordinates, calculating elevation values of the data, and importing the elevation values into a data management module. The method comprises the following specific steps:

(1) and preprocessing the drilling data. The drilling data comprises contents such as a layering serial number, a drilling number, a position coordinate of an orifice plane, an orifice elevation, a stratum bottom depth, a stratum name, a sub-layer name, a stratum geological age, a stratum description and the like, wherein the first six data are necessary, and the second two data are optional data;

(2) and (4) checking data entry errors. Sometimes, partial drilling data need to be removed, or stratum combination is carried out, so as to optimize the model;

(4) import data management module

The drilling data importing method comprises the following specific steps: opening the Voxler software → File → Load Date → selecting the data File;

the derived data is in a text format and a standard XML format.

Preferably, in step a2, the common menu imported by the voxler data includes:

worksheet Worksheet

Function lattice

Geometry \ Geometry map

PointSet \ set of data points

TestLattice \ test grid data

As shown in fig. 7, in step a2, the format of the drilling data is text txt format or excel table format, with the suffix of. xlsx or. csv, as follows:

the drilling data file is divided into 10 columns in total, the first action attribute row is the data corresponding to each layer of each hole. The first column is all serial numbers (numbers), the second column is a borehole number (arbitrary character), the third column is a coordinate (number) in the borehole X direction, the fourth column is a coordinate (number) in the borehole Y direction, the fifth column is an orifice elevation value (number), the sixth column is a layer number (arbitrary character), the seventh column is a layer bottom depth (number), the eighth column is a layer name (arbitrary character), the ninth column is a formation year, and the tenth column is a formation description. Preferably, the module can be used by a user to conveniently and timely backup and restore the whole database.

testing data of a rock soil sample: drilling hole number, sample start-stop depth and geotechnical test value;

the test values in the in-situ test data in the step A3 comprise a standard penetration number, a cone dynamic penetration number, a static sounding test value, a cross plate shearing test value, a side pressure test value, a load test value, a field shearing test value, a flat shovel test value, a wave velocity test value, a rock in-situ test value, a foundation soil dynamic parameter test value, a soil radon test value and a water and soil corrosivity test value;

as shown in fig. 8, the format of the geotechnical test data file is: the first behavior is an attribute row, and the following is data corresponding to each layer of each hole. The first column is all layering serial numbers (numbers), the second column is drilling soil layer numbers (any characters), the third column is drilling soil sample numbers (any characters), the fourth column is coordinates (numbers) in the drilling X direction, the fifth column is coordinates (numbers) in the drilling Y direction, the sixth column is an orifice elevation value H (numbers), the seventh column is a sampling depth (numbers), and other columns are all geotechnical test values.

A4: preparing geophysical prospecting data and importing data management module

Firstly, preprocessing and inverting geophysical prospecting data; and secondly, importing geophysical inversion data into a data management module, wherein the geophysical data comprise engineering geophysical data such as a high-density electrical method, a ground penetrating radar, a common resistivity method, a nano TEM, a wave velocity test, shallow seismic reflection, seismic tomography and the like, are manufactured into excel or csv table data, and are imported.

As shown in fig. 9, in step a4, the format of each geophysical data is as follows:

high density electrical data: measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, AB polar distance, MN polar distance and resistivity;

ground penetrating radar data: measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, measuring depth, reflected radar wave frequency and reflected radar wave amplitude;

general resistivity method data: measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, AB polar distance, MN polar distance and resistivity;

NanoTEM data: the method comprises the following steps of measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, sampling time, sampling depth, Ex values, Hy values and resistivity;

wave speed test data: measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, measuring depth, compression wave velocity, shear wave velocity, frequency and amplitude;

shallow seismic reflection data: measuring line numbers, measuring point numbers, X coordinates, Y coordinates, H elevations, measuring depth, travel time, frequency and amplitude;

seismic tomography data: the test line number, the test point number, the X coordinate, the Y coordinate, the H elevation, the test depth, the compression wave velocity, the shear wave velocity, the frequency and the amplitude.

A7: data storage, statistics and query editing.

The database system adopts a distributed database and a mixed distribution mode. The data management module is compatible with the input of various data sources, and acquires original data of exploration field work including but not limited to drilling geology cataloged data, drilling hole three-dimensional position information, hydrogeological data, geophysical prospecting data and related indoor geotechnical and in-situ test data according to the requirements of relevant technical specifications of geotechnical engineering exploration. The method realizes the editing of the survey data and the management of the drilling data, including data organization, editing and modification, lithology (soil) normalization processing and virtual drilling editing.

The data management system adopts a data exchange mode of a mobile terminal and a PC (personal computer), so that the intellectualization and the rapidness of the internal and external data of geotechnical engineering can be realized; the mobile terminal can be an Android smart phone, an IOS smart phone and a tablet computer; the user can conveniently and timely back up and restore the whole database by using the module.

As shown in fig. 3, the geotechnical engineering survey data processing and analyzing module b (computational) mainly implements the processing and analyzing of geotechnical engineering survey data. The module carries out standardization and intellectualization of reconnaissance three-dimensional data processing and analysis according to the type and process of engineering reconnaissance data analysis and the form of output results and various data statistics and analysis methods of geotechnical engineering reconnaissance. The module is used as follows:

(1) the technical personnel checks the survey data;

B2: computing module selection, module connection

(1) gridding and interpolation are performed by first operating Create → Computational → GridDel → Properties → Action → Begin Gridding. And adding a Grider model in a Network management Network window, and connecting the Grider model with various types of survey data imported in the previous step. And (3) performing property setting on the Grider model, such as selecting a proper interpolation method (such as Kriging interpolation), density of grid data nodes, spacing and the like.

Step B4 uses the following 13 interpolation methods:

(1) kriging interpolation;

(2) a moving average method;

(3) least square method

(4) The minimum curvature method;

(5) natural neighbor interpolation;

(6) nearest neighbor interpolation;

(7) inverse distance weighted interpolation;

(8) DSI discrete smoothing algorithm.

(9) A local polynomial method;

(10) a multiple regression method;

(11) a linear interpolation triangulation method;

(12) improving the Sheberd method;

(13) a radial basis function method;

B5: data discretization, type conversion, data statistics and elimination of error values

As shown in fig. 15, the specific steps of the scattergram generation are:

(3) eliminating mutation or unreasonable data;

b6: data analysis, namely performing statistical analysis on the discretized data, determining a threshold value, and analyzing and comparing each parameter of geotechnical engineering investigation;

in step B6, the threshold value should be determined according to the geological conditions of each project, in combination with the relevant specifications, measured values and relevant expert experiences.

B7: and (4) data storage.

As shown in fig. 4, the geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module C mainly realizes three-dimensional modeling and visual analysis and evaluation based on geotechnical engineering investigation data. The module automatically constructs a three-dimensional earth surface model, a stratum model and a geological model according to the acquired geotechnical engineering investigation data, and dynamic association and updating among the data can be realized; the method can inquire the geological attributes of each model in real time and complete the visual analysis of geotechnical engineering parameters, and the module has the following use steps:

C2: establishing a three-dimensional drilling model, a terrain model, a geologic body initial stratum model and an attribute model

(1) Generation of three-dimensional borehole model using WellData

As shown in fig. 10, the specific steps are as follows:

(2) Generating a three-dimensional terrain model, as shown in FIG. 12, generating a terrain Isosurface map by using a module 'Isosurface', and acquiring terrain images of the survey site at different angles; converting all the obtained images into corresponding point cloud data; and correcting wrong points and bad points in the point cloud data.

(3) Generating a stratum model, which comprises the following specific steps:

a) surface for building structure

b) modeling of rock face and structure face

Leading the earth surface exposure line of the rock stratum into voxler from AUTOCAD to obtain a curve object, converting the rock stratum attitude into a tangent vector of a surface, stretching the curve object of the earth surface for a certain distance along the tangent vector to obtain a surface object (surface), fitting the surface to obtain a curved surface, repeating the processes, and respectively modeling each stratum surface and each fault surface.

(5) carrying out triangular difference by taking the range of the modeling area as a constraint condition and taking the coordinates of the original drilling hole, the discrete point virtual drilling hole and the boundary virtual drilling hole as reference points, and carrying out stratum pinch-out treatment;

c4: generating geotechnical engineering investigation one-way slicing, crossing and comprehensive parameter geological information model,

as shown in fig. 13, the specific steps of the slicing and orthogonal slicing are as follows:

(1) the invention relates to automatic connection of sections, which adopts a drilling interval optimization identification method to automatically connect sections and stratums. The stratum among 2 boreholes is divided into a plurality of large intervals according to the stratum group, and the stratum with the least ambiguity is identified in the intervals and connected. Dividing the original region into 2-3 small regions, and repeating the steps;

(2) slice analysis

As shown in fig. 13 and 16, the "Math _ Filter" grid module slice and the contour image are sliced using "obique image" and "contacts". As needed, a plurality of desired slice images may be created;

(3) cross slicing, namely acquiring a three-dimensional orthogonal slice image for geotechnical engineering investigation by using the OrthoImage;

(4) and projecting the intersection line section of the intersection of the borehole and the stratum interface to a space plane. And calculating a plane projection matrix according to the normal vector and the scaling coefficient of the projection plane, and multiplying the space coordinate of the borehole and the intersection line segment of the stratum and the section by the matrix to obtain the corresponding projection coordinate on the plane.

Step C5 may be performed by screening drilling data, in-situ tests (standard penetration number, cone dynamic penetration test attack number, static penetration Ps value, etc.), and various parameters of geotechnical tests (such as liquidity index, consolidation coefficient, compression modulus, permeability coefficient, compressive strength, softening coefficient, bearing capacity limit value, bearing capacity characteristic value, etc.), and performing single analysis and comprehensive analysis and evaluation to obtain more direct and intuitive useful information.

C6: basic design analysis and evaluation

q _pk-extreme end resistance criterion value (kPa);

(2) analysis and evaluation of pile foundation uplift bearing capacity

T _uk＝∑λ _i q _sik u _i l _i

λ _i-resistance to plucking factor.

C7: analysis and evaluation of foundation pit design

(1) Foundation pit seepage analysis

(2) Checking and calculating the anti-floating stability of the foundation pit:

in the formula:G _k-the sum of the building's dead weight and the weight (kN);

N _w,k-a buoyancy effect value (kN);

C8: other analysis and evaluation

As shown in fig. 5, the geotechnical engineering investigation data visualization display module D realizes visualization investigation result display. The module integrates a ground surface three-dimensional model and a geological three-dimensional model of an engineering investigation working area based on software such as Voxler, Surfer, Grapher and AutoCAD and the like so as to simulate engineering investigation results. The module method comprises the following steps:

d1: obtaining discrete point data

As shown in fig. 11, the discrete data generated in step B5 is acquired, and a vector diagram is created using "VectorPlot".

As shown in fig. 14, in the Voxler three-dimensional data modeling, a surface rendering map may be created by using "FaceRender," a silo rendering map may be created by using "WellRender," a shape rendering map may be created by using "VolRender," and a scatter plot may be created by using "ScatterPlot.

D6: displaying various plan views, section views, bar charts, etc

D7: saving image data and closing the window.

As shown in fig. 6, the geotechnical engineering investigation drawing and data output module e (graphics output) implements the function of drawing various engineering geological drawings. The module finishes drawing most of drawings and tables of geotechnical engineering investigation based on an engineering investigation database, and comprises an actual material map, an exploration point plane arrangement map, a drilling hole histogram, a comprehensive stratum histogram, a flat hole display map, a section map, a tangent plane map, a contour map, a rose map, a polar diagram, a red plane projection map and the like. The module can output various achievement forms such as geotechnical tests, in-situ tests, engineering geophysical prospecting and the like. The module method comprises the following steps:

e1: and updating and correcting data, and when new data are added, adding and deleting the data through the step A2, and correcting by a technician.

E5: a roaming video is derived.

E6: drawing for exporting various two-dimensional results

In the step E6, when the drawing is output, the drawing frame, the scale, the drilling elevation, and the drilling distance marking information are automatically added.

E7: export various achievement forms

In summary, (1) the invention provides a set of method for carrying out three-dimensional modeling analysis and evaluation of intelligent geotechnical engineering investigation, which is highly targeted and easy to master, can quickly construct three-dimensional models of geological elements such as drilling holes, stratums, in-situ tests, geotechnical tests and the like, realizes unification and standardization of the engineering investigation chart manufacturing process, improves the efficiency, saves the cost, and ensures the accuracy, reliability and scientificity of chart drawing;

(2) in the data management link, a method of combining a relational database and a non-relational database is adopted to construct an engineering investigation database and carry out organization and management on investigation original data, intermediate data and result data. Realizing data interchange with professional software such as AutoCAD, Surfer, Grapher, Huaning, Lizheng, MapGIS, ArcGIS, CASS and the like; the attribute query function is utilized to realize digital management and dynamic query of geotechnical engineering investigation;

The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.

Claims

1. The evaluation system is characterized by comprising a geotechnical engineering investigation data management module, a geotechnical engineering investigation data processing and analyzing module, a geotechnical engineering investigation three-dimensional modeling and geotechnical parameter visual analysis and evaluation module, a geotechnical engineering investigation data visual display module and a geotechnical engineering investigation drawing and data output module.

2. The system and method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software according to claim 1, wherein the geotechnical engineering survey data management module comprises the following steps:

a1: establishing engineering and information standardization;

a2: preparing drilling data, converting coordinates, calculating elevation values of the data, and importing the data into a data management module;

a3: preparing indoor geotechnical and in-situ test data and importing the test data into a data management module;

a4: preparing geophysical prospecting data and importing the geophysical prospecting data into a data management module;

a5: importing style data;

a6: importing graphic data;

a7: data storage, statistics and query editing;

the characteristics are as follows:

the database system of the module adopts a distributed database and a mixed distribution mode; the data management module is compatible with the input of various data sources, and acquires original data of exploration field work including but not limited to drilling geology cataloged data, drilling hole three-dimensional position information, hydrogeological data, geophysical prospecting data and related indoor geotechnical and in-situ test data according to the requirements of relevant technical specifications of geotechnical engineering exploration; the method realizes the editing of the survey data and the management of the drilling data, including data organization, editing and modification, lithology (soil) normalization processing and virtual drilling editing.

3. The system and method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software according to claim 1, wherein the geotechnical engineering survey data processing and analyzing module comprises the following steps:

b1: extracting parameters, removing values of data and correcting;

b2: selecting a computing module and connecting the modules;

b3: setting module attributes, defining geological boundary and attribute information of each data point;

b4: data gridding and interpolation calculation;

b5: data discretization, type conversion, data statistics and elimination of error values;

b6: analyzing data;

b7: data storage;

the characteristics are as follows:

the module adopts an advanced interpolation algorithm, and carries out standardization and intellectualization according to various data statistical methods and analysis contents of geotechnical engineering investigation according to the type and process of engineering investigation data analysis and the form of output results.

4. The system and method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software according to claim 1, wherein the module for three-dimensional modeling for geotechnical engineering investigation and visual analysis and evaluation of geotechnical parameters comprises the following steps:

c1: establishing a voxler geotechnical engineering investigation three-dimensional data frame and whitening;

c2: establishing a three-dimensional drilling model, a terrain model, a geologic body initial stratum model and an attribute model;

c3: coupling and modeling stratum structure and attribute data, and performing stratum pinch-out;

c4: generating geotechnical engineering investigation one-way slicing, crossing and comprehensive parameter geological information models;

c5: analyzing and evaluating various geotechnical engineering parameter models;

c6: analyzing and evaluating basic design;

c7: analyzing and evaluating the design of the foundation pit;

c8: other analyses and evaluations;

the characteristics are as follows:

the module automatically constructs a three-dimensional earth surface model, a stratum model and a geological model according to the acquired geotechnical engineering investigation data, and dynamic association and updating among the data can be realized; the geological attributes of each model can be inquired in real time, and the visual analysis of geotechnical engineering parameters can be completed.

5. The system and method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software according to claim 1, wherein the geotechnical engineering survey data visualization display module comprises the following steps:

d1: obtaining discrete point data;

d2: generating a three-dimensional topographic map, a contour map and an exploration point map;

d3: displaying three-dimensional rendering images and scatter diagrams of various types of survey data;

d4: displaying various survey vertical horizontal slice images, orthogonal images and oblique images;

d5: three-dimensional roaming and three-dimensional space information query;

d6: displaying various plan views, section views, bar charts and the like;

d7: saving image data and closing a window;

the characteristics are as follows:

the module integrates a three-dimensional earth surface model and a three-dimensional geological model of an engineering investigation working area based on software such as Voxler, Surfer, Grapher and AutoCAD, and can display various two-dimensional and three-dimensional achievement graphs so as to simulate the engineering investigation achievement more truly.

6. The system and method for three-dimensional analysis and evaluation of smart geotechnical engineering parameters based on voxler software according to claim 1, wherein the geotechnical engineering survey drawing and data output module comprises the following steps:

e1: updating and correcting data; when new data is added, data addition and deletion are carried out through the step A2, and a technician carries out correction;

e2: deriving a three-dimensional topographic map, contour lines and an exploration point mapping;

e3: exporting or intercepting three-dimensional rendering images and scatter diagrams of various types of survey data;

e4: deriving various survey vertical horizontal slice images, orthogonal images and oblique images;

e5: deriving a roaming video;

e6: exporting various two-dimensional achievement drawings;

e7: exporting various achievement tables;

the characteristics are as follows:

the module finishes drawing most of drawings and tables of geotechnical engineering investigation based on an engineering investigation database, and comprises various achievement tables such as an actual material map, an exploration point plane arrangement map, a drilling histogram, a comprehensive stratum histogram, a section map, a tangent plane map, a contour map, a rose pattern, a polar diagram, a red-horizontal projection map, a geotechnical test, an in-situ test, an engineering geophysical prospecting and the like.