     eradication_descript AS populationskontrolle_ergebnis, 
     control_type_descript AS bekaempfungsmethode, 
     cover_code_descript AS deckung, 
-    CASE 
+    CASE  
         WHEN count_unit_descript = 'Fläche [m²]' 
             THEN abundance_code_descript||' m2' 
         ELSE abundance_code_descript||' '||count_unit_descript 

        WHEN typo_ch LIKE '9.4%' 
            THEN 'Versiegelter Sportplatz, Parkplatz etc.'
        ELSE typo_ch 
    END AS lebensraum, 
    taxon_id AS schweizerflora_id, 
    taxon AS artenname_latein, 
    name_de AS artenname_deutsch, 

    remarks AS bemerkungen, 
    geometrie
FROM alw_infoflora.neophyten_neophytenstandorte
WHERE presence IN (681, 686); 


