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:50:12.717717"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_6_0_220126_JP_20CD21A_JP.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
## 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
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 1883 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 1883 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit | |
|---|---|---|---|
| 1 | kg NH3/ha-hr | 0.8224414 | kg N/ha-hr |
| 14 | 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 : 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 : No values to check.
## 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 clay silt sand oc
## 1883 1883 1883 1883 1883
## soil.water.v soil.moist man.source.det man.stor man.vs
## 1883 1883 1883 1883 1883
## man.tic man.ua man.vfa time.incorp man.area
## 1883 1883 1883 1883 1883
## dist.inj furrow.z furrow.w crop.z crop.area
## 1883 1883 1883 1883 1883
## lai notes.plot bg.dl bg.val bg.unit
## 1883 1818 1883 20 20
## pH.surf air.temp.z soil.temp.z soil.temp.surf rad
## 1883 20 20 1883 1883
## wind.z MOL ustar rl air.pres
## 1883 1883 1883 1883 1883
## air.pres.unit rh wind.loc far.loc notes.int
## 1883 1883 1883 1883 1882
## j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact wind.2m soil.type2
## 20 20 20 1883 1883
## exper2 rep2
## 1883 1883Application 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
##
## 26 rows and 184 columns
## 26 unique rows
## pub.id
## Class character
## Minimum AC
## Maximum C
## Mean <NA>
## Unique (excld. NA) 2
## Missing values 0
## Sorted TRUE
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:20C.F:Holstebro1.P:1.T:Bomech.R:1.R2:.T:2020-03-06 14:41:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:21A.F:Holstebro3.P:9.T:Bomech.R:3.R2:.T:2021-03-16 17:28:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 26
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep plot.area
## Class character character character numeric numeric numeric
## Minimum NUGA 20C Holstebro1 1 1 0.2
## Maximum NUGA 21A Holstebro3 12 3 0.2
## Mean <NA> <NA> <NA> 6.42 2.04 0.2
## Unique (excld. NA) 1 3 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 logical logical logical
## Minimum 56.4 8.87 DK Flat <NA> <NA> <NA>
## Maximum 56.4 8.9 DK Flat <NA> <NA> <NA>
## Mean 56.4 8.88 <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 3 1 1 0 0 0
## Missing values 0 0 0 0 26 26 26
## Sorted FALSE FALSE TRUE TRUE <NA> <NA> <NA>
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical character numeric logical logical numeric
## Minimum <NA> Sand 0.1 <NA> <NA> 5.94
## Maximum <NA> Sand 0.29 <NA> <NA> 6.3
## Mean <NA> <NA> 0.186 <NA> <NA> 6.08
## Unique (excld. NA) 0 1 3 0 0 3
## Missing values 26 0 0 26 26 0
## Sorted <NA> TRUE TRUE <NA> <NA> TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.27 Yes No cat <NA>
## Maximum 1.39 Yes No cat <NA>
## Mean 1.33 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 1 1 0
## Missing values 0 0 0 0 26
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1
## Class character character character
## Minimum Straw Slurry Anaerobic digestion
## Maximum Straw Slurry Anaerobic digestion
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## man.trt2 man.trt3 man.stor man.dm man.vs
## Class character character logical numeric logical
## Minimum Mechanical separation Acidification <NA> 3.35 <NA>
## Maximum Mechanical separation None <NA> 5.92 <NA>
## Mean <NA> <NA> <NA> 5.12 <NA>
## Unique (excld. NA) 1 2 0 3 0
## Missing values 0 0 26 0 26
## Sorted TRUE FALSE <NA> FALSE <NA>
##
## man.tkn man.tan man.tic man.ua man.vfa man.ph
## Class numeric numeric logical logical logical numeric
## Minimum 3.51 2.43 <NA> <NA> <NA> 7.28
## Maximum 3.6 3.01 <NA> <NA> <NA> 7.81
## Mean 3.55 2.61 <NA> <NA> <NA> 7.57
## Unique (excld. NA) 3 2 0 0 0 6
## Missing values 0 0 26 26 26 0
## Sorted FALSE TRUE <NA> <NA> <NA> FALSE
##
## app.start app.end app.method app.rate
## Class POSIXct, POSIXt POSIXct, POSIXt character numeric
## Minimum 2020-03-06 14:41:00 2020-03-06 14:41:00 os 18.5
## Maximum 2021-03-16 17:52:00 2021-03-16 17:52:00 ts 25
## Mean 2020-09-01 17:32:02 2020-09-01 17:32:02 <NA> 23
## Unique (excld. NA) 26 26 2 2
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.rate.unit incorp time.incorp man.area dist.inj
## Class character character numeric logical logical
## Minimum t/ha none <NA> <NA> <NA>
## Maximum t/ha none <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 0 0 0
## Missing values 0 0 26 26 26
## 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> grass <NA> <NA> <NA>
## Maximum <NA> <NA> grass <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 0 0 0
## Missing values 26 26 0 26 26 26
## Sorted <NA> <NA> TRUE <NA> <NA> <NA>
##
## notes.plot row.in.file.plot institute sub.period
## Class character numeric character numeric
## Minimum . 5 AU 3
## Maximum . 30 AU 3
## Mean <NA> 17.5 <NA> 3
## Unique (excld. NA) 1 26 1 1
## Missing values 25 0 0 0
## Sorted TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.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 Bomech Wind tunnel <NA> 3/16/2021 16:24
## Maximum Disc Wind tunnel <NA> 6/9/2020 15:53
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 0 26
## Missing values 0 0 26 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 3/16/2021 16:24
## Maximum 6/9/2020 15:53
## Mean <NA>
## Unique (excld. NA) 26
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:20C.F:Holstebro1.P:1.T:Bomech.R:1.R2:.T:2020-03-06 14:41:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:21A.F:Holstebro3.P:9.T:Bomech.R:3.R2:.T:2021-03-16 17:28:00
## Mean <NA>
## Unique (excld. NA) 26
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:20C Pedersen, Johanna 55.7
## Maximum D:1.I:AU.Pr:NUGA.E:21A Pedersen, Johanna 60.8
## Mean <NA> <NA> <NA> 59.2
## Unique (excld. NA) 3 1 1 2
## 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.459 0.647 0.809 1.52 2.17 2.65
## Maximum <NA> 15.5 18.1 22.1 27.1 30.7 32.2
## Mean <NA> 6.21 8.24 11.3 14.7 17.8 19.4
## Unique (excld. NA) 0 26 26 26 26 26 26
## Missing values 26 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 2.77 <NA> 2.85 2.85 <NA> 0.459 0.647
## Maximum 33.5 <NA> 34.1 34.1 <NA> 15.5 18.1
## Mean 20.5 <NA> 21.2 21.2 <NA> 6.21 8.24
## Unique (excld. NA) 26 0 26 26 0 26 26
## Missing values 0 26 0 0 26 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 0.809 1.52 2.17 2.65 2.77 <NA>
## Maximum 22.1 27.1 30.7 32.2 33.5 <NA>
## Mean 11.3 14.7 17.8 19.4 20.5 <NA>
## Unique (excld. NA) 26 26 26 26 26 0
## Missing values 0 0 0 0 0 26
## 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 2.85 2.85 <NA> 0.00824 0.0116 0.0145
## Maximum 34.1 34.1 <NA> 0.255 0.298 0.364
## Mean 21.2 21.2 <NA> 0.103 0.136 0.186
## Unique (excld. NA) 26 26 0 26 26 26
## Missing values 0 0 26 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.0273 0.0389 0.0476 0.0497 <NA> 0.0511
## Maximum 0.446 0.505 0.53 0.551 <NA> 0.561
## Mean 0.244 0.297 0.323 0.341 <NA> 0.353
## Unique (excld. NA) 26 26 26 26 0 26
## Missing values 0 0 0 0 26 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.0511 <NA> 0 0 0 0 0
## Maximum 0.561 <NA> 0 0 0 0 0
## Mean 0.353 <NA> 0 0 0 0 0
## Unique (excld. NA) 26 0 1 1 1 1 1
## Missing values 0 26 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 0 26 0 0 26
## 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 3.52 2.39 1.47 2.41 1.93
## Maximum 22 21.5 18 14.7 13.8
## Mean 13.8 12.9 10.9 9.72 9.97
## Unique (excld. NA) 26 26 26 26 26
## 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 1.61 1.53 2.49 2.49 <NA>
## Maximum 15.5 16.1 16.5 16.5 <NA>
## Mean 10.2 10.3 10.6 10.6 <NA>
## Unique (excld. NA) 26 26 26 26 0
## Missing values 0 0 0 0 26
## 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.31 3.94 3.17 2.95
## Maximum 23.5 21.8 19.3 16.9
## Mean 14.2 13.7 12.8 11.7
## Unique (excld. NA) 26 26 26 26
## 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 2.94 2.68 2.47 2.85
## Maximum 15.3 15.8 16.1 16.5
## Mean 11.4 11.4 11.3 11.5
## Unique (excld. NA) 26 26 26 26
## 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 2.85 <NA> 0.33 0.33 0.33 0.33 0.33
## Maximum 16.5 <NA> 0.33 0.33 0.33 0.33 0.33
## Mean 11.5 <NA> 0.33 0.33 0.33 0.33 0.33
## Unique (excld. NA) 26 0 1 1 2 2 2
## Missing values 0 26 0 0 0 0 0
## Sorted FALSE <NA> TRUE TRUE 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 <NA> 0
## Maximum 0.33 0.33 0.33 0.33 <NA> 0
## Mean 0.33 0.33 0.33 0.33 <NA> 0
## Unique (excld. NA) 2 2 2 2 0 1
## Missing values 0 0 0 0 26 0
## Sorted FALSE FALSE 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 69 65 1.73
## Maximum 1820 1890 80 1.73
## Mean 886 957 72.4 1.73
## Unique (excld. NA) 26 26 6 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE
##
## j.rel1 j.NH31 dt.min dt.max ct.min ct.max
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.00103 0.0571 0.27 1.73 1.73 112
## Maximum 0.0901 5.47 1.6 3.47 1.73 137
## Mean 0.027 1.64 0.872 1.8 1.73 124
## Unique (excld. NA) 26 26 3 2 1 6
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE TRUE FALSE
##
## t.start.p t.end.p air.temp.z
## Class POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 2020-06-03 14:41:00 2020-06-08 05:29:00 2
## Maximum 2021-03-16 18:00:00 2021-03-21 21:47:00 2
## Mean 2020-09-01 17:29:41 2020-09-06 20:21:36 2
## Unique (excld. NA) 26 26 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 0 26 26 26
## Sorted TRUE <NA> <NA> <NA>
##
## pub.info
## Class character
## Minimum Pedersen, J., Nyord T. 2023. Effect of low-dose acidification of slurry digestate on ammonia emissions after field application (Short Communication). Atmospheric Environment: X. 17, 100205. 10.1016/j.aeaoa.2023.100205 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., 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) 2
## Missing values 0
## Sorted TRUE
##
## soil.type2 exper2 rep2 acid
## Class logical logical logical logical
## Minimum <NA> <NA> <NA> FALSE
## Maximum <NA> <NA> <NA> TRUE
## Mean <NA> <NA> <NA> 0.307692307692308 TRUE
## Unique (excld. NA) 0 0 0 2
## Missing values 26 26 26 0
## Sorted <NA> <NA> <NA> FALSE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum Wind tunnel wt Grass Cattle
## Maximum Wind tunnel wt Grass Cattle
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## app.method.orig app.method2 incorp.orig date.start
## Class character character character Date
## Minimum Open slot injection os None 2020-06-03
## Maximum Trailing shoe ts None 2021-03-16
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 2 1 3
## Missing values 0 0 0 0
## Sorted FALSE FALSE TRUE TRUE
## Interval-level emission data
##
## 1883 rows and 137 columns
## 1883 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:20C.F:Holstebro1.P:1.T:Bomech.R:1.R2:.T:2020-03-06 14:41:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:21A.F:Holstebro3.P:9.T:Bomech.R:3.R2:.T:2021-03-16 17:28:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 26
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class character character character character numeric numeric
## Minimum AC NUGA 20C Holstebro1 1 1
## Maximum C NUGA 21A Holstebro3 12 3
## Mean <NA> <NA> <NA> <NA> 6.41 2.04
## Unique (excld. NA) 2 1 3 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 Bomech Wind tunnel <NA> 0.2 56.4
## Maximum Disc Wind tunnel <NA> 0.2 56.4
## Mean <NA> <NA> <NA> 0.2 56.4
## Unique (excld. NA) 3 1 0 1 3
## Missing values 0 0 1883 0 0
## Sorted FALSE TRUE <NA> TRUE FALSE
##
## long country topo clay silt sand oc
## Class numeric character character logical logical logical logical
## Minimum 8.87 DK Flat <NA> <NA> <NA> <NA>
## Maximum 8.9 DK Flat <NA> <NA> <NA> <NA>
## Mean 8.88 <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 1 0 0 0 0
## Missing values 0 0 0 1883 1883 1883 1883
## Sorted FALSE TRUE TRUE <NA> <NA> <NA> <NA>
##
## soil.type soil.water soil.water.v soil.moist soil.ph
## Class character numeric logical logical numeric
## Minimum Sand 0.1 <NA> <NA> 5.94
## Maximum Sand 0.29 <NA> <NA> 6.3
## Mean <NA> 0.189 <NA> <NA> 6.08
## Unique (excld. NA) 1 3 0 0 3
## Missing values 0 0 1883 1883 0
## Sorted TRUE TRUE <NA> <NA> TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.27 Yes No cat <NA>
## Maximum 1.39 Yes No cat <NA>
## Mean 1.33 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 1 1 0
## Missing values 0 0 0 0 1883
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1
## Class character character character
## Minimum Straw Slurry Anaerobic digestion
## Maximum Straw Slurry Anaerobic digestion
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## man.trt2 man.trt3 man.stor man.dm man.vs
## Class character character logical numeric logical
## Minimum Mechanical separation Acidification <NA> 3.35 <NA>
## Maximum Mechanical separation None <NA> 5.92 <NA>
## Mean <NA> <NA> <NA> 5.11 <NA>
## Unique (excld. NA) 1 2 0 3 0
## Missing values 0 0 1883 0 1883
## Sorted TRUE FALSE <NA> FALSE <NA>
##
## man.tkn man.tan man.tic man.ua man.vfa man.ph
## Class numeric numeric logical logical logical numeric
## Minimum 3.51 2.43 <NA> <NA> <NA> 7.28
## Maximum 3.6 3.01 <NA> <NA> <NA> 7.81
## Mean 3.56 2.61 <NA> <NA> <NA> 7.57
## Unique (excld. NA) 3 2 0 0 0 6
## Missing values 0 0 1883 1883 1883 0
## Sorted FALSE TRUE <NA> <NA> <NA> FALSE
##
## app.start app.end app.method app.rate
## Class POSIXct, POSIXt POSIXct, POSIXt character numeric
## Minimum 2020-03-06 14:41:00 2020-03-06 14:41:00 os 18.5
## Maximum 2021-03-16 17:52:00 2021-03-16 17:52:00 ts 25
## Mean 2020-09-08 14:59:26 2020-09-08 14:59:26 <NA> 23
## Unique (excld. NA) 26 26 2 2
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## app.rate.unit incorp time.incorp man.area dist.inj
## Class character character numeric logical logical
## Minimum t/ha none <NA> <NA> <NA>
## Maximum t/ha none <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 0 0 0
## Missing values 0 0 1883 1883 1883
## 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> grass <NA> <NA> <NA>
## Maximum <NA> <NA> grass <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 0 0 0
## Missing values 1883 1883 0 1883 1883 1883
## Sorted <NA> <NA> TRUE <NA> <NA> <NA>
##
## notes.plot row.in.file.plot institute sub.period
## Class character numeric character numeric
## Minimum . 5 AU 3
## Maximum . 30 AU 3
## Mean <NA> 17.8 <NA> 3
## Unique (excld. NA) 1 26 1 1
## Missing values 1818 0 0 0
## Sorted TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 3/16/2021 16:24 3/16/2021 16:24
## Maximum 6/9/2020 15:53 6/9/2020 15:53
## Mean <NA> <NA>
## Unique (excld. NA) 26 26
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:20C.F:Holstebro1.P:1.T:Bomech.R:1.R2:.T:2020-03-06 14:41:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220126_JP_20CD21A_JP.xlsx.E:21A.F:Holstebro3.P:9.T:Bomech.R:3.R2:.T:2021-03-16 17:28:00
## Mean <NA>
## Unique (excld. NA) 26
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:NUGA.E:20C Pedersen, Johanna 55.7
## Maximum D:1.I:AU.Pr:NUGA.E:21A Pedersen, Johanna 60.8
## Mean <NA> <NA> <NA> 59.2
## Unique (excld. NA) 3 1 1 2
## 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 2020-06-03 14:41:00 2020-06-03 16:25:00 0.27
## Maximum 80 2021-03-21 21:47:00 2021-03-21 23:31:00 3.47
## Mean 37 2020-09-05 01:05:31 2020-09-05 02:48:45 1.72
## Unique (excld. NA) 80 1877 1877 6
## 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.00238 ppm 0 kg N/ha-hr <NA>
## Maximum <NA> 0.106 ppm 5.47 kg N/ha-hr <NA>
## Mean <NA> 0.0176 <NA> 0.171 <NA> <NA>
## Unique (excld. NA) 0 216 1 1766 1 0
## Missing values 1883 20 20 0 0 1883
## 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 -4.65 2 0.695 0.05 <NA>
## Maximum 23.3 2 28.1 0.05 <NA>
## Mean 10.7 2 11.6 <NA> <NA>
## Unique (excld. NA) 1293 1 1046 1 0
## Missing values 0 20 0 20 1883
## 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 1883 0 1883 1883 1883 1883 1883
## 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 1883 0 1883 1883 1883 1882
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character character
## Minimum 5 emission rate 03-06-2020 14:41
## Maximum 1890 emission rate 21-03-2021 21:47
## Mean 946 <NA> <NA>
## Unique (excld. NA) 1883 1 1877
## 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 03-06-2020 14:41 kg NH3/ha-hr 0 0.822
## Maximum 21-03-2021 21:47 kg NH3/ha-hr 6.65 0.822
## Mean <NA> <NA> 0.207 0.822
## Unique (excld. NA) 1877 1 1747 1
## Missing values 0 20 20 20
## 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.267 -0.00333 1.73 0.865 -2140 -2140
## Maximum 3.47 0.0133 137 136 2250 2250 m i
## Mean 1.72 -0.00322 63.2 62.4 -84.2 -85.9 <NA>
## Unique (excld. NA) 7 6 258 259 371 371 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 <NA> 0 0.0988 0.0988 0.00177
## Maximum 0 0 <NA> 9.47 34.1 34.1 0.561
## Mean 0 0 <NA> 0.292 17.2 17.2 0.286
## Unique (excld. NA) 1 1 0 1766 1777 1777 1777
## Missing values 0 0 1883 0 0 0 0
## Sorted TRUE TRUE <NA> FALSE FALSE FALSE FALSE
##
## j.rel
## Class numeric
## Minimum 0
## Maximum 0.0901
## Mean 0.00284
## Unique (excld. NA) 1766
## Missing values 0
## Sorted FALSE
##
## pub.info
## Class character
## Minimum Pedersen, J., Nyord T. 2023. Effect of low-dose acidification of slurry digestate on ammonia emissions after field application (Short Communication). Atmospheric Environment: X. 17, 100205. 10.1016/j.aeaoa.2023.100205 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., 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) 2
## Missing values 0
## Sorted TRUE
##
## soil.type2 exper2 rep2 acid
## Class logical logical logical logical
## Minimum <NA> <NA> <NA> FALSE
## Maximum <NA> <NA> <NA> TRUE
## Mean <NA> <NA> <NA> 0.30801911842804 TRUE
## Unique (excld. NA) 0 0 0 2
## Missing values 1883 1883 1883 0
## Sorted <NA> <NA> <NA> FALSE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum Wind tunnel wt Grass Cattle
## Maximum Wind tunnel wt Grass Cattle
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## app.method.orig app.method2 incorp.orig date.start
## Class character character character Date
## Minimum Open slot injection os None 2020-06-03
## Maximum Trailing shoe ts None 2020-06-03
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 2 1 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE TRUE TRUE
##
## first.row.int row.plot first.rows ggplotgroup
## Class numeric numeric factor factor
## Minimum 5 5 Plots 10 Emis. 330 (4.97,10]
## Maximum 1820 30 Plots 9 Emis. 265 (25,30]
## Mean 910 17.8 Plots 22 Emis. 749 (15,20]
## Unique (excld. NA) 26 26 26 5
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##