城市軌道交通隧道結(jié)構(gòu)智能健康監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)A.1項(xiàng)目基礎(chǔ)信息項(xiàng)目基礎(chǔ)信息表設(shè)計(jì)見(jiàn)表A.1。表A.1工程基礎(chǔ)信息字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ProjName項(xiàng)目名稱(chēng)字符型ProjCharge項(xiàng)目管理人員字符型ProjNumber項(xiàng)目編號(hào)字符型ProjType項(xiàng)目類(lèi)型字符型ProjAbbre項(xiàng)目簡(jiǎn)稱(chēng)字符型ProjLongitude所在經(jīng)度雙精度浮點(diǎn)型單位：°ProjLatitude所在緯度雙精度浮點(diǎn)型單位：°OwnerUnit業(yè)主字符型DesignUnit設(shè)計(jì)單位字符型SupervisUnit監(jiān)理單位字符型ConstructUnit施工單位字符型SurveyUnit監(jiān)測(cè)單位字符型ProjDirector項(xiàng)目負(fù)責(zé)人字符型ProjWorker作業(yè)負(fù)責(zé)人字符型ProjAddress項(xiàng)目地址字符型CreateDate創(chuàng)建日期日期時(shí)間型ProjMap項(xiàng)目地圖字符型A.2監(jiān)測(cè)點(diǎn)信息監(jiān)測(cè)點(diǎn)信息表設(shè)計(jì)見(jiàn)表A.2。表A.2監(jiān)測(cè)點(diǎn)信息表字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注PCollection監(jiān)測(cè)工點(diǎn)字符型MonitorObj監(jiān)測(cè)對(duì)象字符型PointType監(jiān)測(cè)類(lèi)型整型PointName監(jiān)測(cè)點(diǎn)名字符型PtPerson負(fù)責(zé)人字符型PointXCor監(jiān)測(cè)點(diǎn)X坐標(biāo)雙精度浮點(diǎn)型單位：mPointYCor監(jiān)測(cè)點(diǎn)Y坐標(biāo)雙精度浮點(diǎn)型單位：mPointZCor監(jiān)測(cè)點(diǎn)Z坐標(biāo)雙精度浮點(diǎn)型單位：mPtLocation測(cè)點(diǎn)位置字符型PtBeginTime開(kāi)始時(shí)間日期時(shí)間型PtEndTime結(jié)束時(shí)間日期時(shí)間型A.3智能全站儀監(jiān)測(cè)智能全站儀監(jiān)測(cè)表設(shè)計(jì)見(jiàn)表A.3。表A.3智能全站儀監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整形PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型TPS_XCorX坐標(biāo)雙精度浮點(diǎn)型單位：mTPS_YCorY坐標(biāo)雙精度浮點(diǎn)型單位：mTPS_ZCorZ坐標(biāo)雙精度浮點(diǎn)型單位：mMark標(biāo)識(shí)整形數(shù)據(jù)有效位標(biāo)識(shí)A.4全球衛(wèi)星導(dǎo)航系統(tǒng)(GNSS)監(jiān)測(cè)GNSS監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.4。表A.4GNSS位移監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整形PointID監(jiān)測(cè)點(diǎn)字符型PeriodId監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型Longitude經(jīng)度雙精度浮點(diǎn)型單位：°Latitude緯度雙精度浮點(diǎn)型單位：°Height大地高雙精度浮點(diǎn)型單位：mGNSS_XCorX坐標(biāo)雙精度浮點(diǎn)型單位：mGNSS_YCorY坐標(biāo)雙精度浮點(diǎn)型單位：mGNSS_ZCorZ坐標(biāo)雙精度浮點(diǎn)型單位：mMark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.5激光雷達(dá)監(jiān)測(cè)激光雷達(dá)監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.5。表A.5激光雷達(dá)監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型LiDAR_XCorX坐標(biāo)雙精度浮點(diǎn)型單位：mLiDAR_YCorY坐標(biāo)雙精度浮點(diǎn)型單位：mLiDAR_ZCorZ坐標(biāo)雙精度浮點(diǎn)型單位：mReflectionIntensity反射強(qiáng)度雙精度浮點(diǎn)型Mark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.6合成孔徑雷達(dá)監(jiān)測(cè)合成孔徑雷達(dá)監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.6。表A.6合成孔徑雷達(dá)監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型DistChangeValue視線(xiàn)向變化量雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整形數(shù)據(jù)有效位標(biāo)識(shí)A.7激光位移監(jiān)測(cè)激光位移監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.7。表A.7激光位移監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Temperature溫度雙精度浮點(diǎn)型單位:℃Distance距離雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.8靜力水準(zhǔn)監(jiān)測(cè)靜力水準(zhǔn)監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.8。表A.8靜力水準(zhǔn)監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Temperature溫度雙精度浮點(diǎn)型單位:℃Settlement沉降量雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.9鋼筋銹蝕監(jiān)測(cè)鋼筋銹蝕監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.9。表A.9鋼筋銹蝕監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Temperature溫度值雙精度浮點(diǎn)型單位:℃RelativeHumidity相對(duì)濕度值雙精度浮點(diǎn)型單位:%ConcreteResistivity混凝土電阻率雙精度浮點(diǎn)型單位：Ω?mCorrosionPotential鋼筋腐蝕電位雙精度浮點(diǎn)型單位：mVCorrosionCurrentDensity腐蝕電流密度雙精度浮點(diǎn)型單位：μA/cm2Mark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.10裂縫監(jiān)測(cè)裂縫監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.10。表A.10裂縫傳感字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Temperature溫度雙精度浮點(diǎn)型單位:℃CrackWdth裂縫寬度雙精度浮點(diǎn)型單位：mmWaterSeepage裂縫是否滲水字符型RustTraces裂縫是否有銹跡字符型Mark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.11應(yīng)力應(yīng)變監(jiān)測(cè)應(yīng)力應(yīng)變監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.11。表A.11應(yīng)力應(yīng)變監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Temperature溫度雙精度浮點(diǎn)型單位:℃StrainValue應(yīng)變雙精度浮點(diǎn)型單位：μεStressValue應(yīng)力雙精度浮點(diǎn)型單位：MPaMark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.12振動(dòng)監(jiān)測(cè)振動(dòng)監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.12。表A.12振動(dòng)監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime監(jiān)測(cè)時(shí)間日期時(shí)間型Vibrate振動(dòng)加速度峰值雙精度浮點(diǎn)型單位:cm/s2VibrateFreq主振頻率雙精度浮點(diǎn)型單位:HzMark標(biāo)識(shí)整型數(shù)據(jù)有效位標(biāo)識(shí)A.13降雨量監(jiān)測(cè)降雨量監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.13。表A.13降雨量監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型RainFall降雨量雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整型數(shù)據(jù)有效標(biāo)識(shí)A.14地下水位監(jiān)測(cè)地下水位監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.14。表A.14地下水位監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型GroundwaterTableDepth地下水位雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整型數(shù)據(jù)有效標(biāo)識(shí)A.15襯砌破損監(jiān)測(cè)襯砌破損監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.15。表A.15襯砌破損監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型LiningDamageArea襯砌破損面積雙精度浮點(diǎn)型單位：mm2LiningDamageDepth襯砌破損深度雙精度浮點(diǎn)型單位：mmMark標(biāo)識(shí)整型數(shù)據(jù)有效標(biāo)識(shí)A.16塌陷監(jiān)測(cè)塌陷監(jiān)測(cè)數(shù)據(jù)表設(shè)計(jì)見(jiàn)表A.16。表A.16塌陷監(jiān)測(cè)字段名字段說(shuō)明數(shù)據(jù)類(lèi)型備注ID主鍵整型PointID監(jiān)測(cè)點(diǎn)字符型Period監(jiān)測(cè)期次整型SurveyDateTime測(cè)量時(shí)間日期時(shí)間型CollapseArea塌陷面積雙精度浮點(diǎn)型單位：mm2CollapseDept