0. Instructions for submitters

Submitters should use this file to check for problems with submitted data. Send either a list of problems or confirmation that everything looks OK to Sasha by email. Be sure to reference the dataset version and file creation date/time when doing so. These are:

## Version:  2.47
## [1] "Date/time: 2024-04-04 14:48:05.114064"

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:

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 2021-10-13

2. Contributors

contributor institute
Shabtai Bittman Agassiz Research and Development Center, BC, Canada
Derek Hunt Agassiz Research and Development Center, BC, Canada

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx"

4. Location

5.Keys and codes

Codes in Treatments sheet

## OK
## OK

Codes in Plots sheet

## OK
## OK

Codes in Emission sheet

## OK
## OK

Code merge check (matching project, experiment, field, plot, treatment)

## OK
## OK
## OK
## OK
## OK

6. Publication info

Check for missing codes

## OK
## OK

Complete citations given

## OK
## OK

7. Emission sheet

Duplicated intervals

## OK

Missing incorporation time

## OK

Delay after application

## OK

Missing 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

Missing 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

Measurement method and units

Measurement technique:

Method Frequency
Wind tunnel 576

Measurement technique classification:

Classification Frequency
wt 576

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 : 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 : OK

Emission

## j.NH3 : OK
## e.int : OK
## e.rel : OK

8. 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 
##            576            576            576            576            576 
##   soil.water.v     soil.moist man.source.det        man.bed       man.trt2 
##            576            576            576            576            576 
##       man.stor         man.vs        man.tic         man.ua        man.vfa 
##            576            576            576            576            576 
##    time.incorp       man.area       dist.inj       furrow.z       furrow.w 
##            576            576            432            576            576 
##      crop.area            lai     notes.plot       man.trt3          bg.dl 
##            576            576            558            576            576 
##        pH.surf      soil.temp    soil.temp.z soil.temp.surf            rad 
##            576            144            144            576            576 
##         wind.z            MOL          ustar             rl       air.pres 
##            576            576            576            576            576 
##  air.pres.unit             rh       wind.loc        far.loc      notes.int 
##            576            576            576            576            575 
##        wind.2m     soil.type2         exper2           rep2 
##            576            576            576            576

Application method and measurement method

## OK
## OK

9. 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

## 
##  64 rows and 184 columns
##  64 unique rows
##                       pub.id
## Class              character
## Minimum                    G
## Maximum                    G
## Mean                    <NA>
## Unique (excld. NA)         1
## Missing values             0
## Sorted                  TRUE
##                             
##                                                                                                                                                                                                      cpmid
## Class                                                                                                                                                                                            character
## Minimum            D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:A.F:Agassiz.P:101.T:untreated wide banded.R:1.R2:.T:2019-05-27 10:22:00.M:Wind tunnelNA
## Maximum                    D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:D.F:Agassiz.P:404.T:untreated SSD.R:4.R2:.T:2019-06-26 09:13:00.M:Wind tunnelNA
## Mean                                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                                      64
## Missing values                                                                                                                                                                                           0
## Sorted                                                                                                                                                                                                TRUE
##                                                                                                                                                                                                           
##                         proj     exper     field    plot     rep plot.area
## Class              character character character numeric numeric   numeric
## Minimum                 NUGA         A   Agassiz     101       1         1
## Maximum                 NUGA         D   Agassiz     404       4         1
## Mean                    <NA>      <NA>      <NA>     252     2.5         1
## Unique (excld. NA)         1         4         1      16       4         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               49.2    -122        CA      Flat    <NA>    <NA>    <NA>
## Maximum               49.2    -122        CA      Flat    <NA>    <NA>    <NA>
## Mean                  49.2    -122      <NA>      <NA>    <NA>    <NA>    <NA>
## Unique (excld. NA)       1       1         1         1       0       0       0
## Missing values           0       0         0         0      64      64      64
## Sorted                TRUE    TRUE      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>      Loam       0.14         <NA>       <NA>     5.3
## Maximum               <NA>      Loam       0.35         <NA>       <NA>     5.3
## Mean                  <NA>      <NA>      0.218         <NA>       <NA>     5.3
## Unique (excld. NA)       0         1          3            0          0       1
## Missing values          64         0          0           64         64       0
## Sorted                <NA>      TRUE      FALSE         <NA>       <NA>    TRUE
##                                                                                
##                    soil.dens  crop.res      till man.source man.source.det
## Class                numeric character character  character        logical
## Minimum                 1.08       Yes        No        cat           <NA>
## Maximum                 1.08       Yes        No        cat           <NA>
## Mean                    1.08      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         1         1         1          1              0
## Missing values             0         0         0          0             64
## Sorted                  TRUE      TRUE      TRUE       TRUE           <NA>
##                                                                           
##                    man.bed   man.con           man.trt1 man.trt2 man.stor
## Class              logical character          character  logical  logical
## Minimum               <NA>    Slurry Gravity separation     <NA>     <NA>
## Maximum               <NA>    Slurry               None     <NA>     <NA>
## Mean                  <NA>      <NA>               <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                  2        0        0
## Missing values          64         0                  0       64       64
## Sorted                <NA>      TRUE              FALSE     <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                1.5    <NA>    1.15    0.75    <NA>    <NA>    <NA>
## Maximum                7.9    <NA>    3.07    1.81    <NA>    <NA>    <NA>
## Mean                  5.36    <NA>    2.39    1.43    <NA>    <NA>    <NA>
## Unique (excld. NA)       7       0       8       8       0       0       0
## Missing values           0      64       0       0      64      64      64
## Sorted               FALSE    <NA>   FALSE   FALSE    <NA>    <NA>    <NA>
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                6.8 2019-05-27 10:22:00 2019-05-27 10:22:00         bc
## Maximum                7.6 2019-06-26 09:13:00 2019-06-26 09:13:00         os
## Mean                  7.11 2019-06-11 03:40:15 2019-06-11 03:40:15       <NA>
## Unique (excld. NA)       6                   4                   4          3
## Missing values           0                   0                   0          0
## Sorted               FALSE                TRUE                TRUE      FALSE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  logical
## Minimum                  60          t/ha      none        <NA>     <NA>
## Maximum                  60          t/ha      none        <NA>     <NA>
## Mean                     60          <NA>      <NA>        <NA>     <NA>
## Unique (excld. NA)        1             1         1           0        0
## Missing values            0             0         0          64       64
## Sorted                 TRUE          TRUE      TRUE        <NA>     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               numeric  logical  logical character numeric   numeric
## Minimum                  20     <NA>     <NA>     grass      10      <NA>
## Maximum                  20     <NA>     <NA>     grass      10      <NA>
## Mean                     20     <NA>     <NA>      <NA>      10      <NA>
## Unique (excld. NA)        1        0        0         1       1         0
## Missing values           48       64       64         0       0        64
## Sorted                 TRUE     <NA>     <NA>      TRUE    TRUE      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot man.trt3 institute
## Class              logical  character          numeric  logical character
## Minimum               <NA>          .                5     <NA>        AU
## Maximum               <NA>          .               68     <NA>        AU
## Mean                  <NA>       <NA>             36.5     <NA>      <NA>
## Unique (excld. NA)       0          1               64        0         1
## Missing values          64         62                0       64         0
## Sorted                <NA>       TRUE             TRUE     <NA>      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_5_2_210929_JP_CanadianData.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx
## Mean                                                                                     <NA>
## Unique (excld. NA)                                                                          1
## Missing values                                                                              0
## Sorted                                                                                   TRUE
##                                                                                              
##                                    treat   meas.tech meas.tech.det
## Class                          character   character       logical
## Minimum              separated broadcast Wind tunnel          <NA>
## Maximum            untreated wide banded Wind tunnel          <NA>
## Mean                                <NA>        <NA>          <NA>
## Unique (excld. NA)                     7           1             0
## Missing values                         0           0            64
## Sorted                             FALSE        TRUE          <NA>
##                                                                   
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            04-06-2019 09:38 04-06-2019 09:38
## Maximum            27-05-2019 10:22 27-05-2019 10:22
## Mean                           <NA>             <NA>
## Unique (excld. NA)                4                4
## Missing values                    0                0
## Sorted                        FALSE            FALSE
##                                                     
##                                                                                                                                                                                       cpid
## Class                                                                                                                                                                            character
## Minimum            D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:A.F:Agassiz.P:101.T:untreated wide banded.R:1.R2:.T:2019-05-27 10:22:00
## Maximum                    D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:D.F:Agassiz.P:404.T:untreated SSD.R:4.R2:.T:2019-06-26 09:13:00
## Mean                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                      64
## Missing values                                                                                                                                                                           0
## Sorted                                                                                                                                                                                TRUE
##                                                                                                                                                                                           
##                                    ceid flag.plot         submitter tan.app
## Class                         character character         character numeric
## Minimum            D:1.I:AU.Pr:NUGA.E:A           Pedersen, Johanna      45
## Maximum            D:1.I:AU.Pr:NUGA.E:D           Pedersen, Johanna     109
## Mean                               <NA>      <NA>              <NA>    85.8
## Unique (excld. NA)                    4         1                 1       8
## 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       0       0       0       0       0
## Maximum               <NA>    20.8    26.3    29.2    34.5      38    41.7
## Mean                  <NA>    7.25    9.23    11.4    15.6      18    19.6
## Unique (excld. NA)       0      59      60      61      61      64      64
## Missing values          64       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               <NA>    <NA>       0       0    <NA>       0       0
## Maximum               <NA>    <NA>    45.6    45.6    <NA>    20.8    26.3
## Mean                  <NA>    <NA>    20.7    20.7    <NA>    7.25    9.23
## Unique (excld. NA)       0       0      64      64       0      59      60
## Missing values          64      64       0       0      64       0       0
## Sorted                <NA>    <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        0        0        0     <NA>      <NA>
## Maximum                29.2     34.5       38     41.7     <NA>      <NA>
## Mean                   11.4     15.6       18     19.6     <NA>      <NA>
## Unique (excld. NA)       61       61       64       64        0         0
## Missing values            0        0        0        0       64        64
## Sorted                FALSE    FALSE    FALSE    FALSE     <NA>      <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                      0         0    <NA>       0       0        0
## Maximum                   45.6      45.6    <NA>   0.198    0.25    0.278
## Mean                      20.7      20.7    <NA>  0.0754  0.0955    0.118
## Unique (excld. NA)          64        64       0      59      60       61
## Missing values               0         0      64       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        0        0     <NA>      <NA>           0
## Maximum               0.328    0.362    0.397     <NA>      <NA>       0.434
## Mean                  0.161    0.188    0.204     <NA>      <NA>       0.216
## Unique (excld. NA)       61       64       64        0         0          64
## Missing values            0        0        0       64        64           0
## Sorted                FALSE    FALSE    FALSE     <NA>      <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    <NA>       0       0       0       0       0
## Maximum                0.434    <NA>       0       0       0       0       0
## Mean                   0.216    <NA>       0       0       0       0       0
## Unique (excld. NA)        64       0       1       1       1       1       1
## Missing values             0      64       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    <NA>     <NA>          0        0       <NA>
## Maximum                  0    <NA>     <NA>          0        0       <NA>
## Mean                     0    <NA>     <NA>          0        0       <NA>
## Unique (excld. NA)       1       0        0          1        1          0
## Missing values           0      64       64          0        0         64
## Sorted                TRUE    <NA>     <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                  16.5       16.5        18.1        15.7        13.8
## Maximum                  22.4       22.5        24.1          21          19
## Mean                     19.4       20.5        21.3        18.1        16.9
## Unique (excld. NA)          4          4           4           4           4
## 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                   13.7        13.7         13.7        13.7    <NA>
## Maximum                   17.7        17.9         17.9        17.9    <NA>
## Mean                      16.2          16           16          16    <NA>
## Unique (excld. NA)           4           4            4           4       0
## Missing values               0           0            0           0      64
## 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        <NA>           0           0
## Mean                      1       1        <NA>           0           0
## Unique (excld. NA)        1       1           0           1           1
## Missing values            0       0          64           0           0
## Sorted                 TRUE    TRUE        <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 soil.temp.1
## Class                   numeric       numeric      numeric     numeric
## Minimum                       0             0            0        <NA>
## Maximum                       0             0            0        <NA>
## Mean                          0             0            0        <NA>
## Unique (excld. NA)            1             1            1           0
## Missing values                0             0            0          64
## Sorted                     TRUE          TRUE         TRUE        <NA>
##                                                                       
##                    soil.temp.4 soil.temp.6 soil.temp.12 soil.temp.24
## Class                  numeric     numeric      numeric      numeric
## Minimum                   17.4        20.3         20.3         18.7
## Maximum                   24.4        24.4         25.5         22.5
## Mean                        21        22.9         23.3         20.5
## Unique (excld. NA)           3           3            3            3
## Missing values              16          16           16           16
## Sorted                   FALSE       FALSE        FALSE        FALSE
##                                                                     
##                    soil.temp.48 soil.temp.72 soil.temp.96 soil.temp.168
## Class                   numeric      numeric      numeric       numeric
## Minimum                    18.6         18.7         18.6          18.6
## Maximum                    21.4           20         19.3          19.3
## Mean                       19.7         19.2         18.9          18.9
## Unique (excld. NA)            3            3            3             3
## Missing values               16           16           16            16
## Sorted                    FALSE        FALSE        FALSE         FALSE
##                                                                        
##                    soil.temp.mn first.row.in.file.int last.row.in.file.int
## Class                   numeric               numeric              numeric
## Minimum                    18.6                     5                   13
## Maximum                    19.3                   572                  580
## Mean                       18.9                   288                  296
## Unique (excld. NA)            3                    64                   64
## Missing values               16                     0                    0
## Sorted                    FALSE                  TRUE                 TRUE
##                                                                           
##                     n.ints     dt1  j.rel1  j.NH31  dt.min  dt.max  ct.min
## Class              integer numeric numeric numeric numeric numeric numeric
## Minimum                  9    1.97       0       0    1.97    17.7    1.97
## Maximum                  9       2  0.0774    8.13       2      18       2
## Mean                     9    1.98  0.0279    2.65    1.98    17.8    1.98
## Unique (excld. NA)       1       3      57      57       3       4       3
## Missing values           0       0       0       0       0       0       0
## Sorted                TRUE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                     ct.max           t.start.p             t.end.p air.temp.z
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum               93.7 2019-05-27 10:22:00 2019-05-30 14:38:00          2
## Maximum                 95 2019-06-26 09:13:00 2019-06-28 14:39:00          2
## Mean                  94.4 2019-06-11 03:40:15 2019-06-14 02:40:30          2
## Unique (excld. NA)       4                   4                   4          1
## Missing values           0                   0                   0          0
## Sorted               FALSE                TRUE                TRUE       TRUE
##                                                                              
##                    soil.temp.z  wind.z wind.loc far.loc
## Class                  numeric logical  logical logical
## Minimum                   0.05    <NA>     <NA>    <NA>
## Maximum                   0.05    <NA>     <NA>    <NA>
## Mean                      0.05    <NA>     <NA>    <NA>
## Unique (excld. NA)           1       0        0       0
## Missing values              16      64       64      64
## Sorted                    TRUE    <NA>     <NA>    <NA>
##                                                        
##                                                                                                                                                                                                                                                                                                                    pub.info
## Class                                                                                                                                                                                                                                                                                                             character
## Minimum            Pedersen, J., Nyord, T., Feilberg, A., Labouriau, R., Hunt, D., & Bittman, S. (2021). Effect of exposed surface area and enhanced infiltration on ammonia emission from untreated and separated cattle slurry. Biosystems Engineering, 211, 141–151. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## Maximum            Pedersen, J., Nyord, T., Feilberg, A., Labouriau, R., Hunt, D., & Bittman, S. (2021). Effect of exposed surface area and enhanced infiltration on ammonia emission from untreated and separated cattle slurry. Biosystems Engineering, 211, 141–151. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## 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             64      64      64       0              0          0
## Sorted                   <NA>    <NA>    <NA>    TRUE           TRUE       TRUE
##                                                                                
##                    crop.orig man.source.orig              app.method.orig
## Class              character       character                    character
## Minimum                Grass          Cattle Band spread or trailing hose
## Maximum                Grass          Cattle                    Wide band
## Mean                    <NA>            <NA>                         <NA>
## Unique (excld. NA)         1               1                            4
## Missing values             0               0                            0
## Sorted                  TRUE            TRUE                        FALSE
##                                                                          
##                    app.method2 incorp.orig date.start
## Class                character   character       Date
## Minimum                     bc        None 2019-05-27
## Maximum                     os        None 2019-06-26
## Mean                      <NA>        <NA>       <NA>
## Unique (excld. NA)           3           1          4
## Missing values               0           0          0
## Sorted                   FALSE        TRUE       TRUE
## 

Interval-level emission data

## 
##  576 rows and 137 columns
##  576 unique rows
##                                                                                                                                                                                                      cpmid
## Class                                                                                                                                                                                            character
## Minimum            D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:A.F:Agassiz.P:101.T:untreated wide banded.R:1.R2:.T:2019-05-27 10:22:00.M:Wind tunnelNA
## Maximum                    D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:D.F:Agassiz.P:404.T:untreated SSD.R:4.R2:.T:2019-06-26 09:13:00.M:Wind tunnelNA
## Mean                                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                                      64
## Missing values                                                                                                                                                                                           0
## Sorted                                                                                                                                                                                                TRUE
##                                                                                                                                                                                                           
##                       pub.id      proj     exper     field    plot     rep
## Class              character character character character numeric numeric
## Minimum                    G      NUGA         A   Agassiz     101       1
## Maximum                    G      NUGA         D   Agassiz     404       4
## Mean                    <NA>      <NA>      <NA>      <NA>     252     2.5
## Unique (excld. NA)         1         1         4         1      16       4
## Missing values             0         0         0         0       0       0
## Sorted                  TRUE      TRUE      TRUE      TRUE   FALSE   FALSE
##                                                                           
##                                    treat   meas.tech meas.tech.det plot.area
## Class                          character   character       logical   numeric
## Minimum              separated broadcast Wind tunnel          <NA>         1
## Maximum            untreated wide banded Wind tunnel          <NA>         1
## Mean                                <NA>        <NA>          <NA>         1
## Unique (excld. NA)                     7           1             0         1
## Missing values                         0           0           576         0
## Sorted                             FALSE        TRUE          <NA>      TRUE
##                                                                             
##                        lat    long   country      topo    clay    silt    sand
## Class              numeric numeric character character logical logical logical
## Minimum               49.2    -122        CA      Flat    <NA>    <NA>    <NA>
## Maximum               49.2    -122        CA      Flat    <NA>    <NA>    <NA>
## Mean                  49.2    -122      <NA>      <NA>    <NA>    <NA>    <NA>
## Unique (excld. NA)       1       1         1         1       0       0       0
## Missing values           0       0         0         0     576     576     576
## Sorted                TRUE    TRUE      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>      Loam       0.14         <NA>       <NA>     5.3
## Maximum               <NA>      Loam       0.35         <NA>       <NA>     5.3
## Mean                  <NA>      <NA>      0.218         <NA>       <NA>     5.3
## Unique (excld. NA)       0         1          3            0          0       1
## Missing values         576         0          0          576        576       0
## Sorted                <NA>      TRUE      FALSE         <NA>       <NA>    TRUE
##                                                                                
##                    soil.dens  crop.res      till man.source man.source.det
## Class                numeric character character  character        logical
## Minimum                 1.08       Yes        No        cat           <NA>
## Maximum                 1.08       Yes        No        cat           <NA>
## Mean                    1.08      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         1         1         1          1              0
## Missing values             0         0         0          0            576
## Sorted                  TRUE      TRUE      TRUE       TRUE           <NA>
##                                                                           
##                    man.bed   man.con           man.trt1 man.trt2 man.stor
## Class              logical character          character  logical  logical
## Minimum               <NA>    Slurry Gravity separation     <NA>     <NA>
## Maximum               <NA>    Slurry               None     <NA>     <NA>
## Mean                  <NA>      <NA>               <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                  2        0        0
## Missing values         576         0                  0      576      576
## Sorted                <NA>      TRUE              FALSE     <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                1.5    <NA>    1.15    0.75    <NA>    <NA>    <NA>
## Maximum                7.9    <NA>    3.07    1.81    <NA>    <NA>    <NA>
## Mean                  5.36    <NA>    2.39    1.43    <NA>    <NA>    <NA>
## Unique (excld. NA)       7       0       8       8       0       0       0
## Missing values           0     576       0       0     576     576     576
## Sorted               FALSE    <NA>   FALSE   FALSE    <NA>    <NA>    <NA>
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                6.8 2019-05-27 10:22:00 2019-05-27 10:22:00         bc
## Maximum                7.6 2019-06-26 09:13:00 2019-06-26 09:13:00         os
## Mean                  7.11 2019-06-11 03:40:15 2019-06-11 03:40:15       <NA>
## Unique (excld. NA)       6                   4                   4          3
## Missing values           0                   0                   0          0
## Sorted               FALSE                TRUE                TRUE      FALSE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  logical
## Minimum                  60          t/ha      none        <NA>     <NA>
## Maximum                  60          t/ha      none        <NA>     <NA>
## Mean                     60          <NA>      <NA>        <NA>     <NA>
## Unique (excld. NA)        1             1         1           0        0
## Missing values            0             0         0         576      576
## Sorted                 TRUE          TRUE      TRUE        <NA>     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               numeric  logical  logical character numeric   numeric
## Minimum                  20     <NA>     <NA>     grass      10      <NA>
## Maximum                  20     <NA>     <NA>     grass      10      <NA>
## Mean                     20     <NA>     <NA>      <NA>      10      <NA>
## Unique (excld. NA)        1        0        0         1       1         0
## Missing values          432      576      576         0       0       576
## Sorted                 TRUE     <NA>     <NA>      TRUE    TRUE      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot man.trt3 institute
## Class              logical  character          numeric  logical character
## Minimum               <NA>          .                5     <NA>        AU
## Maximum               <NA>          .               68     <NA>        AU
## Mean                  <NA>       <NA>             36.5     <NA>      <NA>
## Unique (excld. NA)       0          1               64        0         1
## Missing values         576        558                0      576         0
## Sorted                <NA>       TRUE             TRUE     <NA>      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_5_2_210929_JP_CanadianData.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx
## Mean                                                                                     <NA>
## Unique (excld. NA)                                                                          1
## Missing values                                                                              0
## Sorted                                                                                   TRUE
##                                                                                              
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            04-06-2019 09:38 04-06-2019 09:38
## Maximum            27-05-2019 10:22 27-05-2019 10:22
## Mean                           <NA>             <NA>
## Unique (excld. NA)                4                4
## Missing values                    0                0
## Sorted                        FALSE            FALSE
##                                                     
##                                                                                                                                                                                       cpid
## Class                                                                                                                                                                            character
## Minimum            D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:A.F:Agassiz.P:101.T:untreated wide banded.R:1.R2:.T:2019-05-27 10:22:00
## Maximum                    D:1.I:AU.Pr:NUGA.F:../../data-submitted/03/AU/ALFAM2_template_5_2_210929_JP_CanadianData.xlsx.E:D.F:Agassiz.P:404.T:untreated SSD.R:4.R2:.T:2019-06-26 09:13:00
## Mean                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                      64
## Missing values                                                                                                                                                                           0
## Sorted                                                                                                                                                                                TRUE
##                                                                                                                                                                                           
##                                    ceid flag.plot         submitter tan.app
## Class                         character character         character numeric
## Minimum            D:1.I:AU.Pr:NUGA.E:A           Pedersen, Johanna      45
## Maximum            D:1.I:AU.Pr:NUGA.E:D           Pedersen, Johanna     109
## Mean                               <NA>      <NA>              <NA>    85.8
## Unique (excld. NA)                    4         1                 1       8
## 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 2019-05-27 10:22:00 2019-05-27 12:21:00    1.97
## Maximum                   9 2019-06-28 14:39:00 2019-06-29 08:12:00      18
## Mean                      5 2019-06-12 08:28:56 2019-06-12 18:17:46    10.5
## Unique (excld. NA)        9                  36                  36      34
## 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 kg N/ha-hr       0 kg N/ha-hr    <NA>
## Maximum               <NA>   0.797 kg N/ha-hr    8.13 kg N/ha-hr    <NA>
## Mean                  <NA> 0.00574       <NA>     0.5       <NA>    <NA>
## Unique (excld. NA)       0       9          1     350          1       0
## Missing values         576       0          0       0          0     576
## Sorted                <NA>   FALSE       TRUE   FALSE       TRUE    <NA>
##                                                                         
##                    air.temp air.temp.z soil.temp soil.temp.z soil.temp.surf
## Class               numeric    numeric   numeric     numeric        logical
## Minimum                10.9          2      15.8        0.05           <NA>
## Maximum                24.9          2      26.1        0.05           <NA>
## Mean                   17.2          2      19.7        0.05           <NA>
## Unique (excld. NA)       31          1        24           1              0
## Missing values            0          0       144         144            576
## 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>       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         576       0     576     576     576     576      576
## 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               576       0     576      576     576       575
## Sorted                      <NA>    TRUE    <NA>     <NA>    <NA>      TRUE
##                                                                            
##                    row.in.file.int        j.type     t.start.orig
## Class                      numeric     character        character
## Minimum                          5 emission rate 04-06-2019 09:38
## Maximum                        580 emission rate 30-05-2019 14:38
## Mean                           292          <NA>             <NA>
## Unique (excld. NA)             576             1               36
## 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            04-06-2019 09:38      kg N/ha-hr          0               1
## Maximum            30-05-2019 14:38      kg N/ha-hr       8.13               1
## Mean                           <NA>            <NA>        0.5               1
## Unique (excld. NA)               36               1        350               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                -22 -0.00333    1.97   0.985     -22     -22          
## Maximum               17.9       24      95    86.2    94.8    77.3          
## Mean                  9.81    0.678    44.6    39.4    38.6    28.8      <NA>
## Unique (excld. NA)      33       10      35      35      34      31         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    <NA>       0       0       0       0
## Maximum                    0        0    <NA>    16.1    45.6    45.6   0.434
## Mean                       0        0    <NA>     2.3    15.8    15.8   0.165
## Unique (excld. NA)         1        1       0     350     350     350     350
## Missing values             0        0     576       0       0       0       0
## Sorted                  TRUE     TRUE    <NA>   FALSE   FALSE   FALSE   FALSE
##                                                                              
##                      j.rel
## Class              numeric
## Minimum                  0
## Maximum             0.0774
## Mean                0.0052
## Unique (excld. NA)     350
## Missing values           0
## Sorted               FALSE
##                           
##                                                                                                                                                                                                                                                                                                                    pub.info
## Class                                                                                                                                                                                                                                                                                                             character
## Minimum            Pedersen, J., Nyord, T., Feilberg, A., Labouriau, R., Hunt, D., & Bittman, S. (2021). Effect of exposed surface area and enhanced infiltration on ammonia emission from untreated and separated cattle slurry. Biosystems Engineering, 211, 141–151. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## Maximum            Pedersen, J., Nyord, T., Feilberg, A., Labouriau, R., Hunt, D., & Bittman, S. (2021). Effect of exposed surface area and enhanced infiltration on ammonia emission from untreated and separated cattle slurry. Biosystems Engineering, 211, 141–151. https://doi.org/10.1016/j.biosystemseng.2020.12.005
## 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            576     576     576       0              0          0
## Sorted                   <NA>    <NA>    <NA>    TRUE           TRUE       TRUE
##                                                                                
##                    crop.orig man.source.orig              app.method.orig
## Class              character       character                    character
## Minimum                Grass          Cattle Band spread or trailing hose
## Maximum                Grass          Cattle                    Wide band
## Mean                    <NA>            <NA>                         <NA>
## Unique (excld. NA)         1               1                            4
## 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                     bc        None 2019-05-27             5        5
## Maximum                     os        None 2019-05-27           572       68
## Mean                      <NA>        <NA>       <NA>           288     36.5
## Unique (excld. NA)           3           1          1            64       64
## Missing values               0           0          0             0        0
## Sorted                   FALSE        TRUE       TRUE          TRUE     TRUE
##                                                                             
##                            first.rows ggplotgroup
## Class                          factor      factor
## Minimum             Plots 10 Emis. 50 (4.94,10.7]
## Maximum              Plots 9 Emis. 41 (62.3,68.1]
## Mean               Plots 41 Emis. 329 (33.6,39.4]
## Unique (excld. NA)                 64          11
## Missing values                      0           0
## Sorted                          FALSE        TRUE
##