ForestQuery: Global Deforestation Analysis

ForestQuery Analysis

Project Information

  • Category: Data Analytics, Environmental Science
  • Client: Udacity (Educational Project)
  • Project Date: March 2020
  • Project URL: ForestQuery Repository

Files Used: forestation.sql, project-starter-template-deforestation-exploration-Stephanie Gessler.docx

Description

Analyzed worldwide deforestation data from the World Bank. Investigated forest area and land area changes by country and region. Identified key regions and countries with significant deforestation and forestation changes. Provided actionable insights and recommendations for forest conservation efforts.

Highlights

  • Global forest area decreased by 1,324,449 sq km (3.21%) from 1990 to 2016.
  • Latin America & Caribbean and Sub-Saharan Africa showed the largest decreases in forest areas.
  • Success stories include China and Iceland, with significant increases in forest areas.

Technical Details

  • Tools Used: SQL for data extraction and analysis
  • Credits: Udacity Knowledge Platform, StackOverflow, GeeksforGeeks

Recommendations

  • Focus on countries with the largest deforestation, such as Brazil and Nigeria.
  • Investigate and replicate successful forestation strategies from countries like China and Iceland.