TRE
range tests
no tests available
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 231 | Message: tree VALUE must be the same as at previous observation (unless new trees were intentiously reported - - e.g. due to ingrowth, forgotten or replacement trees) SQL: where (removal_mortality NOT IN (2,3)) AND NOT (tree = tree_t-1) |
warning | since 1984 |
| 232 | Message: tree_species VALUE must not change for particular tree SQL: where (tree_species_t-1 NOT IN (99, 199, 0, 94)) AND NOT (tree_species = tree_species_t-1) |
warning | since 1984 |
| 20260002 | Message: A dead tree has to be reported with defoliation 100 only in the first year (plot: VALUE / tree: VALUE) SQL: where (defol_t-1=100) AND NOT (tree IS NULL) |
error | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 651 | Message: specified code_tree_damage_status VALUE does not match with specified defol VALUE SQL: where (defol = 100) AND NOT (code_tree_damage_status = 4) |
warning | since 1984 |
| 652 | Message: For tree damage status VALUE #2 some damage assessment must be specified SQL: where (code_tree_damage_status = 1) AND NOT (tree IS NOT NULL) |
warning | since 1984 |
| 653 | Message: No damage assessment may be specified for tree damage status 0 and 9 SQL: where (code_tree_damage_status = 0 OR code_tree_damage_status = 9) AND NOT (tree IS NULL) |
error | since 1984 |
| 678 | Message: specified tree_species VALUE does not match with specified symptom VALUE SQL: where (symptom = 18) AND NOT ((tree_species between 100 AND 199)) |
error | since 1984 |
| 679 | Message: specified tree_species VALUE does not match with specified symptom VALUE SQL: where (symptom = 19) AND NOT (tree_species NOT between 100 AND 199) |
error | since 1984 |
| 680 | Message: specified tree_species VALUE does not match with specified affected_part VALUE SQL: where (affected_part IN (11,12,13)) AND NOT (tree_species between 100 AND 199) |
error | since 1984 |
| 681 | Message: specified tree_species VALUE does not match with specified affected_part VALUE SQL: where (affected_part IN (14)) AND NOT (tree_species NOT between 100 AND 199) |
error | since 1984 |
| 2004 | Message: Tree damage status VALUE does not fit to removal_mortality VALUE - contradiction between living and dead status SQL: where (removal_mortality BETWEEN 11 AND 19 OR removal_mortality BETWEEN 31 AND 39) AND NOT (code_tree_damage_status = 4) |
error | since 1984 |
| 2006 | Message: Defoliation code -1 (no assessment) should be used for trees that could not be assessed for defoliation (RM codes 7, 8, 11-19, 21-29, and 41-49 SQL: where (removal_mortality IN (7,8,11,12,13,14,18,19,21,22,23,29,41,42,48,49)) AND NOT (defol = -1) |
error | since 1984 |
| 2009 | Message: Removal mortality code 4, 24, 25, 33 and 34 are not valid for surveys CC and C1 SQL: where NOT (removal_mortality NOT IN (0,4,24,25,33,34)) |
error | since 1984 |
| 3100 | Message: plot VALUE is not registered in the system installation SQL: where NOT (EXIST(plot)) |
error | since 1984 |
| 20002 | Message: Tree species -9 is not valid for this form. Specify a proper tree species. Plot: VALUE SQL: where NOT (tree_species > 0) |
error | since 1984 |
| 20250033 | Message: For tree_damage_status -9, 0, 1 or 9, defoliation must be < 100 SQL: where (code_tree_damage_status IN (-9,0,1,9)) AND NOT (defol < 100) |
error | since 1984 |
| 20250035 | Message: For removal_mortality "tree alive" or "alive, but no longer assessed", tree_damage_status must be unlike 4 SQL: where (removal_mortality BETWEEN 0 AND 8 OR removal_mortality BETWEEN 21 AND 29) AND NOT (code_tree_damage_status <> 4) |
error | since 1984 |
| 20250036 | Message: For removal_mortality -99 and defoliation < 100, tree_damage_status must be unlike 4 SQL: where (removal_mortality = -99 AND defol < 100) AND NOT (code_tree_damage_status <> 4) |
error | 1984 - 2010 |
| 20250038 | Message: For tree_damage_status 4, removal_mortality must be "standing dead tree", "cut and removed" or "fallen trees" SQL: where (code_tree_damage_status = 4) AND NOT (removal_mortality BETWEEN 11 AND 19 OR removal_mortality BETWEEN 31 AND 49) |
error | since 1984 |
| 20250039 | Message: For tree_damage_status 0, 1 or 9, removal_mortality must be unlike "standing dead tree" or "cut and removed" SQL: where (code_tree_damage_status IN (0, 1, 9)) AND NOT (NOT (removal_mortality BETWEEN 11 AND 19 OR removal_mortality BETWEEN 31 AND 39)) |
error | since 1984 |
| 20250041 | Message: For tree damage status VALUE and standing dead or fallen trees some damage assessment must be specified SQL: where (code_tree_damage_status = 4 AND (removal_mortality BETWEEN 31 AND 49)) AND NOT (tree IS NOT NULL) |
error | since 1984 |
| 20250043 | Message: Defoliation code -1 (no assessment) should be used for trees that could not be assessed for defoliation (RM codes 7, 8, 11-19, 21-29, and 41-49 SQL: where (defol = -1) AND NOT (removal_mortality IN (7,8) OR removal_mortality BETWEEN 11 AND 29 OR removal_mortality BETWEEN 41 AND 49) |
error | since 1984 |
| 20260002 | Message: For removal_mortality 1-3, defoliaton must be 0 - 99 SQL: where (removal_mortality IN (1, 2, 3,)) AND NOT (defol Between 0 AND 99) |
error | since 1984 |
| 20260004 | Message: For removal_mortality 31-39, defoliaton must be 100 SQL: where (removal_mortality BETWEEN 31 AND 39) AND NOT (defol = 100) |
error | since 1984 |
| 20260006 | Message: For removal_mortality 41-49, code_tree_damage_status must be <> 0 SQL: where (removal_mortality BETWEEN 41 AND 49) AND NOT (code_tree_damage_status <> 0) |
error | since 1984 |
| 20260008 | Message: For damage_status 4, defoliation must be -1 or 100 SQL: where (code_tree_damage_status = 4) AND NOT (defol IN (-1, 100)) |
error | since 1984 |
| 20260010 | Message: For defoliation 100, removal_mortality must be 31-39 SQL: where (defol = 100) AND NOT (removal_mortality BETWEEN 31 AND 39) |
error | since 1984 |
| 20260012 | Message: For defoliation 0-99, removal_mortality must be 1-3 SQL: where (defol BETWEEN 0 AND 99) AND NOT (removal_mortality BETWEEN 1 AND 3) |
error | since 1984 |
| 20260014 | Message: For defoliation 0-99, damage_status must be 0, 1 or 9 SQL: where (defol BETWEEN 0 AND 99) AND NOT (code_tree_damage_status = 0 OR code_tree_damage_status = 1 OR code_tree_damage_status = 9) |
error | since 1984 |
TRF
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 649 | Message: Tree VALUE from TRF file exist not in TRE file SQL: where NOT (EXIST(tree)) |
error | since 1984 |
| 655 | Message: specified symptom VALUE does not match with specified affected_part VALUE SQL: where (affected_part IN (11,12,13,14)) AND NOT (((symptom BETWEEN 1 AND 12) OR (symptom = 99))) |
error | since 1984 |
| 656 | Message: specified symptom VALUE does not match with specified affected_part VALUE SQL: where (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,99)) |
error | since 1984 |
| 657 | Message: specified symptom VALUE does not match with specified affected_part VALUE SQL: where (affected_part BETWEEN 30 AND 34) AND NOT (symptom IN (8,9,10,11,12,13,14,16,17,18,19,20,21,22,99)) |
error | since 1984 |
| 659 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec BETWEEN 31 AND 36) AND NOT (symptom=1 AND affected_part IN (11,12,13,14)) |
error | since 1984 |
| 660 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec BETWEEN 37 AND 44) AND NOT (symptom IN (2,3,4,5) AND affected_part IN (11,12,13,14)) |
error | since 1984 |
| 661 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec BETWEEN 45 AND 49) AND NOT (symptom=8 AND affected_part IN (11,12,13,14)) |
error | since 1984 |
| 662 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (50,51)) AND NOT (symptom=8 AND affected_part IN (11,12,13,14,21,22,23,24,25,26,27)) |
error | since 1984 |
| 665 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec=54) AND NOT (symptom=10) |
error | since 1984 |
| 666 | Message: specified symptom_specification VALUE does not match with specified symptom VALUE SQL: where (symptom_spec=55) AND NOT (symptom=10) |
error | since 1984 |
| 667 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec=56) AND NOT (symptom=11 AND affected_part IN (11,12,13,14)) |
error | since 1984 |
| 668 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec=57) AND NOT (symptom=11) |
error | since 1984 |
| 669 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (58,59,60)) AND NOT (symptom=17 AND affected_part IN (21,22,23,24,25,26,27,31,32,33,34)) |
error | since 1984 |
| 670 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (61,64)) AND NOT (symptom=8 AND affected_part IN (21,22,23,24,25,26,27)) |
error | since 1984 |
| 671 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (62,63)) AND NOT (symptom=8 AND affected_part IN (21,22,23,24,25,26,27,31,32,33,34)) |
error | since 1984 |
| 672 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (65,66)) AND NOT (symptom=10 AND affected_part IN (21,22,23,24,25,26,27,31,32,33,34)) |
error | since 1984 |
| 673 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec IN (67)) AND NOT (symptom=11 AND affected_part IN (31,32,33,34)) |
error | since 1984 |
| 674 | Message: specified affected_part VALUE does not match with specified crown_loc VALUE SQL: where (crown_loc IN (1,2,3,4)) AND NOT (affected_part <> -9) |
error | since 1984 |
| 1192 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec=53) AND NOT ((symptom IN (10,11)) AND (affected_part IN (4,11,12,13,14))) |
error | since 1984 |
| 20250037 | Message: For code_cause 999 ("Investigated but unidentified"), tree_damage_status must be -9, 1 or 4 SQL: where (code_cause = 999) AND NOT (code_tree_damage_status NOT IN (0, 9)) |
error | since 1984 |
| 20250042 | Message: No damage assessment may be specified for cut and removed trees (RM 11-19) SQL: where (removal_mortality BETWEEN 11 AND 19) AND NOT (tree IS NULL) |
error | since 1984 |