Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bugs import error: No synonym genus specified #47

Open
roger-mahler opened this issue Mar 20, 2020 · 1 comment
Open

Bugs import error: No synonym genus specified #47

roger-mahler opened this issue Mar 20, 2020 · 1 comment
Assignees
@roger-mahler @visead
Labels
data-error Incorrect data in SEAD
Milestone
SEAD @2020.04 rel...

Comments

@roger-mahler
Copy link
Collaborator

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
@roger-mahler roger-mahler added the data-error Incorrect data in SEAD label Mar 20, 2020
@roger-mahler roger-mahler added this to the SEAD @2020.03 release milestone Mar 20, 2020
@roger-mahler roger-mahler mentioned this issue Mar 20, 2020
Closed
@visead
Copy link
Contributor

visead commented Mar 20, 2020

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@roger-mahler roger-mahler

@visead visead

Labels
data-error Incorrect data in SEAD
Projects
None yet
Milestone
SEAD @2020.04 release
Development

No branches or pull requests
2 participants
@roger-mahler @visead