Pipeline relocation and relocation management method and system based on BIM (Building Information Modeling)

Abstract

The invention belongs to the technical field of data management, and particularly relates to a BIM-based pipeline migration and modification management method and system, and the method comprises the following steps: S1) building a BIM model based on a as-built drawing; s2) creating a three-dimensional live-action model; s3) the BIM model takes an IFC format as a carrier; the GIS model takes a GML format as a carrier; realizing conversion and fusion between two different standard formats of IFC and GML by adopting a semantic mapping method; and S4) managing the fused GML model according to layers. According to the method, data fusion of the BIM model and the GIS model is realized by utilizing a semantic mapping method, a data island is broken, a uniform data basis is constructed, data redundancy and inconsistency are avoided, and the data management efficiency is greatly improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of data management, and specifically, relates to a method and system for pipeline relocation management based on BIM. Background Art

[0002] Municipal engineering pipelines include electricity, gas, water supply, drainage, communication, heating, etc. There are many pipeline specialties and complex and diverse pipeline models. During the relocation process, it is carried out based on the original demolition pipeline completion drawings and the geophysical exploration data obtained during the survey stage. The types and quantities of the expropriated and demolished pipelines are counted through paper / electronic forms. There are also some units that use BIM models for relocation management according to the geophysical exploration results and drawings. However, there is a lack of comprehensive and accurate understanding of the underground pipelines and their surrounding environments.

[0003] For example: The lack of an effective BIM and GIS data fusion method results in the difficulty of integrating and analyzing pipeline data and obstacle real scenes, and it is impossible to perform construction simulation and visualization management.

[0004] In addition, existing pipeline management systems usually lack effective management of pipeline topological relationships and spatial analysis functions, such as connectivity analysis and shortest path analysis of pipe points; this limits the optimization of pipeline relocation plans and decision-making support. Summary of the Invention

[0005] To solve the technical problems in the prior art, namely the lack of an effective BIM and GIS data fusion method; and the lack of effective management of pipeline topological relationships and spatial analysis functions, the present invention provides a method and system for pipeline relocation management based on BIM.

[0006] The object of the present invention can be achieved by the following technical solutions:

[0007] A method for pipeline relocation management based on BIM includes the following steps:

[0008] S1) Create a BIM model based on the completion drawings;

[0009] Preferably, the specific implementation process of step S1) includes:

[0010] S1.1) Collect relevant completion drawings and perform digital processing to extract the geometric data and attribute data of the pipelines in the completion drawings; the geometric data of the pipelines includes pipe diameters and pipe point coordinates; the attribute data of the pipelines includes material, burial depth, and positioning information;

[0011] S1.2) Clean the data to remove error and redundant information; then perform standardization processing to unify the position coordinate system, unit, and attribute naming;

[0012] S1.3) Based on the processed data, generate a 3D BIM model of the pipeline according to the geometric data and attribute data of the pipeline;

[0013] Preferably, in step S1.3), the specific implementation process of generating a 3D BIM model of the pipeline according to the geometric data and attribute data of the pipeline includes:

[0014] Abstract the pipeline structure as a line object and record its starting and ending coordinates;

[0015] Abstract the pipe point structure as a point object and record its coordinates and type; the pipe point structure includes valves, access points, and branch points;

[0016] Use an adjacency matrix to define the topological structure of the pipe network and describe the connection relationship between the pipeline structure and the pipe point structure;

[0017] According to the diameter of the pipeline, use the cylinder algorithm for 3D modeling; and preset 3D models for different types of pipe point structures;

[0018] Calculate the rotation angle and scaling ratio of the pipe points according to the connection situation of the pipeline to ensure the correct connection between the pipe points and the pipeline;

[0019] Export the constructed 3D BIM model in IFC format for viewing and use in other software platforms.

[0020] S2) Creation of 3D real-scene model:

[0021] S2.1) Collect the real scenes of the above-ground obstacles related to the pipeline, including building, road, and vegetation information;

[0022] S2.2) Use GIS software to classify and model the above-ground obstacle real scenes to generate a 3D GIS model and mark the attribute IDs of the obstacle real scenes;

[0023] S3) Model data conversion and fusion:

[0024] The BIM model is carried by the IFC format; the GIS model is carried by the GML format; adopt the method of semantic mapping to realize the conversion and fusion between the two different standard formats of IFC and GML;

[0025] Preferably, in step S3), the specific process of adopting the method of semantic mapping to realize the conversion and fusion between the two different standard formats of IFC and GML includes:

[0026] S3.1) Analyze the geometric data and attribute data of the IFC format model;

[0027] S3.2) Based on the semantic mapping rules, perform classification mapping on the geometric data and attribute data in the IFC format model and the GML format model;

[0028] S3.3) Perform coordinate transformation to convert the local coordinate system of the IFC format model into the world coordinate system of the GML format model;

[0029] S3.4) Perform model representation transformation to convert the swept volume representation method of the IFC format model into the boundary representation method of the GML format model. In this way, a multi-level GML model is generated by fusion.

[0030] S4) Create a pipeline relocation management environment:

[0031] Manage the fused GML model by layers;

[0032] Display model data with different attributes by controlling the classification of layers. Locate the model with specific attributes through attribute query and filtering;

[0033] Use different colors to represent different construction areas; control the display of different construction states through a time slider.

[0034] Preferably, in step S4), the specific implementation process of managing the fused GML model by layers includes:

[0035] The layers of the GML format model are divided into a basic model layer and a relocation management layer;

[0036] The secondary layers of the basic model layer are divided into an above-ground obstacle layer and a pipeline project layer; the secondary layers of the relocation management layer are divided into a pipeline relocation project layer and a progress management layer;

[0037] The tertiary layers of the pipeline relocation project layer are divided into a demolished pipeline layer and a newly built pipeline layer; the progress management layer is divided into different construction areas and construction states;

[0038] The construction areas are divided into an above-ground obstacle relocation area and an underground pipeline relocation area; the construction states are divided into not started, in progress, completed, and delayed states.

[0039] Preferably, it further includes S5) Data management: Use the PostgreSQL database and its PostGIS extension for spatial data storage and management;

[0040] Preferably, the specific implementation process of step S5) data management includes:

[0041] Select PostgreSQL as the relational database to store and manage various information data of the pipeline system, including geometric data, attribute data, and topological relationship data of the pipeline;

[0042] Use the PostGIS extension tool of the PostgreSQL database to store geometric data and attribute data together in a data table, which includes a pipeline table and a pipe point table;

[0043] The pipeline table is used to store the ID of each pipeline segment, the ID of the starting pipe point, the ID of the ending pipe point, and geometric data; the pipe point table is used to store the ID, coordinates, and other attributes of each pipe point;

[0044] Use an adjacency matrix to represent the topological relationship between pipe points in the pipeline. The elements in the matrix indicate whether there is a direct connection between two pipe points and the length of the connection.

[0045] Preferably, it further includes step S6): Use the minimum path algorithm to find the shortest path between two pipe points, providing decision support for the relocation and planning of pipelines. The specific implementation process includes:

[0046] S6.1) Create a distance array based on the adjacency matrix to store the shortest distance from the starting node to each other node. Initialize the distance of the starting node to 0, and the distances of other nodes to infinity;

[0047] S6.2) Create an access flag array based on the adjacency matrix to record which nodes have been visited, and initialize all nodes to 'unvisited';

[0048] S6.3) Select the node with the shortest distance from the starting node among all 'unvisited' nodes;

[0049] S6.4) Mark the selected node as 'visited';

[0050] S6.5) Update the distances of its adjacent nodes. If the distance to an adjacent node through the current node is shorter than the currently recorded distance, update the shortest distance;

[0051] S6.6) Repeat steps S6.3 - 6.5) until all nodes are visited or the target node is found;

[0052] S6.7) After obtaining the shortest distance, record the predecessor node of each node according to the algorithm, and backtrack these predecessor nodes to find the complete shortest path.

[0053] Preferably, step S6) further includes: Using the depth - first search (DFS) algorithm to traverse the adjacency matrix to verify the connectivity of the topological relationship and whether there are isolated pipe points. The specific implementation process includes:

[0054] Select a starting node from the pipe points as the starting point of DFS and mark the starting node as 'visited';

[0055] Traverse the adjacent nodes of the starting node;

[0056] After the DFS traversal is completed, check whether all nodes are marked as 'visited'.

[0057] If all nodes are visited, it means that each pipeline point is connected, that is, starting from any node, all other nodes can be reached.

[0058] If there are unvisited nodes, it means that there are isolated pipeline points.

[0059] Further analyze and process the isolated pipeline points.

[0060] The present invention also provides a system for a pipeline relocation management method based on BIM, including: a GIS platform, a memory, and a processor;

[0061] The GIS platform is used to construct a fused GML model, and the GIS platform has functions of layer management, attribute query, spatial analysis, and visualization;

[0062] The memory is used to construct a PostgreSQL database to store and manage various data of the GML model;

[0063] The processor is used to execute spatial analysis functions; including connectivity analysis based on the depth-first search (DFS) algorithm, and shortest path analysis for finding the shortest path between two pipeline points based on the shortest path algorithm.

[0064] Advantages of the present invention:

[0065] 1. The semantic mapping method is used to realize the fusion of BIM model and GIS model data, break the data silos, construct a unified data foundation, avoid data redundancy and inconsistency, and greatly improve the data management efficiency.

[0066] 2. Through the collaborative work of the PostgreSQL database and the PostGIS extension tool, the effective management and analysis of the spatial data and topological relationship of the underground pipe network are realized, which provides strong data support for the modeling, visualization, and management of the underground pipe network.

[0067] 3. The pipeline spatial analysis function based on the database integrates the connectivity analysis and shortest path analysis of pipeline points, providing decision-making support for pipeline relocation and planning. Description of the Drawings

[0068] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following will briefly introduce the drawings required for the description of the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.

[0069] Figure 1 This is a flowchart of the steps of a BIM-based pipeline relocation management method of the present invention.

[0070] Figure 2 This is a flowchart of data management in step S5) of a BIM-based pipeline relocation management method of the present invention. Specific embodiments

[0071] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0072] Please refer to Figure 1 - Figure 2 As shown, a BIM-based pipeline relocation management method includes the following steps:

[0073] S1) Create a BIM model based on the as-built drawings;

[0074] Further, the specific implementation process of step S1) includes:

[0075] S1.1) Collect relevant as-built drawings and perform digital processing to extract the geometric data and attribute data of the pipelines in the as-built drawings; the geometric data of the pipelines includes pipe diameter and pipe point coordinates; the attribute data of the pipelines includes material, burial depth, and positioning information;

[0076] Among them, for drawing digitization, a high-resolution scanner can be used to scan the paper as-built drawings into electronic versions, or directly obtain electronic drawings in CAD format to ensure the clarity of the drawing information.

[0077] S1.2) Clean the data to remove errors and redundant information; for example: duplicate pipelines or pipe points, inconsistent attribute data, and missing data.

[0078] Then perform standardization processing to unify the position coordinate system, unit, and attribute naming; among them, convert the coordinates of all component data into a unified coordinate reference system; use WGS84 or local coordinate systems to unify the components of the pipelines, and then form a pipeline BIM model. In unifying the units of all attribute data, the pipe diameter is in millimeters, and the burial depth is in meters. Use a unified attribute name and coding rule, for example: the pipe diameter is named "DN800" (nominal diameter), and the material is named "PVC, PV, etc."; here, refer to industry standards or formulate internal standards.

[0079] S1.3) Based on the processed data, generate a 3D BIM model of the pipeline according to the geometric data and attribute data of the pipeline;

[0080] Specifically, step S1) creates a BIM model based on the as-built drawings through data extraction, data cleaning and standardization, and finally BIM model construction. In the pipeline relocation project, the as-built drawings in the historical information are the main data source for pipeline modeling, and their accuracy and integrity directly affect the formulation and implementation of subsequent relocation project plans.

[0081] Select a suitable BIM modeling software, such as Revit, etc. Create a 3D model of the pipeline in the BIM software according to the extracted geometric and attribute data. The specific operations include:

[0082] Create the pipeline structure: Create pipe points according to the drawing information, such as elbows, tees, valves, etc. Create the pipeline structure according to the pipe point coordinates and pipe diameters.

[0083] Set the pipeline attributes: Assign the extracted attribute information to the corresponding pipeline objects.

[0084] Check the model: Check the integrity and accuracy of the model to ensure that the model is consistent with the as-built drawings. The final BIM model should contain the accurate geometric shapes, location information, and detailed attribute information of all pipelines, providing a reliable data basis for subsequent pipeline relocation management; finally, export the model in IFC format for convenient data conversion with other software.

[0085] Furthermore, in step S1.3), the specific implementation process of generating a 3D BIM model of the pipeline according to the geometric data and attribute data of the pipeline includes:

[0086] Abstract the pipeline structure as a line object and record its start and end coordinates;

[0087] Abstract the pipe point structure as a point object and record its coordinates and type; the pipe point structure includes valves, access points, and branch points;

[0088] Use an adjacency matrix to define the topological structure of the pipe network and describe the connection relationship between the pipeline structure and the pipe point structure;

[0089] According to the diameter of the pipeline, use the cylinder algorithm for 3D modeling; and preset 3D models for different types of pipe point structures;

[0090] Calculate the rotation angle and scaling ratio of the pipe points according to the connection situation of the pipelines to ensure correct connection between the pipe points and the pipelines;

[0091] Export the constructed 3D BIM model in IFC format for viewing and use in other software platforms.

[0092] S2) 3D Real Scene Model Creation:

[0093] S2.1) Collect the real scenes of above-ground obstacles related to pipelines, including building, road, and vegetation information;

[0094] S2.2) Use GIS software to classify and model the real scenes of above-ground obstacles, generate a 3D GIS model, and mark the attribute IDs of the real scenes of obstacles;

[0095] In the specific implementation process, step S2) is to create a 3D real scene model containing above-ground obstacles, providing a real environment reference for pipeline demolition and new construction. This provides an important reference for evaluating construction feasibility and planning construction routes.

[0096] According to the accuracy requirements and site conditions, select a suitable real scene data collection method, such as photogrammetry: use a drone equipped with a camera for aerial photography to obtain high-resolution image data. Preprocess the obtained image data, including: image stitching: stitch multiple images into a complete orthophoto or panoramic image.

[0097] Point cloud denoising: Remove the noise points in the point cloud data.

[0098] Point cloud classification: Classify the point cloud data into different ground object categories, such as: ground, building, vegetation.

[0099] Then, use GIS software to perform 3D modeling on the preprocessed data. Generate a 3D model from the point cloud data according to different data types. Mark the attribute ID for each obstacle object in the model. The attribute editing function of GIS software can be used and associated with the model. The final 3D GIS model should contain the attribute IDs, accurate geometric shapes, and location information of all relevant above-ground obstacles; export the model in GML data format and be able to establish a spatial association with the BIM model, providing a real environment reference for subsequent pipeline relocation analysis and management.

[0100] S3) Model Data Conversion and Fusion:

[0101] The BIM model uses the IFC format as the carrier; the GIS model uses the GML format as the carrier; adopt the method of semantic mapping to achieve the conversion and fusion between the two different standard formats of IFC and GML;

[0102] Furthermore, the specific steps for adopting the method of semantic mapping to achieve the conversion and fusion between the two different standard formats of IFC and GML in step S3) include:

[0103] S3.1) Analyze the geometric data and attribute data of the IFC format model; the geometric data includes the pipe diameter and pipe point coordinates of the pipeline; the attribute data includes the material, burial depth, and positioning information of the pipeline;

[0104] S3.2) Classify and map the geometric data and attribute data in the IFC format model and the GML format model based on semantic mapping rules;

[0105] In the specific implementation process, according to the predefined mapping rules, classify and screen the components in the IFC format model according to their semantic information. For example, map the "pipeline" element in the IFC format model to the "underground pipeline" in the GML format model; the element includes the geometric data and attribute data of each pipeline.

[0106] S3.3) Perform coordinate transformation to convert the local coordinate system of the IFC format model into the world coordinate system of the GML format model; in the specific implementation process, first clarify the transformation parameters between the two coordinate systems, such as: rotation matrix, translation vector, scaling ratio, etc. The coordinate transformation function in the GIS software or library can be used for transformation.

[0107] S3.4) Perform model expression conversion to convert the swept volume representation method of the IFC format model into the boundary representation method of the GML format model, so as to fuse and generate a multi-level GML model.

[0108] Specifically, through semantic mapping and hierarchical conversion algorithms, create new GML elements according to IFC elements; realize the multi-level expression of the GML model; the final GML model should contain all relevant information of the BIM model and the GIS model, and use a unified coordinate system and data format. This method ensures that when the BIM model data is converted into GIS data, the geometric shape and attribute data can be accurately retained, providing a unified data basis for subsequent pipeline relocation management. In actual operation, the implementation steps and methods should be flexibly adjusted according to the specific project situation and data characteristics.

[0109] S4) Create a pipeline relocation management environment:

[0110] Manage the fused GML model by layers;

[0111] Display the model data with different attributes by controlling the grading of the layers, and quickly locate the model with specific attributes through attribute query and filtering;

[0112] Use different colors to represent different construction areas;

[0113] Control the display of different construction states through the time slider.

[0114] Specifically, the goal of step S4) to create a pipeline relocation management environment is to create an interactive management environment based on the fused GML model, which is convenient for users to view, query, analyze and manage the information of pipeline relocation engineering projects.

[0115] In the specific implementation process, select a GIS platform (such as QGIS or SuperMap) that supports the GML data format and has functions such as layer management, attribute query, spatial analysis, and visualization;

[0116] Create and organize layers according to the following logic: In step S4), the specific implementation process of managing the fused GML model by layer includes:

[0117] The layers of the GML format model are divided into a basic model layer and a relocation management layer;

[0118] The secondary layers of the basic model layer are divided into an above-ground obstacle layer and a pipeline project layer; the secondary layers of the relocation management layer are divided into a pipeline relocation project layer and a progress management layer;

[0119] The tertiary layers of the pipeline relocation project layer are divided into a demolished pipeline layer and a newly built pipeline layer; the progress management layer is divided into different construction areas and construction statuses;

[0120] The construction areas are divided into an above-ground obstacle relocation area and an underground pipeline relocation area; the construction statuses are divided into not started, in progress, completed, and delayed statuses.

[0121] Among them, ensure that all layers contain necessary geometric information and attribute information, such as: pipe diameter, material, construction status, etc. Use different colors to distinguish different construction areas. In addition, an attribute query tool can also be configured to allow users to query and filter pipeline data according to different attribute conditions. For example: query all pipelines with a "construction status" of "in progress".

[0122] A time slider control can also be added to filter and display the construction status at the time point selected according to the time axis. Allow users to view the pipeline status at different time periods and achieve progress visualization. The final pipeline relocation management environment should be an interactive and visual platform that facilitates users to view, query, analyze, and manage pipeline relocation information, and supports progress visualization and spatial analysis.

[0123] Furthermore, it also includes S5) Data management: Use the PostgreSQL database and its PostGIS extension for spatial data storage management;

[0124] Furthermore, the specific implementation process of step S5) data management includes:

[0125] Select PostgreSQL as the relational database to store and manage various information data of the pipeline system, including the geometric data, attribute data, and topological relationship data of the pipelines;

[0126] Among them, the PostGIS extension tool of the PostgreSQL database is used to store geometric data and attribute data together in a data table, and the data table includes a pipeline table and a pipe point table;

[0127] The pipeline table is used to store the ID of each pipeline segment, the ID of the starting pipe point, the ID of the ending pipe point, and geometric data; the pipe point table is used to store the ID, coordinates, and other attributes of each pipe point;

[0128] The adjacency matrix is used to represent the topological relationship between pipe points in the pipeline. The elements in the matrix indicate whether there is a direct connection between two pipe points and the length of the connection.

[0129] It should be noted that PostGIS is an extension of the PostgreSQL database, specifically used to process geospatial data. It adds the ability to store, query, and analyze spatial data to PostgreSQL. PostGIS allows geometric data types (such as points, lines, polygons) to be directly stored in the database and provides various spatial functions to perform spatial operations, such as calculating distances, areas, intersection judgments, etc. The data table structure is used to store the geometric, attribute data, and topological relationship of the pipeline. Among them, the pipeline table stores the pipeline and its connection point information. The pipe point table stores the pipe point information. The foreign key association is used to ensure the correct relationship between the pipeline and the pipe point. These data tables are associated with each other through the attribute ID field, thereby establishing the topological relationship of the pipeline in the database and using the adjacency matrix to represent it.

[0130] Specifically, the technical principle of constructing the adjacency matrix is as follows: First, the pipeline network data needs to be abstracted into a graph structure. The pipelines are abstracted as the edges of the graph, and the pipe points (such as branch points, connection points) are abstracted as the nodes of the graph. Then, the adjacency matrix is used to represent the topological structure of the pipeline network. The adjacency matrix is a two-dimensional array, where the rows and columns of the matrix both represent the nodes of the graph. The elements in the matrix represent the connection relationship between the nodes. Matrix element definition:

[0131] If there is a pipeline connection between node i and node j, the corresponding element aij in the matrix is not 0, and its value can represent the length of the pipeline or other weight information.

[0132] If there is no directly connected pipeline between node i and node j, the corresponding element aij in the matrix is 0.

[0133] The diagonal element aii is null, indicating that there is no loop in the node itself.

[0134] Since the pipeline network connection is bidirectional, the adjacency matrix is symmetric, that is, aij is equal to aji.

[0135] Through the above steps, the PostgreSQL database and the PostGIS extension tool work together to effectively manage and analyze the spatial data and topological relationships of the underground pipe network, providing powerful data support for the modeling, visualization, and management of the underground pipe network.

[0136] Furthermore, it also includes S6): Using the minimum path algorithm to find the shortest path between two pipe points, providing decision-making support for the relocation and planning of pipelines. The specific implementation process includes:

[0137] S6.1) Create a distance array based on the adjacency matrix to store the shortest distance from the starting node to each other node. Initialize the distance of the starting node to 0, and the distances of other nodes to infinity;

[0138] S6.2) Create an access flag array based on the adjacency matrix to record which nodes have been visited, and initialize all nodes to 'unvisited';

[0139] S6.3) Select the node closest to the starting node from all 'unvisited' nodes;

[0140] S6.4) Mark the selected node as 'visited';

[0141] S6.5) Update the distances of its adjacent nodes. If the distance to an adjacent node through the current node is shorter than the currently recorded distance, update the shortest distance;

[0142] S6.6) Repeat steps S6.3 - 6.5) until all nodes are visited or the target node is found;

[0143] S6.7) After obtaining the shortest distance, record the predecessor node of each node according to the algorithm, and backtrack these predecessor nodes to find the complete shortest path.

[0144] Furthermore, step S6) also includes: Using the depth-first search (DFS) algorithm to traverse the adjacency matrix to verify the connectivity of the topological relationship and the existence of isolated pipe points. The specific implementation process includes:

[0145] Select a starting node from the pipe points as the starting point of DFS and mark the starting node as 'visited';

[0146] Traverse the adjacent nodes of the starting node;

[0147] When the DFS traversal is completed, check whether all nodes are marked as 'visited';

[0148] If all nodes are visited, it means that each pipe point is connected, that is, starting from any one node, it is possible to reach all other nodes;

[0149] If there are unvisited nodes, it indicates the existence of isolated pipe points;

[0150] Isolated pipe points for further analysis and processing.

[0151] Specifically, the DFS algorithm is an algorithm used to traverse or search a tree or graph. The algorithm starts from a starting node and searches as deeply as possible into the branches of the graph until it reaches a leaf node, then backtracks to the previous node and continues to search other branches. Through DFS traversal and identification of isolated pipe points, various topological errors existing in the pipe network can be detected, including pipeline connection errors, missing nodes, or redundant pipelines, etc. It provides an intuitive technical means for the design of pipeline relocation projects.

[0152] The minimum path algorithm is used to find the shortest paths from a node in a graph to all other nodes. When new pipelines are built, the minimum path algorithm can be used to select the best pipeline laying path, reduce construction costs, shorten the construction period, and reduce interference to existing infrastructure.

[0153] In this way, integrating the functions of the DFS algorithm and the minimum path algorithm into a unified platform can effectively improve the efficiency and intelligent level of pipe network management.

[0154] The present invention also provides a system for a pipeline relocation management method based on BIM, including: a GIS platform, a memory, and a processor;

[0155] The GIS platform is used to construct a fused GML model, and the GIS platform has functions of layer management, attribute query, spatial analysis, and visualization;

[0156] The memory is used to construct a PostgreSQL database to store and manage various data of the GML model;

[0157] The processor is used to execute spatial analysis functions; including connectivity analysis based on the depth-first search (DFS) algorithm, and shortest path analysis for finding the shortest path between two pipe points based on the shortest path algorithm.

[0158] A BIM-based pipeline relocation management method and system proposed by the present invention realizes the fusion of BIM model and GIS model data by using the semantic mapping method, breaks the data silos, constructs a unified data foundation, avoids data redundancy and inconsistency, and greatly improves the data management efficiency. On the other hand, through the collaborative work of the PostgreSQL database and the PostGIS extension tool, the effective management and analysis of the spatial data and topological relationships of the underground pipe network are realized, which provides powerful data support for the modeling, visualization, and management of the underground pipe network. At the same time, the pipeline spatial analysis function based on the database integrates the connectivity analysis and shortest path analysis of pipe points; it provides decision-making support for the relocation and planning of pipelines.

[0159] The above content is only an example and explanation of the structure of the present invention. Those skilled in the art of the present technology make various modifications or supplements or use similar methods to replace the specific embodiments described, as long as they do not deviate from the structure of the invention or exceed the scope defined by this claim book, they shall fall within the protection scope of the present invention.

Claims

1. A pipeline relocation management method based on BIM, characterized in that: The following steps are involved: S1) Create a BIM model based on the as-built drawing; S2) Collect the real scene of ground obstacles related to pipelines, including information of buildings, roads and vegetation; use GIS software to classify and model the real scene of ground obstacles, generate a three-dimensional GIS model, and mark the attribute ID of the real scene of obstacles; S3) BIM model is based on IFC format; GIS model is based on GML format; semantic mapping method is used to achieve conversion and integration between IFC and GML two different standard formats; S4) managing the fused GML model by layer; Display model data of different attributes by controlling the hierarchy of layers, and locate models of specific attributes through attribute query and filtering; Use different colors to indicate different construction areas; Use the time slider to control and display different construction status; S5) Using PostgreSQL database and its PostGI S extension to store and manage spatial data, the implementation process includes: PostgreSQL is selected as the relational database to store and manage various information data of the pipeline system, including the geometric data, attribute data and topological relationship data of the pipeline; Use the PostGI S extension tool of the PostgreSQL database to store geometric data and attribute data together in data tables, including pipeline tables and pipeline point tables; The pipeline table is used to store the ID, starting point ID, end point ID and geometric data of each pipeline segment; the pipe point table is used to store the ID, coordinates and other attributes of each pipe point; The adjacency matrix is ​​used to represent the topological relationship between the pipe points in the pipeline. The elements in the matrix represent whether there is a direct connection between two pipe points and the length of the connection. S6) Use the minimum path algorithm to find the shortest path between two pipeline points to provide decision support for pipeline relocation and planning.

2. A pipeline relocation management method based on BIM according to claim 1, characterized in that: The specific process of step S1) includes: S1.1) Collect relevant as-built drawings and digitize them to extract geometric data and attribute data of pipelines in as-built drawings; geometric data of pipelines include pipe diameter and pipe point coordinates; attribute data of pipelines include material, buried depth and location information; S1.2) Clean the data to remove errors and redundant information; then standardize the data to unify the location coordinate system, units and attribute naming; S1.3) Based on the processed data, a three-dimensional BIM model of the pipeline is generated according to the geometric data and attribute data of the pipeline.

3. A pipeline relocation management method based on BIM according to claim 2, characterized in that: In step S1.3), the specific process of generating a three-dimensional BIM model of the pipeline based on the geometric data and attribute data of the pipeline includes: Abstract the pipeline structure into a line object and record its starting and ending point coordinates; Abstract the pipe point structure into a point object and record its coordinates and type; the pipe point structure includes valves, access points and branch points; Use the adjacency matrix to define the topological structure of the pipeline network and describe the connection relationship between the pipeline structure and the pipe point structure; According to the diameter of the pipeline, the cylinder algorithm is used for 3D modeling; and 3D models are preset for different types of pipe point structures; Calculate the rotation angle and scaling ratio of the pipe point according to the connection of the pipeline to ensure the correct connection between the pipe point and the pipeline; Export the constructed 3D BIM model to IFC format.

4. The pipeline relocation management method based on BIM according to claim 1, characterized in that: The specific process of step S3) includes: S3.1) parsing geometric data and attribute data of the IFC format model; S3.2) classifying and mapping the geometric data and attribute data in the IFC format model and the GML format model based on the semantic mapping rules; S3.3) performing coordinate conversion to convert the local coordinate system of the IFC format model into the world coordinate system of the GML format model; S3.4) converting the model expression mode, converting the swept volume representation of the IFC format model into the boundary representation of the GML format model, thus merging and generating a multi-level GML model.

5. The pipeline relocation management method based on BIM according to claim 1 is characterized by: In step S4), the specific implementation process of managing the fused GML model by layer includes: The layers of the GML format model are divided into basic model layers and migration management layers; The secondary layers of the basic model layer are divided into ground obstacle layer and pipeline engineering layer; the secondary layers of the relocation management layer are divided into pipeline relocation engineering layer and progress management layer; The three-level layers of the pipeline relocation project layer are divided into the pipeline removal layer and the new pipeline layer; the progress management layer is divided into different construction areas and construction status; The construction area is divided into the ground obstacle relocation area and the underground pipeline relocation area; the construction status is divided into not started, in progress, completed and delayed.

6. The pipeline relocation management method based on BIM according to claim 1, characterized in that: The specific process of step S6) includes: S6.1) creating a distance array based on the adjacency matrix to store the shortest distance from the starting node to each other node; initializing the distance of the starting node to 0 and the distances of other nodes to infinity; S6.2) creating a visit mark array based on the adjacency matrix to record which nodes have been visited, and initializing all nodes to 'unvisited'; S6.3) Select the node closest to the starting node from all 'unvisited' nodes; S6.4) marking the selected node as 'visited'; S6.5) updating the distances of its adjacent nodes. If the distance from the current node to the adjacent node is shorter than the currently recorded distance, updating the shortest distance; S6.6) Repeat steps S6.3-6.5) until all nodes are visited or the target node is found; S6.7) After obtaining the shortest distance, the predecessor nodes of each node are recorded according to the algorithm, and these predecessor nodes are traced back to find the complete shortest path.

7. The pipeline relocation management method based on BIM according to claim 1 is characterized in that: Step S6) also includes: using a depth-first search algorithm to traverse the adjacency matrix to verify the connectivity of the topological relationship and whether there are isolated pipe points; the specific implementation process includes: Select a starting node from the pipe points as the starting point of DFS and mark the starting node as 'visited'; Traverse the adjacent nodes of the starting node; When the DFS traversal is complete, check whether all nodes are marked as 'visited'; If all nodes are visited, it means that the pipe points are connected; If there are unvisited nodes, it means that there are isolated pipe points.

8. A system for a pipeline relocation management method based on BIM, applied to a pipeline relocation management method based on BIM according to any one of claims 1 to 7, characterized in that: include: GIS platform, memory and processor; The GIS platform is used to construct the fused GML model, and the GIS platform has layer management, attribute query, spatial analysis and visualization functions; The memory is used to construct a PostgreSQL database to store and manage various data of the GML model; The processor is used to execute the spatial analysis function; the spatial analysis function includes connectivity analysis based on a depth-first search algorithm and shortest path analysis based on a shortest path algorithm to find the shortest path between two pipe points.

Images