针对基坑群开挖过程中工况复杂、信息量大、开挖与监测信息难以进行耦合分析的问题,开发了监测数据与施工信息动态同步分析系统.利用结构化查询语言(SQL)标准中的数据库软件Microsoft SQL Server进行基坑施工与监测信息的标准化管理,以时间信息作为索引标志,建立两者的动态同步耦合关系;通过对Excel与Visio的二次开发分别实现监测数据与施工工况的可视化模拟,最终开发全局控制台将基坑施工信息与监测数据的可视化模型进行关联以实现动态同步分析.将该系统应用于上海世博园某地块基坑群,实现了基坑群施工中的分块开挖工况与各项监测数据的动态同步分析,呈现了相邻基坑开挖在宏观与局部时空尺度上的相互影响特征.该系统可为基坑群施工对基坑与周围环境受力变形影响机制的分析与验证提供高效的分析手段.
In a foundation pit group project, complex excavation stages and large number of monitor data can be encountered, so that the operators are hard to handle the analysis of the interactive impact of the excavation processes on the adjacent foundation pits. To resolve this problem, an analysis system was devel- oped to monitor data and construct information in a foundation pit group synchronously and dynamically. The system used Microsoft SQL Server to facilitate the classification and management of the information of constructions and instrumentations, the time related fields were selected as the reference for the synchro- nous analysis. The visualized modeling for the excavation processes and the monitor data was conducted through the secondary development of Microsoft Visio and Excel, respectively. A console application was utilized to link and control these models. The system was applied in the synchronous and dynamic analysis of the construction processes and the monitor data in the project of Shanghai Expo foundation pit group,and exposed the interactive impact characteristics of the adjacent excavations in a global and local time/ space domain. The system provided an efficient means for the analysis and verification of theories of the in- teractive impact in the excavation of foundation pit groups.