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.
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2008-03-28 15:12:29|
|Subject: Re: Users, groups and inheritance questions |
|Previous:||From: carty mc||Date: 2008-03-28 14:51:28|
|Subject: creating a trigger to access another postgres database?|