A method for managing data in a pipe jacking construction process

Abstract

The application relates to a method for managing data in a pipe jacking engineering construction process, adopts a pipe jacking engineering construction process data management system composed of a WEB system, a data summary processing module, a data viewing module, a visual report control, a mobile terminal, a SQL Server database, a data pushing service, a PLC collection system and an environment monitoring system, and comprises the following steps: 1) presetting basic information; 2) acquiring external data; 3) a data center: all data are stored in the SQL Server database, external data are connected and analyzed, an independent data table is established, and data support is provided for the management system; 4) jacking data calculation; 5) jacking data analysis; 6) pipe joint information calculation; 7) soil layer data positioning; 8) daily report layout; and 9) data pushing. The application can be used for managing data generated in a pipe jacking construction process, can be improved according to requirements, can be infinitely expanded, and can be connected with different external data.

Description

Technical Field

[0001] This invention relates to the field of pipe jacking engineering, and in particular to a method for collecting, summarizing, analyzing and statistically processing construction process data. Background Technology

[0002] With the advancement of technology, the construction equipment for pipe jacking projects has become highly automated, but the management methods are still relatively outdated and have not fully kept pace with the rapid development of information technology. Based on the experience gained from various projects, the following issues have been identified:

[0003] First, much data recording still relies on paper records, leading to issues with data accuracy, backup, and historical traceability. Second, as projects become increasingly complex, multiple units or subcontractors often collaborate, resulting in a lack of data interoperability and difficulties in data sharing. Third, data from some equipment or instruments can only be viewed on-site, leading to poor data readability and hindering timely delivery to back-office personnel.

[0004] Due to the highly technical nature of much of the data, analysis and judgment require experienced professionals. However, the sheer volume, complexity, and isolation of the data make it difficult for on-site personnel to provide timely and accurate feedback, and for support staff to maintain a firm grasp of the situation. Therefore, this presents a safety hazard for project management, necessitating effective solutions and improvements. Summary of the Invention

[0005] The purpose of this invention is to provide a method for data management in the construction process of pipe jacking projects, which uses information technology to manage various types of data in the construction process in a refined manner, and improves the viewing and readability of the data, thereby solving the problems encountered in current projects.

[0006] To achieve the above objectives, the technical solution of the present invention is: a method for managing data during the construction process of pipe jacking engineering, employing a data management system for the construction process of pipe jacking engineering composed of a web system, a data aggregation and processing module, a data viewing module, a visual report control, a mobile terminal, an SQL Server database, a data push service, a PLC acquisition system, and an environmental monitoring system. The method specifically includes:

[0007] 1) Basic information preset: basic information of the project and pipe jacking route, pipe jacking equipment information, information collected in real time by the PLC acquisition system and data push service, pipe jacking joint configuration information, soil layer information, and relevant parameter warning values;

[0008] 2) External data acquisition methods:

[0009] (1) The system provides a WebAPI interface to receive data pushed from external sources;

[0010] (2) The system calls external interfaces to actively read some public data: weather and temperature;

[0011] (3) The system provides an EXCEL file import function for third parties to upload offline data;

[0012] 3) Data Center: Store all data in a unified SQL Server database, connect to and analyze external data, create independent data tables, and provide data support for the management system;

[0013] 4) Calculation of jacking data:

[0014] (1) Based on the data collected by the PLC acquisition system, the real-time jacking mileage, acquisition time, operator login account, and real-time oil pressure collected by the pipe jacking equipment are used to automatically calculate the working hours of each shift.

[0015] (2) Based on the real-time jacking mileage, collection time, cutter head speed and oil pressure, the jacking time record of the pipe jacking equipment is automatically calculated according to the specific threshold of cutter head speed and oil pressure and the continuous running time.

[0016] 5) Jacking data analysis: The daily jacking distance is compared with relevant parameters such as horizontal deviation, elevation deviation, jacking force, and friction resistance. Data visualization technology is used to form charts, and warning lines are drawn according to the alarm values ​​of specific parameters, so that the data can be viewed and compared more intuitively. Due to the huge amount of real-time operating data of the equipment, the system takes the maximum value of each parameter in every 10 meters for comparison.

[0017] 6) Pipe section information calculation: Based on the pre-entered pipe jacking joint configuration information, calculate the total number of various types of pipe sections used at the current jacking distance, and then compare it with the daily and cumulative number of various types of pipe sections entering the site;

[0018] 7) Soil layer data positioning: The pre-entered SVG jacking route soil layer information map is proportionally converted to the total jacking distance, and then the current soil layer is located according to the actual jacking distance;

[0019] 8) Daily Report Layout: The content of the construction daily report is mainly divided into three categories: charts, tables and attachment previews. The layout of the daily report is based on HTML5 technology, so that the daily report can be viewed on PC and mobile devices in an adaptive manner.

[0020] 9) Data push: Based on WeChat's open interface, push data results to WeChat for viewing.

[0021] The beneficial effects of this invention are:

[0022] This invention can be used to manage data generated during pipe jacking construction. It can be infinitely expanded to meet evolving needs, connecting with various external data sources. It unifies and aggregates all types of data generated during construction, using reasonable, accurate, and scientific methods to calculate, analyze, and statistically analyze the data required by project personnel. The data is then presented in a visual format, making it more readable and easier to understand. Simultaneously, the results are pushed to all relevant personnel, ensuring that all stakeholders can promptly and specifically understand the daily progress of the project. Attached Figure Description

[0023] Figure 1 This is a flowchart of the pipe jacking construction process management system of the present invention. Detailed Implementation

[0024] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0025] Example: Figure 1 As shown, a method for data management during the construction process of pipe jacking projects is presented. The data management system comprises a web system, a data aggregation and processing module, a data viewing module, a visual report control, a mobile terminal, an SQL Server database, a PLC acquisition system, and an environmental monitoring system. The specific steps of this method are as follows:

[0026] Step 1: During the construction preparation phase, relevant construction information, equipment information, personnel information, soil layer information, pipe section information, warning values, etc., are entered into the WEB system.

[0027] The second step, during the construction preparation phase, involves data integration with various subcontractors and external systems, and adjustments to relevant interfaces and data tables. External data primarily includes data from automatic measurements, environmental monitoring, and public weather information.

[0028] Step 3: Since the PLC acquisition system used has relatively simple functions, during the construction preparation phase, relevant software services are deployed at the construction site to monitor and capture data from each node in the PLC acquisition system in real time and push it to the system database.

[0029] Step 4: Determine the list of recipients for the daily construction report. Message recipients can access the corresponding mini-application on WeChat and associate their WeChat account or DingTalk account with the system through OAuth 2.0 authorization.

[0030] Step 5: During the construction process, data from all parties will be aggregated into this system, which will automatically calculate, statistically analyze, summarize, and interpret the required results using algorithms.

[0031] Step 6: You can fill in relevant logs and upload image attachments in the system daily as needed.

[0032] Step 7: The system can generate daily construction reports using HTML5 and visualization technology, either on a scheduled basis or manually.

[0033] Step 8: The system can automatically or manually push the daily construction report to the mobile devices of designated personnel for viewing, according to the configuration scheme.

[0034] The above description is merely a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A method for managing data of a pipe jacking construction process, characterized in that: The pipe jacking construction process data management system is composed of a WEB system, a data aggregation processing module, a data viewing module, a visual report control, a mobile terminal, a SQL Server database, a data pushing service, a PLC acquisition system, and an environmental monitoring system. 1) Basic information preset: project and pipe jacking line basic information, pipe jacking equipment information, information and data pushed by the PLC acquisition system, pipe jacking joint configuration information, soil layer information, and related parameter warning values; 2) External data acquisition method: (1) The system provides a WebAPI interface to receive externally pushed data; (2) The system calls external interfaces to actively read some public data: weather, temperature; 3) Data center: all data are stored in a SQL Server database, and external data are connected and analyzed, an independent data table is established, and data support is provided for the management system; 4) Jacking data calculation: (1) According to the PLC acquisition system acquisition data, the real-time jacking distance, acquisition time, operator login account, and real-time oil pressure collected by the pipe jacking equipment are used to automatically calculate the morning and evening shift work time records of each team; (2) According to the real-time jacking distance, acquisition time, cutter head speed and oil pressure, the jacking time record of the pipe jacking equipment is automatically calculated according to the specific threshold value and continuous running time of the cutter head speed and oil pressure; 5) Jacking data analysis: compare the daily jacking distance with the horizontal deviation, elevation deviation, jacking force, and friction force related parameters, use data visualization technology to form charts, and according to the alarm value of the specific parameter, pull out the warning line, so that the data can be more directly viewed and compared; due to the real-time running data of the equipment, the data volume is huge, and the system compares the maximum value of each parameter every 10 meters; 6) Pipe joint information calculation: according to the pre-recorded pipe joint configuration information, the total number of each type of pipe joint at the current jacking distance is calculated, and then compared with the daily and cumulative arrival number of each type of pipe joint; 7) Soil layer data positioning: the pre-recorded SVG jacking route soil layer information map is proportionally converted with the jacking distance, and then positioned to the current soil layer according to the actual jacking distance; 8) Daily report layout: the construction daily report content is mainly divided into three categories: charts, tables, and attachment previews, and the daily report is laid out based on HTML5 technology, so that the daily report can be viewed on PC and mobile terminals; 9) Data pushing: based on the open interface of WeChat, the data results are pushed to WeChat for viewing.

2. The method of pipe jacking construction process data management according to claim 1, characterized in that: In step 2), the system provides an EXCEL file import function for third-party offline data upload.

Images