Re: [GENERAL] table of US states' neighbours

2008-03-28 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 connected state.

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

[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 be

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

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

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