Gazeteer

tblGazetteer, shared across files, 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 Name, text, 50 byes 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