Distribution (table)

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m (Maehr moved page Distribution to Distribution (table) without leaving a redirect: Needed change to distinguish between other uses of distribution.)
m
 
Line 2: Line 2:
  
 
*TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
 
*TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
*Level1ID, character, 1 byte, = tblGeoLevel2.Level1ID
+
*[[GeoLevel1|Level1ID]], character, 1 byte, = tblGeoLevel2.Level1ID
*Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
+
*[[GeoLevel2|Level2ID]], character, 1 byte, = tblGeoLevel2.Level2ID
 
*AreaFlags, integer, 4 bytes, interpreted bitwise to indicate presence in geographic areas as defined in tblGeoLevel1, tblGeoLevel2 and tblGeoLevel3.  If no flag is on, the row is not recorded.
 
*AreaFlags, integer, 4 bytes, interpreted bitwise to indicate presence in geographic areas as defined in tblGeoLevel1, tblGeoLevel2 and tblGeoLevel3.  If no flag is on, the row is not recorded.
 
*ShadeFlags, integer, 2 bytes, interpreted bitwise to indicate map shading needed, applies only at levels 1 and 2 where specifications for level 2 or 3 might make the level 1 or 2 shading not wanted.
 
*ShadeFlags, integer, 2 bytes, interpreted bitwise to indicate map shading needed, applies only at levels 1 and 2 where specifications for level 2 or 3 might make the level 1 or 2 shading not wanted.

Latest revision as of 13:47, 15 March 2013

tblDistribution contains recorded occurrences in geographic areas.

  • TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
  • Level1ID, character, 1 byte, = tblGeoLevel2.Level1ID
  • Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
  • AreaFlags, integer, 4 bytes, interpreted bitwise to indicate presence in geographic areas as defined in tblGeoLevel1, tblGeoLevel2 and tblGeoLevel3. If no flag is on, the row is not recorded.
  • ShadeFlags, integer, 2 bytes, interpreted bitwise to indicate map shading needed, applies only at levels 1 and 2 where specifications for level 2 or 3 might make the level 1 or 2 shading not wanted.
  • Status, integer, 1 byte
    • 0 = no data (does not occur, row is absent)
    • 1 = known incomplete
    • 2 = may be incomplete
    • 3 = includes known distribution
  • 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