基坑群监测数据与施工信息动态同步分析系统的开发与应用

doi:10.16183/j.cnki.jsjtu.2017.03.003

摘要/Abstract

摘要：

针对基坑群开挖过程中工况复杂、信息量大、开挖与监测信息难以进行耦合分析的问题，开发了监测数据与施工信息动态同步分析系统．利用结构化查询语言（SQL)标准中的数据库软件Microsoft SQL Server进行基坑施工与监测信息的标准化管理，以时间信息作为索引标志，建立两者的动态同步耦合关系；通过对Excel与Visio的二次开发分别实现监测数据与施工工况的可视化模拟，最终开发全局控制台将基坑施工信息与监测数据的可视化模型进行关联以实现动态同步分析．将该系统应用于上海世博园某地块基坑群，实现了基坑群施工中的分块开挖工况与各项监测数据的动态同步分析，呈现了相邻基坑开挖在宏观与局部时空尺度上的相互影响特征．该系统可为基坑群施工对基坑与周围环境受力变形影响机制的分析与验证提供高效的分析手段．

关键词: 基坑群, 监测数据, 施工信息, 可视化, 动态分析, 同步分析

Abstract:

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 developed 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 synchronous 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 interactive impact in the excavation of foundation pit groups.

Key words: foundation pit group, monitor, construction, visualization, dynamic analysis, synchronous analysis

中图分类号:

TU473

曾凡云, 李明广, 陈锦剑, 王建华. 基坑群监测数据与施工信息动态同步分析系统的开发与应用[J]. 上海交通大学学报, 2017, 51(03): 269-276.

ZENG Fanyun, LI Mingguang, CHEN Jinjian, WANG Jianhua. Development and Application of a System for Dynamic and Synchronous Analysis of both Monitor Data and Construction Information in Foundation Pit Groups[J]. Journal of Shanghai Jiao Tong University, 2017, 51(03): 269-276.

图/表 6

图1

图2

图3

图4

图5

图6

参考文献 17

[1]	刘国彬, 王卫东. 基坑工程手册 [M]. 2版. 北京: 中国建筑工业出版社, 2009.
[2]	TAN Y, WEI B. Performance of an overexcavated metro station and facilities nearby[J]. Journal of Performance of Constructed Facilities, 2012, 26(3): 241-254.
[3]	LIU G B, JIANG R J, NG C W W, et al. Deformation characteristics of a 38 mdeep excavation in soft clay[J]. Canadian Geotechnical Journal, 2011, 48(12): 1817-1828.
[4]	ROBOSKI J, FINNO R J. Distributions of ground movements parallel to deep excavations in clay[J]. Canadian Geotechnical Journal, 2006, 43(1): 43-58.
[5]	张友良, 陈从新, 刘小巍. 面向对象的深基坑监测模型及系统开发[J]. 岩石力学与工程学报, 2000, 19(Sup 1): 1061-1064.
	ZHANG Youliang, CHEN Chongxin, LIU Xiaowei. Object-oriented model and development of deep foundation pit monitoring system[J]. Chinese Journal of Rock Mechanics and Enginecring, 2000, 19(Sup 1): 1061-1064.
[6]	徐杨青, 程琳. 基坑监测数据分析处理及预测预警系统研究[J]. 岩土工程学报, 2014, 36(Sup 1): 219-224.
	XU Yangqing, CHENG Lin. Analysis processing of monitoring data and forecast and early warning system of foundation pits[J]. Chinese Journal of Geotechnical Engineering, 2014, 36(Sup 1): 219-224.
[7]	董文澎, 朱合华, 李晓军, 等. 大型基坑工程数字化施工仿真方法研究与应用[J]. 地下空间与工程学报, 2009, 5(4): 776-781.
	DONG Wenpeng, ZHU Hehua, LI Xiaojun, et al. Research on digital construction simulation in large foundation pit engineering[J]. Chinese Journal of Underground Space and Engineering, 2009, 5(4): 776-781.
[8]	杨佳, 张志强, 张强勇, 等. 深基坑安全监测信息分析系统的开发与应用[J]. 地下空间与工程学报, 2010, 6(6): 1246-1250.
	YANG Jia, ZHANG Zhiqiang, ZHANG Qiangyong, et al. Development and application of analyzing system for safety monitoring information on deep foundation pit[J]. Chinese Journal of Underground Space and Engineering, 2010, 6(6): 1246-1250.
[9]	钟正雄. 基坑工程监测数据库管理系统的设计及应用[J]. 地下空间, 1998, 18(Sup 1): 323-328.
	ZHONG Zhengxiong. Design and application of control system for data base on foundation work monitoring[J]. Underground Space, 1998, 18(Sup 1): 323-328.
[10]	高磊, 孙阳阳, 濮慧蕾, 等. 基坑监测信息管理系统的设计与实现[J]. 地下空间与工程学报, 2013, 9(Sup 2): 1984-1988.
	GAO Lei, SUN Yangyang, PU Huilei, et al. Design and implementation of monitoring information management system for foundation pit[J]. Chinese Journal of Underground Space and Engineering, 2013, 9(Sup 2): 1984-1988.
[11]	李元海, 朱合华. 岩土工程施工监测信息系统初探[J]. 岩土力学, 2002, 23(1): 103-106.
	LI Yuanhai, ZHU Hehua. Development of monitoring information system software for geotechnical engineering[J]. Rock and Soil Mechanics, 2002, 23(1): 103-106.
[12]	徐文杰, 唐德泓, 谭儒蛟, 等. 数字基坑系统在深大基坑工程中的应用[J]. 岩石力学与工程学报, 2015, 34(Sup 1): 3510-3517.
	XU Wenjie, TANG Dehong, TAN Rujiao, et al. Application of digital foundation pit system in a deep excavation[J]. Chinese Journal of Rock Mechanics and Engineering, 2015, 34(Sup 1): 3510-3517.
[13]	王浩, 覃卫民, 汤华. 关于深基坑施工期监测现状的一些探讨[J]. 岩土工程学报, 2006, 28(Sup 1): 1789-1793.
	WANG Hao, QIN Weimin, TANG Hua. Discussion on status of monitoring for deep pit excavation[J]. Chinese Journal of Geotechnical Engineering, 2006, 28(Sup 1): 1789-1793.
[14]	房师涛, 王骁云, 龚昕, 等. 上海市深基坑基础数据库系统设计[J]. 岩土工程学报, 2008, 30(Sup 1): 659-662.
	FANG Shitao, WANG Xiaoyun, GONG Xin, et al. Design of database system for deep foundation pit of Shanghai[J]. Chinese Journal of Geotechnical Engineering, 2008, 30(Sup1): 659-662.
[15]	高桂甫, 徐燕. 基于WebGIS的建筑基坑工程监测系统设计[J]. 现代测绘, 2014, 37(6): 24-27.
	GAO Guifu, XU Yan. Design of the monitoring system of building excavation engineering based on WebGIS[J]. Modern Surveying and Mapping, 2014, 37(6): 24-27.
[16]	KAMAT R V, MARTINEZ C J. Visualizing simulated construction operations in 3D[J]. Journal of Computing in Civil Engineering, 2001, 15(4): 329-337.
[17]	HAJJAR D, ABOURIZK S M. Unified modeling methodology for construction simulation[J]. Journal of Construction Engineering and Management, 2002, 128(2): 174-185.