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:48:41.324492"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_18ABC.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
## 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
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 1788 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 1788 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit | |
|---|---|---|---|
| 1 | kg N/ha-hr | 1 | kg N/ha-hr |
| 465 | NA | NA | 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 : OKManure 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 soil.type soil.water.v soil.moist man.source.det
## 1788 1788 1788 1788 1788
## man.bed man.stor man.vs man.tic man.ua
## 1788 1788 1788 1788 1788
## time.incorp man.area dist.inj furrow.z furrow.w
## 1788 1788 1788 1788 1788
## crop.z crop.area lai notes.plot man.trt3
## 1788 1788 1788 1739 1788
## bg.dl bg.val bg.unit pH.surf air.temp.z
## 1788 9 9 1788 9
## soil.temp.z soil.temp.surf rad MOL ustar
## 9 1788 1788 1788 1788
## rl air.pres air.pres.unit rh wind.loc
## 1788 1788 1788 1788 1788
## far.loc notes.int j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## 1788 1787 9 9 9
## soil.type2 exper2 rep2
## 1788 1788 1788Application 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
##
## 27 rows and 194 columns
## 27 unique rows
## pub.id
## Class character
## Minimum A
## Maximum A
## Mean <NA>
## Unique (excld. NA) 1
## 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_18ABC.xlsx.E:18A.F:semi-field facilities.P:1.T:TH.R:1.R2:.T:2018-05-15 13:18:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx.E:18C.F:semi-field facilities.P:9.T:TH.R:3.R2:.T:2018-05-29 14:04:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep
## Class character character character numeric numeric
## Minimum NUGA 18A semi-field facilities 1 1
## Maximum NUGA 18C semi-field facilities 12 3
## Mean <NA> <NA> <NA> 6.33 2
## Unique (excld. NA) 1 3 1 9 3
## Missing values 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE
##
## plot.area lat long country topo clay
## Class numeric numeric numeric character character numeric
## Minimum 0.2 56.5 9.58 DK Flat 4
## Maximum 0.2 56.5 9.58 DK Flat 18
## Mean 0.2 56.5 9.58 <NA> <NA> 10.3
## Unique (excld. NA) 1 1 1 1 1 3
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE
##
## silt sand oc soil.type soil.water soil.water.v
## Class numeric numeric numeric logical numeric logical
## Minimum 5 49 2 <NA> 0.09 <NA>
## Maximum 31 89 2.5 <NA> 0.17 <NA>
## Mean 20 67.7 2.33 <NA> 0.13 <NA>
## Unique (excld. NA) 3 3 2 0 3 0
## Missing values 0 0 0 27 0 27
## Sorted TRUE FALSE TRUE <NA> TRUE <NA>
##
## soil.moist soil.ph soil.dens crop.res till man.source
## Class logical numeric numeric character character character
## Minimum <NA> 4.4 1.32 Yes No pig
## Maximum <NA> 6.3 1.41 Yes No pig
## Mean <NA> 5.07 1.38 <NA> <NA> <NA>
## Unique (excld. NA) 0 3 2 1 1 1
## Missing values 27 0 0 0 0 0
## Sorted <NA> FALSE FALSE TRUE TRUE TRUE
##
## man.source.det man.bed man.con man.trt1 man.trt2
## Class logical logical character character character
## Minimum <NA> <NA> Slurry None None
## Maximum <NA> <NA> Slurry None None
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 1 1
## Missing values 27 27 0 0 0
## Sorted <NA> <NA> TRUE TRUE TRUE
##
## man.stor man.dm man.vs man.tkn man.tan man.tic man.ua
## Class logical numeric logical numeric numeric logical logical
## Minimum <NA> 3.4 <NA> 2.62 2.2 <NA> <NA>
## Maximum <NA> 3.87 <NA> 3.45 2.25 <NA> <NA>
## Mean <NA> 3.7 <NA> 3 2.22 <NA> <NA>
## Unique (excld. NA) 0 3 0 3 3 0 0
## Missing values 27 0 27 0 0 27 27
## Sorted <NA> FALSE <NA> FALSE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 7.5 7.04 2018-05-15 13:18:00 2018-05-15 13:18:00
## Maximum 8.8 7.19 2018-05-29 14:28:00 2018-05-29 14:28:00
## Mean 8.23 7.11 2018-05-22 13:57:22 2018-05-22 13:57:22
## Unique (excld. NA) 3 3 27 27
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 45 m3/ha none <NA>
## Maximum ts 45 m3/ha none <NA>
## Mean <NA> 45 <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 1 0
## Missing values 0 0 0 0 27
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.area dist.inj furrow.z furrow.w crop crop.z
## Class logical logical logical logical character numeric
## Minimum <NA> <NA> <NA> <NA> cereal <NA>
## Maximum <NA> <NA> <NA> <NA> cereal <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 0 1 0
## Missing values 27 27 27 27 0 27
## Sorted <NA> <NA> <NA> <NA> TRUE <NA>
##
## crop.area lai notes.plot row.in.file.plot man.trt3
## Class numeric logical character numeric logical
## Minimum <NA> <NA> . 5 <NA>
## Maximum <NA> <NA> . 31 <NA>
## Mean <NA> <NA> <NA> 18 <NA>
## Unique (excld. NA) 0 0 1 27 0
## Missing values 27 27 26 0 27
## Sorted <NA> <NA> TRUE FALSE <NA>
##
## institute sub.period
## Class character numeric
## Minimum AU 3
## Maximum AU 3
## Mean <NA> 3
## Unique (excld. NA) 1 1
## Missing values 0 0
## Sorted TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.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> 15-05-2018 13:18
## Maximum Vo Wind tunnel <NA> 29-05-2018 14:28
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 0 27
## Missing values 0 0 27 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 15-05-2018 13:18
## Maximum 29-05-2018 14:28
## Mean <NA>
## Unique (excld. NA) 27
## 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_18ABC.xlsx.E:18A.F:semi-field facilities.P:1.T:TH.R:1.R2:.T:2018-05-15 13:18:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx.E:18C.F:semi-field facilities.P:9.T:TH.R:3.R2:.T:2018-05-29 14:04:00
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:18A Pedersen, Johanna 99
## Maximum D:1.I:AU.Pr:NUGA.E:18C Pedersen, Johanna 101
## Mean <NA> <NA> <NA> 100
## Unique (excld. NA) 3 1 1 3
## 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> 1.26 1.8 3.18 5.32 6.98 7.93
## Maximum <NA> 5.69 8.16 13.1 19.1 27.4 31
## Mean <NA> 3.76 5.12 8.02 13.2 19.3 22.5
## Unique (excld. NA) 0 27 27 27 27 27 27
## Missing values 27 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 15.5 <NA> 8.18 8.18 <NA> 1.26 1.8
## Maximum 33.2 <NA> 34.1 34.1 <NA> 5.69 8.16
## Mean 26.4 <NA> 25.6 25.6 <NA> 3.76 5.12
## Unique (excld. NA) 18 0 27 27 0 27 27
## Missing values 9 27 0 0 27 0 0
## Sorted FALSE <NA> 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 3.18 5.32 6.98 7.93 15.5 <NA>
## Maximum 13.1 19.1 27.4 31 33.2 <NA>
## Mean 8.02 13.2 19.3 22.5 26.4 <NA>
## Unique (excld. NA) 27 27 27 27 18 0
## Missing values 0 0 0 0 9 27
## 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 8.18 8.18 <NA> 0.0126 0.018 0.0318
## Maximum 34.1 34.1 <NA> 0.057 0.0817 0.131
## Mean 25.6 25.6 <NA> 0.0375 0.0511 0.08
## Unique (excld. NA) 27 27 0 27 27 27
## Missing values 0 0 27 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.0532 0.0699 0.0794 0.156 <NA> 0.0819
## Maximum 0.192 0.271 0.306 0.328 <NA> 0.337
## Mean 0.132 0.193 0.224 0.263 <NA> 0.256
## Unique (excld. NA) 27 27 27 18 0 27
## Missing values 0 0 0 9 27 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.0819 <NA> 0 0 0 0 0
## Maximum 0.337 <NA> 0 0 0 0 0
## Mean 0.256 <NA> 0 0 0 0 0
## Unique (excld. NA) 27 0 1 1 1 1 1
## Missing values 0 27 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 <NA> 0 0 <NA>
## Maximum 0 0 <NA> 0 0 <NA>
## Mean 0 0 <NA> 0 0 <NA>
## Unique (excld. NA) 1 1 0 1 1 0
## Missing values 0 9 27 0 0 27
## Sorted TRUE TRUE <NA> 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 20 20.7 19.8 17 16
## Maximum 25.5 25.4 23.4 19.9 20.8
## Mean 22.8 23.1 21.4 18.6 18.2
## Unique (excld. NA) 25 27 27 27 27
## 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 15.4 15.1 15.1 15.1 <NA>
## Maximum 20.6 20.6 21.2 21.2 <NA>
## Mean 18.1 18.1 18.3 18.3 <NA>
## Unique (excld. NA) 27 27 27 27 0
## Missing values 0 0 0 0 27
## Sorted FALSE FALSE FALSE FALSE <NA>
##
## soil.temp.4 soil.temp.6 soil.temp.12 soil.temp.24
## Class numeric numeric numeric numeric
## Minimum 16.9 17.1 17.3 16.6
## Maximum 21.9 21.5 20.4 18
## Mean 19.2 19.2 18.7 17
## Unique (excld. NA) 24 25 27 27
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## soil.temp.48 soil.temp.72 soil.temp.96 soil.temp.168
## Class numeric numeric numeric numeric
## Minimum 16.4 16.1 15.9 15.9
## Maximum 17 16.9 16.9 17.2
## Mean 16.8 16.7 16.6 16.7
## Unique (excld. NA) 26 27 27 27
## Missing values 0 0 0 0
## 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 15.9 <NA> 0.33 0.33 0.33 0.33 0.33
## Maximum 17.2 <NA> 0.33 0.33 0.33 0.33 0.33
## Mean 16.7 <NA> 0.33 0.33 0.33 0.33 0.33
## Unique (excld. NA) 27 0 2 2 2 2 2
## Missing values 0 27 0 0 0 0 0
## Sorted FALSE <NA> TRUE TRUE TRUE TRUE TRUE
##
## wind.72 wind.96 wind.168 wind.mn wind.2m.1 wind.2m.4
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.33 0.33 0.33 0.33 <NA> 0.692
## Maximum 0.33 0.33 0.33 0.33 <NA> 0.692
## Mean 0.33 0.33 0.33 0.33 <NA> 0.692
## Unique (excld. NA) 2 3 3 3 0 1
## Missing values 0 0 0 0 27 0
## Sorted TRUE FALSE FALSE FALSE <NA> TRUE
##
## wind.2m.6 wind.2m.12 wind.2m.24 wind.2m.48 wind.2m.72
## Class numeric numeric numeric numeric numeric
## Minimum 0.692 0.692 0.692 0.692 0.692
## Maximum 0.692 0.692 0.692 0.692 0.692
## Mean 0.692 0.692 0.692 0.692 0.692
## Unique (excld. NA) 1 1 2 2 2
## Missing values 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE
##
## wind.2m.96 wind.2m.168 wind.2m.mn rain.rate.1 rain.rate.4
## Class numeric numeric numeric numeric numeric
## Minimum 0.692 0.692 0.692 <NA> 0
## Maximum 0.692 0.692 0.692 <NA> 0
## Mean 0.692 0.692 0.692 <NA> 0
## Unique (excld. NA) 1 2 2 0 1
## Missing values 0 0 0 27 0
## Sorted TRUE FALSE FALSE <NA> 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 53 49 1.73
## Maximum 1730 1790 88 1.82
## Mean 827 893 66.2 1.76
## Unique (excld. NA) 27 27 5 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.0033 0.329 1.73 1.73 1.73 89.2
## Maximum 0.0165 1.67 1.82 12.2 1.82 161
## Mean 0.0103 1.03 1.76 4.79 1.76 119
## Unique (excld. NA) 27 27 2 5 2 5
## 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 2018-05-15 13:26:00 2018-05-19 04:39:00 2
## Maximum 2018-05-29 14:36:00 2018-06-03 00:22:00 2
## Mean 2018-05-22 14:05:00 2018-05-27 11:30:46 2
## Unique (excld. NA) 27 27 1
## Missing values 0 0 0
## Sorted FALSE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc
## Class character numeric logical logical
## Minimum 0.05 0.125 <NA> <NA>
## Maximum 0.05 0.125 <NA> <NA>
## Mean <NA> 0.125 <NA> <NA>
## Unique (excld. NA) 1 1 0 0
## Missing values 0 0 27 27
## Sorted TRUE TRUE <NA> <NA>
##
## pub.info
## Class character
## Minimum Pedersen, J., Feilberg, A., Kamp, J. N., Hafner, S., & Nyord, T. (2020). Ammonia emission measurement with an online wind tunnel system for evaluation of manure application techniques. Atmospheric Environment, 230(December 2019). https://doi.org/10.1016/j.atmosenv.2020.117562 AND 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
## Maximum Pedersen, J., Feilberg, A., Kamp, J. N., Hafner, S., & Nyord, T. (2020). Ammonia emission measurement with an online wind tunnel system for evaluation of manure application techniques. Atmospheric Environment, 230(December 2019). https://doi.org/10.1016/j.atmosenv.2020.117562 AND 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) 1
## Missing values 0
## Sorted TRUE
##
## 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 27 27 27 0 0 0
## Sorted <NA> <NA> <NA> TRUE TRUE TRUE
##
## crop.orig man.source.orig app.method.orig
## Class character character character
## Minimum Cereal Pig Band spread or trailing hose
## Maximum Cereal Pig Trailing shoe
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 2
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## app.method2 incorp.orig date.start
## Class character character Date
## Minimum bsth None 2018-05-15
## Maximum ts None 2018-05-29
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 1 3
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
## Interval-level emission data
##
## 1788 rows and 137 columns
## 1788 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx.E:18A.F:semi-field facilities.P:1.T:TH.R:1.R2:.T:2018-05-15 13:18:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx.E:18C.F:semi-field facilities.P:9.T:TH.R:3.R2:.T:2018-05-29 14:04:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot
## Class character character character character numeric
## Minimum A NUGA 18A semi-field facilities 1
## Maximum A NUGA 18C semi-field facilities 12
## Mean <NA> <NA> <NA> <NA> 6.33
## Unique (excld. NA) 1 1 3 1 9
## Missing values 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE FALSE
##
## rep treat meas.tech meas.tech.det plot.area
## Class numeric character character logical numeric
## Minimum 1 Bo Wind tunnel <NA> 0.2
## Maximum 3 Vo Wind tunnel <NA> 0.2
## Mean 2 <NA> <NA> <NA> 0.2
## Unique (excld. NA) 3 3 1 0 1
## Missing values 0 0 0 1788 0
## Sorted FALSE FALSE TRUE <NA> TRUE
##
## lat long country topo clay silt sand
## Class numeric numeric character character numeric numeric numeric
## Minimum 56.5 9.58 DK Flat 4 5 49
## Maximum 56.5 9.58 DK Flat 18 31 89
## Mean 56.5 9.58 <NA> <NA> 10.6 21.5 65.9
## Unique (excld. NA) 1 1 1 1 3 3 3
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE FALSE
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class numeric logical numeric logical logical numeric
## Minimum 2 <NA> 0.09 <NA> <NA> 4.4
## Maximum 2.5 <NA> 0.17 <NA> <NA> 6.3
## Mean 2.38 <NA> 0.133 <NA> <NA> 5.02
## Unique (excld. NA) 2 0 3 0 0 3
## Missing values 0 1788 0 1788 1788 0
## Sorted TRUE <NA> TRUE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.32 Yes No pig <NA>
## Maximum 1.41 Yes No pig <NA>
## Mean 1.37 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 1 0
## Missing values 0 0 0 0 1788
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.stor man.dm
## Class logical character character character logical numeric
## Minimum <NA> Slurry None None <NA> 3.4
## Maximum <NA> Slurry None None <NA> 3.87
## Mean <NA> <NA> <NA> <NA> <NA> 3.71
## Unique (excld. NA) 0 1 1 1 0 3
## Missing values 1788 0 0 0 1788 0
## Sorted <NA> TRUE TRUE TRUE <NA> FALSE
##
## man.vs man.tkn man.tan man.tic man.ua man.vfa man.ph
## Class logical numeric numeric logical logical numeric numeric
## Minimum <NA> 2.62 2.2 <NA> <NA> 7.5 7.04
## Maximum <NA> 3.45 2.25 <NA> <NA> 8.8 7.19
## Mean <NA> 3.08 2.22 <NA> <NA> 8.3 7.1
## Unique (excld. NA) 0 3 3 0 0 3 3
## Missing values 1788 0 0 1788 1788 0 0
## Sorted <NA> FALSE FALSE <NA> <NA> FALSE FALSE
##
## app.start app.end app.method app.rate
## Class POSIXct, POSIXt POSIXct, POSIXt character numeric
## Minimum 2018-05-15 13:18:00 2018-05-15 13:18:00 bsth 45
## Maximum 2018-05-29 14:28:00 2018-05-29 14:28:00 ts 45
## Mean 2018-05-23 00:52:21 2018-05-23 00:52:21 <NA> 45
## Unique (excld. NA) 27 27 2 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE
##
## app.rate.unit incorp time.incorp man.area dist.inj
## Class character character numeric logical logical
## Minimum m3/ha none <NA> <NA> <NA>
## Maximum m3/ha none <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 0 0 0
## Missing values 0 0 1788 1788 1788
## Sorted TRUE TRUE <NA> <NA> <NA>
##
## furrow.z furrow.w crop crop.z crop.area lai
## Class logical logical character numeric numeric logical
## Minimum <NA> <NA> cereal <NA> <NA> <NA>
## Maximum <NA> <NA> cereal <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 0 0 0
## Missing values 1788 1788 0 1788 1788 1788
## Sorted <NA> <NA> TRUE <NA> <NA> <NA>
##
## notes.plot row.in.file.plot man.trt3 institute sub.period
## Class character numeric logical character numeric
## Minimum . 5 <NA> AU 3
## Maximum . 31 <NA> AU 3
## Mean <NA> 18.6 <NA> <NA> 3
## Unique (excld. NA) 1 27 0 1 1
## Missing values 1739 0 1788 0 0
## Sorted TRUE FALSE <NA> TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 15-05-2018 13:18 15-05-2018 13:18
## Maximum 29-05-2018 14:28 29-05-2018 14:28
## Mean <NA> <NA>
## Unique (excld. NA) 27 27
## 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_18ABC.xlsx.E:18A.F:semi-field facilities.P:1.T:TH.R:1.R2:.T:2018-05-15 13:18:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_211012_JP_18ABC.xlsx.E:18C.F:semi-field facilities.P:9.T:TH.R:3.R2:.T:2018-05-29 14:04:00
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:18A Pedersen, Johanna 99
## Maximum D:1.I:AU.Pr:NUGA.E:18C Pedersen, Johanna 101
## Mean <NA> <NA> <NA> 99.9
## Unique (excld. NA) 3 1 1 3
## 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 2018-05-15 13:26:00 2018-05-15 15:15:00 1.73
## Maximum 88 2018-06-03 00:22:00 2018-06-03 02:06:00 12.2
## Mean 35.6 2018-05-25 16:21:20 2018-05-25 18:09:19 1.8
## Unique (excld. NA) 88 1788 1788 5
## 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.0127 ppm 0 kg N/ha-hr <NA>
## Maximum <NA> 0.114 ppm 1.67 kg N/ha-hr <NA>
## Mean <NA> 0.0502 <NA> 0.215 <NA> <NA>
## Unique (excld. NA) 0 198 1 1680 1 0
## Missing values 1788 9 9 0 0 1788
## 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 6.52 2 11.6 0.05 <NA>
## Maximum 29.2 2 24.4 0.05 <NA>
## Mean 18.5 2 16.8 <NA> <NA>
## Unique (excld. NA) 1066 1 650 1 0
## Missing values 0 9 0 9 1788
## Sorted FALSE TRUE FALSE TRUE <NA>
##
## rad wind wind.z MOL ustar rl air.pres
## Class logical numeric numeric logical logical logical logical
## Minimum <NA> 0.33 0.125 <NA> <NA> <NA> <NA>
## Maximum <NA> 0.33 0.125 <NA> <NA> <NA> <NA>
## Mean <NA> 0.33 0.125 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0 0 0
## Missing values 1788 0 0 1788 1788 1788 1788
## Sorted <NA> TRUE TRUE <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 1788 0 1788 1788 1788 1787
## 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-06-2018 00:05
## Maximum 1790 emission rate 31-05-2018 23:49
## Mean 898 <NA> <NA>
## Unique (excld. NA) 1788 1 1788
## 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-06-2018 00:05 kg N/ha-hr 0 1
## Maximum 31-05-2018 23:49 kg N/ha-hr 1.67 1
## Mean <NA> <NA> 0.215 1
## Unique (excld. NA) 1788 1 1671 1
## Missing values 0 9 9 9
## Sorted FALSE TRUE FALSE TRUE
##
## dt.calc dt.diff ct mt cta bta flag.int
## Class numeric numeric numeric numeric numeric numeric character
## Minimum 1.7 -0.02 1.73 0.865 1.78 -0.0333
## Maximum 12.2 0.03 161 160 161 160 m i
## Mean 1.8 -0.00199 65.1 64.2 65.3 63.5 <NA>
## Unique (excld. NA) 8 8 243 245 209 208 2
## Missing values 0 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##
## rain.rate rain.cum wind.2m e.int e.cum e e.rel
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0 0 0.692 0 0.599 0.599 0.006
## Maximum 0 0 0.692 3.03 34.1 34.1 0.337
## Mean 0 0 0.692 0.387 19.4 19.4 0.194
## Unique (excld. NA) 1 1 1 1680 1702 1702 1702
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE FALSE FALSE
##
## j.rel
## Class numeric
## Minimum 0
## Maximum 0.0165
## Mean 0.00215
## Unique (excld. NA) 1680
## Missing values 0
## Sorted FALSE
##
## pub.info
## Class character
## Minimum Pedersen, J., Feilberg, A., Kamp, J. N., Hafner, S., & Nyord, T. (2020). Ammonia emission measurement with an online wind tunnel system for evaluation of manure application techniques. Atmospheric Environment, 230(December 2019). https://doi.org/10.1016/j.atmosenv.2020.117562 AND 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
## Maximum Pedersen, J., Feilberg, A., Kamp, J. N., Hafner, S., & Nyord, T. (2020). Ammonia emission measurement with an online wind tunnel system for evaluation of manure application techniques. Atmospheric Environment, 230(December 2019). https://doi.org/10.1016/j.atmosenv.2020.117562 AND 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) 1
## Missing values 0
## Sorted TRUE
##
## 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 1788 1788 1788 0 0 0
## Sorted <NA> <NA> <NA> TRUE TRUE TRUE
##
## crop.orig man.source.orig app.method.orig
## Class character character character
## Minimum Cereal Pig Band spread or trailing hose
## Maximum Cereal Pig Trailing shoe
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 2
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## app.method2 incorp.orig date.start first.row.int row.plot
## Class character character Date numeric numeric
## Minimum bsth None 2018-05-15 5 5
## Maximum ts None 2018-05-15 1730 31
## Mean <NA> <NA> <NA> 864 18.6
## Unique (excld. NA) 2 1 1 27 27
## Missing values 0 0 0 0 0
## Sorted FALSE TRUE TRUE FALSE FALSE
##
## first.rows ggplotgroup
## Class factor factor
## Minimum Plots 10 Emis. 250 (4.97,10.2]
## Maximum Plots 9 Emis. 201 (25.8,31]
## Mean Plots 22 Emis. 1149 (15.4,20.6]
## Unique (excld. NA) 27 5
## Missing values 0 0
## Sorted FALSE FALSE
##