3D Modeling Processing Method, Device and Storage Medium for Pipeline Network Data

Abstract

The present application provides a three-dimensional modeling processing method, device, and storage medium for pipeline network data. The method includes: collecting pipeline network data of a to-be-processed area, where the pipeline network data includes inspection well data and pipe segment data; obtaining area data of the to-be-processed area, where the area data includes water body data, road network data, and building data; performing a first three-dimensional transformation process on the inspection well data to obtain three-dimensional inspection well data; performing a second three-dimensional transformation process on the pipe segment data to obtain three-dimensional pipe segment data; performing a third three-dimensional transformation process on the water body data, road network data, and building data to obtain three-dimensional water body data, three-dimensional road network data, and three-dimensional building data; generating a three-dimensional display interface based on the three-dimensional inspection well data, three-dimensional pipe segment data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data; so as to achieve the effect of improving the reconstruction accuracy of pipeline network data.

Description

Technical Field

[0001] This application relates to the technical field of data processing, and in particular, to a three-dimensional modeling processing method, device, and storage medium for pipe network data. Background Art

[0002] Pipe networks are underground hidden projects in cities. They are buried underground, "invisible and unclear", and are responsible for many important tasks such as the sewage treatment and rainwater drainage of the entire city. Moreover, the vertical burial depth information of pipe networks is of great significance for the planning, design, management, and maintenance of pipe networks, as well as for the construction of pipe network-related dispatching and tracing models. Therefore, reconstructing and displaying pipe network data has become a promising direction.

[0003] In the prior art, the reconstruction and display of pipe network data are mainly based on the Geographic Information System (GIS) for two-dimensional planar display.

[0004] However, the two-dimensional display method in the prior art methods is difficult to show the topological relationship of pipe networks in the vertical direction, resulting in an unintuitive two-dimensional display of pipe networks, frequent errors, and the technical problem of low accuracy in reconstructing pipe network data. Summary of the Invention

[0005] This application provides a three-dimensional modeling processing method, device, and storage medium for pipe network data to achieve the effect of improving the accuracy of reconstructing pipe network data.

[0006] In a first aspect, this application provides a three-dimensional modeling processing method for pipe network data, including:

[0007] Collecting pipe network data of the area to be processed, where the pipe network data includes inspection well data and pipe segment data;

[0008] Obtaining area data of the area to be processed, where the area data includes water body data, road network data, and building data;

[0009] Performing a first three-dimensional transformation process on the inspection well data to obtain three-dimensional inspection well data;

[0010] Performing a second three-dimensional transformation process on the pipe segment data to obtain three-dimensional pipe segment data;

[0011] Performing a third three-dimensional transformation process on the water body data, road network data, and building data to obtain three-dimensional water body data, three-dimensional road network data, and three-dimensional building data;

[0012] Generating a three-dimensional display interface based on the three-dimensional inspection well data, three-dimensional pipe segment data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0013] In a possible implementation, the inspection well data includes the administrative region name, component identification code, coordinates, category, name of the road where it is located, elevation of the natural well cover pavement, well depth, and bottom elevation of the well, and also includes multiple ones among features, material, well cover shape, well cover size, and the drainage sub-region to which it belongs.

[0014] In a possible implementation, the pipe segment data includes the administrative region name, component identification code, coordinates of the head, bottom elevation of the head, buried depth data of the head, coordinates of the tail, bottom elevation of the tail, and buried depth data of the tail, and also includes multiple ones among the pipe segment length, wall thickness, pipe segment grade, pressure type, whether it is a pressure pipe, name of the road where it is located, material, shape, size, and the drainage sub-region to which it belongs.

[0015] In a possible implementation, the first three-dimensional transformation process for the inspection well data includes:

[0016] Obtain the ground elevation data corresponding to the inspection well;

[0017] Take the inspection well data as the scatter data of the inspection well;

[0018] Assign the ground elevation data corresponding to the inspection well to the scatter data of the inspection well and assign inspection well attributes.

[0019] In a possible implementation, the second three-dimensional transformation process for the pipe segment data includes:

[0020] Read the pipe segment data of each pipe segment one by one, and use the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail to create a three-dimensional line segment and assign pipe segment attributes.

[0021] In a possible implementation, the water body data, road network data, and building data include multiple coordinate data;

[0022] Correspondingly, the third three-dimensional transformation process for the water body data, road network data, and building data includes:

[0023] Read the multiple coordinate data in the water body data, road network data, and building data;

[0024] Determine the corresponding three-dimensional scatter matrix according to the multiple coordinate data;

[0025] Combine the three-dimensional scatter matrix to generate a linear interpolation function and a nearest point interpolation function;

[0026] Perform spatial interpolation processing according to the linear interpolation function and the nearest point interpolation function, and assign the corresponding water body attributes, road network attributes, and building attributes.

[0027] In a possible implementation, a three-dimensional display interface is generated based on the three-dimensional data of inspection wells, pipeline segments, water bodies, road networks, and buildings, including:

[0028] Read the three-dimensional coordinate data and corresponding attributes in the three-dimensional data of inspection wells, pipeline segments, water bodies, road networks, and buildings;

[0029] Generate a three-dimensional display interface based on the three-dimensional coordinate data and corresponding attributes.

[0030] In a possible implementation, a three-dimensional display interface is generated based on the three-dimensional coordinate data and corresponding attributes, including:

[0031] Obtain the pre-stored existing attribute information, where the existing attribute information includes the existing attribute information of inspection wells, pipeline segments, water bodies, road networks, and buildings, and the existing attribute information is stored in the form of a hash array;

[0032] Determine the corresponding existing attribute information according to the corresponding attributes;

[0033] Assign the existing attribute information to the three-dimensional coordinate data to generate a three-dimensional display interface.

[0034] In a possible implementation, assigning the existing attribute information to the three-dimensional coordinate data to generate a three-dimensional display interface includes:

[0035] For the existing attribute information of inspection wells, assign the existing attribute information of inspection wells to the three-dimensional coordinate data in the three-dimensional data of inspection wells to generate a corresponding three-dimensional display interface for inspection wells;

[0036] For the existing attribute information of pipeline segments, according to quaternion operations, assign the existing attribute information of pipeline segments to the three-dimensional coordinate data in the three-dimensional data of pipeline segments to generate a corresponding three-dimensional display interface for pipeline segments;

[0037] For the existing attribute information of buildings, assign the existing attribute information of buildings to the three-dimensional coordinate data in the three-dimensional data of buildings to generate a corresponding three-dimensional display interface for buildings;

[0038] For the existing attribute information of water bodies and road networks, assign the existing attribute information of water bodies and road networks to the three-dimensional coordinate data in the three-dimensional data of water bodies and the three-dimensional coordinate data in the three-dimensional data of road networks respectively to generate a corresponding three-dimensional display interface for water bodies and road networks.

[0039] In a possible implementation, after assigning the existing attribute information to the three-dimensional coordinate data to generate a three-dimensional display interface, it further includes:

[0040] In response to a stretching operation, obtain the stretching direction corresponding to the stretching operation;

[0041] According to the stretching direction, determine whether to reconstruct the ground plane;

[0042] According to the judgment result, determine the stretching method;

[0043] According to the stretching method, generate a stretching display interface.

[0044] In a second aspect, the present application provides a three-dimensional modeling processing device for pipe network data, including:

[0045] An acquisition module for acquiring pipe network data of a to-be-processed area, where the pipe network data includes inspection well data and pipe section data;

[0046] An acquisition module for acquiring area data of a to-be-processed area, where the area data includes water body data, road network data, and building data;

[0047] A first processing module for performing a first three-dimensional transformation processing on the inspection well data to obtain three-dimensional inspection well data;

[0048] A second processing module for performing a second three-dimensional transformation processing on the pipe section data to obtain three-dimensional pipe section data;

[0049] A third processing module for performing a third three-dimensional transformation processing on the water body data, road network data, and building data to obtain three-dimensional water body data, three-dimensional road network data, and three-dimensional building data;

[0050] A generation module for generating a three-dimensional display interface according to the three-dimensional inspection well data, three-dimensional pipe section data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0051] In a possible implementation manner, the acquisition module is further configured to:

[0052] Inspection well data;

[0053] The inspection well data includes the administrative region name, component identification code, coordinates, category, name of the road where it is located, natural manhole cover road surface elevation, well depth, and bottom elevation of the well, and also includes multiple ones of features, materials, manhole cover shape, manhole cover size, and the drainage area to which it belongs.

[0054] In a possible implementation manner, the acquisition module is further configured to:

[0055] Pipe section data;

[0056] The pipe segment data includes the administrative region name, component identification code, coordinates of the head, bottom elevation of the head, buried depth data of the head, coordinates of the tail, bottom elevation of the tail, and buried depth data of the tail. It also includes multiple of the pipe segment length, wall thickness, pipe segment grade, pressure type, whether it is a pressure pipe, name of the road where it is located, material, shape, size, and the drainage sub - area to which it belongs.

[0057] In a possible implementation manner, the first processing module is further configured to:

[0058] Obtain the ground elevation data corresponding to the inspection well;

[0059] Use the inspection well data as the scatter data of the inspection well;

[0060] Assign the ground elevation data corresponding to the inspection well to the scatter data of the inspection well and assign inspection well attributes.

[0061] In a possible implementation manner, the second processing module is further configured to:

[0062] Read the pipe segment data of each pipe segment, and use the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail to create a three - dimensional line segment and assign pipe segment attributes.

[0063] In a possible implementation manner, the water body data, road network data, and building data include multiple coordinate data. Correspondingly, the third processing module is further configured to:

[0064] Read the multiple coordinate data in the water body data, road network data, and building data;

[0065] Determine the corresponding three - dimensional scatter matrix according to the multiple coordinate data;

[0066] Combine the three - dimensional scatter matrix to generate a linear interpolation function and a nearest - point interpolation function;

[0067] Perform spatial interpolation processing according to the linear interpolation function and the nearest - point interpolation function, and assign the corresponding water body attributes, road network attributes, and building attributes.

[0068] In a possible implementation manner, the generation module is further configured to:

[0069] Read the three - dimensional coordinate data and the corresponding attributes in the inspection well three - dimensional data, pipe segment three - dimensional data, water body three - dimensional data, road network three - dimensional data, and building three - dimensional data;

[0070] Generate a three - dimensional display interface according to the three - dimensional coordinate data and the corresponding attributes.

[0071] In a possible implementation manner, the generation module is further configured to:

[0072] Obtain pre-stored existing attribute information, where the existing attribute information includes existing inspection well attribute information, existing pipe section attribute information, existing water body attribute information, existing road network attribute information, and existing building attribute information, and the existing attribute information is stored in the form of a hash array;

[0073] Determine the corresponding existing attribute information according to the corresponding attribute;

[0074] Assign the existing attribute information to the three-dimensional coordinate data to generate a three-dimensional display interface.

[0075] In a possible implementation manner, the generation module is further configured to:

[0076] For the existing inspection well attribute information, assign the existing inspection well attribute information to the three-dimensional coordinate data in the three-dimensional inspection well data to generate a corresponding three-dimensional display interface for the inspection well;

[0077] For the existing pipe section attribute information, according to quaternion operations, assign the existing pipe section attribute information to the three-dimensional coordinate data in the three-dimensional pipe section data to generate a corresponding three-dimensional display interface for the pipe section;

[0078] For the existing building attribute information, assign the existing building attribute information to the three-dimensional coordinate data in the three-dimensional building data to generate a corresponding three-dimensional display interface for the building;

[0079] For the existing water body attribute information and the existing road network attribute information, assign the existing water body attribute information and the existing road network attribute information to the three-dimensional coordinate data in the three-dimensional water body data and the three-dimensional coordinate data in the three-dimensional road network data respectively to generate a corresponding three-dimensional display interface for the water body and the road network.

[0080] In a possible implementation manner, the generation module is further configured to:

[0081] In response to a stretching operation, obtain the stretching direction corresponding to the stretching operation;

[0082] Judge whether to reconstruct the ground plane according to the stretching direction;

[0083] Determine the stretching method according to the judgment result;

[0084] Generate a stretching display interface according to the stretching method.

[0085] In a third aspect, the present application provides a three-dimensional modeling processing device for pipe network data, including: a memory, a processor;

[0086] The memory stores computer execution instructions;

[0087] The processor executes the computer execution instructions stored in the memory, so that the processor executes the above first aspect and / or various possible implementation manners of the first aspect.

[0088] Fourthly, the present application provides a computer-readable storage medium storing computer-executable instructions, which are used to implement the above first aspect and / or various possible implementation manners of the first aspect when executed by a processor.

[0089] Fifthly, the present application provides a computer program product including a computer program, which implements the above first aspect and / or various possible implementation manners of the first aspect when executed by a processor.

[0090] A three-dimensional modeling processing method, device and storage medium for pipe network data provided by the present application collect pipe network data and regional data of an area to be processed, covering multiple aspects such as inspection wells, pipe sections, water bodies, road networks and buildings, ensuring the comprehensiveness and integrity of the data, providing basic information for subsequent three-dimensional transformation, and ensuring the reliability and practicability of the reconstruction of pipe network data; at the same time, converting the inspection well data into three-dimensional data can more intuitively display information such as the location, shape and size of the inspection wells, which helps to quickly locate the inspection wells in subsequent urban planning or maintenance work and improve work efficiency. The three-dimensional transformation of the pipe section data can clearly display information such as the pipeline direction, connection relationship and size, which helps to intuitively understand the pipeline system in the three-dimensional display interface and facilitates the maintenance and management of the pipelines. Converting the water body, road network and building data into three-dimensional data can more realistically simulate the regional environment, which helps to provide richer visual information in the three-dimensional display interface. Finally, integrating the above multiple three-dimensional data in a display interface, through the three-dimensional display interface, the pipe network layout, water body distribution, road network structure and building distribution information of the area to be processed can be intuitively seen, improving the visualization degree of the information and achieving the effect of improving the accuracy of the reconstruction of pipe network data. BRIEF DESCRIPTION OF THE DRAWINGS

[0091] The drawings herein are incorporated into the specification and form a part of the specification, showing embodiments consistent with the present application and used together with the specification to explain the principles of the present application.

[0092] Figure 1 It is a schematic diagram of an application data processing system architecture provided by an embodiment of the present application;

[0093] Figure 2 It is a flowchart of a three-dimensional modeling processing method for pipe network data provided by an embodiment of the present application Figure 1 ;

[0094] Figure 3 It is a flowchart of a three-dimensional modeling processing method for pipe network data provided by an embodiment of the present application Figure 2 ;

[0095] Figure 4 Flow schematic of the 3D modeling process for pipeline network data provided by the embodiments of the present application Figure 3 ;

[0096] Figure 5 Flow schematic of the 3D modeling process for pipeline network data provided by the embodiments of the present application Figure 4 ;

[0097] Figure 6 Flow schematic of the 3D modeling process for pipeline network data provided by the embodiments of the present application Figure 5 ;

[0098] Figure 7 3D schematic of the pipeline network data provided by the embodiments of the present application;

[0099] Figure 8 Structure schematic of the 3D modeling processing device for pipeline network data provided by the embodiments of the present application;

[0100] Figure 9 Structure schematic of the 3D modeling processing equipment for pipeline network data provided by the embodiments of the present application.

[0101] Through the above-mentioned drawings, the specific embodiments of the present application have been shown, and there will be more detailed descriptions hereinafter. These drawings and text descriptions are not intended to limit the scope of the concept of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. Detailed implementation manners

[0102] Here, the exemplary embodiments will be described in detail, and the examples are shown in the drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementation manners described in the following exemplary embodiments do not represent all the implementation manners consistent with the present application. On the contrary, they are only examples of the devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0103] Due to the two-dimensional display method in the prior art methods, it is difficult to display the topological relationship of the pipeline network in the vertical direction, resulting in an unintuitive two-dimensional display of the pipeline network, frequent errors, and the technical problem of low accuracy in reconstructing pipeline network data.

[0104] In view of the above problems, the three-dimensional modeling processing method, device, and storage medium for pipe network data provided by the embodiments of the present application collect pipe network data and regional data of the area to be processed, covering multiple aspects such as inspection wells, pipe segments, water bodies, road networks, and buildings, ensuring the comprehensiveness and integrity of the data, providing basic information for subsequent three-dimensional transformation, and ensuring the reliability and practicability of the reconstruction of pipe network data. At the same time, converting inspection well data into three-dimensional data can more intuitively display information such as the location, shape, and size of inspection wells, which helps to quickly locate inspection wells in subsequent urban planning or maintenance work, improving work efficiency. The three-dimensional transformation of pipe segment data can clearly display information such as the pipeline orientation, connection relationship, and size, which helps to intuitively understand the pipeline system in the three-dimensional display interface and facilitates the maintenance and management of pipelines. Converting water body, road network, and building data into three-dimensional data can more realistically simulate the regional environment, which helps to provide richer visual information in the three-dimensional display interface. Finally, integrating the above multiple three-dimensional data into a display interface, through the three-dimensional display interface, the pipe network layout, water body distribution, road network structure, and building distribution information of the area to be processed can be intuitively seen, improving the visualization degree of information and achieving the effect of improving the accuracy of pipe network data reconstruction.

[0105] The following specifically describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems with specific embodiments. These several specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below with reference to the accompanying drawings.

[0106] Figure 1 FIG. is a schematic diagram of an application data processing system architecture provided by an embodiment of the present application, and the application data processing system is a computer device. As Figure 1 shown, the above architecture includes at least one of a data acquisition device 101, a processing device 102, and a display device 103.

[0107] It can be understood that the structure schematically shown in the embodiments of the present application does not constitute a specific limitation on the application data processing system architecture. In other feasible embodiments of the present application, the above architecture may include more or fewer components than shown in the figure, or combine certain components, or split certain components, or different component arrangements, which can be specifically determined according to the actual application scenario and will not be limited here. Figure 1 The components shown can be implemented in hardware, software, or a combination of software and hardware.

[0108] In the specific implementation process, the data acquisition device 101 may include an input / output interface or a communication interface, and the data acquisition device 101 may be connected to the processing device through the input / output interface or the communication interface.

[0109] The processing device 102 can collect pipeline network data of the area to be processed, where the pipeline network data includes inspection well data and pipe section data; obtain area data of the area to be processed, where the area data includes water body data, road network data, and building data; perform a first three-dimensional transformation process on the inspection well data to obtain three-dimensional inspection well data; perform a second three-dimensional transformation process on the pipe section data to obtain three-dimensional pipe section data; perform a third three-dimensional transformation process on the water body data, road network data, and building data to obtain three-dimensional water body data, three-dimensional road network data, and three-dimensional building data; generate a three-dimensional display interface based on the three-dimensional inspection well data, three-dimensional pipe section data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0110] The display device 103 can also be a touch display screen or the screen of a terminal device, which is used to receive user instructions while displaying the above content to achieve interaction with the user.

[0111] It should be understood that the above processing device can be implemented by a processor reading and executing instructions in a memory, or can also be implemented by a chip circuit.

[0112] In addition, the network architecture and service scenarios described in the embodiments of the present application are for more clearly explaining the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided by the embodiments of the present application. Those skilled in the art know that with the evolution of the network architecture and the emergence of new service scenarios, the technical solutions provided by the embodiments of the present application are equally applicable to similar technical problems.

[0113] Figure 2 Schematic diagram of the process of the three-dimensional modeling process for pipeline network data provided by the embodiments of the present application Figure 1 As Figure 2 shown, the three-dimensional modeling process for pipeline network data provided in this embodiment includes:

[0114] S201. Collect pipeline network data of the area to be processed, where the pipeline network data includes inspection well data and pipe section data;

[0115] Specifically, conduct field surveying and mapping to collect inspection well data and pipe section data of the area to be processed.

[0116] Optionally, the inspection well data includes administrative region name, component identification code, coordinates, category, name of the road where it is located, elevation of the natural manhole cover on the road surface, well depth, and bottom elevation of the well, and also includes multiple of features, material, manhole cover shape, manhole cover size, and the drainage sub-region to which it belongs.

[0117] Optionally, the pipe segment data includes the administrative region name, component identification code, coordinates of the head, bottom elevation of the head, buried depth data of the head, coordinates of the tail, bottom elevation of the tail, and buried depth data of the tail. It also includes multiple items such as pipe segment length, wall thickness, pipe segment grade, pressure type, whether it is a pressure pipe, name of the road where it is located, material, shape, size, and the drainage sub-region to which it belongs.

[0118] S202. Obtain the regional data of the area to be processed, where the regional data includes water body data, road network data, and building data.

[0119] In this embodiment, the data format of the regional data is the geospatial data format (ESRI SHAPEFILE), the attribute should be a multi-polygon (MultiPolygon), and the building data includes the height attribute of the building.

[0120] Specifically, obtain the water bucket data, road network data, and building data within the area to be processed through an open-source data website (OpenStreetMap) or relevant departments.

[0121] S203. Perform the first three-dimensional transformation processing on the inspection well data to obtain the three-dimensional inspection well data.

[0122] For the two-dimensional data of the inspection well, convert it into three-dimensional data to obtain the transformed three-dimensional inspection well data.

[0123] S204. Perform the second three-dimensional transformation processing on the pipe segment data to obtain the three-dimensional pipe segment data.

[0124] For the two-dimensional data of the pipe segment, convert it into three-dimensional data to obtain the transformed three-dimensional pipe segment data.

[0125] S205. Perform the third three-dimensional transformation processing on the water body data, road network data, and building data to obtain the three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0126] For the two-dimensional data of the water body, road network, and building, respectively convert them into three-dimensional data to obtain the transformed three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0127] S206. Generate a three-dimensional display interface based on the three-dimensional inspection well data, three-dimensional pipe segment data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0128] Specifically, use three-dimensional graphics and image software (Blender) to display the transformed three-dimensional inspection well data, three-dimensional pipe segment data, three-dimensional water body data, three-dimensional road network data, and three-dimensional building data to generate the corresponding three-dimensional display interface.

[0129] It should be noted that Blender is only an exemplary software and does not affect the protection content of the embodiments of the present application. Other software can also adopt the methods provided by the embodiments of the present application.

[0130] The three-dimensional modeling processing method for pipeline network data provided by the embodiments of the present application collects pipeline network data and regional data of the area to be processed, covering multiple aspects such as inspection wells, pipeline segments, water bodies, road networks, and buildings, ensuring the comprehensiveness and integrity of the data, providing basic information for subsequent three-dimensional transformation, and ensuring the reliability and practicability of the reconstruction of pipeline network data; at the same time, converting inspection well data into three-dimensional data can more intuitively display information such as the location, shape, and size of inspection wells, which helps to quickly locate inspection wells in subsequent urban planning or maintenance work and improve work efficiency. The three-dimensional transformation of pipeline segment data can clearly display information such as the pipeline's orientation, connection relationship, and size, which helps to intuitively understand the pipeline system in the three-dimensional display interface and facilitates the maintenance and management of pipelines. Converting water body, road network, and building data into three-dimensional data can more realistically simulate the regional environment, which helps to provide richer visual information in the three-dimensional display interface. Finally, integrating the above-mentioned various three-dimensional data into a display interface, through the three-dimensional display interface, the pipeline network layout, water body distribution, road network structure, and building distribution information of the area to be processed can be intuitively seen, improving the visualization degree of information and achieving the effect of improving the accuracy of pipeline network data reconstruction.

[0131] Figure 3 It is a flow schematic of the three-dimensional modeling processing method for pipeline network data provided by the embodiments of the present application Figure 2 as Figure 3 shown, based on the above embodiments, the three-dimensional transformation processing process of inspection well data is described in detail in this embodiment. The method includes:

[0132] S301. Obtain the ground elevation data corresponding to the inspection well;

[0133] For the inspection wells in the area to be measured, obtain the corresponding ground elevation data.

[0134] S302. Use the inspection well data as the scatter data of the inspection well;

[0135] Use the two-dimensional data of the inspection well as the scatter data of the inspection well.

[0136] S303. Assign the ground elevation data corresponding to the inspection well to the scatter data of the inspection well and assign inspection well attributes to obtain the three-dimensional data of the inspection well.

[0137] Specifically, the Set Zvalue built-in function of Quantum GIS (QGIS) is used to assign the ground elevation data of the inspection well to the three-point data of the inspection well, and at the same time, the attached attributes of the inspection well are also assigned to the new three-dimensional inspection well scatter data, so as to obtain the inspection well three-dimensional data with the data format of ESRI SHAPEFILE and the attribute of PointZM (Point with Z and M values).

[0138] The three-dimensional modeling processing method for pipe network data provided by the embodiments of the present application ensures the accuracy and integrity of the height information of the subsequent generated three-dimensional inspection well data by obtaining the ground elevation data corresponding to the inspection well, converts the inspection well data into scatter data format, improves the convenience for the subsequent processing and analysis process, saves a large amount of time cost. Finally, by assigning the ground elevation information to the inspection well scatter data, the inspection well data with complete three-dimensional information can be generated, achieving the effect of improving the accuracy of pipe network data reconstruction.

[0139] Figure 4 It is a flow schematic of the three-dimensional modeling processing method for pipe network data provided by the embodiments of the present application Figure 3 , as Figure 4 shown, on the basis of the above embodiments, the three-dimensional transformation processing process of the pipe segment data is described in detail in this embodiment, including:

[0140] S401. Read the pipe segment data of each pipe segment one by one;

[0141] Specifically, the OGR (Simple Feature Access Library) module of the Geospatial Data Abstraction Library for Python (Python GDAL) is used to read the two-dimensional data of each pipe segment one by one.

[0142] S402. Create a three-dimensional line segment using the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail, and assign pipe segment attributes to obtain the three-dimensional pipe segment data.

[0143] Specifically, a three-dimensional line segment with the attribute of LineStringZM (Line String with Z and M values) is created using the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail. After creation, the newly created three-dimensional line segment is added to the three-dimensional line segment database, and the storage format is the geospatial data format (ESRI SHAPEFILE), and the attribute is MultiLineStringZM (Multi Line String with Z and M values), so as to obtain the corresponding three-dimensional pipe segment data.

[0144] The 3D modeling processing method for pipe network data provided by the embodiments of the present application reads pipe segment data section by section, ensuring that all relevant pipe segment information is completely obtained, reducing errors in the data reading process, improving the accuracy and flexibility of data acquisition. At the same time, by using the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail information to create a 3D line segment and assign pipe segment attributes, 3D data of the pipe segment is obtained, ensuring the integrity and reliability of the 3D information, and achieving the effect of improving the accuracy of pipe network data reconstruction.

[0145] Figure 5 It is a schematic flow of the 3D modeling processing method for pipe network data provided by the embodiments of the present application Figure 4 , such as Figure 5 shown. Based on the above embodiments, this embodiment further explains the 3D transformation processing process of water body data, road network data, and building data, including:

[0146] S501. Read multiple coordinate data in water body data, road network data, and building data;

[0147] According to the water body data, road network data, and building data, obtain multiple spatial coordinate data corresponding to each data.

[0148] S502. Determine the corresponding 3D scatter point matrix according to the multiple coordinate data;

[0149] Specifically, use the OGR module of the Python GDAL library to read the multiple coordinate data obtained above to form a 3D scatter point matrix of ground scatter points.

[0150] S503. Combine the 3D scatter point matrix to generate a linear interpolation function and a nearest point interpolation function;

[0151] In this embodiment, the linear interpolation function is denoted as FLi(x, y), and the nearest point interpolation function is denoted as FNd(x, y).

[0152] Specifically, use the N-dimensional linear interpolator (LinearNDInterpolator) and N-dimensional nearest point interpolator (NearestNDInterpolator) modules of the Python scientific computing library (Python Scipy) to combine the 3D scatter point matrix to generate a linear interpolation function and a nearest point interpolation function of spatial coordinates (X, Y, Z).

[0153] S504. Perform spatial interpolation processing according to the linear interpolation function and the nearest point interpolation function, and assign the corresponding water body attributes, road network attributes, and building attributes to obtain 3D water body data, 3D road network data, and 3D building data.

[0154] Specifically, for buildings, use the OGR module of the Python GDAL library to read the polygon Pi representing the building's base surface one by one, obtain the X and Y coordinates of the centroid Ci of the polygon Pi, substitute them into the linear interpolation function to obtain the ground elevation ZCi corresponding to Ci. If the interpolation result of FLi(x, y) is "NAN", then use the nearest point interpolation function to obtain ZCi. Extract the vertex coordinate values (Xi, Yi) of the existing Pi, and use the Polygon function of the Python Shapely library to construct a three-dimensional polygon from the three-dimensional vertex coordinate values. The three-dimensional polygon vertex coordinate values are (Xi, Yi, ZCi);

[0155] For water networks and road networks, use the OGR module of the Python GDAL library to read the polygon Pi representing the building's base surface one by one, extract the vertex coordinate values (Xi, Yi) of the existing Pi, substitute them into the linear interpolation function to obtain the corresponding ground elevation Zi. If the interpolation result of FLi(x, y) is "NAN", then use the nearest point interpolation function to obtain Zi. Use the Polygon function of the Python Shapely library to construct a three-dimensional polygon from the three-dimensional vertex coordinate values. The three-dimensional polygon vertex coordinate values are (Xi, Yi, Zi);

[0156] Store the three-dimensional polygon data in a three-dimensional polygon database in the form of ESRI SHAPEFILE, with the attribute being a polygon collection with Z values (MultiPolygonZ) to obtain three-dimensional water body data, three-dimensional road network data, and three-dimensional building data.

[0157] The three-dimensional modeling processing method for pipe network data provided by the embodiments of the present application realizes the integration of multi-source data by reading multiple coordinate data in water body data, road network data, and building data, enabling different sources of geospatial data to be uniformly processed and analyzed within the same framework. It converts the original coordinate data into a three-dimensional scatter matrix, providing a basis for subsequent spatial interpolation processing, improving data utilization. Combining with the three-dimensional scatter matrix, linear interpolation functions and nearest point interpolation functions are generated. Through spatial interpolation processing, the accuracy and reliability of the interpolation results are ensured. In addition, according to the linear interpolation functions and nearest point interpolation functions, three-dimensional attributes are assigned to water body, road network, and building data, making the original data more three-dimensional and intuitive, facilitating subsequent three-dimensional analysis and visualization display, and achieving the effect of improving the reconstruction accuracy of pipe network data.

[0158] Figure 6 It is a flow schematic of the three-dimensional modeling processing method for pipe network data provided by the embodiments of the present application Figure 5 , as Figure 6 shown. Based on the above embodiments, this embodiment will elaborate on the generation process of the three-dimensional display interface, including:

[0159] S601. Read the three-dimensional coordinate data and corresponding attributes in the three-dimensional data of inspection wells, pipe segments, water bodies, road networks, and buildings.

[0160] Specifically, use the Python shapefile library to read the three-dimensional coordinate data and corresponding attributes in the three-dimensional data of inspection wells, pipe segments, water bodies, road networks, and buildings one by one.

[0161] S602. Obtain the pre-stored existing attribute information, where the existing attribute information includes the existing attribute information of inspection wells, the existing attribute information of pipe networks, the existing attribute information of water bodies, the existing attribute information of road networks, and the existing attribute information of buildings.

[0162] In this embodiment, the existing attribute information is stored in the form of a hash array.

[0163] Obtain the pre-stored existing attribute information of inspection wells, the existing attribute information of pipe networks, the existing attribute information of water bodies, the existing attribute information of road networks, and the existing attribute information of buildings.

[0164] S603. Determine the corresponding existing attribute information according to the corresponding attributes.

[0165] According to the attributes corresponding to the three-dimensional coordinate data in the three-dimensional data of inspection wells, pipe segments, water bodies, road networks, and buildings, respectively determine their respective corresponding existing attribute information.

[0166] S604. For the existing attribute information of inspection wells, assign the existing attribute information of inspection wells to the three-dimensional coordinate data in the three-dimensional data of inspection wells to generate a three-dimensional display interface corresponding to the inspection wells.

[0167] Specifically, Figure 7 This is a three-dimensional schematic diagram of the pipe network data provided by the embodiment of the present application, where Figure 7 a is a three-dimensional schematic diagram of an inspection well, the cylinder represents the inspection well, and the dotted line represents the interface grid of Python shapefile. Figure 7 b is a three-dimensional schematic diagram of a pipe segment, the polyhedron represents the three-dimensional pipe segment, and the dotted line represents the interface grid of Python shapefile. Figure 7 c is a three-dimensional schematic diagram of a building, the cube represents the three-dimensional building, and the dotted line represents the interface grid of Python shapefile. Figure 7 d is a three-dimensional schematic diagram of a water body and a road network, the blue curve represents the water body, the black solid line represents the road network, and the dotted line represents the interface grid of Python shapefile.

[0168] As Figure 7 shown in Fig. a, if the inspection well is a circular well, a cylinder with a diameter equal to the diameter of the inspection well, a height equal to the depth Hi of the inspection well, and a cylinder centroid at (Xi, Yi, Zi - Hi / 2) is generated; if the inspection well is a square well, a prism with a length and width equal to the length and width of the inspection well, a height equal to the depth Hi of the inspection well, and a cylinder centroid at (Xi, Yi, Zi - Hi / 2) is generated. The existing attributes of the inspection well stored in the ESRISHAPEFILE file are assigned to the newly created 3D inspection well using a Hash array, and the specific attribute values can be displayed in the Custom Properties of Blender by selecting the object.

[0169] It should be noted that Figure 7 Fig. a is only for reference of the display effect and is not an improvement point or the protection scope of the embodiments of the present application.

[0170] S605. For the existing attribute information of the pipe segment, according to quaternion operations, the existing attribute information of the pipe segment is assigned to the 3D coordinate data in the 3D data of the pipe segment to generate a 3D display interface corresponding to the pipe segment;

[0171] Specifically, as Figure 7 shown in Fig. b, the head and tail 3D coordinates (Xsi, Ysi, Zsi), (Xei, Yei, Zei) and related attributes of the 3D pipe segment are read one by one using Python shapefile. The centroid of the circular pipe / square pipe is ((Xsi + Xei) / 2, (Ysi + Yei) / 2, (Zsi + Zei) / 2), the length is the distance between the centroids, and the diameter / length and width are the corresponding diameter / length and width in the pipe segment attributes. The generated 3D pipe segment spatial direction is =(0, 0, 1). A vector pointing from the head to the tail (Xei - Xsi, Yei - Ysi, Zei - Zsi) is constructed using the Python mathutils library, and it is normalized to obtain a feature vector representing the pipe segment direction , and the quaternion qi from transformed to is calculated. The generated 3D pipe segment is flipped using qi, and the existing attributes of the pipe segment stored in the ESRI SHAPEFILE file are assigned to the newly created 3D pipe segment using a Hash array. The specific attribute values can be displayed in the Custom Properties of Blender by selecting the object.

[0172] It should be noted that Figure 7 Fig. b is only for reference of the display effect and is not an improvement point or the protection scope of the embodiments of the present application.

[0173] S606. For the existing building attribute information, endow the three-dimensional coordinate data in the three-dimensional building data with the existing building attribute information to generate a three-dimensional display interface corresponding to the building;

[0174] Specifically, as Figure 7 shown in c, use Python shapefile to read the three-dimensional coordinates (Xi, Yi, Zi) of the vertices of the three-dimensional polygon and related attributes one by one. Use the three-dimensional coordinates of the vertices to create a mesh processing (Bmesh) object in Blender to construct a three-dimensional polygon. Use the extrusion operation in Blender to extrude a prism along the z-axis direction. The height of the extruded prism is the height attribute in the original building polygon attribute. Use a Hash array to endow the existing building attributes stored in the ESRI SHAPEFILE file to the newly built three-dimensional building. The specific attribute values can be displayed in the Custom Properties of Blender by selecting the object.

[0175] It should be noted that Figure 7 c is only for reference of the display effect and is not an improvement point or the protection scope of the embodiments of the present application.

[0176] S607. For the existing water body attribute information and road network attribute information, endow the existing water body attribute information and road network attribute information to the three-dimensional coordinate data in the three-dimensional water body data and the three-dimensional coordinate data in the three-dimensional road network data respectively to generate three-dimensional display interfaces corresponding to the water body and the road network;

[0177] Specifically, as Figure 7 shown in d, use Python shapefile to read the three-dimensional coordinates (Xi, Yi, Zi) of the vertices of the three-dimensional polygon and related attributes one by one. Use the three-dimensional coordinates of the vertices to create a Bmesh object in Blend to construct a three-dimensional polygon, and use a Hash array to endow the existing water network / road network attributes stored in the ESRI SHAPEFILE file to the newly built three-dimensional water network / road network. The specific attribute values can be displayed in the Custom Properties of Blender by selecting the object.

[0178] It should be noted that Figure 7 d is only for reference of the display effect and is not an improvement point or the protection scope of the embodiments of the present application.

[0179] S608. In response to a stretching operation, obtain the stretching direction corresponding to the stretching operation;

[0180] When three-dimensional topological inspection of the pipe network is required, in response to the stretching operation of the operator, determine the stretching direction corresponding to the operation.

[0181] S609. Determine whether to reconstruct the ground plane according to the stretching direction, and determine the stretching method according to the judgment result;

[0182] Specifically, determine whether to reconstruct the ground plane according to the stretching direction; for those that do not require the smoothness of the ground plane, use the Delaunay module of the Python Scipy library to perform planar triangulation on the spatial scattered points, construct a triangular mesh, and then reconstruct the ground plane using the generated triangular mesh; for cases that require a smooth ground plane, use the Python Open3d library to perform Poisson surface reconstruction on the spatial scattered points, and screen the reconstructed points according to the density to eliminate extremely small points.

[0183] S610. Generate a stretching display interface according to the stretching method.

[0184] Specifically, for inspection wells, keep the X and Y coordinate axes of the inspection wells unchanged, stretch the Z coordinate according to the Z-axis scaling factor (Zscale), and at the same time stretch the depth of the inspection wells according to Zscale;

[0185] For pipe segments, keep the X and Y coordinate axes of the pipe segments unchanged, and stretch the Z coordinates at both ends of the pipe segment according to Zscale;

[0186] For buildings, keep the X and Y coordinate axes of the buildings unchanged, stretch the Z coordinate of the buildings according to Zscale, and keep the height of the buildings unchanged;

[0187] Generate a corresponding stretching display interface according to the above stretching method.

[0188] The 3D modeling processing method for pipe network data provided by the embodiments of the present application realizes the comprehensive integration of the 3D environment of a city or region by reading the 3D data of inspection wells, pipe segments, water bodies, road networks, and buildings. It not only improves the integrity and accuracy of the data but also provides a solid foundation for subsequent 3D display and interaction. By obtaining the pre-stored existing attribute information and storing it in the form of a hash array, the retrieval efficiency and accuracy of the attribute information are improved. At the same time, the system can respond to the stretching operation of the user, determine whether to reconstruct the ground plane according to the stretching direction, and then determine the stretching method, which not only improves the flexibility of the system operation but also improves the interactivity of the user interface. In addition, for the generation process of the 3D display interface of the pipe segment, combined with quaternion operations, the original cylinders and prisms that could only be generated vertically are flipped to the actual direction of the pipe network. Only two 3D points in space and the pipe segment diameter are required to generate the pipe segment, with fewer input parameters required and seamless access to the existing 2D pipe network data, which not only reduces the computational overhead but also improves the generation efficiency. Finally, by generating the stretching display interface according to the stretching method, the system can update the content and layout of the 3D display interface in real time, ensuring the accuracy and real-time nature of the display effect, and achieving the effect of improving the reconstruction accuracy of the pipe network data.

[0189] Figure 8 It is a schematic structural diagram of the 3D modeling processing device for pipe network data provided by the embodiments of the present application. The device in this embodiment can be in the form of software and / or hardware. As Figure 8 shown, the 3D modeling processing device 800 for pipe network data provided by the embodiments of the present application includes: a collection module 801, an acquisition module 802, a first processing module 803, a second processing module 804, a third processing module 805, and a generation module 806:

[0190] The collection module 801 is used to collect the pipe network data of the area to be processed, where the pipe network data includes inspection well data and pipe segment data;

[0191] The acquisition module 802 is used to acquire the area data of the area to be processed, where the area data includes water body data, road network data, and building data;

[0192] The first processing module 803 is used to perform the first 3D transformation processing on the inspection well data to obtain the 3D inspection well data;

[0193] The second processing module 804 is used to perform the second 3D transformation processing on the pipe segment data to obtain the 3D pipe segment data;

[0194] The third processing module 805 is used to perform the third 3D transformation processing on the water body data, road network data, and building data to obtain the 3D water body data, 3D road network data, and 3D building data;

[0195] A generation module 806, configured to generate a three-dimensional display interface according to the three-dimensional data of inspection wells, pipeline segments, water bodies, road networks, and buildings.

[0196] In a possible implementation manner, the acquisition module 801 is further configured to:

[0197] Inspection well data;

[0198] The inspection well data includes the administrative region name, component identification code, coordinates, category, name of the road where it is located, elevation of the natural manhole cover on the road surface, well depth, and bottom elevation of the well, and also includes multiple ones of features, materials, manhole cover shape, manhole cover size, and the drainage sub-region to which it belongs.

[0199] In a possible implementation manner, the acquisition module 801 is further configured to:

[0200] Pipeline segment data;

[0201] The pipeline segment data includes the administrative region name, component identification code, coordinates of the head, bottom elevation of the head, buried depth data of the head, coordinates of the tail, bottom elevation of the tail, and buried depth data of the tail, and also includes multiple ones of pipeline segment length, wall thickness, pipeline segment grade, pressure type, whether it is a pressure pipeline, name of the road where it is located, material, shape, size, and the drainage sub-region to which it belongs.

[0202] In a possible implementation manner, the first processing module 803 is further configured to:

[0203] Obtain the ground elevation data corresponding to the inspection well;

[0204] Use the inspection well data as the scatter data of the inspection well;

[0205] Assign the ground elevation data corresponding to the inspection well to the scatter data of the inspection well, and assign inspection well attributes.

[0206] In a possible implementation manner, the second processing module 804 is further configured to:

[0207] Read the pipeline segment data of each pipeline segment one by one, and use the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail to create a three-dimensional line segment, and assign pipeline segment attributes.

[0208] In a possible implementation manner, the water body data, road network data, and building data include multiple coordinate data. Correspondingly, the third processing module 805 is further configured to:

[0209] Read the multiple coordinate data in the water body data, road network data, and building data;

[0210] Determine the corresponding three-dimensional scatter matrix according to the multiple coordinate data;

[0211] Generate a linear interpolation function and a nearest - point interpolation function in combination with a three - dimensional scatter matrix;

[0212] Perform spatial interpolation processing according to the linear interpolation function and the nearest - point interpolation function, and assign corresponding water body attributes, road network attributes, and building attributes.

[0213] In a possible implementation manner, the generation module 806 is further configured to:

[0214] Read the three - dimensional coordinate data and corresponding attributes in the three - dimensional data of inspection wells, pipe segments, water bodies, road networks, and buildings;

[0215] Generate a three - dimensional display interface according to the three - dimensional coordinate data and the corresponding attributes.

[0216] In a possible implementation manner, the generation module 806 is further configured to:

[0217] Obtain pre - stored existing attribute information, where the existing attribute information includes existing attribute information of inspection wells, existing attribute information of pipe segments, existing attribute information of water bodies, existing attribute information of road networks, and existing attribute information of buildings, and the existing attribute information is stored in the form of a hash array;

[0218] Determine the corresponding existing attribute information according to the corresponding attributes;

[0219] Assign the existing attribute information to the three - dimensional coordinate data to generate a three - dimensional display interface.

[0220] In a possible implementation manner, the generation module 806 is further configured to:

[0221] For the existing attribute information of inspection wells, assign the existing attribute information of inspection wells to the three - dimensional coordinate data in the three - dimensional data of inspection wells to generate a corresponding three - dimensional display interface of inspection wells;

[0222] For the existing attribute information of pipe segments, according to quaternion operations, assign the existing attribute information of pipe segments to the three - dimensional coordinate data in the three - dimensional data of pipe segments to generate a corresponding three - dimensional display interface of pipe segments;

[0223] For the existing attribute information of buildings, assign the existing attribute information of buildings to the three - dimensional coordinate data in the three - dimensional data of buildings to generate a corresponding three - dimensional display interface of buildings;

[0224] For the existing attribute information of water bodies and road networks, assign the existing attribute information of water bodies and road networks to the three - dimensional coordinate data in the three - dimensional data of water bodies and the three - dimensional coordinate data in the three - dimensional data of road networks respectively to generate a corresponding three - dimensional display interface of water bodies and road networks.

[0225] In a possible implementation, the generation module 806 is further configured to:

[0226] In response to a stretching operation, obtain the stretching direction corresponding to the stretching operation;

[0227] Determine whether to reconstruct the ground plane according to the stretching direction;

[0228] Determine the stretching method according to the determination result;

[0229] Generate a stretching display interface according to the stretching method.

[0230] The three-dimensional modeling processing device for pipeline network data provided in this embodiment can execute the method provided in the above method embodiment, and its implementation principle and technical effect are similar, which will not be elaborated here in this embodiment.

[0231] Figure 9 It is a schematic structural diagram of the three-dimensional modeling processing device for pipeline network data provided by this application. As Figure 9 shown, the electronic device 900 provided in this embodiment includes: at least one processor 901 and a memory 902. Optionally, the device 900 further includes a communication component 903. Among them, the processor 901, the memory 902, and the communication component 903 are connected through a bus.

[0232] In a specific implementation process, at least one processor 901 executes the computer execution instructions stored in the memory 902, so that at least one processor 901 executes the above method.

[0233] The specific implementation process of the processor 901 can refer to the above method embodiment, and its implementation principle and technical effect are similar, which will not be elaborated here in this embodiment.

[0234] In the above embodiment, it should be understood that the processor may be a central processing unit (English: Central Processing Unit, abbreviated as: CPU), or other general-purpose processors, digital signal processors (English: Digital Signal Processor, abbreviated as: DSP), application specific integrated circuits (English: Application Specific Integrated Circuit, abbreviated as: ASIC), etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc. The steps of the method disclosed in combination with the invention can be directly embodied as being executed by a hardware processor, or executed by a combination of hardware and software modules in the processor.

[0235] The memory may include a random access memory (RAM), and may also include non-volatile memory (NVM), such as at least one disk memory.

[0236] The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, the buses in the drawings of this application are not limited to only one bus or one type of bus.

[0237] This application also provides a computer program product, including a computer program which, when executed by a processor, implements the above method.

[0238] This application also provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the above method.

[0239] The above-mentioned readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, a magnetic disk or an optical disc. The readable storage medium can be any available medium accessible by a general-purpose or special-purpose computer.

[0240] An exemplary readable storage medium is coupled to the processor, enabling the processor to read information from and write information to the readable storage medium. Of course, the readable storage medium can also be a component of the processor. The processor and the readable storage medium can be located in an application specific integrated circuit (ASIC). Of course, the processor and the readable storage medium can also exist as discrete components in a device.

[0241] The division of units is merely a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the couplings or direct couplings or communication connections shown or discussed among each other can be indirect couplings or communication connections through some interfaces, devices or units, and can be in electrical, mechanical or other forms.

[0242] The units described as separate components may or may not be physically separated. The components shown as units may or may not be physical units, that is, they can be located in one place, or can be distributed to multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0243] In addition, in each embodiment of the present invention, the functional units can be integrated in a processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit.

[0244] If the function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or part of this technical solution can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods in each embodiment of the present invention. And the aforementioned storage medium includes: USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks or optical discs and other various media that can store program codes.

[0245] Those of ordinary skill in the art can understand that all or part of the steps of implementing the above method embodiments can be completed by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps including the above method embodiments; and the aforementioned storage medium includes: ROM, RAM, magnetic disks or optical discs and other various media that can store program codes.

[0246] Finally, it should be noted that: After considering the specification and practicing the invention disclosed herein, those skilled in the art will readily think of other embodiments of the present invention. The present invention is intended to cover any variations, uses, or adaptations of the present invention, which follow the general principles of the present invention and include known common knowledge or conventional technical means in the technical field not disclosed in the present invention. It is not limited to the exact structures described above and shown in the drawings, and various modifications and changes can be made without departing from its scope. The scope of the present invention is only limited by the appended claims.

Claims

1. A three-dimensional modeling processing method for pipe network data, characterized in that Including: Collecting pipeline network data and area data of the area to be processed, where the pipeline network data includes inspection well data and pipe section data, and the area data includes water body data, road network data, and building data; the water body data, road network data, and building data include multiple coordinate data; Taking the inspection well data as the scatter point data of the inspection well; Using the built-in function of setting elevation value in Quantum Geographic Information System (QGIS), assigning the ground elevation data corresponding to the inspection well to the scatter point data of the inspection well, and assigning inspection well attributes to obtain inspection well three-dimensional data in the data format of ESRI SHAPEFILE and the attribute of three-dimensional point with measurement PointZM; Performing a second three-dimensional transformation process on the pipe section data to obtain pipe section three-dimensional data; Determining the corresponding three-dimensional scatter point matrix according to the multiple coordinate data; Generating a linear interpolation function and a nearest point interpolation function in combination with the three-dimensional scatter point matrix; For buildings, using the OGR module of the Python GDAL library to read the polygons representing the building bottom surface one by one, obtaining the coordinates of the centroid of the polygon, substituting them into the linear interpolation function to obtain the ground elevation corresponding to the centroid. If the interpolation result is "NAN", then use the nearest point interpolation function to obtain the ground elevation ZCi, extract the vertex coordinate values (Xi, Yi) of the existing polygon, and use the polygon function of the Python shape operation library to construct a three-dimensional polygon from the three-dimensional vertex coordinate values, and the three-dimensional polygon vertex coordinate values are (Xi, Yi, ZCi); For water networks and road networks, using the OGR module of the Python GDAL library to read the polygons representing the building bottom surface one by one, extracting the vertex coordinate values (Xi, Yi) of the existing polygon, substituting them into the linear interpolation function to obtain the corresponding ground elevation Zi. If the interpolation result is "NAN", then use the nearest point interpolation function to obtain Zi, and use the polygon function to construct a three-dimensional polygon from the three-dimensional vertex coordinate values, and the three-dimensional polygon vertex coordinate values are (Xi, Yi, Zi); Storing the three-dimensional polygon data into a three-dimensional polygon database to obtain water body three-dimensional data, road network three-dimensional data, and building three-dimensional data; Generating a three-dimensional display interface according to the inspection well three-dimensional data, the pipe section three-dimensional data, the water body three-dimensional data, the road network three-dimensional data, and the building three-dimensional data. Among them, the three-dimensional display interface of the pipe section is generated by assigning the existing attribute information corresponding to the pipe section to the three-dimensional coordinate data in the pipe section three-dimensional data according to quaternion operation; Also including: judging whether to reconstruct the ground plane according to the stretching direction corresponding to the stretching operation; determining the stretching method according to the judgment result; Stretching the Z coordinates of the inspection well, pipe section, and building according to the stretching method by the same Z-axis scaling factor to generate a stretching display interface.

2. The method according to claim 1, wherein The inspection well data includes administrative region name, component identification code, coordinates, category, name of the road where it is located, natural manhole cover road surface elevation, well depth, and bottom elevation of the well, and also includes multiple ones among features, materials, manhole cover shape, manhole cover size, and the drainage area to which it belongs.

3. The method according to claim 2, wherein The pipe segment data includes the administrative region name, component identification code, coordinates of the head, bottom elevation of the head, buried depth data of the head, coordinates of the tail, bottom elevation of the tail, and buried depth data of the tail, and also includes multiple of the pipe segment length, wall thickness, pipe segment grade, pressure type, whether it is a pressure pipe, name of the road where it is located, material, shape, size, and the drainage sub - area to which it belongs.

4. The method according to claim 3, wherein It further includes: Obtaining the ground elevation data corresponding to the inspection well.

5. The method according to claim 3, characterized in that, The second 3D transformation processing of the pipe segment data includes: Reading the pipe segment data of each pipe segment one by one, and creating a 3D line segment using the coordinates of the head, the coordinates of the tail, the bottom elevation of the head, and the bottom elevation of the tail, and assigning pipe segment attributes.

6. The method according to any one of claims 1 to 5, characterized in that, Generating a 3D display interface based on the inspection well 3D data, the pipe segment 3D data, the water body 3D data, the road network 3D data, and the building 3D data includes: Reading the 3D coordinate data and corresponding attributes in the inspection well 3D data, the pipe segment 3D data, the water body 3D data, the road network 3D data, and the building 3D data; Generating a 3D display interface based on the 3D coordinate data and corresponding attributes.

7. The method according to claim 1, wherein Generating a 3D display interface based on the 3D coordinate data and corresponding attributes includes: Obtaining pre - stored existing attribute information, where the existing attribute information includes existing inspection well attribute information, existing pipe segment attribute information, existing water body attribute information, existing road network attribute information, and existing building attribute information, and the existing attribute information is stored in the form of a hash array; Determining the corresponding existing attribute information according to the corresponding attributes; Assigning the existing attribute information to the 3D coordinate data to generate a 3D display interface.

8. The method according to claim 7, wherein Assigning the existing attribute information to the 3D coordinate data to generate a 3D display interface includes: For the existing inspection well attribute information, assigning the existing inspection well attribute information to the 3D coordinate data in the inspection well 3D data to generate the 3D display interface corresponding to the inspection well; For the existing pipe segment attribute information, according to quaternion operations, assigning the existing pipe segment attribute information to the 3D coordinate data in the pipe segment 3D data to generate the 3D display interface corresponding to the pipe segment; For the existing building attribute information, assigning the existing building attribute information to the 3D coordinate data in the building 3D data to generate the 3D display interface corresponding to the building; For the existing water body attribute information and the existing road network attribute information, assigning the existing water body attribute information and the existing road network attribute information to the 3D coordinate data in the water body 3D data and the 3D coordinate data in the road network 3D data respectively to generate the 3D display interface corresponding to the water body and the road network.

9. The method according to claim 1, wherein It further includes: Responding to a stretching operation, obtaining the stretching direction corresponding to the stretching operation.

10. A three-dimensional modeling processing device for pipeline network data, characterized in that, It includes: At least one processor; And A memory communicatively connected to the at least one processor; where, The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the three-dimensional modeling processing method for pipeline network data according to any one of claims 1 to 9.

11. A computer-readable storage medium, characterized in that, Computer-executable instructions are stored in the computer-readable storage medium, and when the computer-executable instructions are executed by a processor, they are used to implement the three-dimensional modeling processing method for pipeline network data according to any one of claims 1 to 9.

Images