Gazeteer

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(cat)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
'''tblGazetteer''', shared across files, listing of names and the corresponding values in the preceding four tables, used with human data entry.  
+
'''tblGazetteer''', listing of names and the corresponding values in the preceding four tables, used with human data entry.
  
    ID, integer, 2 bytes, identifier for the name
+
*ID, integer, 4 bytes, identifier for the name
    Name, text, 50 byes maximum, place name (duplicates permitted)
+
*Name, text, 50 characters maximum, place name (duplicates permitted)
    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, = tblGeoLevel3.Level3ID
+
*Level3ID, character, 3 bytes, = tblGeoLevel3.Level3ID
    Level4ID, character, 3 bytes, = tblGeoLevel4.Level4ID
+
*Level4ID, character, 3 bytes, = tblGeoLevel4.Level4ID  
  
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]
 +
[[Category:Tables]]

Latest revision as of 10:00, 9 September 2012

tblGazetteer, listing of names and the corresponding values in the preceding four tables, used with human data entry.

  • ID, integer, 4 bytes, identifier for the name
  • Name, text, 50 characters maximum, place name (duplicates permitted)
  • Level1ID, character, 1 byte, = tblGeoLevel1.Level1ID
  • Level2ID, character, 1 byte, = tblGeoLevel2.Level2ID
  • Level3ID, character, 3 bytes, = tblGeoLevel3.Level3ID
  • Level4ID, character, 3 bytes, = tblGeoLevel4.Level4ID
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox