cnct_top_6_countries

cnct_top_6_countries

-- Connector: cnct_top_6_countries
-- Visualization: -
-- Definition: Gives the 6 highest country forest tree cover makes up statistic that show the percentage of forest from
--  a country and the total area of the country in ha
--   Variables: 
--     - Country (String): Name of the country
--     - NUTS_CODE (String): Code of the country
--     - perct_for (float): Percentage of forest, round to 2 decimals. Area divided by total area for each region multiplied by 100.
--     - fores_area (float): Area of forest in the country in ha
--     - nuts_area (float): Total area of the country in ha
--    - Forest area = 311 + 312 + 313 + 324
--     - NUTS area = 1xx + 2xx + 3xx + 4xx
--     -Tables used: [FISE].[latest].[CLC] and [FISE].[latest].[countries]
SELECT * FROM [FISE].[latest].[v_home_clc_top_6_countries_forest_tree_cover]
ORDER BY perct_for DESC