Bug Fix log
USCH and CLEMS Specify 6 Botany Taxon Tree

2010-04-21 Taxon - IsAccepted values updated for synonyms

Values for IsAccepted were changed to 'NULL' for all synonyms (i.e. any taxon name where AcceptedID=NOT NULL). This will ensure that preferred taxon names are displayed on determinations using synonymized names. Note from Specify 6 users' manual:

Users of previous versions (prior to April 21, 2010) of the USCH and CLEMS Specify 6 Botany Taxon Tree will need to download the file UPDATE-to_make_preffered_taxon_work.mdb. Then within MS Access use an ODBC connection to your MySQL database and import the update query. Once imported, the update query can be run to update the Taxon table.

2010-03-08 TaxonTreeDefItem - FullNameSeparator values updated

Values for FullNameSeparator were changed to a single space for all taxonomic ranks. This will ensure that binomial combinations will be separated by a space when concatenated (e.g. they will appear as Genus species instead of Genusspecies)

Special thanks to Steve Baskauf of Vanderbilt University for finding this issue.

2010-03-05 TaxonTreeDefItem - IsEnforced and IsInFullName values updated

Values for IsEnforced were changed to Null for several taxonomic ranks allowing more flexibility when chosing ranks for new names added to the tree.

TaxonTreeDefItemID Name RankID IsEnforced-old IsEnforced-new IsInFullName-old IsInFullName-new
1 Life 0 -1 1 -1 NULL
2 Kingdom 10 -1 1 -1 NULL
3 Subkingdom 20 -1 NULL -1 NULL
4 Division 30 -1 1 -1 NULL
5 Subdivision 40 -1 NULL -1 NULL
6 Class 60 -1 1 -1 NULL
7 Subclass 70 -1 NULL -1 NULL
8 Order 100 -1 1 -1 NULL
9 Suborder 110 -1 NULL -1 NULL
10 Family 140 -1 1 -1 NULL
11 Subfamily 150 -1 NULL -1 NULL
12 Tribe 160 -1 NULL -1 NULL
13 Subtribe 170 -1 NULL -1 NULL
14 Genus 180 -1 1 -1 1
15 Subgenus 190 -1 NULL -1 NULL
16 Section 200 -1 NULL -1 NULL
17 Subsection 210 -1 NULL -1 NULL
18 Species 220 -1 1 -1 1
19 Subspecies 230 -1 NULL -1 NULL
20 Variety 240 -1 NULL -1 NULL
21 Subvariety 250 -1 NULL -1 NULL
22 Forma 260 -1 NULL -1 NULL
23 Subforma 270 -1 NULL -1 NULL