An online templated borehole column chart generation method based on a cloud database

Abstract

The present application relates to the technical field of geotechnical investigation, in particular to an online templating borehole columnar chart generation method based on a cloud database, which obtains a cloud environment and drawing basic data, enters the drawing basic data in the cloud environment, and uses the cloud environment as a running platform; defines the template content of a borehole columnar chart of a set type, creates a borehole columnar chart template; creates a drawing interface drawing engine including different interfaces; on the running platform, based on the borehole columnar chart template, calls the drawing interface, calculates the basic information of the borehole columnar chart according to the basic data, generates a columnar chart through the drawing engine; based on the generated columnar chart, generates a drawing file stream according to a set format. The present application avoids the dependence on specific software in the borehole columnar chart generation process, realizes the cross-platform consistency of data and results, improves the work efficiency and collaboration ability of different teams, and can be widely applied to the geotechnical engineering investigation field of industrial and civil construction, subway, municipal administration, ocean and other industries.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of geotechnical investigation, and particularly relates to an online templated borehole columnar graph generation method based on a cloud database. BACKGROUND

[0002] The borehole columnar graph is a basic graph in the field of geotechnical engineering investigation, and is widely used in the fields of engineering geology, hydrogeology, geotechnical investigation and petroleum geology. It describes various types of geological information of strata in tabular form, and is an important basis for engineering design, geological analysis and resource development. The traditional manual drawing method of the borehole columnar graph is not only low in efficiency and poor in accuracy, but also prone to errors in data entry and graph drawing, and is difficult to meet the efficient and accurate needs of modern engineering design and geological analysis. With the acceleration of urbanization and the advancement of infrastructure construction, the demand for borehole columnar graphs in the fields of engineering geology and geotechnical investigation is increasing, especially in the fields of civil engineering, subway, municipal engineering, ocean engineering, and geological disaster prevention such as land subsidence and landslide. As an important basis for engineering design, geological analysis and resource development, the rapid and accurate generation of the borehole columnar graph is particularly important.

[0003] In recent years, borehole columnar graph generation systems based on Web Service, WebGIS and BIM technologies have gradually emerged, providing new ideas to solve the shortcomings of traditional methods. For example, Song Shang published a borehole columnar graph drawing software development technology based on NET API (C#) in the journal "Urban Road and Bridge and Flood Control" in 2019. By combining AutoCAD and Excel, the technology realizes the convenient input and batch drawing of borehole columnar graphs, greatly improving the drawing efficiency and quality of designers; Mou Nixia, Liang Chunli, Zhang Lingshen and others published a Web Service-based borehole columnar graph network mapping system in the journal "Metal Mine" in 2010. By using Web Service technology, a four-layer remote mapping architecture is designed, making the generation of borehole columnar graphs more flexible and efficient; Wang Youlin, Wang Jianming, Cheng Xinxing and others published a cross-platform automatic generation method of borehole columnar graphs in the journal "Rock and Soil Engineering Technology" in 2016. By designing a general borehole data model and an automatic lithology pattern filling algorithm, cross-platform automatic generation of borehole columnar graphs is realized, providing technical support for data sharing and full utilization.

[0004] However, the existing research still has some shortcomings: on the one hand, the traditional method is highly dependent on specific software (such as AutoCAD and GIS components), resulting in deep binding of data and software, poor cross-platform compatibility, and low efficiency of manual adjustment. On the other hand, the existing method still needs to be improved in terms of multi-scene reuse and data consistency. SUMMARY

[0005] To solve the above technical problems, the purpose of the present application is to provide an online templated drilling column chart generation method based on a cloud database, and the technical solution adopted is as follows:

[0006] In a first aspect, the present application provides an online templated drilling column chart generation method based on a cloud database, comprising the following steps:

[0007] Obtain a cloud environment and basic data for drawing, enter the basic data for drawing in the cloud environment, and use the cloud environment as a running platform;

[0008] Define the template content of a drilling column chart of a set type, and create a drilling column chart template;

[0009] Create a drawing engine, which includes different drawing interfaces;

[0010] On the running platform, call the drawing interface based on the drilling column chart template, calculate the basic information of the drilling column chart according to the basic data, and generate a column chart through the drawing engine;

[0011] Based on the generated column chart, generate a drawing file stream in a set format.

[0012] In combination with the above first aspect, in some possible implementation manners, the basic data at least includes drilling basic information, stratigraphic layering information, and lithology symbol library.

[0013] In combination with the above first aspect, in some possible implementation manners, the drilling basic information at least includes drilling number, drilling position coordinates, stratigraphic information exposed by drilling, drilling depth, hole opening elevation, hole opening date and final hole date, and underground water level; and the stratigraphic layering information at least includes layer number, layer top depth, layer bottom depth, lithology name, lithology description, and geological era.

[0014] In combination with the above first aspect, in some possible implementation manners, the template content of a drilling column chart of a set type at least includes map sheet, scale, text style, text size, table header content, table tail content, table header style, and table tail style.

[0015] In combination with the above first aspect, in some possible implementation manners, the creation of the drawing engine includes creating at least two different types of drawing engines.

[0016] In combination with the above first aspect, in some possible implementation manners, the creation of the at least two different types of drawing engines includes:

[0017] Constructing a DXF drawing engine based on a NetDXF library;

[0018] Constructing an SVG drawing engine based on an SVG library;

[0019] Defining a set of standardized drawing interfaces for the DXF drawing engine and the SVG drawing engine;

[0020] For specific types that are not supported by the SVG format, compatibility support is achieved by converting them to paths.

[0021] In combination with the first aspect described above, in some possible implementation manners, the standardized drawing interfaces at least include polyline drawing, text rendering, and pattern fill drawing interfaces.

[0022] In combination with the first aspect described above, in some possible implementation manners, the method further includes verifying whether the columnar graph generated by the drawing engine meets industry standards and project requirements, and adjusting the generated columnar graph if it does not meet the industry standards or project requirements.

[0023] In combination with the first aspect described above, in some possible implementation manners, the basic information of the drilling columnar graph is calculated according to the basic data, and the columnar graph is generated by the drawing engine, including:

[0024] Extracting the basic data from the database;

[0025] Initializing the drawing engine, loading necessary symbol libraries and style sheets;

[0026] According to the total depth of the drilling and the preset scale, the total height of the columnar graph is calculated, and according to the top and bottom depth data of each layer of stratum, the specific position and height of each layer of stratum in the columnar graph are determined;

[0027] In combination with the lithology name and the geological era information of the stratum, the matching fill color and style are selected from the lithology symbol library;

[0028] Calling the polyline drawing function of the drawing engine, drawing the stratum boundary and structure, the layering line and the auxiliary line, adding the stratum information, the drilling name and the depth scale, and setting the font, the font size and the color;

[0029] Using the corresponding fill pattern and color to implement pattern filling for each layer of stratum.

[0030] In combination with the first aspect described above, in some possible implementation manners, generating a drawing file stream in a set format includes generating a drawing file stream in a DXF and SVG format.

[0031] Secondly, the application further provides an online templated drilling columnar graph generation device based on a cloud database, the device comprising:

[0032] A data acquisition module is configured to acquire cloud environment and drawing basis data, input the drawing basis data in the cloud environment, and use the cloud environment as a running platform.

[0033] A template construction module is configured to define template content of a drilling column chart of a set type, and create a drilling column chart template.

[0034] An engine creation module is configured to create a drawing engine, wherein the drawing engine comprises different drawing interfaces.

[0035] A column chart generation module is configured to, on the running platform, call a drawing interface based on the drilling column chart template, calculate basic information of the drilling column chart according to the basis data, and generate a column chart through the drawing engine.

[0036] A drawing file stream generation module is configured to generate a drawing file stream in a set format based on the generated column chart.

[0037] In a third aspect, the present application further provides an online template drilling column chart 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 call and run the executable computer program code from the memory, so that the system executes the method in the first aspect or any possible implementation manner of the first aspect.

[0038] In a fourth aspect, the present application further provides a computer program product, which comprises computer program code. When the computer program code runs on a computer, the computer executes the method in the first aspect or any possible implementation manner of the first aspect.

[0039] In a fifth aspect, the present application further provides a computer readable storage medium, which stores computer program code. When the computer program code runs on a computer, the computer executes the method in the first aspect or any possible implementation manner of the first aspect.

[0040] The present application has the following beneficial effects: the present application obtains the drawing basic data in the cloud environment, and uses the cloud environment as a running platform. By creating a drilling histogram template and creating a drawing engine, on the running platform, based on the drilling histogram template, calling the drawing interface, calculating the basic information of the drilling histogram according to the basic data, and accurately generating the histogram based on the drawing engine; finally, based on the generated histogram, a drawing file stream is generated according to the set format. The present application solves the problem of high dependence on specific software (such as AutoCAD, GIS components) in the traditional drilling histogram generation process, 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 multi-scene reuse, ensures the consistency of data and results in different cross-platforms, and provides standardized digital results for engineering design and geotechnical analysis. BRIEF DESCRIPTION OF DRAWINGS

[0041] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, and the advantages thereof, a brief introduction will be given to the drawings needed in the embodiments or prior art description. Obviously, the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained without creative labor based on these drawings.

[0042] Figure 1 A step flow chart of an online template drilling histogram generation method based on a cloud database according to an embodiment of the present application;

[0043] Figure 2 A structural schematic diagram of an online template drilling histogram generation device based on a cloud database according to an embodiment of the present application. DETAILED DESCRIPTION

[0044] In order to clearly illustrate the technical features of the present application, the present application will be described in detail below with specific embodiments and in conjunction with the drawings.

[0045] Embodiments of the present application will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present application are shown in the drawings, it should be understood that the present application can be implemented in various forms, and should not be interpreted as being limited to the embodiments described herein, on the contrary, these embodiments are provided to make the present application more thorough and complete. It should be understood that the drawings and embodiments of the present application are only for illustrative purposes, and are not intended to limit the scope of protection of the present application.

[0046] It should be understood that each step described in the method embodiments of the present application can be executed in different order and / or in parallel. In addition, the method embodiments can include additional steps and / or omit the execution of the steps shown. The scope of the present application is not limited in this respect.

[0047] The term "includes" and its variants are open-ended, and mean "comprising 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". The term "some embodiments" means "at least some embodiments". Related terms have corresponding definitions.

[0048] It should be noted that the terms "first", "second", and the like in the description and in the claims of the present application are used for distinguishing between similar elements and not necessarily for describing a sequential or chronological order. It is to be understood that the terms so used are interchangeable under appropriate circumstances and embodiments of the application are capable of operating according to different scenarios that fall within the ambit of the application.

[0049] In the embodiments of the present application, although the operations or steps are described in a particular order in the accompanying drawings, it should not be understood as requiring the operations or steps to be performed in the particular order or in a serial order, or requiring all of the operations or steps to be performed to obtain a desired result. In the embodiments of the present application, the operations or steps can be performed in series; the operations or steps can be performed in parallel; or a part of the operations or steps can be performed.

[0050] Meanwhile, it can be understood that the data involved in the technical solutions of the present application (including but not limited to the data itself, the acquisition or use of the data) should comply with the requirements of the corresponding laws, regulations and relevant provisions. Unless otherwise defined, all technical and scientific terms used in the present application have the same meaning as understood by a person skilled in the art to which the present application belongs, and all parameters or indicators in the formulas involved in the present application are normalized values after eliminating the dimension influence.

[0051] To solve the problems of low efficiency, poor accuracy, high dependence on specific software and poor cross-platform compatibility in the traditional borehole columnar chart generation method, an online templated borehole columnar chart generation method based on a cloud database is provided in the embodiments of the present application. The method breaks away from the dependence on specific software through standardized data management and template customization technology in a cloud environment, realizes the cross-platform consistency of data and results, and significantly improves the work efficiency and collaboration ability between different departments and teams through one-time configuration and multi-scene reuse.

[0052] The online templated borehole columnar chart generation method based on a cloud database provided by the embodiments of the present application will be described in detail below with reference to the accompanying drawings.

[0053] Figure 1 The basic flowchart of the online templated borehole columnar chart generation method based on a cloud database provided by the embodiments of the present application is shown in FIG. 1. Figure 1As shown, the method specifically includes the following steps:

[0054] Step S100: Obtain the cloud environment and drawing basis data, enter the drawing basis data in the cloud environment, and use the cloud environment as a running platform.

[0055] Build and configure the cloud environment, enter the drilling basis information, stratigraphic layering information, lithology symbol library and other drawing basis data in the cloud environment. Use the cloud environment as the running platform for drawing, and take advantage of its centralized data management, multi-user concurrent access and cross-platform compatibility.

[0056] In a specific example, the drilling basis information entered in the cloud environment includes but is not limited to drilling number, drilling location coordinates, drilling exposed stratigraphic information, drilling depth, hole opening elevation, hole opening date and final hole date, and other drawing data required by drilling columnar graph, which provides basic data support for subsequent drawing and ensures that the generated drilling columnar graph can accurately reflect the actual geological conditions of the drilling.

[0057] The stratigraphic layering information entered in the cloud environment includes but is not limited to layer number, layer top depth, layer bottom depth, lithology name, lithology description and geological era, and other key elements. Stratigraphic layering information is the core data of drilling columnar graph, and after these information is entered into the database, it provides stratigraphic layering data for the drawing engine, ensuring that the generated columnar graph can clearly present the stratigraphic distribution.

[0058] The preparation of lithology symbol library entered in the cloud environment includes: designing symbols according to the geological industry standard, storing symbols in common formats (such as PAT, etc.) to the cloud, and doing good classification management, such as pattern symbols in PAT, which contains a series of pattern definitions (pattern name, pattern type, pattern data). Establish the association between symbols and lithology names in the database to ensure automatic matching of symbols and compliance with industry standards during drawing. Finally, data verification and calibration are performed, that is, integrity check, accuracy verification and format standardization are performed on the data to ensure data quality and guarantee the accuracy of subsequent drawing results.

[0059] Step S200: Define the template content of a type of drilling columnar graph, and create a drilling columnar graph template.

[0060] Define the template content of a type of drilling columnar graph, including map, scale, text style, text size, table header content, table tail content, table header style, table tail style, etc. Based on the template content, create the corresponding drilling columnar graph template according to the specific needs of the project. This template is not only suitable for this project, but also can be applied to other projects of the same type. In addition, other templates that meet the needs of different projects can also be flexibly created according to the characteristics of different projects.

[0061] In a specific example, the specific process of creating a borehole histogram template includes: defining the map size and page layout to adapt to different printing and screen display needs; setting the scale value, determining the scale value according to the actual drilling depth and the expected figure height, and allowing the user to adjust as needed; selecting the specified text style and size to ensure that the text in the figure is clear and identifiable; editing the table header and footer content, covering key information such as project name, borehole number, etc., and designing the style to enhance the professionalism and readability of the chart, as shown in Table 1 and Table 2.

[0062] Table 1: Table header style of borehole histogram

[0063]

[0064] Table 2: Table footer style of borehole histogram

[0065]

[0066] Step S300: Create a drawing engine, which includes different drawing interfaces.

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

[0068] In a specific example, creating a drawing engine involves the following key steps: ① Based on the NetDXF library, build a DXF drawing engine, NetDXF library is an open source library for reading and writing DXF files, which provides rich APIs to manipulate DXF graphics elements. Using this library can realize functions such as polyline drawing, text rendering, and pattern filling, providing strong support for generating DXF format borehole histograms. ② Based on the SVG library, build an SVG drawing engine, SVG library is used to create and manipulate vector graphics, with good cross-platform compatibility and scalability. By using the SVG library to realize similar drawing functions, SVG format borehole histograms can be generated to meet the needs of different application scenarios for graphic formats. ③ To ensure the consistency of the functions of the two drawing engines, a set of standardized interfaces is defined, including polyline drawing, text rendering, and pattern filling. This operation can ensure that regardless of which engine is used, these functions can be called in the same way to generate graphics that meet the requirements. ④ For specific types that SVG format does not support (such as shape text and filling), a solution is adopted to convert these elements into paths (Path) to support compatibility. Path is a general graphic representation method in SVG, which can represent various complex shapes. In this way, the SVG drawing engine can fully present all elements of the borehole histogram, achieving comparable graphic expressiveness to the DXF drawing engine.

[0069] Step S400: On the running platform, based on the borehole column chart template, a drawing interface is called, the basic information of the borehole column chart is calculated according to the basic data, and the column chart is generated through a drawing engine.

[0070] A standardized interface compatible with the drawing engine is called, and the layout of various drawing elements in the borehole column chart is calculated according to the pre-prepared basic data through the standardized interface of the drawing engine. The created drawing engine is used to generate a clear and intuitive column chart, which ensures that it meets the industry standards and project requirements.

[0071] In a specific example, the specific steps of generating the column chart include: calling the drawing interface. The basic data is extracted from the database, including borehole basic information, stratigraphic layering information, and lithology symbol library, etc. Then the drawing engine is initialized, and the necessary symbol library and style sheet are loaded for drawing. According to the total depth of the borehole and the preset scale, the total height of the column chart is calculated, and then according to the top and bottom depth data of each layer of stratum, the specific position and height of each layer of stratum in the column chart are determined. Combined with the lithology name and geological age information of the stratum, the matching fill color and style are selected from the lithology symbol library. Then the polyline drawing function of the drawing engine is called to draw the stratum boundary and structure, layering line and auxiliary line, add text annotations such as stratum information, borehole name and depth scale, and set the font, font size and color. Finally, the corresponding fill pattern and color are used to implement pattern filling for each layer of stratum.

[0072] Step S500: Based on the generated column chart, a drawing file stream is generated in a set format.

[0073] After selecting the DXF or SVG format, the output function of the drawing engine is started, each element in the column chart is converted into the corresponding format instruction and data structure, the standardization and readability of the file stream are optimized, all data are integrated to form a complete file stream, and the file stream is output as an independent file and saved to a specified location. Finally, the integrity of the file is verified to ensure that it can be correctly displayed.

[0074] In a specific example, based on the generated column chart, the drawing file stream is generated in a set format, which includes: according to user needs and application scenarios, selecting the DXF or SVG format to generate the drawing file stream. The output function of the drawing engine is called to start the file stream generation preparation work. The line, text, fill pattern and other graphic elements in the column chart are traversed one by one, and they are converted into the corresponding instructions and data structures of the selected format. The generated file stream is optimized to ensure its structure is standardized and readability is strong. All converted drawing data is integrated to form a complete file stream, which is output as an independent drawing file and saved to a specified location. Finally, the file integrity is checked to ensure that the drawing file can be opened and displayed correctly in related software.

[0075] So far, through the above steps S100-S500, the complete process from data preparation to final file generation is realized, ensuring that the generated drilling column chart meets the industry standards and project requirements.

[0076] The online templated drilling column chart generation method based on a cloud database provided by the embodiment of the present application solves the problem of high dependence on specific software (such as AutoCAD and GIS components) in the traditional drilling column chart generation process, avoids the defects of poor cross-platform compatibility and low efficiency of manual adjustment caused by deep binding of data and software, realizes one-time configuration and multi-scene reuse, ensures the consistency of data and results across different platforms, and can be widely applied to the field of geotechnical engineering investigation in industries such as civil construction, subway, municipal administration, and ocean, thereby providing standardized digital results support for engineering design and geotechnical analysis.

[0077] Based on the same inventive concept, the embodiment of the present application also provides an online templated drilling column chart generation device based on a cloud database, as shown in Figure 2 The device comprises:

[0078] A data acquisition module is configured to acquire a cloud environment and drawing basis data, input the drawing basis data in the cloud environment, and use the cloud environment as a running platform.

[0079] A template construction module is configured to define and set the template content of a drilling column chart of a certain type, and create a drilling column chart template.

[0080] An engine creation module is configured to create a drawing engine, wherein the drawing engine comprises different drawing interfaces.

[0081] A column chart generation module is configured to call a drawing interface based on the drilling column chart template on the running platform, calculate the basic information of the drilling column chart according to the basis data, and generate a column chart through the drawing engine.

[0082] A drawing file stream generation module is configured to generate a drawing file stream in a set format based on the generated column chart.

[0083] It should be noted that the device provided in the above embodiment is only used as an example for the division of the above functional modules, and in actual application, the above functions can be completed by different functional modules according to needs, that is, the internal structure of the computer device is divided into different functional modules to complete all or part of the above described functions.

[0084] Based on the same inventive concept, the embodiment of the present application also provides an online templated drilling column chart generation system based on a cloud database, which comprises a memory, a processor and computer program codes stored in the memory and running on the processor, wherein the processor executes the computer program codes to enable the system to perform any of the online templated drilling column chart generation methods based on the cloud database.

[0085] The embodiment of the present application can divide the system into functional modules according to the above method examples, for example, each functional module can be provided, or two or more functions can be integrated in one processing module, and the integrated module can be realized in the form of hardware.

[0086] Based on the same inventive concept, the embodiment of the present application also provides a computer program product, which comprises computer program codes, when the computer program codes run on a computer, the computer executes any of the online templated drilling column chart generation methods based on the cloud database.

[0087] Based on the same inventive concept, the embodiment of the present application also provides a computer readable storage medium, which stores computer program codes, when the computer program codes run on a computer, the computer executes any of the online templated drilling column chart generation methods based on the cloud database.

[0088] It should be noted that the above-described embodiments are only used to illustrate the technical solutions of the present application, rather than limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that the technical solutions recorded in the foregoing embodiments can be modified, or some technical features can be replaced by equivalent ones; and these modifications or replacements do not change the essence of the corresponding technical solutions, and should be included in the protection scope of the present application.

Claims

1. A cloud database based online templated borehole columnar section generation method, characterized by, The method comprises the following steps: obtaining a cloud environment and drawing basic data, inputting the drawing basic data in the cloud environment, and taking the cloud environment as a running platform; the basic data at least includes drilling basic information, stratigraphic layering information and lithology symbol library; defining the template content of a type of drilling column chart, and creating a drilling column chart template; the template content of the type of drilling column chart at least includes a map, a scale, a text style, a text size, table header content, table tail content, table header style, and table tail style; creating at least two different types of drawing engines, including: constructing a DXF drawing engine based on a NetDXF library; constructing an SVG drawing engine based on an SVG library; defining a set of standardized drawing interfaces for the DXF drawing engine and the SVG drawing engine; for specific types that are not supported by the SVG format, compatibility support is realized by converting them into paths; the drawing engine includes different drawing interfaces; on the running platform, based on the drilling column chart template, a drawing interface is called, the basic information of the drilling column chart is calculated according to the basic data, and a column chart is generated through the drawing engine; based on the generated column chart, a drawing file stream is generated in a set format.

2. A cloud database based online templated borehole column chart generation method as claimed in claim 1 wherein, The drilling basic information at least includes drilling number, drilling location coordinates, stratigraphic information exposed by drilling, drilling depth, hole opening elevation, hole opening date and final hole date, and underground water level; the stratigraphic layering information at least includes layer number, layer top depth, layer bottom depth, lithology name, lithology description and geological era.

3. A cloud database based online templated borehole column chart generation method as claimed in claim 1 wherein, The standardized drawing interfaces at least include polyline drawing, text rendering and pattern filling drawing interfaces.

4. A cloud database based online templated borehole column chart generation method as claimed in claim 1 wherein, The method further comprises verifying whether the column chart generated by the drawing engine meets the industry standards and project requirements, and adjusting the generated column chart if it does not meet the industry standards or project requirements.

5. A cloud database based online templated borehole column chart generation method as claimed in claim 1 wherein, According to the basic data, the basic information of the drilling column chart is calculated, and the column chart is generated through the drawing engine, including: extracting the basic data from the database; initializing the drawing engine, loading necessary symbol libraries and style sheets; according to the total drilling depth and the preset scale, the total height of the column chart is calculated, and then according to the top and bottom depth data of each layer, the specific position and height of each layer in the column chart are determined; combined with the lithology name and geological era information of the stratum, the matching filling color and style are selected from the lithology symbol library; the polyline drawing function of the drawing engine is called to draw the stratigraphic boundary and structure, layering line and auxiliary line, and add stratigraphic information, drilling name and depth scale, and set font, font size and color; the corresponding filling pattern and color are used to implement pattern filling for each layer.

6. A cloud database based online templated borehole column chart generation method as claimed in claim 1 wherein, Generating a drawing file stream in a set format includes generating a drawing file stream in DXF and SVG formats.

Images