upgrade taxonomy using TaxonOccurence Spreadsheet (aka Cover_ver4_withCBS)
Could be Weakley 06 or 07.
#1 Updated by Michael Lee about 12 years ago
After migrating old archive database into the new one, Michael will use the TaxonOccurence Spreadsheet (aka Cover_ver4_withCBS) to upgrade taxonomy from what it was in the old database to new Weakley taxonomy. Matching old names may be tricky for projects 59 and 61, which were upgraded in the spreadsheet BEFORE SAS was completed.
#5 Updated by Michael Lee over 11 years ago
All projects through 61 have new interpretations, all pointing to something in our standard list, which is almost entirely Weakley 2006 (there are a few weird things). 2 plots (25-3-114 and 50-1-100) had no list of species in the excel spreadsheet, so these are not updated yet, but could be using the rules spreadsheet with a little more work.
There are still projects in this spreadsheet higher than project 61. These interpretations may be useful as we add in the new data, but it will be difficult to map the species, as updates have been made to the various entry tools after the spreadsheet was made. It also doesn't solve the data that will be collected later than now and will need pointing to the correct species/species aggregate in Weakley. A more generic solution needs to be created, probably with rules embedded in the entry tool or viewer or even archive to map species names correctly, depending on the taxonomic standard of each plot.
#6 Updated by Michael Lee over 11 years ago
the following ranks are implemented in the database:
composite variety 10.1
composite subspecies 17.1
Species Aggregate 21
composite species 20.1
composite genus 40.1
composite family 60.1
parents are identified for all species, as well, and additionally, the lowest rank of any direct children is specified. This assists in figuring out if a species has valid subspecies, etc.