Re: table of US states' neighbours

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: brian <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: table of US states' neighbours
Date: 2008-03-27 22:00:57
Message-ID: 47EC1919.4020401@denterprises.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

brian wrote:
> I'd like to add a table, state_neighbours, which joins each state with
> all of its neighbour states. Does anyone know where I can find such a list?
>
> I'm not interested in "nearest neighbour", just any connected state.

That sounds like something you could create in 20 minutes with a map.

> eg. IA would be associated with {MN,WS,IL,MO,KS,NB,SD} and HI & AK would
> not be represented.

I think you mean {MN, WI, IL, MO, NE, SD}.

Colin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brian 2008-03-27 22:04:57 Re: table of US states' neighbours
Previous Message Zdenek Kotala 2008-03-27 21:31:15 Re: Survey: renaming/removing script binaries (createdb, createuser...)