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/ ...
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 |