Submitted data error checks
0. Instructions for submitters
Submitters should use this file to check for problems with submitted data. Send either a list of problems or confirmation that everything looks OK to Sasha by email. Be sure to reference the dataset version and file creation date/time when doing so. These are:
## Version: 2.47## [1] "Date/time: 2024-04-04 14:51:26.552502"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 | 230726 |
2. Contributors
| contributor | institute |
|---|---|
| Nyord, Tavs | Aarhus University |
| Feilberg, Anders | Aarhus University |
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.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
## [1] "Problem, see following rows (compare start time to end time in previous rows):"
## [1] 667
## OK
## OK
## OK
## [1] "Problem, see following rows (compare start time to end time in previous rows):"
## [1] 920
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 1789 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 1789 |
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 : No values to check.
## 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 : 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 soil.type soil.water.v soil.moist soil.ph
## 1789 1789 1789 1789 576
## man.source.det man.bed man.trt2 man.trt3 man.stor
## 1789 1789 1789 1789 1789
## man.vs man.tic man.ua man.vfa time.incorp
## 1789 1789 1789 1789 1789
## man.area dist.inj furrow.z furrow.w crop.z
## 1789 1789 1789 1789 1789
## crop.area lai notes.plot bg.dl pH.surf
## 1789 1789 1724 1789 1789
## soil.temp soil.temp.z soil.temp.surf rad MOL
## 1789 1789 1789 1789 1789
## ustar rl air.pres air.pres.unit rh
## 1789 1789 1789 1789 1789
## wind.loc far.loc notes.int soil.type2 exper2
## 1789 1789 1788 1789 1789
## rep2
## 1789Application 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 184 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_6_1_230726_JP_19G20AB.xlsx.E:19G.F:Foulumgård.P:1.T:Trailing hose.R:1.R2:.T:2019-05-15 16:48:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx.E:20B.F:Flakkebjerg.P:9.T:Trailing shoe.R:3.R2:.T:2020-04-23 13:44:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep plot.area
## Class character character character numeric numeric numeric
## Minimum NUGA 19G Flakkebjerg 1 1 0.2
## Maximum NUGA 20B Foulumgård 12 3 0.2
## Mean <NA> <NA> <NA> 6.33 2 0.2
## Unique (excld. NA) 1 3 2 9 3 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE FALSE FALSE FALSE TRUE
##
## lat long country topo clay silt sand
## Class numeric numeric character character numeric numeric numeric
## Minimum 55.3 9.56 DK Flat 4 5 61
## Maximum 56.5 11.4 DK Flat 19 18 89
## Mean 55.7 10.8 <NA> <NA> 14 13.7 70.3
## Unique (excld. NA) 2 2 1 1 2 2 2
## Missing values 0 0 0 0 0 0 0
## Sorted FALSE 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.13 <NA> <NA> 6.52
## Maximum 2 <NA> 0.164 <NA> <NA> 6.62
## Mean 2 <NA> 0.148 <NA> <NA> 6.57
## Unique (excld. NA) 1 0 3 0 0 2
## Missing values 0 27 0 27 27 9
## Sorted TRUE <NA> FALSE <NA> <NA> TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.47 Yes No pig <NA>
## Maximum 1.7 Yes No pig <NA>
## Mean 1.57 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 1 1 0
## Missing values 0 0 0 0 27
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.trt3 man.stor
## Class logical character character logical logical logical
## Minimum <NA> Slurry None <NA> <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0 0
## Missing values 27 0 0 27 27 27
## Sorted <NA> TRUE TRUE <NA> <NA> <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical logical
## Minimum 3.27 <NA> 2.5 1.55 <NA> <NA> <NA>
## Maximum 6.46 <NA> 4.85 3.76 <NA> <NA> <NA>
## Mean 4.89 <NA> 3.84 2.94 <NA> <NA> <NA>
## Unique (excld. NA) 3 0 3 3 0 0 0
## Missing values 0 27 0 0 27 27 27
## Sorted FALSE <NA> TRUE TRUE <NA> <NA> <NA>
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.51 2019-05-15 16:48:00 2019-05-15 16:48:00 bsth
## Maximum 7.82 2020-04-23 14:08:00 2020-04-23 14:08:00 ts
## Mean 7.7 2019-12-28 22:53:20 2019-12-28 22:53:20 <NA>
## Unique (excld. NA) 3 27 27 2
## Missing values 0 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 23 t/ha none <NA> <NA>
## Maximum 30 t/ha none <NA> <NA>
## Mean 27.7 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 27 27
## Sorted TRUE 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> cereal <NA> <NA>
## Maximum <NA> <NA> <NA> cereal <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 1 0 0
## Missing values 27 27 27 0 27 27
## Sorted <NA> <NA> <NA> TRUE <NA> <NA>
##
## lai notes.plot row.in.file.plot institute sub.period
## Class logical character numeric character numeric
## Minimum <NA> . 5 AU 3
## Maximum <NA> . 31 AU 3
## Mean <NA> <NA> 18 <NA> 3
## Unique (excld. NA) 0 1 27 1 1
## Missing values 27 26 0 0 0
## Sorted <NA> TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.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 NUGA Wind tunnel <NA> 15-05-2019 16:48
## Maximum Trailing shoe Wind tunnel <NA> 23-04-2020 14:08
## 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-2019 16:48
## Maximum 23-04-2020 14:08
## 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_6_1_230726_JP_19G20AB.xlsx.E:19G.F:Foulumgård.P:1.T:Trailing hose.R:1.R2:.T:2019-05-15 16:48:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx.E:20B.F:Flakkebjerg.P:9.T:Trailing shoe.R:3.R2:.T:2020-04-23 13:44: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:19G Pedersen, Johanna 35.6
## Maximum D:1.I:AU.Pr:NUGA.E:20B Pedersen, Johanna 113
## Mean <NA> <NA> <NA> 84.7
## Unique (excld. NA) 3 1 1 3
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## 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.727 1 1.36 2.06 2.6 2.92
## Maximum <NA> 20.5 24.7 30 35.4 43 47.6
## Mean <NA> 8.26 10.4 13.5 16.8 21.7 24.1
## 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 3.13 <NA> 3.23 3.23 <NA> 0.727 1
## Maximum 50.5 <NA> 52.7 52.7 <NA> 20.5 24.7
## Mean 25.9 <NA> 27.1 27.1 <NA> 8.26 10.4
## Unique (excld. NA) 27 0 27 27 0 27 27
## Missing values 0 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 1.36 2.06 2.6 2.92 3.13 <NA>
## Maximum 30 35.4 43 47.6 50.5 <NA>
## Mean 13.5 16.8 21.7 24.1 25.9 <NA>
## Unique (excld. NA) 27 27 27 27 27 0
## Missing values 0 0 0 0 0 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 3.23 3.23 <NA> 0.0204 0.0282 0.0382
## Maximum 52.7 52.7 <NA> 0.182 0.219 0.266
## Mean 27.1 27.1 <NA> 0.083 0.105 0.136
## 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.0577 0.0728 0.0819 0.0877 <NA> 0.0905
## Maximum 0.314 0.381 0.422 0.448 <NA> 0.467
## Mean 0.172 0.22 0.245 0.263 <NA> 0.275
## Unique (excld. NA) 27 27 27 27 0 27
## Missing values 0 0 0 0 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.0905 <NA> 0 0 0 0 0
## Maximum 0.467 <NA> 0 0 0 0 0
## Mean 0.275 <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 0 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 10.1 8.75 5.37 5.69 6.2
## Maximum 17.2 16.6 12.9 11.5 11.9
## Mean 13.8 12.9 9.78 8.97 9.15
## Unique (excld. NA) 14 17 21 26 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 wind.1
## Class numeric numeric numeric numeric numeric
## Minimum 6.45 7.04 7.24 7.24 <NA>
## Maximum 11.5 12.1 12.3 12.3 <NA>
## Mean 8.83 9.08 9.31 9.31 <NA>
## Unique (excld. NA) 27 27 27 27 0
## Missing values 0 0 0 0 27
## Sorted FALSE FALSE FALSE FALSE <NA>
##
## wind.4 wind.6 wind.12 wind.24 wind.48 wind.72 wind.96
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Maximum 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Mean 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Unique (excld. NA) 1 1 1 1 1 1 1
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE TRUE
##
## wind.168 wind.mn wind.2m.1 wind.2m.4 wind.2m.6 wind.2m.12
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.33 0.33 <NA> 0.543 0.543 0.543
## Maximum 0.33 0.33 <NA> 0.543 0.543 0.543
## Mean 0.33 0.33 <NA> 0.543 0.543 0.543
## Unique (excld. NA) 2 2 0 1 1 1
## Missing values 0 0 27 0 0 0
## Sorted FALSE FALSE <NA> TRUE TRUE TRUE
##
## wind.2m.24 wind.2m.48 wind.2m.72 wind.2m.96 wind.2m.168
## Class numeric numeric numeric numeric numeric
## Minimum 0.543 0.543 0.543 0.543 0.543
## Maximum 0.543 0.543 0.543 0.543 0.543
## Mean 0.543 0.543 0.543 0.543 0.543
## Unique (excld. NA) 1 1 1 1 1
## Missing values 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE
##
## wind.2m.mn rain.rate.1 rain.rate.4 rain.rate.6 rain.rate.12
## Class numeric numeric numeric numeric numeric
## Minimum 0.543 <NA> 0 0 0
## Maximum 0.543 <NA> 0 0 0
## Mean 0.543 <NA> 0 0 0
## Unique (excld. NA) 1 0 1 1 1
## Missing values 0 27 0 0 0
## Sorted TRUE <NA> TRUE TRUE TRUE
##
## rain.rate.24 rain.rate.48 rain.rate.72 rain.rate.96
## 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.168 rain.rate.mn first.row.in.file.int
## Class numeric numeric numeric
## Minimum 0 0 5
## Maximum 0 0 1730
## Mean 0 0 856
## Unique (excld. NA) 1 1 27
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## last.row.in.file.int n.ints dt1 j.rel1 j.NH31 dt.min
## Class numeric integer numeric numeric numeric numeric
## Minimum 69 60 1.73 0.00507 0.181 1.73
## Maximum 1790 68 1.73 0.0595 6.72 1.73
## Mean 921 66.3 1.73 0.0246 2.46 1.73
## Unique (excld. NA) 27 6 1 27 27 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE FALSE TRUE FALSE FALSE TRUE
##
## dt.max ct.min ct.max t.start.p
## Class numeric numeric numeric POSIXct, POSIXt
## Minimum 1.73 1.73 104 2019-05-15 16:48:00
## Maximum 1.73 1.73 118 2020-04-23 14:08:00
## Mean 1.73 1.73 115 2019-12-28 22:53:20
## Unique (excld. NA) 1 1 6 27
## Missing values 0 0 0 0
## Sorted TRUE TRUE FALSE FALSE
##
## t.end.p air.temp.z soil.temp.z wind.z wind.loc
## Class POSIXct, POSIXt numeric logical numeric logical
## Minimum 2019-05-20 07:28:00 2 <NA> 0.25 <NA>
## Maximum 2020-04-28 09:35:00 2 <NA> 0.25 <NA>
## Mean 2020-01-02 16:44:40 2 <NA> 0.25 <NA>
## Unique (excld. NA) 27 1 0 1 0
## Missing values 0 0 27 0 27
## Sorted FALSE TRUE <NA> TRUE <NA>
##
## far.loc
## Class logical
## Minimum <NA>
## Maximum <NA>
## Mean <NA>
## Unique (excld. NA) 0
## Missing values 27
## Sorted <NA>
##
## pub.info
## Class character
## Minimum McCollough, M. R., Pedersen, J., Nyord, T., Sørensen, P., Melander, B. 2022. Ammonia emissions, exposed surface area, and crop and weed responses resulting from three post-emergence slurry application stretegies in cereals. Agronomy 12, 2441. https://doi.org/10.3390/agronomy12102441.
## Maximum McCollough, M. R., Pedersen, J., Nyord, T., Sørensen, P., Melander, B. 2022. Ammonia emissions, exposed surface area, and crop and weed responses resulting from three post-emergence slurry application stretegies in cereals. Agronomy 12, 2441. https://doi.org/10.3390/agronomy12102441.
## 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 3
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## app.method2 incorp.orig date.start
## Class character character Date
## Minimum bsth None 2019-05-15
## Maximum ts None 2020-04-23
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 2 1 3
## Missing values 0 0 0
## Sorted FALSE TRUE TRUE
## Interval-level emission data
##
## 1789 rows and 137 columns
## 1789 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx.E:19G.F:Foulumgård.P:1.T:Trailing hose.R:1.R2:.T:2019-05-15 16:48:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx.E:20B.F:Flakkebjerg.P:9.T:Trailing shoe.R:3.R2:.T:2020-04-23 13:44:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 27
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class character character character character numeric numeric
## Minimum a NUGA 19G Flakkebjerg 1 1
## Maximum a NUGA 20B Foulumgård 12 3
## Mean <NA> <NA> <NA> <NA> 6.29 1.99
## Unique (excld. NA) 1 1 3 2 9 3
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE FALSE
##
## treat meas.tech meas.tech.det plot.area lat
## Class character character logical numeric numeric
## Minimum NUGA Wind tunnel <NA> 0.2 55.3
## Maximum Trailing shoe Wind tunnel <NA> 0.2 56.5
## Mean <NA> <NA> <NA> 0.2 55.7
## Unique (excld. NA) 3 1 0 1 2
## Missing values 0 0 1789 0 0
## Sorted FALSE TRUE <NA> TRUE FALSE
##
## long country topo clay silt sand oc
## Class numeric character character numeric numeric numeric numeric
## Minimum 9.56 DK Flat 4 5 61 2
## Maximum 11.4 DK Flat 19 18 89 2
## Mean 10.8 <NA> <NA> 14.2 13.8 70 2
## Unique (excld. NA) 2 1 1 2 2 2 1
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE FALSE TRUE
##
## soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical numeric logical logical numeric
## Minimum <NA> 0.13 <NA> <NA> 6.52
## Maximum <NA> 0.164 <NA> <NA> 6.62
## Mean <NA> 0.148 <NA> <NA> 6.57
## Unique (excld. NA) 0 3 0 0 2
## Missing values 1789 0 1789 1789 576
## Sorted <NA> FALSE <NA> <NA> TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 1.47 Yes No pig <NA>
## Maximum 1.7 Yes No pig <NA>
## Mean 1.57 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 1 1 0
## Missing values 0 0 0 0 1789
## Sorted FALSE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.trt3 man.stor
## Class logical character character logical logical logical
## Minimum <NA> Slurry None <NA> <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0 0
## Missing values 1789 0 0 1789 1789 1789
## Sorted <NA> TRUE TRUE <NA> <NA> <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical logical
## Minimum 3.27 <NA> 2.5 1.55 <NA> <NA> <NA>
## Maximum 6.46 <NA> 4.85 3.76 <NA> <NA> <NA>
## Mean 4.88 <NA> 3.86 2.97 <NA> <NA> <NA>
## Unique (excld. NA) 3 0 3 3 0 0 0
## Missing values 0 1789 0 0 1789 1789 1789
## Sorted FALSE <NA> TRUE TRUE <NA> <NA> <NA>
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.51 2019-05-15 16:48:00 2019-05-15 16:48:00 bsth
## Maximum 7.82 2020-04-23 14:08:00 2020-04-23 14:08:00 ts
## Mean 7.7 2020-01-01 19:44:05 2020-01-01 19:44:05 <NA>
## Unique (excld. NA) 3 27 27 2
## Missing values 0 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 23 t/ha none <NA> <NA>
## Maximum 30 t/ha none <NA> <NA>
## Mean 27.7 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 1789 1789
## Sorted TRUE 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> cereal <NA> <NA>
## Maximum <NA> <NA> <NA> cereal <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 1 0 0
## Missing values 1789 1789 1789 0 1789 1789
## Sorted <NA> <NA> <NA> TRUE <NA> <NA>
##
## lai notes.plot row.in.file.plot institute sub.period
## Class logical character numeric character numeric
## Minimum <NA> . 5 AU 3
## Maximum <NA> . 31 AU 3
## Mean <NA> <NA> 18.1 <NA> 3
## Unique (excld. NA) 0 1 27 1 1
## Missing values 1789 1724 0 0 0
## Sorted <NA> TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 15-05-2019 16:48 15-05-2019 16:48
## Maximum 23-04-2020 14:08 23-04-2020 14:08
## 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_6_1_230726_JP_19G20AB.xlsx.E:19G.F:Foulumgård.P:1.T:Trailing hose.R:1.R2:.T:2019-05-15 16:48:00
## Maximum D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_6_1_230726_JP_19G20AB.xlsx.E:20B.F:Flakkebjerg.P:9.T:Trailing shoe.R:3.R2:.T:2020-04-23 13:44: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:19G Pedersen, Johanna 35.6
## Maximum D:1.I:AU.Pr:NUGA.E:20B Pedersen, Johanna 113
## Mean <NA> <NA> <NA> 85.5
## Unique (excld. NA) 3 1 1 3
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## interval t.start t.end dt
## Class numeric POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 1 2019-05-15 16:48:00 2019-05-15 18:32:00 1.73
## Maximum 68 2020-04-28 09:35:00 2020-04-28 11:19:00 1.73
## Mean 33.7 2020-01-04 04:41:11 2020-01-04 06:25:51 1.73
## Unique (excld. NA) 68 1789 1789 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE
##
## bg.dl bg.val bg.unit j.NH3 j.NH3.unit pH.surf
## Class logical numeric character numeric character logical
## Minimum <NA> 0.00436 ppm 0.00335 kg N/ha-hr <NA>
## Maximum <NA> 0.0664 ppm 6.72 kg N/ha-hr <NA>
## Mean <NA> 0.0159 <NA> 0.236 <NA> <NA>
## Unique (excld. NA) 0 201 1 1789 1 0
## Missing values 1789 0 0 0 0 1789
## Sorted <NA> FALSE TRUE FALSE TRUE <NA>
##
## air.temp air.temp.z soil.temp soil.temp.z soil.temp.surf
## Class numeric numeric numeric logical logical
## Minimum -1.4 2 <NA> <NA> <NA>
## Maximum 19 2 <NA> <NA> <NA>
## Mean 9.26 2 <NA> <NA> <NA>
## Unique (excld. NA) 504 1 0 0 0
## Missing values 0 0 1789 1789 1789
## Sorted FALSE TRUE <NA> <NA> <NA>
##
## rad wind wind.z MOL ustar rl air.pres
## Class logical numeric numeric logical logical logical logical
## Minimum <NA> 0.33 0.25 <NA> <NA> <NA> <NA>
## Maximum <NA> 0.33 0.25 <NA> <NA> <NA> <NA>
## Mean <NA> 0.33 0.25 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0 0 0
## Missing values 1789 0 0 1789 1789 1789 1789
## 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 1789 0 1789 1789 1789 1788
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character character
## Minimum 5 emission rate 15-05-2019 16:48
## Maximum 1790 emission rate 28-04-2020 09:35
## Mean 899 <NA> <NA>
## Unique (excld. NA) 1789 1 1789
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class character character numeric numeric
## Minimum 15-05-2019 16:48 kg N/ha-hr 0.00335 1
## Maximum 28-04-2020 09:35 kg N/ha-hr 6.72 1
## Mean <NA> <NA> 0.236 1
## Unique (excld. NA) 1789 1 1789 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 1.72 -6.94 1.73 0.865 1.72 0
## Maximum 8.67 0.0133 118 117 118 116
## Mean 1.74 -0.0144 58.2 57.4 58.7 57 <NA>
## Unique (excld. NA) 7 7 68 68 185 184 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 0.543 0.0058 0.313 0.313 0.00877
## Maximum 0 0 0.543 11.6 52.7 52.7 0.467
## Mean 0 0 0.543 0.408 21.6 21.6 0.218
## Unique (excld. NA) 1 1 1 1789 1789 1789 1789
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE FALSE FALSE
##
## j.rel
## Class numeric
## Minimum 9.41e-05
## Maximum 0.0595
## Mean 0.0024
## Unique (excld. NA) 1789
## Missing values 0
## Sorted FALSE
##
## pub.info
## Class character
## Minimum McCollough, M. R., Pedersen, J., Nyord, T., Sørensen, P., Melander, B. 2022. Ammonia emissions, exposed surface area, and crop and weed responses resulting from three post-emergence slurry application stretegies in cereals. Agronomy 12, 2441. https://doi.org/10.3390/agronomy12102441.
## Maximum McCollough, M. R., Pedersen, J., Nyord, T., Sørensen, P., Melander, B. 2022. Ammonia emissions, exposed surface area, and crop and weed responses resulting from three post-emergence slurry application stretegies in cereals. Agronomy 12, 2441. https://doi.org/10.3390/agronomy12102441.
## 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 1789 1789 1789 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 3
## 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 2019-05-15 5 5
## Maximum ts None 2019-05-15 1730 31
## Mean <NA> <NA> <NA> 866 18.1
## Unique (excld. NA) 2 1 1 27 27
## Missing values 0 0 0 0 0
## Sorted FALSE TRUE TRUE TRUE FALSE
##
## first.rows ggplotgroup
## Class factor factor
## Minimum Plots 10 Emis. 451 (4.97,10.2]
## Maximum Plots 9 Emis. 386 (25.8,31]
## Mean Plots 23 Emis. 1189 (15.4,20.6]
## Unique (excld. NA) 27 5
## Missing values 0 0
## Sorted FALSE FALSE
##