A pipeline relocation management method and system based on BIM

Abstract

The present invention belongs to the field of data management technology, specifically to a BIM-based pipeline relocation management method and system, comprising the following steps: S1) creating a BIM model based on as-built drawings; S2) creating a three-dimensional real-world model; S3) using the IFC format as the carrier for the BIM model and the GML format as the carrier for the GIS model; employing a semantic mapping method to achieve conversion and fusion between the two different standard formats of IFC and GML; and S4) managing the fused GML model by layer. The semantic mapping method achieves the fusion of BIM and GIS model data, breaking down data silos, building a unified data foundation, avoiding data redundancy and inconsistency, and significantly improving data management efficiency.

Description

Technical Field

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

[0002] Municipal engineering pipelines include electricity, gas, water supply, drainage, communications, and heating, encompassing a wide range of disciplines and complex models. During the relocation process, the original as-built drawings of the demolished pipelines and geophysical data obtained during the survey phase are used as a basis for calculation, using paper or electronic spreadsheets to calculate the types and quantities of requisitioned and demolished pipelines. Some organizations also use BIM models based on geophysical survey results and drawings to manage relocation. However, this lacks a comprehensive and accurate understanding of underground pipelines and their surrounding environments.

[0003] For example, the lack of effective BIM and GIS data fusion methods makes it difficult to integrate and analyze pipeline data and real-life obstacle scenes, making construction simulation and visual management impossible.

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

[0005] In order to solve the technical problems in the existing technology of lacking an effective BIM and GIS data fusion method; and lacking effective management of pipeline topological relationships and spatial analysis functions, the present invention provides a BIM-based pipeline relocation management method and system.

[0006] The purpose of the present invention can be achieved through the following technical solutions:

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

[0008] S1) Create a BIM model based on the as-built drawing;

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

[0010] S1.1) Collect relevant as-built drawings and digitize them, extracting the geometric and attribute data of pipelines from the as-built drawings. Pipeline geometric data includes pipe diameter and pipe point coordinates; pipeline attribute data includes material, burial depth, and location information.

[0011] 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;

[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 three-dimensional BIM model of the pipeline based on the geometric data and attribute data of the pipeline includes:

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

[0015] 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;

[0016] 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;

[0017] 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;

[0018] 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;

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

[0020] S2) Creation of 3D reality model:

[0021] S2.1) Collect real-world images of pipeline-related ground obstacles, including buildings, roads, and vegetation information;

[0022] S2.2) Use GIS software to classify and model the real scene of ground obstacles, generate a 3D GIS model, and mark the attribute ID of the real scene of obstacles;

[0023] S3) Model data conversion and fusion:

[0024] BIM models are based on the IFC format; GIS models are based on the GML format; semantic mapping is used to achieve conversion and integration between IFC and GML.

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

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

[0027] 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;

[0028] 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;

[0029] S3.4) Perform model expression conversion, converting the swept volume representation of the IFC format model into the boundary representation of the GML format model, thereby generating a multi-level GML model through fusion.

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

[0031] Manage the fused GML model by layers;

[0032] Display model data with different attributes by controlling the hierarchy of layers, and locate models with specific attributes through attribute query and filtering;

[0033] Use different colors to represent different construction areas; use the time slider to control the display of different construction statuses.

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

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

[0036] The secondary layers of the basic model layer are divided into the ground obstacle layer and the pipeline engineering layer; the secondary layers of the relocation management layer are divided into the pipeline relocation engineering layer and the progress management layer;

[0037] The three-level layers of the pipeline relocation project layer are divided into the demolished pipeline layer and the newly built pipeline layer; the progress management layer is divided into different construction areas and construction statuses;

[0038] 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.

[0039] Preferably, it also includes S5) data management: using PostgreSQL database and its PostGIS extension to store and manage spatial data;

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

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

[0042] Use the PostGIS extension tool of the PostgreSQL database to store geometric data and attribute data together in data tables, including pipeline tables and pipeline point tables;

[0043] 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;

[0044] The adjacency matrix is ​​used to represent the topological relationship between the 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, the method further includes step S6): using a minimum path algorithm to find the shortest path between two pipeline points, providing decision support for pipeline relocation and planning. 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 to the starting node to 0 and the distances to other nodes to infinity.

[0047] 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';

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

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

[0050] S6.5) updating the distances to its adjacent nodes. If the distance to the adjacent node through the current node is shorter than the currently recorded distance, then updating 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 nodes of each node according to the algorithm, and backtrack to these predecessor nodes to find the complete shortest path.

[0053] Preferably, step S6) further includes: using a 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 nodes as the starting point of DFS and mark the starting node as 'visited';

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

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

[0057] If all nodes are visited, it means that all nodes are connected, that is, starting from any node, you can reach all other nodes;

[0058] If there are unvisited nodes, it means there are isolated nodes;

[0059] Isolated tube points for further analysis and processing.

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

[0061] 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;

[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 perform spatial analysis functions, including connectivity analysis based on a depth-first search (DFS) algorithm, and shortest path analysis based on a shortest path algorithm to find the shortest path between two nodes.

[0064] Beneficial effects of the present invention:

[0065] 1. The semantic mapping method is used to achieve the integration of BIM model and GIS model data, breaking the data silos, building a unified data foundation, avoiding data redundancy and inconsistency, and greatly improving data management efficiency.

[0066] 2. Through the collaborative work of the PostgreSQL database and PostGIS extension tools, effective management and analysis of underground pipeline network spatial data and topological relationships are achieved, which provides powerful data support for the modeling, visualization, and management of underground pipeline networks.

[0067] 3. The database-based pipeline space analysis function integrates the connectivity analysis and shortest path analysis of pipeline points, providing decision support for pipeline relocation and planning. BRIEF DESCRIPTION OF THE DRAWINGS

[0068] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for describing the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[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 flow chart of data management in step S5) of a BIM-based pipeline relocation management method of the present invention. DETAILED DESCRIPTION

[0071] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making any creative efforts shall fall within the scope of protection of the present invention.

[0072] See also Figure 1-Figure 2 As shown, a pipeline relocation management method based on BIM includes the following steps:

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

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

[0075] S1.1) Collect relevant as-built drawings and digitize them, extracting the geometric and attribute data of pipelines from the as-built drawings. Pipeline geometric data includes pipe diameter and pipe point coordinates; pipeline attribute data includes material, burial depth, and location information.

[0076] Among them, the digitization of drawings can use a high-resolution scanner to scan paper completion 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 points, inconsistent attribute data, and missing data.

[0078] Standardization is then performed to unify the position coordinate system, units, and attribute naming. The coordinates of all component data are converted to a unified coordinate reference system. Each pipeline component is assigned a WGS84 or local coordinate system, which then forms the pipeline BIM model. All attribute data is standardized, with millimeters used for pipe diameter and meters for burial depth. Uniform attribute names and coding conventions are used, for example, "DN800" (nominal diameter) for pipe diameter and "PVC, PV, etc." for material. Industry standards can be referenced or internal standards developed.

[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 as-built drawings through data extraction, data cleaning and standardization, and the final BIM model construction. In pipeline relocation projects, as-built drawings in historical information are the primary data source for pipeline modeling, and their accuracy and completeness directly impact the development and implementation of subsequent relocation project plans.

[0081] Select appropriate BIM modeling software, such as Revit. Create a 3D model of the pipeline in the BIM software based on the extracted geometry and attribute data. Specific operations include:

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

[0083] Set pipeline attributes: assign the extracted attribute information to the corresponding pipeline object.

[0084] Check the model: Check the model's completeness and accuracy to ensure it is consistent with the as-built drawings. The final BIM model should include the exact geometry, location, and detailed attribute information of all pipelines, providing a reliable data foundation for subsequent pipeline relocation management. Finally, export the model in IFC format to facilitate subsequent data conversion with other software.

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

[0086] Abstract the pipeline structure into a line object and record its starting and ending point coordinates;

[0087] 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;

[0088] 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;

[0089] 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;

[0090] 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;

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

[0092] S2) Creation of 3D reality model:

[0093] S2.1) Collect real-world images of pipeline-related ground obstacles, including buildings, roads, and vegetation information;

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

[0095] In the specific implementation process, step S2) is to create a 3D real-world model that includes ground obstacles, providing a real-world reference for pipeline removal and construction. This provides an important reference for assessing construction feasibility and planning construction routes.

[0096] Based on the accuracy requirements and site conditions, select appropriate methods for collecting real-world data, such as photogrammetry, which uses drones equipped with cameras to capture aerial footage and obtain high-resolution image data. Preprocess the captured image data, including image stitching, which combines multiple images into a complete orthophoto or panoramic image.

[0097] Point cloud denoising: remove noise points from point cloud data.

[0098] Point cloud classification: classify point cloud data into different ground object categories, such as ground, buildings, and vegetation.

[0099] GIS software is then used to perform 3D modeling on the preprocessed data. A 3D model is generated from the point cloud data, depending on the data type. Each obstacle object in the model is labeled with an attribute ID. The GIS software's attribute editing capabilities can be used and associated with the model. The final 3D GIS model should include the attribute IDs, accurate geometry, and location information of all relevant ground obstacles. The model can be exported in GML data format and spatially associated with the BIM model, providing a realistic context for subsequent pipeline relocation analysis and management.

[0100] S3) Model data conversion and fusion:

[0101] BIM models are based on the IFC format; GIS models are based on the GML format; semantic mapping is used to achieve conversion and integration between IFC and GML.

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

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

[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] During implementation, components in the IFC model are classified and filtered based on their semantic information according to predefined mapping rules. For example, the "Pipeline" element in the IFC model is mapped to the "Underground Pipeline" element in the GML model; the element includes the geometric data and attribute data of each pipeline.

[0106] S3.3) Perform coordinate conversion to convert the local coordinate system of the IFC model to the world coordinate system of the GML model. During this process, first define the conversion parameters between the two coordinate systems, such as the rotation matrix, translation vector, and scaling factor. This conversion can be performed using coordinate conversion functions in GIS software or libraries.

[0107] S3.4) Perform model expression conversion, converting the swept volume representation of the IFC format model into the boundary representation of the GML format model, thereby generating a multi-level GML model through fusion.

[0108] Specifically, through semantic mapping and hierarchical conversion algorithms, new GML elements are created from IFC elements, achieving multi-level representation of the GML model. The final GML model should contain all relevant information from both the BIM and GIS models, using a unified coordinate system and data format. This approach ensures that the geometry and attribute data of the BIM model are accurately preserved when converted to GIS data, providing a unified data foundation for subsequent pipeline relocation management. In practice, the implementation steps and methods should be flexibly adjusted based on the specific project circumstances and data characteristics.

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

[0110] Manage the fused GML model by layers;

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

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

[0113] Use the time slider to control the display of different construction statuses.

[0114] Specifically, the goal of creating a pipeline relocation management environment in step S4 is to create an interactive management environment based on the fused GML model, which facilitates users to view, query, analyze and manage pipeline relocation project information.

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

[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 basic model layers and migration management layers;

[0118] The secondary layers of the basic model layer are divided into the ground obstacle layer and the pipeline engineering layer; the secondary layers of the relocation management layer are divided into the pipeline relocation engineering layer and the progress management layer;

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

[0120] 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.

[0121] Ensure all layers contain the necessary geometry and attribute information, such as pipe diameter, material, and construction status. Use different colors to distinguish different construction areas. Additionally, configure attribute query tools to allow users to query and filter pipeline data based on 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 a selected time point on the timeline. This allows users to view pipeline status at different time periods and visualize progress. The ultimate pipeline relocation management environment should be an interactive and visual platform that facilitates user viewing, querying, analysis, and management of pipeline relocation information, supporting progress visualization and spatial analysis.

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

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

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

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

[0127] 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;

[0128] The adjacency matrix is ​​used to represent the topological relationship between the 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 for processing 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 stored directly in the database, and provides various spatial functions to perform spatial operations, such as calculating distance, area, intersection judgment, etc. The data table structure is used to store the geometry, attribute data and topological relationships of pipelines. Among them, the pipeline table stores pipelines and their connection point information. The pipe point table stores pipe point information. Foreign key associations are used to ensure that the relationship between pipelines and pipe points is correct. These data tables are interconnected through the attribute ID field, thereby establishing the topological relationship of the pipelines in the database and representing it using an adjacency matrix.

[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. Pipelines are abstracted as edges of the graph, and pipeline points (such as branch points and connection points) are abstracted as 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 both the rows and columns of the matrix represent the nodes of the graph. The elements in the matrix represent the connection relationships 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 the node itself has no loop.

[0134] Since the pipe 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 PostGIS extension tool work together to achieve effective management and analysis of underground pipeline network spatial data and topological relationships, which provides powerful data support for the modeling, visualization, and management of underground pipeline networks.

[0136] Furthermore, the process also includes S6): using a minimum path algorithm to find the shortest path between two pipeline points to provide decision support for pipeline relocation and planning. 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 to the starting node to 0 and the distances to other nodes to infinity.

[0138] 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';

[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) updating the distances to its adjacent nodes. If the distance to the adjacent node through the current node is shorter than the currently recorded distance, then updating 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 nodes of each node according to the algorithm, and backtrack to these predecessor nodes to find the complete shortest path.

[0144] Furthermore, step S6) further includes: using a 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:

[0145] Select a starting node from the pipe nodes 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 complete, check whether all nodes are marked as 'visited';

[0148] If all nodes are visited, it means that all nodes are connected, that is, starting from any node, you can reach all other nodes;

[0149] If there are unvisited nodes, it means there are isolated nodes;

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

[0151] Specifically, the DFS algorithm is used to traverse or search a tree or graph. Starting from a starting node, the algorithm searches the graph branches as deeply as possible until it reaches a leaf node, then backtracks to the previous node and continues searching other branches. Through DFS traversal and isolated pipe point identification, various topological errors in the pipeline network can be detected, including incorrect pipeline connections, missing nodes, and redundant pipelines. This provides an intuitive technical approach for pipeline relocation project design.

[0152] The minimum path algorithm is used to find the shortest path from one node to all other nodes in a graph. When constructing new pipelines, the minimum path algorithm can be used to select the optimal pipeline laying path, reducing construction costs, shortening the construction period, and minimizing disruption 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 intelligence level of pipeline network management.

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

[0155] 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;

[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 perform spatial analysis functions, including connectivity analysis based on a depth-first search (DFS) algorithm, and shortest path analysis based on a shortest path algorithm to find the shortest path between two nodes.

[0158] The present invention proposes a BIM-based pipeline relocation management method and system, which uses a semantic mapping method to achieve the integration of BIM model and GIS model data, breaking down data silos, building a unified data foundation, avoiding data redundancy and inconsistency, and greatly improving data management efficiency. On the other hand, through the collaborative work of the PostgreSQL database and the PostGIS extension tool, effective management and analysis of underground pipeline network spatial data and topological relationships are achieved, which provides powerful data support for the modeling, visualization, and management of underground pipeline networks. At the same time, the database-based pipeline spatial analysis function integrates the connectivity analysis and shortest path analysis of pipe points, providing decision support for pipeline relocation and planning.

[0159] The above content is merely an example and explanation of the structure of the present invention. Those skilled in the art may make various modifications or additions to the described specific embodiments or replace them in a similar manner. As long as they do not deviate from the structure of the invention or exceed the scope defined by the claims, they should all fall within the scope of protection 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) Collecting real scenes of pipeline-related ground obstacles, including information on buildings, roads, and vegetation; using GIS software to classify and model the real scenes of ground obstacles, generate a 3D GIS model, and mark the attribute IDs of the real scenes of obstacles; S3) BIM models are based on the IFC format; GIS models are based on the GML format; semantic mapping is used to achieve conversion and integration between the two different standard formats of IFC and GML; S4) managing the fused GML model by layer; Display model data with different attributes by controlling the hierarchy of layers, and locate models with 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 pipeline geometry data, attribute data, and topological relationship data; 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 nodes in the pipeline. The elements in the matrix represent whether there is a direct connection between two nodes 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. The BIM-based pipeline relocation management method according to claim 1, characterized in that: The specific process of step S1) includes: S1.1) Collect relevant as-built drawings and digitize them, extracting the geometric and attribute data of pipelines from the as-built drawings. The geometric data of pipelines includes pipe diameter and pipe point coordinates; the attribute data of pipelines includes material, burial 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. The BIM-based pipeline relocation management method according to claim 2, characterized in that: In step S1.3), the specific process of generating a 3D 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 BIM-based pipeline relocation management method 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) Classify and map the geometric data and attribute data in the IFC format model and the GML format model based on 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) Perform model expression conversion, converting the swept volume representation of the IFC format model into the boundary representation of the GML format model, thereby generating a multi-level GML model through fusion.

5. The BIM-based pipeline relocation management method according to claim 1, characterized in that: 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 the ground obstacle layer and the pipeline engineering layer; the secondary layers of the relocation management layer are divided into the pipeline relocation engineering layer and the progress management layer; The three-level layers of the pipeline relocation project layer are divided into the demolished pipeline layer and the newly built pipeline layer; the progress management layer is divided into different construction areas and construction statuses; 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 BIM-based pipeline relocation management method according to claim 1, characterized in that: The specific process of step S6) includes: S6.1) Create a distance array based on the adjacency matrix to store the shortest distance from the start node to each other node; initialize the distance of the start 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) Mark the selected node as 'visited'; S6.5) updating the distances to its adjacent nodes. If the distance to the adjacent node through the current node is shorter than the currently recorded distance, then 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, record the predecessor nodes of each node according to the algorithm, and backtrack to these predecessor nodes 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) further 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 nodes 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 all the nodes are connected; If there are unvisited nodes, it means there are isolated nodes.

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 perform spatial analysis functions; the spatial analysis functions include connectivity analysis based on a depth-first search algorithm and analysis of finding the shortest path between two points based on a shortest path algorithm.

Images