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:53:44.430878"

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
INRAE Génermont, Sophie V2 2024 Feb

2. Contributors

contributor institute
Décuq, Céline INRAE
Loubet, Benjamin INRAE
Voylokova, Polina INRAE
Savoie, Antoine INRAE
Houot, Sabine INRAE
Moinard,Victor INRAE

3. File and directory names

## [1] "../../data-submitted/03/INRAE"
## [1] "../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.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

## OK

Missing or double interval number

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

Missing time between intervals

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

Measurement method and units

Measurement technique:

Method Frequency
Inversion Dispersion small plots 121

Measurement technique classification:

Classification Frequency
micro met 121

Emission units and conversion factors.

Original unit Conversion factor applied Final unit
kg N/ha 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 : OK
## man.dm : Some values out of range
## [1]  0.772 34.954
## 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 : Some values out of range
## [1] 6.60 9.96
## app.rate : OK
## crop.z : Some values out of range
## [1]  0 60

Emission

## j.NH3 : OK
## e.int : OK
## e.rel : Some values out of range
## [1] -0.0258311  1.9481058

8. Missing values

Check for missing values.

All variables

## Some values missing:
## Table below has number of missing observations by variable:
##            rep   soil.water.v     soil.moist       crop.res        man.bed 
##            121            121            121             52            121 
##       man.trt2       man.trt3         man.vs        man.tic         man.ua 
##             40            121            121            121            121 
##        man.vfa    time.incorp       man.area       dist.inj       furrow.z 
##            121             91             33            121            121 
##       furrow.w      crop.area            lai     notes.plot          bg.dl 
##            121             91            121             76            121 
##        pH.surf      soil.temp    soil.temp.z soil.temp.surf       air.pres 
##             69            121            121            121            121 
##  air.pres.unit        far.loc       pub.info     soil.type2         exper2 
##            121            121            121            121            121 
##           rep2 
##            121

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

## 
##  21 rows and 205 columns
##  21 unique rows
##                                         pub.id      proj                 exper
## Class                                character character             character
## Minimum            Moinard et al, under review MetaMetha MM1_2017_march_DIGB_1
## Maximum            Moinard et al, under review MetaMetha  MM7_2019_march_LIS_5
## Mean                                      <NA>      <NA>                  <NA>
## Unique (excld. NA)                           1         1                    21
## Missing values                               0         0                     0
## Sorted                                    TRUE      TRUE                  TRUE
##                                                                               
##                                                                                                                                                                                                                                                      cpmid
## Class                                                                                                                                                                                                                                            character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM1_2017_march_DIGB_1.F:SOERE-PRO-NOUZILLY.P:E.T:DIGB_1.R:NA.R2:.T:2017-03-22 10:06:00.M:Inversion Dispersion small plotssee notes
## Maximum              D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM7_2019_march_LIS_5.F:SOERE-PRO-NOUZILLY.P:A.T:LIS_5.R:NA.R2:.T:2019-03-12 13:10:00.M:Inversion Dispersion small plotssee notes
## Mean                                                                                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                                                                                      21
## Missing values                                                                                                                                                                                                                                           0
## Sorted                                                                                                                                                                                                                                                TRUE
##                                                                                                                                                                                                                                                           
##                                 field      plot     rep plot.area     lat
## Class                       character character logical   numeric numeric
## Minimum            SOERE-PRO-NOUZILLY         A    <NA>      1800    47.5
## Maximum            SOERE-PRO-NOUZILLY         E    <NA>      1800    47.5
## Mean                             <NA>      <NA>    <NA>      1800    47.5
## Unique (excld. NA)                  1         3       0         1       1
## Missing values                      0         0      21         0       0
## Sorted                           TRUE     FALSE    <NA>      TRUE    TRUE
##                                                                          
##                       long   country      topo soil.samp.z    clay    silt
## Class              numeric character character   character numeric numeric
## Minimum               0.79        FR      Flat        0-20    15.4    59.2
## Maximum               0.79        FR      Flat        0-20    17.1    70.6
## Mean                  0.79      <NA>      <NA>        <NA>    16.1      64
## Unique (excld. NA)       1         1         1           1       3       3
## Missing values           0         0         0           0       0       0
## Sorted                TRUE      TRUE      TRUE        TRUE   FALSE   FALSE
##                                                                           
##                       sand      oc soil.type soil.water soil.water.v soil.moist
## Class              numeric numeric character    numeric      logical    logical
## Minimum               13.6    1.28      Loam      0.162         <NA>       <NA>
## Maximum               24.7    1.46      Loam       0.26         <NA>       <NA>
## Mean                  19.6    1.36      <NA>        0.2         <NA>       <NA>
## Unique (excld. NA)       3       3         1          3            0          0
## Missing values           0       0         0          0           21         21
## Sorted               FALSE   FALSE      TRUE      FALSE         <NA>       <NA>
##                                                                                
##                    soil.ph soil.dens  crop.res      till man.source
## Class              numeric   numeric character character  character
## Minimum                6.1      1.36        No        No        cat
## Maximum                6.5      1.36       Yes        No        mix
## Mean                  6.33      1.36      <NA>      <NA>       <NA>
## Unique (excld. NA)       3         1         2         1          2
## Missing values           0         0         9         0          0
## Sorted               FALSE      TRUE     FALSE      TRUE      FALSE
##                                                                    
##                       man.source.det man.bed   man.con            man.trt1
## Class                      character logical character           character
## Minimum                        Dairy    <NA>    Liquid Anaerobic digestion
## Maximum            see "experiments"    <NA>     Solid                None
## Mean                            <NA>    <NA>      <NA>                <NA>
## Unique (excld. NA)                 2       0         2                   2
## Missing values                     0      21         0                   0
## Sorted                         FALSE    <NA>     FALSE               FALSE
##                                                                           
##                                 man.trt2 man.trt3 man.stor  man.dm  man.vs
## Class                          character  logical  numeric numeric logical
## Minimum            Mechanical separation     <NA>      182   0.772    <NA>
## Maximum                             None     <NA>      182      35    <NA>
## Mean                                <NA>     <NA>      182    9.84    <NA>
## Unique (excld. NA)                     2        0        1      21       0
## Missing values                         7       21        0       0      21
## Sorted                             FALSE     <NA>     TRUE   FALSE    <NA>
##                                                                           
##                    man.tkn man.tan man.tic  man.ua man.vfa  man.ph
## Class              numeric numeric logical logical logical numeric
## Minimum               0.98   0.579    <NA>    <NA>    <NA>     6.6
## Maximum               8.57    3.87    <NA>    <NA>    <NA>    9.96
## Mean                  4.48    1.88    <NA>    <NA>    <NA>    8.14
## Unique (excld. NA)      21      21       0       0       0      18
## Missing values           0       0      21      21      21       0
## Sorted               FALSE   FALSE    <NA>    <NA>    <NA>   FALSE
##                                                                   
##                              app.start             app.end app.method app.rate
## Class                  POSIXct, POSIXt     POSIXct, POSIXt  character  numeric
## Minimum            2017-03-22 10:06:00 2017-03-22 10:19:00         bc     12.2
## Maximum            2019-03-12 13:10:00 2019-03-12 13:10:00       bsth     60.4
## Mean               2018-03-13 05:26:22 2018-03-13 05:38:22       <NA>       28
## Unique (excld. NA)                  20                  20          2       21
## Missing values                       0                   0          0        0
## Sorted                           FALSE               FALSE      FALSE    FALSE
##                                                                               
##                    app.rate.unit    incorp time.incorp man.area dist.inj
## Class                  character character     numeric  numeric  logical
## Minimum                     t/ha      none          23       25     <NA>
## Maximum                     t/ha   shallow          29      100     <NA>
## Mean                        <NA>      <NA>        24.9       60     <NA>
## Unique (excld. NA)             1         2           5        3        0
## Missing values                 0         0          15        6       21
## Sorted                      TRUE     FALSE       FALSE    FALSE     <NA>
##                                                                         
##                    furrow.z furrow.w      crop  crop.z crop.area     lai
## Class               logical  logical character numeric   numeric logical
## Minimum                <NA>     <NA> bare soil       0         0    <NA>
## Maximum                <NA>     <NA>  rapeseed      60         0    <NA>
## Mean                   <NA>     <NA>      <NA>    16.8         0    <NA>
## Unique (excld. NA)        0        0         3       7         1       0
## Missing values           21       21         0       0        15      21
## Sorted                 <NA>     <NA>     FALSE   FALSE      TRUE    <NA>
##                                                                         
##                                                                            notes.plot
## Class                                                                       character
## Minimum                                                        15 cm of crop residues
## Maximum            Height (cm): 15 cm of crop residues, no plant present in the field
## Mean                                                                             <NA>
## Unique (excld. NA)                                                                  5
## Missing values                                                                     12
## Sorted                                                                          FALSE
##                                                                                      
##                    row.in.file.plot institute sub.period
## Class                       numeric character    numeric
## Minimum                           5     INRAE          3
## Maximum                          25     INRAE          3
## Mean                             15      <NA>          3
## Unique (excld. NA)               21         1          1
## Missing values                    0         0          0
## Sorted                        FALSE      TRUE       TRUE
##                                                         
##                                                                                       file
## Class                                                                            character
## Minimum            ../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx
## Maximum            ../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx
## Mean                                                                                  <NA>
## Unique (excld. NA)                                                                       1
## Missing values                                                                           0
## Sorted                                                                                TRUE
##                                                                                           
##                        treat                        meas.tech meas.tech.det
## Class              character                        character     character
## Minimum               DIGB_1 Inversion Dispersion small plots     see notes
## Maximum                LIS_5 Inversion Dispersion small plots     see notes
## Mean                    <NA>                             <NA>          <NA>
## Unique (excld. NA)        21                                1             1
## Missing values             0                                0             0
## Sorted                 FALSE                             TRUE          TRUE
##                                                                            
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            02-08-2017 10:26 02-08-2017 10:50
## Maximum            22-03-2017 12:03 22-03-2017 12:11
## Mean                           <NA>             <NA>
## Unique (excld. NA)               20               20
## Missing values                    0                0
## Sorted                        FALSE            FALSE
##                                                     
##                                                                                                                                                                                                           cpid
## Class                                                                                                                                                                                                character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM1_2017_march_DIGB_1.F:SOERE-PRO-NOUZILLY.P:E.T:DIGB_1.R:NA.R2:.T:2017-03-22 10:06:00
## Maximum              D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM7_2019_march_LIS_5.F:SOERE-PRO-NOUZILLY.P:A.T:LIS_5.R:NA.R2:.T:2019-03-12 13:10:00
## Mean                                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                                          21
## Missing values                                                                                                                                                                                               0
## Sorted                                                                                                                                                                                                    TRUE
##                                                                                                                                                                                                               
##                                                                ceid flag.plot
## Class                                                     character character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.E:MM1_2017_march_DIGB_1          
## Maximum             D:1.I:INRAE.Pr:MetaMetha.E:MM7_2019_march_LIS_5          
## Mean                                                           <NA>      <NA>
## Unique (excld. NA)                                               21         1
## Missing values                                                    0         0
## Sorted                                                         TRUE      TRUE
##                                                                              
##                            submitter tan.app     e.1     e.4     e.6    e.12
## Class                      character numeric numeric numeric numeric numeric
## Minimum            Génermont, Sophie    9.67    <NA>    2.63    2.94    3.88
## Maximum            Génermont, Sophie    97.7    <NA>    22.2    35.2    53.4
## Mean                            <NA>    49.3    <NA>    11.7    12.2    16.1
## Unique (excld. NA)                 1      21       0       4       9      15
## Missing values                     0       0      21      17      12       6
## Sorted                          TRUE   FALSE    <NA>   FALSE   FALSE   FALSE
##                                                                             
##                       e.24    e.48    e.72    e.96   e.168 e.final   e.tot
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum              0.203   0.207   0.177   0.148  0.0627  -0.607  -0.607
## Maximum               57.8    60.1    60.1      60    37.6    59.8    59.8
## Mean                  14.1    14.8    15.2    15.6      14    16.3    16.3
## Unique (excld. NA)      21      21      21      21       9      21      21
## Missing values           0       0       0       0      12       0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    e.cum.1 e.cum.4 e.cum.6 e.cum.12 e.cum.24 e.cum.48 e.cum.72
## Class              numeric numeric numeric  numeric  numeric  numeric  numeric
## Minimum               <NA>    2.63    2.94     3.88    0.203    0.207    0.177
## Maximum               <NA>    22.2    35.2     53.4     57.8     60.1     60.1
## Mean                  <NA>    11.7    12.2     16.1     14.1     14.8     15.2
## Unique (excld. NA)       0       4       9       15       21       21       21
## Missing values          21      17      12        6        0        0        0
## Sorted                <NA>   FALSE   FALSE    FALSE    FALSE    FALSE    FALSE
##                                                                               
##                    e.cum.96 e.cum.168 e.cum.final e.cum.tot e.rel.1 e.rel.4
## Class               numeric   numeric     numeric   numeric numeric numeric
## Minimum               0.148    0.0627      -0.607    -0.607    <NA>  0.0559
## Maximum                  60      37.6        59.8      59.8    <NA>   0.358
## Mean                   15.6        14        16.3      16.3    <NA>    0.22
## Unique (excld. NA)       21         9          21        21       0       4
## Missing values            0        12           0         0      21      17
## Sorted                FALSE     FALSE       FALSE     FALSE    <NA>   FALSE
##                                                                            
##                    e.rel.6 e.rel.12 e.rel.24 e.rel.48 e.rel.72 e.rel.96
## Class              numeric  numeric  numeric  numeric  numeric  numeric
## Minimum             0.0625   0.0823  0.00866   0.0088  0.00754  0.00629
## Maximum               1.76     1.81     1.91     1.44     1.37     1.35
## Mean                  0.37    0.448    0.365    0.358    0.364    0.368
## Unique (excld. NA)       9       15       21       21       21       21
## Missing values          12        6        0        0        0        0
## Sorted               FALSE    FALSE    FALSE    FALSE    FALSE    FALSE
##                                                                        
##                    e.rel.168 e.rel.final e.rel.tot  rain.1  rain.4  rain.6
## Class                numeric     numeric   numeric numeric numeric numeric
## Minimum              0.00267     -0.0258   -0.0258    <NA>       0       0
## Maximum                0.593        1.32      1.32    <NA>       0    0.46
## Mean                     0.2       0.376     0.376    <NA>       0  0.0511
## Unique (excld. NA)         9          21        21       0       1       2
## Missing values            12           0         0      21      17      12
## Sorted                 FALSE       FALSE     FALSE    <NA>    TRUE    TRUE
##                                                                           
##                    rain.12 rain.24 rain.48 rain.72 rain.96 rain.168 rain.final
## Class              numeric numeric numeric numeric numeric  numeric    numeric
## Minimum                  0       0       0       0       0    0.842        0.4
## Maximum               2.16    13.9    15.2    15.5    19.9     24.2        113
## Mean                  0.36     2.7    5.42    6.44    8.34     13.6       31.4
## Unique (excld. NA)       3       4       8      12      12        7          7
## Missing values           6       0       0       0       0       12          0
## Sorted                TRUE   FALSE   FALSE   FALSE   FALSE    FALSE      FALSE
##                                                                               
##                    rain.tot air.temp.1 air.temp.4 air.temp.6 air.temp.12
## Class               numeric    numeric    numeric    numeric     numeric
## Minimum                 0.4       <NA>       9.38       9.38        10.5
## Maximum                 113       <NA>       29.2       29.2        29.2
## Mean                   31.4       <NA>       15.4         15        17.2
## Unique (excld. NA)        7          0          4          8          11
## Missing values            0         21         17         12           6
## Sorted                FALSE       <NA>      FALSE      FALSE       FALSE
##                                                                         
##                    air.temp.24 air.temp.48 air.temp.72 air.temp.96 air.temp.168
## Class                  numeric     numeric     numeric     numeric      numeric
## Minimum                   1.61        1.94        3.76        3.76         6.88
## Maximum                   29.2        22.7        21.6        21.6         19.7
## Mean                      11.2        9.92        9.87        9.87         11.1
## Unique (excld. NA)          16          16          16          16           16
## Missing values               0           0           0           0            0
## Sorted                   FALSE       FALSE       FALSE       FALSE        FALSE
##                                                                                
##                    air.temp.mn  wind.1  wind.4  wind.6 wind.12 wind.24 wind.48
## Class                  numeric numeric numeric numeric numeric numeric numeric
## Minimum                   8.27    <NA>    1.04    1.04    1.23   0.817   0.893
## Maximum                   49.6    <NA>    3.94    5.71    5.71    3.94     3.4
## Mean                      23.7    <NA>     2.3    2.87    3.27    2.09    1.83
## Unique (excld. NA)          16       0       4       8      11      15      16
## Missing values               0      21      17      12       6       0       0
## Sorted                   FALSE    <NA>   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                               
##                    wind.72 wind.96 wind.168 wind.mn wind.2m.1 wind.2m.4
## Class              numeric numeric  numeric numeric   numeric   numeric
## Minimum              0.985   0.985     1.28    1.28      <NA>      1.13
## Maximum               3.73    3.73     3.58     6.5      <NA>      4.29
## Mean                   1.9     1.9     1.93    3.84      <NA>      2.53
## Unique (excld. NA)      16      16       16      16         0         4
## Missing values           0       0        0       0        21        17
## Sorted               FALSE   FALSE    FALSE   FALSE      <NA>     FALSE
##                                                                        
##                    wind.2m.6 wind.2m.12 wind.2m.24 wind.2m.48 wind.2m.72
## Class                numeric    numeric    numeric    numeric    numeric
## Minimum                 1.13       1.33       0.89      0.972       1.07
## Maximum                 6.28       6.28       4.29       3.74       4.11
## Mean                    3.16       3.58        2.3       2.01       2.09
## Unique (excld. NA)         8         12         16         17         17
## Missing values            12          6          0          0          0
## Sorted                 FALSE      FALSE      FALSE      FALSE      FALSE
##                                                                         
##                    wind.2m.96 wind.2m.168 wind.2m.mn   rad.1   rad.4   rad.6
## Class                 numeric     numeric    numeric numeric numeric numeric
## Minimum                  1.07         1.4        1.4    <NA>      82      82
## Maximum                  4.11        3.94       7.41    <NA>     733     743
## Mean                     2.09        2.13       4.26    <NA>     461     488
## Unique (excld. NA)         17          17         17       0       4       9
## Missing values              0           0          0      21      17      12
## Sorted                  FALSE       FALSE      FALSE    <NA>   FALSE   FALSE
##                                                                             
##                     rad.12  rad.24  rad.48  rad.72  rad.96 rad.168  rad.mn
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum                 82    21.2    48.9    48.9    48.9    91.7    91.7
## Maximum                743     743     335     262     262     269     845
## Mean                   441     263     146     134     134     150     360
## Unique (excld. NA)      12      16      16      16      16      16      16
## Missing values           6       0       0       0       0       0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    rain.rate.1 rain.rate.4 rain.rate.6 rain.rate.12
## Class                  numeric     numeric     numeric      numeric
## Minimum                   <NA>           0           0            0
## Maximum                   <NA>           0      0.0393       0.0393
## Mean                      <NA>           0     0.00437      0.00643
## Unique (excld. NA)           0           1           2            3
## Missing values              21          17          12            6
## Sorted                    <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.6        0.334        0.334        0.334
## Mean                      0.116        0.117       0.0956       0.0956
## Unique (excld. NA)            4            8            8            8
## Missing values                0            0            0            0
## Sorted                    FALSE        FALSE        FALSE        FALSE
##                                                                       
##                    rain.rate.168 rain.rate.mn    rh.1    rh.4    rh.6   rh.12
## Class                    numeric      numeric numeric numeric numeric numeric
## Minimum                        0      0.00279    <NA>    41.3    41.3    41.3
## Maximum                    0.203        0.778    <NA>    91.3    91.3    84.9
## Mean                       0.085        0.221    <NA>    64.8    61.4      60
## Unique (excld. NA)            14           16       0       4       9      12
## Missing values                 0            0      21      17      12       6
## Sorted                     FALSE        FALSE    <NA>   FALSE   FALSE   FALSE
##                                                                              
##                      rh.24   rh.48   rh.72   rh.96  rh.168   rh.mn
## Class              numeric numeric numeric numeric numeric numeric
## Minimum               41.3    57.2    57.2    57.2    62.2      67
## Maximum               98.3    97.9    97.9    97.9    87.7     354
## Mean                  76.2    80.3    80.4    80.4    79.1     175
## Unique (excld. NA)      16      16      16      16      16      16
## Missing values           0       0       0       0       0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                   
##                    first.row.in.file.int last.row.in.file.int  n.ints     dt1
## Class                            numeric              numeric integer numeric
## Minimum                                5                   10       4     2.5
## Maximum                              120                  125       7      23
## Mean                                62.3                 67.1    5.76    9.98
## Unique (excld. NA)                    21                   21       4      16
## Missing values                         0                    0       0       0
## Sorted                             FALSE                FALSE   FALSE   FALSE
##                                                                              
##                      j.rel1  j.NH31  dt.min  dt.max  ct.min  ct.max
## Class               numeric numeric numeric numeric numeric numeric
## Minimum            0.000376 0.00883     2.5      48     2.5     118
## Maximum               0.293    7.64    22.5     192      23     650
## Mean                 0.0544    2.06     9.9     121    9.98     312
## Unique (excld. NA)       21      21      16       7      16      15
## Missing values            0       0       0       0       0       0
## Sorted                FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                    
##                              t.start.p             t.end.p air.temp.z
## Class                  POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum            2017-03-22 11:30:00 2017-04-11 09:30:00          2
## Maximum            2019-03-12 13:10:00 2019-03-15 10:15:00          2
## Mean               2018-03-13 05:37:08 2018-03-21 07:25:42          2
## Unique (excld. NA)                  16                   7          1
## Missing values                       0                   0          0
## Sorted                           FALSE                TRUE       TRUE
##                                                                      
##                    soil.temp.z  wind.z  wind.loc far.loc  pub.info soil.type2
## Class                  logical numeric character logical character    logical
## Minimum                   <NA>     1.3     Field    <NA>      <NA>       <NA>
## Maximum                   <NA>     1.3     Field    <NA>      <NA>       <NA>
## Mean                      <NA>     1.3      <NA>    <NA>      <NA>       <NA>
## Unique (excld. NA)           0       1         1       0         0          0
## Missing values              21       0         0      21        21         21
## Sorted                    <NA>    TRUE      TRUE    <NA>      <NA>       <NA>
##                                                                              
##                     exper2    rep2    acid                   meas.tech.orig
## Class              logical logical logical                        character
## Minimum               <NA>    <NA>   FALSE Inversion Dispersion small plots
## Maximum               <NA>    <NA>   FALSE Inversion Dispersion small plots
## Mean                  <NA>    <NA>  0 TRUE                             <NA>
## Unique (excld. NA)       0       0       1                                1
## Missing values          21      21       0                                0
## Sorted                <NA>    <NA>    TRUE                             TRUE
##                                                                            
##                    meas.tech2 crop.orig man.source.orig
## Class               character character       character
## Minimum             micro met Bare soil          Cattle
## Maximum             micro met  Rapeseed             Mix
## Mean                     <NA>      <NA>            <NA>
## Unique (excld. NA)          1         3               2
## Missing values              0         0               0
## Sorted                   TRUE     FALSE           FALSE
##                                                        
##                                 app.method.orig app.method2 incorp.orig
## Class                                 character   character   character
## Minimum            Band spread or trailing hose          bc        None
## Maximum                               Broadcast        bsth     Shallow
## Mean                                       <NA>        <NA>        <NA>
## Unique (excld. NA)                            2           2           2
## Missing values                                0           0           0
## Sorted                                    FALSE       FALSE       FALSE
##                                                                        
##                    date.start
## Class                    Date
## Minimum            2017-03-22
## Maximum            2019-03-12
## Mean                     <NA>
## Unique (excld. NA)          7
## Missing values              0
## Sorted                   TRUE
## 

Interval-level emission data

## 
##  121 rows and 138 columns
##  121 unique rows
##                                                                                                                                                                                                                                                      cpmid
## Class                                                                                                                                                                                                                                            character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM1_2017_march_DIGB_1.F:SOERE-PRO-NOUZILLY.P:E.T:DIGB_1.R:NA.R2:.T:2017-03-22 10:06:00.M:Inversion Dispersion small plotssee notes
## Maximum              D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM7_2019_march_LIS_5.F:SOERE-PRO-NOUZILLY.P:A.T:LIS_5.R:NA.R2:.T:2019-03-12 13:10:00.M:Inversion Dispersion small plotssee notes
## Mean                                                                                                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                                                                                                      21
## Missing values                                                                                                                                                                                                                                           0
## Sorted                                                                                                                                                                                                                                                TRUE
##                                                                                                                                                                                                                                                           
##                                         pub.id      proj                 exper
## Class                                character character             character
## Minimum            Moinard et al, under review MetaMetha MM1_2017_march_DIGB_1
## Maximum            Moinard et al, under review MetaMetha  MM7_2019_march_LIS_5
## Mean                                      <NA>      <NA>                  <NA>
## Unique (excld. NA)                           1         1                    21
## Missing values                               0         0                     0
## Sorted                                    TRUE      TRUE                  TRUE
##                                                                               
##                                 field      plot     rep     treat
## Class                       character character logical character
## Minimum            SOERE-PRO-NOUZILLY         A    <NA>    DIGB_1
## Maximum            SOERE-PRO-NOUZILLY         E    <NA>     LIS_5
## Mean                             <NA>      <NA>    <NA>      <NA>
## Unique (excld. NA)                  1         3       0        21
## Missing values                      0         0     121         0
## Sorted                           TRUE     FALSE    <NA>     FALSE
##                                                                  
##                                           meas.tech meas.tech.det plot.area
## Class                                     character     character   numeric
## Minimum            Inversion Dispersion small plots     see notes      1800
## Maximum            Inversion Dispersion small plots     see notes      1800
## Mean                                           <NA>          <NA>      1800
## Unique (excld. NA)                                1             1         1
## Missing values                                    0             0         0
## Sorted                                         TRUE          TRUE      TRUE
##                                                                            
##                        lat    long   country      topo soil.samp.z    clay
## Class              numeric numeric character character   character numeric
## Minimum               47.5    0.79        FR      Flat        0-20    15.4
## Maximum               47.5    0.79        FR      Flat        0-20    17.1
## Mean                  47.5    0.79      <NA>      <NA>        <NA>    16.1
## Unique (excld. NA)       1       1         1         1           1       3
## Missing values           0       0         0         0           0       0
## Sorted                TRUE    TRUE      TRUE      TRUE        TRUE   FALSE
##                                                                           
##                       silt    sand      oc soil.type soil.water soil.water.v
## Class              numeric numeric numeric character    numeric      logical
## Minimum               59.2    13.6    1.28      Loam      0.162         <NA>
## Maximum               70.6    24.7    1.46      Loam       0.26         <NA>
## Mean                    64    19.6    1.36      <NA>        0.2         <NA>
## Unique (excld. NA)       3       3       3         1          3            0
## Missing values           0       0       0         0          0          121
## Sorted               FALSE   FALSE   FALSE      TRUE      FALSE         <NA>
##                                                                             
##                    soil.moist soil.ph soil.dens  crop.res      till man.source
## Class                 logical numeric   numeric character character  character
## Minimum                  <NA>     6.1      1.36        No        No        cat
## Maximum                  <NA>     6.5      1.36       Yes        No        mix
## Mean                     <NA>    6.33      1.36      <NA>      <NA>       <NA>
## Unique (excld. NA)          0       3         1         2         1          2
## Missing values            121       0         0        52         0          0
## Sorted                   <NA>   FALSE      TRUE     FALSE      TRUE      FALSE
##                                                                               
##                       man.source.det man.bed   man.con            man.trt1
## Class                      character logical character           character
## Minimum                        Dairy    <NA>    Liquid Anaerobic digestion
## Maximum            see "experiments"    <NA>     Solid                None
## Mean                            <NA>    <NA>      <NA>                <NA>
## Unique (excld. NA)                 2       0         2                   2
## Missing values                     0     121         0                   0
## Sorted                         FALSE    <NA>     FALSE               FALSE
##                                                                           
##                                 man.trt2 man.trt3 man.stor  man.dm  man.vs
## Class                          character  logical  numeric numeric logical
## Minimum            Mechanical separation     <NA>      182   0.772    <NA>
## Maximum                             None     <NA>      182      35    <NA>
## Mean                                <NA>     <NA>      182    9.03    <NA>
## Unique (excld. NA)                     2        0        1      21       0
## Missing values                        40      121        0       0     121
## Sorted                             FALSE     <NA>     TRUE   FALSE    <NA>
##                                                                           
##                    man.tkn man.tan man.tic  man.ua man.vfa  man.ph
## Class              numeric numeric logical logical logical numeric
## Minimum               0.98   0.579    <NA>    <NA>    <NA>     6.6
## Maximum               8.57    3.87    <NA>    <NA>    <NA>    9.96
## Mean                  4.35    1.89    <NA>    <NA>    <NA>    8.09
## Unique (excld. NA)      21      21       0       0       0      18
## Missing values           0       0     121     121     121       0
## Sorted               FALSE   FALSE    <NA>    <NA>    <NA>   FALSE
##                                                                   
##                              app.start             app.end app.method app.rate
## Class                  POSIXct, POSIXt     POSIXct, POSIXt  character  numeric
## Minimum            2017-03-22 10:06:00 2017-03-22 10:19:00         bc     12.2
## Maximum            2019-03-12 13:10:00 2019-03-12 13:10:00       bsth     60.4
## Mean               2018-03-18 18:35:40 2018-03-18 18:45:49       <NA>     27.9
## Unique (excld. NA)                  20                  20          2       21
## Missing values                       0                   0          0        0
## Sorted                           FALSE               FALSE      FALSE    FALSE
##                                                                               
##                    app.rate.unit    incorp time.incorp man.area dist.inj
## Class                  character character     numeric  numeric  logical
## Minimum                     t/ha      none          23       25     <NA>
## Maximum                     t/ha   shallow          29      100     <NA>
## Mean                        <NA>      <NA>        24.6     60.8     <NA>
## Unique (excld. NA)             1         2           5        3        0
## Missing values                 0         0          91       33      121
## Sorted                      TRUE     FALSE       FALSE    FALSE     <NA>
##                                                                         
##                    furrow.z furrow.w      crop  crop.z crop.area     lai
## Class               logical  logical character numeric   numeric logical
## Minimum                <NA>     <NA> bare soil       0         0    <NA>
## Maximum                <NA>     <NA>  rapeseed      60         0    <NA>
## Mean                   <NA>     <NA>      <NA>    16.9         0    <NA>
## Unique (excld. NA)        0        0         3       7         1       0
## Missing values          121      121         0       0        91     121
## Sorted                 <NA>     <NA>     FALSE   FALSE      TRUE    <NA>
##                                                                         
##                                                                            notes.plot
## Class                                                                       character
## Minimum                                                        15 cm of crop residues
## Maximum            Height (cm): 15 cm of crop residues, no plant present in the field
## Mean                                                                             <NA>
## Unique (excld. NA)                                                                  5
## Missing values                                                                     76
## Sorted                                                                          FALSE
##                                                                                      
##                    row.in.file.plot institute sub.period
## Class                       numeric character    numeric
## Minimum                           5     INRAE          3
## Maximum                          25     INRAE          3
## Mean                             15      <NA>          3
## Unique (excld. NA)               21         1          1
## Missing values                    0         0          0
## Sorted                        FALSE      TRUE       TRUE
##                                                         
##                                                                                       file
## Class                                                                            character
## Minimum            ../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx
## Maximum            ../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx
## Mean                                                                                  <NA>
## Unique (excld. NA)                                                                       1
## Missing values                                                                           0
## Sorted                                                                                TRUE
##                                                                                           
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            02-08-2017 10:26 02-08-2017 10:50
## Maximum            22-03-2017 12:03 22-03-2017 12:11
## Mean                           <NA>             <NA>
## Unique (excld. NA)               20               20
## Missing values                    0                0
## Sorted                        FALSE            FALSE
##                                                     
##                                                                                                                                                                                                           cpid
## Class                                                                                                                                                                                                character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM1_2017_march_DIGB_1.F:SOERE-PRO-NOUZILLY.P:E.T:DIGB_1.R:NA.R2:.T:2017-03-22 10:06:00
## Maximum              D:1.I:INRAE.Pr:MetaMetha.F:../../data-submitted/03/INRAE/ALFAM2_template_8.0_META_METHA_Vf_v4.xlsx.E:MM7_2019_march_LIS_5.F:SOERE-PRO-NOUZILLY.P:A.T:LIS_5.R:NA.R2:.T:2019-03-12 13:10:00
## Mean                                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                                          21
## Missing values                                                                                                                                                                                               0
## Sorted                                                                                                                                                                                                    TRUE
##                                                                                                                                                                                                               
##                                                                ceid flag.plot
## Class                                                     character character
## Minimum            D:1.I:INRAE.Pr:MetaMetha.E:MM1_2017_march_DIGB_1          
## Maximum             D:1.I:INRAE.Pr:MetaMetha.E:MM7_2019_march_LIS_5          
## Mean                                                           <NA>      <NA>
## Unique (excld. NA)                                               21         1
## Missing values                                                    0         0
## Sorted                                                         TRUE      TRUE
##                                                                              
##                            submitter tan.app interval             t.start
## Class                      character numeric  numeric     POSIXct, POSIXt
## Minimum            Génermont, Sophie    9.67        1 2017-03-22 11:30:00
## Maximum            Génermont, Sophie    97.7        7 2019-03-15 10:15:00
## Mean                            <NA>    49.4     3.45 2018-03-21 16:22:18
## Unique (excld. NA)                 1      21        7                  54
## Missing values                     0       0        0                   0
## Sorted                          TRUE   FALSE    FALSE               FALSE
##                                                                          
##                                  t.end      dt   bg.dl  bg.val   bg.unit
## Class                  POSIXct, POSIXt numeric logical numeric character
## Minimum            2017-03-23 10:30:00     2.5    <NA>    1.56     µg/m3
## Maximum            2019-03-18 09:45:00     192    <NA>      72     µg/m3
## Mean               2018-03-23 22:30:00    54.1    <NA>    7.96      <NA>
## Unique (excld. NA)                  45      47       0      40         1
## Missing values                       0       0     121       0         0
## Sorted                           FALSE   FALSE    <NA>   FALSE      TRUE
##                                                                         
##                                 j.type   j.NH3 j.NH3.unit pH.surf air.temp
## Class                        character numeric  character numeric  numeric
## Minimum            cumulative emission  -0.539 kg N/ha-hr   0.104     1.61
## Maximum            cumulative emission    7.64 kg N/ha-hr    8.02     29.2
## Mean                              <NA>   0.393       <NA>    3.14     11.2
## Unique (excld. NA)                   1     121          1      23       47
## Missing values                       0       0          0      69        0
## Sorted                            TRUE   FALSE       TRUE   FALSE    FALSE
##                                                                           
##                    air.temp.z soil.temp soil.temp.z soil.temp.surf     rad
## Class                 numeric   numeric     logical        logical numeric
## Minimum                     2      <NA>        <NA>           <NA>    3.69
## Maximum                     2      <NA>        <NA>           <NA>     743
## Mean                        2      <NA>        <NA>           <NA>     181
## Unique (excld. NA)          1         0           0              0      51
## Missing values              0       121         121            121       0
## Sorted                   TRUE      <NA>        <NA>           <NA>   FALSE
##                                                                           
##                       wind  wind.z     MOL   ustar      rl air.pres
## Class              numeric numeric numeric numeric numeric  logical
## Minimum              0.356     1.3    -405  0.0463   0.025     <NA>
## Maximum               5.71     1.3     495   0.458   0.717     <NA>
## Mean                  2.02     1.3    4.39   0.207   0.207     <NA>
## Unique (excld. NA)      48       1      50      49      10        0
## Missing values           0       0       0       0       0      121
## Sorted               FALSE    TRUE   FALSE   FALSE   FALSE     <NA>
##                                                                    
##                    air.pres.unit    rain      rh  wind.loc far.loc
## Class                    logical numeric numeric character logical
## Minimum                     <NA>       0    41.3     Field    <NA>
## Maximum                     <NA>    57.6    99.9     Field    <NA>
## Mean                        <NA>    5.44    78.7      <NA>    <NA>
## Unique (excld. NA)             0      19      51         1       0
## Missing values               121       0       0         0     121
## Sorted                      <NA>   FALSE   FALSE      TRUE    <NA>
##                                                                   
##                                                                                                                                                                  notes.int
## Class                                                                                                                                                            character
## Minimum            Inversion with FIDES, 2 or 3 concentration measurement heights with 2 or 3 passive badges per measurement height, 3 places of measurement per treatment
## Maximum            Inversion with FIDES, 2 or 3 concentration measurement heights with 2 or 3 passive badges per measurement height, 3 places of measurement per treatment
## Mean                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                       1
## Missing values                                                                                                                                                           0
## Sorted                                                                                                                                                                TRUE
##                                                                                                                                                                           
##                    row.in.file.int        t.start.orig          t.end.orig
## Class                      numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum                          5 2017-03-22 11:30:00 2017-03-22 11:30:00
## Maximum                        125 2019-03-15 10:15:00 2019-03-15 10:15:00
## Mean                            65 2018-03-21 16:22:18 2018-03-21 16:22:18
## Unique (excld. NA)             121                  54                  54
## Missing values                   0                   0                   0
## Sorted                       FALSE               FALSE               FALSE
##                                                                           
##                    j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact dt.calc dt.diff
## Class                    character    numeric         numeric numeric numeric
## Minimum                    kg N/ha     -0.607               1     2.5       0
## Maximum                    kg N/ha       60.2               1     192       0
## Mean                          <NA>       14.3               1    54.1       0
## Unique (excld. NA)               1        121               1      47       1
## Missing values                   0          0               0       0       0
## Sorted                        TRUE      FALSE            TRUE   FALSE    TRUE
##                                                                              
##                         ct      mt     cta     bta  flag.int rain.rate rain.cum
## Class              numeric numeric numeric numeric character   numeric  numeric
## Minimum                2.5    1.25       3   -1.58                   0        0
## Maximum                650     564     652     479               0.935      113
## Mean                   124    96.7     124    69.8      <NA>    0.0903     11.2
## Unique (excld. NA)      87      89     115     109         1        23       22
## Missing values           0       0       0       0         0         0        0
## Sorted               FALSE   FALSE   FALSE   FALSE      TRUE     FALSE    FALSE
##                                                                                
##                    wind.2m   e.int   e.cum       e   e.rel   j.rel  pub.info
## Class              numeric numeric numeric numeric numeric numeric character
## Minimum              0.388   -11.3  -0.607  -0.607 -0.0258 -0.0269      <NA>
## Maximum               6.28    51.5    60.2    60.2    1.95   0.293      <NA>
## Mean                  2.23    2.83    14.3    14.3    0.34    0.01      <NA>
## Unique (excld. NA)      60     121     121     121     121     121         0
## Missing values           0       0       0       0       0       0       121
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE      <NA>
##                                                                             
##                    soil.type2  exper2    rep2    acid
## Class                 logical logical logical logical
## Minimum                  <NA>    <NA>    <NA>   FALSE
## Maximum                  <NA>    <NA>    <NA>   FALSE
## Mean                     <NA>    <NA>    <NA>  0 TRUE
## Unique (excld. NA)          0       0       0       1
## Missing values            121     121     121       0
## Sorted                   <NA>    <NA>    <NA>    TRUE
##                                                      
##                                      meas.tech.orig meas.tech2 crop.orig
## Class                                     character  character character
## Minimum            Inversion Dispersion small plots  micro met Bare soil
## Maximum            Inversion Dispersion small plots  micro met  Rapeseed
## Mean                                           <NA>       <NA>      <NA>
## Unique (excld. NA)                                1          1         3
## Missing values                                    0          0         0
## Sorted                                         TRUE       TRUE     FALSE
##                                                                         
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                     Cattle Band spread or trailing hose          bc
## Maximum                        Mix                    Broadcast        bsth
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               2                            2           2
## Missing values                   0                            0           0
## Sorted                       FALSE                        FALSE       FALSE
##                                                                            
##                    incorp.orig date.start first.row.int row.plot
## Class                character       Date       numeric  numeric
## Minimum                   None 2017-03-22             5        5
## Maximum                Shallow 2017-03-22           120       25
## Mean                      <NA>       <NA>          62.5       15
## Unique (excld. NA)           2          1            21       21
## Missing values               0          0             0        0
## Sorted                   FALSE       TRUE         FALSE    FALSE
##                                                                 
##                           first.rows ggplotgroup
## Class                         factor      factor
## Minimum            Plots 10 Emis. 89   (4.98,10]
## Maximum             Plots 9 Emis. 71     (20,25]
## Mean               Plots 20 Emis. 37     (10,15]
## Unique (excld. NA)                21           4
## Missing values                     0           0
## Sorted                         FALSE       FALSE
##