GPL
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| slope | 0 | 100 | warning | since 1984 |
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 298 | Message: Code Age VALUE does not match with value VALUE from previous year SQL: where (age_t-1 <> 9) AND NOT (age <> 9) |
error | since 1984 |
| 299 | Message: Code Age VALUE does not match with value VALUE from previous year SQL: where (age_t-1 = 8) AND NOT (age = 8) |
warning | since 1984 |
| 300 | Message: EFTC VALUE does not match with value VALUE from previous year SQL: where NOT (eftc = eftc_t-1) |
warning | since 1984 |
| 301 | Message: orientation VALUE does not match with value VALUE from previous year SQL: where NOT (orientation = orientation_t-1) |
error | since 1984 |
| 302 | Message: Preuse VALUE does not match with value VALUE from previous year SQL: where (preuse IN (1,2,3,4)) AND NOT (preuse = preuse_t-1) |
warning | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 841 | Message: GPS elevation VALUE not in range between 0 and 2200 SQL: where (country = 1) AND NOT (gps_elevation BETWEEN 0 AND 2200) |
warning | since 1984 |
| 842 | Message: GPS elevation VALUE not in range between 0 and 690 SQL: where (country = 2) AND NOT (gps_elevation BETWEEN 0 AND 690) |
warning | since 1984 |
| 843 | Message: GPS elevation VALUE not in range between 0 and 2000 SQL: where (country = 4) AND NOT (gps_elevation BETWEEN 0 AND 2000) |
warning | since 1984 |
| 844 | Message: GPS elevation VALUE not in range between 0 and 2200 SQL: where (country = 5) AND NOT (gps_elevation BETWEEN 0 AND 2200) |
warning | since 1984 |
| 845 | Message: GPS elevation VALUE not in range between 0 and 500 SQL: where (country = 6) AND NOT (gps_elevation BETWEEN 0 AND 500) |
warning | since 1984 |
| 846 | Message: GPS elevation VALUE not in range between 0 and 500 SQL: where (country = 7) AND NOT (gps_elevation BETWEEN 0 AND 500) |
warning | since 1984 |
| 847 | Message: GPS elevation VALUE not in range between 0 and 170 SQL: where (country = 8) AND NOT (gps_elevation BETWEEN 0 AND 170) |
warning | since 1984 |
| 848 | Message: GPS elevation VALUE not in range between 0 and 2200 SQL: where (country = 11) AND NOT (gps_elevation BETWEEN 0 AND 2200) |
warning | since 1984 |
| 849 | Message: GPS elevation VALUE not in range between 0 and 900 SQL: where (country = 13) AND NOT (gps_elevation BETWEEN 0 AND 900) |
warning | since 1984 |
| 850 | Message: GPS elevation VALUE not in range between 120 and 2000 SQL: where (country = 14) AND NOT (gps_elevation BETWEEN 120 AND 2000) |
warning | since 1984 |
| 851 | Message: GPS elevation VALUE not in range between 0 and 1320 SQL: where (country = 15) AND NOT (gps_elevation BETWEEN 0 AND 1320) |
warning | since 1984 |
| 852 | Message: GPS elevation VALUE not in range between 200 and 2200 SQL: where (country = 50) AND NOT (gps_elevation BETWEEN 200 AND 2200) |
warning | since 1984 |
| 853 | Message: GPS elevation VALUE not in range between 80 and 1000 SQL: where (country = 51) AND NOT (gps_elevation BETWEEN 80 AND 1000) |
warning | since 1984 |
| 854 | Message: GPS elevation VALUE not in range between 0 and 2000 SQL: where (country = 53) AND NOT (gps_elevation BETWEEN 0 AND 2000) |
warning | since 1984 |
| 855 | Message: GPS elevation VALUE not in range between 100 and 2000 SQL: where (country = 54) AND NOT (gps_elevation BETWEEN 100 AND 2000) |
warning | since 1984 |
| 856 | Message: GPS elevation VALUE not in range between 0 and 290 SQL: where (country = 56) AND NOT (gps_elevation BETWEEN 0 AND 290) |
warning | since 1984 |
| 857 | Message: GPS elevation VALUE not in range between 120 and 1600 SQL: where (country = 58) AND NOT (gps_elevation BETWEEN 120 AND 1600) |
warning | since 1984 |
| 858 | Message: GPS elevation VALUE not in range between 0 and 2200 SQL: where (country = 60) AND NOT (gps_elevation BETWEEN 0 AND 2200) |
warning | since 1984 |
| 859 | Message: GPS elevation VALUE not in range between 0 and 300 SQL: where (country = 64) AND NOT (gps_elevation BETWEEN 0 AND 300) |
warning | since 1984 |
| 860 | Message: GPS elevation VALUE not in range between 0 and 1950 SQL: where (country = 66) AND NOT (gps_elevation BETWEEN 0 AND 1950) |
warning | since 1984 |
| 872 | Message: specified Forest type VALUE does not match with specified EFTC VALUE SQL: where (eftc IN (1,2,3,10)) AND NOT ((forest_type <> 6) AND (forest_type <> 7)) |
error | since 1984 |
| 877 | Message: specified Forest type VALUE and age VALUE does not match with specified Previous land-use VALUE SQL: where (preuse = 4) AND NOT ((forest_type IN (5,6,8)) AND (age IN (1,2))) |
warning | since 1984 |
| 880 | Message: VALUE is an invalid UTM Zone. SQL: where NOT (utm_zone IN ('30W','31W','32W','33W','34W','35W','36W','37W','38W','29V','30V','31V','32V','33V','34V','35V','36V','37V','38V','29U','30U','31U','32U','33U','34U','35U','36U','37U','38U','29T','30T','31T','32T','33T','34T','35T','36T','37T','38T','29S','30S','31S','32S','33S','34S','35S','36S','37S','38S','28R')) |
warning | since 1984 |
DBH
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| azimuth | 0 | 359 | error | since 1984 |
| tree | 1 | 125 | warning | since 1984 |
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 294 | Message: DBH VALUE does not match with value VALUE from previous year SQL: where (tree_status = 1) AND NOT (dbh >= dbh_t-1) |
error | since 1984 |
| 295 | Message: Code Decay VALUE does not match with value VALUE from previous year SQL: where NOT (decay >= decay_t-1) |
error | since 1984 |
| 296 | Message: DBH VALUE does not match with value VALUE from previous year SQL: where (tree_status IN (2,3)) AND NOT (dbh <= dbh_t-1) |
error | since 1984 |
| 297 | Message: Code Tree Status VALUE does not match with value VALUE from previous year SQL: where (tree_status_t-1 IN (2,3)) AND NOT (tree_status <> 1) |
error | since 1984 |
| 303 | Message: tree species VALUE does not match with value VALUE from previous year SQL: where (tree_species NOT IN (000,199)) AND NOT (tree_species = tree_species_t-1) |
warning | since 1984 |
| 304 | Message: Distance VALUE does not match with value VALUE from previous year SQL: where ((distance_t-1 IS NOT NULL) AND (distance IS NOT NULL)) AND NOT (distance = distance_t-1) |
error | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 832 | Message: specified distance VALUE does not match with specified subplot VALUE SQL: where (((distance IS NOT NULL) AND (subplot = 1))) AND NOT (distance <= 3.1) |
error | since 1984 |
| 833 | Message: specified distance VALUE does not match with specified subplot VALUE SQL: where (((distance IS NOT NULL) AND (subplot = 2))) AND NOT (distance BETWEEN 3.1 AND 11.3) |
error | since 1984 |
| 834 | Message: specified distance VALUE does not match with specified subplot VALUE SQL: where (((distance IS NOT NULL) AND (subplot = 3))) AND NOT (distance BETWEEN 11.3 AND 25.3) |
error | since 1984 |
| 861 | Message: dbh VALUE not in range between 0 and 150 SQL: where (subplot = 1) AND NOT (dbh BETWEEN 0.001 and 150) |
warning | since 1984 |
| 862 | Message: dbh VALUE not in range between 10 and 150 SQL: where (subplot = 2) AND NOT (dbh BETWEEN 10 and 150) |
warning | since 1984 |
| 863 | Message: dbh VALUE not in range between 50 and 150 SQL: where (subplot = 3) AND NOT (dbh BETWEEN 50 and 150) |
warning | since 1984 |
| 865 | Message: decay not specified although tree status is specified with VALUE SQL: where (tree_status IN (2,3)) AND NOT (decay IS NOT NULL) |
error | since 1984 |
| 881 | Message: Tree VALUE in DBH has not the same species (VALUE) and dbh (VALUE) than Tree VALUE in THT (species VALUE, dbh VALUE). SQL: where NOT (((tree_species = tree_species) AND (dbh = dbh))) |
warning | since 1984 |
| 888 | Message: specified Code canopy closure VALUE and subplot VALUE does not match with specified Tree status VALUE SQL: where ((canopy = 1) AND (subplot IN (1,2))) AND NOT (tree_status <> 1) |
warning | since 1984 |
| 20000 | 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 |
THT
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| canopy_height | 0.3 | 40 | warning | since 1984 |
| height | 1.31 | 50 | warning | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 873 | Message: specified Tree height VALUE does not match with specified Mean age code (GPL) VALUE SQL: where (age=1) AND NOT (height < 4) |
warning | since 1984 |
| 874 | Message: specified Tree height VALUE does not match with specified Mean age code (GPL) VALUE SQL: where (age>1) AND NOT (height > 3) |
warning | since 1984 |
| 875 | Message: specified Tree height VALUE must not smaller than specified Height of the base of the canopy layer VALUE SQL: where NOT (canopy_height < height) |
error | since 1984 |
| 20001 | 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 |
DWD
range tests
no tests available
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 836 | Message: diameter VALUE in Deadwood type VALUE is exceptional SQL: where (dw_type IN (1,3,4)) AND NOT (diameter <= 150) |
warning | since 1984 |
| 837 | Message: dw_length/height VALUE in Deadwood type VALUE is exceptional SQL: where (dw_type = 1) AND NOT (dw_length <= 40) |
warning | since 1984 |
| 838 | Message: dw_length/height VALUE in Deadwood type VALUE is exceptional SQL: where (dw_type = 3) AND NOT (dw_length <= 50) |
warning | since 1984 |
| 839 | Message: specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE SQL: where (dw_type = 4) AND NOT ((dw_length < 1.3) AND (diameter > 10)) |
error | since 1984 |
| 840 | Message: dw_species not specified although dw_type is specified with VALUE SQL: where (dw_type IN (1,3,4)) AND NOT (dw_species IS NOT NULL) |
error | since 1984 |
| 864 | Message: specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE SQL: where (dw_type = 3) AND NOT ((dw_length > 1.3) AND (diameter > 10)) |
error | since 1984 |
| 866 | Message: diameter VALUE not in range between 5 and 10 SQL: where (dw_type = 2) AND NOT (((diameter > 5) AND (diameter < 10))) |
error | since 1984 |
| 885 | Message: specified Deadwood type VALUE does not match with specified Removal of coarse woody debris VALUE SQL: where ((dw_rem = 1) AND(subplot IN (1,2))) AND NOT (dw_type <> 1) |
error | since 1984 |
| 892 | Message: specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE SQL: where (dw_type = 9) AND NOT ((dw_length = 1.3) OR (diameter IN (5,10))) |
error | since 1984 |
| 893 | Message: diameter VALUE not in range between lower and 5 SQL: where (dw_type = 5) AND NOT (diameter < 5) |
error | since 1984 |
| 894 | Message: specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE SQL: where (dw_type = 1) AND NOT ((dw_length <> 1.3) AND (diameter > 10)) |
error | since 1984 |
CAN
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| n_trees | 1 | 110 | warning | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 867 | Message: specified Code canopy closure VALUE does not match with specified code number of tree layer VALUE SQL: where (canopy = 1) AND NOT (n_treelayer = 5) |
error | since 1984 |
| 868 | Message: specified Code canopy closure VALUE does not match with specified code number of tree layer VALUE SQL: where (n_treelayer = 5) AND NOT (canopy = 1) |
error | since 1984 |
| 869 | Message: specified dbh_percentage VALUE does not match with specified Code canopy closure VALUE SQL: where ((canopy = 1) AND (subplot IN (1,2))) AND NOT ((dbh_percentage = 0) OR (dbh_percentage IS NULL)) |
warning | since 1984 |
| 870 | Message: specified Number of trees VALUE does not match with specified Code canopy closure VALUE SQL: where ((canopy = 1) AND (subplot IN (1,2))) AND NOT ((n_trees = 0) OR (n_trees IS NULL)) |
warning | since 1984 |
| 871 | Message: specified dbh_percentage VALUE does not match with specified Number of trees VALUE SQL: where ((dbh_percentage = 0) AND (dbh_percentage IS NULL)) AND NOT ((n_trees = 0) OR (n_trees IS NULL)) |
error | since 1984 |
| 876 | Message: specified dbh_percentage VALUE does not match with specified subplot VALUE SQL: where (subplot <> 1) AND NOT (dbh_percentage = 100) |
warning | since 1984 |
| 878 | Message: specified Previous land-use VALUE does not match with specified Number of tree layers VALUE SQL: where (preuse = 4) AND NOT (n_treelayer IN (1,2,5)) |
warning | since 1984 |
| 886 | Message: specified Number of layer VALUE does not match with specified Forest type VALUE SQL: where (forest_type = 7) AND NOT (n_treelayer IN (2,3,4) ) |
warning | since 1984 |
| 887 | Message: specified GV layer VALUE and GV coverage VALUE does not match with specified Code canopy closure VALUE SQL: where ((layer = 1) AND (cover < 10)) AND NOT (canopy IN (2,3,4)) |
warning | since 1984 |
| 889 | Message: specified Survey date VALUE does not match with specified EFTC VALUE SQL: where (eftc IN (4,5,6,7,8,11,12,13)) AND NOT (to_char(date_survey, 'mm') IN ('05','06','07','08','09','10')) |
warning | since 1984 |
GVG
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| cover | 0.01 | 100 | error | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 882 | Message: specified moos/lichen species VALUE does not match with specified layer VALUE SQL: where (substr(species,0,1) = '3' ) AND NOT (layer = 4) |
error | since 1984 |
| 883 | Message: specified moos/lichen species VALUE does not match with specified layer VALUE SQL: where (substr(species,0,1) = '4' ) AND NOT (layer = 4) |
error | since 1984 |
| 884 | Message: specified moos/lichen species VALUE does not match with specified layer VALUE SQL: where (substr(species,0,1) = '5' ) AND NOT (layer = 4) |
error | since 1984 |
| 890 | Message: specified Survey date VALUE does not match with specified EFTC VALUE SQL: where (eftc IN (4,5,6,7,8,11,12,13)) AND NOT (to_char(date_survey, 'mm') IN ('03','04','05','06','07','08','09','10','11')) |
warning | since 1984 |
| 891 | Message: specified Layer (GVG) VALUE and Code canopy closure VALUE does not match with specified Code number of tree layers VALUE SQL: where (layer =1 ) AND NOT ((canopy <> 1) AND (n_treelayer <> 5) ) |
error | since 1984 |