CN116521777B - Remote interface method for tunnel engineering monitoring data - Google Patents

Remote interface method for tunnel engineering monitoring data Download PDF

Info

Publication number
CN116521777B
CN116521777B CN202310815362.5A CN202310815362A CN116521777B CN 116521777 B CN116521777 B CN 116521777B CN 202310815362 A CN202310815362 A CN 202310815362A CN 116521777 B CN116521777 B CN 116521777B
Authority
CN
China
Prior art keywords
monitoring data
monitoring
value
final
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202310815362.5A
Other languages
Chinese (zh)
Other versions
CN116521777A (en
Inventor
帅永建
程胜祥
杨祖林
陈柯朴
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sinohydro Bureau 7 Co Ltd
Original Assignee
Sinohydro Bureau 7 Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sinohydro Bureau 7 Co Ltd filed Critical Sinohydro Bureau 7 Co Ltd
Priority to CN202310815362.5A priority Critical patent/CN116521777B/en
Publication of CN116521777A publication Critical patent/CN116521777A/en
Application granted granted Critical
Publication of CN116521777B publication Critical patent/CN116521777B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G01MEASURING; TESTING
    • G01DMEASURING NOT SPECIALLY ADAPTED FOR A SPECIFIC VARIABLE; ARRANGEMENTS FOR MEASURING TWO OR MORE VARIABLES NOT COVERED IN A SINGLE OTHER SUBCLASS; TARIFF METERING APPARATUS; MEASURING OR TESTING NOT OTHERWISE PROVIDED FOR
    • G01D21/00Measuring or testing not otherwise provided for
    • G01D21/02Measuring two or more variables by means not covered by a single other subclass
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/02Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Testing Or Calibration Of Command Recording Devices (AREA)

Abstract

The invention discloses a remote interface method for tunnel engineering monitoring data, and belongs to the technical field of data processing. The method comprises the following steps: determining monitoring data category information according to the selected monitoring instrument; if the monitoring data category information exists in the database, determining the format of the monitoring data position information according to the monitoring data category information; acquiring monitoring data position information input according to the format of the monitoring data position information; acquiring input model parameters; if the model parameters exist in the database, acquiring an input original monitoring value; forming a final monitoring value according to the original monitoring value and the model parameter; forming initial monitoring data according to the monitoring data category information, the monitoring data position information and the final monitoring value; and carrying out format unification on the final monitoring value in the initial monitoring data according to the model parameters to obtain the final monitoring data. The invention realizes the high-speed, standardized and structured unified processing of the monitoring data.

Description

Remote interface method for tunnel engineering monitoring data
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a remote interface method for tunnel engineering monitoring data.
Background
The safety monitoring of tunnel engineering is developed by people in the summary of the teaching and training of various engineering accidents, and is diversified and diversified with the appearance of various advanced technologies. Before engineering construction, people recognize various potential accidents in engineering construction in advance and verify construction effects, monitor, analyze, judge, predict and early warn unknown information, and ensure safe and effective construction. Safety monitoring is accompanied with the whole life cycle of underground engineering design, construction and operation, and the monitoring is not only an important means for judging the safety and stability of underground engineering, but also an important method for checking the rationality of the design and construction. The monitoring technology of the underground engineering comprises the technical methods of multipoint displacement meter monitoring, anchor rod stress meter monitoring, microseismic monitoring, sound wave detection, optical fiber sensing deformation monitoring, laser convergence deformation monitoring, sliding micrometer monitoring, drilling television detection and the like.
However, the monitoring instruments are various, and the data result structure difference is large; for the same monitoring data, there are often multiple types of monitoring instruments, and the data formats of the monitoring instruments are different. This presents a significant challenge to monitoring data acquisition and entry, etc. In order to ensure timeliness of the monitoring data, more and more projects start to construct a monitoring data platform, and the monitoring data is timely and completely recorded into a system for analysis and calculation. For the establishment of the relevant monitoring platform, the speed, standardization and structuring of the unified processing of the monitoring data are necessary and urgent.
Disclosure of Invention
The invention aims to overcome the defects of the prior art, provides a remote interface method for monitoring data of tunnel engineering, and aims to carry out induction classification and format unification on the monitoring data acquired by monitoring instruments of various types and models so as to realize automatic input of the monitoring data.
The aim of the invention is realized by the following technical scheme: a remote interface method of tunnel engineering monitoring data, comprising:
determining monitoring data category information according to the selected monitoring instrument;
judging whether the monitoring data category information exists in the database, if so, determining the format of the monitoring data position information according to the monitoring data category information;
acquiring monitoring data position information input according to the format of the monitoring data position information;
acquiring input model parameters, wherein the model parameters correspond to the models of the monitoring instruments under the monitoring data category information one by one;
judging whether the model parameters exist in the database, if so, acquiring an input original monitoring value;
forming a final monitoring value according to the original monitoring value and the model parameter;
forming initial monitoring data according to the monitoring data category information, the monitoring data position information and the final monitoring value;
and carrying out format unification on the final monitoring value in the initial monitoring data according to the model parameters to obtain the final monitoring data.
Further, the monitoring instrument comprises one or more of a multipoint displacement meter, an anchor rod stress meter, a laser range finder and a microseismic monitor.
Further, the first bit of the final monitoring value is a model parameter.
Further, if the monitoring data category information does not exist in the database, the database is expanded.
Further, if the model parameters do not exist in the database, the database is expanded.
The beneficial effects of the invention are as follows:
(1) The invention classifies different kinds of monitoring data, unifies the formats of the same kind of data with different formats, so that the monitoring data obtained by a monitoring instrument can be automatically input into a specific monitoring system and stored in a specific data format, thereby realizing the high speed, standardization and structuring of unified processing of the monitoring data;
(2) In the invention, the data input and processing process is completely completed by the algorithm program, the time consumption is about 5s, the human intervention is not needed, the field measured data can be timely transmitted to the system and processed, and the timeliness of the monitored data is ensured;
(3) In the invention, the data with uniform format corresponding to the type of instrument is obtained by automatically processing the monitored data after being input. The data with a single format is visually expressed, and the change of the corresponding field in the life cycle of tunnel engineering can be well shown, so that the rationality of design and construction is checked. For the monitoring platform, the monitoring data in a unified format is easier to process, and can be better used for building a monitoring system of the whole tunnel engineering in all aspects.
Drawings
FIG. 1 is a flow chart of a remote interface method of the present invention;
fig. 2 is a schematic diagram of a composition of the final monitoring data.
Detailed Description
The technical solutions of the present invention will be clearly and completely described below with reference to the embodiments, and it is apparent that the described embodiments are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by a person skilled in the art without any inventive effort, are intended to be within the scope of the present invention, based on the embodiments of the present invention.
Referring to fig. 1 to 2, the present invention provides a remote interface method for tunnel engineering monitoring data:
the tunnel monitoring data can be divided into three parts: monitoring data category information (Type), monitoring data Location information (Location), and monitoring Value (Value). The monitoring data category information, i.e. the meaning of the monitored physical quantity represented by the monitoring data, is defined by the type of monitoring instrument and not represented by the data. The monitoring data position information is the layout position of the monitoring instrument, is recorded by a monitoring person and is not directly displayed on the monitoring instrument. The monitoring value is a reading of the monitoring instrument, and the data size is large in difference and can represent the change of the monitored physical quantity.
As shown in fig. 1, a remote interface method for tunnel engineering monitoring data includes steps S100 to S800. The following is a detailed description.
And S100, determining monitoring data category information according to the selected monitoring instrument.
The Type information (Type) of the monitoring data is selected and input by an operator, a specific monitoring instrument is selected when the data is input, and the Type value of the data is automatically defined. The monitoring instrument of the tunnel engineering can be defined as a multipoint displacement meter A, an anchor rod stress meter B, a laser distance meter C, a microseismic monitor D and the like, and the data obtained by monitoring comprise displacement, anchor rod stress, a tunnel wall displacement convergence value, microseismic data and the like.
And S200, judging whether the monitoring data type information exists in the database, and if yes, determining the format of the monitoring data position information according to the monitoring data type information.
In some embodiments, the database and algorithm are extended if the monitored data category information is not present in the database.
And S300, acquiring the monitoring data position information input according to the format of the monitoring data position information.
The monitoring data position information (Location) is input by an operator, and Location data with different dimensions are required to be input according to the Type value. The multipoint displacement meter, the anchor rod stress meter and the microseismic monitor have only one measuring point, and the coordinate P (x, y, z) of the measuring point is required to be input; the laser range finder acquires the convergence value of the displacement of the tunnel wall, and inputs the coordinates P1 (x 1, y1, z 1) and P2 (x 2, y2, z 2) of measuring points at the two ends of the tunnel wall.
And S400, acquiring input model parameters, wherein the model parameters correspond to the models of the monitoring instruments in the monitoring data category information one by one.
S500, judging whether the model parameters exist in the database, and if yes, acquiring an input original monitoring value.
In some embodiments, the database is expanded if the model parameter is not present in the database.
The original monitoring Value (Value) is read by a monitoring instrument and can be directly imported by files such as TXT, XLsX and the like. The raw monitored value contains more than one value. The Value values obtained by different types of monitoring instruments under the same Type Value can be different in specific numerical sequence although the numerical values of the Value values are the same, and the data cannot be directly summarized together. So, for each Type Value, a symbol (model parameter) is added in the first position of the Value, and the symbol is related to the model of the monitoring instrument under the Type Value and is independent from the Type Value.
And S600, forming a final monitoring value according to the original monitoring value and the model parameter.
The first bit of the final monitoring value is a model parameter.
And S700, forming initial monitoring data according to the monitoring data category information, the monitoring data position information and the final monitoring value.
And S800, unifying formats of final monitoring values in the initial monitoring data according to the model parameters to obtain the final monitoring data.
The final monitoring data consisted of Type, location, value parts together. As shown in fig. 2, a certain final monitoring data may be represented as ([ X ], [ P1, …, pn ], [ Xi, C1, C2, …, cm ]), where [ X ] is a Type value, and the values are a, B, C, D; [ P1, …, pn ] is a Location value, which is at most the coordinate values of two measuring points; [ Xi, C1, C2, …, cm ] is the Value, xi is the symbol corresponding to the monitoring instrument under the Type Value, and C1, C2, …, cm is the reading of the monitoring instrument.
The recording and processing process of the monitoring data in this embodiment can be summarized as follows: and an operator selects and inputs category information (Type) of the monitoring data, inputs position information according to a Location format set by the system according to the Type, inquires parameters corresponding to the Type of the instrument under the Type, and inputs the parameters and the monitoring Value together to form a Value. And the system algorithm performs format unification on the data with the same Type Value according to the first Value of the Value so as to be used by a monitoring platform.
The foregoing is merely a preferred embodiment of the invention, and it is to be understood that the invention is not limited to the form disclosed herein but is not to be construed as excluding other embodiments, but is capable of numerous other combinations, modifications and environments and is capable of modifications within the scope of the inventive concept, either as taught or as a matter of routine skill or knowledge in the relevant art. And that modifications and variations which do not depart from the spirit and scope of the invention are intended to be within the scope of the appended claims.

Claims (5)

1. A remote interface method for tunnel engineering monitoring data, comprising:
determining monitoring data category information according to the selected monitoring instrument;
judging whether the monitoring data category information exists in the database, if so, determining the format of the monitoring data position information according to the monitoring data category information;
acquiring monitoring data position information input according to the format of the monitoring data position information;
acquiring input model parameters, wherein the model parameters correspond to the models of the monitoring instruments under the monitoring data category information one by one;
judging whether the model parameters exist in the database, if so, acquiring an input original monitoring value;
forming a final monitoring value according to the original monitoring value and the model parameter;
forming initial monitoring data according to the monitoring data category information, the monitoring data position information and the final monitoring value;
and carrying out format unification on the final monitoring value in the initial monitoring data according to the model parameters to obtain the final monitoring data.
2. The method of claim 1, wherein the monitoring instrument comprises one or more of a multipoint displacement gauge, an anchor rod stress gauge, a laser range finder and a microseismic monitor.
3. The method of claim 1, wherein the first bit of the final monitor value is a model parameter.
4. The method of claim 1, wherein the database is expanded if the monitoring data category information is not present in the database.
5. The method of claim 1, wherein the database is expanded if the model parameters are not present in the database.
CN202310815362.5A 2023-07-05 2023-07-05 Remote interface method for tunnel engineering monitoring data Active CN116521777B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310815362.5A CN116521777B (en) 2023-07-05 2023-07-05 Remote interface method for tunnel engineering monitoring data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310815362.5A CN116521777B (en) 2023-07-05 2023-07-05 Remote interface method for tunnel engineering monitoring data

Publications (2)

Publication Number Publication Date
CN116521777A CN116521777A (en) 2023-08-01
CN116521777B true CN116521777B (en) 2023-09-22

Family

ID=87406791

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310815362.5A Active CN116521777B (en) 2023-07-05 2023-07-05 Remote interface method for tunnel engineering monitoring data

Country Status (1)

Country Link
CN (1) CN116521777B (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN202009405U (en) * 2011-02-23 2011-10-12 上海巨一科技发展有限公司 Health monitoring data acquiring module for bridge structure
CN102609513A (en) * 2012-02-07 2012-07-25 云南电力试验研究院(集团)有限公司电力研究院 Multi-data-source database system for condition monitoring of electric transmission and transformation equipment
CN104252665A (en) * 2014-09-16 2014-12-31 国家海洋信息中心 Method and system for managing marine environment monitoring data
CN107229838A (en) * 2017-07-17 2017-10-03 成都嘉逸科技有限公司 A kind of collecting method and data acquisition unit for medical monitoring equipment
CN208689748U (en) * 2018-07-14 2019-04-02 安徽峰翔电子科技有限公司 A kind of high-speed transit data abstraction and separator
CN115953877A (en) * 2022-12-28 2023-04-11 四川省化工质量安全检测研究院 Chemistry experiment room safety emergency wisdom platform
CN116361269A (en) * 2023-03-20 2023-06-30 中国科学院城市环境研究所 Method for rapidly generating database by modularly arranging biological monitoring data

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101485803B1 (en) * 2007-12-11 2015-01-26 삼성전자주식회사 Method and system for Data Transmission based on DLNA network
KR20100001434A (en) * 2008-06-27 2010-01-06 호서대학교 산학협력단 Message converting device for unified monitoring of industrial equipment

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN202009405U (en) * 2011-02-23 2011-10-12 上海巨一科技发展有限公司 Health monitoring data acquiring module for bridge structure
CN102609513A (en) * 2012-02-07 2012-07-25 云南电力试验研究院(集团)有限公司电力研究院 Multi-data-source database system for condition monitoring of electric transmission and transformation equipment
CN104252665A (en) * 2014-09-16 2014-12-31 国家海洋信息中心 Method and system for managing marine environment monitoring data
CN107229838A (en) * 2017-07-17 2017-10-03 成都嘉逸科技有限公司 A kind of collecting method and data acquisition unit for medical monitoring equipment
CN208689748U (en) * 2018-07-14 2019-04-02 安徽峰翔电子科技有限公司 A kind of high-speed transit data abstraction and separator
CN115953877A (en) * 2022-12-28 2023-04-11 四川省化工质量安全检测研究院 Chemistry experiment room safety emergency wisdom platform
CN116361269A (en) * 2023-03-20 2023-06-30 中国科学院城市环境研究所 Method for rapidly generating database by modularly arranging biological monitoring data

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
A unified rule format for bounded nondeterminism in SOS with terms as labels;L. Aceto 等;《Logical and Algebraic Methods in Programming》;64-86 *
智能化无线电监测管理平台系统建设的思考和探索;马家凯;《网络安全技术与应用》;119-120 *

Also Published As

Publication number Publication date
CN116521777A (en) 2023-08-01

Similar Documents

Publication Publication Date Title
CN111552995B (en) BIM-3DGIS and data automatic analysis technology-based rail transit construction visual monitoring management system
CN102750413B (en) Data processing and mapping method of topographic surveying of electric transmission line tower positions
CN110008274B (en) BIM-based visual automatic monitoring system for internal force of pile foundation
CN114136293B (en) BIM-based visual monitoring and early warning method and device
CN111291436A (en) BIM-based high formwork safety management monitoring method and monitoring system
CN114186825B (en) Natural gas inspection planning method
CN115654381A (en) Water supply pipeline leakage detection method based on graph neural network
CN112330184A (en) Construction risk prediction method, device, equipment and medium
CN115045714A (en) Mineral mining early warning method, mineral mining early warning equipment and computer-readable storage medium
CN111626046A (en) Correlation verification method for positions of telemetering text primitives and equipment primitives of transformer substation
Urbas et al. Augmented reality aided inspection of gears
CN114387332B (en) Pipeline thickness measuring method and device
CN116308185A (en) Visual progress input and early warning method for constructional engineering
CN115905650A (en) Coal mine production three-dimensional visual information system based on Internet of things and sensor technology
CN105632114A (en) Monitoring measurement point safety state monitoring method based on GIS technology
CN116678368B (en) BIM technology-based intelligent acquisition method for assembled steel structure data
CN116521777B (en) Remote interface method for tunnel engineering monitoring data
CN116842765B (en) Method and system for realizing underground safety management of petroleum logging based on Internet of things
CN111538297A (en) Web-based interactive three-dimensional visualization platform
CN116522096A (en) Three-dimensional digital twin content intelligent manufacturing method based on motion capture
CN113919170A (en) Working condition environment simulation method and system based on multi-sensor fusion
CN106997462A (en) A kind of quantum wire image-recognizing method
CN115017585A (en) Arch dam deformation behavior characterization visual analysis system
CN110873896B (en) Method and system for intelligently analyzing seismic trace head information
CN110580385A (en) data processing method, device and equipment for underground pipeline and computer storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant