Spatial Network in SQL Databases for Real-Time Multimodal Emergency Routing in Wildland Fires

Abstract

Evacuation routing in wildland areas is an important aspect during various emergencies, including fire incidents. A review of the literature found a lack of research on vector routing systems for evacuations from wildland areas. This article aims to address the issue of determining evacuation routes using vector object database technology with various optimization methods. To this end, the author developed a novel algorithm for network creation and optimization through heuristic data aggregation. Case studies were conducted in a wooded area of the Bieszczady Mountains, where the potential of determining evacuation routes in the proprietary geodatabase (SQLite SpatiaLite) was examined, and the results were compared with traditional methods based on raster least-cost path analyses. The analyses confirmed the feasibility of creating a network of connections in the database within an area of 3.74 km² with undefined roads. Through the implementation of optimizations, the determination of evacuation routes in wildland areas was reduced to less than 1 s. Additionally, the possibility of the system operating for areas covering 40 km² was presented. The use of optimized vector data and database technology enabled the development of a comprehensive forest area management system, encompassing points of rescue units situated at significant distances from the area. This facilitated the establishment of flexible evacuation routes or rescue missions, particularly allowing for the establishment of multimodal routes using different means of transportation to reach the destination.