Global Forest Data: 2001-2022
Tree Cover, Biomass, and Carbon Flux Analysis
@kaggle.karnikakapoor_global_forest_data_2001_2022
Tree Cover, Biomass, and Carbon Flux Analysis
@kaggle.karnikakapoor_global_forest_data_2001_2022
This dataset, titled "Global Forest Data (2001-2022): Tree Cover, Biomass, and Carbon Flux Analysis," presents a comprehensive overview of global forestry metrics over 21 years. It includes data on tree cover extent, aboveground live woody biomass (AGB) stocks and densities, along with detailed annual records of tree cover loss and forest greenhouse gas (GHG) emissions from 2001 to 2022. The data set is enhanced by insights into annual average forest CO2 removals (sequestration) and the net GHG flux at both the country and first sub-national levels.
Key features of the dataset:
Tree Cover Data: Offers information on tree cover loss and emissions with annual granularity for 2001-2022. Tree cover statistics are available for the years 2000 and 2010.
Biomass Stocks and Densities: Presents aboveground biomass stocks and densities for 2000.
Carbon Metrics: Includes carbon densities, emissions, removals, and net flux data in megagrams CO2e/yr, detailing carbon dioxide, methane (CH4), and nitrous oxide (N2O) emissions due to forest disturbances.
Canopy Cover Thresholds: Data is categorized by per cent canopy cover (>10%, 15%, 20%, 25%, 30%, 50%, and 75%) for 2000, with emissions, removals, and net flux presented for >30%, 50%, and 75% canopy cover levels.
The dataset is a result of collaborations with notable entities such as the University of Maryland's GLAD laboratory and Google and is based on research by Hansen et al. (2013) and Harris et al. (2021). This resource is essential for understanding the dynamics of tree cover loss, forest carbon emissions, and the overall net effect of climate change. It is precious for environmental researchers, policymakers, and educators looking to analyze trends and develop strategies in forest conservation and carbon management.
Please note: The dataset defines "tree cover" as vegetation over 5 meters in height, including natural forests or plantations. "Loss" refers to the removal or mortality of tree cover from various factors and does not equate to deforestation. The emissions, removals, and net flux data are model-based and should be interpreted with care, considering the inherent degree of error and uncertainty. Users are encouraged to read the provided metadata and documentation thoroughly before analysis.
For further inquiries about this dataset, contact Liz Goldman at the World Resources Institute (elizabeth.goldman@wri.org).
CREATE TABLE country_carbon_data (
"country" VARCHAR,
"umd_tree_cover_density_2000_threshold" BIGINT -- Umd Tree Cover Density 2000, Threshold,
"umd_tree_cover_extent_2000_ha" BIGINT -- Umd Tree Cover Extent 2000, Ha,
"gfw_aboveground_carbon_stocks_2000_mg_c" BIGINT -- Gfw Aboveground Carbon Stocks 2000, Mg C,
"avg_gfw_aboveground_carbon_stocks_2000_mg_c_ha_1" BIGINT -- Avg Gfw Aboveground Carbon Stocks 2000, Mg C Ha-1,
"gfw_forest_carbon_gross_emissions_mg_co2e_yr_1" DOUBLE -- Gfw Forest Carbon Gross Emissions, Mg CO2e Yr-1,
"gfw_forest_carbon_gross_removals_mg_co2_yr_1" DOUBLE -- Gfw Forest Carbon Gross Removals, Mg CO2 Yr-1,
"gfw_forest_carbon_net_flux_mg_co2e_yr_1" DOUBLE -- Gfw Forest Carbon Net Flux, Mg CO2e Yr-1,
"gfw_forest_carbon_gross_emissions_2001_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2001, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2002_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2002, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2003_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2003, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2004_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2004, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2005_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2005, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2006_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2006, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2007_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2007, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2008_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2008, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2009_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2009, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2010_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2010, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2011_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2011, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2012_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2012, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2013_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2013, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2014_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2014, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2015_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2015, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2016_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2016, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2017_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2017, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2018_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2018, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2019_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2019, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2020_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2020, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2021_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2021, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2022_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2022, Mg CO2e
);
CREATE TABLE country_tree_cover_loss (
"country" VARCHAR,
"threshold" BIGINT,
"area_ha" BIGINT,
"extent_2000_ha" BIGINT,
"extent_2010_ha" BIGINT,
"gain_2000_2020_ha" BIGINT,
"tc_loss_ha_2001" BIGINT,
"tc_loss_ha_2002" BIGINT,
"tc_loss_ha_2003" BIGINT,
"tc_loss_ha_2004" BIGINT,
"tc_loss_ha_2005" BIGINT,
"tc_loss_ha_2006" BIGINT,
"tc_loss_ha_2007" BIGINT,
"tc_loss_ha_2008" BIGINT,
"tc_loss_ha_2009" BIGINT,
"tc_loss_ha_2010" BIGINT,
"tc_loss_ha_2011" BIGINT,
"tc_loss_ha_2012" BIGINT,
"tc_loss_ha_2013" BIGINT,
"tc_loss_ha_2014" BIGINT,
"tc_loss_ha_2015" BIGINT,
"tc_loss_ha_2016" BIGINT,
"tc_loss_ha_2017" BIGINT,
"tc_loss_ha_2018" BIGINT,
"tc_loss_ha_2019" BIGINT,
"tc_loss_ha_2020" BIGINT,
"tc_loss_ha_2021" BIGINT,
"tc_loss_ha_2022" BIGINT
);
CREATE TABLE subnational_1_carbon_data (
"country" VARCHAR,
"subnational1" VARCHAR,
"umd_tree_cover_density_2000_threshold" BIGINT -- Umd Tree Cover Density 2000, Threshold,
"umd_tree_cover_extent_2000_ha" BIGINT -- Umd Tree Cover Extent 2000, Ha,
"gfw_aboveground_carbon_stocks_2000_mg_c" BIGINT -- Gfw Aboveground Carbon Stocks 2000, Mg C,
"avg_gfw_aboveground_carbon_stocks_2000_mg_c_ha_1" BIGINT -- Avg Gfw Aboveground Carbon Stocks 2000, Mg C Ha-1,
"gfw_forest_carbon_gross_emissions_mg_co2e_yr_1" DOUBLE -- Gfw Forest Carbon Gross Emissions, Mg CO2e Yr-1,
"gfw_forest_carbon_gross_removals_mg_co2_yr_1" DOUBLE -- Gfw Forest Carbon Gross Removals, Mg CO2 Yr-1,
"gfw_forest_carbon_net_flux_mg_co2e_yr_1" DOUBLE -- Gfw Forest Carbon Net Flux, Mg CO2e Yr-1,
"gfw_forest_carbon_gross_emissions_2001_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2001, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2002_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2002, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2003_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2003, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2004_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2004, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2005_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2005, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2006_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2006, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2007_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2007, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2008_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2008, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2009_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2009, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2010_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2010, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2011_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2011, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2012_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2012, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2013_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2013, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2014_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2014, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2015_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2015, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2016_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2016, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2017_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2017, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2018_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2018, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2019_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2019, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2020_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2020, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2021_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2021, Mg CO2e,
"gfw_forest_carbon_gross_emissions_2022_mg_co2e" DOUBLE -- Gfw Forest Carbon Gross Emissions 2022, Mg CO2e
);
CREATE TABLE subnational_1_tree_cover_loss (
"country" VARCHAR,
"subnational1" VARCHAR,
"threshold" BIGINT,
"area_ha" BIGINT,
"extent_2000_ha" BIGINT,
"extent_2010_ha" BIGINT,
"gain_2000_2020_ha" BIGINT,
"tc_loss_ha_2001" BIGINT,
"tc_loss_ha_2002" BIGINT,
"tc_loss_ha_2003" BIGINT,
"tc_loss_ha_2004" BIGINT,
"tc_loss_ha_2005" BIGINT,
"tc_loss_ha_2006" BIGINT,
"tc_loss_ha_2007" BIGINT,
"tc_loss_ha_2008" BIGINT,
"tc_loss_ha_2009" BIGINT,
"tc_loss_ha_2010" BIGINT,
"tc_loss_ha_2011" BIGINT,
"tc_loss_ha_2012" BIGINT,
"tc_loss_ha_2013" BIGINT,
"tc_loss_ha_2014" BIGINT,
"tc_loss_ha_2015" BIGINT,
"tc_loss_ha_2016" BIGINT,
"tc_loss_ha_2017" BIGINT,
"tc_loss_ha_2018" BIGINT,
"tc_loss_ha_2019" BIGINT,
"tc_loss_ha_2020" BIGINT,
"tc_loss_ha_2021" BIGINT,
"tc_loss_ha_2022" BIGINT
);
Anyone who has the link will be able to view this.