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:49:55.174824"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 | 2022-07-07 |
2. Contributors
| contributor | institute |
|---|---|
| Nyord, Tavs | Aarhus Universitet |
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.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
## 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
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 1622 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 1622 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit |
|---|---|---|
| kg N/ha-hr | 1 | 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 : OK
## 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 : No values to check.Emission
## 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:
## meas.tech.det silt soil.type soil.water.v soil.moist
## 1622 987 1622 1622 1622
## man.source.det man.bed man.stor man.vs man.tic
## 1622 1622 1622 1622 1622
## man.ua man.vfa man.ph time.incorp man.area
## 1622 987 987 1622 1622
## dist.inj furrow.z furrow.w crop crop.z
## 1622 1622 1622 1622 1622
## crop.area lai notes.plot man.trt3 bg.dl
## 1622 1622 1582 1622 1622
## pH.surf soil.temp soil.temp.z soil.temp.surf rad
## 1622 1262 1262 1622 1622
## wind.z MOL ustar rl air.pres
## 1622 1622 1622 1622 1622
## air.pres.unit rh wind.loc far.loc notes.int
## 1622 1622 1622 1622 1621
## wind.2m soil.type2 exper2 rep2 crop.orig
## 1622 1622 1622 1622 1622Application 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
Manure and application
10. dfsumm summary
Plot-level data
##
## 30 rows and 184 columns
## 30 unique rows
## pub.id
## Class character
## Minimum C
## Maximum F
## Mean <NA>
## Unique (excld. NA) 3
## Missing values 0
## Sorted TRUE
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19B.F:semi-field.P:1.T:NUGA-tine.R:1.R2:.T:2019-02-25 15:23:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19I.F:SLU2.P:9.T:untreated.R:3.R2:.T:2019-08-29 12:10:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 30
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep plot.area
## Class character character character numeric numeric numeric
## Minimum NUGA 19B semi-field 1 1 0.2
## Maximum NUGA 19I SLU2 12 3 0.2
## Mean <NA> <NA> <NA> 5.93 2 0.2
## Unique (excld. NA) 1 4 3 9 3 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE TRUE
##
## lat long country topo clay silt sand
## Class numeric numeric character character numeric numeric numeric
## Minimum 56.5 9.58 DK Flat 9 24 11
## Maximum 58.4 13.5 SE Flat 43 31 71
## Mean 57.6 11.8 <NA> <NA> 23.4 29.2 45.8
## Unique (excld. NA) 3 3 2 1 4 2 4
## Missing values 0 0 0 0 0 18 0
## Sorted TRUE TRUE TRUE TRUE FALSE FALSE FALSE
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class numeric logical numeric logical logical numeric
## Minimum 2.5 <NA> 0.16 <NA> <NA> 5.95
## Maximum 3.1 <NA> 0.23 <NA> <NA> 7.25
## Mean 2.86 <NA> 0.2 <NA> <NA> 6.42
## Unique (excld. NA) 2 0 4 0 0 4
## Missing values 0 30 0 30 30 0
## Sorted TRUE <NA> FALSE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.11 Yes No cat <NA>
## Maximum 1.39 Yes No pig <NA>
## Mean 1.27 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 4 1 1 3 0
## Missing values 0 0 0 0 30
## Sorted FALSE TRUE TRUE FALSE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.stor
## Class logical character character character logical
## Minimum <NA> Slurry Anaerobic digestion None <NA>
## Maximum <NA> Slurry None None <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 3 1 0
## Missing values 30 0 0 0 30
## Sorted <NA> TRUE FALSE TRUE <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical numeric
## Minimum 2.09 <NA> 1.89 1.11 <NA> <NA> 1.37
## Maximum 8.69 <NA> 4.77 3.34 <NA> <NA> 2.42
## Mean 4.38 <NA> 3.11 1.88 <NA> <NA> 1.63
## Unique (excld. NA) 7 0 7 8 0 0 2
## Missing values 0 30 0 0 30 30 18
## Sorted FALSE <NA> FALSE FALSE <NA> <NA> TRUE
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.78 2019-02-25 15:23:00 2019-02-25 15:23:00 bsth
## Maximum 7.98 2019-08-29 12:34:00 2019-08-29 12:34:00 ts
## Mean 7.93 2019-06-15 10:49:42 2019-06-15 10:49:42 <NA>
## Unique (excld. NA) 2 30 30 2
## Missing values 18 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.rate app.rate.unit incorp time.incorp man.area
## Class numeric character character numeric logical
## Minimum 35 m3/ha none <NA> <NA>
## Maximum 45 m3/ha none <NA> <NA>
## Mean 39 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 30 30
## Sorted FALSE TRUE TRUE <NA> <NA>
##
## dist.inj furrow.z furrow.w crop crop.z crop.area
## Class logical logical logical character numeric numeric
## 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 30 30 30 30 30 30
## Sorted <NA> <NA> <NA> <NA> <NA> <NA>
##
## lai notes.plot row.in.file.plot man.trt3 institute
## Class logical character numeric logical character
## Minimum <NA> . 5 <NA> AU
## Maximum <NA> . 34 <NA> AU
## Mean <NA> <NA> 19.5 <NA> <NA>
## Unique (excld. NA) 0 1 30 0 1
## Missing values 30 29 0 30 0
## Sorted <NA> TRUE FALSE <NA> 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_5_2_211012_JP_19BCHI.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.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 Bo Wind tunnel <NA> 07-03-2019 12:12
## Maximum untreated Wind tunnel <NA> 29-08-2019 12:34
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 6 1 0 30
## Missing values 0 0 30 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 07-03-2019 12:12
## Maximum 29-08-2019 12:34
## Mean <NA>
## Unique (excld. NA) 30
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19B.F:semi-field.P:1.T:NUGA-tine.R:1.R2:.T:2019-02-25 15:23:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19I.F:SLU2.P:9.T:untreated.R:3.R2:.T:2019-08-29 12:10:00
## Mean <NA>
## Unique (excld. NA) 30
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:19B Pedersen, Johanna 50
## Maximum D:1.I:AU.Pr:NUGA.E:19I Pedersen, Johanna 117
## Mean <NA> <NA> <NA> 70.2
## Unique (excld. NA) 4 1 1 8
## 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 0.162 0.386 0.517 0.768 1.02 1.25 1.35
## Maximum 0.194 19.9 26.4 36.8 44.6 53.8 59.1
## Mean 0.175 5.84 7.85 11.5 15.3 19.1 21.1
## Unique (excld. NA) 3 30 30 30 30 30 30
## Missing values 27 0 0 0 0 0 0
## Sorted FALSE 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 1.45 <NA> 1.36 1.36 0.162 0.386 0.517
## Maximum 61.5 <NA> 61.6 61.6 0.194 19.9 26.4
## Mean 19.2 <NA> 22.2 22.2 0.175 5.84 7.85
## Unique (excld. NA) 14 0 30 30 3 30 30
## Missing values 16 30 0 0 27 0 0
## Sorted FALSE <NA> FALSE FALSE FALSE 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.768 1.02 1.25 1.35 1.45 <NA>
## Maximum 36.8 44.6 53.8 59.1 61.5 <NA>
## Mean 11.5 15.3 19.1 21.1 19.2 <NA>
## Unique (excld. NA) 30 30 30 30 14 0
## Missing values 0 0 0 0 16 30
## Sorted FALSE FALSE FALSE FALSE FALSE <NA>
##
## 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 1.36 1.36 0.00317 0.00772 0.0103 0.015
## Maximum 61.6 61.6 0.00378 0.171 0.226 0.315
## Mean 22.2 22.2 0.00342 0.0685 0.0924 0.137
## Unique (excld. NA) 30 30 3 30 30 30
## Missing values 0 0 27 0 0 0
## Sorted FALSE FALSE FALSE 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.0198 0.0244 0.0263 0.029 <NA> 0.0266
## Maximum 0.382 0.46 0.506 0.526 <NA> 0.527
## Mean 0.185 0.232 0.256 0.24 <NA> 0.27
## Unique (excld. NA) 30 30 30 14 0 30
## Missing values 0 0 0 16 30 0
## Sorted FALSE FALSE FALSE FALSE <NA> 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.0266 0 0 0 0 0 0
## Maximum 0.527 0 0 0 0 0 0
## Mean 0.27 0 0 0 0 0 0
## Unique (excld. NA) 30 1 1 1 1 1 1
## Missing values 0 27 0 0 0 0 0
## Sorted FALSE TRUE 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 <NA> 0 0 8.4
## Maximum 0 0 <NA> 0 0 8.8
## Mean 0 0 <NA> 0 0 8.67
## Unique (excld. NA) 1 1 0 1 1 2
## Missing values 0 16 30 0 0 27
## Sorted TRUE TRUE <NA> TRUE TRUE FALSE
##
## air.temp.4 air.temp.6 air.temp.12 air.temp.24 air.temp.48
## Class numeric numeric numeric numeric numeric
## Minimum 7.1 6.22 5.62 5.48 4.8
## Maximum 20.6 20 18.8 16 16.5
## Mean 14.8 14.4 13.4 12.1 12.3
## Unique (excld. NA) 25 23 26 28 28
## 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 4.53 3.53 3.53 3.53 <NA>
## Maximum 17.5 16.9 16.9 16.9 <NA>
## Mean 12.7 12.2 12.2 12.2 <NA>
## Unique (excld. NA) 27 27 28 28 0
## Missing values 0 0 0 0 30
## Sorted FALSE FALSE FALSE FALSE <NA>
##
## soil.temp.4 soil.temp.6 soil.temp.12 soil.temp.24
## Class numeric numeric numeric numeric
## Minimum 6.72 5.96 5.26 5.6
## Maximum 7.44 6.94 5.79 6.33
## Mean 7.15 6.46 5.55 5.77
## Unique (excld. NA) 9 9 9 9
## Missing values 21 21 21 21
## Sorted FALSE FALSE FALSE FALSE
##
## soil.temp.48 soil.temp.72 soil.temp.96 soil.temp.168
## Class numeric numeric numeric numeric
## Minimum 5.38 5.3 4.78 4.78
## Maximum 5.58 5.4 5.01 4.92
## Mean 5.42 5.34 4.94 4.85
## Unique (excld. NA) 9 9 9 9
## Missing values 21 21 21 21
## Sorted FALSE FALSE FALSE FALSE
##
## soil.temp.mn wind.1 wind.4 wind.6 wind.12 wind.24 wind.48
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 4.78 0.33 0.33 0.33 0.33 0.33 0.33
## Maximum 4.92 0.33 0.33 0.33 0.33 0.33 0.33
## Mean 4.85 0.33 0.33 0.33 0.33 0.33 0.33
## Unique (excld. NA) 9 1 2 2 2 2 2
## Missing values 21 27 0 0 0 0 0
## Sorted FALSE TRUE FALSE FALSE FALSE FALSE FALSE
##
## wind.72 wind.96 wind.168 wind.mn rain.rate.1 rain.rate.4
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.33 0.33 0.33 0.33 0 0
## Maximum 0.33 0.33 0.33 0.33 0 0
## Mean 0.33 0.33 0.33 0.33 0 0
## Unique (excld. NA) 2 2 2 2 1 1
## Missing values 0 0 0 0 27 0
## Sorted FALSE FALSE FALSE FALSE TRUE TRUE
##
## rain.rate.6 rain.rate.12 rain.rate.24 rain.rate.48
## 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.72 rain.rate.96 rain.rate.168 rain.rate.mn
## 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
##
## first.row.in.file.int last.row.in.file.int n.ints dt1
## Class numeric numeric integer numeric
## Minimum 5 44 40 1
## Maximum 1540 1630 92 2.6
## Mean 691 744 54.1 1.89
## Unique (excld. NA) 30 30 6 3
## 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.00209 0.104 1 1 1 91
## Maximum 0.0482 5.63 2.6 2.6 2.6 104
## Mean 0.0187 1.61 1.89 1.92 1.89 96.9
## Unique (excld. NA) 30 30 3 3 3 7
## 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 2019-02-25 15:23:00 2019-03-01 20:48:00 2
## Maximum 2019-08-29 12:34:00 2019-09-02 11:22:00 2
## Mean 2019-06-15 10:49:42 2019-06-19 10:14:06 2
## Unique (excld. NA) 30 30 1
## Missing values 0 0 0
## Sorted FALSE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc
## Class character logical logical logical
## Minimum 0.05 <NA> <NA> <NA>
## Maximum 0.05 <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 0 0 0
## Missing values 21 30 30 30
## Sorted TRUE <NA> <NA> <NA>
##
## pub.info
## Class character
## Minimum Pedersen, J., Andresson, K., Feilberg, A., Delin, S., Hafner, S., & Nyord, T. (2020). The effect of manure exposed surface area on ammonia emission from untreated, separated, and digested cattle manure. Biosystems Engineering, 202, 66–78. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## Maximum Pedersen, J., Nyord, T., Feilberg, A., & Labouriau, R. (2021). Analysis of the effect of air temperature on ammonia emission from band application of slurry. Environmental Pollution, 282, 1–25. https://doi.org/10.1016/j.envpol.2021.117055
## Mean <NA>
## Unique (excld. NA) 3
## Missing values 0
## Sorted FALSE
##
## soil.type2 exper2 rep2 acid meas.tech.orig meas.tech2
## Class logical logical logical logical character character
## Minimum <NA> <NA> <NA> FALSE Wind tunnel wt
## Maximum <NA> <NA> <NA> FALSE Wind tunnel wt
## Mean <NA> <NA> <NA> 0 TRUE <NA> <NA>
## Unique (excld. NA) 0 0 0 1 1 1
## Missing values 30 30 30 0 0 0
## Sorted <NA> <NA> <NA> TRUE TRUE TRUE
##
## crop.orig man.source.orig app.method.orig
## Class logical character character
## Minimum <NA> Cattle Band spread or trailing hose
## Maximum <NA> Pig Trailing shoe
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 0 3 3
## Missing values 30 0 0
## Sorted <NA> FALSE FALSE
##
## app.method2 incorp.orig date.start
## Class character character Date
## Minimum bsth None 2019-02-25
## Maximum ts None 2019-08-29
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 1 4
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
## Interval-level emission data
##
## 1622 rows and 137 columns
## 1622 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19B.F:semi-field.P:1.T:NUGA-tine.R:1.R2:.T:2019-02-25 15:23:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19I.F:SLU2.P:9.T:untreated.R:3.R2:.T:2019-08-29 12:10:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 30
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class character character character character numeric numeric
## Minimum C NUGA 19B semi-field 1 1
## Maximum F NUGA 19I SLU2 12 3
## Mean <NA> <NA> <NA> <NA> 5.65 2
## Unique (excld. NA) 3 1 4 3 9 3
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE FALSE FALSE
##
## treat meas.tech meas.tech.det plot.area lat
## Class character character logical numeric numeric
## Minimum Bo Wind tunnel <NA> 0.2 56.5
## Maximum untreated Wind tunnel <NA> 0.2 58.4
## Mean <NA> <NA> <NA> 0.2 57.6
## Unique (excld. NA) 6 1 0 1 3
## Missing values 0 0 1622 0 0
## Sorted FALSE TRUE <NA> TRUE TRUE
##
## long country topo clay silt sand oc
## Class numeric character character numeric numeric numeric numeric
## Minimum 9.58 DK Flat 9 24 11 2.5
## Maximum 13.5 SE Flat 43 31 71 3.1
## Mean 11.8 <NA> <NA> 22.7 28 47.1 2.87
## Unique (excld. NA) 3 2 1 4 2 4 2
## Missing values 0 0 0 0 987 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE FALSE TRUE
##
## soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical numeric logical logical numeric
## Minimum <NA> 0.16 <NA> <NA> 5.95
## Maximum <NA> 0.23 <NA> <NA> 7.25
## Mean <NA> 0.197 <NA> <NA> 6.34
## Unique (excld. NA) 0 4 0 0 4
## Missing values 1622 0 1622 1622 0
## Sorted <NA> FALSE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.11 Yes No cat <NA>
## Maximum 1.39 Yes No pig <NA>
## Mean 1.28 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 4 1 1 3 0
## Missing values 0 0 0 0 1622
## Sorted FALSE TRUE TRUE FALSE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.stor
## Class logical character character character logical
## Minimum <NA> Slurry Anaerobic digestion None <NA>
## Maximum <NA> Slurry None None <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 3 1 0
## Missing values 1622 0 0 0 1622
## Sorted <NA> TRUE FALSE TRUE <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical numeric
## Minimum 2.09 <NA> 1.89 1.11 <NA> <NA> 1.37
## Maximum 8.69 <NA> 4.77 3.34 <NA> <NA> 2.42
## Mean 4.4 <NA> 3.12 1.89 <NA> <NA> 1.82
## Unique (excld. NA) 7 0 7 8 0 0 2
## Missing values 0 1622 0 0 1622 1622 987
## Sorted FALSE <NA> FALSE FALSE <NA> <NA> TRUE
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.78 2019-02-25 15:23:00 2019-02-25 15:23:00 bsth
## Maximum 7.98 2019-08-29 12:34:00 2019-08-29 12:34:00 ts
## Mean 7.89 2019-06-17 17:02:20 2019-06-17 17:02:20 <NA>
## Unique (excld. NA) 2 30 30 2
## Missing values 987 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.rate app.rate.unit incorp time.incorp man.area
## Class numeric character character numeric logical
## Minimum 35 m3/ha none <NA> <NA>
## Maximum 45 m3/ha none <NA> <NA>
## Mean 38.9 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 1622 1622
## Sorted FALSE TRUE TRUE <NA> <NA>
##
## dist.inj furrow.z furrow.w crop crop.z crop.area
## Class logical logical logical character numeric numeric
## 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 1622 1622 1622 1622 1622 1622
## Sorted <NA> <NA> <NA> <NA> <NA> <NA>
##
## lai notes.plot row.in.file.plot man.trt3 institute
## Class logical character numeric logical character
## Minimum <NA> . 5 <NA> AU
## Maximum <NA> . 34 <NA> AU
## Mean <NA> <NA> 20.1 <NA> <NA>
## Unique (excld. NA) 0 1 30 0 1
## Missing values 1622 1582 0 1622 0
## Sorted <NA> TRUE FALSE <NA> 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_5_2_211012_JP_19BCHI.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 07-03-2019 12:12 07-03-2019 12:12
## Maximum 29-08-2019 12:34 29-08-2019 12:34
## Mean <NA> <NA>
## Unique (excld. NA) 30 30
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19B.F:semi-field.P:1.T:NUGA-tine.R:1.R2:.T:2019-02-25 15:23:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_19BCHI.xlsx.E:19I.F:SLU2.P:9.T:untreated.R:3.R2:.T:2019-08-29 12:10:00
## Mean <NA>
## Unique (excld. NA) 30
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:19B Pedersen, Johanna 50
## Maximum D:1.I:AU.Pr:NUGA.E:19I Pedersen, Johanna 117
## Mean <NA> <NA> <NA> 70.5
## Unique (excld. NA) 4 1 1 8
## 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 2019-02-25 15:23:00 2019-02-25 17:59:00 1
## Maximum 92 2019-09-02 11:22:00 2019-09-02 13:06:00 2.6
## Mean 29.4 2019-06-19 16:20:41 2019-06-19 18:08:41 1.79
## Unique (excld. NA) 92 1621 1621 3
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## bg.dl bg.val bg.unit j.NH3 j.NH3.unit pH.surf
## Class logical numeric character numeric character logical
## Minimum <NA> 0.0022 ppm 0 kg N/ha-hr <NA>
## Maximum <NA> 0.0414 ppm 5.63 kg N/ha-hr <NA>
## Mean <NA> 0.0121 <NA> 0.236 <NA> <NA>
## Unique (excld. NA) 0 241 1 1483 1 0
## Missing values 1622 0 0 0 0 1622
## Sorted <NA> FALSE TRUE FALSE TRUE <NA>
##
## air.temp air.temp.z soil.temp soil.temp.z soil.temp.surf
## Class numeric numeric numeric character logical
## Minimum -2.7 2 1.05 0.05 <NA>
## Maximum 27.2 2 10.6 0.05 <NA>
## Mean 12.1 2 4.87 <NA> <NA>
## Unique (excld. NA) 554 1 342 1 0
## Missing values 0 0 1262 1262 1622
## Sorted FALSE TRUE FALSE TRUE <NA>
##
## rad wind wind.z MOL ustar rl air.pres
## Class logical numeric logical logical logical logical logical
## Minimum <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Mean <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 0 0 0 0 0
## Missing values 1622 0 1622 1622 1622 1622 1622
## Sorted <NA> TRUE <NA> <NA> <NA> <NA> <NA>
##
## air.pres.unit rain rh wind.loc far.loc notes.int
## Class logical numeric logical logical logical character
## Minimum <NA> 0 <NA> <NA> <NA> .
## Maximum <NA> 0 <NA> <NA> <NA> .
## Mean <NA> 0 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 0 0 0 1
## Missing values 1622 0 1622 1622 1622 1621
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character character
## Minimum 5 emission rate 01-03-2019 00:00
## Maximum 1630 emission rate 31-08-2019 23:54
## Mean 816 <NA> <NA>
## Unique (excld. NA) 1622 1 1621
## Missing values 0 0 0
## Sorted FALSE TRUE FALSE
##
## t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class character character numeric numeric
## Minimum 01-03-2019 00:00 kg N/ha-hr 0 1
## Maximum 31-08-2019 23:54 kg N/ha-hr 5.63 1
## Mean <NA> <NA> 0.236 1
## Unique (excld. NA) 1621 1 1483 1
## Missing values 0 0 0 0
## Sorted FALSE TRUE FALSE TRUE
##
## dt.calc dt.diff ct mt cta bta flag.int
## Class numeric numeric numeric numeric numeric numeric character
## Minimum 0 -0.887 1 0.5 1 0
## Maximum 2.62 1 104 103 104 101
## Mean 1.8 -0.00723 48.9 48 49.1 47.3 <NA>
## Unique (excld. NA) 11 12 209 213 211 208 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 0.162 0.162 0.00317
## Maximum 0 0 <NA> 9.74 61.6 61.6 0.527
## Mean 0 0 <NA> 0.41 17.8 17.8 0.216
## Unique (excld. NA) 1 1 0 1483 1503 1503 1501
## Missing values 0 0 1622 0 0 0 0
## Sorted TRUE TRUE <NA> FALSE FALSE FALSE FALSE
##
## j.rel
## Class numeric
## Minimum 0
## Maximum 0.0482
## Mean 0.00286
## Unique (excld. NA) 1483
## Missing values 0
## Sorted FALSE
##
## pub.info
## Class character
## Minimum Pedersen, J., Andresson, K., Feilberg, A., Delin, S., Hafner, S., & Nyord, T. (2020). The effect of manure exposed surface area on ammonia emission from untreated, separated, and digested cattle manure. Biosystems Engineering, 202, 66–78. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## Maximum Pedersen, J., Nyord, T., Feilberg, A., & Labouriau, R. (2021). Analysis of the effect of air temperature on ammonia emission from band application of slurry. Environmental Pollution, 282, 1–25. https://doi.org/10.1016/j.envpol.2021.117055
## Mean <NA>
## Unique (excld. NA) 3
## Missing values 0
## Sorted FALSE
##
## soil.type2 exper2 rep2 acid meas.tech.orig meas.tech2
## Class logical logical logical logical character character
## Minimum <NA> <NA> <NA> FALSE Wind tunnel wt
## Maximum <NA> <NA> <NA> FALSE Wind tunnel wt
## Mean <NA> <NA> <NA> 0 TRUE <NA> <NA>
## Unique (excld. NA) 0 0 0 1 1 1
## Missing values 1622 1622 1622 0 0 0
## Sorted <NA> <NA> <NA> TRUE TRUE TRUE
##
## crop.orig man.source.orig app.method.orig
## Class logical character character
## Minimum <NA> Cattle Band spread or trailing hose
## Maximum <NA> Pig Trailing shoe
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 0 3 3
## Missing values 1622 0 0
## Sorted <NA> FALSE FALSE
##
## app.method2 incorp.orig date.start first.row.int row.plot
## Class character character Date numeric numeric
## Minimum bsth None 2019-02-25 5 5
## Maximum ts None 2019-02-25 1540 34
## Mean <NA> <NA> <NA> 787 20.1
## Unique (excld. NA) 2 1 1 30 30
## Missing values 0 0 0 0 0
## Sorted FALSE TRUE TRUE FALSE FALSE
##
## first.rows ggplotgroup
## Class factor factor
## Minimum Plots 10 Emis. 205 (4.97,10.8]
## Maximum Plots 9 Emis. 165 (28.2,34]
## Mean Plots 24 Emis. 743 (16.6,22.4]
## Unique (excld. NA) 30 5
## Missing values 0 0
## Sorted FALSE FALSE
##