Taxa (table)

From Species File Help
(Difference between revisions)
Jump to: navigation, search
Line 24: Line 24:
 
***Species, then = tblTaxa.TaxonNameID of subspecies by same name
 
***Species, then = tblTaxa.TaxonNameID of subspecies by same name
 
***Subspecies, then = tblTaxa.TaxonNameID of species by same name
 
***Subspecies, then = tblTaxa.TaxonNameID of species by same name
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus is synonym, then the value of Extinct is ignored.  Could be changed to allow additional values such as threatened, endangered and presumed extirpated.
+
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored.  Could be changed to allow additional values such as threatened, endangered and presumed extirpated.
 
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored.  This will be implemented during summer, 2013.
 
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored.  This will be implemented during summer, 2013.
 
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored.  This will be implemented during summer, 2013.
 
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored.  This will be implemented during summer, 2013.

Revision as of 09:33, 10 July 2013

tblTaxa contains taxon names at all ranks, including synonyms and other non valid names.

  • TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.
  • FileID, integer, 4 bytes, = tblFiles.FileID
  • TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-".
    • If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.
    • If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".
    • For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.
    • The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).
    • For all taxa outside the primary scope, TaxonNameStr begins with "0-".
      • For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.
      • For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.
      • For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.
      • For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.
      • For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".
  • RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy
  • Name, text, 30 characters maximum, name of taxon
  • Parens, boolean, enclose author name in parens?
  • AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.
  • LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are
    • Valid or temporary taxa
      • Genus, then = tblTaxa.TaxonNameID of subgenus by same name
      • Subgenus, then = tblTaxa.TaxonNameID of genus by same name
      • Species, then = tblTaxa.TaxonNameID of subspecies by same name
      • Subspecies, then = tblTaxa.TaxonNameID of species by same name
  • Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.
  • HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored. This will be implemented during summer, 2013.
  • HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored. This will be implemented during summer, 2013.
  • RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.
  • NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information
  • DataFlags, integer, 2 bytes, with bitwise flags for type of data present
    • 1 = image
    • 2 = sound
    • 4 = link to other website
    • 8 = specimen data
    • 0x10 (16) = scrutiny
    • 0x20 (32) = key group
    • 0x40 (64) = supplementary information
    • 0x80 (128) = common name
    • 0x100 (256) = related taxon
    • 0x200 (512) = automatic link to other website
    • 0x400 (1024) = ecological relationship
    • 0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)
    • 0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower
  • AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode
  • NameStatus, integer, 1 byte
    • 0 = valid
    • 2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)
    • 4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)
    • 5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)
    • 7 = synonym (subordinate taxa not allowed)
  • StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.
    • 1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.
    • 2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.
    • 4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.
    • 8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.
    • 0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.
    • 0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.
    • 0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.
    • 0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.
    • 0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.
    • 0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.
    • 0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.
    • 0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.
    • 0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.
    • 0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.
    • 0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.
    • 0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.
    • 0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.
    • 0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.
    • 0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.
    • 0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.
    • 0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.
    • 0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.
    • 0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.
    • 0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.
    • 0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.
    • 0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.
    • The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.
      • 0x1000 senior homonym (opposite junior homonym)
      • 0x2000 correct not replaced (opposite unnecessary replacement)
      • 0x4000 correct not emended (opposite unjustified emendation)
      • 0x8000 correct as spelled (opposite subsequent misspelling)
      • 0x10000 misapplied to (opposite misapplied)
      • 0x20000 correct usage of misapplied (opposite misapplied)
    • Notes about StatusFlags.
      • Type data for taxa is available based on rank and name status:
        • No type data for ranks above superfamily.
        • No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).
        • No type data for ranks above species and below subgenus.
        • No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).
      • Age qualification is required for the following NameStatus values:
        • Junior synonym must not be older than the valid name.
        • Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.
        • Incorrectly formed name must not be younger than the justified emendation name.
        • Nomen novum must not be younger than the homonym replaced.
        • Nomen oblitum must not be younger than the valid name.
      • Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:
        • Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.
        • Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.
        • Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.
        • Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.
        • Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.
        • Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.
        • Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.
        • Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.
  • UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.
    • 1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7
    • 2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7
    • 4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent
    • 8 = suppressed, compatible only with tblTaxa.NameStatus = 7
    • 0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7
    • 0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7
    • 0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7
    • 0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7
    • 0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7
    • 0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7
  • OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.
  • Distribution, text, 400 characters maximum.
  • Ecology, text, 400 characters maximum.
  • Comment, text, 400 characters maximum, explanation relating to the status of the name.
  • ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon
  • ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography
    • When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.
  • CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.
  • LifeZone, integer, 1 byte, bit values:
    • 1 = Marine
    • 2 = Brackish
    • 4 = Freshwater
    • 8 = Terrestrial
  • LastUpdate, smalldatetime, date and time row last updated
  • ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
  • CreatedOn, smalldatetime, date and time row was created
  • CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox