利用Excel实现AutoCAD自动批量绘制地质灾害点分布图的方法尝试

The Attempt of Realizing AutoCAD Bacth Drawing Geological Hazard Point Distribution Map with Excel

在AutoCAD制图平台中绘制地质灾害点分布图时,可利用Excel软件强大的数据处理功能将调查数据进行处理,然后自动批量绘制地质灾害点及其名称注记等内容,从而相对于传统手工标绘方式而言大大提高了图件绘制效率及准确率。同时,该方法可以举一反三地应用到其他制图工作中,诸如自动批量绘制岩土工程勘察中的钻孔平面布置图、钻孔柱状图以及剖面图、公路里程及坐标图、征地范围拐点及注记标绘,等等。因此,该方法的推广应用价值较大。

When drawing the distribution map of geological disaster locations on AutoCAD,the powerful data processing function of Excel software could be used to process the survey data,and then performing the functions of automatic drawing of the geological disaster locations as well as name annotating.Compared with traditional manual plotting,it is of dramatic efficiency and accuracy.At the same time,this method can be applied to other mapping work by analogy,such as automatic batch drawing of borehole layout,borehole histogram and section diagrams,highway mileage and coordinate diagrams,land acquisition range inflection points and coordinate mapping in geotechnical engineering surveys and etc.Therefore,this method is of great potential for application.