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:01.537417"

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 2023-11-09

2. Contributors

contributor institute
Pedersen, Johanna Aarhus University
Feilberg, Anders Aarhus University

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.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

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

Measurement method and units

Measurement technique:

Method Frequency
Wind tunnel 3230

Measurement technique classification:

Classification Frequency
wt 3230

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 : OK
## 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:
##         pub.id  meas.tech.det             oc      soil.type   soil.water.v 
##           3230           3230           3230           3230           3230 
##        man.bed       man.trt1       man.trt2       man.trt3       man.stor 
##           3230            518           1595           2672           3230 
##         man.vs        man.tic         man.ua    time.incorp       man.area 
##           3230           3230           3230           3230           3230 
##       dist.inj       furrow.z       furrow.w      crop.area            lai 
##           3230           3230           3230           3230           3230 
##     notes.plot          bg.dl        pH.surf      soil.temp    soil.temp.z 
##           3136           3230           3230           3230           3230 
## soil.temp.surf            rad         wind.z            MOL          ustar 
##           3230           3230           3230           3230           3230 
##             rl       air.pres  air.pres.unit             rh       wind.loc 
##           3230           3230           3230           3230           3230 
##        far.loc      notes.int        wind.2m       pub.info     soil.type2 
##           3230           3229           3230           3230           3230 
##         exper2           rep2 
##           3230           3230

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

## 
##  36 rows and 175 columns
##  36 unique rows
##                     pub.id      proj     exper
## Class              logical character character
## Minimum               <NA>       MAG       22H
## Maximum               <NA>       MAG       22K
## Mean                  <NA>      <NA>      <NA>
## Unique (excld. NA)       0         1         4
## Missing values          36         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_22HIJK_240208.xlsx.E:22H.F:A.P:1.T:Reference.R:1.R2:.T:2022-06-08 12:56:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22K.F:A.P:9.T:Reference.R:3.R2:.T:2022-06-29 13:17:00.M:Wind tunnelNA
## Mean                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                          36
## Missing values                                                                                                                                                               0
## Sorted                                                                                                                                                                    TRUE
##                                                                                                                                                                               
##                        field    plot     rep plot.area     lat    long
## Class              character numeric numeric   numeric numeric numeric
## Minimum                    A       1       1       0.2    56.5    9.57
## Maximum                    A      12       3       0.2    56.5    9.57
## Mean                    <NA>    6.33       2       0.2    56.5    9.57
## Unique (excld. NA)         1       9       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 cm       9      24      65
## Maximum                   DK      Flat      0-5 cm       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  character numeric
## Minimum               <NA>      <NA>       0.19         <NA>        Dry     5.8
## Maximum               <NA>      <NA>       0.31         <NA>        Dry     5.8
## Mean                  <NA>      <NA>      0.248         <NA>       <NA>     5.8
## Unique (excld. NA)       0         0          4            0          1       1
## Missing values          36        36          0           36          0       0
## Sorted                <NA>      <NA>      FALSE         <NA>       TRUE    TRUE
##                                                                                
##                    soil.dens  crop.res      till man.source
## Class                numeric character character  character
## Minimum                 1.09       Yes        No        mix
## Maximum                 1.09       Yes        No        pig
## Mean                    1.09      <NA>      <NA>       <NA>
## Unique (excld. NA)         1         1         1          2
## Missing values             0         0         0          0
## Sorted                  TRUE      TRUE      TRUE      FALSE
##                                                            
##                                                                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
## Class              logical character             character
## Minimum               <NA>    Liquid   Anaerobic digestion
## Maximum               <NA>    Slurry Mechanical separation
## Mean                  <NA>      <NA>                  <NA>
## Unique (excld. NA)       0         2                     2
## Missing values          36         0                     6
## Sorted                <NA>     FALSE                 FALSE
##                                                           
##                                 man.trt2  man.trt3 man.stor  man.dm  man.vs
## Class                          character character  logical numeric logical
## Minimum            Mechanical separation    Plasma     <NA>       2    <NA>
## Maximum                           Plasma    Plasma     <NA>     6.3    <NA>
## Mean                                <NA>      <NA>     <NA>    3.62    <NA>
## Unique (excld. NA)                     2         1        0       8       0
## Missing values                        18        30       36       0      36
## Sorted                             FALSE      TRUE     <NA>   FALSE    <NA>
##                                                                            
##                    man.tkn man.tan man.tic  man.ua man.vfa  man.ph
## Class              numeric numeric logical logical numeric numeric
## Minimum               1.87    1.04    <NA>    <NA>    0.38     4.8
## Maximum               4.11    2.08    <NA>    <NA>    9.48     8.4
## Mean                  2.75    1.67    <NA>    <NA>    3.78    6.78
## Unique (excld. NA)      12      11       0       0      12      11
## Missing values           0       0      36      36       0       0
## Sorted               FALSE   FALSE    <NA>    <NA>   FALSE   FALSE
##                                                                   
##                              app.start             app.end app.method app.rate
## Class                  POSIXct, POSIXt     POSIXct, POSIXt  character  numeric
## Minimum            2022-06-08 12:56:00 2022-06-15 06:59:00       bsth       30
## Maximum            2022-06-29 14:37:00 2022-07-06 07:09:00       bsth       30
## Mean               2022-06-19 01:07:35 2022-06-25 20:19:41       <NA>       30
## Unique (excld. NA)                  36                  36          1        1
## Missing values                       0                   0          0        0
## Sorted                           FALSE               FALSE       TRUE     TRUE
##                                                                               
##                    app.rate.unit    incorp time.incorp man.area dist.inj
## Class                  character character     numeric  logical  logical
## Minimum                     t/ha      none        <NA>     <NA>     <NA>
## Maximum                     t/ha      none        <NA>     <NA>     <NA>
## Mean                        <NA>      <NA>        <NA>     <NA>     <NA>
## Unique (excld. NA)             1         1           0        0        0
## Missing values                 0         0          36       36       36
## Sorted                      TRUE      TRUE        <NA>     <NA>     <NA>
##                                                                         
##                    furrow.z furrow.w      crop  crop.z crop.area     lai
## Class               logical  logical character numeric   numeric logical
## Minimum                <NA>     <NA>     grass       5      <NA>    <NA>
## Maximum                <NA>     <NA>     grass      40      <NA>    <NA>
## Mean                   <NA>     <NA>      <NA>    22.5      <NA>    <NA>
## Unique (excld. NA)        0        0         1      36         0       0
## Missing values           36       36         0       0        36      36
## Sorted                 <NA>     <NA>      TRUE   FALSE      <NA>    <NA>
##                                                                         
##                    notes.plot row.in.file.plot institute sub.period
## Class               character          numeric character    numeric
## Minimum                     .                5        AU          3
## Maximum                     .               40        AU          3
## Mean                     <NA>             22.5      <NA>          3
## Unique (excld. NA)          1               36         1          1
## Missing values             35                0         0          0
## Sorted                   TRUE            FALSE      TRUE       TRUE
##                                                                    
##                                                                                 file
## Class                                                                      character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.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               Plasma Wind tunnel          <NA> 2022-06-08 12:56:00
## Maximum            Separated Wind tunnel          <NA> 2022-06-29 14:37:00
## Mean                    <NA>        <NA>          <NA> 2022-06-19 01:07:35
## Unique (excld. NA)         3           1             0                  36
## Missing values             0           0            36                   0
## Sorted                 FALSE        TRUE          <NA>               FALSE
##                                                                           
##                           app.end.orig
## Class                  POSIXct, POSIXt
## Minimum            2022-06-15 06:59:00
## Maximum            2022-07-06 07:09:00
## Mean               2022-06-25 20:19:41
## Unique (excld. NA)                  36
## Missing values                       0
## Sorted                           FALSE
##                                       
##                                                                                                                                                           cpid
## Class                                                                                                                                                character
## Minimum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22H.F:A.P:1.T:Reference.R:1.R2:.T:2022-06-08 12:56:00
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22K.F:A.P:9.T:Reference.R:3.R2:.T:2022-06-29 13:17:00
## Mean                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                          36
## Missing values                                                                                                                                               0
## Sorted                                                                                                                                                    TRUE
##                                                                                                                                                               
##                                     ceid flag.plot         submitter tan.app
## Class                          character character         character numeric
## Minimum            D:1.I:AU.Pr:MAG.E:22H           Pedersen, Johanna    31.2
## Maximum            D:1.I:AU.Pr:MAG.E:22K           Pedersen, Johanna    62.4
## Mean                                <NA>      <NA>              <NA>    50.1
## Unique (excld. NA)                     4         1                 1      11
## 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.11   0.167    0.19   0.369   0.586   0.733
## Maximum               <NA>    8.92    11.9    16.9    21.6    24.8    26.7
## Mean                  <NA>    2.18    2.95    4.22    5.93    7.59    8.31
## Unique (excld. NA)       0      36      36      36      36      36      36
## Missing values          36       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.889    <NA>    1.18    1.18    <NA>    0.11   0.167
## Maximum               27.9    <NA>    29.8    29.8    <NA>    8.92    11.9
## Mean                  8.76    <NA>    9.49    9.49    <NA>    2.18    2.95
## Unique (excld. NA)      36       0      36      36       0      36      36
## Missing values           0      36       0       0      36       0       0
## Sorted               FALSE    <NA>   FALSE   FALSE    <NA>   FALSE   FALSE
##                                                                           
##                    e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96 e.cum.168
## Class               numeric  numeric  numeric  numeric  numeric   numeric
## Minimum                0.19    0.369    0.586    0.733    0.889      <NA>
## Maximum                16.9     21.6     24.8     26.7     27.9      <NA>
## Mean                   4.22     5.93     7.59     8.31     8.76      <NA>
## Unique (excld. NA)       36       36       36       36       36         0
## Missing values            0        0        0        0        0        36
## Sorted                FALSE    FALSE    FALSE    FALSE    FALSE      <NA>
##                                                                          
##                    e.cum.final e.cum.tot e.rel.1 e.rel.4 e.rel.6 e.rel.12
## Class                  numeric   numeric numeric numeric numeric  numeric
## Minimum                   1.18      1.18    <NA> 0.00202 0.00378  0.00578
## Maximum                   29.8      29.8    <NA>   0.156   0.209    0.296
## Mean                      9.49      9.49    <NA>  0.0402  0.0543   0.0772
## Unique (excld. NA)          36        36       0      36      36       36
## Missing values               0         0      36       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.00984   0.0188   0.0235   0.0285      <NA>      0.0378
## Maximum               0.379    0.435    0.469    0.489      <NA>       0.522
## Mean                  0.109    0.141    0.154    0.163      <NA>       0.176
## Unique (excld. NA)       36       36       36       36         0          36
## Missing values            0        0        0        0        36           0
## Sorted                FALSE    FALSE    FALSE    FALSE      <NA>       FALSE
##                                                                             
##                    e.rel.tot  rain.1  rain.4  rain.6 rain.12 rain.24 rain.48
## Class                numeric numeric numeric numeric numeric numeric numeric
## Minimum               0.0378    <NA>       0       0       0       0       0
## Maximum                0.522    <NA>       0       0       0       0       0
## Mean                   0.176    <NA>       0       0       0       0       0
## Unique (excld. NA)        36       0       1       1       1       1       1
## Missing values             0      36       0       0       0       0       0
## Sorted                 FALSE    <NA>    TRUE    TRUE    TRUE    TRUE    TRUE
##                                                                             
##                    rain.72 rain.96 rain.168 rain.final rain.tot air.temp.1
## Class              numeric numeric  numeric    numeric  numeric    numeric
## Minimum                  0       0     <NA>          0        0       <NA>
## Maximum                  0       0     <NA>          0        0       <NA>
## Mean                     0       0     <NA>          0        0       <NA>
## Unique (excld. NA)       1       1        0          1        1          0
## Missing values           0       0       36          0        0         36
## Sorted                TRUE    TRUE     <NA>       TRUE     TRUE       <NA>
##                                                                           
##                    air.temp.4 air.temp.6 air.temp.12 air.temp.24 air.temp.48
## Class                 numeric    numeric     numeric     numeric     numeric
## Minimum                    15         15        14.4        13.3        14.2
## Maximum                  22.1         22        20.4        18.5        19.1
## Mean                     17.2       17.2        16.1          15        16.1
## Unique (excld. NA)         13         21          27          33          34
## 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                   14.4        14.5         13.8        13.8    <NA>
## Maximum                   18.7        19.2         17.8        17.8    <NA>
## Mean                      16.4        16.6         15.5        15.5    <NA>
## Unique (excld. NA)          36          36           36          36       0
## Missing values               0           0            0           0      36
## 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.2     0.2     0.2     0.2     0.2     0.2     0.2
## Maximum                0.2     0.2     0.2     0.2     0.2     0.2     0.2
## Mean                   0.2     0.2     0.2     0.2     0.2     0.2     0.2
## Unique (excld. NA)       2       2       2       2       2       2       2
## Missing values           0       0       0       0       0       0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    wind.168 wind.mn rain.rate.1 rain.rate.4 rain.rate.6
## Class               numeric numeric     numeric     numeric     numeric
## Minimum                 0.2     0.2        <NA>           0           0
## Maximum                 0.2     0.2        <NA>           0           0
## Mean                    0.2     0.2        <NA>           0           0
## Unique (excld. NA)        2       2           0           1           1
## Missing values            0       0          36           0           0
## Sorted                FALSE   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                   98      80    1.72
## Maximum                             3140                 3230      94    1.73
## Mean                                1570                 1660    89.7    1.73
## Unique (excld. NA)                    36                   36       6       3
## Missing values                         0                    0       0       0
## Sorted                              TRUE                 TRUE   FALSE   FALSE
##                                                                              
##                      j.rel1  j.NH31  dt.min  dt.max  ct.min  ct.max
## Class               numeric numeric numeric numeric numeric numeric
## Minimum            6.31e-05 0.00373   0.133    1.73    1.72     159
## Maximum              0.0433    2.47    1.72      26    1.73     166
## Mean                 0.0109   0.584    1.64    9.58    1.73     163
## Unique (excld. NA)       36      36       5       8       3       8
## Missing values            0       0       0       0       0       0
## Sorted                FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                    
##                              t.start.p             t.end.p air.temp.z
## Class                  POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum            2022-06-08 12:56:00 2022-06-15 05:15:00          2
## Maximum            2022-06-29 14:37:00 2022-07-06 05:25:00          2
## Mean               2022-06-19 01:07:35 2022-06-25 18:35:41          2
## Unique (excld. NA)                  36                  36          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              36      36       36      36       36         36
## Sorted                    <NA>    <NA>     <NA>    <NA>     <NA>       <NA>
##                                                                            
##                     exper2    rep2    acid meas.tech.orig meas.tech2 crop.orig
## Class              logical logical logical      character  character character
## Minimum               <NA>    <NA>   FALSE    Wind tunnel         wt     Grass
## Maximum               <NA>    <NA>   FALSE    Wind tunnel         wt     Grass
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              1          1         1
## Missing values          36      36       0              0          0         0
## Sorted                <NA>    <NA>    TRUE           TRUE       TRUE      TRUE
##                                                                               
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                        Mix Band spread or trailing hose        bsth
## Maximum                        Pig Band spread or trailing hose        bsth
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               2                            1           1
## Missing values                   0                            0           0
## Sorted                       FALSE                         TRUE        TRUE
##                                                                            
##                    incorp.orig date.start
## Class                character       Date
## Minimum                   None 2022-06-08
## Maximum                   None 2022-06-29
## Mean                      <NA>       <NA>
## Unique (excld. NA)           1          4
## Missing values               0          0
## Sorted                    TRUE       TRUE
## 

Interval-level emission data

## 
##  3230 rows and 138 columns
##  3230 unique rows
##                                                                                                                                                                          cpmid
## Class                                                                                                                                                                character
## Minimum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22H.F:A.P:1.T:Reference.R:1.R2:.T:2022-06-08 12:56:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22K.F:A.P:9.T:Reference.R:3.R2:.T:2022-06-29 13:17:00.M:Wind tunnelNA
## Mean                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                          36
## Missing values                                                                                                                                                               0
## Sorted                                                                                                                                                                    TRUE
##                                                                                                                                                                               
##                     pub.id      proj     exper     field    plot     rep
## Class              logical character character character numeric numeric
## Minimum               <NA>       MAG       22H         A       1       1
## Maximum               <NA>       MAG       22K         A      12       3
## Mean                  <NA>      <NA>      <NA>      <NA>    6.32       2
## Unique (excld. NA)       0         1         4         1       9       3
## Missing values        3230         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               Plasma Wind tunnel          <NA>       0.2    56.5
## Maximum            Separated Wind tunnel          <NA>       0.2    56.5
## Mean                    <NA>        <NA>          <NA>       0.2    56.5
## Unique (excld. NA)         3           1             0         1       1
## Missing values             0           0          3230         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.57        DK      Flat      0-5 cm       9      24
## Maximum               9.57        DK      Flat      0-5 cm       9      24
## Mean                  9.57      <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  character
## Minimum                 65    <NA>      <NA>       0.19         <NA>        Dry
## Maximum                 65    <NA>      <NA>       0.31         <NA>        Dry
## Mean                    65    <NA>      <NA>      0.249         <NA>       <NA>
## Unique (excld. NA)       1       0         0          4            0          1
## Missing values           0    3230      3230          0         3230          0
## Sorted                TRUE    <NA>      <NA>      FALSE         <NA>       TRUE
##                                                                                
##                    soil.ph soil.dens  crop.res      till man.source
## Class              numeric   numeric character character  character
## Minimum                5.8      1.09       Yes        No        mix
## Maximum                5.8      1.09       Yes        No        pig
## Mean                   5.8      1.09      <NA>      <NA>       <NA>
## Unique (excld. NA)       1         1         1         1          2
## Missing values           0         0         0         0          0
## Sorted                TRUE      TRUE      TRUE      TRUE      FALSE
##                                                                    
##                                                                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
## Class              logical character             character
## Minimum               <NA>    Liquid   Anaerobic digestion
## Maximum               <NA>    Slurry Mechanical separation
## Mean                  <NA>      <NA>                  <NA>
## Unique (excld. NA)       0         2                     2
## Missing values        3230         0                   518
## Sorted                <NA>     FALSE                 FALSE
##                                                           
##                                 man.trt2  man.trt3 man.stor  man.dm  man.vs
## Class                          character character  logical numeric logical
## Minimum            Mechanical separation    Plasma     <NA>       2    <NA>
## Maximum                           Plasma    Plasma     <NA>     6.3    <NA>
## Mean                                <NA>      <NA>     <NA>    3.66    <NA>
## Unique (excld. NA)                     2         1        0       8       0
## Missing values                      1595      2672     3230       0    3230
## Sorted                             FALSE      TRUE     <NA>   FALSE    <NA>
##                                                                            
##                    man.tkn man.tan man.tic  man.ua man.vfa  man.ph
## Class              numeric numeric logical logical numeric numeric
## Minimum               1.87    1.04    <NA>    <NA>    0.38     4.8
## Maximum               4.11    2.08    <NA>    <NA>    9.48     8.4
## Mean                  2.77    1.68    <NA>    <NA>    3.64     6.8
## Unique (excld. NA)      12      11       0       0      12      11
## Missing values           0       0    3230    3230       0       0
## Sorted               FALSE   FALSE    <NA>    <NA>   FALSE   FALSE
##                                                                   
##                              app.start             app.end app.method app.rate
## Class                  POSIXct, POSIXt     POSIXct, POSIXt  character  numeric
## Minimum            2022-06-08 12:56:00 2022-06-15 06:59:00       bsth       30
## Maximum            2022-06-29 14:37:00 2022-07-06 07:09:00       bsth       30
## Mean               2022-06-19 02:49:01 2022-06-25 21:59:59       <NA>       30
## Unique (excld. NA)                  36                  36          1        1
## Missing values                       0                   0          0        0
## Sorted                           FALSE               FALSE       TRUE     TRUE
##                                                                               
##                    app.rate.unit    incorp time.incorp man.area dist.inj
## Class                  character character     numeric  logical  logical
## Minimum                     t/ha      none        <NA>     <NA>     <NA>
## Maximum                     t/ha      none        <NA>     <NA>     <NA>
## Mean                        <NA>      <NA>        <NA>     <NA>     <NA>
## Unique (excld. NA)             1         1           0        0        0
## Missing values                 0         0        3230     3230     3230
## Sorted                      TRUE      TRUE        <NA>     <NA>     <NA>
##                                                                         
##                    furrow.z furrow.w      crop  crop.z crop.area     lai
## Class               logical  logical character numeric   numeric logical
## Minimum                <NA>     <NA>     grass       5      <NA>    <NA>
## Maximum                <NA>     <NA>     grass      40      <NA>    <NA>
## Mean                   <NA>     <NA>      <NA>    22.6      <NA>    <NA>
## Unique (excld. NA)        0        0         1      36         0       0
## Missing values         3230     3230         0       0      3230    3230
## Sorted                 <NA>     <NA>      TRUE   FALSE      <NA>    <NA>
##                                                                         
##                    notes.plot row.in.file.plot institute sub.period
## Class               character          numeric character    numeric
## Minimum                     .                5        AU          3
## Maximum                     .               40        AU          3
## Mean                     <NA>             22.6      <NA>          3
## Unique (excld. NA)          1               36         1          1
## Missing values           3136                0         0          0
## Sorted                   TRUE            FALSE      TRUE       TRUE
##                                                                    
##                                                                                 file
## Class                                                                      character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx
## Mean                                                                            <NA>
## Unique (excld. NA)                                                                 1
## Missing values                                                                     0
## Sorted                                                                          TRUE
##                                                                                     
##                         app.start.orig        app.end.orig
## Class                  POSIXct, POSIXt     POSIXct, POSIXt
## Minimum            2022-06-08 12:56:00 2022-06-15 06:59:00
## Maximum            2022-06-29 14:37:00 2022-07-06 07:09:00
## Mean               2022-06-19 02:49:01 2022-06-25 21:59:59
## Unique (excld. NA)                  36                  36
## 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_22HIJK_240208.xlsx.E:22H.F:A.P:1.T:Reference.R:1.R2:.T:2022-06-08 12:56:00
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_22HIJK_240208.xlsx.E:22K.F:A.P:9.T:Reference.R:3.R2:.T:2022-06-29 13:17:00
## Mean                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                          36
## Missing values                                                                                                                                               0
## Sorted                                                                                                                                                    TRUE
##                                                                                                                                                               
##                                     ceid flag.plot         submitter tan.app
## Class                          character character         character numeric
## Minimum            D:1.I:AU.Pr:MAG.E:22H           Pedersen, Johanna    31.2
## Maximum            D:1.I:AU.Pr:MAG.E:22K           Pedersen, Johanna    62.4
## Mean                                <NA>      <NA>              <NA>    50.4
## Unique (excld. NA)                     4         1                 1      11
## 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 2022-06-08 12:56:00 2022-06-08 14:40:00   0.133
## Maximum                  94 2022-07-06 05:25:00 2022-07-06 07:09:00      26
## Mean                   45.5 2022-06-22 11:20:00 2022-06-22 13:09:09    1.82
## Unique (excld. NA)       94                3229                3229      14
## 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.000928       ppm -0.0574 kg N/ha-hr    <NA>
## Maximum               <NA>   0.0699       ppm    2.47 kg N/ha-hr    <NA>
## Mean                  <NA>  0.00956      <NA>  0.0601       <NA>    <NA>
## Unique (excld. NA)       0      361         1    3230          1       0
## Missing values        3230        0         0       0          0    3230
## 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                 9.2          2      <NA>        <NA>           <NA>
## Maximum                26.6          2      <NA>        <NA>           <NA>
## Mean                   15.6          2      <NA>        <NA>           <NA>
## Unique (excld. NA)      154          1         0           0              0
## Missing values            0          0      3230        3230           3230
## 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>     0.2    <NA>    <NA>    <NA>    <NA>     <NA>
## Maximum               <NA>     0.2    <NA>    <NA>    <NA>    <NA>     <NA>
## Mean                  <NA>     0.2    <NA>    <NA>    <NA>    <NA>     <NA>
## Unique (excld. NA)       0       1       0       0       0       0        0
## Missing values        3230       0    3230    3230    3230    3230     3230
## 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              3230       0    3230     3230    3230      3229
## 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 2022-06-08 12:56:00
## Maximum                       3230 emission rate 2022-07-06 05:25:00
## Mean                          1620          <NA> 2022-06-22 11:20:00
## Unique (excld. NA)            3230             1                3229
## 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            2022-06-08 12:56:00      kg N/ha-hr    -0.0574
## Maximum            2022-07-06 05:25:00      kg N/ha-hr       2.47
## Mean               2022-06-22 11:20:00            <NA>     0.0601
## Unique (excld. NA)                3229               1       3230
## 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   0.133 -3.55e-15    1.72   0.858    1.72
## Maximum                          1      26  3.55e-15     166     165     166
## Mean                             1    1.82 -2.29e-15    82.3    81.4    82.3
## Unique (excld. NA)               1      12         7     456     483     248
## 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.0995 0.00647
## Maximum                165                   0        0    <NA>    4.28    29.8
## Mean                  80.5      <NA>         0        0    <NA>   0.106    7.99
## Unique (excld. NA)     246         1         1        1       0    3230    3230
## Missing values           0         0         0        0    3230       0       0
## Sorted               FALSE      TRUE      TRUE     TRUE    <NA>   FALSE   FALSE
##                                                                                
##                          e    e.rel     j.rel pub.info soil.type2  exper2
## Class              numeric  numeric   numeric  logical    logical logical
## Minimum            0.00647 0.000109 -0.000991     <NA>       <NA>    <NA>
## Maximum               29.8    0.522    0.0433     <NA>       <NA>    <NA>
## Mean                  7.99    0.147   0.00112     <NA>       <NA>    <NA>
## Unique (excld. NA)    3230     3230      3230        0          0       0
## Missing values           0        0         0     3230       3230    3230
## Sorted               FALSE    FALSE     FALSE     <NA>       <NA>    <NA>
##                                                                          
##                       rep2    acid meas.tech.orig meas.tech2 crop.orig
## Class              logical logical      character  character character
## Minimum               <NA>   FALSE    Wind tunnel         wt     Grass
## Maximum               <NA>   FALSE    Wind tunnel         wt     Grass
## Mean                  <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       1              1          1         1
## Missing values        3230       0              0          0         0
## Sorted                <NA>    TRUE           TRUE       TRUE      TRUE
##                                                                       
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                        Mix Band spread or trailing hose        bsth
## Maximum                        Pig Band spread or trailing hose        bsth
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               2                            1           1
## Missing values                   0                            0           0
## Sorted                       FALSE                         TRUE        TRUE
##                                                                            
##                    incorp.orig date.start first.row.int row.plot
## Class                character       Date       numeric  numeric
## Minimum                   None 2022-06-08             5        5
## Maximum                   None 2022-06-08          3140       40
## Mean                      <NA>       <NA>          1570     22.6
## Unique (excld. NA)           1          1            36       36
## Missing values               0          0             0        0
## Sorted                    TRUE       TRUE          TRUE    FALSE
##                                                                 
##                             first.rows ggplotgroup
## Class                           factor      factor
## Minimum             Plots 10 Emis. 661 (4.96,10.8]
## Maximum              Plots 9 Emis. 567   (34.2,40]
## Mean               Plots 28 Emis. 2222 (22.5,28.3]
## Unique (excld. NA)                  36           6
## Missing values                       0           0
## Sorted                           FALSE       FALSE
##