Skip site navigation (1) Skip section navigation (2)

Re: table of US states' neighbours

From: Erik Jones <erik(at)myemma(dot)com>
To: Colin Wetherbee <cww(at)denterprises(dot)org>
Cc: brian <brian(at)zijn-digital(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: table of US states' neighbours
Date: 2008-03-27 22:11:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Mar 27, 2008, at 5:00 PM, 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.
>> 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}.

Sounds like your 2% there!

Erik Jones

DBA | Emma®
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at

In response to

pgsql-general by date

Next:From: Sam MasonDate: 2008-03-27 22:17:27
Subject: Re: dunction issue
Previous:From: brianDate: 2008-03-27 22:04:57
Subject: Re: table of US states' neighbours

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group