TRE
range tests
no tests available
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 229 | Message: defol VALUE does not match with value VALUE from previous year SQL: where (defol_t-1 = 100) AND NOT (defol = -1) |
error | since 1984 |
| 230 | Message: affected_part VALUE does not match with defoliation 100 from previous year SQL: where (defol_t-1 = 100) AND NOT ((affected_part IN (4, 9)) OR (affected_part IS NULL)) |
error | since 1984 |
| 231 | Message: 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) SQL: where (removal_mortality <> 2) 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 |
| 290 | Message: removal_mortality VALUE does not match with defoliation 100 from previous year SQL: where (defol_t-1 = 100) AND NOT ((removal_mortality IN (7, 11, 12, 13, 14, 18, 19, 31, 32, 38, 39, 41, 42, 48, 49)) OR (removal_mortality IS NULL)) |
error | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 646 | Message: Tree VALUE from TRE file exist not in TRF file SQL: where NOT (EXIST(tree)) |
error | since 1984 |
| 677 | Message: specified affected_part VALUE and removal_mortality VALUE does not match with specified defol VALUE SQL: where (affected_part = 4 AND removal_mortality NOT BETWEEN 11 AND 19) AND NOT (defol IN (100, -1)) |
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 OR tree_species IN (218,219))) |
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 |
| 682 | Message: defoliation must not be NULL SQL: where ((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) |
error | since 1984 |
| 683 | Message: specified defol VALUE does not match with specified removal_mortality VALUE SQL: where ((removal_mortality IN (31, 32, 38, 39))) AND NOT (defol IN (100, -1)) |
error | since 1984 |
| 2006 | Message: Defoliation VALUE does not fit to removal_mortality VALUE - A tree cutted and removed (removal_mortality 11-19) has to be coded defol = -1 SQL: where ((removal_mortality BETWEEN 11 AND 19)) AND NOT (defol = -1) |
error | since 1984 |
| 2009 | Message: Removal mortality code 4 is not valid for surveys CC and C1 SQL: where NOT (removal_mortality <> 4) |
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 |
| 20220083 | Message: specified defol VALUE does not match with specified removal_mortality VALUE SQL: where ((removal_mortality BETWEEN 1 AND 8) OR (removal_mortality BETWEEN 21 AND 29)) AND NOT (defol < 100) |
error | since 1984 |
TRF
range tests
no tests available
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 230 | Message: affected_part VALUE does not match with defoliation 100 from previous year SQL: where (defol_t-1 = 100) AND NOT ((affected_part IN (4, 9)) OR (affected_part IS NULL)) |
error | since 1984 |
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 |
| 651 | Message: specified affected_part VALUE does not match with specified defol VALUE SQL: where (defol = 100) AND NOT (affected_part = 4) |
warning | since 1984 |
| 652 | Message: specified affected_part VALUE does not match with not specified value for symptom (NULL value) SQL: where ((symptom IS NULL) OR (symptom = -9)) AND NOT (affected_part IN (0,4,9)) |
error | since 1984 |
| 653 | Message: specified affected_part VALUE does not match with specified symptom VALUE SQL: where ((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)) |
error | since 1984 |
| 654 | Message: sympton not specified although affected_part is specified with VALUE SQL: where (affected_part >=10) AND NOT ((symptom IS NOT NULL) AND (symptom <> -9)) |
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)) |
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)) |
error | since 1984 |
| 658 | Message: Value VALUE of symptom was specified (not NULL) although affected_part was specified with VALUE and no value was expected SQL: where (affected_part IN (0,4,9)) AND NOT ((symptom IS NULL) OR (symptom = -9 OR symptom = 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 (4,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 (4,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 (4,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 (4,11,12,13,14,21,22,23,24,25,26,27))) |
error | since 1984 |
| 663 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (symptom_spec=52) AND NOT ((affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,30,31,32,33,34))) |
error | since 1984 |
| 664 | 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,21,22,23,24,25,26,27,28))) |
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) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,28,30,31,32,33,34))) |
error | since 1984 |
| 666 | Message: specified symptom VALUE and/or affected_part VALUE does not match with specified symptom_specification VALUE SQL: where (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))) |
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 (4,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) AND (affected_part IN (4,11,12,13,14,21,22,23,24,25,26,27,31,32,33,34))) |
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 (4,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 (4,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 (4,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 (4,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 (4,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 IN (4,11,12,13,14,21,22,23,24,25,26,27,28,30,31,34)) |
error | since 1984 |
| 675 | Message: specified affected_part VALUE does not match with specified extent VALUE SQL: where (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)) |
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 |
| 2002 | Message: Please be aware that cause 541 stands for MARKING CUTS, not for a cutted tree SQL: where ((removal_mortality BETWEEN 11 AND 19)) AND NOT (cause <> 541) |
warning | since 1984 |
| 2004 | Message: 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) SQL: where ((removal_mortality BETWEEN 11 AND 19)) AND NOT (affected_part = 4) |
error | since 1984 |