Foundation Pile Testing Data Management Platform

Abstract

This invention discloses a pile foundation testing data management platform. In the field of pile foundation technology, this invention establishes permissions for the tested pile data through a permission setting module. A modification approval module displays modification requests to administrators for review; only after approval are testing personnel allowed to modify the collected data for specific testing items. A testing and evaluation separation module separates the processes of modification by testing personnel from those of reviewers. The permission setting module binds and sets permissions for testing items in all subsequently received manual and automated testing data of pile foundations based on several co-occurrence lists for each pile type. This not only avoids the problem of excessive permissions caused by uniform permission settings, reducing the risk of accidental modification or abuse of permissions and ensuring data security, but also reduces the cumbersome operation of setting permissions individually for multiple related testing items, improving the convenience and accuracy of permission management.

Description

Technical Field

[0001] This invention relates to the field of foundation pile technology, specifically a foundation pile testing data management platform. Background Technology

[0002] In the process of the vigorous development of modern infrastructure construction, foundation piles, as the foundation of buildings, shoulder the key mission of bearing all the loads of the superstructure and safely transferring them to the deep stable soil layer of the foundation. Their quality directly affects the safety and stability of the entire project.

[0003] As a core link in controlling the quality of foundation piles, pile testing uses a variety of professional technical means to accurately measure key parameters such as pile integrity, bearing capacity, and pile material properties. The data obtained is like a "health diagnosis" for engineering construction, providing an indispensable key basis for optimizing the rationality of engineering design and scientific management of the construction process.

[0004] However, due to the complexity of the pile testing work itself, the traditional management model for pile testing data makes it difficult to effectively implement traditional supervision methods. Inappropriate corrections to the original data by the testing personnel often occur, and the authenticity and reliability of the testing data cannot be effectively guaranteed.

[0005] With the rapid development of new-generation information technologies such as 5G, IoT, and big data, the concept of "information intelligence promotes refined management" has been widely applied in various industry regulatory fields. As the core foundation of information intelligence management, the security control and efficient utilization of original data have become the focus of industry attention, and the hierarchical authorization management of original data has emerged.

[0006] In existing technologies, access control for raw data has formed a certain system. Typically, basic permissions are divided according to user roles. For example, for raw data of foundation pile inspection, inspectors only have the permission to upload and view the raw data, while auditors only have the permission to audit the raw data. At the same time, to ensure data accuracy, inspectors lose the permission to modify the raw data after uploading it. If modification is required, an application must be submitted and approved by the administrator, who will then grant temporary modification permissions.

[0007] In existing technologies, there are two methods for setting permissions on original data, but both have obvious shortcomings:

[0008] One approach is to uniformly set permissions for all collected data of the test items included in the original data. In practical applications, when it is necessary to modify the original data, the modification operation often targets multiple items. For example, the characteristic value of the vertical bearing capacity of the foundation pile needs to be calculated using parameters such as pile length, pile diameter, and concrete cube compressive strength. If the pile length is entered incorrectly (e.g., the actual pile length of 20m is mistakenly entered as 18m), the bearing capacity calculated based on this data will inevitably be incorrect. In this case, uniform authorization would give the testing personnel the right to modify all test items in that batch, which would result in excessive permissions and the risk of accidental modification or abuse of permissions, which is not conducive to data security.

[0009] Another approach is to set permissions for each detection item in the original data individually. In this approach, when the inspector needs to modify several detection items in the original data, the administrator needs to grant permissions to the corresponding detection items individually. This is cumbersome and inconvenient, and the frequent permission granting operations will increase the time cost of the administrator and create a management burden. If there are many modification requests, it may also lead to oversights in the review process and affect the accuracy of permission management.

[0010] To address the above problems, this invention proposes a solution. Summary of the Invention

[0011] The purpose of this invention is to provide a foundation pile testing data management platform in order to solve the problems mentioned in the background art.

[0012] This invention provides a foundation pile testing data management platform, including:

[0013] The personnel inspection terminal is used to acquire manual inspection data of the test piles collected at the construction site by the inspection personnel. The manual inspection data includes the collection data of several inspection items. It is also used to acquire modification request information submitted by the inspection personnel, and after receiving the authorization instruction, acquire and transmit the collection data of all inspection items resubmitted by the inspection personnel. The modification request information includes several modification items and the reasons for modification.

[0014] The testing data management platform is used to manage and analyze automated and manual testing data of foundation piles. The testing data management platform includes a permission setting module, a modification approval module, and a modification analysis module.

[0015] The permission setting module is used to store automated and manual inspection data of the foundation piles. When storing the data, it obtains several co-occurrence lists of the foundation pile types based on the foundation pile type.

[0016] For any co-occurrence list obtained, extract all detection items and bind them according to the corresponding collected data extracted from automated detection data and manual detection data, and set the operation permission to view only for each item individually;

[0017] The modification approval module is used to receive modification application information and display it to the administrator for review; if the review is approved, a temporary opening instruction is generated and transmitted to the permission setting module. The temporary opening instruction carries the temporary authorized object, the temporary authorization number and several temporary authorization items.

[0018] The analysis module is modified to store the open record data transmitted by the permission setting module, and analyzes the data after storing the fixed data. During the analysis, based on any type of foundation pile, each detection item of the foundation pile type that can be detected by the foundation pile detection equipment and the detection personnel is used as a benchmark, grouping indicators are set, and several grouping lists based on each detection item are determined.

[0019] The co-occurrence frequency of each group list is calculated using a co-occurrence algorithm. The group list with the highest co-occurrence frequency is selected as a co-occurrence list for the foundation pile type. All elements contained in the selected group list are removed from the remaining group lists to obtain several new group lists. The process of calculating the co-occurrence frequency using the co-occurrence algorithm, selecting the group list with the highest co-occurrence frequency, and removing the corresponding elements is repeated until the number of group lists obtained is 0.

[0020] Furthermore, it also includes a testing equipment terminal, used to collect automated testing data of foundation piles at the construction site. The automated testing data includes data collected from several testing items.

[0021] Furthermore, the personnel detection terminal includes an electronic device, in which a recording app is installed, the recording app being developed based on a mobile operating system.

[0022] Furthermore, the app has several pre-set mandatory detection items. The app performs mandatory detection on all the data collected for all detection items included in the submitted manual detection data. During the detection process, the app searches for the existence of data collected for the corresponding mandatory detection items in all the submitted data according to all the built-in mandatory detection items. If data collected for several mandatory detection items cannot be found, the app generates a prompt message based on the undetected mandatory detection items, prompting the searcher to submit the data collected for the aforementioned mandatory detection items.

[0023] Furthermore, the testing data management platform also includes a testing and evaluation separation module, which separates the process of modification by testing personnel from that of judgment by reviewers. Reviewers only have the right to view the automated testing data and manual testing data of the foundation piles and fill in their evaluation opinions. The system automatically records the operation log.

[0024] Furthermore, the testing data management platform also includes a report generation module, which has 12 built-in report templates that conform to industry standards, supports custom testing item configuration, and automatically fills in and generates PDF reports based on the collected data and evaluation results of several testing items.

[0025] Furthermore, the testing personnel submit modification application information through the recording app, which is transmitted to the modification approval module via the personnel testing terminal. After the management personnel approve it, the modification approval module generates a temporary opening instruction and transmits it to the permission setting module. The permission setting module grants time-limited modification permissions based on the temporary opening instruction. The testing personnel resubmit the data through the recording app, which is transmitted to the permission setting module via the personnel testing terminal. The permission setting module then completes the data replacement, permission reset, and generation and transmission of open record data.

[0026] Furthermore, the permission setting module is also used to grant temporary authorized objects time-limited modification permissions for the corresponding test item collection data after receiving a temporary opening instruction; after receiving the collection data of all several test items that have been resubmitted, it replaces the corresponding test item data in the corresponding automated test data and manual test data, and at the same time resets the operation permission to view only, and generates open record data according to the temporary authorization number in the temporary opening instruction, the pile type of the corresponding test pile and several temporary authorization items, and transmits it to the modification and analysis module for storage.

[0027] Furthermore, the analysis steps for modifying the analysis module to determine several co-occurrence lists of several pile types are as follows:

[0028] S11: Label all pile types that can be detected by inspectors as A1, A2, ..., Aa, where a≥1; label all test items of piles belonging to pile type A1 that can be detected by pile testing equipment and inspectors as B1, B2, ..., Bb, where b≥1;

[0029] S12: Using detection item B1 as the benchmark, set a grouping index c, and let c take values ​​of 0, 1, 2, ..., b-1 in sequence. Each time c takes a value, combine detection item B1 with the corresponding number of detection items to obtain a grouping list D1, D2, ..., Dd based on detection item B1, where d=C. 2 b-1 +...+C e b-1 +2, specifically:

[0030] When c is 0, the detection item B1 is added to an empty list to obtain a group list, and the number of elements in the group list is 1.

[0031] When c is 1, the detection item B1 is combined with the detection items B2, B3, ..., Bb to obtain b-1 group lists. At this time, the number of elements in each of these b-1 group lists is 2.

[0032] When c is 2, any two detection items selected from B2, B3, ..., Bb are combined with detection item B1 to obtain D. 2 b-1 A grouped list, currently in this D 2 b-1 The number of elements in each of the group lists is 3;

[0033] Similarly, when c=e and 3≤e≤b-1, select e detection items from B2, B3, ..., Bb and combine them with detection item B1 to obtain D. e b-1 There are grouped lists, and each group list contains e+1 elements;

[0034] When setting the grouping index c, c means the number of detection items selected from detection items B2, B3, ..., Bb in each grouping list, excluding detection item B1;

[0035] S13: Retrieve all temporary open record data F1, F2, ..., Ff containing pile type A1 from the modification analysis module, where f≥1;

[0036] The temporary open record data F1, F2, ..., Ff are traversed, and the grouping lists D1, D2, ..., Df are calculated sequentially using the co-occurrence algorithm. 2 b-1 The co-occurrence frequency, which characterizes the correlation strength among all detection items included in the grouping list;

[0037] S14: From the grouping list D1, D2, ..., D 2 b-1 The group list with the highest co-occurrence frequency is selected as a co-occurrence list for pile type A1. After selection, all elements contained in the selected group list are extracted, and then the elements in the group lists D1, D2, ..., D... are compared. 2 b-1 By removing all the extracted elements from the corresponding values, we obtain D. 2 b-1 -1 grouping list, and then continue to use the co-occurrence algorithm combined with temporary open record data F1, F2, ..., Ff to calculate D. 2 b-1-1 co-occurrence frequency of the group list, and select the group list with the highest co-occurrence frequency as a co-occurrence list of pile type A1. Repeat the above process until the obtained group list is 0. It should be noted that once a group list is selected as a co-occurrence list of pile type A1, the list will not participate in the further selection process.

[0038] S15: Obtain several co-occurrence lists of pile types 2, A3, ..., Aa in sequence according to S14, and transfer all co-occurrence lists of pile types 1, A2, ..., Aa to the permission setting module;

[0039] The permission setting module receives and stores the list of all co-occurrences of the transmitted piling types 1, A2, ..., Aa.

[0040] Compared with existing technologies, it has the following advantages:

[0041] This invention collects automated and manual inspection data of foundation piles by setting up inspection equipment terminals and personnel inspection terminals, respectively. The automated inspection data includes the collection of data for several inspection items, which relies on the modified foundation pile inspection equipment. The modified foundation pile monitoring equipment integrates a high-performance network communication module, giving it stable network connectivity.

[0042] This invention establishes a permission setting module to configure permissions for automated and manual testing data of foundation piles. A modification approval module receives modification requests and displays them to administrators for review. Only after approval are testing personnel allowed to modify the collected data for specific testing items. This effectively prevents arbitrary modification of testing data by testing personnel. A separate inspection and evaluation module separates the processes of modification by testing personnel from the judgment of reviewers. Reviewers only have viewing permissions for automated and manual testing data of foundation piles and can fill in evaluation comments. This approach enables supervision of testing progress, personnel, technology, and quality, achieving separation of inspection and evaluation of foundation pile testing data and reducing management risks associated with testing.

[0043] This invention analyzes the open record data recorded after each approval modification through a modification analysis module. During the analysis, based on any type of foundation pile, several group lists are determined for each monitoring item. A co-occurrence algorithm is used to filter and obtain several co-occurrence lists for each foundation pile type. The permission setting module then binds and sets permissions for the detection items in all subsequently received manual and automated detection data of foundation piles based on these co-occurrence lists. By binding the collected data of several detection items that are likely to be modified together in each modification with unified permission settings, this invention not only avoids the problem of excessive permissions caused by unified permission settings, reducing the risk of accidental modification or abuse of permissions and ensuring data security, but also reduces the cumbersome operation of setting permissions for multiple related detection items individually, alleviating the time cost and management burden of managers, and improving the convenience and accuracy of permission management.

[0044] This invention features a report generation module with 12 industry-standard report templates and supports custom test item configuration. The module automatically generates a PDF report based on the collected data and evaluation results of several test items, thus reducing the workload of testing personnel.

[0045] This invention digitizes the entire process from task assignment, data collection, review and evaluation, report generation to file management, breaking down information silos, improving testing management efficiency, and promoting the industry's transformation towards intelligence and informatization. Attached Figure Description

[0046] Figure 1 This is a system block diagram of the present invention. Detailed Implementation

[0047] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0048] Please see Figure 1 This application provides a foundation pile testing data management platform, including testing equipment terminals, personnel testing terminals, and a testing data management platform;

[0049] The testing equipment terminal is used to collect automated testing data of foundation piles at the construction site and transmit it to the testing data management platform. The automated testing data includes the collected data of several testing items. The testing equipment terminal includes a modified foundation pile testing device. It should be noted that the collected data of several testing items included in the automated testing data depends on the foundation pile testing device and is directly detected by the foundation pile testing device or calculated based on the calculation logic built into the foundation pile testing device in combination with the directly detected testing items.

[0050] The modification process of the foundation pile testing equipment is as follows:

[0051] First, integrate a high-performance network communication module into the existing pile testing equipment to enable it to have stable network connectivity. It can access the Internet via wired or wireless means (such as Wi-Fi, 4G / 5G networks). While upgrading the hardware, upgrade and optimize the software system on the pile testing equipment, and develop a suitable data acquisition and transmission program. When the pile testing equipment completes the testing task, the automated testing data can be automatically uploaded to the designated testing data management platform immediately through the network.

[0052] To ensure the reliability and security of automated testing data transmission, data encryption technology is used to encrypt the uploaded automated testing data to prevent it from being stolen or tampered with during transmission. Simultaneously, a data caching and verification mechanism is implemented in the pile foundation testing equipment. When a brief network failure occurs, the data can be temporarily stored in the equipment's cache and automatically resumed and verified after network recovery, ensuring data integrity and accuracy. These measures enable real-time, secure, and efficient uploading of testing data, laying a solid foundation for subsequent data management and analysis.

[0053] Taking the MC-6361 multi-channel ultrasonic pile tester as an example, the specific modification steps are as follows:

[0054] Hardware modification details:

[0055] The original USB data interface module was removed, and a SIM7600CE 4G communication module was soldered in. An external antenna was connected using a U.FL interface with an antenna gain ≥5dBi to ensure signal strength. An LC filter circuit was added to the power supply section to suppress interference from the communication module to the detection circuit.

[0056] The motherboard expands the SPI interface to communicate with the communication module, and uses interrupt mode to handle data transmission and reception, ensuring that detection data acquisition and network transmission are processed in parallel without affecting the real-time performance of the detection.

[0057] Software development process:

[0058] The underlying driver is developed based on Android NDK to realize the data interaction between the ADC data acquisition and communication module of the detection device. The sampling rate is configured to 10kHz to meet the high-frequency data requirements of ultrasonic testing.

[0059] Develop a data transmission service that uses the WebSocket protocol to maintain a long connection, and customize the data frame format to include fields such as the detection project ID, device number, data type, and timestamp to ensure data traceability; implement a breakpoint resume algorithm, sort and cache data according to timestamp, and upload it in order after the network is restored.

[0060] Test and verification plan:

[0061] During on-site testing at the Huyi-Meixian Expressway project site, the data upload latency was ≤200ms under a 4G network environment, and no data loss was observed when 100 piles were continuously tested. In tests conducted in areas with weak signals, such as tunnels, the communication module automatically switched to a 2G network to ensure no data loss.

[0062] The personnel inspection terminal is used to collect manual inspection data of foundation piles at the construction site and transmit it to the inspection data management platform. The manual inspection data includes basic information of the foundation piles, inspection location, inspection time, inspection personnel information, and collection data of several inspection items.

[0063] The personnel detection terminal includes an electronic device, which is a device provided by the detection unit to the detection personnel for submitting detection data. In this application, the electronic device is a smartphone.

[0064] The electronic device is equipped with a recording app, which is developed based on a mobile operating system and has a user-friendly interface and a programmed operation process.

[0065] It should be noted that the data collected by the personnel detection terminal includes data on several detection items that are manually detected by the personnel using the detection equipment or can be calculated based on the data of several manually detected detection items.

[0066] The testing personnel first enter the basic information of the foundation piles to be tested, the testing location, the testing time, and the testing personnel information in advance through the recording app. The basic information includes the task order number, task order name, task name, person in charge, name of testing instrument, number of testing instrument and type of foundation pile. The testing personnel information includes the name of the testing personnel and the testing personnel number.

[0067] After the data entry is completed, the collected data of several test items recorded in real time during the test of the test pile will be submitted to the recording app. The test items recorded by the test personnel include, but are not limited to, the concrete strength of the pile body, the verticality of the pile body, and the installation depth of the steel cage. The data of several test items also include several on-site photos and videos.

[0068] During the submission process, the recording app performs mandatory checks on the collected data of all submitted detection items. During the check, the recording app searches for the existence of each mandatory detection item in all submitted collected data according to all mandatory detection items preset by the administrator. If no data for several mandatory detection items is found, a prompt message is generated based on the several mandatory detection items, prompting the searcher to submit the collected data for the several mandatory detection items.

[0069] It should be noted that the app has several mandatory testing items pre-set. These are selected by the administrator from several testing items of pile foundations according to the "Technical Specification for Testing of Building Foundation Piles" (JGJ 106-2014), including but not limited to pile diameter, design pile length, concrete strength, etc. If these are not submitted, the data cannot be obtained, thus ensuring data integrity from the source.

[0070] The testing data management platform is used to manage and analyze the testing data of the foundation piles. The testing data management platform includes a permission setting module, a testing and evaluation separation module, a report generation module, a modification approval module, and a modification analysis module.

[0071] After receiving the automated and manual inspection data of the test piles, the test data management platform transmits them to the permission setting module;

[0072] The permission setting module is used to store and set operation permissions for the automated and manual detection data of the foundation piles. In this application, the types of operation permissions set include two types: view only and temporary modification permission. View only means that the corresponding data can only be viewed, and temporary modification permission means that the collected data of the corresponding detection item can be modified. Modification includes adding, deleting, modifying and querying the collected data.

[0073] After receiving the transmitted automated and manual inspection data of the test piles, the permission setting module stores them. During the storage process, the operation permissions of the automated and manual inspection data are uniformly set to "view only".

[0074] The inspection and evaluation separation module is used to separate the process of the initial judgment by the inspectors and the secondary judgment by the auditors. The auditors only have the operation permission to view the automated inspection data and manual inspection data of the foundation piles and fill in the evaluation comments. The system automatically records the operation log.

[0075] The report generation module has 12 built-in report templates that conform to industry standards, supports custom test item configuration, and automatically fills in and generates PDF reports based on the collected data and evaluation results of several test items. The generation time is ≤30 seconds per report, which is 85% more efficient than manual writing and reduces the paperwork workload of testing personnel.

[0076] The modification approval module is used by administrators to approve modification requests submitted by testing personnel. The modification request information includes the modification task number, several modification items, and the reason for modification. The modification task number represents the task order number to be modified, which helps the system quickly find the corresponding automated testing data and manual testing data of the test pile.

[0077] The modification items indicate the detection items corresponding to the collected data to be modified. The reason for modification is a textual explanation of why the modification is necessary, so that managers can quickly assess the necessity of the modification.

[0078] The testing personnel submit modification request information through the recording app, which is then acquired by the personnel's testing terminal and transmitted to the testing data management platform. After receiving the transmitted modification request record, the testing data management platform transmits it to the modification approval module.

[0079] After receiving the transmitted modification application information, the modification approval module displays it to the administrator. The administrator reviews and approves the reasons for the modifications described in the modification application information. If the review is approved, a temporary opening instruction is generated. The temporary opening instruction carries a temporary authorization object, a temporary authorization number, and several temporary authorization items. The temporary authorization object refers to the testing personnel who submitted the modification application information, the temporary authorization number is the modification task number carried in the modification application record, and the temporary authorization items are the modification items carried in the modification application record.

[0080] The modification approval module transmits the temporary opening instruction to the permission setting module. After receiving the transmitted temporary opening instruction, the permission setting module finds the automated and manual inspection data of the corresponding inspection piles according to the temporary authorization number carried in the temporary opening instruction. Based on the several temporary authorization items and temporary authorization objects carried in the temporary opening instruction, the module grants the temporary authorization object the operation permission to collect the corresponding inspection items for the automated and manual inspection data. The operation permission type is temporarily modified to time-limited modification permission. After the modification is completed, an authorization instruction is generated and transmitted to the personnel inspection terminal.

[0081] After receiving the authorization instruction, the personnel detection terminal displays it to the corresponding detection personnel for viewing. The detection personnel resubmit the collected data of several corresponding detection items through the recording app. After submission, the personnel detection terminal obtains the collected data of all submitted detection items and transmits it to the permission setting module.

[0082] After receiving the collected data of all the detection items after transmission, the permission setting module replaces the collected data of the corresponding detection items in the automated detection data and manual detection data of the detected foundation piles. At the same time, the operation permission of the replaced collected data of the corresponding detection items is set to "view only". After the setting is completed, the permission setting module finds the foundation pile type of the corresponding foundation pile according to the temporary authorization number carried in the temporary opening instruction, generates the opening record data of the temporary opening instruction according to the foundation pile type and several temporary authorization items carried in the temporary opening instruction, and transmits the opening record data to the modification and analysis module for storage.

[0083] If the review fails, a failure instruction is generated and transmitted to the personnel inspection terminal, which then displays it to the inspection personnel for review. The failure instruction contains the reason for failure entered by the administrator based on the modification application record.

[0084] The modification analysis module is used to analyze open record data containing a fixed amount of modification application information to determine a co-occurrence list of several pile types. The open record data includes pile types and several detection items. The analysis steps are as follows:

[0085] S11: Label all pile types that can be detected by inspectors as A1, A2, ..., Aa, where a≥1; label all test items of piles belonging to pile type A1 that can be detected by pile testing equipment and inspectors as B1, B2, ..., Bb, where b≥1;

[0086] S12: Using detection item B1 as the benchmark, set a grouping index c, and let c take values ​​of 0, 1, 2, ..., b-1 in sequence. Each time c takes a value, combine detection item B1 with the corresponding number of detection items to obtain a grouping list D1, D2, ..., Dd based on detection item B1, where d=C. 2 b-1 +...+C e b-1 +2, specifically:

[0087] When c is 0, the detection item B1 is added to an empty list to obtain a group list, and the number of elements in the group list is 1.

[0088] When c is 1, the detection item B1 is combined with the detection items B2, B3, ..., Bb to obtain b-1 group lists. At this time, the number of elements in each of these b-1 group lists is 2.

[0089] When c is 2, any two detection items selected from B2, B3, ..., Bb are combined with detection item B1 to obtain D. 2 b-1 A grouped list, currently in this D 2 b-1 The number of elements in each of the group lists is 3;

[0090] Similarly, when c=e and 3≤e≤b-1, select e detection items from B2, B3, ..., Bb and combine them with detection item B1 to obtain D. e b-1 There are grouped lists, and each group list contains e+1 elements;

[0091] It should be noted here that when setting the grouping index c, c means the number of detection items selected from detection items B2, B3, ..., Bb in each grouping list, excluding detection item B1;

[0092] S13: Retrieve all open record data F1, F2, ..., Ff containing piles of type A1 from the modification analysis module, where f ≥ 1;

[0093] The system iterates through all detection items contained in the open-record data F1, F2, ..., Ff, and uses a co-occurrence algorithm to sequentially calculate and obtain the grouping lists D1, D2, ..., Df. 2 b-1 The co-occurrence frequency, which characterizes the correlation strength among all detection items included in the grouping list;

[0094] S14: From the grouping list D1, D2, ..., D 2 b-1 The group list with the highest co-occurrence frequency is selected as a co-occurrence list for pile type A1. After selection, all elements contained in the selected group list are extracted, and then the elements in the group lists D1, D2, ..., D... are compared. 2 b-1 By removing all the extracted elements from the corresponding values, we obtain D. 2 b-1 -1 grouping list, and then continue to use the co-occurrence algorithm to combine the open record data F1, F2, ..., Ff to calculate D. 2 b-1-1 co-occurrence frequency of the group list, and select the group list with the highest co-occurrence frequency as a co-occurrence list of pile type A1. Repeat the above process until the obtained group list is 0. It should be noted that once a group list is selected as a co-occurrence list of pile type A1, the list will not participate in the further selection process.

[0095] S15: Obtain a list of co-occurrences of pile types 2, A3, ..., Aa in sequence according to S14;

[0096] The modification analysis module transmits the co-occurrence list of all pile types 1, A2, ..., Aa to the permission setting module;

[0097] After receiving the list of all co-occurrences of the transmitted pile types 1, A2, ..., Aa, the permission setting module stores it.

[0098] Once the automated and manual inspection data of the next pile foundation is transmitted to the permission setting module, the permission setting module will set permissions for the automated and manual inspection data. The permission settings are as follows:

[0099] Based on the pile type of the detected pile, obtain a list of several co-occurrences of the pile type from the permission setting module;

[0100] For any co-occurrence list of the obtained pile types, first extract all detection items from it, and then extract the corresponding collection data from the automated detection data and manual detection data based on these detection items. Bind all the extracted collection data and set operation permissions for them individually. The operation permissions are set to view only.

[0101] After setting the operation permissions for all data collected from the automated and manual inspection data based on the co-occurrence list of all pile types, operation permissions are uniformly set for all remaining data, with the operation permissions set to "view only".

[0102] Some of the data in the above formulas are numerical calculations with dimensions removed, and the contents not described in detail in this specification are all prior art known to those skilled in the art.

[0103] The above embodiments are only used to illustrate the technical methods of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical methods of the present invention without departing from the spirit and scope of the technical methods of the present invention.

Claims

1. A foundation pile testing data management platform, characterized in that, include: The personnel inspection terminal is used to acquire manual inspection data of the test piles collected at the construction site by the inspection personnel. The manual inspection data includes the collection data of several inspection items. It is also used to acquire modification request information submitted by the inspection personnel, and after receiving the authorization instruction, acquire and transmit the collection data of all inspection items resubmitted by the inspection personnel. The modification request information includes several modification items and the reasons for modification. The testing data management platform is used to manage and analyze automated and manual testing data of foundation piles. The testing data management platform includes a permission setting module, a modification approval module, and a modification analysis module. The permission setting module is used to store automated and manual inspection data of the tested piles. When storing the data, it obtains several co-occurrence lists of the pile types based on the pile type of the tested pile. For any co-occurrence list obtained, extract all detection items and bind them according to the corresponding collected data extracted from automated detection data and manual detection data, and set the operation permission to view only for each item individually; The modification approval module is used to receive modification application information and display it to the administrator for review; if the review is approved, a temporary opening instruction is generated and transmitted to the permission setting module. The temporary opening instruction carries the temporary authorized object, the temporary authorization number and several temporary authorization items. The analysis module is modified to store the open record data transmitted by the permission setting module, and analyzes the data after storing the fixed data. During the analysis, based on any type of foundation pile, each detection item of the foundation pile type that can be detected by the foundation pile detection equipment and the detection personnel is used as a benchmark, grouping indicators are set, and several grouping lists based on each detection item are determined. The co-occurrence frequency of each group list is calculated using a co-occurrence algorithm. The group list with the highest co-occurrence frequency is selected as a co-occurrence list for the pile type. All elements contained in the selected group list are removed from the remaining group lists to obtain several new group lists. The process of calculating the co-occurrence frequency using the co-occurrence algorithm, selecting the group list with the highest co-occurrence frequency and removing the corresponding elements is repeated until the number of group lists obtained is 0.

2. The foundation pile testing data management platform according to claim 1, characterized in that, It also includes a testing equipment terminal, used to collect automated testing data of foundation piles at the construction site. The automated testing data includes the collection data of several testing items.

3. The foundation pile testing data management platform according to claim 1, characterized in that, The personnel detection terminal includes an electronic device, in which a recording app is installed. The recording app is developed based on a mobile operating system.

4. The foundation pile testing data management platform according to claim 3, characterized in that, The app has several pre-set mandatory detection items. The app performs mandatory detection on all the data collected for each of the detection items included in the submitted manual detection data. During the detection process, the app searches for the existence of data for each mandatory detection item in all the submitted data. If data for several mandatory detection items cannot be found, the app generates a prompt message based on the undetected mandatory detection items, prompting the user to submit the data for those mandatory detection items.

5. The foundation pile testing data management platform according to claim 1, characterized in that, The testing data management platform also includes a testing and evaluation separation module, which separates the process of testing personnel modifying data from that of reviewers. Reviewers only have the right to view the automated testing data and manual testing data of the foundation piles and fill in their evaluation opinions. The system automatically records the operation log.

6. The foundation pile testing data management platform according to claim 1, characterized in that, The testing data management platform also includes a report generation module, which has 12 built-in report templates that conform to industry standards, supports custom testing item configuration, and automatically fills in and generates PDF reports based on the collected data and evaluation results of several testing items.

7. The foundation pile testing data management platform according to claim 4, characterized in that, The testing personnel submit modification request information through the recording app, which is then transmitted to the modification approval module via the personnel testing terminal. After the management personnel approve it, the modification approval module generates a temporary opening instruction and transmits it to the permission setting module. The permission setting module grants time-limited modification permissions based on temporary opening instructions. Inspectors resubmit data through the recording app, which is then transmitted to the permission setting module via the personnel's inspection terminal. The permission setting module then completes data replacement, permission reset, and the generation and transmission of opening record data.

8. The foundation pile testing data management platform according to claim 1, characterized in that, The permission setting module is also used to grant temporary authorized objects time-limited modification permissions for the corresponding test item collection data after receiving a temporary opening instruction; after receiving the collection data of all several test items that have been resubmitted, it replaces the corresponding test item data in the corresponding automated test data and manual test data, and at the same time resets the operation permission to view only, and generates open record data according to the temporary authorization number in the temporary opening instruction, the pile type of the corresponding test pile and several temporary authorization items, and transmits it to the modification and analysis module for storage.

9. The foundation pile testing data management platform according to claim 1, characterized in that, The analysis steps for modifying the analysis module to determine several co-occurrence lists of several pile types are as follows: S11: Label all pile types that can be detected by inspectors as A1, A2, ..., Aa, where a≥1; label all test items of piles belonging to pile type A1 that can be detected by pile testing equipment and inspectors as B1, B2, ..., Bb, where b≥1; S12: Using detection item B1 as the benchmark, set a grouping index c, and let c take values ​​of 0, 1, 2, ..., b-1 in sequence. Each time c takes a value, combine detection item B1 with the corresponding number of detection items to obtain a grouping list D1, D2, ..., Dd based on detection item B1, where d=C. 2 b-1 +...+C e b-1 +2, specifically: When c is 0, the detection item B1 is added to an empty list to obtain a group list, and the number of elements in the group list is 1. When c is 1, the detection item B1 is combined with the detection items B2, B3, ..., Bb to obtain b-1 group lists. At this time, the number of elements in each of these b-1 group lists is 2. When c is 2, any two detection items selected from B2, B3, ..., Bb are combined with detection item B1 to obtain D. 2 b-1 A grouped list, currently in this D 2 b-1 The number of elements in each of the group lists is 3; Similarly, when c=e and 3≤e≤b-1, select e detection items from B2, B3, ..., Bb and combine them with detection item B1 to obtain D. e b-1 There are grouped lists, and each group list contains e+1 elements; When setting the grouping index c, c means the number of detection items selected from detection items B2, B3, ..., Bb in each grouping list, excluding detection item B1; S13: Retrieve all temporary open record data F1, F2, ..., Ff containing pile type A1 from the modification analysis module, where f≥1; The temporary open record data F1, F2, ..., Ff are traversed, and the grouping lists D1, D2, ..., Df are calculated sequentially using the co-occurrence algorithm. 2 b-1 The co-occurrence frequency, which characterizes the correlation strength among all detection items included in the grouping list; S14: From the grouping list D1, D2, ..., D 2 b-1 The group list with the highest co-occurrence frequency is selected as a co-occurrence list for pile type A1. After selection, all elements contained in the selected group list are extracted, and then the group lists D1, D2, ..., D... are used to identify the co-occurrence groups. 2 b-1 By removing all the extracted elements from the corresponding values, we obtain D. 2 b-1 -1 grouping list, and then continue to use the co-occurrence algorithm combined with temporary open record data F1, F2, ..., Ff to calculate D. 2 b-1 -1 co-occurrence frequency of the group list, and select the group list with the highest co-occurrence frequency as a co-occurrence list of pile type A1. Repeat the above process until the obtained group list is 0. Each time a group list is selected as a co-occurrence list of pile type A1, the list will not participate in the further selection process. S15: Obtain several co-occurrence lists of pile types 2, A3, ..., Aa in sequence according to S14, and transfer all co-occurrence lists of pile types 1, A2, ..., Aa to the permission setting module; The permission setting module receives and stores the list of all co-occurrences of the transmitted piling types 1, A2, ..., Aa.

Images