Distribution (table)
From Species File Help
(Difference between revisions)
(created page) |
|||
Line 1: | Line 1: | ||
− | '''tblDistribution''' contains recorded | + | '''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 | ||
[[Category:TaxaTables]] | [[Category:TaxaTables]] |
Revision as of 16:24, 29 August 2012
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