Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
  1. Are the following geographic hierarchies correct?

  2. Do any US/Canadian area codes cross state/province lines?

  3. Do any US/Canadian counties cross state/province lines?

  4. Are there countries with counties but no principal country divisions (states/provinces)?

Zip / Postal Codes

US Style

Continent > Country > State/Province > Postal/Zip

UK Style

Continent > Country > Postal Code

Towns / Cities

US Style

Continent > Country > State/Province > City

UK Style

Continent > Country > City

Area Codes

US Style

Continent > Country > State/Province > Area Code

UK Style

Continent > Country > Area Code


US Style

Continent > Country > State/Province > County

UK Style

Continent > Country > County

share|improve this question
I've been out of the postal game for a few years but I do believe there were US postal codes that crossed state boundaries. Sorry I can't be more specific on that front, I only have a hazy recollection of the incident –  billinkc Jul 10 '13 at 20:57
Maybe you'd get better traction at GIS –  swasheck Jul 10 '13 at 21:04
@swasheck should I delete this question here, or should I post on both? thx –  Neil McGuigan Jul 10 '13 at 21:38
I don't know how U.S. post codes work but UK post codes go something like 'Area' (SW), 'District' (SW20), 'Sector' (SW20 8), 'Postcode' (SW20 8RX). I don't think it's directly related to counties. –  ConcernedOfTunbridgeWells Jul 10 '13 at 21:47

1 Answer 1

To answer at least some of this:

  1. Area codes do cross state boundaries in rare cases. There is a tiny bit of the Oregon 541 area code that is shared with California:

  1. Zip codes do very rarely cross state boundaries, or have really odd zip code assignments compared to their geographical assignments. One example being 65733 in Arkansas and Missouri, where a few remote places are served by the 65733 Missouri Zip code:

  1. New Zealand used to have only counties, when they abolished provinces in the 1800's, and now a lot of them have merged into districts. Denmark also changed from counties to regions as well, without any provinces. Norway and Hungary are two more examples of a hop from country to county. There's a lot of fascinating pages on Wikipedia regarding counties and other administrative divisions:

  1. There are certainly odd cases that would be hard to fit into the hierarchies you've outlined above. China, for example, has prefectural level cities that are below a province and above a county in their administrative division hierarchy. I'm not sure how much effort you would want to go through to make these generic by country, though.

Hope that helps answer your question. =)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.