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:52.134996"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
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.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
## [1] "Missing pub codes in Publications sheet."## [1] "Some pub codes missing in Experiments sheet."Complete 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
## 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
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 2903 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 2903 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit |
|---|---|---|
| kg NH3/ha-hr | 0.8224414 | 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 : OK
## man.ph : OK
## app.rate : OK
## crop.z : OKEmission
## j.NH3 : OK
## e.int : OK
## e.rel : OK8. Missing values
Check for missing values.
All variables
## Some values missing:
## Table below has number of missing observations by variable:
## pub.id meas.tech.det oc soil.type soil.water.v
## 2903 2903 2903 2903 2903
## soil.moist soil.ph man.bed man.trt2 man.trt3
## 2903 978 2903 2903 2903
## man.stor man.vs man.tic man.ua time.incorp
## 2903 2903 2903 2903 2903
## man.area dist.inj furrow.z furrow.w crop.area
## 2903 2903 2903 2903 2903
## lai notes.plot bg.dl pH.surf soil.temp
## 2903 2764 2903 2903 2903
## soil.temp.z soil.temp.surf rad MOL ustar
## 2903 2903 2903 2903 2903
## rl air.pres air.pres.unit rh wind.loc
## 2903 2903 2903 2903 2903
## far.loc notes.int pub.info soil.type2 exper2
## 2903 2902 2903 2903 2903
## rep2
## 2903Application 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
##
## 22 rows and 184 columns
## 22 unique rows
## pub.id
## Class logical
## Minimum <NA>
## Maximum <NA>
## Mean <NA>
## Unique (excld. NA) 0
## Missing values 22
## Sorted <NA>
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:21C.F:FoulumgårdD.P:1.T:AER30.R:1.R2:.T:2021-08-11 16:15:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:22A.F:FoulumgårdD.P:9.T:AER54.R:3.R2:.T:2022-01-05 14:30:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 22
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep plot.area
## Class character character character numeric numeric numeric
## Minimum eGylle 21C FoulumgårdD 1 1 0.2
## Maximum eGylle 22A FoulumgårdD 12 3 0.2
## Mean <NA> <NA> <NA> 5.5 1.82 0.2
## Unique (excld. NA) 1 3 1 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.56 DK Flat 9 24 65
## Maximum 56.5 9.56 DK Flat 9 24 65
## Mean 56.5 9.56 <NA> <NA> 9 24 65
## 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
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical logical numeric logical logical numeric
## Minimum <NA> <NA> 0.21 <NA> <NA> 5.24
## Maximum <NA> <NA> 0.27 <NA> <NA> 5.55
## Mean <NA> <NA> 0.232 <NA> <NA> 5.4
## Unique (excld. NA) 0 0 2 0 0 2
## Missing values 22 22 0 22 22 8
## Sorted <NA> <NA> TRUE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source
## Class numeric character character character
## Minimum 1.38 Yes No mix
## Maximum 1.38 Yes No mix
## Mean 1.38 <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## man.source.det
## Class character
## Minimum Primarily cattle slurry, but also some pig slurry and silage
## Maximum Primarily cattle slurry, but also some pig slurry and silage
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## man.bed man.con man.trt1 man.trt2 man.trt3
## Class logical character character logical logical
## Minimum <NA> Slurry Anaerobic digestion <NA> <NA>
## Maximum <NA> Slurry Anaerobic digestion <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0
## Missing values 22 0 0 22 22
## Sorted <NA> TRUE TRUE <NA> <NA>
##
## man.stor man.dm man.vs man.tkn man.tan man.tic man.ua
## Class logical numeric logical numeric numeric logical logical
## Minimum <NA> 4.47 <NA> 2.49 1.72 <NA> <NA>
## Maximum <NA> 5.31 <NA> 2.8 1.95 <NA> <NA>
## Mean <NA> 4.89 <NA> 2.69 1.85 <NA> <NA>
## Unique (excld. NA) 0 3 0 2 3 0 0
## Missing values 22 0 22 0 0 22 22
## Sorted <NA> FALSE <NA> FALSE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 0.16 7.7 2021-08-11 16:15:00 2021-08-11 16:15:00
## Maximum 0.51 7.9 2022-01-05 14:54:00 2022-01-05 14:54:00
## Mean 0.316 7.84 2021-10-06 21:44:38 2021-10-06 21:44:38
## Unique (excld. NA) 3 2 22 22
## Missing values 0 0 0 0
## Sorted FALSE TRUE FALSE FALSE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 35.9 t/ha none <NA>
## Maximum bsth 35.9 t/ha none <NA>
## Mean <NA> 35.9 <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1 0
## Missing values 0 0 0 0 22
## Sorted TRUE 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> stubble 10
## Maximum <NA> <NA> <NA> <NA> stubble 10
## Mean <NA> <NA> <NA> <NA> <NA> 10
## Unique (excld. NA) 0 0 0 0 1 1
## Missing values 22 22 22 22 0 0
## Sorted <NA> <NA> <NA> <NA> TRUE TRUE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 26 AU
## Mean <NA> <NA> <NA> 15.5 <NA>
## Unique (excld. NA) 0 0 1 22 1
## Missing values 22 22 21 0 0
## Sorted <NA> <NA> TRUE FALSE 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_6_1_220317_JP_21CD22A.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.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 AER20 Wind tunnel <NA> 05-01-2022 13:26
## Maximum AER7 Wind tunnel <NA> 20-08-2021 11:55
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 5 1 0 22
## Missing values 0 0 22 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 05-01-2022 13:26
## Maximum 20-08-2021 11:55
## Mean <NA>
## Unique (excld. NA) 22
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:21C.F:FoulumgårdD.P:1.T:AER30.R:1.R2:.T:2021-08-11 16:15:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:22A.F:FoulumgårdD.P:9.T:AER54.R:3.R2:.T:2022-01-05 14:30:00
## Mean <NA>
## Unique (excld. NA) 22
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:eGylle.E:21C Pedersen, Johanna 61.7
## Maximum D:1.I:AU.Pr:eGylle.E:22A Pedersen, Johanna 70
## Mean <NA> <NA> <NA> 66.4
## 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.07 1.94 4.09 7.09 10 11.6
## Maximum <NA> 12.8 17.2 24.7 29 33.2 35.4
## Mean <NA> 7.77 10.7 15.8 20.8 24.9 27
## Unique (excld. NA) 0 22 22 22 22 22 22
## Missing values 22 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 12.5 14.7 16.1 16.1 <NA> 1.07 1.94
## Maximum 36.8 39.2 39.4 39.4 <NA> 12.8 17.2
## Mean 28.3 30.7 31.4 31.4 <NA> 7.77 10.7
## Unique (excld. NA) 22 22 22 22 0 22 22
## Missing values 0 0 0 0 22 0 0
## Sorted FALSE FALSE FALSE FALSE <NA> FALSE FALSE
##
## e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96 e.cum.168
## Class numeric numeric numeric numeric numeric numeric
## Minimum 4.09 7.09 10 11.6 12.5 14.7
## Maximum 24.7 29 33.2 35.4 36.8 39.2
## Mean 15.8 20.8 24.9 27 28.3 30.7
## Unique (excld. NA) 22 22 22 22 22 22
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.cum.final e.cum.tot e.rel.1 e.rel.4 e.rel.6 e.rel.12
## Class numeric numeric numeric numeric numeric numeric
## Minimum 16.1 16.1 <NA> 0.0173 0.0314 0.0663
## Maximum 39.4 39.4 <NA> 0.187 0.245 0.353
## Mean 31.4 31.4 <NA> 0.114 0.158 0.234
## Unique (excld. NA) 22 22 0 22 22 22
## Missing values 0 0 22 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.115 0.162 0.187 0.203 0.239 0.261
## Maximum 0.417 0.487 0.519 0.538 0.566 0.585
## Mean 0.31 0.372 0.403 0.424 0.459 0.471
## Unique (excld. NA) 22 22 22 22 22 22
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.rel.tot rain.1 rain.4 rain.6 rain.12 rain.24 rain.48
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0.261 <NA> 0 0 0 0 0
## Maximum 0.585 <NA> 0 0 0 0 0
## Mean 0.471 <NA> 0 0 0 0 0
## Unique (excld. NA) 22 0 1 1 1 1 1
## Missing values 0 22 0 0 0 0 0
## Sorted FALSE <NA> TRUE TRUE TRUE TRUE TRUE
##
## rain.72 rain.96 rain.168 rain.final rain.tot air.temp.1
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0 0 0 0 0 <NA>
## Maximum 0 0 0 0 0 <NA>
## Mean 0 0 0 0 0 <NA>
## Unique (excld. NA) 1 1 1 1 1 0
## Missing values 0 0 0 0 0 22
## Sorted TRUE TRUE TRUE TRUE TRUE <NA>
##
## air.temp.4 air.temp.6 air.temp.12 air.temp.24 air.temp.48
## Class numeric numeric numeric numeric numeric
## Minimum 1 0.667 0.2 -1 0.167
## Maximum 19.2 18.6 15.8 16.9 17.4
## Mean 11.8 11.4 10 9.33 9.85
## Unique (excld. NA) 13 13 15 15 17
## 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 0.571 0.733 1.11 3.09 <NA>
## Maximum 16.9 16.6 15.6 17 <NA>
## Mean 9.9 9.99 10 11.6 <NA>
## Unique (excld. NA) 19 17 19 19 0
## Missing values 0 0 0 0 22
## 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.1 0.1 0.1 0.1 0.1 0.1 0.1
## Maximum 0.72 0.72 0.72 0.72 0.72 0.72 0.72
## Mean 0.367 0.367 0.367 0.367 0.367 0.367 0.367
## Unique (excld. NA) 7 8 7 6 6 8 6
## Missing values 0 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##
## 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.1 0.108 <NA> 0.1 0.1 0.1
## Maximum 0.72 0.906 <NA> 0.72 0.72 0.72
## Mean 0.367 0.424 <NA> 0.367 0.367 0.367
## Unique (excld. NA) 6 10 0 7 8 7
## Missing values 0 0 22 0 0 0
## Sorted FALSE FALSE <NA> FALSE FALSE FALSE
##
## wind.2m.24 wind.2m.48 wind.2m.72 wind.2m.96 wind.2m.168
## Class numeric numeric numeric numeric numeric
## Minimum 0.1 0.1 0.1 0.1 0.1
## Maximum 0.72 0.72 0.72 0.72 0.72
## Mean 0.367 0.367 0.367 0.367 0.367
## Unique (excld. NA) 6 6 8 6 6
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE
##
## wind.2m.mn rain.rate.1 rain.rate.4 rain.rate.6 rain.rate.12
## Class numeric numeric numeric numeric numeric
## Minimum 0.108 <NA> 0 0 0
## Maximum 0.906 <NA> 0 0 0
## Mean 0.424 <NA> 0 0 0
## Unique (excld. NA) 10 0 1 1 1
## Missing values 0 22 0 0 0
## Sorted FALSE <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 2790
## Mean 0 0 1430
## Unique (excld. NA) 1 1 22
## 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 143 122 1.33 0.00187 0.115 1.33
## Maximum 2910 139 1.73 0.0519 3.54 1.73
## Mean 1560 132 1.48 0.0281 1.92 1.48
## Unique (excld. NA) 22 4 2 22 22 2
## 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.33 1.33 181 2021-08-11 16:15:00
## Maximum 1.73 1.73 215 2022-01-05 14:54:00
## Mean 1.48 1.48 193 2021-10-06 21:18:35
## Unique (excld. NA) 2 2 4 22
## 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 2021-08-19 08:10:00 2 <NA> 2 <NA>
## Maximum 2022-01-14 08:31:00 2 <NA> 2 <NA>
## Mean 2021-10-14 21:44:00 2 <NA> 2 <NA>
## Unique (excld. NA) 22 1 0 1 0
## Missing values 0 0 22 0 22
## Sorted FALSE TRUE <NA> TRUE <NA>
##
## far.loc pub.info soil.type2 exper2 rep2 acid
## Class logical character logical logical logical logical
## Minimum <NA> <NA> <NA> <NA> <NA> FALSE
## Maximum <NA> <NA> <NA> <NA> <NA> FALSE
## Mean <NA> <NA> <NA> <NA> <NA> 0 TRUE
## Unique (excld. NA) 0 0 0 0 0 1
## Missing values 22 22 22 22 22 0
## Sorted <NA> <NA> <NA> <NA> <NA> TRUE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum Wind tunnel wt Stubble Mix
## Maximum Wind tunnel wt Stubble Mix
## 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
## Class character character character
## Minimum Band spread or trailing hose bsth None
## Maximum Band spread or trailing hose bsth None
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## date.start
## Class Date
## Minimum 2021-08-11
## Maximum 2022-01-05
## Mean <NA>
## Unique (excld. NA) 3
## Missing values 0
## Sorted TRUE
## Interval-level emission data
##
## 2903 rows and 137 columns
## 2903 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:21C.F:FoulumgårdD.P:1.T:AER30.R:1.R2:.T:2021-08-11 16:15:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:22A.F:FoulumgårdD.P:9.T:AER54.R:3.R2:.T:2022-01-05 14:30:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 22
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class logical character character character numeric numeric
## Minimum <NA> eGylle 21C FoulumgårdD 1 1
## Maximum <NA> eGylle 22A FoulumgårdD 12 3
## Mean <NA> <NA> <NA> <NA> 5.47 1.81
## Unique (excld. NA) 0 1 3 1 9 3
## Missing values 2903 0 0 0 0 0
## Sorted <NA> TRUE TRUE TRUE FALSE FALSE
##
## treat meas.tech meas.tech.det plot.area lat
## Class character character logical numeric numeric
## Minimum AER20 Wind tunnel <NA> 0.2 56.5
## Maximum AER7 Wind tunnel <NA> 0.2 56.5
## Mean <NA> <NA> <NA> 0.2 56.5
## Unique (excld. NA) 5 1 0 1 1
## Missing values 0 0 2903 0 0
## Sorted FALSE TRUE <NA> TRUE TRUE
##
## long country topo clay silt sand oc
## Class numeric character character numeric numeric numeric logical
## Minimum 9.56 DK Flat 9 24 65 <NA>
## Maximum 9.56 DK Flat 9 24 65 <NA>
## Mean 9.56 <NA> <NA> 9 24 65 <NA>
## Unique (excld. NA) 1 1 1 1 1 1 0
## Missing values 0 0 0 0 0 0 2903
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE <NA>
##
## soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical numeric logical logical numeric
## Minimum <NA> 0.21 <NA> <NA> 5.24
## Maximum <NA> 0.27 <NA> <NA> 5.55
## Mean <NA> 0.23 <NA> <NA> 5.4
## Unique (excld. NA) 0 2 0 0 2
## Missing values 2903 0 2903 2903 978
## Sorted <NA> TRUE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source
## Class numeric character character character
## Minimum 1.38 Yes No mix
## Maximum 1.38 Yes No mix
## Mean 1.38 <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## man.source.det
## Class character
## Minimum Primarily cattle slurry, but also some pig slurry and silage
## Maximum Primarily cattle slurry, but also some pig slurry and silage
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## man.bed man.con man.trt1 man.trt2 man.trt3
## Class logical character character logical logical
## Minimum <NA> Slurry Anaerobic digestion <NA> <NA>
## Maximum <NA> Slurry Anaerobic digestion <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 1 0 0
## Missing values 2903 0 0 2903 2903
## Sorted <NA> TRUE TRUE <NA> <NA>
##
## man.stor man.dm man.vs man.tkn man.tan man.tic man.ua
## Class logical numeric logical numeric numeric logical logical
## Minimum <NA> 4.47 <NA> 2.49 1.72 <NA> <NA>
## Maximum <NA> 5.31 <NA> 2.8 1.95 <NA> <NA>
## Mean <NA> 4.91 <NA> 2.7 1.86 <NA> <NA>
## Unique (excld. NA) 0 3 0 2 3 0 0
## Missing values 2903 0 2903 0 0 2903 2903
## Sorted <NA> FALSE <NA> FALSE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum 0.16 7.7 2021-08-11 16:15:00 2021-08-11 16:15:00
## Maximum 0.51 7.9 2022-01-05 14:54:00 2022-01-05 14:54:00
## Mean 0.323 7.83 2021-10-03 01:31:04 2021-10-03 01:31:04
## Unique (excld. NA) 3 2 22 22
## Missing values 0 0 0 0
## Sorted FALSE TRUE FALSE FALSE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 35.9 t/ha none <NA>
## Maximum bsth 35.9 t/ha none <NA>
## Mean <NA> 35.9 <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1 0
## Missing values 0 0 0 0 2903
## Sorted TRUE 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> stubble 10
## Maximum <NA> <NA> <NA> <NA> stubble 10
## Mean <NA> <NA> <NA> <NA> <NA> 10
## Unique (excld. NA) 0 0 0 0 1 1
## Missing values 2903 2903 2903 2903 0 0
## Sorted <NA> <NA> <NA> <NA> TRUE TRUE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 26 AU
## Mean <NA> <NA> <NA> 15.2 <NA>
## Unique (excld. NA) 0 0 1 22 1
## Missing values 2903 2903 2764 0 0
## Sorted <NA> <NA> TRUE FALSE 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_6_1_220317_JP_21CD22A.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 05-01-2022 13:26 05-01-2022 13:26
## Maximum 20-08-2021 11:55 20-08-2021 11:55
## Mean <NA> <NA>
## Unique (excld. NA) 22 22
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:21C.F:FoulumgårdD.P:1.T:AER30.R:1.R2:.T:2021-08-11 16:15:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220317_JP_21CD22A.xlsx.E:22A.F:FoulumgårdD.P:9.T:AER54.R:3.R2:.T:2022-01-05 14:30:00
## Mean <NA>
## Unique (excld. NA) 22
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:eGylle.E:21C Pedersen, Johanna 61.7
## Maximum D:1.I:AU.Pr:eGylle.E:22A Pedersen, Johanna 70
## Mean <NA> <NA> <NA> 66.6
## 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 2021-08-11 16:15:00 2021-08-11 17:34:00 1.33
## Maximum 139 2022-01-14 08:31:00 2022-01-14 10:15:00 1.73
## Mean 66.7 2021-10-07 01:10:33 2021-10-07 02:38:43 1.46
## Unique (excld. NA) 139 2903 2903 2
## 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.00151 ppm 0 kg N/ha-hr <NA>
## Maximum <NA> 0.0826 ppm 3.54 kg N/ha-hr <NA>
## Mean <NA> 0.00694 <NA> 0.166 <NA> <NA>
## Unique (excld. NA) 0 397 1 2900 1 0
## Missing values 2903 0 0 0 0 2903
## 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 -3.4 2 <NA> <NA> <NA>
## Maximum 22.3 2 <NA> <NA> <NA>
## Mean 10.8 2 <NA> <NA> <NA>
## Unique (excld. NA) 186 1 0 0 0
## Missing values 0 0 2903 2903 2903
## 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.1 2 <NA> <NA> <NA> <NA>
## Maximum <NA> 0.72 2 <NA> <NA> <NA> <NA>
## Mean <NA> 0.366 2 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 5 1 0 0 0 0
## Missing values 2903 0 0 2903 2903 2903 2903
## Sorted <NA> FALSE 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 2903 0 2903 2903 2903 2902
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character character
## Minimum 5 emission rate 05-01-2022 13:26
## Maximum 2910 emission rate 27-08-2021 23:50
## Mean 1460 <NA> <NA>
## Unique (excld. NA) 2903 1 2903
## 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 05-01-2022 13:26 kg NH3/ha-hr 0 0.822
## Maximum 27-08-2021 23:50 kg NH3/ha-hr 4.31 0.822
## Mean <NA> <NA> 0.202 0.822
## Unique (excld. NA) 2903 1 2900 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.4 -9.55 1.33 0.665 1.32 -9.55
## Maximum 10.9 1.33 215 214 211 210
## Mean 1.47 -0.00471 97 96.3 97.1 95.7 <NA>
## Unique (excld. NA) 6 7 263 262 333 333 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.1 0 0.2 0.2 0.00324
## Maximum 0 0 0.72 4.71 39.4 39.4 0.585
## Mean 0 0 0.366 0.238 26.8 26.8 0.4
## Unique (excld. NA) 1 1 5 2900 2899 2899 2899
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE FALSE FALSE FALSE FALSE FALSE
##
## j.rel pub.info soil.type2 exper2 rep2 acid
## Class numeric character logical logical logical logical
## Minimum 0 <NA> <NA> <NA> <NA> FALSE
## Maximum 0.0519 <NA> <NA> <NA> <NA> FALSE
## Mean 0.00248 <NA> <NA> <NA> <NA> 0 TRUE
## Unique (excld. NA) 2900 0 0 0 0 1
## Missing values 0 2903 2903 2903 2903 0
## Sorted FALSE <NA> <NA> <NA> <NA> TRUE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum Wind tunnel wt Stubble Mix
## Maximum Wind tunnel wt Stubble Mix
## 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
## Class character character character
## Minimum Band spread or trailing hose bsth None
## Maximum Band spread or trailing hose bsth None
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## date.start first.row.int row.plot first.rows
## Class Date numeric numeric factor
## Minimum 2021-08-11 5 5 Plots 10 Emis. 700
## Maximum 2021-08-11 2790 26 Plots 9 Emis. 561
## Mean <NA> 1390 15.2 Plots 20 Emis. 2298
## Unique (excld. NA) 1 22 22 22
## Missing values 0 0 0 0
## Sorted TRUE TRUE FALSE FALSE
##
## ggplotgroup
## Class factor
## Minimum (4.98,10.2]
## Maximum (20.8,26]
## Mean (10.2,15.5]
## Unique (excld. NA) 4
## Missing values 0
## Sorted FALSE
##