Re: Postal code radius searches - Mailing list pgsql-general

From will trillich
Subject Re: Postal code radius searches
Date
Msg-id 20020214214651.C6113@serensoft.com
Whole thread Raw
In response to Re: Postal code radius searches  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
List 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@yahoo.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/ ...

pgsql-general by date:

Previous
From: Samik Raychaudhuri
Date:
Subject: Pg.so problem
Next
From: "Andre' Blanchard"
Date:
Subject: How to properly build postgresql version 7.2 on Unix Platforms?