Postgres Pro
Downloads
Home   >   mailing lists

Thread: table of US states' neighbours

table of US states' neighbours

From
brian
Date:
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.

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

Re: table of US states' neighbours

From
Colin Wetherbee
Date:
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

Re: table of US states' neighbours

From
Erik Jones
Date:
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®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

Re: table of US states' neighbours

From
brian
Date:
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. ;-)

Re: table of US states' neighbours

From
Michael Fuhr
Date:
On Thu, Mar 27, 2008 at 06:00:57PM -0400, 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.

Or a few minutes with shapefiles and PostGIS, using the latter's
spatial functions to identify geometries that touch.  Below are the
results of such an operation; I haven't verified the entire list
but I did check a few and they were correct.

AL|{FL,GA,MS,TN}
AR|{LA,MO,MS,OK,TN,TX}
AZ|{CA,CO,NM,NV,UT}
CA|{AZ,NV,OR}
CO|{AZ,KS,NE,NM,OK,UT,WY}
CT|{MA,NY,RI}
DC|{MD,VA}
DE|{MD,NJ,PA}
FL|{AL,GA}
GA|{AL,FL,NC,SC,TN}
IA|{IL,MN,MO,NE,SD,WI}
ID|{MT,NV,OR,UT,WA,WY}
IL|{IA,IN,KY,MI,MO,WI}
IN|{IL,KY,MI,OH}
KS|{CO,MO,NE,OK}
KY|{IL,IN,MO,OH,TN,VA,WV}
LA|{AR,MS,TX}
MA|{CT,NH,NY,RI,VT}
MD|{DC,DE,PA,VA,WV}
ME|{NH}
MI|{IL,IN,MN,OH,WI}
MN|{IA,MI,ND,SD,WI}
MO|{AR,IA,IL,KS,KY,NE,OK,TN}
MS|{AL,AR,LA,TN}
MT|{ID,ND,SD,WY}
NC|{GA,SC,TN,VA}
ND|{MN,MT,SD}
NE|{CO,IA,KS,MO,SD,WY}
NH|{MA,ME,VT}
NJ|{DE,NY,PA}
NM|{AZ,CO,OK,TX,UT}
NV|{AZ,CA,ID,OR,UT}
NY|{CT,MA,NJ,PA,VT}
OH|{IN,KY,MI,PA,WV}
OK|{AR,CO,KS,MO,NM,TX}
OR|{CA,ID,NV,WA}
PA|{DE,MD,NJ,NY,OH,WV}
RI|{CT,MA}
SC|{GA,NC}
SD|{IA,MN,MT,ND,NE,WY}
TN|{AL,AR,GA,KY,MO,MS,NC,VA}
TX|{AR,LA,NM,OK}
UT|{AZ,CO,ID,NM,NV,WY}
VA|{DC,KY,MD,NC,TN,WV}
VT|{MA,NH,NY}
WA|{ID,OR}
WI|{IA,IL,MI,MN}
WV|{KY,MD,OH,PA,VA}
WY|{CO,ID,MT,NE,SD,UT}

--
Michael Fuhr

Re: table of US states' neighbours

From
brian
Date:
Michael Fuhr wrote:
> On Thu, Mar 27, 2008 at 06:00:57PM -0400, 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.
>
> Or a few minutes with shapefiles and PostGIS, using the latter's
> spatial functions to identify geometries that touch.  Below are the
> results of such an operation; I haven't verified the entire list
> but I did check a few and they were correct.


Brilliant, thanks. Yes the PostGIS angle is why i asked on this list. I
figured that this info must be readily available. Now google will pick
it up for the next bloke.


> AL|{FL,GA,MS,TN}
> AR|{LA,MO,MS,OK,TN,TX}
> AZ|{CA,CO,NM,NV,UT}
> CA|{AZ,NV,OR}
> CO|{AZ,KS,NE,NM,OK,UT,WY}
> CT|{MA,NY,RI}
> DC|{MD,VA}
> DE|{MD,NJ,PA}
> FL|{AL,GA}
> GA|{AL,FL,NC,SC,TN}
> IA|{IL,MN,MO,NE,SD,WI}
> ID|{MT,NV,OR,UT,WA,WY}
> IL|{IA,IN,KY,MI,MO,WI}
> IN|{IL,KY,MI,OH}
> KS|{CO,MO,NE,OK}
> KY|{IL,IN,MO,OH,TN,VA,WV}
> LA|{AR,MS,TX}
> MA|{CT,NH,NY,RI,VT}
> MD|{DC,DE,PA,VA,WV}
> ME|{NH}
> MI|{IL,IN,MN,OH,WI}
> MN|{IA,MI,ND,SD,WI}
> MO|{AR,IA,IL,KS,KY,NE,OK,TN}
> MS|{AL,AR,LA,TN}
> MT|{ID,ND,SD,WY}
> NC|{GA,SC,TN,VA}
> ND|{MN,MT,SD}
> NE|{CO,IA,KS,MO,SD,WY}
> NH|{MA,ME,VT}
> NJ|{DE,NY,PA}
> NM|{AZ,CO,OK,TX,UT}
> NV|{AZ,CA,ID,OR,UT}
> NY|{CT,MA,NJ,PA,VT}
> OH|{IN,KY,MI,PA,WV}
> OK|{AR,CO,KS,MO,NM,TX}
> OR|{CA,ID,NV,WA}
> PA|{DE,MD,NJ,NY,OH,WV}
> RI|{CT,MA}
> SC|{GA,NC}
> SD|{IA,MN,MT,ND,NE,WY}
> TN|{AL,AR,GA,KY,MO,MS,NC,VA}
> TX|{AR,LA,NM,OK}
> UT|{AZ,CO,ID,NM,NV,WY}
> VA|{DC,KY,MD,NC,TN,WV}
> VT|{MA,NH,NY}
> WA|{ID,OR}
> WI|{IA,IL,MI,MN}
> WV|{KY,MD,OH,PA,VA}
> WY|{CO,ID,MT,NE,SD,UT}
>

Re: table of US states' neighbours

From
"Richard Broersma"
Date:
On Thu, Mar 27, 2008 at 11:33 PM, Michael Fuhr <mike@fuhr.org> wrote:
> On Thu, Mar 27, 2008 at 06:00:57PM -0400, Colin Wetherbee wrote:
>  > brian wrote:
>  Or a few minutes with shapefiles and PostGIS, using the latter's
>  spatial functions to identify geometries that touch.  Below are the
>  results of such an operation; I haven't verified the entire list
>  but I did check a few and they were correct.
>
>  AL|{FL,GA,MS,TN}
>  AR|{LA,MO,MS,OK,TN,TX}
>  AZ|{CA,CO,NM,NV,UT}

Where is Hawaii and Alaska? :o)


--
Regards,
Richard Broersma Jr.

Re: table of US states' neighbours

From
Colin Wetherbee
Date:
Richard Broersma wrote:
> On Thu, Mar 27, 2008 at 11:33 PM, Michael Fuhr <mike@fuhr.org> wrote:
>>  Or a few minutes with shapefiles and PostGIS, using the latter's
>>  spatial functions to identify geometries that touch.  Below are the
>>  results of such an operation; I haven't verified the entire list
>>  but I did check a few and they were correct.
>>
>>  AL|{FL,GA,MS,TN}
>>  AR|{LA,MO,MS,OK,TN,TX}
>>  AZ|{CA,CO,NM,NV,UT}
>
> Where is Hawaii and Alaska? :o)

The OP said he didn't want HI and AK in the list since they don't
touch other states.

Colin