Task #915
Updated by Aaron Marcuse-Kubitza over 10 years ago
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":http://fs.vegpath.org/inputs/VegBank/verify/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 formula in [[TNRS derived columns#scrubbed_morphospecies_binomial]] > @scrubbed_morphospecies_binomial@ ._
h3(. instructions for forming taxonMorphospecies:
p((. from an "e-mail from Brad":mailto:bboyleATemail.arizona.edu?Brad_Boyle.2013-2-8-12:41PT.Modification+to+use+of+TNRS+for+scrubbing+BIEN+names.(Modifications+to+procedure+to+scrubbing+names+using+TNRS.docx)#page=4:
<pre><code class="SQL">
# 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)
)
)
)
);
</code></pre>