Jump to content

 
Photo

Standard geographic hierarchy

- - - - -

  • Please log in to reply
2 replies to this topic

#1
20 Ton Squirrel

20 Ton Squirrel

    Newbie

  • Validated Member
  • Pip
  • 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

For example:
• North America -> USA -> Southwest -> Harris County -> Houston
• Asia -> China -> East -> Jiangxi Province -> Xinyu
• Europe -> UK -> South -> London Area -> Beckenham

Any advice would be greatly appreciated, hopefully I'm not being too vague!

#2
Dennis McClendon

Dennis McClendon

    Hall of Fame

  • Validated Member
  • PipPipPipPipPipPipPip
  • 1,083 posts
  • Gender:Male
  • Location:Chicago
  • Interests:map design, large-scale maps of cities
  • United States

I don't think you'll find any standardization outside political divisions, as shown in this Wikipedia table or this article about ISO 3166-2. Natural Earth and perhaps others have indicated countries as Admin-0.

Obviously you could insert your own regions in between as admin-1.5 or the like, but it's probably smarter to use a label such as Sales Regions that makes sense to you and your colleagues.
Dennis McClendon, Chicago CartoGraphics
chicagocarto.com

#3
20 Ton Squirrel

20 Ton Squirrel

    Newbie

  • Validated Member
  • Pip
  • 6 posts
  • United States

Thanks for your advice and for the useful links!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->