cnct_eufact_clc_forest_and_land_cover

-- Connector: cnct_eu_forest_and_land_cover
-- Visualization: vis_forest_europe_forest_area_eu_eea_2015
-- Definition: Gives the land, transitional woodland and forest cover for EEA38 and EU27 without UK in ha units
-- Variables: 
--  - label (String): EEA38 or EU27 without UK
--  - nuts_code (String): EEA38 or EU27 without UK
--  - fores_area (float): Forest area in ha (CLC2018 Lv2: 311+312+313)
--  - total_area (float): Total area in ha
--  - other_wl (float): Transitional woodland-shrub area in ha (CLC2018 Lv2: 324)
SELECT 
  country AS country_NUTSCODE,
  --REPLACE(NUTS_CODE,'EEA38','EEA') AS nuts_code,
  --NUTS_CODE,
  nuts_area AS value,
  'Land' AS land_type,
  units
FROM [FISE].[latest].[v_multi_clc_forest_and_land_cover]
WHERE NUTS_CODE IN ('EU27','EEA38') AND year=2018

UNION ALL

SELECT 
  country AS country_NUTSCODE,
  --REPLACE(NUTS_CODE,'EEA38','EEA') AS nuts_code,
  --NUTS_CODE,
  (fores_area_311_312_313 - woodland_area) AS value,
  'Forest cover' AS land_type,
  units
FROM [FISE].[latest].[v_multi_clc_forest_and_land_cover]
WHERE NUTS_CODE IN ('EU27','EEA38') AND year=2018

UNION ALL

SELECT 
  country AS country_NUTSCODE,
  --REPLACE(NUTS_CODE,'EEA38','EEA') AS nuts_code,
  --NUTS_CODE,
  woodland_area AS value,
  'Transitional woodland' AS land_type,
  units
FROM [FISE].[latest].[v_multi_clc_forest_and_land_cover]
WHERE NUTS_CODE IN ('EU27','EEA38') AND year=2018



/*SELECT 
  country,
  --REPLACE(NUTS_CODE,'EEA38','EEA') AS nuts_code,
  --NUTS_CODE,
  nuts_area AS total_area,
  (fores_area_311_312_313 - woodland_area) AS forest_area,
  woodland_area,
  units
FROM [FISE].[latest].[v_multi_clc_forest_and_land_cover]
WHERE NUTS_CODE IN ('EU27','EEA38') AND year=2018*/