Three-dimensional drilling data integration and display system for safety evaluation of earthquake area

Abstract

The invention relates to the technical field of data processing, and discloses a three-dimensional drilling data integration and display system for safety evaluation of an earthquake area. Comprising a mode selection module for selecting a point location marking mode of an earthquake region, a point location marking module for marking evaluation data point locations distributed at intervals, a data acquisition module for acquiring three-dimensional drilling data, a model construction module for constructing a region simulation model matched with the earthquake region, and an interactive display module. The dividing module is used for dividing a regional simulation model into sub-models and establishing regional channels between adjacent sub-regions; according to the invention, dynamic integration and display effects of three-dimensional drilling data at adjacent positions of an earthquake area can be realized, and an independent and reliable interactive display channel can be provided for integration and display of three-dimensional drilling data at different time lines and different geographic positions; the targeted integration and display effect of the local position of the earthquake area on the timeline is realized, and the accuracy of safety evaluation of the earthquake area is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and more particularly to a three-dimensional drilling data integration and display system for earthquake area safety assessment. Background Art

[0002] In the safety assessment of earthquake zones, three-dimensional borehole data is an important basis for analyzing the stability of geological structures. Traditional earthquake safety assessment methods usually rely on two-dimensional geological profiles or discrete borehole data, which cannot fully reflect the three-dimensional spatial distribution characteristics of complex geological structures. With the development of three-dimensional geological modeling technology, regional geological modeling methods based on three-dimensional borehole data have become an important method for earthquake safety assessment. In order to comprehensively and accurately evaluate the safety of earthquake zones, the collected three-dimensional borehole data needs to be integrated and displayed.

[0003] The patent application with reference publication number CN118626544A discloses a method for integrating and visualizing data collected on-site at a water conservancy project. By integrating the data collected at the project site and uniformly storing it locally or in the cloud, it has functions such as data analysis, complete data backup, and data sharing, thereby efficiently managing and analyzing the data. This helps to improve the efficiency of the on-site gate personnel’s entry and exit attendance, ensure the personal safety of the operators, and improve the efficiency of distributed multi-node data access. At the same time, it realizes real-time monitoring, integrated display, excessive warning, and real-time display of tunnel toxic gases, providing important support for promoting the construction of information display of water conservancy projects, and accelerating the process of water conservancy projects from traditional management mode to digital management mode. During the project implementation process, it comprehensively integrates multi-source information, realizes the data aggregation, exchange and sharing of the whole life cycle of the project from the construction period to the operation and maintenance period, and assists project managers in management and decision analysis. When existing data integration and display systems collect 3D borehole data, the collection points in the earthquake area are usually set based on fixed rules or experience, which is difficult to dynamically adjust according to the actual structural morphology of different earthquake areas, resulting in adjacent 3D borehole data easily interfering with each other in spatial position. In addition, the overall integration and display method of all 3D borehole data cannot achieve the dynamic visualization effect of the geological structure of local positions in the earthquake area on different time lines, resulting in limited data integration and display operations at local key positions in the earthquake area, and unable to provide a refined spatiotemporal evolution basis for the safety evaluation of the earthquake area, thereby reducing the accuracy of the safety evaluation of the earthquake area.

[0004] In view of this, the present invention proposes a three-dimensional drilling data integration and display system for earthquake area safety assessment to solve the above problems. Summary of the Invention

[0005] In order to overcome the above-mentioned defects of the prior art and to achieve the above-mentioned objectives, the present invention provides the following technical solution: a three-dimensional drilling data integration and display system for earthquake area safety assessment, comprising: A mode selection module is used to collect the horizontal span value and the vertical span value of the earthquake area, calculate the regional symmetry coefficient, and select the point marking mode of the earthquake area based on the relationship between the regional symmetry coefficient and the calibration symmetry coefficient; The point marking module is used to identify the regional center point in the earthquake area according to different point marking modes, and mark the evaluation data points distributed at intervals based on the regional center point; The data acquisition module is used to set a safety assessment period, collect three-dimensional drilling data of the assessment data points in the earthquake area during the safety assessment period, and summarize the three-dimensional drilling data based on the standard that one point data set corresponds to four subsets to generate a point data set; The model building module is used to establish a basic regional model with four simulation locations, import the point data set into the corresponding four simulation locations for data integration, and build a regional simulation model that matches the earthquake area; The interactive display module is used to divide the regional simulation model into sub-models, establish regional channels with closed sub-channels between adjacent sub-regions, and control the interactive display of adjacent sub-models in the regional channels.

[0006] Furthermore, the method for calculating the regional symmetry coefficient is: Using a drone to take an overhead image of the earthquake area, and drawing the outer boundary line of the earthquake area in the overhead image, which is recorded as the area boundary line; Draw A horizontal extension lines and A vertical extension lines intersecting the region boundary line on the overhead image along the horizontal direction and the vertical direction, respectively, and record the horizontal extension line and the vertical extension line between two intersection points of the region boundary line as the horizontal span line and the vertical span line, respectively; Measure the lengths of A horizontal span lines and A vertical span lines respectively, obtain A first span values ​​and A second span values, and record the maximum value of the first span values ​​and the maximum value of the second span values ​​as the horizontal span value and the vertical span value; The larger and smaller values ​​of the horizontal span value and the vertical span value are recorded as the upper digit and the lower digit respectively, and the upper digit and the lower digit are divided to calculate the regional symmetry coefficient.

[0007] Furthermore, the point marking modes include a ring array mode and a rectangular diffusion mode; The method for selecting the point marking mode is: When the regional symmetry coefficient is greater than or equal to the calibration symmetry coefficient, the rectangular diffusion mode is selected; When the regional symmetry coefficient is less than the calibration symmetry coefficient, the annular array mode is selected; When the regional symmetry coefficient is equal to the calibration symmetry coefficient, three adjacent points on the regional boundary line are randomly selected and connected to obtain C curved lines. The curvatures of the C curved lines are identified one by one through computer vision technology, and the maximum curvature is marked; If the maximum value of the bending arc is greater than the calibrated arc value, the rectangular diffusion mode is selected; if the maximum value of the bending arc is less than or equal to the calibrated arc value, the circular array mode is selected.

[0008] Furthermore, the method of marking evaluation data points includes: When the circular array mode is selected, the intersection of the horizontal span line and the vertical span line corresponding to the horizontal span value and the vertical span value is recorded as the center point of the area; Add the horizontal span value and the vertical span value and average them to calculate the span mean; In the overhead image, a first area circle is drawn with the area center point as the circle center and the mean of one-third of the span as the first radius. The inner points of the interval distribution are marked on the first area circle with an interval angle of 45 degrees as the first standard. In the overhead image, a second area circle is drawn with the area center point as the circle center and the mean of two-thirds of the span as the second radius; Taking the interval of one third of the first radius as the second standard, mark the outer points of the interval distribution on the second area circle, and after summarizing all the outer points and inner points, obtain B evaluation data points.

[0009] Furthermore, the method for selecting the point marking mode also includes: When the rectangular diffusion mode is selected, the curvatures of the curved lines are arranged in order from large to small to generate a curvature queue; The curved lines corresponding to the first four curved arcs in the arc queue are recorded as target lines, and the point in the middle of the target line is recorded as the corner point. Four corner points are obtained, and two non-adjacent corner points are connected to form two diagonal lines. The intersection of the two diagonal lines is recorded as the center point of the area. Measure the lengths of the two diagonals separately, add them together and average them to calculate the diagonal mean. Taking the center point of the region as the benchmark and the mean of one quarter of the diagonal as the diffusion standard, the center point of the region is diffused outward in a circumferential direction to generate a diffusion area. The boundary line of the diffusion area is drawn, and B points distributed at intervals are marked on the boundary line of the diffusion area to obtain B evaluation data points.

[0010] Furthermore, the three-dimensional drilling data includes borehole latitude and longitude, borehole depth, borehole inclination angle, rock and soil type, rock and soil color, rock formation trend, rock formation inclination, cone tip resistance, side wall friction, pH value and static water pressure.

[0011] Furthermore, the method for generating a point data set is: Create B blank initial sets, and divide the initial sets into four subsets, which are respectively recorded as the first subset, the second subset, the third subset, and the fourth subset; Import the borehole latitude and longitude, borehole depth, and borehole inclination angle of B evaluation data points into the first subset to generate a spatial subset; import the rock and soil type, rock and soil color, rock stratum trend, and rock stratum inclination angle into the second subset to generate a rock and soil subset; import the cone tip resistance and sidewall friction into the third subset to generate a borehole subset; The pH value and static water pressure are introduced into the fourth subset to produce the environmental subset, and the initial set having the space subset, geotechnical subset, borehole subset and environmental subset is recorded as the point data set to obtain B point data sets.

[0012] Furthermore, the method of constructing the regional simulation model is: The geological data of the earthquake area is queried through the geographic information system, and based on the geological data, a basic regional model of the earthquake area is constructed in combination with 3D modeling technology; Query the coordinates of B evaluation data points one by one, record them as geographic coordinates, and mark the points consistent with the geographic coordinates in the basic regional model to obtain B model points; Four annularly distributed simulation positions are simulated at B model points, which are respectively recorded as space simulation position, geotechnical simulation position, drilling simulation position and environmental simulation position; In the order of acquisition time, the B point data sets of D safety assessment cycles are bound to B model points respectively, and the spatial subset, geotechnical subset, borehole subset and environmental subset are integrated into the spatial simulation position, geotechnical simulation position, borehole simulation position and environmental simulation position respectively, so as to promote the conversion of the basic regional model into a regional simulation model.

[0013] Furthermore, the method of dividing the sub-model is: Mark the location of the regional center point and B evaluation data points in the regional simulation model to obtain the benchmark point and B division points; Taking the reference point as the starting point, draw extension lines through the locations of B dividing points respectively, and adjust the extension lines to extend to the outer edge of the regional simulation model to form B dividing lines; The regional simulation model is divided into B adjacent sub-models using B dividing lines as division criteria.

[0014] Furthermore, the method for establishing a regional channel is: In a clockwise manner, the ends of the B sub-models that are in contact with the two adjacent sub-models are respectively recorded as sub-ports and mother-ports, thereby obtaining B sub-ports and B mother-ports; The sub-port and the mother port in adjacent positions are respectively used as the two ports of the regional channel, a bidirectional transmission channel profile is established between the two ports, and D closed sub-channels are constructed within the channel profile, which promotes the conversion of the channel profile into a regional channel.

[0015] The technical effects and advantages of the three-dimensional drilling data integration and display system for earthquake area safety assessment of the present invention are as follows: (1): The present invention selects the point marking mode by calculating the regional symmetry coefficient, and can select the specific location suitable for three-dimensional drilling data collection according to the actual structural form of the earthquake area, so that the best evaluation data point can be accurately marked in earthquake areas with different structural forms, ensuring that the three-dimensional drilling data collected in the earthquake area maintain independence, avoiding the negative impact of the actual geographical location of the collected three-dimensional drilling data being too close to each other, and thus ensuring the independence and pertinence of the earthquake area safety evaluation data.

[0016] (2): The present invention integrates the three-dimensional drilling data of multiple safety evaluation cycles with the basic regional model to construct a regional simulation model that continuously simulates the geological changes in the earthquake area on the timeline, thereby realizing the dynamic integration effect of multi-mode data in the earthquake area in different time periods. By dividing the regional simulation model into sub-models and establishing regional channels between the sub-models, it can not only realize the dynamic integration and display effect of the three-dimensional drilling data at adjacent positions in the earthquake area, but also provide an independent and reliable interactive display channel for the integration and display of the three-dimensional drilling data at different timelines and different geographical locations, thereby realizing the targeted integration and display effect of the local positions in the earthquake area on the timeline, laying a safe data foundation for the safety evaluation of the earthquake area, and improving the accuracy of the safety evaluation results of the earthquake area. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 This is a module diagram of a three-dimensional drilling data integration and display system for earthquake area safety assessment provided in the first embodiment of the present invention; Figure 2 This is a flow chart of a method for integrating and displaying three-dimensional borehole data for earthquake area safety assessment provided in the second embodiment of the present invention. DETAILED DESCRIPTION

[0018] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0019] Example 1: Please refer to Figure 1 As shown, the three-dimensional drilling data integration and display system for earthquake area safety assessment described in this embodiment includes: The mode selection module collects regional parameters of the earthquake area, calculates the regional symmetry coefficient of the earthquake area, and selects the point marking mode of the earthquake area based on the regional symmetry coefficient; A seismic zone refers to a geographical area affected by earthquakes and requiring a geological overall structural safety assessment and analysis. It also serves as a guide for subsequent data integration and presentation. For these reasons, when conducting a safety assessment of a seismic zone, it is necessary to first analyze the structural and geographical characteristics of the seismic zone to lay the foundation for the safety assessment. Regional parameters are used to represent the geographical structure and location distribution of the earthquake region, which can provide data support for the identification of specific regional types of earthquake regions; Specifically, the regional parameters include horizontal span value and vertical span value; the horizontal span value refers to the length value of the earthquake area across the geographical range in the horizontal direction, and the vertical span value refers to the length value of the earthquake area across the geographical range in the vertical direction, which can represent the length effect of the geographical distribution of the earthquake area on the horizontal plane.

[0020] The method for collecting regional parameters is: Using a drone to take an overhead image of the earthquake area, and drawing the outer boundary line of the earthquake area in the overhead image, which is recorded as the area boundary line; Draw A horizontal extension lines and A vertical extension lines intersecting the region boundary line on the overhead image along the horizontal direction and the vertical direction, respectively, and record the horizontal extension line and the vertical extension line between two intersection points of the region boundary line as the horizontal span line and the vertical span line, respectively; The lengths of A horizontal span lines and A vertical span lines are measured respectively by a scale to obtain A first span values ​​and A second span values, and the maximum value of the first span value and the maximum value of the second span value are recorded as the horizontal span value and the vertical span value.

[0021] After the horizontal span value and the vertical span value are collected, the regional symmetry coefficient of the earthquake region can be calculated based on the horizontal span value and the vertical span value, so that the regional symmetry coefficient can be used as a numerical basis for judging whether the morphological structure of the earthquake region is symmetrical; Specifically, the method for calculating the regional symmetry coefficient is: Compare the horizontal span value and the vertical span value of the earthquake area, and record the larger and smaller values ​​as the upper and lower digits respectively; Divide the upper digit and the lower digit to calculate the area symmetry coefficient; The calculation formula of the regional symmetry coefficient is: ; Where, is the regional symmetry coefficient, For the upper digit, The lower digit.

[0022] After calculating the regional symmetry coefficient, the specific structural morphology and location distribution attributes of the earthquake area are analyzed and identified based on the regional symmetry coefficient, and the specific morphological type of the earthquake area is determined. Finally, a point marking pattern that matches the morphological structure of the earthquake area is selected. The point marking mode is a mode for marking data collection points within the earthquake area. The selection of the point marking mode varies according to the actual structural form of the earthquake area, so the point marking mode for circular earthquake areas and rectangular earthquake areas is different. Specifically, the point marking modes include a circular array mode and a rectangular diffusion mode; the circular array mode is suitable for earthquake areas with circular morphological structures, and the rectangular diffusion mode is suitable for earthquake areas with rectangular morphological structures.

[0023] The method for selecting the point marking mode is: When the regional symmetry coefficient is greater than or equal to the calibration symmetry coefficient, the horizontal and vertical spans of the earthquake region are quite different, indicating that the morphological structure of the earthquake region is quite different from a circular structure and is closer to a rectangle. In this case, the rectangular diffusion mode is selected. The calibration symmetry coefficient refers to the minimum value of the regional symmetry coefficient in the earthquake region where the rectangular diffusion mode is selected, and provides a basis for the selection of the point marking mode. When the regional symmetry coefficient is equal to the calibration symmetry coefficient, the horizontal and vertical spans of the earthquake zone are moderate, indicating that the morphological structure of the earthquake zone is not much different from a circular structure and is close to a rectangle or a circle. Three adjacent points on the regional boundary line are randomly selected and connected to obtain C curved lines. The curvatures of the C curved lines are identified one by one through computer vision technology, and the maximum curvature is marked; If the maximum value of the curvature is greater than the calibration value, the structural morphology of the earthquake area is closer to a rectangle, and the rectangular diffusion mode is selected. The calibration value refers to the minimum value of the curvature when the rectangular diffusion mode is selected, which provides a lower limit for the actual curvature of the curvature line. If the maximum value of the bending arc is less than or equal to the calibration arc value, the structural morphology of the earthquake area is closer to a circle, so the circular array mode is selected; When the regional symmetry coefficient is less than the calibrated symmetry coefficient, the span difference between the earthquake area in the horizontal and vertical directions is small, indicating that the morphological structure of the earthquake area is not much different from the circular structure and is close to a circle, so the circular array mode is selected.

[0024] It should be noted that the value of the regional symmetry coefficient is greater than or equal to 1. At this time, the calibration symmetry coefficient is greater than 1 and close to 1. When the regional symmetry coefficient is the calibration symmetry coefficient, it means that the horizontal length and vertical length of the earthquake area are very close. At this time, the structural form of the earthquake area may be one of square or circle.

[0025] The point marking module identifies the center point of the earthquake area according to the point marking mode, and marks the evaluation data points of the earthquake area based on the center point of the area; After selecting the point marking mode of the seismic area, it is necessary to mark the evaluation data points required for 3D drilling data collection from the seismic area according to different point marking modes. When marking the evaluation data points, it is necessary to first identify the regional center point in the seismic area. At this time, the regional center point can provide the position basis for marking the subsequent evaluation data points. Specifically, when identifying the center point of the area, when the structural morphology of the earthquake area is closer to a circle or a rectangle, the specific identification operation of the identification method used is different. Therefore, it is necessary to evaluate the marking operation of the data points in different point marking modes to distinguish them.

[0026] Specifically, the method for marking evaluation data points is: When the circular array mode is selected, the structural shape of the earthquake area is closer to a circle, and the intersection of the horizontal span line and the vertical span line corresponding to the horizontal span value and the vertical span value is recorded as the center point of the area; Add the horizontal span value and the vertical span value and average them to calculate the span mean; In the overhead image, a first area circle is drawn with the area center point as the circle center and the mean of one-third of the span as the first radius. The inner points of the interval distribution are marked on the first area circle with an interval angle of 45 degrees as the first standard. In the overhead image, a second area circle is drawn with the area center point as the circle center and the mean of two-thirds of the span as the second radius; Taking the interval of one third of the first radius as the second standard, mark the outer points of the interval distribution on the second area circle, and after summarizing all the outer points and inner points, obtain B evaluation data points.

[0027] It should be noted that when the circular array mode is selected, the B data evaluation points marked in the seismic area remain independent of each other, and there will be no overlap between any two data evaluation points, thereby providing an accurate and independent position basis for the subsequent acquisition of three-dimensional drilling data.

[0028] As another implementation of this embodiment, the method for selecting the point marking mode is: When the rectangular diffusion mode is selected, the structural morphology of the earthquake area is closer to a rectangle, so the curvature of the curvature line is arranged in order from large to small to generate a curvature queue; The curved lines corresponding to the first four curved arcs in the arc queue are recorded as target lines, and the points in the middle of the target lines are recorded as turning points, thereby obtaining four turning points. Connect two non-adjacent corner points to form two diagonal lines, and record the intersection of the two diagonals as the center point of the region. Since the earthquake region is in a rectangular structure as a whole, the curved lines corresponding to the first four curved arcs in the arc queue are the locations of the four boundary corners of the earthquake region. At this time, the point in the middle of the target line is the location of the four boundary corners of the earthquake region, which can provide point support for the drawing of the two diagonals and ensure the accuracy of the marking of the center point of the region. Measure the lengths of the two diagonals separately, add them together and average them to calculate the diagonal mean. Taking the center point of the region as the benchmark and the mean of one quarter of the diagonal as the diffusion standard, the center point of the region is diffused outward in a circumferential direction to generate a diffusion area; Draw the boundary line of the diffusion area, mark B points distributed at intervals on the boundary line of the diffusion area, and obtain B evaluation data points.

[0029] It should be noted that the diffusion area formed by the diffusion is similar to the overhead image of the earthquake area, which ensures that the diffusion area and the earthquake area can maintain relative consistency in structural morphology and provides accurate position definition for the marking of subsequent evaluation data points; At the same time, no matter which point marking mode is used to mark the evaluation data points, they are used to meet the location limitations of subsequent three-dimensional drilling data collection, and the marked evaluation data points are converted to the corresponding geographical locations in the earthquake area according to the specific positions in the overhead image, so that the evaluation data points can be matched one-to-one with the earthquake area.

[0030] The data acquisition module sets a safety assessment cycle, collects 3D drilling data of the assessment data points in the earthquake area during the safety assessment cycle, and aggregates the 3D drilling data based on similar aggregation criteria to generate a point data set; Three-dimensional drilling data refers to relevant evaluation data collected at evaluation data points that can affect the safety and stability of the geological structure in the earthquake area, thereby providing data support for the safety evaluation results of the earthquake area and laying the foundation for subsequent data integration and display.

[0031] Before collecting 3D borehole data, in order to be able to continuously evaluate the safety and stability results of the earthquake area in different time periods, it is necessary to regularly collect and process the 3D borehole data of the earthquake area at a certain time interval to ensure that the 3D borehole data in the earthquake area can be effectively collected at a certain time interval. Therefore, it is necessary to pre-set a safety evaluation cycle so that the safety evaluation cycle can serve as a time interval for the 3D borehole data collection operation at the evaluation data points in the earthquake area. Specifically, when setting the safety evaluation cycle, the duration of the safety evaluation cycle is not fixed or unique. It can be set according to the working performance of the actual three-dimensional drilling data acquisition equipment or manually customized. For example, the duration of a safety evaluation cycle is 20 minutes, 60 minutes, 120 minutes, etc.

[0032] After setting the safety assessment cycle, the three-dimensional drilling data of the evaluation data points in the earthquake area during the safety assessment cycle can be collected. Specifically, the three-dimensional drilling data includes the borehole latitude and longitude, borehole depth, borehole inclination angle, rock and soil type, rock and soil color, rock formation direction, rock formation inclination, cone tip resistance, side wall friction, pH value and static water pressure.

[0033] The borehole longitude and latitude, borehole depth and borehole inclination angle are data used to represent the spatial position of the borehole when the drilling equipment in the evaluation data point performs a drilling operation. They can refer to the longitude and latitude geographic information, actual borehole depth and actual borehole inclination angle of the drilling equipment; specifically, the borehole longitude and latitude, borehole depth and borehole inclination angle are all obtained through querying the controller on the drilling equipment.

[0034] The rock and soil type, rock and soil color, rock formation strike and rock formation dip are used to represent the specific form and structure of the geological rock formation at the borehole location, and can refer to the specific rock and soil type, actual rock and soil color, rock formation fault position strike and dip at the borehole location; specifically, rock and soil types include but are not limited to clay, granite, etc.; rock and soil colors include but are not limited to red, gray, etc.; rock and soil type, rock and soil color, rock formation strike and rock formation dip are all obtained through detection by various sensors integrated on the drilling equipment; for example, the rock and soil color is obtained by shooting and detecting with a camera integrated on the drilling equipment during drilling operations.

[0035] The cone tip resistance and side wall friction are used to specifically express the tip pressure and side wall friction of the rock and soil at the drill hole location on the drilling equipment. They can refer to the rock and soil reaction to the drilling equipment in the drill hole. Specifically, the cone tip resistance and side wall friction are obtained after detection by the pressure sensor on the drilling equipment.

[0036] The pH value and static water pressure are used to specifically represent the environmental parameters in the rock and soil at the borehole location, and can reflect the actual rock and soil geological environment at the borehole location. Specifically, the pH value and static water pressure are obtained through detection by the acid-base sensor and water pressure sensor integrated in the drilling equipment.

[0037] After collecting the 3D borehole data, it is necessary to classify and summarize the data of different evaluation data points in different safety evaluation cycles, so as to achieve the independent summary state of the 3D borehole data of each evaluation data point in each safety evaluation cycle, and provide an independent and accurate point data set for the subsequent safety evaluation of the earthquake area; When aggregating 3D drilling data into point data sets, it is necessary to do so under the constraints of similar aggregation criteria to ensure effective and accurate aggregation of 3D drilling data; Specifically, the same category aggregation criterion is: one point data set corresponds to four subsets.

[0038] The method for generating point data sets is: Create B blank initial sets, and divide the initial sets into four subsets, which are respectively recorded as the first subset, the second subset, the third subset, and the fourth subset; Import the borehole latitude and longitude, borehole depth and borehole inclination angle of B evaluation data points into the first subset to generate a spatial subset; Importing rock and soil type, rock and soil color, rock layer direction and rock layer dip into the second subset to generate a rock and soil subset; The cone tip resistance and side wall friction are introduced into the third subset to generate the drilling subset; The pH value and static water pressure are introduced into the fourth subset to produce the environmental subset, and the initial set having the space subset, geotechnical subset, borehole subset and environmental subset is recorded as the point data set to obtain B point data sets.

[0039] It should be noted that the constructed B point data sets can only represent the three-dimensional drilling data of the B evaluation data points in one safety evaluation cycle. When the three-dimensional drilling data of multiple safety evaluation cycles are collected, it is necessary to perform a reciprocating aggregation operation on the three-dimensional drilling data of multiple safety evaluation cycles to ensure that each safety evaluation cycle can be used for the corresponding B point data sets.

[0040] The model building module establishes a basic regional model with simulation locations, imports point data sets into the simulation locations for data integration, and constructs a regional simulation model that matches the earthquake area; The basic regional model is a three-dimensional geological model used to represent the structural distribution characteristics of the relevant area of ​​the earthquake area marked with the evaluation data points, which can be used to describe the distribution and location of the relevant point data in the earthquake area. Since the basic regional model can only represent the simple structural position of the earthquake zone and cannot simulate the three-dimensional drilling data at each evaluation data point in the earthquake zone one by one, the basic regional model cannot be directly used as the object of subsequent safety evaluation of the earthquake zone. It is necessary to integrate and match the three-dimensional drilling data of the evaluation data points with the basic regional model to generate a regional simulation model that can be used for subsequent safety evaluation of the earthquake zone.

[0041] The regional simulation model is a virtual model that integrates the basic geological structure characteristics of the earthquake region and the 3D borehole data of the evaluation data points. It can comprehensively and accurately reflect the safety of the earthquake region. In order to ensure the rationality of the integration operation of the 3D borehole data and the basic regional model, it is necessary to establish simulation points corresponding to the evaluation data points in the basic regional model so that the simulation points can serve as the location limit for the data integration between the 3D borehole data and the basic regional model. Specifically, the method for constructing the regional simulation model is: The geological data of the earthquake area is retrieved through the geographic information system, and based on the geological data, a basic regional model of the earthquake area is constructed in combination with 3D modeling technology; the geological data is the relevant data that reflects the specific geological structure of the earthquake area and is pre-stored in the geographic information system, including but not limited to image data, elevation data, point cloud data, etc. Query the coordinates of B evaluation data points one by one, record them as geographic coordinates, and mark the points consistent with the geographic coordinates in the basic regional model to obtain B model points; Four annularly distributed simulation positions are simulated at B model points, which are respectively recorded as space simulation position, geotechnical simulation position, drilling simulation position and environmental simulation position; In the order of acquisition time, the B point data sets of D safety assessment cycles are bound to B model points respectively, and the spatial subset, geotechnical subset, borehole subset and environmental subset are integrated into the spatial simulation position, geotechnical simulation position, borehole simulation position and environmental simulation position respectively, so as to promote the conversion of the basic regional model into a regional simulation model.

[0042] It should be noted that after the regional simulation model is constructed, the regional simulation model can sequentially integrate and summarize the three-dimensional drilling data of the earthquake area in multiple safety evaluation cycles, ensuring that each safety evaluation cycle has complete and comprehensive three-dimensional drilling data, and providing a good model basis for subsequent safety evaluation of the earthquake area.

[0043] The interactive display module divides the regional simulation model into sub-models, establishes regional channels between adjacent sub-regions, and controls the interactive display of adjacent sub-models within the regional channels; After the regional simulation model is constructed, it can be used as a direct object for safety assessment of the earthquake zone. The regional simulation model can be used to fully integrate and visualize the three-dimensional drilling data of the earthquake zone safety assessment, thus facilitating the safety assessment of the earthquake zone. Since the regional simulation model is constructed based on the overall structural simulation of the earthquake zone, the amount of three-dimensional drilling data contained and involved in the regional simulation model is large, which makes it impossible to focus on the local locations when displaying the data for safety assessment of the earthquake zone, resulting in poor display of the local location data. Therefore, it is necessary to differentiate and divide the regional simulation model so that the overall regional simulation model can be divided into small-volume sub-models that can accurately and boundary-display the data of the local locations of the earthquake zone; Specifically, the method of dividing the sub-model is: Mark the location of the regional center point and B evaluation data points in the regional simulation model to obtain the benchmark point and B division points; Taking the reference point as the starting point, draw extension lines through the locations of B dividing points respectively, and adjust the extension lines to extend to the outer edge of the regional simulation model to form B dividing lines; The regional simulation model is divided into B adjacent sub-models using B dividing lines as division criteria.

[0044] After the sub-models are divided, the sub-models can display the 3D drilling data of each evaluation data point in a one-to-one correspondence, thereby achieving a point-to-point display effect. In order to ensure that all small models can maintain associations and meet the subsequent integration and aggregation requirements between adjacent small models, it is necessary to establish regional channels between adjacent small models, thereby achieving the dual effects of point-to-point integration and display between sub-models and evaluation data points. Specifically, the method for establishing a regional channel is: In a clockwise manner, the ends of the B sub-models that are in contact with the two adjacent sub-models are respectively recorded as sub-ports and mother-ports, thereby obtaining B sub-ports and B mother-ports; The sub-port and the mother port in adjacent positions are respectively used as the two ports of the regional channel, a bidirectional transmission channel profile is established between the two ports, and D closed sub-channels are constructed within the channel profile, which promotes the conversion of the channel profile into a regional channel.

[0045] It should be noted that when a regional channel with D closed sub-channels is constructed, the regional channel at this time can not only realize the dynamic integration and display effect of the three-dimensional drilling data of the evaluation data points on the two adjacent sub-models, but also provide an independent and reliable interactive display channel for the independent integration and display of the three-dimensional drilling data of D safety evaluation cycles, ensuring that the three-dimensional drilling data of each safety evaluation cycle can have a unique interactive display environment to meet the subsequent interactive display needs of the three-dimensional drilling data of the earthquake area through the sub-model, thereby facilitating the safety evaluation operation of the earthquake area.

[0046] Example 2: Please refer to Figure 2 As shown, for parts not described in detail in this embodiment, please refer to the description of the first embodiment. A three-dimensional borehole data integration and display method for earthquake area safety assessment is provided, which is implemented based on a three-dimensional borehole data integration and display system for earthquake area safety assessment, including: Step 1: Collect the horizontal span value and vertical span value of the earthquake area, calculate the regional symmetry coefficient, and select the point marking mode of the earthquake area based on the relationship between the regional symmetry coefficient and the calibration symmetry coefficient; Step 2: According to the different point marking modes, the regional center point is identified in the earthquake area, and the evaluation data points with interval distribution are marked based on the regional center point; Step 3: Set a safety assessment period, collect 3D borehole data of the assessment data points in the earthquake area during the safety assessment period, and summarize the 3D borehole data to generate a point data set based on the standard that one point data set corresponds to four subsets; Step 4: Establish a basic regional model with four simulation locations, import the point data set into the corresponding four simulation locations for data integration, and construct a regional simulation model that matches the earthquake area; Step 5: Divide the regional simulation model into sub-models, establish regional channels with closed sub-channels between adjacent sub-regions, and control the interactive display of adjacent sub-models within the regional channels.

[0047] The above description is only a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any technician familiar with this technical field can easily think of changes or replacements within the technical scope disclosed by the present invention, which should be covered by the scope of protection of the present invention.

Claims

1. A 3D borehole data integration and display system for earthquake zone safety assessment, characterized by: include: A mode selection module is used to collect the horizontal span value and the vertical span value of the earthquake area, calculate the regional symmetry coefficient, and select the point marking mode of the earthquake area based on the relationship between the regional symmetry coefficient and the calibration symmetry coefficient; The point marking module is used to identify the regional center point in the earthquake area according to different point marking modes, and mark the evaluation data points distributed at intervals based on the regional center point; The data acquisition module is used to set a safety assessment period, collect three-dimensional drilling data of the assessment data points in the earthquake area during the safety assessment period, and summarize the three-dimensional drilling data based on the standard that one point data set corresponds to four subsets to generate a point data set; The model building module is used to establish a basic regional model with four simulation locations, import the point data set into the corresponding four simulation locations for data integration, and build a regional simulation model that matches the earthquake area; The interactive display module is used to divide the regional simulation model into sub-models, establish regional channels with closed sub-channels between adjacent sub-regions, and control the interactive display of adjacent sub-models in the regional channels.

2. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 1 is characterized in that: The method for calculating the regional symmetry coefficient is: Using a drone to take an overhead image of the earthquake area, and drawing the outer boundary line of the earthquake area in the overhead image, which is recorded as the area boundary line; Draw A horizontal extension lines and A vertical extension lines intersecting the region boundary line on the overhead image along the horizontal direction and the vertical direction, respectively, and record the horizontal extension line and the vertical extension line between two intersection points of the region boundary line as the horizontal span line and the vertical span line, respectively; Measure the lengths of A horizontal span lines and A vertical span lines respectively, obtain A first span values ​​and A second span values, and record the maximum value of the first span values ​​and the maximum value of the second span values ​​as the horizontal span value and the vertical span value; The larger and smaller values ​​of the horizontal span value and the vertical span value are recorded as the upper digit and the lower digit respectively, and the upper digit and the lower digit are divided to calculate the regional symmetry coefficient.

3. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 2, characterized in that: Point marking modes include circular array mode and rectangular diffusion mode; The method for selecting the point marking mode is: When the regional symmetry coefficient is greater than or equal to the calibration symmetry coefficient, the rectangular diffusion mode is selected; When the regional symmetry coefficient is less than the calibration symmetry coefficient, the annular array mode is selected; When the regional symmetry coefficient is equal to the calibration symmetry coefficient, three adjacent points on the regional boundary line are randomly selected and connected to obtain C curved lines. The curvatures of the C curved lines are identified one by one through computer vision technology, and the maximum curvature is marked; If the maximum value of the bending arc is greater than the calibrated arc value, the rectangular diffusion mode is selected; if the maximum value of the bending arc is less than or equal to the calibrated arc value, the circular array mode is selected.

4. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 3 is characterized in that: Methods for marking evaluation data points include: When the circular array mode is selected, the intersection of the horizontal span line and the vertical span line corresponding to the horizontal span value and the vertical span value is recorded as the center point of the area; Add the horizontal span value and the vertical span value and take the average to calculate the span mean; In the overhead image, a first area circle is drawn with the area center point as the circle center and the mean of one-third of the span as the first radius. The inner points of the interval distribution are marked on the first area circle with an interval angle of 45 degrees as the first standard. In the overhead image, a second area circle is drawn with the area center point as the circle center and the mean of two-thirds of the span as the second radius; Taking the interval of one third of the first radius as the second standard, mark the outer points of the interval distribution on the second area circle, and after summarizing all the outer points and inner points, obtain B evaluation data points.

5. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 4 is characterized in that: The method of selecting the point marking mode also includes: When the rectangular diffusion mode is selected, the curvatures of the curved lines are arranged in order from large to small to generate a curvature queue; The curved lines corresponding to the first four curved arcs in the arc queue are recorded as target lines, and the point in the middle of the target line is recorded as the corner point. Four corner points are obtained, and two non-adjacent corner points are connected to form two diagonal lines. The intersection of the two diagonal lines is recorded as the center point of the area. Measure the lengths of the two diagonals separately, add them together and average them to calculate the diagonal mean. Taking the center point of the region as the benchmark and the mean of one quarter of the diagonal as the diffusion standard, the center point of the region is diffused outward in a circumferential direction to generate a diffusion area. The boundary line of the diffusion area is drawn, and B points distributed at intervals are marked on the boundary line of the diffusion area to obtain B evaluation data points.

6. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 5, characterized in that: The three-dimensional drilling data includes borehole latitude and longitude, borehole depth, borehole inclination angle, rock and soil type, rock and soil color, rock formation trend, rock formation inclination, cone tip resistance, side wall friction, pH value and static water pressure.

7. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 6, characterized in that: The method for generating point data sets is: Create B blank initial sets, and divide the initial sets into four subsets, which are respectively recorded as the first subset, the second subset, the third subset, and the fourth subset; Import the borehole latitude and longitude, borehole depth, and borehole inclination angle of B evaluation data points into the first subset to generate a spatial subset; import the rock and soil type, rock and soil color, rock stratum trend, and rock stratum inclination angle into the second subset to generate a rock and soil subset; import the cone tip resistance and sidewall friction into the third subset to generate a borehole subset; The pH value and static water pressure are introduced into the fourth subset to produce the environmental subset, and the initial set having the space subset, geotechnical subset, borehole subset and environmental subset is recorded as the point data set to obtain B point data sets.

8. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 7, characterized in that: The method for constructing a regional simulation model is: The geological data of the earthquake area is queried through the geographic information system, and based on the geological data, a basic regional model of the earthquake area is constructed in combination with 3D modeling technology; Query the coordinates of B evaluation data points one by one, record them as geographic coordinates, and mark the points consistent with the geographic coordinates in the basic regional model to obtain B model points; Four annularly distributed simulation positions are simulated at B model points, which are respectively recorded as space simulation position, geotechnical simulation position, drilling simulation position and environmental simulation position; In the order of acquisition time, the B point data sets of D safety assessment cycles are bound to B model points respectively, and the spatial subset, geotechnical subset, borehole subset and environmental subset are integrated into the spatial simulation position, geotechnical simulation position, borehole simulation position and environmental simulation position respectively, so as to promote the conversion of the basic regional model into a regional simulation model.

9. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 8, characterized in that: The method of dividing the sub-model is: Mark the location of the regional center point and B evaluation data points in the regional simulation model to obtain the benchmark point and B division points; Taking the reference point as the starting point, draw extension lines through the locations of B dividing points respectively, and adjust the extension lines to extend to the outer edge of the regional simulation model to form B dividing lines; The regional simulation model is divided into B adjacent sub-models using B dividing lines as division criteria.

10. The three-dimensional drilling data integration and display system for earthquake area safety assessment according to claim 9, characterized in that: The method to establish a regional channel is: In a clockwise manner, the ends of the B sub-models that are in contact with the two adjacent sub-models are respectively recorded as sub-ports and mother-ports, thereby obtaining B sub-ports and B mother-ports; The sub-port and the mother port in adjacent positions are respectively used as the two ports of the regional channel, a bidirectional transmission channel profile is established between the two ports, and D closed sub-channels are constructed within the channel profile, which promotes the conversion of the channel profile into a regional channel.

Images