testToSQLite: adaptation_solution_basic_information: 1 row where where Database = "UNDP" sorted by Description

1 row where Database = "UNDP" sorted by Description

descending

Link	rowid	ID	Project_Name	Region	Country	Province_Community	Scale	Focus_Sector	Main_Climate_Risks	Adaptation_Measures	Time_frame	Finance_Desegregation	Main_funding_agencies	Implementing_agency	Database	Description ▼	Main_Source
38	38	38	Integrating Community-based Adaptation into Afforestation and Reforestation Programmes in Bangladesh (ICBAAR)	South Asia	Bangladesh	Coastal communities	Regional	Human habitat; Biodiversity conservation and restoration; Coastal protection; Nature-based solutions and ecosystem services	Sea level rise; Saltwater intrusion; Floods; Storms; Climate extremes	Monitoring and early warning systems; Policies and strategies; Planning; Finance; Capacity building	2016 - 2020	LDCF (GEF) $5,650,000 Co-funding: GoB $35,000,000 USAID $10,000,000 UNDP $2,000,000	LDCF (GEF), GoB UNDP	Implementing Agency: Bangladesh Forest Department (BFD) Executing agency: Ministry of Environment & Forests Other execution partners: USAID, UNDP	UNDP	The project aim to enable the GoB to design measures for mitigation and adaptation to address climate change, through (1) supporting communities living in coastal afforestation/reforestation sites to adopt resilient livelihoods, (2) regulatory reform and fiscal incentive structures introduction that incorporate climate change risk management, and (3) training CPP volunteers for climate risks, disaster preparedness and the benefit of coastal forest for climate risk mitigation. The project aims to assist the GoB to carry out all the necessary activities to increase climate resilience of costal belt communities and through adaptation and mitigation activities.	ICBA AR midterm rep Document 1 Project implementation report 2019 (word doc.) Document 2 file:///C:/Users/Henk/Downloads/ID4700__BGD_Prodoc_Final_as_of_2_Sep2013.pdf Document 3 file:///C:/Users/Henk/Downloads/ID4700__BGD_Prodoc_Final_as_of_2_Sep2013.pd

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "adaptation_solution_basic_information" (
	"ID" VARCHAR(255) NULL,
	"Project_Name" VARCHAR(255) NULL,
	"Region" VARCHAR(255) NULL,
	"Country" VARCHAR(255) NULL,
	"Province_Community" VARCHAR(255) NULL,
	"Scale" VARCHAR(255) NULL,
	"Focus_Sector" VARCHAR(255) NULL,
	"Main_Climate_Risks" VARCHAR(255) NULL,
	"Adaptation_Measures" VARCHAR(255) NULL,
	"Time_frame" VARCHAR(255) NULL,
	"Finance_Desegregation" VARCHAR(255) NULL,
	"Main_funding_agencies" VARCHAR(255) NULL,
	"Implementing_agency" VARCHAR(255) NULL,
	"Database" VARCHAR(255) NULL,
	"Description" TEXT NULL,
	"Main_Source" VARCHAR(255) NULL
);