{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["COVER","METADATA_Output data","METADATA_Sources","Lists","MacroBehaviour","Specific Lists","Locks","MustNotBeNegative","IsNumeric","Summations","Mandatory","Table 3 (Level 3)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[]
[null,null,{"$f":"Lists!K4","v":"Directorate E: Sectoral and regional statistics"}]
[null,null,{"$f":"Lists!K5","v":"Unit E-2: Environmental statistics and accounts; sustainable development"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ECOSYSTEM EXTENT ACCOUNTS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 19 December 2024"}]

{"sheet":"METADATA_Output data","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,3,7,4],[1,3,1,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
[]
[]
[null,null,null,null,"STATISTICAL OFFICE OF THE EUROPEAN UNION"]
[null,null,null,"ECOSYSTEM EXTENT ACCOUNTS"]
[]
[null,null,null,"Most headings contain additional instructions for filling requested information. These are shown after clicking on the heading."]
[null,null,null,"METADATA (A) "]
[null,null,null,"Output data"]
[null,null,null,"Minimum Mapping Unit","example: \n- 1 ha\n- 1 ha for urban ecosystem; MMU = 10 ha for the other ecosystems\n- 1 ha for L1 ecosysrtems; 0.5 ha - for level 2 ecosystems\n"]
[null,null,null,"Treatment of linear features","examples: \n- geographic features, such as roads and rivers, wider than the target MMW and represented as lines in the input dataset are converted to polygons through the application of buffer. They are shown as polygon features and their area accounted for, accordingly\n- input data did not contain features represented as lines [e.g. in case of CLC]\n- individual mapped linear features are incorporated within the spatial unit representing the surrounding ecosystem asset (i.e. linear features not considered as separate assets)"]
[null,null,null,"Minimum Mapping Width","example: 50 m"]
[null,null,null,"Coordinate reference system of the reported extent accounts ","European system ETRS89-LAEA (EPSG:3035) "]
[null,null,null,"Spatial accuracy","example: 5 m, assessed using aerial orthophotographs and a random selection of 100 checkpoints as a reference. Expressed as Root Mean Square Error (RMSE)\n"]
[null,null,null,"Classification accuracy (% correctly classified areas in validation set based on reference points) for each level 1 ecosystem type separately","[also referred to as 'thematic accuracy']\n example:\n- Forest and woodland - 85%\n- Grassland, Cropland, Heathland - 80%, etc.\nCalculated and express as Overal Accuracy (OA)"]
[null,null,null,"Temporal coherence - reference year(s) of source data ","example:\n- all source data are from reference year [yyyy-yyyy], see METADATA Source for detail\n- main input layers from reference year yyyy, data inputs x and z are from year yyyy \n"]
[null,null,null,"Threshold applied to record ecosystem conversion between reference years","example: 0.1 ha"]
[null,null,null,"Workflow for ecosystem classification ","example: \n- dataset [xxxx] was used as basis, thematic national layers [xxxx, zzzz, etc] were overlaid in the following order [1, 2, 3, etc], prioritizing layers for the most recent reference years, \n- detailed workflow [description/code] is available at: [include public hyperlink] in English [other language]"]
[null,null,null,"Method to calculate representative averages of ecosystem extent per ecosystem type","example: data reflect situation during growing seasons of respective reference years\n"]
[null,null,null,"Length of comparable time series","example:\n- data for 2021 and 2024 are comparable\n- break in time series in 2021 [i.e. data before 2021 are not comparable with data for 2021 and later] due to change in method [xxxx, key points on method change to be provided]"]
[null,null,null,"Spatial coverage","example: the entire national territory covered"]
[null,null,null,"Plausibility checks applied","example:\n- comparison of level 1 aggregates with [dataset xxxx, statistics xxxx]\n- time-series comparison of extent accounts for reference years yyyy1 and yyyy2"]
[null,null,null,"Other methodological notes","example:\n- public hyperlink to national methodological reports on ecosystem extent accounts\n- public hyperlink to published national map of ecosystem types  "]

{"sheet":"METADATA_Sources","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,3,27,4],[28,3,28,4],[7,3,7,4],[7,6,7,7],[7,8,7,9],[7,10,7,11],[24,3,24,4],[25,3,25,4],[5,3,5,4],[5,6,5,7],[5,8,5,9],[5,10,5,11],[6,3,6,4],[6,6,6,7],[6,8,6,9],[6,10,6,11],[3,3,3,4],[3,6,3,7],[3,8,3,9],[3,10,3,11],[4,3,4,4],[4,6,4,7],[4,8,4,9],[4,10,4,11],[1,3,1,4],[1,6,1,7],[1,8,1,9],[1,10,1,11],[2,6,2,7],[2,8,2,9],[2,10,2,11]]}
[]
[]
[null,null,null,null,"STATISTICAL OFFICE OF THE EUROPEAN UNION"]
[null,null,null,"ECOSYSTEM EXTENT ACCOUNTS"]
[]
[null,null,null,"Most headings contain additional instructions for filling requested information. These are shown after clicking on the heading."]
[null,null,null,"METADATA (B1)"]
[null,null,null,"Source data - characteristics"]
[null,null,null,"Source dataset name","Link to INSPIRE documentation ","OR:","Dataset type (raster or vector; area, linear, point)","Dataset status (e.g. official data, provisional data, national/international; private, research data)","Minimum mapping unit","Minimum mapping width","Reference year of source dataset\n","Dataset frequency","Classification used","Other metadata information"]
[null,null,1,"example: National Topographic Map",null,null,"vector","official national data","1 ha","50 m",2010,"irregular","NA","hyperlink to dataset/further documentation"]
[null,null,2,"example: Digital Terrain Model/Digital Elevation Model",null,null,"raster","official national data","10 m","NA",2010,"constant/stable","NA","Vertical resolution of 1 meter\nhyperlink to dataset/further documentation"]
[null,null,3,"example: Water Framework Directive - surface water bodies",null,null,"vector","official national data",null,null,"2019-2024","6 years",null,"hyperlink to dataset/further documentation"]
[null,null,4,"example: Small Woody Features (Copernicus HRL)",null,null,"raster","official EU data","5 m",null,2018,"3 years","see EEA documentation","hyperlink to dataset/further documentation"]
[null,null,5,"example: National Forest Registry",null,null,"vector","offical national data","0.5 ha","not assessed",2020,"annual","NA","hyperlink to dataset/further documentation"]
[null,null,6,"example: Natura 2000 habitats (Annex I)","https://inspire-geoportal.ec.europa.eu/srv/eng/catalog.search#/overview?view=themeOverview&theme=hb",null,"vector","offical national data","0.1 ha",null,2021,"3 years","Natura 2000/EUNIS","hyperlink to dataset/further documentation"]
[null,null,7,"example: Greenhouses Spatial Mask (EEA)",null,null,"raster","EU data","100 m",null,2018,"irregular","NA","hyperlink to dataset/further documentation"]
[null,null,8,"example: National Soil Map",null,null,"vector","official national data","1 ha","20 m",2021,"3-yearly","national soil classification","hyperlink to dataset/further documentation"]
[null,null,9,"example: National Cadaster Map",null,null,"vector","official national data","0.1 ha","2 m",2021,"annual","national land parcel classification","hyperlink to dataset/further documentation"]
[null,null,10,"type name here"]
[null,null,11,"type name here"]
[null,null,12,"type name here"]
[null,null,13,"type name here"]
[null,null,14,"type name here"]
[null,null,15,"type name here"]
[]
[null,null,null,"AND (if reporting ecosystem types at level 2):"]
[]
[null,null,null,"METADATA (B2)"]
[null,null,null,"Source data - mapping to EU ecosystem typology"]
[null,null,null,"EU ecosystem type - level 2","Name of source dataset \n(from Metadata B1)","AND:","Name/code of corresponding class(es) in the source dataset"]
[null,null,null,"1.5 Other artificial areas ","National Cadaster Map",null,"land parcel types: xx1, xx2, etc"]
[null,null,null,"2.6 Other farmland "]
[null,null,null,"4.1 Broadleaved deciduous forest","example: National Forest Registry",null,"xxxx"]
[null,null,null,"4.3 Broadleaved evergreen forest","example: not reported"]
[null,null,null,"4.6 Plantations"]
[null,null,null,"5.1 Tundra","example: not applicable (NA)"]
[null,null,null,"8.1 Rivers","example: Water Framework Directive"]
[null,null,null,"8.2 Canals, ditches, and drains"]
[null,null,null,"9.1 Lakes"]
[null,null,null,"9.2 Artificial reservoirs","example: National Topographic Map",null,"NA"]
[null,null,null,"9.3 Geothermal pools and wetlands","example: Natura 2000 habitats, National Soil Map",null,"habitat codes: xxx, xxz, etc."]
[null,null,null,"11.1 Artificial shorelines "]
[null,null,null,"11.2 Coastal dunes, beaches and sandy and muddy shores "]
[null,null,null,"11.3 Rocky shores"]

{"sheet":"Lists","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,9,1,10],[5,9,5,10],[10,9,10,10],[15,9,15,10]]}
["Country label","Country code","Currency","Valid flags (obs_status)","Label",null,"Valid flags (obs_conf)","Label",null,"Textual variables","String",null,"TEST"]
["Belgium","BE","EUR","B","break in time series",null,"C","confidential",null,"Institutional names"]
["Bulgaria","BG","BGN","E","estimated data",null,"D","secondary confidentiality set by the sender",null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ","CZK","P","provisional",null,null,null,null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK","DKK","BE",null,null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE","EUR","BP",null,null,null,null,null,"Data collection information"]
["Estonia","EE","EUR","EP",null,null,null,null,null,"Data Collection Title","Ecosystem Extent Accounts"]
["Ireland","IE","EUR","BEP",null,null,null,null,null,"Data Collection Year",2024]
["Greece","EL","EUR",null,null,null,null,null,null,"Launching date","19 December 2024"]
["Spain","ES","EUR",null,null,null,null,null,null,"Submission deadline","30 April 2025"]
["France","FR","EUR",null,null,null,null,null,null,"EDAMIS data"]
["Croatia","HR","EUR",null,null,null,null,null,null,"Domain name","ENVDATA"]
["Italy","IT","EUR",null,null,null,null,null,null,"Dataset name","ENVDATA_ECOEXT_3"]
["Cyprus","CY","EUR",null,null,null,null,null,null,"Web page","https://cros.ec.europa.eu/book-page/national-transmission-coordinators"]
["Latvia","LV","EUR",null,null,null,null,null,null,"Functional e-mail","ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"]
["Lithuania","LT","EUR",null,null,null,null,null,null,"E2 information"]
["Luxembourg","LU","EUR",null,null,null,null,null,null,"Telephone","(+352) 4301 33213"]
["Hungary","HU","HUF",null,null,null,null,null,null,"Contact","ESTAT-ECOSYSTEMS@EC.EUROPA.EU"]
["Malta","MT","EUR",null,null,null,null,null,null,"Methodology URL","https://ec.europa.eu/eurostat/web/environment/methodology "]
["Netherlands","NL","EUR",null,null,null,null,null,null,"Legislation URL","NA"]
["Austria","AT","EUR"]
["Poland","PL","PLN"]
["Portugal","PT","EUR"]
["Romania","RO","RON"]
["Slovenia","SI","EUR"]
["Slovakia","SK","EUR"]
["Finland","FI","EUR"]
["Sweden","SE","SEK"]
["United Kingdom","UK","GBP"]
["Iceland","IS","ISK"]
["Liechtenstein","LI","CHF"]
["Norway","NO","NOK"]
["Switzerland","CH","CHF"]
["Montenegro","ME","EUR"]
["North Macedonia","MK","MKD"]
["Albania","AL","ALL"]
["Serbia","RS","RSD"]
["Turkey","TR","TRY"]
["Bosnia and Herzegovina","BA","BAM"]
["Kosovo (UNSCR 1244)","XK","EUR"]

{"sheet":"MacroBehaviour","index":4,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["COMMON TO ALL (OR MOST)  QUESTIONNAIRE",null,null,null,"SPECIFIC TO THIS QUESTIONNAIRE"]
["Parameter","Value","(Valid values)",null,"Parameter","Value","(Valid values)"]
["DevelopementMode",false,"TRUE (during development)\nFALSE (For real reporting and testing)"]

{"sheet":"Specific Lists","index":5,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,3,0,4],[0,7,0,8]]}
["TYPES OF PERIODS",null,null,"LOOKUP COLUMN",null,null,"CLOSING AT END OF YEAR","OPENING AT START OF YEAR"]
["Text","Code",null,"Period type code","column number",null,null,"(annual - A)","(3-years - A3)"]
["Annual","A",null,"A",2,null,2000,{"$f":"G3-1","v":1999},"Invalid closing year"]
["3-years","A3",null,"A3",3,null,2001,{"$f":"G4-1","v":2000},"Invalid closing year"]
[null,null,null,null,null,null,2002,2001,"Invalid closing year"]
[null,null,null,null,null,null,2003,2002,"Invalid closing year"]
[null,null,null,null,null,null,2004,2003,"Invalid closing year"]
[null,null,null,null,null,null,2005,2004,"Invalid closing year"]
[null,null,null,null,null,null,2006,2005,"Invalid closing year"]
[null,null,null,null,null,null,2007,2006,"Invalid closing year"]
[null,null,null,null,null,null,2008,2007,"Invalid closing year"]
[null,null,null,null,null,null,2009,2008,"Invalid closing year"]
[null,null,null,null,null,null,2010,2009,"Invalid closing year"]
[null,null,null,null,null,null,2011,2010,"Invalid closing year"]
[null,null,null,null,null,null,2012,2011,"Invalid closing year"]
[null,null,null,null,null,null,2013,2012,"Invalid closing year"]
[null,null,null,null,null,null,2014,2013,"Invalid closing year"]
[null,null,null,null,null,null,2015,2014,2012]
[null,null,null,null,null,null,2016,2015,"Invalid closing year"]
[null,null,null,null,null,null,2017,2016,"Invalid closing year"]
[null,null,null,null,null,null,2018,2017,2015]
[null,null,null,null,null,null,2019,2018,"Invalid closing year"]
[null,null,null,null,null,null,2020,2019,{"$f":"IF(AND(G23>=2018,MOD(G23,3)=0),G23-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2021,2020,{"$f":"G24-3","v":2018}]
[null,null,null,null,null,null,2022,2021,"Invalid closing year"]
[null,null,null,null,null,null,2023,2022,"Invalid closing year"]
[null,null,null,null,null,null,2024,2023,{"$f":"G27-3","v":2021}]
[null,null,null,null,null,null,2025,2024,"Invalid closing year"]
[null,null,null,null,null,null,2026,2025,"Invalid closing year"]
[null,null,null,null,null,null,2027,2026,{"$f":"G30-4","v":2023}]
[null,null,null,null,null,null,2028,2027,"Invalid closing year"]
[null,null,null,null,null,null,2029,2028,"Invalid closing year"]
[null,null,null,null,null,null,2030,2029,{"$f":"G33-3","v":2027}]
[null,null,null,null,null,null,2031,2030,"Invalid closing year"]
[null,null,null,null,null,null,2032,2031,"Invalid closing year"]
[null,null,null,null,null,null,2033,2032,{"$f":"G36-3","v":2030}]
[null,null,null,null,null,null,2034,2033,"Invalid closing year"]
[null,null,null,null,null,null,2035,2034,"Invalid closing year"]
[null,null,null,null,null,null,2036,2035,{"$f":"G39-3","v":2033}]
[null,null,null,null,null,null,2037,2036,"Invalid closing year"]
[null,null,null,null,null,null,2038,2037,"Invalid closing year"]
[null,null,null,null,null,null,2039,2038,{"$f":"G42-3","v":2036}]
[null,null,null,null,null,null,2040,2039,"Invalid closing year"]
[null,null,null,null,null,null,2041,2040,"Invalid closing year"]
[null,null,null,null,null,null,2042,2041,{"$f":"G45-3","v":2039}]
[null,null,null,null,null,null,2043,2042,"Invalid closing year"]
[null,null,null,null,null,null,2044,2043,"Invalid closing year"]
[null,null,null,null,null,null,2045,2044,{"$f":"G48-3","v":2042}]
[null,null,null,null,null,null,2046,2045,"Invalid closing year"]
[null,null,null,null,null,null,2047,2046,"Invalid closing year"]
[null,null,null,null,null,null,2048,2047,{"$f":"G51-3","v":2045}]
[null,null,null,null,null,null,2049,2048,"Invalid closing year"]
[null,null,null,null,null,null,2050,2049,"Invalid closing year"]
[null,null,null,null,null,null,2051,2050,{"$f":"G54-3","v":2048}]
[null,null,null,null,null,null,2052,2051,"Invalid closing year"]
[null,null,null,null,null,null,2053,2052,"Invalid closing year"]
[null,null,null,null,null,null,2054,2053,{"$f":"G57-3","v":2051}]
[null,null,null,null,null,null,2055,2054,"Invalid closing year"]
[null,null,null,null,null,null,2056,2055,"Invalid closing year"]
[null,null,null,null,null,null,2057,2056,{"$f":"G60-3","v":2054}]
[null,null,null,null,null,null,2058,2057,"Invalid closing year"]
[null,null,null,null,null,null,2059,2058,"Invalid closing year"]
[null,null,null,null,null,null,2060,2059,{"$f":"G63-3","v":2057}]
[null,null,null,null,null,null,2061,2060,"Invalid closing year"]
[null,null,null,null,null,null,2062,2061,"Invalid closing year"]
[null,null,null,null,null,null,2063,2062,{"$f":"G66-3","v":2060}]
[null,null,null,null,null,null,2064,2063,"Invalid closing year"]
[null,null,null,null,null,null,2065,{"$f":"G68-1","v":2064},"Invalid closing year"]
[null,null,null,null,null,null,2066,2065,{"$f":"G69-3","v":2063}]
[null,null,null,null,null,null,2067,2066,"Invalid closing year"]
[null,null,null,null,null,null,2068,2067,{"$f":"IF(AND(G71>=2018,MOD(G71,3)=0),G71-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2069,2068,{"$f":"G72-3","v":2066}]
[null,null,null,null,null,null,2070,2069,"Invalid closing year"]
[null,null,null,null,null,null,2071,2070,{"$f":"IF(AND(G74>=2018,MOD(G74,3)=0),G74-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2072,2071,{"$f":"G75-3","v":2069}]
[null,null,null,null,null,null,2073,2072,"Invalid closing year"]
[null,null,null,null,null,null,2074,2073,{"$f":"IF(AND(G77>=2018,MOD(G77,3)=0),G77-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2075,2074,{"$f":"G78-3","v":2072}]
[null,null,null,null,null,null,2076,2075,"Invalid closing year"]
[null,null,null,null,null,null,2077,2076,{"$f":"IF(AND(G80>=2018,MOD(G80,3)=0),G80-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2078,2077,{"$f":"G81-3","v":2075}]
[null,null,null,null,null,null,2079,2078,"Invalid closing year"]
[null,null,null,null,null,null,2080,2079,{"$f":"IF(AND(G83>=2018,MOD(G83,3)=0),G83-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2081,2080,{"$f":"G84-3","v":2078}]
[null,null,null,null,null,null,2082,2081,"Invalid closing year"]
[null,null,null,null,null,null,2083,2082,{"$f":"IF(AND(G86>=2018,MOD(G86,3)=0),G86-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2084,2083,{"$f":"G87-3","v":2081}]
[null,null,null,null,null,null,2085,2084,"Invalid closing year"]
[null,null,null,null,null,null,2086,2085,{"$f":"IF(AND(G89>=2018,MOD(G89,3)=0),G89-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2087,2086,{"$f":"G90-3","v":2084}]
[null,null,null,null,null,null,2088,2087,"Invalid closing year"]
[null,null,null,null,null,null,2089,2088,{"$f":"IF(AND(G92>=2018,MOD(G92,3)=0),G92-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2090,2089,{"$f":"G93-3","v":2087}]
[null,null,null,null,null,null,2091,2090,"Invalid closing year"]
[null,null,null,null,null,null,2092,2091,{"$f":"IF(AND(G95>=2018,MOD(G95,3)=0),G95-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2093,2092,{"$f":"G96-3","v":2090}]
[null,null,null,null,null,null,2094,2093,"Invalid closing year"]
[null,null,null,null,null,null,2095,2094,{"$f":"IF(AND(G98>=2018,MOD(G98,3)=0),G98-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2096,2095,{"$f":"G99-3","v":2093}]
[null,null,null,null,null,null,2097,2096,"Invalid closing year"]
[null,null,null,null,null,null,2098,2097,{"$f":"IF(AND(G101>=2018,MOD(G101,3)=0),G101-2,\"Invalid closing year\")","v":"Invalid closing year"}]
[null,null,null,null,null,null,2099,2098,{"$f":"G102-3","v":2096}]
[null,null,null,null,null,null,2100,2099,"Invalid closing year"]

{"sheet":"Locks","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To"]
["Table 1 (Level 1 + 2)","G13","S13",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G20","S20",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G23","S23",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G30","S30",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G34","S34",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G38","S38",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G41","S41",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G44","S44",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G48","S48",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G52","S52",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G57","S57",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G68","S69",1,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","W8","W69",1,999,"Formulas","G8"]

{"sheet":"MustNotBeNegative","index":7,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 (Level 1 + 2)","G8","S69",1,4]
["Error","Table 2 (Conversion matrix)","G11","S23",999,1]

{"sheet":"IsNumeric","index":8,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 (Level 1 + 2)","G8","W69",1,4]
["Error","Table 2 (Conversion matrix)","H11","S11",999,1]
["Error","Table 2 (Conversion matrix)","I12","S12",999,1]
["Error","Table 2 (Conversion matrix)","J13","S13",999,1]
["Error","Table 2 (Conversion matrix)","K14","S14",999,1]
["Error","Table 2 (Conversion matrix)","L15","S15",999,1]
["Error","Table 2 (Conversion matrix)","M16","S16",999,1]
["Error","Table 2 (Conversion matrix)","N17","S17",999,1]
["Error","Table 2 (Conversion matrix)","O18","S18",999,1]
["Error","Table 2 (Conversion matrix)","P19","S19",999,1]
["Error","Table 2 (Conversion matrix)","Q20","S20",999,1]
["Error","Table 2 (Conversion matrix)","R21","S21",999,1]
["Error","Table 2 (Conversion matrix)","G12","G12",999,999]
["Error","Table 2 (Conversion matrix)","G13","H13",999,1]
["Error","Table 2 (Conversion matrix)","G14","I14",999,1]
["Error","Table 2 (Conversion matrix)","G15","J15",999,1]
["Error","Table 2 (Conversion matrix)","G16","K16",999,1]
["Error","Table 2 (Conversion matrix)","G17","L17",999,1]
["Error","Table 2 (Conversion matrix)","G18","M18",999,1]
["Error","Table 2 (Conversion matrix)","G19","N19",999,1]
["Error","Table 2 (Conversion matrix)","G20","O20",999,1]
["Error","Table 2 (Conversion matrix)","G21","P21",999,1]
["Error","Table 2 (Conversion matrix)","G22","Q22",999,1]
["Error","Table 2 (Conversion matrix)","G23","S23",999,1]

{"sheet":"Summations","index":9,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":true,"merged":[[38,5,38,6]]}
["Severity","Sheet Name","List of Cells\n (first block)","First Total Cell (first block)","Last Total Cell\n(Last block)","Row Block Repetition Step","Column Block Repetition Step","Greater or Equal","Valid Tolerance","Only if all data is available","Non compliance Is Valid If Footnote Exists","Footnote Shift From Value","Display text in error"]
["Error","Table 1 (Level 1 + 2)","G8,G9,G10,G11,G12","G13","W13",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G14,G15,G16,G17,G18,G19","G20","W20",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G21,G22","G23","W23",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G24,G25,G26,G27,G28,G29","G30","W30",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G31,G32,G33","G34","W38",4,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G39,G40","G41","W44",3,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G45,G46,G47","G48","W52",4,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G53,G54,G55,G56","G57","W57",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G58,G59,G60,G61,G62,G63,G64,G65,G66,G67","G68","W58",999,12,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68","G69","W69",999,12,"EQ",0.1,"YES","NO",3,"TOTAL must be the sum of all 12 ecosystem types"]
["Error","Table 1 (Level 1 + 2)","G8,G9,G10,G11,G12","G13","W13",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G14,G15,G16,G17,G18,G19","G20","W20",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G21,G22","G23","W23",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G24,G25,G26,G27,G28,G29","G30","W30",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G31,G32,G33","G34","W38",4,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G39,G40","G41","W44",3,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G45,G46,G47","G48","W52",4,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G53,G54,G55,G56","G57","W57",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G58,G59,G60,G61,G62,G63,G64,G65,G66,G67","G68","W58",999,12,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68","G69","W69",999,12,"GE",0.1,"NO","NO",3,"TOTAL must be the sum of all 12 ecosystem types"]
["Error","Table 2 (Conversion matrix)","G11,G12,G13,G14,G15,G16,G17,G18,G19,G20,G21,G22","G23","R23",999,1,"EQ",1,"YES","NO",3,"TOTAL ADDITIONS must be equal to the sum of additions"]
["Error","Table 2 (Conversion matrix)","G11,H11,I11,J11,K11,L11,M11,N11,O11,P11,Q11,R11","S11","S22",1,999,"EQ",1,"YES","NO",3,"TOTAL REDUCTIONS must be equal to the sum of reductions"]
["Error","Table 2 (Conversion matrix)","G26","G23","R23",999,1,"EQ",1000,"NO","NO",3,"TOTAL ADDITIONS in Table 2 for a given ecosystem type must be close to additions at level 1 in Table 1"]
["Error","Table 2 (Conversion matrix)","T11","S11","S22",1,999,"EQ",1000,"NO","NO",3,"TOTAL REDUCTIONS in Table 2 for a given ecosystem type must be close to reductions at level 1 in Table 1"]
[]
["Error","Table 1 (Level 1 + 2)","G8,G9,G10,G11,G12","G13","W13",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G14,G15,G16,G17,G18,G19","G20","W20",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G21,G22","G23","W23",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G24,G25,G26,G27,G28,G29","G30","W30",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G31,G32,G33","G34","W38",4,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G39,G40","G41","W44",3,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G45,G46,G47","G48","W52",4,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G53,G54,G55,G56","G57","W57",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G58,G59,G60,G61,G62,G63,G64,G65,G66,G67","G68","W58",999,4,"GE",0.1,"YES","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68","G69","W69",999,4,"GE",0.1,"YES","NO",3,"TOTAL must be the sum of all 12 ecosystems"]
[]
[]
[null,null,null,null,null,"Must be > 0 for a not relevant dimension. Else you get an infinite loop",null,"EQ or GE or GT","GT does not admit Tolerance","NO or YES",null,"Not Applicable if the previous column is \"NO\""]
[]
["DESCRIPTION"]
["This sheet is meant to define the validation for summations in a row or in a column."]
["- A block is defined as a sequence of addendums in the same row or column"]
["- Only the first block must be explicitly defined"]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]

{"sheet":"Mandatory","index":10,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Empty Is Valid If Footnote Exists","Footnote Shift From Value"]
["Error","GETTING STARTED","E9","E13",2,999,"NO",999]
["Error","GETTING STARTED","D19","D19",999,999,"NO",999]
["Error","GETTING STARTED","D27","D27",999,999,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G13","S13",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G20","S20",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G23","S23",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G30","S30",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G34","S34",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G38","S38",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G41","S41",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G44","S44",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G48","S48",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G52","S52",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G57","S57",999,4,"NO",999]
["Warning","Table 1 (Level 1 + 2)","G68","S68",999,4,"NO",999]
["Warning","Table 2 (Conversion matrix)","H11","R11",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","I12","R12",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","J13","R13",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","K14","R14",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","L15","R15",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","M16","R16",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","N17","R17",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","O18","R18",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","P19","R19",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","Q20","R20",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","R21","R21",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G12","G12",999,999,"NO",999]
["Warning","Table 2 (Conversion matrix)","G13","H13",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G14","I14",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G15","J15",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G16","K16",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G17","L17",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G18","M18",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G19","N19",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G20","O20",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G21","P21",999,1,"NO",999]
["Warning","Table 2 (Conversion matrix)","G22","Q22",999,1,"NO",999]

{"sheet":"Table 3 (Level 3)","index":11,"n_rows":140,"n_cols":8,"rows_kept":140,"cut":false,"hidden":true,"merged":[[90,0,97,0],[91,1,93,1],[94,1,97,1],[98,1,99,1],[100,1,102,1],[59,0,89,0],[59,1,68,1],[69,1,77,1],[78,1,84,1],[85,1,87,1],[50,0,58,0],[50,1,51,1],[52,1,58,1],[7,0,24,0],[7,1,8,1],[9,1,10,1],[11,1,17,1],[18,1,20,1],[21,1,24,1],[25,0,49,0],[25,1,34,1],[36,1,43,1],[44,1,45,1],[47,1,49,1],[134,2,135,2],[98,0,103,0],[104,0,112,0],[113,0,114,0],[128,1,129,1],[130,1,131,1],[130,0,139,0],[134,1,135,1],[104,1,106,1],[107,1,112,1],[115,0,117,0],[118,0,121,0],[122,0,129,0],[123,1,125,1],[126,1,127,1]]}
["Table 3 - Ecosystem extent accounts level 3 only"]
["Reporting unit = ",null,null,"1000 ha"]
["Reference year ="]
["Previous reference year = "]
["Items in bold are mandatory to be reported."]
[]
["EU ecosystem typology: level 1 ","EU ecosystem typology: level 2","EU Ecosystem typology: level 3","Opening area (Extent in the previous reference year)","Additions","Reductions","Net changes (additions less reductions; +/-)","Closing area (Extent in the current reference year)"]
["1. Settlements and other artificial areas","1.1   Continuous settlement area","1.1.1 Continuous residential area"]
[null,null,"1.1.2 Continuous commercial and industrial area"]
[null,"1.2   Discontinuous settlement area","1.2.1 Discontinuous residential area"]
[null,null,"1.2.2 Discontinuous commercial and industrial area"]
[null,"1.3   Infrastructure ","1.3.1 Road and rail networks and associated land "]
[null,null,"1.3.2 Port areas "]
[null,null,"1.3.3 Airports"]
[null,null,"1.3.4 Other infrastructure (e.g. water purification plants, energy plants, transforming stations)."]
[null,null,"1.3.5 Mineral extraction sites (excluding peat extraction sites, see 7.3.1)"]
[null,null,"1.3.6 Dump areas"]
[null,null,"1.3.7 Construction sites"]
[null,"1.4   Urban greenspace","1.4.1 Parks (including Zoos and botanical gardens)"]
[null,null,"1.4.2 Sports and recreation sites"]
[null,null,"1.4.3 Other urban green  "]
[null,"1.5   Other artificial areas","1.5.1. Permanent greenhouses"]
[null,null,"1.5.2 Cemeteries"]
[null,null,"1.5.3 Archaeological sites"]
[null,null,"1.5.4 Urban blue"]
["2. Cropland","2.1 Annual cropland ","2.1.1 Cereals excluding rice (C1000) excluding maize (C1500)"]
[null,null,"2.1.2 Maize (C1500 + G3000)"]
[null,null,"2.1.3 Dry pulses and protein crops (P0000)"]
[null,null,"2.1.4 Root crops (R0000)"]
[null,null,"2.1.5 Vegetables (including melons) and strawberries (V0000_S0000)"]
[null,null,"2.1.6 Industrial crops including annual bioenergy crops (I0000)"]
[null,null,"2.1.7 Flowers and ornamental plants (N0000)"]
[null,null,"2.1.8 Fallow land (Q0000)"]
[null,null,"2.1.9 Temporary grasses and grazing areas (G1000)"]
[null,null,"2.1.10 Other crops (further categories may be added by Member States, depending upon nationally important crop types)."]
[null,"2.2 Rice fields","2.2.1 Rice fields (C2000)"]
[null,"2.3 Permanent crops","2.3.1 Olives (O1000)"]
[null,null,"2.3.2 Grapes (W1000)"]
[null,null,"2.3.3 Pome fruits (F1100) "]
[null,null,"2.3.4 Stone fruits (F1200)  "]
[null,null,"2.3.5 Berries excluding strawberries (F3000)"]
[null,null,"2.3.6 Citrus fruits (T1000)"]
[null,null,"2.3.7 Nuts (F4000)"]
[null,null,"2.3.8 Other perennial crops and orchards"]
[null,"2.4 Agro-forestry areas ","2.4.1 Holm and cork oak forests"]
[null,null,"2.4.2 Other agro-forestry areas"]
[null,"2.5 Mixed farmland","2.5.1 Mosaic farmland (comprising cropland, grassland and (semi-)natural components)"]
[null,"2.6 Other farmland","2.6.1 Nurseries"]
[null,null,"2.6.2 Christmas tree plantations"]
[null,null,"2.6.3 Perennial bioenergy crops"]
["3. Grassland (pastures, semi-natural and natural grasslands)","3.1 Sown pastures and fields (modified grasslands) ","3.1.1 Sown pastures used for grazing"]
[null,null,"3.1.2 Sown grassland mown frequently for fodder or silage"]
[null,"3.2 Natural and semi-natural grasslands ","3.2.1 Dry grasslands "]
[null,null,"3.2.2 Seasonally wet and wet grasslands"]
[null,null,"3.2.3 Alpine and subalpine grasslands"]
[null,null,"3.2.4 Woodland fringes and clearings and tall forb stands"]
[null,null,"3.2.5 Inland salt steppes"]
[null,null,"3.2.6 Sparsely wooded grasslands"]
[null,null,"3.2.7 Mesophilous extensive grassland"]
["4. Forest and woodlands ","4.1 Broadleaved deciduous forest ","4.1.1 Riparian forest and woodland"]
[null,null,"4.1.2 Broadleaved swamp woodland on non-acid and acid"]
[null,null,"peat"]
[null,null,"4.1.3 Fagus dominated forest"]
[null,null,"4.1.4 Submediterranean and Mediterranean thermophilous deciduous forest "]
[null,null,"4.1.5 Acidophilous [Quercus]-"]
[null,null,"dominated woodland"]
[null,null,"4.1.6 Temperate and boreal and Southern European Betula and Populus tremula forest on mineral soils "]
[null,null,"4.1.7 Other broadleaved deciduous forest, excluding highly-modified plantations"]
[null,null,"4.1.8 Highly modified broadleaved deciduous forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.2 Coniferous forests ","4.2.1 Boreal and temperate  fir and spruce forest"]
[null,null,"4.2.2 Mediterranean mountain fir and spruce forest"]
[null,null,"4.2.3 Temperate subalpine Larix, Pinus cembra and Pinus uncinata forest"]
[null,null,"4.2.4 Pine forest (excluding mires, non-thermophilous)"]
[null,null,"4.2.5 Mediterranean thermophilous lowland pine forest  "]
[null,null,"4.2.6 Spruce, pine and larch mire forest "]
[null,null,"4.2.7 Taiga forests"]
[null,null,"4.2.8 Other coniferous forests, excluding plantations"]
[null,null,"4.2.9 Highly modified coniferous forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.3 Broadleaved evergreen forest ","4.3.1 Mediterranean evergreen Quercus forest"]
[null,null,"4.3.2 Mainland laurophyllous forest"]
[null,null,"4.3.3 Macaronesian laurophyllous forest"]
[null,null,"4.3.4 Olea europaea-Ceratonia siliqua forest"]
[null,null,"4.3.5 Palm groves"]
[null,null,"4.3.6 Other broadleaved evergreen forests"]
[null,null,"4.3.7 Highly modified broadleaved evergreen forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.4 Mixed forests","4.4.1 Mixed forests dominated by coniferous species"]
[null,null,"4.4.2 Mixed forests dominated by broadleaved species"]
[null,null,"4.4.3 Other mixed forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.5 Transitional forest and woodland shrub ","4.5.1 Transitional woodland/forest land "]
[null,"4.6 Plantations","4.6.1 Monoculture plantations of non-native tree species (note: forest stands of single or mixed species consisting of native and/or non-native trees species that have long been established in European ecosystems and have diverse undergrowth typical for forest ecosystems should be classified as part of types 4.1 to 4.4)"]
["5. Heathland and shrub ","5.1 Tundra","5.1.1 Tundra"]
[null,"5.2 Heathland and (sub-) alpine shrub","5.2.1 Arctic alpine, subalpine and lowland shrub and heathland"]
[null,null,"5.2.2 Temperate and Mediterranean montane and hilly shrub and heathland"]
[null,null,"5.2.3 Temperate and Mediterranean lowland shrub and heathland"]
[null,"5.3 Sclerophyllous vegetation","5.3.1 Maquis, arborescent matorral and thermo-Mediterranean shrub;  "]
[null,null,"5.3.2 Garrigue; "]
[null,null,"5.3.3 Spiny Mediterranean heaths (phrygana, hedgehog-heaths & coastal cliff vegetation);"]
[null,null,"5.3.4 Thermo-Atlantic xerophytic shrub (Madeira and Canary Islands)"]
["6. Sparsely vegetated ecosystems","6.1 Bare rocks","6.1.1 Rocky pavements, outcrops, and screes "]
[null,null,"6.1.2 Lava flows"]
[null,"6.2 Semi-desert, desert and other sparsely vegetated areas","6.2.1 Semi-desert steppes "]
[null,null,"6.2.2 Cool deserts and semi-desert steppes "]
[null,null,"6.2.3 Other sparsely vegetated areas"]
[null,"6.3 Ice sheets, glaciers and perennial snowfields","6.3.1 Ice sheets, glaciers and perennial snowfields"]
["7. Inland wetlands ","7.1 Inland marshes on mineral soil","7.1.1 Reedbeds"]
[null,null,"7.1.2 Inland salt marshes"]
[null,null,"7.1.3 Other marshland and water-fringing ecosystems"]
[null,"7.2 Mires, bogs and fens","7.2.1 Raised bogs "]
[null,null,"7.2.2 Blanket bogs"]
[null,null,"7.2.3 Valley mires, poor fens and transition mires "]
[null,null,"7.2.4 Aapa, palsa and polygon mires"]
[null,null,"7.2.5 Base-rich fens and calcareous spring mires"]
[null,null,"7.2.6 Peat extraction sites"]
["8. Rivers and canals","8.1 Rivers","8.1.1 Rivers"]
[null,"8.2 Canals, ditches and drains","8.2.1 Canals, ditches and drains"]
["9. Lakes and reservoirs","9.1 Lakes","9.1.1 Lakes"]
[null,"9.2 Artificial reservoirs","9.2.1 Artificial reservoirs"]
[null,"9.3 Geothermal pools and wetlands (Iceland)","9.3.1 Geothermal pools and wetlands (Iceland)"]
["10. Marine inlets and transitional waters ","10.1 Coastal lagoons","10.1.1 Coastal lagoons"]
[null,"10.2 Estuaries and bays ","10.2.1 Estuaries and bays "]
[null,"10.3 Intertidal flats","10.3.1 Intertidal flats (e.g., Wadden Sea)"]
[null,"10.4 Deepwater coastal inlets (fjords)","10.4.1 Deepwater coastal inlets (fjords)"]
["11. Coastal beaches, dunes and wetlands ","11.1 Artificial shorelines ","11.1.1 Artificial shorelines "]
[null,"11.2 Coastal dunes, beaches and sandy and muddy shores ","11.2.1 Coastal dunes"]
[null,null,"11.2.2 Beaches and sandy shores"]
[null,null,"11.2.3 Muddy shores"]
[null,"11.3 Rocky shores","11.3.1 Coastal shingle"]
[null,null,"11.3.2 Rock cliffs, ledges and shores"]
[null,"11.4 Coastal saltmarshes and salines","11.4.1 Coastal saltmarshes "]
[null,null,"11.4.2 Salines"]
["12. Marine ecosystems ","12.1 Marine macrophytes","12.1.1 Kelp forests"]
[null,null,"12.1.2 Seagrass meadows"]
[null,"12.2 Coral reefs ","12.2.1 Coral reefs "]
[null,"12.3 Shellfish beds and reefs","12.3.1 Shellfish beds and reefs"]
[null,"12.4 Subtidal sand beds and mud plains","12.4.1 Subtidal sand beds and mud plains"]
[]
[null,"12.5 Subtidal rocky substrates","12.5.1 Subtidal rocky substrates"]
[null,"12.6 Continental and island slopes","12.6.1 Continental and island slopes"]
[null,"12.7 Deepwater benthic and pelagic ecosystems","12.7.1 Deepwater benthic and pelagic ecosystems"]
[null,"12.8 Sea ice","12.8.1 Sea ice"]