Re: table of US states' neighbours - Mailing list pgsql-general

From Colin Wetherbee
Subject Re: table of US states' neighbours
Date
Msg-id 47ED2179.4010109@denterprises.org
Whole thread Raw
In response to Re: table of US states' neighbours  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Delete after trigger fixing the key of row numbers
Next
From: Chris Mayfield
Date:
Subject: Re: Merge Joins and Views