Database Designed for Urban 3D Geological Investigations
-
摘要: 将城市地质调查中的基础地理、工程地质、地球物理、地球化学等数据综合起来进行一体化管理, 对城市规划、建设、环境综合评价、公众信息发布具有重要的意义.在通过分析城市地质调查数据的广泛性、多样性、多维性等特点的基础上, 对数据进行了分类整理, 提出了适合城市三维地质信息管理与服务系统建设的基于勘测点的数据结构模型, 这种结构具有简单、易维护、可以满足多层次查询需求等特点.在此基础上结合城市三维地质应用设计了C/S (Client/Server) 和B/S (Browse/Server) 混合的数据库体系结构, 达到了应用的要求.Abstract: It is essential to manage geological data such as geophysical, geochemical, geotechnical and geographical data in urban planning, construction, environmental evaluation and public information issue. Based on an analysis of the characteristics of city geological data, such as universality, diversity, and multi-dimensionality, this paper classifies the investigations geological data, and proposes a structural data model on the basis of the survey and geodesic dots. It has many characteristics, including simplicity and easy maintenance, and it can be requeried at any level. Based on the data structure, a mixture database system structure is designed, including Client/Server structure and Browse/Server structure, which can realize the professional data processing and maintaining, information publishing and browsing, fit for constructing city 3-dimensional geological information management and service system.
-
-
[1] Dai, Q. F., Wei, H. L., Su, G. H., et al., 2004. Modeling of marine geological survey database. Application Research of Computers, 21 (3): 65-66 (in Chinese with English abstract). [2] Hu, J. W., Wu, X. C., Song, L. H., 2003. Technique for isomeric database design in environment GIS application. Journal of Jilin Post and Telecommunication Institute, 21 (1): 61-64 (in Chinese with English abstract). [3] Hu, Z. Y., He, J. B., 2000. The architecture and technical solution of distributed geographical information sharing. Computer Engineering and Applications, 36 (12) 51-54 (in Chinese with English abstract). [4] ISO/TC 211 Secretariat, 2001. DIS 19115 geographic information-metadata. ISO, [s. n.]. [5] Liu, Y. B., Liu, D. Y., 2000. A review on spatial reasoning and geographic information system. Journal of Software, 11 (12): 1598-1606 (in Chinese with English abstract). [6] Wu, X. C., Bai, Y. Q., 2000. Development and prospect of geographic information system. Computer Engineering and Applications, 36 (4): 8-9 (in Chinese with English abstract). [7] Zhu, L. F., Wu, X. C., 2003. Study of management and service system of urban 3D geological data supported by 3D GIS. Journal of Wuhan Urban Construction Institute, 20 (4): 40-46. [8] Zhu, L. F., Wu, X. C., Liu, X. G., 2004. Study of information system of urban 3D geological data supported by 3D GIS. Rock and Soil Mechanics, 23 (6): 882-886 (in Chinese with English abstract). [9] 戴勤奋, 魏合龙, 苏国辉, 等, 2004. 区域海洋地质调查数据库结构模型. 计算机应用研究, 21 (3): 65-66. doi: 10.3969/j.issn.1001-3695.2004.03.023 [10] 胡建武, 吴信才, 宋利好, 2003. 环境地理信息系统中异构数据库的设计. 吉林大学学报(信息科学版), 21 (1): 61-64. doi: 10.3969/j.issn.1671-5896.2003.01.013 [11] 胡志勇, 何建邦, 2000. 分布式地理信息共享形式及技术策略. 计算机工程与应用, 36 (12): 51-54. doi: 10.3321/j.issn:1002-8331.2000.12.020 [12] 刘亚彬, 刘大友, 2000. 空间推理和地理信息系统综述. 软学报, 11 (12): 1598-1606. https://www.cnki.com.cn/Article/CJFDTOTAL-RJXB200012005.htm [13] 吴信才, 白玉琪, 2000. 地理信息系统(GIS) 发展现状及展望. 计算机工程与应用, 36 (4): 8-9. doi: 10.3321/j.issn:1002-8331.2000.04.003 [14] 朱良峰, 吴信才, 刘修国, 2004.3D GIS支持下的城市三维地质信息系统研究. 岩土力学, 23 (6): 882-886. doi: 10.3969/j.issn.1000-7598.2004.06.008