Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: table of US states' neighbours



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group