Drilling histogram generation method, system and device

Abstract

The present invention discloses a method, system and device for generating a borehole histogram, comprising sending a drawing request and a drawing standard request to a NodeJS cloud server; responding to the drawing request, querying borehole data, and returning a drawing json data group; responding to the drawing standard request, retrieving a soil layer vector legend corresponding to the borehole to be drawn; according to the drawing json data group, drawing a borehole histogram using the soil layer vector legend, and marking the text description of the borehole to be drawn in the borehole histogram, and outputting the borehole histogram file; the present invention uses rendering on a NodeJS cloud server to generate a borehole histogram, which can ensure that the borehole histogram generated by the same data source has the same drawing effect and drawing efficiency on any configured client; through the cloud configuration and preset drawing standards of the NodeJS cloud server, the identification differences when different personnel operate are effectively eliminated, and a standard unified, editable and reusable borehole histogram can be obtained.

Description

Technical Field

[0001] The present invention belongs to the cross-technical field of computer information technology and geology, and in particular relates to a method, system and equipment for generating a borehole column chart. Background Art

[0002] Borehole column charts are widely used in geological research and engineering practice. They are the most intuitive way for geologists to identify and study changes in stratum lithology. They are usually drawn and edited using large commercial software such as CAD and GIS, and are also automatically drawn using desktop applications or web programs that integrate data management functions.

[0003] The existing technology has four major defects. First, manual drawing is cumbersome and labor-intensive, and there is an inevitable risk of errors or omissions. Second, when different users operate, due to changes in reference standards, there are inconsistencies in scales, legend filling, stratigraphic age identification, etc. between borehole column charts, which increases the workload of secondary combination to form geological profiles. Third, desktop applications or web programs have requirements for client configuration. Desktop applications require users to install and configure software, which is cumbersome to operate. Web programs may have different response times in different client configurations, and even inconsistent mapping effects may occur on some clients with large differences in hardware configurations. Fourth, web programs can often only generate regular image format files, which are difficult to directly use for secondary use in engineering software such as CAD and ARCGIS. Summary of the invention

[0004] In view of the technical problems existing in the prior art, the present invention provides a method, system and device for generating a drilling bar graph to solve the technical problems of low mapping efficiency, inconsistent mapping standards and inability to achieve secondary utilization in the existing drilling bar graph generation process.

[0005] In order to achieve the above object, the technical solution adopted by the present invention is:

[0006] The present invention provides a method for generating a drilling histogram, comprising the following steps:

[0007] Send drawing requests and drawing standard requests to the NodeJS cloud server;

[0008] Respond to drawing requests, query drilling data, and return drawing json data group;

[0009] In response to the request for mapping standards, the soil layer vector diagram corresponding to the borehole to be mapped is retrieved;

[0010] According to the drawing json data group, a borehole histogram is drawn using the soil layer vector diagram legend, and the text description of the borehole to be drawn is marked in the borehole histogram, and the borehole histogram file is output.

[0011] Furthermore, it also includes:

[0012] Send modification request to NodeJS cloud server;

[0013] In response to the modification request, the drawing json data group is overwritten to obtain the modified drawing json data group;

[0014] According to the modified drawing json data group, a modified drilling histogram file is drawn.

[0015] Furthermore, a drawing request and a drawing standard request are sent to a NodeJS cloud server through a client; the client is a WEB browser, a mobile browser or a desktop application.

[0016] Furthermore, the process of sending the drawing request to the NodeJS cloud server through the client is specifically as follows: using the filtering method provided by the client page, the borehole number to be drawn is sent as the drawing request to the NodeJS cloud server; wherein the filtering method provided by the client page is a map point selection method or a borehole number query method;

[0017] The process of sending a drawing standard request to a NodeJS cloud server through a client is specifically as follows: using the drawing standard option provided by the client page to send the drawing standard request to the NodeJS cloud server.

[0018] Furthermore, the process of responding to the drawing request, querying the borehole data, and returning the drawing json data group is as follows: according to the drawing request, the NodeJS cloud server searches the drilling parameters and soil layer data of the borehole to be drawn from the drawing database, and writes the drilling parameters and soil layer data of the borehole to be drawn into the json array to obtain the drawing json data group;

[0019] The process of responding to the mapping standard request and retrieving the soil layer vector legend corresponding to the borehole to be drawn is as follows: according to the mapping standard request, the NodeJS cloud server searches the soil layer vector legend corresponding to the borehole to be drawn from the drawing database; wherein the legend group and the drawing scale are used as the mapping standard request.

[0020] Furthermore, according to the drawing json data group, the process of drawing the borehole histogram using the soil layer vector diagram is as follows:

[0021] According to the drilling parameters of the borehole to be drawn and the drawing scale in the drawing standard request, fill in the corresponding soil layer vector legends from the ground downward in sequence; and according to the soil layer data of the borehole to be drawn, adjust the height of each soil layer vector legend to obtain a borehole bar chart.

[0022] Furthermore, the textual description of the borehole to be mapped includes the lithology of the strata, the thickness of the soil layer and the age and genesis of the soil layer.

[0023] Furthermore, the process of outputting the drilling histogram file is specifically as follows:

[0024] Send the image format request to the NodeJS cloud server;

[0025] In response to the drawing format request, a drilling histogram file of the corresponding format is generated and returned to the client for storage.

[0026] The present invention also provides a drilling histogram generation system, including a sending request module, a response module and a drawing output module;

[0027] Send request module, used to send drawing requests and drawing standard requests to NodeJS cloud server;

[0028] The response module is used to respond to drawing requests, query borehole data, and return drawing json data groups; respond to mapping standard requests, and retrieve the soil layer vector legend corresponding to the borehole to be drawn;

[0029] The drawing output module is used to draw a drilling histogram according to the drawing json data group using the drilling histogram vector legend, and mark the text description of the drilling to be drawn in the drilling histogram, and output the drilling histogram file.

[0030] The present invention also provides a drilling bar chart generating device, characterized in that it includes a memory, a processor and executable instructions stored in the memory and executable in the processor; when the processor executes the executable instructions, the drilling bar chart generating method is implemented.

[0031] Compared with the prior art, the present invention has the following beneficial effects:

[0032] The present invention provides a method, system and device for generating a drilling histogram, which sends a drawing request and a drawing standard to a NodeJS cloud server, and uses the NodeJS cloud server to render and draw according to a data source; since the hardware and software environment of the NodeJS cloud server is fixed, the drawing effect and efficiency are determined by the cloud environment; through the cloud configuration and preset drawing standards of the NodeJS cloud server, the identification differences when different operators operate are effectively eliminated, and a drilling histogram with unified standards that can be edited and reused can be obtained, which can ensure that the drilling histograms generated from the same data source have the same drawing effect and efficiency.

[0033] Furthermore, by sending a modification request to the NodeJS cloud server, the drawing json data group is overwritten, and the modified drawing json data group is used for drawing, the modification parameters entered by the user are separated from the cloud data, ensuring the stability and security of the original data in the cloud data.

[0034] Furthermore, a drilling histogram of a corresponding format is generated in the NodeJS cloud server according to the set drawing format, and the output of various image formats or engineering file formats is realized, which is convenient for the secondary use of the drilling histogram. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 The figure is a schematic flow chart of the method for generating a drilling histogram according to the present invention. DETAILED DESCRIPTION

[0036] In order to make the technical problems, technical solutions and beneficial effects solved by the present invention more clearly understood, the present invention is further described in detail in the following specific embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0037] The present invention provides a method for generating a drilling histogram, comprising the following steps:

[0038] Step 1. Send a drawing request to the NodeJS cloud server through the client; the NodeJS cloud server responds to the drawing request, and queries the drilling data of the borehole to be drawn in the drilling data table in the drawing database; the drilling data includes drilling parameters and soil layer data; and writes the drilling parameters and soil layer data of the borehole to be drawn into a json array to obtain a drawing json data group.

[0039] In the present invention, the filtering method provided by the client page is used to send the borehole number to be drawn as a drawing request to the NodeJS cloud server; wherein the filtering method provided by the client page is a map point selection method or a borehole number query method.

[0040] The drilling parameters of the borehole to be mapped include the borehole coordinates, the borehole ground elevation, the borehole depth, the attributes of the geomorphic unit to which the borehole belongs, the collapsibility grade of the area to which the borehole belongs, the borehole stable water level, the borehole opening / ending date and the borehole standard penetration test parameters; the soil layer data of the borehole to be mapped include the thickness of each soil layer in the borehole, the age and origin of the soil layer, the soil layer number, the soil layer name, the soil layer color, the soil layer description and the physical and mechanical parameters of the soil layer.

[0041] Step 2: Send a drawing standard request to the NodeJS cloud server through the client. The NodeJS cloud server responds to the drawing standard request and retrieves the soil layer vector legend corresponding to the borehole to be drawn in the drawing data table of the drawing database. In the present invention, the drawing standard option provided by the client page is used to send the drawing standard request to the NodeJS cloud server. Among them, the legend group and the drawing scale are used as the drawing standard request.

[0042] Step 3: According to the drawing json data group, a borehole histogram is obtained by using the soil layer vector diagram legend, and the text description of the borehole to be drawn is marked in the borehole histogram, and the borehole histogram file is output.

[0043] In the present invention, the process of obtaining a borehole bar chart by using a soil layer vector diagram legend is specifically as follows: according to the drilling parameters of the borehole to be drawn and the drawing scale in the drawing standard request, the corresponding soil layer vector diagram legends are filled in from the ground downward in sequence; and according to the soil layer data of the borehole to be drawn, the height of each soil layer vector diagram legend is adjusted to obtain a borehole bar chart.

[0044] The process of marking the text description of the borehole to be drawn in the borehole column chart is specifically to mark the various soil layers of the borehole column chart with the text description of the borehole to be drawn using a preset font or font size style; wherein the preset font or font size style is selected and determined in the client; the text description of the borehole to be drawn includes stratum lithology, soil layer thickness, soil layer age and cause and standard penetration test results.

[0045] The process of outputting the drilling histogram file is specifically as follows: sending a drawing format request to a NodeJS cloud server through a client page; responding to the drawing format request, generating a drilling histogram file in a corresponding format, and returning it to the client for storage.

[0046] Step 4. Modify the generated borehole histogram. Use the borehole histogram page generated on the client, click the modify button, and send a modification request to the NodeJS cloud server. The NodeJS cloud server responds to the modification request, overwrites the drawing json data group, and obtains the modified drawing json data group. According to the modified json data group, the borehole histogram is drawn using the soil layer vector legend, and the text description of the borehole to be drawn is marked in the borehole histogram, and the modified borehole histogram file is output.

[0047] In the present invention, the client is a WEB browser, a mobile browser or a desktop application; wherein the mobile browser includes an Android mobile browser or an IOS mobile browser; the drawing database adopts the MySQL open source database, and according to the requirements of drilling bar chart drawing, the database table structure and field design of the MySQL open source database are modified.

[0048] The method for generating a drill bar chart of the present invention uses rendering on a NodeJS cloud server to generate a drill bar chart, which can ensure that a drill bar chart generated by the same data source has the same drawing effect and efficiency on any configured client; through the cloud configuration and preset mapping standards of the NodeJS cloud server, the identification differences when different personnel operate are effectively eliminated, and a standard unified, editable and reusable drill bar chart can be obtained.

[0049] The present invention is suitable for generating a borehole histogram in a geological information system or geological desktop software based on network services or cloud services; the mapping standards are consistent, the client configuration is simple, the mapping effects have little difference, and the function of automatically generating, modifying and saving a borehole histogram in a secondary reusable format in the cloud is realized; in the present invention, a modification input box is provided to the user in the client operation interface, the modification content submitted by the user is transmitted to the cloud to cover the borehole and soil layer data group, and the borehole histogram is redrawn, so as to realize the real-time modification of the borehole histogram.

[0050] The method for generating a borehole histogram of the present invention utilizes a NodeJS cloud server and adopts a B / S network architecture mode, is applicable to various cloud environments and cross-platform deployments, and is operated by a client using a WEB browser, a mobile browser or a desktop program software, and is simple to operate; data access and drawing of a borehole histogram are performed on the NodeJS cloud server, and the response speed is fast, the drawing effect is stable, and it is not affected by the configuration of the client device; when the borehole histogram is modified for the second time, the modification parameters input by the user are separated from the cloud database, and the stability and security of the original data of the database can be guaranteed; using a unified mapping standard confirmed by the user, the scale, legend, font size, etc. of the drawn borehole histogram are consistent, and can be directly used for drawing engineering geological profiles without secondary processing; the borehole histogram drawn in the cloud can be output to various commonly used image formats or engineering file formats such as CAD and shape.

[0051] The present invention also provides a borehole histogram generation system, including a sending request module, a response module and a drawing output module; the sending request module is used to send a drawing request and a drawing standard request to a NodeJS cloud server; the response module is used to respond to the drawing request, query the drilling data, and return a drawing json data group; respond to the drawing standard request, and retrieve the soil layer vector legend corresponding to the borehole to be drawn; the drawing output module is used to draw a borehole histogram according to the drawing json data group using the borehole histogram vector legend, and mark the text description of the borehole to be drawn in the borehole histogram, and output the borehole histogram file.

[0052] The present invention also provides a drilling histogram generation device, the drilling histogram generation device comprising a processor, a memory, and a computer program stored in the memory and executable on the processor, such as a drilling histogram generation program. When the processor executes the computer program, the steps in the drilling histogram method are implemented, such as the following steps:

[0053] Send drawing requests and drawing standard requests to the NodeJS cloud server;

[0054] Respond to drawing requests, query drilling data, and return drawing json data group;

[0055] In response to the request for mapping standards, the soil layer vector diagram corresponding to the borehole to be mapped is retrieved;

[0056] According to the drawing json data group, a borehole histogram is drawn using the soil layer vector diagram legend, and the text description of the borehole to be drawn is marked in the borehole histogram, and the borehole histogram file is output.

[0057] Alternatively, when the processor executes the computer program, the functions of each module in the above-mentioned borehole bar chart generating device are implemented, for example: a sending request module, used to send a drawing request and a drawing standard request to a NodeJS cloud server; a response module, used to respond to the drawing request, query the drilling data, and return a drawing json data group; respond to the drawing standard request, and retrieve the soil layer vector legend corresponding to the borehole to be drawn; a drawing output module, used to draw a borehole bar chart according to the drawing json data group using the borehole bar chart vector legend, and mark the text description of the borehole to be drawn in the borehole bar chart, and output the borehole bar chart file.

[0058] Exemplarily, the computer program may be divided into one or more modules, which are stored in the memory and executed by the processor to implement the present invention. The one or more modules may be a series of computer program instruction segments capable of implementing specific functions, and the instruction segments are used to describe the execution process of the computer program in the drilling histogram generating device.

[0059] For example, the computer program can be divided into a data module, a legend module and a drawing module, and the specific functions of each module are as follows: a sending request module, used to send drawing requests and drawing standard requests to a NodeJS cloud server; a response module, used to respond to drawing requests, query drilling data, and return a drawing json data group; respond to drawing standard requests, and retrieve the soil layer vector legend corresponding to the borehole to be drawn; a drawing output module, used to draw a borehole histogram based on the drawing json data group and the borehole histogram vector legend, and mark the text description of the borehole to be drawn in the borehole histogram, and output the borehole histogram file.

[0060] The drilling bar graph generating device may be a computing device such as a desktop computer, a notebook, a PDA, and a cloud server. The drilling bar graph generating device may include, but is not limited to, a processor and a memory. Those skilled in the art may understand that the above is only an example of a drilling bar graph generating device and does not constitute a limitation on the drilling bar graph generating device. The drilling bar graph generating device may include more or fewer components, or a combination of certain components, or different components. For example, the drilling bar graph generating device may also include an input and output device, a network access device, and a bus.

[0061] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc. The processor is the control center of the drilling histogram generating device, and uses various interfaces and lines to connect various parts of the entire drilling histogram generating device.

[0062] The memory can be used to store the computer program and / or module, and the processor realizes various functions of the drilling histogram generating device by running or executing the computer program and / or module stored in the memory and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the data storage area can store data created according to the use of the mobile phone (such as audio data, a phone book, etc.), etc.

[0063] In addition, the memory may include high-speed random access memory and may also include non-volatile memory, such as a hard disk, an internal memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0064] If the module integrated in the drilling histogram generating device is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium.

[0065] Based on such understanding, the present invention implements all or part of the processes in the above-mentioned drilling histogram generation method, and can also be completed by instructing related hardware through a computer program, and the computer program can be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the above-mentioned drilling histogram generation method can be implemented. Wherein, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form, etc.

[0066] The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal and software distribution medium, etc.

[0067] It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media does not include electrical carrier signals and telecommunication signals.

[0068] Example

[0069] As attached Figure 1 As shown, this embodiment provides a method for generating a drilling histogram, including data retrieval, vector legend retrieval, drilling histogram drawing, modification and saving; the specific steps are as follows:

[0070] Step 1: Deploy the NodeJS cloud server system; wherein, the hardware environment and software environment of the NodeJS cloud server are set; the hardware environment includes the deployment of various computer hardware and network environments that meet the computing power and concurrent processing capabilities, and the software environment includes the setting of the drawing database, the image operation interface for user operation, and the calculation program for data processing and drawing.

[0071] Using the filtering method provided by the client page, the number of the borehole to be drawn is sent as a drawing request to the NodeJS cloud server; the NodeJS cloud server responds to the drawing request, queries the drilling data table in the drawing database, and searches for the drilling data of the borehole to be drawn; the drilling data of the borehole to be drawn includes drilling parameters and soil layer data; and the drilling parameters and soil layer data of the borehole to be drawn are written into a json array to obtain a json data group.

[0072] In this embodiment, the data written into the json array include: borehole coordinates, borehole ground elevation, borehole depth, attributes of the geomorphic unit to which the borehole belongs, the collapsibility grade of the area to which the borehole belongs, the stable water level of the borehole, the standard penetration test parameters of the borehole, the date of opening / ending the borehole, the thickness of each soil layer in the borehole, the age and causes of the soil layer, the soil layer number, the soil layer name, the soil layer color, the soil layer description and the physical and mechanical parameters of the soil layer; wherein, the borehole parameters of the borehole to be drawn include the borehole coordinates, the borehole ground elevation, the borehole depth, attributes of the geomorphic unit to which the borehole belongs, the collapsibility grade of the area to which the borehole belongs, the stable water level of the borehole, the date of opening / ending the borehole and the standard penetration test parameters of the borehole; the soil layer data of the borehole to be drawn include the thickness of each soil layer in the borehole, the age and causes of the soil layer, the soil layer number, the soil layer name, the soil layer color, the soil layer description and the physical and mechanical parameters of the soil layer.

[0073] Step 2. According to the drilling column chart drawing standard determined by the user, the drawing standard option provided by the client page is used to send the drawing standard request to the NodeJS cloud server; the NodeJS cloud server responds to the drawing standard request and retrieves the soil layer vector legend corresponding to the drilling hole to be drawn in the drawing data table of the drawing database; wherein the drawing standard request includes a legend group and a drawing scale, and the drawing data table is used to store the soil layer vector legend.

[0074] Step 3, according to the drawing json data group, using the drilling parameters of the borehole to be drawn, according to the drawing scale in the drawing standard request, fill in the corresponding soil layer vector legends from the ground downward in sequence; and according to the soil layer data of the borehole to be drawn, adjust the height of each soil layer vector legend to obtain a borehole bar chart; in this embodiment, according to the drawing standard (legend group, vertical and horizontal scales) selected by the client user, the corresponding borehole bar chart vector legend is retrieved from the drawing database, and the vector legend corresponding to each soil layer is adjusted according to the thickness data of the soil layer, and the borehole bar chart is spliced ​​from top to bottom on the NodeJS cloud server.

[0075] The text description of the borehole to be drawn is used to mark each soil layer of the borehole column chart using a preset font or font size style; a drawing format request is sent to the NodeJS cloud server through the client page; in response to the drawing format request, a borehole column chart file of the corresponding format is generated and returned to the client for storage; wherein, the preset font or font size style is selected and determined in the client; the text description of the borehole to be drawn includes stratum lithology, soil layer thickness, soil layer age and genesis, and standard penetration test results.

[0076] In this embodiment, the borehole bar chart is a schematic diagram that reflects the spatial position relationship of each soil layer in the borehole and the physical and mechanical properties of each soil layer; the directly retrieved soil layer vector diagram is standardized, and the size (width and height) of each soil layer vector diagram is consistent; the corresponding soil layer vector diagram is height-adjusted according to the thickness of each soil layer, which can truly reflect the spatial relationship of each soil layer in the borehole.

[0077] Step 4, modify the generated borehole histogram, use the borehole histogram page generated on the client, click the modify button, and send a modification request to the NodeJS cloud server; the NodeJS cloud server responds to the modification request, overwrites the drawing json data group, and obtains the modified drawing json data group; and according to the modified json data group, the soil layer vector legend is used to draw the borehole histogram, and the text description of the borehole to be drawn is marked in the borehole histogram, and the modified borehole histogram file is output; in this embodiment, a modification input box is provided to the user in the client operation interface, and the modification content submitted by the user is passed to the cloud to overwrite the drawing json data group, and the borehole histogram is redrawn according to steps 2-3, so as to realize the real-time modification of the borehole histogram; after the modification, according to the drawing format selected by the user, the corresponding picture or engineering file format is generated in the NodeJs cloud, and returned to the client for local storage.

[0078] In this embodiment, the client is a WEB browser, a mobile browser or a desktop application; wherein the mobile browser includes an Android mobile browser or an IOS mobile browser; the drawing database adopts the MySQL open source database, and according to the requirements of the drilling bar chart drawing, the database table structure and field design of the MySQL open source database are modified.

[0079] In this embodiment, the borehole bar chart is composed of vector diagrams of each soil layer in the borehole in sequence. The vector diagram legends are retrieved according to the borehole parameters, and the heights of the vector diagram legends of each soil layer are adjusted according to the soil layer data, so as to splice and form the borehole bar chart. Among them, according to the soil layer number in the drawing json data group, the corresponding vector diagram legend can be directly obtained from the drawing database. The soil layer vector diagram legend is used to ensure that when the scale and drawing size are adjusted, the drawing is always clear and identifiable without distortion. By determining the borehole number and drawing scale to be drawn, the style of text annotations displayed on the borehole bar chart is determined according to user needs, so as to realize the display of text annotations, soil layer physical and mechanical properties and other annotations on the borehole bar chart.

[0080] The drilling bar chart generation method and system described in this embodiment, the drawing effect and drawing efficiency of the drilling bar chart are determined by the cloud computer hardware and software environment; the cloud computer hardware and software environment are fixed, so the cloud is used for rendering. As long as the data source is the same, the drawing effect and drawing efficiency are determined by the cloud environment and are independent of the client hardware and software conditions, thus ensuring consistent drawing effect and stable drawing efficiency.

[0081] The description of the relevant parts of the drilling histogram generation system and device provided in this embodiment can refer to the detailed description of the corresponding parts of the drilling histogram generation method described in this embodiment, which will not be repeated here.

[0082] The method for generating a borehole histogram of the present invention deploys a system in the cloud, selects a borehole for which a histogram is to be drawn through a WEB page or a desktop program entry, passes the borehole number obtained by the client as a parameter to the cloud, queries the borehole database through the cloud service and returns a drawing json data group; retrieves the corresponding soil layer vector legend from the database according to the borehole histogram drawing standard selected by the user, fills in the soil layer vector legend from the ground downward in sequence according to the drawing scale in the drawing standard, and adjusts the legend height according to the thickness of each soil layer; annotates the standard penetration test, soil layer age and cause, stratum lithology and other text descriptions on the borehole histogram according to the drawing json data group; on the generated borehole histogram page, click Click the modify button, fill in the parameters that need to be modified (stratum lithology, soil layer thickness, soil layer age and cause, standard penetration test and other text descriptions), pass the modified parameters to the cloud to overwrite the drawing json data group, and redraw the borehole column chart; according to the drawing format selected by the user, generate a file in the corresponding format in the cloud and return it to the user end for storage; in the present invention, the secondary modification of the borehole column chart adopts the modification of the drawing json array generated after the user's call operation, and the drawing json array is an intermediate temporary storage array. The modification of the drawing json array will not affect the original data of the database, thereby ensuring the security of the original data and avoiding permanent damage to the original data of the database caused by user misoperation.

[0083] The above embodiment is only one of the implementation methods that can realize the technical solution of the present invention. The scope of protection claimed by the present invention is not limited only to this embodiment, but also includes changes, replacements and other implementation methods that can be easily thought of by any technician familiar with the technical field within the technical scope disclosed by the present invention.

Claims

1. A method for generating a drilling histogram, characterized in that: The following steps are involved: Send drawing requests and drawing standard requests to the NodeJS cloud server; Respond to drawing requests, query drilling data, and return drawing json data group; In response to the request for mapping standards, the soil layer vector diagram corresponding to the borehole to be mapped is retrieved; According to the drawing json data group, a borehole histogram is obtained by using the soil layer vector diagram legend, and the text description of the borehole to be drawn is marked in the borehole histogram, and the borehole histogram file is output; Send modification request to NodeJS cloud server; In response to the modification request, the drawing json data group is overwritten to obtain the modified drawing json data group; According to the modified drawing json data group, a modified drilling histogram file is drawn; The process of responding to drawing requests, querying drilling data, and returning drawing json data groups is as follows: according to the drawing request, the NodeJS cloud server searches for the drilling parameters and soil layer data of the borehole to be drawn from the drawing database, and writes the drilling parameters and soil layer data of the borehole to be drawn into the json array to obtain the drawing json data group; The process of responding to the mapping standard request and retrieving the soil layer vector legend corresponding to the borehole to be drawn is as follows: according to the mapping standard request, the NodeJS cloud server searches the soil layer vector legend corresponding to the borehole to be drawn from the drawing database; wherein the legend group and the drawing scale are used as the mapping standard request.

2. A method for generating a drilling histogram according to claim 1, characterized in that: Drawing requests and drawing standard requests are sent to the NodeJS cloud server through the client; the client is a WEB browser, mobile browser or desktop application.

3. A method for generating a drilling histogram according to claim 2, characterized in that: The process of sending a drawing request to the NodeJS cloud server through the client is specifically as follows: using the filtering method provided by the client page, the borehole number to be drawn is used as a drawing request and sent to the NodeJS cloud server; wherein the filtering method provided by the client page is a map point selection method or a borehole number query method; The process of sending a drawing standard request to a NodeJS cloud server through a client is specifically as follows: using the drawing standard option provided by the client page to send the drawing standard request to the NodeJS cloud server.

4. A method for generating a drilling histogram according to claim 1, characterized in that: According to the drawing json data group, the process of drawing the borehole histogram using the soil layer vector legend is as follows: According to the drilling parameters of the borehole to be drawn and the drawing scale in the drawing standard request, fill in the corresponding soil layer vector legends from the ground downward in sequence; and according to the soil layer data of the borehole to be drawn, adjust the height of each soil layer vector legend to obtain a borehole bar chart.

5. A method for generating a drilling histogram according to claim 1, characterized in that: The text description of the borehole to be mapped includes the lithology, thickness of the soil layer and the age and origin of the soil layer.

6. A method for generating a drilling histogram according to claim 1, characterized in that: The process of outputting the drilling histogram file is specifically as follows: Send the image format request to the NodeJS cloud server; In response to the drawing format request, a drilling histogram file of the corresponding format is generated and returned to the client for storage.

7. A drilling histogram generation system, characterized in that: It includes a sending request module, a response module and a drawing output module; Send request module, used to send drawing requests and drawing standard requests to NodeJS cloud server; The response module is used to respond to drawing requests, query borehole data, and return drawing json data groups; respond to mapping standard requests, and retrieve the soil layer vector legend corresponding to the borehole to be drawn; A drawing output module is used to draw a drilling histogram according to the drawing json data group using the drilling histogram vector legend, and mark the text description of the drilling to be drawn in the drilling histogram, and output the drilling histogram file; Send modification request to NodeJS cloud server; In response to the modification request, the drawing json data group is overwritten to obtain the modified drawing json data group; According to the modified drawing json data group, a modified drilling histogram file is drawn; The process of responding to drawing requests, querying drilling data, and returning drawing json data groups is as follows: according to the drawing request, the NodeJS cloud server searches for the drilling parameters and soil layer data of the borehole to be drawn from the drawing database, and writes the drilling parameters and soil layer data of the borehole to be drawn into the json array to obtain the drawing json data group; The process of responding to the mapping standard request and retrieving the soil layer vector legend corresponding to the borehole to be drawn is as follows: according to the mapping standard request, the NodeJS cloud server searches the soil layer vector legend corresponding to the borehole to be drawn from the drawing database; wherein the legend group and the drawing scale are used as the mapping standard request.

8. A drilling histogram generating device, characterized in that: The method comprises a memory, a processor and executable instructions stored in the memory and executable in the processor; when the processor executes the executable instructions, the method according to any one of claims 1 to 6 is implemented.

Images