This project consisted on the development of an interative and didatic tool
We know that many tools have been created since COVID-19 appareance, however, few of them have provided integrated environmental and social-economic data. Ours, although, provided a simple and interative tool with a reliable data integration that can be used by any person.
Of course, the biggest challenge was to really understand what were these key-factors and how to integrate them in a visual tool. Starting at pollution considerations we have related a HUGE database in real-time to create our dashboards, thinking about a score system we showed up with an innovative solution that can provide pieces of information to be used by public administration to allocate investments or funds correctly in the pandemic fight.
The idea of innovation was what brought us to this challenge. From an emerging culture we know how many environmental factors influences in the pandemic crisis. We have never found a tool that could bring data about how in danger we are in our country related to socioeconomic factos.
What have really been the apple of our eyes was the possibility of creation of a high-ended solution with integrations never thought before. We all know that public administration has a high influence in the number of cases, we all know that poverty influences the virus proliferation, we all have an idea that pollution in addition with weather factors bring us a bad influence, but how can we prove that these data are corelated?
Once we had all the human resources required for the challenge we have started to gather data from different reliable fonts such as NASA databases, United Nations, World Health Organization and World Bank, while part of the team was leaded to front and back-ending development, some of us have focused on data integration and analysis.
Using a mathematical method we have studied the relations between the factors mentioned above with the number of COVID-19 cases, this was a very hard process, some of these tasks we needed to do manually, what made even harder to provide the real-time code afterwards. After that we have used Python to create an A.I. that analyses the multiple variables and shows up with relations among them.
Of course, all these correlations were mathematic and statistic based, the technics used are scienfic proven and equivalent with other studies (we can mention a study provided by Hardvard for example), we needed a visual solution that could make our tool useful for any person, that's when we decided to create our own score.
We have had many challenges during the development, such as:
Scorevid was our solution, this is a KPI that relates 4 enviromental and socioeconomic variables:
These variables evidences the relations between the number of cases globally, this is a proposed model which ranges from 0 to 19 (where 0 is bad and 19 is good) that can help global administration to deal with the situation with investments and so on.
We have uploaded a video on YouTube to explain the solution breefly:
https://data.nasa.gov/browse?q=brazil&sortBy=relevance
https://coronavirus.jhu.edu/map.html
https://www.imf.org/external/pubs/ft/weo/2019/02/weodata/index.aspx
https://population.un.org/wpp/Download/Standard/Population/
https://sedac.ciesin.columbia.edu/data/set/gpw-v4-population-density-rev11
https://www.undp.org/content/undp/en/home.html
https://www.transparency.org/en/cpi/2019/results