A Study Of Spatial Analysis Based On SQL Server 2008

Along with the development of social information, geographic information system has been has widely used in reality. Spatial data is an important part of geographic information system. How to efficiently organize spatial data, perform query and analysis becomes a hot study issue. As spatial database can effectively organize and manage both spatial and non-spatial data, it has become one of the main ways in spatial data management.In this paper, relevant theoretical research on spatial database and spatial analysis is processed step by step. Moreover, this paper chooses SQL Server 2008 as research object, then, explores the implementation process of spatial database and spatial analysis. The process includes the organization and construction of spatial databases, spatial query, spatial analysis and the implementation process of spatial index.Based on the basic theory, a prototype was build, which includes storing of spatial data, conversion of heterogeneous spatial data, visualization, query and analysis of spatial data. The implementation process includes system analysis and design, spatial data format conversion of Shape file format and dwg file format, organization of map layers of spatial data query and analysis, visualization of results. SQL Server 2008 provides the basic spatial analysis functions, based on it, this paper improvements and optimization the method, acquires the ability of spatial data queries, topological relationship queries, buffer analysis, overlay analysis and other functions. Finaly, this paper chooses dangling node as topology error and fix the errors.The system improves and expands the functions provided by SQL Server 2008 such as spatial data organization, spatial query, analysis and visualization. Moreover, the results of this study has a certain academic value and practical value for study how to build spatial data management system which is based on spatial database.