Standard geographic hierarchy

20 Ton Squirrel

Posted 08 May 2012 - 12:36 PM

20 Ton Squirrel

Newbie

Validated Member

6 posts

United States

I have several tables separated by country where, between them, only the geography definitions differ. I'd like to merge this data into a single table. I am curious if there is an "industry standard" in defining this sort of thing?

I had in mind to make the hierarchy something like…
Market -> Country -> Region -> Area -> City