DWD

range tests

no tests available

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
836 (dw_type IN (1,3,4)) AND NOT (diameter <= 150) w
837 (dw_type = 1) AND NOT (dw_length <= 40) w
838 (dw_type = 3) AND NOT (dw_length <= 50) w
839 (dw_type = 4) AND NOT ((dw_length < 1.3) AND (diameter > 10)) e
840 (dw_type IN (1,3,4)) AND NOT (dw_species IS NOT NULL) e
864 (dw_type = 3) AND NOT ((dw_length > 1.3) AND (diameter > 10)) e
866 (dw_type = 2) AND NOT (((diameter > 5) AND (diameter < 10))) e
885 ((dw_rem = 1) AND(subplot IN (1,2))) AND NOT (dw_type <> 1) e
892 (dw_type = 9) AND NOT ((dw_length = 1.3) OR (diameter IN (5,10))) e
893 (dw_type = 5) AND NOT (diameter < 5) e
894 (dw_type = 1) AND NOT ((dw_length <> 1.3) AND (diameter > 10)) e
RULE_ID MSG
836 diameter VALUE in Deadwood type VALUE is exceptional
837 dw_length/height VALUE in Deadwood type VALUE is exceptional
838 dw_length/height VALUE in Deadwood type VALUE is exceptional
839 specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE
840 dw_species not specified although dw_type is specified with VALUE
864 specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE
866 diameter VALUE not in range between 5 and 10
885 specified Deadwood type VALUE does not match with specified Removal of coarse woody debris VALUE
892 specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE
893 diameter VALUE not in range between lower and 5
894 specified length/height VALUE and diameter VALUE does not match with specified deadwood type VALUE


THT

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
canopy_height 2004   0.3 40 w
height 2004   1.31 50 w

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
873 (age=1) AND NOT (height < 4) w
874 (age>1) AND NOT (height > 3) w
875 canopy_height < height e
RULE_ID MSG
873 specified Tree height VALUE does not match with specified Mean age code (GPL) VALUE
874 specified Tree height VALUE does not match with specified Mean age code (GPL) VALUE
875 specified Tree height VALUE must not smaller than specified Height of the base of the canopy layer VALUE


DBH

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
azimuth 2004   0 359 e
tree 2004   1 125 w

temporal tests

RULE_ID TEST ERROR
294 (dbh >= dbh_t-1) WHERE (tree_status = 1) e
295 decay >= decay_t-1 e
296 (dbh <= dbh_t-1) WHERE (tree_status IN (2,3)) e
297 (tree_status <> 1) WHERE (tree_status_t-1 IN (2,3)) e
303 (tree_species = tree_species_t-1) WHERE (tree_species NOT IN (000,199)) w
304 (distance = distance_t-1) WHERE ((distance_t-1 IS NOT NULL) AND (distance IS NOT NULL)) e
RULE_ID MSG MSG_CODE
294 DBH VALUE does not match with value VALUE from previous year TT_NOT_MATCH
295 Code Decay VALUE does not match with value VALUE from previous year TT_NOT_MATCH
296 DBH VALUE does not match with value VALUE from previous year TT_NOT_MATCH
297 Code Tree Status VALUE does not match with value VALUE from previous year TT_NOT_MATCH
303 tree species VALUE does not match with value VALUE from previous year TT_NOT_MATCH
304 Distance VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
832 (((distance IS NOT NULL) AND (subplot = 1))) AND NOT (distance <= 3.1) e
833 (((distance IS NOT NULL) AND (subplot = 2))) AND NOT (distance BETWEEN 3.1 AND 11.3) e
834 (((distance IS NOT NULL) AND (subplot = 3))) AND NOT (distance BETWEEN 11.3 AND 25.3) e
861 (subplot = 1) AND NOT (dbh BETWEEN 0.001 and 150) w
862 (subplot = 2) AND NOT (dbh BETWEEN 10 and 150) w
863 (subplot = 3) AND NOT (dbh BETWEEN 50 and 150) w
865 (tree_status IN (2,3)) AND NOT (decay IS NOT NULL) e
881 ((tree_species = tree_species) AND (dbh = dbh)) w
888 ((canopy = 1) AND (subplot IN (1,2))) AND NOT (tree_status <> 1) w
RULE_ID MSG
832 specified distance VALUE does not match with specified subplot VALUE
833 specified distance VALUE does not match with specified subplot VALUE
834 specified distance VALUE does not match with specified subplot VALUE
861 dbh VALUE not in range between 0 and 150
862 dbh VALUE not in range between 10 and 150
863 dbh VALUE not in range between 50 and 150
865 decay not specified although tree status is specified with VALUE
881 Tree VALUE in DBH has not the same species (VALUE) and dbh (VALUE) than Tree VALUE in THT (species VALUE, dbh VALUE).
888 specified Code canopy closure VALUE and subplot VALUE does not match with specified Tree status VALUE


GVG

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
cover 2004   0.01 100 e

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
882 (substr(species,0,1) = '3' ) AND NOT (layer = 4) e
883 (substr(species,0,1) = '4' ) AND NOT (layer = 4) e
884 (substr(species,0,1) = '5' ) AND NOT (layer = 4) e
890 (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')) w
891 (layer =1 ) AND NOT ((canopy <> 1) AND (n_treelayer <> 5) ) e
RULE_ID MSG
882 specified moos/lichen species VALUE does not match with specified layer VALUE
883 specified moos/lichen species VALUE does not match with specified layer VALUE
884 specified moos/lichen species VALUE does not match with specified layer VALUE
890 specified Survey date VALUE does not match with specified EFTC VALUE
891 specified Layer (GVG) VALUE and Code canopy closure VALUE does not match with specified Code number of tree layers VALUE


GPL

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
slope 2004   0 100 w

temporal tests

RULE_ID TEST ERROR
298 (age <> 9) WHERE (age_t-1 <> 9) e
299 (age = 8) WHERE (age_t-1 = 8) w
300 eftc = eftc_t-1 w
301 orientation = orientation_t-1 e
302 (preuse = preuse_t-1) WHERE (preuse IN (1,2,3,4)) w
RULE_ID MSG MSG_CODE
298 Code Age VALUE does not match with value VALUE from previous year TT_NOT_MATCH
299 Code Age VALUE does not match with value VALUE from previous year TT_NOT_MATCH
300 EFTC VALUE does not match with value VALUE from previous year TT_NOT_MATCH
301 orientation VALUE does not match with value VALUE from previous year TT_NOT_MATCH
302 Preuse VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
841 (country = 1) AND NOT (gps_elevation BETWEEN 0 AND 2200) w
842 (country = 2) AND NOT (gps_elevation BETWEEN 0 AND 690) w
843 (country = 4) AND NOT (gps_elevation BETWEEN 0 AND 2000) w
844 (country = 5) AND NOT (gps_elevation BETWEEN 0 AND 2200) w
845 (country = 6) AND NOT (gps_elevation BETWEEN 0 AND 500) w
846 (country = 7) AND NOT (gps_elevation BETWEEN 0 AND 500) w
847 (country = 8) AND NOT (gps_elevation BETWEEN 0 AND 170) w
848 (country = 11) AND NOT (gps_elevation BETWEEN 0 AND 2200) w
849 (country = 13) AND NOT (gps_elevation BETWEEN 0 AND 900) w
850 (country = 14) AND NOT (gps_elevation BETWEEN 120 AND 2000) w
851 (country = 15) AND NOT (gps_elevation BETWEEN 0 AND 1320) w
852 (country = 50) AND NOT (gps_elevation BETWEEN 200 AND 2200) w
853 (country = 51) AND NOT (gps_elevation BETWEEN 80 AND 1000) w
854 (country = 53) AND NOT (gps_elevation BETWEEN 0 AND 2000) w
855 (country = 54) AND NOT (gps_elevation BETWEEN 100 AND 2000) w
856 (country = 56) AND NOT (gps_elevation BETWEEN 0 AND 290) w
857 (country = 58) AND NOT (gps_elevation BETWEEN 120 AND 1600) w
858 (country = 60) AND NOT (gps_elevation BETWEEN 0 AND 2200) w
859 (country = 64) AND NOT (gps_elevation BETWEEN 0 AND 300) w
860 (country = 66) AND NOT (gps_elevation BETWEEN 0 AND 1950) w
872 (eftc IN (1,2,3,10)) AND NOT ((forest_type <> 6) AND (forest_type <> 7)) e
877 (preuse = 4) AND NOT ((forest_type IN (5,6,8)) AND (age IN (1,2))) w
880 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') w
RULE_ID MSG
841 GPS elevation VALUE not in range between 0 and 2200
842 GPS elevation VALUE not in range between 0 and 690
843 GPS elevation VALUE not in range between 0 and 2000
844 GPS elevation VALUE not in range between 0 and 2200
845 GPS elevation VALUE not in range between 0 and 500
846 GPS elevation VALUE not in range between 0 and 500
847 GPS elevation VALUE not in range between 0 and 170
848 GPS elevation VALUE not in range between 0 and 2200
849 GPS elevation VALUE not in range between 0 and 900
850 GPS elevation VALUE not in range between 120 and 2000
851 GPS elevation VALUE not in range between 0 and 1320
852 GPS elevation VALUE not in range between 200 and 2200
853 GPS elevation VALUE not in range between 80 and 1000
854 GPS elevation VALUE not in range between 0 and 2000
855 GPS elevation VALUE not in range between 100 and 2000
856 GPS elevation VALUE not in range between 0 and 290
857 GPS elevation VALUE not in range between 120 and 1600
858 GPS elevation VALUE not in range between 0 and 2200
859 GPS elevation VALUE not in range between 0 and 300
860 GPS elevation VALUE not in range between 0 and 1950
872 specified Forest type VALUE does not match with specified EFTC VALUE
877 specified Forest type VALUE and age VALUE does not match with specified Previous land-use VALUE
880 VALUE is an invalid UTM Zone.


CAN

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
n_trees 2004   1 110 w

temporal tests

no tests available

multiple tests

RULE_ID TEST ERROR
867 (canopy = 1) AND NOT (n_treelayer = 5) e
868 (n_treelayer = 5) AND NOT (canopy = 1) e
869 ((canopy = 1) AND (subplot IN (1,2))) AND NOT ((dbh_percentage = 0) OR (dbh_percentage IS NULL)) w
870 ((canopy = 1) AND (subplot IN (1,2))) AND NOT ((n_trees = 0) OR (n_trees IS NULL)) w
871 ((dbh_percentage = 0) AND (dbh_percentage IS NULL)) AND NOT ((n_trees = 0) OR (n_trees IS NULL)) e
876 (subplot <> 1) AND NOT (dbh_percentage = 100) w
878 (preuse = 4) AND NOT (n_treelayer IN (1,2,5)) w
886 (forest_type = 7) AND NOT (n_treelayer IN (2,3,4) ) w
887 ((layer = 1) AND (cover < 10)) AND NOT (canopy IN (2,3,4)) w
889 (eftc IN (4,5,6,7,8,11,12,13)) AND NOT (to_char(date_survey, 'mm') IN ('05','06','07','08','09','10')) w
RULE_ID MSG
867 specified Code canopy closure VALUE does not match with specified code number of tree layer VALUE
868 specified Code canopy closure VALUE does not match with specified code number of tree layer VALUE
869 specified dbh_percentage VALUE does not match with specified Code canopy closure VALUE
870 specified Number of trees VALUE does not match with specified Code canopy closure VALUE
871 specified dbh_percentage VALUE does not match with specified Number of trees VALUE
876 specified dbh_percentage VALUE does not match with specified subplot VALUE
878 specified Previous land-use VALUE does not match with specified Number of tree layers VALUE
886 specified Number of layer VALUE does not match with specified Forest type VALUE
887 specified GV layer VALUE and GV coverage VALUE does not match with specified Code canopy closure VALUE
889 specified Survey date VALUE does not match with specified EFTC VALUE