testToSQLite

Custom SQL query returning 12 rows (hide)

Query parameters

This data as json, CSV

rowidIDProject_NameRegionCountryProvince_CommunityScaleFocus_SectorMain_Climate_RisksAdaptation_MeasuresTime_frameFinance_DesegregationMain_funding_agenciesImplementing_agencyDatabaseDescriptionMain_Source
1 1 Ecotourism as a mechanism to strengthen resilience in Tumani Tenda Sub-Saharan Africa The Gambia Tumani Tenda Local Biodiversity conservation and restoration; Food and agriculture; Tourism; Nature-based solutions and ecosystem services Changes in crop productivity, crop pest and diseases; Water scarcity; Floods; Saltwater intrusion; Sea level rise; Biodiversity loss Capacity building; Nature-based solutions and ecosystem services 1997 – ongoing ≈ 2000 (USD) ) per one hectare of territory ready to be used for ecotourism National Environment Agency (NEA), the Saint Joseph Family Farm project and the Ministry of Water and Forests Enda Energy in partnership with the United Nations Institute for Training and Research (UNITAR) as part of the C3D+ program (Capacity Development for Adaptation to Climate Change and GHG Mitigation) Partnership on Transparency in the Paris Agreement As a result of climate change, the community of Tumani Tenda has experienced erratic rainfall for many years, leading to a decline in agricultural production, loss of vegetation and biodiversity, including birds and animals. All of these factors have led to a loss of income (Drame and Kiema, 2016). This situation has led actors in this area to initiate the practice of ecotourism. This has included direct community involvement in the protection of the region’s natural resources through activities such as protecting the communal forest and establishing an ecotourism camp including modest accommodation, food services, extraction and sale of forest products owned and managed by the community. The activities in Tumani Tenda are supported by various organisations, including the National Environment Agency (NEA), the Saint Joseph Family Farm project and the Ministry of Water and Forests (ibid). https://www.transparency-partnership.net/system/files/migrated_document_files/191202_gpd_gambia_ecotourism_web.pdf
30 30 Ground Water Recharge and Solar Micro Irrigation to Ensure Food Security and Enhance Resilience in Vulnerable Tribal Areas of Odisha South Asia India Odisha Local Food and agriculture; Water; Health; Infrastructure Floods; Drought; Climate extremes Infrastructure; Technological innovations; Policies and strategies; Planning 2017-2023 GCF: USD 34,357,000 Co-finance: USD131,940,000 (USD 110,671,000 grant+ USD 7,064,000 loan+ USD 14,205,000 in kind) GCF and World Bank Groundwater Division of Department of Water Resources, Govt. of Odisha GCF Enhancing ground water recharge in the community ponds through structural adaptation measures, and the use of solar pumps for micro irrigation. The ground water recharge measures will improve water security and quality for around 5.2 million beneficiaries in vulnerable communities through the installation of groundwater recharge shafts in 10,000 tanks. At the same time, resilient crop planning through irrigation will improve food security in the region, whilst the use of solar pumps for irrigation will increase energy access and contribute to the state’s climate-resilient, low emission crop planning. https://www.greenclimate.fund/project/fp045
33 33 Sustainable and Climate Resilient Connectivity for Nauru East Asia and Pacific Nauru Port of Nauru Local Infrastructure Storms; Sea level rise Infrastructure; Technological innovations; Policies and strategies; Planning 2018 - 2023 GCF: 26,910,000 (USD) Co-fiance: 38,290,000 GCFGCF, Asian Development Bank(ADB), Government of Australia and Government of Nauru Ministry of Finance GCF Nauru is the world’s smallest island nation. Isolated deep in the Pacific, it depends almost entirely on its port for supplies of food, energy, and most other essentials its people and economy need to survive. Yet its aging dysfunctional port facilities are completely exposed to the effects of climate change. The alternative proposed for GCF’s support is construction of a climate-resilient port that can operate year-round. Of five designs appraised, the one selected comprises (i) a channel through which oceangoing ships can pass between the sea and the shore for the first time in Nauru’s history, (ii) a stable wharf with a turning berth, (iii) a breakwater to shelter the wharf and the berth from waves, and (iv) port buildings, container terminal and port security provisions complying United Nation conventions such as International Ship and Port Facility Security (ISPS) Code. https://www.greenclimate.fund/project/fp052
52 52 Irrigation development and adaptation of irrigated agriculture to climate change in semi-arid Morocco North Africa and the Middle East Morocco Boudnib Valley in the Tafilalet region Local Food and agriculture; Infrastructure Water scarcity; Climate extremes; Drought Intrastructure; Planning; Capacity building 2018 - 2023 GCF: 23,894,862 (USD) Co-finance: 66,905,614 (USD) GCF, The Agence Française de Développement (AFD) and Kingdom of Morocco Ministry of Agriculture and Fisheries – Direction de l’Irrigation et de l’Aménagement de l’Espace Agricole (Directorate of Irrigation and the Development of Agricultural Areas) DIAEA - Office Régional de Mise en Valeur Agricole du Tafilalet (Regional Offi GCF The project area, the Boudnib Valley, is located in the semi-arid Tafilalet region, in the South-East part of the Kingdom, characterized by a high vulnerability to the effects of climate change (increased temperatures and water scarcity). The local population relies on oasis-based agriculture along the Guir wadi (intermittent river) The project is organized into three components: C1: Connecting to the dam and transfer of surface water to the Boudnib Valley [45,6 MEUR] C2: Building the climate - resilience of oasis communities through a holistic approach [12,5 MEUR] C3: Cross-cutting sustainability measures (technical assistance, groundwater preservation, environmental and social impacts management) [8,3 MEUR] C4: Project Management [2,4 MEUR] https://www.greenclimate.fund/sites/default/files/document/funding-proposal-fp042-afd-morocco.pdf
62 62 The Saïss Water Conservation Project North Africa and the Middle East Morocco Saïss Plain Local Water; Infrastructure; Food and agriculture Water Scarcity Infrastructure; Capacity building; Planning; Policies and strategies 2018 - 2023 GCF: 38,195,937 (USD) Co-finance: 208,721,623 (USD) European Bank for Reconstruction and Development (EBRD) loan, Kingdom of Morocco, and GCF (grant) Ministry of Agriculture and Maritime Fisheries (MAMF) GCF Project aims to enable water users and agricultural production in the Saïss Plain to make the transformational shift away from current irrigation practices which are based on an unsustainable dependency on groundwater abstraction. The Project will achieve this by a provision of critical irrigation infrastructure – a bulk water transfer scheme, thus making possible the annual transfer of 90-110 million m3 of surface water from the M’Dez dam to the Saiss Plain area. https://www.greenclimate.fund/sites/default/files/document/funding-proposal-fp043-ebrd-morocco.pdf
68 68 Miami Forever Bond North America United States of America Miami, Florida Local Coastal protection; Health; Infrastructure; Human habitat Sea level rise; Floods Policies and strategies; Planning; Finance; Investments 2018 - 2021 400,000,000 (USD) Government of Florida through the General Obligation Bond (GO Bond) Government of Miami Government of Miami In 2017, City of Miami voters passed the $400 million Miami Forever Bond initiative—a bond aimed at making the city more resilient to sea-level rise. The intent of Miami Forever Bond is to build a stronger, more resilient future for Miami, alleviating existing and future risks to residents, economy, tourism and the city’s legacy. The Bond will fund a series of projects that will transform the future of Miami by investing a total of $400 million in five key categories, which align with the City’s most pressing needs: Sea-Level Rise and Flood Prevention, Roadways, Parks and Cultural Facilities, Public Safety and Affordable Housing. Bond projects will benefit current and future residents, businesses and visitors, while also creating jobs and lowering costs related to sea-level rise and increased storm events. Main Page: https://www.miamigov.com/Government/Departments-Organizations/Office-of-Capital-Improvements/Miami-Forever-Bond and Projects: https://miamigis.maps.arcgis.com/apps/Shortlist/index.html?appid=5cd31470066f43a7b0d7a514d12e7a78 and https://www.miam
77 77 Adapting to the impacts of heatwaves in a changing climate in Botkyrka, Sweden Europe and Central Asia Sweden Botkyrka Local Disaster risk reduction Heatwaves Research; Monitoring and early warning systems 2010 – 2011 ≈100,000 Euros Municipality of Botkyrka Municipality of Botkyrka Swedish Defence Research Agency (FOI) and the Botkyrka Municipality Climate Adapt This project integrates heatwave resilience and action into planning and community guidance, contributing knowledge on heatwave risks in Botkyrka, Sweden with a vulnerability assessment to heatwaves, producing maps of vulnerable groups and areas. This vulnerability assessment initiated the publication of a guide to advise other municipalities experiencing similar vulnerability to heatwaves, and the implementation of protection measures in most vulnerable areas such as care homes. Early warning systems were improved and updated based on the findings of the vulnerability assessment, with focus placed on disseminating information within the most vulnerable areas. Innovative finance mechanisms encouraged environmental co-benefits: air-conditioning units were procured and installed by the government as long as costs were offset by the municipality, and so solar panels were built by the municipality to compensate for the increased energy consumption of the aircon units. Within vulnerable areas, 'cool spots’ were installed by a housing company managing 11,000 apartments. The project incurred limited costs to cover salaries of the three employees hired for the programme. https://climate-adapt.eea.europa.eu/metadata/case-studies/adapting-to-the-impacts-of-heatwaves-in-a-changing-climate-in-botkyrka-sweden
78 78 Isar-Plan – Water management plan and restoration of the Isar River, Munich (Germany) Europe and Central Asia Germany Munich Local Nature-based solutions and ecosystem services; Infrastructure; Water; Biodiversity conservation and restoration Floods Planning; Policies and strategies; Infrastructure 1995-2011 35,000,000 Euros - Bavarian State Government (55%) and the City of Munich (45%) Bavarian State Government and the City of Munich State Office of Water Management Munich, the City of Munich Climate Adapt Responding to increased rainfall, flooding and economic and infrastructural losses in Munich, the city implemented a floor risk management plan on the River Isar, the Isar-Plan. This worked on flood protection and restoration measures, protecting Munich from the 2005 floor which damaged other cities in Southern Germany; improving water quality so that swimming is now possible in the river; improving water and land habitats; and improving recreational quality for residents. A success area of the project was interdisciplinary group driving the Isar-Plan, integrating stakeholders operating at different levels. This consisted of a group of NGOs (the Isar-Allianz), the State Office of Water Management Munich, and the City of Munich, while public participation was driven by internet engagement, dissemination of pamphlets, workshops, press engagement, round tables, and telephone/information services. Environmental co-benefits emerged from cross river sills, preventing fish from passing through, being replaced by flat ramps, improving biodiversity and restoring the habitat of flora and fauna within the river. Outcomes are as follows: the main channel was widened from 50 to 90 metres, giving more space to the river and improving run off and discharge. Embankments, previously secured with concrete slabs, have been replaced by sloping banks. Runoff has improved and can now run off at a rate of 1,100 cubic meters per second. A distance of one metre has been implemented between flood water level and the crest of the dike, protecting low-lying areas from high flood water. https://climate-adapt.eea.europa.eu/metadata/case-studies/isar-plan-2013-water-management-plan-and-restoration-of-the-isar-river-munich-germany
79 79 Adaptive restoration of the former saltworks in Camargue, southern France Europe and Central Asia France Camargue Local Nature-based solutions and ecosystem services; Infrastructure; Water; Biodiversity conservation and restoration Sea level rise Planning; Infrastructure; Nature-based solutions and ecosystem services; 2011 – ongoing 7-13 million euros, plus 80,000€ to 140 K€ for annual maintenance has been estimated in order to maintain and adapt the inner protection dyke system (about 16 km linear extension). The cost for hydraulic reconnection works were estimated to be less than 1 Regional Natural Park of the Camargue, Tour du Valat Research Institute and the National Society for Nature Protection Regional Natural Park of the Camargue, Tour du Valat Research Institute and the National Society for Nature Protection Climate Adapt This project aims to restore the Camargue delta, 70% of which is within an altitude of less than 1 metre. To protect the area from flooding dykes were built, and as a former saltworks, Camargue as an area has become increasingly artificial, causing coastal erosion and altered water and ecological conditions. The project thus aims to restore the ecosystem and natural functioning of the system and reconnecting it with the Rhone river, the Mediterranean Sea, and inland lagoons. In doing so, the project hopes to increase biodiversity in the area, implement adaptive flood protection, and enhance eco-tourism and recreational activities. The project has been considered successful for its wide scope as a restoration and adaptation project, as well as its long-term and inexpensive intervention to save public funds. The NBS approach mitigates possible environmental risks through monitoring of ecosystem functioning. Current outcomes include channel dredging, and rehabilitation of connections between the area and surrounding water bodies. https://climate-adapt.eea.europa.eu/metadata/case-studies/adaptive-restoration-of-the-former-saltworks-in-camargue-southern-france
82 82 Crop diversification and improved soil management for adaptation to climate change in Segovia Europe and Central Asia Spain Segovia Local Food and agriculture Drought Research 2017 – ongoing  The total cost for producing the assessment and the action plan of the Melque de Cercos farm amounted to 5,000 €. Implementation costs not yet estimated AgriAdapt project & European Commission through the LIFE Program; co-financed by Fundación Biodiversidad from the Spanish Ministry of Ecological Transition Fundación Global Nature Climate Adapt the LIFE AgriAdapt project has initiated 120 pilot farms to test adaptation measures, and one of these is in Melque de Cercos (Segovia, Spain). Responding to droughts, extreme temperature and soil degradation, the Segovia project aims to increase the resilience of rainfed crops through cross-cutting measures, promoting synergy between adaptation and mitigation. A local-level vulnerability assessment was undertaken, from which adaptation measures were proposed: crop rotation was improved with movement away from monoculture, along with soil management measures to control soil usage. The final measure was to implement multifunctional field margins to improve biodiversity: after 2 years, vegetation in these areas to include a diverse species mix including pollinators and increased local fauna. To monitor the progress of this project, a climate risk assessment was undertaken, with feedback from farmers taken into account at regular points of the project. https://climate-adapt.eea.europa.eu/metadata/case-studies/crop-diversification-and-improved-soil-management-for-adaptation-to-climate-change-in-segovia-spain
83 83 Flood protection in the Upper Vistula river basin: grey and green measures implemented in the Sandomierz area Europe and Central Asia Poland Sandomierz area Local Water; Infrastructure; Nature-based solutions and ecosystem services Floods Policies and strategies; Planning; Infrastructure; Nature-based solutions and ecosystem services 2011-2019 217 million EUR World Bank Regional Water Management authorities of Krakow, Kielce and Rzeszow Climate Adapt Flooding events in the Upper Vistula river basin in 2010 and 2011, drove the implementation of this project to cope with increasing flooding. The town of Sandomierz, which is home to about 24,700 people, saw 40% of its total extension flooded and flood losses were estimated at approximately 100 million Euros. In that context, the project of Flood protection in the Upper Vistula river basin: grey and green measures implemented in the Sandomierz area was born. One of the main objectives of the project were to increase the retention capacity and to reduce flood risk in and around this town in the Sandomierz. The project implements a hybrid approach in which green/grey infrastructure is used. Measurements include the rehabilitation of reservoirs and wetlands, expansion, reconstruction and modernization of river embankments; and the (re)construction of water pump stations and water discharge channels. The adaptation measures were designed within the scope of the River Basin Management Plans (RBMP) and elaborated according to the WFD and the Flood Directive. Furthermore, the impact on natural habitats were monitored according to Natura 2000 policies. https://climate-adapt.eea.europa.eu/metadata/case-studies/flood-protection-in-the-upper-vistula-river-basin-grey-and-green-measures-implemented-in-the-sandomierz-area
84 84 Jinan: Build a modern spring city to adapt to climte change East Asia and Pacific China Jinan Local Water; Infastructure; Human habitat Floods; Climate extremes Capacity building 2015-2018 7.9 billion yuan Central financial subsidies and PPP investments Government N/A In April 2015, Jinan was selected as one of the first sponge city pilot cities in China. During the three-year sponge city pilot construction period, Jinan received 1.5 billion yuan of central financial subsidy. In February 2017, Jinan was approved as a national pilot city for climate-resilient urban construction. Jinan all-round to carry out the city to adapt to climate change action, improve the ability to adapt to climate change of the city and building safety, toughness, livable, quality of modern springs, efforts to build mountains, springs, lakes, rivers, the integration of city of urban water circulation system, address the springs dried up, frequent floods, water shortage, water pollution and other issues, sponge cities and climate adaptive building pilot fruitful. Information shared by our partners