Organization and query of point clouds data based on SQL Server spatial

Abstract

Three-dimensional laser scanning produces a large number of point clouds data. In order to efficiently retrieve the point clouds data, this paper stores the point clouds data in SQL Server 2008, and create a spatial index. Using C # software and SQL Server 2008 Spatial technology to achieve the storage and inquiry of point clouds data, and the results of the inquiry is carried out visualization in the MapObjects component, preparing for the follow-up feature extraction. The test shows that the method greatly improves the efficiency of point clouds data retrieval. © 2010 IEEE.