Online template drilling histogram generation method based on cloud database

Abstract

The invention relates to the technical field of geotechnical investigation, in particular to an online template borehole histogram generation method based on a cloud database, and the method comprises the steps: obtaining a cloud environment and drawing basic data, inputting the drawing basic data in the cloud environment, and employing the cloud environment as an operation platform; defining template contents of the drilling histogram of a set type, and creating a drilling histogram template; creating a drawing engine comprising different drawing interfaces; on the operation platform, calling a drawing interface based on the drilling histogram template, calculating basic information of the drilling histogram according to the basic data, and generating the histogram through a drawing engine; and generating a drawing file stream according to a set format based on the generated histogram. According to the method, dependence on specific software in the drilling histogram generation process is avoided, cross-platform consistency of data and achievements is achieved, the working efficiency and the cooperative ability of different teams are improved, and the method can be widely applied to the field of geotechnical engineering investigation in industrial and civil construction, subways, municipal administration, ocean and other industries.

Description

Technical Field

[0001] The present invention relates to the field of geotechnical exploration technology, and in particular to an online templated borehole histogram generation method based on a cloud database. Background Art

[0002] Borehole histograms are fundamental drawings in geotechnical engineering surveys and are widely used in engineering geology, hydrogeology, geotechnical exploration, and petroleum geology. They depict various geological information about strata in a tabular format, with both graphic and textual information, and serve as a crucial basis for engineering design, geological analysis, and resource development. Traditional manual drawing of borehole histograms is not only inefficient and inaccurate, but also prone to errors during data entry and graph creation, making it difficult to meet the efficiency and precision requirements of modern engineering design and geological analysis. With the acceleration of urbanization and the advancement of infrastructure construction, the demand for borehole histograms in engineering geology and geotechnical surveys is growing. This is particularly true in engineering fields such as civil engineering, subways, municipal engineering, and marine engineering, as well as in the prevention and control of geological hazards such as land subsidence and landslides. As a crucial basis for engineering design, geological analysis, and resource development, the rapid and accurate generation of borehole histograms is crucial.

[0003] In recent years, the drilling histogram generation system based on Web Service, WebGIS and BIM technologies has gradually emerged, providing new ideas for solving the shortcomings of traditional methods. For example, in 2019, Song Shang published a borehole histogram drawing software development technology based on NET API (C#) in the journal "Urban Roads, Bridges and Flood Control". By combining AutoCAD and Excel, the convenient input and batch drawing functions of borehole histograms were realized, which greatly improved the drawing efficiency and quality of designers; in 2010, Mou Naixia, Liang Chunli, Zhang Lingxian and others published a WebService-based borehole histogram network mapping system research in the journal "Metal Mines". Based on Web Service technology, a four-layer remote mapping architecture was designed to make the generation of borehole histograms more flexible and efficient; in 2016, Wang Youlin, Wang Jianming, Cheng Xinxing and others published a cross-platform borehole histogram automatic generation method in the journal "Geotechnical Engineering Technology". By designing a general borehole data model and an automatic filling algorithm for lithologic patterns, it realized the automatic generation of cross-platform borehole histograms, providing technical support for data sharing and full utilization.

[0004] However, existing research still has some shortcomings. On the one hand, traditional methods are highly dependent on specific software (such as AutoCAD and GIS components), resulting in a deep binding of data and software, poor cross-platform compatibility, and inefficient manual adjustments. On the other hand, existing methods still need to be improved in terms of multi-scenario reuse and data consistency. Summary of the Invention

[0005] In order to solve the above technical problems, the purpose of the present invention is to provide an online template-based drilling histogram generation method based on a cloud database. The technical solutions adopted are as follows: In a first aspect, the present invention provides an online templated drilling histogram generation method based on a cloud database, comprising the following steps: Acquire a cloud environment and basic data for drawing output, input the basic data for drawing output into the cloud environment, and use the cloud environment as an operating platform; Define the template content of the drill bar chart of the set type and create a drill bar chart template; Creating a drawing engine, wherein the drawing engine includes different drawing interfaces; On the operating platform, based on the drilling histogram template, a drawing interface is called, basic information of the drilling histogram is calculated according to the basic data, and a histogram is generated through a drawing engine; Based on the generated histogram, a drawing file stream is generated according to the set format.

[0006] In combination with the first aspect above, in some possible implementations, the basic data at least includes basic drilling information, stratigraphic layer information, and a lithologic symbol library.

[0007] In combination with the first aspect above, in some possible implementations, the basic drilling information includes at least: the drilling number, the drilling location coordinates, the stratum information revealed by the drilling, the drilling depth, the hole mouth elevation, the drilling date and the hole completion date, and the groundwater level; the stratigraphic stratification information includes at least: the layer number, the layer top depth, the layer bottom depth, the lithology name, the lithology description and the geological age.

[0008] In combination with the first aspect above, in some possible implementations, the template content of the set type of drilling bar chart includes at least the map size, scale, text style, text size, header content, footer content, header style, and footer style.

[0009] In combination with the foregoing first aspect, in some possible implementations, creating a drawing engine includes: creating at least two different types of drawing engines.

[0010] In conjunction with the foregoing first aspect, in some possible implementations, creating at least two different types of drawing engines includes: Build DXF drawing engine based on NetDXF library; Build an SVG drawing engine based on the SVG library; Define a set of standardized drawing interfaces for DXF drawing engine and SVG drawing engine; For specific types not supported by the SVG format, compatibility support is achieved by converting them into paths.

[0011] In combination with the above first aspect, in some possible implementations, the standardized drawing interface includes at least polyline drawing, text rendering, and pattern fill drawing interfaces.

[0012] In combination with the first aspect above, in some possible implementations, the method further includes: verifying whether the bar chart generated by the drawing engine meets industry standards and project requirements, and if not, adjusting the generated bar chart.

[0013] In conjunction with the first aspect above, in some possible implementations, calculating basic information of a drill histogram based on the basic data and generating the histogram using a drawing engine includes: Extract basic data from the database; Initialize the drawing engine and load the necessary symbol libraries and style sheets; The total height of the histogram is calculated based on the total depth of the borehole and the preset scale, and then the specific position and height of each layer in the histogram are determined based on the top and bottom depth data of each layer; Combine the lithology name and geological age information of the stratum and select the matching fill color and style from the lithology symbol library; Call the polyline drawing function of the drawing engine to draw stratum boundaries and structures, layer lines and auxiliary lines, add stratum information, drill hole names and depth scales, and set the font, size and color; Use corresponding filling patterns and colors to implement pattern filling for each layer of stratum.

[0014] In combination with the first aspect above, in some possible implementations, generating the drawing file stream according to the set format includes: generating the drawing file stream according to DXF and SVG formats.

[0015] In a second aspect, the present invention further provides an online template-based drilling histogram generation device based on a cloud database, the device comprising: A data acquisition module is used to obtain a cloud environment and basic data for drawing output, input the basic data for drawing output into the cloud environment, and use the cloud environment as an operating platform; A template building module is used to define the template content of a set type of drilling histogram and create a drilling histogram template; An engine creation module, used to create a drawing engine, wherein the drawing engine includes different drawing interfaces; A histogram generation module is used to call a drawing interface on the operating platform based on the drilling histogram template, calculate basic information of the drilling histogram according to the basic data, and generate a histogram through a drawing engine; The drawing file stream generation module is used to generate a drawing file stream according to a set format based on the generated histogram.

[0016] In a third aspect, the present invention further provides an online template-based drill histogram generation system based on a cloud database, comprising a memory and a processor. The memory is configured to store executable computer program code, and the processor is configured to retrieve and execute the executable computer program code from the memory, causing the system to perform the method of the first aspect or any possible implementation of the first aspect.

[0017] In a fourth aspect, the present invention further provides a computer program product, comprising: a computer program code, which, when executed on a computer, enables the computer to execute the method in the above-mentioned first aspect or any possible implementation of the first aspect.

[0018] In a fifth aspect, the present invention also provides a computer-readable storage medium, which stores a computer program code. When the computer program code runs on a computer, the computer executes the method in the above-mentioned first aspect or any possible implementation of the first aspect.

[0019] The present invention has the following beneficial effects: the present invention obtains basic drawing data in a cloud environment and uses the cloud environment as an operating platform. By creating a drill bar chart template and a drawing engine, on the operating platform, based on the drill bar chart template, the drawing interface is called, the basic information of the drill bar chart is calculated based on the basic data, and the bar chart is accurately generated based on the drawing engine; finally, based on the generated bar chart, a drawing file stream is generated according to the set format. On the one hand, the present invention solves the problem of high dependence on specific software (such as AutoCAD, GIS components) in the traditional drill bar chart generation process, avoiding the defects of poor cross-platform compatibility and low manual adjustment efficiency caused by deep binding of data and software; on the other hand, it realizes one-time configuration and multiple-scenario reuse, ensuring the consistency of data and results across different cross-platforms, and providing standardized digital results for engineering design and geotechnical analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions and advantages of the embodiments of the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the prior art descriptions. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0021] Figure 1 This is a flowchart of a method for generating an online templated drilling histogram based on a cloud database according to an embodiment of the present invention; Figure 2 This is a structural schematic diagram of an online templated drilling histogram generation device based on a cloud database according to an embodiment of the present invention. DETAILED DESCRIPTION

[0022] In order to clearly illustrate the technical features of this solution, the present invention is described in detail below through specific implementation methods in conjunction with the accompanying drawings.

[0023] Embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as limited to the embodiments described herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are for illustrative purposes only and are not intended to limit the scope of protection of the present invention.

[0024] It should be understood that the various steps described in the method embodiments of the present invention may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present invention is not limited in this respect.

[0025] As used herein, the term "including" and its variations are open-ended, i.e., "including but not limited to." The term "based on" means "based, at least in part, on." The term "one embodiment" means "at least one embodiment," the term "another embodiment" means "at least one additional embodiment," and the term "some embodiments" means "at least some embodiments." Other terms are defined in the following description.

[0026] It should be noted that the concepts of "first" and "second" mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0027] Although operations or steps are described in a particular order in the drawings in the embodiments of the present invention, this should not be understood as requiring that these operations or steps be performed in the particular order shown or in a serial order, or that all of the operations or steps shown be performed to obtain a desired result. In the embodiments of the present invention, these operations or steps may be performed serially; they may also be performed in parallel; or a portion of these operations or steps may be performed.

[0028] At the same time, it is understood that the data involved in the technical solutions of the present invention (including but not limited to the data itself, the acquisition or use of the data) must comply with the requirements of relevant laws, regulations and relevant provisions. Unless otherwise defined, all technical and scientific terms used in this invention have the same meanings as those commonly understood by those skilled in the art to which this invention belongs, and all parameters or indicators in the formulas involved in this invention are normalized values ​​to eliminate dimension effects.

[0029] In order to solve the problems of low efficiency, poor accuracy, high dependence on specific software and poor cross-platform compatibility in traditional drilling histogram generation methods, an embodiment of the present invention provides an online templated drilling histogram generation method based on a cloud database. This method uses standardized data management and template customization technology in a cloud environment to get rid of the dependence on specific software and achieve cross-platform consistency of data and results. At the same time, through one-time configuration and multi-scenario reuse, it significantly improves the work efficiency and collaboration capabilities between different departments and teams.

[0030] An online templated drilling histogram generation method based on a cloud database provided by an embodiment of the present invention will be described in detail below with reference to the accompanying drawings.

[0031] Figure 1 FIG. 1 shows a basic flow chart of a method for generating an online templated drilling histogram based on a cloud database provided by an embodiment of the present invention. Figure 1 As shown, the method specifically includes the following steps: Step S100: Obtain the cloud environment and basic data for drawing output, enter the basic data for drawing output in the cloud environment, and use the cloud environment as an operating platform.

[0032] Build and configure a cloud-based environment to input basic data for mapping, including basic drilling information, stratigraphic layer information, and lithologic symbol libraries for a specific survey project. Use the cloud-based environment as the platform for mapping, leveraging its advantages of centralized data management, multi-user concurrent access, and cross-platform compatibility.

[0033] In a specific example, the basic drilling information entered in the cloud environment includes but is not limited to: drilling number, drilling location coordinates, stratum information revealed by the drilling, drilling depth, hole mouth elevation, drilling date and final date, groundwater level and other data required for the drilling histogram. This information provides basic data support for subsequent drawing, ensuring that the generated drilling histogram can accurately reflect the actual geological conditions of the drilling.

[0034] Stratigraphic information entered in the cloud environment includes, but is not limited to, key elements such as layer number, layer top depth, layer bottom depth, lithology name, lithology description, and geological age. Stratigraphic information is the core data for drillhole histograms. Once entered into the database, this information provides layered data to the drawing engine, ensuring that the generated histograms clearly present the stratigraphic distribution.

[0035] Preparation for entering a lithologic symbol library into a cloud environment includes designing symbols according to geological industry standards, storing them in the cloud in common formats (such as PAT), and managing them in a categorized manner. For example, pattern symbols use PAT, which contains a series of pattern definitions (pattern name, pattern type, and pattern data). Linking symbols to lithologic names in the database ensures automatic symbol matching during drawing and adherence to industry standards. Finally, data verification and calibration are performed, including integrity checks, accuracy verification, and format standardization to ensure data quality and the accuracy of subsequent drawing results.

[0036] Step S200: defining the template content of a set type of drilling histogram and creating a drilling histogram template.

[0037] Define the template content for a specific type of drill histogram, including the drawing area, scale, text style, text size, header content, footer content, header style, and footer style. Based on the template content, create a corresponding drill histogram template based on the specific needs of the project. This template can be applied not only to this project but also to other similar projects. In addition, you can flexibly create other templates to meet the needs of different projects.

[0038] In a specific example, the specific process of creating a drill hole bar chart template includes: defining the drawing size and page layout to accommodate different printing and screen display requirements; setting the scale value, which is determined based on the actual drilling depth and the expected drawing height, and allowing users to adjust the scale as needed; selecting the specified text style and size to ensure that the text in the diagram is clear and legible; editing the header and footer content to include key information such as the project name and drill hole number, and designing its style to enhance the professionalism and readability of the chart. The styles of the header and footer are shown in Tables 1 and 2.

[0039] Table 1 Header style of drill bar chart

[0040] Table 2 Footer style of drill bar chart

[0041] Step S300: creating a drawing engine, which includes different drawing interfaces.

[0042] Create multiple drawing engines, each of which implements standardized interfaces such as polyline drawing, text rendering, and pattern filling.

[0043] In a specific example, creating a drawing engine involves the following key steps: ① Building a DXF drawing engine based on the NetDXF library, an open-source library for reading and writing DXF files, provides a rich API for manipulating DXF graphic elements. This library enables functions such as polyline drawing, text rendering, and pattern fills, providing robust support for generating DXF-formatted drill bar charts. ② Building an SVG drawing engine based on the SVG library, a library for creating and manipulating vector graphics with excellent cross-platform compatibility and scalability. Implementing similar drawing functions using the SVG library allows for generating SVG-formatted drill bar charts, meeting the graphic format requirements of various application scenarios. ③ To ensure functional consistency between the two drawing engines, a set of standardized interfaces is defined, including those for polyline drawing, text rendering, and pattern fills. This ensures that these functions can be called in the same manner regardless of the engine used, generating graphics that meet the requirements. ④ For specific types not supported by the SVG format (such as glyphs and fills), these elements are converted to paths for compatibility. Paths are a common graphical representation in SVG that can represent a variety of complex shapes. In this way, it is ensured that the SVG drawing engine can fully render all elements of the drill histogram and achieve graphic expression comparable to that of the DXF drawing engine.

[0044] Step S400: On the running platform, based on the drilling histogram template, the drawing interface is called, basic information of the drilling histogram is calculated according to basic data, and the histogram is generated through the drawing engine.

[0045] Using a standardized interface compatible with the drawing engine, the layout of various elements in the drill histogram is calculated based on pre-prepared basic data. The created drawing engine generates clear and intuitive histograms that meet industry standards and project requirements.

[0046] In a specific example, the specific steps for generating a histogram include: calling the drawing interface. Extracting basic data from the database, including basic borehole information, stratigraphic layer information, and a lithologic symbol library. Then, initializing the drawing engine and loading the necessary symbol libraries and style sheets for drawing. Calculating the total height of the histogram based on the total borehole depth and the preset scale. Then, determining the specific position and height of each stratum within the histogram based on the top and bottom depth data of each stratum. Combining the stratum's lithologic name and geological age information, selecting a matching fill color and style from the lithologic symbol library. Then, calling the drawing engine's polyline drawing function to draw stratum boundaries and structures, layer lines, and auxiliary lines. At the same time, adding text annotations such as stratum information, borehole name, and depth scale, and setting the font, font size, and color. Finally, applying the corresponding fill pattern and color to each stratum.

[0047] Step S500: Based on the generated histogram, a drawing file stream is generated according to a set format.

[0048] Generate the file stream corresponding to the vector diagram. After selecting the DXF or SVG format, start the output function of the drawing engine, convert each element in the bar chart into instructions and data structures of the corresponding format, optimize the standardization and readability of the file stream, integrate all data to form a complete file stream, and output it as an independent file to the specified location. Finally, verify the integrity of the file to ensure it can be displayed correctly.

[0049] In a specific example, based on the generated bar chart, the steps for generating a drawing file stream in a set format include: selecting DXF or SVG format to generate the drawing file stream according to user needs and application scenarios. Calling the output function of the drawing engine to start the preparation work for file stream generation. Traversing the lines, texts, fill patterns and other graphic elements in the bar chart one by one, and converting them into instructions and data structures corresponding to the selected format. Optimizing the generated file stream to ensure its structure is standardized and highly readable. Integrating all converted drawing data to form a complete file stream, and outputting it as an independent drawing file, saving it to a specified location. Finally, verifying the integrity of the file to ensure that the drawing file can be opened and displayed correctly in the relevant software.

[0050] At this point, the complete process from data preparation to final file generation is realized through the above steps S100-S500, ensuring that the generated drill histogram meets industry standards and project requirements.

[0051] The above-mentioned online templated drill histogram generation method based on cloud database provided by the embodiment of the present invention, on the one hand, solves the problem of high dependence on specific software (such as AutoCAD, GIS components) in the traditional drill histogram generation process, and avoids the defects of poor cross-platform compatibility and low manual adjustment efficiency caused by deep binding of data and software; on the other hand, it realizes one-time configuration and multiple-scenario reuse, ensuring the consistency of data and results across different cross-platforms, and can be widely used in geotechnical engineering survey fields in industries such as civil engineering, subway, municipal administration, and ocean, providing standardized digital results support for engineering design and geotechnical analysis.

[0052] Based on the same inventive concept, the embodiment of the present invention also provides an online templated drilling histogram generation device based on a cloud database, such as Figure 2 As shown, the device includes: A data acquisition module is used to obtain a cloud environment and basic data for drawing output, input the basic data for drawing output into the cloud environment, and use the cloud environment as an operating platform; A template building module is used to define the template content of a set type of drilling histogram and create a drilling histogram template; An engine creation module, used to create a drawing engine, wherein the drawing engine includes different drawing interfaces; A histogram generation module is used to call a drawing interface on the operating platform based on the drilling histogram template, calculate basic information of the drilling histogram according to the basic data, and generate a histogram through a drawing engine; The drawing file stream generation module is used to generate a drawing file stream according to a set format based on the generated histogram.

[0053] It should be noted that the device provided in the above embodiment is only illustrated by the division of the above functional modules. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the computer device can be divided into different functional modules to complete all or part of the functions described above.

[0054] Based on the same inventive concept, an embodiment of the present invention also provides an online templated drill bar chart generation system based on a cloud database, the system comprising: a memory, a processor, and a computer program code stored in the memory and running on the processor, wherein when the processor executes the computer program code, the system can execute any one of the online templated drill bar chart generation methods based on a cloud database introduced above.

[0055] In embodiments of the present invention, the system can be divided into functional modules based on the above-described method examples. For example, these modules can correspond to individual functional modules, or two or more functions can be integrated into a single processing module. The integrated modules can be implemented in hardware. It should be noted that the module division in this embodiment is illustrative and represents only a logical functional division. In actual implementation, other division methods may be used.

[0056] Based on the same inventive concept, an embodiment of the present invention also provides a computer program product, which includes: computer program code, which, when running on a computer, enables the computer to execute any one of the online templated drilling histogram generation methods based on a cloud database introduced above.

[0057] Based on the same inventive concept, an embodiment of the present invention also provides a computer-readable storage medium, which stores computer program code. When the computer program code runs on a computer, the computer executes any one of the online templated drilling histogram generation methods based on a cloud database introduced above.

[0058] It should be noted that the above-described embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. These modifications or replacements do not deviate the essence of the corresponding technical solutions from the scope of the technical solutions of the various embodiments of the present invention, and should all be included in the protection scope of the present invention.

Claims

1. An online templated drilling histogram generation method based on a cloud database, characterized in that: The following steps are involved: Acquire a cloud environment and basic data for drawing output, input the basic data for drawing output into the cloud environment, and use the cloud environment as an operating platform; Define the template content of the drill bar chart of the set type and create a drill bar chart template; Creating a drawing engine, wherein the drawing engine includes different drawing interfaces; On the operating platform, based on the drilling histogram template, a drawing interface is called, basic information of the drilling histogram is calculated according to the basic data, and a histogram is generated through a drawing engine; Based on the generated histogram, a drawing file stream is generated according to the set format.

2. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: The basic data at least includes basic drilling information, stratum layer information and a lithology symbol library.

3. The online template-based drilling histogram generation method based on a cloud database according to claim 2, characterized in that: The basic drilling information includes at least: the drilling number, the drilling location coordinates, the stratum information revealed by the drilling, the drilling depth, the hole mouth elevation, the drilling date and the hole completion date, and the groundwater level; the stratigraphic stratification information includes at least: the layer number, the layer top depth, the layer bottom depth, the lithology name, the lithology description and the geological age.

4. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: The template content of a set type of drill column chart includes at least the drawing area, scale, text style, text size, header content, footer content, header style, and footer style.

5. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: The creating of the drawing engine includes: creating at least two different types of drawing engines.

6. The online template-based drilling histogram generation method based on a cloud database according to claim 5, characterized in that: The creating of at least two different types of drawing engines includes: Build DXF drawing engine based on NetDXF library; Build an SVG drawing engine based on the SVG library; Define a set of standardized drawing interfaces for DXF drawing engine and SVG drawing engine; For specific types not supported by the SVG format, compatibility support is achieved by converting them into paths.

7. The online template-based drilling histogram generation method based on a cloud database according to claim 6, characterized in that: The standardized drawing interface at least includes polyline drawing, text rendering and pattern filling drawing interfaces.

8. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: The method further includes: verifying whether the histogram generated by the drawing engine meets industry standards and project requirements, and if not, adjusting the generated histogram.

9. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: Calculating basic information of the drilling histogram based on the basic data and generating the histogram through a drawing engine includes: Extract basic data from the database; Initialize the drawing engine and load the necessary symbol libraries and style sheets; The total height of the histogram is calculated based on the total depth of the borehole and the preset scale, and then the specific position and height of each layer in the histogram are determined based on the top and bottom depth data of each layer; Combine the lithology name and geological age information of the stratum and select the matching fill color and style from the lithology symbol library; Call the polyline drawing function of the drawing engine to draw stratum boundaries and structures, layer lines and auxiliary lines, add stratum information, drill hole names and depth scales, and set the font, size and color; Use corresponding filling patterns and colors to implement pattern filling for each layer of stratum.

10. The online template-based drilling histogram generation method based on a cloud database according to claim 1, characterized in that: Generating a drawing file stream according to a set format includes: generating a drawing file stream according to DXF and SVG formats.

Images