Monitoring data processing method, device and electronic equipment

Abstract

The present invention proposes a monitoring data processing method, device and electronic device, wherein the method comprises: obtaining pile body horizontal displacement monitoring data at the monitoring point position, wherein the pile body horizontal displacement monitoring data is used to indicate the pile body horizontal displacement corresponding to the buried depth of each set distance interval of at least one pile body, and realizing, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determining the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and generating a pile body model corresponding to each pile body according to the pile body horizontal displacement monitoring data, so as to determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body for any pile body, and displaying the ratio on the pile body model corresponding to the pile body. Since the ratio between the pile body horizontal displacement and the displacement alarm value can be displayed on the pile body model, the difficulty of understanding the pile body horizontal displacement monitoring data is effectively reduced.

Description

Technical Field

[0001] The present invention relates to the intersection of computer-aided design and construction monitoring, and in particular to a monitoring data processing method, device and electronic equipment. Background Art

[0002] For foundation pit projects, the deformation of retaining piles as retaining structures is particularly important for the stability of the foundation pit. The horizontal displacement monitoring of piles provides a basis for evaluating the stability of the foundation pit by measuring the overall horizontal displacement deformation of the piles. The quality of the work will directly affect the safety, cost and quality of the project.

[0003] In related technologies, monitoring results data can only be expressed in digital form, which is not intuitive enough. It is difficult for workers who have not received professional training to understand the data. At the same time, the alarm values ​​of monitoring data are uniformly set according to the specifications, making it difficult to make segmented judgments based on the depth of the foundation pit, support, etc., and to achieve refined management. Summary of the invention

[0004] The present invention aims to solve one of the technical problems in the related art at least to a certain extent.

[0005] To this end, the first purpose of the present invention is to propose a monitoring data processing method to display the ratio between the horizontal displacement of the pile body and the displacement alarm value on the pile body model, thereby reducing the difficulty of understanding the horizontal displacement monitoring data of the pile body. At the same time, since the displacement alarm value is determined based on the set displacement alarm value calculation rule of the pile body segment, the user is provided with the function of independently setting the alarm value, which can carry out more refined management and control of construction safety issues.

[0006] The second objective of the present invention is to provide a monitoring data processing device.

[0007] A third objective of the present invention is to provide an electronic device.

[0008] A fourth object of the present invention is to provide a computer-readable storage medium.

[0009] A fifth object of the present invention is to provide a computer program product.

[0010] To achieve the above object, a first embodiment of the present invention provides a monitoring data processing method, comprising:

[0011] Acquire pile horizontal displacement monitoring data at the monitoring point; wherein the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of at least one pile at each set interval;

[0012] For any of the pile bodies, according to the displacement alarm value calculation rule of the pile body segments, the displacement alarm value corresponding to the buried depth of each set distance of the pile body is determined;

[0013] Generating a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data;

[0014] For any of the pile bodies, the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body is determined, and the ratio is displayed on the pile body model corresponding to the pile body.

[0015] To achieve the above object, a second embodiment of the present invention provides a monitoring data processing device, comprising:

[0016] An acquisition module is used to acquire pile horizontal displacement monitoring data at the monitoring point location; wherein the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of at least one pile at each set interval;

[0017] A determination module, for determining, for any of the pile bodies, a displacement alarm value corresponding to a buried depth of each set distance of the pile body according to a displacement alarm value calculation rule of the pile body segment;

[0018] A generating module, used for generating a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data;

[0019] The processing module is used to determine, for any of the pile bodies, the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and display the ratio on the pile body model corresponding to the pile body.

[0020] To achieve the above-mentioned purpose, the third aspect of the present invention proposes an electronic device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the monitoring data processing method of the first aspect mentioned above.

[0021] In order to achieve the above-mentioned purpose, a fourth aspect of the present invention proposes a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable the computer to execute the monitoring data processing method of the first aspect.

[0022] In order to achieve the above-mentioned purpose, a fifth aspect of the present invention proposes a computer program product, including a computer program, which implements the monitoring data processing method of the first aspect when executed by a processor.

[0023] The technical solution provided by the embodiment of the present invention has the following beneficial effects:

[0024] By acquiring the monitoring data of the pile body horizontal displacement at the monitoring point position, wherein the monitoring data of the pile body horizontal displacement is used to indicate the pile body horizontal displacement corresponding to the buried depth of each set distance interval of at least one pile body, it is realized that for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body is determined, and according to the pile body horizontal displacement monitoring data, the pile body model corresponding to each pile body is generated, so that for any pile body, the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body is determined, and the ratio is displayed on the pile body model corresponding to the pile body. Since the ratio between the pile body horizontal displacement and the displacement alarm value can be displayed on the pile body model, the difficulty of understanding the monitoring data of the pile body horizontal displacement is effectively reduced. At the same time, since the displacement alarm value is determined based on the displacement alarm value calculation rule of the set pile body segment, the user is provided with the function of independently setting the alarm value, which can carry out more refined control of the safety issues of the construction.

[0025] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0027] Figure 1 A flow chart of a monitoring data processing method provided by an embodiment of the present invention;

[0028] Figure 2 A flowchart of another monitoring data processing method provided by an embodiment of the present invention;

[0029] Figure 3 A flowchart of another monitoring data processing method provided by an embodiment of the present invention;

[0030] Figure 4 A rendering of a ratio in a scenario provided by an embodiment of the present invention is displayed in the form of a rainbow diagram on a pile model corresponding to the pile;

[0031] Figure 5A flowchart of another monitoring data processing method provided by an embodiment of the present invention;

[0032] Figure 6 A flowchart of a monitoring data processing method in a scenario provided by an embodiment of the present invention;

[0033] Figure 7 A schematic diagram of a pile horizontal displacement monitoring result file in a scenario provided by an embodiment of the present invention;

[0034] Figure 8 A schematic diagram of a page for a user to set displacement alarm value expressions for each segment of a pile body in a scenario provided by an embodiment of the present invention;

[0035] Fig. 9 A schematic diagram of the structure of a monitoring data processing device provided by an embodiment of the present invention;

[0036] Fig.10 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0037] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present invention, and should not be construed as limiting the present invention.

[0038] In related technologies, the monitoring of pile horizontal displacement provides a basis for evaluating the stability of foundation pits by measuring the overall horizontal displacement deformation of the pile body. However, this process has the following technical problems:

[0039] 1. The results of pile horizontal displacement monitoring are expressed in digital form, which is not intuitive enough and it is difficult for people without professional training to understand the data;

[0040] 2. The monitoring of pile horizontal displacement has the characteristics of long cycle (usually up to one or two years or even longer) and large amount of data (the monitoring frequency is once a day in most time periods during the monitoring cycle, and 2 to 4 times a day in special periods). The traditional data storage and expression form is inconvenient to view and compare;

[0041] 3. The traditional form of pile horizontal displacement report is paper report, which is not convenient for the coordination of different disciplines;

[0042] 4. In the traditional working mode, the alarm value of pile horizontal displacement adopts a unified value according to the specification, which cannot achieve refined management of the project.

[0043] In response to the above problems, an embodiment of the present invention provides a monitoring data processing method to display the ratio between the horizontal displacement of the pile body and the displacement alarm value on the pile body model, thereby reducing the difficulty of understanding the horizontal displacement monitoring data of the pile body. At the same time, since the displacement alarm value is determined based on the set displacement alarm value calculation rule of the pile body segment, the user is provided with the function of independently setting the alarm value, which can carry out more refined management and control of construction safety issues.

[0044] The monitoring data processing method, device and electronic device according to the embodiments of the present invention are described below with reference to the accompanying drawings.

[0045] Figure 1 A flowchart of a monitoring data processing method provided by an embodiment of the present invention.

[0046] like Figure 1 As shown, the monitoring data processing method includes the following steps:

[0047] Step 101, obtaining pile horizontal displacement monitoring data at the monitoring point location.

[0048] The monitoring point position may be any monitoring position set artificially, which is not limited in this embodiment.

[0049] The monitoring data of pile horizontal displacement is used to indicate the pile horizontal displacement corresponding to the buried depth of each set distance of at least one pile. The setting of the set distance is not limited in the embodiment of the present invention. Optionally, the set distance can be set according to manual experience, for example, the set distance can be set to 0.5 meters, or the set distance can be dynamically adjusted according to actual application requirements, which is not limited in this embodiment.

[0050] That is to say, for any pile body, the monitoring data of pile body horizontal displacement consists of the buried depths at set intervals and the pile body horizontal displacements corresponding to each buried depth. That is, each pile body has a buried depth at each set interval, and each buried depth has a corresponding pile body horizontal displacement. For example, assuming the set distance is 0.5 meters, the monitoring data of pile body horizontal displacement is shown in Table 1:

[0051] Table 1 Example of pile horizontal displacement monitoring data

[0052]

[0053] It should be noted that the piles indicated by the pile horizontal displacement monitoring data have been completed, that is, the burial work has also been completed. The pile horizontal displacement monitoring data is only the monitoring data obtained by monitoring the corresponding horizontal displacement of the piles at each set interval of the buried depth of the buried piles. For example, in the above Table 1, the pile horizontal displacement corresponding to the burial depth of 0.0 meters is the horizontal displacement of the buried piles on the ground surface, and the pile horizontal displacement corresponding to the burial depth of 0.5 meters is the horizontal displacement of the buried piles at 0.5 meters from the ground surface.

[0054] In some embodiments, the pile body horizontal displacement monitoring data at the monitoring point location can be obtained in various public, legal, and compliant ways. For example, the pile body horizontal displacement monitoring data at the monitoring point location can be collected in real time, or the pile body horizontal displacement monitoring data at the monitoring point location can be obtained from other devices (such as monitoring instruments) that store the pile body horizontal displacement monitoring data at the monitoring point location through network transmission or physical copying, or the pile body horizontal displacement monitoring data at the monitoring point location can be obtained in other public, legal, and compliant ways, which is not limited in this embodiment.

[0055] Step 102, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance of the pile body.

[0056] Among them, the pile body segmentation can be any segmentation set artificially based on the burial depth of the interval setting distance. For example, assuming that the burial depth of the interval setting distance is 0.0 meter, 0.5 meter, 1.0 meter, 1.5 meter, 2.0 meter, ..., then the pile body segmentation can be 0.0-1.5 meter, 1.5-2.5 meter, ..., or 0.0-0.5 meter, 0.5-3.0 meter, ..., etc., which is not limited in this embodiment.

[0057] The displacement alarm value calculation rule may be any form of calculation rule, such as a function expression, an algorithm, etc., which is not limited in this embodiment.

[0058] As a possible implementation, the displacement alarm value calculation rule may be a displacement alarm value expression, and the displacement alarm value expression corresponds to a set pile segment, wherein the pile segment is determined based on the buried depth of the segment starting point and the buried depth of the segment end point.

[0059] In some embodiments, for any pile body, the displacement alarm value corresponding to each set distance interval of the pile body can be determined according to the displacement alarm value calculation rule of the pile body segment. For example, assuming that the burial depth is represented by x, the displacement alarm value is represented by y, and the displacement alarm calculation rule is a function expression of y with respect to x, then the displacement alarm value y corresponding to each burial depth x of the pile body can be determined according to the function expression of y with respect to x for each pile body segment.

[0060] Step 103: Generate a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data.

[0061] The pile model is used to truly reflect the position status of the buried pile.

[0062] In some embodiments, since the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to each set interval of burial depth of at least one pile, a pile model corresponding to each pile can be generated according to the pile horizontal displacement monitoring data.

[0063] As a possible implementation method, the pile body horizontal displacement monitoring data includes the serial number corresponding to each pile body, which can be obtained by obtaining at least one selected initial pile body model, wherein the initial pile body model is selected based on the pile body at the monitoring point position, and any initial pile body model has a corresponding pile body number, so as to determine the matching relationship between each pile body and each initial pile body model according to the serial number corresponding to each pile body and the pile body number of each initial pile body model, so as to add the pile body horizontal displacement corresponding to the burial depth of each pile body at each set interval to the matching initial pile body model according to the matching relationship between each pile body and each initial pile body model, and obtain the pile body model corresponding to each pile body.

[0064] Step 104, for any pile body, determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and display the ratio on the pile body model corresponding to the pile body.

[0065] In some embodiments, after obtaining the horizontal displacement of the pile body corresponding to the buried depth of each pile body at each set distance interval and the displacement alarm value corresponding to the buried depth of each pile body at each set distance interval at the monitoring point location, the ratio between the horizontal displacement of the pile body corresponding to the buried depth of each pile body at each set distance interval and the displacement alarm value corresponding to the buried depth of each pile body at each set distance interval can be determined for any pile body, and the ratio can be displayed on the pile body model corresponding to the generated pile body.

[0066] It should be noted that the number of ratios between the pile horizontal displacement corresponding to the buried depth per set distance interval of the pile body and the displacement alarm value corresponding to the buried depth per set distance interval of the pile body is consistent with the number of buried depths of the pile body. Since each pile body has a buried depth per set distance interval, the number of buried depths of the pile body is at least two, and thus the number of determined ratios is also at least two.

[0067] Among them, there are many ways to display the ratio on the pile model corresponding to the pile body, such as rainbow chart, line chart, data table, text, etc., which are not limited in this embodiment. But no matter which display method is used, it is necessary to enable workers who have not received professional training to easily understand the monitoring results. For example, the rainbow chart can show the changes in the horizontal displacement of the pile body through color contrast, the line chart can show the changes in the horizontal displacement of the pile body through the tortuous changes of the lines, and the data table can be combined with text to show the changes in the horizontal displacement of the pile body with simple and straightforward data and text explanations. These display methods are intuitive displays of the monitoring results, which can make the management, viewing, and comparison of data easier.

[0068] The monitoring data processing method provided in this embodiment obtains the monitoring data of the pile body horizontal displacement at the monitoring point position, wherein the monitoring data of the pile body horizontal displacement is used to indicate the pile body horizontal displacement corresponding to the buried depth of each set distance interval of at least one pile body, so as to achieve, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and generate the pile body model corresponding to each pile body according to the pile body horizontal displacement monitoring data, so as to determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body for any pile body, and display the ratio on the pile body model corresponding to the pile body. Since the ratio between the pile body horizontal displacement and the displacement alarm value can be displayed on the pile body model, the difficulty of understanding the monitoring data of the pile body horizontal displacement is effectively reduced. At the same time, since the displacement alarm value is determined based on the displacement alarm value calculation rule of the set pile body segment, the function of autonomously setting the alarm value is provided for the user, so that the safety issues of the construction can be more finely controlled.

[0069] It can be seen from the above analysis that in the present invention, the pile model corresponding to each pile body can be generated according to the pile body horizontal displacement monitoring data. In order to clearly explain this process, this embodiment provides another monitoring data processing method. Figure 2 A schematic flow chart of another monitoring data processing method provided by an embodiment of the present invention.

[0070] like Figure 2 As shown, the monitoring data processing method may include the following steps:

[0071] Step 201, obtaining pile horizontal displacement monitoring data at the monitoring point location.

[0072] Step 202, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance of the pile body.

[0073] Step 203: obtaining at least one selected initial pile model.

[0074] The initial pile model is selected based on the pile at the monitoring point, and any initial pile model has a corresponding pile number.

[0075] As a possible implementation manner, the obtained selected at least one initial pile model may be a pile model corresponding to the pile at the monitoring point location selected by the user in computer-aided design software (such as MicroStation).

[0076] Step 204: for any sub-file, compare the serial number corresponding to the target pile body in the sub-file with the pile body serial number of each initial pile body model.

[0077] It should be noted that, in the present embodiment, the pile body horizontal displacement monitoring data includes the serial number corresponding to each pile body, and the pile body horizontal displacement monitoring data is stored in the target file, and the target file includes at least one sub-file, and any sub-file is used to indicate the pile body horizontal displacement corresponding to the burial depth of any pile body at each set interval.

[0078] Since any sub-file is used to indicate the horizontal displacement of the pile body corresponding to the buried depth of each set distance of any pile body, for any sub-file, the number corresponding to the target pile body in the sub-file can be compared with the pile body number of each initial pile body model to determine the target initial pile body model that matches the target pile body in the sub-file.

[0079] Step 205 , when the number corresponding to the target pile body in the subfile is consistent with the pile body number of the target initial pile body model, it is determined that there is a matching relationship between the target pile body in the subfile and the target initial pile body model.

[0080] Optionally, for any sub-file, after comparing the serial number corresponding to the target pile body in the sub-file with the pile body serial number of each initial pile body model, it can be determined that there is a matching relationship between the target pile body in the sub-file and the target initial pile body model when the serial number corresponding to the target pile body in the sub-file is consistent with the pile body serial number of the target initial pile body model. The target initial pile body model can be an initial pile body model whose serial number is the same as the serial number corresponding to the target pile body in the sub-file among the at least one selected initial pile body model.

[0081] Step 206, according to the matching relationship between the target pile body and the target initial pile body model in any sub-file, the file path of the sub-file is added to the target initial pile body model, and the pile body horizontal displacement corresponding to the burial depth of the target pile body at each set interval indicated by the sub-file is read and added to the target initial pile body model to obtain the pile body model corresponding to the target pile body.

[0082] In this embodiment, in order to save resources, the pile body horizontal displacement corresponding to the buried depth of each set distance of the target pile body indicated by the subfile can be read according to the path link and added to the matching initial pile body model. Specifically, according to the matching relationship between the target pile body and the target initial pile body model in any subfile, the file path of the subfile can be added to the target initial pile body model, so that the pile body horizontal displacement corresponding to the buried depth of each set distance of the target pile body indicated by the subfile can be read according to the file path of the subfile and added to the target initial pile body model to obtain the pile body model corresponding to the target pile body.

[0083] Step 207, for any pile body, determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and display the ratio on the pile body model corresponding to the pile body.

[0084] It should be noted that the explanation of step 201, step 202 and step 207 can refer to the relevant description in any embodiment of the present invention, and will not be repeated here.

[0085] The monitoring data processing method provided by the present embodiment, by acquiring at least one selected initial pile body model, realizes that for any sub-file, the number corresponding to the target pile body in the sub-file is compared with the pile body number of each initial pile body model respectively, so that when the number corresponding to the target pile body in the sub-file is consistent with the pile body number of the target initial pile body model, it is determined that there is a matching relationship between the target pile body in the sub-file and the target initial pile body model, and then according to the matching relationship between the target pile body in any sub-file and the target initial pile body model, the file path of the sub-file is added to the target initial pile body model, and the pile body horizontal displacement corresponding to the buried depth of each interval set distance of the target pile body indicated by the sub-file is read and added to the target initial pile body model, so as to obtain the pile body model corresponding to the target pile body. Since the pile body horizontal displacement corresponding to the buried depth of each interval set distance of the target pile body indicated by the sub-file can be read according to the file path of the sub-file and added to the matching initial pile body model, it can save resources while realizing the generation of a pile body model that truly reflects the position state of the buried pile body.

[0086] In order to clearly explain how the above embodiment determines and displays the ratio, this embodiment provides another monitoring data processing method. Figure 3 A schematic flow chart of another monitoring data processing method provided by an embodiment of the present invention.

[0087] like Figure 3 As shown, the monitoring data processing method may include the following steps:

[0088] Step 301, obtaining pile horizontal displacement monitoring data at the monitoring point location.

[0089] Step 302, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance of the pile body.

[0090] Step 303: Generate a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data.

[0091] It should be noted that the explanation of step 301, step 302 and step 303 can refer to the relevant description in any embodiment of the present invention, and will not be repeated here.

[0092] Step 304, for any pile body, a displacement value set is created according to the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body, and an alarm value set is created according to the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body.

[0093] The elements in the displacement value set are composed of pile depth and pile horizontal displacement, and the elements in the alarm value set are composed of pile depth and displacement alarm value. The pile depth of elements at the same position in the displacement value set and the alarm value set is the same.

[0094] It can be understood that since the displacement value set is created based on the horizontal displacement of the pile body corresponding to the buried depth of each set distance interval of the pile body, and the alarm value set is created based on the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, the buried depth of the pile body in the displacement value set and the alarm value set is consistent. Specifically, the buried depth of the pile body of the elements at the same position in the displacement value set and the alarm value set is the same.

[0095] As an example, assuming that the pile depth is represented by x, the displacement alarm value is represented by y, and the pile horizontal displacement is represented by Y, the displacement value set can be represented as {<x1,Y1> ,<x2,Y2> ,<x3,Y3> ,……}, the alarm value set can be expressed as {<x1,y1> ,<x2,y2> ,<x3,y3> ,……}.

[0096] Step 305: Determine the ratio between the horizontal displacement of the pile body and the displacement alarm value corresponding to each position according to the position of each element of the displacement value set and the alarm value set.

[0097] In this embodiment, since the buried depths of the pile bodies of the elements at the same positions in the displacement value set and the alarm value set are the same, the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value can be determined according to the positions of the elements in the displacement value set and the alarm value set. It should be noted that the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value is the ratio between the horizontal displacement of the pile body corresponding to the buried depth of the pile body at this position and the displacement alarm value.

[0098] As an example, assume that the displacement value set is represented by {<x1,Y1> ,<x2,Y2> ,<x3,Y3> ,……}, the alarm value set is represented by {<x1,y1> ,<x2,y2> ,<x3,y3> ,……}, then according to the position of each element of the displacement value set and the alarm value set, the ratio between the pile horizontal displacement corresponding to the pile burial depth x1 and the displacement alarm value can be determined as The ratio between the pile horizontal displacement corresponding to the pile burial depth x2 and the displacement alarm value is The ratio between the pile horizontal displacement corresponding to the pile burial depth x3 and the displacement alarm value is ,…….

[0099] Step 306: Display the ratio on the pile model corresponding to the pile in at least one of a rainbow chart, a line chart, a data table and text.

[0100] In some embodiments, the ratio can be displayed on the pile model corresponding to the pile body in at least one of a rainbow chart, a line chart, a data table and text. It should be noted that no matter which display method is used, it is necessary to enable workers who have not received professional training to easily understand the monitoring results. For example, a rainbow chart can show the changes in the horizontal displacement of the pile body through color contrast, a line chart can show the changes in the horizontal displacement of the pile body through the twists and turns of the lines, and a data table can be combined with text to show the changes in the horizontal displacement of the pile body with simple and straightforward data and text explanations. These display methods are intuitive displays of monitoring results, which can make data management, viewing, and comparison easier.

[0101] As a possible implementation method, the process of displaying the ratio in the form of a rainbow diagram on the pile model corresponding to the pile body may include the following steps: first, according to the size of the ratio corresponding to each buried depth of the pile body, the color between two adjacent buried depths of the pile body is determined, and then the color between two adjacent buried depths of the pile body is displayed on the pile model corresponding to the pile body. As an example, the effect diagram of displaying the ratio in the form of a rainbow diagram on the pile model corresponding to the pile body is shown in Figure 4.

[0102] The monitoring data processing method provided in this embodiment creates a displacement value set according to the pile body horizontal displacement corresponding to the buried depth of each interval set distance of the pile body, and creates an alarm value set according to the displacement alarm value corresponding to the buried depth of each interval set distance of the pile body for any pile body, so as to determine the ratio between the pile body horizontal displacement corresponding to each position and the displacement alarm value according to the position of each element of the displacement value set and the alarm value set, so as to display the ratio on the pile body model corresponding to the pile body in at least one form of a rainbow chart, a line chart, a data table and text. Thus, it is possible to determine the ratio based on the displacement value set and the alarm value set and display the ratio in a variety of easy-to-understand display methods, which reduces the difficulty of understanding the monitoring data of the pile body horizontal displacement, facilitates multiple terminals to view the monitoring results, is conducive to data sharing, and enables the monitoring results to better guide the project.

[0103] It should be noted that, in the present invention, the displacement alarm value related data can also be stored in the database. Figure 5 , which explains this process.

[0104] like Figure 5 As shown, the monitoring data processing method may include the following steps:

[0105] Step 501, obtaining pile horizontal displacement monitoring data at the monitoring point location.

[0106] Step 502, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance of the pile body.

[0107] Step 503, for any pile body at the monitoring point location, according to the number corresponding to the pile body, the buried depth of the pile body and the displacement alarm value corresponding to the buried depth of the pile body, a displacement alarm value data table corresponding to the pile body is created in the database.

[0108] The displacement alarm value data table includes an identification field, a burial depth field and a displacement alarm value field. The identification field is used to store the number corresponding to the pile body, the burial depth field is used to store the burial depth of the pile body, and the displacement alarm value field is used to store the displacement alarm value corresponding to the burial depth of the pile body.

[0109] It should be noted that the displacement alarm value data tables corresponding to each pile body at the monitoring point location may be the same or different, and this is not limited in the present embodiment. For example, it is assumed that the monitoring point location includes piles numbered 1, 2, 3, and 4. Therefore, if the piles numbered 1, 2, 3, and 4 have the same buried depth at each set distance, and the displacement alarm value calculation rules of the pile segments are the same, then the piles numbered 1, 2, 3, and 4 can use the same displacement alarm value data table; if only part of the piles (such as the piles numbered 1 and 3) have the same buried depth at each set distance, and the displacement alarm value calculation rules of the pile segments are the same, then these piles can use the same displacement alarm value data table, that is, the piles numbered 1 and 3 can use the same displacement alarm value data table, that is, the piles numbered 1 and 3 can create a displacement alarm value data table with number fields 1 and 3 according to the buried depth of any one of the piles and the displacement alarm value corresponding to the buried depth of the piles, and the other part of the piles can use their respective corresponding displacement alarm value data tables, that is, the piles numbered 2 and 4 need to create their respective corresponding displacement alarm value data tables according to the corresponding numbers of the piles, the buried depths of the piles, and the displacement alarm values ​​corresponding to the buried depths of the piles.

[0110] In this embodiment, after determining the displacement alarm value corresponding to the buried depth of each pile body at each interval of the set distance at the monitoring point position, a displacement alarm value data table corresponding to each pile body at the monitoring point position can be created in the database to store the displacement alarm value information corresponding to the buried depth of each pile body at each interval of the set distance at the monitoring point position. Specifically, for any pile body at the monitoring point position, according to the number corresponding to the pile body, the buried depth of the pile body, and the displacement alarm value corresponding to the buried depth of the pile body, a displacement alarm value data table corresponding to the pile body can be created in the database. Among them, the database can be any database, such as SQL (Structured Query Language, Structured Query Language) sever database, MySQL database, etc., which is not limited in this embodiment.

[0111] As an example, in the SQL sever database, for any pile body at the monitoring point location, a displacement alarm value data table named "DisplacementAlarmValue" corresponding to the pile body can be created according to the corresponding number of the pile body, the buried depth of the pile body, and the displacement alarm value corresponding to the buried depth of the pile body. The displacement alarm value data table may include three fields, namely GUID (identification field), Depth (buried depth field), and Displacement (displacement alarm value field).

[0112] Step 504: Generate a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data.

[0113] Step 505, connecting to the database, and reading the displacement alarm value data table corresponding to each pile body at the monitoring point position.

[0114] In this embodiment, since the displacement alarm value information corresponding to the buried depth of each pile body at each set distance at the monitoring point location is stored in the displacement alarm value data table of the database, it is necessary to connect to the database to read the displacement alarm value data table corresponding to each pile body at the monitoring point location to obtain the displacement alarm value information corresponding to the buried depth of each pile body at each set distance at the monitoring point location.

[0115] Step 506, for any pile body, create a displacement value set according to the pile body horizontal displacement corresponding to each set interval of the buried depth of the pile body, and create an alarm value set according to the displacement alarm value data table corresponding to the pile body.

[0116] The elements in the displacement value set are composed of pile depth and pile horizontal displacement, and the elements in the alarm value set are composed of pile depth and displacement alarm value. The pile depth of elements at the same position in the displacement value set and the alarm value set is the same.

[0117] In this embodiment, since the displacement alarm value data table stores the displacement alarm value information corresponding to the buried depth of each pile body at each set distance interval at the monitoring point location, after obtaining the displacement alarm value data table corresponding to each pile body at the monitoring point location, for any pile body, a displacement value set can be created according to the horizontal displacement of the pile body corresponding to the buried depth of each set distance interval of the pile body, and an alarm value set can be created according to the displacement alarm value data table corresponding to the pile body.

[0118] Step 507: Determine the ratio between the horizontal displacement of the pile body and the displacement alarm value corresponding to each position according to the position of each element of the displacement value set and the alarm value set.

[0119] Step 508: display the ratio on the pile model corresponding to the pile.

[0120] It should be noted that the explanations of step 501, step 502, step 504, step 507 and step 508 can refer to the relevant descriptions in any embodiment of the present invention, and will not be repeated here.

[0121] The monitoring data processing method provided in this embodiment creates a displacement alarm value data table corresponding to the pile body in a database according to the number corresponding to the pile body, the buried depth of the pile body, and the displacement alarm value corresponding to the buried depth of the pile body for any pile body at the monitoring point position, so that when determining the ratio, the database is first connected to read the displacement alarm value data table corresponding to each pile body at the monitoring point position, and then for any pile body, a displacement value set is created according to the pile body horizontal displacement corresponding to each interval of the set distance buried depth of the pile body, and an alarm value set is created according to the displacement alarm value data table corresponding to the pile body, so that the ratio between the pile body horizontal displacement corresponding to each position and the displacement alarm value is determined according to the position of each element of the displacement value set and the alarm value set, and then the ratio is displayed on the pile body model corresponding to the pile body. Therefore, the displacement alarm value information corresponding to each interval of the set distance buried depth of each pile body at the monitoring point position can be stored in the displacement alarm value data table of the database, which is convenient for subsequent use.

[0122] In order to clearly illustrate the above embodiment, an example is now given for illustration.

[0123] Figure 6 A flowchart of a monitoring data processing method in a scenario provided by an embodiment of the present invention.

[0124] It should be noted that Figure 6 The embodiment shown is only the implementation of the monitoring result file path in the local computer, and the implementation process for the network address is similar. Figure 6 The illustrated embodiment uses Windows 10 as the operating system environment, Microsoft visual studio 2015 as the development environment, C++ / CLI as the development language, and the development package versions are MicroStation SDK Update 12 and PROJ.4 4.9.3.

[0125] like Figure 6 As shown, the monitoring data processing method includes the following steps:

[0126] Step 601, reading the pile horizontal displacement monitoring result file from the monitoring instrument.

[0127] Among them, the pile horizontal displacement monitoring result file is the pile horizontal displacement monitoring data at the monitoring point position, and the monitoring point position can be any monitoring position set manually, and the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of each set distance of at least one pile. In other words, the pile horizontal displacement monitoring result file is used to indicate the pile horizontal displacement corresponding to the buried depth of each set distance of at least one pile at the monitoring point position.

[0128] As an example, the pile horizontal displacement monitoring results file can be as follows: Figure 7As shown, it includes pile number information, date information, time information, depth information, offset information, offset line graph, etc. Among them, the offset information can include current offset and first offset, and the current offset is the horizontal displacement of the pile body corresponding to the buried depth of each set distance of the current pile body.

[0129] It should be noted that Figure 7 A worksheet in the pile horizontal displacement monitoring results file shown indicates the pile horizontal displacement corresponding to each set distance of the buried depth of a pile. Therefore, Figure 7 The pile horizontal displacement monitoring result file shown may include at least one worksheet.

[0130] The monitoring instrument is a monitoring device for monitoring the horizontal displacement change of each pile body at the monitoring point. Optionally, the monitoring instrument can be any monitoring device, which is not limited in this embodiment.

[0131] Step 602: Select the initial pile model corresponding to each pile at the monitoring point in MicroStation, and enter the number in its attribute.

[0132] It should be noted that the number entered in the properties of the initial pile model is the pile number in the pile horizontal displacement monitoring results file.

[0133] Step 603, according to the pile number selected by the user and the pile horizontal displacement monitoring result file, the displacement alarm value expression of each section of the pile body is set.

[0134] In this embodiment, the displacement alarm value expression of each section of the pile body can be set according to the pile number selected by the user. The specific process is as follows:

[0135] ① Create a table named "DisplacementAlarmValue" in the SQL server database, with a total of 3 columns in the table header, namely GUID (unique identification code), Depth (burial depth), and Displacement (displacement alarm value);

[0136] ②Create two double objects:

[0137] double x; / / Used to store the buried depth of pile

[0138] double y; / / Used to store the pile horizontal displacement alarm value;

[0139] ③ According to the pile horizontal displacement monitoring results file, determine x=0 / 0.5 / 1 / 1.5……L;

[0140] ④ According to the expression input by the user, assign y through x=x=0 / 0.5 / 1 / 1.5……L;

[0141] ⑤Store the values ​​of x and y in the database, where x corresponds to Depth and y corresponds to Displacement.

[0142] As an example, the page where the user sets the displacement alarm value expression for each segment of the pile is as follows: Figure 8 As shown, the user can enter the pile number on this page to determine which pile body displacement alarm value expression is set for each segment of the pile body, and the user can enter the segment start point burial depth and segment end point burial depth on this page to determine the pile body segment, and can set the corresponding expression (displacement alarm value expression) for the pile body segment, and the expression must be written as a function of y with respect to x. In addition, the user can also enter the file path on this page to determine the corresponding pile body horizontal displacement monitoring results file, that is, to determine the corresponding measured monitoring data.

[0143] Step 604, according to the local path selected by the user (the file path storing the pile horizontal displacement monitoring result file), obtain all sub-files under this path, and read the pile number of each sub-file, which is used as an index to match the number in the initial pile model to generate a pile model corresponding to the pile.

[0144] In this embodiment, the pile horizontal displacement monitoring result file includes at least one sub-file (for example Figure 7 The pile horizontal displacement monitoring result file shown may include at least one worksheet, and each worksheet may be a sub-file at this time), any sub-file is used to indicate the pile horizontal displacement corresponding to each set interval of the buried depth of any pile, and the pile horizontal displacement monitoring result file is stored in the local computer, so that all sub-files under this path can be obtained according to the local path selected by the user, and the pile number of each sub-file can be read, which is used as an index to match the number in the initial pile model to generate the pile model corresponding to the pile. The specific process is as follows:

[0145] ① Create a DgnLinkTreeSpec pointer object spec with the pile unit instance object PileElementEeh in the initial pile model;

[0146] ② Create a DgnDocumentMoniker pointer object moniker with any sub-file in the pile horizontal displacement monitoring result file;

[0147] ③ Determine whether the pile number in the sub-file is consistent with the number of the initial pile model;

[0148] ④If they are consistent, read the DgnLinkTree pointer object linkTree from spec, and get the root node object root from linkTree;

[0149] ⑤Create a TempDgnLinkTreeLeafOwner object fileLeaf of file type;

[0150] ⑥Get the DgnLinkP pointer object link from fileLeaf, and convert the link object into a DgnFileLinkP pointer object fileLink;

[0151] ⑦Get the alias of fileLink from the moniker pointer object and set the name of fileLeaf;

[0152] ⑧Add the fileLeaf object as a child node to the root object;

[0153] ⑨Finally write the linkTree pointer object.

[0154] In summary, according to the matching relationship between the target pile body and the target initial pile body model in any sub-file, the file path of the sub-file can be added to the target initial pile body model, so as to read the pile horizontal displacement corresponding to the burial depth of the target pile body at each set interval indicated by the sub-file and add it to the target initial pile body model to obtain the pile body model corresponding to the target pile body.

[0155] Optionally, the above process can be implemented by the following pseudo code:

[0156] ElementHandle eh = PileElementEeh; / / Get the pile unit object

[0157] DgnLinkTreeSpecPtr spec = DgnLinkManager::CreateTreeSpec(eh); / / Create a pointer object to receive the pile unit

[0158] DgnDocumentMonikerPtr moniker = DgnDocumentMoniker::CreateFromFileName(excelPath); / / Create a DgnDocumentMoniker pointer object moniker with the *.xls file in the current loop

[0159] String pileNumber=ReadExcel(* moniker,1,1); / / Read the pile number in cell B2 of the currently opened Excel file

[0160] if(pileNumber.CompareTo(*spec.PileNumber)==0) / / Judge whether the pile number in the file is consistent with the pile number of the pile body

[0161] {

[0162] DgnLinkTreePtr linkTree = DgnLinkManager::ReadLinkTree(*spec,true); / / Read the DgnLinkTree pointer object linkTree from spec

[0163] DgnLinkTreeBranchR root = linkTree->GetRootR(); / / Get the root node object root from linkTree

[0164] StatusInt status;

[0165] TempDgnLinkTreeLeafOwner fileLeaf = DgnLinkManager::CreateLink(status, DGNLINK_TYPEKEY_File); / / Create a TempDgnLinkTreeLeafOwner object fileLeaf of file type.

[0166] DgnLinkP link = fileLeaf->GetLinkP(); / / Get the DgnLinkP pointer object link from fileLeaf

[0167] DgnFileLinkP fileLink = dynamic_cast <dgnfilelinkp>(link); / / Convert the link object into a DgnFileLinkP pointer object fileLink

[0168] fileLink->SetMoniker(moniker.get(), true); / / Get the alias of fileLink from the moniker pointer object

[0169] WString name = link->BuildSuggestedName(&root, true); / /

[0170] WString uniqueName = root.GetUniqueChildName(name.GetWCharCP());

[0171] fileLeaf->SetName(uniqueName.GetWCharCP()); / / Set the name of fileLeaf

[0172] root.AddChild(*fileLeaf, 0); / / Add the fileLeaf object as a child node to the root object

[0173] DgnLinkManager::WriteLinkTree(*linkTree); / / Write linkTree pointer object

[0174] }

[0175] Step 605, calculating the ratio of the pile horizontal displacement to the displacement alarm value.

[0176] It should be noted that the number of ratios of the pile body horizontal displacement to the displacement alarm value is consistent with the number of pile body burial depths, and each pile body burial depth corresponds to a ratio of the pile body horizontal displacement to the displacement alarm value.

[0177] Since the pile horizontal displacement monitoring results file indicates the pile horizontal displacement corresponding to the buried depth of each set distance of at least one pile at the monitoring point, and the displacement alarm value expression of each section of the pile set by the user is used to determine the displacement alarm value corresponding to the buried depth of each set distance of the pile, the ratio of the pile horizontal displacement to the displacement alarm value can be calculated. The specific process is as follows:

[0178] ①Read the displacement alarm value in the database;

[0179] ② Read the pile horizontal displacement in the pile horizontal displacement monitoring results file;

[0180] ③ Calculate the ratio of the horizontal displacement of the pile to the displacement alarm value.

[0181] Optionally, the above process can be implemented by the following pseudo code:

[0182] std::vector <alarmvalue>_alarmValueList; / / Create an alarm value set, including two attributes: depth and alarm value

[0183] sql::mysql::MySQL_Driver *driver;

[0184] sql::Connection *con;

[0185] sql::Statement *stmt;

[0186] sql::ResultSet *alarmValue;

[0187] driver = sql::mysql::get_mysql_driver_instance();

[0188] con = driver->connect("tcp: / / 127.0.0.1:3306", "username", "password"); / / Create a database connection

[0189] con->setSchema("DisplacementAlarmValue"); / / Select database

[0190] stmt = con->createStatement();

[0191] alarmValue = stmt->executeQuery("SELECT * FROM DisplacementAlarmValue"); / / Execute query statement

[0192] _alarmValueList=alarmValue; / / Store the alarm value database data into the alarm value collection. The two columns of database data (Depth and Displacement) correspond to the two attributes of AlarmValue respectively.

[0193] std::vector <cumulativevalue>_cumulativeValueList; / / Create a displacement value set, including two attributes: depth and displacement value

[0194] _cumulativeValueList = ExcelRead (* moniker); / / Read the final depth and current offset data of the pile horizontal displacement monitoring results file, starting from the sixth line, and store them in _cumulativeValueList

[0195] std::vector <double>_specificValue; / / Create a ratio set

[0196] for(int i=0;i<_cumulativeValueList.Count;i++)

[0197] {

[0198] _specificValue.inserrt(_cumulativeValueList[i] / _alarmValueList[i]); / / Store the ratio of displacement value to alarm value into the ratio set

[0199] }

[0200] Step 606: Display the ratio of the pile horizontal displacement to the displacement alarm value on the pile model in the form of a rainbow diagram.

[0201] In this embodiment, after obtaining the pile model and the ratio of the pile horizontal displacement to the displacement alarm value, the ratio of the pile horizontal displacement to the displacement alarm value can be displayed on the pile model in the form of a rainbow graph. The specific process is as follows:

[0202] ① Determine whether the display mode is selected as rainbow image;

[0203] ②If yes, call the rainbow image display mode.

[0204] Optionally, the above process can be implemented by the following pseudo code:

[0205] if (IsRainbow==true) / / Determine whether to display in rainbow image format

[0206] {

[0207] eh. Rainbow(_cumulativeValueList); / / Display the pile body in rainbow diagram according to the ratio set, the effect is as follows Figure 4

[0208] }

[0209] In summary, the following technical effects can be achieved:

[0210] 1. Reduce the difficulty of understanding the monitoring data of pile horizontal displacement, so that workers without professional training can easily understand the monitoring results;

[0211] 2. The change of pile horizontal displacement can be displayed by color contrast, which makes the display of monitoring results more intuitive and makes data management, viewing and comparison easier;

[0212] 3. It is convenient for multiple terminals to view monitoring results, which is conducive to data sharing, so that the monitoring results can provide better guidance for the project;

[0213] 4. Provide users with the function of independently setting alarm values, which can enable more refined management and control of construction safety issues.

[0214] In order to implement the above embodiment, the present invention also provides a monitoring data processing device.

[0215] Fig. 9 A schematic diagram of the structure of a monitoring data processing device provided by an embodiment of the present invention.

[0216] like Fig. 9 As shown, the monitoring data processing device includes: an acquisition module 11, a determination module 12, a generation module 13 and a processing module 14.

[0217] The acquisition module 11 is used to acquire the pile horizontal displacement monitoring data at the monitoring point; wherein the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of at least one pile at each set interval;

[0218] A determination module 12 is used to determine, for any pile body, the displacement alarm value corresponding to the buried depth of each set distance of the pile body according to the displacement alarm value calculation rule of the pile body segment;

[0219] A generating module 13 is used to generate a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data;

[0220] The processing module 14 is used to determine the ratio between the pile horizontal displacement corresponding to each set interval of the pile depth and the displacement alarm value corresponding to each set interval of the pile depth for any pile body, and display the ratio on the pile model corresponding to the pile body.

[0221] Furthermore, in a possible implementation of the embodiment of the present invention, the pile horizontal displacement monitoring data includes the serial number corresponding to each pile; the generating module 13 includes:

[0222] An acquisition unit is used to acquire at least one selected initial pile model; wherein the initial pile model is selected based on the pile at the monitoring point position, and any initial pile model has a corresponding pile number;

[0223] A determination unit, used to determine the matching relationship between each pile body and each initial pile body model according to the number corresponding to each pile body and the pile body number of each initial pile body model;

[0224] The adding unit is used to add the pile horizontal displacement corresponding to the buried depth of each pile body at each set interval to the matching initial pile body model according to the matching relationship between each pile body and each initial pile body model, so as to obtain the pile body model corresponding to each pile body.

[0225] Furthermore, in a possible implementation of the embodiment of the present invention, the monitoring data of the pile horizontal displacement is stored in a target file, the target file includes at least one sub-file, and any sub-file is used to indicate the pile horizontal displacement corresponding to the buried depth of any pile body at each set interval; the determination unit is further used to:

[0226] For any sub-file, the numbers corresponding to the target piles in the sub-file are compared with the pile numbers of the initial pile models;

[0227] When the number corresponding to the target pile body in the subfile is consistent with the pile body number of the target initial pile body model, it is determined that there is a matching relationship between the target pile body in the subfile and the target initial pile body model.

[0228] Furthermore, in a possible implementation manner of the embodiment of the present invention, the adding unit is further configured to:

[0229] According to the matching relationship between the target pile body and the target initial pile body model in any sub-file, the file path of the sub-file is added to the target initial pile body model, and the pile body horizontal displacement corresponding to the burial depth of the target pile body at each set interval indicated by the sub-file is read and added to the target initial pile body model to obtain the pile body model corresponding to the target pile body.

[0230] Furthermore, in a possible implementation of the embodiment of the present invention, the processing module 14 is further configured to:

[0231] For any pile body, a displacement value set is created according to the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body, and an alarm value set is created according to the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body; wherein the elements in the displacement value set are composed of the buried depth of the pile body and the horizontal displacement of the pile body, and the elements in the alarm value set are composed of the buried depth of the pile body and the displacement alarm value, and the pile body buried depth of the elements at the same position in the displacement value set and the alarm value set is the same;

[0232] According to the positions of the elements of the displacement value set and the alarm value set, the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value is determined.

[0233] Furthermore, in a possible implementation of the embodiment of the present invention, the processing module 14 is further configured to:

[0234] The ratio is displayed on the pile model corresponding to the pile body in at least one form of a rainbow chart, a line chart, a data table and text.

[0235] Furthermore, in a possible implementation of the embodiment of the present invention, the processing module 14 is further configured to:

[0236] According to the size of the ratio corresponding to each buried depth of the pile body, the color between two adjacent buried depths of the pile body is determined;

[0237] The color between two adjacent buried depths of the pile is displayed on the pile model corresponding to the pile.

[0238] Furthermore, in a possible implementation of the embodiment of the present invention, the pile horizontal displacement monitoring data includes the serial number corresponding to each pile; the above-mentioned device further includes:

[0239] A creation module is used to create a displacement alarm value data table corresponding to the monitoring point position in the database according to the number corresponding to the pile body, the buried depth of the pile body and the displacement alarm value corresponding to the buried depth of the pile body; wherein the displacement alarm value data table includes an identification field, a buried depth field and a displacement alarm value field.

[0240] Furthermore, in a possible implementation of the embodiment of the present invention, the processing module 14 is further configured to:

[0241] Connect to the database and read the displacement alarm value data table corresponding to the monitoring point location;

[0242] For any pile body, a displacement value set is created according to the pile body horizontal displacement corresponding to the pile body buried depth at each set distance interval, and an alarm value set is created according to the displacement alarm value data table; wherein the elements in the displacement value set are composed of the pile body buried depth and the pile body horizontal displacement, and the elements in the alarm value set are composed of the pile body buried depth and the displacement alarm value, and the pile body buried depth of the elements at the same position in the displacement value set and the alarm value set is the same;

[0243] According to the positions of the elements of the displacement value set and the alarm value set, the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value is determined.

[0244] Furthermore, in a possible implementation of an embodiment of the present invention, the displacement alarm value calculation rule is a displacement alarm value expression, the displacement alarm value expression corresponds to the set pile body segment, and the pile body segment is determined based on the buried depth of the segment starting point and the buried depth of the segment end point.

[0245] It should be noted that the above explanations of the monitoring data processing method embodiment are also applicable to the monitoring data processing device of this embodiment, and will not be repeated here.

[0246] The monitoring data processing device provided in this embodiment obtains the monitoring data of the pile body horizontal displacement at the monitoring point position, wherein the monitoring data of the pile body horizontal displacement is used to indicate the pile body horizontal displacement corresponding to the buried depth of each set distance interval of at least one pile body, so as to achieve, for any pile body, according to the displacement alarm value calculation rule of the set pile body segment, determine the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body, and generate the pile body model corresponding to each pile body according to the pile body horizontal displacement monitoring data, so as to determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body for any pile body, and display the ratio on the pile body model corresponding to the pile body. Since the ratio between the pile body horizontal displacement and the displacement alarm value can be displayed on the pile body model, the difficulty of understanding the monitoring data of the pile body horizontal displacement is effectively reduced. At the same time, since the displacement alarm value is determined based on the displacement alarm value calculation rule of the set pile body segment, the function of autonomously setting the alarm value is provided for the user, so that the safety issues of the construction can be more finely controlled.

[0247] In order to implement the above embodiments, the present invention also proposes an electronic device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the monitoring data processing method proposed in any of the above embodiments of the present invention.

[0248] In order to implement the above embodiments, the present invention further proposes a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the monitoring data processing method proposed in any of the above embodiments of the present invention.

[0249] In order to implement the above embodiments, the present invention further proposes a computer program product, including a computer program, which, when executed by a processor, implements the monitoring data processing method proposed in any of the above embodiments of the present invention.

[0250] Fig.10 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention.

[0251] It should be noted that Fig.10 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0252] like Fig.10 As shown, the electronic device includes:

[0253] A memory 21 , a processor 22 , and a computer program stored in the memory 21 and executable on the processor 22 .

[0254] When the processor 22 executes the program, the monitoring data processing method provided in any of the above embodiments is implemented.

[0255] Furthermore, the electronic device further comprises:

[0256] The communication interface 23 is used for communication between the memory 21 and the processor 22 .

[0257] The memory 21 is used to store computer programs that can be run on the processor 22 .

[0258] The memory 21 may include a high-speed RAM memory, and may also include a non-volatile memory (non-volatile memory), such as at least one disk memory.

[0259] The processor 22 is used to implement the monitoring data processing method described in any of the above embodiments when executing the program.

[0260] If the memory 21, the processor 22 and the communication interface 23 are implemented independently, the communication interface 23, the memory 21 and the processor 22 can be connected to each other through a bus and communicate with each other. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Fig.10 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0261] Optionally, in a specific implementation, if the memory 21, the processor 22 and the communication interface 23 are integrated on a chip, the memory 21, the processor 22 and the communication interface 23 can communicate with each other through an internal interface.

[0262] The processor 22 may be a central processing unit (CPU), or an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of the present invention.

[0263] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, unless they are contradictory.

[0264] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of the present invention, "plurality" means at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0265] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present invention includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present invention belong.

[0266] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purposes of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples (non-exhaustive list) of computer-readable media include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0267] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0268] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0269] In addition, each functional unit in each embodiment of the present invention may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0270] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present invention have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limiting the present invention. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present invention.< / double> < / cumulativevalue> < / alarmvalue> < / dgnfilelinkp>

Claims

1. A monitoring data processing method, characterized in that: include: Acquire pile horizontal displacement monitoring data at the monitoring point; wherein the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of at least one pile at each set interval; For any of the pile bodies, according to the displacement alarm value calculation rule of the pile body segments, the displacement alarm value corresponding to the buried depth of each set distance of the pile body is determined; Generating a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data; For any of the pile bodies, determine the ratio between the pile body horizontal displacement corresponding to the buried depth of each set interval of the pile body and the displacement alarm value corresponding to the buried depth of each set interval of the pile body, and display the ratio on the pile body model corresponding to the pile body; The pile body horizontal displacement monitoring data includes serial numbers corresponding to the pile bodies; and the pile body models corresponding to the pile bodies are generated according to the pile body horizontal displacement monitoring data, including: Acquire at least one selected initial pile model; wherein the initial pile model is selected based on the pile at the monitoring point position, and any of the initial pile models has a corresponding pile number; Determining a matching relationship between each of the pile bodies and each of the initial pile body models according to the numbers corresponding to each of the pile bodies and the pile body numbers of each of the initial pile body models; According to the matching relationship between each pile body and each initial pile body model, the pile body horizontal displacement corresponding to the buried depth of each pile body at each set interval is added to the matching initial pile body model to obtain the pile body model corresponding to each pile body.

2. The method according to claim 1, characterized in that The monitoring data of pile body horizontal displacement is stored in a target file, the target file includes at least one sub-file, any of the sub-files is used to indicate the pile body horizontal displacement corresponding to the buried depth of each set distance of any of the pile bodies; the matching relationship between each of the pile bodies and each of the initial pile body models is determined according to the number corresponding to each of the pile bodies and the pile body number of each of the initial pile body models, including: For any of the sub-files, comparing the serial number corresponding to the target pile body in the sub-file with the pile body serial number of each of the initial pile body models; When the number corresponding to the target pile body in the subfile is consistent with the pile body number of the target initial pile body model, it is determined that there is a matching relationship between the target pile body in the subfile and the target initial pile body model.

3. The method according to claim 2, characterized in that According to the matching relationship between each pile body and each initial pile body model, the pile body horizontal displacement corresponding to the buried depth of each pile body at each set interval is added to the matching initial pile body model to obtain the pile body model corresponding to each pile body, including: According to the matching relationship between the target pile body and the target initial pile body model in any of the sub-files, the file path of the sub-file is added to the target initial pile body model, so as to read the pile body horizontal displacement corresponding to the burial depth of the target pile body at each set interval indicated by the sub-file and add it to the target initial pile body model to obtain the pile body model corresponding to the target pile body.

4. The method according to claim 1, characterized in that The determining, for any of the pile bodies, of the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body comprises: For any of the pile bodies, a displacement value set is created according to the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body, and an alarm value set is created according to the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body; wherein the elements in the displacement value set are composed of the buried depth of the pile body and the horizontal displacement of the pile body, and the elements in the alarm value set are composed of the buried depth of the pile body and the displacement alarm value, and the pile body buried depth of the elements at the same position in the displacement value set and the alarm value set is the same; According to the positions of the elements of the displacement value set and the alarm value set, the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value is determined.

5. The method according to claim 1, characterized in that The displaying of the ratio on the pile model corresponding to the pile body comprises: The ratio is displayed on the pile model corresponding to the pile body in at least one form of a rainbow graph, a line graph, a data table and text.

6. The method according to claim 5, characterized in that The displaying of the ratio in the form of a rainbow diagram on the pile model corresponding to the pile body includes: Determine the color between two adjacent burial depths of the pile body according to the size of the ratio corresponding to each burial depth of the pile body; The color between two adjacent buried depths of the pile body is displayed on the pile body model corresponding to the pile body.

7. The method according to claim 1, characterized in that The pile horizontal displacement monitoring data includes the serial number corresponding to each pile body; for any of the pile bodies, after determining the displacement alarm value corresponding to the buried depth of each set distance of the pile body according to the displacement alarm value calculation rule of the set pile body segment, the method further includes: For any of the pile bodies at the monitoring point location, a displacement alarm value data table corresponding to the pile body is created in the database according to the number corresponding to the pile body, the buried depth of the pile body and the displacement alarm value corresponding to the buried depth of the pile body; wherein the displacement alarm value data table includes an identification field, a buried depth field and a displacement alarm value field.

8. The method according to claim 7, characterized in that The determining, for any of the pile bodies, of the ratio between the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body and the displacement alarm value corresponding to the buried depth of each set distance interval of the pile body comprises: Connecting to the database, reading the displacement alarm value data table corresponding to each of the pile bodies at the monitoring point position; For any of the pile bodies, a displacement value set is created according to the pile body horizontal displacement corresponding to the buried depth of each set distance interval of the pile body, and an alarm value set is created according to the displacement alarm value data table corresponding to the pile body; wherein the elements in the displacement value set are composed of the pile body buried depth and the pile body horizontal displacement, and the elements in the alarm value set are composed of the pile body buried depth and the displacement alarm value, and the pile body buried depth of the elements at the same position in the displacement value set and the alarm value set is the same; According to the positions of the elements of the displacement value set and the alarm value set, the ratio between the horizontal displacement of the pile body corresponding to each position and the displacement alarm value is determined.

9. The method according to any one of claims 1 to 8, characterized in that The displacement alarm value calculation rule is a displacement alarm value expression, and the displacement alarm value expression corresponds to the set pile body segmentation, and the pile body segmentation is determined based on the buried depth of the segment starting point and the buried depth of the segment end point.

10. A monitoring data processing device, characterized in that: include: An acquisition module, used to acquire pile horizontal displacement monitoring data at the monitoring point; wherein the pile horizontal displacement monitoring data is used to indicate the pile horizontal displacement corresponding to the buried depth of at least one pile at each set interval; A determination module, for determining, for any of the pile bodies, a displacement alarm value corresponding to a buried depth of each set distance of the pile body according to a displacement alarm value calculation rule of the pile body segment; A generating module, used for generating a pile model corresponding to each pile body according to the pile body horizontal displacement monitoring data; a processing module, for determining, for any of the pile bodies, a ratio between a pile horizontal displacement corresponding to a buried depth at each interval of a set distance of the pile body and a displacement alarm value corresponding to a buried depth at each interval of the set distance of the pile body, and displaying the ratio on a pile body model corresponding to the pile body; Wherein, the pile horizontal displacement monitoring data includes the serial number corresponding to each pile; the generating module includes: An acquisition unit, used for acquiring at least one selected initial pile model; wherein the initial pile model is selected based on the pile at the monitoring point position, and any of the initial pile models has a corresponding pile number; A determination unit, configured to determine a matching relationship between each of the pile bodies and each of the initial pile body models according to the serial number corresponding to each of the pile bodies and the pile body serial number of each of the initial pile body models; The adding unit is used to add the pile horizontal displacement corresponding to the buried depth of each pile body at each set interval to the matching initial pile body model according to the matching relationship between each pile body and each initial pile body model, so as to obtain the pile body model corresponding to each pile body.

11. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed 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 perform the method according to any one of claims 1 to 9.

12. A computer-readable storage medium storing computer instructions, characterized in that: The computer instructions are used to cause the computer to execute the method according to any one of claims 1 to 9.

13. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 9.

Images