PLI

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
plot_size 2011   0.1 9.9999 w

temporal tests

RULE_ID TEST ERROR
249 longitude = longitude_t-1 w
250 latitude = latitude_t-1 w
RULE_ID MSG MSG_CODE
249 longitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH
250 latitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
696 plot_size = plot_size w
3014 EXIST(plot) e
3223 LENGTH(latitude) = 7 AND latitude LIKE('+%') e
3224 LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) e
RULE_ID MSG
696 specified SI_plot_size VALUE does not match with specified GR_plot_size VALUE
3014 plot VALUE is not registered in the system instalment
3223 latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+'
3224 longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-'


IRM

range/temp tests/mulitiple tests

no tests available


IPM

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
bark 2011   0.1 9.9 w
crown_base_height 2011   0.1 40 w
crown_width 2011   0.1 30 w
height 2011   1 50 w
volume 2011   0.001 15 w

temporal tests

RULE_ID TEST ERROR
253 (tree_species = tree_species_t-1) WHERE (tree_species_t-1 NOT IN (99, 199, 0, 94)) w
254 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) >= ((diameter_t-1 + CASE WHEN diameter2_t-1 IS NULL THEN diameter_t-1 ELSE diameter2_t-1 END) / 2 * 0.98)) w
255 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) <= ((diameter_t-1 + CASE WHEN diameter2_t-1 IS NULL THEN diameter_t-1 ELSE diameter2_t-1 END) / 2 * 1.2)) w
256 height >= (height_t-1 -1) w
257 height >= (height_t-1 * 0.95) w
258 tree = tree_t-1 w
259 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) <= ((diameter_t-1) * (1 + (1.2/SQRT(POWER(1.16,diameter_t-1)))))) WHERE (((country = 50) AND (diameter2_t-1 IS NULL))) w
260 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) <= ((diameter_t-1) * (1 + (1.2/SQRT(POWER(1.16,diameter_t-1)))))) WHERE (((country = 50) AND (diameter2_t-1 IS NOT NULL))) w
261 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) >= ((diameter_t-1) * (1 - (0.2/SQRT(POWER(1.16,diameter_t-1)))))) WHERE (((country = 50) AND (diameter2_t-1 IS NULL))) w
262 (((diameter + CASE WHEN diameter2 IS NULL THEN diameter ELSE diameter2 END) / 2) >= ((diameter_t-1) * (1 - (0.2/SQRT(POWER(1.16,diameter_t-1)))))) WHERE (((country = 50) AND (diameter2_t-1 IS NOT NULL))) w
263 (height >= (height_t-1 * 0.9)) WHERE ((country = 50)) w
RULE_ID MSG MSG_CODE
253 tree_species VALUE must not change for particular tree TT_TREE_SPECIES
254 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
255 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
256 height VALUE does not match with value VALUE from previous year TT_NOT_MATCH
257 height VALUE does not match with value VALUE from previous year TT_NOT_MATCH
258 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
259 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
260 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
261 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
262 diameter VALUE does not match with value VALUE from previous year TT_NOT_MATCH
263 height VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
697 (removal IN (1,2,3)) AND NOT (diameter IS NOT NULL) e
RULE_ID MSG
697 diameter not specified although removal is specified with VALUE


IRH

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
276 (tree_species = tree_species_t-1) WHERE (tree_species_t-1 NOT IN (99, 199, 0, 94)) w
RULE_ID MSG MSG_CODE
276 tree_species VALUE must not change for particular tree TT_TREE_SPECIES

multiple tests

no tests available


IRP

range/temp tests/mulitiple tests

no tests available


INV

range tests

FIELD VALID_FROM VALID_TO MIN MAX ERROR
volume_stemwood_newlydead 2011   1 999 w
volume_stemwood_remaining 2011   1 999 w
volume_stemwood_removed 2011   1 999 w

temporal tests

RULE_ID TEST ERROR
275 ((volume_stemwood_remaining + volume_stemwood_newlydead + volume_stemwood_removed) <= (vol1_t-1 * 1.15)) WHERE ((tree_species = tree_species_t-1)) w
4002 longitude = longitude_t-1 w
4008 latitude = latitude_t-1 w
RULE_ID MSG MSG_CODE
275 vol1 VALUE does not match with value VALUE from previous year TT_NOT_MATCH
4002 longitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH
4008 latitude VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
698 altitude = altitude w
699 latitude = latitude w
700 longitude = longitude w
3021 EXIST(plot) e
3217 LENGTH(latitude) = 7 AND latitude LIKE('+%') e
3218 LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%')) e
RULE_ID MSG
698 GR_altitude VALUE is not the same as in GENER.PLT
699 GR_latitude VALUE is not the same as in GENER.PLT (VALUE).
700 GR_longitude VALUE is not the same as in GENER.PLT (VALUE).
3021 plot VALUE is not registered in the system instalment
3217 latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading '+'
3218 longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading '+/-'


IEV

range tests

no tests available

temporal tests

RULE_ID TEST ERROR
124 volume_plot_per BETWEEN (vol_t-1 * 0.85) AND (vol_t-1 * 1.15) w
RULE_ID MSG MSG_CODE
124 vol VALUE does not match with value VALUE from previous year TT_NOT_MATCH

multiple tests

RULE_ID TEST ERROR
229 basal_5 < basal_plot w
230 volume_5 < volume_plot w
231 basal_10 < basal_5 w
232 volume_10 < volume_5 w
233 basal_15 < basal_10 w
234 volume_15 < volume_10 w
235 basal_20 < basal_15 w
236 volume_20 < volume_15 w
237 basal_25 < basal_20 w
238 volume_25 < volume_20 w
RULE_ID MSG
229 specified basal_5 VALUE must not smaller than specified basal_plot VALUE
230 specified volume_5 VALUE must not smaller than specified volume_plot VALUE
231 specified basal_10 VALUE must not smaller than specified basal_5 VALUE
232 specified volume_10 VALUE must not smaller than specified volume_5 VALUE
233 specified basal_15 VALUE must not smaller than specified basal_10 VALUE
234 specified volume_15 VALUE must not smaller than specified volume_10 VALUE
235 specified basal_20 VALUE must not smaller than specified basal_15 VALUE
236 specified volume_20 VALUE must not smaller than specified volume_15 VALUE
237 specified basal_25 VALUE must not smaller than specified basal_20 VALUE
238 specified volume_25 VALUE must not smaller than specified volume_20 VALUE

results matching ""

    No results matching ""