坐标法监测基坑水平位移的精度分析及数据处理

2005,21(1):1012CN53-1124/TDISSN1007-9394SurveyingandMappingofGeologyandMineralResourcesVol.21,No.1,20053,(,210098):,,,Excel2000,:;;;:P25;P207:A:1007-9394(2005)01-0010-03PrecisionAnalysisandDataProcessingforCoordinateMethodMonitoringHorizontalDisplacementofFoundationPitZHOUXi2zhen,ZHAOZhong2rong(Dept.ofSurveyingandMappingEngineering,HehaiUniversity,Nanjing,Jiangsu210098,China)Abstract:Thispaperintroducesdirectdeterminingcoordinatemethod.Takingthemeasureofhorizontaldisplace2mentofNanjingcertainpitasanexample,itcarriesthroughbrieflyprecisiondiscussion.Inobservationdataprocessing,itutilizesExcel2000electronicsheetfunctionofcalculationtocarrythroughthecalulationofdisplacementvalueandthepileofdisplacementvalueandtheplotting,andcouldofferspeedilyandtrulyobservationreportformsandmapsordraw2ings.Keywords:horizontaldisplacement;coordinatesurveying;precisionanalysis;dataprocessing0,,,,,,,,,,,,1,,,,,,,812m,,,,,,2,,,,,,,,,1,SDNDX,WY3,,P:xp=xA+ssinzcos;yp=yA+ssinzsin(1)(1):ZP,S,P,013:2003-12-30(1):dx=dssinzcos+scoscoszdz-ssinzsinddy=dssinzsin+scoszsindz-ssinzcosd(2):m2x=m2ssin2zcos2+s2cos2zcos2(mz)2+s2sin2zsin2(m)2m2y=m2ssin2zsin2+s2cos2zsin2(mz)2+s2sin2zcos2(m)2m2p=m2x+m2y=m2ssin2z+s2cos2z(mz)2+s2sin2z(m)2(3),mz=m=m,mp=m2ssin2z+(m2)s2(4)ms:m2s=2+(bppms)2(5)TC2003(1+10-6s)mm,015SET2C(3+210-6s)mm,210,115mm,310mm,610mm,(4)(5)1(90)1Table1Theprecisionanalysistableofmeansquareerrorofpoints/m2030405060708090mp/mmTC2003,0151+110-6S11231123112411251126112711291132SET210,22+210-6S21132114211621182120212321262134SET2C,23+210-6S310931103111311231143116311831241,100m,,TC20031,,2(2+210-6S)SET2101TC2003,,mp=11322=1187(mm),,2(3+210-6S)SET2C,mp=31242=4158(mm),,,4,20m,60m,,016m,019m,812m,415m,,,,,11Fig.1SketchmapofdisplacementmonitoringpointsTC2003,22Table2HorizontaldisplacementtableofdistortionmonitoringpointsX0Y0/mXi-1Yi-1/mXiYi/md/mmD/mmWD1(Y)100108351001089410010910116715WD2(Y)100106181001068410010699115811WD3(Y)100105481001061110010617016619ND1(X)128145501281447312814460113910ND2(X)1281450412814402128143901121114ND3(X)1281452112814397128143732141418ND4(X)1281450012814393128143791141211ND5(X)128144251281433712814332015913SD1(X)1061960510619772106197321101217SD2(X)1061959710619735106197531181516SD3(X)1061950810619358106193761181312SD4(X)1061937010619482106194900181210SD5(X)10619600106197061061971911311192,Excel2000,,::di=xi-xi-1di=yi-yi-1:Di=xi-x0Di=yi-y0(6)57,415m5=2215mm,1/101/20,1/102215mm1/10=2125mm,TC2003113,:2,WD2ND3SD2SD3,,,,,,,1,,,,,,,,,1,5,,+,XY,,,,,Excel2000,X,Excel2000,2,2,,6,,2Fig.2Horizontaldisplacementmap,,,,Excel2000,,,,,,[][1],1[M]1:,20011[2],1[M]1:,20021:(1963),,,,,(6)(ai):x(t)=a0+a1t+a2t2=6414644-1111023t+0101024t2v=dx/dt=-1111023+01024048tv=0,:t=54d54d53d,:1,200274+54=2002827,2002827,,,,:,,,0():n,n;()x=f(t),()xm(t)=a0+a1t+a2t2++antm,f(t)xm(tj),xm(t)ai,x(t)(),v=dx/dt,v=dx/dt=0,t,,,3,,,,,,,,,,,,,,,[][1],1[M]1:,19841[2],,1[M]1:,20011:(1966),,,2121