Take the 2-minute tour ×
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

Your Answer


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

Browse other questions tagged or ask your own question.