| From: | Colin Wetherbee <cww(at)denterprises(dot)org> |
|---|---|
| To: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, brian <brian(at)zijn-digital(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: table of US states' neighbours |
| Date: | 2008-03-28 16:48:57 |
| Message-ID: | 47ED2179.4010109@denterprises.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teemu Juntunen, e-ngine | 2008-03-28 17:48:12 | VS: Delete after trigger fixing the key of row numbers |
| Previous Message | Chris Mayfield | 2008-03-28 16:41:04 | Re: Merge Joins and Views |