Underground pipeline geophysical prospecting data multi-source fusion system, method, equipment and medium

Abstract

The invention provides an underground pipeline geophysical prospecting data multi-source fusion system, method, device and medium, and belongs to the field of geophysical prospecting, and the method specifically comprises the steps: obtaining geophysical prospecting point table data of different formats from different sources; according to the geophysical prospecting point table data in different formats, constructing a pipeline layout three-dimensional model of the underground pipeline in different three-dimensional spaces; displaying the pipeline layout three-dimensional model so as to receive modification of underground pipelines in the pipeline layout three-dimensional model by a user, and performing real-time adjustment; the pipeline layout three-dimensional models of the geophysical prospecting point table data from different sources are uniformly fused and mapped to a standard three-dimensional space, and a three-dimensional fusion model is generated; through a space geometry algorithm, detecting the collision risk between different pipeline layout three-dimensional models in the three-dimensional fusion model, and generating visual early warning information in real time; and outputting the three-dimensional fusion model as a drawing file in a specified format according to a preset rule. Through the processing scheme provided by the invention, real-time linkage of data can be realized, multi-source information can be fused, and three-dimensional intelligent analysis can be provided.

Description

Technical Field

[0001] This application relates to the field of geophysical exploration, and in particular to a multi-source fusion system, method, equipment, and medium for geophysical data of underground pipelines. Background Technology

[0002] Underground pipelines are the "lifeline" of a city, making the accuracy, timeliness, and visual management of their data crucial. Currently, the geophysical exploration industry faces the following long-standing unresolved technical challenges in editing and managing various pipeline data: 1. Image library is separate and cannot be linked. The attribute data collected in the field (stored in an embedded database, such as an SQLite database stored in DB3 format) and the graphic data (CAD drawings) generated in the office are physically isolated. CAD files (e.g., .dwg) and database files (e.g., .db3) are two independent physical files, and modifications occur in their respective closed environments, preventing updates to the other's data. After modifying the drawing, the attribute database cannot automatically update based on the changes; conversely, modifying attribute data cannot be synchronized to the graphic data. This leads to inconsistencies between the field and office data, requiring extensive manual comparison and verification, which is inefficient and prone to errors.

[0003] 2. Data from multiple sources is isolated and difficult to integrate. For trenchless pipelines and pipelines inferred through blind exploration technology, existing software cannot generate and display the corresponding point table data of the pipelines on the same result map, resulting in a "two-layer" phenomenon and failing to provide a complete and unified view of underground space.

[0004] 3. Poor visualization effects and information overload. Two-dimensional CAD drawings struggle to express complex three-dimensional spatial relationships. Traditional 2D CAD engines or simple graphical controls cannot clearly render and represent multi-dimensional and multi-type data within a single view. For example, clearly representing a three-dimensional trenchless trajectory and its relationship with surrounding pipelines on a two-dimensional plane presents a technical challenge. Furthermore, in areas with dense pipelines, overlapping and overlapping annotations negatively impact the accuracy and efficiency of data interpretation.

[0005] 4. Lack of intelligent analysis capabilities The risk of spatial collisions between pipelines relies entirely on manual judgment, making it impossible to quickly and automatically identify potential conflicts between existing pipelines or with newly planned pipelines, which poses a huge safety hazard to subsequent construction.

[0006] The core problems of the aforementioned pipeline geophysical exploration technology system can be summarized as: "fragmented data flow, limited representation dimensions, and low intelligence level." This results in the entire workflow relying heavily on manual intervention, leading to low efficiency, high error rates, and high risks.

[0007] Therefore, there is an urgent need in this field for a method that can solve the above-mentioned pain points. Summary of the Invention

[0008] Therefore, in order to overcome the shortcomings of the prior art, the present invention provides a multi-source fusion system, method, device and medium for underground pipeline geophysical exploration data that can achieve real-time data linkage, integrate multi-source information and provide three-dimensional intelligent analysis.

[0009] To achieve the above objectives, this invention provides a multi-source fusion system for underground pipeline geophysical exploration data, comprising: a data integration module for acquiring geophysical point table data of different formats from different sources, wherein the geophysical point table data includes three-dimensional coordinates and burial depth data corresponding to underground pipelines at various geophysical points; a three-dimensional model generation module for mapping the geophysical point table data of different formats to corresponding three-dimensional spaces and constructing three-dimensional models of the underground pipeline layout in different three-dimensional spaces; a two-way linkage editing module for displaying the three-dimensional model of the pipeline layout to receive user modifications to the underground pipelines in the three-dimensional model of the pipeline layout and to adjust the three-dimensional model of the pipeline layout in real time; a multi-source data fusion processing module for uniformly fusing and mapping the three-dimensional models of the pipeline layout from geophysical point table data of different sources to a standard three-dimensional space to generate a three-dimensional fusion model; an intelligent collision detection module for detecting the collision risk between different three-dimensional models of the pipeline layout in the three-dimensional fusion model through spatial geometric algorithms and generating visual early warning information in real time; and an output module for outputting the three-dimensional fusion model into a drawing file of a specified format according to predetermined rules.

[0010] In one embodiment, the three-dimensional model generation module includes: a pipeline analysis unit, used to perform statistical analysis on the geophysical point table data to obtain the types of pipe segments that make up the underground pipeline and their corresponding parameter dimensions; a pipe segment model generation unit, used to generate pipe segment models corresponding to each pipe segment type based on the parameter dimensions; and a model establishment unit, used to establish three-dimensional models of the underground pipeline layout in different three-dimensional spaces using the three-dimensional coordinates and the burial depth data.

[0011] In one embodiment, the 3D model generation module further includes: a pipe segment type creation unit, used to create pipe fitting templates for various manhole covers, valves, and pipes that make up the corresponding underground pipeline for different formats; and a configuration mapping unit, used to map and store the pipe segment model and the corresponding format through a configuration file.

[0012] In one embodiment, the multi-source data fusion processing module includes: a coordinate system transformation unit, used to transform the parameter data of geophysical point table data from different sources according to a coordinate system, so as to map multiple pipeline layout 3D models to a target coordinate system; a mapping unit, used to match the transformed geophysical point table data with the spatial location of underground pipelines, so as to map multiple pipeline layout 3D models to the standard 3D space where the target coordinate system is located; a conflict detection unit, used to detect and determine whether there is an attribute association between different pipeline layout 3D models in the standard 3D space; a model fusion unit, used to fuse the parameter data of the multiple pipeline layout 3D models to obtain 3D fusion parameter data in the standard 3D space; and a 3D modeling unit, used to output a 3D fusion model according to the 3D fusion parameter data.

[0013] In one embodiment, the bidirectional linkage editing module includes: a three-dimensional front-end display unit for displaying the pipeline layout three-dimensional model in real time, allowing the user to update and adjust a certain pipe segment model in the pipeline layout three-dimensional model; a listening unit for listening to the user's adjustments in the pipeline layout three-dimensional model and generating a corresponding model update request; and a response unit for calling and updating the pipe segment model according to the model update request, and establishing a real-time responsive pipeline layout three-dimensional model.

[0014] In one embodiment, the intelligent collision detection module includes: a model analysis unit, used to analyze the vertical intersection risk and horizontal collision risk of the underground pipeline in different pipeline layout 3D models through the pipeline layout 3D model, and obtain risk assessment results; and a risk rendering unit, used to render and annotate the risk coordinates in the pipeline layout 3D model according to the risk assessment results, and feed them back to the bidirectional linkage editing module for display.

[0015] In one embodiment, the output module includes: a testing unit for performing pressure tests on pipeline data in the three-dimensional fusion model; and a model output unit for outputting the tested three-dimensional fusion model as a drawing file in a specified format according to predetermined rules.

[0016] A multi-source fusion method for underground pipeline geophysical exploration data includes: acquiring geophysical point table data of different formats from different sources, wherein the geophysical point table data contains three-dimensional coordinates and burial depth data corresponding to underground pipelines at various geophysical point locations; mapping the geophysical point table data of different formats to corresponding three-dimensional spaces and constructing three-dimensional models of the underground pipeline layout in different three-dimensional spaces; displaying the three-dimensional models of the pipeline layout to receive user modifications to the underground pipelines in the three-dimensional models of the pipeline layout and to adjust the three-dimensional models of the pipeline layout in real time; uniformly fusing and mapping the three-dimensional models of the pipeline layout from geophysical point table data of different sources to a standard three-dimensional space to generate a three-dimensional fusion model; detecting collision risks between different three-dimensional models of the pipeline layout in the three-dimensional fusion model through spatial geometric algorithms and generating visual early warning information in real time; and outputting the three-dimensional fusion model as a drawing file of a specified format according to predetermined rules.

[0017] A computer device includes a memory and a processor, the memory storing a computer program, characterized in that the processor executes the computer program to implement the steps of the above-described method.

[0018] A computer-readable storage medium having a computer program stored thereon, characterized in that the computer program, when executed by a processor, implements the steps of the above-described method.

[0019] Compared with existing technologies, the advantages of this invention are: by unifying and mapping the geophysical point table data of different formats into a standard three-dimensional space, it overcomes the fundamental defects of existing underground pipeline management technologies, such as map library separation, isolated multi-source data, poor visualization effects, and lack of intelligent analysis.

[0020] Furthermore, this application achieves seamless data flow by unifying and mapping the geophysical point data in different formats into a standard three-dimensional space. It breaks down data barriers between field data collection, data processing, and results management, ensuring real-time bidirectional synchronization from mobile to desktop and from graphics to attributes, completely resolving the "lack of map library linkage" problem and eliminating data inconsistencies. Moreover, the unified underground space data model constructed is a unified management solution integrating multi-source heterogeneous data from excavation, trenchless, and blind exploration, generating a truly comprehensive "single map" of underground pipelines and solving the "two maps" problem.

[0021] This application also utilizes 3D visualization technology through a two-way interactive editing module to intuitively display the spatial distribution of pipelines, enhancing data visualization and interactive experience, and solving the problems of overlapping markings and difficult information interpretation in 2D views. The intelligent collision detection module achieves automated collision detection, shifting the management of underground pipelines from post-event verification to pre-event warning, proactively identifying spatial conflicts, and significantly improving the safety of underground pipeline planning, design, and construction. Furthermore, the entire process significantly reduces the workload of manual data cleaning, drawing preparation, and risk assessment, optimizing the entire workflow and improving work efficiency. Attached Figure Description

[0022] To more clearly illustrate the technical solutions of the embodiments of this application, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0023] Figure 1 This is a structural block diagram of the multi-source fusion system for underground pipeline geophysical exploration data in an embodiment of the present invention; Figure 2 This is a flowchart of the multi-source fusion system for underground pipeline geophysical exploration data in an embodiment of the present invention; Figure 3 This is a flowchart illustrating the multi-source fusion method for geophysical exploration data of underground pipelines in an embodiment of the present invention; Figure 4 This is an internal structural diagram of a computer device in an embodiment of the present invention. Detailed Implementation

[0024] The embodiments of this application will now be described in detail with reference to the accompanying drawings.

[0025] The following specific examples illustrate the implementation of this application. Those skilled in the art can easily understand other advantages and effects of this application from the content disclosed in this specification. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of them. This application can also be implemented or applied through other different specific embodiments, and the details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of this application. It should be noted that, in the absence of conflict, the following embodiments and features in the embodiments can be combined with each other. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0026] It should be noted that the following description covers various aspects of embodiments within the scope of protection of this invention. It will be apparent that the aspects described herein can be embodied in a wide variety of forms, and any particular structure and / or function described herein is merely illustrative. Based on this application, those skilled in the art will understand that one aspect described herein can be implemented independently of any other aspect, and two or more of these aspects can be combined in various ways. For example, any number and aspects set forth herein can be used to implement the device and / or practice the method. Additionally, this device and / or method can be implemented using other structures and / or functionalities besides one or more of the aspects set forth herein.

[0027] It should also be noted that the illustrations provided in the following embodiments are only schematic representations of the basic concept of this application. The drawings only show the components related to this application and are not drawn according to the actual number, shape and size of the components in the actual implementation. In the actual implementation, the form, quantity and proportion of each component can be arbitrarily changed, and the layout of the components may also be more complex.

[0028] Furthermore, specific details are provided in the following description to facilitate a thorough understanding of the examples. However, those skilled in the art will understand that the described aspects can be practiced without these specific details.

[0029] like Figure 1 and Figure 2 As shown in the figure, this application provides a multi-source fusion system for geophysical exploration data of underground pipelines, including a data integration module 101, a three-dimensional model generation module 102, a two-way linkage editing module 103, a multi-source data fusion processing module 104, an intelligent collision detection module 105, and an output module 106.

[0030] The data integration module 101 is used to acquire geophysical point table data in different formats from different sources. The geophysical point table data includes the three-dimensional coordinates and burial depth data corresponding to the underground pipelines at each geophysical point location.

[0031] Geophysical point table data is a core data table used in geophysical exploration and underground pipeline detection to record the location, attributes, and results of measurement points. It serves as both the original record of field data collection and the foundation for subsequent 3D modeling, analysis, and data management. The geophysical points in the table are the physical locations where measurements were taken; these can be pipeline points or connection points of underground pipelines. The geophysical point table data includes the 3D coordinates and depth data corresponding to each underground pipeline at the geophysical point location. For example, the data may include information such as pipeline point, connection point, x-coordinate, y-coordinate, pipe top elevation, pipe bottom elevation, depth, and attributes. Geophysical point table data can be excavated data, trenchless data, or blind exploration data. Excavated data is obtained through open trench excavation or post-excavation field measurements, including as-built surveys and well survey data, and can be collected using handheld field equipment or RTK positioning equipment. Trenchless data is pipeline data obtained through directional drilling techniques such as pipe jacking and pipe pulling, and can be obtained through construction guidance records or subsequent specialized surveys. Blind probe data refers to the detection data of non-metallic pipelines using ground-penetrating radar (GPR). Geophysical point table data can be data in various formats collected by handheld devices in the field (site data acquisition). In this case, the data integration module 101 can integrate and summarize the multiple formats of data collected by the same handheld device in the field to obtain precise coordinate data from the site, ensuring the accuracy and completeness of the data source. Geophysical point table data is stored in the underlying attribute database.

[0032] The 3D model generation module 102 is communicatively connected to the data integration module 101. The 3D model generation module 102 maps geophysical point table data of different formats transmitted from the data integration module 101 into corresponding 3D spaces, and constructs 3D models of underground pipeline layouts in different 3D spaces. Based on the imported geophysical point table data, the 3D model generation module 102 automatically and quickly constructs 3D models of underground pipelines on a 3D platform using preset modeling rules and algorithms, enabling three-dimensional visualization query and management of the data.

[0033] For example, the 3D model generation module 102 can directly use the engineering coordinate system during construction to convert excavation data into a 3D model of underground pipelines; the 3D model generation module 102 can also first determine the transformation amount for converting the engineering coordinate system during construction into a unified urban coordinate system, and then convert the trenchless data into a 3D model of underground pipelines in the unified urban coordinate system based on the transformation amount; the 3D model generation module 102 can also determine the absolute coordinate system corresponding to the blind exploration data through bottom surface marker points, and then convert the blind exploration data into a 3D model of underground pipelines in the absolute coordinate system. After determining the coordinate system corresponding to the geophysical point table data, the 3D model generation module 102 further determines the position of each pipe segment in the underground pipeline in 3D space, and then generates 3D entities of the pipeline segments in the corresponding 3D space. Finally, based on the topological relationship in the geophysical point table data, it assembles all the 3D entities of the pipeline segments into a 3D model of the underground pipeline.

[0034] The bidirectional linkage editing module 103 is used to display the 3D model of the pipeline layout, so as to receive user modifications to the underground pipelines in the 3D model and adjust the 3D model of the pipeline layout in real time. The bidirectional linkage editing module 103 allows users to directly make graphical adjustments to the pipeline model in the 3D scene, such as moving nodes and modifying the direction, and any graphical modification will be updated to the underlying attribute database in real time. At the same time, any changes to attribute information in the database will also be synchronized to the 3D model in real time, which completely solves the problem of the library not being linked. The bidirectional linkage editing module 103 can directly replace the original attribute data with the user's graphically modified attribute data, or it can store the user's graphically modified attribute data as the new version of attribute data and store it in the underlying attribute database.

[0035] After displaying the 3D model of the pipeline layout, the bidirectional linkage editing module 103 can generate a calling interface for the 3D model and publish it. After publication, the bidirectional linkage editing module 103 receives user modifications to the underground pipelines in the 3D model. These modifications can be dragging and dropping a pipeline segment in the 3D model; adjusting the parameters of a pipeline segment; or deleting or adding a pipeline segment.

[0036] The multi-source data fusion processing module 104 is used to uniformly fuse and map the 3D model of pipeline layout from geophysical point table data from different sources into a standard 3D space, generating a 3D fusion model. The multi-source data fusion processing module 104 standardizes pipeline data from different sources and with different levels of precision, such as trenchless data and blind exploration data, and integrates them uniformly into a standard 3D space to generate a 3D fusion model. The attribute data of the 3D fusion model is stored in the underlying attribute database, enabling the management of multi-source data from a single map, thereby solving the problem of having two separate maps.

[0037] The intelligent collision detection module 105 is used to detect collision risks between different pipeline layout 3D models in a 3D fusion model using spatial geometric algorithms, and generates real-time visual early warning information. Based on the generated 3D fusion model, the intelligent collision detection module 105 automatically detects collision risks such as intersections and excessively close spacing between different pipeline models in 3D space using spatial geometric algorithms, and provides real-time visual early warnings to provide decision support for safe construction.

[0038] The output module 106 is used to output the 3D fusion model as a drawing file in a specified format according to predetermined rules. Based on a customized template, the output module 106 can export geophysical results tables and schematic CAD drawings that conform to industry standards with one click, which can greatly improve the efficiency of outputting indoor (indoor data processing and mapping) results.

[0039] The aforementioned system overcomes the fundamental shortcomings of existing underground pipeline management technologies, such as map library separation, isolated multi-source data, poor visualization effects, and lack of intelligent analysis, by unifying and mapping geophysical point data in different formats into a standard three-dimensional space.

[0040] Furthermore, this application achieves seamless data flow by unifying and mapping geophysical point data in different formats into a standard 3D space. It breaks down data barriers between field data collection, data processing, and results management, ensuring real-time bidirectional synchronization from mobile to desktop and from graphics to attributes, completely resolving the "lack of map library linkage" problem and eliminating data inconsistencies. Moreover, the unified underground space data model it constructs is a unified management solution integrating multi-source heterogeneous data from excavation, trenchless, and blind exploration, generating a truly comprehensive "single map" of underground pipelines and solving the "two maps" problem.

[0041] This application also utilizes 3D visualization technology through a two-way interactive editing module to intuitively display the spatial distribution of pipelines, enhancing data visualization and interactive experience, and solving the problems of overlapping markings and difficult information interpretation in 2D views. The intelligent collision detection module achieves automated collision detection, shifting the management of underground pipelines from post-event verification to pre-event warning, proactively identifying spatial conflicts, and significantly improving the safety of underground pipeline planning, design, and construction. Furthermore, the entire process significantly reduces the workload of manual data cleaning, drawing preparation, and risk assessment, optimizing the entire workflow and improving work efficiency.

[0042] In one embodiment, the 3D model generation module includes a pipeline analysis unit, a pipe segment model generation unit, and a model building unit.

[0043] The pipeline analysis unit is used to perform statistical analysis on the geophysical point table data to obtain the types of each pipe segment that make up the underground pipeline and their corresponding parameter dimensions.

[0044] The pipeline analysis unit analyzes the geophysical point table data to identify the pipeline segments that make up the underground pipeline. Then, based on characteristic points such as the start and end points, turning points, tees, and crosses of the pipeline segments, it determines the pipeline type. Next, it obtains the corresponding pipe fitting templates and corresponding parameter dimensions based on the determined pipeline type. Pipeline segments can be not only pipes but also pipe accessories. Pipe accessories can be manholes, valves, supports, and other components associated with the pipeline. Pipe segment types can be various manhole covers, valves, and pipes of the underground pipeline. The pipeline analysis unit also analyzes and obtains the parameter dimensions corresponding to the pipe segment type. The pipeline analysis unit can create and store core data tables, such as pipe point tables, pipe segment tables, and project tables. The attribute fields in the core data tables, such as pipe diameter, material, pipeline type, ownership unit, and detection date, are all standardized fields and can be directly obtained from the geophysical point table data.

[0045] The pipe segment model generation unit is used to generate pipe segment models corresponding to each pipe segment type based on parameter dimensions. The pipe segment model generation unit takes two-dimensional data composed of parameter dimensions and automatically stretches the pipe fitting template into a pipe segment model corresponding to each pipe segment type along the pipeline route.

[0046] The model building unit is used to create 3D models of underground pipeline layouts in different 3D spaces using 3D coordinates and burial depth data. Based on the 3D coordinates and burial depth data, the unit first locates the pipeline segments at their burial depth positions, and then creates 3D models of the underground pipeline layouts in different 3D spaces. The unit can also color-code the pipelines according to their functions; for example, water supply pipelines are blue; gas pipelines are purple; power lines are red; communication pipelines are green; and sewage pipelines are brown.

[0047] The model building unit can also define 3D spatial fields (for storing coordinates with elevation) based on 3D coordinates and burial depth data, and store them in the corresponding pipe point table, pipe segment table, or project table. The model building unit can also create a systematic metadata management table corresponding to the pipeline layout 3D model, recording information such as data source, accuracy, and version, thereby creating a spatial index for all pipeline spatial fields and significantly improving the performance of subsequent spatial queries. Since the model building unit is generated based on geophysical point table data in the database, any changes to attribute information in the database will be synchronized to the pipeline layout 3D model in real time, completely solving the problem of incoordination between the map library and the model.

[0048] The system described above not only automatically and quickly constructs a 3D model of the pipeline layout, enabling three-dimensional visualization and management of data; it also constructs a 3D spatial database, thereby establishing spatial indexes for the spatial fields of all pipelines and significantly improving the performance of subsequent spatial queries.

[0049] In one embodiment, the 3D model generation module further includes a pipe segment type creation unit and a configuration mapping unit.

[0050] The Pipe Segment Type Creation Unit is used to create pipe fitting templates for various manhole covers, valves, and pipes that make up corresponding underground pipelines, based on different formats. The Pipe Segment Type Creation Unit can create parametric models of various manhole covers, valves, and pipes using 3D modeling software.

[0051] The configuration mapping unit is used to map and store pipe segment models and their corresponding formats via configuration files. This unit establishes a configuration file within the system that defines the "symbol-attribute" mapping rules, specifying which attribute combinations correspond to which 3D model formats.

[0052] The aforementioned system can construct various manhole covers, valves, and pipes in a 3D model of pipeline layout, thereby enabling three-dimensional visualization query and management of data.

[0053] In one embodiment, the multi-source data fusion processing module includes a coordinate system transformation unit, a mapping unit, a conflict detection unit, a model fusion unit, and a 3D modeling unit.

[0054] The coordinate system transformation unit is used to transform the parameter data of geophysical point table data from different sources according to the coordinate system, so as to map multiple pipeline layout 3D models to a target coordinate system. The coordinate system transformation unit can first standardize pipeline data from different sources and with different accuracies, such as trenchless data and blind probe data, and then transform the parameter data of the geophysical point table data from different sources according to the coordinate system, so as to map multiple pipeline layout 3D models to a target coordinate system, thereby facilitating the subsequent integration of multiple pipeline layout 3D models into a single 3D scene. During the process of transforming the parameter data of geophysical point table data from different sources according to the coordinate system, the coordinate system transformation unit can assign different weights to the data from different sources. For example, the weight of excavated data > the weight of trenchless data (the weight of metallic pipelines is greater than the weight of non-metallic pipelines) > the weight of blind probe data, in order to reduce error interference when mapping multiple pipeline layout 3D models to a target coordinate system.

[0055] The mapping unit is used to match the converted geophysical point table data with the spatial location of underground pipelines, enabling the mapping of multiple pipeline layout 3D models to the standard 3D space of the target coordinate system. The mapping unit adjusts the pipeline layout 3D model based on the geophysical point table data converted by the coordinate system transformation unit, and then maps the adjusted pipeline layout 3D model to the standard 3D space of the target coordinate system.

[0056] The collision detection unit is used to detect and determine whether there are attribute relationships between different pipeline layout 3D models in standard 3D space. Based on the generated 3D model, the collision detection unit uses spatial geometric algorithms to automatically detect collision risks such as intersections and excessively close spacing between different pipeline models in standard 3D space, and provides real-time visual warnings based on the detected collision risks, thereby providing decision analysis and support for early-stage safe construction.

[0057] The model fusion unit is used to fuse the parameter data of multiple pipeline layout 3D models to obtain 3D fused parameter data in standard 3D space. When there are attribute relationships between different pipeline layout 3D models, the model fusion unit will additionally annotate the attribute relationships to facilitate subsequent warning display; when there are no attribute relationships between different pipeline layout 3D models, the model fusion unit will directly fuse the parameter data of multiple pipeline layout 3D models to obtain 3D fused parameter data in standard 3D space.

[0058] The 3D modeling unit is used to output a 3D fusion model based on 3D fusion parameter data, enabling one-map management and solving the problem of two maps.

[0059] The system described above standardizes pipeline data from different sources and with different levels of precision, such as trenchless data and blind exploration data, and integrates them into the same 3D scene and shared database to achieve single-map management and solve the problem of having two separate maps.

[0060] In one embodiment, the bidirectional linkage editing module includes a 3D front-end display unit, a listening unit, and a response unit.

[0061] The 3D front-end display unit is used to display the 3D model of the pipeline layout in real time, allowing users to update and adjust specific pipe segments within the 3D model. The 3D front-end display unit can use a JavaScript framework to initialize the 3D scene. It sets the terrain, influences map services, and integrates a user interaction space. The user interaction space can include functions such as zooming, panning, selection, and measurement. The pipeline layout 3D model is built through a back-end service unit. The back-end service unit can use Java or Python frameworks to build the back-end application and configure API interfaces. The back-end service unit associates the API interfaces with the user interaction space, and can handle front-end data requests, business logic, and database operations through the API interfaces.

[0062] The listening unit monitors user adjustments to the pipeline layout 3D model and generates corresponding model update requests. Responding to mouse movement events, the unit listens for drag-to-end events in the 3D scene, reads the coordinates of the dragged primitives in real time, determines the conversion between movement distance and time string based on the drag time, generates the user's adjustment in the pipeline layout 3D model, and generates a corresponding model update request based on the conversion values ​​before and after the adjustment. The backend service unit accepts model update requests through an API interface and executes them within a transaction, updating the database containing the geophysical point table data. After updating the attribute information in the database, the backend service unit can publish an update event, which the 3D frontend display unit subscribes to via a plugin (e.g., a WebSocket plugin). Upon receiving the event, the 3D frontend display unit locates the corresponding 3D model based on its feature ID, calls its update method, and refreshes the model's state, such as position, size, and color.

[0063] The response unit is used to call and update the pipe segment model according to the model update request, and establish a real-time responsive 3D model of the pipeline layout.

[0064] The system allows users to make graphical adjustments to pipeline models directly in a 3D scene, such as moving nodes and modifying their direction, and ensures that any graphical modifications will be synchronously updated to the underlying attribute database in real time.

[0065] In one embodiment, the intelligent collision detection module includes a model analysis unit and a risk rendering unit.

[0066] The model analysis unit is used to analyze the vertical intersection risk and horizontal collision risk of underground pipelines in different 3D pipeline layout models, obtaining risk assessment results. The model analysis unit utilizes spatial geometric algorithms to automatically detect collision risks such as intersections and excessively close spacing between different pipeline models in 3D space. Spatial geometric algorithms are computational methods for representing, manipulating, and solving 3D spatial geometric problems in computers. Their core objective is to accurately handle the position, shape, and interrelationships of geometric objects such as points, lines, surfaces, and volumes in space.

[0067] To achieve the safe and efficient generation of urban underground pipeline models, this embodiment employs spatial geometric algorithms to systematically analyze the horizontal and vertical spacing of underground pipelines. Specifically, horizontal and vertical spacing values ​​are extracted based on pipeline layout density and burial depth data. Pipelines are then classified, and horizontal and vertical safety spacing thresholds are generated and verified to meet safety requirements. Non-compliant sections are identified by comparing actual spacing with safety thresholds. For sections that do not meet safety spacing requirements, pipeline coordinates are extracted, and a recursive optimization algorithm is applied to calculate position adjustments. Optimized spacing parameters are generated by combining space utilization constraints. The pipeline coordinates for non-compliant sections are extracted from the database containing geophysical point data. The recursive optimization algorithm iteratively adjusts pipeline positions in 0.1-meter increments, stopping when the difference between adjacent iterations falls below 0.05 meters. The optimization process is constrained by underground space utilization rates; for example, the upper limit for utilization in urban built-up areas is 85%, and in green areas, it is 60%. After adjustment, the horizontal spacing increment is typically between 0.2 and 0.6 meters, ensuring safety while avoiding excessive space occupation. Optimize the parameter recording adjustment amount and corresponding coordinates to facilitate subsequent verification and implementation. In one embodiment, the model analysis unit can output non-compliant sections as risk assessment results; the model analysis unit can also output non-compliant sections, parameter recording adjustment amounts, and corresponding coordinates as risk assessment results.

[0068] The risk rendering unit is used to render and annotate the risk coordinates in the 3D model of the pipeline layout based on the risk assessment results, and then feeds the results back to the two-way collaborative editing module for display. The risk rendering unit can provide a collision report generation interface, generating a PDF or Excel document listing all collision points with a single click.

[0069] The aforementioned system, through a combination of spatial geometric algorithms and recursive optimization, can accurately verify and adjust the horizontal spacing of pipelines to meet safety regulations.

[0070] In one embodiment, the output module includes a test unit and a model output unit.

[0071] The testing unit is used to stress test pipeline data in the 3D fusion model. It performs stress tests on large-scale pipeline data scenarios. The testing unit can optimize spatial database query statements and employ LOD and chunked loading techniques for the 3D scene to ensure smooth system operation.

[0072] The model output unit is used to output the tested 3D fusion model as a drawing file in a specified format according to predetermined rules.

[0073] Each module in the aforementioned multi-source fusion system for underground pipeline geophysical data can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the computer device's memory as software, so that the processor can call and execute the corresponding operations of each module.

[0074] In one embodiment, such as Figure 3 As shown, a multi-source fusion method for underground pipeline geophysical data includes the following steps: Step 201: Obtain geophysical point table data in different formats from different sources. The geophysical point table data includes the three-dimensional coordinates and burial depth data corresponding to the underground pipelines at each geophysical point location. Step 202: Map geophysical point data in different formats to the corresponding three-dimensional space, and construct a three-dimensional model of the underground pipeline layout in different three-dimensional spaces; Step 203: Display the 3D model of the pipeline layout so as to receive user modifications to the underground pipelines in the 3D model of the pipeline layout and adjust the 3D model of the pipeline layout in real time. Step 204: Unify and map the 3D model of pipeline layout from geophysical point data from different sources into a standard 3D space to generate a 3D fusion model; Step 205: Using spatial geometry algorithms, detect the collision risk between different pipeline layout 3D models in the 3D fusion model and generate real-time visual early warning information. Step 206: Output the 3D fusion model as a drawing file in a specified format according to the predetermined rules.

[0075] For specific limitations on the multi-source fusion method for underground pipeline geophysical exploration data, please refer to the limitations on the multi-source fusion system for underground pipeline geophysical exploration data mentioned above, which will not be repeated here.

[0076] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 3As shown, the computer device includes a processor, memory, network interface, and database connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and database. The internal memory provides the environment for the operation of the operating system and computer programs in the non-volatile storage media. The database stores data such as geophysical point tables. The network interface is used for communication with external terminals via a network connection. When the computer program is executed by the processor, it implements a multi-source fusion method for underground pipeline geophysical data.

[0077] In one embodiment, a computer device is provided, including a memory and a processor. The memory stores a computer program, and the processor executes the computer program to perform the following steps: acquiring geophysical point table data of different formats from different sources, the geophysical point table data containing three-dimensional coordinates and burial depth data corresponding to underground pipelines at various geophysical point locations; mapping the geophysical point table data of different formats to corresponding three-dimensional spaces and constructing three-dimensional models of underground pipeline layout in different three-dimensional spaces; displaying the three-dimensional model of pipeline layout to receive user modifications to the underground pipelines in the three-dimensional model of pipeline layout and to adjust the three-dimensional model of pipeline layout in real time; uniformly fusing and mapping the three-dimensional models of pipeline layout from geophysical point table data of different sources to a standard three-dimensional space to generate a three-dimensional fused model; detecting collision risks between different three-dimensional models of pipeline layout in the three-dimensional fused model through spatial geometric algorithms and generating visual early warning information in real time; and outputting the three-dimensional fused model as a drawing file of a specified format according to predetermined rules.

[0078] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When executed by a processor, the computer program performs the following steps: acquiring geophysical point table data of different formats from different sources, the geophysical point table data containing three-dimensional coordinates and burial depth data corresponding to underground pipelines at various geophysical point locations; mapping the geophysical point table data of different formats to corresponding three-dimensional spaces and constructing three-dimensional models of underground pipeline layout in different three-dimensional spaces; displaying the three-dimensional model of pipeline layout to receive user modifications to the underground pipelines in the three-dimensional model of pipeline layout and to adjust the three-dimensional model of pipeline layout in real time; uniformly fusing and mapping the three-dimensional models of pipeline layout from geophysical point table data of different sources to a standard three-dimensional space to generate a three-dimensional fused model; detecting collision risks between different three-dimensional models of pipeline layout in the three-dimensional fused model through spatial geometric algorithms and generating visual early warning information in real time; and outputting the three-dimensional fused model as a drawing file of a specified format according to predetermined rules.

[0079] The above description is merely a specific embodiment of this application, but the scope of protection of this application is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application.

Claims

1. A multi-source fusion system for geophysical exploration data of underground pipelines, characterized in that, include: The data integration module is used to acquire geophysical point table data in different formats from different sources. The geophysical point table data includes the three-dimensional coordinates and burial depth data corresponding to the underground pipelines in the geophysical point locations. The three-dimensional model generation module is used to map the geophysical point table data in different formats to the corresponding three-dimensional space and construct the three-dimensional model of the underground pipeline layout in different three-dimensional spaces. The two-way linkage editing module is used to display the three-dimensional model of the pipeline layout so as to receive user modifications to the underground pipelines in the three-dimensional model of the pipeline layout and to adjust the three-dimensional model of the pipeline layout in real time. The multi-source data fusion processing module is used to uniformly fuse and map the 3D model of pipeline layout from geophysical point table data from different sources into a standard 3D space to generate a 3D fusion model. The intelligent collision detection module is used to detect the collision risk between different pipeline layout 3D models in the 3D fusion model through spatial geometry algorithms, and generate visual early warning information in real time. The output module is used to output the 3D fusion model as a drawing file in a specified format according to predetermined rules.

2. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 1, characterized in that, The 3D model generation module includes: The pipeline analysis unit is used to perform statistical analysis and processing on the geophysical point table data to obtain the types of each pipe segment that make up the underground pipeline and the corresponding parameter dimensions. The pipe segment model generation unit is used to generate pipe segment models corresponding to each pipe segment type based on the parameter dimensions. The model building unit is used to build three-dimensional models of the underground pipeline layout in different three-dimensional spaces using the three-dimensional coordinates and the burial depth data.

3. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 2, characterized in that, The 3D model generation module also includes: The pipe segment type creation unit is used to create various manhole covers, valves, and pipe fitting templates that make up the corresponding underground pipelines for different formats; The configuration mapping unit is used to map and store the pipe segment model and its corresponding format through a configuration file.

4. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 1, characterized in that, The multi-source data fusion processing module includes: The coordinate system transformation unit is used to transform the parameter data of geophysical point table data from different sources according to the coordinate system, so as to map multiple pipeline layout 3D models to a target coordinate system. The mapping unit is used to match the converted geophysical point table data with the spatial location of underground pipelines, so as to map multiple pipeline layout 3D models to the standard 3D space where the target coordinate system is located. The conflict detection unit is used to detect and determine whether there are attribute relationships between different pipeline layout 3D models in the standard 3D space. The model fusion unit is used to fuse the parameter data of the multiple pipeline layout three-dimensional models to obtain three-dimensional fused parameter data in the standard three-dimensional space. A 3D modeling unit is used to output a 3D fusion model based on the 3D fusion parameter data.

5. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 1, characterized in that, The bidirectional linkage editing module includes: A three-dimensional front-end display unit is used to display the three-dimensional model of the pipeline layout in real time, so that users can update and adjust a certain pipe segment model in the three-dimensional model of the pipeline layout. The monitoring unit is used to monitor the user's adjustments to the pipeline layout 3D model and generate corresponding model update requests. The response unit is used to call and update the pipe segment model according to the model update request, and establish a real-time responsive three-dimensional model of the pipeline layout.

6. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 1, characterized in that, The intelligent collision detection module includes: The model analysis unit is used to analyze the vertical intersection risk and horizontal collision risk of the underground pipeline in different pipeline layout three-dimensional models through the pipeline layout three-dimensional model, and obtain the risk assessment results; The risk rendering unit is used to render and annotate the risk coordinates in the three-dimensional model of the pipeline layout based on the risk assessment results, and then feed them back to the bidirectional linkage editing module for display.

7. The multi-source fusion system for underground pipeline geophysical exploration data according to claim 1, characterized in that, The output module includes: The testing unit is used to perform stress tests on the pipeline data in the three-dimensional fusion model; The model output unit is used to output the tested 3D fusion model as a drawing file in a specified format according to predetermined rules.

8. A method for multi-source fusion of geophysical data for underground pipelines, characterized in that, The method includes: Obtain geophysical point table data in different formats from different sources. The geophysical point table data includes the three-dimensional coordinates and burial depth data corresponding to the underground pipelines at each geophysical point location. The geophysical point data in different formats are mapped to the corresponding three-dimensional space, and a three-dimensional model of the underground pipeline layout in different three-dimensional spaces is constructed. The system displays a 3D model of the pipeline layout to receive user modifications to the underground pipelines in the 3D model and to adjust the 3D model of the pipeline layout in real time. The pipeline layout 3D model from geophysical point data from different sources is uniformly fused and mapped into a standard 3D space to generate a 3D fusion model; Using spatial geometry algorithms, the collision risk between different pipeline layout 3D models in the 3D fusion model is detected, and visual early warning information is generated in real time. The 3D fusion model is output as a drawing file in a specified format according to predetermined rules.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method of claim 8.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the method of claim 8.

Images