Urban Societal Behavior Patterns During COVID-19

The COVID-19 pandemic is currently bringing unprecedented impacts to every aspect of human life. Your challenge is to better understand societal trends in response to COVID-19 through the analysis of remote sensing data and products.

Variation of Urban Societal Behavior Parameters across Countries and over Time

Summary

As due to Covid-19 and lockdown, the generic urban societal behavior has changed initially rapidly and stabilized over time, which has a major economic impact across the world. This project tries to understand (through visualization) how multiple urban societal behavior parameters changes over time across countries by analyzing the parameters. This project also depicts how the average change of those parameters varies across countries OVER time. The data contains time frame between (February 2020 - 20th June 2021).This project deals with the Mobility data of EO-Dashboard as mentioned in the Project Page.

How I Addressed This Challenge

Software used: Tableau Public

Data Used:

  1. Mobility data (Covid-19 Google Community Mobility report) from dashboard as mentioned in the project resource page
  2. CO2 and NO2 data from EO Dashboard

Data Time Frame: February 2020 - 20th June 2021

Hardware: Mac book Pro

Coding: Have to code multiple new fields (hyper-parameters) as those are not present within the raw data.


Inspiration:

Covid-19 (and lockdown), has changed the human lifestyle and behavior pattern over time, across the globe. At the same time, due to lockdown, the public places are closed and commute has reduced drastically. I want to understand visually how the societal parameters has changed over time across the world over a period of time.


Approach:

I wanted to bring all the parameters (societal behavior parameters) under a single frame along with the hyper-parameters (the filters) to understand, how the change of hyper-parameters also changes the corresponding parameters.


Problem:

As Tableau public (which is a free software) does not allow to save my work locally and also I am unable to save the ACTUAL worksheets (and Codes). Once I close the software environment locally, all my work is gone.

At the last day, I had to re-do the everything again (Unfortunately).


Lesson-Learned:

Use licensed software and work as a team (for extra brain, hand and eye :-) )


Achievements:

I am glad to work with NASA, ESA, JAXA data/environment it was absolutely a pleasure in itself to talk to respective SMEs. I personally feel, it's an honor to work in this hackathon and I have learned lots of things (Both technical and soft skills)


Next Step for me: (Personal Goal)

I am going to develop multiple mockups/variations of visualizations to understand the pattern like, G7-Countries Vs Parameter Change, G20-Countries Vs Parameter Change, Different regions of the world Vs Parameter Change and how NO2 and CO2 concentration changes due to those change in parameters and will show as a story to understand the flow in totality.



Description

This project tries to understand (through visualization) how multiple urban societal behavior parameters changes over time across the globe. 

I have developed a live dashboard (using multiple worksheets) using Tableau which shows how the multiple urban societal parameters like 'Grocery and Pharmacy', 'Parks', 'Residential', 'Retail and Recreation', 'Transit Stations', 'Workplaces' varies from country to county and City to City. 

The dashboard has two sections. The upper section depicts the filter(s) for Country, City, Weekday/Weekend and the below section reflects the change in those urban societal variables over time axis based on the selection.

User can filter a particular Country and/or associated major city(cities) in combination (one Country at a time) and the filter function automatically will point the County/City on the map on the upper section of the dashboard.

At the same time, below section gets updated with change of parameter (multiple) values spread across time.


Note: Directly choosing country from the map also updates the parameter values.


I have also developed visualization which shows the average change of those parameters across countries OVER time. The data contains time frame from February 2020 till 20th June 2021 and once the timer starts, it shows the overall change of ALL parameter values across complete duration.

How I Developed This Project

Description:

I have developed a live dashboard (using multiple worksheets) using Tableau which shows how the multiple urban societal parameters like 'Grocery and Pharmacy', 'Parks', 'Residential', 'Retailand Recreation', 'Transit Stations', 'Workplaces' varies from country to county and City to City. 



How to navigate and functionality of the Dashboard:

The dashboard has two sections. The upper section depicts the filter for Country, City, Weekday/Weekend and the below section reflects those urban societal variables change over time axis.

User can filter a particular Country and/or associated major city(cities) in combination (one Country at a time) and the filter function automatically will point the County/City on the map on the upper section of the dashboard.

At the same time, below section will get updated with change of parameter (multiple) values spread across time.


Note: Directly choosing country from the map also updates the parameter values.


Another mockup/visualization:

I have also developed visualization which shows the average change of those parameters across countries OVER time. The data contains time frame from February 2020 till 20th June 2021 and once the timer starts, it shows the change of ALL parameter values across the complete time frame.

How I Used Space Agency Data in This Project

I have used the following data,



  1. Mobility data (Covid-19 Google Community Mobility report) from dashboard as mentioned in the project resource page
  2. CO2 and NO2 data from EO Dashboard (Worked on but could show at the dashboard as a final solution)
Project Demo

Following are the links of the live dashboards which are interactive in nature, and which contains multiple worksheets (equivalent to powerpoint site)



  1. https://public.tableau.com/app/profile/joydeep.ghatak8375/viz/CountryVsEconomicParameterChange-NasaHackathon/CountryVsEconomicParameterChange
  2. https://public.tableau.com/app/profile/joydeep.ghatak8375/viz/DynamicEconomicParameterChangeOverTime-NasaHackathon/DynamicEconomicParameterChange
Earth Observing Dashboard Integration

The following are my personal Tableau Public server location, which contains the following links (Live dashboard) and these can surely be used as a link to EODashboard for visibility.



  1. https://public.tableau.com/app/profile/joydeep.ghatak8375/viz/CountryVsEconomicParameterChange-NasaHackathon/CountryVsEconomicParameterChange
  2. https://public.tableau.com/app/profile/joydeep.ghatak8375/viz/DynamicEconomicParameterChangeOverTime-NasaHackathon/DynamicEconomicParameterChange
Data & Resources

Mobility data (Covid-19 Google Community Mobility report) from dashboard as mentioned in the project resource page

Tags

#economic impact #Tableau #tableau #visualization #Dashboard

Judging

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