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.

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

Soil collection determinations need cleaning #524

Open
kyule opened this issue Jul 25, 2024 · 0 comments
Open

Soil collection determinations need cleaning #524

kyule opened this issue Jul 25, 2024 · 0 comments
Assignees
Labels
data Data cleaning is needed low priority This is a low priority issue

Comments

@kyule
Copy link
Member

kyule commented Jul 25, 2024

Dry soil collection with collid 30 needs its determinations cleaned up. For example, see the results of

SELECT d.detid,o.collid,d.occid,d.sciname,o.sciName,d.tidInterpreted,o.tidInterpreted FROM omoccurdeterminations d
LEFT JOIN omoccurrences o ON o.occid=d.occid
WHERE d.isCurrent=1 AND d.sciname!=o.sciName AND o.collid=30;

@kyule kyule added low priority This is a low priority issue data Data cleaning is needed labels Jul 25, 2024
@kyule kyule self-assigned this Jul 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data Data cleaning is needed low priority This is a low priority issue
Projects
None yet
Development

No branches or pull requests

1 participant