VBA在宗地图绘制中的应用  

Application of VBA Technology in Plotting Cadastral Parcel Map

作　　者：付博[1] 马晶[2] 谢振红[1] 刘祥[1] 

机构地区：[1]吉林建筑工程学院测绘与勘查工程学院,吉林长春130118 [2]中国土地勘测规划院,北京100035

出　　处：《中国土地科学》2010年第10期58-62,共5页China Land Science

基　　金：吉林省教育厅"十一五"科学技术研究项目(2007351)

摘　　要：研究目的:运用Excel VBA自动完成地籍测量中宗地图的绘制及进行界址点成果表的显示输出。研究方法:运用Excel电子表格作为开发平台,以附置其中的VBA语言作为编程工具进行程序编制。研究结果:VBA可完成宗地图的图面绘制及相应的界址点号、界址边长等信息的标注,并可生成包含界址边长、方位角及宗地面积的界址点成果表。研究结论:编写的程序摆脱了现有宗地图绘制程序中需要安装相应软件并熟悉软件操作的不便之处,本程序在测试中使用方便,运行效果良好。The purposes of this paper are to draw cadastral parcel map automatically and to show the tables of boundary marks in a cadastral survey based on Excel VBA tool. Method employed is to conduct programming using Excel spreadsheet as development platform and the attached VBA as programming language. The results indicate that through Excel VBA the plotting of cadastral parcel map, corresponding numbers of boundary marks and the labeling of side lengths of boundary sites can be achieved. Furthermore a result table containing side lengths of boundary sites, azimuths and area of land parcel can also be generated. It is concluded that the compiled programs in this paper are easy to be applied to draw a cadastral parcel map, while avoiding the inconveniences of installing a third-party software which requires the users to get familiar with the software in advance.

关 键 词：土地调查 宗地图 界址点 VBA 

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