1. Please correct the following in taxonMorphospecies:

1.1. Family should be included in taxonMorphospecies only if the resolved genus is null.
1.2. Remove Author from taxonMorphospecies. It should never be included. this is actually not the taxon name author, but the Unmatched_terms, which happen to be an unmatched author in some cases. to remove these, we would need to add a filter on the Unmatched_terms.

2. After that, please change the taxon validation csv extracts to provide the following information:

verbatim_name_with_author
tnrs_input_name
tnrs_taxonomic_status
tnrs_accepted_name_family
tnrs_accepted_name
tnrs_accepted_name_author
taxonMorphospecies (see #927)

see VegBank.tnrs_names.xls .

This format is similar to, but not exactly the same as the way you presented the data on for Salvias (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/TaxonMorphospecies_creation).

In the csv filename, please include the dataset name (VegBank, SALVIAS, Brian's pet plot).

3. Please send the group the instructions you have on how to form the taxonMorphospecies. see also formula in TNRS derived columns > scrubbed_morphospecies_binomial .

instructions for forming taxonMorphospecies:¶

from an e-mail from Brad:

# Reconstruct morphospecies using accepted names
UPDATE observations
SET morphospecies=
TRIM(
IF(acceptedSpecies IS NOT NULL,acceptedSpecies,
IF(acceptedGenus IS NOT NULL,CONCAT(acceptedGenus," ",unmatchedTerms),
IF(acceptedFamily IS NOT NULL,CONCAT(acceptedFamily," ",unmatchedTerms),
IF(unmatchedTerms IS NOT NULL,unmatchedTerms,nameSubmitted)
)
)
)
);