SDG-AI-Lab / Digital_Technologies_Radar

SDG AI Lab in partnership with UNDP DRT and CBi has developed an online tool – a Frontier Technology Radar for Disaster Risk Reduction (FTR4DRR), which allows for the systematic tracking and understanding of frontier technologies as they are developed. This would categorize technological solutions according to their technology type, disaster/crisis type and maturity level. Moreover, it is expected that the tool developed would encourage knowledge and experience-sharing among development stakeholders on the use of frontier technologies in disaster and conflict contexts. The Frontier Technology Radar for Disaster Risk Reduction (FTR4DRR) aims to highlight the potential of technological solutions in disaster contexts to those working in the fields of risk reduction, response and recovery. It supports development stakeholders to navigate the variety of existing and emerging technologies and their possible use cases.
11 stars 4 forks source link

Backend - database #313

Open jacksono opened 1 year ago

jacksono commented 1 year ago

Add tables and models: To help in data management where we can review the data and add projects easily, as well as give the ability to have a taxonomy system for the data we can introduce a relational database (Postgres database). The data base will have at minimum tables for:

Projects. With fields for all the project details

Location. Ie Region, Subregion, Country

SDGs

Technologies

The Projects table will have foreign key references to the other tables and will be indexed for query optimisation.