Rule based ETL (RETL) approach for GEO spatial data warehouse

This paper presents the use of Service Oriented Architecture (SOA) for integrating multi source heterogeneous geospatial data in order to facilitate geospatial data warehouse. In this study, Real Based ETL (RETL) concept is adapted in order to extract, transform and load data from a variety of heterogeneous data sources. ETL will transform data to schematic format and loading data into the Geo spatial data warehouse.By using a rule-based technique, the distribution of parallel ETL pipeline will enhance and perform more efficient in large scale of data and overcome data bottleneck and performance overhead. This can ease the disaster management and enables planners to monitor disaster emergency response in an efficient manner

Volunteered geographic information in natural hazard analysis : a systematic literature review of current approaches with a focus on preparedness and mitigation

With the rise of new technologies, citizens can contribute to scientific research via Web 2.0 applications for collecting and distributing geospatial data. Integrating local knowledge, personal experience and up-to-date geoinformation indicates a promising approach for the theoretical framework and the methods of natural hazard analysis. Our systematic literature review aims at identifying current research and directions for future research in terms of Volunteered Geographic Information (VGI) within natural hazard analysis. Focusing on both the preparedness and mitigation phase results in eleven articles from two literature databases. A qualitative analysis for in-depth information extraction reveals auspicious approaches regarding community engagement and data fusion, but also important research gaps. Mainly based in Europe and North America, the analysed studies deal primarily with floods and forest fires, applying geodata collected by trained citizens who are improving their knowledge and making their own interpretations. Yet, there is still a lack of common scientific terms and concepts. Future research can use these findings for the adaptation of scientific models of natural hazard analysis in order to enable the fusion of data from technical sensors and VGI. The development of such general methods shall contribute to establishing the user integration into various contexts, such as natural hazard analysis

Digitalization and Spatial Documentation of Post-Earthquake Temporary Housing in Central Italy: An Integrated Geomatic Approach Involving UAV and a GIS-Based System

Geoinformation and aerial data collection are essential during post-earthquake emergency response. This research focuses on the long-lasting spatial impacts of temporary solutions, which have persisted in regions of Central Italy affected by catastrophic seismic events over the past 25 years, significantly and permanently altering their landscapes. The paper analyses the role of geomatic and photogrammetric tools in documenting the emergency process and projects in post-disaster phases. An Atlas of Temporary Architectures is proposed, which defines a common semantic and geometric codification for mapping temporary housing from territorial to urban and building scales. The paper presents an implementation of attribute specification in existing official cartographic data, including geometric entities in a 3D GIS data model platform for documenting and digitalising these provisional contexts. To achieve this platform, UAV point clouds are integrated with non-metric data to ensure a complete description in a multiscalar approach. Accurate topographic modifications can be captured by extracting very high-resolution orthophotos and elevation models (DSM and DTM). The results have been validated in Visso (Macerata), a small historical mountain village in Central Italy which was heavily damaged by the seismic events of 2016/2017. The integrated approach overcomes the existing gaps and emphasizes the importance of managing heterogeneous geospatial emergency data for classification purposes. It also highlights the need to enhance an interoperable knowledge base method for post-disaster temporary responses. By combining geomatic tools with architectural studies, these visualization techniques can support national and local organizations responsible for post-earthquake management through a 3D modelling method to aid future transformations or interventions following other natural disasters