Gazeteer

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