Re: Postal code radius searches

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postal code radius searches
Date: 2002-02-15 03:46:51
Message-ID: 20020214214651.C6113@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 06, 2002 at 02:47:14PM -0500, P.J. Josh Rovero wrote:
> Simpler math helps -- for example all zip codes within a
> certain (whole or fractional) degrees lat and long of
> another zip is an easy and fast calculation, as it's just
> addition/subtraction. You get a cell or box around the
> center zip.

isn't it a bit more complicated than that?

for example, chicago is where you'll find 60606 but gary
indiana, barely 30 miles away, is 46407. zipcodes are
one-dimensional (00000 to 99999) but the geography is
two-dimensional (north/south, east/west on a mercator-projection
map) or three-dimensional (latitude, longitude[, radius] on the
surface of an oblate spheroid).

--
DEBIAN NEWBIE TIP #61 from Hamma Scott <scott_hamma(at)yahoo(dot)com>
:
Ever have troubles with EITHER X OR CONSOLE LOCKUP? If your
session is hung you can type <CTRL><ALT>F2-F6 to get to another
login session. This way, you can shut your machine down
properly, or kill whichever process is causing trouble (use "ps
axf" to see them all).

Also see http://newbieDoc.sourceForge.net/ ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre' Blanchard 2002-02-15 04:31:52 How to properly build postgresql version 7.2 on Unix Platforms?
Previous Message Samik Raychaudhuri 2002-02-15 03:31:06 Pg.so problem