工程地质信息化和自动成图技术研究

为实现工程地质信息化管理,以SQL Server 2008数据库为平台,建立地质信息数据库,对庞大的地质勘测信息实施科学存储和统一管理。针对钻孔柱状图通常采用传统的手工绘制、效率低而且不易修改等问题,以VS2010为开发工具,利用地质信息数据库系统,开发了钻孔柱状图的自动成图系统和用户友好型界面。针对生成的钻孔柱状图不能够根据钻孔长度与图框关系智能分段等问题,提出了分段算法,实现了钻孔柱状图自动分段显示的功能,并以乌江构皮滩工程为依托,对新方法的有效性和可行性进行验证。结果表明:变孔径成图算法解决了变孔径钻孔柱状图的显示问题,生成能反应实际情况的变孔径钻孔柱状图;该方法成图方便快捷,图形美观协调,满足实际工作的需要。研究成果对工程地质信息化具有重要的参考价值。

Study on informatization of engineering geology and automatic mapping technology

In order to realize the informatized management of engineering geology,a geological information database is established for implementing scientific storage and unified management of huge geological survey information by taking SQL Server 2008 database as the platform. Aiming at the problem of that the borehole histogram is conventionally and manually drawn under a lower efficiency and is not easy to be revised,both the automatic mapping system for borehole histogram and the user-friendly interface are developed with the geological information database system by taking VS2010 as the development tool. Furthermore, a segmentation algorithm is proposed for the problem of that the created borehole histogram cannot be intelligently segmented in accordance with the borehole length and the frame relation,and then the function of the automatic segment display of the borehole histogram is realized,while the availability and feasibility of the new method are verified depending on Goupitan Hydropower Project on Wujiang Ｒiver. The result shows that the variable aperture mapping algorithm solves the problem from the display of the variable aperture borehole histogram and creates the variable aperture borehole histogram that can reflect the actual condition concerned. The mapping of the method is convenient and quick with the beautiful and harmonious graphics,thus can meet the demand of the actual work. The study result has an important referential value for the informatization of engineering geology.