基于数据库二次开发的地铁项目地层统计与管理研究  

Research on statistic and management of subway project stratum data based on database and secondary development

作　　者：耿计计 党立平 刘艺 朱才辉[3] Geng Jiji;Dang Liping;Liu Yi;Zhu Caihui(Sinohydro Bureau 3 Co.,Ltd.,Xi’an Shaanxi 710024,China;China Jikan Research Institute of Engineering Investigations and Design,Co.,Ltd.,Xi’an Shaanxi 710043,China;Institute of Geotechnical Engineering,Xi’an University of Technology,Xi’an Shaanxi 710048,China)

机构地区：[1]中国水利水电第三工程局有限公司,陕西西安710024 [2]机械工业勘察设计研究院有限公司,陕西西安710043 [3]西安理工大学岩土工程研究所,陕西西安710048

出　　处：《山西建筑》2024年第18期112-115,158,共5页Shanxi Architecture

基　　金：国家自然科学基金(52279110)。

摘　　要：研究旨在解决地铁项目勘察阶段中地层数据统计与管理存在的问题,主要围绕理正勘察软件6.8.1在地铁勘察项目中对主层和亚层的不合理统计展开。通过数据库编程与二次开发的方法,针对软件在地层区分和数据统计方面的局限性,设计了一套自动化的数据处理和统计工具,并基于AutoCAD提供的VBA集成开发环境实现了工具的开发与应用。在实际项目中,对该工具进行了有效性验证和实例演示,展示了其对地铁工程数据管理的重要性和有效性。最终总结的研究结果证明了通过数据库编程与二次开发可以优化地铁项目中地层数据的统计与管理,并为类似工程项目提供了有益的技术方案和经验借鉴。The study aims to address issues in stratigraphic data statistics and management in metro survey projects,focusing on the unreasonable statistics of primary and secondary layers using Lizheng Survey Software 6.8.1.By database programming and secondary development techniques,the study designed an automated data processing and statistical tool to overcome the software’s limitations in stratigraphic differentiation and data statistics.This tool was developed and implemented using the VBA integrated development environment provided by AutoCAD.Its effectiveness was validated and demonstrated in actual projects,highlighting its significance and efficacy in managing engineering data.The research concludes that database programming and secondary development can optimize stratigraphic data statistics and management in metro survey projects,offering valuable technical solutions and practical insights for similar engineering projects.

关 键 词：地层数据 数据库编程 数据统计 AutoCAD VBA 

分 类 号：TU997[建筑科学—市政工程] U491[交通运输工程—交通运输规划与管理]