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 |