146 Sample ID


The sample ID defines a sample which is foreseen for analysis.

This might be a separate ID for each sample of a single lysimeter (recommended) or an ID for a pooled sample from a group of lysimeters of the same sampler type, depth and layer.

The sample ID must be unique and together with Country, Plotnumber, and Sampler(group)_ID clearly identifies data for the analysis.

Two examples for SSM:

  1. Sample from each Sampler/Sampler group (same Sampler(group)_ID) was analysed separately (each sampler creates an own sample_ID):

    country; plot; sampler_ID; sample_ID; date_start; date_end; period; sample_vol; pH; […]

    04; 4321; 001; 01; 010112; 070112; 1; 120; 6.5; […]

    04; 4321; 001; 02; 070112; 130112; 2; 250; 6.4; […]

    04; 4321; 001; 03; 130112; 190112; 3; 330; 6.8; […]

    […]

    04; 4321; 002; 53; 010112; 070112; 1; 460; 6.2; […]

    04; 4321; 002; 54; 070112; 130112; 2; 440; 6.4; […]

    04; 4321; 002; 55; 130112; 190112; 3; 370; 6.1; […]

  2. Pooled samples from different lysimeters with same attributes (sampled layer, depth and type) were occasionally analysed together due to e.g. too little volume in one period (several samplers contribute to one sample_ID). country; plot; sampler_ID; sample_ID; date_start; date_end; period; sample_vol; pH; […]

    04; 4321; 001; 01; 010112; 070112; 1; 120; 6.5; […] (sampler type 1 pooled, depth -0.4, layer M, period 1)

    04; 4321; 001; 02; 070112; 130112; 2; 100; 6.4; […] (sampler type 1 pooled, depth -0.4, layer M, period 2)

    04; 4321; 001; 03; 130112; 190112; 3; 110; 6.8; […] (sampler type 1 pooled, depth -0.4, layer M, period 3)

    […]

    04; 4321; 002; 53; 010112; 070112; 1; 460; 6.2; […] (sampler type 1 pooled, depth -1.2, layer M, period 1)

    04; 4321; 002; 54; 070112; 130112; 2; 440; 6.4; […] (sampler type 1 pooled, depth -1.2, layer M, period 2)

    04; 4321; 002; 55; 130112; 190112; 3; 370; 6.1; […] (sampler type 1 pooled, depth -1.2, layer M, period 3)

Summing up: sampler_id refers to the instrument, the sample_id refers to the gained sample which is analysed.