Managing Green Cover in Urban Area Using NoSQL Database

Green cover is important for the sustainability of urban area. Urban green area is a land space that covered by grass, shrubs, trees, and other vegetation that exist in the urban area. It functions to increases the environment quality and the beauty of an area. With the development of urban area, it is becoming harder to track and control the green cover area as some of the green cover is covered by building and the image failed to completely visualize and classify the green cover. Thus, this chapter investigates a method to store information of green cover in urban area using 3D point clouds. The point clouds data are acquired using Airborne LIDAR and classify several urban green areas, such as grass, shrubs, trees, and ground. Due to the very detail features captured by LIDAR data acquisition, this study proposed to organize the point clouds of urban green cover in NoSQL database. The NoSQL database offers capability in handling voluminous unstructured data efficiently. Since the main data source for this study are unstructured 3D point clouds, this chapter is aimed to test the capability of NoSQL database in handling information of green covers. Several queries related to urban sustainability such as sustainability value and nearest query are performed. Based on the result, it is showed that the NoSQL database efficiently organize the urban green cover dataset and successfully responded to the query operation. Even though traditional database is common than NoSQL, we believe for future application, the NoSQL database could offer better performance and features than traditional database in handling urban green covers, Ultimately, our finding is meant to support the planning and management of green infrastructure that can assist the local authorities for decision making and future planning of urban sustainability.