A standardized code catalog management method and system

Abstract

The present application relates to code catalog management technical field, especially for a kind of standardization code catalog management method and system, the present application constructs the standard catalog code base covering multiple geological elements, different geological elements are cataloged data using the mode of subtab classification collection, geological feature change node is automatically identified based on the depth interval of code in each subtable, complete continuous mutually exclusive geological layering processing, through preset description template and code semantic mapping rule, standardization description text in line with geological specification is automatically generated, finally geological layering result, description text and original catalog data are associated storage, realize achievement bidirectional tracing and standardization output.The present application solves the pain points of traditional geological catalog standard not unified, low efficiency, achievement not standard, data not traceable, realizes geological catalog whole-process standardization and automation, greatly improves cataloging operation efficiency and achievement quality.

Description

Technical Field

[0001] This invention relates to the field of code cataloging and management technology, specifically to a standardized code cataloging and management method and system. Background Technology

[0002] Traditional geological logging operations often employ a manual on-site recording, manual division of geological strata, and manual writing of descriptive texts. This approach is inefficient and highly dependent on the professional level and experience of the logging personnel. It is prone to problems such as inconsistent naming, non-standard terminology, and inconsistent determination of stratification boundaries. Consequently, logging results from different projects and different operators are difficult to standardize and have extremely poor data reusability.

[0003] Currently available digital logging tools in the industry mostly only achieve the electronic conversion of traditional paper records, without establishing a standardized coding system covering all geological elements, and thus cannot achieve the structuring and standardization of logging data from the source. Furthermore, existing tools still rely on manual pre-completion of geological stratification, failing to automate the stratification process and enabling full-link traceability of logging results and original data. This makes it difficult to fundamentally address the core pain points of traditional logging operations and to meet the development needs of the geological industry's digital and intelligent transformation.

[0004] With the high-quality development of the geological exploration industry, the industry has put forward higher requirements for the standardization, efficiency, quality of results and data management capabilities of geological logging operations. There is an urgent need to develop a technical solution that can achieve standardization, automation and closed-loop management of the entire logging process to fill the gaps in the industry's existing technology.

[0005] Therefore, a standardized code cataloging and management method and system are proposed to address the above problems. Summary of the Invention

[0006] The purpose of this invention is to provide a standardized code cataloging and management method and system to solve the problems mentioned in the background art.

[0007] To achieve the above objectives, the present invention provides the following technical solution:

[0008] A standardized code cataloging and management method includes the following steps:

[0009] Step S1: Establish a standard logging code system: Construct a standard logging code library covering multiple geological elements. Each standard logging code has a unique coding identifier, a preset geological semantic definition, and data structure constraints.

[0010] Step S2: Sub-table data acquisition: Collect logging data of different geological elements through multiple independent sub-tables. Each sub-table corresponds to a type of geological element. Users only need to input the standard logging code and its corresponding depth interval information in each sub-table, without having to pre-divide geological strata.

[0011] Step S3: Automatic stratification: Based on the depth range of the standard catalog codes in each sub-table, the start and end points of each code in the depth direction are automatically identified. By comparing the start and end points of codes in multiple sub-tables, geological feature change nodes are determined, and the depth range is divided into continuous and mutually exclusive geological stratification results according to the change nodes.

[0012] Step S4: Automatic generation of description text: For each geological stratification result, summarize all standard cataloging code combinations that appear in that stratum, call the preset description template and code-semantic mapping rules, and convert the code combinations into standardized description text that conforms to geological specifications;

[0013] Step S5: Results Association and Storage: The generated geological stratification results and standardized descriptive text are associated and stored with the original logging data to form traceable and output geological logging results.

[0014] As a preferred option, the establishment of a standard catalog code system in step S1 specifically includes:

[0015] Step S1-1: Based on the classification system of geological elements, determine multiple primary geological element categories and assign a category code to each primary category;

[0016] Step S1-2: Under each primary category, refine the secondary and tertiary subcategories according to the hierarchical relationship of geological features, and assign corresponding hierarchical codes to each subcategory;

[0017] Step S1-3: Combine the category code and the hierarchical code in a preset order to form a standard catalog code with a hierarchical structure, so that the code itself can reflect the classification path of geological features;

[0018] Steps S1-4: Define geological semantics for each standard catalog code, including the name, definition, and descriptive text template of geological features, and establish a mapping relationship between codes and semantics;

[0019] Steps S1-5: Set data structure constraints for each standard catalog code, including data format, allowed values, units, and geological logical association rules between this code and other standard catalog codes in the standard catalog code library; geological logical association rules include mandatory co-occurrence rules, mutual exclusion rules, and hierarchical dependency rules;

[0020] Steps S1-6: Store all the above codes and their attributes in the database to form a standard catalog code library.

[0021] As a preferred approach, the sub-table data collection in step S2 specifically includes the following sub-steps:

[0022] Step S2-1: Based on the primary geological element categories in the standard cataloging code library, construct multiple independent data acquisition sub-tables, each sub-table corresponding to a primary category, and pre-set a list of standard cataloging code options allowed under that category in the sub-table;

[0023] Step S2-2: Display all sub-tables in parallel on the user interface. Each sub-table is presented in a table format that can dynamically add or delete rows. The table columns include at least the start depth, end depth, and code selection bar.

[0024] Step S2-3: The user adds records row by row in each sub-table, selects the standard catalog code corresponding to the current depth interval from the preset code options through the code selection bar, and manually enters the start and end depth values ​​of the interval. The same code is allowed to correspond to multiple non-contiguous depth intervals in the same sub-table.

[0025] Step S2-4: During the data acquisition process, the system performs real-time logical verification on the depth ranges input in each sub-table, including checking whether there is overlap between the depth ranges of each row in the same sub-table, whether the depth value meets the requirement that the starting value is less than the ending value, and prompting the user to correct the error when an error is detected.

[0026] Step S2-5: After the data collection is completed, the depth range and standard cataloging code data entered in each sub-table are stored as independent datasets. Each dataset records the distribution of all codes under the geological element category along the depth direction, which serves as the original input for subsequent automatic stratification processing.

[0027] As a preferred approach, the automatic stratification process in step S3 specifically includes the following sub-steps:

[0028] Step S3-1: Collect the standard catalog codes of all records in each sub-table and their corresponding starting and ending depths to form the original dataset with depth intervals as the basic unit;

[0029] Step S3-2: Extract all starting depth values ​​and ending depth values ​​from all original datasets to form a set of depth nodes. Sort and deduplicate the depth values ​​in this set to generate a series of smallest indivisible depth micro-intervals defined by adjacent depth values.

[0030] Step S3-3: Traverse each depth micro-interval and retrieve the standard catalog code covering the micro-interval range in each sub-table. If multiple codes in a sub-table cover the current micro-interval at the same depth interval, select a valid code from them according to the preset priority rules or geological logic to ensure that each sub-table corresponds to at most one valid standard catalog code in each micro-interval.

[0031] Step S3-4: Summarize the valid standard catalog codes selected from all sub-tables within the same depth micro-interval to form the code combination corresponding to the micro-interval, and merge adjacent micro-intervals with the same code combination in depth order to generate preliminary geological stratification segments;

[0032] Step S3-5: Determine the top and bottom depths of each merged stratum as the minimum starting depth and maximum ending depth of all micro-intervals within that stratum, and use the code combinations that appear within that stratum as the code set of that stratum, ultimately forming a stratification sequence composed of multiple continuous and mutually exclusive geological stratification results.

[0033] As a preferred approach, the automatic generation of the descriptive text in step S4 specifically includes the following sub-steps:

[0034] Step S4-1: For each geological stratification result, extract all standard logging codes and their corresponding depth intervals that appear in that stratum to form the original code set for that stratum;

[0035] Step S4-2: Based on the hierarchical structure and geological semantic definition of the standard cataloging code, classify and group the codes in the original code set, identify the main geological feature codes and auxiliary description codes, and sort the codes according to the preset priority rules to determine the logical order of description;

[0036] Step S4-3: Based on the sorted code combinations, match the description template corresponding to the code combination type from the preset description template library. The description template includes a fixed text part and a fillable variable part, and the template type covers a variety of geological description scenarios such as single code description, multi-code combination description, and code superposition description.

[0037] Step S4-4: Call the code-semantic mapping rules to convert each standard catalog code into a corresponding geological semantic name or descriptive phrase, and fill the converted semantic content into the corresponding variable positions in the description template according to the variable mapping relationship in the template to form a preliminary description text;

[0038] Step S4-5: Perform grammatical verification and geological logic consistency checks on the preliminary description text, adjust the word order, add modifiers, or merge similar descriptions according to geological specifications, and generate a standardized description text that conforms to geological professional standards.

[0039] As a preferred approach, the result association storage in step S5 specifically includes the following sub-steps:

[0040] Step S5-1: Generate a unique layer identifier for each geological layering result, and record the top and bottom depths, code combination, and standardized descriptive text of the layer to construct a layering result data table;

[0041] Step S5-2: Establish a traceability relationship between the stratification results and the original logging data: For each geological stratification result, identify and record the sub-table name, record row number or record identifier of each original standard logging code record that constitutes the stratification result, and form a correlation mapping table;

[0042] Step S5-3: Store the hierarchical result data table, the association mapping table, and the original sub-table dataset in the same database or data file, and establish data links through foreign keys or pointers;

[0043] Step S5-4: Based on the stored association, provide a traceability query interface to support reverse querying from any geological stratification result to all original catalog data records it depends on, and forward querying from any original record to its corresponding geological stratification result;

[0044] Step S5-5: Based on the preset output format template, the geological stratification results, their standardized descriptive text, and the original logging data corresponding to the traceability query requirements are automatically generated into a geological logging result document or data file, thus achieving the output capability of the results.

[0045] A standardized code cataloging and management system for performing the above method, the system comprising:

[0046] The standard cataloging code system construction module is configured to establish a standard cataloging code library covering multiple geological elements based on a classification system of geological elements. Each standard cataloging code has a unique coding identifier, a preset geological semantic definition, and data structure constraints.

[0047] The sub-table data acquisition module is configured to collect cataloging data of different geological elements through multiple independent sub-tables. Each sub-table corresponds to a type of geological element. Users only need to input the standard cataloging code and its corresponding depth range information in each sub-table, and perform logical verification on the input depth range. After the acquisition is completed, the data of each sub-table is stored as an independent dataset.

[0048] The automatic stratification processing module is configured to collect the standard catalog codes and their depth intervals from each sub-table, extract all depth nodes and generate the minimum depth micro-interval, traverse each micro-interval to determine the valid codes of each sub-table within that micro-interval, form a micro-interval code combination, and then merge adjacent micro-intervals with consecutive and identical code combinations to generate a stratification sequence consisting of multiple consecutive and mutually exclusive geological stratification results.

[0049] The automatic description text generation module is configured to extract all standard catalog codes appearing in each geological stratum result, sort and group them according to the code hierarchy and preset rules, match the corresponding description template, and call the code-semantic mapping rules to convert the code into geological semantic phrases to fill the template, generating standardized description text that conforms to geological specifications.

[0050] The results association storage module is configured to generate a unique layer identifier for each geological layer result and record its top and bottom depths, code combinations and standardized descriptive text, establish a traceability association mapping between the layer results and the original logging data, associate and store the layer results, association mapping and the original sub-table dataset, and provide a traceability query interface and results output function.

[0051] As can be seen from the technical solutions provided by the present invention above, the standardized code cataloging and management method and system provided by the present invention have the following beneficial effects:

[0052] This invention constructs a hierarchical standard logging code system, providing unified coding rules, semantic benchmarks, and data structure constraints for the entire geological logging process. This system deeply binds the classification paths of geological elements with the code structure, achieving a one-to-one correspondence between codes and geological semantics. It eliminates coding differences and semantic ambiguities from the source under different operating entities and project scenarios, and completely solves the common industry problems of inconsistent naming, non-standard terminology, and inconsistent expression logic in traditional logging operations. It achieves comprehensive standardization and normalization of geological logging data and results.

[0053] This invention innovatively adopts a sub-table data acquisition mode, breaking the limitations of traditional manual pre-division of geological strata. By collecting logging data of different geological elements through independent sub-tables, users only need to enter the standard logging code and the corresponding depth interval information to complete the data acquisition, eliminating the need for prior geological stratification judgment and greatly simplifying the operation process in front-line work. At the same time, the built-in real-time logic verification mechanism during the acquisition process can promptly identify and correct problems such as overlapping depth intervals and numerical logic errors, avoiding the entry of invalid and erroneous data from the source and ensuring the accuracy and compliance of the original logging data.

[0054] This invention achieves fully automated geological stratification, completely replacing traditional manual stratification operations. Based on code depth data collected from multiple sub-tables, the system can automatically identify nodes of geological feature changes. Through a full-process algorithm that generates minimum depth micro-intervals, filters effective codes, and merges intervals with the same features, it generates continuous and mutually exclusive standardized geological stratification results. The entire stratification process is entirely driven by raw data, requiring no manual intervention. This eliminates problems such as subjective judgment bias, inconsistent boundary determination standards, and low work efficiency caused by manual stratification, significantly improving the accuracy and efficiency of geological stratification while ensuring consistency of stratification results across different projects and among different workers.

[0055] This invention enables the automated and standardized generation of geological logging description texts, effectively solving the problems of low efficiency, non-standard expression, and inconsistent content quality associated with traditional manual writing of description texts. Through preset code semantic mapping rules and a full-scene description template library, the system can automatically convert the code combinations corresponding to geological strata into standardized description texts that conform to geological professional standards. At the same time, through dual verification of grammatical fluency and geological logical consistency, the professionalism and compliance of the generated text are ensured. This function significantly reduces the manual workload of logging results compilation, shortens the results output cycle, and achieves comprehensive uniformity in the expression of logging results.

[0056] This invention constructs a fully traceable results-related storage system, realizing closed-loop management of the entire lifecycle of geological logging data. The system deeply associates and binds the final generated geological stratification results, standardized descriptive texts, and original logging data, establishing a two-way traceability query mechanism. It supports tracing back from the final results to the original collected data, and also allows forward querying from the original records to their application scope in the results. This completely solves the problems of disconnect between results and original data, untraceable data sources, and inability to define responsibilities in traditional logging operations, ensuring the integrity and credibility of logging data, and providing complete data support for subsequent results verification, data auditing, and accountability.

[0057] This invention significantly improves the reusability and sharing of geological logging data, effectively breaking down data silos within the industry. All logging data generated by the system is structured data based on a unified coding system, which can be directly connected to various professional platforms such as geological exploration data management systems, 3D geological modeling systems, and mineral resource evaluation systems, achieving cross-platform sharing and reuse of data without secondary conversion processing. The standardized output data also provides high-quality basic data support for geological data aggregation and analysis, regional geological research, and mineral resource exploration within the industry, fully releasing the application value of geological logging data.

[0058] This invention effectively lowers the professional threshold and overall cost of geological logging operations. Through standardized code option pre-setting, automated layered processing, and standardized text generation, it significantly reduces the professional ability requirements for front-line logging personnel. Operators do not need to have a deep geological background or rich logging experience to complete high-quality logging operations, effectively alleviating the current shortage of professional personnel in the industry. At the same time, the fully automated processing greatly reduces manual operation links, reduces the labor input and time cost of logging operations, and achieves cost reduction and efficiency improvement in geological logging operations. It has strong industry promotion value and application prospects. Attached Figure Description

[0059] Figure 1 This is a schematic diagram of the steps in a standardized code cataloging and management method according to the present invention;

[0060] Figure 2 This is a schematic diagram of the structure of a standardized code cataloging and management system according to the present invention. Detailed Implementation

[0061] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention.

[0062] To better understand the above technical solutions, the following will provide a detailed explanation of the technical solutions in conjunction with the accompanying drawings and specific embodiments.

[0063] like Figure 1-2 As shown, this embodiment of the invention provides a standardized code cataloging and management method, including the following steps:

[0064] Step S1: Establish a standard logging code system: Construct a standard logging code library covering multiple geological elements. Each standard logging code has a unique coding identifier, a preset geological semantic definition, and data structure constraints.

[0065] Step S2: Sub-table data acquisition: Collect logging data of different geological elements through multiple independent sub-tables. Each sub-table corresponds to a type of geological element. Users only need to input the standard logging code and its corresponding depth interval information in each sub-table, without having to pre-divide geological strata.

[0066] Step S3: Automatic stratification: Based on the depth range of the standard catalog codes in each sub-table, the start and end points of each code in the depth direction are automatically identified. By comparing the start and end points of codes in multiple sub-tables, geological feature change nodes are determined, and the depth range is divided into continuous and mutually exclusive geological stratification results according to the change nodes.

[0067] Step S4: Automatic generation of description text: For each geological stratification result, summarize all standard cataloging code combinations that appear in that stratum, call the preset description template and code-semantic mapping rules, and convert the code combinations into standardized description text that conforms to geological specifications;

[0068] Step S5: Results Association and Storage: The generated geological stratification results and standardized descriptive text are associated and stored with the original logging data to form traceable and output geological logging results.

[0069] In this embodiment, the core function of step S1 is to construct a standard logging code library covering multiple geological elements. This provides unified coding rules, semantic benchmarks, and data structure constraints for the entire process of subsequent sub-table data acquisition, automatic hierarchical processing, automatic generation of descriptive text, and result association storage. This achieves standardization, structuring, and reusability of geological logging data from the source, eliminating coding differences and semantic ambiguities under different logging entities and different operational scenarios, and ensuring the consistency and standardization of data logic throughout the entire process. The detailed steps are as follows:

[0070] Step S1-1: Establishment of a hierarchical classification system for geological elements and division of primary categories:

[0071] Based on current national standards for geological exploration and industry-standard geological logging classification rules, a comprehensive hierarchical classification system for geological elements is established. This system uses the core geological objects to be recorded during geological logging operations as the classification benchmark, clearly defining the hierarchical division rules for geological elements. The hierarchical division follows a progressive logic from macro to micro and from main to subordinate elements, ensuring that the classification system meets the needs of geological professionals and practical logging operations. Based on this classification system, multiple primary geological element categories are determined. These primary geological element categories fully cover all core geological objects to be recorded throughout the geological logging process, including lithology, structure, alteration, mineralization, fossils, hydrogeological phenomena, and engineering geological phenomena. Each primary geological element category is assigned a unique category code using fixed-length uppercase English character encoding, with a minimum length of two digits, ensuring that each primary geological element category corresponds to a unique category code, without duplication or omission. The primary geological element categories and their corresponding category codes are associated and stored to form a primary classification mapping benchmark, providing a basic framework for subsequent sub-level code refinement.

[0072] Step S1-2: Geological element hierarchical refinement and sub-hierarchical code allocation:

[0073] For each primary geological element category, a hierarchical refinement process is performed based on the inherent hierarchical relationships of the corresponding geological features and industry classification standards. This refinement process strictly adheres to geological professional standards. Under each primary category, secondary geological element subcategories are first refined according to the major attributes of the geological features. Then, under each secondary subcategory, tertiary geological element subcategories are further refined according to the specific types of geological features. This ensures that the classification boundaries of each sub-level are clear, non-overlapping, and completely cover all geological feature types under the corresponding higher-level category. Each refined secondary and tertiary subcategory is assigned a corresponding hierarchical code. The hierarchical code uses a fixed-length Arabic numeral encoding that matches the length of the higher-level category code. Sub-level codes under the same higher-level category remain continuous and unique, while sub-level codes under different higher-level categories can be encoded independently without interference. Each level of subcategory is associated with its corresponding hierarchical code and stored to form a hierarchical classification mapping table, providing a hierarchical basis for the generation of standard catalog codes.

[0074] Step S1-3: Generation of hierarchical standard catalog code combination:

[0075] Based on preset code combination rules, the category code of the first-level geological element category is combined with the hierarchical code of the corresponding sub-level in a fixed order to generate a standard catalog code with a hierarchical structure. The code combination rules follow the classification path order from the upper level to the lower level. The standard catalog code generated by the combination can directly reflect the complete classification path of the corresponding geological feature, realizing a one-to-one correspondence between the code and the classification path.

[0076] The formula for calculating code combination is:

[0077] ,in, The final generated standard catalog code; This refers to the category code corresponding to the primary geological element category; This is the hierarchical code corresponding to the secondary geological element subclass; This is the hierarchical code corresponding to the third-level geological element subclass; This is an operation for concatenating code characters in sequence;

[0078] For secondary geological element subclasses without tertiary subclasses, fixed padding characters are used to fill the corresponding hierarchical code positions to ensure that the total length of all standard catalog codes remains consistent. Uniqueness verification is performed on all generated standard catalog codes to ensure that each standard catalog code has a unique identifier, with no duplicate or invalid codes. After verification, the standard catalog codes are associated with and stored with the complete classification paths of the corresponding geological elements to form a database of correspondences between codes and classification paths.

[0079] Step S1-4: Defining the geological semantics of standard catalog codes and establishing mapping relationships:

[0080] For each standard cataloging code with a unique identifier, a standardized geological semantic definition operation is performed. The geological semantic definition strictly follows the current national standards and industry terminology standards for geological exploration to ensure the professionalism, accuracy, and universality of the semantic expression. The geological semantic definition includes three core contents: the standard name of the corresponding geological feature, the standard definition, and the standardized descriptive text template. The standard name of the geological feature adopts the industry-standard naming rules to ensure that different cataloging entities have a completely consistent naming of the same geological feature. The standard definition of the geological feature clearly defines the core identification features, boundary determination criteria, and applicable operation scenarios of the geological element, completely eliminating semantic ambiguity. The standardized descriptive text template pre-sets the standard expression structure of the geological feature in the geological cataloging results, providing a basic template support for the automatic generation of subsequent descriptive text.

[0081] After completing the geological semantic definition of all standard catalog codes, a one-to-one mapping relationship between each standard catalog code and its corresponding geological semantic content is established, forming a code-semantic mapping rule base. The code-semantic mapping rule base supports quick retrieval of the corresponding complete geological semantic content through the standard catalog code, and also supports reverse retrieval of the corresponding standard catalog code through the geological feature standard name, realizing a two-way accurate mapping between code and semantics.

[0082] Step S1-5: Setting constraints for standard catalog code data structure:

[0083] For each standard cataloging code, corresponding data structure constraints are set to ensure that the cataloging data collected based on that code conforms to a unified format specification and geological logic rules, thus avoiding the input of invalid or erroneous data from the source. The data structure constraints include four core components: data format constraints, allowed value range constraints, standard unit of measurement constraints, and cross-code association rule constraints.

[0084] Data format constraints clearly define the storage format of the data corresponding to the standard catalog code, including three basic formats: numeric, character, and Boolean. For numeric data, constraints on the effective decimal places are set synchronously. Allowable value range constraints clearly define the legal value range of the data corresponding to the standard catalog code; data exceeding this range will be considered invalid. Standard unit of measurement constraints clearly define the legal standard unit of measurement for the data corresponding to the standard catalog code; all collected data must be uniformly converted to standard units of measurement for storage to eliminate data deviations caused by unit differences. Cross-code association rule constraints clearly define the geological logical relationships between the standard catalog code and other codes, including three types: mandatory co-occurrence rules, mutual exclusion rules, and hierarchical dependency rules, ensuring that the collected code combinations conform to geological professional logic and have no logical conflicts.

[0085] All data structure constraints corresponding to the standard catalog codes are associated with and stored with the codes themselves to form a code constraint rule base, which provides rule support for real-time data verification in the subsequent sub-table data collection process;

[0086] Steps S1-6: Construction and permanent storage of the standard catalog codebase:

[0087] All standard catalog codes generated in the preceding steps, along with the corresponding classification path information, geological semantic content, data structure constraints, code-semantic mapping rules, and cross-code association rules, are comprehensively integrated to construct a complete standard catalog code library. The standard catalog code library is stored using a structured relational database, with the unique encoding identifier of the standard catalog code as the primary key, and all attribute information corresponding to the code stored as association fields, ensuring that all attribute information of each code can be quickly retrieved and called through the primary key.

[0088] After the initial construction of the codebase is completed, a full-base integrity check and a logical consistency check are performed. The integrity check ensures that the codebase fully covers all preset geological element types, with no missing codes or attribute information. The logical consistency check ensures that there are no logical conflicts or content contradictions between the hierarchical structure, semantic definitions, and constraint rules of the code. After the checks pass, the standard logging codebase is solidified and stored. At the same time, a standardized program call interface is set up to support real-time calling and retrieval of the codebase content by subsequent process modules, providing a unified standardized code benchmark for the entire geological logging operation.

[0089] In this embodiment, the core function of step S2 is to classify and collect different geological element cataloging data based on the standard cataloging code library constructed in step S1, using multiple independent sub-tables. Each sub-table corresponds to a type of geological element, and the user only needs to enter the standard cataloging code and its corresponding depth interval information in each sub-table, without needing to pre-divide the geological strata. Simultaneously, real-time data verification ensures the logical compliance of the original collected data, providing structured and highly reliable raw input data for subsequent automatic stratification processing. The detailed steps are as follows:

[0090] Step S2-1: Data Acquisition Sub-table Construction and Code Option Presets:

[0091] Based on the first-level geological element categories defined in the standard cataloging code library, an independent data acquisition sub-table is constructed for each first-level geological element category. Each sub-table has a one-to-one correspondence with a unique first-level geological element category, and the number of sub-tables is exactly the same as the number of first-level geological element categories. For each data acquisition sub-table, a list of all allowed standard cataloging codes under the corresponding first-level geological element category is pre-set within the sub-table. The standard cataloging codes in the option list are synchronously associated with their corresponding geological semantic definitions and data structure constraints, ensuring that users can directly select compliant standard cataloging codes from the option list without manually entering code characters, thus avoiding the entry of invalid and erroneous codes from the source.

[0092] Step S2-2: Displaying the Sub-Table Interface and Configuring the Table Structure:

[0093] All data acquisition sub-tables are displayed in parallel on the system user interface. Each sub-table is presented in a table format that supports dynamic addition and deletion of rows. The basic columns of the table include at least three core columns: starting depth, ending depth, and code selection bar. The starting depth and ending depth columns are used to enter the depth interval boundary values ​​of the corresponding logging records, and the code selection bar is used to retrieve and select the preset standard logging code option list within the sub-table. The table allows users to freely add or delete data rows according to the actual logging operation requirements, without a fixed number of rows, adapting to logging operation scenarios with different depth ranges and different geological complexities.

[0094] Step S2-3: Enter data line by line and configure depth range:

[0095] Users add logging data records row by row in the tables of each data collection sub-table. To complete the entry of a single record, two core operations must be performed sequentially. The first operation is code selection. Users select the standard logging code that matches the geological features of the current depth interval from the pre-set list of standard logging code options in the code selection bar of the corresponding row. The second operation is depth interval configuration. Users manually enter the start and end depth values ​​of the depth interval corresponding to the standard logging code in the start and end depth columns of the corresponding row. Within the same sub-table, the same standard logging code can correspond to multiple non-contiguous depth intervals, adapting to actual logging scenarios where the same geological feature appears repeatedly in different depth segments.

[0096] Step S2-4: Real-time logic verification and error correction prompts for depth ranges:

[0097] Throughout the entire data collection process, the system performs real-time logical validation on the depth range data entered by the user in each sub-table. The validation operation is triggered immediately after the user completes and confirms the entry of a single data row, without waiting for all data to be collected. The logical validation includes two core validation rules: the first is a depth value logical validation, which checks whether the starting depth value in a single record is less than the ending depth value, avoiding logical errors caused by inverted depth range boundaries. The validity of the depth range of a single catalog record must satisfy the following formula:

[0098] ,in, This refers to the starting depth value entered within a single record. The termination depth value entered within the same record;

[0099] The second step is interval overlap verification, which checks whether there is any overlap in the depth intervals corresponding to different rows of data within the same sub-table, ensuring that only one valid catalog record corresponds to the same depth position within the same sub-table; any two entered catalog records within the same sub-table... With records For their depth intervals to be non-overlapping, the following formula must be satisfied:

[0100] ,in, For record The initial depth value, For record The termination depth value, For record The initial depth value, For record The termination depth value, The logical OR operator indicates that the intervals are non-overlapping if either of the two inequalities is satisfied.

[0101] When the system detects data that does not conform to the verification rules, it immediately displays an error message at the corresponding data row position on the user interface, and locks the submission operation of the erroneous record, guiding the user to complete the data correction until the data passes the verification before the data entry can be completed.

[0102] Step S2-5: Independent storage of sub-table datasets and encapsulation of original input data:

[0103] After all logging data collection is completed and all sub-table data passes logical verification, the system stores the depth interval data and standard logging code data entered in each sub-table into independent datasets according to the primary geological element category corresponding to the sub-table. Each dataset fully records the distribution of all standard logging codes along the depth direction under the corresponding geological element category. Each record in the dataset contains three core information: standard logging code, starting depth value, and ending depth value. All independent datasets corresponding to the sub-tables together constitute the original logging dataset, which serves as the sole original input for the subsequent automatic stratification process in step S3, ensuring that the original entry information of each geological feature can be fully traced during the subsequent stratification process.

[0104] In this embodiment, the core function of step S3 is to automatically identify the start and end points of each code in the depth direction based on the standard cataloging codes and their corresponding depth interval data collected in each sub-table in step S2. By comparing the start and end depth nodes of codes in multiple sub-tables, the geological feature change nodes are determined. Then, based on the change nodes, the complete depth interval is divided into continuous and mutually exclusive geological stratification results, completely replacing manual stratification operations and eliminating problems such as inconsistent standards, low efficiency, and boundary judgment deviations caused by manual stratification. This provides a unified stratification benchmark for the subsequent generation of standardized descriptive text. The detailed steps are as follows:

[0105] Step S3-1: Aggregation of raw datasets and integration of depth interval units:

[0106] Collect all the independent datasets corresponding to the sub-tables generated in step S2, extract the standard catalog codes of all records in each dataset, as well as the start and end depth values ​​of the corresponding records, and combine each code and its corresponding depth interval into an independent basic unit of depth interval. The basic units of depth intervals of all sub-tables together constitute the original dataset for automatic stratification processing. The original dataset completely retains the source sub-table information and code attribute information of each catalog record, ensuring that the stratification process can be traced back to the original collected data without information loss or tampering.

[0107] Step S3-2: Construction of the depth node set and generation of the minimum indivisible depth micro-interval:

[0108] From all the basic units of depth intervals in the original dataset, all starting and ending depth values ​​are extracted, and all extracted depth values ​​together constitute a depth node set. All depth values ​​in the depth node set are sorted in ascending order, and duplicate depth values ​​are removed to ensure that there are no duplicate values ​​in the sorted depth node set, and all depth values ​​are arranged in ascending order. Using two adjacent depth values ​​after sorting as the upper and lower boundaries, a series of continuous minimum indivisible depth micro-intervals are generated. Each micro-interval does not contain any geological feature change nodes and is the smallest unit that cannot be further divided in the depth direction.

[0109] The sorted and deduplicated depth node sequence is represented by the following formula:

[0110] ,in, This is the sorted and deduplicated sequence of depth nodes. These are the depth node values ​​sorted in ascending order within the sequence. This represents the total number of depth nodes;

[0111] The generation of a single minimum indivisible depth microinterval is expressed by the following formula:

[0112] ,in, For the first The smallest indivisible depth interval This represents the starting depth node value for this micro-interval. This is the value of the terminal depth node in this micro-interval. The value range is 1 to ;

[0113] Step S3-3: Depth-wise micro-range traversal and effective code filtering of sub-tables:

[0114] Traverse each generated minimum indivisible depth micro-interval in ascending order of depth. For the currently traversed depth micro-interval, retrieve the standard catalog code that completely covers the current micro-interval from the independent dataset of each sub-table. The coverage determination must meet the preset logical rules to ensure that the retrieved code is valid throughout the entire micro-interval. If multiple codes in a sub-table cover the current micro-interval, select the only valid code based on the preset priority rules or geological logic rules. This ensures that each sub-table corresponds to at most one valid standard catalog code in each depth micro-interval, avoiding multiple conflicting feature descriptions of the same geological element at the same depth location.

[0115] The rule for determining whether code covers the current microinterval is expressed by the following formula:

[0116] ,in, This is the starting depth value of the record corresponding to the code to be retrieved. This represents the termination depth value of the record corresponding to the code to be retrieved. The logical AND operator indicates that two inequality conditions must be satisfied simultaneously for the code to be considered to cover the current microinterval.

[0117] Step S3-4: Micro-interval code combination construction and adjacent interval merging:

[0118] For each depth micro-interval, all valid standard catalog codes selected from the sub-tables within that micro-interval are compiled to form a unique code combination corresponding to that micro-interval. The code combination completely contains the valid codes corresponding to all geological elements within the current micro-interval, fully reflecting all geological features at that depth location. After completing the code combination construction for all micro-intervals, adjacent depth micro-intervals with identical code combinations are merged in ascending order of depth. The resulting continuous depth intervals are the preliminary geological stratification segments. During the merging process, the depth continuity rule is strictly followed, and merging is only performed on adjacent micro-intervals. Non-adjacent micro-intervals are not merged to ensure that the merged geological stratification segments remain continuous in the depth direction without depth breaks.

[0119] Step S3-5: Determination of geological stratification results and final generation of stratification sequence:

[0120] For each preliminary geological stratum generated after merging, the minimum starting depth value of all micro-intervals within the stratum is determined as the top boundary depth of the stratum, and the maximum ending depth value of all micro-intervals within the stratum is determined as the bottom boundary depth of the stratum. At the same time, the unified code combination within the stratum is determined as the code set corresponding to the stratum. All geological strata are arranged in ascending order of depth, ultimately forming a stratification sequence composed of multiple continuous and mutually exclusive geological stratification results. The stratification sequence must completely cover the entire depth range of the logging operation, with the top and bottom depths of adjacent strata completely connected, with no depth overlap areas and no depth omission intervals, providing standardized stratification units for the subsequent automatic generation of descriptive text.

[0121] The depth connection rule between adjacent geological strata is expressed by the following formula:

[0122] ,in, For the first The depth of the bottom boundary of each geological stratification result. For the first The top boundary depth of a geological stratification result. This refers to the sequence number of the geological stratification results.

[0123] In this embodiment, the core function of step S4 is to summarize all standard logging code combinations appearing within each geological stratification result generated in step S3, and call preset description templates and code-semantic mapping rules to convert the code combinations into standardized description text conforming to geological specifications. This achieves the unification, standardization, and automated generation of geological logging description content, eliminating problems such as inconsistent terminology, non-standard expressions, and logical inconsistencies caused by manual description, and significantly improving the efficiency and professional compliance of geological logging results. The detailed steps are as follows:

[0124] Step S4-1: Extraction of hierarchical code sets and aggregation of raw data:

[0125] For each geological stratification result generated in step S3, the top and bottom depths of the stratum are first determined. Then, from the independent datasets of each sub-table in step S2, standard catalog codes that completely cover the stratum range in all depth intervals are extracted, along with the complete depth interval information of the corresponding codes. All extracted standard catalog codes are integrated to form a set of original codes that uniquely corresponds to the geological stratification result. The set of original codes completely preserves the hierarchical structure information and source sub-table information corresponding to the codes, without any omissions or tampering, providing complete basic data support for subsequent classification, grouping, and semantic transformation.

[0126] The rule for determining whether code covers the current geological stratum is expressed by the following formula:

[0127] ,in, For the first The top boundary depth of a geological stratification result. For the first The depth of the bottom boundary of each geological stratification result;

[0128] Step S4-2: Code classification and grouping, and determination of logical order of description:

[0129] Based on the hierarchical structure and geological semantic definition of the standard logging code constructed in step S1, a classification and grouping operation is performed on all codes in the original code set. First, according to the primary geological element category corresponding to the code, the code is divided into two major categories: main geological feature code and auxiliary description code. The main geological feature code corresponds to the geological element category that determines the core attributes of the layer, and the auxiliary description code corresponds to the geological element category that supplements the description of the additional features of the layer. Then, according to the preset geological description priority rules, the grouped codes are sorted in descending order. The priority rules completely match the description order of the general specifications of the geological logging industry, and finally the description logic order of the layer code combination is determined.

[0130] The priority weight of a single standard catalog code is calculated using the following formula:

[0131] ,in, This refers to the priority weight value of a single standard catalog code. These are the preset weight values ​​for the primary geological element categories corresponding to the codes. The preset weight value is assigned to the corresponding level of the code. The higher the weight value, the higher the order of the code in the description logic.

[0132] Step S4-3: Describe the template matching and adaptation rule invocation:

[0133] Based on the sorted code combinations, a description template that perfectly matches the code combination type is matched from a pre-set description template library. The templates in the description template library contain fixed text parts and fillable variable parts, and the template types fully cover all common geological logging description scenarios such as single code description, multi-code combination description, and code overlay description. The template matching process follows the principle of maximum fit, giving priority to matching templates that are completely compatible with the code combination in terms of code quantity, category composition, and hierarchical structure, ensuring that the description framework of the template fully complies with the expression requirements of geological professional specifications.

[0134] Step S4-4: Code semantic transformation and template content filling:

[0135] The code-semantic mapping rule library constructed in step S1 is called to convert each standard catalog code in the sorted code combination into the corresponding geological semantic name or standardized descriptive phrase; then, according to the variable mapping relationship in the matched description template, the converted geological semantic content is filled into the corresponding variable position of the description template according to the preset description logic order, and the full filling operation of the template content is completed to generate the preliminary description text corresponding to the geological stratification result.

[0136] The conversion from standard catalog codes to geological semantics is represented by the following formula:

[0137] ,in, This refers to the geological semantic content converted from standard catalog codes. The standard catalog code to be converted, The mapping function corresponding to the code-semantic mapping rule library built in step S1;

[0138] Step S4-5: Compliance verification and final generation of standardized description text:

[0139] The generated preliminary descriptive text undergoes a dual verification process. The first verification is grammatical fluency, checking whether the text's sentence structure and word order logic conform to modern Chinese expression standards, avoiding issues such as incoherent sentences and incomplete components. The second verification is geological logical consistency, checking whether the text content conforms to geological professional standards, whether the semantic content after code conversion fully matches the code combination of geological stratification, and whether the description order of different categories of geological features conforms to industry-standard rules. After verification, the text is adjusted in word order, modifiers are added, or similar descriptions are merged according to geological standards to eliminate redundant expressions, ultimately generating a standardized descriptive text that conforms to geological professional standards.

[0140] In this embodiment, the core function of step S5 is to perform end-to-end association and storage of the geological stratification results generated in step S3, the standardized descriptive text generated in step S4, and the original logging data collected in step S2. This constructs a complete geological logging results system that is bidirectionally traceable and can be output in a standardized manner, ensuring the data integrity, logical traceability, and universality of the logging results. It provides standardized data support for the archiving, retrieval, reuse, and output of geological logging results. The detailed steps are as follows:

[0141] Step S5-1: Construction of hierarchical result data table and generation of unique identifiers:

[0142] For each geological stratification result generated in step S3, a globally unique stratification identifier is generated. The stratification identifier uses a fixed-length coding rule that balances uniqueness and identifiability, ensuring that each geological stratification result corresponds to a unique identifier, with no duplication or omission. Simultaneously, the top and bottom boundary depths of the stratum, the corresponding code set, and the standardized descriptive text generated in step S4 are recorded. All information is structured and integrated according to the stratification identifier to construct a stratification result data table. The stratification result data table uses the stratification identifier as the primary key, and all stratification-related attribute information as associated fields, supporting quick retrieval of full information for the corresponding stratum by stratification identifier. The validity of the stratification depth must satisfy the following formula:

[0143] ,in, For the first The top boundary depth of a geological stratification result. For the first The depth of the bottom boundary of each geological stratification result;

[0144] Step S5-2: Tracing the construction of the association mapping table:

[0145] For each geological stratification result, identify and record each original standard logging code record that constitutes the stratification result, along with its corresponding sub-table name, record row number, and unique record identifier. Bind the stratification identifier to the original record identifier one-to-one, fully recording the geological stratification result formed by each original logging record, as well as all original logging records that each geological stratification result depends on, forming an association mapping table. The association mapping table fully covers the association between all stratification results and all original logging records, with no association faults, ensuring that each stratification attribute can be traced back to the corresponding original acquisition data.

[0146] The mapping relationship between hierarchical levels and original records is represented by the following formula:

[0147] ,in, For a set of association mapping relationships, It serves as a unique stratification identifier for geological stratification results. To constitute the first layer of this hierarchical result The unique identifier of each original catalog record This represents the total number of original catalog records corresponding to a single-level result.

[0148] Step S5-3: Multi-table join storage and data link construction:

[0149] The constructed hierarchical result data table and association mapping table, along with the original sub-table dataset generated in step S2, are stored in the same database or data file. Stable data links are established between the hierarchical result data table, association mapping table, and original sub-table dataset through database foreign keys or data pointers. The data links use the hierarchical identifier and the original record identifier as the anchor points to ensure that the relationships between the data tables can be stably identified and called by the system, and that the relationships will not be broken due to data migration or changes in the storage environment. During the storage process, the original attributes of all data are completely preserved, and there is no data tampering or information loss.

[0150] Step S5-4: Configuration and implementation of the bidirectional traceability query interface:

[0151] Based on established relationships and data links, a standardized bidirectional traceability query interface was developed and configured. The query interface supports two core traceability query operations: the first is reverse traceability query, which allows querying from any geological stratum result back to all original logging data records it depends on, fully restoring the original data source and formation logic of that stratum result; the second is forward traceability query, which allows querying from any original logging data record forward to all geological stratum results to which it belongs, clarifying the application scenarios and scope of influence of the original data in the final logging results. The query interface adopts standardized calling rules, supporting compatibility and adaptation with various geological exploration data management systems, enabling calls without additional adaptation development.

[0152] Step S5-5: Standardized output and document generation of cataloging results:

[0153] The system loads a pre-defined geological logging output format template, which fully complies with national geological exploration standards and industry archiving requirements. Based on the output format template, it integrates geological stratification results, corresponding standardized descriptive text, and original logging data for traceability and query needs according to a pre-defined structure and order, automatically generating a compliant geological logging output document or structured data file. The output supports multiple common formats to meet the needs of archiving, reporting, submitting, and reusing results in different scenarios, achieving standardized output of geological logging results. During the output process, users can customize the output content modules according to their needs, flexibly adapting to different application scenarios.

[0154] A standardized code cataloging and management system is provided for executing the above-mentioned methods. This system serves as the core carrier for standardized and automated operations throughout the entire geological logging process. By constructing a closed-loop architecture encompassing a unified code system, sub-table data acquisition, automated hierarchical processing, standardized text generation, and end-to-end results management, it addresses the pain points of traditional geological logging operations, such as inconsistent standards, low efficiency, untraceable data, and insufficient results standardization. This achieves a digital, standardized, and intelligent upgrade of geological logging operations. The system includes:

[0155] Standard catalog code system construction module:

[0156] The standard cataloging code system construction module is the foundational core of the entire system, providing a unified standardized coding benchmark and semantic specifications for the entire process, eliminating coding differences and semantic ambiguities among different operators and in different work scenarios from the source;

[0157] Geological Element Hierarchical Classification System Construction: Based on current national standards for geological exploration and industry-standard geological logging classification rules, a comprehensive hierarchical classification system for geological elements is constructed. The system follows a progressive logic from macro to micro and from primary to secondary elements, aligning with the needs of geological professionals in both cognitive and practical logging operations. Based on this system, multiple primary geological element categories are identified, fully covering all core geological objects required to be recorded throughout the geological logging process. A unique category code is assigned to each primary geological element category, forming a primary classification mapping benchmark. For each primary geological element category, it is further refined according to the inherent hierarchical relationships of geological characteristics, sequentially forming secondary and tertiary geological element subcategories. This ensures clear, non-overlapping, and non-intersecting boundaries between sub-level classifications. A corresponding hierarchical code is assigned to each sub-level, forming a hierarchical classification mapping table.

[0158] Hierarchical standard catalog code generation: Based on preset code combination rules, the category code of the primary geological element category and the hierarchical code of the corresponding sub-level are combined in a fixed order to generate a hierarchical standard catalog code. The code can directly reflect the complete classification path of the corresponding geological feature, realizing a one-to-one correspondence between the code and the classification path.

[0159] For secondary geological element subclasses without tertiary subclasses, fixed padding characters are used to fill the corresponding level code positions to ensure that the total length of all standard catalog codes remains consistent; all generated codes are uniquely verified to ensure that each standard catalog code has a unique identifier and that there are no duplicate or invalid codes.

[0160] Code geological semantic definition and mapping relationship establishment: For each standard catalog code with a unique coded identifier, a standardized geological semantic definition is executed. The semantic expression strictly follows the current national geological exploration standards and industry terminology standards to ensure professional accuracy and universality. The geological semantic definition includes three core contents: the standard name of the corresponding geological feature, the standard definition, and the standardized descriptive text template. It clarifies the core identification features, boundary judgment standards, and applicable operation scenarios of geological elements, and completely eliminates semantic ambiguity. After completing the semantic definition of all codes, a one-to-one mapping relationship between each standard catalog code and the corresponding geological semantic content is established to form a code semantic mapping rule base, which supports two-way accurate mapping between code and semantics.

[0161] Code data structure constraint settings: For each standard cataloging code, corresponding data structure constraints are set to ensure that the cataloging data collected based on that code conforms to a unified format specification and geological logic rules, avoiding the input of invalid and erroneous data from the source. The data structure constraints include four core components: data format constraints, allowed value range constraints, standard unit of measurement constraints, and cross-code association rule constraints. These clearly define the storage format, legal value range, legal standard unit of measurement, and geological logical association relationships between the code and its corresponding data. All data structure constraints corresponding to all codes are stored in association with the code itself, forming a code constraint rule base, providing rule support for real-time verification during subsequent data collection.

[0162] Construction and Solidification of Standard Catalog Code Repository: This involves comprehensively integrating all standard catalog codes and their corresponding classification path information, geological semantic content, data structure constraints, code semantic mapping rules, and cross-code association rules to construct a complete standard catalog code repository. The repository is stored using a structured relational database, with the unique identifier of each standard catalog code as the primary key, and all corresponding attribute information stored as association fields. After the initial construction of the repository, a full repository integrity check and logical consistency check are performed. Upon successful verification, the standard catalog code repository is solidified and stored. Simultaneously, standardized program call interfaces are set up to support real-time access and retrieval of the repository content by subsequent workflow modules.

[0163] Sub-table data acquisition module:

[0164] The sub-table data acquisition module is the core entry point for the system to obtain raw catalog data. Based on the standard catalog code library, it realizes the classification, structuring and compliance of catalog data acquisition, providing highly reliable raw input data for subsequent automatic hierarchical processing.

[0165] Classification and Acquisition Sub-table Construction and Code Option Pre-setting: Based on the first-level geological element categories divided in the standard cataloging code library, an independent data acquisition sub-table is constructed for each first-level geological element category. Each sub-table has a one-to-one correspondence with a unique first-level geological element category, and the number of sub-tables is exactly the same as the number of first-level geological element categories. For each data acquisition sub-table, a list of all allowed standard cataloging code options under the corresponding first-level geological element category is pre-set within the sub-table. The standard cataloging codes in the option list are synchronously associated with their corresponding geological semantic definitions and data structure constraints. Users can directly select compliant standard cataloging codes from the option list without manually entering code characters, thus avoiding the entry of invalid and erroneous codes from the source.

[0166] Data Acquisition Interface Configuration and Interaction Logic Design: All data acquisition sub-tables are displayed in parallel on the system user interface. Each sub-table is presented in a table format that supports dynamic addition and deletion of rows. The basic columns of the table include at least three core columns: starting depth, ending depth, and code selection bar. The starting depth and ending depth columns are used to enter the depth interval boundary values ​​of the corresponding logging records, and the code selection bar is used to retrieve and select the preset standard logging code option list within the sub-table. The table allows users to freely add or delete data rows according to the actual logging operation requirements, without a fixed number of rows, adapting to logging operation scenarios with different depth ranges and different geological complexities.

[0167] Data entry and depth range configuration: Users add data records row by row in the tables of each data acquisition sub-table. To complete the entry of a single record, two core operations must be performed sequentially. The first operation is code selection. Users select the standard logging code that matches the geological features of the current depth range from the preset standard logging code option list in the code selection bar of the corresponding row. The second operation is depth range configuration. Users manually enter the start and end depth values ​​of the depth range corresponding to the standard logging code in the start and end depth columns of the corresponding row. Within the same sub-table, the same standard logging code can correspond to multiple non-contiguous depth ranges, adapting to actual logging scenarios where the same geological feature appears repeatedly in different depth segments.

[0168] Real-time logical verification of depth range: Throughout the entire data collection process, the system performs real-time logical verification on the depth range data entered by the user in each sub-table. The verification operation is triggered immediately after the user completes the entry and confirmation of a single data row, without waiting for all data to be collected. The logical verification includes two core verification rules. The first is depth value logical verification, which checks whether the starting depth value in a single record is less than the ending depth value, avoiding logical errors of inverted depth range boundaries.

[0169] The second item is interval overlap verification, which checks whether there is any overlap in the depth intervals corresponding to each row of data in the same sub-table, to ensure that only one valid catalog record corresponds to the same depth position in the same sub-table.

[0170] When the system detects data that does not conform to the verification rules, it immediately displays an error message at the corresponding data row position on the user interface, and locks the submission operation of the erroneous record, guiding the user to complete the data correction until the data passes the verification before the data entry can be completed.

[0171] Sub-table datasets are stored and encapsulated independently: After all logging data collection is completed and all sub-table data passes logical verification, the system stores the depth interval data and standard logging code data entered in each sub-table as independent datasets according to the first-level geological element category corresponding to the sub-table. Each dataset fully records the distribution of all standard logging codes along the depth direction under the corresponding geological element category. Each record in the dataset contains three core pieces of information: standard logging code, starting depth value, and ending depth value. All independent datasets corresponding to the sub-tables together constitute the original logging dataset, which serves as the sole original input for subsequent automatic stratification processing, ensuring that the original entry information of each geological feature can be fully traced during the subsequent stratification process.

[0172] Automatic layering module:

[0173] The automatic stratification module is the core unit of the system to realize the automation of geological stratification. Based on the code depth data collected from multiple sub-tables, it automatically identifies geological feature change nodes and completes the geological stratification, completely replacing manual stratification operations and eliminating problems such as inconsistent standards, low efficiency, and boundary judgment deviation caused by manual stratification.

[0174] Raw dataset aggregation and depth interval unit integration: Aggregate the independent datasets corresponding to all sub-tables, extract the standard catalog codes of all records in each dataset, as well as the start and end depth values ​​of the corresponding records, and combine each code and its corresponding depth interval into an independent depth interval basic unit. The depth interval basic units of all sub-tables together constitute the raw dataset for automatic stratification processing. The raw dataset fully retains the source sub-table information and code attribute information of each catalog record, ensuring that the stratification process is traceable to the original collected data, with no information loss or tampering.

[0175] Depth Node Set Construction and Minimum Depth Micro-interval Generation: From all basic units of depth intervals in the original dataset, extract all starting and ending depth values. All extracted depth values ​​together constitute a depth node set. Sort all depth values ​​in the depth node set in ascending order, and remove duplicate depth values ​​to ensure that there are no duplicate values ​​in the sorted depth node set, and that all depth values ​​are arranged in ascending order. Using two adjacent depth values ​​after sorting as upper and lower boundaries, generate a series of continuous minimum indivisible depth micro-intervals. Each micro-interval does not contain any nodes with changes in geological features and is the smallest unit that cannot be further divided in the depth direction.

[0176] Micro-interval traversal and valid code filtering for sub-tables: Each generated minimum indivisible depth micro-interval is traversed in ascending order of depth. For the currently traversed depth micro-interval, the standard catalog code that completely covers the depth interval of the current micro-interval is retrieved from the independent dataset of each sub-table. If multiple codes in a sub-table cover the current micro-interval, a unique valid code is selected based on preset priority rules or geological logic rules. This ensures that each sub-table corresponds to at most one valid standard catalog code in each depth micro-interval, avoiding multiple conflicting feature descriptions of the same geological element at the same depth location.

[0177] Micro-interval code combination construction and adjacent interval merging: For each depth micro-interval, all valid standard catalog codes selected from the sub-tables within that micro-interval are summarized to form a code combination uniquely corresponding to that micro-interval; the code combination completely contains the valid codes corresponding to all geological elements within the current micro-interval, fully reflecting all geological characteristics at that depth location; after completing the code combination construction of all micro-intervals, adjacent depth micro-intervals with identical code combinations are merged in ascending order of depth, and the resulting continuous depth intervals are the preliminary geological stratification segments; during the merging process, the depth continuity rule is strictly followed, and merging is only performed on adjacent micro-intervals, while non-adjacent micro-intervals are not merged, ensuring that the merged geological stratification segments remain continuous in the depth direction without depth breaks;

[0178] Geological stratification results determination and final generation of stratification sequence: For each preliminary geological stratum generated after merging, the minimum starting depth value of all micro-intervals within the stratum is determined as the top boundary depth of the stratum, and the maximum ending depth value of all micro-intervals within the stratum is determined as the bottom boundary depth of the stratum; at the same time, the unified code combination within the stratum is determined as the code set corresponding to the stratum; all geological strata are arranged in ascending order of depth, ultimately forming a stratification sequence composed of multiple continuous and mutually exclusive geological stratification results; the stratification sequence must completely cover the entire depth range of the logging operation, with the top and bottom depths of adjacent strata completely connected, with no depth overlap areas and no depth omission intervals;

[0179] Description text auto-generation module:

[0180] The automatic description text generation module is the core component of the system to achieve standardized output of geological logging results. For the generated geological stratification results, it automatically converts the code combination into standardized description text that conforms to geological professional standards, eliminating problems such as inconsistent terminology, non-standard expression, and logical inconsistency caused by manual description, and greatly improving the efficiency and professional compliance of geological logging results.

[0181] Layered code set extraction and raw data aggregation: For each geological stratification result, the top and bottom boundary depths of the stratum are first determined. Then, from the independent datasets of each sub-table, all standard logging codes that completely cover the stratification range in depth intervals are extracted, along with the complete depth interval information of the corresponding codes. All extracted standard logging codes are integrated to form a raw code set that uniquely corresponds to the geological stratification result. The raw code set completely preserves the hierarchical structure information and source sub-table information corresponding to the codes, without any omissions or tampering, providing complete basic data support for subsequent classification, grouping, and semantic transformation.

[0182] Code classification and grouping, and determination of the logical order of description: Based on the hierarchical structure and geological semantic definition of standard logging codes, all codes in the original code set are classified and grouped. First, according to the primary geological element category corresponding to the code, the codes are divided into two categories: main geological feature codes and auxiliary description codes. The main geological feature codes correspond to the geological element categories that determine the core attributes of the layer, and the auxiliary description codes correspond to the geological element categories that supplement the description of additional features of the layer. Then, according to the preset geological description priority rules, the grouped codes are sorted in descending order. The priority rules completely match the description order of the general specifications in the geological logging industry, and finally the logical order of description for the layer code combination is determined.

[0183] Description template matching and adaptation rule invocation: Based on the sorted code combinations, a description template that completely corresponds to the code combination type is matched from the preset description template library; the templates in the description template library contain fixed text parts and fillable variable parts, and the template types fully cover all common geological logging description scenarios such as single code description, multi-code combination description, and code superposition description; the template matching process follows the principle of maximum fit, giving priority to matching templates that are completely compatible with the code combination in terms of code quantity, category composition, and hierarchical structure, ensuring that the description framework of the template fully complies with the expression requirements of geological professional specifications;

[0184] Code semantic conversion and template content filling: The code semantic mapping rule library is called to convert each standard catalog code in the sorted code combination into the corresponding geological semantic name or standardized descriptive phrase; then, according to the variable mapping relationship in the matched description template, the converted geological semantic content is filled into the corresponding variable position of the description template according to the preset description logic order, completing the full filling operation of the template content and generating the preliminary description text corresponding to the geological stratification result.

[0185] Compliance verification and final generation of standardized description text: The generated preliminary description text undergoes a dual verification process. The first verification is grammatical fluency, checking whether the sentence structure and word order logic conform to modern Chinese expression standards, avoiding issues such as incoherent sentences and incomplete components. The second verification is geological logic consistency, checking whether the text content conforms to geological professional standards, whether the semantic content after code conversion fully matches the code combination of geological stratification, and whether the description order of different categories of geological features conforms to industry-standard rules. After verification, the text is adjusted in word order, modifiers are added, or similar descriptions are merged according to geological standards to eliminate redundant expressions, ultimately generating a standardized description text that conforms to geological professional standards.

[0186] Results-related storage module:

[0187] The results association storage module is the core carrier for the system to realize the full life cycle management of the logging results. It links and stores the geological stratification results, standardized descriptive text and original logging data in the whole link, and builds a complete geological logging results system that can be traced in both directions and output in a standardized manner, so as to ensure the data integrity, logical traceability and application universality of the logging results.

[0188] Layered result data table construction and unique identifier generation: For each geological stratification result, a globally unique stratification identifier is generated. The stratification identifier adopts a fixed-length coding rule that balances uniqueness and identifiability, ensuring that each geological stratification result corresponds to a unique identifier without duplication or omission. The top boundary depth, bottom boundary depth, corresponding code set, and standardized descriptive text of the stratification are recorded simultaneously. All information is structured and integrated according to the stratification identifier to construct a stratified result data table. The stratified result data table uses the stratification identifier as the primary key and all stratification-related attribute information as associated fields, supporting quick retrieval of full information of the corresponding stratification by stratification identifier.

[0189] Construction of the correlation mapping table: For each geological stratification result, identify and record each original standard logging code record that constitutes the stratification result, along with its corresponding sub-table name, record row number, and unique record identifier; bind the stratification identifier to the original record identifier one-to-one, fully recording the geological stratification result formed by each original logging record, as well as all original logging records that each geological stratification result depends on, forming a correlation mapping table; the correlation mapping table fully covers the relationship between all stratification results and all original logging records, with no correlation gaps, ensuring that each stratification attribute can be traced back to the corresponding original acquisition data;

[0190] Multi-table join storage and data link construction: The constructed hierarchical result data table, join mapping table, and original sub-table datasets are stored uniformly in the same database or data file; a stable data link is established between the hierarchical result data table, join mapping table, and original sub-table datasets through database foreign keys or data pointers; the data link uses the hierarchical identifier and the original record identifier as the association anchor point to ensure that the relationship between each data table can be stably identified and called by the system, and the association will not be broken due to data migration or changes in storage environment; the original attributes of all data are completely preserved during the storage process, with no data tampering or information loss;

[0191] Configuration and Functionality of Bidirectional Traceability Query Interface: Based on established relationships and data links, a standardized bidirectional traceability query interface is developed and configured. The query interface supports two core traceability query operations: the first is reverse traceability query, which allows querying from any geological stratum result back to all original logging data records it depends on, fully restoring the original data source and formation logic of the stratum result; the second is forward traceability query, which allows querying from any original logging data record forward to all geological stratum results to which it belongs, clarifying the application scenario and scope of influence of the original data in the final logging results. The query interface adopts standardized calling rules, supporting compatibility and adaptation with various geological exploration data management systems, and can be called without additional adaptation development.

[0192] Standardized output and document generation of logging results: Pre-set geological logging result output format templates are loaded, with template formats fully compliant with national geological exploration standards and industry archiving requirements. Based on the output format templates, geological stratification results, corresponding standardized descriptive text, and original logging data corresponding to traceability query needs are integrated according to a preset structure and order, automatically generating standardized geological logging result documents or structured data files. Output supports multiple common formats to meet the needs of archiving, reporting, submission, and reuse in different scenarios, achieving standardized output of geological logging results. During the output process, output content modules can be customized according to requirements, flexibly adapting to different application scenarios.

[0193] Although embodiments of the invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the appended claims and their equivalents.

Claims

1. A standardized code cataloging and management method, characterized in that: Includes the following steps: Step S1: Establish a standard logging code system: Construct a standard logging code library covering multiple geological elements. Each standard logging code has a unique coding identifier, a preset geological semantic definition, and data structure constraints. Step S2: Sub-table data acquisition: Collect logging data of different geological elements through multiple independent sub-tables. Each sub-table corresponds to a type of geological element. Users only need to input the standard logging code and its corresponding depth interval information in each sub-table, without having to pre-divide geological strata. Step S3: Automatic stratification: Based on the depth range of the standard catalog codes in each sub-table, automatically identify the start and end points of each code in the depth direction. By comparing the start and end points of codes in multiple sub-tables, determine the geological feature change nodes, and divide the depth range into continuous and mutually exclusive geological stratification results according to the change nodes. Specifically, this includes: Step S3-1: Collect the standard catalog codes of all records in each sub-table and their corresponding starting and ending depths to form the original dataset with depth intervals as the basic unit; Step S3-2: Extract all starting depth values ​​and ending depth values ​​from all original datasets to form a set of depth nodes. Sort and deduplicate the depth values ​​in this set to generate a series of smallest indivisible depth micro-intervals defined by adjacent depth values. Step S3-3: Traverse each depth micro-interval and retrieve the standard catalog code covering the micro-interval range in each sub-table. If multiple codes in a sub-table cover the current micro-interval at the same depth interval, select a valid code from them according to the preset priority rules or geological logic to ensure that each sub-table corresponds to at most one valid standard catalog code in each micro-interval. Step S3-4: Summarize the valid standard catalog codes selected from all sub-tables within the same depth micro-interval to form the code combination corresponding to the micro-interval, and merge adjacent micro-intervals with the same code combination in depth order to generate preliminary geological stratification segments; Step S3-5: Determine the top and bottom depths of each merged segment as the minimum starting depth and maximum ending depth of all micro-intervals within that segment, and use the code combinations that appear within that segment as the code set of that segment, ultimately forming a layered sequence composed of multiple continuous and mutually exclusive geological layering results; Step S4: Automatic generation of description text: For each geological stratification result, summarize all standard cataloging code combinations that appear in that stratum, call the preset description template and code-semantic mapping rules, and convert the code combinations into standardized description text that conforms to geological specifications; Step S5: Results Association and Storage: The generated geological stratification results and standardized descriptive text are associated and stored with the original logging data to form traceable and output geological logging results.

2. The standardized code cataloging and management method according to claim 1, characterized in that: The establishment of the standard catalog code system in step S1 specifically includes: Step S1-1: Based on the classification system of geological elements, determine multiple primary geological element categories and assign a category code to each primary category; Step S1-2: Under each primary category, refine the secondary and tertiary subcategories according to the hierarchical relationship of geological features, and assign corresponding hierarchical codes to each subcategory; Step S1-3: Combine the category code and the hierarchical code in a preset order to form a standard catalog code with a hierarchical structure, so that the code itself can reflect the classification path of geological features; Steps S1-4: Define geological semantics for each standard catalog code, including the name, definition, and descriptive text template of geological features, and establish a mapping relationship between codes and semantics; Step S1-5: Set data structure constraints for each standard catalog code, including data format, allowed values, units, and geological logical association rules between this code and other standard catalog codes in the standard catalog code library; the geological logical association rules include mandatory co-occurrence rules, mutual exclusion rules, and hierarchical dependency rules; Steps S1-6: Store all the above codes and their attributes in the database to form a standard catalog code library.

3. The standardized code cataloging and management method according to claim 1, characterized in that: The sub-table data collection in step S2 specifically includes the following sub-steps: Step S2-1: Based on the primary geological element categories in the standard cataloging code library, construct multiple independent data acquisition sub-tables, each sub-table corresponding to a primary category, and pre-set a list of standard cataloging code options allowed under that category in the sub-table; Step S2-2: Display all sub-tables in parallel on the user interface. Each sub-table is presented in a table format that can dynamically add or delete rows. The table columns include at least the start depth, end depth, and code selection bar. Step S2-3: The user adds records row by row in each sub-table, selects the standard catalog code corresponding to the current depth interval from the preset code options through the code selection bar, and manually enters the start and end depth values ​​of the interval. The same code is allowed to correspond to multiple non-contiguous depth intervals in the same sub-table. Step S2-4: During the data acquisition process, the system performs real-time logical verification on the depth ranges input in each sub-table, including checking whether there is overlap between the depth ranges of each row in the same sub-table, whether the depth value meets the requirement that the starting value is less than the ending value, and prompting the user to correct the error when an error is detected. Step S2-5: After the data collection is completed, the depth range and standard cataloging code data entered in each sub-table are stored as independent datasets. Each dataset records the distribution of all codes under the geological element category along the depth direction, which serves as the original input for subsequent automatic stratification processing.

4. The standardized code cataloging and management method according to claim 1, characterized in that: The automatic generation of descriptive text in step S4 specifically includes the following sub-steps: Step S4-1: For each geological stratification result, extract all standard logging codes and their corresponding depth intervals that appear in that stratum to form the original code set for that stratum; Step S4-2: Based on the hierarchical structure and geological semantic definition of the standard cataloging code, classify and group the codes in the original code set, identify the main geological feature codes and auxiliary description codes, and sort the codes according to the preset priority rules to determine the logical order of description; Step S4-3: Based on the sorted code combinations, match the description template corresponding to the code combination type from the preset description template library. The description template contains a fixed text part and a fillable variable part, and the template type covers a variety of geological description scenarios, including single code description, multi-code combination description, and code superposition description. Step S4-4: Call the code-semantic mapping rules to convert each standard catalog code into a corresponding geological semantic name or descriptive phrase, and fill the converted semantic content into the corresponding variable positions in the description template according to the variable mapping relationship in the template to form a preliminary description text; Step S4-5: Perform grammatical verification and geological logic consistency checks on the preliminary description text, adjust the word order, add modifiers, or merge similar descriptions according to geological specifications, and generate a standardized description text that conforms to geological professional standards.

5. The standardized code cataloging and management method according to claim 1, characterized in that: The result association storage in step S5 specifically includes the following sub-steps: Step S5-1: Generate a unique layer identifier for each geological layering result, and record the top and bottom depths, code combination, and standardized descriptive text of the layer to construct a layering result data table; Step S5-2: Establish a traceability relationship between the stratification results and the original logging data: For each geological stratification result, identify and record the sub-table name, record row number or record identifier of each original standard logging code record that constitutes the stratification result, and form a correlation mapping table; Step S5-3: Store the hierarchical result data table, the association mapping table, and the original sub-table dataset in the same database or data file, and establish data links through foreign keys or pointers; Step S5-4: Based on the stored association, provide a traceability query interface to support reverse querying from any geological stratification result to all original catalog data records it depends on, and forward querying from any original record to its corresponding geological stratification result; Step S5-5: Based on the preset output format template, the geological stratification results, their standardized descriptive text, and the original logging data corresponding to the traceability query requirements are automatically generated into a geological logging result document or data file, thus achieving the output capability of the results.

6. A standardized code cataloging and management system for executing the method according to any one of claims 1-5, characterized in that: The system includes: The standard cataloging code system construction module is configured to establish a standard cataloging code library covering multiple geological elements based on a classification system of geological elements. Each standard cataloging code has a unique coding identifier, a preset geological semantic definition, and data structure constraints. The sub-table data acquisition module is configured to collect cataloging data of different geological elements through multiple independent sub-tables. Each sub-table corresponds to a type of geological element. Users only need to input the standard cataloging code and its corresponding depth range information in each sub-table, and perform logical verification on the input depth range. After the acquisition is completed, the data of each sub-table is stored as an independent dataset. The automatic stratification processing module is configured to collect the standard catalog codes and their depth intervals from each sub-table, extract all depth nodes and generate the minimum depth micro-interval, traverse each micro-interval to determine the valid codes of each sub-table within that micro-interval, form a micro-interval code combination, and then merge adjacent micro-intervals with consecutive and identical code combinations to generate a stratification sequence consisting of multiple consecutive and mutually exclusive geological stratification results. The automatic description text generation module is configured to extract all standard catalog codes appearing in each geological stratum result, sort and group them according to the code hierarchy and preset rules, match the corresponding description template, and call the code-semantic mapping rules to convert the code into geological semantic phrases to fill the template, generating standardized description text that conforms to geological specifications. The results association storage module is configured to generate a unique layer identifier for each geological layer result and record its top and bottom depths, code combinations and standardized descriptive text, establish a traceability association mapping between the layer results and the original logging data, associate and store the layer results, association mapping and the original sub-table dataset, and provide a traceability query interface and results output function.

Images