CASE WHEN "distance" = 1000 THEN CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.4
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.5
WHEN left("clc06",3)= '221' THEN 0.4
WHEN left("clc06",3)= '222' THEN 0.4
WHEN left("clc06",3)= '223' THEN 0.4
WHEN left("clc06",3)= '241' THEN 0.55
WHEN left("clc06",3)= '242' THEN 0.6
WHEN left("clc06",3)= '231' THEN 0
WHEN left("clc06",3)= '243' THEN 0
WHEN left("clc06",3)= '321' THEN 0
WHEN left("clc06",3)= '322' THEN 0.6
WHEN left("clc06",3)= '323' THEN 0.6
WHEN left("clc06",3)= '324' THEN 0.6
WHEN left("clc06",3)= '243' THEN 0.6
WHEN left("clc06",3)= '311' THEN 0.7
WHEN left("clc06",3)= '312' THEN 0.6
WHEN left("clc06",3)= '313' THEN 0.7
WHEN left("clc06",3)= '411' THEN 0.8
WHEN left("clc06",3)= '412' THEN 0.6
WHEN left("clc06",3)= '421' THEN 0.8
WHEN left("clc06",3)= '422' THEN 0.6
WHEN left("clc06",3)= '423' THEN 0.6
WHEN left("clc06",3)= '511' THEN 0.6
WHEN left("clc06",3)= '512' THEN 0.6
END
WHEN "distance" = 3000 THEN CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.4
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.6
WHEN left("clc06",3)= '221' THEN 0.4
WHEN left("clc06",3)= '222' THEN 0.6
WHEN left("clc06",3)= '223' THEN 0.6
WHEN left("clc06",3)= '241' THEN 0.6
WHEN left("clc06",3)= '242' THEN 0.75
WHEN left("clc06",3)= '231' THEN 0
WHEN left("clc06",3)= '243' THEN 0
WHEN left("clc06",3)= '321' THEN 0
WHEN left("clc06",3)= '322' THEN 0.8
WHEN left("clc06",3)= '323' THEN 0.8
WHEN left("clc06",3)= '324' THEN 0.6
WHEN left("clc06",3)= '243' THEN 0.6
WHEN left("clc06",3)= '311' THEN 0.8
WHEN left("clc06",3)= '312' THEN 0.8
WHEN left("clc06",3)= '313' THEN 0.8
WHEN left("clc06",3)= '411' THEN 0.8
WHEN left("clc06",3)= '412' THEN 0.8
WHEN left("clc06",3)= '421' THEN 0.8
WHEN left("clc06",3)= '422' THEN 0.6
WHEN left("clc06",3)= '423' THEN 0.8
WHEN left("clc06",3)= '511' THEN 0.8
WHEN left("clc06",3)= '512' THEN 0.8
END
WHEN "distance" = 5000 THEN CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.4
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.75
WHEN left("clc06",3)= '221' THEN 0.6
WHEN left("clc06",3)= '222' THEN 0.6
WHEN left("clc06",3)= '223' THEN 0.6
WHEN left("clc06",3)= '241' THEN 0.8
WHEN left("clc06",3)= '242' THEN 0.8
WHEN left("clc06",3)= '231' THEN 0
WHEN left("clc06",3)= '243' THEN 0
WHEN left("clc06",3)= '321' THEN 0
WHEN left("clc06",3)= '322' THEN 0.8
WHEN left("clc06",3)= '323' THEN 0.8
WHEN left("clc06",3)= '324' THEN 0.8
WHEN left("clc06",3)= '243' THEN 0.7
WHEN left("clc06",3)= '311' THEN 1
WHEN left("clc06",3)= '312' THEN 0.8
WHEN left("clc06",3)= '313' THEN 1
WHEN left("clc06",3)= '411' THEN 1
WHEN left("clc06",3)= '412' THEN 1
WHEN left("clc06",3)= '421' THEN 1
WHEN left("clc06",3)= '422' THEN 0.7
WHEN left("clc06",3)= '423' THEN 0.8
WHEN left("clc06",3)= '511' THEN 1
WHEN left("clc06",3)= '512' THEN 1
END
WHEN "distance" = 10000 THEN CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.6
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.8
WHEN left("clc06",3)= '221' THEN 0.6
WHEN left("clc06",3)= '222' THEN 0.6
WHEN left("clc06",3)= '223' THEN 0.8
WHEN left("clc06",3)= '241' THEN 0.8
WHEN left("clc06",3)= '242' THEN 1
WHEN left("clc06",3)= '231' THEN 0
WHEN left("clc06",3)= '243' THEN 0
WHEN left("clc06",3)= '321' THEN 0
WHEN left("clc06",3)= '322' THEN 1
WHEN left("clc06",3)= '323' THEN 1
WHEN left("clc06",3)= '324' THEN 1
WHEN left("clc06",3)= '243' THEN 0.8
WHEN left("clc06",3)= '311' THEN 1
WHEN left("clc06",3)= '312' THEN 0.8
WHEN left("clc06",3)= '313' THEN 1
WHEN left("clc06",3)= '411' THEN 1
WHEN left("clc06",3)= '412' THEN 1
WHEN left("clc06",3)= '421' THEN 1
WHEN left("clc06",3)= '422' THEN 0.8
WHEN left("clc06",3)= '423' THEN 1
WHEN left("clc06",3)= '511' THEN 1
WHEN left("clc06",3)= '512' THEN 1
END
WHEN "distance" = 100000 THEN CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.6
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.8
WHEN left("clc06",3)= '221' THEN 0.6
WHEN left("clc06",3)= '222' THEN 0.7
WHEN left("clc06",3)= '223' THEN 0.8
WHEN left("clc06",3)= '241' THEN 0.8
WHEN left("clc06",3)= '242' THEN 1
WHEN left("clc06",3)= '231' THEN 0
WHEN left("clc06",3)= '243' THEN 0
WHEN left("clc06",3)= '321' THEN 0
WHEN left("clc06",3)= '322' THEN 1
WHEN left("clc06",3)= '323' THEN 1
WHEN left("clc06",3)= '324' THEN 1
WHEN left("clc06",3)= '243' THEN 0.8
WHEN left("clc06",3)= '311' THEN 1
WHEN left("clc06",3)= '312' THEN 0.8
WHEN left("clc06",3)= '313' THEN 1
WHEN left("clc06",3)= '411' THEN 1
WHEN left("clc06",3)= '412' THEN 1
WHEN left("clc06",3)= '421' THEN 1
WHEN left("clc06",3)= '422' THEN 0.8
WHEN left("clc06",3)= '423' THEN 1
WHEN left("clc06",3)= '511' THEN 1
WHEN left("clc06",3)= '512' THEN 1
END
END