Method for constructing a comprehensive stratigraphic column based on an arbitrary stratigraphic section line of a three-dimensional scene

Abstract

The application discloses a comprehensive stratum columnar chart construction method based on an arbitrary stratum profile line of a three-dimensional scene, which comprises the following steps: obtaining a three-dimensional geological model and associating a background multi-element geological attribute database, generating a three-dimensional geological layer set according to parameters; receiving a stratum profile line path defined by a user in the three-dimensional scene, accurately determining a target stratum sequence through intersection calculation with the layer set; taking the target stratum sequence as an index, automatically integrating thickness, lithology, fossils and geochemical indexes related to each stratum to construct a data set; and finally, based on the data set, matching an internal built international age color scale and a national standard lithology symbol library to automatically render and generate a columnar chart. The application realizes full-process automation from accurate selection of three-dimensional space stratum to integrated integration of multi-element attribute data, ensures dynamic real-time linkage update of graphics and underlying data, and greatly improves professional drawing efficiency.

Description

Technical Field

[0001] This invention relates to the field of geological information technology, and in particular to a method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene. Background Technology

[0002] Stratigraphic columnar sections, as core professional maps that intuitively display information such as vertical lithological sequences, thickness distribution, paleontological fossil occurrences, and geochemical characteristics of strata, play a crucial role in basic stratigraphic research, regional geological survey report preparation, and mineral resource exploration. Traditionally, the creation of stratigraphic columnar sections relied primarily on manual mapping by geologists based on blueprints or on the assistance of conventional desktop mapping software. In recent years, with the continuous development of geological information technology, some professional geological mapping software has achieved parametric-assisted drawing of graphics at the two-dimensional level. However, existing mapping methods mostly remain in a one-way data file processing mode, generally failing to achieve deep spatial integration with three-dimensional real-world models, and lacking a unified management mechanism for diverse and heterogeneous geological attribute data.

[0003] Although existing professional mapping software has improved efficiency to some extent, it still exhibits many limitations in practical applications: First, it lacks three-dimensional spatial constraints in selecting the stratigraphic range for mapping. Relying on traditional manual table lookups to determine stratigraphic sequences cannot fully utilize the continuous positional information of the three-dimensional spatial model, resulting in limited accuracy in stratigraphic selection. Second, integrating heterogeneous data such as lithology, fossil stratigraphy, and multiple geochemical curves is extremely difficult, and reading various types of data and establishing independent coordinate systems consumes a significant amount of manual labor. Third, existing mapping methods lack automated standard constraints, and the matching of chronostratigraphic colors and lithological symbols relies heavily on manual retrieval and verification, making it difficult to effectively guarantee consistency with national standards (GB / T 958) and International Commission on Stratigraphy (ICS) standards. Finally, currently generated maps are usually disconnected from the underlying geological database, lacking data-driven real-time linkage and dynamic redrawing mechanisms. Once geological data changes, a complete redrawing is required, which severely restricts the accuracy and timeliness of comprehensive geological output. Summary of the Invention

[0004] The purpose of this section is to outline some aspects of embodiments of the present invention and to briefly describe some preferred embodiments. Simplifications or omissions may be made in this section, as well as in the abstract and title of this application, to avoid obscuring the purpose of these documents; however, such simplifications or omissions should not be construed as limiting the scope of the invention.

[0005] In view of the aforementioned existing problems, this invention is proposed. Therefore, this invention provides a method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene, to solve the problems mentioned in the background art.

[0006] To solve the above-mentioned technical problems, the present invention provides the following technical solution: a method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene, comprising: S1: Obtain a three-dimensional geological model representing the geological structure of the target area, and establish the association between the spatial geological bodies in the three-dimensional geological model and the multi-dimensional geological attribute data in the background database; S2: In the three-dimensional geological model, based on the stratigraphic parameters in the database, a set of three-dimensional geological layers representing the spatial location of each stratigraphic layer is generated; S3: Receive an arbitrary stratigraphic profile path defined by the user in the three-dimensional scene, and determine a target stratigraphic sequence corresponding to the intersection order by calculating the intersection relationship between the path and the set of three-dimensional geological layers. S4: Based on the target stratigraphic sequence, automatically integrate multi-dimensional geological attribute data related to each stratum in the sequence from the database to construct a dataset for graphic generation; S5: Based on the constructed dataset, an integrated stratigraphic columnar section is automatically generated, which graphically displays the multi-dimensional geological attribute data.

[0007] Compared with the prior art, the beneficial effects of the present invention are as follows: 1. This invention overcomes the limitations of traditional manual table lookup for determining stratigraphic extent. It utilizes the intersection calculation between stratigraphic profile paths in a 3D scene and a set of 3D geological layers to accurately identify and extract stratigraphic sequences. This method fully leverages continuous spatial location information, avoids errors from manual configuration, and improves the accuracy and efficiency of stratigraphic selection.

[0008] 2. This invention utilizes a multi-table linked backend database to uniformly manage and retrieve lithology, thickness, fossil data, and multi-channel geochemical time series data with a single click. This eliminates the cumbersome steps of multiple manual queries and format conversions required in traditional methods, reducing labor costs. Furthermore, this invention incorporates a built-in age color code library conforming to the latest version of the International Commission on Stratigraphy and a lithology symbol library based on national standards. This achieves automatic and accurate matching of age colors and lithology symbols without manual verification, ensuring the standardization and international comparability of the maps.

[0009] 3. Furthermore, the integrated stratigraphic columnar section generated by this invention is bound to the underlying database through a unique identifier. When the underlying attribute data changes, the integrated columnar section can be dynamically redrawn and refreshed, thereby eliminating the technical problem of map and data disconnection and ensuring the timeliness of geological results. Attached Figure Description

[0010] To more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. Wherein: Figure 1 This is a flowchart illustrating the overall process of constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene, according to an embodiment of the present invention. Figure 2 This is an interface design diagram of a method for constructing a comprehensive stratigraphic columnar diagram based on arbitrary stratigraphic profiles in a three-dimensional scene, according to an embodiment of the present invention. Figure 3 This is a pop-up window interface diagram of a method for constructing a comprehensive stratigraphic columnar diagram based on arbitrary stratigraphic profiles in a three-dimensional scene, as described in an embodiment of the present invention. Figure 4 This is a schematic diagram of the standardized integrated stratigraphic columnar diagram result of the integrated stratigraphic columnar diagram construction method based on arbitrary stratigraphic profile lines in a three-dimensional scene according to an embodiment of the present invention. Detailed Implementation

[0011] To make the above-mentioned objects, features, and advantages of the present invention more apparent and understandable, specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the protection scope of the present invention.

[0012] Many specific details are set forth in the following description in order to provide a full understanding of the invention. However, the invention may also be practiced in other ways different from those described herein, and those skilled in the art can make similar extensions without departing from the spirit of the invention. Therefore, the invention is not limited to the specific embodiments disclosed below.

[0013] Secondly, the term "one embodiment" or "embodiment" as used herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The phrase "in one embodiment" appearing in different places in this specification does not necessarily refer to the same embodiment, nor is it a single or selective embodiment that is mutually exclusive with other embodiments.

[0014] Furthermore, in the description of this invention, it should be noted that the terms "upper," "lower," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. These terms are used solely for the convenience of describing the invention and for simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on the invention. In addition, the terms "first," "second," or "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0015] Example 1

[0016] Reference Figures 1 to 4 This is the first embodiment of the present invention, which provides a method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene, including: S1: Obtain a three-dimensional geological model representing the geological structure of the target area, and establish the association between the spatial geological bodies in the three-dimensional geological model and the multi-dimensional geological attribute data in the background database.

[0017] Furthermore, a real-world 3D geological model of the target area (e.g., a model established through oblique photogrammetry) is loaded, and a real-time connection is established between the system and the background integrated stratigraphic database.

[0018] In particular, in this embodiment, the database adopts a multi-table association structure, and the multi-dimensional geological attribute data includes at least one or more of the following: stratigraphic lithology, thickness, geological age, biological fossils, and geochemical indicators.

[0019] More specifically, this comprehensive stratigraphic database mainly contains the following data tables: Profile basic information table: used to store basic metadata such as profile name, geographic coordinates, measurement date, and references.

[0020] Stratigraphic information master table: used to store the stratigraphic sequence of each profile. Core fields include layer number (as a unique identifier), meter distance, thickness, lithology, contact relationship type, and attitude parameters.

[0021] Rock stratigraphic table: Stores detailed information on groups, groups, sections, and layers according to rock stratigraphic classification.

[0022] Biostratigraphic table: Stores opinions on the division of fossil zones in each stratum.

[0023] Fossil occurrence table: A detailed record of the types, preservation status, and relative abundance of fossils in each stratum.

[0024] Geochemical Tables: Storage of Carbon Isotopes (δ¹²) 13 O), oxygen isotopes (δ) 18 O), strontium isotopes ( 87 Sr / 86Stable isotope values ​​such as Sr, as well as geochemical data sequences such as major and trace elements, total organic carbon (TOC), and magnesium-calcium ratio (Mg / Ca).

[0025] Furthermore, the system uses a hierarchical association mechanism between profile IDs and stratigraphic layers to link spatial attributes and establish a structured binding between all the aforementioned data tables and the three-dimensional spatial geological model. For example... Figure 2 As shown, the system interface displays a three-column layout (left, middle, and right), with the main 3D view area in the middle loading and centering the acquired 3D cross-sectional model.

[0026] S2: In the three-dimensional geological model, based on the stratigraphic parameters in the database, a set of three-dimensional geological layers representing the spatial location of each stratigraphic layer is generated.

[0027] Furthermore, based on the stratigraphic baselines drawn by the user on the three-dimensional geological model, and combined with the layer thickness and meter spacing parameters in the database, the set of three-dimensional geological layers is calculated and generated.

[0028] It should be noted that, in practice, the steps for generating a three-dimensional geological layer set are as follows: (i) Obtain a stratigraphic baseline drawn by the user on the surface of the 3D model along the direction of stratigraphic exposure. The coordinate point set is obtained, and the distance in meters and the thickness of each stratum are read from the stratigraphic information master table in the background database. ) and attitude parameters (strike and azimuth) ,inclination ).

[0029] (ii) Using the stratigraphic baseline as the initial reference position, determine the horizontal extension direction of the strata based on the strike azimuth, and determine the dip orientation of the strata in three-dimensional space based on the dip angle. According to the principles of spatial analytical geometry, use the coordinates of the starting point of a stratum... and normal vector Construct the three-dimensional spatial plane equations for this stratum:

[0030] in, These are the normal vector components determined by the attitude parameters.

[0031] (iii) Based on the cumulative thickness parameters of each subsequent stratum, the initial three-dimensional spatial plane equation is translated by equal or variable distance along the direction of the normal vector, and the three-dimensional plane equation of all strata on the profile is calculated in sequence.

[0032] (iv) Generate a set of spatial stratigraphic planes that includes the geometric locations of all stratigraphic boundaries on the profile.

[0033] It should be noted that this set of ground planes in the cross-section serves as a digital spatial representation of each underlying boundary, providing high-precision basic data support for subsequent three-dimensional spatial intersection calculations.

[0034] S3: Receives an arbitrary stratigraphic profile path defined by the user in the 3D scene, and determines a target stratigraphic sequence corresponding to the intersection order by calculating the intersection relationship between the path and the set of 3D geological layers.

[0035] Furthermore, the stratigraphic profile path can be a straight line segment, a broken line, or a curve drawn by the user.

[0036] Specifically, such as Figure 2 As shown in the central main 3D view area, within the exposed stratigraphic area of ​​the 3D cross-sectional model in the 3D scene, the user can use the drawing tools to draw a selected straight line segment (or polyline segment) along the direction perpendicular to the stratigraphic strike, covering the stratigraphic range of the target observation. Upon receiving this drawn path, the system will perform a 3D spatial intersection operation between the selected straight line segment and the stratigraphic set of the cross-sectional space generated by S2 in the 3D coordinate system. This operation process is as follows: First, convert the selected line segments drawn by the user into parametric equations in three-dimensional space. ,in The three-dimensional coordinates of the starting point of the line segment. Let be the direction vector of the line segment. For parameters ( Then, the parametric equations of this straight line segment are substituted into the spatial plane equations of each three-dimensional geological layer generated in S2, and the corresponding parameters are solved simultaneously. and the corresponding spatial intersection coordinates Finally, for all the spatial intersection points found, based on this parameter... The numerical values ​​(i.e., the distance between the intersection points in the direction of the straight line segment) are sorted in ascending or descending order (by default, the corresponding strata are from newest to oldest from top to bottom), and then the stratum numbers corresponding to the intersection points are extracted, finally forming an ordered array of stratum numbers that correspond one-to-one with the stratum sequence (e.g., L12, L11, L10, L9, ..., L1).

[0037] It is important to emphasize that during this operation, the order of the ordered array of layer numbers is consistent with the actual absolute spatial position of the strata. Using it as a unified index for subsequent multi-attribute data retrieval can completely avoid the errors of traditional manual table lookup for configuring the strata order, and greatly improve the objectivity and accuracy of data extraction.

[0038] S4: Based on the target stratigraphic sequence, automatically integrate multivariate geological attribute data related to each stratum in the sequence from the database to construct a dataset for graphic generation.

[0039] Furthermore, using the ordered array of layer numbers obtained in S3 as an index, the system concurrently retrieves multivariate geological attribute data of the target strata from various associated tables in the backend database. The retrieval content includes: Basic stratigraphic attributes such as layer number, single layer thickness, cumulative thickness, lithology code, and contact relationship type for each stratum.

[0040] Information on the geological age (Eon, Era, Period, Epoch, Time) to which the strata belong.

[0041] Detailed descriptions of rock types.

[0042] The fossil species and representative genera and species recorded in each stratum.

[0043] In addition, vertical time series data of specific geochemical indicators selected by the user (such as numerical series corresponding to formation depth / thickness).

[0044] Furthermore, once the retrieval is complete, the retrieved content becomes a multi-dimensional heterogeneous data set. After the set undergoes format standardization, it can be assembled into a structured bar chart data object (i.e., a dataset for graph generation), which can then be directly called by the system's rendering module.

[0045] In addition, combined Figure 3 As shown, users can dynamically select the desired geochemical curve fields (e.g., δ) in the pop-up bar chart settings window. 13 C and TOC) and output formats (e.g., SVG, PNG, PDF, etc.).

[0046] S5: Based on the constructed dataset, an integrated stratigraphic columnar section is automatically generated, which graphically displays the multi-dimensional geological attribute data.

[0047] Furthermore, based on the diverse and heterogeneous data set integrated by S4, the system automatically executes a standardized rendering process to generate, for example... Figure 4 The comprehensive stratigraphic columnar section shown is illustrated. The standardized rendering process is as follows: Based on the geological age information in the dataset, the system automatically retrieves the standard color value corresponding to the age from the built-in stratigraphic age color code library (using the latest standard age color code published by the International Commission on Stratigraphy ICS) and fills it into the background color area of ​​the age stratigraphic column, without the need for manual configuration.

[0048] Furthermore, based on the lithological information of various strata in the dataset, lithological symbols are automatically retrieved and overlaid from the built-in lithological symbol library (adopting the national standard GB / T958), specifically implemented as follows: The system pre-stores all standard lithological filling patterns conforming to the national standard GB / T 958 in a built-in standard lithological symbol library file as vector pattern units. Each vector pattern unit uses the standard identifier of the corresponding lithology as its unique index key (e.g., limestone, sandstone, mudstone, siltstone, etc., each have their own unique standard identifier). During system initialization, the pattern library loading module reads the symbol library file from the preset storage path, parses all pattern units in the file, and builds a pattern index table using the lithological identifier as the key. This index table is resident in memory and can be called upon in subsequent rendering processes at any time, eliminating the need to repeatedly read the file during each rendering, thus ensuring rendering efficiency.

[0049] During the rendering phase, the system automatically converts the lithology names of various strata in the dataset into corresponding standard pattern identifiers using a built-in bidirectional mapping table between lithology names and standard pattern identifiers. Then, it retrieves the corresponding vector pattern units from the memory pattern index table. Subsequently, the retrieved pattern units are injected into the pattern definition area of ​​the output map. Within the corresponding depth range of each stratum, the standard lithology symbols are overlaid and rendered on the graphic blocks of that stratum using a pattern-filling method, achieving precise coverage and display of the lithology symbols.

[0050] Furthermore, to eliminate the visual discontinuity at the junctions of patterns between adjacent strata of the same lithology, the system automatically generates several spatially offset variants of the same base pattern: using the texture height of the base pattern as a unit, it spatially offsets the pattern at proportions of 1 / 4, 1 / 2, and 3 / 4, resulting in four pattern variants with different phases. Adjacent strata of the same lithology sequentially use variants of different phases, giving the overall pattern a visually continuous and natural filling effect, avoiding the mechanical feel of repetitive splicing. The pattern's fill density adaptively adjusts to the display height corresponding to the thickness of the stratum, ensuring that the lithological symbols of both thick and thin layers are clearly readable with a reasonable density. The entire matching and overlay rendering process is completed automatically by the system without manual intervention.

[0051] The boundary style is automatically determined and drawn based on the contact relationship type field in the stratigraphic information master table. The specific specifications are as follows: conformable contacts use continuous solid lines, pseudo-conformable contacts use regular dashed lines, and unconformable contacts use zigzag lines. At the same time, the corresponding contact relationship text labels are added at the boundary.

[0052] Add fossil occurrence symbols to the corresponding depth layers on the right side of the lithological column, and supplement them with the Latin names of representative fossils.

[0053] Based on the geochemical indicators selected by the user, a separate curve area is created on the right side of the bar chart, and at least one corresponding geochemical data curve is plotted. The specific implementation is as follows: During the S4 dataset construction phase, the system will incorporate geochemical index measurements (such as δ) from various stratigraphic records. 13C、δ 18 O, TOC, Mg / Ca, etc., along with the corresponding stratigraphic depth coordinates of each measurement point, are encapsulated as an ordered data point sequence in the form of depth-numerical key-value pairs and stored in the dataset. Each geochemical index corresponds to an independent data channel in the dataset. The numerical display range of each channel is adaptively determined by the measured maximum and minimum values ​​of all measurement data of that index, forming the numerical coordinate interval of that channel. This interval can be constrained and adjusted through preset display window parameters.

[0054] During the graphics rendering stage, the system establishes an independent horizontal coordinate axis (X-axis) for each geochemical data channel. The numerical scale is uniformly divided according to the adaptively determined numerical coordinate range for that channel, and the number of scale levels is calculated using an adaptive algorithm (7 levels by default). A scale bar with scale lines and numerical labels is drawn at the top of the channel to facilitate quantitative interpretation. The vertical coordinate axis (Y-axis) of each channel shares the same depth / thickness coordinate system with the core lithology column to ensure that the vertical position of the curve is strictly aligned with the depth position of each stratum in the columnar section.

[0055] During rendering, the system maps the depth and measurement values ​​of each data point to the vertical and horizontal coordinates of the corresponding channel, and connects adjacent valid data points sequentially in a polyline (skipping missing measurement points) to draw a continuous geochemical curve. If fill display is configured, a semi-transparent color block is used to fill the area between the curve and the zero-value reference line to enhance the visual contrast of different geochemical stages. If data point markers are configured, a marker symbol of a specified shape (supporting circles, squares, triangles, or crosses) is drawn at each valid measurement point.

[0056] Multiple curve channels for different geochemical indicators are arranged side-by-side in columns on the right side of the map. The horizontal starting position of each channel is determined by sequentially adding the widths of each channel during the pre-calculation stage before rendering, ensuring that the multiple channels do not obscure each other and that the layout is neat and consistent. The name label of the corresponding indicator (supporting superscript and subscript formats) is automatically generated at the top of each curve channel for easy map reading and identification.

[0057] The cumulative thickness / depth scale axis is automatically generated on the left side of the composite column chart. The scale spacing of this axis is automatically calculated and optimized based on the ratio of the total thickness of the target stratigraphic sequence to the actual height of the map, ensuring uniform distribution and high readability of the scale under any total thickness. In addition, stratigraphic age codes are generated in the corresponding positions, and standard elements such as lithological legend title blocks and legends are automatically added, outputting SVG format vector graphics or PNG format raster graphics.

[0058] It should be noted that the present invention also includes an interactive viewing and dynamic configuration step.

[0059] Specifically, when the generated comprehensive stratigraphic column is displayed in a new front-end window, the system has already bound a unique layer number to each graphic block element representing a stratum. When a user interacts with any graphic element (e.g., clicking on a lithological block), the system uses the bound layer number as an index to query and display detailed attribute information of that stratum in real time from the backend database (including complete lithological record, fossil details, and full geochemical data). Furthermore, as... Figure 3 As shown in the settings pop-up window, when the user dynamically selects or deselects other geochemical curve fields (e.g., adding Mg / Ca indices) in the settings panel, the system does not need to re-execute the aforementioned main searches S1 to S4. It only needs to directly read the new data sequence from the generated structured dataset and redraw or add curve trace areas in the map in real time. The entire process can achieve instant response and preview in just a few seconds, and also supports online editing and annotation of map content as well as automatic export of multi-format linked profile records.

[0060] It should be noted that, in addition to the interactive viewing and dynamic configuration steps described above, the present invention also includes a data linkage update step, thereby generating a comprehensive stratigraphic columnar section that is consistent with the latest data. The specific implementation is as follows: The structured binding relationship between maps and the database: In the comprehensive stratigraphic column chart generated by the system, all graphic elements representing each stratum include lithological fill blocks, age color bars, fossil annotation symbols, and geochemical curve data points. These data points are structurally bound to their corresponding records in the backend database through unique layer numbers for each stratum. This structured binding relationship is established along with the graphic elements when the map is generated and is continuously maintained throughout the map's lifespan. Specifically, when a user modifies the attribute data of any stratum in the backend database through the system attribute panel (including but not limited to correcting single-layer thickness, updating lithological names, modifying contact relationship types, or updating geochemical measurement values ​​such as carbon isotopes), the system backend continuously monitors and generates a unique data version identifier. The system view layer employs a dual-track response mechanism for these data updates. The mechanism has two modes. The first is the real-time linkage mode: if the system detects that the current stratigraphic map (such as a cross-sectional bar chart) is already rendered and the data version used by the view differs from the latest version in the background, the system immediately pushes a data change notification to the user interface and triggers a local data hot update and map redrawing process after obtaining user confirmation. The second mechanism is the on-demand loading mode: if the system detects that the current view is not in the display state of the map (e.g., the map is closed or in the background), the system will directly call the latest version of the data stream for overall instantiation and rendering when the user next issues a command to view the cross-sectional bar chart. The system will re-execute the multi-table concurrent retrieval of the S4 stage using the original ordered array of layer numbers as the index, obtain the complete attribute dataset containing the latest modified content from each associated data table, and reassemble the structured bar chart data object. Subsequently, the system uses the latest data object as input to re-execute the full-scale standardized rendering process of the S5 stage, and completes the following items in sequence: re-matching and filling the chronological stratigraphic colors according to the latest age information. Based on the latest lithological codes, the corresponding vector patterns are retrieved from the pattern index table and overlaid with lithological symbols. The display height and depth scale axis spacing of each stratigraphic block are recalculated based on the latest thickness data. Stratigraphic boundary styles are redrawn based on the latest contact relationship types. The numerical coordinate ranges of each curve channel are adaptively determined based on the latest geochemical measurements, and the curves are completely redrawn. Standard map elements such as lithological legends and title blocks are regenerated, and entirely new maps are output. The full rendering process is completed within seconds, and the front-end maps are immediately updated to be completely consistent with the latest database content, fundamentally eliminating the problems of map disconnection from underlying data and the need for complete manual redrawing after data changes in traditional drawing methods.

[0061] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the claims of the present invention.

Claims

1. A method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a 3D scene, characterized in that, include: S1: Obtain a three-dimensional geological model representing the geological structure of the target area, and establish the association between the spatial geological bodies in the three-dimensional geological model and the multi-dimensional geological attribute data in the background database; S2: In the three-dimensional geological model, based on the stratigraphic parameters in the database, a set of three-dimensional geological layers representing the spatial location of each stratigraphic layer is generated; The S2 includes: Based on the stratigraphic baselines drawn by the user on the 3D geological model, and combined with the layer thickness and meter spacing parameters in the database, the set of 3D geological layers is calculated and generated; the steps for generating the set of 3D geological layers are as follows: (i) Obtain the set of coordinate points of a stratigraphic baseline drawn by the user on the surface of the 3D model along the direction of stratigraphic exposure, and read the meter distance, thickness and attitude parameters of each stratum from the stratigraphic information master table in the background database. The attitude parameters include the strike azimuth. and tilt angle ; (ii) Using the stratigraphic baseline as the initial reference position, determine the horizontal extension direction of the stratigraphic plane based on the strike azimuth, and determine the dip orientation of the stratigraphic plane in three-dimensional space based on the dip angle; according to the principles of spatial analytical geometry, use the coordinates of the starting point of a certain stratigraphic plane. and normal vector Construct the three-dimensional spatial plane equations for this stratum: in, These are the normal vector components determined by the attitude parameters; (iii) Based on the cumulative thickness parameters of each stratum, the initial three-dimensional spatial plane equation is translated by equal or variable distance along the direction of the normal vector, and the three-dimensional plane equation of all strata on the profile is calculated in sequence. (iv) Generate a set of spatial stratigraphic planes that includes the geometric locations of all stratigraphic boundaries on the profile; S3: Receive an arbitrary stratigraphic profile path defined by the user in the three-dimensional scene, and determine a target stratigraphic sequence corresponding to the intersection order by calculating the intersection relationship between the path and the set of three-dimensional geological layers. Within the exposed stratigraphic area of ​​the 3D cross-sectional model in a 3D scene, the user uses a drawing tool to draw a selected straight line segment along the direction perpendicular to the stratigraphic strike, covering the stratigraphic range of the target observation area. Upon receiving this drawn path, the user performs a 3D spatial intersection operation between the selected straight line segment and the stratigraphic set generated by S2 in the 3D coordinate system. This operation process is as follows: Transform the selected line segments drawn by the user into parametric equations in three-dimensional space. ,in The three-dimensional coordinates of the starting point of the line segment. Let be the direction vector of the line segment. The parameter is then used as the input; subsequently, the parametric equation of this line segment is substituted into the spatial plane equations of each three-dimensional geological layer generated in S2, and the corresponding parameters are solved simultaneously. and the corresponding spatial intersection coordinates Finally, for all the spatial intersection points found, based on this parameter... The numerical values ​​are sorted in ascending or descending order, and the stratigraphic layer numbers corresponding to the intersection points are extracted to form an ordered array of layer numbers that correspond one-to-one with the stratigraphic sequence. S4: Based on the target stratigraphic sequence, automatically integrate multi-dimensional geological attribute data related to each stratum in the sequence from the database to construct a dataset for graphic generation; Using the ordered array of layer numbers obtained in S3 as an index, the multivariate geological attribute data of the target strata are retrieved concurrently from the associated tables in the background database; Once the retrieval is complete, the retrieved content is a multi-dimensional heterogeneous data set. The set is then formatted and assembled into a structured bar chart data object, which can be directly called by the system's rendering module. S5: Based on the constructed dataset, an integrated stratigraphic columnar section is automatically generated, which graphically displays the multi-dimensional geological attribute data.

2. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The aforementioned multi-dimensional geological attribute data includes at least one or more of the following: stratigraphic lithology, thickness, geological age, biological fossils, and geochemical indicators.

3. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The stratigraphic profile path is a straight line segment, polyline, or curve drawn by the user.

4. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The S5 includes: Based on the geological age information in the dataset, the stratigraphic colors are matched and filled from the built-in stratigraphic age color code library; And / or, based on lithological information, match and overlay lithological symbols from the built-in lithological symbol library.

5. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 4, characterized in that, The stratigraphic age color code library adopts the standard issued by the International Commission on Stratigraphy, and the lithological symbol library adopts the national standard, namely GB / T 958.

6. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The S5 also includes: Based on the geochemical index data in the dataset, at least one corresponding geochemical data curve is plotted on the bar chart.

7. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 6, characterized in that, Plotting the aforementioned geochemical data curves includes: An independent coordinate axis is established for each type of geochemical index, and the numerical range of the coordinate axis is adaptively determined based on the maximum and minimum values ​​of the index data.

8. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The method further includes an interactive step, which includes: In the generated integrated stratigraphic column, a unique identifier is attached to the graphic elements representing each stratum. When a user interacts with any graphic element, the database is retrieved and detailed attribute information of that stratum is displayed based on its unique identifier.

9. The method for constructing a comprehensive stratigraphic columnar section based on arbitrary stratigraphic profiles in a three-dimensional scene as described in claim 1, characterized in that, The method further includes a data linkage update step, which includes: When the geological attribute data in the database changes, S4 and S5 are automatically re-executed to generate a comprehensive stratigraphic columnar section consistent with the latest data.

Images