基于VBA技术的土地整理土方量批量计算  

Batch calculation of land consolidation earthwork based on VBA technology

作　　者：司聪[1] 江征华 朱杰 SI Cong;JIANG Zhenghua;ZHU Jie(Geo engineering Investigation Institute of Jiangsu Province Jiangsu,Nanjing,Jiangsu 211111,China;College of Civil Engineering,Nanjing Forestry University,Nanjing,Jiangsu 210037,China)

机构地区：[1]江苏省地质工程勘察院,江苏南京211111 [2]南京林业大学,江苏南京210037

出　　处：《测绘标准化》2023年第1期102-106,共5页Standardization of Surveying and Mapping

摘　　要：土地开发整理是实现耕地总量动态平衡的有效措施,也是提高土地质量、促进土地集约化利用的重要手段。传统的土方量计算方法,单个地块计算快速、准确,但对于土地开发整理项目不仅计算效率低,而且操作烦琐。本文提出基于VBA技术的批量计算土地开发整理土方量方法。借助CASS 2008平台,采用VBA技术统一建立全区域的DTM,通过循环剪切DTM进行各地块的土方量计算,实现土地开发整理土方量的批量计算。通过与基于方格网的土方量批量计算进行对比,进一步验证本文方法的可靠性。工程实践表明,本文方法可同时对工程区域多个地块土方量进行自动批量计算,能满足土地整治项目中大规模土方准确计算的要求。Land development and consolidation is an effective measure to realize the dynamic balance of total cultivated land,and also an important means to improve land quality and intensive land use.The traditional earthwork calculation method is fast and accurate for a single parcel,but it is inefficient and cumbersome for land development and consolidation projects.This paper proposes a method of using VBA technology to batch calculate the earthwork volume of land development and consolidation.With the help of CASS 2008 platform,the method uses VBA technology to uniformly establish the DTM of the whole region,and then calculates the earthwork of each parcel through circular cutting DTM,so as to realize the batch calculation of the earthwork of land development and consolidation.The engineering practice shows that proposed method can automatically batch calculate the earthwork of multiple parcels in the project area at the same time,and can meet the requirements of accurate calculation of large scale earthwork in land development and consolidation projects.

关 键 词：土方计算 VBA技术 批量计算 土地整平 DTM 方格网法 

分 类 号：P258[天文地球—测绘科学与技术]