Design And Implementation Of The Database System For The Hollow Villages In Suburban Areas

The development of rural hollowing out and the emergence of a large number of"hollow village" affected the construction and development of new countryside in China seriously.At present,the domestic research on regional information database is mainly embodied on the platform of single land type element such as "digital city" or"digital village",research on the suburban areas that both has architectural features in cities and topographical features of village district is relatively scarce.In the analysis of the problem of hollowing out of the suburban areas,the database system that reflects the basic information of such villages needs to be further studied and rationally constructed.This paper based on the unmanned aerial vehicle(UAV)technology rapid acquisition of land use information in suburban areas,established the digital suburban village database system preliminarily,and functional testing and practical application are also carried out,it can provide certain technical support for village basic data management,village scientific management and construction and development.The main work and results of this paper are:(1)Collect and collate the experimentation area UAV image and DLG map,land-use map,economic and social survey data of suburban hollowing villages those are necessary on basic data analysis,and conducted a preliminary data warehousing and statistical analysis.(2)Design the model structure of suburban hollow village database system,using the SQL Server to storage attribute data and table data,using ArcSDE spatial data engine to organize the storage of spatial data such as raster,vector and images,.(3)Using C#language,create database system interface and functions based on ArcObjects programming module,it realizes the functions of management,update and protection of the basic data in the database,that only the administrator can do,as well as the browsing,querying and outputting of the data that users available,so as to provide the basic data support for the hollow village governance.(4)In the database management system provides a number of statistical analysis modules for the statistical analysis of the basic data,to output of the user's interest histogram,line chart,pie charts and other statistical map.And according to the needs of the user,selective output the thematic maps such as overlay map of UAV image and land use map of village,and the potential of improvement of hollow structure map based on ecological sensitivity analysis,it will help the departments concerned plan and scientifically and rationally push forward the renovation of hollow villages in suburban areas.