Open IJBG opened 2 months ago
And then add a check for the mbbs that there's nothing that's on the imput column still, and if they is run the conversion again. BC an example of like House Wren -> Northern House wren, and then a couple years later it becomes Northern House Wren -> Southern House Wren
EG: Also Barn House to American Barn Owl
It should check scientific names against the past taxonomy to try to automatically set up the conversion, and THEN if we don't have it it can take input
This is happening in the function conform_taxonomy now, add case_whens and it will be a utility function that is applied to all the datasets.
Also, add information into the workflow README so that: If conform_taxonomy() stops the update because it's flagged that there's a common name in the historical data that is NOT present in the ebird data, eg. because taxonomy has changed for that species and been updated on ebird, add eg. "House Wren = Northern House Wren" to conform taxonomy
Taxonomy does not have a check for when taxonomy changes.
Taxon_in -> Taxon_out table to help with these changes. Something to automatically ID when a name on the last year's taxonomy is no longer present on this year's taxonomy, and update that taxon_in taxon_out table.