CN109145429B - Method and device for calculating earthwork quantity - Google Patents

Method and device for calculating earthwork quantity Download PDF

Info

Publication number
CN109145429B
CN109145429B CN201810924292.6A CN201810924292A CN109145429B CN 109145429 B CN109145429 B CN 109145429B CN 201810924292 A CN201810924292 A CN 201810924292A CN 109145429 B CN109145429 B CN 109145429B
Authority
CN
China
Prior art keywords
earthwork
calculating
measurement data
earthwork quantity
engineering measurement
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201810924292.6A
Other languages
Chinese (zh)
Other versions
CN109145429A (en
Inventor
赵双权
许志勇
董丽娜
肖伟华
侯保灯
孙红霞
曹振宇
张�浩
王启东
杨恒
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Heilongjiang Prov Investigation Design And Research Institute Of Water Conservancy And Hydropower
China Institute of Water Resources and Hydropower Research
Original Assignee
Heilongjiang Prov Investigation Design And Research Institute Of Water Conservancy And Hydropower
China Institute of Water Resources and Hydropower Research
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Heilongjiang Prov Investigation Design And Research Institute Of Water Conservancy And Hydropower, China Institute of Water Resources and Hydropower Research filed Critical Heilongjiang Prov Investigation Design And Research Institute Of Water Conservancy And Hydropower
Priority to CN201810924292.6A priority Critical patent/CN109145429B/en
Publication of CN109145429A publication Critical patent/CN109145429A/en
Application granted granted Critical
Publication of CN109145429B publication Critical patent/CN109145429B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/10Geometric CAD
    • G06F30/13Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Geometry (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Theoretical Computer Science (AREA)
  • Civil Engineering (AREA)
  • Structural Engineering (AREA)
  • Computational Mathematics (AREA)
  • Architecture (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a calculation method of earthwork quantity and a device for calculating the earthwork quantity, wherein the calculation method of the earthwork quantity comprises the following steps: s1, acquiring engineering measurement data of earthwork quantity; s2, constructing a surface area model according to the acquired engineering measurement data; and S3, calculating the earthwork quantity according to the constructed area model. According to the method for calculating the earthwork quantity, disclosed by the embodiment of the invention, the earthwork quantity can be automatically calculated in batches, and the method for calculating the earthwork quantity is simple, quick and high in precision.

Description

Method and device for calculating earthwork quantity
Technical Field
The invention relates to the technical field of hydraulic engineering, in particular to a calculation method of earthwork quantity and a device for calculating the earthwork quantity.
Background
In the hydraulic engineering design process, designers often need to carry out engineering design on dykes and dams, river channels, ditches, roadbeds and the like, calculate engineering quantities and draw longitudinal and transverse section diagrams of engineering. The working process is to use Office software to calculate the correlation, and manually draw a section chart and measure the engineering quantity in an AutoCAD. The engineering quantity and the engineering drawing workload are very heavy, the data processing is numerous, the repeated workload is large, the time and the labor are wasted, and the working efficiency is low.
Disclosure of Invention
In view of the above, the present invention provides a method for calculating earthwork quantities.
The invention also provides a device for calculating the earthwork quantity.
In order to solve the technical problems, the invention adopts the following technical scheme:
according to an embodiment of the first aspect of the invention, the method for calculating the earthwork quantity comprises the following steps:
s1, acquiring engineering measurement data of earthwork quantity;
s2, constructing a surface area model according to the acquired engineering measurement data;
and S3, calculating the earthwork quantity according to the constructed area model.
Further, the step S1 includes:
s11, acquiring current terrain section data of the earthwork quantity;
and step S12, obtaining design standard section data of the earthwork quantity.
Further, the design standard section data is formed as an initial design parameter.
Further, the area model includes:
the current situation terrain section model is constructed and formed according to the current situation terrain section data;
and designing a standard section model, wherein the design standard section model is formed by constructing according to the design standard section data.
Further, the step S3 includes:
step S31, the acquired engineering measurement data are stored in a database and are programmed according to the constructed area model;
and S32, calculating the earthwork quantity by using a Boolean operation principle.
Further, the calculation method of the earthwork quantity further comprises the following steps: and S4, storing, printing and outputting the calculation result of the earthwork quantity and the drawing file.
An apparatus for calculating an amount of earthwork according to an embodiment of a second aspect of the present invention includes:
the acquisition module is used for acquiring engineering measurement data of the earthwork quantity;
the storage module is used for storing engineering measurement data of the earthwork quantity;
and the calculation module is used for calculating the earthwork quantity according to the acquired engineering measurement data of the earthwork quantity.
Further, the computing module includes:
the model building unit builds a surface area model according to the acquired engineering measurement data;
and the calculating unit is used for calculating the earthwork quantity according to the constructed area model.
The technical scheme of the invention has the following beneficial effects:
according to the method for calculating the earthwork quantity, disclosed by the embodiment of the invention, the earthwork quantity can be automatically calculated in batches, and the method for calculating the earthwork quantity is simple, quick and high in precision.
Drawings
Fig. 1 is a flowchart of a method for calculating an earthwork quantity according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. It will be apparent that the described embodiments are some, but not all, embodiments of the invention. All other embodiments, which are obtained by a person skilled in the art based on the described embodiments of the invention, fall within the scope of protection of the invention.
Unless defined otherwise, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. The terms "first," "second," and the like, as used herein, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. Likewise, the terms "a" or "an" and the like do not denote a limitation of quantity, but rather denote the presence of at least one. The terms "connected" or "connected," and the like, are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", etc. are used merely to indicate a relative positional relationship, which changes accordingly when the absolute position of the object to be described changes.
The method for calculating the amount of earthwork according to the embodiment of the present invention will be described in detail with reference to the accompanying drawings.
As shown in fig. 1, the method for calculating the earthwork quantity according to the embodiment of the invention comprises the following steps:
s1, acquiring engineering measurement data of earthwork quantity;
s2, constructing a surface area model according to the acquired engineering measurement data;
and S3, calculating the earthwork quantity according to the constructed area model.
In other words, according to the calculation method of the earthwork quantity of the embodiment of the present invention, firstly, engineering measurement data of the earthwork quantity can be acquired, then, a surface area model can be constructed according to the acquired engineering measurement data, and finally, the earthwork quantity can be calculated according to the constructed surface area model. The calculation of the earthwork amount can be realized by using Boolean (boost) operation of an AutoCAD area, and the area (Region) is a command in AutoCAD drawing software and refers to a planar area with a boundary. Closed multi-segment lines, straight lines and curved lines are all effective choices. Boolean provides three ways of computation and the final composite region can be obtained by way of the three ways of computation.
From the concept of the area, the closed multi-section line can create the area, the engineering measurement section is generally a multi-point broken line, and a closed area model can be constructed; the design standard section is also a multi-end broken line, and a closed area model can be constructed. Then, the engineering quantity can be calculated by obtaining a composite graph through Boolean operation of the created area model and calling the area attribute of the composite graph.
Therefore, according to the method for calculating the earthwork quantity, which is disclosed by the embodiment of the invention, the earthwork quantity can be automatically calculated in batches, and the method for calculating the earthwork quantity is simple, quick and high in precision.
According to one embodiment of the invention, step S1 comprises:
s11, acquiring current terrain section data of earthwork quantities;
and S12, acquiring design standard section data of the earthwork quantity.
That is, in step S1, the current terrain cross-section data and the design standard cross-section data of the earthwork quantity can be acquired. Design criteria profile data may be formed as initial design parameters.
In some embodiments of the invention, the area model includes a current terrain section model and a design standard section model.
Specifically, the current terrain section model is constructed and formed according to current terrain section data, and the design standard section model is constructed and formed according to design standard section data.
In other words, the area model may be constructed as a current terrain section model, which may be a model constructed based on engineering current measurement data, and a design standard section model, which may be a model constructed based on a standard section designed by an engineer.
According to one embodiment of the invention, step S3 comprises:
step S31, the acquired engineering measurement data are stored in a database and are programmed according to the constructed area model;
and S32, calculating the earthwork quantity by using a Boolean operation principle.
That is, in step S3, first, the acquired engineering measurement data may be stored in a database, and may be programmed according to the constructed current terrain section model and design standard section model, the programming may be in a high-level language, preferably Visual basic language, the data input is realized in the program, the database is established, the originally measured longitudinal and transverse section data and the initial design parameters are stored in the database, and the related parameters of the design section may be determined according to the data stored in the database, such as calculation of hydraulic elements, etc.
Then, water surface line design, engineering quantity calculation and drawing can be performed. The method comprises the steps of establishing a link between a programming language and an AutoCAD by using a ActiveX automation technology, controlling the AutoCAD as an object from outside, designing, fitting and optimizing a water surface line, manually or automatically sleeving cross sections in batches according to parameters determined by the design, simultaneously calculating engineering quantities by using a Boolean (Boolean) operation principle, and calling the AutoCAD to draw in batches.
And finally, storing, printing and outputting the calculation result of the earthwork quantity and the drawing file. The process can be completed in a main program example, and can also be realized by utilizing ActiveX automation technology to control AutoCAD, excel and Access.
In summary, according to the method for calculating the earthwork quantity, which is disclosed by the embodiment of the invention, the earthwork quantity can be automatically calculated in batches, and the method for calculating the earthwork quantity is simple, quick and high in precision.
The device for calculating the earthwork quantity according to the embodiment of the second aspect of the invention comprises an acquisition module, a storage module and a calculation module.
Specifically, the acquisition module is used for acquiring engineering measurement data of the earthwork quantity, the storage module is used for storing the engineering measurement data of the earthwork quantity, and the calculation module calculates the earthwork quantity according to the acquired engineering measurement data of the earthwork quantity.
That is, the apparatus for calculating the amount of earthwork according to the embodiment of the present invention is mainly composed of an acquisition module, a storage module, and a calculation module. The acquisition module can be used for acquiring engineering measurement data of the earthwork quantity, the storage module can be used for storing the engineering measurement data of the earthwork quantity, and the calculation module can be used for calculating the earthwork quantity according to the acquired engineering measurement data of the earthwork quantity.
According to one embodiment of the invention, the calculation module comprises a model building unit and a calculation unit.
Specifically, the model construction unit constructs a surface area model according to the acquired engineering measurement data, and the calculation unit calculates the earthwork amount according to the constructed surface area model.
In other words, the calculation module is mainly composed of a model building unit and a calculation unit. The model construction unit can construct a surface area model according to the acquired engineering measurement data, and the calculation unit can calculate the earthwork quantity according to the constructed surface area model.
While the foregoing is directed to the preferred embodiments of the present invention, it will be appreciated by those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the present invention.

Claims (7)

1. The calculation method of the earthwork quantity is characterized by comprising the following steps:
s1, acquiring engineering measurement data of earthwork quantity;
s2, constructing a surface area model according to the acquired engineering measurement data;
s3, calculating the earthwork quantity according to the constructed area model;
wherein, the step S3 includes:
step S31, the acquired engineering measurement data are stored in a database and are programmed according to the constructed area model;
s32, calculating the earthwork quantity by using a Boolean operation principle;
the storing the acquired engineering survey data in a database and programming according to the constructed area model comprises:
the method comprises the steps of establishing a link between a programming language and an AutoCAD by using a ActiveX automation technology, taking the AutoCAD as an object to operate from outside, designing, fitting and optimizing a water surface line, manually or automatically sleeving cross sections in batches according to parameters determined by the design, simultaneously calculating engineering quantities by using a Boolean operation principle, and calling the AutoCAD to draw in batches, so that the automatic batch calculation of earthwork quantities is realized.
2. The method for calculating the amount of earthwork according to claim 1, characterized in that said step S1 comprises:
s11, acquiring current terrain section data of the earthwork quantity;
and step S12, obtaining design standard section data of the earthwork quantity.
3. The method of calculating an amount of earthwork according to claim 2, characterized in that the design standard section data is formed as an initial design parameter.
4. The method of calculating an amount of earthwork according to claim 1, characterized in that the area model comprises:
the current situation terrain section model is constructed and formed according to the current situation terrain section data;
and designing a standard section model, wherein the design standard section model is formed by constructing according to the design standard section data.
5. The method for calculating an amount of earthwork according to claim 1, further comprising: and S4, storing, printing and outputting the calculation result of the earthwork quantity and the drawing file.
6. An apparatus for calculating an amount of earthwork comprising:
the acquisition module is used for acquiring engineering measurement data of the earthwork quantity;
the storage module is used for storing engineering measurement data of the earthwork quantity;
the calculation module is used for calculating the earthwork quantity according to the acquired engineering measurement data of the earthwork quantity;
wherein the computing module comprises:
storing the acquired engineering measurement data in a database and programming according to the constructed area model;
calculating the earthwork quantity by using a Boolean operation principle;
the storing the acquired engineering measurement data in a database and programming according to the constructed area model comprises the following steps:
the method comprises the steps of establishing a link between a programming language and an AutoCAD by using a ActiveX automation technology, taking the AutoCAD as an object to operate from outside, designing, fitting and optimizing a water surface line, manually or automatically sleeving cross sections in batches according to parameters determined by the design, simultaneously calculating engineering quantities by using a Boolean operation principle, and calling the AutoCAD to draw in batches, so that the automatic batch calculation of earthwork quantities is realized.
7. The apparatus for calculating an amount of earthwork according to claim 6, characterized in that said calculation module comprises:
the model building unit builds a surface area model according to the acquired engineering measurement data;
and the calculating unit is used for calculating the earthwork quantity according to the constructed area model.
CN201810924292.6A 2018-08-14 2018-08-14 Method and device for calculating earthwork quantity Active CN109145429B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810924292.6A CN109145429B (en) 2018-08-14 2018-08-14 Method and device for calculating earthwork quantity

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810924292.6A CN109145429B (en) 2018-08-14 2018-08-14 Method and device for calculating earthwork quantity

Publications (2)

Publication Number Publication Date
CN109145429A CN109145429A (en) 2019-01-04
CN109145429B true CN109145429B (en) 2023-10-13

Family

ID=64793040

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810924292.6A Active CN109145429B (en) 2018-08-14 2018-08-14 Method and device for calculating earthwork quantity

Country Status (1)

Country Link
CN (1) CN109145429B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110516399B (en) * 2019-09-03 2020-04-14 贵州正业工程技术投资有限公司 Karst depression spherical crown type shelling excavation square amount calculation method

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20100116382A (en) * 2009-04-22 2010-11-01 (주)덕성알파이엔지 System of automatically calculating and displaying amount of earthwork materials based on three dimensional design and method thereof
CN103196403A (en) * 2013-03-21 2013-07-10 中国农业大学 Earth volume measurement method based on GPS control ground system
KR20150015725A (en) * 2013-08-01 2015-02-11 쌍용건설 주식회사 System and Method for Earth Work Plan of Civil Facilities
CN105064263A (en) * 2015-07-16 2015-11-18 上海市园林设计院有限公司 Water system of waterfront green space landscape
CN106909740A (en) * 2017-03-02 2017-06-30 中国石油天然气集团公司 The computational methods and computing device of a kind of Oil & Gas Storage yard total figure volume of earthwork
CN107679337A (en) * 2017-10-20 2018-02-09 浙江煤炭测绘院 A kind of method that irregular earthwork calculates in engineering survey

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20100116382A (en) * 2009-04-22 2010-11-01 (주)덕성알파이엔지 System of automatically calculating and displaying amount of earthwork materials based on three dimensional design and method thereof
CN103196403A (en) * 2013-03-21 2013-07-10 中国农业大学 Earth volume measurement method based on GPS control ground system
KR20150015725A (en) * 2013-08-01 2015-02-11 쌍용건설 주식회사 System and Method for Earth Work Plan of Civil Facilities
CN105064263A (en) * 2015-07-16 2015-11-18 上海市园林设计院有限公司 Water system of waterfront green space landscape
CN106909740A (en) * 2017-03-02 2017-06-30 中国石油天然气集团公司 The computational methods and computing device of a kind of Oil & Gas Storage yard total figure volume of earthwork
CN107679337A (en) * 2017-10-20 2018-02-09 浙江煤炭测绘院 A kind of method that irregular earthwork calculates in engineering survey

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
基于3 维实体模型的复杂工程场地土石方量的精确计算及可视化研究;张勇等;《四川大学学报(工程科学版)》;20121220;第117-121页 *
王坚.运用CAD 与Excel 软件配合计算不规则断面工程量的方法.《山西水土保持科技》.2011, *
运用CAD 与Excel 软件配合计算不规则断面工程量的方法;王坚;《山西水土保持科技》;20110925;第44-46页 *

Also Published As

Publication number Publication date
CN109145429A (en) 2019-01-04

Similar Documents

Publication Publication Date Title
CN106777460B (en) Method for determining pipe diameter and gradient of urban rainwater pipe network based on SWMM hydraulic model
CN104392013B (en) Modeling Calculation system and method integrated by substation project cable duct based on CAD
CN110880717B (en) Automatic cable laying method based on equipment and bridge positioning digitization
CN105224749A (en) Plant design CAD platform realizes the method for structure discipline three-dimensional design
Ji et al. Integration of parametric geometry into IFC-Bridge
Mohamed et al. Reliability-based design optimization strategy for soil tillage equipment considering soil parameter uncertainty
CN110990928A (en) Software platform-crossing special-shaped space grid structure parameterization design method
CN112163256A (en) Method for establishing and analyzing template support model based on finite element analysis and BIM
CN109145429B (en) Method and device for calculating earthwork quantity
CN113434928A (en) Parametric construction method of complex three-dimensional linear structure
CN114580056A (en) BIM-based comprehensive pipe gallery main body structure parametric design method
CN105677955A (en) Foundation pit stability checking computation method based on excavation real-time data feedback
CN111985034A (en) Method and system for constructing school civil engineering Building Information Model (BIM)
CN110990923A (en) Rapid engineering calculation method, system and medium for hyperbolic arch dam of water conservancy and hydropower engineering
CN112182886A (en) Engineering model generation method and device, computer equipment and storage medium
CN109241579B (en) Rapid modeling method considering fluid additional mass multidimensional space transient characteristics
CN105302979A (en) Modeling method and system of valve groups in two-phase fluid network model
CN113821858B (en) Revit-based method for detaching electromechanical embedded parts in any concrete pouring block
KR102034868B1 (en) Numerical method for the coupled analysus between the ground deformation analysis due to excavation and groundwater flow analysis
CN110992475B (en) Method, system and medium for rapidly calculating engineering quantity of any part of large-volume concrete of hydraulic and hydroelectric engineering
CN113867267A (en) Steel pipe digital processing system and method based on BIM spherical shell structure shape finding construction
CN109408972B (en) Method for calculating water environment capacity through computer programming based on Delft3D model
CN115495830B (en) Engineering intelligent design method and system based on three-dimensional digital model
CN110162578A (en) A kind of high standard farmland construction spatial shape recognition methods and device
CN103927716A (en) Method for calculating target deformation or shielding degree in target tracking process

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant