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:52:50.861957"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 | 2023-11-17 |
2. Contributors
| contributor | institute |
|---|---|
| Pedersen, Johanna | Aarhus University |
| Hafner, Sasha | Aarhus University |
| Pacholski, Andreas | Thünen Institute |
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx"4. Location
5.Keys and codes
Codes in Treatments sheet
## OK## OKCodes in Plots sheet
## OK## OKCodes in Emission sheet
## OK## OKCode merge check (matching project, experiment, field, plot, treatment)
## OK## OK## OK## OK## OK6. Publication info
Check for missing codes
## OK## OKComplete citations given
## OK## OK7. Emission sheet
Duplicated intervals
## OKMissing incorporation time
## OKDelay after application
## OKMissing or double interval number
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMissing time between intervals
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Dynamic chamber | 4715 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| chamber | 4715 |
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 : 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 : 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
## 4715 4715 4715 4715 4715
## soil.moist man.bed man.trt2 man.trt3 man.stor
## 4715 4715 4123 4715 4715
## man.vs man.tic man.ua man.vfa time.incorp
## 4715 4715 4715 4715 4715
## man.area dist.inj furrow.z furrow.w crop.area
## 4715 4715 4715 4715 4715
## lai notes.plot bg.dl pH.surf soil.temp
## 4715 4651 4715 4715 4715
## soil.temp.z soil.temp.surf rad wind.z MOL
## 4715 4715 4715 4715 4715
## ustar rl air.pres air.pres.unit rh
## 4715 4715 4715 4715 4715
## wind.loc far.loc notes.int wind.2m pub.info
## 4715 4715 4714 4715 4715
## soil.type2 exper2 rep2
## 4715 4715 4715Application 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
##
## 75 rows and 175 columns
## 75 unique rows
## pub.id proj exper
## Class logical character character
## Minimum <NA> MAG 23C
## Maximum <NA> MAG 23I
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 0 1 5
## Missing values 75 0 0
## Sorted <NA> TRUE TRUE
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23C.F:A.P:1 A.T:A.R:1.R2:.T:2023-04-12 14:45:00.M:Dynamic chamberNA
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23I.F:A.P:8 I.T:I.R:2.R2:.T:2023-05-24 14:47:00.M:Dynamic chamberNA
## Mean <NA>
## Unique (excld. NA) 75
## Missing values 0
## Sorted TRUE
##
## field plot rep plot.area lat long
## Class character character numeric numeric numeric numeric
## Minimum A 1 A 1 0.385 56.5 9.56
## Maximum A 8 I 3 0.385 56.5 9.56
## Mean <NA> <NA> 2 0.385 56.5 9.56
## Unique (excld. NA) 1 69 3 1 1 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE FALSE FALSE TRUE TRUE TRUE
##
## country topo soil.samp.z clay silt sand
## Class character character character numeric numeric numeric
## Minimum DK Flat 0-5 9 24 65
## Maximum DK Flat 0-5 9 24 65
## Mean <NA> <NA> <NA> 9 24 65
## Unique (excld. NA) 1 1 1 1 1 1
## Missing values 0 0 0 0 0 0
## Sorted 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.13 <NA> <NA> 5.2
## Maximum <NA> <NA> 0.24 <NA> <NA> 5.6
## Mean <NA> <NA> 0.178 <NA> <NA> 5.34
## Unique (excld. NA) 0 0 4 0 0 4
## Missing values 75 75 0 75 75 0
## Sorted <NA> <NA> FALSE <NA> <NA> FALSE
##
## soil.dens crop.res till man.source
## Class numeric character character character
## Minimum 1.03 Yes No mix
## Maximum 1.17 Yes No mix
## Mean 1.09 <NA> <NA> <NA>
## Unique (excld. NA) 5 1 1 1
## Missing values 0 0 0 0
## Sorted FALSE TRUE TRUE TRUE
##
## man.source.det
## Class character
## Minimum mix of slurry co-digested with other agricultural residues
## Maximum mix of slurry co-digested with other agricultural residues
## 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 character logical
## Minimum <NA> Slurry Acidification Acidification <NA>
## Maximum <NA> Slurry None Acidification <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 4 1 0
## Missing values 75 0 0 66 75
## Sorted <NA> TRUE FALSE TRUE <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> 2.52 <NA> 2.59 1.17 <NA> <NA>
## Maximum <NA> 10.6 <NA> 5.55 3.36 <NA> <NA>
## Mean <NA> 6.34 <NA> 3.92 2.06 <NA> <NA>
## Unique (excld. NA) 0 25 0 25 24 0 0
## Missing values 75 0 75 0 0 75 75
## Sorted <NA> FALSE <NA> FALSE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class logical numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum <NA> 6.5 2023-04-12 14:45:00 2023-04-19 09:13:00
## Maximum <NA> 8.4 2023-05-24 16:07:00 2023-05-31 07:14:00
## Mean <NA> 7.84 2023-05-05 00:46:00 2023-05-11 18:41:28
## Unique (excld. NA) 0 12 75 75
## Missing values 75 0 0 0
## Sorted <NA> FALSE FALSE FALSE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 19 t/ha none <NA>
## Maximum bsth 38 t/ha none <NA>
## Mean <NA> 27.1 <NA> <NA> <NA>
## Unique (excld. NA) 1 9 1 1 0
## Missing values 0 0 0 0 75
## Sorted TRUE FALSE 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 8
## Maximum <NA> <NA> <NA> <NA> cereal 13
## Mean <NA> <NA> <NA> <NA> <NA> 10.4
## Unique (excld. NA) 0 0 0 0 1 5
## Missing values 75 75 75 75 0 0
## Sorted <NA> <NA> <NA> <NA> TRUE FALSE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 79 AU
## Mean <NA> <NA> <NA> 42 <NA>
## Unique (excld. NA) 0 0 1 75 1
## Missing values 75 75 74 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_7.0_MAGspring23_231117.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.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 POSIXct, POSIXt
## Minimum A Dynamic chamber <NA> 2023-04-12 14:45:00
## Maximum I Dynamic chamber <NA> 2023-05-24 16:07:00
## Mean <NA> <NA> <NA> 2023-05-05 00:46:00
## Unique (excld. NA) 18 1 0 75
## Missing values 0 0 75 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class POSIXct, POSIXt
## Minimum 2023-04-19 09:13:00
## Maximum 2023-05-31 07:14:00
## Mean 2023-05-11 18:41:28
## Unique (excld. NA) 75
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23C.F:A.P:1 A.T:A.R:1.R2:.T:2023-04-12 14:45:00
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23I.F:A.P:8 I.T:I.R:2.R2:.T:2023-05-24 14:47:00
## Mean <NA>
## Unique (excld. NA) 75
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:MAG.E:23C Pedersen, Johanna 43.7
## Maximum D:1.I:AU.Pr:MAG.E:23I Pedersen, Johanna 63.8
## Mean <NA> <NA> <NA> 52.6
## Unique (excld. NA) 5 1 1 25
## 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.308 0.412 0.602 0.863 0.993 0.978
## Maximum <NA> 8.22 10.4 13.8 20.1 26.4 28.3
## Mean <NA> 4.38 5.84 8.65 12.5 16 17.4
## Unique (excld. NA) 0 75 75 75 75 75 75
## Missing values 75 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 0.876 10.7 0.313 0.313 <NA> 0.308 0.412
## Maximum 29.3 29.6 30.5 30.5 <NA> 8.22 10.4
## Mean 18.3 20.5 19.6 19.6 <NA> 4.38 5.84
## Unique (excld. NA) 75 15 75 75 0 75 75
## Missing values 0 60 0 0 75 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 0.602 0.863 0.993 0.978 0.876 10.7
## Maximum 13.8 20.1 26.4 28.3 29.3 29.6
## Mean 8.65 12.5 16 17.4 18.3 20.5
## Unique (excld. NA) 75 75 75 75 75 15
## Missing values 0 0 0 0 0 60
## 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 0.313 0.313 <NA> 0.0059 0.0079 0.0115
## Maximum 30.5 30.5 <NA> 0.157 0.199 0.265
## Mean 19.6 19.6 <NA> 0.0849 0.113 0.168
## Unique (excld. NA) 75 75 0 75 75 75
## Missing values 0 0 75 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.0165 0.019 0.0188 0.0168 0.189 0.00599
## Maximum 0.403 0.54 0.585 0.607 0.542 0.632
## Mean 0.242 0.309 0.336 0.354 0.383 0.377
## Unique (excld. NA) 75 75 75 75 15 75
## Missing values 0 0 0 0 60 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.00599 <NA> 0 0 0 0 0
## Maximum 0.632 <NA> 0 0 0 0 0
## Mean 0.377 <NA> 0 0 0 0 0
## Unique (excld. NA) 75 0 1 1 1 1 1
## Missing values 0 75 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 60 0 0 75
## 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 7.2 6.65 6.3 6.81 6.54
## Maximum 18.2 17.5 15.1 13 13
## Mean 13.4 12.5 10.5 9.66 9.94
## Unique (excld. NA) 15 28 36 45 68
## 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 7.17 7.76 8.23 8.23 <NA>
## Maximum 13.8 14.1 13.1 13.1 <NA>
## Mean 10.6 11.2 11 11.1 <NA>
## Unique (excld. NA) 66 69 72 70 0
## Missing values 0 0 0 0 75
## 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 1 1 1 1 1 1 1
## Maximum 1 1 1 1 1 1 1
## Mean 1 1 1 1 1 1 1
## 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 rain.rate.1 rain.rate.4 rain.rate.6
## Class numeric numeric numeric numeric numeric
## Minimum 1 1 <NA> 0 0
## Maximum 1 1.05 <NA> 0 0
## Mean 1 1.01 <NA> 0 0
## Unique (excld. NA) 1 2 0 1 1
## Missing values 0 0 75 0 0
## Sorted TRUE FALSE <NA> TRUE TRUE
##
## rain.rate.12 rain.rate.24 rain.rate.48 rain.rate.72
## 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.96 rain.rate.168 rain.rate.mn
## Class numeric numeric numeric
## Minimum 0 0 0
## Maximum 0 0 0
## Mean 0 0 0
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## first.row.in.file.int last.row.in.file.int n.ints dt1
## Class numeric numeric integer numeric
## Minimum 5 68 54 2.52
## Maximum 4660 4720 69 2.53
## Mean 2380 2440 62.9 2.53
## Unique (excld. NA) 75 75 7 2
## Missing values 0 0 0 0
## Sorted TRUE TRUE FALSE TRUE
##
## j.rel1 j.NH31 dt.min dt.max ct.min ct.max
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.00157 0.0819 0.8 2.53 2.52 137
## Maximum 0.0469 2.45 2.53 3.22 2.53 175
## Mean 0.0239 1.23 2.51 2.66 2.53 159
## Unique (excld. NA) 75 75 3 3 2 8
## 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 2023-04-12 14:45:00 2023-04-19 06:41:00 2
## Maximum 2023-05-24 16:07:00 2023-05-31 04:42:00 2
## Mean 2023-05-05 00:46:00 2023-05-11 18:19:06 2
## Unique (excld. NA) 75 75 1
## Missing values 0 0 0
## Sorted FALSE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc pub.info soil.type2
## Class logical logical logical logical logical logical
## Minimum <NA> <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> <NA> <NA> <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 0 0 0
## Missing values 75 75 75 75 75 75
## Sorted <NA> <NA> <NA> <NA> <NA> <NA>
##
## exper2 rep2 acid meas.tech.orig meas.tech2
## Class logical logical logical character character
## Minimum <NA> <NA> FALSE Dynamic chamber chamber
## Maximum <NA> <NA> TRUE Dynamic chamber chamber
## Mean <NA> <NA> 0.2 TRUE <NA> <NA>
## Unique (excld. NA) 0 0 2 1 1
## Missing values 75 75 0 0 0
## Sorted <NA> <NA> FALSE TRUE TRUE
##
## crop.orig man.source.orig app.method.orig
## Class character character character
## Minimum Cereal Mix Band spread or trailing hose
## Maximum Cereal Mix Band spread or trailing hose
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## app.method2 incorp.orig date.start
## Class character character Date
## Minimum bsth None 2023-04-12
## Maximum bsth None 2023-05-24
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 5
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
## Interval-level emission data
##
## 4715 rows and 138 columns
## 4715 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23C.F:A.P:1 A.T:A.R:1.R2:.T:2023-04-12 14:45:00.M:Dynamic chamberNA
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23I.F:A.P:8 I.T:I.R:2.R2:.T:2023-05-24 14:47:00.M:Dynamic chamberNA
## Mean <NA>
## Unique (excld. NA) 75
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class logical character character character character numeric
## Minimum <NA> MAG 23C A 1 A 1
## Maximum <NA> MAG 23I A 8 I 3
## Mean <NA> <NA> <NA> <NA> <NA> 2
## Unique (excld. NA) 0 1 5 1 69 3
## Missing values 4715 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 A Dynamic chamber <NA> 0.385 56.5
## Maximum I Dynamic chamber <NA> 0.385 56.5
## Mean <NA> <NA> <NA> 0.385 56.5
## Unique (excld. NA) 18 1 0 1 1
## Missing values 0 0 4715 0 0
## Sorted FALSE TRUE <NA> TRUE TRUE
##
## long country topo soil.samp.z clay silt
## Class numeric character character character numeric numeric
## Minimum 9.56 DK Flat 0-5 9 24
## Maximum 9.56 DK Flat 0-5 9 24
## Mean 9.56 <NA> <NA> <NA> 9 24
## Unique (excld. NA) 1 1 1 1 1 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE TRUE TRUE
##
## sand oc soil.type soil.water soil.water.v soil.moist
## Class numeric logical logical numeric logical logical
## Minimum 65 <NA> <NA> 0.13 <NA> <NA>
## Maximum 65 <NA> <NA> 0.24 <NA> <NA>
## Mean 65 <NA> <NA> 0.18 <NA> <NA>
## Unique (excld. NA) 1 0 0 4 0 0
## Missing values 0 4715 4715 0 4715 4715
## Sorted TRUE <NA> <NA> FALSE <NA> <NA>
##
## soil.ph soil.dens crop.res till man.source
## Class numeric numeric character character character
## Minimum 5.2 1.03 Yes No mix
## Maximum 5.6 1.17 Yes No mix
## Mean 5.34 1.09 <NA> <NA> <NA>
## Unique (excld. NA) 4 5 1 1 1
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE TRUE TRUE TRUE
##
## man.source.det
## Class character
## Minimum mix of slurry co-digested with other agricultural residues
## Maximum mix of slurry co-digested with other agricultural residues
## 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 character logical
## Minimum <NA> Slurry Acidification Acidification <NA>
## Maximum <NA> Slurry None Acidification <NA>
## Mean <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 4 1 0
## Missing values 4715 0 0 4123 4715
## Sorted <NA> TRUE FALSE TRUE <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> 2.52 <NA> 2.59 1.17 <NA> <NA>
## Maximum <NA> 10.6 <NA> 5.55 3.36 <NA> <NA>
## Mean <NA> 6.32 <NA> 3.92 2.06 <NA> <NA>
## Unique (excld. NA) 0 25 0 25 24 0 0
## Missing values 4715 0 4715 0 0 4715 4715
## Sorted <NA> FALSE <NA> FALSE FALSE <NA> <NA>
##
## man.vfa man.ph app.start app.end
## Class logical numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum <NA> 6.5 2023-04-12 14:45:00 2023-04-19 09:13:00
## Maximum <NA> 8.4 2023-05-24 16:07:00 2023-05-31 07:14:00
## Mean <NA> 7.83 2023-05-04 08:02:29 2023-05-11 02:10:56
## Unique (excld. NA) 0 12 75 75
## Missing values 4715 0 0 0
## Sorted <NA> FALSE FALSE FALSE
##
## app.method app.rate app.rate.unit incorp time.incorp
## Class character numeric character character numeric
## Minimum bsth 19 t/ha none <NA>
## Maximum bsth 38 t/ha none <NA>
## Mean <NA> 27.1 <NA> <NA> <NA>
## Unique (excld. NA) 1 9 1 1 0
## Missing values 0 0 0 0 4715
## Sorted TRUE FALSE 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 8
## Maximum <NA> <NA> <NA> <NA> cereal 13
## Mean <NA> <NA> <NA> <NA> <NA> 10.5
## Unique (excld. NA) 0 0 0 0 1 5
## Missing values 4715 4715 4715 4715 0 0
## Sorted <NA> <NA> <NA> <NA> TRUE FALSE
##
## crop.area lai notes.plot row.in.file.plot institute
## Class numeric logical character numeric character
## Minimum <NA> <NA> . 5 AU
## Maximum <NA> <NA> . 79 AU
## Mean <NA> <NA> <NA> 41.2 <NA>
## Unique (excld. NA) 0 0 1 75 1
## Missing values 4715 4715 4651 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_7.0_MAGspring23_231117.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class POSIXct, POSIXt POSIXct, POSIXt
## Minimum 2023-04-12 14:45:00 2023-04-19 09:13:00
## Maximum 2023-05-24 16:07:00 2023-05-31 07:14:00
## Mean 2023-05-04 08:02:29 2023-05-11 02:10:56
## Unique (excld. NA) 75 75
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23C.F:A.P:1 A.T:A.R:1.R2:.T:2023-04-12 14:45:00
## Maximum D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_MAGspring23_231117.xlsx.E:23I.F:A.P:8 I.T:I.R:2.R2:.T:2023-05-24 14:47:00
## Mean <NA>
## Unique (excld. NA) 75
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:MAG.E:23C Pedersen, Johanna 43.7
## Maximum D:1.I:AU.Pr:MAG.E:23I Pedersen, Johanna 63.8
## Mean <NA> <NA> <NA> 52.6
## Unique (excld. NA) 5 1 1 25
## 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 2023-04-12 14:45:00 2023-04-12 17:16:00 0.8
## Maximum 69 2023-05-31 04:42:00 2023-05-31 07:14:00 3.22
## Mean 32.1 2023-05-07 17:36:46 2023-05-07 20:11:18 2.53
## Unique (excld. NA) 69 4715 4715 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.0143 ppm -0.228 kg N/ha-hr <NA>
## Maximum <NA> 0.158 ppm 2.45 kg N/ha-hr <NA>
## Mean <NA> 0.0339 <NA> 0.123 <NA> <NA>
## Unique (excld. NA) 0 315 1 4715 1 0
## Missing values 4715 0 0 0 0 4715
## 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 2.9 2 <NA> <NA> <NA>
## Maximum 22.1 2 <NA> <NA> <NA>
## Mean 10.9 2 <NA> <NA> <NA>
## Unique (excld. NA) 173 1 0 0 0
## Missing values 0 0 4715 4715 4715
## Sorted FALSE TRUE <NA> <NA> <NA>
##
## rad wind wind.z MOL ustar rl air.pres
## Class logical numeric logical logical logical logical logical
## Minimum <NA> 1 <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> 1 <NA> <NA> <NA> <NA> <NA>
## Mean <NA> 1 <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 0 0 0 0 0
## Missing values 4715 0 4715 4715 4715 4715 4715
## 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 4715 0 4715 4715 4715 4714
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character POSIXct, POSIXt
## Minimum 5 emission rate 2023-04-12 14:45:00
## Maximum 4720 emission rate 2023-05-31 04:42:00
## Mean 2360 <NA> 2023-05-07 17:36:46
## Unique (excld. NA) 4715 1 4715
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## t.end.orig j.NH3.unit.orig j.NH3.orig
## Class POSIXct, POSIXt character numeric
## Minimum 2023-04-12 14:45:00 kg N/ha-hr -0.228
## Maximum 2023-05-31 04:42:00 kg N/ha-hr 2.45
## Mean 2023-05-07 17:36:46 <NA> 0.123
## Unique (excld. NA) 4715 1 4715
## Missing values 0 0 0
## Sorted FALSE TRUE FALSE
##
## j.NH3.conv.fact dt.calc dt.diff ct mt cta
## Class numeric numeric numeric numeric numeric numeric
## Minimum 1 -160 -24 2.52 1.26 0
## Maximum 1 26.6 162 175 174 175
## Mean 1 2.58 -0.041 81.4 80.1 84.1
## Unique (excld. NA) 1 7 8 138 143 167
## Missing values 0 0 0 0 0 0
## Sorted TRUE FALSE FALSE FALSE FALSE FALSE
##
## bta flag.int rain.rate rain.cum wind.2m e.int e.cum
## Class numeric character numeric numeric numeric numeric numeric
## Minimum 0 0 0 <NA> -0.579 0.206
## Maximum 172 0 0 <NA> 6.2 30.5
## Mean 81.6 <NA> 0 0 <NA> 0.311 16.2
## Unique (excld. NA) 164 1 1 1 0 4715 4715
## Missing values 0 0 0 0 4715 0 0
## Sorted FALSE TRUE TRUE TRUE <NA> FALSE FALSE
##
## e e.rel j.rel pub.info soil.type2 exper2 rep2
## Class numeric numeric numeric logical logical logical logical
## Minimum 0.206 0.00395 -0.00418 <NA> <NA> <NA> <NA>
## Maximum 30.5 0.632 0.0469 <NA> <NA> <NA> <NA>
## Mean 16.2 0.312 0.00237 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 4715 4715 4715 0 0 0 0
## Missing values 0 0 0 4715 4715 4715 4715
## Sorted FALSE FALSE FALSE <NA> <NA> <NA> <NA>
##
## acid meas.tech.orig meas.tech2 crop.orig
## Class logical character character character
## Minimum FALSE Dynamic chamber chamber Cereal
## Maximum TRUE Dynamic chamber chamber Cereal
## Mean 0.213361611876988 TRUE <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 1
## Missing values 0 0 0 0
## Sorted FALSE TRUE TRUE TRUE
##
## man.source.orig app.method.orig app.method2
## Class character character character
## Minimum Mix Band spread or trailing hose bsth
## Maximum Mix Band spread or trailing hose bsth
## Mean <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## incorp.orig date.start first.row.int row.plot
## Class character Date numeric numeric
## Minimum None 2023-04-12 5 5
## Maximum None 2023-04-12 4660 79
## Mean <NA> <NA> 2330 41.2
## Unique (excld. NA) 1 1 75 75
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE
##
## first.rows ggplotgroup
## Class factor factor
## Minimum Plots 10 Emis. 261 (4.93,10.7]
## Maximum Plots 9 Emis. 901 (73.3,79.1]
## Mean Plots 46 Emis. 2384 (39.2,44.8]
## Unique (excld. NA) 75 13
## Missing values 0 0
## Sorted FALSE FALSE
##