Construction method, system and equipment of underground pipe network database and storage medium

Abstract

The invention provides an underground pipe network database construction method, system and device and a storage medium, and the method comprises the steps: obtaining the related data of a multi-source power plant overground and underground pipe network, and carrying out the standardization processing of the related data, and obtaining the standardized related data; constructing a three-dimensional twinborn model of the power plant based on the standardized related data, extracting pipe network data in the three-dimensional twinborn model, and establishing a mapping relationship between the three-dimensional twinborn model and attribute data in the pipe network data; bidirectionally associating the character file and the graphic file with corresponding objects in the three-dimensional twinborn model; and constructing an underground pipe network database according to the association relationship among the attribute data, the text file, the graphic file and the three-dimensional twinborn model. A plurality of technical means are adopted to construct a high-precision three-dimensional twinborn model for buildings, equipment, pipe networks and underground facilities of the whole plant, and a three-dimensional virtual database of the pipe network assets of the power plant is realized; and associating the three-dimensional twin model with a database to form a digital three-dimensional file of the underground pipe network.

Description

Technical Field

[0001] The present invention relates to the technical field of underground pipe network management, and in particular to a method, system, equipment and storage medium for constructing an underground pipe network database. Background Art

[0002] After a power plant is built, it has a vast number of electrical facilities, particularly underground pipelines. These crisscross and intertwine to form a complex network. However, due to incomplete, inaccurate, or inconsistent data on underground pipelines, human resources are unable to accurately determine pipeline routes in the event of a leak, a breach, or damage. Consequently, the efficiency of pipeline hazard detection and restoration is low, resulting in inestimable direct and indirect economic losses. Furthermore, power plants currently rely on manual management, with the text and graphic files serving as the basis for management stored on paper. Data and drawings are separated, making updates difficult and ensuring consistency difficult. Manual data retrieval is inefficient, making comprehensive analysis of stored data nearly impossible. Consequently, planning or renovating underground facilities and pipelines requires a lack of clarity and a lack of documentation. Engineering maintenance personnel with sufficient practical experience often serve as "walking maps," significantly complicating the construction, management, and maintenance of power plant underground facilities. In addition, traditional information systems have obvious deficiencies in processing massive spatial data and related attribute data, and are unable to support efficient management of a wide range of data types, including images, vectors, models, and human-computer interaction. Currently, the data management of underground pipe networks has the following problems:

[0003] 1. The data collection method is single and the accuracy is insufficient;

[0004] 2. Lack of 3D visualization function makes it difficult to intuitively display the spatial distribution and connection relationship of the pipeline network;

[0005] 3. Pipeline network information is isolated and lacks relevance to actual construction and operation and maintenance data;

[0006] 4. Data is not updated in a timely manner, resulting in delayed decision-making basis. Summary of the Invention

[0007] The purpose of the present invention is to provide a method, system, device and storage medium for constructing an underground pipe network database, aiming to solve the above-mentioned problems in the prior art.

[0008] An embodiment of the present invention provides a method for constructing an underground pipe network database, comprising:

[0009] Acquire relevant data of above-ground and underground pipeline networks of a multi-source power plant, and perform standardization processing on the relevant data to obtain standardized relevant data;

[0010] Constructing a three-dimensional twin model of the power plant based on the standardized relevant data, extracting the pipe network data in the three-dimensional twin model, and establishing a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data;

[0011] Bidirectionally link text and graphic files related to the underground pipe network with corresponding objects in the 3D twin model; and

[0012] The final underground pipe network database is constructed based on the association between attribute data, text files, graphic files and three-dimensional twin models.

[0013] An embodiment of the present invention provides a system for constructing an underground pipe network database, comprising:

[0014] A data module is used to obtain relevant data of the above-ground and underground pipeline networks of a multi-source power plant, and perform standardization processing on the relevant data to obtain standardized relevant data;

[0015] A twin module, configured to construct a three-dimensional twin model of the power plant based on the standardized related data, extract the pipe network data in the three-dimensional twin model, and establish a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data;

[0016] A file association module for bidirectionally associating text files and graphic files related to the underground pipe network with corresponding objects in the 3D twin model; and

[0017] The construction module is used to construct the final underground pipe network database based on the association between attribute data, text files, graphic files and 3D twin models.

[0018] An embodiment of the present invention also provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the above-mentioned method for constructing an underground pipe network database.

[0019] An embodiment of the present invention further provides a computer-readable storage medium, on which a program for implementing information transmission is stored. When the program is executed by a processor, the steps of the above-mentioned method for constructing an underground pipe network database are implemented.

[0020] The use of the embodiments of the present invention can include the following beneficial effects: The embodiments of the present invention propose a method for constructing an underground pipeline database based on laser point cloud technology and an underground pipeline mapper, and realize the digital management of power plant pipeline assets by establishing a high-precision three-dimensional twin model. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate one or more embodiments of this specification or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments recorded in this specification. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0022] Figure 1 is a flow chart of a method for constructing an underground pipe network database according to an embodiment of the present invention;

[0023] Figure 2 2 is a schematic diagram of a system for constructing an underground pipe network database according to an embodiment of the present invention. DETAILED DESCRIPTION

[0024] In order to enable those skilled in the art to better understand the technical solutions in one or more embodiments of this specification, the technical solutions in one or more embodiments of this specification will be clearly and completely described below in conjunction with the drawings in one or more embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on one or more embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without making creative efforts should fall within the scope of protection of this document.

[0025] Method Example

[0026] According to an embodiment of the present invention, a method for constructing an underground pipe network database is provided. Figure 1 This is a flow chart of a method for constructing an underground pipe network database according to an embodiment of the present invention. Figure 1 As shown, the method for constructing an underground pipe network database according to an embodiment of the present invention specifically includes:

[0027] Step S101, obtaining relevant data of the above-ground and underground pipe networks of a multi-source power plant, and performing standardization processing on the relevant data to obtain standardized relevant data, specifically includes:

[0028] Laser point cloud scanning technology is used to collect 3D data of buildings, equipment, and ground facilities throughout the power plant, generating corresponding point cloud data. An underground pipe network surveyor is used to detect the underground pipe network and obtain underground pipe network data, including spatial location, material, buried depth, direction, and connection relationships with other facilities. The spatial coordinates corresponding to the collected data are obtained by combining a geographic information system and a positioning system.

[0029] The point cloud data and the underground pipe network data are cleaned, denoised and format converted to obtain standardized related data.

[0030] Step S102, constructing a three-dimensional twin model of the power plant based on the standardized related data, extracting the pipe network data in the three-dimensional twin model, and establishing a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data, specifically includes:

[0031] Using 3D modeling software to convert the standardized related data into a 3D twin model of the power plant, extracting the pipe network data in the 3D twin model, and establishing a mapping relationship between the 3D twin model and the attribute data in the pipe network data after structured processing of the pipe network data;

[0032] The three-dimensional twin model is a three-layer structure, including a ground layer, an underground layer, and an equipment layer;

[0033] The pipeline network data includes attribute data and implicit data in the three-dimensional twin model, and the implicit data includes historical change records, inspection records and maintenance status.

[0034] Step S103, bidirectionally associating text files and graphic files related to the underground pipe network with corresponding objects in the 3D twin model, specifically includes:

[0035] The text and graphic files related to the underground pipeline network are digitized, and the processed text and graphic files are bidirectionally associated with the corresponding objects in the three-dimensional twin model through unique identifiers.

[0036] Step S104: constructing a final underground pipe network database based on the association between the attribute data, text files, graphic files and the 3D twin model;

[0037] The underground pipe network database includes spatial information, attribute information, time information, archive information and associated information of the underground pipe network.

[0038] The method further comprises:

[0039] Developing a corresponding user interaction interface based on the underground pipe network database, utilizing the user interaction interface to visualize the data in the underground pipe network database or the three-dimensional twin model and provide multiple types of service functions; wherein the multiple types of services include query and editing;

[0040] Periodically retesting the relevant data of the power plant's above-ground and underground pipeline networks, and updating the underground pipeline network database and the three-dimensional twin model based on the retested data;

[0041] And the status of the underground pipeline network is monitored in real time through the Internet of Things sensors, and the monitored abnormal data is fed back to the underground pipeline network database in real time.

[0042] The above technical solution of the embodiment of the present invention is described in detail below in conjunction with the specific situation of the method for constructing the underground pipe network database of the embodiment of the present invention.

[0043] The embodiment of the present invention aims to provide an efficient and accurate method for constructing an underground pipe network database. By using laser point cloud, underground pipe network mapping instrument and other technical means, the entire plant buildings, equipment, pipe network and underground facilities are constructed into a high-precision three-dimensional twin model, and the three-dimensional model is deeply associated with attribute data, design drawings and process parameters; and the model is associated with the database to form a digital three-dimensional archive. At the same time, the method also supports the associated storage of text archives and graphic archives, adapting to the management needs of massive spatial data and multiple data types. The embodiment of the present invention includes:

[0044] 1. Real-time data collection stage

[0045] Laser point cloud scanning technology is used to collect three-dimensional data of buildings, equipment and ground facilities throughout the factory, generating high-precision point cloud data.

[0046] Use underground pipe network surveying instruments (such as radar detectors, pipe endoscopes, etc.) to detect underground pipe networks and obtain information such as their spatial location, material, burial depth, direction, and connection relationships.

[0047] Combining the Geographic Information System (GIS) and the Global Positioning System (GPS) ensures that the collected data has accurate spatial coordinates.

[0048] 2. 3D model conversion and attribute data storage

[0049] The collected point cloud data and underground pipeline network data are cleaned, denoised and format converted to unify data standards.

[0050] Use 3D modeling software (such as BIM or CAD) to convert the processed data into a high-precision 3D twin model. The model should include the following layers:

[0051] A. Ground layer: displays the three-dimensional form of buildings, roads and other ground facilities.

[0052] B. Underground layer: Accurately restore the spatial distribution of underground pipelines and their interactions with other facilities.

[0053] C. Equipment layer: Mark the location and attribute information of key equipment.

[0054] Extract attribute data (such as pipe network type, material, specification, purpose, etc.) and implicit data (such as historical change records, maintenance status, etc.) from the 3D model, and store them in the central database after structured processing.

[0055] Establish a mapping relationship between attribute data and 3D models to ensure that each model object can be associated with its corresponding attribute data.

[0056] At this stage, the embodiment of the present invention comprehensively considers environmental factors such as the complexity and obstruction of underground and ground pipelines. Therefore, during the modeling process, first, an underground pipeline mapper and a laser point cloud 3D imager are used in combination with engineering drawings and manual experience to conduct on-site pipeline network surveys and path mapping; secondly, the accuracy of the surveying drawings is corrected through methods such as rangefinders, manual inspections, and verification of original engineering drawings, and each deviation is corrected through iterative adjustments to improve data accuracy and error control; finally, the digital, drawing, and image information materials of the design, procurement, and construction stages of the physical pipeline are combined, and accurate characteristic data such as the pipeline network path and burial depth are accessed. Through material mapping, light and shadow effects, texture details, and other means, the three-dimensional model is visually closer to the real object, thereby enhancing the perception of model accuracy.

[0057] 3. Associated storage of text files and graphic files

[0058] Text files (such as design drawings, construction records, maintenance logs, etc.) and graphic files (such as CAD drawings, as-built drawings, etc.) related to the underground pipeline network are digitized and stored in association with the corresponding objects in the 3D model through unique identifiers (UIDs). For example, design drawings (vector or raster images), design data, and the installation locations of equipment and facilities such as shafts, underground pipelines, valves, elbows (the absolute coordinates of the object's location point in the factory coordinate system), relative space (factory name, floor name, location name), path direction, pipeline and accessory names, material composition, specifications, operating parameters, manufacturers, and other design and manufacturing information, attribute information, and technical parameters are all attached to the corresponding 3D twin model to achieve linked design and two-way associated query with the 3D model.

[0059] A data entry interface was developed to allow users to quickly enter various types of relevant data (such as text files, graphic files, and process parameters) into the database, automatically generating indexes related to the 3D model. An indexing mechanism was also established to ensure that users can directly access related text files and graphic files through the 3D model, and vice versa, improving information retrieval efficiency.

[0060] 4. Massive spatial data management

[0061] In view of the characteristics of wide coverage and large data volume of the underground pipeline network three-dimensional model, distributed storage technology is adopted to divide the data by region or functional module to improve storage efficiency and access speed.

[0062] Supports comprehensive management of multiple data types (such as image data, vector data, 3D model data, etc.) to ensure data consistency and integrity.

[0063] 5. Database construction and mutual access mechanism

[0064] Build an underground pipeline network database that supports massive spatial data and its related attribute data, which can efficiently manage a variety of data types such as wide coverage, images, vectors, models, human-computer interaction, etc., covering multiple dimensions such as spatial information, attribute information, time information and related information.

[0065] The database structure should include but not be limited to the following parts:

[0066] A. Spatial information: spatial coordinates, geometric shape and topological relationship of the pipeline network.

[0067] B. Attribute information: type, material, specification, purpose and maintenance status of the pipeline network.

[0068] C. Time information: records the historical changes and update time of the pipeline network.

[0069] D. File information: associated text files and graphic files.

[0070] E. Related information: the relationship between text files, graphic files and three-dimensional models.

[0071] It realizes the two-way mutual access function between the pipeline 3D digital model and database information. Users can access relevant attribute data and design drawings through the 3D model, and can also reversely query the corresponding objects in the 3D model through attribute data or design drawings.

[0072] 6. Data association and application stage

[0073] Deeply integrate the 3D twin model with the database to ensure that each object in the model can be associated with the corresponding information in the database (including space, attributes, time and archival information).

[0074] Develop a user interaction interface that supports multiple query methods (such as query by area, query by pipe network type, etc.) to improve the system's usability and query efficiency.

[0075] It provides visual display functions and supports the display, query, and editing of three-dimensional models, allowing managers to intuitively understand the distribution, status, and historical changes of underground pipeline networks.

[0076] Support multi-terminal access (such as PC, mobile, etc.) to improve the usability of the system.

[0077] 7. Data update mechanism

[0078] Regularly re-survey the entire plant facilities using laser point clouds and underground pipe network surveying instruments, and update the three-dimensional twin model and relevant information in the database.

[0079] With the help of IoT sensors, the status of the pipeline network is monitored in real time, and abnormal data is automatically fed back to the database to ensure the timeliness and accuracy of the data.

[0080] The underground pipe network database construction method proposed in the embodiment of the present invention fully realizes computer-based graphical management of underground pipe networks by converting 3D models into a system format, storing attribute data, and associating design drawings and materials with the 3D models. This method has the following beneficial effects:

[0081] 1. Efficient model conversion: Through standardized format conversion technology, efficient import and application of 3D models are achieved, improving system compatibility.

[0082] 2. Standardized storage of attribute data: Extract attribute data and implicit data from the 3D model, perform structured processing, and store them in the central database, improving data organization and management capabilities.

[0083] 3. Multi-source data association: Establishes a deep association between design drawings, materials, process parameters and 3D models, improving data traceability and availability.

[0084] 4. Computer graphic management: Through the visual management system, the underground pipeline network can be intuitively displayed and efficiently managed, greatly improving the operation and maintenance efficiency.

[0085] 5. Dynamic data update: The application of data update mechanism and Internet of Things technology ensures the dynamic and real-time nature of the database, providing a scientific basis for the construction and operation and maintenance of power plants.

[0086] System Example

[0087] According to an embodiment of the present invention, a system for constructing an underground pipe network database is provided. Figure 2 FIG. 1 is a schematic diagram of a construction system of an underground pipe network database according to an embodiment of the present invention. Figure 2 As shown, the construction system of the underground pipe network database according to an embodiment of the present invention specifically includes:

[0088] The data module 20 is used to obtain relevant data of the above-ground and underground pipeline networks of the multi-source power plant, and perform standardization processing on the relevant data to obtain standardized relevant data;

[0089] A twin module 22 is configured to construct a three-dimensional twin model of the power plant based on the standardized related data, extract the pipe network data in the three-dimensional twin model, and establish a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data;

[0090] The file association module 24 is used to bidirectionally associate text files and graphic files related to the underground pipe network with corresponding objects in the three-dimensional twin model; and

[0091] A construction module 26 is used to construct a final underground pipe network database based on the association relationship between the attribute data, text files, graphic files and the three-dimensional twin model;

[0092] The system further comprises:

[0093] A user module is configured to develop a corresponding user interaction interface based on the underground pipe network database, and utilize the user interaction interface to visualize the data in the underground pipe network database or the three-dimensional twin model and provide multiple types of service functions; wherein the multiple types of services include query and editing;

[0094] An updating module, configured to periodically retest the relevant data of the power plant's above-ground and underground pipeline networks, and update the underground pipeline network database and the three-dimensional twin model using the retested data;

[0095] The monitoring module is used to monitor the status of the underground pipeline network in real time through the Internet of Things sensors, and to feed back the monitored abnormal data to the underground pipeline network database in real time.

[0096] The embodiment of the present invention is a system embodiment corresponding to the above-mentioned method embodiment. The specific operations of each module can be understood by referring to the description of the method embodiment, which will not be repeated here.

[0097] In summary, the present invention uses technologies such as laser point cloud and underground pipe network mapping instruments to construct a high-precision 3D twin model of all plant buildings, equipment, pipe networks, and underground facilities, creating a 3D virtual database of the power plant's pipe network assets. The 3D twin model is then linked to the database to form a digital, three-dimensional archive of the underground pipe network. This includes the following benefits:

[0098] 1. High-precision modeling: By collecting data using laser point clouds and underground pipe network mapping instruments, combined with 3D modeling technology, high-precision digital restoration of the entire plant facilities is achieved.

[0099] 2. Multi-dimensional management: The constructed database covers information in multiple dimensions such as space, attributes, time and related information, greatly improving the ability to organize and manage data.

[0100] 3. Massive data support: Using distributed storage technology, it supports the comprehensive management of various data types such as images, vectors, and models to meet the needs of massive spatial data.

[0101] 4. File-associated storage: Storing text files and graphic files in association with 3D models improves data traceability and availability.

[0102] 5. Intelligent operation and maintenance: The application of data update mechanism and Internet of Things technology ensures the dynamic and real-time nature of the database, providing a scientific basis for the construction and operation and maintenance of power plants.

[0103] Device Example 1

[0104] An embodiment of the present invention provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program implements the steps described in the method embodiment when executed by the processor.

[0105] Device Example 2

[0106] An embodiment of the present invention provides a computer-readable storage medium, on which a program for implementing information transmission is stored. When the program is executed by a processor, the steps described in the method embodiment are implemented.

[0107] The computer-readable storage medium in this embodiment includes, but is not limited to, ROM, RAM, magnetic disk, or optical disk.

[0108] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the above embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for constructing an underground pipe network database, characterized in that include: Acquire relevant data of above-ground and underground pipeline networks of a multi-source power plant, and perform standardization processing on the relevant data to obtain standardized relevant data; Constructing a three-dimensional twin model of the power plant based on the standardized relevant data, extracting the pipe network data in the three-dimensional twin model, and establishing a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data; Bidirectionally associate text and graphic files related to the underground pipe network with corresponding objects in the 3D twin model; as well as The final underground pipe network database is constructed based on the association between attribute data, text files, graphic files and three-dimensional twin models.

2. The method according to claim 1, characterized in that The method further comprises: Developing a corresponding user interaction interface based on the underground pipe network database, utilizing the user interaction interface to visualize the data in the underground pipe network database or the three-dimensional twin model and provide multiple types of service functions; wherein the multiple types of services include query and editing; Periodically retesting the relevant data of the power plant's above-ground and underground pipeline networks, and updating the underground pipeline network database and the three-dimensional twin model based on the retested data; And the status of the underground pipeline network is monitored in real time through the Internet of Things sensors, and the monitored abnormal data is fed back to the underground pipeline network database in real time.

3. The method according to claim 1, characterized in that Obtain relevant data of the above-ground and underground pipeline networks of a multi-source power plant, and perform standardization on the relevant data to obtain standardized relevant data, specifically including: Laser point cloud scanning technology is used to collect 3D data of buildings, equipment, and ground facilities throughout the power plant, generating corresponding point cloud data. An underground pipe network surveyor is used to detect the underground pipe network and obtain underground pipe network data, including spatial location, material, buried depth, direction, and connection relationships with other facilities. The spatial coordinates corresponding to the collected data are obtained by combining a geographic information system and a positioning system. The point cloud data and the underground pipe network data are cleaned, denoised and format converted to obtain standardized related data.

4. The method according to claim 1, wherein Constructing a three-dimensional twin model of a power plant based on the standardized related data, extracting the pipe network data in the three-dimensional twin model, and establishing a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data specifically includes: Using 3D modeling software to convert the standardized related data into a 3D twin model of the power plant, extracting the pipe network data in the 3D twin model, and establishing a mapping relationship between the 3D twin model and the attribute data in the pipe network data after structured processing of the pipe network data; The three-dimensional twin model is a three-layer structure, including a ground layer, an underground layer, and an equipment layer; The pipeline network data includes attribute data and implicit data in the three-dimensional twin model, and the implicit data includes historical change records, inspection records and maintenance status.

5. The method according to claim 1, wherein Bidirectionally associating text files and graphic files related to the underground pipe network with corresponding objects in the 3D twin model specifically includes: The text and graphic files related to the underground pipeline network are digitized, and the processed text and graphic files are bidirectionally associated with the corresponding objects in the three-dimensional twin model through unique identifiers.

6. The method according to claim 1, characterized in that The underground pipe network database includes spatial information, attribute information, time information, archive information and associated information of the underground pipe network.

7. A system for constructing an underground pipe network database, characterized in that include: A data module is used to obtain relevant data of the above-ground and underground pipeline networks of a multi-source power plant, and perform standardization processing on the relevant data to obtain standardized relevant data; A twin module, configured to construct a three-dimensional twin model of the power plant based on the standardized related data, extract the pipe network data in the three-dimensional twin model, and establish a mapping relationship between the three-dimensional twin model and the attribute data in the pipe network data; The file association module is used to bidirectionally associate text files and graphic files related to the underground pipe network with corresponding objects in the 3D twin model; as well as The construction module is used to construct the final underground pipe network database based on the association between attribute data, text files, graphic files and 3D twin models.

8. The system according to claim 7, characterized in that The system further comprises: A user module is configured to develop a corresponding user interaction interface based on the underground pipe network database, and utilize the user interaction interface to visualize the data in the underground pipe network database or the three-dimensional twin model and provide multiple types of service functions; wherein the multiple types of services include query and editing; An updating module, configured to periodically retest the relevant data of the power plant's above-ground and underground pipeline networks, and update the underground pipeline network database and the three-dimensional twin model using the retested data; The monitoring module is used to monitor the status of the underground pipeline network in real time through the Internet of Things sensors, and to feed back the monitored abnormal data to the underground pipeline network database in real time.

9. An electronic device, characterized in that: include: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the method for constructing an underground pipe network database as described in any one of claims 1 to 6.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores an implementation program for information transmission, and when the program is executed by the processor, the steps of the method for constructing an underground pipe network database as described in any one of claims 1 to 6 are implemented.

Images