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

Re: table of US states' neighbours

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: brian <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: table of US states' neighbours
Date: 2008-03-27 22:00:57
Message-ID: 47EC1919.4020401@denterprises.org (view raw or flat)
Thread:
Lists: pgsql-general
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.

> eg. IA would be associated with {MN,WS,IL,MO,KS,NB,SD} and HI & AK would 
> not be represented.

I think you mean {MN, WI, IL, MO, NE, SD}.

Colin

In response to

Responses

pgsql-general by date

Next:From: brianDate: 2008-03-27 22:04:57
Subject: Re: table of US states' neighbours
Previous:From: Zdenek KotalaDate: 2008-03-27 21:31:15
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group