humlab-sead / sead_bugs_import

SEAD bugs import
2 stars 0 forks source link

Question: Should taxa be unique within a taxonomic order system? #57

Open roger-mahler opened 1 year ago

roger-mahler commented 1 year ago

This query returns 36 unique taxon_id's having more than one records in taxonomic order:

select *
from tbl_taxonomic_order
where taxon_id in (
    select taxon_id
    from tbl_taxonomic_order
        where taxonomic_order_system_id = 1
    group by taxon_id
    having count(*) > 1
)
order by taxon_id

All have different taxonomic_code, so I guess this is OK?