GeoLevel3

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(added content)
Line 1: Line 1:
'''tblGeoLevel3''', shared across files, country or portion of large country.  From World Geographical Scheme for Recording Plant Distributions, Plant Taxonomic Database Standards No. 2. Edition 2.
+
'''tblGeoLevel3''', country or portion of large country.  From World Geographical Scheme for Recording Plant Distributions, Plant Taxonomic Database Standards No. 2. Edition 2.
  
    Index3, integer, 2 bytes, = 2000 * Level1ID + 100 * (Level2ID + 1) + sequence number of Level3ID in alphabetic order among rows with the same Level1ID and Level2ID.  When Level3ID = "---", the sequence number is treated as 0.
+
*Index3, integer, 4 bytes, = 2000 * Level1ID + 100 * (Level2ID + 1) + sequence number of Level3ID in alphabetic order among rows with the same Level1ID and Level2ID.  When Level3ID = "---", the sequence number is treated as 0.
    Level1ID, character, 1 byte, = tblGeoLevel1.Level1ID
+
*Level1ID, character, 1 byte, = tblGeoLevel1.Level1ID
    Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
+
*Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
    Level3ID, character, 3 bytes, identifier for "country" within region
+
*Level3ID, character, 3 bytes, identifier for "country" within region
    Name, text, 50 bytes maximum, name for the region
+
*Name, text, 50 characters maximum, name for the region
    ExpandedName, text 100 bytes maximum, includes identifying name (usually tblGeoLevel2.Name) before tblGeoLevel3.Name
+
*ExpandedName, text 100 bytes maximum, includes identifying name (usually tblGeoLevel2.Name) before tblGeoLevel3.Name
    BitValue, integer, 4 bytes, value of the bit that indicates this level 3 area
+
*BitValue, integer, 4 bytes, value of the bit that indicates this level 3 area
  
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]

Revision as of 11:07, 29 August 2012

tblGeoLevel3, country or portion of large country. From World Geographical Scheme for Recording Plant Distributions, Plant Taxonomic Database Standards No. 2. Edition 2.

  • Index3, integer, 4 bytes, = 2000 * Level1ID + 100 * (Level2ID + 1) + sequence number of Level3ID in alphabetic order among rows with the same Level1ID and Level2ID. When Level3ID = "---", the sequence number is treated as 0.
  • Level1ID, character, 1 byte, = tblGeoLevel1.Level1ID
  • Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
  • Level3ID, character, 3 bytes, identifier for "country" within region
  • Name, text, 50 characters maximum, name for the region
  • ExpandedName, text 100 bytes maximum, includes identifying name (usually tblGeoLevel2.Name) before tblGeoLevel3.Name
  • BitValue, integer, 4 bytes, value of the bit that indicates this level 3 area
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox