1010CASE
WHEN "ProtectedByLaw" THEN 0
WHEN "Natura2000HabitatsDirectiveArticle2PrioritySpecie" THEN 1
WHEN "Natura2000HabitatsDirectiveArticle2" THEN 2
WHEN "Natura2000HabitatsDirectiveArticle4" THEN 3
WHEN "Natura2000HabitatsDirectiveArticle5" THEN 4
WHEN "TaxonIsRedlisted" THEN
CASE
WHEN "RedlistCategory" = 'DD' THEN 5
WHEN "RedlistCategory" = 'RE' THEN 6
WHEN "RedlistCategory" = 'CR' THEN 7
WHEN "RedlistCategory" = 'EN' THEN 8
WHEN "RedlistCategory" = 'VU' THEN 9
WHEN "RedlistCategory" = 'NT' THEN 10
ELSE 11
END
WHEN "TaxonIsSignalSpecie" THEN 12
ELSE 999
END"EndDate"001