2 replies to this topic

[20 Ton Squirrel]

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!

[Dennis McClendon]

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.

[20 Ton Squirrel]

Thanks for your advice and for the useful links!