CN116486025A - Urban geological data processing platform based on big data cloud computing technology - Google Patents
Urban geological data processing platform based on big data cloud computing technology Download PDFInfo
- Publication number
- CN116486025A CN116486025A CN202310416731.3A CN202310416731A CN116486025A CN 116486025 A CN116486025 A CN 116486025A CN 202310416731 A CN202310416731 A CN 202310416731A CN 116486025 A CN116486025 A CN 116486025A
- Authority
- CN
- China
- Prior art keywords
- data
- dimensional
- model
- geological
- modeling
- 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
Links
- 238000012545 processing Methods 0.000 title claims abstract description 81
- 238000005516 engineering process Methods 0.000 title claims abstract description 37
- 238000007726 management method Methods 0.000 claims abstract description 40
- 230000000007 visual effect Effects 0.000 claims abstract description 28
- 238000010276 construction Methods 0.000 claims abstract description 23
- 238000011161 development Methods 0.000 claims abstract description 21
- 238000013079 data visualisation Methods 0.000 claims abstract description 19
- 238000013499 data model Methods 0.000 claims abstract description 12
- 238000003860 storage Methods 0.000 claims abstract description 11
- 238000013480 data collection Methods 0.000 claims abstract description 8
- 238000007792 addition Methods 0.000 claims abstract description 5
- 238000012217 deletion Methods 0.000 claims abstract description 5
- 230000037430 deletion Effects 0.000 claims abstract description 5
- 238000012795 verification Methods 0.000 claims abstract description 4
- 238000004458 analytical method Methods 0.000 claims description 89
- 238000005553 drilling Methods 0.000 claims description 84
- 230000006870 function Effects 0.000 claims description 72
- 238000000034 method Methods 0.000 claims description 50
- 238000005520 cutting process Methods 0.000 claims description 43
- 238000011156 evaluation Methods 0.000 claims description 28
- 238000009826 distribution Methods 0.000 claims description 26
- 230000002452 interceptive effect Effects 0.000 claims description 22
- 238000012423 maintenance Methods 0.000 claims description 22
- 230000018109 developmental process Effects 0.000 claims description 20
- 238000004364 calculation method Methods 0.000 claims description 19
- 238000010586 diagram Methods 0.000 claims description 19
- 238000011835 investigation Methods 0.000 claims description 18
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 17
- 239000000463 material Substances 0.000 claims description 15
- 230000008569 process Effects 0.000 claims description 14
- 238000013523 data management Methods 0.000 claims description 13
- 238000001914 filtration Methods 0.000 claims description 13
- 238000006243 chemical reaction Methods 0.000 claims description 12
- 230000000694 effects Effects 0.000 claims description 10
- 238000012360 testing method Methods 0.000 claims description 10
- 230000010354 integration Effects 0.000 claims description 9
- 238000013507 mapping Methods 0.000 claims description 9
- 238000012876 topography Methods 0.000 claims description 9
- 230000003993 interaction Effects 0.000 claims description 8
- 239000000126 substance Substances 0.000 claims description 8
- 238000012800 visualization Methods 0.000 claims description 8
- 230000008859 change Effects 0.000 claims description 7
- 238000005192 partition Methods 0.000 claims description 7
- 230000003044 adaptive effect Effects 0.000 claims description 6
- 238000009933 burial Methods 0.000 claims description 6
- 238000004141 dimensional analysis Methods 0.000 claims description 6
- 230000007613 environmental effect Effects 0.000 claims description 6
- 238000005259 measurement Methods 0.000 claims description 6
- 238000005728 strengthening Methods 0.000 claims description 6
- 238000012544 monitoring process Methods 0.000 claims description 5
- 238000012216 screening Methods 0.000 claims description 5
- 230000009471 action Effects 0.000 claims description 4
- 230000008878 coupling Effects 0.000 claims description 4
- 238000010168 coupling process Methods 0.000 claims description 4
- 238000005859 coupling reaction Methods 0.000 claims description 4
- 238000011068 loading method Methods 0.000 claims description 4
- 230000003068 static effect Effects 0.000 claims description 4
- 230000008901 benefit Effects 0.000 claims description 3
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000004422 calculation algorithm Methods 0.000 claims description 3
- 230000004927 fusion Effects 0.000 claims description 3
- 230000002123 temporal effect Effects 0.000 claims description 3
- 238000013142 basic testing Methods 0.000 claims description 2
- 230000006835 compression Effects 0.000 claims description 2
- 238000007906 compression Methods 0.000 claims description 2
- 238000013210 evaluation model Methods 0.000 claims description 2
- 239000011521 glass Substances 0.000 claims description 2
- 239000007787 solid Substances 0.000 claims description 2
- 230000011218 segmentation Effects 0.000 claims 2
- 239000010410 layer Substances 0.000 description 40
- 230000015572 biosynthetic process Effects 0.000 description 13
- 238000005755 formation reaction Methods 0.000 description 13
- 239000003673 groundwater Substances 0.000 description 10
- 230000008520 organization Effects 0.000 description 7
- 238000011049 filling Methods 0.000 description 6
- 229910052500 inorganic mineral Inorganic materials 0.000 description 6
- 239000011707 mineral Substances 0.000 description 6
- 238000012986 modification Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 239000011435 rock Substances 0.000 description 6
- 238000013500 data storage Methods 0.000 description 4
- 238000013461 design Methods 0.000 description 4
- 238000013439 planning Methods 0.000 description 4
- 238000011160 research Methods 0.000 description 4
- 230000008676 import Effects 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 210000004258 portal system Anatomy 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 229910052729 chemical element Inorganic materials 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 230000035699 permeability Effects 0.000 description 2
- 238000009877 rendering Methods 0.000 description 2
- 239000002689 soil Substances 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000033558 biomineral tissue development Effects 0.000 description 1
- 230000003139 buffering effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 239000003245 coal Substances 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011157 data evaluation Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000002224 dissection Methods 0.000 description 1
- 238000004880 explosion Methods 0.000 description 1
- 238000013213 extrapolation Methods 0.000 description 1
- 238000007499 fusion processing Methods 0.000 description 1
- 238000011065 in-situ storage Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 239000011229 interlayer Substances 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000000704 physical effect Effects 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000007639 printing Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 230000005855 radiation Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
- G06T17/05—Geographic models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Geometry (AREA)
- Remote Sensing (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computer Graphics (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention provides a city geological data processing platform based on big data cloud computing technology, which relates to the field of city geological information, and a data collection module is used for obtaining geological data; the database construction module is used for constructing databases of different types of data layers according to the types of the geological data so as to store the geological data; the data processing module is used for analyzing the acquired geological data types and dividing the geological data types into corresponding data layer databases for storage; performing addition, deletion and verification on the geological data based on a control instruction input by a user; the data visualization processing module is used for constructing a data model and realizing two-dimensional and three-dimensional integrated visual processing; and the supporting platform is used for integrally managing and displaying three-dimensional information in the air, on the ground, on the earth surface and under the ground, so that the full sharing of multidimensional space-time information is realized. The platform provides a comprehensive, intelligent and standardized tool platform, provides a geological science basis for users, and improves the development and management level of urban science.
Description
Technical Field
The invention relates to the field of urban geological information, in particular to an urban geological data processing platform based on a big data cloud computing technology.
Background
Urban geological information refers to the nature and characteristics of urban geology. The urban geological system mainly refers to the material composition, structure, construction, development history and the like of the urban geology, including physical properties, chemical properties, rock properties, mineral components, the output states of rock strata and rock bodies, contact relation, transition history of urban geology information, occurrence conditions and distribution rules of mineral resources and the like.
In the prior art, the problem of processing urban geological data exists, such as a large geological data application platform for urban planning construction disclosed in application number 201911143534.9, and the file comprises a core platform server, a background management module, a data application module, a data storage module and a data input unit which are all connected with the core platform server; the data application module comprises a project integrating unit, a project scheme unit and a project analysis unit; the data storage module includes a material data unit, a project data unit, and a graphic data unit. When the file is used for creating a building project, only key data and calibration data are required to be input, and a project schema document and budget can be obtained; according to the requirements of the current urban geological data and project data, the file obtains a site three-dimensional visual effect and displays a detail data effect during construction; the clients can voluntarily upload the project data of themselves so as to achieve the collection and larger sharing of the urban geological data.
However, the file cannot integrally manage and display three-dimensional information in the air, on the ground, on the earth and underground, three-dimensional space information cannot be formed, and as the city is continuously developed and built and the environment is continuously changed, geological data are continuously changed, so that a large amount of geological data can be generated. The three-dimensional model attribute maintenance cannot be effectively updated, so that the effective utilization of geological data is affected, the utilized urban geological database cannot be satisfied, and the conditions of urban hydrology, engineering geological structures, underground space, underground pipe network and the like can be comprehensively, rapidly and accurately mastered.
Disclosure of Invention
The invention provides a city geological data processing platform based on a big data cloud computing technology, which is used for effectively updating the attribute maintenance of a three-dimensional model, further affecting the effective utilization of geological data, meeting the requirements of an utilized city geological database, and comprehensively, quickly and accurately grasping the conditions of city hydrology, engineering geological structures, underground space, underground pipe network and the like.
The platform includes: the system comprises a data collection module, a data processing module, a database construction module and a data visualization processing module; the data collection module is used for obtaining geological data; the database construction module is used for constructing databases of different types of data layers according to the types of the geological data so as to store the geological data; wherein the data layer database comprises: an original data layer database, a basic data layer database and a result data layer database; the data processing module is used for analyzing the acquired geological data types and dividing the geological data types into corresponding data layer databases for storage; performing addition, deletion and verification on the geological data based on a control instruction input by a user; the data visualization processing module is used for constructing a data model integrated unit, a data management integrated unit, a data visualization unit and a development integrated unit, so as to realize two-dimensional and three-dimensional integrated visual processing; and the supporting platform is used for integrally managing and displaying three-dimensional information in the air, on the ground, on the earth surface and under the ground, so that the full sharing of multidimensional space-time information is realized.
From the above technical scheme, the invention has the following advantages:
the urban geological data processing platform based on the big data cloud computing technology utilizes the modern database technology, the GIS technology, the three-dimensional visualization technology and the big data cloud computing technology to design and develop the urban geological informatization platform which integrates the basic geography, basic geology, engineering geology, hydrogeology, environmental geology, underground space development and utilization, underground pipe network and other multi-specialty and multi-parameter three-dimensional geological data input, management, visualization and analysis and evaluation, has comprehensive functions and stable performance.
The urban geological data processing platform based on the big data cloud computing technology surrounds the demands of urban planning construction and development on geological resources and geological environment, on the basis of collecting the existing data by a system, establishes an urban geological information platform through various investigation technical means and methods, thereby meeting the multi-aspect demands of geological investigation data management, analysis and evaluation, realizing the comprehensive, effective, convenient and quick management of urban geological data, forming a sustainable-update, virtuous-circle and high-efficiency-available urban geological database, comprehensively, quickly and accurately mastering the conditions of urban hydrology, engineering geological structures, underground space, underground pipe network and the like, providing a comprehensive, intelligent and standardized tool platform for professional technicians, providing a geological science basis for government decisions, urban construction and the like, providing a basic service platform for public information demands, improving the development and management level of urban science, and better promoting the comprehensive and coordinated development of urban economy and society.
The invention also establishes a city geological data processing platform by developing or introducing three-dimensional data management and visualization technology, comprehensively and systematically integrates city geological data, realizes unified management of multi-source, heterogeneous and massive geological data, constructs a city basic geological database, provides visualization processing, professional analysis and standardization processing of various city geological data, simultaneously has basic information service oriented to professional inquiry and retrieval, and provides a three-dimensional visualized geological information platform for city planning, construction and management work.
Aiming at the characteristics of wide profession, multiple sources, different structures and different periods of urban geological data, the system adopts a spatial data warehouse technology, provides series of tools including standardized processing of original layered data, input and importing of heterogeneous geological data, inspection and updating maintenance of data consistency and the like, reduces the difficulty of database construction, improves the database construction efficiency, and realizes the integrated organization and management of the multi-source heterogeneous urban geological data. The invention realizes the organization management of the integration of the urban geological space data and the attribute data, adopts advanced control table mapping technology, interface automatic generation and other technologies, and is convenient for expanding the geological professional data content and functions along with the deep geological investigation work. By means of the mixed database storage management mechanism, a complete management scheme of file data (documents, tables, pictures, videos and the like) is provided, and distributed storage management of spatial data and non-spatial data is achieved.
The method is based on urban three-dimensional geological modeling, the expression mode of urban geological survey results is greatly improved, the evaluation prediction capability of urban geological resource environments is improved, and the two-dimensional analysis and evaluation system performs integrated display and analysis on multi-dimensional multi-thematic two-dimensional professional drawing pieces and three-dimensional models of the whole city, so that a visual window of a transparent city is created. The invention also operates in a B/S mode, and provides services such as urban geological basic information, geological science popularization, geological and homeland resource combined result sharing, geological interaction and the like for the public.
Drawings
In order to more clearly illustrate the technical solutions of the present invention, the drawings that are needed in the description will be briefly introduced below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a city geological data processing platform based on big data cloud computing technology;
FIG. 2 is a diagram of a full-space true three-dimensional integrated display effect;
fig. 3 is an integrated display effect diagram of the full space model.
Detailed Description
As GIS applications continue to go deep, there is an increasing desire to deal with problems from true three-dimensional space. Three-dimensional GIS plays an important role in an increasingly wide range of fields. The urban geological data processing platform based on the big data cloud computing technology provided by the invention is used for integrally managing and displaying three-dimensional information in the air, on the ground, on the earth surface and underground, so that three-dimensional space information is completely expressed, and full sharing of multidimensional space-time information is realized.
Aerial: and simulating and expressing various space-time objects occurring in the atmosphere ring on the surface of the earth, and sharing three-dimensional visual information such as meteorological data, aviation flight, satellite operation, environmental simulation and the like.
Ground: the method can efficiently express entity information on the ground, such as buildings, road networks, trees and the like, and construct a vivid and efficient three-dimensional ground scene.
Surface: the terrain analysis and the remote sensing treatment are combined, so that the production, display, sharing, analysis and use processes of the land surface such as the trend of the terrain, earthquake, disaster prevention, flood control and drought resistance are covered, a shared base surface is provided for the air, the ground and the underground, and the difficulty of ground and underground integrated scene fusion is solved.
Underground: the comprehensive underground space information modeling and analysis technology realizes various modeling of geologic bodies, ore bodies, underground tunnel roadways, underground buildings, subways, underground pipelines and the like, shares stratum structure information, integral information of ore areas and urban underground complex geological information, and provides support for building huge three-dimensional digital cities.
The three-dimensional information of the air, the ground, the earth surface and the underground is integrally managed and displayed, the three-dimensional space information is completely expressed, and the full sharing of the multidimensional space-time information is realized. The integrated display of the whole-space overground and underground integrated three-dimensional model enables the overground landscape model, the underground geological structure model, the underground pipeline model, the subway model and the underground water flow model to be integrated. And supporting seamless butt joint display of the overground and underground three-dimensional model. And superposing and displaying the built overground building model, vegetation model, water body model, digital elevation model, underground three-dimensional geological model, underground pipeline model and subway model, namely integrating and displaying the BIM model, oblique photography model, 3DMAX model, underground pipeline model and three-dimensional geological structure model, so as to achieve overground and underground integrated display.
The illustration provided in the urban geological data processing platform based on big data cloud computing technology provided by the invention is shown in fig. 1 only to illustrate the basic idea of the invention in a schematic way, only the modules related to the invention are shown in the figure, not according to the number and functions of the modules in actual implementation, the functions, the number and the functions of each module in actual implementation can be changed at will, and the functions and the purposes of the modules can be more complex.
The urban geological data processing platform based on big data cloud computing technology is applied to one or more terminal machines, wherein the terminal machines are equipment capable of automatically carrying out numerical calculation and/or information processing according to preset or stored instructions, and hardware of the terminal machines comprises, but is not limited to, microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASICs), programmable gate arrays (Field-Programmable Gate Array, FPGAs), digital processors (Digital Signal Processor, DSPs), embedded equipment and the like.
The terminal described in the embodiments of the present invention is intended to represent various forms of digital computers, such as laptops, desktops, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the embodiments of the present application described and/or claimed herein. Typically, the method is used to determine the quality of the product.
The operating system platform of the terminal selects Windows Server 2012, and the client operating system selects Windows 10. The system uses and generates a large amount of data at run time, and thus the system needs to use a sophisticated, powerful database management system to effectively manage the data. Taking technical advantages of space data management capability, support capability for mass data storage and the like into consideration, a MySQL database is adopted as a system database platform. And a fourth generation geographic information system MapGIS 10 basic platform is adopted. The MapGIS 10 has the characteristic of good compatibility with Window series operating system environments, can conveniently perform data conversion with ARC/INFO, MAPINFO, AUTOCAD, and realizes efficient storage and management of space data in a mysql database through a space data engine unique to a MapGIS platform.
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1 to 3, which are schematic diagrams of an urban geological data processing platform based on big data cloud computing technology in an embodiment, the platform includes: the system comprises a data collection module, a data processing module, a database construction module and a data visualization processing module;
the data collection module is used for obtaining geological data;
the raw data collected by the data collection module includes three main categories:
the first category is graphic data, mainly paper drawings related to the establishment of a basic graphic database and result data, digitized graphic data and established database data.
The second category is text data, including reports, field original record cards and record books, and is mainly used for filling in the attributes of the basic graphic database.
The third category is data with point space characteristics obtained by using instrumentation or sampling observations in geological surveys, which includes geophysical, geochemical, borehole, and test data, which are mainly data contained in a point space database. Meanwhile, the precision and quality of the data source are required to meet the standard requirements. And performing active updating on the older data, thereby ensuring the accuracy and reliability of the database content.
The database construction module is used for constructing databases of different types of data layers according to the types of the geological data so as to store the geological data;
the data layer is composed of data resources and information resource libraries required by platform operation, and basic geographic data, basic geological data, hydraulic loop data, remote sensing images, physical and chemical exploration data, urban geological data, mineral geological data, geological disaster data, travel geological data, geothermal resource data, popular geological science popularization resources and the like which are subjected to standardized processing are assembled and logically divided into basic class data, professional class data, management class data, document data and the like, and the basic geographic data, the basic geological data, the hydraulic loop data, the remote sensing images, the physical and chemical exploration data, the urban geological data, mineral geological data, geological disaster data, travel geological data, geothermal resource data, popular geological science popularization resources and the like are physically included, and the basic class data, the professional class data, the management class data, the document data and the like are physically included. And unified and authoritative data support is provided for an application system, so that the urban geological database in Jinan city is formed. The database realizes data management and maintenance such as updating, editing, inquiring and displaying of data, provides a statistical analysis function and maintains a unified data catalog.
The invention provides various applications for geology professionals, government decision-making personnel and the public society, and specifically comprises a city geology data management and maintenance system, a city geology two-three-dimensional analysis and evaluation system, a socialization and sharing service subsystem and a city geology government decision-making support subsystem.
Wherein the data layer database comprises: an original data layer database, a base data layer database, and a result data layer database.
Two types of data, namely original investigation data and graphic data, are stored in an original data layer database. The original investigation data comprise field description in various drilling cards, deep well files, various test data, dynamic monitoring data and original data acquired in geophysical and geochemical investigation, wherein the layer data are data which are stored as data and are not allowed to be changed, and the data are expressed in the form of an original data table. Before the database is built, the original data is firstly filed and classified, and then the original data is input into the database according to different classifications.
The base data layer database stores base test analysis data, engineering geological data, graphic data, vector format data, image database, geographic data, and the like.
The basic test analysis data specifically comprises bedrock drilling and fourth-period drilling field stratum description and test data, such as rock and mineral identification data parameters, chemical analysis data and rock analysis data of the bedrock drilling, and fourth-period drilling data.
Engineering geological data includes field layering and test data of engineering geological census or detailed borehole. With the development of large-scale city construction, accumulated engineering investigation data are more and more, and become a main body of engineering geological original data.
The graphic data mainly refers to professional related text reports, documents, data files, pictures and video files.
The basic data layer divides the urban geology into a plurality of topics including geographic data, regional geology, fourth-period geology, hydrogeology, engineering geology, marine geology, geological disasters, environmental geology, geochemistry and geophysics according to the characteristics of the urban geology work, and the specific data organization is as follows:
geographic data is generally divided into vector format data and image format data, and corresponding data warehousing and sorting tools are respectively provided for geographic data in different formats.
The vector format data mainly includes: urban topography lines, traffic lines, administrative area demarcations, residential point distribution maps, regional climate zone maps, regional landform zone maps, urban land use current situation maps and urban land use perspective planning maps. The basic geographic data exists in the form of vector graphics and can be directly converted into point, line and surface files in a GIS system for storage and management. Vector data is required to support multi-scale database building to accommodate the requirements of the system hierarchical display on the geographic base map.
The image database is actually a collection of image libraries, including aerial and satellite image data, and typically images from different sources are stored in different image libraries. These image data are typically in JPEG, TIFF or other format prior to warehousing, with each image having a coordinate file. The GIS platform image processing function is utilized to convert the GIS platform image processing function into GIS format image files, data in the coordinate files are stored in the files, and then corresponding warehousing work is carried out. In addition, the image data should also use the same coordinate reference system as the geographic base map, so as to facilitate the database construction and data display of the geographic data.
Regional geology, as referred to in regional geology surveys, refers to the rock, strata, structure, topography, hydrogeology, mineral production and crust movement and development history of a region of a larger extent (e.g., within a geologic unit, zone, or map).
The fourth geologic formation stored in the base data layer database includes: the corrected and supplemented raw test data and description information of the fourth drill hole, a basic condition table of the fourth drill hole, a layering condition table of the fourth drill hole, various test result condition tables of the fourth drill hole, a fourth geologic chart, a fourth lithology ancient geographic chart, a fourth drill hole histogram, a fourth drill hole section chart, a fourth stratum contour map and related text reports.
The hydrogeologic data in the base data layer database comprises: corrected and supplemented hydrogeological drilling, original test data and description information of the well, hydrogeological drilling, production well, observation well, standard component layering situation table, hydrogeological layering overall layering description table, groundwater water level change situation diagram, groundwater aquifer exploitation intensity distribution diagram, groundwater aquifer water enrichment and water conductivity distribution diagram, groundwater aquifer water quality and mineralization diagram, groundwater aquifer chemical type diagram, hydrogeological drilling result histogram, hydrogeological section diagram and related text report.
Engineering geological data in the base data layer database comprises: the corrected and supplemented engineering geological drilling original test data and description information, a regional foundation soil layer division table (standard layering), an engineering geological drilling layering situation table, an engineering geological drilling distribution map, an engineering geological drilling histogram, an engineering geological profile and a stratum contour map, and related original record, photo video and document report data. Other topics such as geological disasters, environmental geology, shallow geothermal energy, and geophysical data should also be classified by profession.
The result data layer database contains various result data generated by a system and made by a user, and the main data content is as follows:
each professional contour line and thematic map automatically generated by the system; comprehensive evaluation results of various professions; a three-dimensional geologic structure model; analyzing a result of the three-dimensional model; various thematic drawings, thematic evaluation drawings and various partition drawings made by users.
The processing flow of the three types of data layer databases is as follows:
1. warehousing the collected various original investigation data;
2. performing standardization processing according to national standard, industry standard or standard formulated in the project, and storing processed data into a basic data layer database as basic data of subsequent analysis and evaluation;
3. Carrying out multi-source data coupling three-dimensional modeling by utilizing drilling data, geological map, topographic map and profile map multivariate information to establish a drilling solid model, a three-dimensional geological structure model and a three-dimensional geological attribute model;
4. and extracting two-dimensional basic data and three-dimensional geological model data required by analysis and evaluation, and carrying out comprehensive analysis and evaluation under the support of an evaluation model in a model database. The analysis evaluation comprises conventional analysis evaluation (namely analysis evaluation in a traditional two-dimensional mode) and three-dimensional analysis evaluation, wherein the conventional analysis evaluation mainly completes inquiry statistics, drawing generation and conventional professional analysis functions according to basic data, and the three-dimensional analysis evaluation integrally displays and analyzes various three-dimensional models. The generated analysis and evaluation results are stored in a result data base;
5. and sharing and publishing the model data and the result data.
The data processing module is used for analyzing the acquired geological data types and dividing the geological data types into corresponding data layer databases for storage; performing addition, deletion and verification on the geological data based on a control instruction input by a user;
specifically, the data processing module is used for preprocessing the collected data, and mainly comprises the steps of active updating, data arrangement and projection transformation.
And (5) updating the behavior: the data used as data source, especially topography map, is updated before digitization to reflect urban situation as much as possible.
And (3) data arrangement: drilling, experimental data, monitoring data and statistical data used as data sources are arranged before being recorded, so that the data are suitable for the recording requirements of the urban geological survey database.
Projection conversion: since the data sources selected are from different coordinate systems, projective transformation into the coordinate system required by the database is required.
Data conversion: the selected data sources have different data formats and are required to be converted into a GIS format unified by a database system.
System library replacement: the selected data sources come from different projects, the system libraries used are different, and the system libraries are replaced by the system libraries with uniform projects.
In addition, the three-dimensional modeling data also needs to be combined with the requirements of three-dimensional geologic modeling on data precision and consistency, and data summarization and fusion processing are carried out on drilling holes, sections and geologic maps according to certain rules, so that a foundation is laid for building engineering geologic models, bedrock-fourth-period geologic models and hydrogeologic models, and the foundation is integrated with other model data collected by geologic investigation. The method comprises the following steps of data structuring processing, unified coordinates, adding necessary attributes, data conversion, validity checking and geological consistency interpretation processing of different geological data.
The data processing module also involves conversion of the non-GIS formatted electronic data. The remote sensing image data conversion method is to support the input and output conversion of the image file format (MSI) exclusive to the MapGIS and the common various image data format files (such as Tiff, geoTiff, raw, bmp, jpeg 2000) and the conversion of other format type image files such as HDF4 files and MSI files. While the system provides for problems during import (export) of log records for inspection by the user.
The difference between the vector data format conversion step and the remote sensing image is that the vector data is stored in the element data set. The system supports the import and export of vector data (such as mif, e00, shp and dxf) in other formats based on vector data in a GIS format. The vector data with different formats are mutually converted by importing data with other formats, editing the data and exporting the data into the data with other formats, different importing and exporting parameters can be set according to different selected data formats, a sub-graph library and a symbol library are set, and a system automatically checks whether the data naming is legal or not and provides an automatic naming modifying function in the conversion process.
The data processing method of the paper map is to form GIS format point, line and surface files from the paper data results, then to strip the professional map layer according to the relevant technical requirements, and to assign the space entity to the internal attribute to form the map layer information file.
The processing mode of the drawing scanning is to consider the folding condition of the data source drawing, the side length of the drawing and the diagonal length of the drawing, if the error exceeds the error specified by the database building guideline, the original drawing is processed (such as humidity increasing or dehumidifying), and then the drawing scanning is carried out. The scanning adopts gray scale scanning, and the resolution is more than 300 dpi. Meanwhile, the parameters of the edge length of the outline of the grating file, the diagonal length of the outline and the precision of the coordinate network line spacing are checked, and if the parameters exceed the specified errors, rescanning is carried out. However, because the accuracy of the map itself and the human factors in the digitizing process are affected, the accuracy of the graph processed by the engineering scanner is difficult to meet the requirement of the GIS system accuracy, and the digitizing result needs to be corrected according to the actual data, and the process can be performed in the platform.
The vectorization processing mode is to read the graph, namely, according to the information reflected by the graph piece, the urban geological information is synthesized, the design of the graph layer is carried out, and the hierarchical vectorization of the graph elements is carried out according to the design. When in digitalization, the rule flow of the database-establishing guide is strictly followed.
Dot element vectorization: and recording according to the positions of the points on the raster file. And adopting a method for automatically generating coordinate points for the points with coordinates.
Line drawing element vectorization: tracking vectorization is carried out on raster files one by one according to the digitizing sequence and direction; the graph is not repeatedly recorded and can not lose the graph layer when being digitized, so when the graph layer with other graph layer elements is needed to be added during vectorization, the graph layer with the elements to be added is copied to the current graph layer, and irrelevant lines are deleted after line parameters are changed.
Zone file topology processing: in order to ensure accuracy, the node search radius is set to 10-5mm, and the minimum distance between the nodes is set to 10-5mm. Prior to topology, arc segment spatial relationships are checked for errors and processed. After the topology is finished, the nesting condition of the region and the arc section is checked, and especially at the inflection point of the arc section, if the region and the arc section are not nested, the reason is checked and corrected. Finally, according to the legend parameters of the technical requirements, editing the graphic elements, printing and outputting, and adopting self-checking, mutual checking and spot checking quality supervision means to modify errors.
The attribute entry is to build a structure by building a layer of the main view. Under the default data structure, the requirements of the project can be basically met by adding according to the fields set in the database building guide. The data can be input directly in a GIS platform; batch attribution is carried out by utilizing a method of attributing according to parameters/attributes; and (3) utilizing Excel software to realize batch input of data and realizing hooking of the attribute by taking the ID code as a keyword. Primitive coding: definition of internal attribute structure.
And coordinate processing is performed on the processed map data, and because the collected data sources may come from different coordinate systems, projection transformation is needed to a unified standard coordinate system of a database.
The data processing module may import the processed data into a database. Specifically, the map and the space data in the original format which are subjected to digital processing can be directly imported and managed by using a platform provided with the urban geological information management and service system. The whole GIS space database is stored in an HDF file format and comprises a map library, an image library and a vector file. The GDB manager classifies various primitives of the graph data into a plurality of types, such as: element class, object class, annotation class, modification class, dynamic class, raster data set, metadata base and map set, and the corresponding data format is imported into the corresponding type.
The data visualization processing module is used for constructing a data model integrated unit, a data management integrated unit, a data visualization unit and a development integrated unit, so as to realize two-dimensional and three-dimensional integrated visual processing; and the supporting platform is used for integrally managing and displaying three-dimensional information in the air, on the ground, on the earth surface and under the ground, so that the full sharing of multidimensional space-time information is realized.
It should be noted that, the two-dimensional model and the three-dimensional model are very different in both data structure and modeling flow, and many functions in the GIS system are developed based on two dimensions. Therefore, the two-dimensional data and the three-dimensional data are not unified well in modeling, data management, data visualization, data integration and other aspects, so that the two-dimensional data and the three-dimensional data are repeatedly developed on similar applications. Therefore, the platform realizes two-dimensional and three-dimensional integrated management strategies based on the data center from four aspects of the most basic data model, data management, data visualization and development integration.
The integration of the data model is to uniformly express a two-dimensional data model and a three-dimensional data model from the concept of an element model, so that two-dimensional data and three-dimensional data can be managed by adopting a uniform concept; the data management integration is to integrate and manage the space database by a unified element class and element data set by a classification concept; the data visualization is to display the two-dimensional display and the three-dimensional display in a unified view, so that the modeling effect is more prominent for the two-dimensional and three-dimensional comprehensive display application; the application development integration is realized by means of a data center technology, a plug-in management mode based on a middleware technology is adopted on the premise that the difference of data is not involved, the two-dimensional application difference is shielded, and the two-dimensional application function and the three-dimensional application function are integrated.
Based on a management strategy of two-dimensional and three-dimensional integration of the data processing platform, the situation of the previous two-dimensional and three-dimensional data processing is changed, so that the two-dimensional and three-dimensional data are treated indiscriminately on the aspects of data model, data management, data visualization, data integration and the like, and the application of the two-dimensional and three-dimensional space data in deep level is truly realized. By means of the data center technology, on the premise of not involving the difference of the data, the plug-in management mode based on the middleware technology shields the difference of two three-dimensional data, integrates the two three-dimensional space data, logically performs unified management based on the concept of the space data, and unifies the processing flows of data storage, visualization, analysis application and the like.
Aiming at the rendering and calling requirements of a browser end on a three-dimensional geological model, the invention self-defines an M3D three-dimensional data exchange format aiming at multi-terminal application, performs grid division and hierarchical organization on massive three-dimensional data, and adopts a streaming mode to realize high-efficiency analysis and rendering of the three-dimensional data.
Through the M3D data format, a high-efficiency network transmission mode of high compression ratio and streaming transmission is realized; performing fine grid division on the multi-level LOD model according to the data distribution characteristics; the method comprehensively supports a three-dimensional client without a plug-in, and ensures the seamless fusion of WebGL; support the monomerized inquiry, support the highlight choice, support and modify the object color, modify the object visibility in batches; five characteristics of the integrated application modes of the desktop end, the browser end and the mobile end. Meanwhile, the method supports the conversion of various data such as geologic bodies, pipelines, landscape models, OSGB (open sensor grid) and the like into M3D, and the data display efficiency is greatly improved. Based on the M3D data format, the system is released from the data service of the server to load the application to various clients, and a complete B/S application solution is formed.
In order to solve the problem that if a plurality of users send out a plurality of requests to call web services at the same time, the threads are occupied and can necessarily influence the operation efficiency, the invention adopts asynchronous call, when a server needs to process the data request of a client for a long time, the call thread can return in time, and the server can put a method to be called on a new thread to operate and execute in the background without influencing other behaviors of the call method. When the last request service is completed, the server informs the client in a certain message manner that the thread request processing is completed, and returns the data to the client, and the client performs visual drawing management after receiving the data.
In the embodiment of the invention, new geological survey data and engineering survey data are formed continuously due to continuous progress of geological work and development of urban construction, and new data are required to enter the database continuously.
For geographic data and geological result map class data, old data is required to be stored in a historical database, and then the geographic data in the current database is replaced by new data. For documents, drawings and model data, existing data and existing data need to be compared, for places where materials lack, new data are added, and for places where materials are rich, screening according to rules and updating or adding are needed. For dynamic monitoring data, the data acquisition time is recorded, and can be directly added into the action database.
In particular, the data processing platform further comprises: and a data maintenance and update module. The database construction module also constructs a history database.
The data maintenance and update module is used for updating the geographic data and the geological result map data, storing the old data into the historical database, and replacing the geographic data in the current database with the new data. And maintaining and updating the space data, maintaining and updating the attribute data of the geological data, maintaining and updating the three-dimensional model, maintaining and updating the attribute of the three-dimensional model, and updating the texture.
The maintenance and update mode for the three-dimensional model comprises the following steps: for the surface topography and various geological curved surfaces, a new model is established by adopting a reconstruction method when modeling data are updated. For the engineering geological stratum model, a three-dimensional geological model generated by dynamic and automatic modeling is adopted by virtue of drilling data, and a new model is established by adopting a reconstruction method when modeling data are updated. For the hydrogeology with the sequence law, a three-dimensional geologic model generated by automatically modeling the multi-source data coupling lamellar geologic body with the section as the main part is adopted, when two-dimensional section data are updated, a three-dimensional section is firstly reconstructed through a function of converting the two-dimensional section into the three-dimensional section, then the three-dimensional model is reconstructed based on the three-dimensional section, and when only the three-dimensional section or other constraint data are updated, the three-dimensional model is reconstructed. And for the fourth-line stratum model, a three-dimensional geologic body structure model established based on a cell partition-splicing interactive modeling method is adopted, geological boundary lines, geological interfaces and characteristic points in cells are modified or new data are added through a three-dimensional interactive editing tool provided by a system, then a block model is reconstructed, and model maintenance and update are realized through local update by taking cells as units. The updating mode for the maintenance of the three-dimensional model attribute comprises the following steps: the system provides a function of editing and modifying the attribute of the model element, realizes maintenance and update of the own attribute of the three-dimensional model through the function, and realizes update of the related attribute of the three-dimensional model through maintenance and update of the related attribute table of the related database.
The updating mode of the texture comprises the following steps: the system supports a dynamic mapping function of a mode of making texture files, and a user can maintain and update textures by editing and replacing the texture files.
According to an embodiment of the present application, a data processing module includes: the system comprises a two-dimensional directory tree management and visual display unit, a two-dimensional data query unit, a two-dimensional data statistics unit, a surrounding drilling number statistics unit of a building, a drilling histogram generation unit, a geological profile generation and auxiliary tool and a plan generation and editing module.
The two-dimensional directory tree management and visual display unit is used for providing the user with the service data nodes added on the two-dimensional directory tree, displaying vector diagrams such as remote sensing images, geographic base diagrams, geological diagrams and the like of urban geological investigation areas with different scales, displaying data of different professional drilling holes and attribute point positions, and carrying out convenient node movement, grouping and renaming operations on the directory tree.
The two-dimensional data query unit is used for providing general query, single click query and information query of the vector drawing. And supporting screening and inquiring according to the attribute information and the space position of the thematic point location. And support data export after query, information statistics, grid density query and associated histogram display query functions.
The two-dimensional data query unit provides various space query modes including point query, line query, polygon query, rectangular query, circle query, administrative area query and the like. The query scope input mode is to designate the query scope on the geographic base map and/or the geological map by adopting tools such as clicking, line drawing, rectangle, circle, irregular polygon, administrative area and the like.
Query result expression mode: the system displays the object attribute list meeting the requirements in the queried range, and further positions and draws the result point position on the graph by using a designated display mode (such as highlighting) by using the corresponding relation between the graph and the attribute. If the plurality of specialized point location data are simultaneously opened, the query mode can query the information of the plurality of specialized exploration points in the designated range at one time and display the information in a tab mode, and the basic information record of the selected exploration point can query other detailed information of the exploration point by double clicking, and can also carry out data statistics analysis in the query result. The query result output mode is an Excel format file.
The two-dimensional data statistics unit also supports screening and inquiring according to the attribute information and the space position of the thematic point location, the system can inquire and retrieve the drilling data in the database according to screening conditions such as drilling codes, drilling depth, orifice elevation, drilling level and the like, and supports the data export, information statistics, grid density inquiring and associated histogram display inquiring functions after inquiring.
The two-dimensional data statistics unit is used for providing an operation window for setting statistics types, statistics indexes and statistics information for a user and generating a statistics graph according to the set parameters. Setting data sources, setting segment fields and setting statistic field functions are listed according to the generation sequence of the statistic map.
The around-building borehole count unit supports counting the number of boreholes around the building area file.
The statistics unit of the number of holes drilled around the building can enable the building area files and engineering geological drilling layers queried by a user to be added to the directory tree. The "building area" is selected in the statistical interface, the query data is "engineering geological borehole", the layer is selected as the "building name" field in the building area, the buffer radius user can be customized, and the example is selected as 0m. And selecting a query range in the view through mouse interaction, and carrying out frame drawing selection on the building area to be queried through mouse interaction. The system pops up a dialog box for counting the number of the drilled holes, the counting result selects 'building name', and the total number of the drilled holes is the number of the drilled holes contained in the selected building area file.
The drilling histogram generation unit is used for automatically generating professional drilling histograms according to drilling holes selected by a user and a prefabricated template. The user uses a histogram template generator and a histogram macro configurator tool to generate the histogram template and support the undo and redo of the editing. Multi-level combination of tracks, segmented scale. The strengthening of the header and tail tables supports the strengthening of column merging and text display formats and the improvement of interactive editing operation. The method supports convenient external secondary development of the image, realizes plug-in loading of the image and expansion of the functions of the histogram, and reduces the development amount when expanding a new image.
According to the drilling holes selected by the user and the prefabricated templates (the system can quickly create the templates according to the database), the professional drilling hole bar charts are automatically generated, besides the flexible editing function of the conventional drilling hole bar charts is realized, the editing function is perfected, the use habit is more met, the user can obtain the required bar charts in the shortest time, in addition, the user can use a bar chart template generator and a bar chart macro configurator tool to generate the bar chart templates, and the rapid drawing of the same type of professional data is facilitated mainly comprising: undo and redo of edits are supported. Multi-level combination of tracks, segmented scale. The strengthening of the header and tail tables supports the strengthening of column merging and text display formats and the improvement of interactive editing operation. The method supports convenient external secondary development of the image, realizes plug-in loading of the image and expansion of the functions of the histogram, and reduces the development amount when expanding a new image.
The geological profile generating and assisting tool provides the function of automatically generating the profile based on the drilling data and the set stratum connection mode, and performs operations of adding and deleting drilling holes, adding and editing fault lines, breaking zones, legends, responsibility tables, converting two-dimensional profiles into three-dimensional profiles and exporting the profiles into MapGIS 67, mapGIS hdf or picture formats on the generated profile.
The section view related by the invention is taken as a geological professional view, so that not only can the staff be assisted to visually, intuitively and accurately understand the stratum geological structure, but also important reference conditions and data source information can be provided for further establishing a bedrock model, a fourth-period geological model and a hydrologic model of a city investigation region. The system provides the function of automatically generating the section based on the drilling data and the set stratum connection mode, and can perform operations such as adding and deleting drilling holes, adding and editing fault lines, breaking zones, legends, responsibility tables, converting two-dimensional sections into three-dimensional sections, and exporting the sections into MapGIS 67, mapGIS hdf or picture formats.
Thus, in a system design, the profile mapping function will map profiles based on borehole data, providing multiple ways to read the desired borehole data. In the drawing process, constraint control is carried out on the added altitude GIS vector data comprising surface data, bedrock surface data, plane fault data, landform partitions, stratum roof plates and the like.
In addition, according to the requirement, in the process of drawing the stratum line, in order to improve the drawing efficiency of the section view, the system provides the functions of manually connecting and automatically connecting the stratum line, and helps a user to quickly generate the section view. The system integrates system point, line and zone editing functions, provides intelligent capturing functions of layering points and stratum demarcation points, and supports professional operators to conveniently, rapidly and professionally generate geological section diagrams. After the profile is generated, the profile parameters can be modified, drilling information is queried, formation attribute statistics is carried out, drilling holes can be added or deleted to regenerate the profile, and the functions of manually adding faults, dragging formation lines to adjust the break distance or adjusting the formation lines and deleting formation lines to assist editing are supported. The method supports the use of all graphic editing drawing functions and printout, and the generated sectional view supports the importing of three-dimensional modeling, so that the three-dimensional function and the two-dimensional function are kept uniform, and the unified flow of the system is perfected.
The plan generation and editing module is used for supporting a user to generate and edit professional plane geologic maps, including a drilling point position distribution map, a drilling stratum thickness/burial depth contour map, a drilling stratum distribution map, a water level contour map and a field generation contour map selected from a database.
The plan generation and editing module is used for supporting a user to generate and edit professional plane geologic maps, including a drilling point position distribution map, a drilling stratum thickness/burial depth contour map, a drilling stratum distribution map, a water level contour map and a field generation contour map selected from a database.
The system provides a comprehensive module for contour map generation, different types of contour lines are obtained according to user requirements by managing and loading different original data through plug-in units, and the generated contour lines can be edited and stored to meet the requirements of a map.
And when the contour map is automatically generated, a certain stratum missing region in the region can be automatically removed, and the contour map considering the constraint conditions of the stratum missing region, other cavity region data, fault data, profile data and outer boundary constraint data is generated. According to the professional numerical data in the database, the system supports to generate a contour map of a drilling appointed horizon contour map, a geochemical anomaly contour map, a geochemical type partition map and a groundwater level contour map type.
1. And (6) generating a borehole stratum contour map. And automatically generating a stratum contour map in a specified range according to the drilling data. Comprising the following steps: a layer top burial depth contour map, a layer bottom burial depth contour map, and a layer thickness contour map.
2. And generating a hydrogeological contour map. According to the underground water investigation data and the related water quality analysis result data, a groundwater quantity change curve chart of a specified area can be generated, and a hydrogeological contour chart in a specified range can be automatically generated.
And generating a geochemical contour map, and generating a single element/combined element geochemical anomaly contour map in a designated area according to environmental geochemical survey data of soil and water.
The system provides the generation and editing of the plan such as the drilling point position distribution diagram, the geophysical plan and the like, the generated plan can be displayed by being overlapped on the geographic base diagram, and the generated result can be saved as an engineering file.
In an embodiment of the present invention, the data processing module further includes: the device comprises a layered geologic body rapid modeling module based on drilling, a yield push-down modeling module, a three-dimensional interactive modeling module, a zoned splicing interactive modeling module based on cross sections, a three-dimensional terrain and curved surface modeling module, a three-dimensional attribute modeling module, a zoned splicing interactive modeling module, a three-dimensional terrain and curved surface modeling module and a geologic body attribute spatial distribution modeling module.
The layered geologic body rapid modeling module based on drilling is used for constructing each stratum surface by adopting a grid template shared by all stratum interfaces, generating a stratum surface strong constraint point by overlapping contour line data of drilling points and layering information from a basic database on the basis of generating a terrain grid according to modeling range and precision requirements, extracting relevant stratum boundary line information from a section, carrying out interpolation calculation by applying the two types of data based on the terrain grid to construct each stratum surface model, generating a stratum entity model according to geological information such as overlapping relation among strata, and meanwhile, adding terrain constraint to the surface model to construct a geological model of a real topography and landform unit. And continuously adding various constraint data to the established geologic model, designating the influence range of the constraint data, and repeatedly reconstructing and updating the geologic model so as to represent the real geologic form.
The system provides a series of modeling tools for assisting a user to quickly construct a geological three-dimensional structure model aiming at geological drilling, geological profile, gao Chengdian, bedrock burial depth contour, bedrock exposure area contour multi-source geological data generated in a geological investigation process, comprises automatic modeling based on a geological body with a standard layer sequence profile and semiautomatic interactive modeling based on a complex geological body, and can select a proper modeling method according to actual data conditions and modeling precision requirements.
For simple lamellar geologic bodies such as engineering geology, hydrogeology and the like, a lamellar geologic body rapid modeling module based on drilling adopts an integral modeling thought of 'drilling-section/contour line-stratum entity' modeling, grid templates shared by all stratum interfaces are adopted to construct each stratum surface, then on the basis of generating a terrain grid according to modeling range and precision (grid spacing) requirements, drilling points and layering information superposition contour line data can be extracted from a basic database to generate stratum surface strong constraint points, relevant stratum boundary line information is extracted from the section, interpolation calculation is carried out on the basis of the terrain grid, each stratum surface model is constructed by applying the two types of data, finally, a stratum entity model is generated according to geological information such as overlapping relation among strata, and meanwhile, terrain constraint can be added to the surface model to construct a geological model of a real terrain and landform unit. Various constraint data can be continuously added to the established geologic model, the influence range of the constraint data is specified, and repeated reconstruction and updating are carried out on the geologic model, so that the real geologic form is more accurately represented.
The modeling method needs to arrange a set of consistent, macroscopic stratum partitioning schemes with fixed layer sequences in a modeling range. The method can directly establish a three-dimensional stratum model through drilling data, and can intervene in modeling of areas with more complex geological conditions, such as areas containing special geological phenomena of interlayers, pinch-outs, lens bodies and the like, by supplementing profile, stratum plane distribution map (used for determining stratum boundaries and stratum surface fluctuation change conditions), setting parameters and the like.
For a particular modeling area in practice there may be a large number of boreholes, and the information that these boreholes can provide includes the location (geographical coordinates) of each borehole, the type of borehole, and layering information of the formation, etc. Considering that the distribution of some types of drilling holes is dense, the number of drilling holes used for modeling in a large range or even in the whole city range is huge, the modeling efficiency is greatly reduced, and the analysis and the research of a model are not facilitated, the drilling holes can be classified according to a certain degree of network, the drilling hole level used is calculated according to the area size (a standard can be defined in advance) of the modeling range when modeling is performed, and then the drilling hole data of the corresponding level are extracted for modeling.
In addition, when modeling the urban three-dimensional stratum, the user can select the stratum fineness according to the needs without establishing a model according to the stratum data with the finest division each time due to different modeling ranges and research purposes. For this reason, it is required that a user divides the formation into different levels according to the degree of research fineness when sorting modeling data of a borehole, a section, etc., for building a three-dimensional model of the formation of different degrees of fineness.
The occurrence push-down modeling module is used for establishing a three-dimensional geological structure model reflecting stratum, fault and fold structures in a modeling area by using the bedrock geological map and bedrock buried depth contour line data. And (3) cutting the plane or the folded surface into the section by using the established model, and then modifying the cut section according to the knowledge of an expert on the geology of the region, wherein the modified section is still added into the model to restrict the establishment of the model.
The occurrence push-down modeling module establishes a three-dimensional geological structure model reflecting stratum, fault and fold structures in a modeling area by utilizing data such as a bedrock geological map, a bedrock buried depth contour line and the like.
The constraint profile is constrained in the modeling process, so that the modeling is more accurate. In actual mapping work, if only actual material map and PRB data are started, the data can be directly used for carrying out the yield inference modeling. In a later stage of operation, multiple sections of the region may be measured again, and at this time we can add section constraints in the modeling of the yield inference, making the model of the region finer. The model established by the method is utilized to cut a plane or a folded plane into a section, then the cut section is modified according to the knowledge of an expert on the geology of the region, and the modified section can still be added into the model to restrict the establishment of the model.
Full-area extrapolation: for the occurrence of geological boundaries of several adjacent regions, the occurrence of these adjacent regions needs to be involved in the inference.
Old stratum inference: for the occurrence of geological boundaries in several adjacent regions, only the occurrence of the oldest formation in these regions is involved in the inference.
All occurrence points: in performing the occurrence inference, occurrence of a geological boundary of unknown occurrence needs to be inferred from occurrence of all occurrence points around it.
Recent birth points: in performing the occurrence inference, the occurrence of a geological boundary of unknown occurrence directly takes the occurrence of the known occurrence closest to it.
Treatment fourth: because the stratum of the fourth system is formed by stacking and covering, the corresponding occurrence information is not available, and occurrence modeling cannot be performed. The fourth line is checked to determine that the fourth line formation is not modeled, and if the fourth line is not checked, the fourth line is modeled (modeling is performed using the fourth line modeling method above).
Constraint profile: the cross-section constraint modeling may be performed after the collusion.
The three-dimensional interactive modeling module is used for obtaining geological rule expert experience geological information based on a mode of man-machine interaction by modeling staff, connecting characteristic points of corresponding stratum on a plurality of three-dimensional geological sections, and constructing boundary contour lines of the stratum surface and the fault surface. And constructing the fault plane model and the ground plane model by using the contour lines of the closed surfaces. And then constructing a closed geologic body model according to the fault plane and the stratum plane.
The three-dimensional interactive modeling module is a semi-automatic modeling method, modeling staff provides work requiring subjective experience such as geological rule expert experience geology through a man-machine interaction mode, and a computer carries out mathematical calculation. The core of the three-dimensional interactive modeling is a 'lifting dimension' semi-automatic man-machine interactive modeling process from low dimension to high dimension of 'point-line-surface-body'. The first step is to connect the feature points of the corresponding stratum on the three-dimensional geological section to construct the boundary contour of the stratum surface and the fault surface. The second step is to construct a fault plane model and a floor plane model from the contours of the closed surfaces. And thirdly, constructing a closed geologic body model according to the fault plane and the stratum plane.
Terrain, geologic maps, and borehole data may be added to constrain the modeling process. The basic idea of modeling is as follows: the space is divided into a plurality of cells by utilizing a plurality of cross sections in the modeling area, a modeling staff establishes a curved surface sheet by utilizing a series of closed contour lines in a single cell, the space geometric forms of all geobodies in the cell are determined to form a cell geological block, and finally the geological blocks of each cell are combined to form a complete geological body model, so that the geological bodies such as stratum, fault, coal seam, goaf and the like can be clearly expressed.
The partition splicing interactive modeling module divides a modeling space into a plurality of cells based on cross sections, then respectively constructs each cell, in the modeling process of each cell, based on geological information implied by each section line, proposes an auxiliary line adding and cutting method based on geological rules, and then realizes automatic and rapid construction of the ground proton surface by using the cut auxiliary lines and section lines.
The partition splicing interactive modeling module adopts the idea of 'dividing and autonomy' to divide a modeling space into a plurality of cells, then respectively constructs each cell, and in the modeling process of each cell, provides an auxiliary line adding and cutting method based on geological rules based on geological information implied by each section line, and then realizes automatic and rapid construction of the ground proton surface by using the cut auxiliary line and section line. The common surface is only generated once in modeling and shared by the upper geologic body and the lower geologic body, and the geometric consistency and the topological consistency of the model can be ensured by adopting the mode. And then, aiming at complex geological conditions, giving out ideas and methods for interactively constructing geological interfaces.
The three-dimensional terrain and curved surface modeling module is used for constructing a three-dimensional curved surface, constructing and analyzing basic terrain, and displaying the three-dimensional modeling of the collection results of data such as basic geology, a geographic map, remote sensing images, DEM and the like. And for the two-dimensional raster data of the scanned picture, a model simplification algorithm based on visual characteristics and an adaptive technology is adopted, and an adaptive surface model is generated in real time according to the distance change from the viewpoint.
The three-dimensional terrain and curved surface modeling module is used for constructing a three-dimensional curved surface, constructing and analyzing basic terrain, and displaying the three-dimensional modeling of the collection results of data such as basic geology, a geographic map, remote sensing images, DEM and the like. In the aspect of three-dimensional visualization requirements, the three-dimensional visual display device can integrally display other data in a three-dimensional scene through the specified elevation value or elevation surface. For two-dimensional raster data of a scanned picture, a model (LOD) simplification algorithm based on visual characteristics and an adaptive technology is adopted, and an adaptive surface model is generated in real time according to the distance change from a viewpoint.
The geologic body attribute space distribution modeling module is used for modeling three-dimensional space distribution regularization of physical and chemical attribute values and other geologic parameters (such as porosity, water storage rate, permeability coefficient, chemical element content and the like) in the geologic body. And supporting analysis of specified geophysical and geochemical data disclosure or custom plain code formats, and reading the geophysical and geochemical data.
The geologic body attribute space distribution modeling module is used for modeling three-dimensional space distribution regularization of physical and chemical attribute values and other geologic parameters (such as porosity, water storage rate, permeability coefficient, chemical element content and the like) in the geologic body. The geologic body attribute space distribution modeling module supports analysis of specified geophysics (such as earthquakes and aeromagnetic), geochemical data disclosure or custom plain code formats, and reads in the geophysics and geochemical data, wherein the data types are mainly cbs discrete point data.
The geologic body attribute space distribution modeling module supports multiple space analysis functions including attribute model range constraint, dynamic sectioning and query, two-dimensional profile generation, local attribute value modification, attribute change according to attributes, attribute hooking, three-dimensional buffering and the like, is used for standardizing and evaluating attribute factors, adjusting attribute model space relation and preparing data for general evaluation of attribute models
For different types of attribute sample data, various modeling methods are provided, such as distance inverse interpolation, kriging related interpolation and the like. Pipeline modeling importation supports importation and demonstration of pipeline models in the obj, # 3ds format.
In an embodiment of the present invention, a data visualization processing module includes: the system comprises a three-dimensional directory tree management and visualization display unit, a three-dimensional basic operation unit, a multi-view roaming display unit and a three-dimensional curved surface dynamic previewing unit.
The three-dimensional directory tree management and visual display unit supports adding different service data nodes on the three-dimensional directory tree, wherein the service data nodes comprise three-dimensional thematic points, terrains, geological models, attribute volumes and three-dimensional vector data.
The three-dimensional basic operation unit realizes the operations of moving, rotating, zooming, flying in and out of the model.
The three-dimensional basic operation unit realizes the operations of moving, rotating, zooming, flying in, jumping out and the like of the model. And add some gadgets such as: model explosion display, coordinate grid display, surrounding grid display, model transparency setting, three-dimensional legend display and model texture unified modification, so that the expression of the three-dimensional model is more visual and richer.
The multi-view roaming display unit is used for realizing double-view roaming, multi-view roaming, fixed path roaming, three-dimensional overground and three-dimensional underground dynamic double-screen display and dynamic double-screen display of two-dimensional view, three-dimensional underground view and three-dimensional overground view by taking topographic data as constraint boundaries.
The multi-view roaming display unit is used for realizing double-view roaming, multi-view roaming, fixed path roaming, three-dimensional overground and three-dimensional underground dynamic double-screen display and dynamic double-screen display of two-dimensional view, three-dimensional underground view and three-dimensional overground view by taking topographic data as constraint boundaries.
The three-dimensional curved surface dynamic pre-modeling unit supports the use of a four-dimensional time sequence function, analyzes the model through temporal evolution dynamic on the time dimension on the basis of the display of the original static model, creates a three-dimensional curved surface model with large-scale data volume, and supports the dynamic pre-modeling of multiple three-dimensional curved surface models.
The three-dimensional curved surface dynamic previewing unit supports and utilizes rich four-dimensional time sequence functions, fully excavates the expression means of the model in the time dimension on the basis of the display of the original static model, analyzes the model through temporal evolution dynamics, creates a three-dimensional curved surface model with large-scale data volume, and supports the dynamic previewing of multiple three-dimensional curved surface models. For example, groundwater dynamic previewing can be realized by constructing groundwater level curved surfaces in different historical periods through groundwater monitoring data for years. Water level analysis over the years and the like are performed.
Besides the dynamic demonstration of the simulated multi-curved surface model, a user can obtain graphs of water level, settlement and the like at a certain point on the model, and can also obtain graphs of water levels at a plurality of points.
In an embodiment of the present invention, the data processing module further includes: the system comprises a three-dimensional basic analysis unit, a three-dimensional model pickup unit, a three-dimensional geologic body cutting analysis unit, a three-dimensional topography analysis unit, a three-dimensional attribute model analysis unit, a legend and annotation unit and a model material editing module.
The three-dimensional basic analysis module provides a three-dimensional model basic analysis tool which comprises a three-dimensional magnifying glass, a calculation model area and volume, a stratum model thickness calculation and a model distance calculation.
The three-dimensional model picking unit is used for picking and inquiring the stratum model, the drilling model, the attribute model and the section model, and listing the attributes carried by the model in a list mode.
The three-dimensional model picking unit can finish the picking inquiry of the stratum model, the drilling model, the attribute model and the section model, can pick up the tunnel model which is being demonstrated for the model after cutting, and lists the attributes carried by the model in a list mode, so that the picking operation of the model is ubiquitous. In addition to the picking up of formation and borehole basis information, formation information for individual formations may also be picked up.
The three-dimensional geologic body cutting analysis unit is used for cutting and analyzing the model and comprises body cutting, section cutting, tunnel cutting, cutting along a drilling hole, cutting along a closed fold line and dynamically cutting, and the cut model is stored. The pattern is cut in three directions X, Y, Z or along a polyline path.
The three-dimensional geologic body cutting analysis unit provides abundant and various model cutting and analysis tools, including body cutting (external model and geologic body model, geologic body model are mutually cut), section cutting, tunnel cutting, along drilling cutting, closed broken line cutting, dynamic sectioning, help the user to know that geologic body internal structure is through sectioning more clearly, can more truly acquire the inside tissue condition of model, and the model after sectioning can be preserved. The system can cut the pattern in three directions X, Y, Z or along a polyline path.
The following is exemplified by a fold line cut: firstly, selecting a cutting mode, such as 'X-axis vertical', supporting adding a plurality of sections, selecting one section, adjusting the section position at the cutting axis, and operating the 'Y-axis vertical' and the 'Z-axis horizontal' identically. If "broken line cutting" is selected, a broken line path is interactively input by using a mouse, and an existing line file, such as a subway line file, can be imported, and the cutting line can be selected to extend outside the model: after cutting, the cutting result is automatically hung under the directory tree, and the cut section can be seen by closing the in-situ mass model.
The three-dimensional terrain analysis unit is used for providing various terrain analysis tools, including terrain single-point terrain parameter inquiry, distance measurement, area measurement, gradient slope direction analysis, flood inundation analysis, sunlight analysis, visual field analysis, two-point visibility judgment and fill-in calculation.
The single-point terrain parameter inquiry provides a function of inquiring the slope of the terrain of a certain area and the three-dimensional coordinate value.
The distance calculation provides the function of calculating the surface distance between any two points on the terrain, and provides four distance measurements of the surface distance, the horizontal distance, the direct distance and the vertical distance.
The area measurement function provides a calculation of the circular or polygonal area on the terrain.
Slope analysis provides the function of analyzing the slope of the terrain in a region. And a calculation mode is selected in a gradient and slope analysis interface, and the calculation mode comprises two modes of gradient and slope. The invention can select one region file by setting the range of the research region, and can also directly select the region by mouse interaction on the topography in the scene. Setting a storage path of the file, automatically performing gradient analysis by the system, and automatically hanging the gradient analysis result under the directory tree to display the gradient analysis result in the two-dimensional window.
Flood inundation presentation provides an analysis of the extent of inundation when a flood occurs in an area. The present invention performs parameter settings, including settings specifying flooding height and transparency. The region acquisition mode can select a region file, or can directly select a region range through mouse interaction. The area selection is complete and the system will calculate itself the range submerged by the flood at that height flood level with the default blue color. A path may be provided and the analysis result may be saved. The saved results can be automatically hung on the directory tree, and the previews can be checked by clicking.
The solar radiation analysis is to simulate the irradiation effect of the sun, and parameters such as the altitude angle, the azimuth angle and the like of the sun can be set, so that the shadow effect of the solar irradiation is simulated on a three-dimensional terrain model. After the time zone parameters and other parameters are set, the shadow effect of solar irradiation can be simulated on the terrain.
The visual field analysis may calculate the visibility of a certain observation point within a certain analysis area, i.e. the visual field analysis. An observation point is set, and clicking is carried out on the three-dimensional terrain model, and a small red flag appears on the point. The point is the selected viewpoint, and the system automatically displays the height of the viewpoint. And selecting a region on the terrain, wherein the region is the region to be analyzed, and after the analysis region is selected, the system automatically represents the visible region and the invisible region of the observation point in the region by different colors.
The two-point visibility judgment can judge whether the two points on the terrain are directly visible or not, and after the two points are selected, the system judges and calculates whether the two points are visible or not according to the terrain information of the observation point and the target point, and displays the two points in a three-dimensional labeling mode.
The filling and excavating method provides the function of calculating the filling and excavating range and volume of a certain area according to the height of a specified flat surface, and the color, the flat height and other information of each area can be set in a filling and excavating calculation interface. After the parameters are set, the area needing to be calculated is pulled out on the terrain, and the system can calculate the area altitude range and area value by itself.
The three-dimensional attribute model analysis unit is used for providing attribute value single-point query, attribute value filtering and model cutting visual analysis functions.
The filtering styles supported by the attribute value filtering function include: and the control of the filtering value supports direct input and action bar dragging and also supports a transparent effect setting function.
The attribute model visual analysis function provides visual analysis functions such as attribute value single-point query, attribute value filtering, model cutting and the like.
The three-dimensional attribute model analysis unit supports a plurality of filtering styles: the control of the filtering value supports direct input and action bar dragging in several modes of greater than (equal to), less than (equal to), equal to, unequal to, total non-filtering and the like. And supporting a transparent effect setting function.
The model dissection function supports dynamic and static cutting of the model in the X, Y, Z three directions, so that a user can know the internal attribute data information of the attribute model in detail from multiple angles. While supporting attribute model cut and slice model cut.
The model transparency settings allow a user to view information inside the attribute model from outside, with respective default transparency settings for a particular professional model. In addition, the method also allows the point on the model to be picked up by using a mouse, and the space coordinates and attribute values of the point to be obtained in real time.
The legend and annotation unit is used for supporting the legend of the three-dimensional model to be displayed, selecting the field displayed by the legend and directly displaying the three-dimensional legend in the scene.
The model material editing module supports modifying the material of the geological model according to the color and texture information defined by the standard stratum, supports large-scale mapping and provides mapping resolution of the real texture material of the model.
And selecting the attribute of the model, such as selecting the stratum code, listing the classification according to the stratum code of the model, and selecting the real material, the filling color and the texture display ratio table corresponding to the stratum code to be modified, so that the model material and the filling color which are wanted by the user can be selected, and the unified modification of the model texture can be completed.
The background management of the invention comprises organization configuration, function authority setting and service resource sharing authority setting. Organization configuration: the portal system provides complete resource management capability, an administrator can perform unified operation and maintenance management on various resources in the portal, can configure an organization structure, and allocate different department administrators to manage the resources of respective departments in the portal. The system comprises functions of department management, user management, role management and the like, and realizes the unified management of departments, users, roles, addition, deletion, modification, inquiry and the like. Function authority setting: and each department manager gives different functional module authorities according to different user service roles in the departments.
Resource sharing permission setting: the portal system has the capability of sharing various resources, and the supported sharing range comprises: private, public, group-designated, user-designated means of sharing resources. Sharing of specified user/group authorizations is supported, such as setting specified users/groups viewable, editable. After sharing the resources to the appointed users/groups, the appointed users/groups can check and cooperatively edit the resources by members, so that the real-time maintenance and update of the resources are realized, and the utilization rate of various resources is improved. The portal system supports unified authority control capability for the multi-source service, provides proxy function for the registered multi-source service, and conceals the original service address, thereby realizing unified authority control for the multi-source service at the portal level.
In embodiments of the present invention, computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including but not limited to an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. The utility model provides a city geology data processing platform based on big data cloud computing technique which characterized in that includes: the system comprises a data collection module, a data processing module, a database construction module and a data visualization processing module;
the data collection module is used for obtaining geological data; the database construction module is used for constructing databases of different types of data layers according to the types of the geological data so as to store the geological data; wherein the data layer database comprises: an original data layer database, a basic data layer database and a result data layer database;
the data processing module is used for analyzing the acquired geological data types and dividing the geological data types into corresponding data layer databases for storage; performing addition, deletion and verification on the geological data based on a control instruction input by a user;
The data visualization processing module is used for constructing a data model integrated unit, a data management integrated unit, a data visualization unit and a development integrated unit, so as to realize two-dimensional and three-dimensional integrated visual processing; and the supporting platform is used for integrally managing and displaying three-dimensional information in the air, on the ground, on the earth surface and under the ground, so that the full sharing of multidimensional space-time information is realized.
2. The urban geological data processing platform based on big data cloud computing technology as claimed in claim 1, wherein,
the data model integrated unit is used for uniformly expressing the two-dimensional data model and the three-dimensional data model from the concept of the element model, so that the two-dimensional data and the three-dimensional data can be managed by adopting the uniform concept;
the data management integrated unit is used for integrally managing the spatial database by a unified element class and element data set according to the classification concept;
the data visualization unit is used for displaying the two-dimensional display and the three-dimensional display in a unified view;
the development and integration unit is used for shielding the two-dimensional and three-dimensional application difference and integrating the two-dimensional and three-dimensional application functions in a plug-in management mode.
3. The urban geological data processing platform based on big data cloud computing technology according to claim 1, wherein the data visualization processing module is further configured to implement a network transmission mode of high compression ratio and streaming through an M3D data format;
A multi-level LOD model for grid division according to the data distribution characteristics;
the method comprises the steps of supporting a three-dimensional client without a plug-in, and supporting WebGL seamless fusion;
support the monomerized inquiry, support the highlight choice, support and modify the object color, modify the object visibility in batches;
five characteristics of an integrated application mode based on a desktop end, a browser end and a mobile end;
the data processing module supports the conversion of geologic body, pipeline, landscape model and OSGB data into M3D function, and based on the M3D data format, the data is released from the data service of the server to load the application to various clients, so that a B/S application solution is formed.
4. The urban geological data processing platform based on big data cloud computing technology as claimed in claim 1, wherein the original data layer is used for storing original investigation data and graphic data;
the original survey data includes: basic test analysis data, original investigation engineering geological data, field description in various drilling cards, deep well files, various test data, dynamic monitoring data and original data acquired in geophysical and geochemical investigation, wherein an original data layer is used as data for storing data which is not allowed to be changed;
the data processing module files and classifies the original data, and then records the data into a database according to different classifications;
The data processing module is used for dividing the urban geology into a plurality of data types including geographic data, regional geology, fourth-period geology, hydrogeology, engineering geology, marine geology, geological disasters, environmental geology, geochemistry and geophysics according to the characteristics of the urban geology in a basic data layer database;
the achievement data layer database comprises: various achievement data generated by a system and made by a user; the data content comprises: each professional contour line and thematic map automatically generated by the system; comprehensive evaluation results of various professions; a three-dimensional geologic structure model; analyzing a result of the three-dimensional model; various thematic drawings, thematic evaluation drawings and various partition drawings made by users.
5. The urban geological data processing platform based on big data cloud computing technology as claimed in claim 4, wherein the data processing module is used for processing geological data by the following steps:
warehousing the collected various original investigation data;
carrying out standardization processing, and storing processed data serving as basic data for subsequent analysis and evaluation into a basic database;
carrying out multi-source data coupling three-dimensional modeling by utilizing drilling data, geological map, topographic map and profile map multivariate information to establish a drilling solid model, a three-dimensional geological structure model and a three-dimensional geological attribute model;
Extracting two-dimensional basic data and three-dimensional geological model data required by analysis and evaluation, and carrying out comprehensive analysis and evaluation under the support of an evaluation model in a model database;
the analysis evaluation comprises conventional analysis evaluation and three-dimensional analysis evaluation, wherein the conventional analysis evaluation completes inquiry statistics, drawing generation and conventional professional analysis functions according to basic data, and the three-dimensional analysis evaluation performs integrated display and analysis on various three-dimensional models; the generated analysis and evaluation results are stored in a result data base;
and sharing and publishing the model data and the result data.
6. The urban geological data processing platform based on big data cloud computing technology of claim 1, further comprising: a data maintenance and update module;
the database construction module also constructs a history database;
the data maintenance and update module is used for updating the geographic data and the geological result map data, storing the old data into the historical database, and replacing the geographic data in the current database with the new data; the space data is maintained and updated, the attribute data of the geological data is maintained and updated, the three-dimensional model is maintained and updated, the attribute maintenance of the three-dimensional model is updated, and the texture is updated;
The maintenance and update mode for the three-dimensional model comprises the following steps:
for the surface topography and various geological curved surfaces, a new model is established by adopting a reconstruction method when modeling data are updated;
for an engineering geological stratum model, a three-dimensional geological model generated by dynamic and automatic modeling is adopted by virtue of drilling data, and a new model is established by adopting a reconstruction method when modeling data are updated;
for the hydrogeology with an sequence rule, a three-dimensional geologic model generated by automatically modeling a multi-source data coupling lamellar geologic body with a section as a main part is adopted, when two-dimensional section data are updated, a three-dimensional section is firstly reconstructed through a function of converting the two-dimensional section into the three-dimensional section, then the three-dimensional model is reconstructed based on the three-dimensional section, and when only the three-dimensional section or other constraint data are updated, the three-dimensional model is reconstructed;
for a fourth-line stratum model, a three-dimensional geologic body structure model established based on a cell partition-splicing interactive modeling method is adopted, geological boundary lines, geological interfaces and characteristic points in cells are modified or new data are added through a three-dimensional interactive editing tool provided by a system, then a block model is reconstructed, and model maintenance and update are realized through local update taking cells as units;
The updating mode for the maintenance of the three-dimensional model attribute comprises the following steps:
the system provides a function of editing and modifying the attribute of the model element, realizes maintenance and update of the own attribute of the three-dimensional model through the function, and realizes update of the related attribute of the three-dimensional model through maintenance and update of the related attribute table of the related database;
the updating mode of the texture comprises the following steps: the system supports a dynamic mapping function of a mode of making texture files, and a user can maintain and update textures by editing and replacing the texture files.
7. The urban geological data processing platform based on big data cloud computing technology according to claim 1, wherein the data processing module comprises: the system comprises a two-dimensional directory tree management and visual display unit, a two-dimensional data query unit, a two-dimensional data statistics unit, a surrounding drilling number statistics unit of a building, a drilling histogram generation unit, a geological profile generation and auxiliary tool and a plan generation and editing module;
the two-dimensional directory tree management and visualization display unit is used for providing users with service data nodes added with different types on the two-dimensional directory tree, displaying vector diagrams such as remote sensing images, geographic base diagrams, geological diagrams and the like of urban geological investigation areas with different scales, displaying data of different professional drilling holes and attribute point positions, and carrying out convenient node movement, grouping and renaming operations on the directory tree;
The two-dimensional data query unit is used for providing general query, single click query and information query of the vector drawing; support to carry on the screening inquiry according to attribute information and space position of the thematic point location; supporting the data export after query, information statistics, grid density query and associated histogram display query functions;
the two-dimensional data statistics unit is used for providing an operation window for setting statistics types, statistics indexes and statistics information for a user and generating a statistics graph according to the set parameters; listing the functions of setting a data source, setting a segmentation field and setting a statistics field according to the generation sequence of the statistics map;
the surrounding drilling hole number counting unit supports counting the number of drilling holes around the building area file;
the drilling histogram generation unit is used for automatically generating professional drilling histograms according to drilling holes selected by a user and a prefabricated template; the user uses a histogram template generator and a histogram macro configurator tool to generate a histogram template and support the undo and redo of editing; multistage combination and segmentation scale of the image track; strengthening the head and tail tables, supporting column merging, strengthening text display format and improving interactive editing operation; the method has the advantages that the convenient secondary development outside the image track is supported, the plug-in loading of the image track and the expansion of the functions of the histogram are realized, and the development amount when a new image track is expanded is reduced;
The geological profile generating and assisting tool provides the function of automatically generating the profile based on the drilling data and the set stratum connection mode, and performs operations of adding and deleting drilling holes, adding and editing fault lines, breaking zones, legends, responsibility tables, converting two-dimensional profiles into three-dimensional profiles and guiding out picture formats on the generated profile;
the plan generation and editing module is used for supporting a user to generate and edit professional plane geologic maps, including a drilling point position distribution map, a drilling stratum thickness/burial depth contour map, a drilling stratum distribution map, a water level contour map and a field generation contour map selected from a database.
8. The urban geological data processing platform based on big data cloud computing technology of claim 1, wherein the data processing module further comprises: the system comprises a layered geologic body rapid modeling module based on drilling, a yield push-down modeling module, a three-dimensional interactive modeling module, a zoned splicing interactive modeling module based on cross sections, a three-dimensional terrain and curved surface modeling module, a three-dimensional attribute modeling module, a zoned splicing interactive modeling module, a three-dimensional terrain and curved surface modeling module and a geologic body attribute spatial distribution modeling module;
The rapid modeling module of the layered geologic body based on drilling is used for constructing each stratum surface by adopting a grid template shared by all stratum interfaces, generating a stratum surface strong constraint point by overlapping contour line data of drilling points and layering information from a basic database on the basis of generating a terrain grid according to modeling range and precision requirements, extracting relevant stratum boundary line information from a section, carrying out interpolation calculation by applying the two types of data on the terrain grid to construct each stratum surface model, finally generating a stratum entity model according to overlapping relation geological information among strata, and meanwhile, adding terrain constraint to the surface model to construct a geological model of a real terrain and landform unit; adding various constraint data to the established geological model continuously, designating the influence range of the constraint data, and repeatedly reconstructing and updating the geological model so as to represent the real geological form;
the occurrence push-down modeling module is used for establishing a three-dimensional geological structure model reflecting stratum, fault and fold structures in a modeling area by using a bedrock geological map and bedrock buried depth contour line data; cutting a plane or a folded surface into sections by using the established model, and then modifying the cut sections according to the knowledge of experts on the geology of the region, wherein the modified sections are still added into the model to restrict the establishment of the model;
The three-dimensional interactive modeling module is used for obtaining geological rule expert experience geological information based on a modeling person through a man-machine interaction mode, connecting characteristic points of corresponding stratum on a plurality of three-dimensional geological sections, and constructing boundary contour lines of a stratum surface and a fault surface; constructing a fault plane model and a ground plane model by using the contour lines of the closed surfaces; then constructing a closed geologic body model according to the fault plane and the stratum plane;
the partition splicing interactive modeling module divides a modeling space into a plurality of cells based on cross sections, then respectively constructs each cell, and in the modeling process of each cell, proposes an auxiliary line adding and cutting method based on geological rules based on geological information implied by each section line, and then realizes automatic and rapid construction of the ground proton surface by using the cut auxiliary line and section line;
the three-dimensional terrain and curved surface modeling module is used for constructing a three-dimensional curved surface, constructing and analyzing basic terrain, and displaying the three-dimensional modeling of the collection results of basic geology, a geographic map, remote sensing images and DEM data; for two-dimensional raster data of a scanned picture, a model simplification algorithm based on visual characteristics and an adaptive technology is adopted, and an adaptive surface model is generated in real time according to the distance change from a viewpoint;
The geologic body attribute space distribution modeling module is used for modeling three-dimensional space distribution regularization of physical and chemical attribute values and other geologic parameters in the geologic body; and supporting analysis of specified geophysical and geochemical data disclosure or custom plain code formats, and reading the geophysical and geochemical data.
9. The urban geological data processing platform based on big data cloud computing technology according to claim 1, wherein the data visualization processing module comprises: the three-dimensional directory tree management and visualization display unit, the three-dimensional basic operation unit, the multi-view roaming display unit and the three-dimensional curved surface dynamic previewing unit;
the three-dimensional directory tree management and visual display unit supports adding different service data nodes on the three-dimensional directory tree, wherein the service data nodes comprise three-dimensional thematic points, terrains, geological models, attribute bodies and three-dimensional vector data;
the three-dimensional basic operation unit realizes the movement, rotation, scaling, flying-in and jumping-out operations of the model;
the multi-view roaming display unit is used for realizing double-view roaming, multi-view roaming, fixed path roaming, three-dimensional overground and three-dimensional underground dynamic double-screen display and dynamic double-screen display of two-dimensional view, three-dimensional underground view and three-dimensional overground view by taking topographic data as constraint boundaries;
The three-dimensional curved surface dynamic pre-modeling unit supports the use of a four-dimensional time sequence function, analyzes the model through temporal evolution dynamic on the time dimension on the basis of the display of the original static model, creates a three-dimensional curved surface model with large-scale data volume, and supports the dynamic pre-modeling of multiple three-dimensional curved surface models.
10. The urban geological data processing platform based on big data cloud computing technology of claim 1, wherein the data processing module further comprises: the system comprises a three-dimensional basic analysis unit, a three-dimensional model pick-up unit, a three-dimensional geologic body cutting analysis unit, a three-dimensional topography analysis unit, a three-dimensional attribute model analysis unit, a legend and annotation unit and a model material editing module;
the three-dimensional basic analysis module provides a three-dimensional model basic analysis tool which comprises a three-dimensional magnifying glass, a calculation model area and volume, a stratum model thickness calculation and a model distance calculation;
the three-dimensional model pick-up unit is used for picking up and inquiring the stratum model, the drilling model, the attribute model and the section model, and listing the attributes carried by the model in a list mode;
the three-dimensional geologic body cutting analysis unit is used for cutting and analyzing the model, and comprises body cutting, section cutting, tunnel cutting, cutting along a drilling hole, cutting along a closed fold line and dynamically cutting, and storing the cut model; cutting the model according to X, Y, Z three directions or along a broken line path;
The three-dimensional terrain analysis unit is used for providing various terrain analysis tools, including terrain single-point terrain parameter inquiry, distance measurement, area measurement, gradient slope analysis, flood inundation analysis, sunlight analysis, visual field analysis, two-point visibility judgment and fill-in calculation;
the three-dimensional attribute model analysis unit is used for providing an attribute value single-point query, attribute value filtering and model cutting visual analysis function;
the filtering styles supported by the attribute value filtering function include: the control of the filtering value supports direct input and action bar dragging and also supports a transparent effect setting function;
the attribute model visual analysis function provides visual analysis functions such as attribute value single-point query, attribute value filtering, model cutting and the like;
the legend and annotation unit is used for supporting the legend of the three-dimensional model, selecting a field displayed by the legend and directly displaying the three-dimensional legend in a scene;
the model material editing module supports modifying the material of the geological model according to the color and texture information defined by the standard stratum, supports large-scale mapping and provides mapping resolution of the real texture material of the model.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310416731.3A CN116486025A (en) | 2023-04-13 | 2023-04-13 | Urban geological data processing platform based on big data cloud computing technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310416731.3A CN116486025A (en) | 2023-04-13 | 2023-04-13 | Urban geological data processing platform based on big data cloud computing technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116486025A true CN116486025A (en) | 2023-07-25 |
Family
ID=87213182
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310416731.3A Pending CN116486025A (en) | 2023-04-13 | 2023-04-13 | Urban geological data processing platform based on big data cloud computing technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116486025A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117272191A (en) * | 2023-11-21 | 2023-12-22 | 山东省物化探勘查院 | Urban underground space intelligent mapping method and system |
| CN117437373A (en) * | 2023-12-21 | 2024-01-23 | 四川正基岩土工程有限公司 | Auxiliary drawing method and system for urban rock and soil based on web |
| CN117633140A (en) * | 2024-01-25 | 2024-03-01 | 中化地质矿山总局山东地质勘查院 | Urban geological investigation method based on big data cloud computing technology |
| CN117745466A (en) * | 2024-02-21 | 2024-03-22 | 中国有色金属工业昆明勘察设计研究院有限公司 | Tailing pond counting intelligent operation and maintenance system |
| CN117763700A (en) * | 2024-02-21 | 2024-03-26 | 济南神经网络科技有限公司 | Urban area Gaussian projection remote sensing image loading method and system |
| CN118037971A (en) * | 2024-02-22 | 2024-05-14 | 广东省核工业地质调查院 | Overground and underground three-dimensional model integrated display method and system |
| CN118050300A (en) * | 2024-04-16 | 2024-05-17 | 河北天辰仪器设备有限公司 | Geotextile intelligent vertical permeability coefficient determination method and determination device |
-
2023
- 2023-04-13 CN CN202310416731.3A patent/CN116486025A/en active Pending
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117272191A (en) * | 2023-11-21 | 2023-12-22 | 山东省物化探勘查院 | Urban underground space intelligent mapping method and system |
| CN117272191B (en) * | 2023-11-21 | 2024-02-23 | 山东省物化探勘查院 | Urban underground space intelligent mapping method and system |
| CN117437373A (en) * | 2023-12-21 | 2024-01-23 | 四川正基岩土工程有限公司 | Auxiliary drawing method and system for urban rock and soil based on web |
| CN117633140A (en) * | 2024-01-25 | 2024-03-01 | 中化地质矿山总局山东地质勘查院 | Urban geological investigation method based on big data cloud computing technology |
| CN117633140B (en) * | 2024-01-25 | 2024-04-16 | 中化地质矿山总局山东地质勘查院 | Urban geological investigation method based on big data cloud computing technology |
| CN117745466A (en) * | 2024-02-21 | 2024-03-22 | 中国有色金属工业昆明勘察设计研究院有限公司 | Tailing pond counting intelligent operation and maintenance system |
| CN117763700A (en) * | 2024-02-21 | 2024-03-26 | 济南神经网络科技有限公司 | Urban area Gaussian projection remote sensing image loading method and system |
| CN117745466B (en) * | 2024-02-21 | 2024-04-26 | 中国有色金属工业昆明勘察设计研究院有限公司 | Tailing pond counting intelligent operation and maintenance system |
| CN117763700B (en) * | 2024-02-21 | 2024-04-30 | 济南神经网络科技有限公司 | Urban area Gaussian projection remote sensing image loading method and system |
| CN118037971A (en) * | 2024-02-22 | 2024-05-14 | 广东省核工业地质调查院 | Overground and underground three-dimensional model integrated display method and system |
| CN118050300A (en) * | 2024-04-16 | 2024-05-17 | 河北天辰仪器设备有限公司 | Geotextile intelligent vertical permeability coefficient determination method and determination device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116486025A (en) | Urban geological data processing platform based on big data cloud computing technology | |
| Guo et al. | Three-dimensional geological modeling and spatial analysis from geotechnical borehole data using an implicit surface and marching tetrahedra algorithm | |
| Velasco et al. | The use of GIS-based 3D geological tools to improve hydrogeological models of sedimentary media in an urban environment | |
| CN111339691A (en) | Intelligent geotechnical engineering parameter three-dimensional analysis and evaluation system and method based on voxler software | |
| Zhang et al. | The BIM-enabled geotechnical information management of a construction project | |
| CN108765567A (en) | A kind of system for building urban design digitlization sand table | |
| CN116152461B (en) | Geological modeling method, device, computer equipment and computer readable storage medium | |
| CN113570275A (en) | Water resource real-time monitoring system based on BIM and digital elevation model | |
| Strassberg et al. | A geographic data model for representing ground water systems | |
| Dodagoudar | An integrated geotechnical database and GIS for 3D subsurface modelling: Application to Chennai City, India | |
| CN115100373A (en) | Surface and underground environment three-dimensional integrated representation method, device, medium and equipment | |
| CN113052967A (en) | Geological survey result expression method based on digital three-dimensional visualization | |
| Lin et al. | 3D geological modelling based on 2D geological map | |
| Hofierka et al. | Modelling karst landscape with massive airborne and terrestrial laser scanning data | |
| CN111243088A (en) | True three-dimensional aerial remote sensing geological interpretation method and system in engineering geological investigation | |
| He et al. | Three-dimensional hydrogeological modeling method and application based on TIN-GTP-TEN | |
| Li et al. | Integrated representation of geospatial data, model, and knowledge for digital twin railway | |
| Li et al. | 3D geological implicit modeling method of regular voxel splitting based on layered interpolation data | |
| Hegemann et al. | Hybrid ground data model for interacting simulations in mechanized tunneling | |
| Duncan et al. | 3D GIS for mine development–integrated concepts | |
| WO2018196214A1 (en) | Statistics system and statistics method for geographical influence on vernacular architectural form | |
| CN116681847A (en) | Management and service system for urban three-dimensional geological data | |
| Zhu et al. | Recent advances of digitization in rock mechanics and rock engineering | |
| Zobl et al. | Multidimensional aspects of GeoBIM data: new standards needed | |
| CN114492093A (en) | City visualization method and system |
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 |