Other Habitats

select code_2000,
    scientific_name,
    habitat_description,
    habitat_category,
    eunis_habitat_code,
REPLACE(REPLACE(habitat_type_tree, '[', ''), ']', '') as habitat_type_tree,
    habitat_unique_id,
    CASE
        WHEN habitat_type_tree like '%RL - Marine habitats%' THEN 1
        ELSE 0
    END AS marine,
    replace(habitat_unique_id, 'REDLIST_', '') as redlist_code
from EUNIS.latest.Habitat_Information