Check locality species

[karilint]

A procedure that checks the minimum taxonomy composition in a locality species list, i.e. if there is Genus indet. and Genus species, the Genus indet. will be treated as an unnecessary entry that needs to be removed.

[karilint]

Activity
Show details
Write a comment…
indre.zliobaite Jan 18, 2023 2:34 PM
In the long run yes

[karilint]

577 rows:

SELECT DISTINCT
ls.lid,
ls.species_id,
sp.class_name,
sp.order_name,
sp.family_name,
sp.subclass_or_superorder_name,
sp.suborder_or_superfamily_name,
sp.subfamily_name,
sp.genus_name,
sp.species_name
FROM now_ls ls
JOIN com_species sp ON ls.species_id = sp.species_id
WHERE sp.species_name <> 'indet.' AND sp.genus_name <> 'indet.'
AND EXISTS (
SELECT 1
FROM now_ls ls2
JOIN com_species sp2 ON ls2.species_id = sp2.species_id
WHERE ls2.lid = ls.lid
AND sp2.genus_name = sp.genus_name
AND sp2.species_name = 'indet.'
AND sp2.unique_identifier = '-'
AND sp2.genus_name <> ''
);