-blueviolet.svg){kind=icon}
Kona Connect’s legal team, together with students and expert volunteers from around the world, are developing a tool to connect people in need to the organisations best equipped to help them. This tool which is accessible 24/7 through any device, will automatically guide its users to the help they need, whilst simultaneously reducing aid agencies’ staggering workloads, freeing up time to help more individuals.
- Problem Statement
- Mission
- Solution
- The web app
- For developers
- Repository structure
- Cloud deployment
- The database
- App translation
- UX/UI
- Troubleshooting
- Future Work
- License
- Authors
- Acknowledgments
The 17 Sustainable Development Goals (SDGs) are the world’s shared plan that includes ending extreme poverty, reducing inequalities, and protecting the planet. Achieving the Goals by 2030 will require a lot of effort, determination to learn about what works, and agility to adapt to new information and changing trends. Initiatives that generate impact and advance the SDG commitment to “leave no one behind,” should be backed by evidence, practical commitments, and action - something that doesn't happen right now.
Access to tailored and trustworthy information is essential for individuals in precarious (and often life-threatening) situations. However, it is easy to get lost in a bureaucratic maze amongst the numerous support institutions that exist. Databases containing information of aid organisations already exist, but the information tends to be incomplete and fails to describe the services provided.
The urgency to solve this problem is reflected by the increase of people living in precarious situations. A main factor of this increase is statelessness. A stateless person is someone who is "not considered as a national by any state under the operation of its law" 1. UNHCR estimates that statelesness affects millions of people worldwide, and at least 700.000 are in West and Central Africa 2. Being stateless is just one of the many reasons that lead people to be in vulnerable situations, rendering it of high importance the provision of a tool that eases peoples' search for help.
Our mission is to:
- Develop a trustworthy and unified NGO database.
- Empower people to know their human rights.
- Facilitate access to NGO information to fulfill user's needs using intelligent technologies, i.e. Dots.
Facilitating the search for assistance and support can be done by empowering people to know what their human rights are, where to look for reliable help, what to expect from aid services, and how to contact the right organisations.
6 weeks ago we did brainstorming sessions to define how we were going to solve the stated Dots problem, and how we could use the information to satisfy our stakeholders' needs. The solution was provided by Kona Connect by means of the platform "Dots.", a web app used by people in vulnerable situations to search for help. To do this, Kona Connect's team has identified and classified the social organisations. In order to provide accurate information for the users, we have improved the database by including a classification of the NGOs based on their target user, location and contact information (coordinates, address, email, phone number, opening hours, web site, social media, etc.)
The classification of the NGOs target users is based on the 17 United Nations Sustainable Development Goals (SDG). The SDGs are a collection of goals carefully designed by the UN to create a better planet for a better future 3. By means of these goals we not only achieve a meaninful classification of the organisations, but also we are able to trace the impact created by Dots.
The main goal of the tool is to connect people in need to the right organisations as quickly as easily as possible. For this, our solutions provides two main options:
- A quick quiz: By answering a few questions, users will be guided to the organisation(s) most likely to be able to help them and their situation.
- The list of all organisations with filters: By selecting the filters that apply to their situation, the user will reach the NGOs that provide the required help.
To measure the impact of our app we have to define, evaluate and quantify impact (brainstorming and inspiration ideas). The Credit Suisse Impact Management Project Framework was selected to define and evaluate the likely impact of Dots across five dimensions. We will explain how each classification contributes to the definition of Dots impact. The defined impact has been aligned to the 2030 SDG targets.
In the first stage, our solution is focused on providing help for the people located in Senegal. Therefore, the web app is available in English and French, and has a framework which allows easy translation to any regional language. Moreover, thanks to the design of our UX/UI experts, most interface options are coupled with an icon to make the app more accessible and intuitive.
Dots web app is a responsive website so it can be used from any device (laptop, phone, tablet). Our website is also a Progressive Web App (PWA), so the user can save our website on their phone and have our launcher icon on their home screen. They will be then able to open our website like a mobile app. The decision of choosing this technology was supported by the advantages that it has compared to a native app:
- Can be used anonymously: If the user opens Dots on an incognito window, the visit won't leave any 'trace'. We are aware that some of the users may be in a vulnerable situation and may not want to take the risk to leave a browser history or mobile app on their phone.
- Better discoverability: Our website could be found through search engines and we believe our users will be searching for information through a search engine rather than an app store.
- Updates are done automatically: All new features and bug fixes are available without any manual action required.
- Sharable: The user could easily share a link with a specific URL (example: list of organisations in the results page of the quiz).
- Low on data: PWAs are smaller than mobile apps, and they also require less bandwidth than traditional mobile apps 4.
Other resources: MDN
You can now use it here: https://dots.azureedge.net/
The app has the following pages:
- Home: This is the app home page. From here the user has the option to use the search assistant or to view the list of organisations.
- Search assistant (quiz): This page guides the user to find the right NGO by means of a set of questions.
- List of organisations: This page presents the complete list of NGOs and allows the user to define the filters.
- I am an NGO: This is the contact form for the NGO to contact Kona Connect. In future development it could be linked to the database.
- About us: This page presents the authors of the Dots. app.
- Privacy policy: This page contains the web app's privacy policy.
If you are a developer you need to know this.
Frontent:
- React - Web Framework
- NodeJs - Developer Server Environment
- Tailwindcss - CSS Framework
Backend:
- Python 3.8
- Pandas
- SQLAlchemy - For future developments
- Postgres - For future developments
- Progressive web app
- Runs in all major browsers
- Has a mobile-first responsive design
- Display information sent by the backend with the NGOs information and the United Nations Sustainable Development Goals
Find the instructions on how to run it here.
- Developped using Python 3.8
- Processes database using pandas and SQL
Find the instructions on how to run it here.
-
backend: In this directory you will find all the files related to the backend.
-
frontend: In this directory you will find all the files related to the frontend.
-
UX/UI_docs.md: UX/UI documentation.
-
LICENSE: File containing the license information.
The frontend and backend are hosted on Azure. The frontend uses Azure storage containers with a CDN in front. The backend uses App Service to run the Python code.
Specific deployment commands can be found in the frontend and backend directories.
To deploy the web app Azure CLI would need to be installed and correctly set up. Find out more here.
Databases containing information of aid organisations already exist, but the information tends to be incomplete and doesn't describe the services provided. For this reason we decided to create our own and to be able to ask the user about it.
The database information can be found in /backend/data/csv/data. This file contains all the NGO information in a human readable format. For each NGO the information collected is: NGO name, objective, services, can the NGO be contacted by individuals, phone_number, email, website, address, region, latitude, longitude, opening hours, hotline, facebook, linkedin, twitter, youtube, instagram, tiktok, flicker, sound_cloud, and other in case they have another social media account.
The organisations services are categorised in the database according to the SDG and targets that they contribute to. This allows us not only to provide a meaninful grouping of NGOs, but also to trace the impact of the app. In order to be more accurate when recommending NGOs to the user, an age and gender classification was added. This allows the app to recommend specific NGOs directly to the group of people they are able to help.
To make the database more machine readable, it was processed and divided into the following datasets:
-
age and gender: In this dataset the organisations are categorized in a machine readable format according to the age and gender of the people to whom they offer their help. In the following table you can find the categories assigned to the NGOs. This classification will help Dots to answer "who is going to benefit from the service impact".
-
We also have a separate age and gender classification files to enable the user to filter the dataset using these fields separately.
Categories Options gender male, female, other age baby, child, youth, adult -
region: To provide as much information as possible to the user, the database also contains the specific region where each NGO is located. Find below the available options:
Categories Options location dakar, saint_louis, louga, thies, diourbel, mattam, fatick, kaolack, kaffrine, tamabacounda, kedougou, kolda, sedhiou, ziguinohor
This classification will help Dots to answer "what is the region where the impact is created".
- SDG subcategory: One of the strengths of our database is that each NGO is linked to the Sustainable Development Goals (SDG) subcategories. This allow us to filter the database according to the user specific needs, allowing them to find the help they need in a shorter time and more effectively. This classification was developed taking into consideration that it is not always clear what are the services provided by the NGOs.
Categories Options sdg 1-40
This classification will help Dots to answer "what are the services whoses impact is going to be monitored by Dots".
This app is just as powerful as the information it contains, thefore it is very important to increase and enrich the database. For now, to add a NGO to the database one would need to add the information manually to the corresponding .csv files. The goal is that in the future the information will be stored in a SQL database and the addition of new NGOs will be semi-automated through the NGO-application page. Read more about future develompments in the section Future Work.
Using the APIs that provide information to the front end and the migration to SQL:
The SQL database creation was developed in parallel to the creation of the CSV classification tables and API connections between CSV file and front end. We decided to do this because we used an shared Excel document to create classification tables, standardise the NGOs information provided, and create questions and answers of the quiz.
We wanted to avoid using CSV files in the future, therefore the CSV files are migrated into database. As a further step we would like to connect the front end directly to the database, and just have the CSV for an initial run.
We have written down all the API end points that can access this database such as getting organisation information and quiz information. The list of APIs includes the explanation of usage.
In the future, we suggest having an admin portal to access the SQL database. In the admin portal an authentication system should be included to validate who is the user managing the database information. A tool that generates access tokens for API authorization scenarios that limit the access to the database is OAuth.
This same logic could be applied to the organisation information in our database by providing editing access to each NGO. The organisations can submit their data through the "organisation application form" and the data will be sent to the database portal at the same time as it will send an alert to the Dots team by Email or other notification system. The Dots team should have the capacity to accept or discard the submitted organisation information. In case the information is not approved, Dots should be able to answer the notification mail to the NGO and get back to the organisation. The organisation should be provided with an access to edit or delete its information.
Currently the app is available in English and French, but it has been specially developped so that it can be easily translated to any language. The tranlation files are handled by the front-end and can be found in /frontend/public/locales/.
For more information about the translation library used on Dots, please have a look at the frontend documentation.
To know and emphathise with the user was one of our main priorities when developing the app. Therefore, our UX/UI team has done wonderful job researching information to understand the user needs, frustrations and pain points. This information, combined with the feedback obtained from interviews with potential users, helped us to design the different aspects of the app such as colours, icons and wording. To find more information about the design process and user research check the UX/UI_docs
If you find any error or weird behaviour when using Dots, please open an issue and we will try to address it ass soon as possible.
The app provided here is only the minimum viable product of the Dots. app and several improvements are planned to come:
- Adding more NGOs: Adding more NGOs to the dataset to create a unified resource that people in need can quickly access and navigate.
- Collect user data: Collecting data about how the user intracts with the app would allow us to get a better understanding of the accessibility and common usages of the app. Additionally, this data would allow us to create recommendation systems to new users based on searchers that previously other users did. Collect data from "feedback box". "Feedback box" asking the user "was the NGO-information provided useful? Tell us more about it". The user should be able to leave a written or spoken message about the NGO information provided. This information could be used to improve NGO services, and to keep a reliable list of organisations.
- Collect user feedback: The goal is that users would rank the information provided in Dots. and add their comments. This would allow Konaconnect to improve the app and update the NGOs information.
- Add info pop-ups: The information pop-ups would be a way of interactively educating the user about their rights and the UN Sustainable Development Goals.
- NGOs portal + admin login: This feature allows the NGOs to apply directly to appear in Dots. On the other hand, an admin login is required so that the Dots. administrator can access the information submitted through the NGOs portal and approve it or regect it.
- Dots impact reporting: The amount of resources available to create real impact, to monitor advances and to identify underserved human rights has been increasing and is set to grow in the upcoming years. This is assumed because of the increasing pressures on mapping the trazability of contributions towards the Sustainable Development Goals and targets, and because of the improved Machile Learning and other technologies. We suggest createing integrated and automated, on demand reports using the data obtained from the user interaction with the "ngo services" (aligned to SDG targets for 2030). Humanitarian effort reports should be reliable, a result of robust data acquisition and selection. Gathering information for this type of reports has been taken into consideration by identifying how to obtain the information required to comply with "Credit Suisse's Framework to define and evaluate impact". Considerations of data coleection following Credit Suisse Framework are mentioned in The database. Brainstorming document here. The information aligned to the SDG targets and Credit Suisse Framework can be used to help define Dots performance and objectives aligned to the SDGs.
- News feed: One potential user group of Dots. is people who are looking for education and/or a job. This feature would act like a news feed where the latest information and opportunities would show, allowing the user to be alwasy updated about what the NGOs can offer for them.
- NGO location: One of the improvements added to the given database was to include the latitude and longitude coordinates of each organisation. The idea is to include a map in the NGO information page containing its exact location, making it more easy for the user to find it.
- Restructure database connections: The description can be found in the Access section of "Database" in this document.
- Meeting with Senegalese lawyers: To ask the following questions:
- What type of information could we ask the User in the "Feedback" box (the one created at the bottom of the main page of each NGO), taking into consideration that we want this to be used for providing constructive feedback to the NGO and maintain reliable organisations in the database.
- Are there specific questions that we should ask a defined group of people (refugees, domestic abuse survivors, stateless persons, etc.)? It would be useful to obtain information about the types of questions to ask, and then to try to codify it. That way we can make the search assistant tool (i.e. the quiz) more intelligent (this would be a future step). We want to figure out what are the most common questions that people ask. For example, where someone is looking for legal aid: Are there questions that lawyers always ask that we perhaps should add to the search assistance process as sub-questions?
- What type of features can we add to the web app to make the app "an alternative legal aid" tool, and save the lawyers additional paperwork.
This repository is licensed under the GPL - 3 license. This guarantees the end users the freedom to run, study, share, and modify the software provided. You can find more information in the LICENSE file.
- @bcabgil - Project management and data science
- @gildafc - Project management and data science
- @lorna-mn - UX / UI
- @andrewfair92 - UX / UI
- @heba0 - Fullstack
- @EmilieHumbert - Frontend web developer
- @jacksondieter - Frontend and backend lead
- Code reference:
- Inspiration:
- User interaction: https://www.blinkist.com/
- Documentation: https://github.com/kylelobo/The-Documentation-Compendium
- Credit Suisse Impact Management Project Framework found in the Sustainable Investment Framework report: https://www.credit-suisse.com/sustainability/en/reports.html
- References:
- Database of social organisations that provide help to Senegal: https://docs.google.com/spreadsheets/d/1t0-ol45Tz43zTCvqFXLLu5FSWuCbg4kElbocGbylCHA/edit#gid=1868970450