Re: [GENERAL] table of US states' neighbours

2008-03-28 Thread Colin Wetherbee
Richard Broersma wrote: On Thu, Mar 27, 2008 at 11:33 PM, Michael Fuhr <[EMAIL PROTECTED]> 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 li

Re: [GENERAL] table of US states' neighbours

2008-03-28 Thread Richard Broersma
On Thu, Mar 27, 2008 at 11:33 PM, Michael Fuhr <[EMAIL PROTECTED]> 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 >

Re: [GENERAL] table of US states' neighbours

2008-03-28 Thread brian
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

Re: [GENERAL] table of US states' neighbours

2008-03-27 Thread Michael Fuhr
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 connec

Re: [GENERAL] table of US states' neighbours

2008-03-27 Thread Erik Jones
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 sou

Re: [GENERAL] table of US states' neighbours

2008-03-27 Thread brian
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 cr

Re: [GENERAL] table of US states' neighbours

2008-03-27 Thread Colin Wetherbee
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

[GENERAL] table of US states' neighbours

2008-03-27 Thread brian
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 b