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
CREATE TABLE country_carbon_data (
"country" VARCHAR,
"umd_tree_cover_density_2000_threshold" BIGINT,
"umd_tree_cover_extent_2000_ha" BIGINT,
"gfw_aboveground_carbon_stocks_2000_mg_c" BIGINT,
"avg_gfw_aboveground_carbon_stocks_2000_mg_c_ha_1" BIGINT,
"gfw_forest_carbon_gross_emissions_mg_co2e_yr_1" DOUBLE,
"gfw_forest_carbon_gross_removals_mg_co2_yr_1" DOUBLE,
"gfw_forest_carbon_net_flux_mg_co2e_yr_1" DOUBLE,
"gfw_forest_carbon_gross_emissions_2001_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2002_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2003_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2004_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2005_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2006_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2007_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2008_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2009_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2010_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2011_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2012_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2013_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2014_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2015_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2016_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2017_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2018_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2019_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2020_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2021_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2022_mg_co2e" DOUBLE
);
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_extent_2000_ha" BIGINT,
"gfw_aboveground_carbon_stocks_2000_mg_c" BIGINT,
"avg_gfw_aboveground_carbon_stocks_2000_mg_c_ha_1" BIGINT,
"gfw_forest_carbon_gross_emissions_mg_co2e_yr_1" DOUBLE,
"gfw_forest_carbon_gross_removals_mg_co2_yr_1" DOUBLE,
"gfw_forest_carbon_net_flux_mg_co2e_yr_1" DOUBLE,
"gfw_forest_carbon_gross_emissions_2001_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2002_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2003_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2004_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2005_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2006_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2007_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2008_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2009_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2010_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2011_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2012_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2013_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2014_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2015_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2016_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2017_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2018_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2019_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2020_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2021_mg_co2e" DOUBLE,
"gfw_forest_carbon_gross_emissions_2022_mg_co2e" DOUBLE
);
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.