TRD

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
216 ((affected_part IN (4, 9)) OR (affected_part IS NULL)) WHERE (defol_t-1 = 100) e
4101 (defol = 100) WHERE ((defol_t-1 < 100) AND (defol_t-1 <> -1) AND (affect_part = 4)) e
RULE_ID MSG MSG_CODE
216 affected_part VALUE does not match with defoliation 100 from previous year TT_NOT_MATCH_DEFOL
4101 A dead tree has to be reported with defoliation 100 in the first year TT_DEFOL_DEAD_TREE

multiple tests

RULE_ID TEST ERROR
20 (defol = 100) AND NOT (affected_part = 4) w
24 ((symptom IS NULL) OR (symptom = -9)) AND NOT (affected_part IN (0,4,9)) e
26 ((symptom IS NOT NULL) AND (symptom <> -9 AND symptom <> 99 )) AND NOT (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,28,30,31,32,33,34)) e
28 (affected_part >=10) AND NOT ((symptom IS NOT NULL) AND (symptom <> -9)) e
38 (affected_part IN (11,12,13,14)) AND NOT (((symptom BETWEEN 1 AND 12) OR (symptom = 99))) e
40 (affected_part IN (21,22,23,24,25,26,27)) AND NOT (symptom IN (1,8,9,10,11,12,13,14,15,16,17,18,19,20)) e
42 (affected_part BETWEEN 30 AND 34) AND NOT (symptom IN (8,9,10,11,12,13,14,16,17,18,19,20,21,22)) e
44 (affected_part IN (0,4,9)) AND NOT ((symptom IS NULL) OR (symptom = -9 OR symptom = 99)) e
46 (symptom_spec BETWEEN 31 AND 36) AND NOT ((symptom=1) AND (affected_part IN (4,11,12,13,14))) e
48 (symptom_spec BETWEEN 37 AND 44) AND NOT ((symptom IN (2,3,4,5)) AND (affected_part IN (4,11,12,13,14))) e
50 (symptom_spec BETWEEN 45 AND 49) AND NOT ((symptom=8) AND (affected_part IN (4,11,12,13,14))) e
52 (symptom_spec IN (50,51)) AND NOT ((symptom=8) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27))) e
54 (symptom_spec=52) AND NOT ((symptom=8) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,31,32,33,34))) e
56 (symptom_spec=53) AND NOT ((symptom IN (10,11)) AND (affected_part IN (4,11,12,13,14))) e
58 (symptom_spec=54) AND NOT ((symptom=10) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27))) e
60 (symptom_spec=55) AND NOT ((symptom=10) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,31,32,33,34))) e
62 (symptom_spec=56) AND NOT ((symptom=11) AND (affected_part IN (4,11,12,13,14))) e
64 (symptom_spec=57) AND NOT ((symptom=11) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,31,32,33,34))) e
66 (symptom_spec IN (58,59,60)) AND NOT ((symptom=17) AND (affected_part IN (4,21,22,23,24,25,26,27,31,32,33,34))) e
68 (symptom_spec IN (61,64)) AND NOT ((symptom=8) AND (affected_part IN (4,21,22,23,24,25,26,27))) e
70 (symptom_spec IN (62,63)) AND NOT ((symptom=8) AND (affected_part IN (4,21,22,23,24,25,26,27,31,32,33,34))) e
72 (symptom_spec IN (65,66)) AND NOT ((symptom=10) AND (affected_part IN (4,21,22,23,24,25,26,27,31,32,33,34))) e
74 (symptom_spec IN (67)) AND NOT ((symptom=11) AND (affected_part IN (4,31,32,33,34))) e
76 (extent IN (0,1,2,3,4,5,6,7)) AND NOT (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,28,30,31,32,33,34)) e
445 (crown_loc IN (1,2,3,4)) AND NOT (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,28,31,32,33,34)) e
605 (defol = 100) AND NOT (affected_part = 4) w
650 EXIST(tree) e
2003 ((removal_mortality BETWEEN 11 AND 19)) AND NOT (cause <> 541) w
2005 ((removal_mortality BETWEEN 11 AND 19)) AND NOT (affected_part = 4) e
RULE_ID MSG
20 specified affected_part VALUE does not match with specified defol VALUE
24 specified affected_part VALUE does not match with not specified value for symptom (NULL value)
26 specified affected_part VALUE does not match with specified symptom VALUE
28 symptom not specified although affected_part is specified with VALUE
38 specified symptom VALUE does not match with specified affected_part VALUE
40 specified symptom VALUE does not match with specified affected_part VALUE
42 specified symptom VALUE does not match with specified affected_part VALUE
44 Value VALUE of symptom was specified (not NULL) although affected_part was specified with VALUE and no value was expected
46 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
48 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
50 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
52 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
54 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
56 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
58 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
60 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
62 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
64 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
66 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
68 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
70 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
72 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
74 specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE
76 specified affected_part VALUE does not match with specified extent VALUE
445 specified affected_part VALUE does not match with specified crown_loc VALUE
605 specified affected_part VALUE does not match with specified defol VALUE
650 Tree VALUE from TRD file exist not in TRC file
2003 Please be aware that cause 541 stands for MARKING CUTS, not for a cutted tree
2005 Affected part VALUE does not fit to removal_mortality VALUE - A tree cutted and removed (removal_mortality 11-19) has to be coded as dead tree (affected_part = 4)


TRC

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
215 (defol = -1) WHERE (defol_t-1 = 100) e
216 ((affected_part IN (4, 9)) OR (affected_part IS NULL)) WHERE (defol_t-1 = 100) e
217 ((removal_mortality IN (7, 11, 12, 13, 14, 18, 19, 31, 32, 38, 39, 41, 42, 48, 49)) OR (removal_mortality IS NULL)) WHERE (defol_t-1 = 100) e
218 (tree_species = tree_species_t-1) WHERE (tree_species_t-1 NOT IN (99, 199, 0, 94)) e
219 tree = tree_t-1 w
4101 (defol = 100) WHERE ((defol_t-1 < 100) AND (defol_t-1 <> -1) AND (affect_part = 4)) e
RULE_ID MSG MSG_CODE
215 defol VALUE does not match with value VALUE from previous year TT_NOT_MATCH
216 affected_part VALUE does not match with defoliation 100 from previous year TT_NOT_MATCH_DEFOL
217 removal_mortality VALUE does not match with defoliation 100 from previous year TT_NOT_MATCH_DEFOL
218 tree_species VALUE does not match with value VALUE from previous year TT_NOT_MATCH
219 tree VALUE must be the same as at previous observation (unless new trees were intentiously involved - e.g. due to ingrowth - or existing trees were felled or wind-thrown) TT_TREE_NUMBER
4101 A dead tree has to be reported with defoliation 100 in the first year TT_DEFOL_DEAD_TREE

multiple tests

RULE_ID TEST ERROR
606 (affected_part = 4 AND removal_mortality NOT BETWEEN 11 AND 19) AND NOT (defol IN (100, -1)) e
607 (symptom = 18) AND NOT ((tree_species between 100 AND 199)) e
608 (symptom = 19) AND NOT (tree_species NOT between 100 AND 199) e
609 (affected_part IN (11,12,13)) AND NOT (tree_species between 100 AND 199) e
610 (affected_part IN (14)) AND NOT (tree_species NOT between 100 AND 199) e
611 ((removal_mortality NOT IN (4, 7, 8, 11, 12, 13, 14, 18, 19, 21, 22, 23, 29, 41, 42, 48, 49))) AND NOT (defol IS NOT NULL) e
623 ((removal_mortality IN (31, 32, 38, 39))) AND NOT (defol IN (100, -1)) e
647 EXIST(tree) e
814 (removal_mortality NOT IN (2,3,31,32,38,39,41,42,48,49)) AND NOT (visibility IN (1,2,3)) w
815 ((removal_mortality NOT IN (4, 7, 8, 11, 12, 13, 14, 18, 19, 21, 22, 23, 29, 31, 32, 33, 34, 38, 39, 41, 42, 48, 49))) AND NOT (visibility IS NOT NULL) e
816 ((removal_mortality NOT IN (4, 7, 8, 11, 12, 13, 14, 18, 19, 21, 22, 23, 29, 31, 32, 33, 34, 38, 39, 41, 42, 48, 49))) AND NOT (social_class IS NOT NULL) e
823 (tree_age_class IS NOT NULL) AND NOT (removal_mortality NOT IN (4,7,8,11,12,13,14,18,19,21,22,23,29,31,32,41,42,48,49)) w
824 (age_method IS NOT NULL) AND NOT (removal_mortality NOT IN (4,7,8,11,12,13,14,18,19,21,22,23,29,31,32,41,42,48,49)) w
825 (fruiting_assess IS NOT NULL) AND NOT (removal_mortality NOT IN (4,7,8,11,12,13,14,18,19,21,22,23,29,31,32,41,42,48,49)) w
826 (CDRD_N IS NOT NULL) AND NOT (removal_mortality NOT IN (4,7,8,11,12,13,14,18,19,21,22,23,29,31,32,41,42,48,49)) w
2007 ((removal_mortality BETWEEN 11 AND 19)) AND NOT (defol = -1) e
3099 EXIST(plot) e
RULE_ID MSG
606 specified affected_part VALUE and removal_mortality VALUE does not match with specified defol VALUE
607 specified tree_species VALUE does not match with specified symptom VALUE
608 specified tree_species VALUE does not match with specified symptom VALUE
609 specified tree_species VALUE does not match with specified affected_part VALUE
610 specified tree_species VALUE does not match with specified affected_part VALUE
611 defoliation must not be NULL
623 specified defol VALUE does not match with specified removal_mortality VALUE
647 Tree VALUE from TRC file exist not in TRD file
814 Value VALUE of visibility was specified (not NULL) although removal_mortality was specified with VALUE and no value was expected
815 visibility must not be NULL
816 social class must not be NULL
823 Value VALUE of tree_age_class was specified (not NULL) although removal_mortality was specified with VALUE and no value was expected
824 Value VALUE of age method was specified (not NULL) although removal_mortality was specified with VALUE and no value was expected
825 Value VALUE of fruiting_assess was specified (not NULL) although removal_mortality was specified with VALUE and no value was expected
826 Value VALUE of Relative crown distance was specified (not NULL) although removal_mortality was specified with VALUE and no value was expected
2007 Defoliation VALUE does not fit to removal_mortality VALUE - A tree cutted and removed (removal_mortality 11-19) has to be coded defol = -1
3099 plot VALUE is not registered in the system instalment