testToSQLite: adaptation_solution_basic_information: 1 row where where Database = "Adaptation Fund" sorted by Main_Climate

1 row where Database = "Adaptation Fund" sorted by Main_Climate_Risks

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
19	19	19	Solomon Islands: Enhancing resilience of communities in Solomon Islands to the adverse effects of climate change in agriculture and food security	East Asia and Pacific	Solomon Islands	N/A	Subnational	Human habitat	Storms; Climate extremes; Floods; Drought	Capacity building; Institutional strengthening and awareness raising; Policies and strategies; Planning	2011 - 2015	5,610,000 (USD)	UNDP/ World Bank	UN Development Programme	Adaptation Fund	Traditional agricultural practices that communities rely on in the Solomon Islands have been placed under increasing pressure from emerging climate change risks. The preferred solution is to support communities to better manage and adapt to climate change pressures in the context of food security through community based adaptation. This project will strengthen the ability of communities in the Solomon Islands to make informed decisions and manage likely climate change driven pressures on food production and management systems. In particular the project will lead to the following key results (outcomes): 1) Promoted and piloted community adaptation activities enhancing food security and livelihood resilience in pilot communities in at least 3 selected regions. 2) Adjusted the national and sub-national policies related to governing agriculture in a range of climate futures and; 3) Fostered the generation and spread of relevant knowledge for assisting decision-making at the community and policy-formulation level.	https://www.adaptation-fund.org/project/enhancing-resilience-of-communities-in-solomon-islands-to-the-adverse-effects-of-climate-change-in-agriculture-and-food-security/

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
);