Automatic compiling system for water and soil conservation scheme report of production and construction project
Through the automated system, the database and formula calculation modules are used to solve the problem of time-consuming and low efficiency in writing soil and water conservation plans reports for production and construction projects, and efficient and accurate report generation is achieved.
Patent Information
- Application Number
- CN202310533502.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-05-12
- Publication Date
- 2024-11-15
AI Technical Summary
The preparation method for the existing soil and water conservation plan report for production and construction projects is problematic, which is time-consuming, inefficient, and error-prone to calculations.
An automatic writing system was designed, including a database module, a data input module and a formula calculation module. The soil and water conservation plan report was automatically generated through the national natural conditions database, the soil and water conservation measure standard section database and the key content database of soil and water conservation plans for production and construction projects. . The system allows the front-end to input data, the back-end to perform statistical analysis and calculation, and automatically fill in report templates.
It improves the efficiency of report writing, reduces maintenance costs, reduces errors in manual writing, and realizes the automatic generation of soil and water conservation plan reports.
Smart Images

Figure CN118966987A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the technical field of soil and water conservation plan preparation, and in particular to an automatic preparation system for a soil and water conservation plan report for a production and construction project. Background Art
[0002] Soil and water conservation refers to the analysis, prediction and evaluation of soil and water loss that may be caused during the implementation of production and construction projects, and the proposal of countermeasures and measures to prevent or control soil and water loss. In other words, it analyzes the impact that the implementation of production and construction projects may have on soil and water resources, and proposes countermeasures and measures to prevent and control soil and water loss.
[0003] The existing method of compiling soil and water conservation plan reports for production and construction projects is mainly for report writers to manually compile reports based on relevant documents provided by the client, the project's own conditions at the on-site construction site, and information about the surrounding conditions. This method has problems such as long preparation time, low efficiency, and prone to calculation errors. Summary of the invention
[0004] The purpose of the present invention is to provide an automatic writing system for soil and water conservation plan reports for production and construction projects, so as to solve the problems of time-consuming, low efficiency and easy calculation errors in manually compiling soil and water conservation plan reports.
[0005] In order to achieve the above purpose, the embodiment of the present invention provides the following technical solutions:
[0006] A system for automatically compiling a report on a water and soil conservation plan for a production and construction project, the system comprising: a database module, a data input module, a formula calculation module, and a report writing module. The database module will establish a national natural conditions database, a standard section database of water and soil conservation measures, and a key content database of water and soil conservation plans for production and construction projects, and can obtain corresponding characteristic values based on basic project information; the data input module will fill in custom data into a predetermined form template, input data through the system front end, and perform statistical analysis later; the formula calculation module processes data using a front-end input, back-end calculation, and front-end display result mode; the report writing module automatically compiles and generates a water and soil conservation plan report for a production and construction project based on project characteristic parameters through the data input module and the formula calculation module.
[0007] Furthermore, the national natural conditions database includes administrative divisions and soil erosion prevention and control area divisions. By selecting the province, city, or county where the project is located at the front end, the system automatically outputs the annual rainfall erosivity factor and soil erodibility factor values of the county across the country for later statistical analysis. By selecting the province or city where the project is located at the front end, the system automatically outputs the division results of the national key soil erosion prevention area and the national key soil erosion control area for the city for later statistical analysis.
[0008] Furthermore, the standard section database of soil and water conservation measures includes unit length engineering quantity tables of various lining forms and intercepting drainage ditches, sedimentation basins, and retaining walls of various sizes.
[0009] Furthermore, the key contents of the soil and water conservation plan for the production and construction projects include: a road engineering template, which is used to store the soil and water conservation plan report template for the road engineering project, including two types: with drilled cuttings and without drilled cuttings; a point-shaped housing construction project template, which is used to store the soil and water conservation plan report template for the point-shaped housing construction project, including two types: with drilled cuttings and without drilled cuttings; a hydropower project template, which is used to store the soil and water conservation plan report template for the hydropower project, including two types: with drilled cuttings and without drilled cuttings; a water conservancy project template, which is used to store the water and soil conservation plan report template for the water conservancy project, including two types: with drilled cuttings and without drilled cuttings; a pumped-storage power station project template, which is used to store the water and soil conservation plan report template for the pumped-storage power station project, including two types: with drilled cuttings and without drilled cuttings.
[0010] Furthermore, the key contents of the water and soil conservation plan for production and construction projects can be downloaded, updated, and uploaded by the report templates of different types of water and soil conservation plans for production and construction projects. When the template is re-uploaded, the report writing module will use the latest uploaded template.
[0011] Furthermore, the system front-end input data includes basic project information, parameter factors of each soil loss type, key parameter factors of each control zone engineering measures, plant measures, temporary measures, soil and water conservation monitoring methods, and soil and water loss control standard index values. According to the system front-end input data, the back-end performs statistical calculations.
[0012] Furthermore, the data input and formula calculation module includes soil erosion modulus calculation for 6 types of soil loss in production and construction projects, flow capacity calculation for intercepting and draining ditches, sedimentation basins, retaining works, topsoil stripping, land improvement, vegetation construction, and temporary protection engineering quantities calculation. The above calculations are based on existing formulas and manually input factors, with the system back-end calculating and the front-end displaying the calculation results.
[0013] Furthermore, the soil erosion modulus of the six types of soil loss in production and construction projects include general disturbed surface with vegetation destruction type, general disturbed surface with surface disturbance type, excavation surface with no water supply project above, excavation surface with water supply project above, accumulation body without water supply project above and accumulation body with water supply project above, etc.
[0014] Furthermore, the predetermined table template can be downloaded through the system front end and filled with custom data. The custom data includes column data and row data. The column data includes prevention and control zones, disturbed area, land occupation type, green area, start and completion time, proportion of each soil loss type, remarks, land area, reservoir inundation area, and abandoned volume. The row data includes the names of each prevention and control zone, and the prevention and control zone includes three levels of zones, which are respectively distributed in columns A, B, and C of the table.
[0015] Furthermore, the row data can be added or deleted according to one's own needs, but the column data cannot be added or deleted by oneself, that is, the first row and the second row are fixed items.
[0016] Furthermore, the report writing module will fill in and modify the soil and water conservation plan report template of the corresponding type of production and construction project with the data and calculation results obtained through the database module, data input module and formula calculation module, and automatically write and generate the soil and water conservation plan report.
[0017] The present invention has the following advantages:
[0018] 1. The post-maintenance cost of the automatic writing system of the water and soil conservation plan report for production and construction projects is low, and it can be downloaded, updated and uploaded by itself in the template management. When the template is re-uploaded, the report writing module will use the latest uploaded template.
[0019] 2. The report can be automatically written and generated by uploading an Excel spreadsheet and inputting parameters, which greatly improves the efficiency of writing soil and water conservation plan reports for production and construction projects, and solves the problems of time-consuming manual writing, low efficiency, and prone to calculation errors. BRIEF DESCRIPTION OF THE DRAWINGS
[0020] Figure 1 It is a structural diagram of an embodiment of a system for automatically writing a soil and water conservation plan report of the present invention;
[0021] Figure 2 This is a partial interface diagram of step S1.2 of writing a soil and water conservation plan report in an embodiment of the automatic writing system for a soil and water conservation plan report of the present invention;
[0022] Figure 3 It is a partial interface diagram of step S1.3 of writing a soil and water conservation plan report in an embodiment of the automatic writing system for a soil and water conservation plan report of the present invention. DETAILED DESCRIPTION
[0023] The present invention is further described below in conjunction with the accompanying drawings and embodiments.
[0024] This embodiment describes how to automatically compile and generate a report on soil and water conservation plans for production and construction projects based on the system described above. Figure 1As shown, it includes the following modules: database module, data input and formula calculation module, and report writing module.
[0025] In the embodiment of the present invention, the database module includes a national natural conditions database, a soil and water conservation measures standard section database, and a production and construction project soil and water conservation plan key content database.
[0026] The national natural conditions database is established based on the National Soil and Water Conservation Plan (2015-2030) to establish a national database of key soil and water loss prevention areas and key soil and water loss control areas; and based on the Guidelines for Calculating Soil Loss in Production and Construction Projects (SL 773-2018), a database of annual rainfall erosion factors and soil erodibility factor values for counties across the country is established.
[0027] The standard section database of soil and water conservation measures includes unit length engineering quantity tables of intercepting and drainage ditches of different section forms, various lining forms, and sizes, engineering quantity tables of single earthen sedimentation basins and tertiary sedimentation basins of different sizes, and unit length engineering quantity tables of retaining walls of different materials.
[0028] The key content database of soil and water conservation plans for production and construction projects includes soil and water conservation plan report templates for different types of projects such as road projects, point-shaped housing construction projects, water conservancy and hydropower projects, and pumped-storage power station projects. The road project template is used to store soil and water conservation plan report templates for road projects, including two types: with drill cuttings and without drill cuttings; the point-shaped housing construction project template is used to store soil and water conservation plan report templates for point-shaped housing construction projects, including two types: with drill cuttings and without drill cuttings; the water conservancy project template is used to store water and soil conservation plan report templates for water conservancy projects, including two types: with drill cuttings and without drill cuttings; the hydropower project template is used to store soil and water conservation plan report templates for conventional hydropower station projects, including two types: with drill cuttings and without drill cuttings; the pumped-storage power station project template is used to store soil and water conservation plan report templates for pumped-storage power station projects, including two types: with drill cuttings and without drill cuttings.
[0029] The data input and formula calculation module fills the customized data into the established form template, and processes the data through the mode of inputting data at the front end of the system, statistical analysis at the back end, and displaying the results at the front end; the data input at the front end of the system includes basic project information, parameter factors of each soil loss type, key parameter factors of each prevention and control zone engineering measures, plant measures, and temporary measures, soil and water conservation monitoring methods, and standard index values for soil and water loss prevention and control. According to the data input at the front end of the system, the back end performs statistical calculations. The data input and formula calculation module includes soil erosion modulus calculations for 6 types of soil loss in production and construction projects, flow capacity calculations for intercepting and draining ditches, and engineering quantity calculations for intercepting and draining ditches, sedimentation tanks, blocking projects, topsoil stripping, land improvement, vegetation construction, and temporary protection; the above calculations are based on existing formulas and manually input factors, calculated by the back end of the system, and the calculation results are displayed at the front end; the soil erosion modulus of the 6 types of soil loss in production and construction projects include general disturbed surfaces of vegetation destruction type, general disturbed surfaces of surface disturbance type, excavation surfaces of projects without water supply above, excavation surfaces of projects with water supply above, accumulation bodies of projects without water supply above, and accumulation bodies of projects with water supply above.
[0030] In an embodiment of the present invention, the following steps can be performed through the data input and formula calculation module:
[0031] S1.1: Download the excel spreadsheet template, fill in the data and upload it. In the excel spreadsheet, the columns are fixed items and cannot be added or deleted. Columns A, B, and C are project prevention and control zones, column D is the disturbed surface area, columns E to P are land use status classifications, column Q is green area, columns R and S are start and completion time, columns T to V are soil loss types, column W is remarks, column X is land area, column Y is the reservoir inundation area, and column Z is the amount of abandoned soil. In the excel spreadsheet, the rows are the prevention and control zones, which are not fixed items and can be added or deleted. Upload the filled-in table to the system. An example of the partial structure of this excel spreadsheet is as follows:
[0032]
[0033]
[0034] S1.2: Enter the basic information of the project. On the "Basic Information" page, the user enters the document name, background value, construction unit name, rainy season month, selects the document type, and the geographical location of the province, city, and county. The system automatically identifies whether it belongs to the national key prevention and control area for soil and water loss based on the database module. The user selects whether it involves the provincial key prevention and control area for soil and water loss. If "involved" is selected, enter the name of the provincial key prevention and control area for soil and water loss. If "not involved" is selected, the system automatically identifies it and generates a report describing it as "not involving the provincial key prevention and control area for soil and water loss". The user selects whether there is drill cuttings. If "yes" is selected, enter the drill cuttings volume, loss coefficient, and bulk density.
[0035] Click Next.
[0036] Enter the parameters of the "Soil and Water Loss Analysis and Prediction" section. On the "Soil and Water Loss Analysis and Prediction" page, the user enters the amount of earthwork, stonework and silt waste, and the system automatically calculates the total amount of waste based on the amount of drilling waste. The user selects the start and completion time of the construction preparation period and the construction period. Figure 2 As shown in the figure, in the calculation box of the general disturbance surface soil loss modulus of the surface disturbance type, according to the geographical location of the province, city and county, the system automatically fills in the rainfall erosivity factor (R) and the soil erodibility factor (K) based on the database module. The user enters the soil erodibility factor coefficient (N), and the system automatically calculates the soil erodibility factor (Kyd) value using the formula Kyd = N*K. The user enters the horizontal projection slope length (λ) of the calculation unit and the calculation unit slope (θ), and the system uses the formula L y =(λ / 20) m Automatically calculate the slope length factor (Ly), using the formula S y =-1.5+17 / [1+e (2.3-6.1sinθ) ] automatically calculates the slope factor (Sy). The user selects different general disturbed surface calculation units and coverage, original surface soil and water conservation engineering measures, and whether the general disturbed surface original surface is non-agricultural land. The system automatically displays the vegetation coverage factor (B), engineering measures factor (E), and tillage measures factor (T). The user enters the calculation unit width (w), and the system automatically displays the calculation unit horizontal projection area (A). Further, using formula M yd =RK yd L y S y The BETA system automatically calculates the soil loss (Mdy) of the surface disturbance type general disturbance surface calculation unit, using the formula M i =100M ky / A system automatically calculates the soil erosion modulus (Mi) of the general disturbed surface calculation unit of the surface disturbance type.
[0037] According to their needs, users can input parameter factors of soil loss types such as excavation surface without water supply engineering above, accumulation body without water supply engineering above, excavation surface with water supply engineering above, accumulation body with water supply engineering above, and general disturbed surface with vegetation destruction. The system will use the database module formula to automatically calculate the soil loss amount and soil erosion modulus of each soil loss type.
[0038] Click Next.
[0039] S1.3: Enter the parameters of the "Soil and Water Conservation Measures" section. On the "Soil and Water Conservation Measures" page, the soil and water conservation measures chapter directory is displayed on the left side of the page, and the names of the prevention and control zones at all levels are automatically extracted based on the information in the Excel spreadsheet.
[0040] In the "Project Examples" section, the user selects a project example, and the system automatically generates relevant information and experience photos of the selected example.
[0041] In each prevention and control zoning engineering measure, the user inputs the topsoil stripping thickness of each type of land, and the system automatically extracts the topsoil stripping area based on the information in the Excel spreadsheet. Based on the topsoil stripping thickness and the topsoil stripping area, the system automatically calculates the topsoil stripping amount.
[0042] In each prevention and control zone engineering measure, such as Figure 3 As shown, the user inputs the retaining wall material, maximum wall height, wall top width, face slope ratio, back slope, foundation burial depth, retaining wall length and other information, and the system automatically calculates the foundation section size and retaining wall engineering quantity based on the database module formula. The user inputs the intercepting drainage ditch lining material, section size, length and other information, and the system automatically calculates the intercepting drainage ditch engineering quantity based on the formula. The user inputs the site's rainwater collection area, rainfall intensity, and runoff coefficient, and the system automatically calculates the design flow using the formula Q=16.67ψqF; based on the intercepting drainage ditch section size, the system uses the formula Automatically calculate the flow capacity. If the flow capacity is greater than or equal to the design flow, the next step will be automatically performed; if the flow capacity is less than the design flow, the user needs to re-enter the cross-sectional dimensions of the intercepting drainage ditch until the flow capacity is greater than or equal to the design flow.
[0043] In the plant measures of each prevention and control zone, the user inputs the greening area of each slope in the permanent land, and the system automatically extracts the area of restored gardens and forests and grasslands according to the information in the Excel spreadsheet. The system automatically calculates the nurturing and management area based on the greening area of the slopes, the area of restored gardens and forests and grasslands.
[0044] In the temporary measures of each prevention and control zone, the user inputs the form, quantity and cross-sectional dimensions of the temporary drainage ditches and siltation ponds, and the system automatically calculates the engineering quantities of the temporary drainage ditches and siltation ponds.
[0045] Click Next.
[0046] S1.4: Enter the parameters of the "Soil and Water Conservation Monitoring" section. The user selects the ground observation monitoring method and enters the area to which each monitoring method is applied based on the selected method.
[0047] Click Next.
[0048] S1.5: Input the parameters of the "Benefit Analysis" section. Input the values of the six soil and water loss prevention and control indicators. The system will automatically analyze whether the six indicators meet the standards based on the calculation results of the engineering measures and plant measures in the "Soil and Water Conservation Measures" section. The six indicators are soil and water loss control degree, soil loss control ratio, slag protection rate, surface soil protection rate, forest and grass vegetation recovery rate, and forest and grass coverage rate.
[0049] S1.6: Enter the “Soil and Water Conservation Management” section parameters.
[0050] Click Submit.
[0051] In the embodiment of the present invention, the report writing module calls the corresponding template according to the project situation through the data input and formula calculation module and the database module to write and generate the soil and water conservation plan report, thereby completing the report writing module. This step includes:
[0052] S2.1: According to the document type selected in step S2.2, the corresponding soil and water conservation report template is called. According to step S2, the system automatically fills in the soil and water conservation report template.
[0053] S2.2: Select the document and click "Generate Document". The system will automatically write and generate the document and display a progress bar. When the progress bar shows 100%, the document is generated successfully.
[0054] S2.3: Select the document, click “Download”, select the local save directory, and download it to the local computer.
[0055] In summary, the automatic writing system for soil and water conservation plan reports for production and construction projects provided by the present invention provides a free text filling method, can adapt to the needs of data filling and special situation description in actual report writing, and has good practicality.
[0056] Although the present invention has been described in detail above by general description and specific embodiments, it is obvious to those skilled in the art that some modifications or improvements can be made to the present invention. Therefore, these modifications or improvements made without departing from the spirit of the present invention all belong to the scope of protection claimed by the present invention.
Claims
1. A system for automatically compiling soil and water conservation plan reports for production and construction projects, characterized in that: The system includes: a database module, a data input and formula calculation module, and a report writing module; the database module establishes a national natural conditions database, a soil and water conservation measures standard section database, and a key content database of soil and water conservation plans for production and construction projects, and can obtain corresponding characteristic values based on basic project information; the data input and formula calculation module fills customized data into a predetermined form template, and processes data through a system front-end data input, back-end statistical analysis, and front-end result display mode; the report writing module automatically writes and generates a soil and water conservation plan report for a production and construction project through a data input module and a formula calculation module based on project characteristic parameters.
2. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The national natural conditions database includes administrative divisions and soil and water loss prevention and control area divisions; by selecting the province, city, or county where the project is located through the front end, the system automatically outputs the annual rainfall erosion factor and soil erodibility factor values of the county across the country for subsequent statistical analysis; by selecting the province or city where the project is located through the front end, the system automatically outputs the division results of the national key soil and water loss prevention areas and national key soil and water loss control areas for the city for subsequent statistical analysis.
3. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The standard section database of soil and water conservation measures includes unit length engineering quantity tables of intercepting and draining ditches, sedimentation basins, and retaining walls of different sections and lining forms and various sizes.
4. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The key contents of the soil and water conservation plan for the production and construction project include: Road engineering template, used to store the soil and water conservation plan report template for road engineering, including two types: with drilling slag and without drilling slag; Point-shaped housing construction project template, used to store point-shaped housing construction project soil and water conservation plan report template, including two types: with drilling slag and without drilling slag; Water conservancy project template, used to store water and soil conservation plan report templates for water conservancy projects, including two types: with drilling debris and without drilling debris; Hydropower project template, used to store the report template of water and soil conservation plan for conventional hydropower station projects, including two types: with drilling slag and without drilling slag; The pumped storage power station project template is used to store the water and soil conservation plan report template for the pumped storage power station project, including two types: with and without drill cuttings.
5. The method and system for automatically compiling a report on soil and water conservation plan for a production and construction project as claimed in claim 1, characterized in that: The key contents of the soil and water conservation plan for the production and construction project can be downloaded, updated and uploaded by different types of soil and water conservation plan report templates for production and construction projects; when the template is re-uploaded, the report writing module will use the latest uploaded template.
6. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The system front-end input data includes basic project information, parameter factors of various soil loss types, key parameter factors of engineering measures, plant measures, and temporary measures in various prevention and control zones, soil and water conservation monitoring methods, and soil and water loss prevention and control standard index values; based on the system front-end input data, the back-end performs statistical calculations.
7. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The data input and formula calculation module includes soil erosion modulus calculation for 6 types of soil loss in production and construction projects, calculation of flow capacity of intercepting drainage ditches, calculation of engineering quantities of intercepting drainage ditches, sedimentation ponds, retaining projects, topsoil stripping, land improvement, vegetation construction, and temporary protection; the above calculations are based on existing formulas and manually input factors, the system backend calculates, and the frontend displays the calculation results; the soil erosion modulus for the 6 types of soil loss in production and construction projects include general disturbed surfaces with vegetation destruction type, general disturbed surfaces with surface disturbance type, excavation surfaces with no water supply projects above, excavation surfaces with water supply projects above, accumulation bodies with no water supply projects above, and accumulation bodies with water supply projects above.
8. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1 is characterized in that: The established table template can be downloaded through the system front end and filled with custom data; the custom data includes column data and row data; the column data includes prevention and control zones, disturbed area, land occupation type, greening area, start and completion time, proportion of each soil loss type, remarks, land area, reservoir inundation area, and abandoned volume; the row data includes the name of each prevention and control zone, and the prevention and control zones include three levels of zones, which are respectively distributed in columns A, B, and C of the table.
9. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 8, characterized in that: The row data can be added or deleted according to one's own needs, but the column data cannot be added or deleted, that is, the first row and the second row are fixed items.
10. The automatic writing system for soil and water conservation plan report of production and construction projects as claimed in claim 1, characterized in that: The report writing module will fill in and modify the soil and water conservation plan report template of the corresponding type of production and construction project according to the project characteristic parameters, the data and calculation results obtained through the database module, the data input module, and the formula calculation module, and automatically write and generate the soil and water conservation plan report.
Citation Information
Cited By
Slope soil erosion prediction method, system, equipment and medium
CN121721250A
