DP - Sampling and Analysis of Deposition

Form: DEM - Contents of datafile with deposition measurements (mandatory)

Form introduced: 2002

Last change: 2011

Tests

Changes

!Sequence; plot; date_start; date_end; period; sampler; sampler_id; sample_id; V_sampling; quantity; pH; conductivity; K; Ca; Mg; Na; N_NH4; Cl; N_NO3; S_SO4; alkalinity; N_total; DOC; Al; Mn; Fe; P_PO4; Cu; Zn; Hg; Pb; Co; Mo; Ni; Cd; S_total; C_total; p_total; cr; n_no2; hco3; don; other_observations

POSITION FIELD DESCRIPTION
1 Sequence

Description: Continuous number to identify the line of the submitted file
Format: I
2 plot
M K

DB Column: code_plot
Description: Observation plot number
Remarks: A unique number (per country) given to the permanent plot during the selection or installation
Format: I
3 date_start (DDMMYY)
K

Description: Start date
Remarks: Mandatory since 2007
Format: Date
Introduced: 2007
4 date_end (DDMMYY)

Description: End date
Remarks: Mandatory since 2007
Format: Date
Introduced: 2007
5 period
M K

DB Column: period_number
Description: Period number
Format: I
Explanatory Item: 144
6 sampler
M K

DB Column: code_sampler
Description: Coded sampler type
Format: I
Dictionary: d_sampler_deposition
Explanatory Item: 400
7 sampler_id
M K

Description: Sampler ID
Format: I
Explanatory Item: 160
Introduced: 2011
8 sample_id
M K

Format: I
Explanatory Item: 161
Introduced: 2011
9 V_sampling
M

DB Column: code_vsampling
Description: Description of sample / sampling
Format: I
Dictionary: d_sampling_deposition
Introduced: 2011
10 quantity (mm)

Description: Quantity of the total collected sample
Format: F
Explanatory Item: 167
Introduced: 2011
11 pH

Format: F
12 conductivity (µS/cm)

Format: F
13 K (mg/l)

Format: F
14 Ca (mg/l)

Format: F
15 Mg (mg/l)

Format: F
16 Na (mg/l)

Format: F
17 N_NH4 (mg N/l)

Description: N-NH4
Format: F
18 Cl (mg/l)

Format: F
19 N_NO3 (mg N/l)

Description: N-NO3
Format: F
20 S_SO4 (mg S/l)

Description: S-SO4
Format: F
21 alkalinity (µeq/l)

Remarks: Mandatory for individual samples if pH > 5
Format: F
22 N_total (mg N/l)

Description: Total Nitrogen
Format: F
23 DOC (mg/l)

Description: Dissolved organic carbon (DOC)
Format: F
Introduced: 2007
24 Al (mg/l)

Remarks: Mandatory if pH<5
Format: F
Introduced: 2011
25 Mn (mg/l)

Format: F
26 Fe (mg/l)

Format: F
27 P_PO4 (mg/l)

Description: P-PO43-
Format: F
Introduced: 2011
28 Cu (μg/l)

Format: F
29 Zn (μg/l)

Format: F
Introduced: 2011
30 Hg (µg/l)

Description: Hg
Format: F
Introduced: 2011
31 Pb (μg/l)

Format: F
Introduced: 2011
32 Co (µg/l)

Format: F
Introduced: 2011
33 Mo (µg/l)

Format: F
Introduced: 2011
34 Ni (µg/l)

Format: F
35 Cd (µg/L)

Format: F
Introduced: 2007
36 S_total (mg/l)

Description: Stotal
Format: F
37 C_total (mg/l)

Description: Ctotal
Format: F
Introduced: 2011
38 p_total (mg/L)

Description: Total phosphorus
Format: F
Introduced: 2011
39 cr (µg/L)

Description: Chromium
Format: F
Introduced: 2011
40 n_no2 (mg/L)

Description: Nitrite - nitrogen
Format: F
Introduced: 2011
41 hco3 (mg/L)

Description: Bicarbonate
Format: F
Introduced: 2011
42 don (mg/L)

Description: Dissolved organic nitrogen
Remarks: Directly measured NOT calculated
Format: F
Introduced: 2011
43 other_observations

DB Column: other_obs
Description: Observation text
Format: C