Research on Point Cloud Data Management Based on Spatial Index and Database

Abstract:

Laser point set has a massive quantity of data, which not only increases system load, but greatly reduces the follow-up processing efficiency as well. Considering the difficulty of mass point cloud data organization and management, grid index of point cloud data based on the decimal linear quadtree is proposed in this paper, point cloud data is segmented and encoded by means of linear quadtree based on decimal system, which will be stored in SQL Server, then, we can block and index point cloud in terms of Morton code or rectangular region, combine with the advantages of both spatial index and database to manage point cloud efficiently and safely. The results show that the proposed method ideally solves the problem of point cloud data organization and management.

• Periodical: Advanced Materials Research (Volumes 850-851)
• Pages: 685-688
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.850-851.685
• Online since: December 2013
• Authors: Jian Li*, Hong Yuan Fang, Yu Rong Ma, Hai Bo Yang
• Keywords: Database, Morton Code, Point Cloud, Spatial Index, Visualization

References

[1] J Li: Research on terrestrial laser scanning technology combined with the close-range photogrammetry reconstruction key technology(Ph.D., ​​Wuhan University, China 2012), p.5. [In Chinese].

[2] J Li, RF Zhong and WJ Zhao. Journal of System Simulation. Vol. 20 (2008) pp.33-35, 39. [In Chinese].

[3] YF Liu: Theory and method on point cloud data spatial management based on kd-tree(MS., ​​ Central South University, China 2009), p.26. [In Chinese].

[4] ZL Lai, YC Wan, SH Shen and JZ Xu. Science of Surveying and Mapping. Vol. 34 (2009) No. 6, pp.128-130. [In Chinese].

[5] M. Meijers, S. Zlatanova and N. Pfeifer. 3D Geo-Information Indoors: Structuring for Evacuation[J]. Proceedings of Next Generation 3D City Models, Bonn. Vol. 21 (2005) No. 8, p.6.