I need to consult with an expert to create this lookup table:
- extract the list of all common names from
art_1andart_2and their correspondingsort - consult with an expert to determine the correct species, taxon_id, record_type_name, record_type_id +/- record_type_description for each and record the information in a file (Strucke common names etc.xlsx)
- import the complete file into Shape Shifter
- choose the columns
species,common_name, `taxa_common_name_id
Note: there are many other tables that connect to taxa_tree_master in SEAD, but as most (all?) are not relevant for this dataset, I choose to re-use the image for taxa_common_names instead of displaying the full set