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:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 11:55 AM > To: Ryan; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
