| 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: | Whole Thread | Raw Message | 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. ;-)
| 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 |