FOSS4G-Asia 2023 Seoul

The identification of critical infrastructure facilities is critical for climate and disaster risk assessments that forms part of a resilient land use plan. This study utilized the application of a geo-analytics platform using free and open source software for geospatial analysis, namely Quantum GIS (QGIS) in generating multi-hazard exposure maps of critical infrastructure facilities in Taguig City, Philippines. The study was conducted as a necessity for planners looking for an alternative viable solution for resilient land use planning using non-proprietary Geographic Information Systems (GIS).
The study developed a workflow for geospatial analysis with direct application in hazard exposure mapping for floods, active fault lines, and waterway easements. A review of open data portals was first performed which discussed the limitations and opportunities of existing official data repositories. A supplementary online survey was likewise conducted with local planners to understand their knowledge, skills, attitudes, and perceptions to GIS and its application to disaster risk assessment. The survey responses from local planning and development offices showed that they are open to improving institutional capacity and professional capabilities in GIS, particularly in QGIS. A comparative review of different spatial decision support systems for climate and disaster risk assessment was also carried out that revealed important ways forward in further developing open tools for disaster risk assessment. The case study was able to identify the multi-hazards exposure profile of Taguig City using open data while using the free and open-source software QGIS. The data used were accessed from online data portals that have free public access, and data formats useful for independent study.
The online survey also provided invaluable insights into the knowledge, skills, awareness, perceptions, and preferences of the respondents with regards to GIS-related topics. The results of the survey showed that there is a need for GIS training programs and in particular an expressed openness to learning QGIS. Also, the review of existing spatial decision support systems available in online and standalone platforms showcase the limitations and opportunities of adapting graphical models to automate the process of disaster risk assessments.
The study was able to demonstrate a viable alternative geo-analytics platform using free and open-source software for geographic information systems and open data. Results of the comparative review of existing data portals and spatial decision support systems helped in the development of the proposed open resilience framework. Said framework was able to produce the required exposure maps of critical infrastructure in Taguig City.

Identifying the current ecosystem extent and the underlying economic activities and opportunities therein requires spatial analysis utilizing the most recent data. This is made possible with the use of Earth Observation (EO) data retrieved from multi-spectral satellite imagery openly available to the public domain through the Copernicus and Landsat program of the European Space Agency (ESA) and the National Aeronautics and Space Administration (NASA) respectively. EO data has several advantages. It is supported by national governments, and inter-governmental agencies maintaining access to the data publicly available. It is free and open for use by researchers, governments, and by the commercial sector. The project areas are three municipalities in the island of Mindoro, Region IV-B MIMAROPA, Philippines. Specifically in the province of Occidental Mindoro. The three municipalities are the provincial capital, the Municipality of Mamburao, and the other two are the Municipalities of Rizal and Sablayan. The World Wide Fund for Nature – Philippines (WWF) commissioned the Community Environmental Economic and Social Accounting Matrix (CEESAM) study for these three municipalities in support of its expanded sustainable livelihood project for Tuna production and fisherfolk. This study’s component for spatial analysis is in support of the CEESAM for these municipalities. In summary, the study produced a land cover classification map achieving an average overall accuracy of 80% computed for all three municipalities. This is a good result since the accepted practice of achieving an overall accuracy within that 80% range is commendable. Processing the land cover classification was complemented with in situ observations using aerial imagery from light commercial drones and from ground based mobile imagery through QFIELD. Referencing the different imagery from earth observation data to aerial drone imagery, and ground based field observations led to the identification of spatial challenges and opportunities per municipality.
The study presented a workflow with a use-case for utilizing earth observation data using the latest and available update satellite imagery, complemented by in situ observations from aerial drone imagery and mobile field mapping app QFIELD. Also, the municipalities included in the study have common issues with regards to intermittent power interruption. Disruption in this vital utility slows down the production of any processing or cold chain facilities. Agricultural production primarily focus on annual crops for staples such as rice and corn. Mono cropping dominates the agricultural landscape with pockets of perennial crops which have room to integrate with traditional agriculture. Some areas have unfinished or unpaved farm to market roads. This results to inefficient logistics for the farmers in taking their produce to market. This could also add additional cost for them. Further, there is still a need for improving on post-harvest and post-catch support for farmers and fisherfolk with regards to facilities and market linkage facilitation.