Detection System of Tunnel Portal Steel Ring Based on C# and SQL Server

doi:10.3969/j.issn.1674-0696.2017.12.04

Journal of Chongqing Jiaotong University(Natural Science) ›› 2017, Vol. 36 ›› Issue (12): 18-21.DOI: 10.3969/j.issn.1674-0696.2017.12.04

• Bridge & Tunnel Engineering • Previous Articles Next Articles

Detection System of Tunnel Portal Steel Ring Based on C# and SQL Server

ZHANG Yang1，ZHANG Zhigang1，QIAN Dong1，TIAN Linya2，BI Jixin2

(1. Suzhou Geological Engineering Investigation Institute，Suzhou 215129，Jiangsu，P. R. China； 2. School of Earth Science and Engineering，Hohai University，Nanjing 211100，Jiangsu，P. R. China)

Received:2016-11-08 Revised:2017-03-10 Online:2017-12-18 Published:2017-12-18

基于C#与SQL Server的隧道洞门钢环检测系统

张洋1，张志刚1，钱栋1，田林亚2，毕继鑫2

(1. 苏州地质工程勘察院，江苏苏州 215129； 2. 河海大学地球科学与工程学院，江苏南京 211100)

作者简介:张洋(1968—)，男，江苏徐州人，高级工程师，主要从事精密工程测量方面的研究。E-mail：873240839@qq.com。通信作者：毕继鑫(1994—)，男，黑龙江牡丹江人，硕士，主要从事测量数据处理理论与方法方面的研究。E-mail：bijixin7317@163.com。
基金资助:
江苏省地质矿产勘查局科研项目（2016-KY-03）

Abstract

Abstract: The research on the algorithm that directly obtains the center coordinates and the radius based on space vector fitting 3D circle was carried out，and the proposed algorithm was applied to the detection and analysis of tunnel portal steel ring’s spatial formation. C# programming language and SQL Server database were used to develop the data processing and analysis system for detection of tunnel portal steel ring. The proposed system could fit portal steel ring’s spatial formation，calculate the center coordinates and radius of tunnel portal steel ring and accomplish the quality evaluation of the spatial formation of portal steel ring. Through an example of engineering application，the correctness of the proposed detection method and analysis system was verified. Research results can provide the reference to the detection work of spatial formation for other similar buildings.

Key words: tunnel engineering, metro tunnel, tunnel portal steel ring, formation-fitting, C# programming language, SQLServer database, detection system

摘要： 对基于空间向量拟合空间圆直接获取圆心坐标及半径的算法进行研究，将该算法应用于隧道洞门钢环空间形态的检测与分析。以C#编程语言和SQL Server数据库为工具，开发了隧道洞门钢环检测数据处理与分析系统，利用该系统可进行洞门钢环空间形态的拟合，进行洞门钢环圆心坐标和半径的计算，完成洞门钢环空间形态的质量评价。通过工程实例，验证了所提出的检测方法与分析系统的正确性，研究成果也可为其它类似建筑物的空间形态检测工作提供参考。

关键词: 隧道工程, 地铁隧道, 洞门钢环, 形态拟合, 编程语言C#, 数据库SQLServer, 检测系统

CLC Number:

U231+.4

ZHANG Yang1，ZHANG Zhigang1，QIAN Dong1，TIAN Linya2，BI Jixin2. Detection System of Tunnel Portal Steel Ring Based on C# and SQL Server[J]. Journal of Chongqing Jiaotong University(Natural Science), 2017, 36(12): 18-21.

张洋1，张志刚1，钱栋1，田林亚2，毕继鑫2. 基于C#与SQL Server的隧道洞门钢环检测系统[J]. 重庆交通大学学报（自然科学版）, 2017, 36(12): 18-21.

References

［1］贾志强. 地铁盾构隧道洞门钢环圆心坐标的精确测定［J］. 测绘信息与工程，2011，36(2)：31-33.
JIA Zhiqiang. Accurate surveying of center coordinate of circle of subway shield tunnel gateway steel ring［J］. Journal of
Geomatics
，2011，36(2)：31-33.
［2］韩三琪，张晓川. 地铁洞门钢环中心三维坐标拟合计算［J］. 施工技术，2016，45(6)：521-523.
HAN Sanqi，ZHANG Xiaochuan. The 3D coordinate fitting calculate-on of the center of subway shield tunnel portal steel ring［J］.
Construction Technology，2016，45(6)：521-523.
［3］田林亚，王进峰，武东辉. 全站仪三维坐标法在桥梁施工测量中的应用［J］.测绘科学，2010，35(3)：198-202.
TIAN Linya，WANG Jinfeng，WU Donghui. Application of total station three dimensional coordinate surveying in construction survey
of
bridge［J］. Science of Surveying and Mapping，2010，35(3)：198-202.
［4］刘九阳，杨凤芸，刘森，等. TM30测量机器人ATR功能的功效及精度［J］. 辽宁工程技术大学学报(自然科学版)，2015，34(11)：1275-1279.
LIU Jiuyang，YANG Fengyun，LIU Sen，et al. Efficiency and precision of ATR function for TM30 measurement robot［J］. Journal of
Liaoning Technical University (Natural Science)，2015，34(11)：1275-1279.
［5］郭雪瑶，田林亚，黄瑾，等. 校园标志物空间形态的测量与分析［J］. 测绘通报，2015(9)：87-90.
GUO Xueyao，TIAN Linya，HUANG Jin，et al. Measurement and analysis of campus landmark spatial form［J］. Bulletin of Surveying and
Mapping，2015(9)：87-90.
［6］潘国荣，陈晓龙. 空间圆形物体数据拟合新方法［J］. 大地测量与地球动力学，2008，28(2)：92-94.
PAN Guorong，CHEN Xiaolong. A new method for 3D circular object fitting［J］. Journal of Geodesy and Geodynamics，2008，28(2)：92
-94.
［7］潘国荣，李怀锋. 基于空间向量的空间圆形拟合检测新方法［J］. 大地测量与地球动力学，2010，30(4)：106-108.
PAN Guorong，LI Huaifeng. A new test method based on space vector in 3D circle fitting［J］. Journal of Geodesy and Geodynamics，
2010
，30(4)：106-108.
［8］闫旭. 浅谈SQL Server数据库的特点和基本功能［J］. 价值工程，2012，31(22)：229-230.
YAN Xu. Research of the characteristics and basic functions of the SQL Server database［J］. Value Engineering，2012，31(22)：229-230.

[1]	QIN Haiyang1, TANG Yongjing1,2, CHEN Zhiyuan3. Application of BIM Technology in Tunnel Design Based on CATIA [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(07): 82-87.
[2]	DAI Yuhao, WANG Hua, PENG Guibin. Prediction Method of Leakage State in the Yuxi-Mohan Railway Tunnel Based on TEM [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(07): 88-92.
[3]	SU Xingju. Design and Analysis of Half-Open Arch Portal in Shallow Buried Bias Tunnel [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(06): 112-116.
[4]	WEI Meng, FANG Zhongyang, CHAI Bingbing, QI Jinhui. Prediction of the Maximum Surface Settlement of Shield Tunnel in Sandy Cobble Stratum [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(05): 110-115.
[5]	ZHANG Shihao1, LI Tong2,3,4, LI Xuan5, HAO Baoan1, SHI Chun1. Influence Factors of Shield Tunneling Efficiency in Granite Strata [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(04): 105-111.
[6]	TAN Xukai1,2, GAO Feng1,2, XU Wei1, LUO Xing1. Instability Criterion Method of Tunnel Engineering under Seismic Action [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(03): 108-115.
[7]	ZHONG Yupei1, QI Yanjun2, LIU Shukui2. Application of PVC Pipe Cumulative Blasting Method in Horizontal Sandy Mudstone Tunnel [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(03): 116-120.
[8]	JIANG Jiabing1, CHEN Zilong2, XU Tao3. Excavation Face Stability of Slurry Shield Tunnel in Saturated Sand Layer [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(02): 95-100.
[9]	LI Zhiyong, HUANG Hua. Tunnel Lighting Quality Based on Bright Color Pavement [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(02): 101-107.
[10]	CAO Liqiao1, WANG Zhibin2, ZHOU Dingheng3. Influence Analysis of Buckle-Arch Construction Sequence of PBA Station on the Settlement of Upper River-Crossing Bridge [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(01): 79-86.
[11]	WU Zhouhu. Properties and Optimization Design of a New Heteromorphic Ellipse Tunnel Cross-Section [J]. Journal of Chongqing Jiaotong University(Natural Science), 2021, 40(01): 87-95.
[12]	LI Yingshuai1, WANG Weijie1, WANG Maosheng2. Optimization Design of Urban Tunnel Lighting [J]. Journal of Chongqing Jiaotong University(Natural Science), 2020, 39(11): 76-80.
[13]	DING Hao1,2, LIU Peng1, MA Fei2, XIA-Yang Yuyu2, LI Yu1. Lighting Quality of Asymmetric Light Distribution in Highway Tunnels [J]. Journal of Chongqing Jiaotong University(Natural Science), 2020, 39(10): 54-59.
[14]	ZHANG Xiao, YIN Zhanchao, LIU Xiao, DUAN Chonghao, HAO Pengshuai. Application of Integrated Geophysical Prospecting Technology in Disease Detection of Operating Karst Tunnels [J]. Journal of Chongqing Jiaotong University(Natural Science), 2020, 39(10): 60-66.
[15]	ZHOU Zhihai, CHEN Fang. Safety Impact Assessment of Existing Track Structure under the Proposed Municipal Viaduct [J]. Journal of Chongqing Jiaotong University(Natural Science), 2020, 39(06): 59-65.

Detection System of Tunnel Portal Steel Ring Based on C# and SQL Server

基于C#与SQL Server的隧道洞门钢环检测系统

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics