Cloud Data Management And Analysis Of Road Collapse Detection By Transient Electromagnetic Method

With the acceleration of our country urbanization process,road collapse accidents have occurred frequently.The collapse of urban roads seriously threatens people’s lives.To prevent the incident from happening again,it’s urgent to develop a detection device that can often detect road collapses,and the data management and analysis system for this device.Transient electromagnetic method is a relatively mature method of geophysical prospecting,which has been widely used in engineering.Others in this laboratory have developed an array type transient electromagnetic instrument suitable for road collapse detection.For this instrument,this thesis has developed a transient electromagnetic data management and analysis system based on cloud server for its related data acquisition,storage,processing and forward and inverse analysis needs.Through theoretical analysis,the use of array-type receiving coils in the transient electromagnetic instrument,can effectively improve its resolution in shallow geological exploration.Using the finite element analysis software ANSYS Maxwell,the electromagnetic simulation model of the road collapse detection system is established,the magnetic flux density of the abnormal body under test is analyzed,and the simulation results are used to guide the analysis and processing of transient electromagnetic data.Aiming at the problem of data collection,an Android-based collection control software was developed.The software and hardware devices use a custom communication protocol to connect via WiFi,and the custom communication protocol is implemented based on the TCP/IP protocol.The acquisition software realizes the function of uploading data files to the cloud based on the mobile application direct transfer service,and realizes the function of marking the hidden danger location of collapse based on the GPS system,as well as the function of displaying the map result,waveform display,parameter setting and so on.Because road collapse detection has the characteristics of large amount of data and many types of files,in order to ensure the reliable classification,storage,archiving and traceability of the data,a data management system based on cloud servers has been developed.The system has a B/S architecture,and the system is divided into administrator and user ends,and both the administrator and the user ends can upload and download files.The cloud server uses the MySql database and adopts the primary and foreign key design to establish the association between the collected data,the drawing results,and the analysis report in the same project.In order to ensure the security of user information and data files,Shiro framework and RBAC authority design are introduced to realize the authority management of user login,upload,download and other actions by the administrator.The SpringBoot framework is used to realize the system hot deployment function,which reduces the difficulty of system maintenance.Aiming at the problem of data processing,a transient electromagnetic data processing system based on cloud server was developed.The data processing system includes electromagnetic data interpretation software,automation script,and graph output software.To achieve the goal of automatic processing of data in a cloud server,this thesis integrates the least mean square adaptive filtering algorithm in the electromagnetic data interpretation software to automatically process the tail end interference of the secondary field data.The inversion procedure is completed based on the "smoke ring theory",the data is imported into the charting software through an automated script to complete the final result chart.After the overall development of the system was completed,a black box test was carried out for the file upload cloud function of the data acquisition software,result graph display function,and the map marking anomaly point function,at the same time,a black box test was carried out on the file upload and download function,file classification management function,and management authority of the data management system.According to the comparison between the test results and the expected demand,the system as a whole can initially meet the requirements of actual exploration work.