Data processing method for a sliding inclinometer

Abstract

The application provides a data processing method of a sliding inclinometer, S10, divided into several depth sections; S20, obtaining a forward measurement value of each depth section; S30, obtaining a reverse measurement value of each depth section; S40, obtaining a displacement value of each depth section; S50, obtaining a measurement reference of a measuring hole; S60, repeating S10-S40 to perform measurement of the next measurement time, and obtaining a sum value of each depth section; S70, obtaining a mean square error and a covariance; S80, judging whether the mean square error is less than or equal to a mean square error threshold value, if yes, turning to S90, otherwise, judging that the data is unusable; S90, in the case that the covariance is greater than or equal to a first covariance threshold value, the measuring head is normal, and the data is normal and usable; in the case that the covariance is less than or equal to a second covariance threshold value, the forward and reverse side heads are reversed, and the data is usable after being adjusted; S100, repeating S60-S90 until a preset measurement time is completed. The application can solve the technical problem that the forward and reverse side heads are reversed in the measurement process of the sliding inclinometer.

Description

Technical Field

[0001] This invention relates to the field of sliding inclinometer technology, and more particularly to a data processing method for a sliding inclinometer. Background Technology

[0002] With the significant increase in slope and foundation pit engineering projects in China in recent years, sliding inclinometers (also known as borehole inclinometers or movable inclinometers) have become widely used. An inclinometer is a high-precision tilt angle measuring instrument used to obtain the trajectory of the inclinometer tube axis within the borehole on the cross-section formed by the guide groove pair. Calculations can then be made to obtain the horizontal displacement of each measuring point within this cross-section relative to the bottom of the borehole.

[0003] A typical inclinometer mainly consists of a probe (such as...) Figure 4 The instrument consists of a data acquisition device (reading device), a measuring cable, etc. The probe is the core component of the sliding inclinometer, containing a precision sensor that calculates the displacement change between different depth measuring points relative to the plumb line. The data acquisition device comprises a data acquisition and storage unit and corresponding software. The cable assembly enables functions such as probe setup and management, temporary storage of measurement data, and measurement data output. The cable assembly includes a calibration cable and connectors. Besides supplying power to the probe and providing a signal output channel, it also provides a depth reference for the measuring points, facilitating the reception, storage, and output of probe data.

[0004] The measurement error of an inclinometer is mainly affected by many factors, including the guide wheel spacing reference, transmission line, zero point and gain of the data acquisition device circuit, accelerometer scale factor and bias, accelerometer installation angle, guide wheel assembly, inclinometer tube, and its operating conditions. To eliminate these errors, when using a sliding inclinometer, two measurements are taken in both forward and reverse directions (A0, A180 and B0, B180). When reversing the direction, the probe needs to be removed, rotated 180°, and placed at the correct depth, which is labor-intensive and prone to cable handling errors. One common problem in engineering surveying is "probe reversal in both forward and reverse directions": In engineering, the positive direction of displacement is generally the natural direction of displacement (e.g., the displacement direction of a foundation pit is set as the free face of a continuous wall). When measuring in the forward direction (e.g., A0 or B0), the upper wheel faces the positive direction, and when measuring in the reverse direction (e.g., A180 or B180), the upper wheel faces the opposite direction. It is common in engineering to reverse the probe in both directions, resulting in the cumulative displacement direction being opposite to the actual displacement direction. Summary of the Invention

[0005] This invention provides a data processing method for a sliding inclinometer, which can solve the technical problem in the prior art where the probes are reversed during the measurement process of a sliding inclinometer, resulting in the cumulative displacement direction being opposite to the actual displacement direction.

[0006] According to an aspect of the present application, a data processing method of a sliding inclinometer is provided, the method comprising:

[0007] S10, dividing the measured depth of the hole to be measured into several depth segments according to the cable gauge length;

[0008] S20, placing the measuring head of the sliding inclinometer at the depth to be measured and pulling up to the hole mouth from the depth to be measured to obtain the forward measurement value of each depth segment;

[0009] S30, rotating the measuring head of the sliding inclinometer by 180° and placing it at the depth to be measured, and pulling up to the hole mouth from the depth to be measured to obtain the reverse measurement value of each depth segment;

[0010] S40, obtaining the displacement value of each depth segment based on the forward measurement value of each depth segment and the reverse measurement value of each depth segment;

[0011] S50, taking the displacement value of each depth segment in the first measurement as the measurement reference of the hole;

[0012] S60, repeating S10-S40 to perform the measurement of the next measurement, and obtaining the sum value of each depth segment based on the forward measurement value of each depth segment and the reverse measurement value of each depth segment in the current measurement;

[0013] S70, obtaining the mean square error of the sum value of all depth segments of the hole in the current measurement based on the sum value of each depth segment, and obtaining the covariance of the displacement values between the current measurement and the previous measurement based on the displacement value of each depth segment in the current measurement and the displacement value of each depth segment in the previous measurement, wherein if the data of the previous measurement is unavailable, the displacement value of each depth segment in the previous measurement is replaced by the displacement value of each depth segment in the last measurement in which the data is available;

[0014] S80, determining whether the mean square error of the sum value of all depth segments of the hole in the current measurement is less than or equal to the mean square error threshold, if yes, going to S90, otherwise, determining that the forward measurement value and the reverse measurement value in the current measurement are both unavailable.

[0015] S90, in the case that the covariance of the displacement values between the current measurement and the previous measurement is greater than or equal to the first covariance threshold, the operation of the measuring head in the current measurement is normal, and the forward measurement value and the reverse measurement value are normally available; in the case that the covariance of the displacement values between the current measurement and the previous measurement is less than or equal to the second covariance threshold, the normal and reverse directions of the measuring head in the current measurement are reversed, and the forward measurement value and the reverse measurement value of each depth segment are available after being swapped, wherein the first covariance threshold is greater than the second covariance threshold;

[0016] S100, repeating S60-S90 until the preset number of measurements is completed.

[0017] Preferably, the displacement value of each depth segment is obtained by the following formula:

[0018]

[0019] wherein, Δ j,i represents displacement value of the i-th depth section in the j-th measurement, A0 i represents forward measurement value of the i-th depth section, A180 i represents reverse measurement value of the i-th depth section.

[0020] Preferably, the sum value of each depth section is obtained by the following formula:

[0021]

[0022] wherein, S j,i represents sum value of the i-th depth section in the j-th measurement, A0 i represents forward measurement value of the i-th depth section, A180 i represents reverse measurement value of the i-th depth section.

[0023] Preferably, the mean square error of sum values of all depth sections in the current measurement is obtained by the following formula:

[0024]

[0025] wherein, SD j represents mean square error of sum values of all depth sections in the j-th measurement, S j,i represents sum value of the i-th depth section in the j-th measurement, I represents total number of depth sections of the measurement hole.

[0026] Preferably, the forward measurement value and the reverse measurement value of the current measurement are both unavailable if:

[0027] if the covariance of displacement values between the current measurement and the previous measurement is greater than or equal to a first covariance threshold, the measurement head of the current measurement operates normally, and the forward measurement value and the reverse measurement value are unavailable;

[0028] if the covariance of displacement values between the current measurement and the previous measurement is less than or equal to a second covariance threshold, the forward and reverse operations of the measurement head of the current measurement are reversed, and the forward measurement value and the reverse measurement value are unavailable.

[0029] According to another aspect of the present application, there is provided a computer device comprising a memory, a processor, and a data processing program of a sliding inclinometer stored in the memory and executable on the processor, wherein the processor implements any of the above-mentioned methods when executing the data processing program of the sliding inclinometer.

[0030] Compared with the prior art, the technical scheme of the present application has the following beneficial effects:

[0031] 1. Through the processing of the present application, data problems caused by operation can be found in time, and the quality of inclination data is improved;

[0032] 2. No manual data analysis is needed, and the work intensity of data processing personnel can be reduced;

[0033] 3. The processing method of the present application is integrated into a mobile phone APP, operation problems can be found in time, the number of trips to the measurement site is reduced, the inclination operation efficiency is improved, and the intelligent level of the inclinometer equipment is improved. BRIEF DESCRIPTION OF DRAWINGS

[0034] The accompanying drawings included to provide a further understanding of the embodiments of the present application and constitute a part of the specification, serve to illustrate the embodiments of the present application and, together with the text description, explain the principles of the present application. Obviously, the drawings described below are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor on the basis of these drawings.

[0035] Figure 1 A flow chart of a data processing method of a sliding inclinometer provided by an embodiment of the present application is shown;

[0036] Figure 2a A curve diagram before correction of one measurement data provided by an embodiment of the present application is shown;

[0037] Figure 2b A curve diagram after correction of one measurement data provided by an embodiment of the present application is shown;

[0038] Figure 3a A curve diagram before correction of another measurement data provided by an embodiment of the present application is shown;

[0039] Figure 3b A curve diagram after correction of another measurement data provided by an embodiment of the present application is shown;

[0040] Figure 4 A structural schematic diagram of a sliding inclinometer probe is shown. DETAILED DESCRIPTION

[0041] It should be noted that, unless otherwise specified, the embodiments and features described in this application can be combined with each other. The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. The following description of at least one exemplary embodiment is merely illustrative and is in no way intended to limit the present invention or its application or use. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0042] It should be noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the exemplary embodiments according to this application. As used herein, the singular form is intended to include the plural form as well, unless the context clearly indicates otherwise. Furthermore, it should be understood that when the terms "comprising" and / or "including" are used in this specification, they indicate the presence of features, steps, operations, devices, components, and / or combinations thereof.

[0043] Unless otherwise specifically stated, the relative arrangement, numerical expressions, and values ​​of the components and steps set forth in these embodiments do not limit the scope of the invention. It should also be understood that, for ease of description, the dimensions of the various parts shown in the drawings are not drawn to actual scale. Techniques, methods, and devices known to those skilled in the art may not be discussed in detail, but where appropriate, such techniques, methods, and devices should be considered part of the specification. In all examples shown and discussed herein, any specific values ​​should be interpreted as merely exemplary and not as limitations. Therefore, other examples of exemplary embodiments may have different values. It should be noted that similar reference numerals and letters in the following figures denote similar items; therefore, once an item is defined in one figure, it need not be further discussed in subsequent figures.

[0044] like Figure 1 As shown, the present invention provides a data processing method for a sliding inclinometer, the method comprising:

[0045] S10. Divide the measurement depth of the hole to be measured into several depth segments according to the cable gauge length;

[0046] S20. Place the probe of the sliding inclinometer at the depth to be measured, and pull it up from the depth to the borehole opening to obtain the positive measurement value of each depth segment.

[0047] S30. After rotating the probe of the sliding inclinometer 180°, place it at the depth to be measured, and pull it up from the depth to the borehole opening to obtain the reverse measurement value of each depth segment.

[0048] S40, obtaining a displacement value of each depth segment based on the forward measurement value of each depth segment and the reverse measurement value of each depth segment;

[0049] S50, taking the displacement value of each depth segment in the first measurement as a measurement reference of the borehole;

[0050] S60, repeating S10-S40 to perform measurement of the next measurement, and obtaining a sum value of each depth segment based on the forward measurement value of each depth segment and the reverse measurement value of each depth segment in the current measurement;

[0051] S70, obtaining a mean square error of the sum value of all depth segments of the borehole in the current measurement based on the sum value of each depth segment, and obtaining a covariance of the displacement value between the current measurement and the previous measurement based on the displacement value of each depth segment in the current measurement and the displacement value of each depth segment in the previous measurement, wherein if the data of the previous measurement is unavailable, the displacement value of each depth segment in the previous measurement is replaced by the displacement value of each depth segment in the last available measurement;

[0052] S80, judging whether the mean square error of the sum value of all depth segments of the borehole in the current measurement is less than or equal to a mean square error threshold, if yes, turning to S90, otherwise, judging that the forward measurement value and the reverse measurement value in the current measurement are both unavailable.

[0053] S90, in the case that the covariance of the displacement value between the current measurement and the previous measurement is greater than or equal to a first covariance threshold, the operation of the measuring head in the current measurement is normal, and the forward measurement value and the reverse measurement value are normally available; in the case that the covariance of the displacement value between the current measurement and the previous measurement is less than or equal to a second covariance threshold, the normal and reverse directions of the measuring head in the current measurement are reversed, and the forward measurement value and the reverse measurement value of each depth segment are available after being exchanged, wherein the first covariance threshold is greater than the second covariance threshold;

[0054] S100, repeating S60-S90 until a preset number of measurements is completed.

[0055] Compared with the prior art, the present application has the following beneficial effects:

[0056] 1. Through the processing of the present application, data problems caused by operation can be found in time, and the quality of the inclination data is improved;

[0057] 2. Manual data analysis is not required, and the working intensity of the data processing personnel can be reduced;

[0058] 3. The processing method of the present application is integrated into a mobile phone APP, operation problems can be found in time, the number of trips to the measurement site is reduced, the inclination operation efficiency is improved, and the intelligent level of the inclinometer equipment is improved.

[0059] According to an embodiment of the present application, the displacement value of each depth section is obtained by the following formula:

[0060]

[0061] In the formula, Δ j,i represents the displacement value of the i-th depth section in the j-th measurement, A0 i represents the forward measurement value of the i-th depth section, A180 i represents the reverse measurement value of the i-th depth section.

[0062] According to an embodiment of the present application, the sum value of each depth section is obtained by the following formula:

[0063]

[0064] In the formula, S j,i represents the sum value of the i-th depth section in the j-th measurement, A0 i represents the forward measurement value of the i-th depth section, A180 i represents the reverse measurement value of the i-th depth section.

[0065] According to an embodiment of the present application, the mean square error of the sum values of all depth sections in the current measurement is obtained by the following formula:

[0066]

[0067] In the formula, SD j represents the mean square error of the sum values of all depth sections in the j-th measurement, S j,i represents the sum value of the i-th depth section in the j-th measurement, and I represents the total number of depth sections of the measurement hole.

[0068] According to an embodiment of the present application, the forward measurement value and the reverse measurement value of the current measurement are both unavailable when:

[0069] When the covariance of the displacement values between the current measurement and the previous measurement is greater than or equal to a first covariance threshold, the measurement head of the current measurement operates normally, and the forward measurement value and the reverse measurement value are unavailable;

[0070] When the covariance of the displacement values between the current measurement and the previous measurement is less than or equal to a second covariance threshold, the forward and reverse directions of the measurement head of the current measurement are reversed, and the forward measurement value and the reverse measurement value are unavailable.

[0071] In order to have a further understanding of the present application, the following Figures 1-4 The data processing of the present application is described in detail.

[0072] In the present embodiment, a data processing method of a sliding inclinometer is provided, which specifically comprises the following steps:

[0073] First step, measuring the initial value of the hole, establishing the initial reference of the hole

[0074] A1.1, first A0 / B0 direction measurement: the probe is placed at the hole bottom for a period of time, the high wheel of the probe is oriented to the positive direction of the set displacement, the guide wheel of the probe is placed in the guide groove and at the depth to be measured (generally the hole bottom) as the starting point of measurement and reading;

[0075] A1.2, pull up to measure data at every 500mm depth gauge, recorded as A0 i (i is the serial number of each depth), until the hole opening; wherein the depth gauge is generally 500mm or 1m, and 500mm is taken in this embodiment;

[0076] A1.3, A180 / B180 direction measurement is performed again: the probe is taken out, rotated by 180°, the high wheel is oriented to the reverse direction of the set displacement, placed at the depth to be measured (generally the hole bottom) as the starting point of measurement and reading, and pulled up to measure data A180 at every 500mm depth gauge i (i is the serial number of each depth), and the following data of each depth section is calculated during the period:

[0077]

[0078] Δ1=∑Δ 1i

[0079]

[0080] wherein,

[0081] A0 i — the positive direction measurement value of the i-th depth section, unit: mm;

[0082] A180 i — the reverse direction measurement value of the i-th depth section, unit: mm;

[0083] i— the serial number of each depth section of the hole, i = 1, 2, 3,..., I;

[0084] I— the total number of depth sections of the hole;

[0085] Δ 1i — the displacement value of the i-th depth section in the first (initial measurement), unit: mm;

[0086] Δ1— the displacement value of the hole in the first (initial measurement), unit: mm;

[0087] S 1i — the sum value of the i-th depth section in the first (initial measurement), unit: mm;

[0088] S1—The average sum of the depths in each depth segment during the first (preliminary) measurement, in mm;

[0089] SD1 – The mean square error of all depth segments and values ​​measured in the first (initial) borehole survey, in mm.

[0090] Step 2: After the probe has been stationary at the bottom of the hole for a period of time, the data of the subsequent Jth measurement is statistically analyzed. A2.1: Calculate the displacement value Δ of the Jth measurement using the above formula set. J,i SD J (Where J represents the number of measurements, J = 2, 3, 4...)

[0091] A2.1 Calculate Δ j,i and Δ (j-1),i Covariance Cov[Δ j,i ,Δ (j-1),i ].

[0092] Step 3: Determining if the test result is normal

[0093] A3.1, when Cov[Δ j,i ,Δ (j-1),i ]≥c1 and SD J If ≤sd (c1 and sd are empirical engineering values), the probe operation is normal and the data is normal and usable for this test.

[0094] Among them, c1 and sd are related to the working conditions and the type of inclinometer tube material. sd is generally taken as 0.2 mm and c1 is generally taken as 0.6 mm, which can be adjusted according to the specific project.

[0095] A3.2, when Cov[Δ j,i ,Δ (j-1),i ]≤c2 and SD J ≤sd (c2 is an empirical engineering value), the probe operation for this measurement is reversed, and the data is A0. i A180 i Available;

[0096] C2 is typically set to -0.6mm, but can be adjusted depending on the specific project.

[0097] A3.3, when Cov[Δ j,i ,Δ (j-1),i ]≥c1 and SD J >sd, the probe is operating normally, but the data is unavailable;

[0098] A3.4, when Cov[Δ j,i ,Δ (j-1),i ]≤c2 and SD J >sd, the forward and reverse probes are reversed for this test, and the data is unavailable.

[0099] The fourth step is to judge the reverse direction of the measuring head

[0100] When A3.2 is satisfied, A0 i and A180 i The data is reversed, the data is available, and the normal inclinometer data processing can be performed.

[0101] Figures 2 and 3 show the curves before and after the correction of the measurement data, and the correct measurement data can be obtained by the processing method of the present application.

[0102] The present application also provides a computer device comprising a memory, a processor and a data processing program of the sliding inclinometer stored in the memory and executable on the processor, and the processor implements any of the above-mentioned methods when executing the data processing program of the sliding inclinometer.

[0103] In summary, the present application provides a data processing method of the sliding inclinometer, which has the following beneficial effects compared with the prior art:

[0104] 1. Through the processing of the present application, data problems caused by operation can be found in time, and the quality of the inclinometer data is improved.

[0105] 2. No manual data analysis is required, which can reduce the work intensity of the data processing personnel.

[0106] 3. The processing method of the present application is integrated into a mobile phone APP, which can find operation problems in time, reduce the number of trips to the measurement site, improve the operation efficiency of the inclinometer, and improve the intelligent level of the inclinometer equipment.

[0107] The part of the present application not described in detail is the technology known to those skilled in the art.

[0108] In the description of the present application, it should be understood that the orientation words such as "front, rear, upper, lower, left, right", "horizontal, vertical, perpendicular, horizontal" and "top, bottom" and the like indicate the orientation or position relationship shown in the drawings, and are only for the convenience of describing the present application and simplifying the description, and in the absence of the opposite description, these orientation words do not indicate and imply that the indicated device or element must have a specific orientation or be constructed and operated in a specific orientation, therefore it cannot be understood as a limitation on the protection scope of the present application; the orientation words "inner, outer" refer to the inner and outer relative to the contour of each component.

[0109] For purposes of the description hereinafter, the terms "upper", "lower", "right", "left", "rear", "front", "vertical", "horizontal", and derivatives thereof shall relate to the application as oriented in the drawing. The terms "forward" and "aft" refer to a direction toward the front of the device and a direction toward the rear of the device, respectively. However, it is to be understood that the application can assume various alternative orientations, except where expressly omitted.

[0110] In addition, it should be noted that the use of "first", "second", and the like herein does not indicate any order, quantity, or importance, but rather is used to distinguish one element from another, and the terms "first", "second", and the like are not otherwise limiting on the scope of the application.

[0111] The application has been described herein in relation to particular embodiments, which are in no way to be considered limiting of the application rather the opposite, the application is intended to embrace all possible embodiments and changes coming within the spirit and purview of the application.

Claims

1. A data processing method for a sliding inclinometer, characterized in that, The method comprises: S10, dividing the measured depth of the hole to be measured into several depth sections according to the cable gauge length; S20, placing the measuring head of the sliding inclinometer at the depth to be measured and pulling it up to the hole mouth from the depth to be measured to obtain the forward measurement value of each depth section; S30, rotating the measuring head of the sliding inclinometer by 180° and placing it at the depth to be measured, and pulling it up to the hole mouth from the depth to be measured to obtain the reverse measurement value of each depth section; S40, obtaining the displacement value of each depth section based on the forward measurement value of each depth section and the reverse measurement value of each depth section; S50, taking the displacement value of each depth section in the first measurement as the measurement reference of the hole; S60, repeating S10-S40 to perform the measurement of the next measurement, and obtaining the sum value of each depth section based on the forward measurement value of each depth section and the reverse measurement value of each depth section in the current measurement; S70, obtaining the mean square error of the sum value of all depth sections of the hole in the current measurement based on the sum value of each depth section, and obtaining the covariance of the displacement value between the current measurement and the previous measurement based on the displacement value of each depth section in the current measurement and the displacement value of each depth section in the previous measurement, wherein if the data of the previous measurement is unavailable, the displacement value of each depth section in the previous measurement is replaced by the displacement value of each depth section in the last measurement in which the data is available; S80, determining whether the mean square error of the sum value of all depth sections of the hole in the current measurement is less than or equal to the mean square error threshold, if yes, turning to S90, otherwise, determining that the forward measurement value and the reverse measurement value in the current measurement are both unavailable; S90, in the case that the covariance of the displacement value between the current measurement and the previous measurement is greater than or equal to the first covariance threshold, the current measurement head operates normally, and the forward measurement value and the reverse measurement value are normally available; in the case that the covariance of the displacement value between the current measurement and the previous measurement is less than or equal to the second covariance threshold, the current measurement head operates in the reverse direction, and the forward measurement value and the reverse measurement value are available after being swapped, wherein the first covariance threshold is greater than the second covariance threshold; S100, repeating S60-S90 until the preset number of measurements is completed.

2. The method of claim 1, wherein, The displacement value of each depth section is obtained by the following formula: In the formula, Δ j,i represents the displacement value of the i-th depth section in the j-th measurement, A0 i represents the forward measurement value of the i-th depth section, A180 i represents the reverse measurement value of the i-th depth section.

3. The method of claim 1, wherein, The sum value of each depth section is obtained by the following formula: In the formula, S j,i represents the sum value of the ith depth section in the jth measurement, A0 i represents the forward measurement value of the ith depth section, A180 i represents the reverse measurement value of the ith depth section.

4. The method of claim 1, wherein, The mean square error of the sum value of all depth sections of the hole in the current measurement is obtained by the following formula: where SD j represents the mean square deviation of all depth segments and values of the jth measurement hole, S j,i represents the sum value of the ith depth segment in the jth measurement, and I represents the total number of depth segments of the measurement hole.

5. The method of claim 1, wherein, The forward measurement value and the reverse measurement value in the current measurement are both unavailable, which includes: In the case that the covariance of the displacement value between the current measurement and the previous measurement is greater than or equal to the first covariance threshold, the current measurement head operates normally, and the forward measurement value and the reverse measurement value are unavailable; In the case that the covariance of the displacement value between the current measurement and the previous measurement is less than or equal to the second covariance threshold, the current measurement head operates in the reverse direction, and the forward measurement value and the reverse measurement value are unavailable.

6. A computer device, comprising: The data processing program of the sliding inclinometer stored in the memory and executable on the processor, wherein the processor implements the method of any one of claims 1-5 when executing the data processing program of the sliding inclinometer.

Images