Method for bidirectional data fusion and one-well-one-code asset archiving of multi-source heterogeneous municipal drainage platforms

By integrating data from a multi-source heterogeneous municipal drainage platform and using a one-well-one-code asset filing method, the problems of fragmented pipeline systems and dirty data processing have been solved. This has enabled automated management and full lifecycle traceability of pipeline assets, improved update efficiency and standardized risk assessment, and made the system suitable for third-party supervision scenarios in government procurement.

CN123115249APending Publication Date: 2026-11-17江苏仝创达信息科技有限公司
View PDF 12 Cites 0 Cited by

Patent Information

Application Number
CN202611197406.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2026-08-07
Publication Date
2026-11-17

AI Technical Summary

Technical Problem

The existing pipeline asset management system suffers from problems such as fragmented multi-source systems, one-way data reading, manual processing of dirty data, lack of standardized and unique asset codes, manual assessment of pipeline risks, inconvenience in on-site asset viewing and updating, and is only suitable for internal enterprise management, making it unsuitable for third-party digital supervision scenarios in government procurement.

Method used

A multi-source heterogeneous municipal drainage platform is adopted to achieve bidirectional data fusion and a one-well-one-code asset filing method. By automatically cleaning the dirty data of the pipeline topology, a globally unique code is generated, an incremental bidirectional data synchronization interface is built, and risk points are determined by combining the pipeline plane distance calculation formula. It supports offline scanning of codes on mobile devices to view and update asset information.

Benefits of technology

It achieves standardized governance and full lifecycle traceability of pipeline assets, reduces manual workload by 85%, improves ledger update efficiency by 80%, unifies pipeline risk assessment standards, supports multiple deployment architectures, and is adaptable to third-party supervision projects of different sizes.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN123115249A_ABST
    Figure CN123115249A_ABST
Patent Text Reader

Abstract

This invention discloses a method for bidirectional data fusion and one-well-one-code asset archiving of a multi-source heterogeneous municipal drainage platform, belonging to the technical fields of multi-source data governance and pipeline asset management in municipal water affairs. The steps include: full data access of multiple types of existing drainage systems; automated cleaning of dirty pipeline topology data and unification of asset fields; generation of a unique one-well-one-code across the entire domain through a segmented coding formula and binding it to a full lifecycle archive; establishment of an incremental bidirectional synchronization interface for incremental transmission of changed asset data back to the government's existing platform; quantitative identification of high-risk pipeline collision sections based on pipeline planar distance calculation formula; and mobile terminal support for offline scanning and archiving, online on-site updates, and bidirectional data synchronization. This invention is specifically designed for third-party digital supervision scenarios in government procurement, addressing the shortcomings of existing solutions such as data silos across multiple systems, one-way data retrieval, manual data cleaning, lack of standardized asset coding, manual assessment of pipeline risks, and inconvenience in on-site asset updates. It is equipped with a complete mathematical calculation model, compatible with both private and cloud-based SaaS deployments, significantly reducing the cost of manual management of pipeline asset ledgers and achieving precise traceability and control of pipeline facilities throughout their entire lifecycle.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention belongs to the field of municipal multi-source water affairs data governance and pipeline asset management technology, and is suitable for the standardized management and control of pipeline assets in government procurement third-party digital supervision services. Background Technology

[0002] Existing publicly available invention patents related to pipeline network assets and multi-source data governance include CN120297544A, CN116485606A, CN111798007A, CN115564068A, CN102915474A, CN119338140A, CN117540897A, CN120258780A, CN119624148A, CN119067466A, CN120931067A, and CN120448440A. All prior patents are internal operation and maintenance designs for water utilities and cannot be adapted to government procurement of third-party digital monitoring services, exhibiting several inherent defects: 1. Existing GIS, operation and maintenance ledgers, and SCADA monitoring systems are independent of each other, forming data silos; CN120448440A 1. Only supports one-way reading of existing system data, and cannot reverse write back to update asset archives; CN120931067A lacks cross-system data integration capabilities; 2. Existing pipeline network data contains topologically dirty data such as duplicate pipelines, coordinate offsets, and suspended pipelines. The existing solution lacks an automated cleaning process and can only rely on manual correction of each pipeline, resulting in a huge workload; 3. There is a lack of standardized segmented coding and quantification models. Only simple pipeline numbers are set or there are no asset codes, making it difficult to trace the entire life cycle of pipeline nodes; 4. There is no standardized formula for quantifying pipeline planar distances. Pipeline collision and burst risk points rely entirely on manual investigation, and the judgment standards are inconsistent; 5. It does not support offline scanning of asset archives on mobile devices or on-site synchronous updates of asset data, making it very inconvenient to view pipeline network data in underground and outdoor maintenance sites; 6. All technical solutions are only adapted to internal enterprise management, do not distinguish between the asset viewing permissions of the regulatory end and maintenance units, and are not compatible with both private and cloud SaaS deployment architectures. Summary of the Invention

[0003] (1) Technical problems to be solved To address the shortcomings of existing pipeline network data governance solutions, such as fragmented multi-source systems, one-way data reading only, manual processing of dirty data, lack of standardized and unique asset codes, manual assessment of pipeline network risks, inconvenience in on-site asset retrieval and updates, and applicability only to enterprise self-use, this paper provides a method for bidirectional data fusion and one-well-one-code asset archiving of multi-source heterogeneous municipal drainage platforms. This enables standardized, automated governance and full life-cycle traceability management of pipeline network assets in government procurement and third-party supervision scenarios.

[0004] (2) Technical solution A method for bidirectional data fusion and one-well-one-code asset archiving of a multi-source heterogeneous municipal drainage platform includes the following steps: S1. Connecting with various existing drainage business systems such as GIS geographic information systems, pipeline network operation and maintenance ledgers, and pipeline network SCADA monitoring systems, compatible with MySQL and Oracle databases, adapting to various coordinate formats and differentiated field naming specifications, completing the unified access of all original pipeline network asset data, and opening up data channels between multiple systems; S2. Automating the cleaning of dirty pipeline network topology data, automatically identifying and filtering topology anomalies such as duplicate pipelines, coordinate offsets, and unassigned suspended pipelines; unifying the standards for all key asset fields such as pipe materials, pipe diameters, manholes, maintenance records, and hidden danger ledgers, and establishing a unified pipeline network asset data caliber; S3. Generating a globally unique one-well-one-code using a segmented coding calculation formula, the coding calculation formula is as follows: Parameter explanation: The numerical code representing the area ranges from 1 to 99. The code represents the facility type: 1 corresponds to a manhole, 2 corresponds to a rainwater inlet, and 3 corresponds to a pipeline node. This represents the auto-incrementing serial number of similar facilities within the area, with a value range of 1 to 999. A globally unique digital code is generated; this unique code is bound to the pipe material, pipe age, maintenance records, and full lifecycle asset archive of potential defects, and a corresponding QR code is generated; S4, an incremental two-way data synchronization interface is established, pushing only the asset data added or modified during the operation and maintenance process to the government's existing drainage platform, and the synchronization process will not overwrite the original historical pipe network data of the existing platform; the interface realizes two-way real-time data transmission, ensuring that the pipe network asset ledger of the existing platform and this system are consistent in real time; S5, based on the standardized cleaned pipe network topology coordinate data, the straight-line distance between the endpoints of two pipes is quantitatively calculated using the pipe plane distance calculation formula: Pipe plane distance calculation formula: Parameter explanation: , The coordinates of the endpoints of the two pipelines are in the plane. The straight-line plane distance of the pipeline; the system presets a fixed pipeline safety threshold. If the calculated \ If the location is determined to be a high-risk location for pipeline collision, the high-risk locations are further screened based on the pipeline age information, and a batch of pipeline burst risk lists are generated. S6: The mobile terminal has a built-in local offline cache database. In the absence of a network signal, the basic asset files of the pipeline network can be retrieved by scanning the facility's QR code. When connected to the network, staff can modify asset parameters on-site. The modified asset data is bidirectionally synchronized to the government's existing drainage platform and the local business database, forming a closed loop for asset data updates.

[0005] The entire set of data cleaning, encoding generation, risk assessment, two-way synchronization, and mobile scanning update business logic can be fully reused in both private local server deployment and cloud SaaS multi-tenant deployment architectures, adapting to the implementation of various regional government procurement third-party digital supervision projects.

[0006] (3) Beneficial effects

[0007] 1. Compatible with various heterogeneous business systems such as GIS, operation and maintenance ledgers, and SCADA, coupled with an automated dirty data cleaning process, unifying the field standards for all pipeline assets, reducing the workload of manual ledger organization by 85%; 2. Adopting an incremental two-way synchronization mechanism, only synchronizing changed data without overwriting the government's existing original pipeline archives, solving the problem of inconsistencies between government and enterprise ledgers caused by traditional one-way data retrieval, improving the efficiency of pipeline asset ledger updates by more than 80%; 3. Equipped with standardized segmented coding calculation formulas, assigning unique codes to all pipeline facilities across the entire region, binding complete full lifecycle archives, and achieving accurate traceability of any pipeline node; 4. Built-in quantitative calculation formula for pipeline planar distance, unifying the standards for determining pipeline collision and burst risk, replacing manual subjective inspection with quantitative calculation, identifying high-risk pipeline sections in advance, and reducing operation and maintenance safety hazards; 5. Mobile terminals support offline scanning and document retrieval, and online on-site updates of asset information, adapting to underground and outdoor maintenance on-site operation scenarios, making asset data retrieval and updates convenient; 6. The same set of business logic is compatible with both private and cloud-based SaaS deployment architectures, adapting to third-party supervision projects of different sizes in urban and rural areas; 7. The instruction manual fully discloses two sets of mathematical calculation formulas for code generation and pipeline distance determination. The technical solutions are fully disclosed, and ordinary technicians in this field can completely reproduce the entire asset filing and data governance process. Attached Figure Description

[0008] Figure 1 This is a diagram of the overall architecture of multi-source data fusion in this invention, showing the complete data link of multi-system data input, data fusion processing, and bidirectional synchronous output; Figure 2 This is a flowchart of the one-code-per-well-one-file and mobile scanning business process of the present invention, showing the full business process of code generation, QR code binding, offline viewing, on-site modification, and two-way synchronization. Figure 3 This diagram illustrates the comparison between the old and new systems for data exchange, visually demonstrating the efficiency difference between the traditional one-way data retrieval scheme and the incremental two-way synchronization scheme of this invention. Detailed Implementation

[0009] This method was implemented in a scenario involving third-party pipeline asset supervision procured by the urban government: Step 1: Connect with the existing GIS drainage platform, offline pipeline maintenance ledger, and pipeline SCADA online monitoring system in the area. The system automatically adapts to the existing Oracle database and reads all original asset data for pipelines, manholes, and storm drains. Step 2: The automated cleaning module identifies and filters duplicate pipeline entries, misaligned manholes, and unassigned suspended branch pipes, unifying the format of pipe diameter, pipe material, burial years, and hidden danger record fields in all asset ledgers. Step 3: Input the area code, facility type, and auto-incrementing serial number. Generate a globally unique numerical code using a segmented coding formula. Generate a corresponding QR code for each manhole and bind it to the complete archive of maintenance, defects, and inspections over the years. Step 4: The project adopts a cloud-based SaaS deployment architecture. After maintenance personnel update pipeline defect records on-site, the system only pushes the incremental changes to the existing government GIS platform, ensuring that the platform's original historical pipeline data is completely preserved and not overwritten. Step 5: The system retrieves the plane coordinates of all pipelines, substitutes them into the pipeline distance calculation formula to calculate the pipeline spacing in batches, compares it with the preset safety threshold, automatically marks the collision points where pipelines are too close, and filters old and high-risk pipeline sections based on pipeline age, outputting a monthly pipeline network risk disposal list; Step 6: When maintenance personnel enter the well for work in an environment without network access, they can view the basic asset data of the well through offline caching on their mobile devices; after returning to the office area and connecting to the network, they can modify the well chamber defect information, and the modified content is synchronously updated to the government's existing platform and the local business database.

[0010] Practical implementation verification: Traditional manual cleaning, data entry, and verification of pipeline network ledgers consume a large amount of manpower hours every month. After adopting this solution, most of the processes are automated. Traditional solutions only read existing data from the system in one direction and repeatedly enter ledgers. The incremental two-way synchronous mode of this invention improves the efficiency of pipeline network asset ledger updates by more than 80%.

Claims

1. A multi-source heterogeneous municipal drainage platform bidirectional data fusion and one-well one-code asset filing method, characterized in that, Includes the following steps: S1. Connects to multiple existing drainage business systems, is compatible with different types of databases and differentiated field specifications, and completes unified access to all original pipeline network asset data; S2: Automated cleaning of dirty data in pipeline network topology, automatic filtering of abnormal data such as duplicate pipelines, coordinate offsets, and unassigned suspended pipelines, and standardization of key fields of pipeline network assets across the entire platform; S3. A segmented coding logic is used to generate a globally unique code for each well. Each inspection well and pipeline node is bound to a complete full life cycle asset file and a corresponding QR code is generated. S4. Establish an incremental two-way data synchronization interface. During the operation and maintenance process, newly added or modified asset data is only pushed incrementally to the government's existing drainage platform. The synchronization process does not cover the original historical pipeline data of the existing platform. S5. Based on the standardized cleaned pipeline topology coordinate data, quantitatively calculate the pipeline plane spacing, automatically identify pipeline collision points, and batch mark high-risk sections of pipeline bursts. S6. Mobile devices can be configured with an offline cache database, allowing users to scan a code to retrieve basic asset files of the pipeline network even in environments without a network connection. When asset parameters are modified on-site while connected to the internet, the changes are synchronized bidirectionally to the government's existing platform and the local business database.

2. The multi-source heterogeneous municipal drainage platform bidirectional data fusion and one-well one-code asset filing method according to claim 1, characterized in that, The complete business logic for multi-source data cleaning, encoding generation, risk assessment, two-way synchronization, and mobile terminal QR code scanning updates can be fully reused in both private local server deployment and cloud-based SaaS multi-tenant deployment architectures.

3. The method of claim 1, wherein the method is a two-way data fusion and one-well one-code asset filing method for a multi-source heterogeneous municipal drainage platform. The existing drainage business system connected in step S1 includes a GIS geographic information system, a pipeline operation and maintenance ledger system, and a pipeline SCADA monitoring system, and is compatible with mainstream databases such as MySQL and Oracle.

4. The method of claim 1, wherein the method is a two-way data fusion and one-well one-code asset filing method for a multi-source heterogeneous municipal drainage platform. In step S5, the system presets a pipeline safety distance threshold, compares the calculated pipeline plane spacing with the threshold, and determines the pipeline collision high-risk point if the spacing is less than the threshold. The pipeline age information is then combined to generate a pipeline network risk list through secondary screening.

5. The method of claim 1, wherein the method is a two-way data fusion and one-well one-code asset filing method of a multi-source heterogeneous municipal drainage platform. The unique code generated in step S3 contains three segments of information: area identifier, facility type identifier, and auto-incrementing serial number of facilities within the area. All pipeline facility codes in the entire region are unique, supporting the full lifecycle traceability query of pipeline nodes.

Citation Information

Patent Citations

  • Municipal drainage network maintenance management method

    CN102915474A

  • Intelligent informatization system for drainage pipe network

    CN111798007A

  • Supervision method and system for inspection and maintenance of drainage pipe network and facilities, and storage medium

    CN115564068A

  • Intelligent water affair management platform for drainage households, pipe networks, pump stations, sewage plants and river channels

    CN116485606A

  • Sewage pipeline operation and maintenance supervision system and supervision method thereof

    CN117540897A