CN115564914A - Three-dimensional simulation management system - Google Patents

Three-dimensional simulation management system Download PDF

Info

Publication number
CN115564914A
CN115564914A CN202211319099.2A CN202211319099A CN115564914A CN 115564914 A CN115564914 A CN 115564914A CN 202211319099 A CN202211319099 A CN 202211319099A CN 115564914 A CN115564914 A CN 115564914A
Authority
CN
China
Prior art keywords
data
dimensional
model
module
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202211319099.2A
Other languages
Chinese (zh)
Inventor
高安宁
潘雅静
金光辉
孙锐
张伟
田俊
雷军龙
张群威
曹亚杰
杨小华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Arsc Underground Space Technology Development Co ltd
Original Assignee
Hubei Ruijie Information Integration Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hubei Ruijie Information Integration Co ltd filed Critical Hubei Ruijie Information Integration Co ltd
Priority to CN202211319099.2A priority Critical patent/CN115564914A/en
Publication of CN115564914A publication Critical patent/CN115564914A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T17/00Three dimensional [3D] modelling, e.g. data description of 3D objects
    • G06T17/05Geographic models

Landscapes

  • Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Geometry (AREA)
  • Software Systems (AREA)
  • Remote Sensing (AREA)
  • Computer Graphics (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Geophysics And Detection Of Objects (AREA)

Abstract

The application relates to the technical field of engineering management, in particular to a three-dimensional simulation management system which is beneficial to solving the problems that miscellaneous data in a geological geographic information system reduce the comprehensiveness and usability of geological data utilization. The three-dimensional simulation management system comprises a database generation module, a model initial building module, a model fusion module, a data integration module and a data management module, wherein the database generation module is used for receiving and/or calling data and storing the data into a three-dimensional special subject database in a classified manner, and the data comprise data with different formats; the model initial modeling block generates a drilling data three-dimensional visualization model for determining three-dimensional geological body models of different regions and different stratums according to drilling information in the three-dimensional thematic database; the model fusion module is used for combining the three-dimensional geologic body model and the elevation model above the ground; the data integration module is used for sorting and fusing the data in the three-dimensional special topic database; the data management module is used for managing and displaying the data.

Description

Three-dimensional simulation management system
Technical Field
The application relates to the technical field of engineering management, in particular to a three-dimensional simulation management system.
Background
With the advancement of science and technology, the engineering and geological exploration industry has been changed in a lot, new exploration techniques and new technology are in endless, exploration measures are continuously improved, and exploration results tend to be comprehensive and scientific. The object of engineering geological exploration is a geologic body generated after a long geological historical age, and none of the properties and characteristics of the geologic body are related to the geographic position, so that the GIS technology is applied to the exploration industry, and the establishment of a geological and geographic information system becomes the key point of the work of the exploration industry.
In the process of implementing engineering geological exploration, a plurality of engineering geological and geographic information systems aiming at different regions or different research projects are generally established, then the engineering geological and geographic information is obtained through a GIS technology and stored in a database in the engineering geological exploration information system so as to be convenient for managing and utilizing the engineering geological information.
However, the geological data is distributed among different geological and geographic information systems, and the information systems are numerous and are not associated with each other, so that the comprehensiveness and the usability of the geological data are reduced.
Disclosure of Invention
In order to solve the problem that comprehensive and easy-to-use performance of geological data utilization is reduced by miscellaneous data in a geological geographic information system, the application provides a three-dimensional simulation management system.
The embodiment of the application is realized as follows:
an embodiment of the present application provides a three-dimensional simulation management system, including:
the database generation module is used for receiving and/or calling data and storing the data into the three-dimensional thematic database in a classified manner, wherein the data comprise data with different formats;
the model initial building module is used for generating a drilling data three-dimensional visualization model used for determining three-dimensional geological body models of different areas and different stratums according to drilling information in the three-dimensional thematic database, wherein the three-dimensional geological body model is used for representing an elevation model below the ground, and the three-dimensional geological body model and the three-dimensional visualization model are both stored in the three-dimensional thematic database;
the model fusion module is used for combining the three-dimensional geological body model and the elevation model above the ground and storing the three-dimensional thematic model in the three-dimensional thematic database so as to realize three-dimensional presentation of the project geological thematic data;
the data integration module is used for sorting and fusing the data in the three-dimensional special topic database so as to enable the data to belong according to a preset rule;
and the data management module is used for managing and displaying the data in the three-dimensional thematic database.
In some embodiments, when the elevation of the borehole is higher than the ground elevation data, the model initial modeling block adopts DEM constraint modeling to realize the fusion of the three-dimensional visualization model of the borehole data and the ground elevation data.
In some embodiments, when the borehole elevation is lower than the ground elevation data, the model initial modeling block extends to the DEM elevation according to the top stratum so as to realize the fusion of the three-dimensional visualization model of the borehole data and the ground elevation data.
In some embodiments, the database generation module is further to:
importing data information with different formats such as survey reports, flat sections, bar charts, soil-water tests, rock tests, wave velocity tests, load tests and the like;
and the database generation module is also used for supporting the coverage update of the data of the imported exploration project.
In some embodiments, the database generation module is further configured to, after the standard formation information is established, match the established standard formation with the engineering project formation information in the database, and achieve borehole formation standardization.
In some embodiments, the system further comprises a self-checking module, configured to provide a data warehousing check function, and edit the document data by adding, deleting, and modifying.
In some embodiments, the data management module comprises:
the data presentation sub-module is used for realizing three-dimensional presentation of the project geological thematic data on the basis of the three-dimensional thematic database;
and the data query submodule is used for supporting the query of three-dimensional drilling information and geologic body information and the sectioning analysis, excavation analysis and underground space analysis of the three-dimensional geologic body model.
In some embodiments, during the three-dimensional presentation of the engineering geological topic data, the data presentation submodule is used for implementing a three-dimensional presentation of a drilling space for embodying drilling position information; and/or implementing spatial three-dimensional presentation of the survey project engineering site, the engineering borehole arrangement; and/or realizing the section line space display of the engineering project in a mode of a special layer of the line elements.
In some embodiments, the data presentation sub-module is further configured to present different stratigraphic distributions and contour conditions to quickly extract the geologic body for layered presentation or rotational presentation.
In some embodiments, the data presentation sub-module is further configured to generate a combined report based on the engineering data or the regional engineering data in the three-dimensional thematic database.
The beneficial effect of this application: the database generation module is compatible with data in different formats, and various data can be stored in the same system, so that the richness and usability of the data in the three-dimensional simulation management system are greatly improved, and related personnel can conveniently acquire required information only by opening the three-dimensional simulation management system; further, three-dimensional geologic body models of different regions and different stratums are established, and the three-dimensional geologic body models of different regions and different stratums are fused with an elevation model above the ground, so that the information is organized into structures of different stratums to be associated, the relation among main data is analyzed, and the effective unification of multiple data is promoted; furthermore, by arranging the data management module, related personnel can conveniently and quickly call and read information, and convenience and practicability of the three-dimensional simulation management system are improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and those skilled in the art can obtain other drawings without inventive labor.
FIG. 1 is a schematic block diagram of a three-dimensional simulation management system according to some embodiments of the present application;
FIG. 2 is a schematic diagram of a three-dimensional simulation management system according to further embodiments of the present application;
FIG. 3 is a schematic representation of a three-dimensional visualization model of borehole data generated by a three-dimensional simulation management system according to one or more embodiments of the present application;
FIG. 4 is a schematic illustration of a three-dimensional geological model formed by a three-dimensional simulation management system operating in accordance with one or more embodiments of the present application;
FIG. 5 is a schematic diagram of a three-dimensional representation of a borehole space formed by a three-dimensional simulation management system operating in accordance with one or more embodiments of the present application;
FIG. 6 is an illustration of a drill hole map formed during operation of a three-dimensional simulation management system according to one or more embodiments of the present application.
Detailed Description
To make the objects, embodiments and advantages of the present application clearer, the following description of exemplary embodiments of the present application will clearly and completely describe the exemplary embodiments of the present application with reference to the accompanying drawings in the exemplary embodiments of the present application, and it is to be understood that the described exemplary embodiments are only a part of the embodiments of the present application, and not all of the embodiments.
It should be noted that the brief descriptions of the terms in the present application are only for convenience of understanding of the embodiments described below, and are not intended to limit the embodiments of the present application. These terms should be understood in their ordinary and customary meaning unless otherwise indicated.
The terms "first," "second," "third," and the like in the description and claims of this application and in the above-described drawings are used for distinguishing between similar or analogous objects or entities and not necessarily for describing a particular sequential or chronological order, unless otherwise indicated. It is to be understood that the terms so used are interchangeable under appropriate circumstances.
The terms "comprises" and "comprising," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a product or apparatus that comprises a list of elements is not necessarily limited to all elements expressly listed, but may include other elements not expressly listed or inherent to such product or apparatus.
As one of the important links of engineering construction, the engineering geological exploration industry obviously improves the speed and quality of single engineering exploration work, and meets the requirement of rapid development of urban construction to a certain extent. Compared with the development of exploration means and exploration methods, the management and utilization of exploration data are in a relatively lagged state, most of the exploration data accumulated for decades are high, and the original engineering geological exploration data serving as information resources are difficult to share, so that the waste of repeated exploration work is caused, and the difficulty is brought to the utilization of the method for researching the urban engineering geological overall law and scientifically planning the city.
The establishment of engineering investigation three-dimensional simulation management system is specially proposed in "construction investigation technical policy" of construction department, and said system is characterized by that it utilizes the comprehensive arrangement of the data of stratum distribution under the earth surface, rock-soil layer composition and its physical and mechanical properties, underground water and structure, etc. to make the dispersed data systematized and standardized, and make the single-element data become comprehensive data, and make the work result be converted into working resource.
However, since the properties and characteristics of geologic bodies are related to geographical locations, at present, different three-dimensional simulation management systems need to be established for data storage in different geology and different research fields, and various data management systems are either established for specific projects or limited to specific requirements and applications, so that various engineering geological data and geological three-dimensional models are collected by the existing various data management systems, and further, since geological data include different formats such as data, documents and charts and different data types, the geological data are often stored in different systems, which is very easy to cause inefficient communication, and reduces the comprehensiveness and usability of geological data utilization.
In summary, in the face of huge data processing work, a technical breakthrough to be solved urgently is to realize the functions of integrating, processing and calling data quickly and conveniently, which requires a database construction system to be comprehensive and easy to use. The invention carries out targeted research, combines the professional characteristics of engineering geology and the system design principles of completeness, normalization, high efficiency, applicability, expandability, advancement, reliability and the like, divides the engineering geology three-dimensional management system into a plurality of modules, the modules have synergistic action, can be compatible with data in various formats, and systematically summarizes various related data in the engineering geology three-dimensional management system, and realizes the unification of main data by organizing related information into the structure of a map layer table and analyzing the relationship among all main data tables, thereby achieving the comprehensive utilization of the system and improving the comprehensiveness and convenience of the engineering exploration three-dimensional simulation management system.
The technical solutions in the present application will be discussed below with reference to specific embodiments.
Fig. 1 is a schematic structural diagram of a three-dimensional simulation management system. As shown in fig. 1, the three-dimensional simulation management system includes a database generation module, a model initial building module, a model fusion module, a data integration module, and a data management module, wherein:
the database generation module is used for receiving and/or calling the survey data, the survey data comprises result data and data of various engineering survey projects, the data can be input in a manual input system mode, the data in other data sources can be called through the database generation module, for example, completed survey project results can be imported into the database generation module according to the attribute data of the engineering survey projects, or files in mdb format of single or multiple engineering surveys can be directly called through the database generation module, and document data in different formats capable of realizing the engineering survey projects can be imported in single or batch mode. Then, the data is subjected to forgery removal and truth preservation, and is classified and sorted to form a three-dimensional special subject database. The data comprises documents, data, pictures and other data with different formats, for example, the data in the three-dimensional special subject database comprises engineering information, basic drilling information, drilling stratum information, in-situ test data, indoor geotechnical test and other data.
It should be noted that the documentation may include contracts (entrusts), survey plans, survey reports, flat-section profiles, geotechnics, in-situ test result tables, photographs of drill cores, and the like. The database generation module can read drilling data in other databases, the read data exist in a three-dimensional special subject database in a three-dimensional columnar drilling mode, and data information with different formats such as survey reports, flat sections, histograms, soil and water tests, rock tests, wave velocity tests, load tests and the like can be imported into the database generation module. In addition, the classification management of the data can be carried out in a manual configuration mode, and the classification organization management of the engineering data can also be carried out through a database generation module according to a predefined data type.
In some embodiments, the database generation module may also support overlay updates to the warehoused survey project data, thereby promoting the timeliness and validity of information in the three-dimensional simulation management system. In some embodiments, as shown in fig. 2, the three-dimensional simulation management system includes a self-checking module, where the self-checking module is configured to provide a data warehousing checking function, check whether a project is warehoused by a project number and a project name, and edit document data such as adding, deleting, and modifying.
It should be noted that, in some embodiments, a single or multiple standard strata in the standard stratum hierarchy table are added to the database generation module by way of manual creation or direct import, and the database generation module may manage multiple standard stratum versions and provide a function of creating a standard stratum, for example, a standard stratum is defined according to a stratum of a certain region, or a standard stratum table is created according to a main layer, a sub layer and a sub layer, and a stratum number in the three-dimensional thematic database may be automatically read in by way of loading a stratum tree and importing a standard stratum for drilling, and the read stratum may be referred to for creating a standard stratum. In some embodiments, after the standard stratum information is established, the database generation module matches the established standard stratum with the engineering project stratum information in the three-dimensional special topic database to realize borehole stratum standardization. And then, the database generation module can modify and edit the standard stratum information, wherein the editing content of the stratum comprises the stratum code number, the stratum number, the geological age, the stratum description information and the like of the standard stratum, and the symbolic information such as the pattern, the color and the like of the standard stratum.
Just because the three-dimensional simulation management system in this application can be compatible the data of different formats, and can all accomodate in same system after all kinds of data are distinguished, greatly improved the richness and the ease for use of data in the three-dimensional simulation management system, relevant personnel only need open the three-dimensional simulation management system in this application, can conveniently acquire required information.
And the model initial building module is used for generating a drilling data three-dimensional visualization model for determining three-dimensional geological body models of different regions and different stratums according to the drilling hole diameter and the hole depth in the three-dimensional special subject database and soil layer information contained in the drilling hole, so as to realize three-dimensional geological body modeling in different ranges. And the three-dimensional geological body models of different areas and different stratums are used for representing an elevation model below the ground, and the three-dimensional geological body model and the three-dimensional visualization model of the drilling data are stored in a three-dimensional special subject database.
It should be noted that the drilling data is point source information, which is substantially the effective layering of the original point and line data, and the generation of each layer or entity by applying the surface construction method according to the elevation of each layer. The three-dimensional geological modeling is established based on the drilling data, and the model is suitable for the ideal situation that the drilling hole is vertically stratified and the stratum is equal in thickness, and is developed to the common situation that STP and GTP are suitable for the drilling hole which is not vertical and the stratum is unequal in thickness. As shown in the three-dimensional visualization model of the borehole data shown in fig. 3, different strata can be represented by different colors in a borehole data histogram in the three-dimensional visualization model of the borehole data, and the same color represents the same stratum, so that the color of the established three-dimensional visualization model of the borehole data is reasonable and beautiful, and meets the specification requirements. It should be noted that the closer the borehole data is to the surface, the more likely it is that the same height is in different formations. At present, a large number of two-dimensional geological profiles can be generated by a profile framework method, and then a three-dimensional geological model expressed by each level surface is generated by applying a curved surface construction method, as shown in fig. 4.
It should be noted that the three-dimensional geologic body models of different regions and different stratums comprise a full-region single-stratum three-dimensional geologic body model, a block-range full-stratum three-dimensional geologic body model and an engineering investigation project range full-stratum three-dimensional geologic body model, wherein the full-region single-stratum three-dimensional geologic body model can be generated by selecting full-region single-stratum drilling data in the visual modeling view to represent the distribution condition of the stratum in the full-region range. And selecting full-stratum drilling data of a specific area in the visual modeling view to generate a block-range full-stratum three-dimensional geologic body model. And selecting universe full-layer drilling data from the visual model view to generate a full-engineering investigation project range full-stratum three-dimensional geologic body model. It is understood that universe refers to the entire survey area, a particular area may be an independent project area or a small area to be studied, and a three-dimensional geologic body has information on elevation, formation, thickness, earth work, in-situ test, etc. as we survey a two-dimensional profile.
In an actual production environment, due to the difference of data acquisition time or other reasons, ground elevation data, namely DEM data, is different from drilling elevation data in exploration engineering data, so that a geological body model established according to the drilling elevation is poor in surface fitting effect, in some embodiments, a model initial modeling block needs to compare the drilling elevation and the DEM data, and when the drilling elevation is higher than the DEM, the model initial modeling block adopts DEM constraint modeling to realize the fusion of a three-dimensional visualization model of the drilling data and the ground elevation data; when the drilling elevation is lower than the DEM, the model initial modeling block extends to the DEM elevation according to the top stratum so as to realize the three-dimensional visualization model of the drilling data and the fusion of the ground elevation data.
The model fusion module can combine three-dimensional geological body models of different areas and different stratums with an elevation model above the ground and store the three-dimensional thematic data into a three-dimensional thematic database so as to realize three-dimensional presentation of project geological thematic data, and at the moment, the elevation of an underground building and the elevation of an above-ground model can be conveniently integrated together. The three-dimensional geologic body model is combined with the geotechnical engineering investigation major, so that the integrated output of the above-ground model, the underground structure and the geologic body model is realized, the reference and the analysis of related personnel are facilitated, and the convenience of using the three-dimensional simulation management system by the related personnel is greatly improved.
By establishing three-dimensional geologic body models of different areas and different stratums and fusing the three-dimensional geologic body models of different areas and different stratums with an elevation model above the ground, the method is beneficial to organizing related information into structures of different stratums to be associated, analyzes the relation among main data, and promotes effective unification of multiple data.
The data integration module is used for sorting and fusing the data in the three-dimensional special topic database so as to enable the data to belong according to a preset rule. Because the data in each module is stored in the three-dimensional special topic database, the data in the three-dimensional special topic database can be organized through the data integration module, the preset rule can be that each piece of data of the same project in the three-dimensional special topic database is belonged to a file, or that the data of the same category in the three-dimensional special topic database is placed in the same folder, and the preset rule of data integration is not specifically limited in this embodiment.
The data management module manages and displays the geological body model established by utilizing the drilling data based on DEM constraint in a layer form, stores the geological body model under a local corresponding folder, realizes the display of the generated three-dimensional geological body model in a scene, and can perform display control by realizing a switch model layer.
The data management module comprises a data presentation sub-module and a data query sub-module, the data presentation sub-module is connected with the data query sub-module through communication data, wherein the data presentation sub-module is used for realizing three-dimensional presentation of project geological special data based on a three-dimensional special topic database, such as project space three-dimensional presentation, section line space three-dimensional presentation or drilling space three-dimensional presentation, and the drilling space three-dimensional presentation mode is shown in figure 5. The data query submodule can realize the query of three-dimensional drilling information and geologic body information, and the sectioning analysis, excavation analysis and underground space analysis of the three-dimensional geologic body model.
In some embodiments, the data presentation sub-module can generate a drilling histogram of any exploration point position in an engineering exploration project, wherein the drilling histogram contains information such as stratum sequence, thickness, rock-soil layer type, sampling position and test data of a drilling hole, and is a comprehensive display of stratum sequence, thickness, lithology change, sampling position and test data of the drilling hole. The data presentation sub-module is further capable of generating an engineering geological profile according to a profile line or a custom profile line, wherein the profile line comprises an existing profile line of an engineering investigation project and a newly drawn profile line of a selected drill hole. The profile map can visually show the internal structure of the geologic body, and the generation of the engineering geologic profile map is realized by selecting a newly drawn section line of the engineering borehole according to the section line of an exploration project.
In the process of realizing three-dimensional presentation of the drilling space through the data presentation submodule and when realizing distribution presentation of the drilling positions in a point thematic layer mode, as shown in fig. 6, the data presentation submodule presents information including drilling numbers and drilling types on a user interface, and drilling display or hiding can be realized through a switch layer. And at the moment, the data presentation submodule can mark the drilled holes in a combined coding mode of the engineering number and the drilling number.
When the three-dimensional presentation of the engineering project space is realized through the data presentation submodule, the data presentation submodule can use the engineering serial number or the engineering name as an index to realize the three-dimensional presentation of the spatial arrangement of the exploration project engineering place and the engineering drilling, and can also realize the display or the hiding of the engineering project through the switch layer.
When the three-dimensional presentation of the engineering project section line space is realized through the data presentation submodule, the data presentation submodule realizes the section line space presentation of the engineering project in a mode of a line element thematic layer, wherein in the three-dimensional presentation image of the engineering project section line space, presentation information comprises a section line number and a section line initial drilling hole number, and at the moment, the data presentation submodule can realize the display or the hiding of the section line through a switch layer.
In some embodiments, the data presentation submodule can present different stratigraphic distributions and contour line conditions in a user-defined range, and can find out the positions with the maximum and minimum thicknesses of different stratums; the platform can rapidly extract the geologic body in a local small area (according to planning red line control), and layered display and rotary display are carried out. It is understood that the generated three-dimensional geological model can be exported from the system to software or plug-ins, and can be displayed integrally or hierarchically as an independent survey result.
In the working process of the data presentation sub-module, the data query sub-module can realize the query analysis function of the drilling information and the detailed information of the engineering project by picking up point positions, drawing a region range or drawing a buffer range. For example, by selecting the picked-up drill hole, basic attribute information of the drill hole, including basic information such as a drill hole number, a drill hole type, a drilling depth, an XY coordinate, an orifice elevation and the like, can be checked, meanwhile, original engineering information, regional engineering information, test data and the like of the drill hole can be checked, the selected drill hole can be made to generate a two-dimensional or three-dimensional histogram according to a predefined histogram template through selection of the drill hole, and a query result is displayed on a user interface in the form of an image through a data presentation sub-module. In other embodiments, the data query submodule may draw a region range (including a rectangular region, a circular region and a polygonal drawing region) in the view of the visual modeling, so as to query all drilling data and engineering data within the region range, or may select a certain drilling to view detailed information of the drilling, and the query result is displayed on the user interface through the data presentation submodule in a list form. In addition, the data query submodule can also draw a buffer line or select a drill hole in a visual modeling view, set a buffer radius, query drill holes and engineering information in a buffer range, and display a query result in a list form through the data presentation submodule, at the moment, relevant personnel can view the basic information of the drill hole through selecting the drill hole, select the engineering to view the basic information of the engineering, and can also select any drill hole to be connected into a cutting line and then generate a two-dimensional and three-dimensional sectional view.
In some embodiments, the data presentation sub-module may further generate a combined report based on the engineering data or the regional engineering data in the three-dimensional thematic database, such as a survey point list generated by statistical summary, a formation statistical table, a geotechnical test result table, and a physical and mechanical property statistical table. When the data presentation submodule generates an exploration point list function by using the header template, part or all of exploration points under the current engineering can be selected to participate, the exploration points are checked, basic information and test information of the finally selected exploration points are obtained, an exploration point list is generated, and at the moment, the basic information of the exploration points, including exploration point types, drilling depths, exploration point numbers and the like, can be checked through the exploration point list; the generated survey point list supports browsing and can be saved as Excel file output.
And the data presentation sub-module acquires the data of the drilling basic data table for statistical calculation and outputs a stratum statistical table. At the moment, the stratum attributes can be checked through the stratum statistical table, the stratum attributes comprise statistical item values such as layer top depth, layer thickness and layer top elevation, and the generated stratum statistical table supports browsing and can be additionally stored as an Excel file for outputting.
And the data presentation submodule generates an index summary table from the data of the indoor test data table in a header form, looks up test data such as the depth, the mass density, the natural water content and the soil particle specific gravity of a drilled hole, and generates a geotechnical test result table which supports browsing and can be stored as an Excel file for outputting.
It is understood that the physical mechanics statistical table makes statistical calculations based on the basic data of the borehole, in-situ tests and laboratory test data. The data presentation submodule generates a statistical table by using a header form, the number, the maximum value, the minimum value, the average value, the standard deviation, the variation coefficient, the standard value and the like of samples such as in-situ test data, indoor test data and the like can be checked, and the generated statistical table supports browsing and can be stored as an Excel file for outputting.
It can be understood that the fuzzy query of the document data can be realized by inputting the key information of the document data to the data query submodule, and the quick and accurate query of the document data of a certain engineering project can be realized by using the engineering number or the engineering name as an index, and the browsing and downloading of the document data can be realized. For example, the data query submodule selects an engineering project from a data project list in the three-dimensional thematic database, and exports the engineering project to a specified directory, at this time, original drilling data and test data (including physical mechanics, soil thickness, dynamic exploration and penetration) under the engineering project can be exported to mdb files, so that the analysis of related personnel is facilitated.
The data query submodule can also be used for extracting the geologic body in the local area, on one hand, the geologic body in the selected area can be extracted, on the other hand, the geologic body in the selected area can be removed, and the rest unselected parts are presented in a three-dimensional geologic body form. And the data query submodule can realize horizontal sectioning, vertical sectioning, delamination analysis, excavation analysis (earth volume calculation of each stratum) and the like of the geologic body, and carries out layering and transparentization treatment on the three-dimensional geologic model, so that underground pipelines and other underground structures can be browsed independently.
The data query sub-module can also add a configuration file for geological service to record the related map layer of the underground space, and the current situation of deep utilization can be analyzed and queried according to the configuration file. For example, in the design of a foundation pit support, a certain distance is buffered outwards according to the boundary and the depth of the foundation pit, and pipelines and structures within the buffer distance are displayed and can be integrally exported and displayed.
It should be noted that, the whole consultation process can be performed efficiently and orderly by using the interactive service to perform query, analysis and assistant decision on the request of the client through the data query submodule.
In conclusion, the three-dimensional simulation management system can realize good lap joint between the underground model and the ground model and even between the underground pipe gallery, can also realize the common display of the underground three-dimensional model and the underground pipe gallery, pipelines, ground building models and the like in a local area, and can inquire related attribute information (geological age, elevation, thickness, geotechnical test information, in-situ test information and the like) of a stratum when a certain stratum is selected, thereby greatly facilitating the process of managing and using geological data by related personnel.
In addition, it is worth mentioning that the method takes a large amount of engineering geology and engineering survey data as main information sources over the years, integrates information of buildings, municipal infrastructure and the like, takes GIS software as a platform, and builds a practical and effective three-dimensional simulation management system as an efficient and easy-to-use engineering geology database management platform. After being developed, the three-dimensional simulation management system can be delivered and used after trial operation is successful. The three-dimensional simulation management system improves the information resource sharing degree, saves the management cost and the communication cost and initially realizes the auxiliary decision support function through the mutual cooperation of all the modules; the ground and the underground are integrated, the scientificity of decision making is improved, and full life cycle service is provided for early evaluation, simulation construction, operation management and future transformation and updating of construction projects. For example, the establishment of the three-dimensional simulation management system can provide services for urban engineering geological zoning, engineering geological mapping, seismic plot research, urban disaster prevention, geological environment protection and recovery and the like.
The embodiment has the advantages that the database generation module is compatible with data in different formats, various data can be identified and stored in the same system, the richness and the usability of the data in the three-dimensional simulation management system are greatly improved, and relevant personnel can conveniently acquire required information only by opening the three-dimensional simulation management system; further, three-dimensional geologic body models of different regions and different stratums are established, and the three-dimensional geologic body models of different regions and different stratums are fused with an elevation model above the ground, so that the information is organized into structures of different stratums to be associated, the relation among main data is analyzed, and the effective unification of multiple data is promoted; furthermore, by arranging the data management module, related personnel can conveniently and quickly call and read information, and convenience and practicability of the three-dimensional simulation management system are improved. All modules are matched together, so that the usability and comprehensiveness of the whole three-dimensional simulation management system are promoted.
The foregoing description, for purpose of explanation, has been described with reference to specific embodiments. However, the foregoing discussion in some embodiments is not intended to be exhaustive or to limit the embodiments to the precise forms disclosed above. Many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles and the practical application, to thereby enable others skilled in the art to best utilize the embodiments and various embodiments with various modifications as are suited to the particular use contemplated.

Claims (10)

1. A three-dimensional simulation management system, comprising:
the database generation module is used for receiving and/or calling data and storing the data into the three-dimensional thematic database in a classified manner, wherein the data comprise data with different formats;
the model initial building module is used for generating a drilling data three-dimensional visualization model used for determining three-dimensional geological body models of different areas and different stratums according to drilling information in the three-dimensional special topic database, wherein the three-dimensional geological body model is used for representing an elevation model below the ground, and the three-dimensional geological body model and the three-dimensional visualization model are both stored in the three-dimensional special topic database;
the model fusion module is used for combining the three-dimensional geological body model and the elevation model above the ground and storing the three-dimensional thematic model in the three-dimensional thematic database so as to realize three-dimensional presentation of the project geological thematic data;
the data integration module is used for sorting and fusing the data in the three-dimensional special topic database so as to enable the data to belong according to a preset rule;
and the data management module is used for managing and displaying the data in the three-dimensional special topic database.
2. The three-dimensional simulation management system according to claim 1, wherein when the borehole elevation is higher than the ground elevation data, the model initial modeling block adopts DEM constraint modeling to realize the fusion of the three-dimensional visualization model of the borehole data and the ground elevation data.
3. The three-dimensional simulation management system according to claim 2, wherein when the borehole elevation is lower than the ground elevation data, the model initial modeling block extends to the DEM elevation according to the top stratum so as to realize the fusion of the three-dimensional visualization model of the borehole data and the ground elevation data.
4. The three-dimensional simulation management system of claim 1, wherein the database generation module is further configured to:
importing data in different formats such as survey reports, flat sections, bar charts, soil-water tests, rock tests, wave velocity tests, load tests and the like;
and the database generation module is also used for supporting the coverage update of the data of the imported exploration project.
5. The three-dimensional simulation management system according to claim 4, wherein the database generation module is further configured to match the established standard formation with the formation information of the project in the database after the standard formation information is established, so as to achieve the standardization of the borehole formation.
6. The three-dimensional simulation management system according to claim 1, further comprising a self-check module for providing a function of data warehousing check and editing document data such as adding, deleting and modifying.
7. The three-dimensional simulation management system of claim 1, wherein the data management module comprises:
the data presentation submodule is used for realizing three-dimensional presentation of the project geological thematic data on the basis of the three-dimensional thematic database;
and the data query submodule is used for supporting the query of three-dimensional drilling information and geologic body information and the sectioning analysis, excavation analysis and underground space analysis of the three-dimensional geologic body model.
8. The three-dimensional simulation management system of claim 7, wherein, during the three-dimensional presentation of the engineering geological topic data, the data presentation sub-module is configured to implement a three-dimensional presentation of a drilling space for embodying drilling position information; and/or realizing the spatial three-dimensional presentation of the engineering sites and the engineering drilling arrangement of the exploration project; and/or realizing the section line space display of the engineering project in a mode of a special layer of the line elements.
9. The three-dimensional simulation management system according to claim 8, wherein the data presentation sub-module is further configured to present different stratigraphic distributions and contour conditions, so as to extract geologic bodies rapidly, and perform hierarchical presentation or rotational presentation.
10. The three-dimensional simulation management system of claim 8, wherein the data presentation sub-module is further configured to generate a combined report based on the engineering data or the regional engineering data in the three-dimensional topical database.
CN202211319099.2A 2022-10-26 2022-10-26 Three-dimensional simulation management system Pending CN115564914A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211319099.2A CN115564914A (en) 2022-10-26 2022-10-26 Three-dimensional simulation management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211319099.2A CN115564914A (en) 2022-10-26 2022-10-26 Three-dimensional simulation management system

Publications (1)

Publication Number Publication Date
CN115564914A true CN115564914A (en) 2023-01-03

Family

ID=84768132

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211319099.2A Pending CN115564914A (en) 2022-10-26 2022-10-26 Three-dimensional simulation management system

Country Status (1)

Country Link
CN (1) CN115564914A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117435579A (en) * 2023-12-21 2024-01-23 四川正基岩土工程有限公司 Data management system based on geotechnical engineering three-dimensional modeling

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117435579A (en) * 2023-12-21 2024-01-23 四川正基岩土工程有限公司 Data management system based on geotechnical engineering three-dimensional modeling
CN117435579B (en) * 2023-12-21 2024-03-12 四川正基岩土工程有限公司 Data management system based on geotechnical engineering three-dimensional modeling

Similar Documents

Publication Publication Date Title
Kessler et al. The capture and dissemination of integrated 3D geospatial knowledge at the British Geological Survey using GSI3D software and methodology
CN110807023B (en) Survey management and data intelligent analysis system and method based on GIS
CN104732359A (en) Oil field geographic information and exploration development collaboration work platform system
CN104834518A (en) Oilfield exploitation and development working platform system
McCarthy et al. A GIS-based borehole data management and 3D visualization system
CN110211231B (en) Three-dimensional geological disaster information model modeling method
Zhang et al. The BIM-enabled geotechnical information management of a construction project
Mierzejowska et al. The characteristics of geographical information systems in terms of their current use
CN116486025A (en) Urban geological data processing platform based on big data cloud computing technology
Dodagoudar An integrated geotechnical database and GIS for 3D subsurface modelling: Application to Chennai City, India
CN115564914A (en) Three-dimensional simulation management system
CN117436054B (en) Geotechnical engineering big data sharing platform
Kokkala et al. An engineering geological database for managing, planning and protecting intelligent cities: The case of Thessaloniki city in Northern Greece
Camp et al. GIS procedure for developing three-dimensional subsurface profile
US20130346394A1 (en) Virtual tree
Oloufa et al. Construction applications of relational data bases in three-dimensional GIS
KR101585053B1 (en) Management apparatus of geothermal resource information with the management interface and the information supply method thereof
Pierdicca et al. Development of a GIS environment for archaeological multipurpose applications: the Fano historic centre
CN117435579B (en) Data management system based on geotechnical engineering three-dimensional modeling
Strassberg et al. Arc hydro groundwater data model and tools: overview and use cases
Khudaykulovich et al. Application geoinformational technologies in hydrogeological research
Mehri‐e‐Sedighi Use of geographical information system (GIS) in the cataloging of documents: A case study of earthquake documents collections
Veeger et al. Harnessing the power of relational databases for managing subsurface geotechnical and geologic data
Lawrence The development of a geotechnical GIS-based database in Austin, TX
CN117289842A (en) Method, device, electronic equipment and computer readable medium for informationizing oil-gas data

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right

Effective date of registration: 20230712

Address after: 710199 Shenzhou four road 216, Xi'an Aerospace base, Shaanxi

Applicant after: ARSC UNDERGROUND SPACE TECHNOLOGY DEVELOPMENT Co.,Ltd.

Address before: 10/F, Huafa Siji Phase II Office Building, No. 19, Meilin East Road, Hanyang District, Wuhan City, 430000 Hubei Province

Applicant before: Hubei Ruijie Information Integration Co.,Ltd.

TA01 Transfer of patent application right