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

Guardado en:
Detalles Bibliográficos
Publicado en:ISPRS International Journal of Geo-Information vol. 14, no. 3 (2025), p. 110
Autor principal: Ilba, Mateusz
Publicado:
MDPI AG
Materias:
Acceso en línea:Citation/Abstract
Full Text + Graphics
Full Text - PDF
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Descripción
Resumen: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 km2 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 km2 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.
ISSN:2220-9964
DOI:10.3390/ijgi14030110
Fuente:Advanced Technologies & Aerospace Database