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.50
## [1] "Date/time: 2024-05-30 09:40:03.460406"

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
WUR Huijsmans, Jan 1 2024-02-22

2. Contributors

contributor institute
?? WUR

3. File and directory names

## [1] "../../data-submitted/03/WUR"
## [1] "../../data-submitted/03/WUR/WUR_arable_2024.xlsx"

4. Location

## Skipping map because lat/long not provided.

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

## bta (cum. time since application began) is not available.

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
## 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

## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."
## [1] "No start or end times provided, so cannot check for missing time."

Measurement method and units

Measurement technique:

Method Frequency
IHF 973

Measurement technique classification:

Classification Frequency
micro met 973

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

Manure and application

## man.stor : No values to check.
## man.dm : OK
## man.vs : No values to check.
## man.tkn : No values to check.
## 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:
##         pub.id            rep      plot.area            lat           long 
##            973            973            467            973            973 
##           topo    soil.samp.z           clay           silt           sand 
##            973            973            973            973            973 
##             oc     soil.water   soil.water.v     soil.moist        soil.ph 
##            973            973            457            973            973 
##      soil.dens       crop.res man.source.det        man.bed        man.con 
##            973            973            973            973            973 
##       man.trt2       man.trt3       man.stor         man.dm         man.vs 
##            973            973            973             24            973 
##        man.tkn        man.tic         man.ua        man.vfa         man.ph 
##            973            973            973            973            529 
##      app.start        app.end    time.incorp       man.area       dist.inj 
##            973            973            567            973            973 
##       furrow.z       furrow.w         crop.z      crop.area            lai 
##            973            973            470            973            973 
##     notes.plot app.start.orig   app.end.orig        t.start          t.end 
##            964            973            973            973            973 
##          bg.dl         bg.val        bg.unit        pH.surf      soil.temp 
##            973            973            973            973            973 
##    soil.temp.z soil.temp.surf            rad            MOL          ustar 
##            973            973            470            973            973 
##             rl       air.pres  air.pres.unit             rh       wind.loc 
##            973            973            973            973            973 
##        far.loc      notes.int   t.start.orig     t.end.orig        dt.calc 
##            973            972            467            467            973 
##        dt.diff            bta       pub.info     soil.type2         exper2 
##            973            973            973            973            973 
##           rep2     date.start 
##            973            973

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

## 
##  120 rows and 195 columns
##  120 unique rows
##                     pub.id      proj     exper
## Class              logical character character
## Minimum               <NA>  B1990-15  B1990-15
## Maximum               <NA>  B2011-17  B2011-17
## Mean                  <NA>      <NA>      <NA>
## Unique (excld. NA)       0        41        41
## Missing values         120         0         0
## Sorted                <NA>      TRUE      TRUE
##                                               
##                                                                                                                                               cpmid
## Class                                                                                                                                     character
## Minimum            D:1.I:WUR.Pr:B1990-15.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B1990-15.F:1-Slootdorp.P:1.T:1.R:NA.R2:.T:NA.M:IHFIHF
## Maximum              D:1.I:WUR.Pr:B2011-17.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B2011-17.F:Slootdorp.P:4.T:4.R:NA.R2:.T:NA.M:IHFIHF
## Mean                                                                                                                                           <NA>
## Unique (excld. NA)                                                                                                                              120
## Missing values                                                                                                                                    0
## Sorted                                                                                                                                         TRUE
##                                                                                                                                                    
##                          field    plot     rep plot.area     lat    long
## Class                character numeric logical   numeric numeric numeric
## Minimum            1-Slootdorp       1    <NA>      1060    <NA>    <NA>
## Maximum              Slootdorp      82    <NA>      1710    <NA>    <NA>
## Mean                      <NA>    21.1    <NA>      1450    <NA>    <NA>
## Unique (excld. NA)          56      55       0        66       0       0
## Missing values               0       0     120        54     120     120
## Sorted                   FALSE   FALSE    <NA>     FALSE    <NA>    <NA>
##                                                                         
##                      country    topo soil.samp.z    clay    silt    sand
## Class              character logical     logical logical logical logical
## Minimum                   NL    <NA>        <NA>    <NA>    <NA>    <NA>
## Maximum                   NL    <NA>        <NA>    <NA>    <NA>    <NA>
## Mean                    <NA>    <NA>        <NA>    <NA>    <NA>    <NA>
## Unique (excld. NA)         1       0           0       0       0       0
## Missing values             0     120         120     120     120     120
## Sorted                  TRUE    <NA>        <NA>    <NA>    <NA>    <NA>
##                                                                         
##                         oc  soil.type soil.water soil.water.v soil.moist
## Class              logical  character    logical      numeric    logical
## Minimum               <NA>       clay       <NA>            9       <NA>
## Maximum               <NA> sandy loam       <NA>         33.5       <NA>
## Mean                  <NA>       <NA>       <NA>         18.7       <NA>
## Unique (excld. NA)       0          3          0           26          0
## Missing values         120          0        120           59        120
## Sorted                <NA>      FALSE       <NA>        FALSE       <NA>
##                                                                         
##                    soil.ph soil.dens crop.res      till man.source
## Class              logical   logical  logical character  character
## Minimum               <NA>      <NA>     <NA>        no      dairy
## Maximum               <NA>      <NA>     <NA>       yes        pig
## Mean                  <NA>      <NA>     <NA>      <NA>       <NA>
## Unique (excld. NA)       0         0        0         2          3
## Missing values         120       120      120         0          0
## Sorted                <NA>      <NA>     <NA>     FALSE      FALSE
##                                                                   
##                    man.source.det man.bed man.con  man.trt1 man.trt2 man.trt3
## Class                     logical logical logical character  logical  logical
## Minimum                      <NA>    <NA>    <NA>      None     <NA>     <NA>
## Maximum                      <NA>    <NA>    <NA>      None     <NA>     <NA>
## Mean                         <NA>    <NA>    <NA>      <NA>     <NA>     <NA>
## Unique (excld. NA)              0       0       0         1        0        0
## Missing values                120     120     120         0      120      120
## Sorted                       <NA>    <NA>    <NA>      TRUE     <NA>     <NA>
##                                                                              
##                    man.stor  man.dm  man.vs man.tkn man.tan man.tic  man.ua
## Class               logical numeric logical logical numeric logical logical
## Minimum                <NA>     3.5    <NA>    <NA>     2.4    <NA>    <NA>
## Maximum                <NA>    15.3    <NA>    <NA>     8.1    <NA>    <NA>
## Mean                   <NA>    7.81    <NA>    <NA>    4.69    <NA>    <NA>
## Unique (excld. NA)        0      61       0       0      52       0       0
## Missing values          120       3     120     120       0     120     120
## Sorted                 <NA>   FALSE    <NA>    <NA>   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph       app.start         app.end app.method
## Class              logical numeric POSIXct, POSIXt POSIXct, POSIXt  character
## Minimum               <NA>     7.2            <NA>            <NA>         bc
## Maximum               <NA>     8.5            <NA>            <NA>         ts
## Mean                  <NA>    7.87            <NA>            <NA>       <NA>
## Unique (excld. NA)       0      13               0               0          4
## Missing values         120      62             120             120          0
## Sorted                <NA>   FALSE            <NA>            <NA>      FALSE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  logical
## Minimum                12.1          t/ha      deep        0.05     <NA>
## Maximum                42.8          t/ha   shallow         1.5     <NA>
## Mean                     23          <NA>      <NA>       0.128     <NA>
## Unique (excld. NA)      113             1         3           3        0
## Missing values            0             0         0          71      120
## Sorted                FALSE          TRUE     FALSE       FALSE     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  logical  logical character numeric   numeric
## Minimum                <NA>     <NA>     <NA>      none       0      <NA>
## Maximum                <NA>     <NA>     <NA>     wheat      16      <NA>
## Mean                   <NA>     <NA>     <NA>      <NA>    5.81      <NA>
## Unique (excld. NA)        0        0        0         3       9         0
## Missing values          120      120      120         0      62       120
## Sorted                 <NA>     <NA>     <NA>     FALSE   FALSE      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5       WUR          3
## Maximum               <NA>          .              124       WUR          3
## Mean                  <NA>       <NA>             64.5      <NA>          3
## Unique (excld. NA)       0          1              120         1          1
## Missing values         120        119                0         0          0
## Sorted                <NA>       TRUE            FALSE      TRUE       TRUE
##                                                                            
##                                                                file   treat
## Class                                                     character numeric
## Minimum            ../../data-submitted/03/WUR/WUR_arable_2024.xlsx       1
## Maximum            ../../data-submitted/03/WUR/WUR_arable_2024.xlsx      82
## Mean                                                           <NA>    21.1
## Unique (excld. NA)                                                1      55
## Missing values                                                    0       0
## Sorted                                                         TRUE   FALSE
##                                                                            
##                    meas.tech meas.tech.det app.start.orig app.end.orig
## Class              character     character        logical      logical
## Minimum                  IHF           IHF           <NA>         <NA>
## Maximum                  IHF           IHF           <NA>         <NA>
## Mean                    <NA>          <NA>           <NA>         <NA>
## Unique (excld. NA)         1             1              0            0
## Missing values             0             0            120          120
## Sorted                  TRUE          TRUE           <NA>         <NA>
##                                                                       
##                                                                                                                                       cpid
## Class                                                                                                                            character
## Minimum            D:1.I:WUR.Pr:B1990-15.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B1990-15.F:1-Slootdorp.P:1.T:1.R:NA.R2:.T:NA
## Maximum              D:1.I:WUR.Pr:B2011-17.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B2011-17.F:Slootdorp.P:4.T:4.R:NA.R2:.T:NA
## Mean                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                     120
## Missing values                                                                                                                           0
## Sorted                                                                                                                                TRUE
##                                                                                                                                           
##                                                ceid flag.plot      submitter
## Class                                     character character      character
## Minimum            D:1.I:WUR.Pr:B1990-15.E:B1990-15           Huijsmans, Jan
## Maximum            D:1.I:WUR.Pr:B2011-17.E:B2011-17           Huijsmans, Jan
## Mean                                           <NA>      <NA>           <NA>
## Unique (excld. NA)                               41         1              1
## Missing values                                    0         0              0
## Sorted                                         TRUE      TRUE           TRUE
##                                                                             
##                    tan.app     e.1     e.4     e.6    e.12    e.24    e.48
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum               45.1   0.027  0.0605  0.0723   0.092   0.109   0.127
## Maximum                235    29.6    86.6    99.5     107     110     117
## Mean                   106    6.03    13.5    16.7    19.6    21.9    25.9
## Unique (excld. NA)     118      85     120     120     119     119     105
## Missing values           0      34       0       0       1       1      15
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                       e.72    e.96   e.168 e.final   e.tot e.cum.1 e.cum.4
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum              0.145    1.95    <NA>   0.162   0.162   0.027  0.0605
## Maximum                121    99.9    <NA>     125     125    29.6    86.6
## Mean                  28.2    24.9    <NA>      28      28    6.03    13.5
## Unique (excld. NA)      95      31       0     120     120      85     120
## Missing values          25      89     120       0       0      34       0
## Sorted               FALSE   FALSE    <NA>   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    e.cum.6 e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96
## Class              numeric  numeric  numeric  numeric  numeric  numeric
## Minimum             0.0723    0.092    0.109    0.127    0.145     1.95
## Maximum               99.5      107      110      117      121     99.9
## Mean                  16.7     19.6     21.9     25.9     28.2     24.9
## Unique (excld. NA)     120      119      119      105       95       31
## Missing values           0        1        1       15       25       89
## Sorted               FALSE    FALSE    FALSE    FALSE    FALSE    FALSE
##                                                                        
##                    e.cum.168 e.cum.final e.cum.tot  e.rel.1  e.rel.4  e.rel.6
## Class                numeric     numeric   numeric  numeric  numeric  numeric
## Minimum                 <NA>       0.162     0.162 0.000129 0.000289 0.000345
## Maximum                 <NA>         125       125     0.25    0.597    0.693
## Mean                    <NA>          28        28   0.0613    0.134    0.165
## Unique (excld. NA)         0         120       120       86      120      120
## Missing values           120           0         0       34        0        0
## Sorted                  <NA>       FALSE     FALSE    FALSE    FALSE    FALSE
##                                                                              
##                    e.rel.12 e.rel.24 e.rel.48 e.rel.72 e.rel.96 e.rel.168
## Class               numeric  numeric  numeric  numeric  numeric   numeric
## Minimum            0.000439 0.000522 0.000605  0.00069   0.0283      <NA>
## Maximum               0.745    0.803    0.867    0.894    0.909      <NA>
## Mean                  0.193    0.216    0.251    0.278    0.254      <NA>
## Unique (excld. NA)      119      119      105       95       31         0
## Missing values            1        1       15       25       89       120
## Sorted                FALSE    FALSE    FALSE    FALSE    FALSE      <NA>
##                                                                          
##                    e.rel.final e.rel.tot  rain.1  rain.4  rain.6 rain.12
## Class                  numeric   numeric numeric numeric numeric numeric
## Minimum               0.000772  0.000772       0       0       0       0
## Maximum                  0.909     0.909       0       0       0       0
## Mean                     0.276     0.276       0       0       0       0
## Unique (excld. NA)         119       119       1       1       1       1
## Missing values               0         0      34       0       0       1
## Sorted                   FALSE     FALSE    TRUE    TRUE    TRUE    TRUE
##                                                                         
##                    rain.24 rain.48 rain.72 rain.96 rain.168 rain.final rain.tot
## Class              numeric numeric numeric numeric  numeric    numeric  numeric
## Minimum                  0       0       0       0     <NA>          0        0
## Maximum                  0       0       0       0     <NA>          0        0
## Mean                     0       0       0       0     <NA>          0        0
## Unique (excld. NA)       1       1       1       1        0          1        1
## Missing values           1      15      25      89      120          0        0
## Sorted                TRUE    TRUE    TRUE    TRUE     <NA>       TRUE     TRUE
##                                                                                
##                    air.temp.1 air.temp.4 air.temp.6 air.temp.12 air.temp.24
## Class                 numeric    numeric    numeric     numeric     numeric
## Minimum                  4.47       5.61       5.61        7.95        5.37
## Maximum                  23.7       25.7       28.6        30.8        24.4
## Mean                     13.1       14.2       14.8        15.2          13
## Unique (excld. NA)         71        119        119         120         120
## Missing values             34          0          0           0           0
## Sorted                  FALSE      FALSE      FALSE       FALSE       FALSE
##                                                                            
##                    air.temp.48 air.temp.72 air.temp.96 air.temp.168 air.temp.mn
## Class                  numeric     numeric     numeric      numeric     numeric
## Minimum                   2.34        5.19        6.21         6.21        6.21
## Maximum                   21.9        21.9        21.9         21.9        21.9
## Mean                      12.4        12.3        12.3         12.3        12.3
## Unique (excld. NA)         120         120         120          120         120
## Missing values               0           0           0            0           0
## Sorted                   FALSE       FALSE       FALSE        FALSE       FALSE
##                                                                                
##                     wind.1  wind.4  wind.6 wind.12 wind.24 wind.48 wind.72
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum                0.7   0.971   0.971    1.41     1.1    1.04    1.11
## Maximum                  8    8.58    8.64     8.6    8.31    6.95    7.01
## Mean                  4.06    4.12    4.18    4.27    3.52    3.45    3.33
## Unique (excld. NA)      64     118     119     120     120     120     120
## Missing values          34       0       0       0       0       0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    wind.96 wind.168 wind.mn wind.2m.1 wind.2m.4 wind.2m.6
## Class              numeric  numeric numeric   numeric   numeric   numeric
## Minimum               1.26     1.26    1.26       0.7     0.971     0.971
## Maximum               6.78     6.78    6.78         8      8.58      8.64
## Mean                  3.28     3.27    3.27      4.06      4.12      4.18
## Unique (excld. NA)     120      120     120        65       119       119
## Missing values           0        0       0        34         0         0
## Sorted               FALSE    FALSE   FALSE     FALSE     FALSE     FALSE
##                                                                          
##                    wind.2m.12 wind.2m.24 wind.2m.48 wind.2m.72 wind.2m.96
## Class                 numeric    numeric    numeric    numeric    numeric
## Minimum                  1.41        1.1       1.04       1.11       1.26
## Maximum                   8.6       8.31       6.95       7.01       6.78
## Mean                     4.27       3.52       3.45       3.33       3.28
## Unique (excld. NA)        120        120        120        120        120
## Missing values              0          0          0          0          0
## Sorted                  FALSE      FALSE      FALSE      FALSE      FALSE
##                                                                          
##                    wind.2m.168 wind.2m.mn   rad.1   rad.4   rad.6  rad.12
## Class                  numeric    numeric numeric numeric numeric numeric
## Minimum                   1.26       1.26    13.9    59.4     116     180
## Maximum                   6.78       6.78     616    1260    1390    1490
## Mean                      3.27       3.27     257     533     595     691
## Unique (excld. NA)         120        120      52      58      58      58
## Missing values               0          0      62      62      62      62
## Sorted                   FALSE      FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                          
##                     rad.24  rad.48  rad.72  rad.96 rad.168  rad.mn rain.rate.1
## Class              numeric numeric numeric numeric numeric numeric     numeric
## Minimum                110     108     108     139     158     158           0
## Maximum                945     783     821     925     925     925           0
## Mean                   438     341     353     382     387     387           0
## Unique (excld. NA)      58      58      58      58      58      58           1
## Missing values          62      62      62      62      62      62          34
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE        TRUE
##                                                                               
##                    rain.rate.4 rain.rate.6 rain.rate.12 rain.rate.24
## 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.48 rain.rate.72 rain.rate.96 rain.rate.168
## 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.mn first.row.in.file.int last.row.in.file.int
## Class                   numeric               numeric              numeric
## Minimum                       0                     5                   13
## Maximum                       0                   971                  977
## Mean                          0                   505                  512
## Unique (excld. NA)            1                   120                  120
## Missing values                0                     0                    0
## Sorted                     TRUE                 FALSE                FALSE
##                                                                           
##                     n.ints     dt1   j.rel1  j.NH31  dt.min  dt.max  ct.min
## Class              integer numeric  numeric numeric numeric numeric numeric
## Minimum                  4     0.3 0.000172  0.0277     0.3    3.05     0.3
## Maximum                  9    1.15    0.299    27.7    1.15      33    1.15
## Mean                  8.11   0.756   0.0538    5.25   0.756    24.7   0.756
## Unique (excld. NA)       5      17      113     120      17      62      17
## Missing values           0       0        0       0       0       0       0
## Sorted               FALSE   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               9.07            <NA>            <NA>        1.5
## Maximum               97.7            <NA>            <NA>        1.5
## Mean                  86.4            <NA>            <NA>        1.5
## Unique (excld. NA)     100               0               0          1
## Missing values           0             120             120          0
## Sorted               FALSE            <NA>            <NA>       TRUE
##                                                                      
##                    soil.temp.z  wind.z wind.loc far.loc pub.info soil.type2
## Class                  logical numeric  logical logical  logical    logical
## Minimum                   <NA>       2     <NA>    <NA>     <NA>       <NA>
## Maximum                   <NA>       2     <NA>    <NA>     <NA>       <NA>
## Mean                      <NA>       2     <NA>    <NA>     <NA>       <NA>
## Unique (excld. NA)           0       1        0       0        0          0
## Missing values             120       0      120     120      120        120
## Sorted                    <NA>    TRUE     <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            IHF  micro met      None
## Maximum               <NA>    <NA>   FALSE            IHF  micro met     wheat
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              1          1         3
## Missing values         120     120       0              0          0         0
## Sorted                <NA>    <NA>    TRUE           TRUE       TRUE     FALSE
##                                                                               
##                    man.source.orig app.method.orig app.method2 incorp.orig
## Class                    character       character   character   character
## Minimum                      dairy       Broadcast          bc        Deep
## Maximum                        pig   Trailing shoe          ts     Shallow
## Mean                          <NA>            <NA>        <NA>        <NA>
## Unique (excld. NA)               3               4           4           3
## Missing values                   0               0           0           0
## Sorted                       FALSE           FALSE       FALSE       FALSE
##                                                                           
##                    date.start
## Class                    Date
## Minimum                  <NA>
## Maximum                  <NA>
## Mean                     <NA>
## Unique (excld. NA)          0
## Missing values            120
## Sorted                   <NA>
## 

Interval-level emission data

## 
##  973 rows and 138 columns
##  973 unique rows
##                                                                                                                                               cpmid
## Class                                                                                                                                     character
## Minimum            D:1.I:WUR.Pr:B1990-15.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B1990-15.F:1-Slootdorp.P:1.T:1.R:NA.R2:.T:NA.M:IHFIHF
## Maximum              D:1.I:WUR.Pr:B2011-17.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B2011-17.F:Slootdorp.P:4.T:4.R:NA.R2:.T:NA.M:IHFIHF
## Mean                                                                                                                                           <NA>
## Unique (excld. NA)                                                                                                                              120
## Missing values                                                                                                                                    0
## Sorted                                                                                                                                         TRUE
##                                                                                                                                                    
##                     pub.id      proj     exper       field    plot     rep
## Class              logical character character   character numeric logical
## Minimum               <NA>  B1990-15  B1990-15 1-Slootdorp       1    <NA>
## Maximum               <NA>  B2011-17  B2011-17   Slootdorp      82    <NA>
## Mean                  <NA>      <NA>      <NA>        <NA>      22    <NA>
## Unique (excld. NA)       0        41        41          56      55       0
## Missing values         973         0         0           0       0     973
## Sorted                <NA>      TRUE      TRUE       FALSE   FALSE    <NA>
##                                                                           
##                      treat meas.tech meas.tech.det plot.area     lat    long
## Class              numeric character     character   numeric numeric numeric
## Minimum                  1       IHF           IHF      1060    <NA>    <NA>
## Maximum                 82       IHF           IHF      1710    <NA>    <NA>
## Mean                    22      <NA>          <NA>      1460    <NA>    <NA>
## Unique (excld. NA)      55         1             1        66       0       0
## Missing values           0         0             0       467     973     973
## Sorted               FALSE      TRUE          TRUE     FALSE    <NA>    <NA>
##                                                                             
##                      country    topo soil.samp.z    clay    silt    sand
## Class              character logical     logical logical logical logical
## Minimum                   NL    <NA>        <NA>    <NA>    <NA>    <NA>
## Maximum                   NL    <NA>        <NA>    <NA>    <NA>    <NA>
## Mean                    <NA>    <NA>        <NA>    <NA>    <NA>    <NA>
## Unique (excld. NA)         1       0           0       0       0       0
## Missing values             0     973         973     973     973     973
## Sorted                  TRUE    <NA>        <NA>    <NA>    <NA>    <NA>
##                                                                         
##                         oc  soil.type soil.water soil.water.v soil.moist
## Class              logical  character    logical      numeric    logical
## Minimum               <NA>       clay       <NA>            9       <NA>
## Maximum               <NA> sandy loam       <NA>         33.5       <NA>
## Mean                  <NA>       <NA>       <NA>         18.5       <NA>
## Unique (excld. NA)       0          3          0           26          0
## Missing values         973          0        973          457        973
## Sorted                <NA>      FALSE       <NA>        FALSE       <NA>
##                                                                         
##                    soil.ph soil.dens crop.res      till man.source
## Class              logical   logical  logical character  character
## Minimum               <NA>      <NA>     <NA>        no      dairy
## Maximum               <NA>      <NA>     <NA>       yes        pig
## Mean                  <NA>      <NA>     <NA>      <NA>       <NA>
## Unique (excld. NA)       0         0        0         2          3
## Missing values         973       973      973         0          0
## Sorted                <NA>      <NA>     <NA>     FALSE      FALSE
##                                                                   
##                    man.source.det man.bed man.con  man.trt1 man.trt2 man.trt3
## Class                     logical logical logical character  logical  logical
## Minimum                      <NA>    <NA>    <NA>      None     <NA>     <NA>
## Maximum                      <NA>    <NA>    <NA>      None     <NA>     <NA>
## Mean                         <NA>    <NA>    <NA>      <NA>     <NA>     <NA>
## Unique (excld. NA)              0       0       0         1        0        0
## Missing values                973     973     973         0      973      973
## Sorted                       <NA>    <NA>    <NA>      TRUE     <NA>     <NA>
##                                                                              
##                    man.stor  man.dm  man.vs man.tkn man.tan man.tic  man.ua
## Class               logical numeric logical logical numeric logical logical
## Minimum                <NA>     3.5    <NA>    <NA>     2.4    <NA>    <NA>
## Maximum                <NA>    15.3    <NA>    <NA>     8.1    <NA>    <NA>
## Mean                   <NA>    7.89    <NA>    <NA>    4.66    <NA>    <NA>
## Unique (excld. NA)        0      61       0       0      52       0       0
## Missing values          973      24     973     973       0     973     973
## Sorted                 <NA>   FALSE    <NA>    <NA>   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph       app.start         app.end app.method
## Class              logical numeric POSIXct, POSIXt POSIXct, POSIXt  character
## Minimum               <NA>     7.2            <NA>            <NA>         bc
## Maximum               <NA>     8.5            <NA>            <NA>         ts
## Mean                  <NA>    7.88            <NA>            <NA>       <NA>
## Unique (excld. NA)       0      13               0               0          4
## Missing values         973     529             973             973          0
## Sorted                <NA>   FALSE            <NA>            <NA>      FALSE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  logical
## Minimum                12.1          t/ha      deep        0.05     <NA>
## Maximum                42.8          t/ha   shallow         1.5     <NA>
## Mean                   23.1          <NA>      <NA>       0.134     <NA>
## Unique (excld. NA)      113             1         3           3        0
## Missing values            0             0         0         567      973
## Sorted                FALSE          TRUE     FALSE       FALSE     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  logical  logical character numeric   numeric
## Minimum                <NA>     <NA>     <NA>      none       0      <NA>
## Maximum                <NA>     <NA>     <NA>     wheat      16      <NA>
## Mean                   <NA>     <NA>     <NA>      <NA>    5.79      <NA>
## Unique (excld. NA)        0        0        0         3       9         0
## Missing values          973      973      973         0     470       973
## Sorted                 <NA>     <NA>     <NA>     FALSE   FALSE      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5       WUR          3
## Maximum               <NA>          .              124       WUR          3
## Mean                  <NA>       <NA>             62.4      <NA>          3
## Unique (excld. NA)       0          1              120         1          1
## Missing values         973        964                0         0          0
## Sorted                <NA>       TRUE            FALSE      TRUE       TRUE
##                                                                            
##                                                                file
## Class                                                     character
## Minimum            ../../data-submitted/03/WUR/WUR_arable_2024.xlsx
## Maximum            ../../data-submitted/03/WUR/WUR_arable_2024.xlsx
## Mean                                                           <NA>
## Unique (excld. NA)                                                1
## Missing values                                                    0
## Sorted                                                         TRUE
##                                                                    
##                    app.start.orig app.end.orig
## Class                     logical      logical
## Minimum                      <NA>         <NA>
## Maximum                      <NA>         <NA>
## Mean                         <NA>         <NA>
## Unique (excld. NA)              0            0
## Missing values                973          973
## Sorted                       <NA>         <NA>
##                                               
##                                                                                                                                       cpid
## Class                                                                                                                            character
## Minimum            D:1.I:WUR.Pr:B1990-15.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B1990-15.F:1-Slootdorp.P:1.T:1.R:NA.R2:.T:NA
## Maximum              D:1.I:WUR.Pr:B2011-17.F:../../data-submitted/03/WUR/WUR_arable_2024.xlsx.E:B2011-17.F:Slootdorp.P:4.T:4.R:NA.R2:.T:NA
## Mean                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                     120
## Missing values                                                                                                                           0
## Sorted                                                                                                                                TRUE
##                                                                                                                                           
##                                                ceid flag.plot      submitter
## Class                                     character character      character
## Minimum            D:1.I:WUR.Pr:B1990-15.E:B1990-15           Huijsmans, Jan
## Maximum            D:1.I:WUR.Pr:B2011-17.E:B2011-17           Huijsmans, Jan
## Mean                                           <NA>      <NA>           <NA>
## Unique (excld. NA)                               41         1              1
## Missing values                                    0         0              0
## Sorted                                         TRUE      TRUE           TRUE
##                                                                             
##                    tan.app interval         t.start           t.end      dt
## Class              numeric  numeric POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum               45.1        1            <NA>            <NA>     0.3
## Maximum                235        9            <NA>            <NA>      33
## Mean                   106     4.61            <NA>            <NA>    10.7
## Unique (excld. NA)     118        9               0               0     315
## Missing values           0        0             973             973       0
## Sorted               FALSE    FALSE            <NA>            <NA>   FALSE
##                                                                            
##                      bg.dl  bg.val bg.unit   j.NH3 j.NH3.unit pH.surf air.temp
## Class              logical logical logical numeric  character logical  numeric
## Minimum               <NA>    <NA>    <NA>       0 kg N/ha-hr    <NA>     -0.3
## Maximum               <NA>    <NA>    <NA>    33.8 kg N/ha-hr    <NA>     34.1
## Mean                  <NA>    <NA>    <NA>    1.79       <NA>    <NA>     13.4
## Unique (excld. NA)       0       0       0     967          1       0      512
## Missing values         973     973     973       0          0     973        0
## Sorted                <NA>    <NA>    <NA>   FALSE       TRUE    <NA>    FALSE
##                                                                               
##                    air.temp.z soil.temp soil.temp.z soil.temp.surf     rad
## Class                 numeric   numeric     logical        logical numeric
## Minimum                   1.5      <NA>        <NA>           <NA>    13.9
## Maximum                   1.5      <NA>        <NA>           <NA>    1800
## Mean                      1.5      <NA>        <NA>           <NA>     481
## Unique (excld. NA)          1         0           0              0     492
## Missing values              0       973         973            973     470
## Sorted                   TRUE      <NA>        <NA>           <NA>   FALSE
##                                                                           
##                       wind  wind.z     MOL   ustar      rl air.pres
## Class              numeric numeric logical logical logical  logical
## Minimum                0.5       2    <NA>    <NA>    <NA>     <NA>
## Maximum               9.05       2    <NA>    <NA>    <NA>     <NA>
## Mean                  3.71       2    <NA>    <NA>    <NA>     <NA>
## Unique (excld. NA)     559       1       0       0       0        0
## Missing values           0       0     973     973     973      973
## Sorted               FALSE    TRUE    <NA>    <NA>    <NA>     <NA>
##                                                                    
##                    air.pres.unit    rain      rh wind.loc far.loc notes.int
## Class                    logical numeric logical  logical logical character
## Minimum                     <NA>       0    <NA>     <NA>    <NA>         .
## Maximum                     <NA>       0    <NA>     <NA>    <NA>         .
## Mean                        <NA>       0    <NA>     <NA>    <NA>      <NA>
## Unique (excld. NA)             0       1       0        0       0         1
## Missing values               973       0     973      973     973       972
## Sorted                      <NA>    TRUE    <NA>     <NA>    <NA>      TRUE
##                                                                            
##                    row.in.file.int        j.type         t.start.orig
## Class                      numeric     character            character
## Minimum                          5 emission rate 1998-09-22T12:24:00Z
## Maximum                        977 emission rate 2011-04-24T12:27:00Z
## Mean                           491          <NA>                 <NA>
## Unique (excld. NA)             973             1                  503
## Missing values                   0             0                  467
## Sorted                       FALSE          TRUE                FALSE
##                                                                      
##                              t.end.orig j.NH3.unit.orig j.NH3.orig
## Class                         character       character    numeric
## Minimum            1998-09-22T12:24:00Z      kg N/ha-hr          0
## Maximum            2011-04-24T12:27:00Z      kg N/ha-hr       33.8
## Mean                               <NA>            <NA>       1.79
## Unique (excld. NA)                  503               1        967
## Missing values                      467               0          0
## Sorted                            FALSE            TRUE      FALSE
##                                                                   
##                    j.NH3.conv.fact dt.calc dt.diff      ct      mt     cta
## Class                      numeric logical numeric numeric numeric numeric
## Minimum                          1    <NA>    <NA>     0.3    0.15     0.3
## Maximum                          1    <NA>    <NA>    97.7    89.2    97.7
## Mean                             1    <NA>    <NA>    27.7    22.4    27.7
## Unique (excld. NA)               1       0       0     541     636     541
## Missing values                   0     973     973       0       0       0
## Sorted                        TRUE    <NA>    <NA>   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               <NA>                   0        0     0.5       0  0.0139
## Maximum               <NA>                   0        0    9.05    37.2     125
## Mean                  <NA>      <NA>         0        0    3.71    3.45    18.4
## Unique (excld. NA)       0         1         1        1     567     949     967
## Missing values         973         0         0        0       0       0       0
## Sorted                <NA>      TRUE      TRUE     TRUE   FALSE   FALSE   FALSE
##                                                                                
##                          e    e.rel   j.rel pub.info soil.type2  exper2    rep2
## Class              numeric  numeric numeric  logical    logical logical logical
## Minimum             0.0139 8.58e-05       0     <NA>       <NA>    <NA>    <NA>
## Maximum                125    0.909   0.299     <NA>       <NA>    <NA>    <NA>
## Mean                  18.4    0.182  0.0179     <NA>       <NA>    <NA>    <NA>
## Unique (excld. NA)     967      920     937        0          0       0       0
## Missing values           0        0       0      973        973     973     973
## Sorted               FALSE    FALSE   FALSE     <NA>       <NA>    <NA>    <NA>
##                                                                                
##                       acid meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class              logical      character  character character       character
## Minimum              FALSE            IHF  micro met      None           dairy
## Maximum              FALSE            IHF  micro met     wheat             pig
## Mean                0 TRUE           <NA>       <NA>      <NA>            <NA>
## Unique (excld. NA)       1              1          1         3               3
## Missing values           0              0          0         0               0
## Sorted                TRUE           TRUE       TRUE     FALSE           FALSE
##                                                                               
##                    app.method.orig app.method2 incorp.orig date.start
## Class                    character   character   character       Date
## Minimum                  Broadcast          bc        Deep       <NA>
## Maximum              Trailing shoe          ts     Shallow       <NA>
## Mean                          <NA>        <NA>        <NA>       <NA>
## Unique (excld. NA)               4           4           3          0
## Missing values                   0           0           0        973
## Sorted                       FALSE       FALSE       FALSE       <NA>
##                                                                      
##                    first.row.int row.plot         first.rows ggplotgroup
## Class                    numeric  numeric             factor      factor
## Minimum                        5        5  Plots 10 Emis. 50 (4.88,10.9]
## Maximum                      971      124 Plots 99 Emis. 787   (118,124]
## Mean                         487     62.4 Plots 45 Emis. 346 (58.6,64.5]
## Unique (excld. NA)           120      120                120          20
## Missing values                 0        0                  0           0
## Sorted                     FALSE    FALSE              FALSE        TRUE
##