Engineering investigation report generation and delivery system and method

Abstract

The invention discloses an engineering investigation report generation and delivery system and method, and belongs to the technical field of engineering investigation. The system comprises a historical engineering project database which can acquire and store foundation processing related data of historical engineering projects; the project database can obtain original and processed data of on-site investigation as a basic data source for report generation, and is directly associated with a dynamic field of a report template; the report generation module can read data in the project database and perform statistics and calculation; the report generation module is used for analyzing a template and generating content, identifying a dynamic label, filling statistical data into a corresponding position, and retrieving similar cases from a historical engineering project database module to generate content of non-common chapters, so that a complete report in a preset format is generated; and the reconnaissance result delivery module can carry out electronic delivery of the report. According to the method, the problems that traditional data statistics and report compiling are separated, and artificial transcription is prone to errors can be solved, and a scientific and efficient engineering investigation report is obtained.

Description

Technical Field

[0001] This invention belongs to the field of engineering survey technology, specifically relating to an engineering survey report generation and delivery system and method. Background Technology

[0002] An engineering survey report generally consists of two parts: The first part mainly describes the site's stratigraphic distribution, stratigraphic parameters, and site properties, objectively reflecting the site's geological characteristics. The content of this part is basically consistent across different projects, with differences only in statistical data and evaluations of relevant stratigraphic layers; therefore, this part is defined as a common section of the engineering survey report. The second part mainly focuses on the foundation treatment plan. It requires considering the site's geological characteristics and building characteristics (height, load, foundation type, etc.), and based on existing engineering experience, to propose a scientific, economical, and safe foundation treatment plan for the proposed building in this project. The description of this part varies significantly across different projects; therefore, this part is defined as a non-common section of the engineering survey report.

[0003] The traditional method for writing engineering survey reports is as follows: (1) The original engineering survey data is input into mature commercial software by manual input, the stratigraphy is divided manually, and the software is used to generate the stratification test data table, workload table, etc. The engineering survey report is written manually. During the process, the data statistically generated by the commercial software is filled into the corresponding position of the engineering survey report. This process is inefficient and prone to errors.

[0004] (2) Some software has developed a report generation function, but the generated report content is simple, statistical data is represented by spaces, and the text content is monotonous and not very usable. There is no description of non-common foundation treatment, and a lot of manual modification is still required later.

[0005] Traditionally, engineering survey reports are delivered to owners and relevant users in the form of paper reports and accompanying PDF electronic documents. While engineering survey results primarily present site geological features and foundation treatment methods, the paper reports and electronic documents are not intuitive and result in low user browsing efficiency.

[0006] Therefore, the following three key technical problems exist in the existing technology: 1. Technical problems of low efficiency and susceptibility to errors in the preparation of engineering survey reports. In existing technologies, the preparation of engineering survey reports mainly relies on manual methods, requiring engineers to manually fill in the survey data statistics results into the report template one by one. This results in: the separation of data statistics and report preparation, requiring multiple manual transcriptions, which is prone to data errors; the report template is fixed and cannot be automatically adjusted according to the characteristics of the project; and there is a lack of unified textual expression standards, with report quality depending on personal experience.

[0007] 2. Technical problems stemming from a lack of scientific basis in foundation treatment schemes. Existing engineering survey report generation software cannot provide suggestions for foundation treatment schemes. Engineers can only rely on personal experience to select schemes, which has many technical limitations: there is a lack of systematic comparative analysis methods for historical engineering cases; it is impossible to quantify the similarity of different engineering conditions; and the scientific and economic feasibility of foundation treatment scheme selection is difficult to guarantee.

[0008] 3. Technical problems such as outdated delivery methods and low efficiency in reviewing survey results. Traditional exploration results are delivered in the form of paper reports and PDF electronic documents, which makes the following: two-dimensional charts are not intuitive enough and cannot present geological structures in three dimensions; the delivery medium is fixed, and users can only passively receive the information, lacking interactivity; and exploration results are limited by time and location, making it impossible to access them anytime and anywhere. Summary of the Invention

[0009] The present invention aims to at least partially solve one of the technical problems in the aforementioned related technologies.

[0010] Therefore, the purpose of this invention is to provide an engineering survey report generation and delivery system and method that can solve the problems of traditional "separation of data statistics and report preparation and error-prone manual transcription" and obtain scientific and efficient engineering survey reports.

[0011] To solve the above-mentioned technical problems, the present invention is implemented as follows: This invention provides an engineering survey report generation and delivery system, the system comprising: The historical engineering project database module is configured to acquire and store foundation treatment-related data for historical engineering projects; The project database module is configured to acquire raw and processed data from the site survey as the basic data source for report generation, and is directly associated with the dynamic fields of the report template. The report generation module is configured to read project database data and perform statistics and calculations; it can parse templates and generate content, identify dynamic tags and fill statistical data into the corresponding positions, and retrieve similar cases from the historical engineering project database module to generate content for non-common chapters, thereby generating a complete report in a preset format; The survey results delivery module is configured to enable electronic delivery of reports.

[0012] In addition, the engineering survey report generation and delivery system according to the present invention may also have the following additional technical features: In some of these implementations, the foundation treatment-related data includes: project data, building characteristic data, site data, geological parameter data, actual foundation treatment scheme data, and foundation monitoring and settlement observation data.

[0013] In some implementations, the underlying data sources include project location data, personnel data, borehole data, engineering stratification data, geotechnical test data, and in-situ test data.

[0014] In some implementations, the report generation module calculates formation thickness, bearing capacity characteristic value, and compression modulus.

[0015] In some implementations, the report generation module uses a comprehensive similarity calculation method combining weighted Euclidean distance and fuzzy matching to determine similar cases when searching for similar cases.

[0016] In some implementations, the complete report generated by the report generation module is in the format of a standard Word document and a PDF document.

[0017] In some implementations, the exploration results delivery module adopts a dual-platform architecture of Web and mobile terminals, including the exploration enterprise terminal and the user terminal; The exploration company's client is configured to generate lightweight 3D geological models, manage report documents, create user accounts and permissions, generate unique sharing links and QR codes, and convert MDB data into a JSON format adapted for web / mobile devices. The user terminal is configured to be accessible via a web browser and mobile responsive access, and can view 3D geological models, borehole columnar sections, and report documents, supporting permission verification and report download.

[0018] This invention also provides a method for generating and delivering an engineering survey report, the method comprising: S1. Data Reading: Extracting the basic data source from the project database; S2. Data Statistics: Calculate statistical parameters including formation thickness, bearing capacity characteristic value and compression modulus; S3. Template parsing: Reads the pre-made report template and identifies dynamic tags; S4. Intelligent Matching: Using a similarity algorithm-based judgment method, the system retrieves the most similar cases from the historical engineering project database and recommends foundation treatment solutions. S5. Content Generation: Fill the statistical data from S12 and the matching results from S14 into the corresponding tag positions in the template, and assemble the common and non-common chapters. S6. Output in format, generating Word and PDF versions of the report; S7. Deliverables.

[0019] In addition, the engineering survey report generation and delivery system according to the present invention may also have the following additional technical features: In some of these implementations, the deliverables steps include: S71. The exploration company generates a 3D geological model, converts data formats, creates user permissions, and allows sharing links or QR codes. S72. Users can access the site via QR code or browser and view the 3D model, drilling data, and report documents after authorization.

[0020] In some of these implementations, in step S4, the overall similarity is calculated as Σ(Wi×Si) / Σ(Wi). Where Wi is the weight coefficient of the i-th data class, and Si is the similarity score of the i-th data class; Weighting: Building feature data 36-42%, site data 32-36%, foundation soil data 24-27%, with the sum of the weights of the three being 1.

[0021] Compared with the prior art, the present invention has at least the following beneficial effects: In this embodiment of the invention, the provided engineering survey report generation and delivery system directly links the project database with the report template, and realizes "one-time entry and automatic reuse" of data through dynamic tag replacement, solving the problem of "separation of data statistics and report preparation, and easy error in manual transcription" in the traditional system; In this embodiment of the invention, the engineering survey report generation and delivery system provides a historical engineering database and a similarity algorithm, which breaks through the limitation of traditional systems that "cannot generate non-common chapters (foundation treatment schemes)" and realizes the scientific recommendation of foundation treatment schemes. In this embodiment of the invention, the engineering survey report generation and delivery system automatically generates common chapters of engineering survey reports based on the survey project database, resulting in high report compilation efficiency and strong data accuracy. In this embodiment of the invention, the engineering survey report generation and delivery system provides a method for comparing and reversing the most suitable foundation treatment scheme for the project based on an existing engineering database. It outputs non-common sections of the engineering survey report, with highly scientific foundation treatment content and a complete generated report. In this embodiment of the invention, the engineering survey report generation and delivery system provides highly visualized and practical survey results, and the survey results can be viewed without time or location restrictions.

[0022] Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0023] Figure 1 This is a framework diagram of an engineering survey report generation and delivery system disclosed in one embodiment of the present invention; Figure 2 This is a flowchart of a report generation process disclosed in one embodiment of the present invention; Figure 3 This is a schematic diagram of mobile terminal delivery disclosed in one embodiment of the present invention. Detailed Implementation

[0024] 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, not all, of the embodiments of the present invention. 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.

[0025] The embodiments of the present invention will be described in detail below with reference to the accompanying drawings and specific examples and application scenarios.

[0026] Please see Figure 1 As shown, in some embodiments of the present invention, a method for generating and delivering engineering survey reports is provided. This method establishes a direct link between a project database module and a report template library, employing pre-built chapter assembly technology and dynamic tag replacement methods to achieve automated generation from survey data to a complete report. By establishing a historical engineering project database module and using a similarity calculation algorithm combining weighted Euclidean distance and fuzzy matching, intelligent foundation treatment scheme recommendations based on historical case big data are achieved. Furthermore, by developing a survey results delivery module and employing responsive web technology, online display of 3D geological models, mobile adaptation, and digital delivery are achieved, overcoming the technical limitations of traditional delivery methods.

[0027] In some embodiments of the present invention, an engineering survey report generation and delivery system is provided, comprising a historical engineering project database module, a project database module, a report template library, a report generation module, and a survey result delivery module. The historical engineering project database module, the project database module, and the report template library constitute the data layer; the report generation module constitutes the application layer; and the survey result delivery module constitutes the presentation layer.

[0028] In some embodiments of the present invention, the historical engineering project database module, based on tens of thousands of engineering projects completed by the applicant both domestically and internationally, aggregates key data into a large database, laying the foundation for data comparison with new projects. This includes project data, building characteristic data, site data, stratum distribution data, stratum bearing capacity data, stratum pile foundation parameter data, building foundation soil layer data, actual foundation scheme data used for buildings, foundation monitoring data, and building settlement observation data.

[0029] In some embodiments of the present invention, the project database module refers to the data obtained from the on-site survey and the processed data. The specific database format is mdb, which includes the project location data, personnel data, borehole data, engineering layer number, geotechnical test data and in-situ test data.

[0030] In some embodiments of the present invention, the report generation module accesses and reads all data from the project database, and has the function of statistical calculation of the data. It includes built-in text templates for each chapter of the report and dynamic fields to be replaced; the dynamic fields are replaced according to the data read from the project database. The built-in report template is a unified civil engineering model template, including site location descriptions, test data, etc., such as: 1. Introduction This project is located on P1, and P2 is responsible for the construction drawing design. ... 2.1 Geological Structure This project is located at P1, and the surrounding geological faults are D1 (D2, D3)...

[0031] In the above embodiments, when generating common sections of the report, the corresponding text content is retrieved and assembled according to the site location, and the corresponding field positions are filled in according to the calculation or statistical results such as the amount of water collapse, the compression modulus, and the workload statistics.

[0032] In the above embodiments, when generating non-common sections of the report, the building characteristic data, site data, and building foundation soil layer data of this project are compared with the corresponding parameters in the existing engineering database to find the most similar engineering cases and foundation treatment schemes, which are displayed in a list. The most suitable foundation treatment scheme is manually checked and selected. After clicking confirm, the retrieved foundation treatment scheme is provided to the building of this project, and the foundation treatment section of the engineering survey report (non-common section) is further generated.

[0033] A comprehensive similarity calculation method combining weighted Euclidean distance and fuzzy matching is adopted. The specific algorithm is as follows: Overall similarity = Σ(Wi×Si) / Σ(Wi) Where Wi is the weight coefficient of the i-th data class, and Si is the similarity score of the i-th data class.

[0034] Weighting: Building feature data 36-42%, site data 32-36%, foundation soil data 24-27%.

[0035] For numerical parameters, normalization is used for calculation: Si = 1 - |Vi - Vj| / (Vmax - Vmin). For categorical parameters, multi-level matching is used: perfect match 1.0, same category (1.0 > Si ≥ 0.8), similar category (0.8 > Si ≥ 0.5), related category (0.5 > Si ≥ 0.2), irrelevant (0.2 > Si ≥ 0).

[0036] In some embodiments of the present invention, the exploration results delivery module adopts a dual-platform architecture of Web + mobile terminal, including two main parts: the exploration enterprise terminal and the user terminal.

[0037] In this embodiment, the exploration enterprise terminal (Web management terminal) generates a lightweight 3D geological model for web browsers based on the project database module, manages engineering exploration report documents, creates user accounts, and sets access permissions. It also generates a unique sharing link and QR code for each project, converting MDB format data into a data format compatible with both web and mobile devices. The exploration enterprise terminal, implemented using web technology, possesses the following core functions: 3D model generation: A lightweight 3D geological model for web-based applications is automatically generated based on the project's database module.

[0038] Results document management: Uploading, storing, and managing the final version of the engineering survey report document.

[0039] Access control system: Create user accounts and set access permissions and validity periods for different users.

[0040] Share link generation: Generate a unique share link and corresponding QR code for each project.

[0041] Data format conversion: Convert MDB format data into JSON format suitable for display on web and mobile devices.

[0042] In this embodiment, the user terminal supports both web browser access and mobile responsive access. Authorized personnel can view the 3D geological model, building foundation information, and engineering survey report through a browser or by scanning a QR code, realizing the digital delivery of survey results.

[0043] Web-based user interface: Allows authorized personnel to log in and access via a browser; provides complete 3D geological model viewing functionality; allows viewing of design parameters, foundation soil layer distribution, and foundation treatment schemes for each building; supports downloading PDF versions of engineering survey reports.

[0044] View on mobile: The process is as follows Figure 3 As shown, access is granted by scanning a QR code to obtain the project ID or by directly accessing the link; permission verification is performed, including invalidation checks and password verification; mobile-optimized display is based on data provided by the exploration company, achieving digital delivery. Responsive web technology is adopted, supporting access on mobile phones and tablets; mobile-optimized functions such as 3D geological models, borehole columnar sections, and drawing viewing are provided.

[0045] In some embodiments of the present invention, such as Figure 2As shown, the specific process for generating the report includes: Step 1: Data Reading: Extract drilling data, test data, and engineering layering data from the MDB format project database.

[0046] Step 2, Data Statistical Calculation: Automatically calculates and statistically analyzes parameters such as formation thickness, bearing capacity characteristic value, and compression modulus.

[0047] Step 3: Template parsing: Read the prefabricated report template and identify dynamic label fields such as P1 (project location) and D1 (geological fault).

[0048] Step 4, Intelligent Matching: Use a similarity algorithm to retrieve the most similar cases from the historical engineering database and match the foundation treatment scheme.

[0049] Step 5, Content Generation (Template Filling): Fill the statistical data and matching results into the corresponding tag positions in the template to generate a complete report document. Tag filling can be done through dynamic tag replacement.

[0050] Step 6, Formatted Output: Generate standard formatted Word and PDF documents for output.

[0051] Example 1:

[0052] Take a high-rise building project as an example.

[0053] 1. Data Input Stage: Enter the data from 15 boreholes obtained from the field survey into the MDB format database, including borehole coordinates, stratigraphic distribution, standard penetration test data, etc.

[0054] 2. Report Generation Stage: The system reads borehole data from ZK1 to ZK15, automatically calculates the thickness distribution of each stratum, and determines the bearing capacity characteristic value to be 180 kPa. Five similar cases are retrieved from the historical database using a similarity algorithm, with overall similarity scores of 0.89, 0.85, 0.82, 0.78, and 0.75, respectively. The case with the highest similarity, P001 (a 29-story office building project), is selected, and its foundation treatment scheme is extracted: prestressed concrete pipe piles + pile raft foundation. The statistical data and matching scheme are then entered into the report template to generate a complete engineering survey report containing both common and non-common sections.

[0055] 3. Digital Delivery Phase: A unique QR code is generated for the project, and an access password is set. Construction unit technicians scan the code and enter the password to view the 3D geological model, borehole columnar section, and cross-sectional drawings on their mobile devices. A complete PDF report can be downloaded at any time.

[0056] Through comparative experiments, the following conclusions were drawn: a. Report generation efficiency is improved by more than 90%, reducing the time from 8 hours of traditional manual compilation to within 30 minutes; b. The similarity matching algorithm achieves an accuracy rate of over 85%, significantly improving the scientific rigor of the foundation treatment scheme; c. The mobile delivery system has a response time of less than 3 seconds and supports real-time rendering of 1000+ borehole data.

[0057] Any part of this invention not described in detail can be referred to in the prior art or in the art known to those skilled in the art. This embodiment does not limit such part and will not describe it in detail here.

[0058] The embodiments of the present invention have been described above with reference to the accompanying drawings. However, the present invention is not limited to the specific embodiments described above. The specific embodiments described above are merely illustrative and not restrictive. Those skilled in the art can make many other forms under the guidance of the present invention without departing from the spirit and scope of the claims, and all of these forms are within the protection scope of the present invention.

Claims

1. An engineering survey report generation and delivery system, characterized in that, The system includes: The historical engineering project database module is configured to acquire and store foundation treatment-related data for historical engineering projects; The project database module is configured to acquire raw and processed data from the site survey as the basic data source for report generation, and is directly associated with the dynamic fields of the report template. The report generation module is configured to read project database data and perform statistics and calculations; it can parse templates and generate content, identify dynamic tags and fill statistical data into the corresponding positions, and retrieve similar cases from the historical engineering project database module to generate content for non-common chapters, thereby generating a complete report in a preset format; The survey results delivery module is configured to enable electronic delivery of reports.

2. The engineering survey report generation and delivery system according to claim 1, characterized in that, The foundation treatment-related data includes: project data, building characteristic data, site data, stratum parameter data, actual foundation treatment scheme data, and foundation monitoring and settlement observation data.

3. The engineering survey report generation and delivery system according to claim 1, characterized in that, The basic data sources include project location data, personnel data, borehole data, engineering stratification data, geotechnical test data, and in-situ test data.

4. The engineering survey report generation and delivery system according to claim 1, characterized in that, The report generation module calculates the formation thickness, bearing capacity characteristic value, and compression modulus.

5. The engineering survey report generation and delivery system according to claim 1, characterized in that, The report generation module uses a comprehensive similarity calculation method combining weighted Euclidean distance and fuzzy matching to determine similar cases when searching for similar cases.

6. The engineering survey report generation and delivery system according to claim 1, characterized in that, The complete report generated by the report generation module is in the format of a standard Word document and a PDF document.

7. The engineering survey report generation and delivery system according to claim 1, characterized in that, The exploration results delivery module adopts a dual-platform architecture of Web and mobile terminals, including the exploration enterprise terminal and the user terminal; The exploration company's client is configured to generate lightweight 3D geological models, manage report documents, create user accounts and permissions, generate unique sharing links and QR codes, and convert MDB data into a JSON format adapted for web / mobile devices. The user terminal is configured to be accessible via a web browser and mobile responsive access, and can view 3D geological models, borehole columnar sections, and report documents, supporting permission verification and report download.

8. A method for generating and delivering an engineering survey report, characterized in that, The method includes: S1. Data Reading: Extracting the basic data source from the project database; S2. Data Statistics: Calculate statistical parameters including formation thickness, bearing capacity characteristic value and compression modulus; S3. Template parsing: Reads the pre-made report template and identifies dynamic tags; S4. Intelligent Matching: Using a similarity algorithm-based judgment method, the system retrieves the most similar cases from the historical engineering project database and recommends foundation treatment solutions. S5. Content Generation: Fill the statistical data from S12 and the matching results from S14 into the corresponding tag positions in the template, and assemble the common and non-common chapters. S6. Output in format, generating Word and PDF versions of the report; S7. Deliverables.

9. The method for generating and delivering an engineering survey report according to claim 8, characterized in that, The steps for deliverables include: S71. The exploration company generates a 3D geological model, converts data formats, creates user permissions, and allows sharing links or QR codes. S72. Users can access the site via QR code or browser and view the 3D model, drilling data, and report documents after authorization.

10. The method for generating and delivering an engineering survey report according to claim 8, characterized in that, In step S4, the overall similarity is calculated as Σ(Wi×Si) / Σ(Wi). Where Wi is the weight coefficient of the i-th data class, and Si is the similarity score of the i-th data class; Weighting: Building feature data 36-42%, site data 32-36%, foundation soil data 24-27%, with the sum of the weights of the three being 1.

Images