Long-Term Effects of COVID-19, and Its Impact on Business, Employees, and CO2 Emissions, a Study Using Arc-GIS Survey 123 and Arc-GIS Mapping
Abstract
:1. Introduction
2. Literature Review
2.1. Environmental Impact
2.2. Social Impacts
3. Methodology
3.1. CO2 Data Collection
- Step 1.
- The 2019 and 2020 daily ground transportation data (China, USA, India, EU, UK, and Japan) were exported from the carbonmonitor.org website as a CSV file and then converted to an Excel spreadsheet (.xls).
- Step 2.
- The daily data for several countries (2190 records per year) from 2019 to 2020 (total of 4380 records) were combined in Microsoft Excel as monthly data, but this second attempt to import the data into ArcGIS Online failed because the dataset was still too large.
- Step 3.
- The carbon monitoring CO2 data were then manipulated and formatted to monthly consolidate data into a manageable size (24 records) and format in Microsoft Excel for 2019 and 2020. This data were then successfully imported into ArcGIS Online on a world map as two separate layers, 2019 and 2020. Attempts were made to further analyze these data on the world map, but it was discovered that ArcGIS Online has limited data analysis and management functionality compared to ArcGIS pro.
- Step 4.
- The next step was to import these data into the ArcGIS Pro desktop program. Several attempts to import the consolidated data from Excel to ArcGIS pro failed to recognize the country names and dates. Through trial and error, it was discovered that the projects or Layers created and saved in ArcGIS online are visible and importable as layers in ArcGIS Pro. This method was utilized to bring the data compiled in excel into ArcGIS Pro. The ArcGIS Pro program now had the 2019 and 2020 CO2 data by specific country, which were then used for further analysis.
3.2. Social Sustainability Data Collection
- Positive impacts of COVID-19 on the workforce:
- 1.1.1.
- Reduction in air emission from lack of commute to work.
- 1.1.2.
- Time savings.
- 1.1.3.
- Mental health improvement.
- 1.1.4.
- Job Experience improvement.
- Negative Impacts of COVID-19 on the workforce:
- 1.2.1.
- Costs associated with updating systems for how employees access information from home.
- 1.2.2.
- Higher turnover for employees because employees can find work anywhere in the world
- 1.2.3.
- Work–life balance struggles
- The first group was ERA Environmental Consulting, Inc. employees and client base; an e-mail blast was sent to over 21,000 qualified potential participants. At the start of the survey launch, 14th February 2022, only about 80 respondents completed the survey.
- The second group was member companies of the Suppliers Partnership for Environment (SP) and the Commission for Environmental Cooperation (CEC). The e-mail blast results within two weeks of the survey start date were less than 150 survey respondents.
- A change in strategy was made to reach a broader target audience around 27th February 2022, via social media such as Facebook, LinkedIn, Twitter, and Instagram. Within a day of addition, 150 responses were collected.
- A new strategy to acquire more respondents increased target audience participation. The survey target audience was offered a draw for 50 gift cards of USD 25, which could go to the winner or the charity of their choice.
- A final attempt to increase respondents was made using ERA’s software portal login page, turned into a bulletin board, to notify ERA clients about the survey. We assumed that, due to heightened security around e-mails with links, ERA clients’ results were affected due to a lack of trust in the original e-mail.
- 6.
- Data collected from the above survey were used to build the mathematical model presented in the results section. The mathematical model was built using logical deductions such as percent of participants who desire to continue working from home and the distance they would typically travel if they had to commute monthly to work. Considering their modes of transportation and assuming tailpipe emissions factor provided by EPA [20] mathematical model was built to project the amount of CO2 that could be saved if a given percentage of the workforce continues the work-from-home model.
4. Results
4.1. Data Analysis-ArcGIS
4.2. Daily CO2 Emissions
4.3. Data Analysis-ArcGIS Survey 123 Results
4.4. Transportation Data Analysis
- TM = Total Commute Distance for all respondents (Miles)
- AY = Number of people that answered yes to (Question 1: At any time between the start of thepandemic and now have you ever worked from home)
- MAM = Monthly average miles per person’s commute
- MAM = TM/AY
- AMR = 404 g/miles EPA (CO2) average emission rate from tailpipe grams per one mile traveled
- CR = 0.002204620 lbs./gram
- ES = lbs./month CO2 emissions saved per month per person working from home
- ES = MAM × AMR × CRES = 87.48 miles × 404 gram/miles × 0.00220462 lbs/gram
= 77.92 lbs/Month CO2 Emissons saved per month per person
- P = 332,000,000 population of USA in 2021 (Google, 2022) [19]
- %PW = 64.8% population of USA of working-age
- %SPY = 45% of survey participants said yes to continue work from home
- %AEP = 56.19 % of survey participants with advanced degree of Bachelor, Master, or Doctorate Degrees
- CF = 0.000446429 (metric tons)/lbs.
- TES = Total metric tons/month CO2 emissions saved based on number of people working from home
- ES = lbs./Month CO2 emissions saved per month per person working from home
- NWFH = Potential number of US residents wanting to continue working from home
- NWFH = P × %PW × %SPY × %AEPNWFH = 54,398,213 People
- TES = NWFH × ES × CFTES = 1,892,069 Metric tons/Month CO2 Emissons Saved per month USA Only
4.5. Social Data Analysis
5. Discussion
ArcGIS Data Discussions
6. Conclusions
Author Contributions
Funding
Institutional Review Board Statement
Informed Consent Statement
Data Availability Statement
Acknowledgments
Conflicts of Interest
References
- World Health Organization. Available online: https://www.who.int/ (accessed on 20 April 2022).
- Suresh, M.; Gopakumar, K. Multi-grade fuzzy assessment framework for software professionals in work-from-home mode during and post-COVID-19 era. Future Bus. J. 2021, 7, 10. [Google Scholar] [CrossRef]
- Liu, Z.; Ciais, P.; Deng, Z.; Lei, R.; Davis, S.J.; Feng, S.; Zheng, B.; Cui, D.; Dou, X.; Zhu, B.; et al. Near-real-time monitoring of Global CO2 emissions reveals the effects of the covid-19 pandemic. Nat. Commun. 2020, 11, 5172. Available online: https://www.nature.com/articles/s41467-020-18922-7 (accessed on 2 May 2022). [CrossRef] [PubMed]
- In Proceedings of the Climate Change Conference COP26, Glasgow, 2021. Available online: https://ukcop26.org/ (accessed on 20 April 2022).
- Schlosser, F.; Maier, B.F.; Jack, O.; Hinrichs, D.; Zachariae, A.; Brockmann, D. COVID-19 lockdown induces disease-mitigating structural changes in Mobility Networks. Proc. Natl. Acad. Sci. USA 2020, 117, 32883–32890. [Google Scholar] [CrossRef] [PubMed]
- Chen, L.-W.A.; Chien, L.-C.; Li, Y.; Lin, G. Nonuniform impacts of COVID-19 lockdown on air quality over the United States. Sci. Total Environ. 2020, 745, 141105. Available online: https://www.sciencedirect.com/science/article/abs/pii/S0048969720346349 (accessed on 28 April 2022). [CrossRef] [PubMed]
- Andreoni, V. Estimating the European CO2 emissions change due to COVID-19 restrictions. Sci. Total Environ. 2021, 769, 145115. Available online: https://www.sciencedirect.com/science/article/abs/pii/S0048969721001819 (accessed on 21 April 2022). [CrossRef] [PubMed]
- Mashayekhi, R.; Pavlovic, R.; Racine, J.; Moran, M.D.; Manseau, P.M.; Duhamel, A.; Katal, A.; Miville, J.; Niemi, D.; Peng, S.J.; et al. Isolating the impact of covid-19 lockdown measures on Urban Air Quality in Canada. Air Qual. Atmos. Health 2021, 14, 1549–1570. [Google Scholar] [CrossRef] [PubMed]
- Cicala, S.; Holland, S.P.; Mansur, E.T.; Muller, N.Z.; Yates, A.J. Expected health effects of reduced air pollution from COVID-19 social distancing. Atmosphere 2021, 12, 951. [Google Scholar] [CrossRef]
- carbonmonitor.org. 2021. Available online: www.carbonmonitor.org (accessed on 19 May 2022).
- Does Tourism Really Cause Stress? A Natural Experiment Utilizing ArcGIS Survey123. Taylor & Francis. Available online: https://www.tandfonline.com/doi/abs/10.1080/13683500.2019.1702001 (accessed on 8 October 2022).
- Vaziri, H.; Casper, W.J.; Wayne, J.H.; Matthews, R.A. Changes to the work–family interface during the COVID-19 pandemic: Examining predictors and implications using latent transition analysis. J. Appl. Psychol. 2020, 105, 1073. [Google Scholar] [CrossRef] [PubMed]
- Garrote Sanchez, D.; Gomez Parra, N.; Ozden, C.; Rijkers, B.; Viollaz, M.; Winkler, H. Who on Earth can work from home? World Bank Res. Obs. 2021, 36, 67–100. [Google Scholar] [CrossRef]
- Alifuddin, N.A.; Ibrahim, D. Studies on the impact of work from home during COVID-19 pandemic: A systematic literature review. J. Komun. Borneo (JKoB) 2021, 9, 60–80. [Google Scholar] [CrossRef]
- Karatayev, V.A.; Anand, M.; Bauch, C.T. Local lockdowns outperform global lockdown on the far side of the COVID-19 epidemic curve. Proc. Natl. Acad. Sci. USA 2020, 117, 24575–24580. [Google Scholar] [CrossRef] [PubMed]
- Ritchie, H.; Roser, M.; Rosado, P. CO2 and greenhouse gas emissions. Our World in Data. 2020. Available online: https://ourworldindata.org/co2-emissions?utm_source=coast%20reporter&utm_campaign=coast%20reporter%3A%20outbound&utm_medium=referral (accessed on 19 May 2022).
- Rume, T.; Islam, S.M.D.-U. Environmental effects of COVID-19 pandemic and potential strategies of Sustainability. In Heliyon; 2020. Available online: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7498239/ (accessed on 19 May 2022).
- Bai, B.; Gopalan, N.; Beutell, N.; Ren, F. Impact of Absolute and Relative Commute Time on Work–Family Conflict: Work Schedule Control, Child Care Hours, and Life Satisfaction. J. Fam. Econ. Issues 2021, 42, 586–600. [Google Scholar] [CrossRef] [PubMed]
- World Development Indicators|Databank—World Bank. Available online: https://databank.worldbank.org/reports.aspx?source=2&series=SL.TLF.ACTI.ZS&country (accessed on 27 August 2022).
- EPA. Greenhouse Gas Emissions from a Typical Passenger Vehicle. 2022. Available online: https://www.epa.gov/greenvehicles/greenhouse-gas-emissions-typical-passenger-vehicle (accessed on 27 August 2022).
Sum of Q7. Enter Your Monthly Commute Distance | Miles |
---|---|
199,163.2 (km) | 123,754.24 |
153,877.41 (miles) | 153,877.41 |
Grand Total | 172,512.25 |
# of Survey Respondents | 1972 |
Monthly miles average per person saved | 87.48 |
Q20. What Is Your Highest Level of Education? | Q18. What Is Your Age RANGE? | ||||||
---|---|---|---|---|---|---|---|
Age Groups | 18 to 29 Years | 30 to 39 Years | 40 to 49 Years | 50 to 59 Years | 60 to 69 Years | 70 Years and Older | Grand Total |
Doctorate degree | 0.00% | 1.54% | 0.53% | 0.47% | 0.36% | 0.18% | 3.08% |
Master’s degree | 2.67% | 6.52% | 2.67% | 2.07% | 1.24% | 0.30% | 15.47% |
Bachelor’s Degree | 7.47% | 18.49% | 7.35% | 2.61% | 1.36% | 0.36% | 37.64% |
Certificate or Associate’s Degree | 2.55% | 5.04% | 3.02% | 0.95% | 0.30% | 0.24% | 12.09% |
Some college no degree | 4.09% | 13.28% | 1.24% | 0.95% | 0.47% | 0.00% | 20.04% |
Some graduate school no degree | 0.95% | 1.66% | 1.24% | 0.59% | 0.36% | 0.12% | 4.92% |
High school diploma or equivale | 2.07% | 2.61% | 0.83% | 0.06% | 0.18% | 0.00% | 5.75% |
Did not complete high school diploma | 0.59% | 0.30% | 0.06% | 0.06% | 0.00% | 0.00% | 1.01% |
Grand Total | 20.39% | 49.44% | 16.95% | 7.77% | 4.27% | 1.19% | 100.00% |
Country Name | Population in 2021 | Percent Population Working Age (16–65) in 2021 (~65%) | Percent Survey Respondents Interested to Continue Work from Home after COVID-19 (~45%) | Percent Survey Respondents with Advanced Education Interested to Continue Work from Home after COVID-19 (~56%) | Monthly Potential tons [Imperial] of CO2 Emission Saving If Predicted Population Continues Working-From-Home Model | Annual Potential tons [Imperial] of CO2 Emission Saving If Predicted Population Continues Working-From-Home Model |
---|---|---|---|---|---|---|
World | 7,874,000,000 | 5,102,352,000 | 2,296,058,400 | 1,290,155,215 | 44,873,950 | 538,487,394 |
China | 1,444,000,000 | 935,712,000 | 421,070,400 | 236,599,458 | 8,229,360 | 98,752,324 |
USA | 332,000,000 | 215,136,000 | 96,811,200 | 54,398,213 | 1,892,069 | 22,704,828 |
India | 1,393,000,000 | 902,664,000 | 406,198,800 | 228,243,106 | 7,938,711 | 95,264,534 |
EU & UK | 515,000,000 | 333,720,000 | 150,174,000 | 84,382,771 | 2,934,987 | 35,219,838 |
Japan | 126,000,000 | 81,648,000 | 36,741,600 | 20,645,105 | 718,074 | 8,616,893 |
Name | Annual Potential tons [Imperial] of CO2 Emission Saving Working Population Continue Working-From-Home Model | CO2 Emissions from Ground Transportation in 2021 (Carbon Monitor.Org) | Estimated Annual Percent CO2 Emissions Saving from Ground Transportation in 2021 | Total CO2 Emissions in 2021 (Google, 2022) | Estimated overall Annual Percent CO2 Emissions Saving from in 2021 Area |
---|---|---|---|---|---|
World | 538,487,394 | 6,306,933,800 | 8.54% | 36,300,000,000 | 1.48% |
China | 98,752,324 | 907,484,070 | 10.88% | 11,900,000,000 | 0.83% |
USA | 22,704,828 | 1,592,589,020 | 1.43% | 4,460,000,000 | 0.51% |
India | 95,264,534 | 268,914,040 | 35.43% | 2,880,000,000 | 3.31% |
EU & UK | 35,219,838 | 885,175,110 | 3.98% | 2,824,500,000 | 1.25% |
Japan | 8,616,893 | 172,089,595 | 5.01% | 1,149,000,000 | 0.75% |
Publisher’s Note: MDPI stays neutral with regard to jurisdictional claims in published maps and institutional affiliations. |
© 2022 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Gary, V.; Sarah, S.; Deborah, N. Long-Term Effects of COVID-19, and Its Impact on Business, Employees, and CO2 Emissions, a Study Using Arc-GIS Survey 123 and Arc-GIS Mapping. Sustainability 2022, 14, 13689. https://doi.org/10.3390/su142013689
Gary V, Sarah S, Deborah N. Long-Term Effects of COVID-19, and Its Impact on Business, Employees, and CO2 Emissions, a Study Using Arc-GIS Survey 123 and Arc-GIS Mapping. Sustainability. 2022; 14(20):13689. https://doi.org/10.3390/su142013689
Chicago/Turabian StyleGary, Vegh, Sajedi Sarah, and Naybor Deborah. 2022. "Long-Term Effects of COVID-19, and Its Impact on Business, Employees, and CO2 Emissions, a Study Using Arc-GIS Survey 123 and Arc-GIS Mapping" Sustainability 14, no. 20: 13689. https://doi.org/10.3390/su142013689
APA StyleGary, V., Sarah, S., & Deborah, N. (2022). Long-Term Effects of COVID-19, and Its Impact on Business, Employees, and CO2 Emissions, a Study Using Arc-GIS Survey 123 and Arc-GIS Mapping. Sustainability, 14(20), 13689. https://doi.org/10.3390/su142013689