Re: standard schemas for addresses, others?

On Thu, Jan 23, 2003 at 07:53:18AM -0600, Bruno Wolff III wrote:
> On Wed, Jan 22, 2003 at 14:18:47 -0800,
> Dennis Gearon <gearond(at)cvc(dot)net> wrote:
> > Are there any sites with 'standard schemas' for certain, repetitive database needs? For
> > example, addresses and their components. Does anyone have a schema for addresses that will
> > work for the USA *AND* internation addresses?
> >
> > entities
> > ----------
> > Countries
> > States
> > Counties
> > Cities
> > street addresess.
> > Postal Codes
> >
> > Some rules:
> > -------------
> > A/ Do duplicate countries
> > B/ No duplicate states in Countries
> > (states seem only to exist in 'Federal' governments)
> > C/ No duplicate postal codes in Countries
> > D/ Duplicate cities are allowed in Countries,
> > and in the world.
> > E/ Duplicate cities are allowed in States.

but no duplicate cities per county. (right?)

> > F/ Cities can have multiple postal codes
> > G/ Postal codes are assigned to only one city.

maybe not. double-check that.

> > H/ Postal codes are assigned to counties.

for sparsely-populate counties i'd bet that one zip code can
cover a lot of area, maybe even crossing county boundaries.

> The post office has information on US addresses. They are more
> complicated than you might think. Puerto Rico especially.
> Note that 5 digit zip codes can span states.

really? that's just plain mean. (at least it backs up the
cross-county theory i whipped up, above.)

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !