Skew plot drawing method and device based on programming modeling, equipment, storage medium
By using programming modeling to automate the processing of the freezing hole deviation diagram, the problem of insufficient accuracy in drawing the freezing hole deviation diagram was solved, and efficient and accurate deviation diagram drawing and construction monitoring support were achieved.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- 中煤邯郸特殊凿井有限公司
- Filing Date
- 2026-04-22
- Publication Date
- 2026-06-26
AI Technical Summary
The existing methods for drawing the deflection diagram of freezing holes are not accurate enough, and manual data processing is cumbersome and prone to errors, making it difficult to meet the high-precision monitoring requirements of engineering projects.
A programming-based modeling approach is adopted. By automatically traversing and screening the borehole deviation data, the threshold for deviation rate variation and depth segmentation are determined. Differential interpolation is used to process the coordinate data, and thresholds are set according to engineering construction specifications. The deviation and deviation rate exceeding the standard are automatically determined, standardized coordinates are generated, and finally, the deviation diagram is drawn through parametric modeling.
It improves the accuracy of skew plot drawing, reduces human error, and automates the entire process from raw data to charts, thereby improving data processing and drawing efficiency and providing efficient and accurate construction monitoring data support.
Smart Images

Figure CN122289448A_ABST
Abstract
Description
Technical Field
[0001] This application belongs to the field of intelligent drawing technology, and more specifically, it relates to a method, apparatus, device, and storage medium for drawing skew diagrams based on programming modeling. Background Technology
[0002] In the construction of underground engineering projects such as mines and tunnels using the freezing method, the freezing holes, as the core carriers for the formation of the frozen walls, have their deviation state directly affecting the quality, thickness, and strength of the frozen walls, which in turn relates to construction safety and project progress. Therefore, it is necessary to accurately grasp the deviation status by drawing a freezing hole deviation diagram to provide a basis for construction adjustments.
[0003] Currently, the drawing of frozen borehole deviation maps mostly employs traditional manual or simple data processing methods. This involves obtaining borehole deviation data using methods such as theodolite inclinometers, then manually calculating coordinates and drawing the deviation trajectory, or manually marking out-of-range information after processing coordinate data using a single fixed method. Manual data processing and chart drawing are cumbersome and prone to errors due to human intervention, resulting in insufficient accuracy and failing to meet the high-precision monitoring requirements of engineering projects. Therefore, a method for drawing frozen borehole deviation maps that can overcome these shortcomings is needed. Summary of the Invention
[0004] The purpose of this application is to provide a skew plotting method, apparatus, device, and storage medium based on programming modeling that can improve the accuracy of skew plotting. To achieve the above objective, the technical solutions provided by this application are as follows: Firstly, a method for drawing skew maps based on programming modeling is provided, including: Based on the measured borehole deviation rate in the borehole deviation data, the threshold for the deviation rate change amplitude is determined, and the measured deviation rate of the entire borehole depth is screened to obtain the deviation rate change amplitude data of multiple depth measuring points. Based on the skewness change amplitude data and the skewness change amplitude threshold, the borehole depth segmentation result is determined. Based on the borehole depth segmentation result, the interpolation type of each depth segment is determined. For different interpolation types, the initial coordinate calculation data of non-fixed depths are interpolated to obtain identifiable coordinate parameters. Based on engineering construction specification data, the deviation exceeding threshold and the deviation rate exceeding threshold for each depth layer were determined respectively. The actual deviation of the borehole position and the actual deviation rate of the borehole position in the borehole deviation data are compared with thresholds to obtain the deviation exceeding the standard judgment result and the deviation rate exceeding the standard judgment result. Based on the deviation exceeding the standard judgment result and the deviation rate exceeding the standard judgment result, the identifiable coordinate parameters are classified to obtain standardized coordinates. The standardized coordinates are matched with the family library parameters, and the results of the skewness exceeding the standard and the skewness exceeding the standard are incorporated into the matching process as a new matching dimension to obtain the skew map drawing parameters. Based on the deflection diagram drawing parameters, the deflection diagram of the freezing hole is drawn using parametric modeling.
[0005] Secondly, a skew graph drawing device based on programming modeling is provided, comprising: The deviation rate change amplitude determination module is used to determine the deviation rate change amplitude threshold based on the measured deviation rate of the borehole in the borehole deviation data. It performs a traversal screening process on the measured deviation rate of the entire borehole depth to obtain deviation rate change amplitude data of multiple depth measuring points. The coordinate parameter determination module is used to determine the borehole depth segmentation result based on the skewness change amplitude data and the skewness change amplitude threshold, determine the interpolation type of each depth segment based on the borehole depth segmentation result, and perform interpolation processing on the initial coordinate calculation data of non-fixed depth for different interpolation types to obtain identifiable coordinate parameters. The threshold determination module is used to determine the deviation threshold and the deviation rate threshold for different depth layers based on engineering construction specification data. The standardized coordinate generation module is used to perform threshold comparisons on the actual borehole position offset and actual borehole position offset rate in the borehole deviation data to obtain the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result. Based on the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result, the identifiable coordinate parameters are classified to obtain standardized coordinates. The skew plot drawing parameter generation module is used to match the standardized coordinates with the family library parameters, and to incorporate the skewness exceeding the standard judgment result and the skewness rate exceeding the standard judgment result into the matching process as a new matching dimension to obtain the skew plot drawing parameters; The skew diagram drawing module is used to draw the skew diagram of the frozen hole through parametric modeling based on the skew diagram drawing parameters.
[0006] Thirdly, embodiments of this application also provide an electronic device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the skew diagram drawing method based on programming modeling provided in any possible implementation of the first aspect.
[0007] Fourthly, embodiments of this application also provide a computer-readable storage medium storing a computer program that, when executed by a processor, implements the skew diagram drawing method based on programming modeling provided by any possible implementation of the first aspect.
[0008] The beneficial effects of the technical solution provided in this application are as follows: The skew map drawing method, apparatus, device, and storage medium based on programming modeling provided in this application, compared with related technologies, automatically traverses and screens the measured skew rate across the entire borehole depth, segments the depth based on the skew rate variation, and processes the coordinate data using differentiated interpolation methods according to different segment types. This avoids the trajectory distortion problems caused by traditional manual calculation and single interpolation methods, making the borehole skew trajectory more closely resemble the actual construction state and significantly improving the accuracy of skew description. Simultaneously, this application automatically determines the threshold for each depth layer according to engineering construction specifications and quickly compares and judges the actual borehole offset and skew rate, achieving automatic classification and standardization of coordinate data. This eliminates a large number of manual verification, classification, and organization steps, significantly reducing human error and improving data processing efficiency.
[0009] Furthermore, this embodiment automatically matches standardized coordinates with family library parameters and incorporates offset and skewness determination results into the matching dimension to automatically generate skewness diagram drawing parameters. Then, through parametric modeling, the skewness diagram of the frozen hole is drawn, achieving full automation from raw data to the final chart, eliminating the need for manual point-by-point drawing and segment-by-segment labeling. This embodiment improves the accuracy of skewness diagram drawing, enhances the efficiency and standardization of frozen hole skewness diagram drawing, and can quickly and intuitively reflect the skewness status of frozen holes, providing efficient and accurate data support for on-site construction monitoring and safety management. Attached Figure Description
[0010] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments of this application will be briefly introduced below.
[0011] Figure 1 A flowchart illustrating the skew diagram drawing method based on programming modeling provided in this application embodiment; Figure 2 A structural block diagram of the skew diagram drawing device based on programming modeling provided in the embodiments of this application; Figure 3 A schematic block diagram of an electronic device provided in an embodiment of this application. Detailed Implementation
[0012] The embodiments of this application are described below with reference to the accompanying drawings. It should be understood that the embodiments described below with reference to the accompanying drawings are exemplary descriptions for explaining the technical solutions of the embodiments of this application, and do not constitute a limitation on the technical solutions of the embodiments of this application.
[0013] Those skilled in the art will understand that, unless specifically stated otherwise, the singular forms “a,” “an,” “the,” and “the” used herein may also include the plural forms. It should be further understood that the terms “comprising” and “including” as used in embodiments of this application mean that the corresponding feature can be implemented as the presented feature, information, data, step, operation, element, and / or component, but do not exclude implementation as other features, information, data, step, operation, element, component, and / or combinations thereof supported by the art. It should be understood that when we say that an element is “connected” or “coupled” to another element, the one element can be directly connected or coupled to the other element, or it can mean that the one element and the other element establish a connection relationship through an intermediate element. Furthermore, “connected” or “coupled” as used herein can include wireless connection or wireless coupling. The term “and / or” as used herein indicates at least one of the items defined by the term; for example, “A and / or B” can be implemented as “A,” or as “B,” or as “A and B.” When describing multiple (two or more) items, if the relationship between the multiple items is not explicitly defined, the multiple items can refer to one, several or all of the multiple items. For example, the description of "parameter A includes A1, A2, A3" can be implemented as parameter A includes A1 or A2 or A3, or it can be implemented as parameter A includes at least two of the three items A1, A2 and A3.
[0014] It is understood that in the embodiments of this application, data such as user information are involved. When the embodiments of this application are applied to specific products or technologies, user permission or consent is required, and the collection, use and processing of related data must comply with relevant laws, regulations and standards.
[0015] To make the objectives, technical solutions, and advantages of this application clearer, the following description will be provided in conjunction with the accompanying drawings and specific embodiments.
[0016] This application provides a method for drawing skew maps based on programming modeling. This method can be executed by an electronic device, such as... Figure 1 As shown, the method may include: S101: Determine the threshold for the deviation rate change based on the measured deviation rate in the borehole deviation data, and perform a traversal screening process on the measured deviation rate across the entire borehole depth to obtain deviation rate change data for multiple depth measurement points.
[0017] In this embodiment, the borehole deviation data is a set of data recording the borehole deviation status during the construction of the frozen hole, including data such as the measured borehole deviation rate and the actual deviation distance of the hole position. The measured borehole deviation rate is the degree of deviation per unit drilling depth. The deviation rate change threshold is the critical value for judging whether the borehole deviation rate change is abnormal. The total borehole depth is the entire depth range of the borehole from the borehole opening to the bottom. The depth measuring points are the specific measurement points set within the total borehole depth. The deviation rate change amplitude data is the data on the degree of deviation rate change at each depth measuring point.
[0018] Considering that the deviation of the freezing hole directly affects the safety of the project construction, it is necessary to accurately grasp the law of deviation rate change. Therefore, the threshold of deviation rate change range is first determined based on the actual deviation rate measured in the borehole, so as to provide a standard for subsequent determination of deviation rate change.
[0019] For example, this embodiment acquires borehole deviation data, which is collected in real time during the drilling process using a borehole surveying instrument. The measured deviation rate is calculated from the deviation angles recorded by the surveying instrument at different depths of the borehole. Based on the collected measured deviation rates, the fluctuation range of all measured deviation rates is calculated, and a threshold for the deviation rate change is determined by combining engineering construction experience. Subsequently, the measured deviation rates across the entire borehole depth are screened point by point, and the difference between the measured deviation rates of two adjacent depth measuring points is calculated sequentially. This difference is the deviation rate change data for the corresponding depth measuring point. For example, if the total borehole depth is 0 to 100 meters, and a depth measuring point is set every 2 meters, for a total of 50 depth measuring points, the measured deviation rates of each measuring point are iterated over, and the difference is calculated to obtain the deviation rate change data for the 50 depth measuring points, ensuring that the deviation rate change at each measuring point is accurately captured.
[0020] This embodiment determines the threshold for deviation rate variation based on the measured deviation rate of the borehole, ensuring that the deviation rate change judgment standard aligns with actual engineering conditions and avoiding judgment bias. This embodiment also performs a comprehensive screening of the measured deviation rate across the entire borehole depth, accurately acquiring the deviation rate variation data for each depth measuring point, thus fully understanding the full-depth variation pattern of the borehole deviation rate and providing accurate data support for subsequent depth segmentation. This embodiment effectively solves the problems of low efficiency and large errors in traditional manual screening of deviation rate data, improving the accuracy and efficiency of data processing.
[0021] S102: Determine the borehole depth segmentation results based on the skewness change amplitude data and the skewness change amplitude threshold. Determine the interpolation type of each depth segment based on the borehole depth segmentation results. Perform interpolation processing on the initial coordinate calculation data of non-fixed depths for different interpolation types to obtain identifiable coordinate parameters.
[0022] In this embodiment, the borehole depth segmentation result is a set of different depth intervals obtained by dividing the entire borehole depth based on the skewness variation amplitude data and the skewness variation amplitude threshold. The interpolation type refers to the specific method used when interpolating non-fixed depth coordinate data. The initial coordinate calculation data for non-fixed depths are the basic coordinate calculation data corresponding to depths that are not set at fixed intervals. Identifiable coordinate parameters are standardized coordinate-related parameters that can be identified and processed by subsequent steps after interpolation. For example, the borehole depth segmentation result can be divided into multiple continuous depth intervals, each interval corresponding to a different interpolation type.
[0023] Considering the variations in skewness across the entire borehole depth and the different degrees of skewness in different areas, it is necessary to divide the borehole into segments using skewness variation amplitude data and threshold values to ensure that each segment conforms to the skewness variation pattern. Given the different skewness variation characteristics of different segments, a single interpolation type cannot guarantee the accuracy of coordinate calculations; therefore, the corresponding interpolation type is determined based on the segmentation results.
[0024] In this embodiment, the skewness variation amplitude data of each depth measuring point acquired previously and the determined skewness variation amplitude threshold are first used. Continuous depth measuring points where the skewness variation amplitude data are all less than or equal to the skewness variation amplitude threshold are divided into one segment. The intervals containing depth measuring points where the skewness variation amplitude data are greater than the skewness variation amplitude threshold are divided into independent segments, forming the borehole depth segmentation result. Subsequently, the interpolation type is determined based on the skewness variation characteristics of each segment. Linear interpolation is used for segments with stable skewness variations, while quadratic interpolation is used for segments with large skewness variation fluctuations. Next, initial coordinate calculation data for non-fixed depths is acquired. This data is calculated from non-fixed depth skewness data collected by the borehole surveying instrument. For different interpolation types for different segments, interpolation processing is performed on the initial coordinate calculation data for non-fixed depths within the corresponding segment. Linear interpolation is calculated linearly using the coordinates of adjacent fixed depth measuring points, while quadratic interpolation is calculated by fitting the coordinates of three adjacent fixed depth measuring points. After processing, identifiable coordinate parameters are obtained. For example, if a segment is from 0 to 20 meters, linear interpolation is used to interpolate the initial coordinate calculation data of two non-fixed depths, 5 meters and 15 meters, within the segment to obtain the corresponding identifiable coordinate parameters.
[0025] This embodiment determines the borehole depth segmentation results based on the skewness variation amplitude data and skewness variation amplitude threshold, ensuring that the segmentation closely matches the actual variation law of borehole skewness, providing a reasonable basis for subsequent interpolation processing. Based on the segmentation results, the corresponding interpolation type is determined, achieving differentiated interpolation and improving the accuracy of non-fixed depth coordinate calculation. Through targeted interpolation processing, the initial coordinate calculation data of non-fixed depth is transformed into identifiable parameters, solving the problem of difficulty in accurately obtaining non-fixed depth coordinates and improving the applicability and accuracy of data processing.
[0026] In this embodiment, the borehole depth segmentation result data is determined based on the skewness change amplitude data and the skewness change amplitude threshold, including: The deviation rate change amplitude data of each depth measurement point is compared with their respective deviation rate change amplitude thresholds to determine the deviation rate change judgment result of each depth measurement point. The results of the deviation rate change judgment at each depth measurement point are traversed and integrated to obtain the deviation rate change judgment result for the entire depth. The results of the full-depth deviation rate change determination are divided into intervals to obtain the initial screening data of borehole depth segments; Boundary calibration processing is performed on the initial screening data of borehole depth segments to obtain borehole depth segment calibration data; The borehole depth segment calibration data is structured to determine the borehole depth segment result data.
[0027] In this embodiment, the borehole depth segmentation result data is the final depth segmentation data obtained after comparison, integration, division, calibration, and structuring processing based on the skewness change amplitude data and skewness change amplitude threshold, which is used in subsequent processes. The skewness change judgment result is obtained by comparing the skewness change amplitude data of each depth measuring point with its corresponding skewness change amplitude threshold to determine whether the skewness change of that measuring point meets the requirements. The full-depth skewness change judgment result is the overall judgment data covering the entire borehole depth after traversing and integrating the skewness change judgment results of all depth measuring points. The initial screening data for borehole depth segmentation is the preliminary depth segmentation data obtained after dividing the full-depth skewness change judgment results into intervals. The borehole depth segmentation calibration data is the segmentation data obtained by correcting deviations after boundary calibration processing of the initial screening data for borehole depth segmentation. For example, if a borehole has 40 depth measuring points at its full depth, integrating the skewness change judgment results of all measuring points yields the full-depth skewness change judgment result.
[0028] Considering the differences in geological conditions and drilling conditions at various depth measuring points, the threshold for the magnitude of skewness variation needs to correspond one-to-one with each measuring point. Therefore, the magnitude of skewness variation data at each depth measuring point is compared with its corresponding threshold to ensure the accuracy of the skewness variation determination for each individual measuring point. Drilling depth segmentation needs to be based on the overall skewness variation across the entire depth, requiring a comprehensive analysis and integration of the skewness variation determination results from each depth measuring point to obtain the skewness variation determination result for the entire depth.
[0029] In this embodiment, the skewness variation amplitude data and corresponding skewness variation amplitude thresholds for each depth measuring point are acquired. The skewness variation amplitude data is obtained by screening the measured skewness across the entire borehole depth in the previous stage. The corresponding skewness variation amplitude thresholds are set according to the engineering construction specifications and geological conditions of the strata at each depth measuring point. The skewness variation amplitude data for each depth measuring point is compared one by one with its corresponding skewness variation amplitude threshold to determine the skewness variation judgment result for each depth measuring point. Subsequently, the skewness variation judgment results for all depth measuring points are sorted and summarized, integrating the scattered judgment results of individual measuring points into overall data covering the entire borehole depth, to obtain the skewness variation judgment result for the entire depth. Next, the skewness variation judgment result for the entire depth is processed, dividing continuous depth measuring points with consistent judgment results into a segment, to obtain the initial screening data for borehole depth segments. Then, combined with the actual drilling depth, measuring point layout spacing, and geological stratification, the segment boundaries of the initial screening data are adjusted and corrected to eliminate boundary deviations, resulting in the calibration data for borehole depth segments. Finally, the borehole depth segment calibration data undergoes processing such as defining interval ranges, standardizing formats, and supplementing information to determine the borehole depth segment result data. For example, the threshold for the deviation rate variation of each depth measuring point in a borehole is set according to the geological hardness of the corresponding depth. After comparison and integration, the full-depth judgment result is obtained. After dividing into initial screening segments and calibrating the boundaries, the borehole depth segment result data is obtained through structured processing.
[0030] In this embodiment, the interpolation type for each depth segment is determined based on the borehole depth segmentation results. For each interpolation type, the initial coordinate calculation data for non-fixed depths is interpolated to obtain identifiable coordinate parameters, including: Extract the segmentation type of each depth segment in the borehole depth segmentation results. If the segmentation type is the same depth segment, the interpolation type of the depth segment is linear interpolation; if the segmentation type is an independent depth segment, the interpolation type of the depth segment is quadratic interpolation. For depth segments where the interpolation type data is linear interpolation, linear interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the same segment; for depth segments where the interpolation type data is quadratic interpolation, quadratic interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the independent segment. By integrating the coordinates of the same segment and the coordinates of independent segments, identifiable coordinate parameters are obtained; The same segment of depth is defined as a segment in which the deviation rate change of each depth measuring point within the segment is less than or equal to the corresponding deviation rate change threshold; the independent segment of depth is defined as a segment in which at least one depth measuring point within the segment has a deviation rate change greater than the corresponding deviation rate change threshold.
[0031] In this embodiment, the interpolation type is determined based on the segment type of the depth segments and is a specific method used to interpolate the initial coordinate calculation data for non-fixed depths. The segment type is a category after classifying each depth segment, divided into two types: depth segments within the same segment and depth segments within independent segments. A depth segment within the same segment is a segment where the skewness change amplitude of each depth measuring point within that segment is less than or equal to the corresponding skewness change amplitude threshold. A depth segment within an independent segment is a segment where the skewness change amplitude of at least one depth measuring point within that segment is greater than the corresponding skewness change amplitude threshold. Linear interpolation is a simple interpolation method, while quadratic interpolation is a more accurate interpolation method. The initial coordinate calculation data for non-fixed depths is the basic coordinate calculation data corresponding to depths that are not laid out at fixed intervals. The coordinates within the same segment are the coordinate data obtained after linear interpolation of the initial coordinate calculation data for non-fixed depths within the same depth segment. The coordinates of an independent segment are the coordinate data obtained after quadratic interpolation of the initial coordinate calculation data for non-fixed depths within an independent depth segment. Identifiable coordinate parameters are those coordinate-related parameters that can be recognized and processed by subsequent processes after integrating coordinates of the same segment and independent segments. For example, if the skewness changes of all measuring points within a certain depth segment meet the requirements, then that segment is a depth segment of the same segment, and the corresponding interpolation type is linear interpolation.
[0032] Considering the differences in skewness variation characteristics across different depth segments—segmentation within the same depth segment exhibits stable skewness variation, while skewness variation in independent depth segments shows anomalies—it is necessary to determine the corresponding interpolation type based on the segment type to ensure that the interpolation accuracy matches the segment skewness variation characteristics. Linear interpolation is suitable for intervals with stable data, while quadratic interpolation is suitable for intervals with large data fluctuations. Therefore, linear interpolation is used for depth segments within the same depth segment, and quadratic interpolation is used for depth segments in independent depth segments. Furthermore, there is a need for coordinate calculations at non-fixed depths during construction, requiring separate processing for different interpolation types to ensure that the initial coordinate calculation data at non-fixed depths can be converted into valid coordinates.
[0033] In this embodiment, the previously determined borehole depth segmentation results are obtained, and the segmentation type of each depth segment in the borehole depth segmentation results is extracted one by one. Combining the definitions of depth segments within the same segment and depth segments of independent segments, the category of each depth segment is determined. If the skewness change amplitude data of each depth measuring point within a certain depth segment is less than or equal to the corresponding skewness change amplitude threshold, then the segment type is determined to be a depth segment within the same segment, and the interpolation type of the depth segment is determined to be linear interpolation. If the skewness change amplitude data of at least one depth measuring point within a certain depth segment is greater than the corresponding skewness change amplitude threshold, then the segment type is determined to be a depth segment of independent segments, and the interpolation type of the depth segment is determined to be quadratic interpolation. Subsequently, the initial coordinate calculation data of non-fixed depth is obtained. This data is calculated from data such as non-fixed depth skewness angle and drilling depth collected by the borehole surveying instrument. For depth segments using linear interpolation, linear interpolation is employed. Coordinate data from two adjacent fixed-depth measuring points within the segment are selected, and the initial coordinates for non-fixed depths within that segment are calculated linearly. For depth segments using quadratic interpolation, quadratic interpolation is employed. Coordinate data from three adjacent fixed-depth measuring points within the segment are selected, and the initial coordinates for non-fixed depths within that segment are calculated through curve fitting. Finally, all coordinates for the same segment and independent segments are sorted and summarized in depth order to form identifiable coordinate parameters. For example, in a borehole with multiple depth segments, segments with stable skewness are processed using linear interpolation for non-fixed depth coordinates, while segments with abnormal skewness are processed using quadratic interpolation. The resulting integrated parameters are identifiable.
[0034] This embodiment determines the interpolation type for each depth segment based on the borehole depth segmentation results, achieving precise matching between the interpolation type and the segment skewness variation characteristics, thus avoiding coordinate calculation deviations caused by a single interpolation method. Initial coordinate calculation data for non-fixed depths are processed separately for different interpolation types, improving the calculation accuracy of non-fixed depth coordinates. By integrating coordinates from the same segment and independent segments, standardized and identifiable coordinate parameters are obtained, solving the problem of ineffective utilization of non-fixed depth coordinates.
[0035] S103: Determine the deviation threshold and deviation rate threshold for each depth layer based on engineering construction specification data.
[0036] In this embodiment, the engineering construction specification data refers to a set of industry standards, technical specifications, and engineering design requirements that guide the construction of freezing holes and deviation monitoring. Depth-level strata are defined by dividing the borehole into different depth intervals based on geological conditions and construction process requirements across the entire borehole depth. The deviation exceeding threshold is a critical value determined based on the engineering construction specification data, used to determine whether the actual deviation of the borehole location exceeds the allowable range. The deviation exceeding threshold for each depth-level stratum is a threshold set individually for each stratum. The deviation rate exceeding threshold for each depth-level stratum is a critical value set individually for each stratum, used to determine whether the measured deviation rate of the borehole exceeds the allowable range. For example, for a certain depth-level stratum of 20 to 50 meters, according to the engineering construction specification data, both the deviation exceeding threshold and the deviation rate exceeding threshold for this stratum are clearly defined.
[0037] Considering the differences in geological conditions and construction requirements at different depth levels, a single threshold cannot meet the deviation determination needs of all levels. Therefore, thresholds need to be set separately for each depth level. Engineering construction specification data is the core basis for freezing hole construction. Determining the threshold based on this data ensures that the threshold setting conforms to industry standards and engineering realities, guaranteeing the rationality of deviation determination.
[0038] For example, this embodiment collects engineering construction specification data, which comes from industry-published freezing method construction specifications, engineering design documents, and on-site construction technical requirements, including deviation control standards corresponding to different geological conditions and different depth strata. Subsequently, the entire borehole depth is divided into depth-level strata. Combined with the borehole geological survey report, and based on factors such as stratum lithology and drilling difficulty, the entire borehole depth is divided into multiple continuous depth-level strata. Next, for each depth-level stratum, the corresponding deviation control standard is extracted from the engineering construction specification data. Considering the construction importance and geological risk level of that stratum, the deviation exceeding threshold for that depth-level stratum is determined through standard comparison and engineering experience verification. Simultaneously, using the same method, the corresponding deviation rate control standard is extracted from the engineering construction specification data. Combined with the drilling process requirements for that depth-level stratum, the deviation rate exceeding threshold for that depth-level stratum is determined. Finally, the deviation exceeding thresholds and deviation rate exceeding thresholds for all depth-level strata are organized in depth order to form a complete set of depth-level stratum thresholds for subsequent deviation determination. For example, a borehole is divided into depth layers of 0 to 20 meters, 20 to 50 meters, and 50 to 100 meters. The corresponding standard specifications are extracted for each layer, and the deviation threshold and deviation rate threshold for each layer are determined.
[0039] Thresholds are determined based on engineering construction specifications to ensure that the threshold settings conform to industry standards and engineering realities, avoiding misjudgments of deviation due to unreasonable thresholds. Deviation and deviation rate thresholds are set separately for different depth layers to adapt to the construction needs and geological differences of different layers, improving the accuracy of deviation judgment.
[0040] S104: Perform threshold comparison on the actual borehole offset and actual borehole offset rate in the borehole deviation data to obtain the offset exceeding the standard judgment result and the offset exceeding the standard judgment result. Based on the offset exceeding the standard judgment result and the offset exceeding the standard judgment result, classify the identifiable coordinate parameters to obtain standardized coordinates.
[0041] In this embodiment, the actual hole position offset is the horizontal deviation distance between the actual hole position and the designed hole position. The actual hole position offset rate is the actual deviation degree corresponding to each unit drilling depth. Threshold comparison is the process of comparing the actual hole position offset and the actual hole position offset rate with the corresponding exceedance threshold to determine whether they exceed the allowable range. The offset exceedance judgment result is the conclusion obtained after comparing the actual hole position offset with the offset exceedance threshold to determine whether the offset exceeds the allowable range. The offset rate exceedance judgment result is the conclusion obtained after comparing the actual hole position offset with the offset rate exceedance threshold to determine whether the offset rate exceeds the allowable range. Standardized coordinates are the standardized, unified coordinate data that can be directly used for subsequent matching obtained after classifying identifiable coordinate parameters according to the offset and offset rate exceedance judgment results. For example, if the actual hole position offset of a certain depth measuring point does not exceed the allowable range after threshold comparison, this conclusion is the offset exceedance judgment result.
[0042] Considering that the actual offset and actual offset rate of the hole position are the core indicators for measuring the deviation status of the freezing hole, they need to be compared with the corresponding exceeding thresholds to comprehensively determine whether the deviation exceeds the allowable range. Therefore, it is necessary to obtain the offset exceeding the standard judgment result and the deviation rate exceeding the standard judgment result separately. The identifiable coordinate parameters do not reflect whether the deviation exceeds the standard and cannot be directly used for subsequent drawing parameter matching. It is necessary to classify them based on the two types of judgment results to associate the coordinate parameters with the deviation judgment results.
[0043] In this embodiment, the actual borehole offset and actual borehole offset rate are obtained from the borehole deviation data. This data is collected in real time during the drilling process using a borehole surveying instrument. The actual borehole offset is calculated by the coordinate difference between the measured borehole position and the designed borehole position, and the actual borehole offset rate is calculated by the ratio of the measured deviation angle to the drilling depth. Simultaneously, the previously determined offset and offset rate exceedance thresholds for different depth layers are retrieved to ensure that each depth measuring point corresponds to its respective layer's threshold. Then, the actual borehole offset at each depth measuring point is compared one by one with the offset exceedance threshold for the corresponding depth layer. If the actual borehole offset is greater than the threshold, it is determined to be exceedance; if it is less than or equal to the threshold, it is determined to be within the limit, thus obtaining the offset exceedance determination result for each depth measuring point. Using the same method, the actual borehole offset rate at each depth measuring point is compared one by one with the offset rate exceedance threshold for the corresponding depth layer, thus obtaining the offset rate exceedance determination result for each depth measuring point. Next, the previously obtained identifiable coordinate parameters are retrieved and classified based on the two types of judgment results. Coordinates with both offset and skewness within the limits are grouped into one category, while coordinates with either offset or skewness exceeding the limits are classified into corresponding categories according to the type of exceedance. Finally, the classified coordinate parameters are formatted and annotated to obtain standardized coordinates. For example, after comparing the actual offset and skewness of multiple depth measuring points in a borehole with thresholds, they are classified according to the exceedance situation, and standardized coordinates are obtained after formatting.
[0044] This embodiment achieves a comprehensive and accurate determination of the deviation status of frozen holes by comparing the actual offset and actual deviation rate of the hole positions with thresholds, avoiding misjudgments caused by relying on a single indicator. Based on the two types of determination results, identifiable coordinate parameters are classified, linking them to the deviation determination results and solving the problem of coordinate parameters lacking deviation attribute identifiers. The resulting standardized coordinate specifications provide a unified basis for subsequent matching with family library parameters and drawing deviation diagrams, improving the efficiency and accuracy of subsequent processes, ensuring that the deviation diagrams accurately reflect the deviation status of frozen holes, and providing support for construction safety management.
[0045] In this embodiment, the identifiable coordinate parameters include the identifiable coordinate parameters of multiple depth measurement points; based on the offset exceeding the standard determination result and the skewness exceeding the standard determination result, the identifiable coordinate parameters are classified to obtain standardized coordinates, including: Based on the identifiable coordinate parameters of each depth measuring point, the corresponding offset exceeding judgment results are matched to obtain the offset-related coordinates of each depth measuring point. Based on the offset correlation coordinates of each depth measuring point, the corresponding offset rate exceeding the standard judgment result is matched to obtain the dual index correlation coordinates of each depth measuring point. The dual-index correlated coordinates of each depth measuring point are classified according to the type of exceedance, and the classified coordinates of each depth measuring point are obtained. The classification coordinates of each depth measurement point are sequentially integrated to obtain a full depth classification coordinate set; The full-depth classification coordinate set is formatted to obtain standardized coordinates.
[0046] In this embodiment, the offset-related coordinates are coordinate data with offset judgment information obtained by matching the identifiable coordinate parameters of each depth measuring point with their respective offset exceeding judgment results. The dual-index associated coordinates are coordinate data with two types of judgment information obtained by matching the offset-related coordinates of each depth measuring point with their respective offset exceeding judgment results. The categorized coordinates are coordinate data obtained by classifying the dual-index associated coordinates of each depth measuring point according to the exceeding type. The full-depth categorized coordinate set is the overall coordinate set formed by integrating the categorized coordinates of all depth measuring points in depth order. Format standardization processing is the process of uniformly adjusting the format and standardizing the information of the coordinate set. For example, after matching the identifiable coordinate parameters of a certain depth measuring point with its offset exceeding judgment result, the offset-related coordinates of that measuring point can be obtained.
[0047] Considering that the identifiable coordinate parameters contain the coordinate information of multiple depth measurement points, each measurement point needs to be processed one by one to ensure that the coordinates of each measurement point are accurately associated with the judgment result. Therefore, the corresponding judgment result is matched based on the identifiable coordinate parameters of each depth measurement point.
[0048] For example, this embodiment retrieves the identifiable coordinate parameters obtained through interpolation in the previous stage. These parameters include identifiable coordinate parameters for multiple depth measurement points. Each identifiable coordinate parameter is obtained by interpolation of the non-fixed depth initial coordinate calculation data of the corresponding depth measurement point. Simultaneously, it retrieves the offset exceeding the standard judgment results and offset rate exceeding the standard judgment results for each depth measurement point obtained in the previous stage, ensuring that the judgment result for each depth measurement point corresponds one-to-one with its identifiable coordinate parameters. Then, based on the identifiable coordinate parameters of each depth measurement point, it matches their respective offset exceeding the standard judgment results one by one, and associates and binds the judgment results with the coordinate parameters to obtain the offset-related coordinates of each depth measurement point. Next, based on the offset-related coordinates of each depth measurement point, it matches their respective offset rate exceeding the standard judgment results one by one, further associating the offset rate judgment information to obtain the dual-index related coordinates of each depth measurement point. Then, the dual-index related coordinates of each depth measurement point are divided according to the exceeding type, categorizing them into four types: offset and offset rate not exceeding the standard, offset only exceeding the standard, offset rate only exceeding the standard, and both exceeding the standard, to obtain the classified coordinates of each depth measurement point. Next, following the distribution order of the measuring points throughout the borehole's full depth, the categorized coordinates of all depth measuring points are compiled and summarized to obtain a full-depth categorized coordinate set. Finally, the full-depth categorized coordinate set undergoes processing such as coordinate format standardization, information annotation standardization, and redundant information removal to obtain standardized coordinates. For example, if a borehole has 50 depth measuring points, the identifiable coordinate parameters of each measuring point are matched with the two classification results one by one. After classification, the coordinates are integrated in depth order and standardized after formatting to obtain standardized coordinates.
[0049] This embodiment ensures accurate association between the coordinates of each measurement point and the offset and deviation rate exceeding the standard by matching the judgment results step by step according to individual depth measurement points, thus avoiding association errors. The coordinates associated with the two indicators are classified to clearly distinguish the coordinates of different exceeding types, facilitating subsequent targeted processing. The classified coordinates are then sequentially integrated and formatted to obtain standardized coordinates, solving the problems of chaotic coordinate data and lack of judgment association information.
[0050] S105: Match the standardized coordinates with the family library parameters, and incorporate the results of the skewness exceeding the standard and the skewness exceeding the standard into the matching process as a new matching dimension to obtain the skew plot drawing parameters.
[0051] In this embodiment, standardized coordinates are matched with family library parameters, and the skewness exceedance judgment results and skewness rate exceedance judgment results are incorporated into the matching process as a new matching dimension to obtain skew plotting parameters, including: Based on standardized coordinates, the family library parameter index matching is performed to obtain the basic parameters of the family library for each depth measurement point. Based on the offset exceedance judgment results data, determine the offset exceedance visualization annotation parameters for each depth measuring point; Based on the data of the deviation rate exceeding the standard, determine the visual annotation parameters for deviation rate exceeding the standard at each depth measurement point; The deviation exceeding the standard visualization annotation parameters and the deviation rate exceeding the standard visualization annotation parameters of each depth measuring point are fused to obtain the comprehensive exceeding standard visualization annotation parameters; The comprehensive out-of-specification visualization annotation parameters are embedded into the basic parameters of the family library for matching each depth measurement point, and the matching dimension is expanded to obtain the family library matching parameters with the out-of-specification dimension. Based on the matching parameters of the family library with out-of-standard dimensions, the coordinates of each depth measurement point in the standardized coordinates are subjected to single-point parameter binding processing to obtain the drawing parameter set of each depth measurement point; The plotting parameter sets for each depth measurement point are structured and integrated to obtain the skew plotting parameters.
[0052] In this embodiment, the family library parameters are a set of preset parameters used to match standardized coordinates and support skew plot drawing. The basic family library parameters are the basic family library parameters corresponding to each depth measurement point after the standardized coordinates are matched with the family library parameters. The off-axis excess visualization annotation parameters are parameters used to visually annotate off-axis excess situations in the skew plot based on the off-axis excess judgment result data. The skew rate excess visualization annotation parameters are parameters used to annotate skew rate excess situations in the skew plot based on the skew rate excess judgment result data. The comprehensive excess visualization annotation parameters are unified annotation parameters obtained by fusing the off-axis and skew rate excess visualization annotation parameters. The family library matching parameters with excess dimensions are family library parameters after embedding the comprehensive excess visualization annotation parameters and expanding the matching dimensions. The drawing parameter set is a set of skew plot drawing-related parameters corresponding to each depth measurement point. The skew plot drawing parameters are the final parameters used to draw the skew plot after integrating all depth measurement point drawing parameters. For example, after matching the standardized coordinates of a depth measurement point with the family library parameters, the basic family library parameters matched for that measurement point can be obtained.
[0053] Since standardized coordinates need to be combined with family library parameters to be transformed into parameters usable for plotting, it is necessary to match the standardized coordinates with the family library parameters. The results of skewness and skewness exceeding the limit are core information of the skew plot and need to be incorporated into the matching process as a new dimension so that the plotting parameters simultaneously include coordinate information and exceeding the limit information.
[0054] For example, this embodiment retrieves previously obtained standardized coordinates and preset family library parameters. The family library parameters include basic drawing parameters corresponding to different coordinates. Using a parameter index matching method, based on the standardized coordinates of each depth measurement point, the corresponding family library parameters are retrieved and matched in the family library to obtain the basic family library parameters matched for each depth measurement point. Simultaneously, the previously obtained offset exceedance judgment result data and skewness exceedance judgment result data for each depth measurement point are retrieved. Based on the offset exceedance judgment result data and combined with engineering visualization annotation specifications, the offset exceedance visualization annotation parameters for each depth measurement point are determined, including annotation color and annotation style. Based on the skewness exceedance judgment result data, the skewness exceedance visualization annotation parameters for each depth measurement point are determined in the same way. Subsequently, the offset exceedance visualization annotation parameters and skewness exceedance visualization annotation parameters for each depth measurement point are fused, prioritizing the retention of key exceedance information to obtain the comprehensive exceedance visualization annotation parameters for each depth measurement point. Next, the comprehensive exceedance visualization annotation parameters are embedded into the corresponding depth measurement point's matched family library basic parameters, expanding the dimensions of the family library matching to obtain the family library matching parameters for each depth measurement point with exceedance dimensions. Next, based on the family library matching parameters with out-of-standard dimensions, the coordinates of each depth measuring point in the standardized coordinate system are bound to individual point parameters, mapping the coordinates one-to-one with the matching parameters to obtain the drawing parameter set for each depth measuring point. Finally, the drawing parameter sets of all individual depth measuring points are sorted and organized, and integrated into the full-depth skew plot drawing parameters in depth order. For example, for a borehole with 40 depth measuring points, the family library matching, out-of-standard annotation parameter determination and fusion are completed for each measuring point one by one, and then the drawing parameters of all measuring points are integrated to obtain the skew plot drawing parameters.
[0055] This embodiment expands the matching dimension by matching standardized coordinates with family library parameters and combining the results of deviation and skewness exceeding the standard, so that the drawing parameters contain both coordinate information and exceeding the standard information, thus solving the problem that traditional drawing parameters only contain coordinates and lack exceeding the standard indicators.
[0056] In this embodiment, the deviation exceeding the standard visualization annotation parameters and the deviation rate exceeding the standard visualization annotation parameters of each depth measuring point are fused to obtain the comprehensive exceeding standard visualization annotation parameters, including: Based on the deviation exceeding the standard visualization annotation parameters of each depth measurement point, the deviation annotation feature data of each depth measurement point is determined. Based on the skewness exceeding the standard visualization annotation parameters of each depth measurement point, the skewness annotation feature data of each depth measurement point is determined. Priority determination processing is performed on the offset annotation feature data of each depth measuring point to obtain the offset priority annotation data of each depth measuring point. Based on the skewness annotation feature data of each depth measurement point and the corresponding offset priority annotation data, the fused annotation feature data of each depth measurement point is obtained; The fusion and annotation feature data of each depth measurement point are traversed and integrated to obtain comprehensive over-standard visualization annotation parameters.
[0057] In this embodiment, the offset annotation feature data is data extracted from the offset exceedance visualization annotation parameters of each depth measuring point, which can reflect the core information of offset exceedance annotation. The skewness annotation feature data is data extracted from the skewness exceedance visualization annotation parameters of each depth measuring point, which can reflect the core information of skewness exceedance annotation. The priority determination process is the process of determining the importance of the offset annotation feature data and determining its annotation priority. The offset priority annotation data is the offset annotation data with priority annotation rights obtained after the priority determination of the offset annotation feature data. The fusion annotation feature data is the unified annotation feature data obtained by combining the skewness annotation feature data of each depth measuring point with the corresponding offset priority annotation data. The traversal integration process is the process of sorting and summarizing the fusion annotation feature data of all depth measuring points point by point. For example, the offset exceedance visualization annotation parameters of a certain depth measuring point include annotation color and style. By extracting its core color information, the offset annotation feature data of that measuring point can be obtained.
[0058] Considering that the visualization annotation parameters for skewness exceeding the standard and the visualization annotation parameters for skewness exceeding the standard contain redundant information, core feature data needs to be extracted to achieve effective fusion. Therefore, skewness and skewness annotation feature data are determined separately.
[0059] In this embodiment, the pre-determined visual annotation parameters for deviation exceeding the standard and deviation rate exceeding the standard for each depth measuring point are retrieved. These two types of parameters are determined based on the deviation and deviation rate exceeding the standard judgment results data of the corresponding depth measuring points, combined with the engineering visualization annotation specifications, and include information such as annotation color, style, and position. Based on the visual annotation parameters for deviation exceeding the standard for each depth measuring point, the content that reflects the core information of deviation exceeding the standard is extracted to obtain the deviation annotation feature data of each depth measuring point. Based on the visual annotation parameters for deviation rate exceeding the standard for each depth measuring point, the core annotation information of deviation rate exceeding the standard is extracted to obtain the deviation rate annotation feature data of each depth measuring point. Subsequently, considering the degree of impact of deviation exceeding the standard on construction safety during engineering construction, the deviation annotation feature data of each depth measuring point is prioritized to determine the deviation priority annotation data, and high-priority deviation annotation information is retained first. Next, based on the deviation rate annotation feature data of each depth measuring point and the corresponding deviation priority annotation data, the two types of data are fused, duplicate information is removed, and missing information is supplemented to obtain the fused annotation feature data of each depth measuring point. Finally, the fused labeled feature data of all depth measurement points are sorted and summarized point by point, and integrated into a unified parameter set according to depth order to obtain the comprehensive out-of-specification visualization labeling parameters. For example, the offset labeling feature data of multiple depth measurement points of a borehole are prioritized and then fused with the corresponding offset rate labeling feature data. After traversing and integrating, the comprehensive out-of-specification visualization labeling parameters are obtained.
[0060] This embodiment improves the relevance and effectiveness of annotation data by extracting skewness and skewness annotation feature data and eliminating redundant information. Prioritization of skewness annotation feature data ensures that key out-of-specification information is reflected first, avoiding annotation confusion. Combined annotation data from both types of data to obtain fused annotation feature data, achieving unified integration of out-of-specification annotation information and solving the problem of the two types of annotation parameters existing independently and being difficult to use collaboratively. All fused annotation feature data is traversed and integrated to obtain standardized and unified comprehensive out-of-specification visualization annotation parameters, providing accurate support for subsequent embedding of family library basic parameters and generation of skew plot drawing parameters, improving the standardization and accuracy of skew plot out-of-specification annotation.
[0061] S106: Based on the skew diagram drawing parameters, the skew diagram of the frozen hole is drawn through parametric modeling.
[0062] In this embodiment, the deflection diagram of the frozen hole is drawn using parametric modeling based on the deflection diagram drawing parameters, including: Redundant information is removed from the skew plotting parameters to obtain the initial skew plotting parameters. Based on the initial skew plot parameters, determine the adaptation parameters for the parametric modeling tool; The single-hole coordinates and foundation drawing parameters in the adaptation parameters are processed by trajectory drawing to obtain the single-freezing-hole foundation deviation trajectory diagram; Based on the out-of-standard annotation parameters in the adaptation parameters, the out-of-standard marking processing is performed on the single freezing hole foundation deviation trajectory diagram to obtain the single freezing hole marked deviation diagram. The single-freezing-hole label deviation diagram is processed by hole position alignment and integration to obtain a multi-freezing-hole combined deviation diagram; Auxiliary annotations were added to the skew diagram of multiple frozen holes to obtain a complete draft of the skew diagram of frozen holes. The initial draft of the complete frozen hole deviation diagram is subjected to accuracy verification processing to obtain the frozen hole deviation diagram.
[0063] In this embodiment, the parametric modeling method controls the drawing process through preset parameters, achieving standardized and automated drawing of skew maps. Redundant information removal involves filtering the skew map drawing parameters to remove useless and repetitive information. The initial skew map drawing parameters are those retaining core drawing information after redundant information removal. Adaptation parameters are those adjusted based on the initial skew map drawing parameters to adapt to the parametric modeling tool. Single-hole coordinates are the coordinate data of each depth measurement point of a single frozen hole, and the basic drawing parameters are the fundamental parameters supporting the drawing of the skew trajectory. Trajectory drawing is the process of drawing the skew trajectory of a frozen hole based on the single-hole coordinates and the basic drawing parameters. The basic skew trajectory diagram of a single frozen hole is a basic diagram containing only the skew trajectory of a single frozen hole, without any markings indicating exceeding the standard. Exceeding standard marking is the process of adding relevant marking information to the basic skew trajectory diagram. The marked skew map of a single frozen hole is a skew map of a single frozen hole marked with an exceeding standard marker. Hole alignment and integration is the process of aligning and integrating multiple single frozen hole marker deviation diagrams according to their designed hole positions. A multi-frozen hole combined deviation diagram is a combined diagram obtained after integrating multiple single frozen hole marker deviation diagrams. Adding auxiliary annotations is the process of adding annotation information, legends, and other auxiliary content to the combined deviation diagram. A complete frozen hole deviation diagram draft is a draft of the deviation diagram after adding auxiliary annotations, but without accuracy verification. Accuracy verification is the process of checking and correcting the drawing accuracy of the draft deviation diagram. The frozen hole deviation diagram is the final deviation diagram that has undergone accuracy verification and can be used for engineering monitoring. For example, after trajectory drawing processing, a single frozen hole can obtain a single frozen hole foundation deviation trajectory diagram.
[0064] For example, this embodiment retrieves the previously obtained skew map drawing parameters. These parameters are the result of a structured integration of all depth measurement point drawing parameter sets, including coordinates, out-of-range annotations, basic drawing information, and other related information. The skew map drawing parameters are filtered, removing duplicate coordinate data, useless annotation information, and redundant parameter content, resulting in initial skew map drawing parameters that retain only core drawing information. Subsequently, based on the initial skew map drawing parameters and combined with the parameter requirements of the parametric modeling tool, the parameter format is adjusted, and the basic configuration information required for modeling is supplemented to determine the adaptation parameters for the parametric modeling tool, ensuring that the adaptation parameters can be recognized and called by the modeling tool. Next, the single-hole coordinates and basic drawing parameters are extracted from the adaptation parameters. Using a trajectory drawing algorithm, the skew trajectory of a single frozen hole is drawn according to the depth order and skew state of the single-hole coordinates, resulting in a basic skew trajectory map of a single frozen hole. Then, the out-of-range annotation parameters are extracted from the adaptation parameters. Using an annotation method, out-of-range annotations are added to the basic skew trajectory map of the single frozen hole at the positions corresponding to the out-of-range depth measurement points, completing the out-of-range annotation processing, resulting in a labeled skew map of a single frozen hole. Then, for multiple single-hole skew maps, a hole alignment algorithm is used to align them according to the designed hole coordinates of each hole, followed by integration to obtain a multi-hole combined skew map. Subsequently, auxiliary annotations such as depth scales, out-of-specification symbols, hole numbering, and titles are added to the multi-hole combined skew map to obtain a complete draft of the skew map. Finally, the trajectory coordinates and out-of-specification symbol positions in the draft skew map are compared with actual measurement data and specification requirements to correct drawing deviations and complete accuracy verification, resulting in the final skew map. For example, in a project with 30 skew maps, the basic trajectory drawing and out-of-specification symbol annotations for each skew map are completed sequentially. Then, all single-hole skew maps are aligned and integrated, auxiliary annotations are added, and accuracy is verified to obtain the final skew map.
[0065] This embodiment improves drawing efficiency and avoids drawing errors caused by redundant information by eliminating redundant information in the skew diagram drawing parameters. Determining suitable parameters ensures the normal operation of parametric modeling tools, enabling automated skew diagram drawing. The process involves step-by-step completion of trajectory drawing, out-of-range annotation, hole alignment, and auxiliary annotation, ensuring that the skew diagram fully presents the skew trajectory while clearly annotating out-of-range information. Precision verification corrects drawing deviations, improving the accuracy of the skew diagram drawing and accurately reflecting the skew status of frozen holes, meeting the high-precision monitoring requirements of engineering projects. It also enables rapid drawing of batch frozen hole skew diagrams, adapting to the needs of batch construction monitoring in engineering projects.
[0066] As can be seen from the above, the embodiments of this application automatically traverse and screen the measured deviation rate across the entire borehole depth, segment the depth based on the deviation rate variation, and process the coordinate data using differentiated interpolation methods according to different segment types. This avoids the trajectory distortion problems caused by traditional manual calculations and single interpolation methods, making the borehole deviation trajectory more closely resemble the actual construction state and significantly improving the accuracy of deviation description. Simultaneously, the embodiments of this application automatically determine the threshold for each depth layer according to engineering construction specifications and quickly compare and judge the actual borehole offset and deviation rate, achieving automatic classification and standardization of coordinate data. This eliminates a large number of manual verification, classification, and organization steps, significantly reducing human error and improving data processing efficiency.
[0067] Furthermore, this embodiment automatically matches standardized coordinates with family library parameters and incorporates offset and skewness determination results into the matching dimension to automatically generate skewness diagram drawing parameters. Then, through parametric modeling, the skewness diagram of the frozen hole is drawn, achieving full automation from raw data to the final chart, eliminating the need for manual point-by-point drawing and segment-by-segment labeling. This embodiment improves the accuracy of skewness diagram drawing, enhances the efficiency and standardization of frozen hole skewness diagram drawing, and can quickly and intuitively reflect the skewness status of frozen holes, providing efficient and accurate data support for on-site construction monitoring and safety management.
[0068] For example, this embodiment uses the built-in VBA programming function of Excel to realize the batch conversion and rapid calculation of inclinometer data, forming parameters that can be recognized by the Dynamo program. Combined with the Revit family library, it realizes parametric modeling and one-click inclinometer image drawing. It can interactively generate inclinometer images at different depths and layers according to the changes in layer and depth, and realize interactive switching between two-dimensional graphics and three-dimensional models.
[0069] After acquiring borehole deviation data using a gyroscope at the construction site, the deviation data is quickly converted into parameters recognizable by Revit families and Dynamo programs using Excel programming. Then, the Revit Dynamo plugin calls the family library parameters to generate real-time deviation and total deviation plots. After exporting the generated deviation images, hole spacing analysis and subsequent freeze analysis can be performed.
[0070] This embodiment can be implemented using the software's built-in functions and plugins. The program within the plugin is packaged as a file, and at runtime, only the program file needs to be opened and the field measurement data imported. A single person can complete the data conversion and graphic drawing, resulting in low operating costs. This embodiment has been tested and applied in the Gaojiabao return air shaft project and the Zhaoshipan project. The drawing is simple and quick, highly operable, and can conveniently and accurately view the borehole deviation and maximum borehole spacing at different locations in real time. It can be widely promoted in drilling construction projects.
[0071] Based on the same principle as the skew diagram drawing method based on programming modeling provided in the embodiments of this application, the embodiments of this application also provide a skew diagram drawing device based on programming modeling, such as... Figure 2 As shown, the skew plot drawing device 20 based on programming modeling may specifically include: a skewness change amplitude determination module 21, a coordinate parameter determination module 22, an exceedance threshold determination module 23, a standardized coordinate generation module 24, a skew plot drawing parameter generation module 25, and a skew plot drawing module 26, wherein, The deviation rate change amplitude determination module 21 is used to determine the deviation rate change amplitude threshold based on the measured deviation rate of the borehole in the borehole deviation data, and to perform a traversal screening process on the measured deviation rate of the entire borehole depth to obtain the deviation rate change amplitude data of multiple depth measuring points. The coordinate parameter determination module 22 is used to determine the borehole depth segmentation results based on the skewness change amplitude data and the skewness change amplitude threshold, determine the interpolation type of each depth segment based on the borehole depth segmentation results, and perform interpolation processing on the initial coordinate calculation data of non-fixed depth for different interpolation types to obtain identifiable coordinate parameters. The threshold determination module 23 is used to determine the deviation threshold and the deviation rate threshold for different depth layers based on engineering construction specification data. The standardized coordinate generation module 24 is used to perform threshold comparison on the actual hole position offset and actual hole position offset rate in the borehole deviation data to obtain the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result. Based on the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result, the identifiable coordinate parameters are classified to obtain standardized coordinates. The skew plot drawing parameter generation module 25 is used to match the standardized coordinates with the family library parameters, and incorporate the skewness exceeding the standard judgment result and the skewness rate exceeding the standard judgment result into the matching process as a new matching dimension to obtain the skew plot drawing parameters; The skew diagram drawing module 26 is used to draw the skew diagram of the frozen hole based on the skew diagram drawing parameters and through parametric modeling.
[0072] In one embodiment of this application, the coordinate parameter determination module 22 is specifically used for: The deviation rate change amplitude data of each depth measurement point is compared with their respective deviation rate change amplitude thresholds to determine the deviation rate change judgment result of each depth measurement point. The results of the deviation rate change judgment at each depth measurement point are traversed and integrated to obtain the deviation rate change judgment result for the entire depth. The results of the full-depth deviation rate change determination are divided into intervals to obtain the initial screening data of borehole depth segments; Boundary calibration processing is performed on the initial screening data of borehole depth segments to obtain borehole depth segment calibration data; The borehole depth segment calibration data is structured to determine the borehole depth segment result data.
[0073] In one embodiment of this application, the coordinate parameter determination module 22 is specifically used for: Extract the segmentation type of each depth segment in the borehole depth segmentation results. If the segmentation type is the same depth segment, the interpolation type of the depth segment is linear interpolation; if the segmentation type is an independent depth segment, the interpolation type of the depth segment is quadratic interpolation. For depth segments where the interpolation type data is linear interpolation, linear interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the same segment; for depth segments where the interpolation type data is quadratic interpolation, quadratic interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the independent segment. By integrating the coordinates of the same segment and the coordinates of independent segments, identifiable coordinate parameters are obtained; The same segment of depth is defined as a segment in which the deviation rate change of each depth measuring point within the segment is less than or equal to the corresponding deviation rate change threshold; the independent segment of depth is defined as a segment in which at least one depth measuring point within the segment has a deviation rate change greater than the corresponding deviation rate change threshold.
[0074] In one embodiment of this application, the identifiable coordinate parameters include the identifiable coordinate parameters of multiple depth measurement points; the standardized coordinate generation module 24 is specifically used for: Based on the identifiable coordinate parameters of each depth measuring point, the corresponding offset exceeding judgment results are matched to obtain the offset-related coordinates of each depth measuring point. Based on the offset correlation coordinates of each depth measuring point, the corresponding offset rate exceeding the standard judgment result is matched to obtain the dual index correlation coordinates of each depth measuring point. The dual-index correlated coordinates of each depth measuring point are classified according to the type of exceedance, and the classified coordinates of each depth measuring point are obtained. The classification coordinates of each depth measurement point are sequentially integrated to obtain a full depth classification coordinate set; The full-depth classification coordinate set is formatted to obtain standardized coordinates.
[0075] In one embodiment of this application, the skew plotting parameter generation module 25 is specifically used for: Based on standardized coordinates, the family library parameter index matching is performed to obtain the basic parameters of the family library for each depth measurement point. Based on the offset exceedance judgment results data, determine the offset exceedance visualization annotation parameters for each depth measuring point; Based on the data of the deviation rate exceeding the standard, determine the visual annotation parameters for deviation rate exceeding the standard at each depth measurement point; The deviation exceeding the standard visualization annotation parameters and the deviation rate exceeding the standard visualization annotation parameters of each depth measuring point are fused to obtain the comprehensive exceeding standard visualization annotation parameters; The comprehensive out-of-specification visualization annotation parameters are embedded into the basic parameters of the family library for matching each depth measurement point, and the matching dimension is expanded to obtain the family library matching parameters with the out-of-specification dimension. Based on the matching parameters of the family library with out-of-standard dimensions, the coordinates of each depth measurement point in the standardized coordinates are subjected to single-point parameter binding processing to obtain the drawing parameter set of each depth measurement point; The plotting parameter sets for each depth measurement point are structured and integrated to obtain the skew plotting parameters.
[0076] In one embodiment of this application, the skew plotting parameter generation module 25 is specifically used for: Based on the deviation exceeding the standard visualization annotation parameters of each depth measurement point, the deviation annotation feature data of each depth measurement point is determined. Based on the skewness exceeding the standard visualization annotation parameters of each depth measurement point, the skewness annotation feature data of each depth measurement point is determined. Priority determination processing is performed on the offset annotation feature data of each depth measuring point to obtain the offset priority annotation data of each depth measuring point. Based on the skewness annotation feature data of each depth measurement point and the corresponding offset priority annotation data, the fused annotation feature data of each depth measurement point is obtained; The fusion and annotation feature data of each depth measurement point are traversed and integrated to obtain comprehensive over-standard visualization annotation parameters.
[0077] In one embodiment of this application, the skew diagram drawing module 26 is specifically used for: Redundant information is removed from the skew plotting parameters to obtain the initial skew plotting parameters. Based on the initial skew plot parameters, determine the adaptation parameters for the parametric modeling tool; The single-hole coordinates and foundation drawing parameters in the adaptation parameters are processed by trajectory drawing to obtain the single-freezing-hole foundation deviation trajectory diagram; Based on the out-of-standard annotation parameters in the adaptation parameters, the out-of-standard marking processing is performed on the single freezing hole foundation deviation trajectory diagram to obtain the single freezing hole marked deviation diagram. The single-freezing-hole label deviation diagram is processed by hole position alignment and integration to obtain a multi-freezing-hole combined deviation diagram; Auxiliary annotations were added to the skew diagram of multiple frozen holes to obtain a complete draft of the skew diagram of frozen holes. The initial draft of the complete frozen hole deviation diagram is subjected to accuracy verification processing to obtain the frozen hole deviation diagram.
[0078] The apparatus in this application embodiment can execute the method provided in this application embodiment, and the implementation principle is similar. The actions performed by each module in the apparatus of each embodiment of this application correspond to the steps in the method of each embodiment of this application. For detailed functional descriptions of each module of the apparatus, please refer to the descriptions in the corresponding methods shown above, which will not be repeated here.
[0079] Figure 3 A schematic diagram of the structure of an electronic device to which this application embodiment applies is shown, such as... Figure 3 As shown, the electronic device can be used to implement the methods provided in any embodiment of this application.
[0080] like Figure 3 As shown, the electronic device 300 may primarily include at least one processor 301. Figure 3 The diagram shows components such as a memory 302, a communication module 303, and an input / output interface 304. Optionally, these components can be connected and communicate with each other via a bus 305. It should be noted that... Figure 3 The structure of the electronic device 300 shown is merely illustrative and does not constitute a limitation on the electronic devices to which the methods provided in the embodiments of this application are applicable.
[0081] The memory 302 can be used to store operating systems and applications, etc. The applications can include computer programs that implement the methods shown in the embodiments of this application when invoked by the processor 301, and can also include programs for implementing other functions or services. The memory 302 can be ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, RAM (Random Access Memory) or other types of dynamic storage devices that can store information and computer programs, or it can be EEPROM (Electrically Erasable Programmable Read Only Memory), CD-ROM (Compact Disc Read Only Memory) or other optical disc storage, optical disc storage (including compressed optical discs, laser discs, optical discs, digital universal optical discs, Blu-ray discs, etc.), magnetic disk storage media or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited thereto.
[0082] Processor 301 is connected to memory 302 via bus 305 and implements corresponding functions by calling the application programs stored in memory 302. Processor 301 can be a CPU (Central Processing Unit), a general-purpose processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array), or other programmable logic devices, transistor logic devices, hardware components, or any combination thereof. It can implement or execute the various exemplary logic blocks, modules, and circuits described in conjunction with the disclosure of this application. Processor 301 can also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, etc.
[0083] Electronic device 300 can connect to a network via communication module 303 (which may include, but is not limited to, components such as a network interface) to communicate with other devices (such as user terminals or servers) through the network and achieve data interaction, such as sending data to or receiving data from other devices. Communication module 303 may include wired network interfaces and / or wireless network interfaces, meaning the communication module may include at least one of wired or wireless communication modules.
[0084] The electronic device 300 can connect to necessary input / output devices, such as a keyboard and display device, via the input / output interface 304. The electronic device 300 itself may have a display device, and other external display devices can also be connected via the input / output interface 304. Optionally, a storage device, such as a hard drive, can also be connected via the input / output interface 304 to store data from the electronic device 300, retrieve data from the storage device, or store data from the storage device in the memory 302. It is understood that the input / output interface 304 can be a wired interface or a wireless interface. Depending on the actual application scenario, the device connected to the input / output interface 304 can be a component of the electronic device 300 or an external device connected to the electronic device 300 when needed.
[0085] The bus 305 used to connect the components may include a path for transmitting information between the components. The bus 305 may be a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus, etc. Depending on its function, the bus 305 may be divided into an address bus, a data bus, a control bus, etc.
[0086] Optionally, for the solution provided in the embodiments of this application, the memory 302 can be used to store a computer program that executes the solution of this application, and the processor 301 runs the computer program. When the processor 301 runs the computer program, it implements the operation of the method or apparatus provided in the embodiments of this application.
[0087] Based on the same principle as the method provided in the embodiments of this application, the embodiments of this application provide a computer-readable storage medium storing a computer program, which, when executed by a processor, can implement the corresponding content of the aforementioned method embodiments.
[0088] It should be noted that the terms "first," "second," "third," "fourth," "1," "2," etc. (if present) in the specification, claims, and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this application described herein can be implemented in a sequence other than that shown in the figures or text.
[0089] In the embodiments of this application, the terms "module" or "unit" refer to a computer program or part of a computer program that has a predetermined function and works with other related parts to achieve a predetermined goal, and can be implemented wholly or partially using software, hardware (such as processing circuitry or memory), or a combination thereof. Similarly, a processor (or multiple processors or memory) can be used to implement one or more modules or units. Furthermore, each module or unit can be part of an overall module or unit that includes the functionality of that module or unit.
[0090] It should be understood that although arrows indicate various operation steps in the flowcharts of this application's embodiments, the order in which these steps are implemented is not limited to the order indicated by the arrows. Unless explicitly stated herein, in some implementation scenarios of this application's embodiments, the implementation steps in each flowchart can be executed in other orders as required. Furthermore, some or all steps in each flowchart, based on the actual implementation scenario, may include multiple sub-steps or multiple stages. Some or all of these sub-steps or stages can be executed at the same time, and each sub-step or stage can also be executed at different times. In scenarios where execution times differ, the execution order of these sub-steps or stages can be flexibly configured according to requirements, and this application's embodiments do not limit this.
[0091] The above description is only an optional implementation method for some implementation scenarios of this application. It should be noted that for those skilled in the art, other similar implementation methods based on the technical concept of this application without departing from the technical concept of this application also fall within the protection scope of the embodiments of this application.
Claims
1. A method for drawing a skew plot based on a programmed modeling, characterized by, include: Based on the measured borehole deviation rate in the borehole deviation data, the threshold for the deviation rate change amplitude is determined, and the measured deviation rate of the entire borehole depth is screened to obtain the deviation rate change amplitude data of multiple depth measuring points. Based on the skewness change amplitude data and the skewness change amplitude threshold, the borehole depth segmentation result is determined. Based on the borehole depth segmentation result, the interpolation type of each depth segment is determined. For different interpolation types, the initial coordinate calculation data of non-fixed depths are interpolated to obtain identifiable coordinate parameters. Based on engineering construction specification data, the deviation exceeding threshold and the deviation rate exceeding threshold for each depth layer were determined respectively. The actual deviation of the borehole position and the actual deviation rate of the borehole position in the borehole deviation data are compared with thresholds to obtain the deviation exceeding the standard judgment result and the deviation rate exceeding the standard judgment result. Based on the deviation exceeding the standard judgment result and the deviation rate exceeding the standard judgment result, the identifiable coordinate parameters are classified to obtain standardized coordinates. The standardized coordinates are matched with the family library parameters, and the results of the skewness exceeding the standard and the skewness exceeding the standard are incorporated into the matching process as a new matching dimension to obtain the skew map drawing parameters. Based on the deflection diagram drawing parameters, the deflection diagram of the freezing hole is drawn using parametric modeling.
2. The programming-model-based skew plot drawing method of claim 1, wherein, The determination of borehole depth segmentation results based on the deviation rate change amplitude data and the deviation rate change amplitude threshold includes: The deviation rate change amplitude data of each depth measurement point is compared with their respective deviation rate change amplitude thresholds to determine the deviation rate change judgment result of each depth measurement point. The results of the deviation rate change judgment at each depth measurement point are traversed and integrated to obtain the deviation rate change judgment result for the entire depth. The results of the full-depth deviation rate change determination are divided into intervals to obtain the initial screening data of borehole depth segments; Boundary calibration processing is performed on the initial screening data of borehole depth segments to obtain borehole depth segment calibration data; The borehole depth segment calibration data is structured to determine the borehole depth segment result data.
3. The method for drawing skew diagrams based on programming modeling as described in claim 1, characterized in that, The method involves determining the interpolation type for each depth segment based on the borehole depth segmentation results, and then performing interpolation processing on the initial coordinate calculation data for non-fixed depths for different interpolation types to obtain identifiable coordinate parameters, including: Extract the segmentation type of each depth segment in the borehole depth segmentation result. If the segmentation type is a depth segment of the same segment, then the interpolation type of the depth segment is linear interpolation; if the segmentation type is a depth segment of independent segments, then the interpolation type of the depth segment is quadratic interpolation. For depth segments where the interpolation type data is linear interpolation, linear interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the same segment; for depth segments where the interpolation type data is quadratic interpolation, quadratic interpolation is performed on the initial coordinate calculation data of non-fixed depth to obtain the coordinates of the independent segment. The coordinates of the same segment and the coordinates of the independent segments are integrated to obtain the identifiable coordinate parameters; The depth segmentation of the same segment is defined as follows: the deviation rate change amplitude data of each depth measuring point within the segment is less than or equal to the corresponding deviation rate change amplitude threshold; the depth segmentation of an independent segment is defined as follows: the deviation rate change amplitude data of at least one depth measuring point within the segment is greater than the corresponding deviation rate change amplitude threshold.
4. The method for drawing skew diagrams based on programming modeling as described in claim 1, characterized in that, The identifiable coordinate parameters include identifiable coordinate parameters of multiple depth measurement points; the classification of the identifiable coordinate parameters based on the offset exceeding the standard determination result and the skewness exceeding the standard determination result to obtain standardized coordinates includes: Based on the identifiable coordinate parameters of each depth measuring point, the corresponding offset exceeding judgment results are matched to obtain the offset-related coordinates of each depth measuring point. Based on the offset correlation coordinates of each depth measuring point, the corresponding offset rate exceeding the standard judgment result is matched to obtain the dual index correlation coordinates of each depth measuring point. The dual-index correlated coordinates of each depth measuring point are classified according to the type of exceedance, and the classified coordinates of each depth measuring point are obtained. The classification coordinates of each depth measurement point are sequentially integrated to obtain a full depth classification coordinate set; The full-depth classification coordinate set is formatted to obtain standardized coordinates.
5. The method for drawing skew diagrams based on programming modeling as described in claim 1, characterized in that, The process of matching the standardized coordinates with the family library parameters, and incorporating the skewness exceedance judgment data and the skewness rate exceedance judgment data into the matching process as a new matching dimension, yields the skewness plotting parameters, including: Based on the standardized coordinates, family library parameter index matching is performed to obtain the basic parameters of the family library matched for each depth measurement point; Based on the offset exceeding the standard judgment result data, determine the offset exceeding the standard visualization annotation parameters for each depth measuring point; Based on the deviation rate exceeding the standard judgment result data, determine the deviation rate exceeding the standard visualization annotation parameters for each depth measurement point; The deviation exceeding the standard visualization annotation parameters and the deviation rate exceeding the standard visualization annotation parameters of each depth measuring point are fused to obtain the comprehensive exceeding standard visualization annotation parameters. The comprehensive out-of-standard visualization annotation parameters are embedded into the basic parameters of the family library for matching each depth measurement point, and the matching dimension is expanded to obtain the family library matching parameters with the out-of-standard dimension. Based on the family library matching parameters with the super-standard dimension, the coordinates of each depth measurement point in the standardized coordinates are subjected to single-point parameter binding processing to obtain the drawing parameter set of each depth measurement point; The plotting parameter sets for each depth measurement point are structured and integrated to obtain the skew plotting parameters.
6. The method for drawing skew diagrams based on programming modeling as described in claim 5, characterized in that, The deviation exceeding the standard visualization annotation parameters and the deviation rate exceeding the standard visualization annotation parameters of each depth measuring point are fused to obtain comprehensive exceeding standard visualization annotation parameters, including: Based on the deviation exceeding the standard visualization annotation parameters of each depth measurement point, the deviation annotation feature data of each depth measurement point is determined. Based on the skewness exceeding the standard visualization annotation parameters of each depth measurement point, the skewness annotation feature data of each depth measurement point is determined. The offset annotation feature data of each depth measuring point are processed by priority determination to obtain the offset priority annotation data of each depth measuring point. Based on the bias rate annotation feature data of each depth measurement point and the corresponding bias priority annotation data, the fused annotation feature data of each depth measurement point is obtained; The fusion and annotation feature data of each depth measurement point are traversed and integrated to obtain comprehensive over-standard visualization annotation parameters.
7. The method for drawing skew diagrams based on programming modeling as described in claim 1, characterized in that, The step of drawing the deflection diagram of the frozen hole using parametric modeling based on the deflection diagram drawing parameters includes: Redundant information is removed from the skew plot drawing parameters to obtain the initial skew plot drawing parameters; Based on the initial skew plot parameters, determine the adaptation parameters for the parametric modeling tool; The single-hole coordinates and foundation drawing parameters in the adaptation parameters are processed by trajectory drawing to obtain the single-freezing-hole foundation deviation trajectory diagram; Based on the out-of-standard labeling parameters in the adaptation parameters, the out-of-standard labeling processing is performed on the single freezing hole basic deviation trajectory diagram to obtain the single freezing hole labeled deviation diagram. The single-freezing-hole label deviation diagram is processed by hole alignment and integration to obtain a multi-freezing-hole combined deviation diagram; The multi-freezing hole combination skew diagram is processed by adding auxiliary annotations to obtain a complete draft of the freezing hole skew diagram; The initial draft of the complete frozen hole deviation diagram is subjected to accuracy verification processing to obtain the frozen hole deviation diagram.
8. A device for drawing skew diagrams based on programming modeling, characterized in that, include: The deviation rate change amplitude determination module is used to determine the deviation rate change amplitude threshold based on the measured deviation rate of the borehole in the borehole deviation data. It performs a traversal screening process on the measured deviation rate of the entire borehole depth to obtain deviation rate change amplitude data of multiple depth measuring points. The coordinate parameter determination module is used to determine the borehole depth segmentation result based on the skewness change amplitude data and the skewness change amplitude threshold, determine the interpolation type of each depth segment based on the borehole depth segmentation result, and perform interpolation processing on the initial coordinate calculation data of non-fixed depth for different interpolation types to obtain identifiable coordinate parameters. The threshold determination module is used to determine the deviation threshold and the deviation rate threshold for different depth layers based on engineering construction specification data. The standardized coordinate generation module is used to perform threshold comparisons on the actual borehole position offset and actual borehole position offset rate in the borehole deviation data to obtain the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result. Based on the offset exceeding the standard judgment result and the offset rate exceeding the standard judgment result, the identifiable coordinate parameters are classified to obtain standardized coordinates. The skew plot drawing parameter generation module is used to match the standardized coordinates with the family library parameters, and to incorporate the skewness exceeding the standard judgment result and the skewness rate exceeding the standard judgment result into the matching process as a new matching dimension to obtain the skew plot drawing parameters; The skew diagram drawing module is used to draw the skew diagram of the frozen hole through parametric modeling based on the skew diagram drawing parameters.
9. An electronic device, characterized in that, The electronic device includes a memory and a processor, wherein the memory stores a computer program, and the processor executes the skew diagram drawing method based on programming modeling as described in any one of claims 1 to 7 when running the computer program.
10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the skew diagram drawing method based on programming modeling as described in any one of claims 1 to 7.