Analysis of spatial indexing mechanism and its application in data management: A case study on spatialite database

Abstract

Lightweight spatial database Spatialite is playing an increasing role in the current geographic information applications and other fields. This paper discusses the data organization and spatial indexing mechanism of Spatialite database in detail, studies the use of Spatialite database for data organization and index establishment, and utilizes the retrieval and spatial analysis methods supported by spatial index. The experiment takes urban pipeline data management as an example, through the visual application of urban pipeline data management in the 3DGIS environment, it provides a good solution for data management application of lightweight spatial database.