A method and system for generating engineering geological column chart

Abstract

The present invention discloses a method and system for generating an engineering geological histogram. According to the low-code logic, the first type of data and the basic data of the geological basic database are associated, and the basic graphic element results of the histogram are generated, so that the basic graphic element results of the histogram are generated in a low-code manner. At the same time, the first type of data is designed by a geological engineer, and the second type of data is designed by a geological engineer, which fully gives the geological engineer the opportunity to freely design the engineering drawing frame results and the basic graphic element results of the histogram, so as to facilitate processing in various styles according to the ideas of the geological engineer, and then generate an engineering geological histogram based on the engineering drawing frame results and the basic graphic element results of the histogram, thereby realizing the automatic generation of engineering geological histograms of any style, ensuring the diversity and versatility of the engineering geological histogram results, so as to improve the work efficiency of the geological engineer and the accuracy of the results data.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering geological column charts, and in particular to a method and system for generating an engineering geological column chart. Background Art

[0002] With the development of science and technology, the output method of engineering geological histograms in existing engineering survey software generally adopts fixed template statistics and output methods. This method enables the rapid generation of specific templates by establishing a specific style histogram output method by software engineers. The table style output by this method is fixed. However, in actual work, affected by factors such as user company results specifications, owner results requirements, and review expert preferences, the content and style of geological histograms are changeable and cannot be summarized in a unified template format, resulting in the inability to achieve automatic generation of engineering geological histograms. Summary of the invention

[0003] The purpose of the present invention is to overcome the shortcomings of the prior art. The present invention provides a method and system for generating an engineering geological bar graph, introduces low-code logic, and associates the first type of data and the basic data of the geological basic database according to the low-code logic, and generates a bar graph basic primitive results, thereby generating the bar graph basic primitive results in a low-code manner. At the same time, the first type of data is designed by a geological engineer, and the second type of data is designed by a geological engineer, which fully gives the geological engineer the opportunity to freely design the engineering drawing frame results and the basic primitive results of the bar graph, so as to facilitate processing in various styles according to the ideas of the geological engineer, and then generate an engineering geological bar graph based on the engineering drawing frame results and the basic primitive results of the bar graph, thereby realizing the automatic generation of engineering geological bar graphs of any style, ensuring the diversity and versatility of the engineering geological bar graph results, so as to improve the work efficiency of geological engineers and the accuracy of the results data.

[0004] In order to solve the above technical problems, the present invention provides a method for generating an engineering geological column chart, comprising:

[0005] The first type of data is designed by a geological engineer and acquired by a computer; the first type of data includes histogram template data, which is independently designed by the geological engineer;

[0006] According to the low-code logic, the first type of data and the basic data of the geological basic database are associated, and a bar chart basic graphic element result is generated, wherein the bar chart basic graphic element result includes first characteristic data; the first characteristic data is parameter data in the bar chart basic graphic element result;

[0007] The geological engineer designs the second type of data, and the computer acquires the second type of data and the first characteristic data; the second type of data includes the frame template data;

[0008] Based on the second type of data and the first characteristic data, an engineering drawing frame result is generated; and based on the engineering drawing frame result and the bar chart basic element result, an engineering geological column chart is generated.

[0009] Optionally, before the geological engineer designs the first type of data and the computer acquires the first type of data, a geological basic database is constructed. In this case, the method for constructing the geological basic database includes:

[0010] Entering the basic data;

[0011] The basic data is expanded by single-table expansion and / or multi-table expansion to form associated data; and the basic data and the associated data are collected to form the geological basic database.

[0012] Optionally, the first type of data includes histogram template data, which is independently designed by a geological engineer;

[0013] The method of associating the first type of data with the basic data of the geological basic database according to the low-code logic and generating the basic graphic element results of the bar chart includes:

[0014] Acquire the histogram template data and basic data of the geological basic database;

[0015] Based on low-code logic, the bar chart template data and the basic data of the geological basic database are associated and converted into a first CAD entity in the low-code logic; and based on the first CAD entity, the basic graphic element results of the bar chart are output.

[0016] Optionally, the bar chart template data includes fixed graphic data, single data content, single column data content and special data content;

[0017] The step of associating the histogram template data with the basic data of the geological basic database based on low-code logic and converting the data into a first CAD entity in the low-code logic includes:

[0018] converting the fixed graphic data into a first block reference;

[0019] converting the single data content into the attribute value of the first block reference;

[0020] converting the single column data content into a first independent entity; and converting the special data content into a second independent entity.

[0021] Optionally, the associating the bar chart template data with the basic data of the geological basic database based on the low-code logic and converting them into the first CAD entity in the low-code logic further includes:

[0022] The first block reference, the attribute value of the first block reference, the first independent entity and the second independent entity are integrated in the low-code template file and converted into a first CAD entity.

[0023] Optionally, the second category of data also includes project information data;

[0024] The generating of the engineering drawing frame result based on the second type of data and the first characteristic data includes:

[0025] Acquire the frame template data, the project information data and the first characteristic data;

[0026] Based on the drawing frame template data, the project information data and the first feature data, converting into a second CAD entity; and based on the second CAD entity, outputting the engineering drawing frame result.

[0027] Optionally, the frame template data includes fixed data content and single data content;

[0028] The converting into a second CAD entity based on the drawing frame template data, the project information data and the first feature data includes:

[0029] converting the fixed data content into a second block reference; and converting the single data content into an attribute value of the second block reference.

[0030] Optionally, the outputting the engineering drawing frame result based on the second CAD entity includes:

[0031] The engineering drawing frame result is output based on the second block reference and the attribute value of the second block reference.

[0032] Optionally, generating an engineering geological column chart based on the engineering drawing frame result and the column chart basic element result includes:

[0033] Coupling the engineering drawing frame result and the column chart basic element result in the CAD model space to generate the engineering geological column chart;

[0034] The coupling process includes associating the engineering drawing frame results and the column chart basic element results to the CAD model space, and neatly arranging the engineering drawing frame results and the column chart basic element results in the CAD model space to generate the engineering geological column chart.

[0035] In addition, an embodiment of the present invention further provides a system for generating an engineering geological histogram, and the system for generating an engineering geological histogram includes:

[0036] A first acquisition module is used for a geological engineer to design first-type data, and a computer acquires the first-type data; the first-type data includes histogram template data, and the histogram template data is independently designed by the geological engineer;

[0037] A first generation module is used to associate the first type of data with the basic data of the geological basic database according to the low-code logic, and generate a bar chart basic graphic element result, wherein the bar chart basic graphic element result includes first feature data; the first feature data is parameter data in the bar chart basic graphic element result;

[0038] The second acquisition module is used for the geological engineer to design the second type of data, and the computer acquires the second type of data and the first characteristic data; the second type of data includes the frame template data;

[0039] A second generation module is used to generate an engineering drawing frame result based on the second type of data and the first characteristic data; and a bar chart module is used to generate an engineering geological bar chart based on the engineering drawing frame result and the bar chart basic element result.

[0040] In an embodiment of the present invention, through the method in the embodiment of the present invention, a geological engineer designs a first type of data, and a computer obtains the first type of data; the first type of data and the basic data of the geological basic database are associated according to the low-code logic, and a column chart basic graphic element result is generated, and the column chart basic graphic element result includes the first characteristic data; a geological engineer designs a second type of data, and the computer obtains the second type of data and the first characteristic data; based on the second type of data and the first characteristic data, an engineering drawing frame result is generated; and based on the engineering drawing frame result and the column chart basic graphic element result, an engineering geological column chart is generated. At this time, low-code logic is introduced, and the first type of data and the geological basic data are associated according to the low-code logic. The basic data of the database is obtained, and the basic primitive results of the bar chart are generated, so as to generate the basic primitive results of the bar chart in a low-code manner. At the same time, the first type of data is designed by the geological engineer, and the second type of data is designed by the geological engineer, which fully gives the geological engineer the opportunity to freely design the engineering drawing frame results and the basic primitive results of the bar chart, so as to facilitate various styles of processing along the ideas of the geological engineer, and then generate an engineering geological bar chart based on the engineering drawing frame results and the basic primitive results of the bar chart, thereby realizing the automatic generation of engineering geological bar charts of any style, ensuring the diversity and versatility of the engineering geological bar chart results, so as to improve the work efficiency of geological engineers and the accuracy of the results data. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. 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 creative work.

[0042] Figure 1 It is a schematic diagram of a flow chart of a method for generating an engineering geological histogram in an embodiment of the present invention;

[0043] Figure 2 is a schematic flow chart of S12 in the method for generating an engineering geological histogram in an embodiment of the present invention;

[0044] Figure 3 is a schematic flow chart of S14 in the method for generating an engineering geological histogram in an embodiment of the present invention;

[0045] Figure 4 is a schematic flow chart of S15 in the method for generating an engineering geological histogram in an embodiment of the present invention;

[0046] Figure 5 It is a schematic diagram of the relationship of the database in the method for generating an engineering geological histogram in an embodiment of the present invention;

[0047] Figure 6 It is a schematic diagram of the basic graphic element results of the histogram in the method for generating the engineering geological histogram in the embodiment of the present invention;

[0048] Figure 7 It is a schematic flow chart of a basic primitive module of a histogram in a method for generating an engineering geological histogram in an embodiment of the present invention;

[0049] Figure 8 It is a flow chart of an engineering drawing frame processing module in a method for generating an engineering geological histogram in an embodiment of the present invention;

[0050] Fig. 9 is a schematic diagram of a bar graph primitive template in an embodiment of the present invention;

[0051] Fig.10 It is a schematic diagram of an engineering drawing frame template in an embodiment of the present invention;

[0052] Fig.11 is a schematic diagram of a bar graph primitive template (general specification) in an embodiment of the present invention;

[0053] Fig.12 is a schematic diagram of a histogram primitive template (expert advice) in an embodiment of the present invention;

[0054] Fig.13is a schematic diagram of an A3 frame template in an embodiment of the present invention;

[0055] Fig.14 is a schematic diagram of company specifications in an embodiment of the present invention;

[0056] Fig.15 is a general standard schematic diagram in an embodiment of the present invention;

[0057] Fig.16 is a schematic diagram of expert advice in an embodiment of the present invention;

[0058] Fig.17 It is a schematic diagram of the structural composition of a system for generating an engineering geological histogram in an embodiment of the present invention;

[0059] Fig.18 The figure is a hardware diagram of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

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

[0061] See also Figures 1 to 10 The present invention provides a method for generating an engineering geological column chart, which is applied to the generation scenario of an engineering geological column chart.

[0062] The methods for generating engineering geological histograms include:

[0063] Step S11: A geological engineer designs the first type of data, and a computer acquires the first type of data; the first type of data includes histogram template data, and the histogram template data is independently designed by the geological engineer;

[0064] Step S12: Associating the first type of data with the basic data of the geological basic database according to the low-code logic, and generating a bar chart basic graphic element result, wherein the bar chart basic graphic element result includes first feature data; the first feature data is parameter data in the bar chart basic graphic element result;

[0065] Step S13: The geological engineer designs the second type of data, and the computer acquires the second type of data and the first characteristic data; the second type of data includes the frame template data;

[0066] Step S14: generating an engineering drawing frame result based on the second type of data and the first characteristic data; and Step S15: generating an engineering geological column chart based on the engineering drawing frame result and the column chart basic element result.

[0067] In an embodiment of the present invention, through the method in the embodiment of the present invention, low-code logic is introduced, and the first type of data and the basic data of the geological basic database are associated according to the low-code logic, and the basic primitive results of the bar chart are generated, so as to generate the basic primitive results of the bar chart in a low-code manner. At the same time, the first type of data is designed by a geological engineer, and the second type of data is designed by a geological engineer, which fully gives the geological engineer the opportunity to freely design the engineering drawing frame results and the basic primitive results of the bar chart, so as to facilitate various styles of processing along the ideas of the geological engineer, and then generate an engineering geological bar chart based on the engineering drawing frame results and the basic primitive results of the bar chart, thereby realizing the automatic generation of engineering geological bar charts of any style, ensuring the diversity and versatility of the engineering geological bar chart results, so as to improve the work efficiency of geological engineers and the accuracy of the results data.

[0068] This application aims to fully match the generated bar chart template with the geological frame. It needs to know how many bar chart templates are generated, how many bar charts can be inserted into each frame, the size of the bar chart and other data; how many basic bar chart elements are finally generated is related to how many boreholes the geological engineer has selected, and even which scale and the drawable area of ​​each bar chart template. These data will be automatically calculated by the program based on the input of the geological engineer, and then associated with the frame template as the import parameter in the frame result generation process, that is, the first characteristic data. Therefore, the first characteristic data can be the parameter data in the basic bar chart element result, which connects the relationship between the bar chart template and the geological frame, so that the two modules are fully matched.

[0069] In some embodiments, before the geological engineer designs the first type of data and the computer acquires the first type of data, a geological basic database is constructed. At this time, the method for constructing the geological basic database includes: entering the basic data; expanding the basic data by single-table expansion and / or multi-table expansion to form related data; and collecting the basic data and the related data to form the geological basic database.

[0070] At the same time, the database exists in the database module, which is mainly responsible for the analysis and management of geological data. Under the premise of ensuring the logical completeness of geological data, it is convenient for technicians to call the data of the geological database. In the database module, in addition to the geological basic data directly entered by the technicians, there are also some related data (single table expansion, multi-table expansion) expanded from the basic data to expand the range of optional data when generating geological results.

[0071] For the database module functional process:

[0072] The main function of the database module is to analyze and manage geological data and improve the accuracy of geological data. In the low-code geological results generation method, the logical process of the database module is: analyze basic geological data, build a relational geological database, develop a strong verification data detection method, and add single-table associations and multi-table associations in the data statistics process according to the basic type to form an extended database.

[0073] In some embodiments, the basic data in the geological database includes exploration data and project data. The geological data mainly includes cataloging, water level, in-situ testing, sampling and other data. The project data includes profiles, sections, work sites, results catalogs and other data.

[0074] In the geological results data, there are some output data calculated by basic data. This calculation process is often strange and there is no unified calculation criteria. It is difficult to use a unified function to represent the specific calculation process. The diverse algorithm implementation methods will bring catastrophic difficulties to program design. The reasonable solution should be to set a unified data call interface. The setting of extended data is to solve this problem. In a possible implementation method, the direct input attributes of the exploration point table include drilling number, exploration point type, east coordinate, north coordinate, mileage, offset, start date, completion date and other data; the result data that needs to be calculated and output may have single-table related data such as three-dimensional spatial position and mileage position, as well as multi-table related data such as sampling standard text and water level standard text. In the process of database import, you can pre-define it in the single-table related data in the data table, such as: add three-dimensional spatial position => (east coordinate, north coordinate, elevation) to the exploration point table, mileage coordinate => (K+round (mileage / 1000) + mileage- , left or right + offset) and other single-table association attributes; establish association attributes related to multi-table association data in the database, such as sampling quantity => indexing the data rows related to a certain exploration point in the sampling data table and summing them. By collecting and integrating such association data into extended data, a standard calling interface for all geological data is implemented , providing a data foundation for the implementation of low-code methods.

[0075] In some embodiments, in the specific implementation process of the present invention, step S11 may include:

[0076] In some embodiments of the present application, the first type of data is designed by a geological engineer and formed based on the idea of ​​the geological engineer, so as to fully reflect the style desired by the geological engineer and at the same time, fully reflect the feed matching the geological engineer, so that the computer obtains the first type of data. Optionally, the first type of data includes histogram template data, which is independently designed by the geological engineer.

[0077] In some embodiments, in the specific implementation of the present invention, step S12 may include:

[0078] S121: Acquire the histogram template data and basic data of the geological basic database;

[0079] S122: Associating the bar chart template data with the basic data of the geological basic database based on low-code logic, and converting them into a first CAD entity in the low-code logic; and S123: Outputting the basic graphic element results of the bar chart based on the first CAD entity.

[0080] In certain embodiments of the present application, the bar chart template data and the basic data of the geological basic database are obtained, and the bar chart template data and the basic data are controlled so as to be converted into a first CAD entity based on the bar chart template data and the basic data, thereby clarifying the first CAD entity, and then outputting the basic graphic element results of the bar chart, thereby realizing the generation of the basic graphic element results of the bar chart and ensuring the subsequent generation of the engineering geological bar chart.

[0081] At the same time, based on the low-code logic, the bar chart template data and the basic data of the geological basic database are associated and converted into the first CAD entity in the low-code logic, so as to make full use of the low-code logic. In the low-code logic, the low-code template file is called to combine the low-code template file, the bar chart template data and the basic data of the geological basic database, so as to generate the basic graphic element results of the bar chart in a low-code manner.

[0082] At this time, the first type of data includes bar chart template data. The bar chart template data is provided by CAD (dwg file), and CAD (dwg file) should contain fixed style text for parsing the basic shape of the bar chart, basic data text for graphic drawing that requires an associated database module (used to call a general graphic drawing method), and special text data for special graphic drawing that requires an associated database module (used to call a non-general graphic drawing method).

[0083] In addition, the bar chart template data includes fixed graphic data, single data content, single column data content and special data content. Further, in step S122, the fixed graphic data is converted into a first block reference; the single data content is converted into an attribute value of the first block reference; the single column data content is converted into a first independent entity; and the special data content is converted into a second independent entity, thereby clarifying the second independent entity and the first independent entity and ensuring the accuracy of the second independent entity and the first independent entity, so as to facilitate subsequent operations on the second independent entity and the first independent entity.

[0084] At this time, the first block reference, the attribute value of the first block reference, the first independent entity and the second independent entity are integrated in the low-code template file and converted into the first CAD entity, so as to make full use of the low-code template file, and integrate the first block reference, the attribute value of the first block reference, the first independent entity and the second independent entity under the control of the low-code template file, so as to generate the basic primitive results of the bar chart through the first CAD entity, ensuring the low-code operation of the basic primitive results of the bar chart.

[0085] In step S123, based on the first CAD entity, the bar graph basic primitive result is output, so as to realize the molding of the bar graph basic primitive result. Therefore, the bar graph basic primitive result is applied to the bar graph basic primitive processing module, and the bar graph basic primitive processing module is intended to provide a free design method and automatic generation method for the bar graph basic primitive result. Optionally, the basic data of the bar graph basic primitive processing module has two sources, the first is the basic data provided by the database module, and the second is the bar graph template data provided by CAD (dwg file). At the same time, the low-code template file used when the bar graph basic primitive result is generated. Through the low-code bar graph template design, we have realized the parametric design of all primitive data. This process is manually operated by geological engineers and belongs to the pre-processing process of the bar graph basic primitive module. For the template data in the pre-processing process, we need to parse the original data and call the associated data and methods within the module. This process belongs to the intermediate processing process (logical central process) of the basic graphic element module. After the design of the pre-processing process and the algorithm processing of the intermediate process, we have realized the free design and automatic generation functions of the basic graphic elements of the geological column chart.

[0086] Functional flow of the basic element processing module for the bar chart:

[0087] We divide the data content of the basic graphic elements of the bar chart into template style data, basic graphic data and special graphic data. In order to better explain the specific role and connotation of these data, we Figure 6A standard bar chart result basic primitive result is provided, and its data content is divided as follows:

[0088] 1. The data content outside the dashed and dotted rectangles in the figure is the fixed graphic data content of the bar chart, such as the text content not surrounded by the box, the line content used to determine the specific shape of the bar chart (all the black line segments in the figure), and the specific styles of the text content and line content. These data contents are the common data attributes of all bar chart results, that is, the template style data in our program calculation process.

[0089] 2. The data contents wrapped in the dotted rectangle in the figure are the specific geological data and project data imported through the database module. For the same borehole (due to different drawing scales, one borehole may generate multiple basic graphic data), these data contents are consistent and belong to the single data content in the basic graphic data.

[0090] 3. The data content wrapped in the dotted rectangle frame in the figure, except for the bar chart filling legend and the core sampling rate column. The basic data sources of these data are all database modules, and the drawing methods are all in the form of "extended data + underline". In the actual results table, these data will have different positioning methods and different distance intervals from the baseline. For example: in the rock and soil name and description column, the data positioning interval is located in the upper left part of the column, and in the genetic age column, the data is located in the middle of the column. But in general, these data are specific results positions determined by the drawing scale and the actual depth position. The generation method is universal and belongs to the single-column data content in the basic graphic data.

[0091] 4. The bar chart legend column and the core collection rate column in the dotted rectangle box in the figure belong to special graphic data. There are two reasons for this definition. First, their output results are based on the extended data in the database model, but they need to be processed again, such as: the core collection rate column needs to draw a line chart of the collection rate change based on the core collection rate data, and the bar chart legend column needs to associate the bar chart legend data according to the cataloging depth and stratum name; second, they are not a standardized data implementation process, and specific problems need to be analyzed specifically, and different logic codes need to be written for different problems. The above fixed content is the constant data in the program running data, which does not need to be changed during the program calculation process. We only need to interpret it as fixed data and apply it to all basic graphics. Since the fixed data content of the result file is consistent with the corresponding data in the template file, and the template file is designed by the geological engineer himself, the geological engineer has full control over the fixed data content.

[0092] In most cases, the data source of a single data content is the exploration point table data in the database (the borehole number, borehole location, orifice elevation, start date, completion date, exploration depth, water level depth, and water level elevation in the figure). Therefore, the data table name is ignored in the design and is directly expressed as an attribute column name to simplify the data code. For data content outside the exploration point data table such as the project name, work site name, and bar chart ratio in the bar chart generation, the preset attribute method can be used for association. The graphics drawing method for a single data content is fixed, mainly drawing the data from the data source as a single line of text in the CAD model space. During the drawing process, the single-line text needs to determine its text style and spatial position in CAD. We can set it as the specific style data of the low-code text in the template file, thereby simplifying the function parameters of the single data content to one data source attribute value. For the above reasons, the system uses low-code in the form of "[attribute name]" to control single data content. During the process of generating results, geological engineers can modify the output content of the results by modifying the attribute name of the low-code text (changing [GCBH] to [GCMC]), and can control the shape style and spatial position of the output results by modifying the shape style and spatial position of the low-code text in the template file. Geological engineers will have full control authority over the output process of a single data content.

[0093] The data source of the single-column data content is a column of data in the basic drilling data table, which includes the borehole catalog table, standard penetration data table, dynamic exploration data table, groundwater level table, core sampling rate table, sampling experiment table and static exploration data table. These data tables have a one-to-many relationship with the exploration point data table, that is, one row of exploration point data will be associated with multiple rows of borehole catalog data (other data tables are similar). These data tables are not independent of each other, and they also have a weak correlation with the borehole catalog table. The main correlation point is that the maximum depth position in other data tables should not exceed the maximum catalog depth of the borehole catalog table. The calculation logic of the single-column data content is unified as follows: read the corresponding attribute column of a certain attribute table in the database, draw the row dividing line of the attribute column according to the control depth corresponding to the attribute table, draw the attribute value corresponding to the attribute column as a graphic text object, and position the graphic text object according to the arrangement method and position reference point. The drawing method of single-column data content is fixed and can be directly preset in the program. The specific style of the generated results can be kept consistent with the template file. Therefore, to control the output process of the entire single-column data content, it is only necessary to preset the low-code text including the data table, attribute column, layout method, and offset position. Based on the above reasons, this system uses low-code in the form of "{data table name; attribute name / extended attribute name; data layout method in the bar chart; data upward offset relative to the layout reference point}" to control the single-column data content. Here, it is assumed that a single-column data content in the template is {ZKBLSheet;CYSD;MiddleCenter;0}, then the data source it calls is the CYSD column data and control depth data in ZKBLSheet. The specific value in the column determines the baseline position according to the control depth of ZKBLSheet, and determines the attribute value in the column The cells are sorted in the center according to MiddleCenter.0 (the output results can be seen in the attached Figure 6 ). For the specific style of the achievement entity, the same method as the low-code text style is still used in the logical calculation process of the program. In the process of generating achievements, geological engineers can control the basic data source of the program input through the data table name and attribute column name, control the spacing between the underline and the graphic text through the layout method and offset, and use the style of the low-code text to generate the graphic drawing style. The geological engineer has full control authority in the process of outputting single-column data content.

[0094] The output method of special graphic data is personalized. We must analyze specific problems specifically and write independent algorithm logic for each special graphic data. The output logic of special graphic data is relatively complex, but fortunately, there are not many such data. In the output requirements of engineering geological bar chart results, there are generally three special data processing problems, namely the bar chart legend drawing problem, the core sampling rate line drawing problem, and the standard data block insertion problem. The method of drawing the bar chart legend is: the system determines the filling range according to the control depth, retrieves the corresponding legend name according to the geotechnical name, selects the fill color and ratio, and draws it in the CAD model space. In the above process, the data sources related to the fill shape are the control depth and geotechnical name columns of ZKBLSheet, which can be directly called through the low-code name in the template; the data sources related to the fill style are the color and legend drawing ratio, which need to be specified by the geological engineer. Therefore, we provide in the system ;Color type; To control the output results of the legend drawing column, where ZZTTL means calling the legend filling algorithm in the special graphics drawing algorithm. Indicates a special algorithm call; the color type indicates the color parameter for legend drawing. When the value is SingleColor, the color of the legend fill is determined by the low-code text color in the template file. When the value is not SingleColor, different colors will be selected for different strata. The legend scale parameter is used to control the fill ratio of the bar chart legend during the drawing process in the CAD model space. The drawing method for the core recovery rate polyline is as follows: the system determines the interval range for polyline drawing, calculates the horizontal length range corresponding to the unit recovery rate, determines the position of the recovery rate polyline hole point according to the control depth and CQL column of YRSheet, draws the recovery rate polyline and determines the style of the polyline. In the above process, the parameters related to the shape of the recovery rate polyline are the control depth and CQL column of YRSheet, which can be directly called through the low code in the template; the parameters related to the style are the color and line width of the recovery rate polyline, which need to be specified by the geological engineer. Therefore, we provide ; To control the output of the core recovery rate polyline, where YRLine represents the recovery rate polyline drawing algorithm that calls a special graphics drawing algorithm, the line width represents the global width of the drawn polyline, and the polyline color is determined by the low-code text color in the template file. The standard data block insertion method refers to drawing the standard shapes representing standard penetration, dynamic exploration, sampling and other data in a bar chart. The specific implementation algorithm is: obtain the data block type to be inserted and its associated data table, and determine the vertical insertion position of the block according to the control depth of the data table. Since multiple data columns may be inserted in one column of data, in order to prevent overlap, it is also necessary to determine the horizontal insertion position of the standard block, and then insert the data block at the corresponding position. In the above process, the standard block shape is determined by reading the preset block shape file in the system. If the geological engineer wants to control the standard block shape, he can manually edit the block shape file; the position parameters of the standard block are determined by the control depth column and the lateral offset of the corresponding data table, which need to be manually determined by the geological engineer. Therefore, we provide ;Data table name;Horizontal offset To control the generation of standard blocks, BlockInsert means calling the rate line drawing algorithm of the special graphics drawing algorithm, and the data table name represents the type of standard block to be inserted and its control depth. For example, DTSheet means that the inserted standard block is a dynamic exploration block, and the associated control depth value is the control depth column of DTSheet. The lateral offset represents the left and right offset values ​​of the standard block, and its calculation base point is the leftmost column of the insertion area data column. Based on the above low-code control logic, geological engineers have full control authority over the output process of special data content.

[0095] In the above process, we have realized the control of all data elements and input methods in the basic primitive template of the bar chart through low-code logic, so the geological engineer has all the control rights of the basic primitives of the bar chart. Before the system is running, the geological engineer can design a template data file (pre-processing process) containing the basic primitive shape, style, associated two-dimensional table data content and operation method based on the low-code principle. The computer will automatically parse the data content in the template file according to the preset code, call different operation methods (logical central process) according to different data, and output different basic primitive results of the bar chart to meet the different results requirements of geological engineers.

[0096] In some implementations, in the specific implementation process of step S13 of the present invention, the specific steps may be: a geological engineer designs the second type of data, and a computer acquires the second type of data and the first characteristic data. At this time, the second type of data is acquired, and the second type of data and the first characteristic data are subsequently processed. At this time, the second type of data also includes the project information data and the frame template data in the basic data.

[0097] In some embodiments, in the specific implementation process of the present invention, step S14 may include:

[0098] S141: Acquire the frame template data, the project information data and the first feature data;

[0099] S142: converting into a second CAD entity based on the drawing frame template data, the project information data and the first feature data; and S143: outputting the engineering drawing frame result based on the second CAD entity.

[0100] Specifically, the drawing frame template data, the project information data and the first characteristic data are introduced to facilitate the transformation of the drawing frame template data, the project information data and the first characteristic data to form a second CAD entity, and further output the engineering drawing frame results to ensure the accuracy of the engineering drawing frame results.

[0101] The frame template data includes fixed data content and single data content. In step S142, the fixed data content is converted into a second block reference; and the single data content is converted into an attribute value of the second block reference.

[0102] At this time, the engineering drawing frame results are applied to the engineering drawing frame processing module. The engineering drawing frame processing module aims to provide free design methods and automatic generation methods for engineering drawing frame results. The data of the engineering drawing frame processing module has three sources. The first is the project information data provided by the database module, the second is the frame template data provided by CAD (dwg file), and the third is the basic element quantity and basic element shape data provided by the bar chart basic element results.

[0103] Functional flow of engineering drawing frame processing module:

[0104] The implementation logic of the engineering drawing frame processing module is basically the same as that of the basic primitive module of the bar chart. It is still a design pre-processing process, which gives geological engineers the convenience of operating the drawing frame style independently. The design logic center process solves the template parsing and algorithm calling problems, and finally outputs the engineering drawing frame results. The difference between the two lies in the different data parameters.

[0105] Generally speaking, different companies have different standard drawing frame styles, but in general, we can decompose a project drawing frame into:

[0106] Outer border, inner border, drawing signature area, drawing page number area, graphic drawing area and other areas (for adding graphic descriptions or other data).

[0107] In the above-mentioned areas, the outer border, inner border, graphic drawing area and other areas all belong to fixed data content. We only need to read their shape data and style data as constants. The drawing signature contains fixed data and data content related to the project information and drawing number of the database module, which are all single data texts of the basic data primitives. The drawing page number area is also composed of fixed data content and single data text, but its data does not completely come from the database module. The attribute values ​​of its maximum signature page and minimum signature page are related to the number of inserted frames. In order to generate accurate engineering drawing frame results, when we insert the frame, we must calculate the required number of frames in advance. The number of inserted frames is not only related to the number and size of the basic primitives of the bar chart, but also to the size of the graphic drawing area and the outer frame size of the frame itself. Therefore, we must provide a method to calculate the relevant size data of the frame and the relevant size data of the basic primitives of the bar chart.

[0108] Based on the above logic, we designed a standard low-code A3 frame template, the fixed data content of the frame template, and the processing method of the single data content related to the database module (the single data content of the signature column, [TZBH] of the page number column).

[0109] A final engineering geological column chart result data includes two parts: the external frame and the internal column chart basic element entity. The specific number of frames = the number of column chart basic elements / the number of column chart elements that each frame can contain, rounded down. The number of column chart basic elements is determined by the drawing ratio and drawable height of the column chart basic elements; the number of column chart elements that each frame can contain is determined by the drawable area width of the frame and the drawing width of the column chart basic elements. Considering that the actual shapes of the column chart basic element template and the frame template are variable, as shown in the attached figure, Figure 8 The graphic drawing area of ​​the frame template completely overlaps with the inner frame of the frame, so we need a reference locator to help the program capture the specific calculation position. Starting from the spatial position of the $ASSISTPOSITION$ locator, this system obtains the basic required parameters for determining the number of frames (the outer frame rectangle range of the frame, the graphic drawing area range, and the single-case data filling range of the basic primitives of the bar chart), thereby determining the number of frames in the engineering results (that is, the attribute value corresponding to [ZYM] in the frame template), the attribute value corresponding to [DYQM] can be filled in with the corresponding values ​​in the order of frame insertion, and the arrangement of each frame in the CAD model space can be arranged according to the outer frame rectangle range of the frame.

[0110] Through the low-code engineering drawing frame template design, we have realized the parameterization of all figure metadata. The design process is operated by geological engineers themselves and belongs to the pre-processing process of the engineering drawing frame module. For the pre-processing data of the engineering drawing frame module, we calculate the specific number of frames and input the number of frames as parameters into the subsequent calculation process. This process is automatically calculated by the program, but it does not belong to the construction process of the CAD model entity. Here it is divided into the pre-processing process of the program. The analysis of the original data within the module and the call of the associated data and methods belong to the intermediate processing process (logical central process) of the module. After the design of the pre-processing process, the pre-processing process, and the algorithm processing of the intermediate process, we have realized the free design and automatic generation function of the engineering drawing frame.

[0111] In some embodiments, in the specific implementation of the present invention, step S15 may include:

[0112] S151: coupling the engineering drawing frame result and the bar graph basic element result in the CAD model space to generate the engineering geological bar graph;

[0113] The coupling process includes associating the engineering drawing frame results and the bar chart basic primitive results to the CAD model space, and neatly arranging the engineering drawing frame results and the bar chart basic primitive results in the CAD model space to generate the engineering geological bar chart, thereby realizing the automatic generation of engineering geological bar charts of any style and any data content.

[0114] At this time, low-code logic is introduced, and the first type of data and the basic data of the geological basic database are associated according to the low-code logic, and the basic graphic element results of the bar chart are generated, so as to generate the basic graphic element results of the bar chart in a low-code manner. At the same time, the first type of data is designed by the geological engineer, and the second type of data is designed by the geological engineer, which gives the geological engineer full opportunity to freely design the engineering drawing frame results and the basic graphic element results of the bar chart, so as to facilitate various styles of processing according to the ideas of the geological engineer, and then generate an engineering geological bar chart based on the engineering drawing frame results and the basic graphic element results of the bar chart, thereby realizing the automatic generation of engineering geological bar charts of any style, ensuring the diversity and versatility of the engineering geological bar chart results, so as to improve the work efficiency of geological engineers and the accuracy of the results data.

[0115] Specifically, the present invention expresses the advantages of the implementation of the scheme of the present invention through the bar graph generation process of a certain engineering case. The geomorphic unit of the engineering site is the I-level terrace and eroded residual hill landform, with a ground elevation of 58.5 to 73.3 m. The overlying covering layer is mainly planting soil, filling soil, silty clay, fine sand and sandy gravel layer, with a total thickness of about 0.2 to 15.0 m. The underlying bedrock is the mud siltstone of the Shenhuangshan Formation of the Lower Cretaceous System. Affected by the company's archiving, general standards, and expert needs, this project needs to provide three different engineering geological bar graph results. The basic requirements are shown in Table 1.

[0116] Table 1 Basic requirements table

[0117]

[0118] According to the basic requirements table, the data content is generalized as shown in Table 2.

[0119] Table 2 Basic demand data content division table

[0120]

[0121] Design low-code template files based on the data content division table of basic requirements. The templates are as follows Fig. 9 -Attached Fig.13 shown.

[0122] After completing the design of the template file, we can select the corresponding bar chart element template, associated frame template, and output method (fixed ratio output or drilling single page output) in the bar chart generation system to generate the corresponding bar chart. The comparison of the basic element results of the bar chart generated by the system is shown in the attached figure. Figure 14-16 ,in Fig.16 The small symbol marks in the fill legend are standard mark blocks for water level, sampling, and standard penetration dynamic exploration when the geological column chart is generated. The corresponding mark blocks are drawn in the legend. These mark blocks correspond to graphic algorithms, but they are not the purpose of the invention of this application. Instead, they are drawn in accordance with the requirements of geological professional drawing results.

[0123] Compare the basic primitive template of the bar chart with the output of the program (see attached Fig. 9 With attached Fig.14 ,Attached Fig.11 With attached Fig.15 , attached Fig.12 With attached Fig.16 ) It can be seen that geological engineers can design bar chart element templates of different shapes and different data contents according to the low-code principle. These data will be automatically parsed by the system and output the results corresponding to the template file to meet the different needs that geological engineers may encounter in their work.

[0124] Compare with Fig.14 ,15 , 16 It can be seen that the process of publishing the bar chart results can be done in two ways: single hole single sheet (automatically calculated by computer) and fixed scale (manually defined by geological engineers) to meet the publishing needs of different results. In addition, geological engineers can design the shape and data of the engineering frame based on the low-code principle. The computer will automatically parse the frame data, output the frame results, and associate it with the basic element results of the bar chart to generate the final results of the engineering geological bar chart.

[0125] In summary, this system divides the engineering geological bar chart results into two types of data: basic bar chart elements and engineering drawing frame basic elements, and sets low-code operation methods for each type of data, thereby giving geological engineers the ability to operate all data elements of engineering geological bar charts, allowing geological engineers to design required templates according to the requirements of the results, thereby realizing the automatic generation of geological maps of any style.

[0126] In the present invention, geological engineers can freely design basic graphic element templates and engineering drawing frame templates of bar charts according to the low-code method, and then the built-in program can automatically parse and associate to generate the final geological bar chart results.

[0127] In some embodiments, see Fig.17 , Fig.17 The present invention provides a system for generating an engineering geological histogram, which can optimize the satellite navigation baseband module by using the optimization methods of the above embodiments or other embodiments. The system specifically includes:

[0128] The first acquisition module 21 is used for a geological engineer to design the first type of data, and the computer acquires the first type of data; the first type of data includes histogram template data, and the histogram template data is independently designed by the geological engineer;

[0129] The first generating module 22 is used to associate the first type of data with the basic data of the geological basic database according to the low-code logic, and generate a bar chart basic graphic element result, wherein the bar chart basic graphic element result includes first characteristic data; the first characteristic data is parameter data in the bar chart basic graphic element result;

[0130] The second acquisition module 23 is used for the geological engineer to design the second type of data, and the computer acquires the second type of data and the first characteristic data; the second type of data includes the frame template data;

[0131] The second generating module 24 is used to generate an engineering drawing frame result based on the second type of data and the first characteristic data; and the bar graph module 25 is used to generate an engineering geological bar graph based on the engineering drawing frame result and the bar graph basic element result.

[0132] In some embodiments, see Fig.18 , refer to the following Fig.18 The electronic device 40 according to this embodiment of the present invention will be described. Fig.18 The electronic device 40 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0133] like Fig.18 As shown, the electronic device 40 is in the form of a general computing device. The components of the electronic device 40 may include but are not limited to: at least one processing unit 41, at least one storage unit 42, and a bus 43 connecting different system components (including the storage unit 42 and the processing unit 41).

[0134] The storage unit stores program codes, which can be executed by the processing unit 41, so that the processing unit 41 executes the steps according to various exemplary embodiments of the present invention described in the above “Embodiment Method” section of this specification.

[0135] The storage unit 42 may include a readable medium in the form of a volatile storage unit, such as a random access memory unit (RAM) 421 and / or a cache memory unit 422 , and may further include a read-only memory unit (ROM) 423 .

[0136] The storage unit 42 may also include a program / utility 424 having a set (at least one) of program modules 425, such program modules 425 including but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment.

[0137] Bus 43 may represent one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

[0138] The electronic device 40 may also communicate with one or more external devices (e.g., keyboards, pointing devices, Bluetooth devices, etc.), one or more devices that enable a trainee to interact with the electronic device 40, and / or any device that enables the electronic device 40 to communicate with one or more other computing devices (e.g., routers, modems, etc.). Such communication may be performed via an input / output (I / O) interface 44. Furthermore, the electronic device 40 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 45. Fig.18 As shown, the network adapter 45 communicates with other modules of the electronic device 40 via the bus 43. It should be understood that although Fig.11 Not shown, other hardware and / or software modules may be used in conjunction with the electronic device 40, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup planning systems.

[0139] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, and includes a number of instructions to enable a computing device (which can be a personal computer, a server, a terminal device, or a network device, etc.) to execute the method according to the implementation of the present disclosure.

[0140] Those skilled in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, and the storage medium can include: a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, etc. In addition, it stores computer program instructions, and when the computer program instructions are executed by a computer, the computer executes the above method.

[0141] In addition, the above method and system for generating an engineering geological column chart provided by the embodiment of the present invention are introduced in detail. Specific examples are used in this article to illustrate the principle and implementation mode of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation mode and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A method for generating an engineering geological histogram, characterized in that: include: The first type of data is designed by a geological engineer and acquired by a computer; the first type of data includes histogram template data, which is independently designed by the geological engineer; The first type of data and the basic data of the geological basic database are associated according to the low-code logic, and a bar chart basic graphic element result is generated, wherein the bar chart basic graphic element result includes first characteristic data; the first characteristic data is parameter data in the bar chart basic graphic element result; the basic data in the geological database includes exploration data and project data; The method of associating the first type of data and the basic data of the geological basic database according to the low-code logic and generating the basic primitive results of the bar chart specifically includes: in the low-code logic, calling the low-code template file to combine the low-code template file, the bar chart template data and the basic data of the geological basic database, so as to generate the basic primitive results of the bar chart in a low-code manner; wherein the bar chart template data is provided by the dwg file of CAD, and the bar chart template data includes fixed graphic data, single data content, single column data content and special data content; converting the fixed graphic data into a first block reference; converting the single data content into the attribute value of the first block reference; converting the single column data content into a first independent entity; and converting the The special data content is converted into a second independent entity; the first block reference, the attribute value of the first block reference, the first independent entity and the second independent entity are integrated in the low-code template file and converted into a first CAD entity, and the basic primitive result of the bar chart is output based on the first CAD entity; the fixed graphic data is used to determine the line segment content of the specific shape of the bar chart and the specific style of the text content and the line segment content, which is the common data attribute of all bar chart results, that is, the template style data in the program calculation process; the single data content is the specific geological data and project data imported by the database module; the single column data content is the attribute value corresponding to the corresponding attribute of the attribute table read from the database, and the special data content is the bar chart legend, the core recovery rate polyline and the inserted standard data block; The second type of data is designed by a geological engineer, and the computer obtains the second type of data and the first characteristic data; the second type of data includes drawing frame template data and project information data in the basic data; the drawing frame template data is provided by the dwg file of the CAD; Based on the second type of data and the first characteristic data, an engineering drawing frame result is generated; and based on the engineering drawing frame result and the histogram basic element result, an engineering geological histogram is generated; wherein, the engineering drawing frame result is generated based on the second type of data and the first characteristic data, specifically including: Acquire the drawing frame template data, the project information data and the first feature data, wherein the drawing frame template data includes fixed data content and single data content, convert the fixed data content into a second block reference; and convert the single data content into an attribute value of the second block reference to form a second CAD entity, and output the engineering drawing frame result based on the second CAD entity; Wherein, generating an engineering geological column chart based on the engineering drawing frame result and the column chart basic graphic element result includes: coupling the engineering drawing frame result and the column chart basic graphic element result in the CAD model space to generate the engineering geological column chart; the coupling process includes associating the engineering drawing frame result and the column chart basic graphic element result to the CAD model space, and neatly arranging the engineering drawing frame result and the column chart basic graphic element result in the CAD model space to generate the engineering geological column chart; Before the system is run, a low-code template file is designed according to the data content division table of basic requirements. Based on the low-code principles, geological engineers design template data files including basic graphic element shapes, styles, related two-dimensional table data content and operation methods. In the bar chart generation system, the corresponding bar chart element template, related frame template and output method are selected. Then the computer automatically parses the data content in the template file according to the preset code, calls different operation methods according to different data, and outputs different bar chart basic element results to generate the corresponding bar chart.

2. The method for generating an engineering geological histogram according to claim 1, characterized in that: Before the geological engineer designs the first type of data and the computer acquires the first type of data, a geological basic database is constructed. The method for constructing the geological basic database includes: Entering the basic data; The basic data is expanded by single-table expansion and / or multi-table expansion to form associated data; and the basic data and the associated data are collected to form the geological basic database.

3. A system for generating an engineering geological column chart, characterized in that: Using the method for generating an engineering geological column diagram as claimed in claim 1 or 2, the system comprises: A first acquisition module is used for a geological engineer to design a first type of data, and a computer acquires the first type of data; the first type of data includes a bar chart template data, and the bar chart template data is independently designed by the geological engineer; A first generation module is used to associate the first type of data with the basic data of the geological basic database according to the low-code logic, and generate a bar chart basic graphic element result, wherein the bar chart basic graphic element result includes first feature data; the first feature data is parameter data in the bar chart basic graphic element result; the basic data in the geological database includes exploration data and project data; The method of associating the first type of data and the basic data of the geological basic database according to the low-code logic and generating the basic primitive results of the bar chart specifically includes: in the low-code logic, calling the low-code template file to combine the low-code template file, the bar chart template data and the basic data of the geological basic database, so as to generate the basic primitive results of the bar chart in a low-code manner; wherein the bar chart template data is provided by the dwg file of CAD, and the bar chart template data includes fixed graphic data, single data content, single column data content and special data content; converting the fixed graphic data into a first block reference; converting the single data content into the attribute value of the first block reference; converting the single column data content into a first independent entity; and converting the The special data content is converted into a second independent entity; the first block reference, the attribute value of the first block reference, the first independent entity and the second independent entity are integrated in the low-code template file and converted into a first CAD entity, and the basic primitive result of the bar chart is output based on the first CAD entity; the fixed graphic data is used to determine the line segment content of the specific shape of the bar chart and the specific style of the text content and the line segment content, which is the common data attribute of all bar chart results, that is, the template style data in the program calculation process; the single data content is the specific geological data and project data imported by the database module; the single column data content is the attribute value corresponding to the corresponding attribute of the attribute table read from the database, and the special data content is the bar chart legend, the core recovery rate polyline and the inserted standard data block; The second acquisition module is used for the geological engineer to design the second type of data, and the computer acquires the second type of data and the first characteristic data; the second type of data includes the drawing frame template data and the project information data in the basic data; the drawing frame template data is provided by the CAD dwg file; The second generation module is used to generate an engineering drawing frame result based on the second type of data and the first characteristic data; and to generate an engineering geological column chart based on the engineering drawing frame result and the column chart basic element result; wherein the generation of the engineering drawing frame result based on the second type of data and the first characteristic data specifically includes: Acquire the drawing frame template data, the project information data and the first feature data, wherein the drawing frame template data includes fixed data content and single data content, convert the fixed data content into a second block reference; and convert the single data content into an attribute value of the second block reference to form a second CAD entity, and output the engineering drawing frame result based on the second CAD entity; Wherein, generating an engineering geological column chart based on the engineering drawing frame result and the column chart basic graphic element result includes: coupling the engineering drawing frame result and the column chart basic graphic element result in the CAD model space to generate the engineering geological column chart; the coupling process includes associating the engineering drawing frame result and the column chart basic graphic element result to the CAD model space, and neatly arranging the engineering drawing frame result and the column chart basic graphic element result in the CAD model space to generate the engineering geological column chart; Before the system is run, a low-code template file is designed according to the data content division table of basic requirements. Based on the low-code principles, geological engineers design template data files including basic graphic element shapes, styles, related two-dimensional table data content and operation methods. In the bar chart generation system, the corresponding bar chart element template, related frame template and output method are selected. Then the computer automatically parses the data content in the template file according to the preset code, calls different operation methods according to different data, and outputs different bar chart basic element results to generate the corresponding bar chart.

Images