A method for automatically arranging and calculating the super-digging large-step engineering quantity of a steep slope embankment
By automatically drawing and calculating over-excavation steps in AutoCAD, the problems of low design efficiency and insufficient accuracy in existing technologies are solved, and efficient and accurate calculation of step engineering quantities for steep slope subgrades is achieved.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- GUIZHOU TRANSPORTATION PLANNING SURVEY & DESIGN ACADEME
- Filing Date
- 2022-11-04
- Publication Date
- 2026-04-10
AI Technical Summary
Existing roadbed design software lacks flexibility and specificity in drawing and calculating over-excavation steps, resulting in low design efficiency and easy omissions, which affects the accuracy of engineering quantity calculations.
Develop an AutoCAD-aided tool that automatically draws over-excavated steps and calculates their quantities by identifying cross-sectional node coordinates, setting step width and overburden thickness, including polyline drawing and area calculation, to achieve automated step layout and volume calculation.
It improves the efficiency and accuracy of designers' drawing, reduces workload, and enables more flexible and convenient drawing and calculation of over-excavation steps, making it suitable for highway design.
Smart Images

Figure CN115659442B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to a kind of steep embankment automatic arrangement and calculate overbreak big step engineering quantity method, belong to steep slope subgrade overbreak step engineering drawing technical field. BACKGROUND
[0002] In high fill subgrade or steep slope subgrade design, overbreak step is often needed to the region of cross slope steep, to guarantee the stability of fill subgrade, usually design overbreak step, need according to different topography and geology condition to overbreak step of different width, so that subgrade treatment reaches the best effect, commonly used route, subgrade design software, most is set to a overbreak step width for entire project, overbreak step position is also automatically set according to cross slope, and its engineering quantity is also counted for entire project, lack of flexibility and pertinence, subgrade design personnel often need to manually draw overbreak step line and calculate corresponding engineering quantity, such operation design efficiency is very low, and due to the problem of artificial, prone to missing phenomenon, such as key position missing is not manually modified, then there will be engineering quantity missing etc. Problem, affect the direct interests of contractor and owner. The present application is based on long-term highway subgrade design work and is created, and the problems of automatic drawing and automatic calculation of overbreak step engineering quantity are solved by using Autolisp language to develop and write corresponding Autocad auxiliary tool.
[0003] The technical problem to be solved by the present application is to develop a new functional module of AutoCAD, to realize rapid and accurate drawing of overbreak step on steep slope subgrade, and to automatically calculate overbreak step engineering quantity, which can reduce the workload of designers and improve drawing efficiency and accuracy. SUMMARY
[0004] Therefore, the present application aims to provide a kind of steep embankment automatic arrangement and calculate overbreak big step engineering quantity method, realize the rapid and accurate drawing of overbreak step on steep slope subgrade, and automatically calculate overbreak step engineering quantity, which can reduce the workload of designers and improve drawing efficiency and accuracy, and overcome the deficiencies of prior art.
[0005] The object of the present application is achieved by the following technical solutions:
[0006] The application discloses a method for automatically arranging and calculating the engineering quantity of over-excavated large steps of a steep slope embankment.
[0007] The method comprises the following steps:
[0008] Step 1: input the over-excavated step width number_tjw, the number of horizontal sections to be calculated number_zh and the average thickness of the covering layer thick_over on the module developed by AutoCAD, so as to provide basic parameters for subsequent calculation;
[0009] Step 2: point-select the first calculated horizontal section positioning pile number, take the text as an attribute graphic element, take the existence of K in the text as a screening condition, and save the text after K to zh01;
[0010] Step 3: cyclically judge each byte in zh01, calculate the pile number value and record it to the pile number table list_zh;
[0011] Step 4: select the ground line of the first horizontal section to be calculated, take the node coordinates of the ground line as control points, and save them to the table pts;
[0012] Step 5: point-select the start and end points of the over-excavated step on the selected ground line, record the start and end point coordinates to pt0 and pt1 respectively, so as to provide basic data for further calculation of the over-excavated step end point coordinates;
[0013] Step 6: calculate the intersection (x_c, y_c) on the ground line corresponding to the right end of each step according to the pile spacing and the start and end point coordinates of the over-excavated step;
[0014] Step 7: calculate the end point coordinates of each over-excavated step according to the node coordinates of the ground line corresponding to the right end of the over-excavated step, and record them in list_ch2_jdzb;
[0015] Step 8: Draw the over-excavation step multi-segment line, along the order of the over-excavation step endpoint coordinates list_ch2_jdzb, draw the multi-segment line;
[0016] Step 9: Calculate the area of the over-excavation step, loop to determine the ground line nodes in pts between the start and end points of the over-excavation step, combine them with the over-excavation step endpoints and store them in pline_cwtj_cal, further use pline_cwtj_cal as the multi-segment line endpoints to draw the multi-segment line, calculate the area enclosed by it, and record the point pair of the pile number calculation value and the area in list_zh_area;
[0017] Step 10: Repeat steps 2 to 9 to calculate the pile number value, draw the over-excavation step, and calculate the area of the over-excavation step for the next section, and record the point pair of the pile number calculation value and the area in list_zh_area until all sections have completed the over-excavation step drawing and area calculation;
[0018] Step 11: Calculate the volume of the over-excavation step, according to the pile number, over-excavation step area table list_zh_area of each section, sequentially add the calculated volume of each section to cal_area, and cal_area is the total volume of the over-excavation step;
[0019] Step 12, output the calculated over-excavation step area of each section and the over-excavation step volume calculated by all sections to complete the automatic drawing of the over-excavation step of the steep slope embankment and the automatic calculation of the over-excavation engineering quantity.
[0020] In the above, in step 3, by recognizing the "+" symbol, the text before and after "+" is separated, the front is recorded as kilometers zh02_km_2, and the back is recorded as meters zh02_km_1, and the unit of kilometers is converted to meters, and then recorded to the pile number table list_zh.
[0021] In the above, in step 6, the parameters include the right horizontal coordinate x_c of the i-th over-excavation step, the right control point horizontal coordinate x_a of the adjacent ground line, and the left control point horizontal coordinate x_b, the calculation formula of x_c is: x_c = x_pt0 + (i-1)*number_tjw; the calculation formula of y_c is:
[0022]
[0023] The step 7 is adjusted according to the thickness of the covering layer thick_over, and the step 7 is set as 4% excavation reverse slope, and the step 7 is calculated away from the ground line; if the intersection coordinates of the Kth step right section corresponding to the ground line are (x_k, y_k), the intersection coordinates of the Kth step right section corresponding to the ground line are (x_(k-1), y_(k-1)), and the Kth step left and right end control point calculation formula is as follows:
[0024] When k = 1, the left end control point coordinates are the starting point coordinates (pt0)
[0025] When k > 1,
[0026] In the step 8, the color of the multi-segment line is set as red and other bright colors, and the multi-segment line layer is set as the "overbreak step line" layer.
[0027] In the step 9, the ground line node between the overbreak step starting point and the ending point is combined with the overbreak step end point to form a closed multi-segment line, and the direction of the ground line node is transposed; meanwhile, in order to avoid the closed multi-segment line formed by the ground line node between the overbreak step starting point and the ending point and the overbreak step end point from overlapping with the overbreak step line, the former is deleted after the overbreak area is obtained.
[0028] In the step 11, the volume calculation formula of the kth section is as follows (k starts from the 0th) :
[0029] When k = 0, there is only one section, and cal_area = 0
[0030] When k = 0, there are two or more sections,
[0031] When 0 < k < total number of sections,
[0032] When k = total number of sections,
[0033] Compared with the prior art, the present application has the following advantages:
[0034] 1. The application automatically calculates the stake number value and the over-dig step area of each section, and automatically calculates the over-dig step volume according to the stake number and the over-dig step area, by inputting the over-dig step width, the number of sections to be calculated, and the average thickness of the covering layer into the computer, and sequentially selecting the section stake number, the section ground line, and the start and end point positions of the over-dig step to be laid for each section. The application is based on long-term highway subgrade design work, and can realize automatic drawing of over-dig steps on steep slopes and automatic calculation of over-dig volume, and has more flexible operability and convenience compared with the current route design software.
[0035] 2. The application has high operation convenience, and realizes automatic drawing of over-dig steps on steep slopes and automatic calculation of over-dig volume, and has more flexible operability and convenience compared with the current route design software, effectively reduces the workload of designers, and improves drawing efficiency and accuracy.
[0036] 3. The over-dig step range is flexibly set according to geological and topographical conditions, the over-dig step line is automatically drawn on the section, and the total over-dig step volume is further calculated according to the arranged step quantities on the section, which is a complete method, and the implementation content can be directly applied to the field of highway design.
[0037] Other advantages, objects, and features of the present application will be set forth in part in the following specification, and in part will become apparent to those skilled in the art from a consideration of the following specification, or can be learned from practice of the present application. The objects and other advantages of the present application can be realized and attained by means of the instrumentalities and combinations pointed out in the following specification. BRIEF DESCRIPTION OF DRAWINGS
[0038] In order to make the objects, technical solutions, and advantages of the present application clearer, the following will further describe the present application in combination with the drawings, in which:
[0039] Figure 1 The figure is a method flowchart of the present application.
[0040] Figure 2 The figure is a cross-section diagram of the LK1+480-LK1+520 section of the steep slope subgrade before setting the over-dig step.
[0041] Figure 3 The figure is an effect diagram of automatically drawing and calculating the over-dig step of the LK1+480-LK1+520 section of the steep slope subgrade by using the present application.
[0042] Figure 4 The figure is an automatic calculation result of the over-dig step quantities of the LK1+480-LK1+520 section of the steep slope subgrade by using the present application.
[0043] Figure 5The intersection point of each step on the ground line is calculated.
[0044] Figure 6 The schematic diagram for obtaining y_c in step 6 is shown. DETAILED DESCRIPTION
[0045] The preferred embodiment of the present application will be described in detail below with reference to the accompanying drawings. It should be understood that the preferred embodiment is only for the purpose of illustrating the present application, and is not intended to limit the protection scope of the present application.
[0046] As shown in Figures 1-4 The method for automatically arranging and calculating the engineering quantity of over-excavation large steps of a steep slope embankment disclosed by the present application is developed based on AutoCAD, a pile distributed in the longitudinal direction of a highway is selected as a section, and the coordinate data of each point of the ground line of the section is recorded into AutoCAD. The width of the over-excavation step and the average thickness of the covering layer are set, the starting point and the ending point of the over-excavation step are selected on the ground line, and the over-excavation step is automatically arranged on AutoCAD. Then, the endpoint coordinates of each step are calculated by using the coordinate points of the ground line. Next, the points on the ground line are combined with the endpoint of the step to draw a polyline, and a regular figure is enclosed between the polylines to calculate the area. Thus, the area of the entire section can be calculated. Finally, according to the pile spacing or the over-excavation depth, the volume of the over-excavation of the section can be calculated. The total engineering quantity can be obtained by accumulating the volumes of the over-excavation of multiple sections.
[0047] The method for automatically arranging and calculating the engineering quantity of over-excavation large steps of a steep slope embankment comprises the following steps:
[0048] Step 1: The width of the over-excavation step number_tjw, the number of transverse sections to be calculated number_zh, and the average thickness of the covering layer thick_over are input on the module developed by AutoCAD, to provide basic parameters for subsequent calculation.
[0049] Step 2: The first calculated transverse section positioning pile number is selected, the text is taken as an attribute figure, the text containing “K” is taken as a screening condition, and the text after “K” is saved into zh01.
[0050] Step 3: Each byte in zh01 is cyclically judged, and the pile number value is calculated and recorded into the pile number table list_zh. In step 3, the text before and after the “+” symbol is separated by recognizing the “+” symbol, the front text is recorded into the kilometer number zh02_km_2, the rear text is recorded into the meter number zh02_km_1, and the kilometer unit is converted into meters, which is added to the meter number and recorded into the pile number table list_zh.
[0051] Step 4: The ground line of the first transverse section to be calculated is selected, the node coordinates of the ground line are taken as control points, and the control points are saved into the table pts.
[0052] Step 5: Click the start and end points of the overbreak step to be arranged on the selected ground line, and record the start and end point coordinates into pt0 and pt1 respectively, to provide basic data for further calculation of overbreak step end point coordinates;
[0053] Step 6: Calculate the intersection point (x_c, y_c) on the ground line corresponding to the right end of each step platform according to the pile spacing and the start and end point coordinates of the overbreak step; in step 6, the parameters include the horizontal coordinate x_c of the right end of the i-th overbreak step platform, the horizontal coordinate x_a of the right control point of the adjacent ground line, and the horizontal coordinate x_b of the left control point, the calculation formula of x_c is: x_c = x_pt0 + (i-1)*number_tjw; the calculation formula of y_c is:
[0054]
[0055] Specifically, the intersection point (x_c, y_c) on the ground line corresponding to each step is calculated according to the coordinates of (x_b, y_b), (x_a, y_a) and the start and end point coordinates of the overbreak step, as shown in Figure 5 and Figure 6 When calculating y_c, it is calculated according to similar triangle boa and triangle bec.
[0056] Step 7: Calculate the end point coordinates of each overbreak step according to the node coordinates of the corresponding ground line, and record them in list_ch2_jdzb; in step 7, the end point coordinates of the step close to the ground line can be adjusted according to the thickness of the overburden layer thick_over to adjust the height from the ground line, and a 4% excavation counter slope can be set to calculate the end point coordinates of the step away from the ground line; if the intersection point coordinates of the right segment of the K-th step corresponding to the ground line are (x_k, y_k), and the intersection point coordinates of the right segment of the K-th step corresponding to the ground line are (x_(k-1), y_(k-1)), then the calculation formulas of the left and right end control points of the K-th step are as follows:
[0057] When k = 1, the left end control point coordinates are the start point coordinates (pt0)
[0058] The right end control point coordinates are (x_k, y_pt0-0.04*number_tjw)
[0059] When k > 1, the left end control point coordinates are (x_(k-1), y_k-thick_over)
[0060] The right end control point coordinates are (x_k, y_(k-1)-0.04*number_tjw).
[0061] Step 8: Draw the over-excavation step multi-segment line, along the order of the over-excavation step endpoint coordinates list_ch2_jdzb, draw the multi-segment line; in step 8, in order to make the over-excavation step line drawn convenient to use and more eye-catching, set the multi-segment line color to a bright color such as red, and set the multi-segment line layer to the "over-excavation step line" layer.
[0062] Step 9: Calculate the over-excavation step area, loop to judge the ground line nodes in pts between the over-excavation step start and end points, merge them with the over-excavation step endpoints and store them in pline_cwtj_cal, further take pline_cwtj_cal as the multi-segment line endpoints, draw the multi-segment line, calculate the area surrounded thereby, and record the stake number calculation value and the area as a point pair in list_zh_area; in step 9, in order to form a closed multi-segment line between the over-excavation step start and end points and the ground line nodes therebetween, when merging the ground line nodes with the over-excavation step endpoints, the direction of the ground line nodes should be transposed; at the same time, in order to avoid the closed multi-segment line formed by the over-excavation step start and end points and the ground line nodes therebetween from overlapping with the over-excavation step line, delete the former after obtaining the over-excavation area.
[0063] Step 10: Repeat steps 2 to 9 to calculate the stake number value, draw the over-excavation step, and calculate the over-excavation step area for the next section, and record the stake number calculation value and the area as a point pair in list_zh_area, until all sections have completed over-excavation step drawing and area calculation; for example, Figures 2-3 the over-excavation steps distributed in the middle, and for example, taking stakes 1480 and 1500, and stake 1520 as sections, the obtained area is list_zh_area ((148037.365) (150037.759) (152037.8114));
[0064] Step 11: Calculate the over-excavation step volume, according to the stake number, over-excavation step area table list_zh_area of each section, sequentially stack the volume calculated for each section into cal_area, and cal_area is the total volume of the over-excavation step; in step 11, the volume calculation formula of the kth section is as follows (k starts from 0):
[0065] When k = 0, there is only one section in total, cal_area = 0
[0066] When k = 0, there are ≥ two sections in total,
[0067] When 0 < k < total number of sections,
[0068] When k = total number of sections,
[0069] As the pile 1480 and the shape 1500, the pile 1520 is the total volume of three sections, the calculation process is:
[0070]
[0071] Finally, step 12, the calculated overbreak step area corresponding to each section, and the overbreak step volume calculated from all sections are output, and the automatic drawing of the overbreak step of the steep slope embankment is completed.
[0072] The above is only a preferred embodiment of the present application, and is not a limitation on the present application in any form. Any simple modification, equivalent change and modification made to the above embodiment without departing from the technical solution content of the present application and according to the technical essence of the present application still belongs to the scope of the technical solution of the present application.
Claims
1. A method for automatically arranging and calculating the quantity of overbreak large steps of steep slope embankment, characterized in that: The method is developed based on AutoCAD, selects multiple transverse sections of the highway as operation objects, identifies and records each node coordinate data of the ground line in the section in AutoCAD, sets the width of the overbreak step and the average thickness of the covering layer, selects the start and end points of the overbreak step on the ground line, calculates the end point coordinates of each step through the coordinate points of the ground line, and then draws the end points of the step as a polyline to automatically arrange the overbreak step on the transverse section. Then, the points on the ground line are combined with the end points of the step to draw a polyline, and a regular figure is formed between the polylines to calculate the area, so that the area of the overbreak step in the entire section can be calculated. Finally, the interval between the front and rear sections is calculated, and the volume of the overbreak step corresponding to each section can be calculated. The total engineering quantity of the overbreak step is obtained by accumulating the volumes of the overbreak steps of multiple sections; The method comprises the following steps: Step 1: input the overbreak step width number_tjw, the number of transverse sections to be calculated number_zh, and the average thickness of the covering layer thick_over on the module developed by AutoCAD to provide basic parameters for subsequent calculation; Step 2: select the first calculated transverse section positioning pile number, take "text" as the attribute figure, take "K" in the text as the screening condition, and save the text after "K" to zh01; Step 3: cyclically judge each byte in zh01, calculate the pile number value and record it in the pile number table list_zh; Step 4: select the ground line of the first transverse section to be calculated, take the node coordinates of the ground line as control points, and save them to the table pts; Step 5: select the start and end points of the overbreak step to be arranged on the selected ground line, record the start and end point coordinates to pt0 and pt1 respectively to provide basic data for further calculation of the overbreak step end point coordinates; Step 6: calculate the intersection point (x_c, y_c) on the ground line corresponding to the right end of each step according to the pile spacing and the start and end point coordinates of the overbreak step; Step 7: calculate the end point coordinates of each overbreak step according to the node coordinates of the ground line corresponding to the right end of the overbreak step, and record them in list_ch2_jdzb; Step 8: draw the overbreak step polyline, draw the polyline along the order of the overbreak step end point coordinates list_ch2_jdzb; Step 9: calculate the area of the overbreak step, cyclically judge the ground line nodes between the start and end points of the overbreak step in pts, combine and store them in pline_cwtj_cal, further take pline_cwtj_cal as the end point of the polyline, draw the polyline, calculate the area surrounded by the polyline, and record the pile number calculation value and the area of this section as a point pair in list_zh_area; Step 10: repeat steps 2 to 9 to calculate the pile number value, draw the overbreak step, and calculate the area of the overbreak step of the next section, and record the pile number calculation value and the area as a point pair in list_zh_area until the overbreak step drawing and area calculation of all sections are completed. Step 11: The overbreak step volume is calculated according to the pile number of each section, the overbreak step area table list_zh_area, and the volume calculated for each section is sequentially stacked into cal_area. The cal_area is the total volume of the overbreak step. Step 12: The calculated overbreak step area of each section and the overbreak step volume calculated from all sections are output, completing the automatic drawing and automatic calculation of overbreak quantities for steep embankments. In step 6, the right side horizontal coordinate x_c of the i-th overbreak step, the right side control point horizontal coordinate x_a and the left side control point horizontal coordinate x_b of the adjacent ground line, and the calculation formula of x_c is: x_c = x_pt0 + (i-1) * number_tjw; the calculation formula of y_c is: ; In step 7, the step endpoint coordinates near the ground line are adjusted according to the overburden thickness thick_over to adjust their distance from the ground line height. A 4% excavation counter slope can be set. The step endpoint coordinates away from the ground line are calculated. If the intersection coordinates of the K-th step right segment corresponding to the ground line are (x_k, y_k), and the intersection coordinates of the K-th step right segment corresponding to the ground line are (x_(k-1), y_(k-1)), then the calculation formula of the left and right end control points of the K-th step is as follows: 。 2. The method for automatically arranging and calculating the super-excavation step quantity of steep slope embankment according to claim 1, characterized in that: In step 3, by recognizing the "+" symbol, the text before and after "+" is separated. The front records the kilometer number zh02_km_2, and the back records the meter number zh02_km_1. The kilometer unit is converted to meters, and the meter number is recorded in the pile number table list_zh.
3. The method for automatic arrangement of steep slope embankment and calculation of super-excavation large step engineering quantity according to claim 1, characterized in that: In step 8, in order to make the overbreak step line easy to use and more eye-catching, the color of the polyline is set to red, a more eye-catching color, and the polyline layer is set to the "overbreak step line" layer.
4. The method for automatic arrangement of steep slope embankment and calculation of super-excavation large step engineering quantity according to claim 1, characterized in that: In step 9, in order to make the ground line nodes between the start and end points of the overbreak step form a closed polyline with the overbreak step end points, the ground line nodes should be directionally transposed when merging the ground line nodes between the start and end points of the overbreak step with the overbreak step end points. At the same time, in order to avoid the closed polyline formed by the ground line nodes between the start and end points of the overbreak step and the overbreak step end points overlapping with the overbreak step line, the former is deleted after the overbreak area is obtained.
5. The method for automatic arrangement of steep slope embankment and calculation of super-excavation large step engineering quantity according to claim 1, characterized in that: In step 11, the volume calculation formula of the k-th section is as follows (k starts from 0): 。
Citation Information
Patent Citations
System and method for calculating dig-fill work amount on basis of AutoCAD
CN108121853A
Calculation method and system for roadbed earth-rock volume
CN112765707A