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 Please send the group the instructions you have on how to form the taxonMorphospecies.- taxonMorphospecies. _see also 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>