城市地下工程数据管理技术研究

Research on the Technology of Spatial Data Management in Urban Underground Engineering

城市地下空间的大规模开发建设,必须做好设计、施工与运营的全过程动态监控管理,才能有效预防灾害发生。采用系统科学的思想,提出城市地下工程数据管理应包括城市地下工程数据库存储、城市地下工程数据库管理和城市地下工程数据库应用三个层次;研究并建立了城市地下工程数据库概念设计E-R模型,以钻孔数据为例,研究了数据逻辑关系和数据库设计方法,设计了钻孔数据视图;基于SQL Server数据库管理平台,研究了具有时空属性的变形监测点数据存储拓展技术,并基于此探讨了具有时空属性对象的查询扩展方法;研发了基于GIS平台与相关数值模拟软件相融合的城市地下工程数据库应用软件,使空间分析从宏观到细观得到可视化体现。

Urban underground space is being developed and constructed on a large scale, so dynamic monitoring management during the whole process of design, construction and operation must be well done in order to prevent dis- asters happening. Based on the idea of system science, it is proposed that the spatial data management of urban un- derground engineering should include three aspects, namely, the urban underground engineering database, urban un- derground engineering database management and urban underground engineering database application. The concept design E-R model of urban underground engineering database is researched and established, then the logical relation- ship of data and design method of database are researched based on borehole data, and the views of borehole data have been designed. Based on the management platform of SQL Server database, the storage and development tech- nology of deformation monitoring data with time-space attribute is researched, and on basis of which the query expan- sion method of objects with time-space attribute is discussed. The database application software of urban underground engineering combining GIS platform with related numerical simulation software is developed, which makes spatial a- nalysis from macroscopic level to microscopic level expressed visually.