Team Simoy - PH Air Quality Index | Spatial Analysis and Time Series

Spatial Analysis and Time Series

The EO Dashboard has multiple global maps for air quality and greenhouse gases in GeoTIFF file format. Your challenge is to create a spatial analysis and time series plotting tool for EO Dashboard air quality and greenhouse gas GeoTIFF datasets.

Simoy - PH Air Quality Index

Summary

This data visualization project shows the Air Quality Index (AQI) for some locations in NCR, Region 3, Region 4A, Region 4B and Region 12 from open dataset of Environmental Management Bureau (EMB) Official Social Media Sites. This project aims to depict the AQI trend for some locations in a very understandable manner. This also tries to visualize the effect of recent issues/conditions (e.g. Covid 19) of my country to air quality.

How I Addressed This Challenge

This data visualization project shows the Air Quality Index (AQI) for some locations in NCR, Region 3, Region 4A, Region 4B and Region 12 from open dataset of Environmental Management Bureau (EMB) Official Social Media Sites. This project aims to depict the AQI trend for some locations in a very understandable manner. This also tries to visualize the effect of recent issues/conditions (e.g. Covid 19) of my country to air quality.


As a developing country, one of the untapped resources is data transformation due to several reasons. One of those is the ability to maximize the available digital technology especially in data visualization tools in analyzing internal data.


Data is indeed the new soil. Data when consolidated and analyzed will always give us remarkable insights which can be a tool for interpreting and understanding the underlying principles of some environmental issues. Through data democratization, the developer of Project Simoy aims to bridge data visualization and other relevant technology in utilizing these untapped open-source resources from environment specially climate change and resiliency datasets which can potentially unravel localized climate trends and insights to researchers, policy makers and regulators whose main aim is to combat the suppressing effects of climate change.

How I Developed This Project

From the social media posting of Environmental Management Bureau (PH), the developer is inspired to localize the EARTH OBSERVING DASHBOARD into PH Air Quality Index scenario.


AQI Daily Infographics - When the Taal Volcano erupted last January 2020, EMB continuously releasing daily AQI infographics in order to show the quality of air especially to those affected locations. They releasing two (2) infographics per day, Morning and Afternoon. Up to this day, they have been releasing these cool infographics in their official social media accounts and website.


These AQI Daily Infographics are being reprocessed and stored in to excel sheet and then visualize further using MS Power Bi.

See the Data Viz Link here: https://app.powerbi.com/view?r=eyJrIjoiYjFmODUzMDMtYjNlMS00NjY2LWJiZGYtNTJlYThhYmVlYzczIiwidCI6ImFhMWY3MmNiLTZhNzQtNGI5NC04MzVmLTU4ZmRjODRhYTFlOCIsImMiOjEwfQ%3D%3D&pageName=ReportSectionb72e0b5f3eef39b3d138


This data viz project depicts the AQI trend for some locations in a very understandable manner. This also tries to visualize the effect of recent issues/conditions (e.g. Covid 19) of my country to air quality.

How I Used Space Agency Data in This Project

We studied how NASA is presenting their data and localize it into PH Air Quality Index scenario. In such a way, we are developing an additional datasets from my country by which can be used by NASA as reference or additional to their massive datasets.

Earth Observing Dashboard Integration

In such a way, we are developing an additional datasets from my country by which can be used by NASA as reference or additional to their massive datasets.


Data Viz Link here: https://app.powerbi.com/view?r=eyJrIjoiYjFmODUzMDMtYjNlMS00NjY2LWJiZGYtNTJlYThhYmVlYzczIiwidCI6ImFhMWY3MmNiLTZhNzQtNGI5NC04MzVmLTU4ZmRjODRhYTFlOCIsImMiOjEwfQ%3D%3D&pageName=ReportSectionb72e0b5f3eef39b3d138


Data Viz Embed Code: <iframe width="600" height="373.5" src="https://app.powerbi.com/view?r=eyJrIjoiYjFmODUzMDMtYjNlMS00NjY2LWJiZGYtNTJlYThhYmVlYzczIiwidCI6ImFhMWY3MmNiLTZhNzQtNGI5NC04MzVmLTU4ZmRjODRhYTFlOCIsImMiOjEwfQ%3D%3D&pageName=ReportSectionb72e0b5f3eef39b3d138" frameborder="0" allowFullScreen="true"></iframe>

Data & Resources

AQI PM 10 Open Source Data:

https//www.facebook.com/DENREnviBureau

https://www.facebook.com/EMBRegion12


Published Document: 1-Air-Quality-1.8-National-Air-Quality-Status-Report-2008-2015.pdf (emb.gov.ph)


Software Tools Used

MS Office Applications (MS Excel, MS Powerpoint, MS PowerBI)


Music: Dayspring

Musician: Firefl!es

URL: https://www.youtube.com/watch?v=eoplw2Cc3xc&t=0s


Storage: https://1drv.ms/u/s!AtomsUsjBussi2UOlAYZ_fSp3ES_?e=cWv23x

Tags

#airquality #air quality #Philippines #ClimateChange #LocalOpenSourceData

Judging

This project has been submitted for consideration during the Judging process.