From: Larry Rosenman <ler@lerctr.org>
To: Tim Perdue <tim@perdue.net>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Latitude / Longitude
Date: 12 Sep 2002 12:49:21 -0500
Message-ID: <1031852961.380.20.camel@lerlaptop.iadfw.net> (raw)
In-Reply-To: <20020912124426.A27570@mail.perdue.net>
References: <20020912124426.A27570@mail.perdue.net>
Look at contrib/earthdistance, I **think** it does what you need.
LER
On Thu, 2002-09-12 at 12:44, Tim Perdue wrote:
> 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
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
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: ler@lerctr.org, tim@perdue.net, pgsql-general@postgresql.org
Subject: Re: [SQL] Latitude / Longitude
In-Reply-To: <1031852961.380.20.camel@lerlaptop.iadfw.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