Development And Application Of Geotechnical Engineering Investigation Database System In Nanning Based In GIS

In the past,a large number of geotechnical engineering survey data have been accumulated,and the statistical analysis of these data can provide reference for the design and construction of foundation pit engineering in the future.However,due to the complexity and the huge quantity of the data,it is difficult to conduct the data directly.The combination of urban geotechnical engineering database and visualization technology has become an urgent problem to be solved.Firstly,based on the GIS develop the geotechnical engineering investigation database system of Nanning,to realize information management for geological information,and then apply the database system developed to parameter value analysis and correlation analys of main physical and mechanical parameters of rock and soil layers of Nanning metro.The research results are beneficial to the information management of geotechnical engineering investigation data in Nanning,and provide technical support for the follow-up"smart Nanning" construction.the main research achievements in the article are as follow:(1)Due to the characteristics of closure,large and poor interaction of the traditional GIS structure closed,this paper developed a geotechnical engineering survey database system based on lightweight GIS geographic information system component of Nanning.The system can not only manage the spatial data and non spatial data of geotechnical engineering comprehensively,but also combine with the GIS technology to coordinate overlap attribute information of geotechnical engineering field,drilling,and geotechnical test with area bitmap,contour map,pseudo color map orientation.(2)Based on Nanning subway one,two,three line rail transit project,part of the road and bridge engineering and housing construction project,437 preliminary investigation reports of geotechnical engineering in Nanning city during 1994-2015 were collected,and translate theminto the data entry module of Nanning Geotechnical Engineering Survey Database Management System,which provides the basis for the following value analysis and correlation analysis of the physical and mechanical parameters of the main rock and soil.(3)Taking Nanning metro line three as an example,this paper studies the analysis method of physical and mechanical parameters of main soil layers in Nanning based on GIS system:Firstly,taking the "three order" method to statistic and divide geotechnical units;Then,use the developed GIS geotechnical investigation database information system to retrieved the physical and mechanical indexes of the main rock and soil layers of metro line three and carry out the reliability test of the data.Finally,the SPSS data analysis software is used to comprehensively compare the statistical results.Finally,the physical and mechanical parameters reference values of the main rock and soil layers along the subway line three are obtained.(4)Taking the plastic silty clay in Nanning as an example,the correlation analysis method of physical and mechanical parameters of main soil layers in Nanning based on GIS system is studied.The results show that there is a good correlation between the mechanical parameters and the physical parameters besides the plasticity index;there are multiple linear relationship between mechanical parameters and physical parameters,correlation and correlation are greater than a regression formula of the income.There is a multiple linear correlation between the mechanical parameters and the physical parameters,and the correlation is greater than the correlation of the formula obtained by the unary regression...