All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesCNCT Forest Area Change EU28
(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'CLC' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[CLC]
where nuts_level=0 and NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
UNION ALL
(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'HRL' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[HRL]
where nuts_level=0 and NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
UNION ALL
(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'NFI' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[nfi_forest_area]
where NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
order by 1No data