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.58## [1] "Date/time: 2024-09-12 10:56:16.934407"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 | Pedersen, Johanna | 1 | 2024-09-01 |
2. Contributors
| contributor | institute |
|---|---|
| Pedersen, Johanna | Aarhus University |
| Hafner, Sasha | Aarhus University |
| Pacholski, Andreas | Thünen Institute |
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.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
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## 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
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Dynamic chamber | 15309 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| chamber | 15309 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit | |
|---|---|---|---|
| 1 | % applied TAN / min | 35.49 | kg N/ha-hr |
| 300 | % applied TAN / min | 25.41 | kg N/ha-hr |
| 2239 | kg N/ha-hr | 1.00 | kg N/ha-hr |
| 8886 | % applied TAN / min | 31.92 | kg N/ha-hr |
| 9011 | % applied TAN / min | 35.91 | kg N/ha-hr |
7. Value checks
Check to see if submitted values are within a reasonable range.
Weather
## wind : No values to check.
## rain.rate : OK
## air.temp : OK
## soil.temp : OK
## soil.temp.surf : No values to check.
## air.temp.z : OK
## wind.z : OKManure and application
## man.stor : No values to check.
## man.dm : OK
## man.vs : OK
## man.tkn : OK
## man.tan : OK
## man.tic : No values to check.
## man.ua : No values to check.
## man.vfa : No values to check.
## 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 oc soil.type soil.water.v
## 15309 15309 15309 15309 15309
## soil.moist man.source.det man.bed man.trt1 man.trt2
## 15309 1157 15309 1157 12861
## man.trt3 man.stor man.tic man.ua man.vfa
## 14924 15309 15309 15309 15309
## app.method time.incorp man.area dist.inj furrow.z
## 946 15309 15309 15309 15309
## furrow.w crop.area lai notes.plot bg.dl
## 15309 15309 15309 15159 15309
## pH.surf soil.temp soil.temp.z soil.temp.surf rad
## 15309 1360 1360 15309 15309
## wind MOL ustar rl air.pres
## 15309 15309 15309 15309 15309
## air.pres.unit rh wind.loc far.loc notes.int
## 15309 15309 15309 15309 15308
## wind.2m pub.info soil.type2 exper2 rep2
## 15309 15309 15309 15309 15309Application method and measurement method
## [1] "Missing app.method in some rows"## 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
Manure and application
10. dfsumm summary
Plot-level data
##
## 232 rows and 174 columns
## 232 unique rows
## pub.id proj exper
## Class logical character character
## Minimum <NA> MAG 24A
## Maximum <NA> MAG 24O
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 0 1 15
## Missing values 232 0 0
## Sorted <NA> TRUE TRUE
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24A.F:Foulumgård.P:1.T:Un30.R:1.R2:.T:2024-02-19 15:41:00.M:Dynamic chamberNA
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24O.F:Varde2.P:9.T:TS-TSB.R:1.R2:.T:2024-07-01 16:36:00.M:Dynamic chamberNA
## Mean <NA>
## Unique (excld. NA) 232
## Missing values 0
## Sorted TRUE
##
## field plot rep plot.area lat long
## Class character numeric numeric numeric numeric numeric
## Minimum Foulumgård 1 1 0.385 55.6 8.78
## Maximum Varde2 16 5 0.385 56.5 9.56
## Mean <NA> 8.39 2.33 0.385 56.4 9.45
## Unique (excld. NA) 3 16 5 1 3 3
## Missing values 0 0 0 0 0 0
## Sorted TRUE FALSE FALSE TRUE FALSE FALSE
##
## country topo soil.samp.z clay silt sand
## Class character character character numeric numeric numeric
## Minimum DK Flat 0-5 4.2 1.8 65
## Maximum DK Flat 0-5 9 24 90.3
## Mean <NA> <NA> <NA> 8.34 20.9 68.5
## Unique (excld. NA) 1 1 1 2 2 2
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE TRUE
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical logical numeric logical logical numeric
## Minimum <NA> <NA> 0.1 <NA> <NA> 4.93
## Maximum <NA> <NA> 0.29 <NA> <NA> 6.98
## Mean <NA> <NA> 0.23 <NA> <NA> 5.65
## Unique (excld. NA) 0 0 10 0 0 15
## Missing values 232 232 0 232 232 0
## Sorted <NA> <NA> FALSE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source
## Class numeric character character factor
## Minimum 1.04 Yes No cat
## Maximum 1.38 Yes No none
## Mean 1.21 <NA> <NA> mix
## Unique (excld. NA) 13 1 1 3
## Missing values 0 0 0 0
## Sorted FALSE TRUE TRUE FALSE
##
## man.source.det man.bed man.con
## Class character logical factor
## Minimum Slurry digested with other organic materials <NA> slurry
## Maximum Slurry digested with other organic materials <NA> solid
## Mean <NA> <NA> slurry
## Unique (excld. NA) 1 0 1
## Missing values 18 232 0
## Sorted TRUE <NA> TRUE
##
## man.trt1 man.trt2
## Class character character
## Minimum Anaerobic digestion Acidification
## Maximum Anaerobic digestion Mechanical separation
## Mean <NA> <NA>
## Unique (excld. NA) 1 2
## Missing values 18 199
## Sorted TRUE FALSE
##
## man.trt3 man.stor man.dm man.vs man.tkn
## Class character logical numeric numeric numeric
## Minimum Mechanical separation <NA> 1.72 1.1 1.79
## Maximum Mechanical separation <NA> 11.1 8.5 7.12
## Mean <NA> <NA> 4.35 3.13 2.91
## Unique (excld. NA) 1 0 35 31 34
## Missing values 226 232 0 0 0
## Sorted TRUE <NA> FALSE FALSE FALSE
##
## man.tan man.tic man.ua man.vfa man.ph app.start
## Class numeric logical logical logical numeric POSIXct, POSIXt
## Minimum 1.21 <NA> <NA> <NA> 6 2024-02-19 15:25:00
## Maximum 5.15 <NA> <NA> <NA> 8.52 2024-07-01 17:40:00
## Mean 1.96 <NA> <NA> <NA> 7.82 2024-04-25 19:11:57
## Unique (excld. NA) 32 0 0 0 30 232
## Missing values 0 232 232 232 0 0
## Sorted FALSE <NA> <NA> <NA> FALSE FALSE
##
## app.end app.method app.rate app.rate.unit
## Class POSIXct, POSIXt character numeric character
## Minimum 2024-03-06 09:37:00 bsth 12.5 m3/ha
## Maximum 2024-07-05 09:13:00 ts 36.7 t/ha
## Mean 2024-05-02 19:26:48 <NA> 29.4 <NA>
## Unique (excld. NA) 232 3 15 2
## Missing values 0 15 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## incorp time.incorp man.area dist.inj furrow.z furrow.w
## Class character numeric logical logical logical logical
## Minimum none <NA> <NA> <NA> <NA> <NA>
## Maximum none <NA> <NA> <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 0 0 0 0 0
## Missing values 0 232 232 232 232 232
## Sorted TRUE <NA> <NA> <NA> <NA> <NA>
##
## crop crop.z crop.area lai notes.plot
## Class character numeric numeric logical character
## Minimum cereal 6.5 <NA> <NA> .
## Maximum grass 37.5 <NA> <NA> .
## Mean <NA> 15.9 <NA> <NA> <NA>
## Unique (excld. NA) 2 14 0 0 1
## Missing values 0 0 232 232 231
## Sorted TRUE FALSE <NA> <NA> TRUE
##
## row.in.file.plot institute sub.period
## Class numeric character numeric
## Minimum 5 AU 3
## Maximum 236 AU 3
## Mean 120 <NA> 3
## Unique (excld. NA) 232 1 1
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## treat meas.tech meas.tech.det app.start.orig
## Class character character logical character
## Minimum 2-pos Dynamic chamber <NA> 01-05-2024 16:24
## Maximum Un30 Dynamic chamber <NA> 25-06-2024 16:08
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 35 1 0 232
## Missing values 0 0 232 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 01-05-2024 05:41
## Maximum 31-05-2024 08:12
## Mean <NA>
## Unique (excld. NA) 232
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24A.F:Foulumgård.P:1.T:Un30.R:1.R2:.T:2024-02-19 15:41:00
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24O.F:Varde2.P:9.T:TS-TSB.R:1.R2:.T:2024-07-01 16:36:00
## Mean <NA>
## Unique (excld. NA) 232
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:MAG.E:24A Pedersen, Johanna 42.4
## Maximum D:1.I:AU.Pr:MAG.E:24O Pedersen, Johanna 85.3
## Mean <NA> <NA> <NA> 53.8
## Unique (excld. NA) 15 1 1 35
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE
##
## e.1 e.4 e.6 e.12 e.24 e.48 e.72
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum <NA> -0.0794 -0.142 -0.365 -1.01 -2.71 -3.5
## Maximum <NA> 17.6 22.9 29.7 35.4 37.7 38.8
## Mean <NA> 3.35 4.36 6.04 8.34 10.6 11.7
## Unique (excld. NA) 0 232 232 232 232 232 232
## Missing values 232 0 0 0 0 0 0
## Sorted <NA> FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.96 e.168 e.final e.tot e.cum.1 e.cum.4 e.cum.6
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum -4.57 -5.8 -8.05 -8.05 <NA> -0.0794 -0.142
## Maximum 38.8 19.6 38.6 38.6 <NA> 17.6 22.9
## Mean 12.1 9.6 13.7 13.7 <NA> 3.35 4.36
## Unique (excld. NA) 216 45 232 232 0 232 232
## Missing values 16 187 0 0 232 0 0
## Sorted FALSE FALSE FALSE FALSE <NA> FALSE FALSE
##
## e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96 e.cum.168
## Class numeric numeric numeric numeric numeric numeric
## Minimum -0.365 -1.01 -2.71 -3.5 -4.57 -5.8
## Maximum 29.7 35.4 37.7 38.8 38.8 19.6
## Mean 6.04 8.34 10.6 11.7 12.1 9.6
## Unique (excld. NA) 232 232 232 232 216 45
## Missing values 0 0 0 0 16 187
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.cum.final e.cum.tot e.rel.1 e.rel.4 e.rel.6 e.rel.12
## Class numeric numeric numeric numeric numeric numeric
## Minimum -8.05 -8.05 <NA> -0.00187 -0.00335 -0.00861
## Maximum 38.6 38.6 <NA> 0.277 0.359 0.467
## Mean 13.7 13.7 <NA> 0.0604 0.0784 0.109
## Unique (excld. NA) 232 232 0 232 232 232
## Missing values 0 0 232 0 0 0
## Sorted FALSE FALSE <NA> FALSE FALSE FALSE
##
## e.rel.24 e.rel.48 e.rel.72 e.rel.96 e.rel.168 e.rel.final
## Class numeric numeric numeric numeric numeric numeric
## Minimum -0.0239 -0.064 -0.0827 -0.108 -0.137 -0.19
## Maximum 0.556 0.593 0.611 0.61 0.409 0.606
## Mean 0.15 0.191 0.211 0.22 0.188 0.248
## Unique (excld. NA) 232 232 232 216 45 232
## Missing values 0 0 0 16 187 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.rel.tot rain.1 rain.4 rain.6 rain.12 rain.24 rain.48
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum -0.19 <NA> 0 0 0 0 0
## Maximum 0.606 <NA> 0 0 0 0 0
## Mean 0.248 <NA> 0 0 0 0 0
## Unique (excld. NA) 232 0 1 1 1 1 1
## Missing values 0 232 0 0 0 0 0
## Sorted FALSE <NA> TRUE TRUE TRUE TRUE TRUE
##
## rain.72 rain.96 rain.168 rain.final rain.tot air.temp.1
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0 0 0 0 0 <NA>
## Maximum 0 0 0 0 0 <NA>
## Mean 0 0 0 0 0 <NA>
## Unique (excld. NA) 1 1 1 1 1 0
## Missing values 0 16 187 0 0 232
## Sorted TRUE TRUE TRUE TRUE TRUE <NA>
##
## air.temp.4 air.temp.6 air.temp.12 air.temp.24 air.temp.48
## Class numeric numeric numeric numeric numeric
## Minimum 2 1.55 1.88 2.11 0.772
## Maximum 22.9 22.8 22.3 19.4 20.4
## Mean 12 11.6 10.5 9.82 10.2
## Unique (excld. NA) 48 81 102 155 211
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE
##
## air.temp.72 air.temp.96 air.temp.168 air.temp.mn soil.temp.1
## Class numeric numeric numeric numeric numeric
## Minimum 0.646 0.673 1.71 1.71 <NA>
## Maximum 19.9 19 18 18 <NA>
## Mean 10.1 10.1 9.9 10.4 <NA>
## Unique (excld. NA) 223 226 231 231 0
## Missing values 0 0 0 0 232
## Sorted FALSE FALSE FALSE FALSE <NA>
##
## soil.temp.4 soil.temp.6 soil.temp.12 soil.temp.24
## Class numeric numeric numeric numeric
## Minimum 4.6 4.7 4.75 4.46
## Maximum 16.4 16.5 16.6 16.1
## Mean 9.6 9.71 9.73 9.43
## Unique (excld. NA) 34 58 60 98
## Missing values 32 32 32 32
## Sorted FALSE FALSE FALSE FALSE
##
## soil.temp.48 soil.temp.72 soil.temp.96 soil.temp.168
## Class numeric numeric numeric numeric
## Minimum 4.23 4.06 3.82 3.75
## Maximum 16 15.8 16 15.6
## Mean 9.55 9.65 9.72 9.74
## Unique (excld. NA) 139 162 169 184
## Missing values 32 32 32 32
## Sorted FALSE FALSE FALSE FALSE
##
## soil.temp.mn rain.rate.1 rain.rate.4 rain.rate.6
## Class numeric numeric numeric numeric
## Minimum 3.75 <NA> 0 0
## Maximum 17.3 <NA> 0 0
## Mean 10.4 <NA> 0 0
## Unique (excld. NA) 192 0 1 1
## Missing values 32 232 0 0
## Sorted FALSE <NA> 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 67 34 2.52
## Maximum 15200 15300 150 2.53
## Mean 6990 7050 66 2.53
## Unique (excld. NA) 232 232 16 2
## 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.000537 -0.0317 2.48 2.53 2.52 86.1
## Maximum 0.0818 5.06 2.52 12.7 2.53 380
## Mean 0.0176 0.974 2.52 3.69 2.53 168
## Unique (excld. NA) 232 232 2 5 2 16
## 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 2024-02-19 15:25:00 2024-03-06 07:05:00 2
## Maximum 2024-07-01 17:40:00 2024-07-05 06:41:00 2
## Mean 2024-04-25 19:11:57 2024-05-02 16:54:51 2
## Unique (excld. NA) 232 232 1
## Missing values 0 0 0
## Sorted FALSE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc pub.info soil.type2
## Class character numeric logical logical logical logical
## Minimum 0.1 2 <NA> <NA> <NA> <NA>
## Maximum 0.1 2 <NA> <NA> <NA> <NA>
## Mean <NA> 2 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 0 0 0 0
## Missing values 32 0 232 232 232 232
## Sorted TRUE TRUE <NA> <NA> <NA> <NA>
##
## exper2 rep2 acid meas.tech.orig
## Class logical logical logical character
## Minimum <NA> <NA> FALSE Dynamic chamber
## Maximum <NA> <NA> TRUE Dynamic chamber
## Mean <NA> <NA> 0.0344827586206897 TRUE <NA>
## Unique (excld. NA) 0 0 2 1
## Missing values 232 232 0 0
## Sorted <NA> <NA> FALSE TRUE
##
## meas.tech2 crop.orig app.method.orig
## Class character character character
## Minimum chamber Cereal Band spread or trailing hose
## Maximum chamber Grass Trailing shoe with harrowing tine
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 2 4
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## incorp.orig man.source.orig date.start
## Class character character Date
## Minimum None Cattle 2024-02-19
## Maximum None Pig 2024-07-01
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 3 15
## Missing values 0 0 0
## Sorted TRUE FALSE TRUE
## Interval-level emission data
##
## 15309 rows and 140 columns
## 15309 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24A.F:Foulumgård.P:1.T:Un30.R:1.R2:.T:2024-02-19 15:41:00.M:Dynamic chamberNA
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24O.F:Varde2.P:9.T:TS-TSB.R:1.R2:.T:2024-07-01 16:36:00.M:Dynamic chamberNA
## Mean <NA>
## Unique (excld. NA) 232
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class logical character character character numeric numeric
## Minimum <NA> MAG 24A Foulumgård 1 1
## Maximum <NA> MAG 24O Varde2 16 5
## Mean <NA> <NA> <NA> <NA> 8.37 2.29
## Unique (excld. NA) 0 1 15 3 16 5
## Missing values 15309 0 0 0 0 0
## Sorted <NA> TRUE TRUE TRUE FALSE FALSE
##
## treat meas.tech meas.tech.det plot.area lat
## Class character character logical numeric numeric
## Minimum 2-pos Dynamic chamber <NA> 0.385 55.6
## Maximum Un30 Dynamic chamber <NA> 0.385 56.5
## Mean <NA> <NA> <NA> 0.385 56.4
## Unique (excld. NA) 35 1 0 1 3
## Missing values 0 0 15309 0 0
## Sorted FALSE TRUE <NA> TRUE FALSE
##
## long country topo soil.samp.z clay silt
## Class numeric character character character numeric numeric
## Minimum 8.78 DK Flat 0-5 4.2 1.8
## Maximum 9.56 DK Flat 0-5 9 24
## Mean 9.49 <NA> <NA> <NA> 8.57 22
## Unique (excld. NA) 3 1 1 1 2 2
## Missing values 0 0 0 0 0 0
## Sorted FALSE TRUE TRUE TRUE FALSE FALSE
##
## sand oc soil.type soil.water soil.water.v soil.moist
## Class numeric logical logical numeric logical logical
## Minimum 65 <NA> <NA> 0.1 <NA> <NA>
## Maximum 90.3 <NA> <NA> 0.29 <NA> <NA>
## Mean 67.2 <NA> <NA> 0.235 <NA> <NA>
## Unique (excld. NA) 2 0 0 10 0 0
## Missing values 0 15309 15309 0 15309 15309
## Sorted TRUE <NA> <NA> FALSE <NA> <NA>
##
## soil.ph soil.dens crop.res till man.source
## Class numeric numeric character character factor
## Minimum 4.93 1.04 Yes No cat
## Maximum 6.98 1.38 Yes No none
## Mean 5.61 1.2 <NA> <NA> mix
## Unique (excld. NA) 15 13 1 1 3
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE TRUE TRUE FALSE
##
## man.source.det man.bed man.con
## Class character logical factor
## Minimum Slurry digested with other organic materials <NA> slurry
## Maximum Slurry digested with other organic materials <NA> solid
## Mean <NA> <NA> slurry
## Unique (excld. NA) 1 0 1
## Missing values 1157 15309 0
## Sorted TRUE <NA> TRUE
##
## man.trt1 man.trt2
## Class character character
## Minimum Anaerobic digestion Acidification
## Maximum Anaerobic digestion Mechanical separation
## Mean <NA> <NA>
## Unique (excld. NA) 1 2
## Missing values 1157 12861
## Sorted TRUE FALSE
##
## man.trt3 man.stor man.dm man.vs man.tkn
## Class character logical numeric numeric numeric
## Minimum Mechanical separation <NA> 1.72 1.1 1.79
## Maximum Mechanical separation <NA> 11.1 8.5 7.12
## Mean <NA> <NA> 4.12 2.99 2.77
## Unique (excld. NA) 1 0 35 31 34
## Missing values 14924 15309 0 0 0
## Sorted TRUE <NA> FALSE FALSE FALSE
##
## man.tan man.tic man.ua man.vfa man.ph app.start
## Class numeric logical logical logical numeric POSIXct, POSIXt
## Minimum 1.21 <NA> <NA> <NA> 6 2024-02-19 15:25:00
## Maximum 5.15 <NA> <NA> <NA> 8.52 2024-07-01 17:40:00
## Mean 1.88 <NA> <NA> <NA> 7.83 2024-04-18 02:43:31
## Unique (excld. NA) 32 0 0 0 30 232
## Missing values 0 15309 15309 15309 0 0
## Sorted FALSE <NA> <NA> <NA> FALSE FALSE
##
## app.end app.method app.rate app.rate.unit
## Class POSIXct, POSIXt character numeric character
## Minimum 2024-03-06 09:37:00 bsth 12.5 m3/ha
## Maximum 2024-07-05 09:13:00 ts 36.7 t/ha
## Mean 2024-04-26 00:05:25 <NA> 30.3 <NA>
## Unique (excld. NA) 232 3 15 2
## Missing values 0 946 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## incorp time.incorp man.area dist.inj furrow.z furrow.w
## Class character numeric logical logical logical logical
## Minimum none <NA> <NA> <NA> <NA> <NA>
## Maximum none <NA> <NA> <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 0 0 0 0 0
## Missing values 0 15309 15309 15309 15309 15309
## Sorted TRUE <NA> <NA> <NA> <NA> <NA>
##
## crop crop.z crop.area lai notes.plot
## Class character numeric numeric logical character
## Minimum cereal 6.5 <NA> <NA> .
## Maximum grass 37.5 <NA> <NA> .
## Mean <NA> 15.3 <NA> <NA> <NA>
## Unique (excld. NA) 2 14 0 0 1
## Missing values 0 0 15309 15309 15159
## Sorted TRUE FALSE <NA> <NA> TRUE
##
## row.in.file.plot institute sub.period
## Class numeric character numeric
## Minimum 5 AU 3
## Maximum 236 AU 3
## Mean 108 <NA> 3
## Unique (excld. NA) 232 1 1
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 01-05-2024 16:24 01-05-2024 05:41
## Maximum 25-06-2024 16:08 31-05-2024 08:12
## Mean <NA> <NA>
## Unique (excld. NA) 232 232
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24A.F:Foulumgård.P:1.T:Un30.R:1.R2:.T:2024-02-19 15:41:00
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_8.2_MAGspring24_240901.xlsx.E:24O.F:Varde2.P:9.T:TS-TSB.R:1.R2:.T:2024-07-01 16:36:00
## Mean <NA>
## Unique (excld. NA) 232
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:MAG.E:24A Pedersen, Johanna 42.4
## Maximum D:1.I:AU.Pr:MAG.E:24O Pedersen, Johanna 85.3
## Mean <NA> <NA> <NA> 53.5
## Unique (excld. NA) 15 1 1 35
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE
##
## interval t.start t.end dt
## Class numeric POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 1 2024-02-19 15:25:00 2024-02-19 17:57:00 2.48
## Maximum 150 2024-07-05 06:41:00 2024-07-05 09:13:00 12.7
## Mean 37.7 2024-04-22 00:23:56 2024-04-22 02:56:55 2.55
## Unique (excld. NA) 150 15309 15309 8
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## bg.dl bg.val bg.unit j.type j.NH3 j.NH3.unit
## Class logical numeric character character numeric character
## Minimum <NA> 0.00881 ppm emission rate -0.15 kg N/ha-hr
## Maximum <NA> 0.473 ppm emission rate 5.06 kg N/ha-hr
## Mean <NA> 0.0299 <NA> <NA> 0.0814 <NA>
## Unique (excld. NA) 0 1001 1 1 15309 1
## Missing values 15309 0 0 0 0 0
## Sorted <NA> FALSE TRUE TRUE FALSE TRUE
##
## pH.surf air.temp air.temp.z soil.temp soil.temp.z
## Class logical numeric numeric numeric character
## Minimum <NA> -3.2 2 2.8 0.1
## Maximum <NA> 26.8 2 17.6 0.1
## Mean <NA> 9.3 2 9.43 <NA>
## Unique (excld. NA) 0 260 1 148 1
## Missing values 15309 0 0 1360 1360
## Sorted <NA> FALSE TRUE FALSE TRUE
##
## soil.temp.surf rad wind wind.z MOL ustar
## Class logical logical logical numeric logical logical
## Minimum <NA> <NA> <NA> 2 <NA> <NA>
## Maximum <NA> <NA> <NA> 2 <NA> <NA>
## Mean <NA> <NA> <NA> 2 <NA> <NA>
## Unique (excld. NA) 0 0 0 1 0 0
## Missing values 15309 15309 15309 0 15309 15309
## Sorted <NA> <NA> <NA> TRUE <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 15309 15309 15309 0 15309 15309
## Sorted <NA> <NA> <NA> TRUE <NA> <NA>
##
## far.loc chamber.vol chamber.flow chamber.AER notes.int
## Class logical character character character character
## Minimum <NA> 0.15 15 35 .
## Maximum <NA> 0.15 15 35 .
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 1 1
## Missing values 15309 0 0 0 15308
## Sorted <NA> TRUE TRUE TRUE TRUE
##
## row.in.file.int t.start.orig t.end.orig j.NH3.orig
## Class numeric character character numeric
## Minimum 5 01-03-2024 00:05 01-03-2024 00:05 -0.15
## Maximum 15300 31-05-2024 05:40 31-05-2024 05:40 5.06
## Mean 7660 <NA> <NA> 0.0721
## Unique (excld. NA) 15309 15309 15309 15309
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## j.NH3.conv.fact j.NH3.unit.orig dt.calc dt.diff ct
## Class numeric character numeric numeric numeric
## Minimum 1 % applied TAN / min 2.48 0 2.52
## Maximum 35.9 kg N/ha-hr 12.7 0 380
## Mean 7.44 <NA> 2.55 0 96.2
## Unique (excld. NA) 5 2 8 1 229
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE FALSE
##
## mt cta bta flag.int rain.rate rain.cum wind.2m
## Class numeric numeric numeric character numeric numeric numeric
## Minimum 1.26 2.52 0 0 0 <NA>
## Maximum 379 380 377 0 0 <NA>
## Mean 94.9 96.2 93.7 <NA> 0 0 <NA>
## Unique (excld. NA) 303 229 228 1 1 1 0
## Missing values 0 0 0 0 0 0 15309
## Sorted FALSE FALSE FALSE TRUE TRUE TRUE <NA>
##
## e.int e.cum e e.rel j.rel pub.info soil.type2
## Class numeric numeric numeric numeric numeric logical logical
## Minimum -1.52 -8.05 -8.05 -0.19 -0.00244 <NA> <NA>
## Maximum 12.8 38.9 38.9 0.612 0.0818 <NA> <NA>
## Mean 0.207 10.7 10.7 0.194 0.00148 <NA> <NA>
## Unique (excld. NA) 15309 15309 15309 15309 15309 0 0
## Missing values 0 0 0 0 0 15309 15309
## Sorted FALSE FALSE FALSE FALSE FALSE <NA> <NA>
##
## exper2 rep2 acid meas.tech.orig
## Class logical logical logical character
## Minimum <NA> <NA> FALSE Dynamic chamber
## Maximum <NA> <NA> TRUE Dynamic chamber
## Mean <NA> <NA> 0.0224704422235286 TRUE <NA>
## Unique (excld. NA) 0 0 2 1
## Missing values 15309 15309 0 0
## Sorted <NA> <NA> FALSE TRUE
##
## meas.tech2 crop.orig app.method.orig
## Class character character character
## Minimum chamber Cereal Band spread or trailing hose
## Maximum chamber Grass Trailing shoe with harrowing tine
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 2 4
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## incorp.orig man.source.orig date.start first.row.int
## Class character character Date numeric
## Minimum None Cattle 2024-02-19 5
## Maximum None Pig 2024-02-19 15200
## Mean <NA> <NA> <NA> 7620
## Unique (excld. NA) 1 3 1 232
## Missing values 0 0 0 0
## Sorted TRUE FALSE TRUE FALSE
##
## row.plot first.rows ggplotgroup
## Class numeric factor factor
## Minimum 5 Plots 10 Emis. 15016 (4.77,10.9]
## Maximum 236 Plots 99 Emis. 10853 (230,236]
## Mean 108 Plots 202 Emis. 11562 (106,112]
## Unique (excld. NA) 232 232 39
## Missing values 0 0 0
## Sorted FALSE FALSE FALSE
##