testToSQLite: adaptation_solution_basic_information: 1 row where where Database = "IUCN" sorted by Focus

1 row where Database = "IUCN" sorted by Focus_Sector

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
14	14	14	Manejo de la cuenca del río Cahoacán, Chiapas, México, a través de la conservación y restauración de microcuencas, para prevenir daños causados por el exceso de agua (fase I, II, III)	Latin America and the Caribbean	Mexico	Cuenca del río Cahoacán, Chiapas	Regional	Nature-based solutions and ecosystem services; Water	Climate extremes; Floods; Biodiversity loss; Storms	Nature-based solutions and ecosystem services; Technological innovations; Capacity building	2004 - 2018	Phase II: IUCN: 883,191 (USD) Other Partners: 1,230,920 (USD)	Fundación Gonzalo Río Arronte IAP (FGRA), IUCN & Sociedad de Historia Natural del Soconusco, A.C	Sociedad de Historia Natural del Soconusco, A.C & IUCN	IUCN	The Cahoacán River basin, located in Chiapas, Mexico, covers an area of 28,340 hectares and has an estimated population of 200 000 inhabitants. After Hurricane Stan (October 2005), which affected greatly this area, several analysis took place regarding the impacts it had on the coastal and border region of the state of Chiapas, showing the need of adaptive measures (https://www.iucn.org/node/989). The project builds on several initiatives in the last 15 years. The most recent actions focused on forest restoration to enhance the recovery of vegetation and water infiltration and reduce soil erosion due to surface runoff, thus reducing the possibility of overflow and floods in the basin and elevating its socio-environmental resilience.	https://www.iucn.org/node/29651

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