PLS
range tests
no tests available
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 100233 | Message: longitude VALUE does not match with value VALUE from previous year SQL: where NOT (longitude = longitude_t-1) |
warning | since 1984 |
| 100234 | Message: latitude VALUE does not match with value VALUE from previous year SQL: where NOT (latitude = latitude_t-1) |
warning | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 100684 | Message: specified Y1_altitude VALUE does not match with specified S1_altitude VALUE SQL: where NOT (altitude = altitude) |
warning | since 1984 |
| 103008 | Message: plot VALUE is not registered in the system installation SQL: where NOT (EXIST(plot)) |
error | since 1984 |
| 103243 | Message: longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading "+/-" SQL: where NOT (LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%'))) |
error | since 1984 |
| 103244 | Message: latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading "+" SQL: where NOT (LENGTH(latitude) = 7 AND latitude LIKE('+%')) |
error | since 1984 |
PRF
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| diagnostic_depth_1 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_10 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_2 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_3 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_4 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_5 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_6 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_7 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_8 | -80 | 200 | warning | since 1984 |
| diagnostic_depth_9 | -80 | 200 | warning | since 1984 |
| elevation | 0 | 3000 | error | since 1984 |
temporal tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 104005 | Message: longitude VALUE does not match with value VALUE from previous year SQL: where NOT (longitude = longitude_t-1) |
warning | since 1984 |
| 104011 | Message: latitude VALUE does not match with value VALUE from previous year SQL: where NOT (latitude = latitude_t-1) |
warning | since 1984 |
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 103002 | Message: plot VALUE is not registered in the system installation SQL: where NOT (EXIST(plot)) |
error | since 1984 |
| 103245 | Message: latitude(VALUE) has to be submitted in a 7 digits format (+DDMMSS) with leading "+" SQL: where NOT (LENGTH(latitude) = 7 AND latitude LIKE('+%')) |
error | since 1984 |
| 103246 | Message: longitude(VALUE) has to be submitted in a 7 digits format (+/-DDMMSS) with leading "+/-" SQL: where NOT (LENGTH(longitude) = 7 AND (longitude LIKE('+%') OR longitude LIKE('-%'))) |
error | since 1984 |
| 20220007 | Message: The maximum effective soil depth to be reported is 500cm. Use "999" to report depths known to be deeper than 100cm without knowing the exact depth SQL: where NOT ((eff_soil_depth BETWEEN 0 AND 500) OR eff_soil_depth = 999) |
error | since 1984 |
| 20220047 | Message: qualifier_1 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_1, WRB_publication) IS TRUE) |
error | since 1984 |
| 20220048 | Message: qualifier_2 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_2, WRB_publication) IS TRUE) |
error | since 1984 |
| 20220049 | Message: qualifier_3 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_3, WRB_publication) IS TRUE) |
error | since 1984 |
| 20220050 | Message: qualifier_4 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_4, WRB_publication) IS TRUE) |
error | since 1984 |
| 20220051 | Message: qualifier_5 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_5, WRB_publication) IS TRUE) |
error | since 1984 |
| 20220052 | Message: qualifier_6 "VALUE" is not valid for specified WRB version "VALUE" SQL: where NOT (ref.fn_check_so_soil_adjective(qualifier_6, WRB_publication) IS TRUE) |
error | since 1984 |
| 20230004 | Message: eff_soil_depth is Null, which is not expected for survey years since 2003. If possible, please submit also for earlier years. SQL: where NOT (eff_soil_depth IS NOT NULL) |
warning | since 1984 |
PFH
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| hor_clay | 0 | 100 | error | since 1984 |
| hor_coarse_vol | 0 | 100 | error | since 1984 |
| hor_coarse_weight | 0 | 100 | error | since 1984 |
| hor_gypsum | 0 | 1000 | error | since 1984 |
| hor_organic_carbon | 0 | 1000 | error | since 1984 |
| hor_pH | 0.1 | 14 | error | since 1984 |
| hor_sand | 0 | 100 | error | since 1984 |
| hor_silt | 0 | 100 | error | since 1984 |
| hor_total_CaCO3 | 0 | 1000 | error | since 1984 |
| hor_total_nitrogen | 0 | 1000 | error | since 1984 |
| hor_upper | -80 | 200 | warning | since 1984 |
| hor_vertical | -80 | 200 | warning | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 20220011 | Message: sum of clay, silt and sand not between 97 and 103 percent SQL: where NOT ((hor_clay + hor_silt + hor_sand) BETWEEN 97 AND 103) |
error | since 1984 |
| 20220013 | Message: Master horizon invalid: VALUE . Valid characters are in capital letters: H,O,A,E,B,C,R,I,L,W,/,OL,OF,OFH,OLF,HF,HM,HS, more details at EI 131 SQL: where NOT (hor_master NOT SIMILAR TO '%(/)' AND ((length(hor_master) = 1 AND hor_master SIMILAR TO '(H|O|A|E|B|C|R|I|L|W)') OR ((length(hor_master) > 1 AND hor_master SIMILAR TO '(H|O|A|E|B|C|R|/|OL|OF|OFH|OLF|HF|HM|HS| )*')) )) |
error | since 1984 |
| 20220015 | Message: Subordinate horizon invalid: VALUE . Valid characters for mineral soils are in lowercase letters: a, b, c, d, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z, more details at EI 131 SQL: where (hor_subordinate IS NOT NULL AND (NOT (hor_master LIKE '%O%' OR hor_master LIKE '%H%') OR ((hor_master LIKE '%O%' OR hor_master LIKE '%H%') AND hor_master LIKE '%/%' AND hor_master NOT SIMILAR TO '(O|H|/)*'))) AND NOT (hor_subordinate SIMILAR TO '(a|b|c|d|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z| )*') |
error | since 1984 |
| 20220017 | Message: Subordinate horizon invalid: VALUE . Valid characters for organic soils are in lowercase letters: a, c, d, e, f, g, i, j, k, l, m, n, o, p, q, r, u, v, y, z, @, more details at EI 131 SQL: where (hor_subordinate IS NOT NULL AND (hor_master LIKE '%O%' OR hor_master LIKE '%H%') AND NOT (hor_master LIKE '%/%' AND hor_master NOT SIMILAR TO '(O|H|/)+')) AND NOT (hor_subordinate SIMILAR TO '(a|c|d|e|f|g|i|j|k|l|m|n|o|p|q|r|u|v|y|z|@)| *') |
error | since 1984 |
| 20220019 | Message: Horizon contains space characters: VALUE or VALUE" SQL: where NOT (hor_master NOT LIKE '% %' OR hor_subordinate NOT LIKE '% %') |
warning | since 1984 |
| 20220021 | Message: Subordinate horizon contains duplicate characters: VALUE SQL: where NOT (hor_subordinate !~ '(.+)\1') |
error | since 1984 |
SOM
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| bulk_density_dry_fine_earth | 800 | 1800 | warning | since 1984 |
| carbonates | 0.1 | 660 | warning | since 1984 |
| clay | 0.5 | 51.3 | warning | since 1984 |
| exchange_acidity | 0.05 | 22.5 | warning | since 1984 |
| exchange_Al | 0.002 | 16.6 | warning | since 1984 |
| exchange_Ca | 0.005 | 146 | warning | since 1984 |
| exchange_Fe | 0.01 | 5.2 | warning | since 1984 |
| exchange_K | 0.006 | 5.3 | warning | since 1984 |
| exchange_Mg | 0.002 | 21.5 | warning | since 1984 |
| exchange_Mn | 0.0005 | 5.7 | warning | since 1984 |
| exchange_Na | 0.002 | 21.5 | warning | since 1984 |
| extract_Al | 140 | 55250 | warning | since 1984 |
| extract_Ca | 20 | 140000 | warning | since 1984 |
| extract_Cd | 0.01 | 2.5 | warning | since 1984 |
| extract_Cr | 0.1 | 95 | warning | since 1984 |
| extract_Cu | 0.2 | 75 | warning | since 1984 |
| extract_Fe | 140 | 62500 | warning | since 1984 |
| extract_Hg | 0.01 | 2.25 | warning | since 1984 |
| extract_K | 4 | 9250 | warning | since 1984 |
| extract_Mg | 35 | 30500 | warning | since 1984 |
| extract_Mn | 0.8 | 3600 | warning | since 1984 |
| extract_Na | 4 | 650 | warning | since 1984 |
| extract_Ni | 0.06 | 80 | warning | since 1984 |
| extract_P | 35 | 2100 | warning | since 1984 |
| extract_Pb | 0.03 | 245 | warning | since 1984 |
| extract_S | 10 | 6750 | warning | since 1984 |
| extract_Zn | 0.8 | 300 | warning | since 1984 |
| Free_H_acidity | 0.1 | 17.5 | warning | since 1984 |
| layer_inferior | -80 | 200 | warning | since 1984 |
| layer_superior | -80 | 200 | warning | since 1984 |
| moisture_content | 0.1 | 10 | warning | since 1984 |
| moisture_content | 0 | 100 | error | since 1984 |
| pH_CaCl | 2.6 | 7.7 | warning | since 1984 |
| pH_CaCl | 0.1 | 14 | error | since 1984 |
| pH_H2O | 3.3 | 8.4 | warning | since 1984 |
| pH_H2O | 0.1 | 14 | error | since 1984 |
| P_ox | 0 | 999999 | error | since 1984 |
| reactive_Al | 90 | 50000 | warning | since 1984 |
| reactive_Fe | 48.4 | 7500 | warning | since 1984 |
| sand | 4 | 100 | warning | since 1984 |
| silt | 1.5 | 73 | warning | since 1984 |
| total_Al | 100 | 100000 | warning | since 1984 |
| total_Ca | 50 | 200000 | warning | since 1984 |
| total_Fe | 100 | 65000 | warning | since 1984 |
| total_K | 50 | 50000 | warning | since 1984 |
| total_Mg | 100 | 42000 | warning | since 1984 |
| total_Mn | 15 | 3500 | warning | since 1984 |
| total_Na | 20 | 20000 | warning | since 1984 |
| total_nitrogen | 0.05 | 32 | warning | since 1984 |
| total_organic_carbon | 0.4 | 590 | warning | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 100171 | Message: clay VALUE not in range between 0 and 100 SQL: where (((clay <> -1) AND (layer LIKE 'M%'))) AND NOT (clay BETWEEN 0 AND 100) |
error | since 1984 |
| 100173 | Message: sand VALUE not in range between 0 and 100 SQL: where (((sand <> -1) AND (layer LIKE 'M%'))) AND NOT (sand BETWEEN 0 AND 100) |
error | since 1984 |
| 100175 | Message: silt VALUE not in range between 0 and 100 SQL: where (((silt <> -1) AND (layer LIKE 'M%'))) AND NOT (silt BETWEEN 0 AND 100) |
error | since 1984 |
| 100177 | Message: sum of clay, silt and sand not between 97 and 103 percent SQL: where NOT ((clay + silt + sand) BETWEEN 97 AND 103) |
error | since 1984 |
| 100179 | Message: coarse_fragments_vol VALUE not in range between 0 and 100 SQL: where (((coarse_fragments_vol <> -1) AND (layer LIKE 'M%'))) AND NOT (coarse_fragments_vol BETWEEN 0 AND 100) |
error | since 1984 |
| 100180 | Message: organic_layer_dry_weight VALUE not in range between 0,1 and 150 SQL: where (((organic_layer_dry_weight <> -1) AND (layer IN ('OFH', 'HFH')))) AND NOT (organic_layer_dry_weight BETWEEN 0.1 AND 150) |
warning | since 1984 |
| 100181 | Message: total_organic_carbon VALUE not in range between 10 and 800 SQL: where (((total_organic_carbon <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_organic_carbon BETWEEN 10 AND 800) |
warning | since 1984 |
| 100182 | Message: total_organic_carbon VALUE not in range between 0,4 and 500 SQL: where (((total_organic_carbon <> -1) AND (layer LIKE 'M%'))) AND NOT (total_organic_carbon BETWEEN 0.4 AND 500) |
warning | since 1984 |
| 100183 | Message: total_nitrogen VALUE not in range between 0,5 and 35 SQL: where (((total_nitrogen <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_nitrogen BETWEEN 0.5 AND 35) |
warning | since 1984 |
| 100184 | Message: total_nitrogen VALUE not in range between 0,01 and 20 SQL: where (((total_nitrogen <> -1) AND (layer LIKE 'M%'))) AND NOT (total_nitrogen BETWEEN 0.01 AND 20) |
warning | since 1984 |
| 100185 | Message: carbonates VALUE not in range between 0 and 50 SQL: where (((carbonates <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (carbonates BETWEEN 0 AND 50) |
warning | since 1984 |
| 100186 | Message: carbonates VALUE not in range between 0 and 1000 SQL: where (((carbonates <> -1) AND (layer LIKE 'M%'))) AND NOT (carbonates BETWEEN 0 AND 1000) |
warning | since 1984 |
| 100187 | Message: exchange_acidity VALUE not in range between 0,05 and 150 SQL: where (((exchange_acidity <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%' OR layer LIKE 'M%'))) AND NOT (exchange_acidity BETWEEN 0.05 AND 150) |
warning | since 1984 |
| 100188 | Message: total_Al VALUE not in range between 100 and 50000 SQL: where (((total_Al <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_Al BETWEEN 100 AND 50000) |
warning | since 1984 |
| 100189 | Message: total_Al VALUE not in range between 100 and 100000 SQL: where (((total_Al <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Al BETWEEN 100 AND 100000) |
warning | since 1984 |
| 100190 | Message: total_Ca VALUE not in range between 150 and 150000 SQL: where (((total_Ca <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_Ca BETWEEN 150 AND 150000) |
warning | since 1984 |
| 100191 | Message: total_Ca VALUE not in range between 20 and 350000 SQL: where (((total_Ca <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Ca BETWEEN 20 AND 350000) |
warning | since 1984 |
| 100192 | Message: total_Fe VALUE not in range between 1 and 50000 SQL: where (((total_Fe <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_Fe BETWEEN 1 AND 50000) |
warning | since 1984 |
| 100193 | Message: total_Fe VALUE not in range between 1 and 150000 SQL: where (((total_Fe <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Fe BETWEEN 1 AND 150000) |
warning | since 1984 |
| 100194 | Message: total_K VALUE not in range between 50 and 10000 SQL: where (((total_K <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_K BETWEEN 50 AND 10000) |
warning | since 1984 |
| 100195 | Message: total_K VALUE not in range between 50 and 40000 SQL: where (((total_K <> -1) AND (layer LIKE 'M%'))) AND NOT (total_K BETWEEN 50 AND 40000) |
warning | since 1984 |
| 100196 | Message: total_Mg VALUE not in range between 100 and 150000 SQL: where (((total_Mg <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_Mg BETWEEN 100 AND 150000) |
warning | since 1984 |
| 100197 | Message: total_Mg VALUE not in range between 15 and 100000 SQL: where (((total_Mg <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Mg BETWEEN 15 AND 100000) |
warning | since 1984 |
| 100198 | Message: total_Mn VALUE not in range between 1 and 3500 SQL: where (((total_Mn <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Mn BETWEEN 1 AND 3500) |
warning | since 1984 |
| 100199 | Message: total_Na VALUE not in range between 1 and 5000 SQL: where (((total_Na <> -1) AND (layer LIKE 'O%' OR layer LIKE 'H%'))) AND NOT (total_Na BETWEEN 1 AND 5000) |
warning | since 1984 |
| 100200 | Message: total_Na VALUE not in range between 1 and 10000 SQL: where (((total_Na <> -1) AND (layer LIKE 'M%'))) AND NOT (total_Na BETWEEN 1 AND 10000) |
warning | since 1984 |
LQA
range tests
| FIELD | MIN | MAX | ERROR_TYPE | ACTIVE |
|---|---|---|---|---|
| control_chart_std | 0 | 100 | warning | since 1984 |
| control_chart_std | 0 | 200 | error | since 1984 |
temporal tests
no tests available
multiple tests
| RULE_ID | TEST | ERROR_TYPE | ACTIVE |
|---|---|---|---|
| 100169 | Message: specified date_start VALUE must not smaller than specified date_end VALUE SQL: where NOT (date_start <= date_end) |
error | since 1984 |
| 100546 | Message: control_chart_mean is Null, which is not expected for parameter VALUE SQL: where (parameter NOT IN ('pH_CaCl2', 'pH_H2O')) AND NOT (control_chart_mean IS NOT NULL) |
warning | since 1984 |
| 100547 | Message: control_chart_mean is Null, which is not expected for parameter VALUE SQL: where (parameter IN ('pH_CaCl2', 'pH_H2O')) AND NOT (control_chart_mean IS NOT NULL) |
warning | since 1984 |
| 100548 | Message: control_chart_std is Null, which is not expected for parameter VALUE SQL: where (parameter NOT IN ('pH_CaCl2', 'pH_H2O')) AND NOT (control_chart_std IS NOT NULL) |
warning | since 1984 |
| 100549 | Message: control_chart_std is Null, which is not expected for parameter VALUE SQL: where (parameter IN ('pH_CaCl2', 'pH_H2O')) AND NOT (control_chart_std IS NOT NULL) |
warning | since 1984 |
| 100550 | Message: quantification_limit is Null, which is not expected for parameter VALUE SQL: where (parameter NOT IN ('pH_CaCl2', 'pH_H2O', 'Acid_exch','Free_H+')) AND NOT (quantification_limit IS NOT NULL) |
error | since 1984 |
| 100913 | Message: Quantification limit must not be <= 0 where parameter is VALUE SQL: where NOT (quantification_limit > 0) |
error | since 1984 |
| 100919 | Message: Control chart mean must not be <= 0 where parameter is VALUE SQL: where NOT (control_chart_mean > 0) |
error | since 1984 |
| 100943 | Message: Control chart std VALUE not in range between 0.5 and 10 for VALUE SQL: where NOT (control_chart_std between 0.5 and 10) |
warning | since 1984 |
| 100949 | Message: Control chart std must not be <= 0 where parameter is VALUE SQL: where NOT (control_chart_std > 0) |
error | since 1984 |
| 101036 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter Pclay SQL: where (parameter='Pclay') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
| 101037 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter Psilt SQL: where (parameter='Psilt') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
| 101038 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter Psand SQL: where (parameter='Psand') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
| 101039 | Message: Quantification limit VALUE not in range between 0.05 and 5 for Parameter CaCO3 SQL: where (parameter='CaCO3') AND NOT (quantification_limit between 0.05 and 5) |
warning | since 1984 |
| 101040 | Message: Quantification limit VALUE not in range between 0.02 and 2 for Parameter org_C SQL: where (parameter='org_C') AND NOT (quantification_limit between 0.02 and 2) |
warning | since 1984 |
| 101041 | Message: Quantification limit VALUE not in range between 0.002 and 0.2 for Parameter Total_N SQL: where (parameter='Total_N') AND NOT (quantification_limit between 0.002 and 0.2) |
warning | since 1984 |
| 101042 | Message: Quantification limit VALUE not in range between 0.0025 and 0.25 for Parameter Acid_exch SQL: where (parameter='Acid_exch') AND NOT (quantification_limit between 0.0025 and 0.25) |
warning | since 1984 |
| 101043 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Al_exch SQL: where (parameter='Al_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101044 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Ca_exch SQL: where (parameter='Ca_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101045 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Fe_exch SQL: where (parameter='Fe_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101046 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter K_exch SQL: where (parameter='K_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101047 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Mg_exch SQL: where (parameter='Mg_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101048 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Mn_exch SQL: where (parameter='Mn_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101049 | Message: Quantification limit VALUE not in range between 0.001 and 0.1 for Parameter Na_exch SQL: where (parameter='Na_exch') AND NOT (quantification_limit between 0.001 and 0.1) |
warning | since 1984 |
| 101050 | Message: Quantification limit VALUE not in range between 0.0025 and 0.25 for Parameter Free_H+ SQL: where (parameter='Free_H+') AND NOT (quantification_limit between 0.0025 and 0.25) |
warning | since 1984 |
| 101051 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter Al_extr SQL: where (parameter='Al_extr') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101052 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Ca_extr SQL: where (parameter='Ca_extr') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101053 | Message: Quantification limit VALUE not in range between 0.01 and 1 for Parameter Cd_extr SQL: where (parameter='Cd_extr') AND NOT (quantification_limit between 0.01 and 1) |
warning | since 1984 |
| 101054 | Message: Quantification limit VALUE not in range between 0.03 and 3 for Parameter Cr_extr SQL: where (parameter='Cr_extr') AND NOT (quantification_limit between 0.03 and 3) |
warning | since 1984 |
| 101055 | Message: Quantification limit VALUE not in range between 0.02 and 2 for Parameter Cu_extr SQL: where (parameter='Cu_extr') AND NOT (quantification_limit between 0.02 and 2) |
warning | since 1984 |
| 101056 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter Fe_extr SQL: where (parameter='Fe_extr') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101057 | Message: Quantification limit VALUE not in range between 0.0005 and 0.05 for Parameter Hg_extr SQL: where (parameter='Hg_extr') AND NOT (quantification_limit between 0.0005 and 0.05) |
warning | since 1984 |
| 101058 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter K_extr SQL: where (parameter='K_extr') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101059 | Message: Quantification limit VALUE not in range between 0.7 and 70 for Parameter Mg_extr SQL: where (parameter='Mg_extr') AND NOT (quantification_limit between 0.7 and 70) |
warning | since 1984 |
| 101060 | Message: Quantification limit VALUE not in range between 0.08 and 8 for Parameter Mn_extr SQL: where (parameter='Mn_extr') AND NOT (quantification_limit between 0.08 and 8) |
warning | since 1984 |
| 101061 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Na_extr SQL: where (parameter='Na_extr') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101062 | Message: Quantification limit VALUE not in range between 0.03 and 3 for Parameter Ni_extr SQL: where (parameter='Ni_extr') AND NOT (quantification_limit between 0.03 and 3) |
warning | since 1984 |
| 101063 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter P_extr SQL: where (parameter='P_extr') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101064 | Message: Quantification limit VALUE not in range between 0.05 and 5 for Parameter Pb_extr SQL: where (parameter='Pb_extr') AND NOT (quantification_limit between 0.05 and 5) |
warning | since 1984 |
| 101065 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter S_extr SQL: where (parameter='S_extr') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101066 | Message: Quantification limit VALUE not in range between 0.04 and 4 for Parameter Zn_extr SQL: where (parameter='Zn_extr') AND NOT (quantification_limit between 0.04 and 4) |
warning | since 1984 |
| 101067 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Al_react SQL: where (parameter='Al_react') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101068 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Fe_react SQL: where (parameter='Fe_react') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101069 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter Al_tot SQL: where (parameter='Al_tot') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101070 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Ca_tot SQL: where (parameter='Ca_tot') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101071 | Message: Quantification limit VALUE not in range between 0.5 and 50 for Parameter Fe_tot SQL: where (parameter='Fe_tot') AND NOT (quantification_limit between 0.5 and 50) |
warning | since 1984 |
| 101072 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter K_tot SQL: where (parameter='K_tot') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101073 | Message: Quantification limit VALUE not in range between 0.7 and 70 for Parameter Mg_tot SQL: where (parameter='Mg_tot') AND NOT (quantification_limit between 0.7 and 70) |
warning | since 1984 |
| 101074 | Message: Quantification limit VALUE not in range between 0.08 and 8 for Parameter Mn_tot SQL: where (parameter='Mn_tot') AND NOT (quantification_limit between 0.08 and 8) |
warning | since 1984 |
| 101075 | Message: Quantification limit VALUE not in range between 1 and 100 for Parameter Na_tot SQL: where (parameter='Na_tot') AND NOT (quantification_limit between 1 and 100) |
warning | since 1984 |
| 101126 | Message: Control chart mean VALUE not in range between 0.6 and 80 for Parameter Pclay SQL: where (parameter='Pclay') AND NOT (control_chart_mean between 0.6 and 80) |
warning | since 1984 |
| 101127 | Message: Control chart mean VALUE not in range between 0.4 and 100 for Parameter Psilt SQL: where (parameter='Psilt') AND NOT (control_chart_mean between 0.4 and 100) |
warning | since 1984 |
| 101128 | Message: Control chart mean VALUE not in range between 0.6 and 100 for Parameter Psand SQL: where (parameter='Psand') AND NOT (control_chart_mean between 0.6 and 100) |
warning | since 1984 |
| 101129 | Message: Control chart mean VALUE not in range between 2 and 10 for Parameter pH_CaCl2 SQL: where (parameter='pH_CaCl2') AND NOT (control_chart_mean between 2 and 10) |
warning | since 1984 |
| 101130 | Message: Control chart mean VALUE not in range between 2 and 10 for Parameter pH_H2O SQL: where (parameter='pH_H2O') AND NOT (control_chart_mean between 2 and 10) |
warning | since 1984 |
| 101131 | Message: Control chart mean VALUE not in range between 3 and 850 for Parameter CaCO3 SQL: where (parameter='CaCO3') AND NOT (control_chart_mean between 3 and 850) |
warning | since 1984 |
| 101132 | Message: Control chart mean VALUE not in range between 1.2 and 580 for Parameter org_C SQL: where (parameter='org_C') AND NOT (control_chart_mean between 1.2 and 580) |
warning | since 1984 |
| 101133 | Message: Control chart mean VALUE not in range between 0.1 and 25 for Parameter Total_N SQL: where (parameter='Total_N') AND NOT (control_chart_mean between 0.1 and 25) |
warning | since 1984 |
| 101134 | Message: Control chart mean VALUE not in range between 0.21 and 10 for Parameter Acid_exch SQL: where (parameter='Acid_exch') AND NOT (control_chart_mean between 0.21 and 10) |
warning | since 1984 |
| 101135 | Message: Control chart mean VALUE not in range between 0.2 and 9 for Parameter Al_exch SQL: where (parameter='Al_exch') AND NOT (control_chart_mean between 0.2 and 9) |
warning | since 1984 |
| 101136 | Message: Control chart mean VALUE not in range between 0.22 and 60 for Parameter Ca_exch SQL: where (parameter='Ca_exch') AND NOT (control_chart_mean between 0.22 and 60) |
warning | since 1984 |
| 101137 | Message: Control chart mean VALUE not in range between 0.04 and 2 for Parameter Fe_exch SQL: where (parameter='Fe_exch') AND NOT (control_chart_mean between 0.04 and 2) |
warning | since 1984 |
| 101138 | Message: Control chart mean VALUE not in range between 0.23 and 5 for Parameter K_exch SQL: where (parameter='K_exch') AND NOT (control_chart_mean between 0.23 and 5) |
warning | since 1984 |
| 101139 | Message: Control chart mean VALUE not in range between 0.18 and 15 for Parameter Mg_exch SQL: where (parameter='Mg_exch') AND NOT (control_chart_mean between 0.18 and 15) |
warning | since 1984 |
| 101140 | Message: Control chart mean VALUE not in range between 0.03 and 6 for Parameter Mn_exch SQL: where (parameter='Mn_exch') AND NOT (control_chart_mean between 0.03 and 6) |
warning | since 1984 |
| 101141 | Message: Control chart mean VALUE not in range between 0.17 and 1.5 for Parameter Na_exch SQL: where (parameter='Na_exch') AND NOT (control_chart_mean between 0.17 and 1.5) |
warning | since 1984 |
| 101142 | Message: Control chart mean VALUE not in range between 0.21 and 10 for Parameter Free_H+ SQL: where (parameter='Free_H+') AND NOT (control_chart_mean between 0.21 and 10) |
warning | since 1984 |
| 101143 | Message: Control chart mean VALUE not in range between 76.1 and 50000 for Parameter Al_extr SQL: where (parameter='Al_extr') AND NOT (control_chart_mean between 76.1 and 50000) |
warning | since 1984 |
| 101144 | Message: Control chart mean VALUE not in range between 45.9 and 250000 for Parameter Ca_extr SQL: where (parameter='Ca_extr') AND NOT (control_chart_mean between 45.9 and 250000) |
warning | since 1984 |
| 101145 | Message: Control chart mean VALUE not in range between 0.5 and 18 for Parameter Cd_extr SQL: where (parameter='Cd_extr') AND NOT (control_chart_mean between 0.5 and 18) |
warning | since 1984 |
| 101146 | Message: Control chart mean VALUE not in range between 3.3 and 600 for Parameter Cr_extr SQL: where (parameter='Cr_extr') AND NOT (control_chart_mean between 3.3 and 600) |
warning | since 1984 |
| 101147 | Message: Control chart mean VALUE not in range between 1.9 and 300 for Parameter Cu_extr SQL: where (parameter='Cu_extr') AND NOT (control_chart_mean between 1.9 and 300) |
warning | since 1984 |
| 101148 | Message: Control chart mean VALUE not in range between 75.5 and 250000 for Parameter Fe_extr SQL: where (parameter='Fe_extr') AND NOT (control_chart_mean between 75.5 and 250000) |
warning | since 1984 |
| 101149 | Message: Control chart mean VALUE not in range between 0.3 and 4 for Parameter Hg_extr SQL: where (parameter='Hg_extr') AND NOT (control_chart_mean between 0.3 and 4) |
warning | since 1984 |
| 101150 | Message: Control chart mean VALUE not in range between 74.2 and 40000 for Parameter K_extr SQL: where (parameter='K_extr') AND NOT (control_chart_mean between 74.2 and 40000) |
warning | since 1984 |
| 101151 | Message: Control chart mean VALUE not in range between 33.3 and 200000 for Parameter Mg_extr SQL: where (parameter='Mg_extr') AND NOT (control_chart_mean between 33.3 and 200000) |
warning | since 1984 |
| 101152 | Message: Control chart mean VALUE not in range between 7.2 and 35000 for Parameter Mn_extr SQL: where (parameter='Mn_extr') AND NOT (control_chart_mean between 7.2 and 35000) |
warning | since 1984 |
| 101153 | Message: Control chart mean VALUE not in range between 20.6 and 3000 for Parameter Na_extr SQL: where (parameter='Na_extr') AND NOT (control_chart_mean between 20.6 and 3000) |
warning | since 1984 |
| 101154 | Message: Control chart mean VALUE not in range between 1.5 and 300 for Parameter Ni_extr SQL: where (parameter='Ni_extr') AND NOT (control_chart_mean between 1.5 and 300) |
warning | since 1984 |
| 101155 | Message: Control chart mean VALUE not in range between 32.8 and 10000 for Parameter P_extr SQL: where (parameter='P_extr') AND NOT (control_chart_mean between 32.8 and 10000) |
warning | since 1984 |
| 101156 | Message: Control chart mean VALUE not in range between 2.4 and 1000 for Parameter Pb_extr SQL: where (parameter='Pb_extr') AND NOT (control_chart_mean between 2.4 and 1000) |
warning | since 1984 |
| 101157 | Message: Control chart mean VALUE not in range between 128.6 and 7500 for Parameter S_extr SQL: where (parameter='S_extr') AND NOT (control_chart_mean between 128.6 and 7500) |
warning | since 1984 |
| 101158 | Message: Control chart mean VALUE not in range between 2 and 1000 for Parameter Zn_extr SQL: where (parameter='Zn_extr') AND NOT (control_chart_mean between 2 and 1000) |
warning | since 1984 |
| 101159 | Message: Control chart mean VALUE not in range between 44.6 and 7500 for Parameter Al_react SQL: where (parameter='Al_react') AND NOT (control_chart_mean between 44.6 and 7500) |
warning | since 1984 |
| 101160 | Message: Control chart mean VALUE not in range between 48.4 and 7500 for Parameter Fe_react SQL: where (parameter='Fe_react') AND NOT (control_chart_mean between 48.4 and 7500) |
warning | since 1984 |
| 101161 | Message: Control chart mean VALUE not in range between 40 and 100000 for Parameter Al_tot SQL: where (parameter='Al_tot') AND NOT (control_chart_mean between 40 and 100000) |
warning | since 1984 |
| 101162 | Message: Control chart mean VALUE not in range between 20 and 500000 for Parameter Ca_tot SQL: where (parameter='Ca_tot') AND NOT (control_chart_mean between 20 and 500000) |
warning | since 1984 |
| 101163 | Message: Control chart mean VALUE not in range between 3.5 and 250000 for Parameter Fe_tot SQL: where (parameter='Fe_tot') AND NOT (control_chart_mean between 3.5 and 250000) |
warning | since 1984 |
| 101164 | Message: Control chart mean VALUE not in range between 50 and 50000 for Parameter K_tot SQL: where (parameter='K_tot') AND NOT (control_chart_mean between 50 and 50000) |
warning | since 1984 |
| 101165 | Message: Control chart mean VALUE not in range between 5 and 250000 for Parameter Mg_tot SQL: where (parameter='Mg_tot') AND NOT (control_chart_mean between 5 and 250000) |
warning | since 1984 |
| 101166 | Message: Control chart mean VALUE not in range between 0.5 and 35000 for Parameter Mn_tot SQL: where (parameter='Mn_tot') AND NOT (control_chart_mean between 0.5 and 35000) |
warning | since 1984 |
| 101167 | Message: Control chart mean VALUE not in range between 20 and 12000 for Parameter Na_tot SQL: where (parameter='Na_tot') AND NOT (control_chart_mean between 20 and 12000) |
warning | since 1984 |
| 101173 | Message: Value of Quantification limit is missing SQL: where NOT (quantification_limit IS NOT NULL) |
warning | since 1984 |
| 101179 | Message: Value of Control chart mean is missing SQL: where NOT (control_chart_mean IS NOT NULL) |
warning | since 1984 |
| 101185 | Message: Value of Control chart std is missing SQL: where NOT (control_chart_std IS NOT NULL) |
warning | since 1984 |
| 101191 | Message: Value of Laboratory ID is missing SQL: where NOT (Laboratory_ID IS NOT NULL) |
warning | since 1984 |