Bugs import error: No synonym genus specified

humlab-sead / sead_bugs_import

SEAD bugs import

2 stars 0 forks source link

Bugs import error: No synonym genus specified #47

Open roger-mahler opened 4 years ago

roger-mahler commented 4 years ago

These errors are caused by BugsCEP entries in "TSynonym" that have "SynGenus" equal to null.

select *
from "TSynonym"
where "SynGenus" is null

CODE
7.0050311000000001
21.019005000000000
23.046024100000000
1.0410560000000000
91.027000999999998
83.024000999999998
42.002006999999999
27.008004000000000
1155.0300900000000
1076.0080049999999
75.004017000000005
55.008046000000000
23.188001000000000
18.009015000000002

visead commented 4 years ago

Resolve as follows:

Where SynGenus is null and... SynSpecies is not null, set SynGenus to taxon genus SynSpecies is null, delete the synonym record (these are errors)