As a user I need to enhance scientific name data

[dimus]

scientificName field might contain a full name or a canonical form, while authorship is in a separate column. It is useful to have additional fields, here are some ideas:

scientificNameString - usually with authorship, however, if authorship cannot be found, no authorship. So the idea is -- this field contains the most 'full' name we can come up with.

canonicalForm - scientific name with no authorship, no ranks, no hybrid signs (unless it is a hybrid formula).

canonicalFormFull - canonical form with ranks and hybrid signs

canonicalFormStem - canonical form stemmed. No ranks, no hybrid signs (unless it is a hybrid formula).

We take a significant subset of rows and check if scientificName has authorship. If yes, we consider scientificName equal to scientificNameString if not, we generate scientificNameString by combining scientificName and scientificNameAuthorship fields.

We generate canonical forms by parsing scientificName or scientiricNameString