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. ;-)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general