Submitted data error checks
0. Instructions for submitters
Submitters should use this file to check for problems with submitted data. Send either a list of problems or confirmation that everything looks OK to Sasha by email. Be sure to reference the dataset version and file creation date/time when doing so. These are:
## Version: 2.47## [1] "Date/time: 2024-04-04 14:51:54.312193"Each of these html files contains a summary of the data from a single submitted spreadsheet file. The html name is based on the name of the submitted file. Use the details below to check:
- Institute abbreviation, submitter and contributor names
- The plot location(s), using the map zoom and pan features if needed
- For problems in the first sections; “OK” means there are no problems in a particular section, “warning” is something that should be checked (but might be OK), “error” is a problem that needs to be addressed
- For numeric values outside the expected range in the “Value checks” section
- Variables with missing values–are there any missing that you thought you included?
- Plots of flux, cumulative emission over time, and final cumulative emission for strange patterns, unexpectedly high or low values
- Plots of weather data for appropriate differences between plots and expected diurnal or other patterns
- Plots of manure and application data for correct values
Finally, the numeric summary at the end might provide details that can help in pinpointing problems, but typically does not need to be checked.
1. Submitter
| inst.abbrev | submitter | version | date |
|---|---|---|---|
| AU | Jesper Nørlem Kamp | 3+ | 28 June 2023 |
2. Contributors
| contributor | institute |
|---|---|
| Huijsmans, Jan | Wageningen University and Research, Wageningen, The Netherlands |
| Pacholski, Andreas | Thünen Institute for Climate-Smart Agriculture, Braunschweig, Germany |
| Götze, Hannah | Thünen Institute for Climate-Smart Agriculture, Braunschweig, Germany |
| van Boheemen, Koen | Wageningen University and Research, Wageningen, The Netherlands |
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx"4. Location
5.Keys and codes
Codes in Treatments sheet
## OK## OKCodes in Plots sheet
## OK## OKCodes in Emission sheet
## OK## OKCode merge check (matching project, experiment, field, plot, treatment)
## OK## OK## OK## OK## OK6. Publication info
Check for missing codes
## OK## OKComplete citations given
## OK## OK7. Emission sheet
Duplicated intervals
## OKMissing incorporation time
## OKDelay after application
## OKMissing or double interval number
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMissing time between intervals
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| bLS | 68 |
| DTM | 109 |
| Dynamic chamber | 44 |
| IHF | 8 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| chamber | 153 |
| micro met | 76 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit | |
|---|---|---|---|
| 1 | ug NH3/m2/s | 0.0296079 | kg N/ha-hr |
| 37 | kg N/ha-hr | 1.0000000 | kg N/ha-hr |
7. Value checks
Check to see if submitted values are within a reasonable range.
Weather
## wind : OK
## rain.rate : OK
## air.temp : OK
## soil.temp : No values to check.
## soil.temp.surf : No values to check.
## air.temp.z : OK
## wind.z : No values to check.Manure and application
## man.stor : No values to check.
## man.dm : OK
## man.vs : No values to check.
## man.tkn : OK
## man.tan : OK
## man.tic : No values to check.
## man.ua : No values to check.
## man.vfa : OK
## man.ph : OK
## app.rate : OK
## crop.z : OKEmission
## j.NH3 : OK
## e.int : OK
## e.rel : OK8. Missing values
Check for missing values.
All variables
## Some values missing:
## Table below has number of missing observations by variable:
## pub.id meas.tech.det silt sand oc
## 229 109 84 84 145
## soil.type soil.water.v soil.moist man.source.det man.bed
## 229 229 145 84 229
## man.trt2 man.trt3 man.stor man.vs man.tic
## 229 229 229 229 229
## man.ua man.vfa time.incorp dist.inj furrow.z
## 229 84 229 229 229
## furrow.w crop.area lai notes.plot bg.dl
## 229 229 229 145 229
## bg.val bg.unit pH.surf air.temp air.temp.z
## 177 177 229 44 44
## soil.temp soil.temp.z soil.temp.surf rad wind
## 229 229 229 229 44
## wind.z MOL ustar rl air.pres
## 229 229 229 229 229
## air.pres.unit rh wind.loc far.loc notes.int
## 229 229 229 229 120
## wind.2m pub.info soil.type2 exper2 rep2
## 229 229 229 229 229Application method and measurement method
## OK## OK9. Plots
Calculated cumulative emission
Cumulative emission. Missing values imputed (linear interpolation). Numeric labels show position of data in data file: row in the “Plots” sheet and first row in the “Emission” sheet. Labels in center of the first plot have measurement method, manure source, and application method. The same emission data are plotted a few different ways to facilitate checking for problems, e.g., comparing plot to each other or checking application dates. The same colors should be be used for particular field plots throughout this section.
Final cumulative emission
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.
Relative versus absolute emission
Flux
Weather data
## Warning: Removed 44 rows containing missing values or values outside the scale range
## (`geom_line()`).## Warning: Removed 44 rows containing missing values or values outside the scale range
## (`geom_point()`).
## Warning: Removed 44 rows containing missing values or values outside the scale range
## (`geom_line()`).
## Removed 44 rows containing missing values or values outside the scale range
## (`geom_point()`).
Manure and application
10. dfsumm summary
Plot-level data
##
## 14 rows and 175 columns
## 14 unique rows
## pub.id proj exper
## Class logical character character
## Minimum <NA> eGylle eGylle2
## Maximum <NA> eGylle eGylle3
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 0 1 2
## Missing values 14 0 0
## Sorted <NA> TRUE TRUE
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle2.F:FoulumgårdD.P:1.T:eGylle_bLS_Alpha1.R:1.R2:.T:2021-08-20 10:58:00.M:bLSAlpha samplers
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle3.F:WUR.P:1.T:eGylle_IHF.R:1.R2:.T:2021-11-09 10:15:00.M:IHFAcid traps
## Mean <NA>
## Unique (excld. NA) 14
## Missing values 0
## Sorted TRUE
##
## field plot rep plot.area lat long
## Class character numeric numeric numeric numeric numeric
## Minimum FoulumgårdD 1 1 778 52 5.65
## Maximum WUR 1 1 1540 56.5 9.56
## Mean <NA> 1 1 1270 53.6 7.04
## Unique (excld. NA) 2 1 1 2 2 2
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE FALSE FALSE
##
## country topo soil.samp.z clay silt sand
## Class character character numeric numeric numeric numeric
## Minimum DK Flat 9 9 24 65
## Maximum NL Flat 16 16 24 65
## Mean <NA> <NA> 13.5 13.5 24 65
## Unique (excld. NA) 2 1 2 2 1 1
## Missing values 0 0 0 0 9 9
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class numeric logical numeric logical character numeric
## Minimum 3.5 <NA> 0.21 <NA> wet 5.24
## Maximum 3.5 <NA> 0.49 <NA> wet 5.5
## Mean 3.5 <NA> 0.39 <NA> <NA> 5.41
## Unique (excld. NA) 1 0 2 0 1 2
## Missing values 5 14 0 14 5 0
## Sorted TRUE <NA> TRUE <NA> TRUE TRUE
##
## soil.dens crop.res till man.source
## Class numeric character character character
## Minimum 0.98 Yes No cat
## Maximum 1.38 Yes No mix
## Mean 1.12 <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 2
## Missing values 0 0 0 0
## Sorted FALSE TRUE TRUE FALSE
##
## man.source.det
## Class character
## Minimum Primarily cattle slurry, but also some pig slurry and silage
## Maximum Primarily cattle slurry, but also some pig slurry and silage
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 9
## Sorted TRUE
##
## man.bed man.con man.trt1 man.trt2 man.trt3
## Class logical character character logical logical
## Minimum <NA> Slurry Anaerobic digestion <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 2 0 0
## Missing values 14 0 0 14 14
## Sorted <NA> TRUE TRUE <NA> <NA>
##
## man.stor man.dm man.vs man.tkn man.tan man.tic man.ua
## Class logical numeric logical numeric numeric logical logical
## Minimum <NA> 4.95 <NA> 2.8 1.73 <NA> <NA>
## Maximum <NA> 6.78 <NA> 3.48 1.95 <NA> <NA>
## Mean <NA> 6.13 <NA> 3.24 1.81 <NA> <NA>
## Unique (excld. NA) 0 2 0 2 2 0 0
## Missing values 14 0 14 0 0 14 14
## Sorted <NA> TRUE <NA> TRUE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 0.3 7.7 2021-08-20 10:58:00 2021-08-20 10:58:00
## Maximum 0.3 7.9 2021-11-09 10:15:00 2021-11-09 10:20:00
## Mean 0.3 7.77 2021-10-11 12:13:12 2021-10-11 12:16:25
## Unique (excld. NA) 1 2 2 2
## Missing values 9 0 0 0
## Sorted TRUE FALSE TRUE TRUE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 17.5 t/ha none <NA>
## Maximum os 35.9 t/ha none <NA>
## Mean <NA> 24.1 <NA> <NA> <NA>
## Unique (excld. NA) 2 2 1 1 0
## Missing values 0 0 0 0 14
## Sorted TRUE FALSE TRUE TRUE <NA>
##
## man.area dist.inj furrow.z furrow.w crop crop.z
## Class numeric logical logical logical character numeric
## Minimum 26.6 <NA> <NA> <NA> grass 7
## Maximum 39.8 <NA> <NA> <NA> stubble 7.6
## Mean 31.3 <NA> <NA> <NA> <NA> 7.39
## Unique (excld. NA) 2 0 0 0 2 2
## Missing values 0 14 14 14 0 0
## Sorted FALSE <NA> <NA> <NA> FALSE TRUE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 6 AU
## Mean <NA> <NA> <NA> 5.64 <NA>
## Unique (excld. NA) 0 0 1 2 1
## Missing values 14 14 5 0 0
## Sorted <NA> <NA> TRUE TRUE TRUE
##
## sub.period
## Class numeric
## Minimum 3
## Maximum 3
## Mean 3
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## treat meas.tech meas.tech.det
## Class character character character
## Minimum eGylle_bLS_acid_traps_0.25m bLS Acid traps
## Maximum eGylle_IHF IHF CRDS avg.
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 14 4 3
## Missing values 0 0 3
## Sorted FALSE FALSE FALSE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 09/11/2021 10:15 09/11/2021 10:20
## Maximum 20/08/2021 10:58 20/08/2021 10:58
## Mean <NA> <NA>
## Unique (excld. NA) 2 2
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle2.F:FoulumgårdD.P:1.T:eGylle_bLS_Alpha1.R:1.R2:.T:2021-08-20 10:58:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle3.F:WUR.P:1.T:eGylle_IHF.R:1.R2:.T:2021-11-09 10:15:00
## Mean <NA>
## Unique (excld. NA) 14
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter
## Class character character character
## Minimum D:1.I:AU.Pr:eGylle.E:eGylle2 Jesper Nørlem Kamp
## Maximum D:1.I:AU.Pr:eGylle.E:eGylle3 Jesper Nørlem Kamp
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## tan.app e.1 e.4 e.6 e.12 e.24 e.48
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 30.2 0.0941 0.488 0.752 1.25 1.62 1.94
## Maximum 70 0.209 2.15 3.02 18.5 20.6 23.2
## Mean 44.4 0.126 1.1 1.57 4.37 5.62 6.9
## Unique (excld. NA) 2 4 12 12 14 14 14
## Missing values 0 10 2 2 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.72 e.96 e.168 e.final e.tot e.cum.1 e.cum.4
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 2.42 2.42 10.4 2.42 2.42 0.0941 0.488
## Maximum 24.8 25.5 26.5 26.7 26.7 0.209 2.15
## Mean 7.8 8.37 16.8 8.97 8.97 0.126 1.1
## Unique (excld. NA) 14 14 5 14 14 4 12
## Missing values 0 0 9 0 0 10 2
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.cum.6 e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.752 1.25 1.62 1.94 2.42 2.42
## Maximum 3.02 18.5 20.6 23.2 24.8 25.5
## Mean 1.57 4.37 5.62 6.9 7.8 8.37
## Unique (excld. NA) 12 14 14 14 14 14
## Missing values 2 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.cum.168 e.cum.final e.cum.tot e.rel.1 e.rel.4 e.rel.6
## Class numeric numeric numeric numeric numeric numeric
## Minimum 10.4 2.42 2.42 0.00311 0.0161 0.0249
## Maximum 26.5 26.7 26.7 0.00693 0.0376 0.0517
## Mean 16.8 8.97 8.97 0.00418 0.027 0.0385
## Unique (excld. NA) 5 14 14 4 12 12
## Missing values 9 0 0 10 2 2
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.rel.12 e.rel.24 e.rel.48 e.rel.72 e.rel.96 e.rel.168
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.0415 0.0537 0.0641 0.0801 0.0801 0.149
## Maximum 0.264 0.294 0.331 0.355 0.365 0.379
## Mean 0.0812 0.108 0.135 0.156 0.17 0.24
## Unique (excld. NA) 14 14 14 14 14 5
## Missing values 0 0 0 0 0 9
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.rel.final e.rel.tot rain.1 rain.4 rain.6 rain.12
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.0801 0.0801 0 0 0 0
## Maximum 0.382 0.382 0 0 0 0
## Mean 0.184 0.184 0 0 0 0
## Unique (excld. NA) 14 14 1 1 1 1
## Missing values 0 0 10 2 2 0
## Sorted FALSE FALSE TRUE TRUE TRUE TRUE
##
## rain.24 rain.48 rain.72 rain.96 rain.168 rain.final rain.tot
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0 0 0 0 0 0 0
## Maximum 0 0 0 0 0 0 0
## Mean 0 0 0 0 0 0 0
## Unique (excld. NA) 1 1 1 1 1 1 1
## Missing values 0 0 0 0 9 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE TRUE
##
## air.temp.1 air.temp.4 air.temp.6 air.temp.12 air.temp.24
## Class numeric numeric numeric numeric numeric
## Minimum <NA> 9.3 9.3 9.97 7.03
## Maximum <NA> 16.1 16.5 16.5 13.4
## Mean <NA> 11.8 12 13.2 10.2
## Unique (excld. NA) 0 2 4 5 5
## Missing values 14 6 6 4 4
## Sorted <NA> FALSE FALSE FALSE FALSE
##
## air.temp.48 air.temp.72 air.temp.96 air.temp.168 air.temp.mn
## Class numeric numeric numeric numeric numeric
## Minimum 7.29 7.41 7.41 7.5 7.5
## Maximum 13.3 13.5 14.1 14.7 21.4
## Mean 10.3 10.5 10.7 11.1 13.8
## Unique (excld. NA) 6 6 6 6 6
## Missing values 4 4 4 4 4
## Sorted FALSE FALSE FALSE FALSE FALSE
##
## wind.1 wind.4 wind.6 wind.12 wind.24 wind.48 wind.72
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum <NA> 2.72 2.72 2.5 1.54 1.31 1.35
## Maximum <NA> 2.73 3 3.18 1.88 1.42 1.42
## Mean <NA> 2.72 2.82 2.83 1.69 1.36 1.39
## Unique (excld. NA) 0 2 4 5 5 6 6
## Missing values 14 6 6 4 4 4 4
## Sorted <NA> FALSE FALSE FALSE FALSE FALSE FALSE
##
## wind.96 wind.168 wind.mn rain.rate.1 rain.rate.4 rain.rate.6
## Class numeric numeric numeric numeric numeric numeric
## Minimum 1.23 1.78 1.78 0 0 0
## Maximum 1.42 2.11 3.32 0 0 0
## Mean 1.33 1.94 2.51 0 0 0
## Unique (excld. NA) 6 6 6 1 1 1
## Missing values 4 4 4 10 2 2
## Sorted FALSE FALSE FALSE TRUE TRUE TRUE
##
## rain.rate.12 rain.rate.24 rain.rate.48 rain.rate.72
## Class numeric numeric numeric numeric
## Minimum 0 0 0 0
## Maximum 0 0 0 0
## Mean 0 0 0 0
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## rain.rate.96 rain.rate.168 rain.rate.mn
## Class numeric numeric numeric
## Minimum 0 0 0
## Maximum 0 0 0
## Mean 0 0 0
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## first.row.in.file.int last.row.in.file.int n.ints dt1
## Class numeric numeric integer numeric
## Minimum 5 22 8 0.983
## Maximum 237 244 37 7.1
## Mean 145 160 16.4 2.22
## Unique (excld. NA) 14 14 5 6
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## j.rel1 j.NH31 dt.min dt.max ct.min ct.max
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.00309 0.0933 0.983 18.2 0.983 96.6
## Maximum 0.0356 2.49 7.1 25.9 7.1 238
## Mean 0.00977 0.543 2.15 23.6 2.22 162
## Unique (excld. NA) 14 14 6 5 6 6
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## t.start.p t.end.p air.temp.z
## Class POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 2021-08-20 11:05:00 2021-08-28 13:53:00 2
## Maximum 2021-11-09 10:20:00 2021-11-15 08:47:00 2
## Mean 2021-10-11 12:24:51 2021-10-17 09:00:21 2
## Unique (excld. NA) 6 7 1
## Missing values 0 0 4
## Sorted TRUE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc pub.info soil.type2
## Class logical logical logical logical logical logical
## Minimum <NA> <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> <NA> <NA> <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 0 0 0
## Missing values 14 14 14 14 14 14
## Sorted <NA> <NA> <NA> <NA> <NA> <NA>
##
## exper2 rep2 acid meas.tech.orig meas.tech2 crop.orig
## Class logical logical logical character character character
## Minimum <NA> <NA> FALSE bLS chamber Grass
## Maximum <NA> <NA> FALSE IHF micro met Stubble
## Mean <NA> <NA> 0 TRUE <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 4 2 2
## Missing values 14 14 0 0 0 0
## Sorted <NA> <NA> TRUE FALSE FALSE FALSE
##
## man.source.orig app.method.orig app.method2
## Class character character character
## Minimum Cattle Band spread or trailing hose bsth
## Maximum Mix Open slot injection os
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 2 2
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
##
## incorp.orig date.start
## Class character Date
## Minimum None 2021-08-20
## Maximum None 2021-11-09
## Mean <NA> <NA>
## Unique (excld. NA) 1 2
## Missing values 0 0
## Sorted TRUE TRUE
## Interval-level emission data
##
## 229 rows and 139 columns
## 229 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle2.F:FoulumgårdD.P:1.T:eGylle_bLS_Alpha1.R:1.R2:.T:2021-08-20 10:58:00.M:bLSAlpha samplers
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle3.F:WUR.P:1.T:eGylle_IHF.R:1.R2:.T:2021-11-09 10:15:00.M:IHFAcid traps
## Mean <NA>
## Unique (excld. NA) 14
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class logical character character character numeric numeric
## Minimum <NA> eGylle eGylle2 FoulumgårdD 1 1
## Maximum <NA> eGylle eGylle3 WUR 1 1
## Mean <NA> <NA> <NA> <NA> 1 1
## Unique (excld. NA) 0 1 2 2 1 1
## Missing values 229 0 0 0 0 0
## Sorted <NA> TRUE TRUE TRUE TRUE TRUE
##
## treat meas.tech meas.tech.det
## Class character character character
## Minimum eGylle_bLS_acid_traps_0.25m bLS Acid traps
## Maximum eGylle_IHF IHF CRDS avg.
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 14 4 3
## Missing values 0 0 109
## Sorted FALSE FALSE FALSE
##
## plot.area lat long country topo soil.samp.z
## Class numeric numeric numeric character character numeric
## Minimum 778 52 5.65 DK Flat 9
## Maximum 1540 56.5 9.56 NL Flat 16
## Mean 1060 54.8 8.13 <NA> <NA> 11.6
## Unique (excld. NA) 2 2 2 2 1 2
## Missing values 0 0 0 0 0 0
## Sorted TRUE FALSE FALSE TRUE TRUE TRUE
##
## clay silt sand oc soil.type soil.water
## Class numeric numeric numeric numeric logical numeric
## Minimum 9 24 65 3.5 <NA> 0.21
## Maximum 16 24 65 3.5 <NA> 0.49
## Mean 11.6 24 65 3.5 <NA> 0.313
## Unique (excld. NA) 2 1 1 1 0 2
## Missing values 0 84 84 145 229 0
## Sorted TRUE TRUE TRUE TRUE <NA> TRUE
##
## soil.water.v soil.moist soil.ph soil.dens crop.res
## Class logical character numeric numeric character
## Minimum <NA> wet 5.24 0.98 Yes
## Maximum <NA> wet 5.5 1.38 Yes
## Mean <NA> <NA> 5.34 1.23 <NA>
## Unique (excld. NA) 0 1 2 2 1
## Missing values 229 145 0 0 0
## Sorted <NA> TRUE TRUE FALSE TRUE
##
## till man.source
## Class character character
## Minimum No cat
## Maximum No mix
## Mean <NA> <NA>
## Unique (excld. NA) 1 2
## Missing values 0 0
## Sorted TRUE FALSE
##
## man.source.det
## Class character
## Minimum Primarily cattle slurry, but also some pig slurry and silage
## Maximum Primarily cattle slurry, but also some pig slurry and silage
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 84
## Sorted TRUE
##
## man.bed man.con man.trt1 man.trt2 man.trt3
## Class logical character character logical logical
## Minimum <NA> Slurry Anaerobic digestion <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 2 0 0
## Missing values 229 0 0 229 229
## Sorted <NA> TRUE TRUE <NA> <NA>
##
## man.stor man.dm man.vs man.tkn man.tan man.tic man.ua
## Class logical numeric logical numeric numeric logical logical
## Minimum <NA> 4.95 <NA> 2.8 1.73 <NA> <NA>
## Maximum <NA> 6.78 <NA> 3.48 1.95 <NA> <NA>
## Mean <NA> 5.62 <NA> 3.05 1.87 <NA> <NA>
## Unique (excld. NA) 0 2 0 2 2 0 0
## Missing values 229 0 229 0 0 229 229
## Sorted <NA> TRUE <NA> TRUE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 0.3 7.7 2021-08-20 10:58:00 2021-08-20 10:58:00
## Maximum 0.3 7.9 2021-11-09 10:15:00 2021-11-09 10:20:00
## Mean 0.3 7.83 2021-09-19 03:47:12 2021-09-19 03:49:02
## Unique (excld. NA) 1 2 2 2
## Missing values 84 0 0 0
## Sorted TRUE FALSE TRUE TRUE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 17.5 t/ha none <NA>
## Maximum os 35.9 t/ha none <NA>
## Mean <NA> 29.2 <NA> <NA> <NA>
## Unique (excld. NA) 2 2 1 1 0
## Missing values 0 0 0 0 229
## Sorted TRUE FALSE TRUE TRUE <NA>
##
## man.area dist.inj furrow.z furrow.w crop crop.z
## Class numeric logical logical logical character numeric
## Minimum 26.6 <NA> <NA> <NA> grass 7
## Maximum 39.8 <NA> <NA> <NA> stubble 7.6
## Mean 35 <NA> <NA> <NA> <NA> 7.22
## Unique (excld. NA) 2 0 0 0 2 2
## Missing values 0 229 229 229 0 0
## Sorted FALSE <NA> <NA> <NA> FALSE TRUE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 6 AU
## Mean <NA> <NA> <NA> 5.37 <NA>
## Unique (excld. NA) 0 0 1 2 1
## Missing values 229 229 145 0 0
## Sorted <NA> <NA> TRUE TRUE TRUE
##
## sub.period
## Class numeric
## Minimum 3
## Maximum 3
## Mean 3
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 09/11/2021 10:15 09/11/2021 10:20
## Maximum 20/08/2021 10:58 20/08/2021 10:58
## Mean <NA> <NA>
## Unique (excld. NA) 2 2
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle2.F:FoulumgårdD.P:1.T:eGylle_bLS_Alpha1.R:1.R2:.T:2021-08-20 10:58:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_7_0_eGylle_NL_DE_JK.xlsx.E:eGylle3.F:WUR.P:1.T:eGylle_IHF.R:1.R2:.T:2021-11-09 10:15:00
## Mean <NA>
## Unique (excld. NA) 14
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter
## Class character character character
## Minimum D:1.I:AU.Pr:eGylle.E:eGylle2 Jesper Nørlem Kamp
## Maximum D:1.I:AU.Pr:eGylle.E:eGylle3 Jesper Nørlem Kamp
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## tan.app interval t.start t.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 30.2 1 2021-08-20 11:05:00 2021-08-20 13:40:00
## Maximum 70 37 2021-11-15 08:47:00 2021-11-16 08:47:00
## Mean 55.4 12.3 2021-09-22 02:03:55 2021-09-22 11:59:06
## Unique (excld. NA) 2 37 159 160
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## dt bg.dl bg.val bg.unit j.NH3 j.NH3.unit
## Class numeric logical numeric character numeric character
## Minimum 0.983 <NA> -0.477 mg NH3 /m3 -0.00169 kg N/ha-hr
## Maximum 25.9 <NA> 30.2 mg NH3 /m3 2.49 kg N/ha-hr
## Mean 9.92 <NA> 4.35 <NA> 0.0951 <NA>
## Unique (excld. NA) 101 0 34 1 187 1
## Missing values 0 229 177 177 0 0
## Sorted FALSE <NA> FALSE TRUE FALSE TRUE
##
## pH.surf air.temp air.temp.z soil.temp soil.temp.z
## Class logical numeric numeric numeric logical
## Minimum <NA> 5.92 2 <NA> <NA>
## Maximum <NA> 21.2 2 <NA> <NA>
## Mean <NA> 14.1 2 <NA> <NA>
## Unique (excld. NA) 0 62 1 0 0
## Missing values 229 44 44 229 229
## Sorted <NA> FALSE TRUE <NA> <NA>
##
## soil.temp.surf rad wind wind.z MOL ustar
## Class logical logical numeric logical logical logical
## Minimum <NA> <NA> 0.367 <NA> <NA> <NA>
## Maximum <NA> <NA> 4.69 <NA> <NA> <NA>
## Mean <NA> <NA> 2.32 <NA> <NA> <NA>
## Unique (excld. NA) 0 0 62 0 0 0
## Missing values 229 229 44 229 229 229
## Sorted <NA> <NA> FALSE <NA> <NA> <NA>
##
## rl air.pres air.pres.unit rain rh wind.loc
## Class logical logical logical numeric logical logical
## Minimum <NA> <NA> <NA> 0 <NA> <NA>
## Maximum <NA> <NA> <NA> 0 <NA> <NA>
## Mean <NA> <NA> <NA> 0 <NA> <NA>
## Unique (excld. NA) 0 0 0 1 0 0
## Missing values 229 229 229 0 229 229
## Sorted <NA> <NA> <NA> TRUE <NA> <NA>
##
## far.loc
## Class logical
## Minimum <NA>
## Maximum <NA>
## Mean <NA>
## Unique (excld. NA) 0
## Missing values 229
## Sorted <NA>
##
## notes.int
## Class character
## Minimum Spot sample in time with no 'duration' at start of interval
## Maximum Spot sample in time with no 'duration' at start of interval
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 120
## Sorted TRUE
##
## row.in.file.int j.type fromemis t.start.orig
## Class numeric character numeric character
## Minimum 5 emission rate 1 09/11/2021 10:20
## Maximum 244 emission rate 1 29/08/2021 08:15
## Mean 123 <NA> 1 <NA>
## Unique (excld. NA) 229 1 1 159
## Missing values 0 0 0 0
## Sorted FALSE TRUE TRUE FALSE
##
## t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class character character numeric numeric
## Minimum 09/11/2021 10:20 kg N/ha-hr -0.0572 0.0296
## Maximum 29/08/2021 08:15 ug NH3/m2/s 84.2 1
## Mean <NA> <NA> 1.98 0.491
## Unique (excld. NA) 159 2 187 2
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## dt.calc dt.diff ct mt cta bta flag.int
## Class numeric numeric numeric numeric numeric numeric character
## Minimum 0.983 -0.05 0.983 0.492 1.07 0.0833
## Maximum 25.8 0.05 238 226 238 213
## Mean 9.92 0.004 79.9 74.9 80.2 70.3 <NA>
## Unique (excld. NA) 114 18 148 152 160 159 1
## Missing values 0 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE TRUE
##
## rain.rate rain.cum wind.2m e.int e.cum e e.rel
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0 0 <NA> -0.0262 0.0917 0.0917 0.00304
## Maximum 0 0 <NA> 17.7 26.7 26.7 0.382
## Mean 0 0 <NA> 0.549 8.95 8.95 0.146
## Unique (excld. NA) 1 1 0 180 191 191 191
## Missing values 0 0 229 0 0 0 0
## Sorted TRUE TRUE <NA> FALSE FALSE FALSE FALSE
##
## j.rel pub.info soil.type2 exper2 rep2 acid
## Class numeric logical logical logical logical logical
## Minimum -2.42e-05 <NA> <NA> <NA> <NA> FALSE
## Maximum 0.0356 <NA> <NA> <NA> <NA> FALSE
## Mean 0.00193 <NA> <NA> <NA> <NA> 0 TRUE
## Unique (excld. NA) 187 0 0 0 0 1
## Missing values 0 229 229 229 229 0
## Sorted FALSE <NA> <NA> <NA> <NA> TRUE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum bLS chamber Grass Cattle
## Maximum IHF micro met Stubble Mix
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 4 2 2 2
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.method.orig app.method2 incorp.orig
## Class character character character
## Minimum Band spread or trailing hose bsth None
## Maximum Open slot injection os None
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 2 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## date.start first.row.int row.plot first.rows
## Class Date numeric numeric factor
## Minimum 2021-08-20 5 5 Plots 5 Emis. 117
## Maximum 2021-08-20 237 6 Plots 6 Emis. 237
## Mean <NA> 111 5.37 Plots 6 Emis. 153
## Unique (excld. NA) 1 14 2 14
## Missing values 0 0 0 0
## Sorted TRUE FALSE TRUE FALSE
##
## ggplotgroup
## Class numeric
## Minimum 1
## Maximum 1
## Mean 1
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##