Urban underground full-element information organization and integrated management method, system and medium

Abstract

The present invention discloses a method, system and medium for organizing and integrating urban underground all-factor information. The method obtains underground all-factor information, classifies and organizes the underground all-factor information according to detection methods and storage forms; constructs an information semantic expression model according to the association and constraint conditions between the underground all-factor information and factor entities, provides support for building a three-dimensional model of underground all-factor information and factor entities and conducting a three-dimensional evaluation of underground space development suitability, and facilitates the command of underground production and development; designs a storage structure table for the underground all-factor information and the information semantic expression model; designs a native index and a spatial index of a relational database for the storage structure table, the relational database is used to search for the underground all-factor information, and the indexing of information is also very convenient; uses a full-factor integrated management system to integrate and manage the underground all-factor information, and facilitates the continuous management and updating of the underground all-factor information.

Description

Technical Field

[0001] The present invention relates to the field of geoscience information technology and data integration technology, and in particular to a method, system and medium for organizing and integrating urban underground all-element information. Background Art

[0002] With the development of social economy, urban resource conditions, environmental carrying capacity and other issues continue to emerge. Urban geological surveys, especially underground space exploration, continue to develop and are increasingly used in production. The resulting large amount of multi-source heterogeneous geological survey data also needs to be organized and integrated. At present, in the research related to the integrated management of underground space, the integrated management of elements is focused on certain aspects that researchers are concerned about, such as geological disasters, terrain and environmental elements, underground pipelines, buildings and other elements. It is impossible to integrate and manage all elements of underground space, such as geological parameters, geological structure and existing underground space. This may lead to problems such as unclear understanding of underground conditions and uncoordinated underground space planning, resulting in development contradictions and even development accidents. Research on the organization and integrated management methods of urban underground full-element information is of great significance to the evaluation of underground space resources, coordinated planning, and high-quality development and sustainable utilization of urban underground space. Summary of the invention

[0003] The purpose of the present invention is to overcome the above-mentioned technical deficiencies and propose a method, system and medium for organizing and integrating all-element information of urban underground to solve the technical problems in the prior art of incomplete integrated elements, unclear grasp of underground conditions and uncoordinated underground space planning.

[0004] In order to achieve the above technical objectives, in a first aspect, the technical solution of the present invention provides a method for organizing and integrating urban underground all-element information, comprising the following steps:

[0005] Acquire all underground element information, and classify and organize the underground element information according to detection methods and storage forms;

[0006] Constructing an information semantic expression model according to the association and constraint conditions between the underground full-factor information and the factor entities;

[0007] Designing a storage structure table for the underground full-factor information and the information semantic expression model;

[0008] Designing a native index and a spatial index of a relational database for the storage structure table, wherein the relational database is used to search for all underground element information;

[0009] A full-factor integrated management system is used to carry out integrated management of the underground full-factor information.

[0010] Compared with the prior art, the method for organizing and integrating urban underground all-element information provided by the present invention has the following beneficial effects:

[0011] The method for organizing and integrating urban underground full-factor information provided by the present invention comprises the following steps: firstly, obtaining underground full-factor information, classifying and organizing the underground full-factor information according to detection methods and storage forms, better organizing the underground full-factor information of existing cities, and building an overall framework; secondly, constructing an information semantic expression model according to the association and constraint conditions between the underground full-factor information and the factor entities, providing support for building a three-dimensional model of the underground full-factor information and the factor entities and conducting a three-dimensional evaluation of the suitability of underground space development, and facilitating the command of underground production and development; secondly, designing a storage structure table for the underground full-factor information and the information semantic expression model; designing a native index and a spatial index of a relational database for the storage structure table, the relational database being used to search for the underground full-factor information, and being very convenient for indexing information; finally, using a full-factor integrated management system to integrate and manage the underground full-factor information, facilitating the continuous management and updating of the underground full-factor information, and having very good practical value. Unified and integrated management of all elements of underground space, including geological parameters, geological structure and existing underground space, can provide a clear understanding of the city's underground conditions, facilitate coordinated planning of underground space by municipal departments, reduce or even avoid development conflicts or accidents, and is of great significance to the evaluation and coordinated planning of underground space resources, as well as the high-quality development and sustainable utilization of urban underground space.

[0012] According to some embodiments of the present invention, the underground full-factor information is divided into: point detection information, line detection information and metadata information according to the detection method.

[0013] According to some embodiments of the present invention, the point detection information includes: drilling detection information, well logging detection information and in-situ test data.

[0014] According to some embodiments of the present invention, the survey line detection information includes: micro-seismic survey line information, electrical survey line information and magnetic survey line information.

[0015] According to some embodiments of the present invention, the underground full-factor information is divided into: attribute table data, attribute field data, structural morphology data and unstructured data according to storage form.

[0016] According to some embodiments of the present invention, constructing an information semantic expression model based on the association and constraint conditions between the underground full-factor information and the factor entities comprises the steps of:

[0017] According to the essential characteristics of the underground full-factor information, the main business scenarios, and the data usage for different tasks, semantic division is performed in combination with the relationship, connection and constraint conditions between the underground full-factor information and the feature entities, and the information semantic expression model is constructed in accordance with the organization method of three-dimensional model feature class-attribute field model-feature attribute.

[0018] According to some embodiments of the present invention, designing a storage structure table for the underground full-factor information and the information semantic expression model comprises at least one of the following steps:

[0019] When the underground all-factor information is mainly attribute table data, the storage structure table is designed in combination with metadata of the attribute table data, element attributes, and the relationship between the attribute table data and the three-dimensional model;

[0020] When the underground full-factor information is mainly attribute field data, the storage structure table is designed in combination with the basic information, level information, regular attribute field grid, irregular attribute field grid and grid model of the attribute field data;

[0021] When the underground full-element information is mainly three-dimensional element information, the storage structure table is designed in combination with simple entities, geological entities, terrain entities, and complex geological entities in the three-dimensional element information.

[0022] According to some embodiments of the present invention, the spatial index includes: establishing a B+ tree index according to an ID, and establishing an R tree index according to a geometric range.

[0023] In a second aspect, the technical solution of the present invention provides a system for organizing and integrating the information of all elements of an urban underground environment, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, it implements a method for organizing and integrating the information of all elements of an urban underground environment as described in any one of the first aspects.

[0024] In the third aspect, the technical solution of the present invention provides a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the urban underground full-element information organization and integrated management method as described in any one of the first aspects.

[0025] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the description of the embodiments in conjunction with the following drawings, wherein the abstract drawings are identical to one of the drawings in the specification:

[0027] Figure 1 A flowchart of a method for organizing and integrating urban underground all-element information provided by an embodiment of the present invention;

[0028] Figure 2 A classification diagram of underground all-factor information of a method for organizing and integrating urban underground all-factor information provided by another embodiment of the present invention;

[0029] Figure 3 A flowchart of constructing a semantic expression model for a method for organizing and integrating urban underground all-element information provided by another embodiment of the present invention;

[0030] Figure 4 A schematic diagram of a full-factor integrated management system provided for another embodiment of the present invention. DETAILED DESCRIPTION

[0031] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0032] It should be noted that, although the functional modules are divided in the system schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the system or the order in the flowchart. The terms "first", "second", etc. in the specification, claims and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence.

[0033] The present invention provides a method for organizing and integrating the information of all elements of the urban underground, which conducts unified integrated management of all elements such as the geological parameters, geological structure and existing underground space of the underground space, can clearly grasp the underground situation of the city, facilitate the coordinated planning of underground space by municipal departments, reduce or even avoid development conflicts or development accidents, and is of great significance to the evaluation and coordinated planning of underground space resources, as well as the high-quality development and sustainable utilization of urban underground space.

[0034] The embodiments of the present invention are further described below in conjunction with the accompanying drawings.

[0035] refer to Figure 1 , Figure 1This is a flowchart of a method for organizing and integrating urban underground information of all elements provided by an embodiment of the present invention. The method for organizing and integrating urban underground information of all elements includes but is not limited to steps S110 to S150.

[0036] Step S110, obtaining all underground element information, and classifying and organizing the underground element information according to detection methods and storage forms;

[0037] Step S120, constructing an information semantic expression model according to the association and constraint conditions between underground all-factor information and factor entities;

[0038] Step S130, designing a storage structure table for underground full-factor information and information semantic expression model;

[0039] Step S140, designing a native index and a spatial index of a relational database for the storage structure table, wherein the relational database is used to search for all underground element information;

[0040] Step S150, using the full-factor integrated management system to perform integrated management of all underground factor information.

[0041] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: first, obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form, better organizing the underground all-factor information of the existing city, and building an overall framework; then, constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the factor entity, providing support for building a three-dimensional model of the underground all-factor information and the factor entity and conducting a three-dimensional evaluation of the suitability of underground space development, which is convenient for the command of underground production and development; secondly, designing a storage structure table for the underground all-factor information and the information semantic expression model; designing the native index and spatial index of the relational database for the storage structure table, the relational database is used to search for the underground all-factor information, and the indexing of the information is also very convenient; finally, using the all-factor integrated management system to integrate and manage the underground all-factor information, which is convenient for the continuous management and updating of the underground all-factor information, and has very good practical value. Unified and integrated management of all elements of underground space, including geological parameters, geological structure and existing underground space, can provide a clear understanding of the city's underground conditions, facilitate coordinated planning of underground space by municipal departments, reduce or even avoid development conflicts or accidents, and is of great significance to the evaluation and coordinated planning of underground space resources, as well as the high-quality development and sustainable utilization of urban underground space.

[0042] refer to Figure 2 and Figure 3 , Figure 2A classification diagram of underground all-factor information of a method for organizing and integrating urban underground all-factor information provided by another embodiment of the present invention; Figure 3 A flowchart for constructing a semantic expression model for a method for organizing and integrating urban underground all-factor information provided in another embodiment of the present invention.

[0043] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing a native index and a spatial index of a relational database for the storage structure table, and the relational database is used to search for underground all-factor information; and using a full-factor integrated management system to integrate and manage underground all-factor information. Underground all-factor information is divided into point detection information, line detection information, and metadata information according to the detection method.

[0044] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing a native index and spatial index of a relational database for the storage structure table, and the relational database is used to search for underground all-factor information; and using a full-factor integrated management system to integrate and manage underground all-factor information. Underground all-factor information is divided into point detection information, line detection information, and metadata information according to the detection method, and the point detection information includes: drilling detection information, logging detection information, and in-situ test data.

[0045] In one embodiment, the method for organizing and integrating the urban underground full-factor information includes the following steps: obtaining underground full-factor information, classifying and organizing the underground full-factor information according to the detection method and storage form; constructing an information semantic expression model according to the association and constraint conditions between the underground full-factor information and the element entity; designing a storage structure table for the underground full-factor information and the information semantic expression model; designing the native index and spatial index of the relational database for the storage structure table, and the relational database is used to search for the underground full-factor information; using the full-factor integrated management system to integrate and manage the underground full-factor information. The underground full-factor information is divided into point detection information, line detection information and metadata information according to the detection method. The point detection information includes: drilling detection information, well logging detection information and in-situ test data. The line detection information includes: micro-seismic line information, electrical line information and magnetic line information.

[0046] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing a native index and a spatial index of a relational database for the storage structure table, and the relational database is used to search for underground all-factor information; and using a full-factor integrated management system to integrate and manage underground all-factor information. Underground all-factor information is divided into attribute table data, attribute field data, structural morphology data, and unstructured data according to the storage form.

[0047] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing the native index and spatial index of the relational database for the storage structure table, and the relational database is used to search for the underground all-factor information; using the all-factor integrated management system to integrate and manage the underground all-factor information. The underground all-factor information is divided into: attribute table data, attribute field data, structural morphology data and unstructured data according to the storage form. The underground all-factor information is divided into: point detection information, line detection information and metadata information according to the detection method, and the point detection information includes: drilling detection information, logging detection information and in-situ test data.

[0048] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing the native index and spatial index of the relational database for the storage structure table, and the relational database is used to search for the underground all-factor information; using the all-factor integrated management system to integrate and manage the underground all-factor information. The underground all-factor information is divided into: attribute table data, attribute field data, structural morphology data and unstructured data according to the storage form. The underground all-factor information is divided into: point detection information, line detection information and metadata information according to the detection method, and the point detection information includes: drilling detection information, logging detection information and in-situ test data. An information semantic expression model is constructed based on the association and constraints between the underground full-factor information and the factor entities, including the following steps: semantic division is performed based on the essential characteristics of the underground full-factor information, main business scenarios, and data usage for different tasks, combined with the relationship, connection and constraints between the underground full-factor information and the factor entities, and the information semantic expression model is constructed in accordance with the organization method of three-dimensional model factor class-attribute field model-factor attribute.

[0049] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model based on the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing the native index and spatial index of the relational database for the storage structure table, and the relational database is used to search for the underground all-factor information; using the all-factor integrated management system to integrate and manage the underground all-factor information. The underground all-factor information is divided into: attribute table data, attribute field data, structural morphology data and unstructured data according to the storage form. The underground all-factor information is divided into: point detection information, line detection information and metadata information according to the detection method, and the point detection information includes: drilling detection information, logging detection information and in-situ test data. Designing a storage structure table for underground full-factor information and information semantic expression models includes at least one of the following steps: when the underground full-factor information is mainly attribute table data, the storage structure table is designed in combination with the metadata of the attribute table data, feature attributes, and the relationship between the attribute table data and the three-dimensional model; when the underground full-factor information is mainly attribute field data, the storage structure table is designed in combination with the basic information, level information, regular attribute field grid, irregular attribute field grid and grid model of the attribute field data; when the underground full-factor information is mainly three-dimensional feature information, the storage structure table is designed in combination with the simple entities, geological entities, terrain entities, and complex geological entities in the three-dimensional feature information.

[0050] In one embodiment, the method for organizing and integrating urban underground all-factor information includes the following steps: obtaining underground all-factor information, classifying and organizing the underground all-factor information according to the detection method and storage form; constructing an information semantic expression model according to the association and constraint conditions between the underground all-factor information and the element entity; designing a storage structure table for the underground all-factor information and the information semantic expression model; designing a native index and a spatial index of a relational database for the storage structure table, and the relational database is used to search for underground all-factor information; using a full-factor integrated management system to integrate and manage underground all-factor information. The spatial index includes: establishing a B+ tree index according to an ID, and establishing an R-tree index according to a geometric range. For urban underground three-dimensional model data, a B+ tree index is established according to an ID, and an R-tree index is established according to a geometric range. Indexes are established by element category, partition and layer. According to the thematic semantic division of geological objects, geological objects are divided into several element types, stored in the spatial database in the form of element sets, and similar spatial objects are also aggregated in adjacent storage spaces in physical storage.

[0051] In one embodiment, the present invention analyzes the characteristics of all urban underground elements and their various organizational methods based on the investigated and detected urban underground full-element information, clarifies the various entities and their attributes contained in the full-element information, the connections between entities, etc., and constructs a semantic expression model between all-element information; designs its storage structure according to the characteristics of the urban underground full-element information, designs spatial index management to improve the efficiency of complex queries of heterogeneous data, and finally realizes multi-type integrated design to provide support for urban underground full-element modeling and evaluation. The main technical points are as follows:

[0052] S1: Urban underground full-factor information organization:

[0053] Investigate the information of all elements of the urban underground, analyze the differences in the detection methods and storage forms of elements, and study the various ways of organizing the information of all elements of the urban underground. According to the different detection methods of elements, classify and organize them from the aspects of point information, survey line information, metadata, etc.; according to the differences in the storage forms of elements, classify and organize all element information from the aspects of attribute table, structural morphology data, attribute field data, unstructured data, etc.

[0054] S2: Semantic expression model construction:

[0055] Establish the entities involved in all elements of the urban underground and the entity attributes that match the entities; according to the essential characteristics of all-element information, the main business scenarios, and the data usage for different tasks, consider the relationship, connection, constraint and other conditions between element entities to make reasonable semantic division, and build a semantic expression model of all-element information of the urban underground in accordance with the organization mode of three-dimensional model element class-attribute field model-attribute. Consider the storage form of all-element information, analyze the local view of the underlying all-element information, and establish an ER diagram for the entity and several entity attributes that match it, so that the ER diagram includes three information: entity, entity attribute and connection between entities.

[0056] S3: Storage structure design:

[0057] For feature storage objects based on attribute tables, a specific storage structure is designed considering the description of the feature information itself (metadata attributes), the attributes of the feature class, the relationship between features, and the three-dimensional model.

[0058] For attribute field information, on the basis of mainstream storage solutions, a storage structure table is designed considering the basic information, level information, regular attribute field grid, irregular attribute field grid, grid model, grid model index and other characteristics.

[0059] For three-dimensional feature information, on the basis of mainstream storage solutions, the storage structure table is designed considering the characteristics of simple entities, geological entities, terrain entities, and complex geological entities.

[0060] S4: Index design: Design native indexes and spatial indexes of relational databases for different application scenarios, and consider the spatial attributes of data and commonly used query fields, provide a higher level of joint indexing and query optimization components on top of the database and file system, and improve the efficiency of complex queries of heterogeneous data. Establish different spatial indexes according to different situations: For urban underground three-dimensional model data, establish B+ tree indexes based on ID, and establish R tree indexes based on geometric ranges. Establish indexes by feature category, partition and layer. Based on the thematic semantic division of geological objects, geological objects are divided into several feature types and stored in the spatial database in the form of feature sets, and similar spatial objects are also aggregated in adjacent storage spaces in physical storage.

[0061] S5: Integrated design:

[0062] All-factor information is stored separately as file-type elements and attribute table-type elements. For structural element information, underground space models, images, documents and other element information stored in file form, storage methods on different types of file systems are designed according to their data volume, access frequency, availability requirements, access methods and other characteristics. The metadata storage table of the file is designed considering the storage form of the file metadata in the database to achieve integrated and efficient integrated management of different types of all-factor data.

[0063] Compared with the traditional organization and integrated management of urban underground information, the present invention provides a method for organizing and integrating the information of all elements of urban underground space, which can efficiently organize and integrate the management of various elements of urban underground space-related resources, and is conducive to solving the problems of unclear understanding of underground conditions and development contradictions caused by incomplete elements of traditional underground space integrated management. It is of great significance to the evaluation of underground space resources, coordinated planning, and high-quality development and sustainable utilization of urban underground space.

[0064] refer to Figure 4 , Figure 4 A schematic diagram of a full-factor integrated management system provided for another embodiment of the present invention.

[0065] The present invention provides a city underground full-element information organization and integrated management system, comprising: a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the city underground full-element information organization and integrated management method as described above when executing the computer program.

[0066] The processor and the memory may be connected via a bus or other means.

[0067] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely disposed relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0068] It should be noted that the urban underground full-factor information organization and integrated management system in this embodiment may include a business processing module, an edge database, a server-side version information register, and a data synchronization module. When the processor executes the computer program, it implements the urban underground full-factor information organization and integrated management method as mentioned above in the urban underground full-factor information organization and integrated management system.

[0069] The device embodiments described above are merely illustrative, and the units described as separate components may or may not be physically separated, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0070] In addition, an embodiment of the present invention also provides a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are executed by a processor or controller, for example, by a processor in the above-mentioned terminal embodiment, so that the above-mentioned processor can execute the urban underground full-element information organization and integrated management method in the above-mentioned embodiment.

[0071] It will be appreciated by those skilled in the art that all or some of the steps and systems in the disclosed method above may be implemented as software, firmware, hardware and appropriate combinations thereof. Some physical components or all physical components may be implemented as software executed by a processor, such as a central processing unit, a digital signal processor or a microprocessor, or may be implemented as hardware, or may be implemented as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or a non-transitory medium) and a communication medium (or a temporary medium). As known to those skilled in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules or other data). Computer storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technologies, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, disk storage or other magnetic storage devices, or any other medium that may be used to store desired information and may be accessed by a computer. Furthermore, it is well known to those skilled in the art that communication media typically embodies computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

[0072] The above is a specific description of the preferred implementation of the present invention, but the present invention is not limited to the above-mentioned implementation mode. Technical personnel familiar with the field can also make various equivalent deformations or substitutions without violating the spirit of the present invention. These equivalent deformations or substitutions are all included in the scope defined by the claims of the present invention.

[0073] The specific implementation of the present invention described above does not constitute a limitation on the protection scope of the present invention. Any other corresponding changes and modifications made based on the technical concept of the present invention should be included in the protection scope of the claims of the present invention.

Claims

1. A method for organizing and integrating urban underground all-element information, characterized in that: The following steps are involved: Acquire all underground element information, and classify and organize the underground element information according to detection methods and storage forms; Constructing an information semantic expression model according to the association and constraint conditions between the underground full-factor information and the factor entities; Designing a storage structure table for the underground full-factor information and the information semantic expression model; Designing a native index and a spatial index of a relational database for the storage structure table, wherein the relational database is used to search for all underground element information; Use a full-factor integrated management system to integrate and manage the underground full-factor information; The underground full-factor information is divided into: attribute table data, attribute field data, structural morphology data and unstructured data according to the storage form; The information semantic expression model is constructed according to the association and constraint conditions between the underground full-element information and the element entities, comprising the steps of: According to the essential characteristics of the underground full-factor information, the main business scenarios, and the data usage for different tasks, the semantic division is carried out in combination with the relationship, connection and constraint conditions between the underground full-factor information and the element entities, and the information semantic expression model is constructed in accordance with the organization mode of three-dimensional model element class-attribute field model-element attribute; The designing of a storage structure table for the underground full-factor information and the information semantic expression model comprises at least one of the following steps: When the underground all-factor information is mainly attribute table data, the storage structure table is designed in combination with metadata of the attribute table data, element attributes, and the relationship between the attribute table data and the three-dimensional model; When the underground full-factor information is mainly attribute field data, the storage structure table is designed in combination with the basic information, level information, regular attribute field grid, irregular attribute field grid and grid model of the attribute field data; When the underground full-element information is mainly three-dimensional element information, the storage structure table is designed in combination with simple entities, geological entities, terrain entities, and complex geological entities in the three-dimensional element information.

2. A method for organizing and integrating urban underground all-element information according to claim 1, characterized in that: The underground full-factor information is divided into: point detection information, line detection information and metadata information according to the detection method.

3. A method for organizing and integrating urban underground all-element information according to claim 2, characterized in that: The point detection information includes: drilling detection information, logging detection information and in-situ test data.

4. A method for organizing and integrating urban underground all-element information according to claim 2, characterized in that: The survey line detection information includes: micro-seismic survey line information, electrical survey line information and magnetic survey line information.

5. The method for organizing and integrating urban underground all-element information according to claim 1 is characterized in that: The spatial index includes: establishing a B+ tree index according to an ID, and establishing an R tree index according to a geometric range.

6. An urban underground full-element information organization and integrated management system, characterized in that: include: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method for organizing and integrating urban underground full-element information as described in any one of claims 1 to 5 when executing the computer program.

7. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the urban underground full-element information organization and integrated management method as described in any one of claims 1 to 5.

Images