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:51:50.065944"

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-BCE Sommer Sven Gjedde 1 13.06.2022

2. Contributors

contributor institute
Martin Nørregård Hansen SEGES, Aarhus, Denmark
Sven G. Sommer Aarhus University, Denmark

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).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

## [1] "Missing pub codes in Publications sheet."
## [1] "Some pub codes missing in Experiments sheet."

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

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

Measurement method and units

Measurement technique:

Method Frequency
ZINST 24

Measurement technique classification:

Classification Frequency
micro met 24

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 : Some values out of range
## [1] 31.6 37.3
## man.vs : No values to check.
## man.tkn : OK
## man.tan : OK
## man.tic : No values to check.
## man.ua : No values to check.
## man.vfa : No values to check.
## man.ph : OK
## app.rate : OK
## crop.z : OK

Emission

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

8. Missing values

Check for missing values.

All variables

## Some values missing:
## Table below has number of missing observations by variable:
##           silt     soil.water   soil.water.v     soil.moist        soil.ph 
##             24             24             24             24             24 
##      soil.dens       man.trt2       man.trt3       man.stor         man.vs 
##             24             24             24             24             24 
##        man.tic         man.ua        man.vfa    time.incorp       dist.inj 
##             24             24             24              6             24 
##       furrow.z       furrow.w            lai     notes.plot        t.start 
##              6             24             24             18             24 
##          t.end          bg.dl         bg.val        bg.unit        pH.surf 
##             24             24             24             24             24 
##      soil.temp    soil.temp.z soil.temp.surf            rad            MOL 
##             24             24             24             24             24 
##          ustar             rl       air.pres  air.pres.unit             rh 
##             24             24             24             24             24 
##      notes.int   t.start.orig     t.end.orig        dt.calc        dt.diff 
##             23             24             24             24             24 
##            bta       pub.info     soil.type2         exper2           rep2 
##             24             24             24             24             24 
##     date.start 
##             24

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

institute proj exper field plot man.dm man.ph man.tan app.rate tan.app
AU-BCE 1 1 1 1 37.3 8.6 0.86 13.6 11.696
AU-BCE 1 1 1 2 32.8 8.8 0.99 18.2 18.018
AU-BCE 1 1 1 3 31.6 8.6 1.08 19.6 21.168
AU-BCE 1 1 1 4 33.8 8.7 1.27 18.5 23.495

10. dfsumm summary

Plot-level data

## 
##  4 rows and 184 columns
##  4 unique rows
##                       pub.id
## Class              character
## Minimum                    1
## Maximum                    1
## Mean                    <NA>
## Unique (excld. NA)         1
## Missing values             0
## Sorted                  TRUE
##                             
##                                                                                                                                                                                 cpmid
## Class                                                                                                                                                                       character
## Minimum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:1.T:1.R:1.R2:.T:2004-04-22 09:00:00.M:ZINSTLeuning passive flux sampler
## Maximum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:4.T:4.R:1.R2:.T:2004-04-22 10:30:00.M:ZINSTLeuning passive flux sampler
## Mean                                                                                                                                                                             <NA>
## Unique (excld. NA)                                                                                                                                                                  4
## Missing values                                                                                                                                                                      0
## Sorted                                                                                                                                                                           TRUE
##                                                                                                                                                                                      
##                         proj     exper     field    plot     rep plot.area
## Class              character character character numeric numeric   numeric
## Minimum                    1         1         1       1       1      1260
## Maximum                    1         1         1       4       1      1260
## Mean                    <NA>      <NA>      <NA>     2.5       1      1260
## Unique (excld. NA)         1         1         1       4       1         1
## Missing values             0         0         0       0       0         0
## Sorted                  TRUE      TRUE      TRUE    TRUE    TRUE      TRUE
##                                                                           
##                        lat    long   country      topo    clay    silt    sand
## Class              numeric numeric character character numeric logical numeric
## Minimum               55.9    10.1        DK      Flat    13.1    <NA>    81.7
## Maximum               55.9    10.1        DK      Flat    13.1    <NA>    81.7
## Mean                  55.9    10.1      <NA>      <NA>    13.1    <NA>    81.7
## Unique (excld. NA)       1       1         1         1       1       0       1
## Missing values           0       0         0         0       0       4       0
## Sorted                TRUE    TRUE      TRUE      TRUE    TRUE    <NA>    TRUE
##                                                                               
##                         oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class              numeric character    logical      logical    logical logical
## Minimum                2.2      Sand       <NA>         <NA>       <NA>    <NA>
## Maximum                2.2      Sand       <NA>         <NA>       <NA>    <NA>
## Mean                   2.2      <NA>       <NA>         <NA>       <NA>    <NA>
## Unique (excld. NA)       1         1          0            0          0       0
## Missing values           0         0          4            4          4       4
## Sorted                TRUE      TRUE       <NA>         <NA>       <NA>    <NA>
##                                                                                
##                    soil.dens  crop.res      till man.source man.source.det
## Class                logical character character  character      character
## Minimum                 <NA>        No        No        cat          Dairy
## Maximum                 <NA>        No        No        cat          Dairy
## Mean                    <NA>      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         0         1         1          1              1
## Missing values             4         0         0          0              0
## Sorted                  <NA>      TRUE      TRUE       TRUE           TRUE
##                                                                           
##                      man.bed   man.con  man.trt1 man.trt2 man.trt3 man.stor
## Class              character character character  logical  logical  logical
## Minimum                Straw     Solid      None     <NA>     <NA>     <NA>
## Maximum                Straw     Solid      None     <NA>     <NA>     <NA>
## Mean                    <NA>      <NA>      <NA>     <NA>     <NA>     <NA>
## Unique (excld. NA)         1         1         1        0        0        0
## Missing values             0         0         0        4        4        4
## Sorted                  TRUE      TRUE      TRUE     <NA>     <NA>     <NA>
##                                                                            
##                     man.dm  man.vs man.tkn man.tan man.tic  man.ua man.vfa
## Class              numeric logical numeric numeric logical logical logical
## Minimum               31.6    <NA>       6    0.86    <NA>    <NA>    <NA>
## Maximum               37.3    <NA>     7.4    1.27    <NA>    <NA>    <NA>
## Mean                  33.9    <NA>     6.6    1.05    <NA>    <NA>    <NA>
## Unique (excld. NA)       4       0       4       4       0       0       0
## Missing values           0       4       0       0       4       4       4
## Sorted               FALSE    <NA>   FALSE    TRUE    <NA>    <NA>    <NA>
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                8.6 2004-04-22 09:00:00 2004-04-22 09:30:00         bc
## Maximum                8.8 2004-04-22 10:30:00 2004-04-22 11:00:00         bc
## Mean                  8.68 2004-04-22 09:45:00 2004-04-22 10:15:00       <NA>
## Unique (excld. NA)       3                   4                   4          1
## Missing values           0                   0                   0          0
## Sorted               FALSE                TRUE                TRUE       TRUE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  numeric
## Minimum                13.6          t/ha      deep      0.0833      100
## Maximum                19.6          t/ha   shallow           6      100
## Mean                   17.5          <NA>      <NA>        2.14      100
## Unique (excld. NA)        4             1         3           3        1
## Missing values            0             0         0           1        0
## Sorted                FALSE          TRUE     FALSE       FALSE     TRUE
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  numeric  logical character numeric   numeric
## Minimum                <NA>       10     <NA> bare soil       0         0
## Maximum                <NA>       20     <NA> bare soil       0         0
## Mean                   <NA>     13.3     <NA>      <NA>       0         0
## Unique (excld. NA)        0        2        0         1       1         1
## Missing values            4        1        4         0       0         0
## Sorted                 <NA>    FALSE     <NA>      TRUE    TRUE      TRUE
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5    AU-BCE          3
## Maximum               <NA>          .                8    AU-BCE          3
## Mean                  <NA>       <NA>              6.5      <NA>          3
## Unique (excld. NA)       0          1                4         1          1
## Missing values           4          3                0         0          0
## Sorted                <NA>       TRUE             TRUE      TRUE       TRUE
##                                                                            
##                                                                            file
## Class                                                                 character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx
## Mean                                                                       <NA>
## Unique (excld. NA)                                                            1
## Missing values                                                                0
## Sorted                                                                     TRUE
##                                                                                
##                      treat meas.tech                meas.tech.det
## Class              numeric character                    character
## Minimum                  1     ZINST Leuning passive flux sampler
## Maximum                  4     ZINST Leuning passive flux sampler
## Mean                   2.5      <NA>                         <NA>
## Unique (excld. NA)       4         1                            1
## Missing values           0         0                            0
## Sorted                TRUE      TRUE                         TRUE
##                                                                  
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            22-04-2004 09:00 22-04-2004 09:30
## Maximum            22-04-2004 10:30 22-04-2004 11:00
## Mean                           <NA>             <NA>
## Unique (excld. NA)                4                4
## Missing values                    0                0
## Sorted                         TRUE             TRUE
##                                                     
##                                                                                                                                              cpid
## Class                                                                                                                                   character
## Minimum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:1.T:1.R:1.R2:.T:2004-04-22 09:00:00
## Maximum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:4.T:4.R:1.R2:.T:2004-04-22 10:30:00
## Mean                                                                                                                                         <NA>
## Unique (excld. NA)                                                                                                                              4
## Missing values                                                                                                                                  0
## Sorted                                                                                                                                       TRUE
##                                                                                                                                                  
##                                     ceid flag.plot          submitter tan.app
## Class                          character character          character numeric
## Minimum            D:1.I:AU-BCE.Pr:1.E:1           Sommer Sven Gjedde    11.7
## Maximum            D:1.I:AU-BCE.Pr:1.E:1           Sommer Sven Gjedde    23.5
## Mean                                <NA>      <NA>               <NA>    18.6
## Unique (excld. NA)                     1         1                  1       4
## Missing values                         0         0                  0       0
## Sorted                              TRUE      TRUE               TRUE    TRUE
##                                                                              
##                        e.1     e.4     e.6    e.12    e.24    e.48    e.72
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum               <NA>     1.7    2.11    2.12    2.13     2.3    2.43
## Maximum               <NA>    6.67    7.75    7.87    8.12    8.83    9.08
## Mean                  <NA>    3.35    3.98    4.14    4.45    5.22    5.56
## Unique (excld. NA)       0       4       4       4       4       4       4
## Missing values           4       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               2.45    <NA>    2.42    2.42    <NA>     1.7    2.11
## Maximum               9.08    <NA>    9.08    9.08    <NA>    6.67    7.75
## Mean                  5.63    <NA>    5.67    5.67    <NA>    3.35    3.98
## Unique (excld. NA)       4       0       4       4       0       4       4
## Missing values           0       4       0       0       4       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                2.12     2.13      2.3     2.43     2.45      <NA>
## Maximum                7.87     8.12     8.83     9.08     9.08      <NA>
## Mean                   4.14     4.45     5.22     5.56     5.63      <NA>
## Unique (excld. NA)        4        4        4        4        4         0
## Missing values            0        0        0        0        0         4
## 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                   2.42      2.42    <NA>  0.0801   0.117    0.117
## Maximum                   9.08      9.08    <NA>   0.284    0.33    0.335
## Mean                      5.67      5.67    <NA>   0.183   0.217    0.227
## Unique (excld. NA)           4         4       0       4       4        4
## Missing values               0         0       4       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.118    0.128    0.135    0.136      <NA>       0.135
## Maximum               0.368    0.453    0.487    0.489      <NA>       0.486
## Mean                  0.246    0.292    0.311    0.315      <NA>       0.317
## Unique (excld. NA)        4        4        4        4         0           4
## Missing values            0        0        0        0         4           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.135    <NA>       0       0       0       0       0
## Maximum                0.486    <NA>       0       0       0       0       0
## Mean                   0.317    <NA>       0       0       0       0       0
## Unique (excld. NA)         4       0       1       1       1       1       1
## Missing values             0       4       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    2.72     <NA>          7        7       <NA>
## Maximum                  0    2.72     <NA>          7        7       <NA>
## Mean                     0    2.72     <NA>          7        7       <NA>
## Unique (excld. NA)       1       1        0          1        1          0
## Missing values           0       0        4          0        0          4
## 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                    12       13.5        13.5        13.5        10.9
## Maximum                    12       13.5        13.5        13.5        10.9
## Mean                       12       13.5        13.5        13.5        10.9
## Unique (excld. NA)          1          1           1           1           1
## Missing values              0          0           0           0           0
## Sorted                   TRUE       TRUE        TRUE        TRUE        TRUE
##                                                                             
##                    air.temp.72 air.temp.96 air.temp.168 air.temp.mn  wind.1
## Class                  numeric     numeric      numeric     numeric numeric
## Minimum                   10.4        10.3         10.2        10.2    <NA>
## Maximum                   10.4        10.3         10.2        10.2    <NA>
## Mean                      10.4        10.3         10.2        10.2    <NA>
## Unique (excld. NA)           1           1            1           1       0
## Missing values               0           0            0           0       4
## Sorted                    TRUE        TRUE         TRUE        TRUE    <NA>
##                                                                            
##                     wind.4  wind.6 wind.12 wind.24 wind.48 wind.72 wind.96
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum                  5    2.75    2.75    2.75    2.19    2.08    2.06
## Maximum                  5    2.75    2.75    2.75    2.19    2.08    2.06
## Mean                     5    2.75    2.75    2.75    2.19    2.08    2.06
## Unique (excld. NA)       1       1       1       1       1       1       1
## Missing values           0       0       0       0       0       0       0
## Sorted                TRUE    TRUE    TRUE    TRUE    TRUE    TRUE    TRUE
##                                                                           
##                    wind.168 wind.mn wind.2m.1 wind.2m.4 wind.2m.6 wind.2m.12
## Class               numeric numeric   numeric   numeric   numeric    numeric
## Minimum                2.04    2.04      <NA>      3.84      2.11       2.11
## Maximum                2.04    2.04      <NA>      3.84      2.11       2.11
## Mean                   2.04    2.04      <NA>      3.84      2.11       2.11
## Unique (excld. NA)        1       1         0         1         1          1
## Missing values            0       0         4         0         0          0
## Sorted                 TRUE    TRUE      <NA>      TRUE      TRUE       TRUE
##                                                                             
##                    wind.2m.24 wind.2m.48 wind.2m.72 wind.2m.96 wind.2m.168
## Class                 numeric    numeric    numeric    numeric     numeric
## Minimum                  2.11       1.68        1.6       1.58        1.56
## Maximum                  2.11       1.68        1.6       1.58        1.56
## Mean                     2.11       1.68        1.6       1.58        1.56
## Unique (excld. NA)          1          1          1          1           1
## Missing values              0          0          0          0           0
## Sorted                   TRUE       TRUE       TRUE       TRUE        TRUE
##                                                                           
##                    wind.2m.mn rain.rate.1 rain.rate.4 rain.rate.6 rain.rate.12
## Class                 numeric     numeric     numeric     numeric      numeric
## Minimum                  1.56        <NA>           0           0            0
## Maximum                  1.56        <NA>           0           0            0
## Mean                     1.56        <NA>           0           0            0
## Unique (excld. NA)          1           0           1           1            1
## Missing values              0           4           0           0            0
## Sorted                   TRUE        <NA>        TRUE        TRUE         TRUE
##                                                                               
##                    rain.rate.24 rain.rate.48 rain.rate.72 rain.rate.96
## Class                   numeric      numeric      numeric      numeric
## Minimum                       0            0            0            0
## Maximum                       0            0            0            0
## Mean                          0            0            0            0
## Unique (excld. NA)            1            1            1            1
## Missing values                0            0            0            0
## Sorted                     TRUE         TRUE         TRUE         TRUE
##                                                                       
##                    rain.rate.168 rain.rate.mn first.row.in.file.int
## Class                    numeric      numeric               numeric
## Minimum                   0.0579       0.0579                     5
## Maximum                   0.0579       0.0579                    23
## Mean                      0.0579       0.0579                    14
## Unique (excld. NA)             1            1                     4
## Missing values                 0            0                     0
## Sorted                      TRUE         TRUE                  TRUE
##                                                                    
##                    last.row.in.file.int  n.ints     dt1  j.rel1  j.NH31  dt.min
## Class                           numeric integer numeric numeric numeric numeric
## Minimum                              10       6     1.5  0.0203    0.43     1.5
## Maximum                              28       6     1.5   0.151    3.55     1.5
## Mean                                 19       6     1.5  0.0945    1.72     1.5
## Unique (excld. NA)                    4       1       1       4       4       1
## Missing values                        0       0       0       0       0       0
## Sorted                             TRUE    TRUE    TRUE   FALSE   FALSE    TRUE
##                                                                                
##                     dt.max  ct.min  ct.max       t.start.p         t.end.p
## Class              numeric numeric numeric POSIXct, POSIXt POSIXct, POSIXt
## Minimum               40.7     1.5     121            <NA>            <NA>
## Maximum               40.7     1.5     121            <NA>            <NA>
## Mean                  40.7     1.5     121            <NA>            <NA>
## Unique (excld. NA)       1       1       1               0               0
## Missing values           0       0       0               4               4
## Sorted                TRUE    TRUE    TRUE            <NA>            <NA>
##                                                                           
##                    air.temp.z soil.temp.z  wind.z        wind.loc far.loc
## Class                 numeric     logical numeric       character numeric
## Minimum                    10        <NA>      10 Nearest station     500
## Maximum                    10        <NA>      10 Nearest station     500
## Mean                       10        <NA>      10            <NA>     500
## Unique (excld. NA)          1           0       1               1       1
## Missing values              0           4       0               0       0
## Sorted                   TRUE        <NA>    TRUE            TRUE    TRUE
##                                                                          
##                    pub.info soil.type2  exper2    rep2    acid meas.tech.orig
## Class               logical    logical logical logical logical      character
## Minimum                <NA>       <NA>    <NA>    <NA>   FALSE          ZINST
## Maximum                <NA>       <NA>    <NA>    <NA>   FALSE          ZINST
## Mean                   <NA>       <NA>    <NA>    <NA>  0 TRUE           <NA>
## Unique (excld. NA)        0          0       0       0       1              1
## Missing values            4          4       4       4       0              0
## Sorted                 <NA>       <NA>    <NA>    <NA>    TRUE           TRUE
##                                                                              
##                    meas.tech2 crop.orig man.source.orig app.method.orig
## Class               character character       character       character
## Minimum             micro met Bare soil          Cattle       Broadcast
## Maximum             micro met Bare soil          Cattle       Broadcast
## Mean                     <NA>      <NA>            <NA>            <NA>
## Unique (excld. NA)          1         1               1               1
## Missing values              0         0               0               0
## Sorted                   TRUE      TRUE            TRUE            TRUE
##                                                                        
##                    app.method2 incorp.orig date.start
## Class                character   character       Date
## Minimum                     bc        Deep       <NA>
## Maximum                     bc     Shallow       <NA>
## Mean                      <NA>        <NA>       <NA>
## Unique (excld. NA)           1           3          0
## Missing values               0           0          4
## Sorted                    TRUE       FALSE       <NA>
## 

Interval-level emission data

## 
##  24 rows and 137 columns
##  24 unique rows
##                                                                                                                                                                                 cpmid
## Class                                                                                                                                                                       character
## Minimum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:1.T:1.R:1.R2:.T:2004-04-22 09:00:00.M:ZINSTLeuning passive flux sampler
## Maximum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:4.T:4.R:1.R2:.T:2004-04-22 10:30:00.M:ZINSTLeuning passive flux sampler
## Mean                                                                                                                                                                             <NA>
## Unique (excld. NA)                                                                                                                                                                  4
## Missing values                                                                                                                                                                      0
## Sorted                                                                                                                                                                           TRUE
##                                                                                                                                                                                      
##                       pub.id      proj     exper     field    plot     rep
## Class              character character character character numeric numeric
## Minimum                    1         1         1         1       1       1
## Maximum                    1         1         1         1       4       1
## Mean                    <NA>      <NA>      <NA>      <NA>     2.5       1
## Unique (excld. NA)         1         1         1         1       4       1
## Missing values             0         0         0         0       0       0
## Sorted                  TRUE      TRUE      TRUE      TRUE    TRUE    TRUE
##                                                                           
##                      treat meas.tech                meas.tech.det plot.area
## Class              numeric character                    character   numeric
## Minimum                  1     ZINST Leuning passive flux sampler      1260
## Maximum                  4     ZINST Leuning passive flux sampler      1260
## Mean                   2.5      <NA>                         <NA>      1260
## Unique (excld. NA)       4         1                            1         1
## Missing values           0         0                            0         0
## Sorted                TRUE      TRUE                         TRUE      TRUE
##                                                                            
##                        lat    long   country      topo    clay    silt    sand
## Class              numeric numeric character character numeric logical numeric
## Minimum               55.9    10.1        DK      Flat    13.1    <NA>    81.7
## Maximum               55.9    10.1        DK      Flat    13.1    <NA>    81.7
## Mean                  55.9    10.1      <NA>      <NA>    13.1    <NA>    81.7
## Unique (excld. NA)       1       1         1         1       1       0       1
## Missing values           0       0         0         0       0      24       0
## Sorted                TRUE    TRUE      TRUE      TRUE    TRUE    <NA>    TRUE
##                                                                               
##                         oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class              numeric character    logical      logical    logical logical
## Minimum                2.2      Sand       <NA>         <NA>       <NA>    <NA>
## Maximum                2.2      Sand       <NA>         <NA>       <NA>    <NA>
## Mean                   2.2      <NA>       <NA>         <NA>       <NA>    <NA>
## Unique (excld. NA)       1         1          0            0          0       0
## Missing values           0         0         24           24         24      24
## Sorted                TRUE      TRUE       <NA>         <NA>       <NA>    <NA>
##                                                                                
##                    soil.dens  crop.res      till man.source man.source.det
## Class                logical character character  character      character
## Minimum                 <NA>        No        No        cat          Dairy
## Maximum                 <NA>        No        No        cat          Dairy
## Mean                    <NA>      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         0         1         1          1              1
## Missing values            24         0         0          0              0
## Sorted                  <NA>      TRUE      TRUE       TRUE           TRUE
##                                                                           
##                      man.bed   man.con  man.trt1 man.trt2 man.trt3 man.stor
## Class              character character character  logical  logical  logical
## Minimum                Straw     Solid      None     <NA>     <NA>     <NA>
## Maximum                Straw     Solid      None     <NA>     <NA>     <NA>
## Mean                    <NA>      <NA>      <NA>     <NA>     <NA>     <NA>
## Unique (excld. NA)         1         1         1        0        0        0
## Missing values             0         0         0       24       24       24
## Sorted                  TRUE      TRUE      TRUE     <NA>     <NA>     <NA>
##                                                                            
##                     man.dm  man.vs man.tkn man.tan man.tic  man.ua man.vfa
## Class              numeric logical numeric numeric logical logical logical
## Minimum               31.6    <NA>       6    0.86    <NA>    <NA>    <NA>
## Maximum               37.3    <NA>     7.4    1.27    <NA>    <NA>    <NA>
## Mean                  33.9    <NA>     6.6    1.05    <NA>    <NA>    <NA>
## Unique (excld. NA)       4       0       4       4       0       0       0
## Missing values           0      24       0       0      24      24      24
## Sorted               FALSE    <NA>   FALSE    TRUE    <NA>    <NA>    <NA>
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                8.6 2004-04-22 09:00:00 2004-04-22 09:30:00         bc
## Maximum                8.8 2004-04-22 10:30:00 2004-04-22 11:00:00         bc
## Mean                  8.68 2004-04-22 09:45:00 2004-04-22 10:15:00       <NA>
## Unique (excld. NA)       3                   4                   4          1
## Missing values           0                   0                   0          0
## Sorted               FALSE                TRUE                TRUE       TRUE
##                                                                              
##                    app.rate app.rate.unit    incorp time.incorp man.area
## Class               numeric     character character     numeric  numeric
## Minimum                13.6          t/ha      deep      0.0833      100
## Maximum                19.6          t/ha   shallow           6      100
## Mean                   17.5          <NA>      <NA>        2.14      100
## Unique (excld. NA)        4             1         3           3        1
## Missing values            0             0         0           6        0
## Sorted                FALSE          TRUE     FALSE       FALSE     TRUE
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  numeric  logical character numeric   numeric
## Minimum                <NA>       10     <NA> bare soil       0         0
## Maximum                <NA>       20     <NA> bare soil       0         0
## Mean                   <NA>     13.3     <NA>      <NA>       0         0
## Unique (excld. NA)        0        2        0         1       1         1
## Missing values           24        6       24         0       0         0
## Sorted                 <NA>    FALSE     <NA>      TRUE    TRUE      TRUE
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5    AU-BCE          3
## Maximum               <NA>          .                8    AU-BCE          3
## Mean                  <NA>       <NA>              6.5      <NA>          3
## Unique (excld. NA)       0          1                4         1          1
## Missing values          24         18                0         0          0
## Sorted                <NA>       TRUE             TRUE      TRUE       TRUE
##                                                                            
##                                                                            file
## Class                                                                 character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx
## Mean                                                                       <NA>
## Unique (excld. NA)                                                            1
## Missing values                                                                0
## Sorted                                                                     TRUE
##                                                                                
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            22-04-2004 09:00 22-04-2004 09:30
## Maximum            22-04-2004 10:30 22-04-2004 11:00
## Mean                           <NA>             <NA>
## Unique (excld. NA)                4                4
## Missing values                    0                0
## Sorted                         TRUE             TRUE
##                                                     
##                                                                                                                                              cpid
## Class                                                                                                                                   character
## Minimum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:1.T:1.R:1.R2:.T:2004-04-22 09:00:00
## Maximum            D:1.I:AU-BCE.Pr:1.F:../../data-submitted/03/AU/ALFAM2_template_6.1 SGS(Rev).xlsx.E:1.F:1.P:4.T:4.R:1.R2:.T:2004-04-22 10:30:00
## Mean                                                                                                                                         <NA>
## Unique (excld. NA)                                                                                                                              4
## Missing values                                                                                                                                  0
## Sorted                                                                                                                                       TRUE
##                                                                                                                                                  
##                                     ceid flag.plot          submitter tan.app
## Class                          character character          character numeric
## Minimum            D:1.I:AU-BCE.Pr:1.E:1           Sommer Sven Gjedde    11.7
## Maximum            D:1.I:AU-BCE.Pr:1.E:1           Sommer Sven Gjedde    23.5
## Mean                                <NA>      <NA>               <NA>    18.6
## Unique (excld. NA)                     1         1                  1       4
## Missing values                         0         0                  0       0
## Sorted                              TRUE      TRUE               TRUE    TRUE
##                                                                              
##                    interval         t.start           t.end      dt   bg.dl
## Class               numeric POSIXct, POSIXt POSIXct, POSIXt numeric logical
## Minimum                   1            <NA>            <NA>     1.5    <NA>
## Maximum                   6            <NA>            <NA>    40.7    <NA>
## Mean                    3.5            <NA>            <NA>    20.1    <NA>
## Unique (excld. NA)        6               0               0       6       0
## Missing values            0              24              24       0      24
## Sorted                FALSE            <NA>            <NA>   FALSE    <NA>
##                                                                            
##                     bg.val bg.unit    j.NH3 j.NH3.unit pH.surf air.temp
## Class              logical logical  numeric  character logical  numeric
## Minimum               <NA>    <NA> -0.00109 kg N/ha-hr    <NA>       10
## Maximum               <NA>    <NA>     3.55 kg N/ha-hr    <NA>       14
## Mean                  <NA>    <NA>    0.349       <NA>    <NA>       11
## Unique (excld. NA)       0       0       22          1       0        3
## Missing values          24      24        0          0      24        0
## Sorted                <NA>    <NA>    FALSE       TRUE    <NA>    FALSE
##                                                                        
##                    air.temp.z soil.temp soil.temp.z soil.temp.surf     rad
## Class                 numeric   numeric     logical        logical logical
## Minimum                    10      <NA>        <NA>           <NA>    <NA>
## Maximum                    10      <NA>        <NA>           <NA>    <NA>
## Mean                       10      <NA>        <NA>           <NA>    <NA>
## Unique (excld. NA)          1         0           0              0       0
## Missing values              0        24          24             24      24
## Sorted                   TRUE      <NA>        <NA>           <NA>    <NA>
##                                                                           
##                       wind  wind.z     MOL   ustar      rl air.pres
## Class              numeric numeric logical logical logical  logical
## Minimum                  2      10    <NA>    <NA>    <NA>     <NA>
## Maximum                  5      10    <NA>    <NA>    <NA>     <NA>
## Mean                   2.5      10    <NA>    <NA>    <NA>     <NA>
## Unique (excld. NA)       2       1       0       0       0        0
## Missing values           0       0      24      24      24       24
## Sorted               FALSE    TRUE    <NA>    <NA>    <NA>     <NA>
##                                                                    
##                    air.pres.unit    rain      rh        wind.loc far.loc
## Class                    logical numeric logical       character numeric
## Minimum                     <NA>       0    <NA> Nearest station     500
## Maximum                     <NA>       7    <NA> Nearest station     500
## Mean                        <NA>    1.17    <NA>            <NA>     500
## Unique (excld. NA)             0       2       0               1       1
## Missing values                24       0      24               0       0
## Sorted                      <NA>   FALSE    <NA>            TRUE    TRUE
##                                                                         
##                    notes.int row.in.file.int        j.type t.start.orig
## Class              character         numeric     character      logical
## Minimum                    .               5 emission rate         <NA>
## Maximum                    .              28 emission rate         <NA>
## Mean                    <NA>            16.5          <NA>         <NA>
## Unique (excld. NA)         1              24             1            0
## Missing values            23               0             0           24
## Sorted                  TRUE            TRUE          TRUE         <NA>
##                                                                        
##                    t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class                 logical       character    numeric         numeric
## Minimum                  <NA>      kg N/ha-hr   -0.00109               1
## Maximum                  <NA>      kg N/ha-hr       3.55               1
## Mean                     <NA>            <NA>      0.349               1
## Unique (excld. NA)          0               1         22               1
## Missing values             24               0          0               0
## Sorted                   <NA>            TRUE      FALSE            TRUE
##                                                                         
##                    dt.calc dt.diff      ct      mt     cta     bta  flag.int
## Class              logical numeric numeric numeric numeric numeric character
## Minimum               <NA>    <NA>     1.5    0.75     1.5    <NA>          
## Maximum               <NA>    <NA>     121     101     121    <NA>          
## Mean                  <NA>    <NA>    48.2    38.1    48.2    <NA>      <NA>
## Unique (excld. NA)       0       0       6       6       6       0         1
## Missing values          24      24       0       0       0      24         0
## Sorted                <NA>    <NA>   FALSE   FALSE   FALSE    <NA>      TRUE
##                                                                             
##                    rain.rate rain.cum wind.2m   e.int   e.cum       e   e.rel
## Class                numeric  numeric numeric numeric numeric numeric numeric
## Minimum                    0        0    1.53 -0.0444   0.645   0.645  0.0305
## Maximum                0.172        7    3.84    5.32    9.08    9.08    0.49
## Mean                  0.0287     1.17    1.92   0.946    4.63    4.63   0.257
## Unique (excld. NA)         2        2       2      23      22      22      22
## Missing values             0        0       0       0       0       0       0
## Sorted                 FALSE    FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                              
##                        j.rel pub.info soil.type2  exper2    rep2    acid
## Class                numeric  logical    logical logical logical logical
## Minimum            -9.33e-05     <NA>       <NA>    <NA>    <NA>   FALSE
## Maximum                0.151     <NA>       <NA>    <NA>    <NA>   FALSE
## Mean                  0.0192     <NA>       <NA>    <NA>    <NA>  0 TRUE
## Unique (excld. NA)        22        0          0       0       0       1
## Missing values             0       24         24      24      24       0
## Sorted                 FALSE     <NA>       <NA>    <NA>    <NA>    TRUE
##                                                                         
##                    meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class                   character  character character       character
## Minimum                     ZINST  micro met Bare soil          Cattle
## Maximum                     ZINST  micro met Bare soil          Cattle
## Mean                         <NA>       <NA>      <NA>            <NA>
## Unique (excld. NA)              1          1         1               1
## Missing values                  0          0         0               0
## Sorted                       TRUE       TRUE      TRUE            TRUE
##                                                                       
##                    app.method.orig app.method2 incorp.orig date.start
## Class                    character   character   character       Date
## Minimum                  Broadcast          bc        Deep       <NA>
## Maximum                  Broadcast          bc     Shallow       <NA>
## Mean                          <NA>        <NA>        <NA>       <NA>
## Unique (excld. NA)               1           1           3          0
## Missing values                   0           0           0         24
## Sorted                        TRUE        TRUE       FALSE       <NA>
##                                                                      
##                    first.row.int row.plot       first.rows ggplotgroup
## Class                    numeric  numeric           factor     numeric
## Minimum                        5        5  Plots 5 Emis. 5           1
## Maximum                       23        8 Plots 8 Emis. 23           1
## Mean                          14      6.5 Plots 6 Emis. 11           1
## Unique (excld. NA)             4        4                4           1
## Missing values                 0        0                0           0
## Sorted                      TRUE     TRUE             TRUE        TRUE
##