A method and system for online analysis of core drilling data
By adopting cloud server and blockchain technology in the drill core method, online analysis and management of drill core data is realized, solving the problem of in real-time on-site data supervision and low report generation efficiency, improving data traceability and security enhances the degree of automation and flexibility of inspection reports.
Patent Information
- Application Number
- CN202410040735.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-01-11
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2044-01-11
AI Technical Summary
During the data processing process, the existing drilling core method has problems such as inaccurate on-site data supervision, low report generation efficiency, low level of informatization and low data objectivity.
The network connection between the cloud server and the user terminal is adopted, and the online analysis and management of data is realized through menu bars and list controls, and the drawing processing and report generation are automated, and data storage and management are used using blockchain technology.
Real-time supervision and efficient analysis of drill core data is realized, the efficiency of report generation and data traceability and security are improved, and the degree of automation and flexibility of inspection reports are enhanced.
Smart Images

Figure CN117829119B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to an online analysis method and system for drilling core data. Background Art
[0002] The core drilling method is one of the common methods for detecting the integrity of foundation piles. A core sample is drilled from the foundation pile by a drilling rig. The apparent characteristics and compressive strength of the core sample are used to evaluate the pile length, pile body concrete strength, pile body defects and their locations, and pile bottom sediment thickness of the concrete cast-in-place pile, determine or identify the geotechnical properties of the pile bottom bearing layer, and determine the type of turn integrity. The existing core drilling method workflow has the following shortcomings: After the technicians take photos on site with a camera, they have to return to the room to export the photos. The management personnel cannot conduct real-time supervision of the on-site photography and sampling process, which does not meet the industry supervision requirements; after returning to the room, the technicians have to manually input the description of the core sample based on the photos and edit the preliminary report. When issuing a formal report, the technicians also have to manually edit the formal report and use drawing software to draw the core drilling method bar chart, which takes a lot of time and is prone to errors, resulting in multiple revisions of the report and affecting timeliness; technicians fill in paper forms for on-site cataloging, with extremely low levels of informatization and digitization, and great human-dominated factors, which affect the objective authenticity of the data. Summary of the invention
[0003] In order to overcome the defects and shortcomings of the prior art, the present application provides an online analysis method and system for core drilling data.
[0004] In order to achieve the above objectives, this application adopts the following technical solutions:
[0005] According to one aspect of the present application, there is provided an online analysis method for core drilling data, which is applied to a cloud server, wherein the cloud server also establishes network connections with a plurality of user terminals respectively to realize data information transmission, and a first-level interface is accessed through a browser in the user terminal to establish a network connection with the cloud server, wherein the first-level interface includes a menu bar control and a list control, and when the menu bar control is clicked, the list control is triggered to display, and the list control includes a plurality of option controls, each of which is used to jump to a corresponding second-level interface when the user clicks a corresponding option control, and the method includes: in response to receiving a project creation request, executing a project creation process to register engineering information, wherein the project creation request includes a request ID and engineering information;
[0006] Determine the testing tasks according to the client's testing requirements;
[0007] In response to receiving the detection task completion information, a corresponding completion flag is set based on the task ID, and the detection information is stored, wherein the task completion information includes the request ID, the project ID, the task ID, and the detection information, and the detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of core drilling equipment, identification code of detection personnel, and video file;
[0008] In response to receiving a modification request, determining whether the modification authority is available, and if so, performing the modification operation, and if not, feeding back modification rejection information, wherein the modification request includes a request ID, modification location information, and modification content information;
[0009] In response to receiving an analysis request, reading hole catalog information based on the pile number and the detection record format, performing automated drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile conditions to obtain a pile detection conclusion corresponding to the pile number, the analysis request including a request ID, a project ID, a task ID, and a pile number;
[0010] In response to receiving a report preparation request, generating a formal report based on the pile number set, generating a browsing sequence number corresponding to the formal report, and using the browsing sequence number and the formal report as a report item to add the report item to a report list, wherein the report preparation request includes a request ID and a pile number set, and the pile number set is determined by a user terminal corresponding to the request ID of the report preparation request;
[0011] In response to receiving a report viewing request, determining a formal report to be viewed based on the browsing sequence number, and sending the formal report to a user terminal corresponding to a request ID of the report viewing request, wherein the report viewing request includes the request ID and the browsing sequence number;
[0012] The detection record format is a data record distributed in rows, and the detection record format includes six field groups, which are respectively used to indicate the basic hole information, the round record table, the field catalog table, the final hole information, the core sample strength, and the standard penetration information of a single hole, so that each row of data records represents the detection information of a single hole;
[0013] The modification location information is determined by the information association type of the modification content information, specifically including: respectively screening the corresponding information keywords of the project information, the detection task, and the field record information, and determining the information association type according to the information keywords. When the modification content information is related to the project information, the modification location information is determined by the project ID. When the modification content information is related to the detection task, the modification location information is determined by the project ID and the task ID. When the modification content information is related to the field record information, the modification location information is determined by the project ID, the task ID, the pile number, and the hole number.
[0014] When storing the inspection information, the project ID, task ID, core drilling data, positioning information, time period of video shooting, serial number of core drilling equipment, identification code of inspection personnel and the overall HASH information of the video file are saved to the blockchain through the uplink interface, and a unique block number is obtained accordingly. The block number is bound to the corresponding combined index ID consisting of the project ID and task ID in the inspection record management table;
[0015] When storing project information, the overall HASH information of the project ID, project information, and personnel identification code is saved to the blockchain through the uplink interface, and a unique block number is obtained accordingly. The block number is bound to the corresponding project ID in the inspection record management table;
[0016] When storing on-site record information, the overall HASH information of the project ID, task ID, pile number, on-site record information, and personnel identification code is saved in the blockchain through the uplink interface, and a unique block number is obtained accordingly, and the block number is bound to the corresponding combined index number consisting of the project ID, task ID, pile number, and hole number.
[0017] Preferably, when performing the modification operation, it specifically includes: matching the corresponding block number according to the modification position information, and updating the stored data corresponding to the block number based on the modification content information, and rewriting it into the blockchain to complete the data update.
[0018] Preferably, before determining whether the user has the permission to modify, the method further includes: verifying the modified content information based on the modification location information, specifically: determining the information association type corresponding to the modification location information, matching information keywords based on the information association type, and determining whether the information keyword is contained in the process of traversing the modified content information. If the information keyword is contained, the verification succeeds and the step of determining whether the user has the permission to modify is continued; if the information keyword is not contained, the verification fails and the current step ends.
[0019] Preferably, the pile inspection conclusion includes pile body integrity category, pile body concrete strength conclusion, sediment conclusion, bearing layer conclusion, and comprehensive evaluation;
[0020] The pile body integrity categories include Class I, Class II, Class III, and Class IV. The pile body integrity categories are obtained by analyzing the number of holes using a pre-trained pile integrity identification model. The pile integrity identification model is obtained by pre-training multiple sets of data through machine learning. During training, each set of data includes a bar graph and pile body integrity status identification information corresponding to the bar graph. The pile body integrity status identification information includes continuity characteristics, integrity characteristics, height change smoothness characteristics, and cementation status characteristics.
[0021] When the number of holes is one, a corresponding histogram is input into the pile integrity recognition model for analysis, and then a pile body integrity state identification information obtained by the analysis is judged based on the first pile body integrity judgment rule to obtain a pile body integrity category;
[0022] When the number of holes is two, the corresponding two histograms are sequentially input into the pile integrity recognition model for analysis, and then based on the second pile body integrity judgment rule, the two pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category;
[0023] When the number of holes is three, the corresponding three bar graphs are sequentially input into the pile integrity recognition model for analysis, and then based on the third pile body integrity judgment rule, the three pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category;
[0024] The first pile body integrity judgment rule, the second pile body integrity judgment rule, and the third pile body integrity judgment rule are all determined by matching from a preset rule table according to the number of holes, and the preset rule table is a mapping relationship between the number of holes and the pile body integrity judgment rule;
[0025] The pile body concrete strength conclusion is set by judging whether the core sample strength is less than a preset pile body concrete strength threshold value. If the core sample strength is less than the preset pile body concrete strength threshold value, the pile body concrete strength conclusion is set with an unsatisfied mark, otherwise, the pile body concrete strength conclusion is set with a satisfied mark;
[0026] The sediment conclusion is set by judging whether the sediment thickness at the bottom of the pile exceeds a preset sediment thickness threshold. If the sediment thickness at the bottom of the pile exceeds the preset sediment thickness threshold, a dissatisfaction mark is set for the sediment conclusion; otherwise, a satisfaction mark is set for the sediment conclusion.
[0027] When setting the bearing layer conclusion, if the bearing layer compressive strength is greater than or equal to the preset bearing layer compressive strength threshold and the bearing layer shear strength is greater than or equal to the preset bearing layer shear strength threshold, a satisfied mark is set for the bearing layer conclusion, otherwise the standard penetration hammer number is continued to be judged: the corresponding weathering degree type is matched in the pre-stored lithology weathering degree table according to the standard penetration hammer number, if the weathering degree type matches the preset weathering degree requirement type, a satisfied mark is set for the bearing layer conclusion, if the weathering degree type does not match the preset weathering degree requirement type, a not satisfied mark is set for the bearing layer conclusion;
[0028] When setting the comprehensive evaluation, if any of the following conditions exists: the pile integrity category is Class IV pile, the pile concrete strength conclusion is not satisfied, the sediment conclusion is not satisfied, and the bearing layer conclusion is not satisfied, then the comprehensive evaluation is set with a not satisfied mark; otherwise, a satisfied mark is set.
[0029] Preferably, performing the automated drawing process to obtain a bar graph corresponding to each well specifically includes:
[0030] Extract key drawing information corresponding to the currently processed hole from basic hole information, round record table, on-site catalog table, core sample strength, and standard penetration information;
[0031] The key drawing information is converted into a format to obtain the drawing input information, and the key drawing information includes concrete strength grade, pile top elevation, pile length, designed pile diameter, drilling depth, layering information, sampling information, and core sample strength;
[0032] According to the key information of the drawing, the conditions of the layers above the elevation of the column chart, the properties of the rock formations, the sampling location, the strength of the core sample, and the standard penetration test of the rock formations are judged to obtain the supplementary information of the drawing depth;
[0033] The basic framework of the histogram is determined based on the drawing input information, the graphic depth of the histogram is filled based on the drawing depth supplementary information, and the graphic library is used to perform graphic visualization conversion, so as to obtain the histogram corresponding to the currently processed hole.
[0034] Preferably, when judging whether there is permission to modify, it specifically includes:
[0035] Determine the corresponding operation permission from the permission management table according to the request ID of the modification request;
[0036] Whether the permission to modify is available is determined by judging whether the operation permission reaches a preset modification permission threshold. If the operation permission reaches the preset modification permission threshold, the user has the permission to modify; otherwise, the user does not have the permission to modify.
[0037] Preferably, executing the project creation process to register the engineering information specifically includes:
[0038] Get the request ID of the new project request;
[0039] Determine the corresponding operation authority from a preset authority management table according to the request ID of the project creation request, wherein the authority management table is used to manage the mapping relationship between the user ID and the operation authority, and the request ID is the user ID that initiates the project creation request;
[0040] Determine whether the operation authority reaches the preset project creation authority threshold. If the operation authority reaches the preset project creation authority threshold, a new project is created, and the new project is supplemented with information based on the project information of the project creation request. If it does not reach the threshold, permission prompt information is fed back to the request ID.
[0041] Preferably, in setting the corresponding completion mark based on the task ID, it specifically includes: checking the request ID of the task completion information based on the authority management table, if there is a user ID in the authority management table that is repeated with the request ID of the task completion information, then setting the completion mark for the detection task based on the task ID, otherwise terminating the current operation.
[0042] Preferably, generating a formal report based on the pile number set specifically includes:
[0043] Traverse the pile number set, summarize the bar graphs corresponding to each hole in each pile number to generate a comprehensive bar graph, summarize the pile detection conclusions corresponding to each hole in each pile number to generate a comprehensive conclusion text;
[0044] Fill the comprehensive bar chart and comprehensive conclusion text into the preset test report template and complete the rendering to obtain the formal report.
[0045] According to another aspect of the present application, there is also provided an online analysis system for core drilling data, which is used to execute the online analysis method for core drilling data described above, and the system comprises: a project creation module, which is used to execute a project creation process to register engineering information in response to receiving a project creation request, wherein the project creation request comprises a request ID and engineering information;
[0046] The detection task determination module is used to determine the detection task according to the detection requirements of the client;
[0047] An information storage module, configured to respond to receiving the detection task completion information, set a corresponding completion mark based on the task ID, and store the detection information, wherein the task completion information includes the request ID, the project ID, the task ID, and the detection information, and the detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of the core drilling equipment, identification code of the detection personnel, and video files;
[0048] An information modification module, configured to determine whether the modification authority is available upon receipt of a modification request, and to perform the modification operation if available, or to feedback modification rejection information if not available, wherein the modification request includes a request ID, modification location information, and modification content information;
[0049] A pile analysis module, for responding to receiving an analysis request, reading hole catalog information based on the pile number and the detection record format, performing automated drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile situation to obtain a pile detection conclusion corresponding to the pile number, wherein the analysis request includes a request ID, a project ID, a task ID, and a pile number;
[0050] A report preparation module, configured to generate a formal report based on a pile number set in response to receiving a report preparation request, generate a browsing sequence number corresponding to the formal report, and use the browsing sequence number and the formal report as a report item to add the report item to a report list, wherein the report preparation request includes a request ID and a pile number set, and the pile number set is determined by a user terminal corresponding to the request ID of the report preparation request;
[0051] The report viewing module is used to respond to receiving a report viewing request, determine the formal report to be viewed based on the browsing sequence number, and send the formal report to the user terminal corresponding to the request ID of the report viewing request, wherein the report viewing request includes the request ID and the browsing sequence number.
[0052] Compared with the prior art, this application has the following advantages and beneficial effects:
[0053] (1) When responding to an analysis request, the present application reads the hole catalog information based on the pile number and the detection record format, performs automated drawing processing to obtain a bar chart corresponding to each hole, and realizes automatic generation of a bar chart. Compared with the existing manual method, it is efficient and fast, greatly improving the analysis efficiency, analyzing the pile situation to obtain a pile detection conclusion corresponding to the pile number, and when responding to a report preparation request, a formal report is generated based on the pile number set, and a browsing number corresponding to the formal report is generated. The browsing number and the formal report are used as a report item to add the report item to the report list. When responding to a report viewing request, the formal report to be viewed is determined based on the browsing number, and the formal report is sent to the user terminal corresponding to the request ID of the report viewing request, thereby making up for the cumbersomeness of the existing workflow in analyzing core drilling data. By storing the core drilling data in online cataloging and analysis, the whole process of core drilling method is informatized and automated, the efficiency of issuing core drilling method reports is improved, and the core drilling method analysis process is made clearer, simpler and more efficient;
[0054] (2) When storing inspection information, the present application saves the overall HASH information of the project ID, task ID, core drilling data, positioning information, time period of video shooting, serial number of core drilling equipment, identification code of inspection personnel and video file into the blockchain through the uplink interface, and obtains a unique block number accordingly, and binds the block number with the corresponding combined index ID composed of the project ID and task ID in the inspection record management table; when storing engineering information, the overall HASH information of the project ID, engineering information and identification code of the inspection personnel is saved into the blockchain through the uplink interface, and obtains a unique block number accordingly, and binds the block number with the corresponding engineering ID in the inspection record management table; when storing field record information, the overall HASH information of the project ID, task ID, pile number, field record information and identification code of the inspection personnel is saved into the blockchain through the uplink interface, and obtains a unique block number accordingly, and binds the block number with the corresponding combined index number composed of the project ID, task ID, pile number and hole number. The use of blockchain technology to realize online data processing and cloud storage not only improves the traceability, security and reliability of information storage, but also improves the reliability of on-site real-time supervision, enabling managers to conduct real-time supervision of on-site photography and sampling processes, thus improving the timeliness of supervision;
[0055] (3) When generating a formal report based on a pile number set, the present application traverses the pile number set, summarizes the bar graphs corresponding to each hole in each pile number to generate a comprehensive bar graph, summarizes the pile detection conclusions corresponding to each hole in each pile number to generate a comprehensive conclusion text, fills the comprehensive bar graph and the comprehensive conclusion text into a preset detection report template, and completes the rendering to obtain a formal report, so that the formal report on pile analysis can select the designated pile number for comprehensive analysis according to actual needs, thereby improving the degree of automation and flexibility in issuing the detection report, and making the detection report issuance faster and error-free.
[0056] (4) When setting the corresponding completion mark based on the task ID, this application rejects requests initiated by unexpected user IDs by screening the request IDs, thereby avoiding interference with the update of internal data due to malicious requests initiated from the outside, thereby improving the data security of the detection task during the status update process. At the same time, before determining whether there is permission to modify, the application matches information keywords based on the information association type, and uses the information keywords to verify the modification location information and modification content information, thereby avoiding interference with the format and content of data storage due to malicious requests initiated from the outside, thereby improving the security of data modification. BRIEF DESCRIPTION OF THE DRAWINGS
[0057] Figure 1 A schematic flow chart of the online analysis method of drill core data provided in Example 1 of the present application;
[0058] Figure 2 A schematic diagram of the framework of the online analysis system for drill core data provided in Example 2 of the present application;
[0059] Figure 3 A schematic diagram of the structure of a terminal provided in Embodiment 3 of the present application;
[0060] Figure 4 This is a schematic diagram of the structure of a computer device provided in Example 4 of the present application. DETAILED DESCRIPTION
[0061] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.
[0062] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0063] In Example 1, this embodiment provides an online analysis method for drilling core data, which is applied in a cloud server. The cloud server also establishes network connections with multiple user terminals to realize the transmission of data information.
[0064] Start the engineering management system in the cloud server, which includes: identity recognition module, engineering management module, detection catalog module, engineering review module, data analysis module, and report management module;
[0065] Accessing the first level interface through a browser in a user terminal to establish a network connection with the cloud server;
[0066] Among them, the identity recognition module is used to identify each accessing user terminal to grant corresponding operation permissions; illustratively, the ID card number or facial features can be used as a means of verification for identity recognition.
[0067] The project management module is used to manage the information of each project, classify each inspection task into the corresponding project so that each inspection task has a corresponding project, each inspection task has a unique task ID, each project includes at least one inspection task, each project has a unique project ID, and each project has corresponding project information;
[0068] A detection cataloging module is used to catalog the detected drill core data;
[0069] Engineering review module, used to review data based on operation permissions;
[0070] A data analysis module, used to analyze the cataloged drill core data based on the specified project ID to obtain analysis information;
[0071] The report management module is used to manage the report list. The report list includes multiple report items. Each report item corresponds to a formal report. The report item is obtained by integrating the analysis information and the project information based on the specified project ID and pile number set.
[0072] The first-level interface includes a menu bar control and a list control. When the menu bar control is clicked, the list control is triggered to display. The list control includes multiple option controls, which are respectively bound to the project management module, the detection catalog module, the project review module, the data analysis module, and the report management module, so that the corresponding second-level interface can be jumped when the user clicks the corresponding option control.
[0073] Exemplarily, the second-level interface corresponding to the engineering management module is switched by clicking the menu bar control in the first-level interface and selecting the option control corresponding to the "engineering project" to view, add, and edit engineering information. The engineering information includes basic engineering information, inspection task information, engineering supplementary information, participating units, and engineering attachments. The basic engineering information includes the project name, project address, and detailed address; the inspection task information is used to add and edit inspection tasks, and then determine the inspection personnel, inspection instrument model, inspection technical specifications, inspection quantity, etc.; the engineering supplementary information includes the start date, building area, pile foundation information, foundation information, and contact information. The engineering attachments are a collection of various documents related to the project, including but not limited to engineering design drawings, construction plans, contract texts, etc.
[0074] Exemplarily, the second-level interface corresponding to the detection cataloging module is to switch the interface by clicking the menu bar control in the first-level interface and selecting the option control corresponding to "field record", so that each detection task is displayed using the task list, and the field record information under the detection task can be viewed by double-clicking the detection task, and the field record information of the pile in the task list can be edited by clicking the "Edit" button, supporting two modes of online editing and file import;
[0075] In this embodiment, the field record information includes a pile list and hole catalog information, and the pile list and hole catalog information are respectively displayed in the window in a left-right layout, such as setting the pile list to be displayed in the left window column, and setting the hole catalog information to be displayed in the right window column, wherein the pile list is used to list each pile under the detection task; when the pile list is selected, the corresponding hole catalog information is determined according to the hole number, each pile has at least one hole, and each hole corresponds to a hole catalog information, and the hole catalog information includes basic hole information, return record table, field catalog table, final hole information, core sample strength, and standard penetration information. The basic hole information is used to fill in the basic hole information and select the drilling location. Most basic hole information systems will automatically fill in the information based on the field records and existing basic hole information; the round record sheet is used to record the detailed information and photos of each round of the hole drilling process; the field cataloging table includes stratification information, sampling information, standard penetration information and core sample photos. The standard penetration information in the field cataloging table is mapped to the standard penetration information in the hole cataloging information. The data remains consistent for the same pile number and hole number. The field cataloging table is used to summarize the stratification information, sampling information, standard penetration information and core sample photos.
[0076] In the layering information, layers can be added according to the actual situation on site. There are four types: layer above the design elevation, concrete layer, sediment layer and rock and soil layer. The basic information of each layer, such as depth, sampling rate, pattern, description, etc., can be set. Defects can be added to the concrete layer. The system automatically describes the concrete layer according to the defect type. The rock and soil layer can preset a unified description of the bearing layer; in the sampling information, it is used to describe the depth position and layer category of the core sample, and mark whether it is a defective position sampling; in the standard penetration information, it is used to describe the depth position, layer category and standard penetration hammer number of the standard penetration. For the standard penetration of the concrete layer, it is necessary to mark whether it is a defective position; in the final hole information, it is used to fill in the opening time, final hole time, drilling depth, and select the final hole reason. Necessary remarks can be added. The final hole information needs to be recorded on the system after the on-site hole drilling is completed; in the core sample strength, the representative value of the core sample strength is filled in according to the laboratory compressive strength results;
[0077] Exemplarily, the second level interface corresponding to the data analysis module is switched by clicking the menu bar control in the first level interface and selecting the option control corresponding to "data analysis", which is recorded as the data analysis interface; the data analysis interface includes a data analysis list, which includes analysis items corresponding to each detection task respectively, and by double-clicking the analysis item, the specified detection task is selected to enter the data analysis interface corresponding to the task ID, and then the data of the field record and detection catalog that have been filled in are analyzed. The data analysis interface includes a window in the form of left and right distribution, with a pile list on the left and a result summary table on the right. The pile list is used to list each pile that has completed the field catalog under the detection task, and the result summary table includes the pile detection conclusion of the current pile and the hole catalog information corresponding to each hole, and the hole catalog information corresponds to the hole catalog information in the field record information. Among them, the hole catalog information in the field catalog table can automatically generate a histogram of the hole; the result summary table is used to summarize the pile detection conclusions of the data analysis that have been completed in the current detection task.
[0078] Exemplarily, the second-level interface corresponding to the report issuing module is to switch the interface by clicking the menu bar control in the first-level interface and selecting the option control corresponding to "Report Management". The report list can be added and edited. The report list includes multiple report items, each of which includes engineering information, personnel and equipment allocation information, detection planning information, pile information, detection results, attachments and charts, etc. The engineering information has been filled in when the engineering project was created, and only information verification and minor adjustments are required here; the personnel and equipment allocation information has been allocated when the task order was created, and can also be reselected; the detection planning information is the detection plan, related principles, detection purpose, etc.; in the pile information, check the pile number that needs to be reported; the detection results are the core drilling method conclusion table and bar chart; the core drilling method conclusion table is used to record the pile detection conclusion corresponding to each pile number during data analysis; the attachment chart is used to upload the report attachment picture; after submission, the system automatically issues a formal report as a report item, and the formal report is stored in word or pdf format.
[0079] In this embodiment, the pile formation information includes serial number, pile number, pile diameter (unit: mm), designed pile length (unit: m), designed pile top elevation (unit: m), detected pile top elevation (unit: m), pile concrete pouring date, designed strength grade, and single pile bearing capacity.
[0080] like Figure 1 As shown, the method includes:
[0081] Step S100: In response to receiving a project creation request, executing a project creation process to register engineering information;
[0082] In this embodiment, the project creation request includes a request ID and project information.
[0083] In performing the project creation process to register the project information, specifically including:
[0084] Step S101: Obtain the request ID of the project creation request;
[0085] Step S102: Determine the corresponding operation authority from the preset authority management table according to the request ID of the project creation request; the authority management table is used to manage the mapping relationship between user ID and operation authority, and the request ID is the user ID of the user who initiated the project creation request. Exemplarily, <user ID, authority level> is used as an example to represent the authority of each user in the authority management table, such as <user ID1, 1>, <user ID2, 1>, <user ID3, 4>, <user ID4, 2>, and the larger the value of the operation authority, the higher the authority range of the user.
[0086] Step S103: Determine whether the operation authority reaches the preset project creation authority threshold. If the operation authority reaches the preset project creation authority threshold, a new project is created, and the newly created project is supplemented with information based on the project information of the project creation request. If the operation authority does not reach the preset project creation authority threshold, the permission prompt information is fed back to the request ID. The permission prompt information is used to prompt the user that the current operation authority cannot perform the current operation. The permission prompt information reminds the user in the form of text combined with a prompt sound by triggering a prompt pop-up window on the user terminal. Exemplarily, the preset project creation authority threshold can be 3. If the operation authority of the current request ID is 1, and the operation authority does not reach the preset project creation authority threshold, the permission prompt information is fed back.
[0087] Step S200: determining the inspection task according to the inspection requirements of the client;
[0088] In this embodiment, the client's inspection requirements are obtained by filling in the client using the user terminal, and an inspection task is created according to the client's inspection plan, and then the inspection personnel and core drilling equipment for the inspection task are determined; the inspection personnel go to the construction site to conduct core drilling inspection, and promptly use the user terminal to fill in the on-site record information in the second-level interface corresponding to the inspection cataloging module, thereby realizing the formatted storage of the on-site record information;
[0089] Step S300: in response to receiving the detection task completion information, setting a corresponding completion flag based on the task ID and storing the detection information;
[0090] In this embodiment, the inspection task is completed by the inspection personnel using the core drilling method. When the inspection task is completed, the inspection personnel uses the user terminal to send inspection task completion information to the cloud server, and then the cloud server obtains the inspection information.
[0091] In this embodiment, the task completion information includes the request ID, project ID, task ID, and detection information. The detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of core drilling equipment, detection personnel identification code and video file.
[0092] Exemplarily, the core drilling data may include the length, diameter, sampling location (such as depth, distance from the surface, etc.) of the drilled core sample, and other physical properties of the core sample such as color, texture, etc., so as to analyze the material composition and structure of the core sample; the positioning information is detailed information on the core sampling location, such as the latitude and longitude, altitude, and depth of the sampling, so as to determine the sampling location and the location of the underground structure; the time period of the video shooting is the time range of the video shot during the core drilling process, and the video can be used to observe and record the core drilling process, as well as to check the status and characteristics of the core samples; the serial number of the core drilling equipment is a unique identifier corresponding to the core drilling equipment, which can be used to track and record which equipment is used, as well as the performance and status of the equipment; the inspection personnel identification code is used to indicate the identity of the person performing the core drilling inspection work. Through the identification code, it is possible to track and record who performed the core drilling operation, as well as their professional qualifications and experience level; the video file is a video shot during the core drilling process, which is used to play back and view the core drilling process, and analyze the status and characteristics of the core samples.
[0093] In this embodiment, in setting the corresponding completion mark based on the task ID, it specifically includes: checking the request ID of the task completion information based on the authority management table. If there is a user ID in the authority management table that is repeated with the request ID of the task completion information, then setting the completion mark for the detection task based on the task ID, otherwise terminating the current operation.
[0094] In actual application, by screening the request ID, the request initiated by the unexpected user ID is rejected, avoiding the interference of malicious request attacks initiated from the outside to the update of internal data, thereby improving the data security of the detection task during the status update process.
[0095] In this embodiment, when storing the detection information, it specifically includes: receiving the core drilling data, positioning information, video shooting time period, serial number of the core drilling equipment, personnel identification code and video file corresponding to the project ID and task ID, saving the overall HASH information of the project ID, task ID, core drilling data, positioning information, video shooting time period, serial number of the core drilling equipment, identification code of the detection personnel and the video file to the blockchain through the link interface, and obtaining a unique block number correspondingly, and binding the block number with the corresponding combined index ID composed of the project ID and task ID in the detection record management table, thereby completing the storage process of the detection information. In actual application, the detection information is stored using the blockchain, and the block number is bound to the corresponding combined index ID composed of the project ID and task ID through the detection record management table, thereby improving the data security of each detection task during storage, making the data storage of each detection task independent, solving the management problems and open utilization security problems in the digitization process of the detection information, and making the digital archives more secure and more convenient to manage.
[0096] By analogy, when storing project information, the overall HASH information of the project ID, project information, and personnel identification code is saved to the blockchain through the uplink interface, and a unique block number is obtained accordingly, and the block number is bound to the corresponding project ID in the inspection record management table;
[0097] Accordingly, when storing the on-site record information, the overall HASH information of the project ID, task ID, pile number, on-site record information, and personnel identification code is saved to the blockchain through the uplink interface, and a unique block number is obtained accordingly, and the block number is bound to the corresponding combined index number consisting of the project ID, task ID, pile number, and hole number;
[0098] Step S400: in response to receiving the modification request, determining whether the modification authority is available, and if so, executing the modification operation; if not, feeding back modification rejection information;
[0099] In this embodiment, the modification request includes a request ID, modification location information, and modification content information.
[0100] In this embodiment, the modification location information is determined by the information association type of the modification content information. Specifically, the corresponding information keywords are screened for the project information, detection tasks, and field record information, and the information association type is determined according to the information keywords. The information keyword is a text that is distinguished from the remaining information. For example: the project information has a specific text field "project address", the detection task has a specific text field "commission type", and the field record information has a specific text field "return record table". By using the specific text field as the information keyword, the information keyword is bound to the information association type respectively, so that the corresponding information association type is matched by traversing the information keywords contained in the modification content information, thereby determining the modification location information.
[0101] Exemplarily, the information association type includes engineering information type, detection task type, and field record information type. When the modified content information is related to engineering information, the modified location information is determined by the engineering ID; when the modified content information is related to the detection task, the modified location information is determined by the engineering ID and the task ID; when the modified content information is related to field record information, the modified location information is determined by the engineering ID, the task ID, the pile number, and the hole number.
[0102] Before determining whether the user has the permission to modify, the method further includes: verifying the modified content information based on the modification location information, specifically, determining the information association type corresponding to the modification location information, matching information keywords based on the information association type, and determining whether the information keyword is contained in the process of traversing the modified content information. If the information keyword is contained, the verification succeeds and the step of determining whether the user has the permission to modify is continued. If the information keyword is not contained, the verification fails and the current step is terminated.
[0103] In actual application, by matching information keywords based on information association types before judging whether there is permission to modify, and using information keywords to verify the modification location information and modification content information, it avoids malicious requests initiated from outside from interfering with the format and content of data storage, improves the security of data modification, and ensures the reliability of data storage.
[0104] When judging whether there is permission to modify, the following are specifically included:
[0105] Determine the corresponding operation permission from the permission management table according to the request ID of the modification request;
[0106] Whether the permission to modify is available is determined by judging whether the operation permission reaches a preset modification permission threshold. If the operation permission reaches the preset modification permission threshold, the user has the permission to modify; otherwise, the user does not have the permission to modify.
[0107] In this embodiment, the preset modification permission threshold is pre-set, for example, a value of "2", "3", etc., which corresponds to the operation permission in storage form.
[0108] When performing a modification operation, it specifically includes: matching the corresponding block number according to the modification location information, updating the stored data corresponding to the block number based on the modification content information, and rewriting it into the blockchain to complete the data update.
[0109] Step S500: in response to receiving the analysis request, reading the hole catalog information based on the pile number and the detection record format, performing automatic drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile situation to obtain a pile detection conclusion corresponding to the pile number;
[0110] It should also be noted that the analysis of the pile conditions is an analysis rule created by technical personnel in this field according to the corresponding building inspection specifications. The building inspection specifications are well known to technical personnel in this field and do not fall within the scope of protection of this application. The improvement of this application lies in the process of how to obtain the pile inspection conclusion when analyzing the pile conditions, thereby improving the intelligence level and analysis efficiency of the analysis process.
[0111] In this embodiment, the analysis request includes a request ID, a project ID, a task ID, and a pile number. The detection record format is a data record distributed in rows. The detection record format contains six field groups, which are used to indicate the basic hole information of a single hole, a round record table, a field catalog table, the final hole information, the core sample strength, and the standard penetration information, so that each row of data records represents the detection information of a single hole.
[0112] In this embodiment, the pile inspection conclusion includes a comprehensive evaluation of the pile body integrity category, the pile body concrete strength conclusion, the sediment conclusion, and the bearing layer conclusion;
[0113] The pile body integrity categories include Class I, Class II, Class III, and Class IV. The pile body integrity categories are obtained by analyzing the number of holes using a pre-trained pile integrity identification model. The pile integrity identification model is obtained by pre-training multiple sets of data through machine learning. During training, each set of data includes a bar graph and pile body integrity status identification information corresponding to the bar graph. The pile body integrity status identification information includes continuity characteristics, integrity characteristics, height change smoothness characteristics, and cementation status characteristics.
[0114] When the number of holes is one, a corresponding histogram is input into the pile integrity recognition model for analysis, and then a pile body integrity state identification information obtained by the analysis is judged based on the first pile body integrity judgment rule to obtain a pile body integrity category;
[0115] When the number of holes is two, the corresponding two histograms are sequentially input into the pile integrity recognition model for analysis, and then based on the second pile body integrity judgment rule, the two pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category;
[0116] When the number of holes is three, the corresponding three bar graphs are sequentially input into the pile integrity recognition model for analysis, and then based on the third pile body integrity judgment rule, the three pile body integrity status identification information obtained from the analysis are judged to obtain the pile body integrity category.
[0117] The first pile body integrity judgment rule, the second pile body integrity judgment rule, and the third pile body integrity judgment rule are all determined by matching from a preset rule table according to the number of holes, and the preset rule table is a mapping relationship between the number of holes and the pile body integrity judgment rule; in actual application, the pile body integrity is judged by establishing corresponding judgment rules according to single hole, two holes, and three holes. The first pile body integrity judgment rule, the second pile body integrity judgment rule, and the third pile body integrity judgment rule can all be set by technical personnel in this field according to the actual needs of the building inspection specifications used, that is, under different numbers of holes, the continuity characteristics, integrity characteristics, height change smoothness characteristics, and bonding state characteristics are comprehensively judged rules, which are not specifically limited here.
[0118] Exemplarily, the continuity feature of the histogram includes a continuous mark and a discontinuous mark, which are used to indicate whether the histogram is continuous, whether there are breaks or gaps. If there are breaks or gaps between the core samples, it may mean that there are defects or damages in the corresponding position of the pile body.
[0119] Exemplarily, the integrity feature of the histogram includes a complete mark and an incomplete mark, which are used to indicate whether the histogram is complete, that is, whether there are missing data points or data values. If there are missing data points or data values, it may affect the assessment of the integrity of the pile body;
[0120] Exemplarily, the height change smoothness feature of the histogram includes a smooth mark and a non-smooth mark, which are used to indicate whether the height change of the histogram is smooth. If it is a non-smooth mark, it means that there is an abnormal height fluctuation. If there is an abnormal height fluctuation, it means that there is an abnormality in the corresponding position of the pile body.
[0121] Exemplarily, the bonding state characteristics of the bar graph include a good bonding mark, a general bonding mark and a poor bonding mark. When the bonding is good, the core sample of the pile body concrete is continuous and complete, the side surface of the core sample is smooth, the aggregate is evenly distributed, the core sample is in the shape of a long column, and the fractures match; when the bonding is general, the core sample of the pile body concrete is continuous and complete, but the side surface of the core sample is relatively smooth, the aggregate is unevenly distributed, the core sample is in the shape of a short column, and the fractures do not match; when the bonding is poor, the core sample of the pile body concrete is discontinuous and incomplete, there is a broken pile phenomenon, or the side surface of the core sample is not smooth, the aggregate is unevenly distributed, and it is in the shape of fragments or cakes, or the core sample is in the shape of loose particles.
[0122] It should be noted that pile integrity can be divided into four categories. Class I piles: the pile body is intact; Class II piles: the pile body has slight defects, which will not affect the normal performance of the pile body structure bearing capacity; Class III piles: the pile body has obvious defects, which will affect the pile body structure bearing capacity; Class IV piles: the pile body has serious defects. The severity of the pile body defects is from high to low, namely IV, III, II, and I, corresponding to the pile body integrity categories of IV, III, II, and I, respectively.
[0123] The conclusion of the pile body concrete strength is set by judging whether the core sample strength is less than the preset pile body concrete strength threshold. If the core sample strength is less than the preset pile body concrete strength threshold, the pile body concrete strength conclusion is set with an unsatisfied mark; otherwise, the pile body concrete strength conclusion is set with a satisfied mark.
[0124] The sediment conclusion is set by judging whether the sediment thickness at the bottom of the pile exceeds a preset sediment thickness threshold. If the sediment thickness at the bottom of the pile exceeds the preset sediment thickness threshold, an unsatisfied flag is set for the sediment conclusion; otherwise, a satisfied flag is set for the sediment conclusion.
[0125] When setting the bearing layer conclusion, if the bearing layer compressive strength is greater than or equal to the preset bearing layer compressive strength threshold and the bearing layer shear strength is greater than or equal to the preset bearing layer shear strength threshold, a satisfied mark is set for the bearing layer conclusion, otherwise the standard penetration hammer number is continued to be judged: the corresponding weathering degree type is matched in the pre-stored lithology weathering degree table according to the standard penetration hammer number, if the weathering degree type matches the preset weathering degree requirement type, a satisfied mark is set for the bearing layer conclusion, if the weathering degree type does not match the preset weathering degree requirement type, a not satisfied mark is set for the bearing layer conclusion;
[0126] In this embodiment, the bearing layer conclusion is set by the bearing layer strength condition and the bearing layer lithology condition. The bearing layer strength condition is determined according to the bearing layer compressive strength and the bearing layer shear strength. The bearing layer lithology condition is determined by the standard penetration hammer number. If the weathering degree type matches the preset weathering degree requirement type, it means that the weathering degree type is the same as the preset weathering degree requirement type. If it does not match, it means that the two are different.
[0127] When setting the comprehensive evaluation, if any of the following conditions exists: the pile integrity category is Class IV pile, the pile concrete strength conclusion is not satisfied, the sediment conclusion is not satisfied, and the bearing layer conclusion is not satisfied, then the comprehensive evaluation is set with a not satisfied mark; otherwise, a satisfied mark is set.
[0128] In addition, it should be noted that the standard penetration hammer number, pile bottom sediment thickness, core sample strength, bearing layer compressive strength, and bearing layer shear strength are all obtained by inputting after statistical analysis of test data. The core sample strength is a representative value of the core sample specimen compressive strength. The preset pile body concrete strength threshold is set by technicians in this field according to actual needs to measure the concrete design strength required for the actual construction scene. The preset bearing layer compressive strength threshold, the preset bearing layer shear strength threshold, and the preset sediment thickness threshold can all be set by technicians in this field according to actual conditions. The analysis method of pile bottom sediment thickness and bearing layer strength is a prior art in the field and is not within the scope of protection of this application. In actual application, the evaluation method of the bearing layer in this application is for the case of rock. The bearing layers in other cases are intuitive and simple, and generally no evaluation is required in actual applications.
[0129] In this embodiment, the lithology weathering degree table is a mapping table of standard penetration hammer number and weathering degree type, which can be established by those skilled in the art according to the actual building code standards used. The weathering degree type of the lithology weathering degree table is specifically divided according to the weathering degree of the rock, for example, residual soil type, fully weathered type, and strongly weathered type. Exemplarily, for the case of granite: if the standard penetration hammer number is less than 40, the corresponding weathering degree type is residual soil type, if the standard penetration hammer number is greater than or equal to 40 and less than 70, the corresponding weathering degree type is fully weathered type, and if the standard penetration hammer number is greater than 70, the corresponding weathering degree type is strongly weathered type.
[0130] In this embodiment, a corresponding preset weathering degree requirement type is set for each task ID, and the preset weathering degree requirement type can be set to any one of residual soil type, full weathering type, and strong weathering type. For example, the preset weathering degree requirement type corresponding to task ID1 is: full weathering type, and the preset weathering degree requirement type corresponding to task ID2 is: strong weathering type.
[0131] Specifically, a pre-trained pile integrity recognition model is used for analysis according to the number of holes, and a corresponding judgment rule is selected from the first pile body integrity judgment rule, the second pile body integrity judgment rule or the third pile body integrity judgment rule according to the number of holes. By combining the judgment of continuity characteristics, integrity characteristics, height change smoothness characteristics, and bonding state characteristics, the efficiency and accuracy of pile body integrity category judgment based on core data are improved.
[0132] In performing the automated drawing process to obtain the bar chart corresponding to each hole, specifically including: extracting the key drawing information corresponding to the currently processed hole from the basic hole information, the return record table, the field catalog table, the core sample strength, and the standard penetration information;
[0133] The key drawing information is converted into a format to obtain the drawing input information, and the key drawing information includes concrete strength grade, pile top elevation, pile length, designed pile diameter, drilling depth, layering information, sampling information, and core sample strength;
[0134] According to the key information of the drawing, the conditions of the layers above the elevation of the column chart, the properties of the rock formations, the sampling location, the strength of the core sample, and the standard penetration test of the rock formations are judged to obtain the supplementary information of the drawing depth;
[0135] Determine the basic framework of the histogram based on the drawing input information, fill the graphic depth of the histogram based on the drawing depth supplementary information, use the graphics library to perform graphic visualization conversion, and then obtain the histogram corresponding to the currently processed hole;
[0136] In this embodiment, the use of the graphics library to perform graphics visualization conversion includes scaling graphics of different depths proportionally and adjusting the display position of the visible area. For example, Python's matplotlib library can be used to select appropriate graphics types and parameters to draw a bar chart.
[0137] Specifically, the efficiency of bar chart drawing is improved through automated drawing processing, and the inefficiency problem caused by manual core drilling method drawing is solved.
[0138] Step S600: In response to receiving a report preparation request, a formal report is generated based on a pile number set, a browsing number corresponding to the formal report is generated, and the browsing number and the formal report are used as a report item to add the report item to a report list.
[0139] In this embodiment, the report preparation request includes a request ID and a pile number set. The pile number set is determined by the user terminal corresponding to the request ID of the report preparation request. Exemplarily, in the second-level interface corresponding to the report issuance module, the pile number set is formed by checking the pile numbers for which reports need to be issued.
[0140] In the report list, the browsing sequence number corresponding to each report item is different to distinguish different report items.
[0141] In this embodiment, a formal report is generated based on the pile number set, specifically including:
[0142] Step S601: traverse the pile number set, summarize the bar graphs corresponding to each hole in each pile number to generate a comprehensive bar graph, and summarize the pile detection conclusions corresponding to each hole in each pile number to generate a comprehensive conclusion text;
[0143] Step S602: Fill the comprehensive bar graph and comprehensive conclusion text into the preset test report template, and complete the rendering to obtain a formal report.
[0144] In this embodiment, a project can be divided into multiple inspection tasks to be completed, and different formal reports can be issued for a project (all piles and holes that have been inspected) according to the checked pile numbers. The flexibility of report issuance is improved by checking the required pile numbers.
[0145] Step S700: In response to receiving a report viewing request, determine the formal report to be viewed based on the browsing sequence number, and send the formal report to the user terminal corresponding to the request ID of the report viewing request. In this embodiment, the report viewing request includes a request ID and a browsing sequence number.
[0146] In Example 2, Figure 2 As shown, this embodiment 2 provides an online analysis system for core drilling data based on embodiment 1. The system corresponds to an online analysis method for core drilling data in embodiment 1, and the same contents are not repeated here.
[0147] The system includes: a project creation module for executing a project creation process to register engineering information in response to receiving a project creation request, wherein the project creation request includes a request ID and engineering information;
[0148] The detection task determination module is used to determine the detection task according to the detection requirements of the client;
[0149] An information storage module, configured to respond to receiving the detection task completion information, set a corresponding completion mark based on the task ID, and store the detection information, wherein the task completion information includes the request ID, the project ID, the task ID, and the detection information, and the detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of the core drilling equipment, identification code of the detection personnel, and video files;
[0150] An information modification module, configured to determine whether the modification authority is available upon receipt of a modification request, and to perform the modification operation if available, or to feedback modification rejection information if not available, wherein the modification request includes a request ID, modification location information, and modification content information;
[0151] A pile analysis module, for responding to receiving an analysis request, reading hole catalog information based on the pile number and the detection record format, performing automated drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile situation to obtain a pile detection conclusion corresponding to the pile number, wherein the analysis request includes a request ID, a project ID, a task ID, and a pile number;
[0152] A report preparation module, configured to generate a formal report based on a pile number set in response to receiving a report preparation request, generate a browsing sequence number corresponding to the formal report, and use the browsing sequence number and the formal report as a report item to add the report item to a report list, wherein the report preparation request includes a request ID and a pile number set, and the pile number set is determined by a user terminal corresponding to the request ID of the report preparation request;
[0153] The report viewing module is used to respond to receiving a report viewing request, determine the formal report to be viewed based on the browsing sequence number, and send the formal report to the user terminal corresponding to the request ID of the report viewing request, wherein the report viewing request includes the request ID and the browsing sequence number.
[0154] In Example 3, Figure 3 As shown, this embodiment provides a terminal, including: at least one memory and at least one processor; wherein, the at least one memory is used to store program codes, and the at least one processor is used to call the program codes stored in the at least one memory to execute any one of the online analysis methods for core data in the above embodiments.
[0155] In embodiment 4, this embodiment provides a computer device, which may be a server, and its internal structure diagram may be as follows: Figure 4 As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is a physical layer for storing various databases. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, an online analysis method for drilling core data is implemented.
[0156] Those skilled in the art will understand that Figure 4 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0157] In Example 5, this embodiment provides a storage medium, wherein the storage medium is used to store program codes, and the program codes are used to execute the above-mentioned online analysis method of drill core data.
[0158] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.
[0159] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.
[0160] The above embodiments are preferred implementation modes of the present application, but the implementation modes of the present application are not limited to the above embodiments. Any other changes, modifications, substitutions, combinations, and simplifications that do not deviate from the spirit and principles of the present application should be equivalent replacement methods and are included in the protection scope of the present application.
Claims
1. An online analysis method for core drilling data, characterized in that: The method includes: in response to receiving a project creation request, executing a project creation process to register engineering information, the project creation request including a request ID and engineering information; Determine the testing tasks according to the client's testing requirements; In response to receiving the detection task completion information, a corresponding completion flag is set based on the task ID, and the detection information is stored, wherein the task completion information includes the request ID, the project ID, the task ID, and the detection information, and the detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of core drilling equipment, identification code of detection personnel, and video file; In response to receiving a modification request, determining whether the modification authority is available, and if so, performing the modification operation, and if not, feeding back modification rejection information, wherein the modification request includes a request ID, modification location information, and modification content information; In response to receiving an analysis request, reading hole catalog information based on the pile number and the detection record format, performing automated drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile conditions to obtain a pile detection conclusion corresponding to the pile number, the analysis request including a request ID, a project ID, a task ID, and a pile number; In response to receiving a report preparation request, generating a formal report based on the pile number set, generating a browsing sequence number corresponding to the formal report, and using the browsing sequence number and the formal report as a report item to add the report item to a report list, wherein the report preparation request includes a request ID and a pile number set, and the pile number set is determined by a user terminal corresponding to the request ID of the report preparation request; In response to receiving a report viewing request, determining a formal report to be viewed based on the browsing sequence number, and sending the formal report to a user terminal corresponding to a request ID of the report viewing request, wherein the report viewing request includes the request ID and the browsing sequence number; When performing a modification operation, it specifically includes: matching the corresponding block number according to the modification location information, and updating the stored data corresponding to the block number based on the modification content information, and rewriting it into the blockchain to complete the data update; The pile inspection conclusions include pile body integrity category, pile body concrete strength conclusion, sediment conclusion, bearing layer conclusion, and comprehensive evaluation; The pile body integrity categories include Class I, Class II, Class III, and Class IV. The pile body integrity categories are obtained by analyzing the number of holes using a pre-trained pile integrity identification model. The pile integrity identification model is obtained by pre-training multiple sets of data through machine learning. During training, each set of data includes a bar graph and pile body integrity status identification information corresponding to the bar graph. The pile body integrity status identification information includes continuity characteristics, integrity characteristics, height change smoothness characteristics, and cementation status characteristics. When the number of holes is one, a corresponding histogram is input into the pile integrity recognition model for analysis, and then a pile body integrity state identification information obtained by the analysis is judged based on the first pile body integrity judgment rule to obtain a pile body integrity category; When the number of holes is two, the corresponding two histograms are sequentially input into the pile integrity recognition model for analysis, and then based on the second pile body integrity judgment rule, the two pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category; When the number of holes is three, the corresponding three bar graphs are sequentially input into the pile integrity recognition model for analysis, and then based on the third pile body integrity judgment rule, the three pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category; The first pile body integrity judgment rule, the second pile body integrity judgment rule, and the third pile body integrity judgment rule are all determined by matching from a preset rule table according to the number of holes, and the preset rule table is a mapping relationship between the number of holes and the pile body integrity judgment rule; The pile body concrete strength conclusion is set by judging whether the core sample strength is less than a preset pile body concrete strength threshold value. If the core sample strength is less than the preset pile body concrete strength threshold value, the pile body concrete strength conclusion is set with an unsatisfied mark, otherwise, the pile body concrete strength conclusion is set with a satisfied mark; The sediment conclusion is set by judging whether the sediment thickness at the bottom of the pile exceeds a preset sediment thickness threshold. If the sediment thickness at the bottom of the pile exceeds the preset sediment thickness threshold, a dissatisfaction mark is set for the sediment conclusion; otherwise, a satisfaction mark is set for the sediment conclusion. When setting the bearing layer conclusion, if the bearing layer compressive strength is greater than or equal to the preset bearing layer compressive strength threshold and the bearing layer shear strength is greater than or equal to the preset bearing layer shear strength threshold, a satisfied mark is set for the bearing layer conclusion, otherwise the standard penetration hammer number is continued to be judged: the corresponding weathering degree type is matched in the pre-stored lithology weathering degree table according to the standard penetration hammer number, if the weathering degree type matches the preset weathering degree requirement type, a satisfied mark is set for the bearing layer conclusion, if the weathering degree type does not match the preset weathering degree requirement type, a not satisfied mark is set for the bearing layer conclusion; When setting the comprehensive evaluation, if any of the following conditions exists: the pile body integrity category is Class IV pile, the pile body concrete strength conclusion is not satisfied, the sediment conclusion is not satisfied, and the bearing layer conclusion is not satisfied, then the comprehensive evaluation is set to be not satisfied, otherwise, the satisfaction is set; The modified location information is determined by the information association type of the modified content information, including: The corresponding information keywords are screened for the project information, detection tasks, and field record information respectively, and the information association type is determined according to the information keywords. When the modified content information is related to the project information, the modified location information is determined by the project ID. When the modified content information is related to the detection task, the modified location information is determined by the project ID and the task ID. When the modified content information is related to the field record information, the modified location information is determined by the project ID, the task ID, the pile number, and the hole number. Before determining whether the user has the permission to modify, the method further includes: verifying the modified content information based on the modification location information, specifically, determining the information association type corresponding to the modification location information, matching information keywords based on the information association type, and determining whether the information keyword is contained in the process of traversing the modified content information. If the information keyword is contained, the verification succeeds and the step of determining whether the user has the permission to modify is continued. If the information keyword is not contained, the verification fails and the current step is terminated.
2. The method according to claim 1, characterized in that The automated drawing process is performed to obtain a bar graph corresponding to each well, specifically including: Extract key drawing information corresponding to the currently processed hole from basic hole information, round record table, on-site catalog table, core sample strength, and standard penetration information; The key drawing information is converted into a format to obtain the drawing input information, and the key drawing information includes concrete strength grade, pile top elevation, pile length, designed pile diameter, drilling depth, layering information, sampling information, and core sample strength; According to the key information of the drawing, the conditions of the layers above the elevation of the column chart, the properties of the rock formations, the sampling location, the strength of the core sample, and the standard penetration test of the rock formations are judged to obtain the supplementary information of the drawing depth; The basic framework of the histogram is determined based on the drawing input information, the graphic depth of the histogram is filled based on the drawing depth supplementary information, and the graphic library is used to perform graphic visualization conversion, so as to obtain the histogram corresponding to the currently processed hole.
3. The method according to claim 2, characterized in that When judging whether there is permission to modify, the following are specifically included: Determine the corresponding operation permission from the permission management table according to the request ID of the modification request; Whether the permission to modify is available is determined by judging whether the operation permission reaches a preset modification permission threshold. If the operation permission reaches the preset modification permission threshold, the user has the permission to modify; otherwise, the user does not have the permission to modify.
4. The method according to claim 3, characterized in that In performing the project creation process to register the project information, specifically including: Get the request ID of the new project request; Determine the corresponding operation authority from a preset authority management table according to the request ID of the project creation request, wherein the authority management table is used to manage the mapping relationship between the user ID and the operation authority, and the request ID is the user ID that initiates the project creation request; Determine whether the operation authority reaches the preset project creation authority threshold. If the operation authority reaches the preset project creation authority threshold, a new project is created, and the newly created project is supplemented with information based on the project information of the project creation request. If the operation authority does not reach the preset project creation authority threshold, permission prompt information is fed back to the request ID.
5. The method according to claim 4, characterized in that In setting the corresponding completion mark based on the task ID, it specifically includes: checking the request ID of the task completion information based on the authority management table. If there is a user ID in the authority management table that is repeated with the request ID of the task completion information, then setting the completion mark for the detection task based on the task ID, otherwise terminating the current operation.
6. The method according to claim 5, characterized in that In the formal report generated based on the pile number set, it includes: Traverse the pile number set, summarize the bar graphs corresponding to each hole in each pile number to generate a comprehensive bar graph, summarize the pile detection conclusions corresponding to each hole in each pile number to generate a comprehensive conclusion text; Fill the comprehensive bar chart and comprehensive conclusion text into the preset test report template and complete the rendering to obtain the formal report.
7. An online analysis system for core drilling data, characterized in that: The system for executing the online analysis method of drill core data according to claim 1 comprises: A project creation module, configured to execute a project creation process to register engineering information in response to receiving a project creation request, wherein the project creation request includes a request ID and engineering information; The detection task determination module is used to determine the detection task according to the detection requirements of the client; An information storage module, configured to respond to receiving the detection task completion information, set a corresponding completion mark based on the task ID, and store the detection information, wherein the task completion information includes the request ID, the project ID, the task ID, and the detection information, and the detection information includes: core drilling data, standard penetration information, positioning information, time period of video shooting, serial number of the core drilling equipment, identification code of the detection personnel, and video files; An information modification module, configured to determine whether the modification authority is available upon receipt of a modification request, and to perform the modification operation if available, or to feedback modification rejection information if not available, wherein the modification request includes a request ID, modification location information, and modification content information; A pile analysis module, for responding to receiving an analysis request, reading hole catalog information based on the pile number and the detection record format, performing automated drawing processing to obtain a bar graph corresponding to each hole, and analyzing the pile situation to obtain a pile detection conclusion corresponding to the pile number, wherein the analysis request includes a request ID, a project ID, a task ID, and a pile number; A report preparation module, configured to generate a formal report based on a pile number set in response to receiving a report preparation request, generate a browsing sequence number corresponding to the formal report, and use the browsing sequence number and the formal report as a report item to add the report item to a report list, wherein the report preparation request includes a request ID and a pile number set, and the pile number set is determined by a user terminal corresponding to the request ID of the report preparation request; A report viewing module, configured to determine a formal report to be viewed based on a browsing sequence number in response to receiving a report viewing request, and send the formal report to a user terminal corresponding to a request ID of the report viewing request, wherein the report viewing request includes a request ID and a browsing sequence number; The pile inspection conclusions include pile body integrity category, pile body concrete strength conclusion, sediment conclusion, bearing layer conclusion, and comprehensive evaluation; The pile body integrity categories include Class I, Class II, Class III, and Class IV. The pile body integrity categories are obtained by analyzing the number of holes using a pre-trained pile integrity identification model. The pile integrity identification model is obtained by pre-training multiple sets of data through machine learning. During training, each set of data includes a bar graph and pile body integrity status identification information corresponding to the bar graph. The pile body integrity status identification information includes continuity characteristics, integrity characteristics, height change smoothness characteristics, and cementation status characteristics. When the number of holes is one, a corresponding histogram is input into the pile integrity recognition model for analysis, and then a pile body integrity state identification information obtained by the analysis is judged based on the first pile body integrity judgment rule to obtain a pile body integrity category; When the number of holes is two, the corresponding two histograms are sequentially input into the pile integrity recognition model for analysis, and then based on the second pile body integrity judgment rule, the two pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category; When the number of holes is three, the corresponding three bar graphs are sequentially input into the pile integrity recognition model for analysis, and then based on the third pile body integrity judgment rule, the three pile body integrity status identification information obtained by the analysis are judged to obtain the pile body integrity category; The first pile body integrity judgment rule, the second pile body integrity judgment rule, and the third pile body integrity judgment rule are all determined by matching from a preset rule table according to the number of holes, and the preset rule table is a mapping relationship between the number of holes and the pile body integrity judgment rule; The pile body concrete strength conclusion is set by judging whether the core sample strength is less than a preset pile body concrete strength threshold value. If the core sample strength is less than the preset pile body concrete strength threshold value, the pile body concrete strength conclusion is set with an unsatisfied mark, otherwise, the pile body concrete strength conclusion is set with a satisfied mark; The sediment conclusion is set by judging whether the sediment thickness at the bottom of the pile exceeds a preset sediment thickness threshold. If the sediment thickness at the bottom of the pile exceeds the preset sediment thickness threshold, a dissatisfaction mark is set for the sediment conclusion; otherwise, a satisfaction mark is set for the sediment conclusion. When setting the bearing layer conclusion, if the bearing layer compressive strength is greater than or equal to the preset bearing layer compressive strength threshold and the bearing layer shear strength is greater than or equal to the preset bearing layer shear strength threshold, a satisfied mark is set for the bearing layer conclusion, otherwise the standard penetration hammer number is continued to be judged: the corresponding weathering degree type is matched in the pre-stored lithology weathering degree table according to the standard penetration hammer number, if the weathering degree type matches the preset weathering degree requirement type, a satisfied mark is set for the bearing layer conclusion, if the weathering degree type does not match the preset weathering degree requirement type, a not satisfied mark is set for the bearing layer conclusion; When setting the comprehensive evaluation, if any of the following conditions exists: the pile integrity category is Class IV pile, the pile concrete strength conclusion is not satisfied, the sediment conclusion is not satisfied, and the bearing layer conclusion is not satisfied, then the comprehensive evaluation is set with a not satisfied mark; otherwise, a satisfied mark is set.
Citation Information
Patent Citations
Drilled core method detection system and detection method thereof
CN105807007A
Cast-in-place concrete pile core drilling detection method and auxiliary device
CN112627242A
Foundation pile low-strain signal acquisition system
CN114740089A
Core drilling process supervision system and method, medium and computer
CN116166839A
Foundation core drilling method detection report file generation method, system and equipment and storage medium
CN116303448A
