Re: table of US states' neighbours

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

Colin Wetherbee wrote:
> 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.

I won't argue that but if there's a list available somewhere that would
be easier.

>> 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}.
>

Hence the reason I wondered if someone already had this compiled. ;-)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2008-03-27 22:11:10 Re: table of US states' neighbours
Previous Message Colin Wetherbee 2008-03-27 22:00:57 Re: table of US states' neighbours