Insight Geo Data contains five layers. Each layer contains a set of shapes, except the Cities layer, which does not contain shape information. Each layer is stored in a separate table in the database and linked via IDs (Codes) to the top layer.

• Countries (Topmost layer):

  • Key: Code (ISO alpha-2)

• States

  • Key: Code

  • Link: States.CountryCode maps to Country.Code

• Counties

  • Key: Code

  • Link: Counties.StateId maps to States.Code

  • Link: Counties.CountryCode maps to Country.Code

• Cities

  • Key: Code

  • Link: Counties.StateCode maps to States.Code

  • Link: Counties.Country maps to Country.Code

  • Also contains Long/Lat

• ZipCodes

  • Key: Code

  • Link: ZipCodes.CountyId maps to Counties.Code

  • Link: ZipCodes.StateId maps to States.Code

  • Link: ZipCodes.CountryCode maps to Country.Code

  • Also contains Long/Lat