From: Tamir Halperin <tamir@brobus.net>
To: Michael A Nachbaur <mike@nachbaur.com>
To: Ryan <pgsql-sql@seahat.com>
To: rudi@oasis.net.au
Cc: pgsql-sql@postgresql.org
Subject: Re: Off topic : world database
Date: Wed, 26 Mar 2003 20:33:21 -0500
Message-ID: <985DF46E87E0C047A3670048DBCAD0556BCD@andrew.brobus.net> (raw)
I would imagine that since neither the size of the earth, nor the laws of mathematics and geometry have any scheduled changes pending for their source code any time in the near future, it's reasonable to rely on the long/lat information and extrapolate the distances using basic planet earth dimensions.
There are only so many degrees along the arc of any given sphere (360) and there are only so many minutes in a degree.
The size of the earth represents only one number that needs to be looked up unless you care to include miles in addition to the international standard of km. If so, then you have an additional factor to consider in your calcualations.
Am I making any sense?
Tamir
> -----Original Message-----
> From: Michael A Nachbaur [mailto:mike@nachbaur.com]
> Sent: Wednesday, March 26, 2003 11:55 AM
> To: Ryan; rudi@oasis.net.au
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Off topic : world database
>
>
> On March 26, 2003 10:56 pm, Ryan wrote:
> > Your best bet is buying a good zipcode database that has
> lat/long, but
> > would only really help you in the USA. This kind of data
> tends not to be
> > cheap...
>
> Either that, or web scrape mapquest.com or some other site
> that provides
> lat/long for returned results, but that probably violates the
> acceptable use
> policy of those sites.
>
> I for one would be very interested in such a web service (I'd
> really like a
> address / street lookup to find lat/longs for addresses, but
> thats not likely
> to happen).
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
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: tamir@brobus.net, mike@nachbaur.com, pgsql-sql@seahat.com, rudi@oasis.net.au
Subject: Re: Off topic : world database
In-Reply-To: <985DF46E87E0C047A3670048DBCAD0556BCD@andrew.brobus.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