| 吴应值,谢小峰,瞿岚,曾飞,蔡国荣.基于VBA编程的数字填图资料整理方法与应用[J].贵州地质,2024,(4):456-462 |
| 基于VBA编程的数字填图资料整理方法与应用 |
| Data Sorting Method and Application of Digital Mapping Based on VBA Programming |
| 投稿时间：2024-07-19 |
| DOI： |
| 中文关键词: VBA 数字填图 野外路线记录 资料整理 |
| 英文关键词:Visual Basic for Applications Digital Geological Mapping Field route records Data sorting |
| 基金项目:贵州省科技厅科技计划项目(黔科合平台人才-ZDSYS〔2023〕005)；贵州省科技厅项目(黔科合支撑〔2023〕一般172)；毕节试验区赫章县猪拱塘铅锌矿深部及外围地质三维空间调查项目(黔自然资函〔2021〕1360号、黔自然资函〔2022〕427号、黔自然资函〔2023〕152号、黔自然资函〔2024〕42号)；贵州省地质矿产勘查开发局科技创新人才团队(黔地矿科合〔2023〕TD002)联合资助 |
|
| 摘要点击次数: 21 |
| 全文下载次数: 10 |
| 中文摘要: |
| 采用数字填图技术进行地质填图时，路线原始资料以电子形式存储在计算机中，不便于查看。为了方便专家审查，通常需要将野外路线电子手簿导出、打印并装订成册。在资料整理阶段，由数字地质调查综合平台(DGSS)导出的野外路线电子手簿在内容和格式方面还存在很多不足，不符合相关规范要求，传统的修改方式为人工手动修改，这不仅浪费时间、精力，还容易引发新的错误，工作效率极低。为了解决这一问题，笔者结合地质填图相关规范要求，运用VBA语言编程技术，通过编制程序实现了野外路线记录自动修正，自动调整野外路线记录的格式，自动添加缺失的内容，使繁琐的数字填图资料整理过程实现了自动化、简单化。经项目实践验证，该程序运行稳定，效果显著，大大提高了办公效率。 |
| 英文摘要: |
| When using digital mapping technology for geological mapping, the original route data is stored in electronic form in the computer, which is not easy to view. In order to facilitate expert review, it is usually necessary to export, print, and bind the field route electronic handbook into a volume. In the process of data sorting, the field route electronic handbook exported by the Digital Geological Survey Information System (DGSS) often contains many shortcomings in both contents and formats, not in compliance with relevant regulations. The traditional way of modification is manual editing, which not only wastes time and energy, but also easily leads to new errors, and the work efficiency is very low. In order to solve this problem, the author combined the requirements of geological mapping standards, and used VBA programming technology, through the program, the errors of field route records was automatically corrected, the formats of field route records was automatically adjusted, and the missing contents was automatically added, making the tedious process of digital Geological mapping data sorting automated and simplified. After practical verification, the program runs stably with significant results, greatly improving office efficiency. |
| 查看全文 查看/发表评论 下载PDF阅读器 |
|
|
|
