An integrated cloud platform solution for pipe network detection services
By introducing an integrated cloud platform in the pipeline detection business, the pipeline data is collected and processed in real time, the inefficiency and data inefficiency caused by the separation of external and internal industries is solved, and the complete range from data collection to results output is achieved The process integration generates a real and intuitive three-dimensional pipeline model.
Patent Information
- Application Number
- CN202311028293.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-08-15
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2043-08-15
AI Technical Summary
In the existing pipeline detection technology, the data collection and sorting process of the external and internal industries are separated, resulting in large workload, low efficiency and difficult to ensure the timeliness of data. The real integration of the entire process has not been achieved, and the results are not formed. Contains three-dimensional model.
Provide an integrated cloud platform for pipeline network detection services. By integrating the data acquisition end on a specific pipeline detector, the spatial information and attribute information of the pipe points are collected in real time, and the data is uploaded to the cloud in real time, and the management end is used for sorting. , inspect, repair and generate three-dimensional pipeline models to realize integrated operations from data collection to results output.
The integrated operation of the entire process of the pipeline business is realized, data collection and processing efficiency is improved, and the generated three-dimensional model makes the pipeline data more realistic and intuitive, avoiding data loss and simplifying the collaborative workflow of both internal and external industries.
Smart Images

Figure CN117094672B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of pipe network detection, and in particular to an integrated cloud platform solution for pipe network detection services. Background Art
[0002] The main technology of pipeline detection business is the collection, editing and mapping of pipeline attribute information. At present, the operation mode of pipeline network data collection is mostly separated into indoor and outdoor work. In the outdoor work, the location of underground pipelines is determined by pipeline detectors, the spatial coordinates of pipeline points are recorded by RTK and other measuring equipment, and then the pipeline attribute information is recorded by sketches. In the indoor work, the information collected in the outdoor work is manually entered and a plan is generated. This operation mode requires operators to collect data in the outdoor work during the day and organize it in the indoor work at night. The workload is large, the efficiency is low, and it is difficult to ensure the timeliness of the data.
[0003] A Chinese patent with announcement number CN202110943412.9 discloses an integrated management method for urban underground pipelines. This patent generates pipeline attribute data after editing the three-dimensional attributes, spatial attributes, and flow attributes of the detected pipeline data. The correctness of the pipeline attribute data is then checked. If an error occurs in the pipeline attribute data, the data is repaired. The pipeline data is divided into a pipe point data file and a pipeline data file. The pipe point data file and the pipeline data file are processed using the MDL function to generate a pipeline graphic file. The pipeline graphic file is output to generate an electronic drawing or a paper drawing.
[0004] "Zhang Zhiwei, Yi Pengjun, Zhao Ye. An integrated method for indoor and outdoor pipeline detection based on ArcSDE [J]. Beijing Surveying and Mapping, 2021, 35(07): 986-990" provides an integrated indoor and outdoor measurement method for pipeline detection. The method first uses the mobile terminal pipeline network data acquisition platform to collect various attribute information of the pipeline in real time and upload it to the cloud database, and uses real-time kinematic measurement (RTK) and total station polar coordinate measurement methods to collect spatial information of wells, sieves and other points. The indoor work uses the principle of matching points with the same name to match spatial information with attribute information. Then, the data in the database is visualized and analyzed and checked and corrected on the desktop pipeline network data management platform. Finally, the final result map and database data are exported.
[0005] After analysis, we know that:
[0006] The technical solution described in the Chinese patent "CN202110943412.9 A method for integrated management of urban underground pipelines" is to edit and inspect the pipeline data collected in the field, repair the problematic data, generate graphic files, and export the results. This solution does not involve the content of field collection of pipeline data, but only optimizes the content of internal editing and mapping.
[0007] "Zhang Zhiwei, Yi Pengjun, Zhao Ye. An integrated method for pipeline detection based on ArcSDE [J]. Beijing Surveying and Mapping, 2021, 35(07): 986-990". Although the technical solution described above optimizes and integrates the collection, attribute editing and mapping of pipeline data, the solution still requires the internal industry to match the spatial information of the pipeline with the attribute information based on the principle of matching points with the same name. True full-process integration has not been achieved. Moreover, the results formed in this solution are tables or two-dimensional drawings, and do not include the three-dimensional model results of the pipeline network.
[0008] Therefore, an integrated cloud platform solution for pipeline network detection business is proposed. Summary of the invention
[0009] The present invention aims to solve the problems raised in the background technology and provides an integrated cloud platform solution for pipeline detection business. After creating a pipeline project, a data acquisition terminal that can be integrated on a specific pipeline detector is used to simultaneously complete the spatial information collection of pipe points such as wells and grates and the attribute information collection of pipelines. The collected data will be uploaded to the cloud in real time, and then the desktop management terminal will be used to organize, check, analyze and repair the collected data, generate vector graphics and three-dimensional pipeline models, and finally export the required results graphics or model data, truly realizing the full-process integrated operation of "project management-data collection-warehousing-inspection-drawing-review-modeling-visualization-results export" for pipeline business.
[0010] The specific technical solutions are as follows:
[0011] An integrated cloud platform solution for pipe network detection business, using the pipe network detection business cloud platform for pipe network detection business from data collection to results output, specifically including the following steps:
[0012] S1. Create a pipe network project and user role:
[0013] There are two ways to create a project: ① Push project, ② Custom project;
[0014] There are three types of user role creation: ① unit administrator, ② project leader, and ③ ordinary user;
[0015] S2. Pipeline network data collection:
[0016] After the creation of the pipeline network project and user roles, the spatial information and attribute information of the pipeline are uniformly collected using the data collection terminal integrated on the specific pipeline detector, and the real coordinates of the pipe points are obtained in real time, without the need to collect the spatial information and attribute information of the pipe points separately and then match them together;
[0017] S3, upload to the cloud:
[0018] After the data collector completes the collection of pipeline network data, the data can be uploaded to the cloud with one click to prevent accidental deletion or loss of data. At the same time, data synchronization is achieved, which facilitates the simultaneous work of internal and external work and improves work efficiency.
[0019] S4. Data inspection and modification:
[0020] Use the management terminal to perform basic checks on the incoming data, spatial attribute rationality checks, standardization checks, detection attribute rationality checks, illegal value checks, and collision checks, and then modify the data accordingly based on the error list;
[0021] S5. Automatic modeling:
[0022] Use the 3D modeling function of the management end to build a 3D pipeline model with the modified data;
[0023] S6. Output:
[0024] Export results according to project needs, support export of tables, floor plans and 3D model data including .xls, .mdb, .shp, .dxf and 3dtile. Export can be classified by pipeline type or combined.
[0025] The above-mentioned integrated cloud platform solution for pipe network detection business includes:
[0026] The method of pushing projects is as follows: after the unit administrator creates a project, it is pushed to the project leader, who then creates tasks and pushes them to ordinary users;
[0027] The way to customize projects is: ordinary users directly create projects and tasks;
[0028] When creating a project in the above two ways, both of them set the management type and field information based on the actual needs of the project.
[0029] The above-mentioned integrated cloud platform solution for pipeline network detection business, wherein: the specific pipeline detector includes a transmitting end, a receiving end and a mobile end, the receiving end is communicatively connected to the transmitting end, and the mobile end is communicatively connected to the receiving end.
[0030] The above-mentioned integrated cloud platform solution for pipe network detection business, wherein: the transmitting end includes a signal generating module, a signal processing module 1, a power amplifying module, a transmitting module and a power supply module 1;
[0031] The receiving end includes a signal receiving module, a second signal processing module, a GNSS signal receiving module, a GNSS signal processing module, a button module and a second power supply module;
[0032] The mobile terminal includes a display, a data storage module and a power module.
[0033] The above-mentioned integrated cloud platform solution for the pipeline network detection business, wherein: the signal generating module of the transmitting end is used to form a signal, and the signal is amplified by the signal processing module 1 and sent to the transmitting module. At the same time, the power amplification module amplifies the output power of the transmitting module, and then the signal is transmitted to the underground pipeline through the transmitting module. The power supply module 1 provides power support for the entire transmitting end;
[0034] The signal receiving module of the receiving end receives the signal generated by the underground pipeline, and converts the signal into a digital signal through the signal processing module 2. At the same time, the GNSS signal receiving module receives the satellite signal, and the positioning is accurate to the centimeter level through the GNSS signal processing module. The power supply module provides power support for the entire receiving end, and the key module supports basic operations on the receiving end;
[0035] The mobile terminal integrates a pipeline collection APP to perform data collection operations. The display is used to view the precise coordinates of the current position, signal strength, and specific information on data collection conditions. The data storage module is used to store data information. The power module three provides power support for the entire mobile terminal.
[0036] The above-mentioned integrated cloud platform solution for the pipe network detection business, wherein: the overall architecture of the pipe network detection business cloud platform includes a user layer, an application layer, a data layer and a basic layer, wherein:
[0037] The user layer is divided into system administrators, unit administrators, project leaders, and collectors according to user functions. The user interaction interface is divided into browser and mobile terminals according to the type of terminal device.
[0038] The system administrator is responsible for enterprise certification approval, user management, enterprise management, authority allocation, equipment management, role management, etc. through the management page;
[0039] The unit administrator: creates a new unit project, assigns a project leader, and sends message notifications through the management page;
[0040] The project leader: completes operations such as creating new projects, confirming project leaders, inviting project members, dividing tasks, assigning tasks, merging tasks, and setting collection fields through the mobile APP or management page;
[0041] The project data collectors: collect and edit the data of pipe points, pipelines, accessories, etc. on the field through mobile terminals (mobile phones, PADs), and upload them to the cloud platform;
[0042] The application layer is the core layer for system function calls, which calls the functions of other services in the same layer, realizes the functions that need to be completed by multiple services, and provides a unified interface for the interface module to call. The other services include: adding pipe point service, adding pipe network service, system operation and maintenance management service, tool service, project management service, task management service, data management service, message notification service, identity authentication service, automatic modeling service and 3D visualization service, among which:
[0043] The adding pipe point service is used to collect underground pipe point and pipeline data through a mobile terminal;
[0044] The pipe network adding service is used to quickly copy, insert and delete underground pipe network data through the mobile terminal;
[0045] The system operation and maintenance management service is used to meet the daily operation and maintenance needs of the system, including user management, enterprise management, role management, menu management, device management, password modification, operation logs, etc.;
[0046] The tool service is used to provide distance measurement, area measurement, query, statistics and other services;
[0047] The project management service is used to provide maintenance services such as adding, querying, modifying, and deleting pipeline network projects;
[0048] The task management service is used to provide maintenance services such as adding, querying, modifying, deleting, and merging tasks for the field team;
[0049] The data management service is used to provide management point and pipeline data editing and maintenance, data inspection, and results export services;
[0050] The message notification service is used for notification and confirmation of project leader assignment, project leader confirmation, project member invitation and task assignment;
[0051] The identity authentication service is used to confirm the identity of the user;
[0052] The automatic modeling service is used to realize automatic modeling of pipeline point and pipeline data collected in the field;
[0053] The three-dimensional visualization service is used to perform three-dimensional visualization query, statistics, special analysis and display of the data after the three-dimensional pipe network model is built;
[0054] The data layer is mainly responsible for building inter-system communication services, including field acquisition database, underground pipe network database, project database, business database, model database, symbol library, multimedia database, and is responsible for the background communication service HttpServer to publish web pages and build the Webservice mobile backend interface;
[0055] The field acquisition database is mainly used for local storage on the mobile terminal, including the pipeline points, pipeline space and attribute data detected on site;
[0056] The underground pipe network database is mainly used for cloud storage, including pipe points, pipeline space and attribute data detected on site;
[0057] The project database is used to store project-level related data, such as project information, project collection field information, and project configuration information;
[0058] The business database is used to store device information, user information, authority allocation information, operation log information, enterprise authentication information, etc.
[0059] The symbol library is used to store symbols of various features and accessories of pipe points;
[0060] The model library is used to store pipe point features, accessories, and pipe models;
[0061] The multimedia database is used to store field photo data.
[0062] Basic layer: system hardware layer, using hardware support such as rented public cloud servers.
[0063] The cloud server: includes cloud host, cloud storage, firewall, cloud security and other services;
[0064] The mobile Internet mainly includes 4G, 5G, and Ethernet, and the Ethernet includes wired broadband and wireless WIFI.
[0065] The above-mentioned integrated cloud platform solution for pipe network detection business, wherein: the data inspection and modification function of the pipe network detection business cloud platform includes two major parts: database inspection and collision inspection, which mainly inspect the integrity, standardization, rationality, etc. of pipe network data. After the inspection, non-conforming items will be presented in a list for users to check and modify one by one. Each inspection condition can be adjusted or added through system settings according to project requirements;
[0066] (1) Database inspection, including basic inspection, spatial attribute rationality inspection, standardization inspection, detection attribute rationality inspection, and illegal value inspection;
[0067] Basic inspection is to check the integrity and repeatability of data, such as: measurement point number is empty, point table lacks coordinates, starting point number or end point number is empty, line table lacks point attributes, point table has multiple points, line table has duplicate lines, etc.;
[0068] Spatial attribute rationality check is to check the rationality of the spatial relationship of pipeline data, such as: buried depth, buried depth difference, ground elevation, pipeline elevation, pipeline length, same point position, drainage pipeline elevation, pipeline exposure, drainage large diameter into small diameter, etc. According to the specification or experience, the range of pipeline buried depth, elevation, length and other values is set to check whether the data is within the reasonable value range. It also checks the same point number (all pipelines except drainage) as the starting point or end point of different pipelines, and the corresponding buried depth and elevation are different.
[0069] Normative inspection is to check whether the pipeline data meets the standards by comparing with the standard specifications. For example, check the correspondence between material and cross-section size, well attributes, empty pipe conditions, pipe point connection direction, well depth, etc.
[0070] The detection attribute rationality check is to check the logical rationality between the attributes of some pipeline data, such as attribute relationship, diameter change, material change, depth change, and direction line check;
[0071] Illegal value check is to check whether the data format meets the design specifications, such as: node direction value, point illegal value, line illegal value, surface, rack pipeline burial depth inspection, hidden through point inspection;
[0072] (2) Collision check: Check two vertically intersecting pipelines to determine whether a collision occurs. If (elevation of pipeline 1 at the intersection - elevation of pipeline 2 at the intersection) > (pipeline 1 diameter / 2 + pipeline 2 diameter / 2), then the pipelines have not collided. Otherwise, a collision occurs.
[0073] The above-mentioned integrated cloud platform solution for the pipeline network detection business, wherein: the specific method of establishing a three-dimensional pipeline model with the modified data is as follows:
[0074] (1) Establish a pipe point model library and material library;
[0075] (2) Read the starting and ending coordinates, diameter, thickness, material and other parameters of the pipeline to calculate the length and inner and outer diameters of the pipeline. Use Boolean operators to create a pipeline model, and then calculate the length of the connector through the starting coordinates, direction, diameter, thickness and other parameters of the adjacent pipelines. Then create a Bezier curve, set the point position, radius and handle of the Bezier curve to make the connector transition smooth, set the chamfer depth and resolution of the curve, and apply the set material to the model. Read the manhole cover shape, size, well neck, well chamber, material and other parameters, import the pipe point model in the model library to the specified position, and finally export the model file in glb format;
[0076] (3) Convert the glb format model file into b3dm format;
[0077] (4) According to the JSON specification of 3dtile, write the location information and path of the b3dm format file, generate the corresponding 3dtiels.json file, and complete the automatic modeling work.
[0078] The present invention has the following beneficial effects:
[0079] 1. The integrated cloud platform solution for the pipe network detection business provided by the present invention, after creating a pipe network project, uses a data acquisition terminal that can be integrated on a specific pipeline detector to simultaneously complete the spatial information collection of pipe points such as wells and grates and the attribute information collection of pipelines. The collected data will be uploaded to the cloud in real time, and then the desktop management terminal will be used to organize, inspect, analyze and repair the collected data, generate vector graphics and three-dimensional pipe network models, and finally export the required results graphics or model data. Truly realize the full process integrated operation of "project management-data collection-warehousing-inspection-drawing-review-modeling-visualization-results export" for the pipe network business;
[0080] 2. The integrated cloud platform solution for the pipe network detection business provided by the present invention utilizes a data acquisition terminal that can be integrated on a specific pipeline detector to simultaneously collect spatial information and attribute information of the pipe network data. It is not necessary to separately collect the spatial information and attribute information of the pipe network and then match them separately. The collected data is uploaded to the cloud platform in real time, which prevents data loss and facilitates indoor and outdoor personnel to carry out work at the same time, thereby improving work efficiency. It is not necessary to export the data after the outdoor work is completed and then process it indoors, and the three-dimensional model data of the pipe network can be generated.
[0081] 3. The integrated cloud platform solution for pipeline detection business provided by the present invention has established a full-process integrated cloud platform solution for pipeline detection business from data collection to results output. This solution optimizes the traditional pipeline detection operation process, eliminates the process of matching spatial information with attribute information, improves data accuracy and operation efficiency, and the resulting three-dimensional model of the pipeline network makes the pipeline data more realistic and intuitive. BRIEF DESCRIPTION OF THE DRAWINGS
[0082] Figure 1 A flow chart of an integrated cloud platform solution for pipe network detection services provided by an embodiment of the present invention;
[0083] Figure 2 A schematic diagram of the architecture of a pipe network detection service cloud platform provided in an embodiment of the present invention;
[0084] Figure 3 A schematic diagram of the architecture of a specific pipeline detector provided in an embodiment of the present invention. DETAILED DESCRIPTION
[0085] The technical solution of the present invention is further described below with reference to the accompanying drawings and through specific implementation methods.
[0086] Among them, the drawings are only used for illustrative explanations, and they only represent schematic diagrams rather than actual pictures, and should not be understood as limitations on this patent; in order to better illustrate the embodiments of the present invention, some parts of the drawings may be omitted, enlarged or reduced, and do not represent the size of the actual product; for those skilled in the art, it is understandable that some well-known structures and their descriptions in the drawings may be omitted.
[0087] The same or similar numbers in the drawings of the embodiments of the present invention correspond to the same or similar parts; in the description of the present invention, it should be understood that if the terms "upper", "lower", "left", "right", "inner", "outer", etc. appear, the orientation or position relationship indicated is based on the orientation or position relationship shown in the drawings, which is only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation. Therefore, the terms describing the position relationship in the drawings are only used for illustrative purposes and cannot be understood as a limitation on this patent. For ordinary technicians in this field, the specific meanings of the above terms can be understood according to specific circumstances.
[0088] In the description of the present invention, unless otherwise clearly specified and limited, if the term "connection" or the like appears to indicate the connection relationship between components, the term should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, it can be the internal connection of two components or the interaction relationship between two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.
[0089] Example
[0090] The integrated cloud platform solution for pipe network detection services provided in this embodiment is as follows: Figure 1 As shown in the figure, the pipe network detection business cloud platform is used to collect data from the pipe network detection business to output the results, which specifically includes the following steps:
[0091] S1. Create a pipe network project and user role:
[0092] There are two ways to create a project: ① Push project, ② Custom project;
[0093] There are three types of user role creation: ① unit administrator, ② project leader, and ③ ordinary user;
[0094] S2. Pipeline network data collection:
[0095] After the creation of the pipeline network project and user roles, the spatial information and attribute information of the pipeline are uniformly collected using the data collection terminal integrated on the specific pipeline detector, and the real coordinates of the pipe points are obtained in real time, without the need to collect the spatial information and attribute information of the pipe points separately and then match them together;
[0096] S3, upload to the cloud:
[0097] After the data collector completes the collection of pipeline network data, the data can be uploaded to the cloud with one click to prevent accidental deletion or loss of data. At the same time, data synchronization is achieved, which facilitates the simultaneous work of internal and external work and improves work efficiency.
[0098] S4. Data inspection and modification:
[0099] Use the management terminal to perform basic checks on the incoming data, spatial attribute rationality checks, standardization checks, detection attribute rationality checks, illegal value checks, and collision checks, and then modify the data accordingly based on the error list;
[0100] S5. Automatic modeling:
[0101] Use the 3D modeling function of the management end to build a 3D pipeline model with the modified data;
[0102] S6. Output:
[0103] Export results according to project needs, support export of tables, floor plans and 3D model data including .xls, .mdb, .shp, .dxf and 3dtile. Export can be classified by pipeline type or combined.
[0104] Specifically, in this embodiment:
[0105] The method of pushing projects is as follows: after the unit administrator creates a project, it is pushed to the project leader, who then creates tasks and pushes them to ordinary users;
[0106] The way to customize projects is: ordinary users directly create projects and tasks;
[0107] When creating a project in the above two ways, both of them set the management type and field information based on the actual needs of the project.
[0108] Specifically, Figure 3 As shown, in this embodiment: the specific pipeline detector includes a transmitting end, a receiving end and a mobile end, the receiving end is communicatively connected to the transmitting end, and the mobile end is communicatively connected to the receiving end.
[0109] The transmitting end includes a signal generating module, a signal processing module 1, a power amplifying module, a transmitting module and a power supply module 1;
[0110] The receiving end includes a signal receiving module, a signal processing module 2, a GNSS signal receiving module, a GNSS signal processing module, a button module and a power module 2;
[0111] The mobile terminal includes a display, a data storage module and a power module.
[0112] The signal generation module at the transmitting end is used to form a signal, which is amplified by the signal processing module 1 and sent to the transmitting module. At the same time, the power amplifier module amplifies the output power of the transmitting module, and then the signal is transmitted to the underground pipeline through the transmitting module. The power supply module 1 provides power support for the entire transmitting end.
[0113] The signal receiving module at the receiving end receives the signal generated by the underground pipeline, and converts the signal into a digital signal through the signal processing module 2. At the same time, the GNSS signal receiving module receives the satellite signal, and the positioning is accurate to the centimeter level through the GNSS signal processing module. The power module provides power support for the entire receiving end, and the button module supports basic operations on the receiving end.
[0114] The mobile terminal integrates pipeline collection APP to perform data collection operations. The display is used to view the precise coordinates of the current position, signal strength, and specific information on data collection conditions. The data storage module is used to store data information, and power module three provides power support for the entire mobile terminal.
[0115] Specifically, in this embodiment, the overall architecture of the pipe network detection service cloud platform includes a user layer, an application layer, a data layer, and a basic layer, wherein:
[0116] User layer: divided into system administrators, unit administrators, project leaders, and collectors according to user functions. The user interaction interface is divided into browser and mobile terminals according to the type of terminal device.
[0117] System administrator: responsible for enterprise authentication approval, user management, enterprise management, authority allocation, equipment management, role management, etc. through the management page;
[0118] Unit administrator: Create new unit projects, assign project leaders, and send message notifications through the management page;
[0119] Project leader: Complete operations such as creating new projects, confirming project leaders, inviting project members, dividing tasks, assigning tasks, merging tasks, and setting collection fields through the mobile APP or management page;
[0120] Project data collectors: collect and edit the data of pipe points, pipelines, accessories, etc. on the field through mobile terminals (mobile phones, PADs), and upload them to the cloud platform;
[0121] Application layer: the core layer for system function calls, calling the functions of other services in the same layer, realizing functions that require multiple services to complete together, and providing a unified interface for interface modules to call. Other services include: adding pipe point service, adding pipe network service, system operation and maintenance management service, tool service, project management service, task management service, data management service, message notification service, identity authentication service, automatic modeling service and 3D visualization service, among which:
[0122] The Add Pipeline Point Service is used to collect underground pipe point and pipeline data through the mobile terminal;
[0123] Add pipe network service to quickly copy, insert and delete underground pipe network data through mobile terminal;
[0124] System operation and maintenance management services are used to meet the daily operation and maintenance needs of the system, including user management, enterprise management, role management, menu management, device management, password modification, operation logs, etc.
[0125] Tool services are used to provide distance measurement, area measurement, query, statistics and other services;
[0126] Project management services are used to provide maintenance services such as adding, querying, modifying, and deleting pipeline network projects;
[0127] Task management service is used to provide maintenance services such as adding, querying, modifying, deleting and merging tasks for field teams;
[0128] Data management services are used to provide data editing and maintenance of pipeline points and pipelines, data inspection, and results export services;
[0129] Message notification service is used for notification and confirmation of project leader assignment, project leader confirmation, project member invitation and task assignment;
[0130] Identity authentication service is used to confirm user identity;
[0131] Automatic modeling service is used to realize automatic modeling of pipeline point and pipeline data collected in the field;
[0132] The 3D visualization service is used to perform 3D visualization query, statistics, thematic analysis and display of the data after the 3D pipe network model is built;
[0133] The data layer is mainly responsible for building inter-system communication services, including communication services for field acquisition database, underground pipe network database, project database, business database, model database, symbol library, and multimedia database, as well as the background communication service HttpServer to publish web pages and build the Webservice mobile backend interface;
[0134] Field acquisition database: mainly used for local storage on mobile terminals, including pipeline points, pipeline space and attribute data detected on site;
[0135] Underground pipe network database: mainly used for cloud storage, including pipe points, pipeline space and attribute data detected on site;
[0136] Project database: used to store project-level related data, such as project information, project collection field information, and project configuration information;
[0137] Business database: used to store device information, user information, permission allocation information, operation log information, enterprise authentication information, etc.
[0138] Symbol library: used to store symbols of various features and accessories of pipe points;
[0139] Model library: used to store pipe point features, accessories, and pipeline models;
[0140] Multimedia database: used to store field photo data.
[0141] Basic layer: system hardware layer, using hardware support such as rented public cloud servers.
[0142] Cloud server: including cloud host, cloud storage, firewall, cloud security and other services;
[0143] Mobile Internet: mainly includes 4G, 5G, and Ethernet. Ethernet includes wired broadband and wireless WIFI.
[0144] Specifically, in this embodiment, the data inspection and modification function of the pipe network detection business cloud platform includes two parts: database inspection and collision inspection, which mainly inspect the integrity, standardization, rationality, etc. of the pipe network data. After the inspection is completed, the non-conforming items will be presented in a list for users to check and modify one by one. Each inspection condition can be adjusted or added through system settings according to project requirements;
[0145] (1) Database inspection, including basic inspection, spatial attribute rationality inspection, standardization inspection, detection attribute rationality inspection, and illegal value inspection;
[0146] Basic inspection is to check the integrity and repeatability of data, such as: measurement point number is empty, point table lacks coordinates, starting point number or end point number is empty, line table lacks point attributes, point table has multiple points, line table has duplicate lines, etc.;
[0147] Spatial attribute rationality check is to check the rationality of the spatial relationship of pipeline data, such as: buried depth, buried depth difference, ground elevation, pipeline elevation, pipeline length, same point position, drainage pipeline elevation, pipeline exposure, drainage large diameter into small diameter, etc. According to the specification or experience, the range of pipeline buried depth, elevation, length and other values is set to check whether the data is within the reasonable value range. It also checks the same point number (all pipelines except drainage) as the starting point or end point of different pipelines, and the corresponding buried depth and elevation are different.
[0148] Normative inspection is to check whether the pipeline data meets the standards by comparing with the standard specifications. For example, check the correspondence between material and cross-section size, well attributes, empty pipe conditions, pipe point connection direction, well depth, etc.
[0149] The detection attribute rationality check is to check the logical rationality between the attributes of some pipeline data, such as attribute relationship, diameter change, material change, depth change, and direction line check;
[0150] Illegal value check is to check whether the data format meets the design specifications, such as: node direction value, point illegal value, line illegal value, surface, rack pipeline burial depth inspection, hidden through point inspection;
[0151] (2) Collision check: Check two vertically intersecting pipelines to determine whether a collision occurs. If (elevation of pipeline 1 at the intersection - elevation of pipeline 2 at the intersection) > (pipeline 1 diameter / 2 + pipeline 2 diameter / 2), then the pipelines have not collided. Otherwise, a collision occurs.
[0152] Specifically, in this embodiment, the specific method of establishing a three-dimensional pipeline model using the modified data is as follows:
[0153] (1) Establish a pipe point model library and material library;
[0154] (2) Read the starting and ending coordinates, diameter, thickness, material and other parameters of the pipeline to calculate the length and inner and outer diameters of the pipeline. Use Boolean operators to create a pipeline model, and then calculate the length of the connector through the starting coordinates, direction, diameter, thickness and other parameters of the adjacent pipelines. Then create a Bezier curve, set the point position, radius and handle of the Bezier curve to make the connector transition smooth, set the chamfer depth and resolution of the curve, and apply the set material to the model. Read the manhole cover shape, size, well neck, well chamber, material and other parameters, import the pipe point model in the model library to the specified position, and finally export the model file in glb format;
[0155] (3) Convert the glb format model file into b3dm format;
[0156] (4) According to the JSON specification of 3dtile, write the location information and path of the b3dm format file, generate the corresponding 3dtiels.json file, and complete the automatic modeling work.
[0157] In summary, the integrated cloud platform solution for the pipe network detection service provided by this embodiment has the following advantages:
[0158] 1. The integrated cloud platform solution for the pipe network detection business provided by the present invention, after creating a pipe network project, uses a data acquisition terminal that can be integrated on a specific pipeline detector to simultaneously complete the spatial information collection of pipe points such as wells and grates and the attribute information collection of pipelines. The collected data will be uploaded to the cloud in real time, and then the desktop management terminal will be used to organize, inspect, analyze and repair the collected data, generate vector graphics and three-dimensional pipe network models, and finally export the required results graphics or model data. Truly realize the full process integrated operation of "project management-data collection-warehousing-inspection-drawing-review-modeling-visualization-results export" for the pipe network business;
[0159] 2. The integrated cloud platform solution for the pipe network detection business provided by the present invention utilizes a data acquisition terminal that can be integrated on a specific pipeline detector to simultaneously collect the spatial information and attribute information of the pipe network data. There is no need to separately collect the spatial information and attribute information of the pipe network and then match them separately. The collected data is uploaded to the cloud platform in real time, which prevents data loss and facilitates the work of indoor and outdoor personnel at the same time. There is no need to export the data after the field work is completed and then process it indoors, so that the three-dimensional model data of the pipe network can be generated.
[0160] 3. The integrated cloud platform solution for pipeline detection business provided by the present invention has established a full-process integrated cloud platform solution for pipeline detection business from data collection to results output. This solution optimizes the traditional pipeline detection operation process, eliminates the process of matching spatial information with attribute information, improves data accuracy and operation efficiency, and the resulting three-dimensional model of the pipeline network makes the pipeline data more realistic and intuitive.
[0161] The above are only preferred embodiments of the present invention, and are not intended to limit the implementation methods and protection scope of the present invention. Those skilled in the art should be aware that all solutions obtained by equivalent substitutions and obvious changes made using the description and illustrations of the present invention should be included in the protection scope of the present invention.
Claims
1. An integrated cloud platform solution for pipe network detection services, characterized in that: The pipe network detection business cloud platform is used to collect data from the pipe network detection business to output the results, which specifically includes the following steps: S1. Create a pipe network project and user role: There are two ways to create a project: ① Push project, ② Custom project; There are three types of user role creation: ① unit administrator, ② project leader, and ③ ordinary user; S2. Pipeline network data collection: After the creation of the pipeline network project and user roles, the spatial information and attribute information of the pipeline are uniformly collected using the data collection terminal integrated on the specific pipeline detector, and the real coordinates of the pipe points are obtained in real time, without the need to collect the spatial information and attribute information of the pipe points separately and then match them together; S3, upload to the cloud: After the data collector completes the collection of pipeline network data, the data is uploaded to the cloud with one click to prevent accidental deletion or loss of data. At the same time, data synchronization is achieved, which facilitates the simultaneous work of internal and external work and improves work efficiency. S4. Data inspection and modification: Use the management terminal to perform basic checks on the incoming data, spatial attribute rationality checks, standardization checks, detection attribute rationality checks, illegal value checks, and collision checks, and then modify the data accordingly based on the error list; S5. Automatic modeling: Use the 3D modeling function of the management end to build a 3D pipeline model with the modified data; S6. Output: Export results according to project needs, support exporting tables, floor plans and 3D model data including .xls, .mdb, .shp, .dxf and 3dtile, and can be exported by pipeline type or combined; The method of pushing projects is as follows: after the unit administrator creates a project, it is pushed to the project leader, who then creates tasks and pushes them to ordinary users; The way to customize projects is: ordinary users directly create projects and tasks; When creating a project in the above two ways, both of them set the management type and field information based on the actual needs of the project; The specific pipeline detector comprises a transmitting end, a receiving end and a mobile end, wherein the receiving end is communicatively connected to the transmitting end, and the mobile end is communicatively connected to the receiving end; The transmitting end includes a signal generating module, a signal processing module 1, a power amplifying module, a transmitting module and a power supply module 1; The receiving end includes a signal receiving module, a second signal processing module, a GNSS signal receiving module, a GNSS signal processing module, a button module and a second power supply module; The mobile terminal includes a display, a data storage module and a power module three; The signal generating module of the transmitting end is used to form a signal, which is amplified by the signal processing module 1 and sent to the transmitting module. At the same time, the power amplifying module amplifies the output power of the transmitting module, and then the signal is transmitted to the underground pipeline through the transmitting module. The power supply module 1 provides power support for the entire transmitting end; The signal receiving module of the receiving end receives the signal generated by the underground pipeline, and converts the signal into a digital signal through the signal processing module 2. At the same time, the GNSS signal receiving module receives the satellite signal, and the positioning is accurate to the centimeter level through the GNSS signal processing module. The power supply module provides power support for the entire receiving end, and the key module supports basic operations on the receiving end; The mobile terminal integrates pipeline collection APP to perform data collection operations. The display is used to view the precise coordinates of the current position, signal strength, and specific information about data collection conditions. The data storage module is used to store data information. The power module 3 provides power support for the entire mobile terminal. The overall architecture of the pipe network detection business cloud platform includes a user layer, an application layer, a data layer, and a basic layer, among which: User layer: divided into system administrators, unit administrators, project leaders, and collectors according to user functions. The user interaction interface is divided into browser and mobile terminals according to the terminal device type. System administrator: responsible for enterprise certification approval, user management, enterprise management, authority allocation, equipment management, and role management through the management page; Unit administrator: Create new unit projects, assign project leaders, and send message notifications through the management page; Project leader: Create new projects, confirm project leaders, invite project members, divide tasks, assign tasks, merge tasks, and set collection fields through the mobile APP or management page; Project data collectors: collect and edit the data of points, pipelines, and accessories on site through mobile terminals, and upload them to the cloud platform; Application layer: the core layer for system function calls, calling the functions of other services in the same layer, realizing functions that require multiple services to complete together, and providing a unified interface for interface modules to call. Other services include: adding pipe point service, adding pipe network service, system operation and maintenance management service, tool service, project management service, task management service, data management service, message notification service, identity authentication service, automatic modeling service and 3D visualization service, among which: The Add Pipeline Point Service is used to collect underground pipe point and pipeline data through the mobile terminal; Add pipe network service to quickly copy, insert and delete underground pipe network data through mobile terminal; System operation and maintenance management services are used to meet the daily operation and maintenance needs of the system, including user management, enterprise management, role management, menu management, device management, password modification, and operation logs; Tool services are used to provide distance measurement, area measurement, query, and statistical services; Project management services are used to provide pipeline network project addition, query, modification, deletion and maintenance services; Task management service is used to provide field team task addition, query, modification, deletion, merging and maintenance services; Data management services are used to provide data editing and maintenance of pipeline points and pipelines, data inspection, and results export services; Message notification service is used for project leader assignment, project leader confirmation, project member invitation, and task assignment message notification and confirmation; Identity authentication service is used to confirm user identity; Automatic modeling service is used to realize automatic modeling of pipeline point and pipeline data collected in the field; The 3D visualization service is used to perform 3D visualization query, statistics, thematic analysis and display of the data after the 3D pipe network model is built; The data layer is responsible for building inter-system communication services, including communication services for field acquisition database, underground pipe network database, project database, business database, model database, symbol library, and multimedia database, as well as the background communication service HttpServer to publish web pages and build the Webservice mobile backend interface; The field acquisition database is used for local storage on the mobile terminal, including the pipeline points, pipeline space and attribute data detected on site; The underground pipe network database is used for cloud storage, including the pipe points, pipeline space and attribute data detected on site; The project database is used to store project-level related data, including project information, project collection field information, and project configuration information; The business database is used to store device information, user information, permission allocation information, operation log information, and enterprise authentication information; The symbol library is used to store symbols of various features and accessories of pipe points; The model library is used to store pipe point features, accessories, and pipeline models; The multimedia database is used to store field photo data; The base layer is used for the system hardware layer; Cloud servers include cloud hosts, cloud storage, firewalls, and cloud security services; Mobile Internet includes 4G, 5G, and Ethernet. Ethernet includes wired broadband and wireless WIFI. The data inspection and modification function of the pipe network detection business cloud platform includes two parts: database inspection and collision inspection. The integrity, standardization and rationality of the pipe network data are inspected. After the inspection, the non-conforming items will be presented in a list for users to check and modify one by one. Each inspection condition can be adjusted or added through system settings according to project requirements; (1) Database inspection, including basic inspection, spatial attribute rationality inspection, standardization inspection, detection attribute rationality inspection, and illegal value inspection; The basic check is to check the completeness and duplication of the data; The rationality check of spatial attributes is to check the rationality of the spatial relationship of pipeline data; Normative inspection is to check whether the pipeline data conforms to the specifications by comparing with the standard specifications; The detection attribute rationality check is to check the logical rationality between some attributes of pipeline data; Illegal value checking is to check whether the data format complies with the design specifications; (2) Collision check: check two vertically intersecting pipelines to determine whether a collision occurs. If (elevation of pipeline 1 at the intersection - elevation of pipeline 2 at the intersection) > (pipeline 1 diameter / 2 + pipeline 2 diameter / 2), then the pipelines do not collide; otherwise, a collision occurs. The specific method of establishing a three-dimensional pipeline model with the modified data is as follows: (1) Establish a pipe point model library and material library; (2) Read the starting and ending coordinates, diameter, thickness, and material parameters of the pipeline, calculate the length and inner and outer diameters of the pipeline, use Boolean operators to create a pipeline model, and then calculate the length of the connector through the starting coordinates, direction, diameter, and thickness parameters of the adjacent pipelines. Then create a Bezier curve, set the point position, radius, and handle of the Bezier curve to make the connector transition smooth, set the chamfer depth and resolution of the curve, and apply the set material to the model. Read the shape, size, well neck, well chamber, and material parameters of the manhole cover, import the pipe point model in the model library to the specified position, and finally export the model file in glb format; (3) Convert the glb format model file into b3dm format; (4) According to the JSON specification of 3dtile, write the location information and path of the b3dm format file, generate the corresponding 3dtiels.json file, and complete the automatic modeling work.
Citation Information
Cited By
Investigation data real-time synchronous storage method for indoor and outdoor work integration
CN121935260A
A method for real-time synchronization and database entry of survey data for integrated field and office work.
CN121935260B
