From: Tim Perdue <tim@perdue.net>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Latitude / Longitude
Date: Thu, 12 Sep 2002 12:44:26 -0500
Message-ID: <20020912124426.A27570@mail.perdue.net> (raw)
Hi Folks -
I'm working on a global weather database for a client and have hit an issue
which I'm sure has been solved before. Unfortunately, the site search doesn't
pull up anything.
Essentially, I've got two tables, one with city/county/lat/long and another
with lat/long/weather data.
None of the lat/longs in the two tables match up directly, so I can't do a
simple join of the two tables. I need to join on closest proximity on the
lat/long fields.
Any suggestions? It seems to me this will be pretty expensive on CPU resources
unless there's a really elegant trick uncovered.
Tim
--
Founder - PHPBuilder.com / Geocrawler.com / SourceForge
GPG Public Key: http://www.perdue.net/personal/pgp.php
Perdue, Inc. / Immortal LLC
515-554-9520
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tim@perdue.net, pgsql-general@postgresql.org
Subject: Re: Latitude / Longitude
In-Reply-To: <20020912124426.A27570@mail.perdue.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox