{"text_format":"3","workbook":"xls","n_sheets":14,"sheets":["METADATA","STATION","METHOD","DATA","Ref_STYPE","Ref_SUBPROG","Ref_AREA","Ref_TLEVEL","Ref_SUBST","Ref_MEDIUM","Ref_UNIT","Ref_FLAGQUA","Ref_FLAGSTA","Tabelle4"],"not_rendered":{"images":1,"external_links":1,"defined_names":12},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"METADATA","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"merged":[[5,0,5,2],[7,0,7,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2]],"flags":["formulas_cached_only"]}
[]
[null,"eLTER (H2020)"]
[null,"H2020-funded project, GA: 654359, INFRAIA call 2014-2015"]
[]
[]
["eLTER Data submission"]
[]
["For the eLTER project data on meteorology, vegetation and deposition are collected for the vTA. This includes physical or chemical analysis (e.g. meteorology or air quality) as well as vegetation observation data. \n\nThe data are open and will be used for cross domain and cross site analysis. The data use is defined by the vTA schema\n"]
[]
["IND_NAME"]
["ORG_NAME","Forschungszentrum Jülich GmbH"]
["EMAIL","h.bogena@fz-juelich.de"]
["DATE OF PUBLICATION","2017-03-16"]
["DATA VERSION",1]
["COMMENTS"]

{"sheet":"STATION","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"flags":["formulas_cached_only"]}
["STATION"]
["SCODE","STYPE","westBoundingCoordinate","eastBoundingCoordinate","northBoundingCoordinate","southBoundingCoordinate","altitudeMinimum","altitudeMaximum"]
["stat. code","spatial type","Longitude [decimal degree]","Longitude [decimal degree]","Latitude [decimal degree]","Latitude [decimal degree]","[m a.sl.]","[m a.s.l.]"]
["M","M","C","C","C","C","C","C"]
["name or code for the plot from which the data are reported, left blank if this is not important for the data reporting","PT … point\nHLN … horizontal transect\nVLN … vertical transect\nPL … areal plot","conditional - if different from the site/platform\nbounding box for station in decimal degree WGS84\n\n\n\n7.88749","conditional - if different from the site/platform\nbounding box for station in decimal degree WGS84\n\n\n\n7.93573","conditional - if different from the site/platform\nbounding box for station in decimal degree WGS84\n\n\n\n45.34080","conditional - if different from the site/platform\nbounding box for station in decimal degree WGS84\n\n\n\n45.31461","conditional - if different from the site/platform\nminimum altitude for the observed station, negative if below water level\n\n265","conditional - if different from the site/platform\nmaximum altitude for the observed station, negative if below the water level\n\n270"]
["LTER_EU_DE_013","PT",6.433,null,50.58,null,610]
["LTER_EU_DE_013","PT",6.433,null,50.58,null,610]

{"sheet":"METHOD","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"flags":["formulas_cached_only"]}
["METHOD"]
["CODE","SAMPLING","FIELD_METHOD","LAB_METHOD","AGG_METHOD"]
[]
["Short code for the method to be used in the data submission page; will be used for the drop-down list in the data submission page","sampling method - how the observation sites were selected; e.g. random or stratfied","field method - method applied in the field to collect the data; e.g. sampler, vegetation relevée","lab method - e.g. pretreatment and analysis method","description of the aggregation procedure"]
["Weather station","continuous","Air",null,"10 minute average"]
["Weather station","continuous","Air",null,"10 minute average"]

{"sheet":"DATA","index":3,"n_rows":7,"n_cols":27,"rows_kept":7,"flags":["formulas_cached_only"]}
["eLTER BaseData submission"]
[]
["SUBPROG","SITE_CODE","ORG_NAME","SCODE","MEDIUM","LISTMED","MAX_LEVEL","MIN_LEVEL","SIZE","YEAR","MONTH","DAY","HOUR","MINUTE","SECOND","SPOOL","TPOOL","TLEVEL","TAXA","LISTTAXA","SUBST","LISTSUB","METHOD_CODE","VALUE","UNIT","FLAGQUA","FLAGSTA"]
["code","name","code","code","code","listcode","number [cm]","number [cm]","number [m²]","YYYY","MM","DD","HH","MM","SS","number","number","code","code","listcode","code","listcode","code","number","code","code","code"]
["M","M","M","M","M","M","M","M","M","M","C","C","C","C","C","C","C","C","C","C","M","M","M","M","M",null,"M"]
["Sub programme; e.g. BIOCHEM","Site code (e.g. LTER_EU_AT_003) or Site UUID (e.g. https://data.lter-europe.net/deims/site/0ce0d289-9ef9-4232-a981-8f34869db76d)","name of the organisation, e.g. EAA","Code for the station, e.g. IP1","code for the sampled medium, e.g. SOIL","Codelist for medium, e.g. EnvEurope","measurement level from, e.g. -5","measurement level to, e.g. -10","size of sampling plot in m², e.g. 2","obs. Year, e.g. 2011","obs. Month, e.g. 1","obs. Day","obs. Hour, if necessary","obs. Minunte, if necessary","obs. Second, if necessary","spatial pool of sampling units used for the aggregation, e.g. 5","temporal pool of values used for the aggregation; e.g. 10","level of temporal aggregation; e.g. month","taxa observed, e.g. FAG SYLV","code list for taxa, e.g. B4","parameter name, e.g. TEMP    ","codelist for parameter name, e.g. DB","code for the method as defined in \"METHOD\", e.g. METH_1","value of observation, e.g. 5","unit of observation, e.g. °C        ","quality flag for observation, e.g. -","status flag on how the data were aggregated"]
["see CSV file"]

{"sheet":"Ref_STYPE","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"flags":["formulas_cached_only"]}
["STYPE","Station type","Example"]
["PT","point observation","Sampling point"]
["HLN","horizontal transect observed","transect"]
["VLN","vertical transect observed","depth gradient"]
["PL","area observed","vegetation plot"]

{"sheet":"Ref_SUBPROG","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"flags":["formulas_cached_only"]}
["SUBPROG","Explanation"]
["BIOCHEM","biogeochemistry data"]
["STRUCTU","Structure and function of ecosystems, communities and populations"]
["HUMANEC","human population and economy"]
["SITECHA","site characteristics (land use and land cover)"]

{"sheet":"Ref_AREA","index":6,"n_rows":1,"n_cols":24,"rows_kept":1,"flags":["formulas_cached_only"]}
["UUID","LTER_EU_Site_Code","SiteName","Country","EnvEurope_Group","Checked","Note","Char_Biogeographic_Region","Elevation_avg","FocEcosys1","FocEcosys2","FocEcosys3","Loc_Country","Loc_DEG_X_ETRS89_GEO","Loc_DEG_Y_ETRS89_GEO","LTER_Declaration_Status","LTER_Site_Status","LTER_Site_Type","Actor","Organisation","email","Phone","Role","OBJEKT_ID"]

{"sheet":"Ref_TLEVEL","index":7,"n_rows":8,"n_cols":4,"rows_kept":8,"flags":["formulas_cached_only"]}
["TLEVEL","Explenation","Duration","Exmple"]
["HOUR","aggregated on the level of a hour","60 minutes"]
["DAY","aggregated on the level of a day","24 hours"]
["WEEK","aggregated on the level of a week","7 days"]
["MONTH","aggregated on the level of a month","21, 30 or 31 days"]
["SEASON","aggregated on the level of a season","3 Month","spring, summer, autumn, winter"]
["HYEAR","aggregated on the level of a half year","6 month"]
["YEAR","aggregated on the level of a year","12 month"]

{"sheet":"Ref_SUBST","index":8,"n_rows":107,"n_cols":8,"rows_kept":107,"flags":["formulas_cached_only"]}
["LISTSUB","SUBST","Name","Description","Group","CAS Code","included/changed"]
["*","AB","abundace of","groups; to be specified by user; to be described in the metadata",10," ","2000-06-16 15:39:00.000"]
["DB","ALK     ","Alkalinity"," ",10," ","2000-06-16 15:39:00.000"]
["*","BIOMASS","biomass of ","groups; to be specified by user; to be described in the metadata",10," ","2000-06-16 15:39:00.000"]
["DB","BOD     ","Biochemical oxygen demand","Essential to state incubation time - see pretreatment list: Incubation.",10," ","2000-06-16 15:39:00.000"]
["DB","BPP     ","Biological primary production net"," ",10," ","2000-06-16 15:39:00.000"]
["DB","BPY     ","Biological primary productivity net"," ",10," ","2000-06-16 15:39:00.000"]
["DB","CODCR   ","Chemical oxygen demand COD-Cr"," ",10," ","2000-08-14 15:23:00.000"]
["DB","CODMN   ","Chemical oxygen demand COD-Mn"," ",10," ","2000-08-14 15:23:00.000"]
["DB","COND    ","Conductivity"," ",10," ","2000-06-16 15:39:00.000"]
["IM","COVE_B","spccies cover bottom layer","mean cover of layer/species (%) in the bottom layer per vegetation plot; byrophytes and lichens",10," ","2000-06-16 15:39:00.000"]
["IM","COVE_F","spccies cover field layer","mean cover of layer/species (%) in the field layer per vegetation plot; trees and shrubs <1m and other plants irrespective of height",10," ","2000-06-16 15:39:00.000"]
["IM","COVE_S","spccies cover shrub layer","mean cover of layer/species (%) in the shrub layer per vegetation plot; trees 1-5m, morphological shrubs >1m",10," ","2000-06-16 15:39:00.000"]
["IM","COVE_T","spccies cover tree layer","mean cover of layer/species (%) in the tree layer per vegetation plot; trees >5m",10," ","2000-06-16 15:39:00.000"]
["DB","CP      ","Chlorophyll a"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DC      ","Dissolved carbon"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DEPTHB  ","Depth of sampling from bottom"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DEPTHS  ","Depth of sampling from surface"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DEPTHT  ","Depth to bottom"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DIC     ","Dissolved inorganic carbon"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DISCH","Discharge"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DOC     ","Dissolved organic carbon"," ",10," ","2000-06-16 15:39:00.000"]
["DB","DOD     ","Direct oxygen demand"," ",10," ","2000-06-16 15:39:00.000"]
["DB","EH      ","Redox potential"," ",10," ","2000-08-14 15:24:00.000"]
["DB","FLOW    ","Flow"," ",10," ","2000-06-16 15:39:00.000"]
["*","HAGESTR","age structure","human population",10," ","2000-06-16 15:39:00.000"]
["*","HDENSITY","density","human population",10," ","2000-06-16 15:39:00.000"]
["*","HECONACT","main economic activity","human population",10," ","2000-06-16 15:39:00.000"]
["DB","HH      ","Humidity"," ",10," ","2000-06-16 15:39:00.000"]
["*","HINCOME","average income","human population",10," ","2000-06-16 15:39:00.000"]
["*","LANDCOV","land cover",null,10," ","2001-01-16T09:51:09"]
["*","LANDUSE","land use",null,30," ","2001-01-16T09:56:35"]
["DB","LDEP",null,"litterfall amount (oven dry weight)",30," ","2000-06-16 15:39:00.000","g/m2"]
["DB","LENGTH  ","Length"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NH3     ","Ammonia"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NH4     ","Ammonium"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NH4N    ","Ammonium as nitrogen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NKJ     ","Kjeldahl nitrogen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NO2     ","Nitrite"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NO23    ","Nitrite nitrate","Nitrite + nitrate",30," ","2000-06-16 15:39:00.000"]
["DB","NO23N   ","Nitrite nitrate as nitrogen","Nitrite + nitrate as nitrogen",30," ","2000-06-16 15:39:00.000"]
["DB","NO2N    ","Nitrite as nitrogen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NO3     ","Nitrate"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NO3N    ","Nitrate as nitrogen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NOXNDO  ","Nitrogen oxides as NO2"," ",30," ","2000-06-16 15:39:00.000"]
["DB","NTOT    ","Total nitrogen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","O2      ","Oxygen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","O2D     ","Dissolved oxygen"," ",30," ","2000-06-16 15:39:00.000"]
["DB","O2S     ","Oxygen saturation","The amount of oxygen dissolved in the water compared to what theoretically can be dissolved at the same temperature expressed in percent.",40," ","2000-06-16 15:39:00.000"]
["DB","P","Phosphorus",null,40," ","2000-06-16 15:39:00.000"]
["DB","PH      ","pH"," ",40," ","2000-06-16 15:39:00.000"]
["DB","PO4     ","Phosphate"," ",30," ","2000-06-16 15:39:00.000"]
["DB","PO4P    ","Phosphate as phosphorous"," ",30," ","2000-09-05 12:08:00.000"]
["DB","PREC    ","Precipitation"," ",10,null,"2001-12-07T12:34:10"]
["DB","PTOT    ","Total phosphorous"," "]
["DB","SDT     ","Secchi disc transparency"," ",30,null,"2002-10-18T14:59:18"]
["*","SPNB","number of species","groups; to be specified by user; to be described in the metadata"]
["DB","SS      ","Suspended solids"," "]
["DB","TC      ","Total carbon"," "]
["DB","TEMP    ","Temperature"," "]
["*","THP","total population in the site","human population"]
["DB","TIC     ","Total inorganic carbon"," "]
["DB","TOC     ","Total organic carbon"," "]
["DB","TOD     ","Total oxygen demand"," "]
["DB","TS      ","Total solids"," "]
["DB","TURB    ","Turbidity"," "]
["DB","WEIGHT","Weight"]
["DB","WL      ","Water level"," "]
["DB","WLL     ","Water level local level","Water level compared to a local point."]
["DB","WLS     ","Water level sea level","Water level compared to the sea."]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
["Add"]
[]
[]
[]
["DB"]
["*"]
["IM"]
["Add"]

{"sheet":"Ref_MEDIUM","index":9,"n_rows":20,"n_cols":3,"rows_kept":20,"flags":["formulas_cached_only"]}
["LISTMED","MEDIUM","Explanation"]
["EnvEurope","AIR","air including meteorlogy"]
["EnvEurope","BIOCOM","biological communities"]
["EnvEurope","HUMPOP","human population"]
["EnvEurope","LITTER","litterfall"]
["EnvEurope","SEDIMENT","sediments in aquatic envrionments"]
["EnvEurope","SITECHAR","site characteristics (as habitat or landscape structure)"]
["EnvEurope","SOIL","soil"]
["EnvEurope","SOILWAT","soil water"]
["EnvEurope","WATER","runoff and groundwater"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]
["EnvEurope"]

{"sheet":"Ref_UNIT","index":10,"n_rows":40,"n_cols":1,"rows_kept":40,"flags":["formulas_cached_only"]}
["UNIT"]
["%         "]
["ha    "]
["°C        "]
["cm"]
["CODE      "]
["DEGREES   "]
["eq/m²/yr"]
["g/m²      "]
["g/m²      "]
["ind/m²"]
["k"]
["kg/m³     "]
["l/(s*km²) "]
["m         "]
["m/s      "]
["m²/ha     "]
["m³"]
["ME/kg     "]
["mg C m³/d "]
["mg O2 m³/d"]
["mg/kg     "]
["mg/l      "]
["mg/m³     "]
["mm"]
["mS/m      "]
["N mg/l    "]
["N µg/m³   "]
["µg/m³     "]
["NUMBER    "]
["P µg/l    "]
["PT mg/l   "]
["S mg/l    "]
["S µg/m³   "]
["μg/(G*H)  "]
["μg/l "]
["μg/m³"]
["μmol/(G*H)"]
["W/m²"]
["YEARS     "]

{"sheet":"Ref_FLAGQUA","index":11,"n_rows":3,"n_cols":2,"rows_kept":3,"flags":["formulas_cached_only"]}
["FLAGQUA","Explenation"]
["L","less than detection limit"]
["E","estimated from measured value"]

{"sheet":"Ref_FLAGSTA","index":12,"n_rows":10,"n_cols":2,"rows_kept":10,"flags":["formulas_cached_only"]}
["FLAGSTA","Explenation"]
["X ","Arithmetic average, mean; e.g. monthly average"]
["W ","Weighted mean"]
["S ","Sum"]
["M ","Mode"]
["A","Minimum"]
["Z","Maximum"]
["XA","average monthly minimum"]
["XZ","average monthly maximum"]
["SZ","maximum daily sum"]

{"sheet":"Tabelle4","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}