Search Postgresql Archives

Re: table of US states' neighbours

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Broersma wrote:
On Thu, Mar 27, 2008 at 11:33 PM, Michael Fuhr <mike@xxxxxxxx> 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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux