testToSQLite: adaptation_solution_basic_information: 1 row where where Database = "Delft Institute for Water Education" sorted by Description

1 row where Database = "Delft Institute for Water Education" 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
15	15	15	Room for the Rivers	Europe and Central Asia	The Netherlands	34 locations along the IJsel, Rhine, Lek and Wall rivers	National	Water	Floods	Infrastructure; Institutional strengthening and awareness raising; Planning	2007 - 2015	2.3 billion (Euro)	GoN	Provinces, municipalities, water boards and Rijkswaterstaat	Delft Institute for Water Education	The key of the Room for the River approach is to restore the river’s natural flood plain in places where it is least harmful in order to protect those areas that need to be defended. The plan had three objectives: By 2015 the branches of the Rhine will cope with a discharge capacity of 16,000 cubic metres of water per second without flooding; The measures implemented to increase safety will also improve the overall environmental quality of the river region; The extra room the rivers will need in the coming decades to cope with higher discharges due to the forecast climate changes, will remain permanently available.	https://www.un-ihe.org/sites/default/files/13270-rvdr-brochure-governance-engels_def-pdf-a.pdf and https://www.rijkswaterstaat.nl/water/waterbeheer/bescherming-tegen-het-water/maatregelen-om-overstromingen-te-voorkomen/ruimte-voor-de-rivieren/index.aspx

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